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 <ipaddressof your linux box> 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('<your ODBC pwd here>') where
user = '<your ODBC user name here>';
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]
