Database initialization not working!

Saturday 20 December 2003 1:03:46 am - 3 replies

3 replies

Author	Message
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.

Author

Message

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.

You must be logged in to post messages in this topic!