How do I open port 3306 on OS X 10.4?

[J.B. Mentzer-2]

Hi all,

Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
doesn't list port 3306 being open. How do I open on on my Mac?

Thanks,

* JB *



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5730
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[Douglas Hyde]

Open system preferences, click on sharing, click on the firewall tab, then
add new. There are presets, but select other, type in 3306, then name the
new port as sql, and hit save. Should be it.

D

> From: "J.B. Mentzer" <coldfusion@...>
> Reply-To: <cf-mac@...>
> Date: Mon, 09 Feb 2009 01:46:40 -0500
> To: cf-mac <cf-mac@...>
> Subject: How do I open port 3306 on OS X 10.4?
>
>
> Hi all,
>
> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
> doesn't list port 3306 being open. How do I open on on my Mac?
>
> Thanks,
>
> * JB *
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5731
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[J.B. Mentzer-2]

Hi .... I followed your advice, but the port still isn't displaying in
Network Utilities' Port Scan app.

When "other" is selected from the drop down, I get two boxes to fill in:
TCP and UDP ... should I be using TCP?

Thanks,

* JB *

Douglas Hyde wrote:

> Open system preferences, click on sharing, click on the firewall tab, then
> add new. There are presets, but select other, type in 3306, then name the
> new port as sql, and hit save. Should be it.
>
> D
>
>
>  
>> From: "J.B. Mentzer" <coldfusion@...>
>> Reply-To: <cf-mac@...>
>> Date: Mon, 09 Feb 2009 01:46:40 -0500
>> To: cf-mac <cf-mac@...>
>> Subject: How do I open port 3306 on OS X 10.4?
>>
>>
>> Hi all,
>>
>> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
>> doesn't list port 3306 being open. How do I open on on my Mac?
>>
>> Thanks,
>>
>> * JB *
>>
>>
>>
>>
>>    
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5732
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[Douglas Hyde]

Yes. Try it.

Is stealth mode enabled? I don't think it should matter, but if yes uncheck.
Under firewall tab, click on advanced, then unselect stealth. Then test.
When you have it working, I would recommend turning stealth mode back on.

I would only scan a range of ports around 3306 to test - goes faster.

Make sure you have added security (limited ip access, and/or a password) to
all accounts (like root) in mysql before exposing.

D

> From: "J.B. Mentzer" <coldfusion@...>
> Reply-To: <cf-mac@...>
> Date: Mon, 09 Feb 2009 03:16:10 -0500
> To: cf-mac <cf-mac@...>
> Subject: Re: How do I open port 3306 on OS X 10.4?
>
>
> Hi .... I followed your advice, but the port still isn't displaying in
> Network Utilities' Port Scan app.
>
> When "other" is selected from the drop down, I get two boxes to fill in:
> TCP and UDP ... should I be using TCP?
>
> Thanks,
>
> * JB *
>
> Douglas Hyde wrote:
>> Open system preferences, click on sharing, click on the firewall tab, then
>> add new. There are presets, but select other, type in 3306, then name the
>> new port as sql, and hit save. Should be it.
>>
>> D
>>
>>
>>  
>>> From: "J.B. Mentzer" <coldfusion@...>
>>> Reply-To: <cf-mac@...>
>>> Date: Mon, 09 Feb 2009 01:46:40 -0500
>>> To: cf-mac <cf-mac@...>
>>> Subject: How do I open port 3306 on OS X 10.4?
>>>
>>>
>>> Hi all,
>>>
>>> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
>>> doesn't list port 3306 being open. How do I open on on my Mac?
>>>
>>> Thanks,
>>>
>>> * JB *
>>>
>>>
>>>
>>>
>>>    
>>
>>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5733
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[Douglas Hyde]

Note, if it is behind an existing firewall on an internal network where you
trust other users, you could shut off the firewall. Just a thought, as you
indicated you are scanning an internal address.

If you are scanning a machine behind a hardware firewall on a local network,
you would also need to open the port on the hardware firewall and do port
forwarding for 3306 to the machine on the subnet. So, if you are scanning
from an external ip like 64.79.x.x for 3306 on a machine with the address
you indicated below, it is probably not going to work.

D

> From: "J.B. Mentzer" <coldfusion@...>
> Reply-To: <cf-mac@...>
> Date: Mon, 09 Feb 2009 03:16:10 -0500
> To: cf-mac <cf-mac@...>
> Subject: Re: How do I open port 3306 on OS X 10.4?
>
>
> Hi .... I followed your advice, but the port still isn't displaying in
> Network Utilities' Port Scan app.
>
> When "other" is selected from the drop down, I get two boxes to fill in:
> TCP and UDP ... should I be using TCP?
>
> Thanks,
>
> * JB *
>
> Douglas Hyde wrote:
>> Open system preferences, click on sharing, click on the firewall tab, then
>> add new. There are presets, but select other, type in 3306, then name the
>> new port as sql, and hit save. Should be it.
>>
>> D
>>
>>
>>  
>>> From: "J.B. Mentzer" <coldfusion@...>
>>> Reply-To: <cf-mac@...>
>>> Date: Mon, 09 Feb 2009 01:46:40 -0500
>>> To: cf-mac <cf-mac@...>
>>> Subject: How do I open port 3306 on OS X 10.4?
>>>
>>>
>>> Hi all,
>>>
>>> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
>>> doesn't list port 3306 being open. How do I open on on my Mac?
>>>
>>> Thanks,
>>>
>>> * JB *
>>>
>>>
>>>
>>>
>>>    
>>
>>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5734
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[J.B. Mentzer-2]

Douglas Hyde wrote:
> Note, if it is behind an existing firewall on an internal network where you
> trust other users, you could shut off the firewall. Just a thought, as you
> indicated you are scanning an internal address.
>  

All of my operations are on the same box, a Mac G4 whose IP is
192.168.x.x. I'm physically using this Mac.

I scanned for ports between 3300 and 3400 and nothing was found at the
G4's IP

When I run MySQL Admin and/or Navicat, I am able to log in and admin the
database using "localhost", "root" and "root's PW". These credentials
generate an error when I attempt to use them to configure a datasource
using either Railo or OpenBD.

Would you like to see the stacktrace?

Thank you!

* JB *
> If you are scanning a machine behind a hardware firewall on a local network,
> you would also need to open the port on the hardware firewall and do port
> forwarding for 3306 to the machine on the subnet. So, if you are scanning
> from an external ip like 64.79.x.x for 3306 on a machine with the address
> you indicated below, it is probably not going to work.
>  

>> From: "J.B. Mentzer" <coldfusion@...>
>> Reply-To: <cf-mac@...>
>> Date: Mon, 09 Feb 2009 03:16:10 -0500
>> To: cf-mac <cf-mac@...>
>> Subject: Re: How do I open port 3306 on OS X 10.4?
>>
>>
>> Hi .... I followed your advice, but the port still isn't displaying in
>> Network Utilities' Port Scan app.
>>
>> When "other" is selected from the drop down, I get two boxes to fill in:
>> TCP and UDP ... should I be using TCP?
>>
>> Thanks,
>>
>> * JB *
>>
>> Douglas Hyde wrote:
>>    
>>> Open system preferences, click on sharing, click on the firewall tab, then
>>> add new. There are presets, but select other, type in 3306, then name the
>>> new port as sql, and hit save. Should be it.
>>>
>>> D
>>>
>>>
>>>  
>>>      
>>>> From: "J.B. Mentzer" <coldfusion@...>
>>>> Reply-To: <cf-mac@...>
>>>> Date: Mon, 09 Feb 2009 01:46:40 -0500
>>>> To: cf-mac <cf-mac@...>
>>>> Subject: How do I open port 3306 on OS X 10.4?
>>>>
>>>>
>>>> Hi all,
>>>>
>>>> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
>>>> doesn't list port 3306 being open. How do I open on on my Mac?
>>>>
>>>> Thanks,
>>>>
>>>> * JB *
>>>>
>>>>
>>>>
>>>>
>>>>    
>>>>        
>>>      
>>    
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5735
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[Gert Franz]

JB,

stacktrace is not helping. At least in SQL Server you can define what kind
of connection you would like to have, Named pipes, TCP/IP or similar. Maybe
you have to activate TCP/IP first...

Gert

-----Ursprüngliche Nachricht-----
Von: J.B. Mentzer [mailto:coldfusion@...]
Gesendet: Montag, 9. Februar 2009 22:19
An: cf-mac
Betreff: Re: How do I open port 3306 on OS X 10.4?


Douglas Hyde wrote:
> Note, if it is behind an existing firewall on an internal network where
you
> trust other users, you could shut off the firewall. Just a thought, as you
> indicated you are scanning an internal address.
>  

All of my operations are on the same box, a Mac G4 whose IP is
192.168.x.x. I'm physically using this Mac.

