Mambo, MySQL and Apache – Mambo broken for Tiger?

[jnennemann]

I am unable to successfully install Mambo on a new installation of Tiger server. I have followed the instructions; tried it both through the web interface and through the manual install. I have been using Mambo for about 2 years now. This one has me stumped.

The web install gets to the point where you put in the MySQL user, password, database and host information but their is a second javascript warning that the login info is incorrect. At this point I am wondering:

1. What is different with the MySQL database in Tiger? I have heard the password hash has changed. I tried the PASSWORD_OLD command to no avail.

2. Is there a problem with a PHP library that is causing the login problems?

3. Is there a ‘safe-mode’ in Tiger’s Apache server that is preventing proper access?

Any help on this would be greatly appreciated. I am certain that there will be many others who will confront this same problem as they move to Tiger.

-James

[[email protected]]

I´m having the same problem here. I have changed the mysql.socket in the php.ini file according to the apple KB document that you can find here:

http://docs.info.apple.com/article.html?artnum=301457

But it still does not work, i can connect to the database just fine using MySQL amdinistrator but mambo seems to fail. It´s a big issue here since i got lots of client using mambo for their sites.

[[email protected]]

Edit: The PHP issue does of course has nothing to do with MySQL hashing its just one of those settings that needs to change i OS X Server if using PHP and MySQL.

[jnennemann]

Here is a post from the MamboForge forums. I have not tried it yet, but will tonight:

http://forum.mamboserver.com/showthread.php?t=44568

[QUOTE]I am running it after a few minor changes.

1. In your /etc/my.cnf, if you haven’t put “old_passwords” in there,
that will enable it to use the old-style passwords for MySQL 4.1 since Panther was running on 4.0.x it used a different hashing for authentication. I’m not sure if Mambo handles the newer (longer) password formats.

2. You will probably have to change the socket that PHP looks for. Apple has changed the socket for MySQL in Tiger Server so open up the php.ini file and point it at the new location /var/mysql/mysql.sock. (as opposed to /tmp/mysql.sock

3. Your my.cnf file should also reflect the changes to the place mysql
looks for its socket.

Check this discussion out for more help:

http://discussions.info.apple.com/w…[email protected]

After that, things should go smoothly.[/QUOTE]

[jnennemann]

I have tested the fix. All I had to do was add a file ‘my.cnf’ to the /etc directory with the following information:

[mysqld]
socket=/tmp/mysql.sock
old_passwords

Everything is now well.

[ElgertS]

You are a saint for posting this clean and effective solution to a problem that drove me to distraction on Monday. All the other solutions I found and attempted failed miserably. I can’t thank you enough for taking the time to post this.

On a related note, can anyone verify if the MySQL that Apple ships with Tiger is optimized to run faster than the MySQL you can download from mysql.com? Apple claims this to be the case in answer to an article on AMP performance at Anandtech

[ElgertS]

An alternative to this method is to install PHP5 on Tiger Server. Do note, however, that not all AMP software is compatible with PHP5. Some can be made compatible by turning “register_long_arrays=On”.

[Author]

Posts