3.2-3 Database Initialization Problems

Author Message

RB RB

Wednesday 12 November 2003 2:38:51 am

I have read the other topics regarding this process and though I have applied the patch I am still getting the same problem where the database would not accept the connection.

I am trying to connect via an account I set-up myself and not via root for security purposes. However, the settings for root are not accepted either. I can access MySQL directly with the accounts I set-up so I can not see why the connections are being rejected. Here are the details:

Type: MYSQL
Servername: localhost
Username: moss
Password: knowledge
Socket:

I am using MySQL: 4.0.16 and eZ publish: 3.2-3 running on Linux.

Any help would be appreciated.

Thanks
RB

James Packham

Wednesday 12 November 2003 4:12:10 am

If I understand your post correctly (It's a little unclear as to what exactly you're trying to do, but I assume your running the setup wizard or something) then you can probably fix it by setting up site.ini by hand.

You want an entry something like:

[DatabaseSettings]
DatabaseImplementation=ezmysql
Server=localhost
Database=[DATABASENAME] (- e.g. 'news')
User=moss
Password=knowledge

Hope that helped, if not elaborate more on your problem.

~James~

RB RB

Wednesday 12 November 2003 5:54:18 am

I apologise for not being more concise earlier. I am trying to run the setup wizard but I can not go further than the Database Initialization step.

I have modified the site.ini file by hand but it does not appear to resolve the problem I am experiencing. The info I added was:

DatabaseImplementation=ezmysql
Server=localhost
User=moss
Password=knowledge
Database=ezptest

Again, I want to setup access via a user account I setup and do not wish to set access via root for security purposes.

Is there anything else that can be done? This is the only problem I have with eZ publish.

Thanks for the response RB

James Packham

Wednesday 12 November 2003 8:15:41 am

Ok, I'd guess there must be something wrong with your database setup. I'd go back and check, see which database I inserted into mysql and that my database name was correct. Also mysql isn't using any funny (other than 3306) ports is it?

Oh one other thing, I just wanted to check: you are aware that your mysql root and your system root are different things right? i.e. you can have a different password for each? I suppose having a different username from root makes it more difficult to guess, which is probably what you're getting at.

~James~

RB RB

Thursday 13 November 2003 3:22:40 am

I went back and done a clean install of MySQL as well as removing the old user accounts and creating new user accounts. The eZ publish wizard accepted the user account I created and it all seems to be working ok now.

Thanks for the help

Jaume Presas

Friday 28 November 2003 5:01:42 pm

I'm stuck in the database initialization step too, I can't go forward, I don't get any error, only the same page asking for the database access information. It's not that the user or password are incorrect, if I put a wrong user or password I get the right error message (The database would not accept the connection, please review your settings and try again.), so that means that the connection is accepted, but it doesn't show me the next step. I've tried with different users, root included, no luck. MySql is working perfectly with the rest of almost 1000 databases/users that are on the server.

Anyone has a clue about how to solve this question?

Thanks.

Jaume Presas

Saturday 29 November 2003 3:33:14 am

Ok, I figured out now that in fact, when submitting the database information, I don't get any page as a response: Mozilla keeps showing the same page (I was trying it with Mozilla first) and Explorer returns its default error page.

Anyway, at the end I've decided to make a manual installation, not succsessful either, but I'm going to comment it in another post.

Below I paste what I get just starting the installation (sorry for quotting such a bunch of text). I hope this information helps the developers to fix the setup wizard.

Warning: eZHTTPTool Nov 29 2003 11:32:09
Undefined post variable: setup_previous_step
Warning: PHP Nov 29 2003 11:32:09
Undefined index: regional_info in /home/virtual/site31/fst/var/www/html/kernel/setup/steps/ezstep_database_init.php on line 233
Error: eZTemplate Nov 29 2003 11:32:09
Unknown template variable 'db_not_empty' in namespace ''
Error: eZTemplate @ design/standard/templates/setup/init/database_init.tpl:109[86] Nov 29 2003 11:32:09
No such attribute for array(11): socket
Choose one of following: type, driver, name, has_demo_data, supports_unicode, server, dbname, user, password, info, table
Error: eZTemplate Nov 29 2003 11:32:09
Unknown template variable 'dont_show_back' in namespace ''
Error: eZTemplate Nov 29 2003 11:32:09
Unknown template variable 'refresh' in namespace ''
Warning: PHP Nov 29 2003 11:32:09
Undefined index: regional_info in /home/virtual/site31/fst/var/www/html/kernel/setup/ezsetup_summary.php on line 104
Warning: PHP Nov 29 2003 11:32:09
Undefined index: site_templates in /home/virtual/site31/fst/var/www/html/kernel/setup/ezsetup_summary.php on line 118
Timing: Nov 29 2003 11:32:09
End
Timing: Nov 29 2003 11:32:09
Module end 'setup'
Timing: Nov 29 2003 11:32:09
End

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 31 2025 04:33:04
Script start
Timing: Jan 31 2025 04:33:04
Module start 'layout'
Timing: Jan 31 2025 04:33:04
Module start 'content'
Timing: Jan 31 2025 04:33:04
Module end 'content'
Timing: Jan 31 2025 04:33:04
Script end

Main resources:

Total runtime0.0151 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0048 588.2578151.2266
Module start 'layout' 0.00490.0023 739.484436.6953
Module start 'content' 0.00710.0063 776.179798.1875
Module end 'content' 0.01340.0017 874.367237.9922
Script end 0.0151  912.3594 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002315.0061140.0002
Check MTime0.00117.1218140.0001
Mysql Total
Database connection0.00085.181110.0008
Mysqli_queries0.002113.684430.0007
Looping result0.00000.072510.0000
Template Total0.00138.410.0013
Template load0.00106.296410.0010
Template processing0.00032.022710.0003
Override
Cache load0.00053.514410.0005
General
dbfile0.001711.019080.0002
String conversion0.00000.053640.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_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