I scanned for ports between 3300 and 3400 and nothing was found at the
G4's IP

When I run MySQL Admin and/or Navicat, I am able to log in and admin the
database using "localhost", "root" and "root's PW". These credentials
generate an error when I attempt to use them to configure a datasource
using either Railo or OpenBD.

Would you like to see the stacktrace?

Thank you!

* JB *
> If you are scanning a machine behind a hardware firewall on a local
network,
> you would also need to open the port on the hardware firewall and do port
> forwarding for 3306 to the machine on the subnet. So, if you are scanning
> from an external ip like 64.79.x.x for 3306 on a machine with the address
> you indicated below, it is probably not going to work.
>  

>> From: "J.B. Mentzer" <coldfusion@...>
>> Reply-To: <cf-mac@...>
>> Date: Mon, 09 Feb 2009 03:16:10 -0500
>> To: cf-mac <cf-mac@...>
>> Subject: Re: How do I open port 3306 on OS X 10.4?
>>
>>
>> Hi .... I followed your advice, but the port still isn't displaying in
>> Network Utilities' Port Scan app.
>>
>> When "other" is selected from the drop down, I get two boxes to fill in:
>> TCP and UDP ... should I be using TCP?
>>
>> Thanks,
>>
>> * JB *
>>
>> Douglas Hyde wrote:
>>    
>>> Open system preferences, click on sharing, click on the firewall tab,

then
>>> add new. There are presets, but select other, type in 3306, then name
the

>>> new port as sql, and hit save. Should be it.
>>>
>>> D
>>>
>>>
>>>  
>>>      
>>>> From: "J.B. Mentzer" <coldfusion@...>
>>>> Reply-To: <cf-mac@...>
>>>> Date: Mon, 09 Feb 2009 01:46:40 -0500
>>>> To: cf-mac <cf-mac@...>
>>>> Subject: How do I open port 3306 on OS X 10.4?
>>>>
>>>>
>>>> Hi all,
>>>>
>>>> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
>>>> doesn't list port 3306 being open. How do I open on on my Mac?
>>>>
>>>> Thanks,
>>>>
>>>> * JB *
>>>>
>>>>
>>>>
>>>>
>>>>    
>>>>        
>>>      
>>    
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5736
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[Douglas Hyde]

No use of named pipes in mysql that I am aware of - not for a CF
installation.

In open bd, are you using the JAR driver? I use the older version of new
altanta's bd for development (the free server) and it works fine - sometimes
the file name is important (for example, in bluedragon, you must rename the
jar to "mysql.jar" and place it in the lib directory). I haven't used either
open bd or railo. If you are looking for a development version, I would
consider bluedragon version 7_01_352. You can get a copy at
ftp://ftp.newatlanta.com.

To the problem at hand, perhaps you should try to open the hosts a single
user account is able to use to access the local installation of mysql. Make
a new user account called "coldfusion" assign it a password, and for host
use "%" - that way, it will be able access the local installation no matter
what the IP the user is calling from. Make sure you give the account the
permissions needed (insert, delete, update, ...) and then enter the
information in the coldfusion setting, which ever you are using.

Doug

> From: "J.B. Mentzer" <coldfusion@...>
> Reply-To: <cf-mac@...>
> Date: Mon, 09 Feb 2009 16:18:51 -0500
> To: cf-mac <cf-mac@...>
> Subject: Re: How do I open port 3306 on OS X 10.4?
>
>
> Douglas Hyde wrote:
>> Note, if it is behind an existing firewall on an internal network where you
>> trust other users, you could shut off the firewall. Just a thought, as you
>> indicated you are scanning an internal address.
>>  
>
> All of my operations are on the same box, a Mac G4 whose IP is
> 192.168.x.x. I'm physically using this Mac.
>
> I scanned for ports between 3300 and 3400 and nothing was found at the
> G4's IP
>
> When I run MySQL Admin and/or Navicat, I am able to log in and admin the
> database using "localhost", "root" and "root's PW". These credentials
> generate an error when I attempt to use them to configure a datasource
> using either Railo or OpenBD.
>
> Would you like to see the stacktrace?
>
> Thank you!
>
> * JB *
>> If you are scanning a machine behind a hardware firewall on a local network,
>> you would also need to open the port on the hardware firewall and do port
>> forwarding for 3306 to the machine on the subnet. So, if you are scanning
>> from an external ip like 64.79.x.x for 3306 on a machine with the address
>> you indicated below, it is probably not going to work.
>>  
>
>
>>> From: "J.B. Mentzer" <coldfusion@...>
>>> Reply-To: <cf-mac@...>
>>> Date: Mon, 09 Feb 2009 03:16:10 -0500
>>> To: cf-mac <cf-mac@...>
>>> Subject: Re: How do I open port 3306 on OS X 10.4?
>>>
>>>
>>> Hi .... I followed your advice, but the port still isn't displaying in
>>> Network Utilities' Port Scan app.
>>>
>>> When "other" is selected from the drop down, I get two boxes to fill in:
>>> TCP and UDP ... should I be using TCP?
>>>
>>> Thanks,
>>>
>>> * JB *
>>>
>>> Douglas Hyde wrote:
>>>    
>>>> Open system preferences, click on sharing, click on the firewall tab, then
>>>> add new. There are presets, but select other, type in 3306, then name the
>>>> new port as sql, and hit save. Should be it.
>>>>
>>>> D
>>>>
>>>>
>>>>  
>>>>      
>>>>> From: "J.B. Mentzer" <coldfusion@...>
>>>>> Reply-To: <cf-mac@...>
>>>>> Date: Mon, 09 Feb 2009 01:46:40 -0500
>>>>> To: cf-mac <cf-mac@...>
>>>>> Subject: How do I open port 3306 on OS X 10.4?
>>>>>
>>>>>
>>>>> Hi all,
>>>>>
>>>>> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
>>>>> doesn't list port 3306 being open. How do I open on on my Mac?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> * JB *
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>    
>>>>>        
>>>>      
>>>    
>>
>>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5737
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[J.B. Mentzer-2]

Gert Franz wrote:
> JB,
>
> stacktrace is not helping. At least in SQL Server you can define what kind
> of connection you would like to have, Named pipes, TCP/IP or similar. Maybe
> you have to activate TCP/IP first...
>  

Could you elaborate a bit? The Firefox window that is pointed at OpenBD
Administrator also has tabs for Blue Dragon's website. If I'm able to
browse the net, isn't TCP/IP operating?

Thanks,

 * JB *

> -----Ursprüngliche Nachricht-----
> Von: J.B. Mentzer [mailto:coldfusion@...]
> Gesendet: Montag, 9. Februar 2009 22:19
> An: cf-mac
> Betreff: Re: How do I open port 3306 on OS X 10.4?
>
>
> Douglas Hyde wrote:
>  
>> Note, if it is behind an existing firewall on an internal network where
>>    
> you
>  
>> trust other users, you could shut off the firewall. Just a thought, as you
>> indicated you are scanning an internal address.
>>  
>>    
>
> All of my operations are on the same box, a Mac G4 whose IP is
> 192.168.x.x. I'm physically using this Mac.
>
> I scanned for ports between 3300 and 3400 and nothing was found at the
> G4's IP
>
> When I run MySQL Admin and/or Navicat, I am able to log in and admin the
> database using "localhost", "root" and "root's PW". These credentials
> generate an error when I attempt to use them to configure a datasource
> using either Railo or OpenBD.
>
> Would you like to see the stacktrace?
>
> Thank you!
>
> * JB *
>  
>> If you are scanning a machine behind a hardware firewall on a local
>>    
> network,
>  
>> you would also need to open the port on the hardware firewall and do port
>> forwarding for 3306 to the machine on the subnet. So, if you are scanning
>> from an external ip like 64.79.x.x for 3306 on a machine with the address
>> you indicated below, it is probably not going to work.
>>  
>>    
>
>
>  
>>> From: "J.B. Mentzer" <coldfusion@...>
>>> Reply-To: <cf-mac@...>
>>> Date: Mon, 09 Feb 2009 03:16:10 -0500
>>> To: cf-mac <cf-mac@...>
>>> Subject: Re: How do I open port 3306 on OS X 10.4?
>>>
>>>
>>> Hi .... I followed your advice, but the port still isn't displaying in
>>> Network Utilities' Port Scan app.
>>>
>>> When "other" is selected from the drop down, I get two boxes to fill in:
>>> TCP and UDP ... should I be using TCP?
>>>
>>> Thanks,
>>>
>>> * JB *
>>>
>>> Douglas Hyde wrote:
>>>    
>>>      
>>>> Open system preferences, click on sharing, click on the firewall tab,
>>>>        
> then
>  
>>>> add new. There are presets, but select other, type in 3306, then name
>>>>        
> the
>  
>>>> new port as sql, and hit save. Should be it.
>>>>
>>>> D
>>>>
>>>>
>>>>  
>>>>      
>>>>        
>>>>> From: "J.B. Mentzer" <coldfusion@...>
>>>>> Reply-To: <cf-mac@...>
>>>>> Date: Mon, 09 Feb 2009 01:46:40 -0500
>>>>> To: cf-mac <cf-mac@...>
>>>>> Subject: How do I open port 3306 on OS X 10.4?
>>>>>
>>>>>
>>>>> Hi all,
>>>>>
>>>>> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
>>>>> doesn't list port 3306 being open. How do I open on on my Mac?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> * JB *
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>    
>>>>>        
>>>>>          
>>>>      
>>>>        
>>>    
>>>      
>>    
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5738
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[J.B. Mentzer-2]

