Page 1 of 1

All BUT MySql runs...why?

PostPosted: 16. August 2007 05:45
by truth_seeker
Hi, I just installled XAMPP, but when I start it, there is no connection to the MYSQL.The XAMPP status looks as given below.

Common Gateway Interface (CGI) ACTIVATED
Server Side Includes (SSI) ACTIVATED
PHP extension »eAccelerator« DEACTIVATED see FAQ
PHP extension »OCI8/Oracle« DEACTIVATED see FAQ

How do I resolve this? Please note that before xampp,I had already installed php,mysql and apache, and because php could not connect to the MYSQL I installed XAMPP.Also, when I start the xampp, it says that some mysql agent is already running.Is there a conflict? What should I do to resolve this?

PostPosted: 16. August 2007 14:08
by Wiedmann
but when I start it,

How did you do this?

PostPosted: 16. August 2007 15:11
by truth_seeker
Like this:
sudo /opt/lampp/lampp start

PostPosted: 16. August 2007 15:17
by truth_seeker
I work in Ubuntu btw.

PostPosted: 16. August 2007 15:23
by Wiedmann
Did you see anything in the logfiles?

PostPosted: 16. August 2007 15:26
by truth_seeker
What should I look for in the logfiles? Where are they probably located?

PostPosted: 16. August 2007 15:55
by truth_seeker
This is what I saw in error_log file:

[Thu Aug 16 12:51:07 2007] [notice] Digest: generating secret for digest authentication ...
[Thu Aug 16 12:51:07 2007] [notice] Digest: done
[Thu Aug 16 12:51:08 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Aug 16 12:51:08 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Thu Aug 16 12:51:08 2007] [notice] Apache/2.2.2 (Unix) DAV/2 mod_ssl/2.2.2 OpenSSL/0.9.8b PHP/5.1.4 mod_apreq2-20051231/2.5.7 mod_perl/2.0.2 Perl/v5.8.7 configured -- resuming normal operations
[Thu Aug 16 12:59:08 2007] [notice] caught

PostPosted: 17. August 2007 10:33
by flippi
I have exactly the same problem; xampp has been installed yesterday. Everything went well. Today mysql doesn't want start. Or it is started but there is the message 'MySQL database DEACTIVATED

When i try to log in on the phpmyadmin page i get this:

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

same error message in the logfile as 'truth_seeker'

The things i have done yesterday is running this security command 'lampp security' and filling in some passwords.
Afterwards i imported a Joomla database and everything was working fine. For one day.

Is it possible that i changed some settings that should bot have been changed?

PostPosted: 23. August 2007 15:12
by skuipers
Please see this thread - it might help you as well.

PostPosted: 24. August 2007 02:11
by truth_seeker
Thanks. I am not using xampp now. I just connected PHP directly to MYSQL.Also, I think xampp is not so useful for big projects.