Re: mysql connection problems
Ken, You should probably be specifying the socket for both the startup commands and the connect commands just to be sure. Without seeing your config files, it's hard to say much else. Rich(ard) On Nov 6, 2007 9:37 PM, tech user [EMAIL PROTECTED] wrote: Hello members, I have two mysqld run on the same host (redhat linux OS with 2.4 kernel). the two mysqld are in different versions, one is 4.0.20,another is 5.0.45. the mysql 4.0.20 uses /etc/my.cnf as its config file,listening on default 3306 port. the mysql 5.0.45 uses /etc/mysql5.cnf as its config file,listening on 3307 port. I start them on command line: /usr/local/mysql/bin/mysqld_safe # for mysql4 /opt/mysql5/bin/mysqld_safe --defaults-file=/etc/mysql5.cnf # for mysql5 All run fine.I didn't see exceptions in mysql's error logs. But, when I try to connect to mysql5, with the command, mysql -uroot -P3307 -h127.0.0.1 Sometime I login it successfully,but most time I can't. The connection seems be blocked. (I don't run any iptables or firewall on this host). This let me really be confused. please help. Thanks! --Ken National Bingo Night. Play along for the chance to win $10,000 every week. Download your gamecard now at Yahoo!7 TV. http://au.blogs.yahoo.com/national-bingo-night/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Richard Edward Horner Engineer / Composer / Electric Guitar Virtuoso [EMAIL PROTECTED] http://richhorner.com - updated June 28th -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql connection problems
Hello members, I have two mysqld run on the same host (redhat linux OS with 2.4 kernel). the two mysqld are in different versions, one is 4.0.20,another is 5.0.45. the mysql 4.0.20 uses /etc/my.cnf as its config file,listening on default 3306 port. the mysql 5.0.45 uses /etc/mysql5.cnf as its config file,listening on 3307 port. I start them on command line: /usr/local/mysql/bin/mysqld_safe # for mysql4 /opt/mysql5/bin/mysqld_safe --defaults-file=/etc/mysql5.cnf # for mysql5 All run fine.I didn't see exceptions in mysql's error logs. But, when I try to connect to mysql5, with the command, mysql -uroot -P3307 -h127.0.0.1 Sometime I login it successfully,but most time I can't. The connection seems be blocked. (I don't run any iptables or firewall on this host). This let me really be confused. please help. Thanks! --Ken National Bingo Night. Play along for the chance to win $10,000 every week. Download your gamecard now at Yahoo!7 TV. http://au.blogs.yahoo.com/national-bingo-night/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Connection Problems
Hello all,I'm running into a intermittent and very annoying problem with all of my servers. I'm currently running FreeBSD 4.11, exim-4.51-0, and mySQL 4.1.13. My exim config is setup to have exim do a mySQL lookup in order to determine whether a given user's e-mail is hosted by our e-mail servers.Periodically, exim throws the following error into its panic log:Feb 9 13:24:51 mx_server_1 exim[69953]: 2006-02-09 13:24:51 failed to expand "${lookup mysql {select distinct domain from email_table where domain='$domain'}{$value}}" while checking a list: lookup of "select distinct domain from email_table where domain='bob.com'" gave DEFER: MYSQL connection failed: Can't connect to MySQL server on '127.0.0.1' (61)(where bob.com is one of our customer's domains that we host.)This has been happening for months, and I'm trying to get rid of these errors. The come in bursts - in a single second, I could get as many as 30 to 40 of these messages.Now, I've taken a few different steps to track this down, but the problem is very elusive and hard to replicate. The mySQL error logs are unhelpful. I'm sure that my mySQL server isn't running out of connections, because if it was, I would receive a "too many connection" error message. (I deliberately lowered the max number of mySQL connections to test this.)I'm wondering if there's a system level limit that I'm running into that would be independant of exim or mySQL's configuration. I'm a little hazy in this area, but I would be talking about some sysctl variable, a ulimit on open sockets, or something to that effect.I'm rather stumped on this issue, so if anyone has any suggestions or hints on what might be causing this error or where I might start looking to find the root cause of the problem, I would be very grateful.Thanks,Michael Jeung
smime.p7s
Description: S/MIME cryptographic signature
Re: MySQL Connection Problems
On Thursday, 9 February 2006 at 17:02:06 -0800, Michael Jeung wrote:
Periodically, exim throws the following error into its panic log:
Feb 9 13:24:51 mx_server_1 exim[69953]: 2006-02-09 13:24:51 failed to expand
${lookup mysql {select distinct domain from email_table where
domain='$domain'}{$value}} while checking a list: lookup of select distinct
domain from email_table where domain='bob.com' gave DEFER: MYSQL connection
failed: Can't connect to MySQL server on '127.0.0.1' (61)
(where bob.com is one of our customer's domains that we host.)
This has been happening for months, and I'm trying to get rid of
these errors. The come in bursts - in a single second, I could get as
many as 30 to 40 of these messages.
Now, I've taken a few different steps to track this down, but the
problem is very elusive and hard to replicate. The mySQL error logs
are unhelpful. I'm sure that my mySQL server isn't running out of
connections, because if it was, I would receive a too many
connection error message. (I deliberately lowered the max number of
mySQL connections to test this.)
Since you've checked the MySQL logs, can I assume that you've
confirmed that the server hasn't been failing and being restarted?
Even if you don't find any evidence of such problems, can you check
with ps to see when the mysqld was started?
I'm wondering if there's a system level limit that I'm running into
that would be independant of exim or mySQL's configuration. I'm a
little hazy in this area, but I would be talking about some sysctl
variable, a ulimit on open sockets, or something to that effect.
This doesn't seem consistent with the errors you're reporting. If you
did hit some FreeBSD-related limit, it would be reported in
/var/log/messages.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]
Are you MySQL certified? http://www.mysql.com/certification/
pgp2Zc2X7AfT4.pgp
Description: PGP signature
Re: Mysql Connection Problems
On Wed, Nov 05, 2003 at 03:39:03PM +1030, John wrote: HI All I was wondering if anyone could tell me how to get around this problems Error: could not connect to the database. It's possible the database itself is just not working at the moment. The admin should also check that the database details have been correctly specified in config.php Database host: localhost Database name: Database user: It seems that the database is loosing connections Have you tried connecting directly with the command-line client? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,002,702,478 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Connection Problems
HI All I was wondering if anyone could tell me how to get around this problems Error: could not connect to the database. It's possible the database itself is just not working at the moment. The admin should also check that the database details have been correctly specified in config.php Database host: localhost Database name: Database user: It seems that the database is loosing connections Cheers Trevor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL Connection Problems
Hi all, I am very new to MYSQL and I am running 3.23 on RedHat Linux 7.1. I have just set up a simple database. I was not prompted for a password,and was just allowed to set it up and access it.I now want to access it through C,and I am trying to set up a connection to my database but I am getting an error : ERROR 1045 : Access Denied for User ME@localalhost (Using Password =- Yes). How can I set the password to my database,or how can I turn it off or is there another way to overcome my problem. I know this is a simple one but it has me at a loss and I cant really get started untill I overcome it. Thanks in adbvance for any help receive john - 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
Re: MYSQL Connection Problems
Look at the source for the mysql client, and see how they do it. O'SULLIVAN JOHN wrote: Hi all, I am very new to MYSQL and I am running 3.23 on RedHat Linux 7.1. I have just set up a simple database. I was not prompted for a password,and was just allowed to set it up and access it.I now want to access it through C,and I am trying to set up a connection to my database but I am getting an error : ERROR 1045 : Access Denied for User ME@localalhost (Using Password =- Yes). How can I set the password to my database,or how can I turn it off or is there another way to overcome my problem. I know this is a simple one but it has me at a loss and I cant really get started untill I overcome it. Thanks in adbvance for any help receive john - 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 -- Gerald L. Clark [EMAIL PROTECTED] - 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