Douglas Hyde wrote:
> No use of named pipes in mysql that I am aware of - not for a CF
> installation.
>
> In open bd, are you using the JAR driver?
I don't know ... how would I determine that? I searched for .jar files,
and found 703 matches.

> I use the older version of new
> altanta's bd for development (the free server) and it works fine - sometimes
> the file name is important (for example, in bluedragon, you must rename the
> jar to "mysql.jar" and place it in the lib directory). I haven't used either
> open bd or railo. If you are looking for a development version, I would
> consider bluedragon version 7_01_352. You can get a copy at
> ftp://ftp.newatlanta.com.
>  

So ... replace OpenBD with Version 7_01_352?

It seems like the error is related to port 3306 not being available to
the script that runs when I submit the Datasource form ...

> To the problem at hand, perhaps you should try to open the hosts a single
> user account is able to use to access the local installation of mysql.
What is "hosts"?

> Makea new user account called "coldfusion" assign it a password, and for host
> use "%" -
I have a users called "drgw5771@%". I've tried connecting using this
user, but received the same error.

Thanks,

* JB *

>> From: "J.B. Mentzer" <coldfusion@...>
>> Reply-To: <cf-mac@...>
>> Date: Mon, 09 Feb 2009 16:18:51 -0500
>> To: cf-mac <cf-mac@...>
>> Subject: Re: How do I open port 3306 on OS X 10.4?
>>
>>
>> Douglas Hyde wrote:
>>    
>>> Note, if it is behind an existing firewall on an internal network where you
>>> trust other users, you could shut off the firewall. Just a thought, as you
>>> indicated you are scanning an internal address.
>>>  
>>>      
>> All of my operations are on the same box, a Mac G4 whose IP is
>> 192.168.x.x. I'm physically using this Mac.
>>
>> I scanned for ports between 3300 and 3400 and nothing was found at the
>> G4's IP
>>
>> When I run MySQL Admin and/or Navicat, I am able to log in and admin the
>> database using "localhost", "root" and "root's PW". These credentials
>> generate an error when I attempt to use them to configure a datasource
>> using either Railo or OpenBD.
>>
>> Would you like to see the stacktrace?
>>
>> Thank you!
>>
>> * JB *
>>    
>>> If you are scanning a machine behind a hardware firewall on a local network,
>>> you would also need to open the port on the hardware firewall and do port
>>> forwarding for 3306 to the machine on the subnet. So, if you are scanning
>>> from an external ip like 64.79.x.x for 3306 on a machine with the address
>>> you indicated below, it is probably not going to work.
>>>  
>>>      
>>    
>>>> From: "J.B. Mentzer" <coldfusion@...>
>>>> Reply-To: <cf-mac@...>
>>>> Date: Mon, 09 Feb 2009 03:16:10 -0500
>>>> To: cf-mac <cf-mac@...>
>>>> Subject: Re: How do I open port 3306 on OS X 10.4?
>>>>
>>>>
>>>> Hi .... I followed your advice, but the port still isn't displaying in
>>>> Network Utilities' Port Scan app.
>>>>
>>>> When "other" is selected from the drop down, I get two boxes to fill in:
>>>> TCP and UDP ... should I be using TCP?
>>>>
>>>> Thanks,
>>>>
>>>> * JB *
>>>>
>>>> Douglas Hyde wrote:
>>>>    
>>>>        
>>>>> Open system preferences, click on sharing, click on the firewall tab, then
>>>>> add new. There are presets, but select other, type in 3306, then name the
>>>>> new port as sql, and hit save. Should be it.
>>>>>
>>>>> D
>>>>>
>>>>>
>>>>>  
>>>>>      
>>>>>          
>>>>>> From: "J.B. Mentzer" <coldfusion@...>
>>>>>> Reply-To: <cf-mac@...>
>>>>>> Date: Mon, 09 Feb 2009 01:46:40 -0500
>>>>>> To: cf-mac <cf-mac@...>
>>>>>> Subject: How do I open port 3306 on OS X 10.4?
>>>>>>
>>>>>>
>>>>>> Hi all,
>>>>>>
>>>>>> Port scan for the 192.168.x.x addr pertaining to the Mac MySQL is on
>>>>>> doesn't list port 3306 being open. How do I open on on my Mac?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> * JB *
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>    
>>>>>>        
>>>>>>            
>>>>>      
>>>>>          
>>>>    
>>>>        
>>>      
>>    
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5739
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[Douglas Hyde]

