RE: random access denied
Does anyone think I would have better luck installing MySQL with something other than an RPM?? -Original Message- From: James M Kupernik [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:59 AM To: 'mos' Cc: [EMAIL PROTECTED] Subject: RE: random access denied Thank you, I have checked all of the above. I have set the max connections to 200, but that didn't help any. The connection per hour is not a factor because it doesn't lock out the user, it just fails to authenticate, but as soon as you refresh the page or try to connect via the command line to goes through. Jamie -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:37 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: random access denied At 11:17 AM 9/18/2003, you wrote: It's not a continued access denied, because it can accept connections all day long, but randomly it will just deny one, but the accept it on the next try. I've googled this problem to death, I don't know what else I can do James, Are you sure it's not something simple like exceeding the Max_Connections? (Default is 100) I'm sure you've checked this but there's no harm in asking. For something a little more esoteric, check out the user's Grant properties. It is possible to define Max_Connections_Per_Hour, Max_Updates_Per_Hour or Max_Queries_Per_Hour for the user. So he could be prohibited one hour, but next hour he regains access. Mike -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 5:20 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: random access denied At 03:09 PM 9/17/2003, you wrote: Anything that anyone can suggest that might point me in some direction would be very helpful. I'm just at a complete lose right now ... James, See the Google Group search: http://groups.google.ca/groups?hl=enlr=ie=UTF-8oe=UTF-8safe=offq=m ysql+ %22Access+denied+for+user%22btnG=Google+Search There are quite a few suggestions listed there. Mike -Original Message- From: James M Kupernik [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:58 PM To: [EMAIL PROTECTED] Subject: random access denied Hello, I am having a frustrating problem with MySQL. I don't consider myself a newbie, nor am I a master, but either way I can't figure out this problem and I'm hoping someone here has an idea of what is going wrong. Every so often MySQL decides it doesn't want to authenticate a user, doesn't matter on the user/db, etc;. The error message is: 030916 16:10:50 39 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have a whole log full of these messages. Now and soon as the page is refreshed or you try logging in again (from the command line) it goes through. It's only a temp error. If anyone has any suggestion I'm more than willing to try them. This server was supposed to be in production about a week ago and I can't let it go like this. Thanks very much!! Jamie -- 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] -- 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: random access denied
It's not a continued access denied, because it can accept connections all day long, but randomly it will just deny one, but the accept it on the next try. I've googled this problem to death, I don't know what else I can do -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 5:20 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: random access denied At 03:09 PM 9/17/2003, you wrote: Anything that anyone can suggest that might point me in some direction would be very helpful. I'm just at a complete lose right now ... James, See the Google Group search: http://groups.google.ca/groups?hl=enlr=ie=UTF-8oe=UTF-8safe=offq=mysql+ %22Access+denied+for+user%22btnG=Google+Search There are quite a few suggestions listed there. Mike -Original Message- From: James M Kupernik [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:58 PM To: [EMAIL PROTECTED] Subject: random access denied Hello, I am having a frustrating problem with MySQL. I don't consider myself a newbie, nor am I a master, but either way I can't figure out this problem and I'm hoping someone here has an idea of what is going wrong. Every so often MySQL decides it doesn't want to authenticate a user, doesn't matter on the user/db, etc;. The error message is: 030916 16:10:50 39 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have a whole log full of these messages. Now and soon as the page is refreshed or you try logging in again (from the command line) it goes through. It's only a temp error. If anyone has any suggestion I'm more than willing to try them. This server was supposed to be in production about a week ago and I can't let it go like this. Thanks very much!! Jamie -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: random access denied
Thank you, I have checked all of the above. I have set the max connections to 200, but that didn't help any. The connection per hour is not a factor because it doesn't lock out the user, it just fails to authenticate, but as soon as you refresh the page or try to connect via the command line to goes through. Jamie -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:37 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: random access denied At 11:17 AM 9/18/2003, you wrote: It's not a continued access denied, because it can accept connections all day long, but randomly it will just deny one, but the accept it on the next try. I've googled this problem to death, I don't know what else I can do James, Are you sure it's not something simple like exceeding the Max_Connections? (Default is 100) I'm sure you've checked this but there's no harm in asking. For something a little more esoteric, check out the user's Grant properties. It is possible to define Max_Connections_Per_Hour, Max_Updates_Per_Hour or Max_Queries_Per_Hour for the user. So he could be prohibited one hour, but next hour he regains access. Mike -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 5:20 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: random access denied At 03:09 PM 9/17/2003, you wrote: Anything that anyone can suggest that might point me in some direction would be very helpful. I'm just at a complete lose right now ... James, See the Google Group search: http://groups.google.ca/groups?hl=enlr=ie=UTF-8oe=UTF-8safe=offq=m ysql+ %22Access+denied+for+user%22btnG=Google+Search There are quite a few suggestions listed there. Mike -Original Message- From: James M Kupernik [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:58 PM To: [EMAIL PROTECTED] Subject: random access denied Hello, I am having a frustrating problem with MySQL. I don't consider myself a newbie, nor am I a master, but either way I can't figure out this problem and I'm hoping someone here has an idea of what is going wrong. Every so often MySQL decides it doesn't want to authenticate a user, doesn't matter on the user/db, etc;. The error message is: 030916 16:10:50 39 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have a whole log full of these messages. Now and soon as the page is refreshed or you try logging in again (from the command line) it goes through. It's only a temp error. If anyone has any suggestion I'm more than willing to try them. This server was supposed to be in production about a week ago and I can't let it go like this. Thanks very much!! Jamie -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: random access denied
Anything that anyone can suggest that might point me in some direction would be very helpful. I'm just at a complete lose right now ... -Original Message- From: James M Kupernik [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:58 PM To: [EMAIL PROTECTED] Subject: random access denied Hello, I am having a frustrating problem with MySQL. I don't consider myself a newbie, nor am I a master, but either way I can't figure out this problem and I'm hoping someone here has an idea of what is going wrong. Every so often MySQL decides it doesn't want to authenticate a user, doesn't matter on the user/db, etc;. The error message is: 030916 16:10:50 39 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have a whole log full of these messages. Now and soon as the page is refreshed or you try logging in again (from the command line) it goes through. It's only a temp error. If anyone has any suggestion I'm more than willing to try them. This server was supposed to be in production about a week ago and I can't let it go like this. Thanks very much!! Jamie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: /etc/my.cnf config file doesn`t exist on my system
Look in /usr/share/doc/packages/MySQL-server/ for some example my.cnf and find the one that works for you and copy it the /etc Jamie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:17 PM To: [EMAIL PROTECTED] Subject: /etc/my.cnf config file doesn`t exist on my system Importance: High Dear list: I`ve just to install the binary RPM MySQL-serverv 4.0.15 into my Linux RH7.3 box. The installation was successfull however when I tried to edit the /etc/my.cnf file to configure error and query path logs, my Linux system says : /etc/cnf: No such file or directory However when I runn rpm -ql MySQL-server I see this output: /etc/init.d/mysql /etc/logrotate.d/mysql /etc/my.cnf /usr/bin/isamchk /usr/bin/isamlog /usr/bin/my_print_defaults /usr/bin/myisamchk /usr/bin/myisamlog /usr/bin/myisampack /usr/bin/mysql_convert_table_format /usr/bin/mysql_explain_log /usr/bin/mysql_fix_extensions /usr/bin/mysql_fix_privilege_tables /usr/bin/mysql_install_db /usr/bin/mysql_secure_installation /usr/bin/mysql_setpermission /usr/bin/mysql_zap /usr/bin/mysqlbug /usr/bin/mysqld_multi /usr/bin/mysqld_safe /usr/bin/mysqlhotcopy /usr/bin/mysqltest /usr/bin/pack_isam /usr/bin/perror /usr/bin/replace /usr/bin/resolve_stack_dump /usr/bin/resolveip /usr/bin/safe_mysqld /usr/lib/mysql/mysqld.sym /usr/sbin/mysqld /usr/sbin/rcmysql the rest was ommited for me I reinstalled the RPM packet but the problem exist still. What should I do? Some one have any suggestions? EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: /etc/my.cnf config file doesn`t exist on my system
you just need to restart mysql now as long as you put the file into /etc/my.cnf shutdown mysql: mysqladmin -u root -p shutdown start: safe_mysqld The file never installed from me from the RPM either, i had to manually copy it in, yet the server will work without it. Hope that helps. Jamie -Original Message- From: James M Kupernik [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:35 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: /etc/my.cnf config file doesn`t exist on my system Look in /usr/share/doc/packages/MySQL-server/ for some example my.cnf and find the one that works for you and copy it the /etc Jamie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:17 PM To: [EMAIL PROTECTED] Subject: /etc/my.cnf config file doesn`t exist on my system Importance: High Dear list: I`ve just to install the binary RPM MySQL-serverv 4.0.15 into my Linux RH7.3 box. The installation was successfull however when I tried to edit the /etc/my.cnf file to configure error and query path logs, my Linux system says : /etc/cnf: No such file or directory However when I runn rpm -ql MySQL-server I see this output: /etc/init.d/mysql /etc/logrotate.d/mysql /etc/my.cnf /usr/bin/isamchk /usr/bin/isamlog /usr/bin/my_print_defaults /usr/bin/myisamchk /usr/bin/myisamlog /usr/bin/myisampack /usr/bin/mysql_convert_table_format /usr/bin/mysql_explain_log /usr/bin/mysql_fix_extensions /usr/bin/mysql_fix_privilege_tables /usr/bin/mysql_install_db /usr/bin/mysql_secure_installation /usr/bin/mysql_setpermission /usr/bin/mysql_zap /usr/bin/mysqlbug /usr/bin/mysqld_multi /usr/bin/mysqld_safe /usr/bin/mysqlhotcopy /usr/bin/mysqltest /usr/bin/pack_isam /usr/bin/perror /usr/bin/replace /usr/bin/resolve_stack_dump /usr/bin/resolveip /usr/bin/safe_mysqld /usr/lib/mysql/mysqld.sym /usr/sbin/mysqld /usr/sbin/rcmysql the rest was ommited for me I reinstalled the RPM packet but the problem exist still. What should I do? Some one have any suggestions? EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
random access denied
Hello, I am having a frustrating problem with MySQL. I don't consider myself a newbie, nor am I a master, but either way I can't figure out this problem and I'm hoping someone here has an idea of what is going wrong. Every so often MySQL decides it doesn't want to authenticate a user, doesn't matter on the user/db, etc;. The error message is: 030916 16:10:50 39 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have a whole log full of these messages. Now and soon as the page is refreshed or you try logging in again (from the command line) it goes through. It's only a temp error. If anyone has any suggestion I'm more than willing to try them. This server was supposed to be in production about a week ago and I can't let it go like this. Thanks very much!! Jamie