error with mysql configuration.

Abid Ghufran abidghufran@hotmail.com
Sat, 17 Mar 2001 10:09:32 +0500


Dear All,

I am trying to setup a web based email setup on RedHat Linux 7 platform. I 
am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms 
required for the MySql setup: (I am running the entire setup on my single 
host for test purposes)

1) mysqlclient9-3.23.22-3
2) php-mysql-4.0.3pl1-1
3) mysql-server-3.23.22-6
4) horde-mysql-1.2.4-1rh7
5) mysql-3.23.22-6

Although the required version was 3.23.24 for mysql and mysql-server, these 
are not available at all the three ftp sites within my reach and mentioned 
in the "horde-latest.README": (ftp.horde.org, ftp.sunsite.org.net and 
ftp.sourceforge.net)

Now the problem is as follows:

1) When i try to check the test.php3 i get the following status of the 
installed modules (alongwith other information):
                  IMAP Support: Yes.
                  LDAP Support: No.
                  MySql Support: Yes.
                  PostgreSQL Support: No.

      (I have not yet configured LDAP and PostgreSQL.)

But when i access "Click here to test PHPLIB for Horde" link i get this 
warning:

Warning: Cant connect to local MySql server through socket 
'/var/lib/mysql/mysql.sock' (111) in /var/www/horde-phplib/db_mysql.inc on 
line 73

I checked this code (at line 73) and found mysql_pconnect() thus i assume 
(on the basis of my limited knowledge) that the problem might be with the 
database server connection.

The MySql server is running. File mysql.sock exists. The database for the 
horde-phplib and imp is created. The command "mysql < mysql_create.sql" 
runs. I have the entire setup on a single machine for test purposes (i.e. 
MySql server, Apache Server and etc.). I have yet to run the cinfiguration 
file "setup.php3" on the horde directory of my web site.

When i run "mysqladmin version" in the output i get that the localhost is 
connected via   Unix sock, and when i run "mysqladmin -h `hostname` version 
variables" i get that the localhost is connected via TCP/IP port. I think 
that either the socket or the TCP/PI port should have been used, as given 
with the mysql configuration.

I have given  all the details intentionally to give you an idea of the the 
entire setup.

All kind of thoughts are appreciated and anticipated.

Thank you very much.

Abid Ghufran.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.