Forums / Install & configuration / 3.2-3 Database Initialization Problems

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

eZ debug

Timing: Jan 18 2025 16:01:13
Script start
Timing: Jan 18 2025 16:01:13
Module start 'content'
Timing: Jan 18 2025 16:01:14
Module end 'content'
Timing: Jan 18 2025 16:01:14
Script end

Main resources:

Total runtime0.9332 sec
Peak memory usage4,096.0000 KB
Database Queries208

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0099 588.9844180.8203
Module start 'content' 0.00990.7918 769.8047600.9375
Module end 'content' 0.80170.1314 1,370.7422341.0625
Script end 0.9332  1,711.8047 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00420.4505210.0002
Check MTime0.00170.1868210.0001
Mysql Total
Database connection0.00310.328710.0031
Mysqli_queries0.840990.10852080.0040
Looping result0.00300.32372060.0000
Template Total0.892795.720.4464
Template load0.00230.244420.0011
Template processing0.890495.413120.4452
Template load and register function0.00020.020710.0002
states
state_id_array0.00170.178510.0017
state_identifier_array0.00120.129420.0006
Override
Cache load0.00210.2199760.0000
Sytem overhead
Fetch class attribute can translate value0.00160.168540.0004
Fetch class attribute name0.00150.165680.0002
XML
Image XML parsing0.00110.122040.0003
class_abstraction
Instantiating content class attribute0.00000.002190.0000
General
dbfile0.00490.5231270.0002
String conversion0.00000.000630.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
7content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
12content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 28
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs