Mac OS X Database initialization trouble

Sunday 12 December 2004 3:40:32 pm

I have trouble with my eZ publish setup, it stops at Database initialization.

The error message is:
"The database would not accept the connection, please review your settings and try again."

My setup is like this:

mysql Ver 14.7 Distrib 4.1.7, for apple-darwin7.5.0 (powerpc)
Apache/1.3.28
PHP Version 4.3.2

I have created (several) databases and granted permissions (all). When the wizard tries to connect to the database it just stops with the same error message.

I am not sure if this can have anything to do with the php.ini file, but I have also changed these settings:
max_execution_time = 90 ; Maximum execution time of each script, in seconds
max_input_time = 120 ; Maximum amount of time each script may spend parsing
request data
memory_limit = 32M ; Maximum amount of memory a script may consume (8MB)

I will appreciate any suggestions.

--
Jonas B Holten

Tuesday 21 December 2004 2:59:55 pm

Thanks for the tip, I fixed the problem this way:

I used the tip from this thread:
http://ez.no/community/forum/install_configuration/kernel_50_on_solaris_mysql_4_1_7_ez_3_4_3

--
Open your MySQL configuration file, locate the [mysqld] section and add "old_passwords" on a new line. Restart your MySQL server.
Now open a MySQL console and execute the following to reset the password to the "old" method:
--

The only problem is finding the nonexisting my.cnf file. Google helped me find the answer, I had to make a new file called my.cnf placed in /etc/

I added old_password to a "typical global conf file":
(From http://dev.mysql.com/doc/mysql/en/Option_files.html )

[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=16M
max_allowed_packet=8M
old_password

[mysqldump]
quick

After this I updated mysql:

USE mysql;
UPDATE user SET Password = PASSWORD('<your password>') WHERE User = '<your username>';

Just to be sure I restarted the machine, and like magic, it worked:)

Best regards
Jonas B Holten
(looking forward to a christmas testing ezpublish)

--
Jonas B Holten