Installation problem (Can't connect to the database)

«

Previous topic

|

Install & configuration

|

Next topic

»

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');

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 03:36:27
Script start
Timing:	Jan 31 2025 03:36:27
Module start 'layout'
Timing:	Jan 31 2025 03:36:27
Module start 'content'
Timing:	Jan 31 2025 03:36:27
Module end 'content'
Timing:	Jan 31 2025 03:36:27
Script end

Main resources:

Total runtime	0.0238 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0050	588.3828	151.2422
Module start 'layout'	0.0050	0.0041	739.6250	220.7500
Module start 'content'	0.0091	0.0131	960.3750	1,001.8672
Module end 'content'	0.0222	0.0015	1,962.2422	33.9922
Script end	0.0237		1,996.2344

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	11.2179	14	0.0002
Check MTime	0.0011	4.4320	14	0.0001
Mysql Total
Database connection	0.0007	2.9406	1	0.0007
Mysqli_queries	0.0031	12.9519	3	0.0010
Looping result	0.0000	0.0421	1	0.0000
Template Total	0.0011	4.8	1	0.0011
Template load	0.0009	3.7149	1	0.0009
Template processing	0.0002	1.0220	1	0.0002
Override
Cache load	0.0006	2.6578	1	0.0006
General
dbfile	0.0010	4.2474	8	0.0001
String conversion	0.0000	0.0211	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs