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.

eZ debug

Timing: Jan 31 2025 06:26:04
Script start
Timing: Jan 31 2025 06:26:04
Module start 'content'
Timing: Jan 31 2025 06:26:04
Module end 'content'
Timing: Jan 31 2025 06:26:04
Script end

Main resources:

Total runtime0.0142 sec
Peak memory usage2,048.0000 KB
Database Queries4

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 588.2578180.8203
Module start 'content' 0.00580.0042 769.078197.9297
Module end 'content' 0.01000.0042 867.007874.7031
Script end 0.0141  941.7109 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002215.7311120.0002
Check MTime0.00117.4992120.0001
Mysql Total
Database connection0.00085.788210.0008
Mysqli_queries0.002215.584940.0006
Looping result0.00000.127720.0000
Template Total0.003827.010.0038
Template load0.00085.695810.0008
Template processing0.003021.302510.0030
Override
Cache load0.00053.581510.0005
General
dbfile0.00032.3378100.0000
String conversion0.00000.040330.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs