Re: Remote Connection Problem
Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15 PM: I am having inconsistent behavior maintaining a remote connection with MySql Administrator/Browser. Brand new installations of clients on Windows XP and MySql server on Windows 2003 server. It worked fine at first then suddenly I could no longer connect (Error #1045. Access denied for user '[EMAIL PROTECTED]' Using password: YES). I tweaked permissions to the [EMAIL PROTECTED] (MDAS2 is the name of the client machine) to add SELECT for both the mysql and information_schema schemas. Connections worked well for most of today when suddenly my connection was no longer valid and now I can't connect again. Any ideas? Thanks in advance, Kent Roberts Missoula, MT DNS issues? Reverse DNS lookups seem to be emerging as a weak point for MySQL. Try running your server with --skip-name-resolve and setting your permissions to be IP address (not domain name) specific and see if the problem persists. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Remote Connection Problem
Thanks Shawn. It seems to be just that. [EMAIL PROTECTED] 08/08/05 03:02PM Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15 PM: I am having inconsistent behavior maintaining a remote connection with MySql Administrator/Browser. Brand new installations of clients on Windows XP and MySql server on Windows 2003 server. It worked fine at first then suddenly I could no longer connect (Error #1045. Access denied for user '[EMAIL PROTECTED]' Using password: YES). I tweaked permissions to the [EMAIL PROTECTED] (MDAS2 is the name of the client machine) to add SELECT for both the mysql and information_schema schemas. Connections worked well for most of today when suddenly my connection was no longer valid and now I can't connect again. Any ideas? Thanks in advance, Kent Roberts Missoula, MT DNS issues? Reverse DNS lookups seem to be emerging as a weak point for MySQL. Try running your server with --skip-name-resolve and setting your permissions to be IP address (not domain name) specific and see if the problem persists. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: remote connection problem
Hello. After checking that MySQL server listens on the interface to which you are connecting, solve network problems. If you're able to connect from one host to another it doesn't mean that the opposite is true. Andy McHargue [EMAIL PROTECTED] wrote: Here's some more data on this, if anyone can help. --I can connect the other way around ... i.e. I can connect from B to A. So there's no general connectivity problem. --did an nmap on B, $ nmap -sT -T Polite -p3306 xx.com Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ ) Interesting ports on s191.n33.xx.com (66.84.xx.xx): Port State Service 3306/tcp filteredmysql nmap on B indicates 'open' rather than 'filtered' ... how can i change? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection problem
Hello. Your server listens only on a single interface. Options could be given in different ways, not only from configuration file. If you want MySQL server to listen on every interface you should find where the bind option is given and remove it. See: http://dev.mysql.com/doc/mysql/en/program-options.html Andy McHargue [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 29 lines --] I'm having trouble connecting remotely from Server A (local) to Server B (remote). Both Linux. From Server A, I'm issuing this command mysql -h [domain.com] -u [user] -p And I get ERROR 2003: Can't connect to MySQL server on 'domain.com' (110) I assume this is a time out. 1. The user on Server B is set up with all privileges. 2. Server B's my.cnf has the line bind-address=127.0.0.1 but it is commented out with # 3. Server B's skip_networking is OFF. 4. A netstat -tl on Server B gives the line tcp0 0 domain.com:3306 *:* LISTEN I notice that on a different server, I get this tcp0 0 *:mysql *:* LISTEN and there's no line containing 3306. What's with that? 5. for troubleshooting's sake, ssh [remote-ip] -p 3306 times out. telnet is unavailable. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection problem
Here's some more data on this, if anyone can help. --I can connect the other way around ... i.e. I can connect from B to A. So there's no general connectivity problem. --did an nmap on B, $ nmap -sT -T Polite -p3306 xx.com Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ ) Interesting ports on s191.n33.xx.com (66.84.xx.xx): Port State Service 3306/tcp filteredmysql nmap on B indicates 'open' rather than 'filtered' ... how can i change? Andy McHargue wrote: I'm having trouble connecting remotely from Server A (local) to Server B (remote). Both Linux. From Server A, I'm issuing this command mysql -h [domain.com] -u [user] -p And I get ERROR 2003: Can't connect to MySQL server on 'domain.com' (110) I assume this is a time out. 1. The user on Server B is set up with all privileges. 2. Server B's my.cnf has the line bind-address=127.0.0.1 but it is commented out with # 3. Server B's skip_networking is OFF. 4. A netstat -tl on Server B gives the line tcp0 0 domain.com:3306 *:* LISTEN I notice that on a different server, I get this tcp0 0 *:mysql *:* LISTEN and there's no line containing 3306. What's with that? 5. for troubleshooting's sake, ssh [remote-ip] -p 3306 times out. telnet is unavailable. -- Andy McHargue Webmaster Annenberg School for Communication University of Southern California http://annenberg.usc.edu [EMAIL PROTECTED] Phone: 213.740.1290 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: remote connection problem
1) Are you running a firewall? If so, make sure that port 3306 is open. 2) Is your MySQL server is up and running? 3) Do you have the correct permissions to connect to the server via your mysql.hosts table? Just some thoughts. J.R. -Original Message- From: gerardo Villanueva [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 4:43 PM To: mysql@lists.mysql.com Subject: remote connection problem I have mysql version 4.0.15-nt in a server NT, I can connecting with mysql localy, but when i try remote connection the error is: Error Number 2003 Can't connect to MySQL server on 'IP' (10060) . I use mysql odbc 3.51 Is necesary the file my.cnf in c:\my.cnf Regards Gerardo Campos _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
RE: remote connection problem
When you are running as root, but are you running as 'root'@'%' or 'root'@'localhost'? This does make a big difference. The '%' means all network connections, which isn't secure. I would only using it as testing purposes. However, because your error message says that you cannot see the server, are you sure that your remote connection can see the NT server? This may be a bigger problem, i.e. DNS or IP routing/access lists. You may also want to check the hostname.err logs on the MySQL server to see if there is a connection problem there. J.R. -Original Message- From: gerardo Villanueva [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 5:03 PM To: [EMAIL PROTECTED] Subject: RE: remote connection problem 1.- Yes I have a firewall but the port 3306 is open 2.- Mysql is running in the server 3.- I connecting with user root and his has all the permissions I try to remote connection to my server NT 4.0 , mysql run there. Gerardo Campos _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com smime.p7s Description: S/MIME cryptographic signature
Re: remote connection problem
One other thing to check, make sure --skip-networking isn't specified in your configuration. mysql show variables like 'skip_networking'; +-+---+ | Variable_name | Value | +-+---+ | skip_networking | OFF | +-+---+ 1 row in set (0.00 sec) If the value is ON, you won't be allowed to make connections to the server via TCP/IP. On Tue, 2005-03-22 at 15:43 -0600, gerardo Villanueva wrote: I have mysql version 4.0.15-nt in a server NT, I can connecting with mysql localy, but when i try remote connection the error is: Error Number 2003 Can't connect to MySQL server on 'IP' (10060) . I use mysql odbc 3.51 Is necesary the file my.cnf in c:\my.cnf Regards Gerardo Campos _ Do You Yahoo!? Informacin de Estados Unidos y Amrica Latina, en Yahoo! Noticias. Vistanos en http://noticias.espanol.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection problem
Not necessary to change my.cnf, unless --skip-networking was specified. Also assuming that you are using port 3306. mysql show variables like 'port'; +---+---+ | Variable_name | Value | +---+---+ | port | 3306 | +---+---+ 1 row in set (0.00 sec) Can you verify that network traffic is getting from your remote client to the MySQL server? When you attempt to connect, do you see network packets coming to port 3306 on the MySQL server machine? On Tue, 2005-03-22 at 16:35 -0600, gerardo Villanueva wrote: I execute your query and the skip_networking is OFF. the file my.cnf, have to ubicated in C:\my.cnf or is not necesary?? Regards Gerardo Campos _ Do You Yahoo!? Informacin de Estados Unidos y Amrica Latina, en Yahoo! Noticias. Vistanos en http://noticias.espanol.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]