Apache Friends Support Forum

Well I do not have root access, like most developers to the unix box and can not install to /opt, so i have to put it where I can

I had that already set in my php.ini

The ping had the same error

If I look at the var/mysql the mysql.sock has --> mysql.sock=

It can't be the /same/ error...

hawk@wsqeai05-> /opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin --socket=/opt/app/wsqeai05c01/atlas/xampp/var/mysql/mysql.sock ping
/opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/app/wsqeai05c01/atlas/xampp/var/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/app/wsqeai05c01/atlas/xampp/var/mysql/mysql.sock' exists!

You can see: The path in the two messages are different


But I don't know why we have this message:


Because:


And you told us the socket exists:


Maybe we have to wait for Oswald...

Maybe I am getting confussed what should the entry be for mysql.sock= ?

Ok I reinstalled xampp and only changed the entries to start apache and I still have the same problem. Just wanted to cleanup in case I made some other changes that might have affected it. So I still get

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

Sorry, don't unterstand.
You told me you have this file:

That's all. And exactly this string you must have in "php.ini" (and maybe config.inc.php)

BTW:
The "=" is just the sign for a socket in a directory listing with ls.
--> man ls

But you remember?

Have you found something?

dir list of var/mysql
drwx------ 2 hawk hawk 512 Feb 18 2004 cdcol/
drwx------ 2 hawk hawk 1536 Nov 27 2005 mysql/
srwxrwxrwx 1 hawk hawk 0 Jul 28 16:36 mysql.sock=
drwx------ 2 hawk hawk 512 Feb 18 2004 test/
-rw-r----- 1 hawk hawk 357 Jan 8 2006 ultra10.err
-rw-rw---- 1 hawk hawk 685 Jul 28 16:36 wsqeai05.err
-rw-rw---- 1 hawk hawk 6 Jul 28 16:36 wsqeai05.pid

The wsqeai05.err has:
060728 16:36:13 mysqld started
060728 16:36:13 [Note] /opt/app/wsqeai05c01/atlas/xampp/sbin/mysqld: ready for connections.
Version: '5.0.18' socket: '/opt/app/wsqeai05c01/atlas/xampp/var/mysql/mysql.sock' port: 3306 Source distribution

in /logs:

erro.log:

[Fri Jul 28 16:36:12 2006] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Fri Jul 28 16:36:12 2006] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Fri Jul 28 16:36:15 2006] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Fri Jul 28 16:36:15 2006] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Fri Jul 28 16:36:15 2006] [notice] Apache/2.2.0 (Unix) PHP/5.1.1 DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a configured -- resuming normal operations



I redid the ping and I get:

hawk@wsqeai05-> /opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin --socket=/opt/app/wsqeai05c01/atlas/xampp/var/mysql/mysql.sock ping
mysqld is alive

No other ideas????

Sorry, I must have overlook this part, the first time I read your anwser...

Ok, MySQL is working

Now open phpinfo() with: http://localhost/xampp/phpinfo.php

There is a section about MySQL. Can you copy 'n paste this section?

I see it is trying to get the mysql.sock from root!

MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.18
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /opt/xampp/var/mysql/mysql.sock
MYSQL_INCLUDE -I/opt/xampp/include/mysql
MYSQL_LIBS -L/opt/xampp/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

These are the configure settings during the build. So it's correct. But:

Why have "mysql.default_socket" no value?

Because:

In php.ini:



In my config.inc.php



????

This is from the "php.ini" that PHP used? See at the beginning of phpinfo().

BTW:
You have restarted Apache after the change?

The php.ini is from -> /opt/app/wsqeai05c01/atlas/xampp/etc/php.ini

Yes I restarted.

I also added the path in mysql.server

# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.

basedir=/opt/app/wsqeai05c01/atlas/xampp
datadir=/opt/app/wsqeai05c01/atlas/xampp/var/mysql

This did not help either