Forums / Install & configuration / Database initialization not working!

Database initialization not working!

Author Message

Felix Mic

Saturday 20 December 2003 1:03:46 am

Hi,
In peformed a bundled installation on a RH9 workstation but when I try to initialize the database in the setup wizard no matter what I enter as servername, username and password I get back the message: " The database would not accept the connection, please review your settings and try again."

What could be wrong with the database??

Thanks for your time!

Mark Marsiglio

Sunday 21 December 2003 6:50:22 pm

Are you connecting to a local MySQL database? If it is on a different machine, a user permission has to be created to allow a remote user to connect.

Can you connect to the database using any other method? Command line or some GUI interface for it? Make sure it is running...

http://www.thinkcreative.com
Turning Ideas Into Strategic Solutions

Felix Mic

Sunday 21 December 2003 11:37:52 pm

Mark, thanks for taking your time to answer me!
- I am trying to connect to a local MySQL, the one shipped with the EZ package;

As root I switched to /opt/ezpublish/mysql-3.23.58 and tried to do a "Post-installation Setup and Testing" according to the manual, to see if MySQL is up and running:

http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Post-installation

When I do
$ cd mysql_installation_directory
$ ./scripts/mysql_install_db
S ./bin/mysqld_safe --user=mysql &

I get: No such file or directory

If I do [root@xxxx mysql-3.23.58]# bin/safe_mysqld
i get " A mysqld process aleardy exist".

There must be something wrong with the database setup but I have no ideea! The database is installed but not properly configured and I am not very sure that I can locate the problem! I will try to install a new database and link it to EZPublish. If you have any ideea about what is the problem please let me know! Meanwhile I keep my eyes on the handbook although I never set up a database before!!

Regards, Felix

Clive Amos

Sunday 28 December 2003 1:25:56 pm

Felix,
It looks to me as though you are trying to connect to mySQL as user = mysql when it doesn't work and user = root when it does work. You probably need to create a mysql user in the mysql DB that has all privileges except grant which should be reserved for the root user. Your EZpub config should then be set to user = mysql. If you still have problems you may need to create a mysql user account in your OS with read/write permission for the mysql/data dir. Although I'm not certain the latter is necessary, I did this on my W2K server and have experienced no DB connection problems with any CMS applications.