MYSQL connection failed: Can not connect to MySQL server
Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim was compiled with MySQL support, the MySQL database is external to the mail server. Although the system works, I have a lot of daily messages in exim's log with the following error: MYSQL connection failed: Can not connect to MySQL server on'192 .168.5.1 '(1) What causes some messages are rejected. To try to reproduce the problem I have tried doing Telnet connections to the server and MySQL, sometimes I get the following error: Telnet 192.168.5.1 3306 Trying 192.168.5.1 ... Telnet: connect to address 192.168.5.1: Operation not permitted Telnet: Unable to connect to remote host Someone could help me with this ?, thanks in advance Best regards _ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx
Re: MYSQL connection failed: Can not connect to MySQL server
In the last episode (Oct 31), Jose Romero said: Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim was compiled with MySQL support, the MySQL database is external to the mail server. Although the system works, I have a lot of daily messages in exim's log with the following error: MYSQL connection failed: Can not connect to MySQL server on'192 .168.5.1 '(1) What causes some messages are rejected. To try to reproduce the problem I have tried doing Telnet connections to the server and MySQL, sometimes I get the following error: Telnet 192.168.5.1 3306 Trying 192.168.5.1 ... Telnet: connect to address 192.168.5.1: Operation not permitted Telnet: Unable to connect to remote host Someone could help me with this ?, thanks in advance Best regards Do you maybe have an ipfw rule that would be blocking that? That's the only thing I can think of that will cause an EPERM error on a socket connect call. A limit rule with a too-low connection count could cause what you're seeing. Adding an explicit allow rule before your limit rule, allowing traffic to port 3306 of the other server, should fix your problem. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Connection Failed: Can't create a new thread
I am having problems with the number of simultaneous connections in the MySQL. I configured 5000 connections but when arriving in 4096 it presents the errors below. MySQL Connection Failed: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug It follows below the configuration of the Server and the archive my.cnf Somebody has an idea of as can have 5000 simultaneous connections without problems? MemTotal: 2064404 kB Intel Dual processors 2.4 Ghz HT S.O Red Hat 9.0 Kernel 2.4.20-30.9smp set-variable= max_connections=5000 set-variable= key_buffer=32M set-variable= max_allowed_packet=2M set-variable= table_cache=128 set-variable= sort_buffer=1024K set-variable= net_buffer_length=16K set-variable= myisam_sort_buffer_size=16M #set-variable = log=mysql.log log-bin server-id = 1 # Point the following paths to different dedicated disks #tmpdir = /tmp/ # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /usr/local/mysql/data/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data/ innodb_log_arch_dir = /usr/local/mysql/data/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high set-variable = innodb_buffer_pool_size=1024M set-variable = innodb_additional_mem_pool_size=4M # Set .._log_file_size to 25 % of buffer pool size set-variable = innodb_log_file_size=110M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50[mysqldump] quick set-variable= max_allowed_packet=32M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable= key_buffer=40M set-variable= sort_buffer=40M set-variable= read_buffer=4Mset-variable= write_buffer=4M [myisamchk] set-variable= key_buffer=40M set-variable= sort_buffer=40M set-variable= read_buffer=4M set-variable= write_buffer=4M [mysqlhotcopy] interactive-timeout Daniel Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL connection failed with NIS
Hi, I installed MySQL 3.23.54 on HPUX system with NIS. If I run /opt/mysql/bin/mysql -hlocalhost -uroot mysql, everything looks fine. But if I run $ /opt/mysql/bin/mysql -hhostname.domain -uroot mysql ERROR 2013: Lost connection to MySQL server during query And I can't connect to MySQL with JDBC Driver. I tried root user with both jdbc:mysql://hostname.domain:3306/mysql and jdbc:mysql://localhost:3306/mysql This is the entries of mysql.user table: localhost rootY Y Y . host.domain rootY Y Y host Do anyone have some idears? Thanks very much! Zengfa __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Coldfusion/MySQL - Connection Failed
Hi! Let me try to restate my question and provide more information. Running: Linux 2.2.16-3, Coldfusion 4.5, MySQL 3.23.33 Problem: "The connection to the data source failed. Check the following to resolve this problem: ..." Now, I get this error on one database called xprojects while I can get the datasource to verify on the test database that came with mysql. i connect to the test with no user and no password. I tried to set up the permissions on the xprojects database like the test database.. but it still didnt work. I am assuming based upon what I have read about MySQL and Coldfusion that this is a permissions issue. For those that have this working what should the permissions be like and could this be anything else? Thanks, -Tanya - 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
MYSQL Connection failed
Hallo,
Kann mir irgend jemand helfen?
Ich kann mit der folgenden Meldung nichts anfangen:
Anbei die Datei zum verbinden zur Datenbank:
_
?
$server = "localhost"; // MySQL-Server
$user = "root"; // MySQL-Nutzer
$pass = "geheim"; // MySQL-Kennwort
//
$conn = mysql_connect($server, $user, $pass);
if($conn) {
echo "BYes, we're open!/B Handle: $conn";
} else {
echo "BOops, something goes wrong";
exit;
}
$select = mysql_select_db("customers",$conn);
?
________
Und hier die Fehlermeldung:
Warning: MySQL Connection Failed: Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (111) in
/usr/local/httpd/htdocs/dbopen.php3 on line 8
Oops, something goes wrong
-
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
MYSQL Connection failed
Hallo,
Kann mir irgend jemand helfen?
Ich kann mit der folgenden Meldung nichts anfangen:
Anbei die Datei zum verbinden zur Datenbank:
_
?
$server = "localhost"; // MySQL-Server
$user = "root"; // MySQL-Nutzer
$pass = "geheim"; // MySQL-Kennwort
//
$conn = mysql_connect($server, $user, $pass);
if($conn) {
echo "BYes, we're open!/B Handle: $conn";
} else {
echo "BOops, something goes wrong";
exit;
}
$select = mysql_select_db("customers",$conn);
?
________
Und hier die Fehlermeldung:
Warning: MySQL Connection Failed: Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (111) in
/usr/local/httpd/htdocs/dbopen.php3 on line 8
Oops, something goes wrong
---
-
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
Error: MYSQL Connection failed
Hi there,
First i have the mysql db on linux in /usr/local/
then i installed new on /var
now i get the message:
Warning: MYSQL Connection failed:
Can't connect to local MYSQL Server through Socket
'/var/lib/mysql/mysql.sock' (111) in /usr/local/httpd/htdocs/dbopen.php3 on
line 8.
This is the text from dbopen.php3:
?
$server = "localhost"; // MySQL-Server
$user = "root"; // MySQL-Nutzer
$pass = "secret"; // MySQL-Kennwort
//
$conn = mysql_connect($server, $user, $pass);
if($conn) {
echo "BYes, we're open!/B Handle: $conn";
} else {
echo "BOops, something goes wrong";
exit;
}
$select = mysql_select_db("name_of_db",$conn);
?
Any Ideas?
Thanks in advance
Regards from cologne
denis
-
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
Warning: MySQL Connection Failed - Initial Install Help
Hello all, I hope you can help me with a problem I have been trying to figure out for the past week. I bought Red Hat 7 and am trying to get Apache/PHP/MySQL working correctly. Using the Red Hat install program, I installed all the RPMs including the php, mod_php, apache, mysql, mysql-php, mysql-server, etc. I know Apache works and so does PHP, when its not trying to access MySQL. However, when I try to upload phpMyAdmin to the webserver and then access it, I get the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php on line 255 Error MySQL said: Back That's the entire page that shows up at http://myipaddress/phpMyAdmin/ What is going on? What does that mean? When I am at the console of the Red Hat machine, and I type: mysql startI get the same error: Can't connect to loacl MySQL server through socket 'var/lib/mysql/mysql.sock' (111). When I go to the /var/lib/mysql directory, there is nothing listed in a 'ls' command. Thanks for any help. As you can guess, I am rather new the Linux as a server operating system. Ryan Shrout Athlonmb.com Production Manager http://www.athlonmb.com/ [EMAIL PROTECTED]
MySql connection failed in browser
Hey everyone, I just went through a new setup of Information Resource Manager scripts under PHP 4.0.1p12-9 that work with MySql 3.23.22-6 under Apache 1.3.125-25, all of this stuff except the Resource Manager come standard with RedHat 7.0. After creating the database for the set of php scripts, I should be able to go right into my web browser and get to the scripts and see all the default screens. I can get to the login screen, but when entering a username and password I get the following: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 83 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 84 Warning: MySQL: A link to the server could not be established in ./irm.inc on line 84 It just looks like there may be a problem with the php scripts and the link to the mysql database, I've been through all of the config files I could find and have been searching the internet for some type of answer. I'm new to the mysql and php world, so it's all a struggle right now. Anyone have any ideas? (I'm sure it's a pretty simple fix) Thanks, Tim Czerlinsky Customer Support [EMAIL PROTECTED] ___ TechWorks 4030 West Braker Lane, Suite 350 Austin, Texas 78759-5319 USA 800-688-7466 ___ http://www.techworks.com http://www.techworks.com/ 512-794-8558 FAX Customer Support is available Mon.- Fri. 9:00 AM to 5:30 PM CST 800-933-6113
Re: MySql connection failed in browser
Since you say you're new to this stuff, let's start with the very basics. RH7.0, I thought, was done poorly with many bugs. You can download their latest RPM patches from their ftp server which will fix up a lot of these bugs. With MySQL, my advice is to download the latest and greatest RPM directly from their website, not RH's. If you're not going to bother upgrading PHP then don't bother using persistent connections. The next step, once installed/upgraded, check that the server is working ok. Use ps -ef | grep mysql to find out. - Original Message - From: "Tim Czerlinsky" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 6:39 Subject: MySql connection failed in browser Hey everyone, I just went through a new setup of Information Resource Manager scripts under PHP 4.0.1p12-9 that work with MySql 3.23.22-6 under Apache 1.3.125-25, all of this stuff except the Resource Manager come standard with RedHat 7.0. After creating the database for the set of php scripts, I should be able to go right into my web browser and get to the scripts and see all the default screens. I can get to the login screen, but when entering a username and password I get the following: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 83 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 84 Warning: MySQL: A link to the server could not be established in ./irm.inc on line 84 It just looks like there may be a problem with the php scripts and the link to the mysql database, I've been through all of the config files I could find and have been searching the internet for some type of answer. I'm new to the mysql and php world, so it's all a struggle right now. Anyone have any ideas? (I'm sure it's a pretty simple fix) Thanks, Tim Czerlinsky Customer Support [EMAIL PROTECTED] ___ TechWorks 4030 West Braker Lane, Suite 350 Austin, Texas 78759-5319 USA 800-688-7466 ___ http://www.techworks.com http://www.techworks.com/ 512-794-8558 FAX Customer Support is available Mon.- Fri. 9:00 AM to 5:30 PM CST 800-933-6113 - 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 failed in browser
I've been running Redhat 7.0 for 5 months now on my production server, haven't had any trouble with it. I had trouble with the rpms for 3.23.34 that were on mysql.com's download page. The server was getting intermittent signal 11's with blown stacks. I assume a shared library mismatch. My guess is that it was due to some incompatibility with RH 7.0 as I hear the rpms on mysql.com are built against RH 6.2. I reverted back to 3.23.32 from redhat.com's updates ftp area for 7.0 and it worked fine. To be honest, I don't really know what was causing the signal 11's. They were intermittent and thus hard to track down. Is anyone out there running the 3.23.34 rpms from mysql.com on RH 7.0 successfully (under load)? ...without getting signal 11's? If so, then I'm wrong and it was something else. -bill At 08:06 AM 3/15/2001 +0800, Rolf Hopkins wrote: Since you say you're new to this stuff, let's start with the very basics. RH7.0, I thought, was done poorly with many bugs. You can download their latest RPM patches from their ftp server which will fix up a lot of these bugs. With MySQL, my advice is to download the latest and greatest RPM directly from their website, not RH's. If you're not going to bother upgrading PHP then don't bother using persistent connections. The next step, once installed/upgraded, check that the server is working ok. Use ps -ef | grep mysql to find out. - Original Message - From: "Tim Czerlinsky" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 6:39 Subject: MySql connection failed in browser Hey everyone, I just went through a new setup of Information Resource Manager scripts under PHP 4.0.1p12-9 that work with MySql 3.23.22-6 under Apache 1.3.125-25, all of this stuff except the Resource Manager come standard with RedHat 7.0. After creating the database for the set of php scripts, I should be able to go right into my web browser and get to the scripts and see all the default screens. I can get to the login screen, but when entering a username and password I get the following: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 83 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 84 Warning: MySQL: A link to the server could not be established in ./irm.inc on line 84 It just looks like there may be a problem with the php scripts and the link to the mysql database, I've been through all of the config files I could find and have been searching the internet for some type of answer. I'm new to the mysql and php world, so it's all a struggle right now. Anyone have any ideas? (I'm sure it's a pretty simple fix) Thanks, Tim Czerlinsky Customer Support [EMAIL PROTECTED] ___ TechWorks 4030 West Braker Lane, Suite 350 Austin, Texas 78759-5319 USA 800-688-7466 ___ http://www.techworks.com http://www.techworks.com/ 512-794-8558 FAX Customer Support is available Mon.- Fri. 9:00 AM to 5:30 PM CST 800-933-6113 - 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 - 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
