Home › Forums › OS X Server and Client Discussion › Web › Mambo, MySQL and Apache – Mambo broken for Tiger?
- This topic has 6 replies, 3 voices, and was last updated 19 years, 8 months ago by
ElgertS.
-
AuthorPosts
-
May 18, 2005 at 6:16 pm #361716jnennemannParticipant
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
May 30, 2005 at 8:27 am #361827[email protected]ParticipantI´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.
May 30, 2005 at 8:50 am #361828[email protected]ParticipantEdit: 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.
July 5, 2005 at 8:50 pm #362222jnennemannParticipantHere 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]
July 6, 2005 at 4:05 am #362231jnennemannParticipantI 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_passwordsEverything is now well.
July 28, 2005 at 1:22 am #362545ElgertSParticipantYou 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
August 8, 2005 at 11:46 am #362710ElgertSParticipantAn 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”.
-
AuthorPosts
- You must be logged in to reply to this topic.
Comments are closed