'database would not accept the connection' error

Next topic

Author	Message
Josh Rader	Friday 11 July 2008 10:51:30 am I'm trying to install ez Publish ver 3.3.4 onto a Windows 2003 machine. I have Apache, PHP and MySQL installed. During the ez Publish install, when I get to the part where you connect to the database, I get an error that says "the database would not accept the connection, please review your settings and try again." The database exists in MySQL and the password is correct. The server name is 'localhost' and the 'Mysql' server is running. Any ideas? Thanks.
Kristof Coomans	Friday 11 July 2008 11:54:13 pm Hi Josh First of all, please note that the eZ Publish 3.3.x series is very old and not supported any more for a very long time. I hope you are just installing it for upgrade purposes and not to start a new site with :) Which version of MySQL are you using? Could be related: http://ez.no/developer/forum/install_configuration/mysql_errors_in_3_10 It's best that you enable the debug output, so warnings, errors and notices are displayed at the bottom of the page for debugging purposes. See http://ez.no/doc/ez_publish/technical_manual/current/reference/configuration_files/site_ini/debugsettings/debugoutput. Also make sure you turn on PHP's display_errors directive and set error_reporting to E_ALL. Good luck! independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Josh Rader	Friday 18 July 2008 10:51:59 am Hey, thanks for the reply. We're running MySQL 4.1. The reason I'm installing 3.3.4 is to practice upgrading eZ Publish to the current version. Does anyone know why I'm getting this error? Also, there is a 'socket' field that I leave blank when I try to connect to the database. It says '(optional)' next to the socket field, so, obviously, I don't need it, but is there something I can put in there that will help me connect? Remember, we're doing this on a Windows 2003 box (not an option to use Linux, sorry). Thanks. Josh

Author

Message

Friday 11 July 2008 10:51:30 am

I'm trying to install ez Publish ver 3.3.4 onto a Windows 2003 machine. I have Apache, PHP and MySQL installed. During the ez Publish install, when I get to the part where you connect to the database, I get an error that says "the database would not accept the connection, please review your settings and try again." The database exists in MySQL and the password is correct. The server name is 'localhost' and the 'Mysql' server is running.

Any ideas? Thanks.

Kristof Coomans

Friday 11 July 2008 11:54:13 pm

Hi Josh

First of all, please note that the eZ Publish 3.3.x series is very old and not supported any more for a very long time. I hope you are just installing it for upgrade purposes and not to start a new site with :)

Which version of MySQL are you using? Could be related: http://ez.no/developer/forum/install_configuration/mysql_errors_in_3_10

It's best that you enable the debug output, so warnings, errors and notices are displayed at the bottom of the page for debugging purposes. See http://ez.no/doc/ez_publish/technical_manual/current/reference/configuration_files/site_ini/debugsettings/debugoutput. Also make sure you turn on PHP's display_errors directive and set error_reporting to E_ALL.

Good luck!

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Josh Rader

Friday 18 July 2008 10:51:59 am

Hey, thanks for the reply.

We're running MySQL 4.1.

The reason I'm installing 3.3.4 is to practice upgrading eZ Publish to the current version.

Does anyone know why I'm getting this error?

Also, there is a 'socket' field that I leave blank when I try to connect to the database. It says '(optional)' next to the socket field, so, obviously, I don't need it, but is there something I can put in there that will help me connect?

Remember, we're doing this on a Windows 2003 box (not an option to use Linux, sorry). Thanks.

Josh

eZ debug

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

Main resources:

Total runtime	0.0137 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0045	588.3828	151.2422
Module start 'layout'	0.0045	0.0028	739.6250	36.7109
Module start 'content'	0.0073	0.0047	776.3359	90.1250
Module end 'content'	0.0121	0.0016	866.4609	33.9922
Script end	0.0136		900.4531

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	17.2321	14	0.0002
Check MTime	0.0010	7.6247	14	0.0001
Mysql Total
Database connection	0.0006	4.3885	1	0.0006
Mysqli_queries	0.0026	19.2045	3	0.0009
Looping result	0.0000	0.0957	1	0.0000
Template Total	0.0013	9.4	1	0.0013
Template load	0.0010	7.4332	1	0.0010
Template processing	0.0003	1.9201	1	0.0003
Override
Cache load	0.0006	4.6148	1	0.0006
General
dbfile	0.0003	2.1098	8	0.0000
String conversion	0.0000	0.0592	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