Re: unauthenticated user | while load testing
Usually this is caused by DNS-based authentication, where the reverse-DNS lookups are hanging for one reason or another. If you can, switch to IP-based authentication and use --skip-name-resolve. / Carsten On 05.01.2011 08:26, Yogesh Kore wrote: Hi, What is unauthenticated user seen in mysql processlist ? I am doing load testing and at a single time more than 1000 users are coming to mysql server. Do any one have idea about it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: unauthenticated user
In news:[EMAIL PROTECTED], Jerome Macaranas [EMAIL PROTECTED] wrote: Would it be possible to prevent reverse lookup? Im using the latest GA version.. Please read the manual section on how MySQL uses DNS. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unauthenticated user
Hi JM, JM wrote: i got this results from show processlist | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL | login | | That's just fine. The user is in login state, so he/she/it is not yet authenticated. There might be a DNS issue slowing down login, you might check if you can reverse lookup the hostnames of the connecting users. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unauthenticated user
Would it be possible to prevent reverse lookup? Im using the latest GA version.. thanks, On Wednesday 21 February 2007 23:12, Nils Meyer wrote: Hi JM, JM wrote: i got this results from show processlist | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | | NULL | login | | That's just fine. The user is in login state, so he/she/it is not yet authenticated. There might be a DNS issue slowing down login, you might check if you can reverse lookup the hostnames of the connecting users. regards Nils Mailing-List -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unauthenticated User (lots of connections problem)
BLOCKED::http://www.xamo.com:61519 is not actually part of the output from SHOW PROCESSLIST correct? Have you tried starting MySQL with --skip-name-resolve ? If this is the issue I'm thinking it is, would you be able to run tcpdump through grep for DNS traffic and see if anything is going on. And how well or not do the resolvers in /etc/resolv.conf on the master server resolve the problematic slave's IP address, reverse and forward? Is the problem slave the one on the different network? -Daniel -Original Message- From: Michael Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, June 02, 2005 4:55 PM To: mysql@lists.mysql.com Subject: Unauthenticated User (lots of connections problem) There's very few solutions on this problem in my research. I recently discovered a connection issue I cannot debug for the life of me. I don't know if it's related to a network/dns problem, if its the client, or the db server. My slave client, MySQL 4.0.23a (tried upgrading to 4.1.10, no change) tries to connect to our MySQL 4.1.7 server via PHP5 using mysql_connect(). Upon the connection, it makes approximately 600 connection attempts until the server times out with max connections, then stops and says 'Could not connect to MySQL Server'. The connection attempts appear on the server as: 19331 | unauthenticated user | XXX.XXX.XXX.XXX BLOCKED::http://www.xamo.com:61519 :61519 | NULL | Connect| NULL | Reading from net | NULL The even wierder part is that the IP address it says the connection is coming from isn't the IP address of where it's actually coming from, its a completely different IP on the local network. I don't get that at all. My 3 other slaves don't have this problem at all. I'm using PHP 5 to make the connections on each box, same specs on all slave boxes. The only difference is one is on a different network. All slaves are from external networks. Doesn't appear to be a firewall issue as the firewall is allowing the connections just like the other slaves. The problem slave can ping the database server and make other connections. I'm unsure if this is something on the Server, or if it's an issue related to the one problematic slave. It happens on the connection attempt, so it can't be a permissions issue with the server, or anything to do with SQL queries. Any insight into this at all? Michael Brown Xamo Entertainment Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: unauthenticated user
Well, this has been fixed, for your info, it was a problem from our DNS's with the reverse name process. Greets. Javier Tacon -Mensaje original- De: Javier Tacón [mailto:[EMAIL PROTECTED] Enviado el: martes, 20 de enero de 2004 11:23 Para: [EMAIL PROTECTED] Asunto: unauthenticated user Hi all, Today I have a strange problem, all the connections to mysql takes like 15-30 minuts to finally connect. When keeping an eye on the proccesslist I notice that I have a lot of these: | 4650 | unauthenticated user | 172.26.0.118:1037 | NULL | Connect | NULL | login | NULL | | 4651 | unauthenticated user | 172.26.0.118:1038 | NULL | Connect | NULL | login | NULL | | 4662 | unauthenticated user | 172.26.0.85:47976 | NULL | Connect | NULL | login | NULL | | 4701 | unauthenticated user | 172.26.0.85:47977 | NULL | Connect | NULL | login | NULL | | 4776 | unauthenticated user | 172.26.0.118:1039 | NULL | Connect | NULL | login | NULL | | 4785 | unauthenticated user | 172.26.0.118:1040 | NULL | Connect | NULL | login | NULL | | 4888 | unauthenticated user | 172.26.0.118:1041 | NULL | Connect | NULL | login | NULL | | 4896 | unauthenticated user | 172.26.0.118:1042 | NULL | Connect | NULL | login | NULL | I updated the mysql version to 4.1.1 a few days ago and all went correctly, but I downgraded to 4.0.x again, my old version, and the problem still exists event when I restart the mysql server. Anyone knows any possible reason for this trouble? May be something related with DNS servers (attacks) ? Can I debug to know more about this threads ? Thanks in advance. Javier Tacón ([EMAIL PROTECTED]) - Developer AZ Interactive, SL - (+34) 93 507 http://www.azinteractive.com http://www.azinteractive.com/ :: http://www.justlamp.com http://www.justlamp.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unauthenticated user
On Wed, Oct 16, 2002 at 11:30:47AM +0800, Terence wrote: sql,query I have noticed an entry in the processlist which reads UserHostDBCommandState unauthenticated userconnecting host[blank]connectlogin Can someone shed some light on this for me? Where is it coming from? Is it anything to be concerned about? You've caught a user just as they are connecting. MySQL doesn't know who the remote user is until it gets thru the autenitcation part of the protocol. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 70 days, processed 1,493,578,174 queries (244/sec. avg) - 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