RE: [PHP] Problem connecting to MySQL with PEAR::DB and mysqli
Hello, I suspect that all is OK in your code. I had a very similar problem three days ago. Try connecting to FQDN like [EMAIL PROTECTED] via TCP/IP, not to localhost via UNIX socket. It works in my case at least. BTW it seems to be a DB package bug... write a simple test script with mysqli_* functions and look if it will work. And, of course, check MySQL user priviliges/hosts twice! Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 11:47 AM To: php-general@lists.php.net Subject: [PHP] Problem connecting to MySQL with PEAR::DB and mysqli hello when connecting to MySQL 4.1 using PHP 5 and PEAR::DB I get this error: DB Error: connect failed a closer look gets this: Can't connect to local MySQL server through socket 'localhost' (2) the code for the connection is like this:: public static function getConnection() { $mysql_user=myname; $mysql_password=secret; $mysql_host=localhost; $db_name=mydb; $dsn=mysqli://$mysql_user:[EMAIL PROTECTED]/$db_name; echo$dsn; $db=DB::connect($dsn); if(DB::isError($db)){ echo$db-getMessage(); } return$db; } === the DSN looks correct: and in the php.ini I set the following option: mysqli.default_socket = /var/lib/mysql/mysql.sock this is where the socket for mysql access is. then I restarted apache and mysqld. the MySQL Server is running. I can connect via mysql on the command line but not with PEAR::DB. I am using PHP 5, the latest PEAR::DB, Apache 1.3 on a Redhat 7.3 System. any ideas what's wrong here ? Markus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Problem connecting to MySQL with PEAR::DB and mysqli
hello when connecting to MySQL 4.1 using PHP 5 and PEAR::DB I get this error: DB Error: connect failed a closer look gets this: Can't connect to local MySQL server through socket 'localhost' (2) the code for the connection is like this:: public static function getConnection() { $mysql_user = myname; $mysql_password = secret; $mysql_host = localhost; $db_name = mydb; $dsn = mysqli://$mysql_user:[EMAIL PROTECTED]/$db_name; echo $dsn; $db = DB::connect($dsn); if(DB::isError($db)) { echo $db-getMessage(); } return $db; } === the DSN looks correct: and in the php.ini I set the following option: mysqli.default_socket = /var/lib/mysql/mysql.sock this is where the socket for mysql access is. then I restarted apache and mysqld. the MySQL Server is running. I can connect via mysql on the command line but not with PEAR::DB. I am using PHP 5, the latest PEAR::DB, Apache 1.3 on a Redhat 7.3 System. any ideas what's wrong here ? Markus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Problem connecting to MySQL with PEAR::DB and mysqli
[EMAIL PROTECTED] wrote: when connecting to MySQL 4.1 using PHP 5 and PEAR::DB I get this error: DB Error: connect failed a closer look gets this: Can't connect to local MySQL server through socket 'localhost' (2) the code for the connection is like this:: public static function getConnection() { $mysql_user = myname; $mysql_password = secret; $mysql_host = localhost; $db_name = mydb; $dsn = mysqli://$mysql_user:[EMAIL PROTECTED]/$db_name; echo $dsn; $db = DB::connect($dsn); if(DB::isError($db)) { echo $db-getMessage(); } return $db; } === the DSN looks correct: and in the php.ini I set the following option: mysqli.default_socket = /var/lib/mysql/mysql.sock this is where the socket for mysql access is. then I restarted apache and mysqld. the MySQL Server is running. I can connect via mysql on the command line but not with PEAR::DB. I am using PHP 5, the latest PEAR::DB, Apache 1.3 on a Redhat 7.3 System. You could try using ODBC to connect to the DSN, I think, and maybe see if it's the DSN itself that is messed up... Assuming that DSN means the same thing in 'DB' as it does in 'ODBC', which may be a completely invalid assumption on my part... Perhaps try changing 'localhost' to '127.0.0.1' in case your DNS and /etc/hosts are messed up somehow. I suppose you could even try changing localhost to '/var/lib/mysql/mysql.sock' -- not that I think it will work, but it's the kind of desparation thing I always try, and end up learning something from. :-) -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php