MySQL root pw change, reinstall, and still it doesn't work..

Irgendwelche Probleme mit XAMPP für Mac OS X? Dann ist hier genau der richtige Ort um nachzufragen.

MySQL root pw change, reinstall, and still it doesn't work..

Postby akisma » 17. December 2007 02:18

OS X Leopard, most recent XAMPP build.

I had everything working just fine with XAMPP and its components for about a year until I decided to fix that little security issue of not having a root password. After I added a root password, phpMyAdmin and MySQL both complained about not logging in properly, or having connections rejected, and sent me searching the message boards here for an answer. I found one; or so I thought: change the config files to reflect the new password. Duh.

Except it didn't work.

I reinstalled XAMPP, and things are better without the root password being set (other than for this computer), but I'm still having no luck with PhpMyAdmin. Here's the error message generated by visiting localhost/phpMyAdmin, and following that, the error from the error_log.

phpMyAdmin - Error

Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

[Sun Dec 16 19:54:49 2007] [notice] caught SIGTERM, shutting down
[Sun Dec 16 19:54:53 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sun Dec 16 19:54:53 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Sun Dec 16 19:54:53 2007] [notice] suEXEC mechanism enabled (wrapper: /Applications/xampp/xamppfiles/bin/suexec)
[Sun Dec 16 19:54:54 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sun Dec 16 19:54:54 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Sun Dec 16 19:54:54 2007] [notice] Digest: generating secret for digest authentication ...
[Sun Dec 16 19:54:54 2007] [notice] Digest: done
[Sun Dec 16 19:54:54 2007] [notice] Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8e DAV/2 PHP/5.2.4 configured -- resuming normal operations

Can anyone in the world help me? I'm just trying to get my work environment working again so I can catch up on the work I've missed as a result of this. I'm at my wit's end.

Thanks!
akisma
 
Posts: 3
Joined: 17. December 2007 02:11

Postby kleinweby » 17. December 2007 07:03

hello,

uncomment "session.save_path = /tmp" in your php.ini, resart xampp and it should work.

kleinweby
User avatar
kleinweby
AF Moderator
 
Posts: 393
Joined: 03. August 2005 19:52
Location: Magdeburg
Operating System: Mac OS X 10.7

Postby sari42 » 17. December 2007 10:35

Kleinweby wrote:...uncomment "session.save_path = /tmp" in your php.ini,...
if session.save_path is not set php normally uses /tmp by default. Maybe MacOS needs session.save_path = /tmp explicitly? But the folder has to exist and must be writable by the user php runs under.
sari42
 
Posts: 800
Joined: 27. November 2005 18:28

Postby kleinweby » 17. December 2007 16:57

sari42 wrote:
Kleinweby wrote:...uncomment "session.save_path = /tmp" in your php.ini,...
if session.save_path is not set php normally uses /tmp by default. Maybe MacOS needs session.save_path = /tmp explicitly? But the folder has to exist and must be writable by the user php runs under.

Under OSX php use normaly /var or so but these are not writeable on mac os x leopard, so it dosn't work

kleinweby
User avatar
kleinweby
AF Moderator
 
Posts: 393
Joined: 03. August 2005 19:52
Location: Magdeburg
Operating System: Mac OS X 10.7

not quite

Postby akisma » 17. December 2007 18:10

Did the session.save_path = /tmp thing, didn't work. Do I need to modify the read/write properties of that? what would be the path?
akisma
 
Posts: 3
Joined: 17. December 2007 02:11

Postby kleinweby » 17. December 2007 18:12

Do you have restart Apache?

What say the error_log?
User avatar
kleinweby
AF Moderator
 
Posts: 393
Joined: 03. August 2005 19:52
Location: Magdeburg
Operating System: Mac OS X 10.7

Postby akisma » 17. December 2007 18:21

haha, success!

Thanks a million!
akisma
 
Posts: 3
Joined: 17. December 2007 02:11


Return to XAMPP für macOS

Who is online

Users browsing this forum: No registered users and 9 guests