RE: Unable to connect to DB
I followed what you said up until the last sentence. Which kind of remote connection are you trying to make? I was under the impression that you had an Access front end that you are trying to connect to a MySQL backend. If that's the case you need to make sure that your MySQL server on the Linux box is opening and listening on 3306. I believe the config files are set up to do that automatically. There is also a native socket that opens up on Linux. It is entirely possible that your local client (on your Linux box) is using that socket to connect and not the IP stack. If your IP port isn't open, your Win box can't reach the server. To test if your port is open: 1) On your windows box, open a dos prompt and launch the utility program "telnet" 2) while in telnet, enter: open 3306 The response from the other machine should be some binary data, the server version in clear text, and some more binary data. Just the fact that you got a response means that your server is connecting to the network. Getting that port open is crucial to making an external connection to your server. If you can make contact, then we have to worry about other issues (like permissions). Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Bartis, Robert M (Bob)" To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> <[EMAIL PROTECTED]cc: [EMAIL PROTECTED] m> Fax to: Subject: RE: Unable to connect to DB 06/11/2004 05:11 PM Thanks for the pointers. We can connect from the Linux box to my PC so we're convinced the network is not an issue, but still cannot connect from my PC to the new MySQL server installed on the Linux box. When we monitor the packets coming in we can see the request to connect and to MySQL at port 3306 followed by the request for an ICMP ping instead of the expected ACK. The ports are enabled in the etc/services file so we're at a loss. Is there a setting to allow remote connections in Linux? Still lost:-| Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 3:30 PM To: Bartis, Robert M (Bob) Cc: [EMAIL PROTECTED] Subject: Re: Unable to connect to DB Check to make sure the linux box has its port open (do a MySQL "ping"). >From the windows box, telnet to your linux box on port 3306 (or whatever you set your linux server to listen on in your my.cnf file) you should see the version# of the server and a bunch of non-text information. If that fails, your linux box is not listening. Change your server's config file to open a port. Another issue about mixing platforms if you are trying to access your MySQL server through the ODBC driver (the most current version I can find is 3.x) and your server is version 4.1 or better, you will have to downgrade your password. Log into the MySQL with admin permissions (root) and run this command: update mysql.user set password=old_password('') where user = ''; Also, make sure you have GRANT-ed the appropriate permission for your user acct to the new tables. HTH, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Bartis, Robert M (Bob)" To: [EMAIL PROTECTED] <[EMAIL PROTECTED]cc: m> Fax to: Subject: Unable to connect to DB 06/11/2004 03:19 PM I have been using a local copy of the current production version of MySQL in a windows environment while we evaluate porting a MS Access front-end to make use of MySQL. We are ready to go prime-time within my team and as part of this exercise installed a LINIX version of MySQL on another machine. We can create a DB, import file
RE: Unable to connect to DB
Thanks for the pointers. We can connect from the Linux box to my PC so we're convinced the network is not an issue, but still cannot connect from my PC to the new MySQL server installed on the Linux box. When we monitor the packets coming in we can see the request to connect and to MySQL at port 3306 followed by the request for an ICMP ping instead of the expected ACK. The ports are enabled in the etc/services file so we're at a loss. Is there a setting to allow remote connections in Linux? Still lost:-| Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 3:30 PM To: Bartis, Robert M (Bob) Cc: [EMAIL PROTECTED] Subject: Re: Unable to connect to DB Check to make sure the linux box has its port open (do a MySQL "ping"). >From the windows box, telnet to your linux box on port 3306 (or whatever you set your linux server to listen on in your my.cnf file) you should see the version# of the server and a bunch of non-text information. If that fails, your linux box is not listening. Change your server's config file to open a port. Another issue about mixing platforms if you are trying to access your MySQL server through the ODBC driver (the most current version I can find is 3.x) and your server is version 4.1 or better, you will have to downgrade your password. Log into the MySQL with admin permissions (root) and run this command: update mysql.user set password=old_password('') where user = ''; Also, make sure you have GRANT-ed the appropriate permission for your user acct to the new tables. HTH, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Bartis, Robert M (Bob)" To: [EMAIL PROTECTED] <[EMAIL PROTECTED]cc: m> Fax to: Subject: Unable to connect to DB 06/11/2004 03:19 PM I have been using a local copy of the current production version of MySQL in a windows environment while we evaluate porting a MS Access front-end to make use of MySQL. We are ready to go prime-time within my team and as part of this exercise installed a LINIX version of MySQL on another machine. We can create a DB, import files etc, etc while on the local LINIX box, but are unable to connect via a remote machine. Any suggestions on how to debug this issue? Networking is not an issue as we can ping the machine. Thanks in advance for you help Bob -- 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: Unable to connect to DB
Check to make sure the linux box has its port open (do a MySQL "ping"). >From the windows box, telnet to your linux box on port 3306 (or whatever you set your linux server to listen on in your my.cnf file) you should see the version# of the server and a bunch of non-text information. If that fails, your linux box is not listening. Change your server's config file to open a port. Another issue about mixing platforms if you are trying to access your MySQL server through the ODBC driver (the most current version I can find is 3.x) and your server is version 4.1 or better, you will have to downgrade your password. Log into the MySQL with admin permissions (root) and run this command: update mysql.user set password=old_password('') where user = ''; Also, make sure you have GRANT-ed the appropriate permission for your user acct to the new tables. HTH, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Bartis, Robert M (Bob)" To: [EMAIL PROTECTED] <[EMAIL PROTECTED]cc: m> Fax to: Subject: Unable to connect to DB 06/11/2004 03:19 PM I have been using a local copy of the current production version of MySQL in a windows environment while we evaluate porting a MS Access front-end to make use of MySQL. We are ready to go prime-time within my team and as part of this exercise installed a LINIX version of MySQL on another machine. We can create a DB, import files etc, etc while on the local LINIX box, but are unable to connect via a remote machine. Any suggestions on how to debug this issue? Networking is not an issue as we can ping the machine. Thanks in advance for you help Bob -- 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]