Re: connection issue
Hi, # mysql -P 5045 Add -h127.0.0.1 # mysql -P5045 -h127.0.0.1 Cheers -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: connection issue
Thanks, Doug. How did you figure out it's because of open_files_limit? Best, Tianyin On Sat, Dec 22, 2012 at 5:51 AM, Doug d...@hacks.perl.sh wrote: sorry the problem has been resolved. it's the reason of open_files_limit too small. I increased it and the problem resolved. 2012/12/22 Doug d...@hacks.perl.sh: Hello, When connecting to mysql, sometime I got this error: # mysql -ucdn -h113.108.22x.xx -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 But most time it's correct. What's the reason? Thanks. I am running mysql-5.1.37 on Linux, there is no firewall configured on the host. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: connection issue
sorry the problem has been resolved. it's the reason of open_files_limit too small. I increased it and the problem resolved. 2012/12/22 Doug d...@hacks.perl.sh: Hello, When connecting to mysql, sometime I got this error: # mysql -ucdn -h113.108.22x.xx -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 But most time it's correct. What's the reason? Thanks. I am running mysql-5.1.37 on Linux, there is no firewall configured on the host. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: connection issue
Than you very much . It is working Anil DBA -Original Message- From: Dobromir Velev [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 8:58 PM To: mysql@lists.mysql.com Cc: Anil Subject: Re: connection issue When you connect without specifing the host, the mysql client will try to connect using the mysql socket file (usually /tmp/mysql.sock or /var/lib/mysql/mysql.sock) and when you specify the IP address it will try to connect using a TCP connection to port 3306. My guess is the you have name lookups turned on. If this is the case mysql will try to resolve the IP address given and probably the 192.168.3.111 IP is not resolving properly. The solution for this is to a add a skip-name-resolve option to your MySQL configuration file. You might also check http://dev.mysql.com/doc/refman/5.0/en/dns.html and the related articles in the MySQL documentation HTH Dobromir Velev On Thursday 13 October 2005 15:38, Anil wrote: Hi List, When I am trying to connect to mysql 4.0.20 database it is taking very long time when I specified host like Mysql -ux -p -h192.168.3.111 But it is connecting very quickly when I tried like below Mysql -ux -p It is an urgent issue. Please help me. Thanks Anil DBA -- Dobromir Velev -- 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: connection issue
When you connect without specifing the host, the mysql client will try to connect using the mysql socket file (usually /tmp/mysql.sock or /var/lib/mysql/mysql.sock) and when you specify the IP address it will try to connect using a TCP connection to port 3306. My guess is the you have name lookups turned on. If this is the case mysql will try to resolve the IP address given and probably the 192.168.3.111 IP is not resolving properly. The solution for this is to a add a skip-name-resolve option to your MySQL configuration file. You might also check http://dev.mysql.com/doc/refman/5.0/en/dns.html and the related articles in the MySQL documentation HTH Dobromir Velev On Thursday 13 October 2005 15:38, Anil wrote: Hi List, When I am trying to connect to mysql 4.0.20 database it is taking very long time when I specified host like Mysql -ux -p -h192.168.3.111 But it is connecting very quickly when I tried like below Mysql -ux -p It is an urgent issue. Please help me. Thanks Anil DBA -- Dobromir Velev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection Issue with DBI::DBD::Mysql
[EMAIL PROTECTED] wrote on 06/21/2005 01:56:50 PM: Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with the following output: imp_dbh-connect: dsn = database=userdb:hostname=192.168.2.113: port=3307, uid = user1, pwd = user1 imp_dbh-MyLogin: dbname = userdb, uid = user1, pwd = user1,host = 192.168.2.113, port = 3307 imp_dbh-mysql_dr_connect: host = 192.168.2.113, port = 3307, uid = user1, pwd = user1 imp_dbh-mysql_dr_connect: client_flags = 2 imp_dbh-mysql_dr_connect: -Access denied for user 'user1'@'192. 168.3.90' (using password: YES) error 1045 recorded: Access denied for user 'MSA'@'192.168.3.90' (using password: YES) What disturbs me is that the return error comes back with a different IP address than what I sent out. Anyone have any idea as to why? That would seem to be the problem with the access denied! George The IP address in your error message (192.168.3.90) is not the address you are trying to reach (your server's address) but the address of where you are calling from (your client's address). Authentication depends on not just WHO you are (as a MySQL user) but also from where you are trying to connect. Check for an entry in the mysql.user table that allows that user account to connect from that address. If all it has is an entry for that user to connect from the host localhost, that would be your problem. http://dev.mysql.com/doc/mysql/en/privilege-system.html You may also be running into a password hashing issue. Some clients (that term includes programming APIs) do not know how to authenticate against the stronger, longer password hash introduced in v4.1. More details and at least 3 workarounds here: http://dev.mysql.com/doc/mysql/en/old-client.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Connection Issue with DBI::DBD::Mysql (more information)
Hi, My bad. I forgot to explain that the IP address returned is NOT that of the machine where I'm running the program (the Linux server). That address is different from the one returned. Sorry for the confusion. George [EMAIL PROTECTED] wrote: looking at this the ipnumber 192.168.2.113 is the target windows/mysql machine. the linux machine, whose access is being rejected, has an ipnumber of 192.168.3.90. is that now how your have your machines configured? Original Message Date: Tuesday, June 21, 2005 01:56:50 PM -0400 From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Connection Issue with DBI::DBD::Mysql Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with the following output: imp_dbh-connect: dsn = database=userdb:hostname=192.168.2.113:port=3307, uid = user1, pwd = user1 imp_dbh-MyLogin: dbname = userdb, uid = user1, pwd = user1,host = 192.168.2.113, port = 3307 imp_dbh-mysql_dr_connect: host = 192.168.2.113, port = 3307, uid = user1, pwd = user1 imp_dbh-mysql_dr_connect: client_flags = 2 imp_dbh-mysql_dr_connect: -Access denied for user 'user1'@'192.168.3.90' (using password: YES) error 1045 recorded: Access denied for user 'MSA'@'192.168.3.90' (using password: YES) What disturbs me is that the return error comes back with a different IP address than what I sent out. Anyone have any idea as to why? That would seem to be the problem with the access denied! George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- End Original Message -- __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection issue with Kylix to Mysql 3.23
Hi, Did you make contact with Borland Support? Did you post message in Borland Newsgroup, 'newsgroups.borland.com'? Edward Valentine wrote: I downloaded and installed the new patch from Borland that allows Kylix to use versions of MySQL 3.23 and newer. Most of the errors on connection stopped and it seems to connect. What I am getting now is a "username/password invalid" error. I have connected with Webmin, MySQL at a prompt and kmysql using the same me and password. I have checked on the web and found several others with the same issue but no answers. I am using Caldera 3.1 with updates and all of the software versions included with that distro. I would appreciate any help. Thanks. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php