See below.
>>
>> In open bd, are you using the JAR driver?
> I don't know ... how would I determine that? I searched for .jar files,
> and found 703 matches.

A jar is an archive (like a zip file) used to store java files. You need one
named "mysql.jar" - if you haven't installed it, it probably isn't there.
Get the connector directly from mysql.

http://www.mysql.com/products/connector/j/

>> consider bluedragon version 7_01_352. You can get a copy at
>> ftp://ftp.newatlanta.com.
>>  
>
> So ... replace OpenBD with Version 7_01_352?

Just an idea. Others should work though - connecting to a datasource is
pretty standard. I just haven't done it.

>
> It seems like the error is related to port 3306 not being available to
> the script that runs when I submit the Datasource form ...

Increasingly, sounds like you don't have the driver installed. Need to find
out where to install (with bluedragon, the lib directory) and then restart
your machine (or the cfm service).

>
>> To the problem at hand, perhaps you should try to open the hosts a single
>> user account is able to use to access the local installation of mysql.
> What is "hosts"?

The ip address of the machine trying to access the instance of mysql. Like
203.181.23.25 or 65.79.31.12 or 10.0.0.7 or 192.168.1.100.

>
>> Makea new user account called "coldfusion" assign it a password, and for host
>> use "%" -
> I have a users called "drgw5771@%". I've tried connecting using this
> user, but received the same error.

Again, I think it is because you don't have a driver installed.
>
> Thanks,
>
> * JB *



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5740
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[J.B. Mentzer-2]

Douglas Hyde wrote:
> A jar is an archive (like a zip file) used to store java files. You need one
> named "mysql.jar" - if you haven't installed it, it probably isn't there.
> Get the connector directly from mysql.
>
> http://www.mysql.com/products/connector/j/
>  
Ok ... I downloaded "mysql-connector-java-5.1.7". The contents of the
archive are loose in Blue Dragon's /lib/.

I tried creating the datasource and got this error:

"Could not verify datasource: Could not create connection to database
server. Attempted reconnect 3 times. Giving up."

This displays as a line of red type (shown above), within BD's normal
page layout ... not the page-deforming, verbose Stacktrace dump.
Progress! lol ...

I tried two users: root and "drgw5771" but received the above error.

What should go in the "Database Server" field? The IP address of the box
containing the MySQL server?

I tried various options in the Sharing Control Panel (CP) and also to
create a port forward in the Verizon FIOS router, but I still can't get
port 3306 to show up in Net Util's Port Scan.

* JB *




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5741
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[phipps_73-2]

Hi,

The mysql connector file you need should now be in your BlueDragon lib  
folder called:

mysql-connector-java-5.1.7-bin.jar

rename this as Douglas said to be just

mysql.jar

Then restart BlueDragon.

