Forums / Install & configuration / Installation problem (Can't connect to the database)

Installation problem (Can't connect to the database)

Author Message

Tomas Engström

Tuesday 04 December 2007 3:23:28 am

Hey m8

i have some installation problems... running ezpublish-3.10.0-gpl.zip

ran the installation and it stopped when i filled out the information for the database connection...

i am currently running PHP Version 4.4.7 on IIS and mysql 5.0 on my home computer

i gave the installation the root access, but no result and i created a new database for root and granted full access ...

[ grant all on ezpublish.* to root@localhost identified by 'password'; ]

i created a new user for the database server (global) and with full access and gave the installation the connection information, but it keeps saying:

"The database would not accept the connection, please review your settings and try again. "

so i figured maybe the windows firewall is blocking so i gave it tcp access (manually), but no result...

so here i am ;) anyone got any tips?

or maybe someone can tell me which file i can hack so i can do a work-around in the .php file myself..... so i can post the error here so you can update the "bug" in the CMS.....

/thx

Paul Leclercq

Tuesday 04 December 2007 3:33:59 pm

Hello,

I would recommend you try creating a simple php script on your server before installing ezpublish

try this:

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Impossible de se connecter : " . mysql_error());
echo 'my connection worked';
mysql_close($link);
?>

You will need to make sure you MySQL server is properly runny and interfaced with your server before trying to install ezPublish, maybe installing MySQL query browser or phpmyadmin would help:
http://www.mysql.com/products/tools/query-browser/

I would also recommend using apache, if you can. Since this is the standard for php applications and you would probably get more active support for this type of configuration.

Mark Marsiglio

Tuesday 04 December 2007 5:53:35 pm

you also might try root@127.0.0.1 instead of localhost. If that works it might point you to a problem with the mysql.sock.

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

Tomas Engström

Wednesday 05 December 2007 12:49:22 pm

aa ye thx guys i will try the ip address instead of the name service ;)

and im not sure but i dont think the webserver has anything to do with the
connection problem, i think it is the mysql service...

but anyways thx a lot guys

:D

Fátima Chapri

Monday 10 December 2007 2:07:29 pm

Hi,

I had the same problem and used the following:

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

eZ debug

Timing: Jan 18 2025 15:10:16
Script start
Timing: Jan 18 2025 15:10:16
Module start 'content'
Timing: Jan 18 2025 15:10:17
Module end 'content'
Timing: Jan 18 2025 15:10:17
Script end

Main resources:

Total runtime0.7863 sec
Peak memory usage4,096.0000 KB
Database Queries204

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0049 587.9609180.8047
Module start 'content' 0.00490.6926 768.7656638.4453
Module end 'content' 0.69750.0888 1,407.2109337.0625
Script end 0.7863  1,744.2734 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00370.4756210.0002
Check MTime0.00140.1814210.0001
Mysql Total
Database connection0.00060.073010.0006
Mysqli_queries0.725592.26812040.0036
Looping result0.00130.16042020.0000
Template Total0.763697.120.3818
Template load0.00220.277720.0011
Template processing0.761496.828920.3807
Template load and register function0.00010.011810.0001
states
state_id_array0.00080.097910.0008
state_identifier_array0.00120.153920.0006
Override
Cache load0.00190.2399420.0000
Sytem overhead
Fetch class attribute can translate value0.00090.112950.0002
Fetch class attribute name0.00070.088170.0001
XML
Image XML parsing0.00120.146550.0002
class_abstraction
Instantiating content class attribute0.00000.001270.0000
General
dbfile0.00350.4395310.0001
String conversion0.00000.000530.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
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 20
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs