|
Monday 10 January 2005 1:56:24 pm
After spending to much time on the problem I found the cause of the problem and the answer: eZMySQLDB is using the mysql library built into php (with the option '--with-mysql' during the php build. With the release of mysql 4.1 the password hashing algorithm was changed (to improve security..) Older mysql libraries used during the php build process is therefore not able to decrypt passwords stored in mysql with a version number > 4.1
3 solutions exist:
a) get a phpmodule built with an uptodate mysql library (the version of php may vary)
b) change the password in the database such that they are encrypted the old way. This is done with the following command (in a terminal window):
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
(from http://dev.mysql.com/doc/mysql/en/Old_client.html)
c) don't use a password. BUT that is really not an option.
Ez is now running on my laptop with os x 10.3.7
The non verbose install process:
- download a php module with up to date mysql support or do the changes above
to resolve the password issue
- download mysql from mysql.com
- create a user for ez and a database
- set a password for the user !
- unpack the ez tarball in /Library/Webserver
- rename the ezpublish-3.5.0 directory to something shorter/better
restart the webserver from the control panel or use apachectl
start/restart mysql with the command /Library/StartupItems/MySQLCOM/MySQLCOM restart - start the ez installer by pointing your browser to localhost/"shorter/better"
If you did an installation with no mysql password the following can be done to add a password:
- use the set password command above to add a password
- add the passwor to the Password= entry in the file:
/Library/WebServer/Documents/site/settings/siteaccess/plain/site.ini.append.php
(site=your shorter/better name, and plain=the template for the example site)
|