I haven't used BD before but with CF8 and MySQL on my dev machine I  
usually set up a database e.g. myproject_db1, using the Terminal to do  
a couple of commands to create and assign a user and password to the  
database, assuming you have mysql added to your system path (http://www.comentum.com/mysql-administration.html 
  (see the section about half way down called "Setting PATH for mysql  
on OS X")):

login to MySQL:

mysql -u root -p

Enter password:

You should see a mysql prompt:

mysql> CREATE DATABASE myproject_db1;

Hit enter

Grant permissions to the database for a particular user:

mysql> GRANT ALL ON myproject_db1.* TO myproject_db1 IDENTIFIED BY  
"thisismysecretpassword_not";

Hit enter

Then in the BD administrator you should be able to create a datasource  
which uses (from the above example) the username of myproject_db1 and  
password as above. The server should be localhost, although 127.0.0.1  
should also work.

I think once you have the driver installed with the correct name it  
should be plain sailing.

Cheers,

Dave



On 10 Feb 2009, at 05:14, J.B. Mentzer wrote:

>
> Douglas Hyde wrote:
>> A jar is an archive (like a zip file) used to store java files. You  
>> need one
>> named "mysql.jar" - if you haven't installed it, it probably isn't  
>> there.
>> Get the connector directly from mysql.
>>
>> http://www.mysql.com/products/connector/j/
>>
> Ok ... I downloaded "mysql-connector-java-5.1.7". The contents of the
> archive are loose in Blue Dragon's /lib/.
>
> I tried creating the datasource and got this error:
>
> "Could not verify datasource: Could not create connection to database
> server. Attempted reconnect 3 times. Giving up."
>
> This displays as a line of red type (shown above), within BD's normal
> page layout ... not the page-deforming, verbose Stacktrace dump.
> Progress! lol ...
>
> I tried two users: root and "drgw5771" but received the above error.
>
> What should go in the "Database Server" field? The IP address of the  
> box
> containing the MySQL server?
>
> I tried various options in the Sharing Control Panel (CP) and also to
> create a port forward in the Verizon FIOS router, but I still can't  
> get
> port 3306 to show up in Net Util's Port Scan.
>
> * JB *
>
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5742
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[Douglas Hyde]

JB,

You are using navicat, which can achieve the same thing Dave has suggested
(rather than using terminal, if this is too cryptic). Open navicat, and make
sure that the user you have entered in bd/cf has the right permissions by
hitting edit user in navicat. I would as a general practice avoid using
root, though its ok for a development box.

The only other issue I can see is (1) naming the file "mysql.jar" and (2)
restarting your machine. Should be good to go.

D

 

> I haven't used BD before but with CF8 and MySQL on my dev machine I
> usually set up a database e.g. myproject_db1, using the Terminal to do
> a couple of commands to create and assign a user and password to the
> database, assuming you have mysql added to your system path
> (http://www.comentum.com/mysql-administration.html
>   (see the section about half way down called "Setting PATH for mysql
> on OS X")):
>
> login to MySQL:
>
> mysql -u root -p
>
> Enter password:
>
> You should see a mysql prompt:
>
> mysql> CREATE DATABASE myproject_db1;
>
> Hit enter
>
> Grant permissions to the database for a particular user:
>
> mysql> GRANT ALL ON myproject_db1.* TO myproject_db1 IDENTIFIED BY
> "thisismysecretpassword_not";
>
> Hit enter
>
> Then in the BD administrator you should be able to create a datasource
> which uses (from the above example) the username of myproject_db1 and
> password as above. The server should be localhost, although 127.0.0.1
> should also work.
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5743
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[J.B. Mentzer-2]

David Phipps wrote:

> Hi,
>
> The mysql connector file you need should now be in your BlueDragon lib  
> folder called:
>
> mysql-connector-java-5.1.7-bin.jar
>
> rename this as Douglas said to be just
>
> mysql.jar
>
> Then restart BlueDragon.
>
> I haven't used BD before but with CF8 and MySQL on my dev machine I  
> usually set up a database e.g. myproject_db1, using the Terminal to do  
> a couple of commands to create and assign a user and password to the  
> database, assuming you have mysql added to your system path (http://www.comentum.com/mysql-administration.html 
>   (see the section about half way down called "Setting PATH for mysql  
> on OS X")):
>
> login to MySQL:
>
> mysql -u root -p
>  

All I get when entering this command in a terminal prompt is "tcsh:
mysql: Command Not Found".

The databases that Navicat displays and edits are located in
/volumes/Leela/Applications/MAMP/db/mysql/

I cd to the /mysql/ directory and tried the login command, same error.

The commands listed on comentum.com say "enter your password". I don't
recall setting a PW for MySQL. Unless MAMP created it's own MySQL
installation, I previously installed MySQL along with Apache and PHP
from a CD in a book some time back.

I Stopped the servers (Apache and MySQL) using MAMP ... then tried to
access the db using Navicat. Navicat threw an error, saying it couldn't
connect. After restarting the servers with MAMP, Navicat was able to
connect.

Where to from here?

Feeling rather hopeless,

* JB *


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5744
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[J.B. Mentzer-2]

Douglas Hyde wrote:
> JB,
>
> Open navicat, and make
> sure that the user you have entered in bd/cf has the right permissions by
> hitting edit user in navicat.
By "permissions", are you referring what a given user is allowed to do
once connected to the database?

When I open Manage Users, the userID's I'm trying have all check boxes
checked except "Event" and "Trigger".


> I would as a general practice avoid using
> root, though its ok for a development box.
>  
That occurred to me. I created a user named "drgw5771", but at the
moment no user can connect.

> The only other issue I can see is (1) naming the file "mysql.jar" and (2)
> restarting your machine. Should be good to go.
>  
Shut down. Waited about five minutes. Restarted. Same error.

Does it matter that the MySQL instance Navicat is connected to is on a
different harddrive from the path OpenBD resides in?

I *still* can't get port 3306 to show up in Port Scan. Should this be a
TCP port?

Thanks,

* JB *

>> I haven't used BD before but with CF8 and MySQL on my dev machine I
>> usually set up a database e.g. myproject_db1, using the Terminal to do
>> a couple of commands to create and assign a user and password to the
>> database, assuming you have mysql added to your system path
>> (http://www.comentum.com/mysql-administration.html
>>   (see the section about half way down called "Setting PATH for mysql
>> on OS X")):
>>
>> login to MySQL:
>>
>> mysql -u root -p
>>
>> Enter password:
>>
>> You should see a mysql prompt:
>>
>> mysql> CREATE DATABASE myproject_db1;
>>
>> Hit enter
>>
>> Grant permissions to the database for a particular user:
>>
>> mysql> GRANT ALL ON myproject_db1.* TO myproject_db1 IDENTIFIED BY
>> "thisismysecretpassword_not";
>>
>> Hit enter
>>
>> Then in the BD administrator you should be able to create a datasource
>> which uses (from the above example) the username of myproject_db1 and
>> password as above. The server should be localhost, although 127.0.0.1
>> should also work.
>>
>>    
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5745
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48

[Douglas Hyde]

See below.
>

> By "permissions", are you referring what a given user is allowed to do
> once connected to the database?

Yes.

>
> When I open Manage Users, the userID's I'm trying have all check boxes
> checked except "Event" and "Trigger".

This is fine, though more permissions than needed for a cf account. The
point is the userID has permissions. If a production environment, I would
uncheck drop, reload, shutdown, process, file, grant, references, alter,
show databases, super, create tmp table, lock tables, repl.save,
repl.client, show view, alter routine and create user. Not secure to leave
these open, unless there is some fundamental reason.

> That occurred to me. I created a user named "drgw5771", but at the
> moment no user can connect.
 
Except through navicat. Which account are you using in navicat? And which
port?

> Shut down. Waited about five minutes. Restarted. Same error.
>
> Does it matter that the MySQL instance Navicat is connected to is on a
> different harddrive from the path OpenBD resides in?

I don't think so. You could connect to an instance on an entirely different
machine through BD by using a different IP.

>
> I *still* can't get port 3306 to show up in Port Scan. Should this be a
> TCP port?
>

I don't think this is the issue. The port is open, or you couldn't connect
using navicat. Unfortunately, I haven't used openBD, so I am not familiar
with the configuration - I assume similar to BD.

Here is how I picture your system - you have mysql and openBD working on the
same machine, from different drives NOT different machines. Everything is on
one machine, with one ip address. You can confirm using "Activity Monitor"
that these processes are running. You open Navicat on the same machine, and
in connection properties can confirm that your drgw5771 account can connect
to mysql using "localhost" or the exact IP address of the local machine. In
openBD, you have installed "mysql.jar" in the "/lib" directory and restarted
the process or machine. From the openBD admin console, you add a mysql data
source, enter the username and password, and the host (localhost or exact
ip) and port (3306) exactly as set out in the connection properties for the
database you can access in navicat, and you get the error?

If yes, one possibility is that the xml file is not being written to, though
I am reaching here. Try finding "bluedragon.xml" after you add the
datasource, and search for datasource name="*****" within it (your
datasource). Confirm that your settings have been added. If no, look in log
files (installation or bluedragon, which is in the "/work" directory; or mac
osx log files). If not, you can add them manually.

Can't help you more. I have banged my head against the wall on this type of
thing...very frustrating, but eventually it will work.

 




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/cf-mac/message.cfm/messageid:5746
Subscription: http://www.houseoffusion.com/groups/cf-mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.48