Re: Adding DSN into Coldfusion Admin?
Just the fact that you GOT the gibberish meant that the server was running and that you were able to connect. What you saw was a Hello packet. It's one of the first stages to authenticating a MySQL client to a MySQL server. It's not meant for humans. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Steve Grosz [EMAIL PROTECTED] wrote on 10/15/2004 01:36:23 PM: I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? Jochem van Dieten wrote: On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Any other ideas? Thanks!! Steve Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Dwalu Z. Khasu wrote: =Neither the DOS nor Unix man pages for telnet mention a colon--Why do you =think you need one? Let me try again, how about 'telnet web-server 3306'? = Sorry for the typo. For your example, that should've been: telnet web-server2 3306 Are you sure you're connecting to the appropriate box? Should your command string be telnet db-server 3306 instead? - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? Jochem van Dieten wrote: On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Did the gibberish look something like this? Trying web-server2... Connected to web-server2. Escape character is '^]'. : 4.1.4a-gamma P--=)TK],rFDbDid:5:di Bad handshakeConnection closed by foreign host. If so, you got through to the mysql server. (See the version number?) You weren't connecting as a proper mysql client, so the last string doesn't make sense to you, and your answer didn't make sense to the mysql server, so it hung up on you. The point of the test was simply to see if you could get through to mysql on port 3306 (port is open) or not (port is blocked, probably by a firewall). It looks like you got through. Michael Steve Grosz wrote: I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? Jochem van Dieten wrote: On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
On Fri, 15 Oct 2004 11:36:23 -0600, Steve Grosz wrote: I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? That probably means you can reach the MySQL server and the problem is on OSI-layer 5-8 :-) Could you go into the ColdFusion Administrator and go to the Settings Summary. From there, copy the settings and post them together with the exact text of the error message. (And please, just make a literal copy and don't obfuscating IP addresses etc., they are RFC 1918 addresses so we can't reach them anyway.) Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
telnet to it. MySQL will return a 'hello' packet. -Eric On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz [EMAIL PROTECTED] wrote: I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
So what, a telnet 192.168.x.x:3306 ? Eric Bergen wrote: telnet to it. MySQL will return a 'hello' packet. -Eric On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz [EMAIL PROTECTED] wrote: I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
If that's the case, its not working, I type a telnet 192.168.x.x:3306 and get a could not open a connection to the host even though Mysql-nt shows as running on the Win2003 server. Steve Eric Bergen wrote: telnet to it. MySQL will return a 'hello' packet. -Eric On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz [EMAIL PROTECTED] wrote: I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =If that's the case, its not working, I type a telnet 192.168.x.x:3306 =and get a could not open a connection to the host even though =Mysql-nt shows as running on the Win2003 server. = =Steve = Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Adding DSN into Coldfusion Admin?
Hi Steve, You haven't got a firewall running have you? Is the MS Internet Connection firewall switched on? Sounds like some sort of firewall issue though. Generally you won't get a response from the server if it is protected. Just a thought, I'm more of a unix bod but have seen this on my own PC. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Steve Grosz [mailto:[EMAIL PROTECTED] Sent: Friday, 15 October 2004 9:29 AM To: [EMAIL PROTECTED] Subject: Re: Adding DSN into Coldfusion Admin? I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =If that's the case, its not working, I type a telnet 192.168.x.x:3306 =and get a could not open a connection to the host even though =Mysql-nt shows as running on the Win2003 server. = =Steve = Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Did you tried without the : between web-server2 and 3306? i.e. put a space insted of : B On Thursday 14 October 2004 19:58, Steve Grosz wrote: I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =If that's the case, its not working, I type a telnet 192.168.x.x:3306 =and get a could not open a connection to the host even though =Mysql-nt shows as running on the Win2003 server. = =Steve = Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
On Thu, 14 Oct 2004, Steve Grosz wrote: =I have tried telnet web-server2:3306 = =Didn't work = Neither the DOS nor Unix man pages for telnet mention a colon--Why do you think you need one? Let me try again, how about 'telnet web-server 3306'? ... ... =Dwalu Z. Khasu wrote: [snip] = = = Try 'telnet host port'. = -- - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
On Thu, 14 Oct 2004, Dwalu Z. Khasu wrote: =Neither the DOS nor Unix man pages for telnet mention a colon--Why do you =think you need one? Let me try again, how about 'telnet web-server 3306'? = Sorry for the typo. For your example, that should've been: telnet web-server2 3306 Are you sure you're connecting to the appropriate box? Should your command string be telnet db-server 3306 instead? - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]