Forums / Install & configuration / 'database would not accept the connection' error

'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 30 2025 23:41:22

Script start

Timing:

Jan 30 2025 23:41:22

Module start 'content'

Timing:

Jan 30 2025 23:41:22

Module end 'content'

Timing:

Jan 30 2025 23:41:22

Script end

Main resources:

Total runtime

0.1727 sec

Peak memory usage

8,192.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0076	589.6250	370.2656
Module start 'content'	0.0076	0.0145	959.8906	1,001.5313
Module end 'content'	0.0221	0.1505	1,961.4219	3,889.9453
Script end	0.1727		5,851.3672

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0076

589.6250

370.2656

Module start 'content'

0.0076

0.0145

959.8906

1,001.5313

Module end 'content'

0.0221

0.1505

1,961.4219

3,889.9453

Script end

0.1727

5,851.3672

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0041	2.3543	20	0.0002
Check MTime	0.0012	0.7163	20	0.0001
Mysql Total
Database connection	0.0008	0.4527	1	0.0008
Mysqli_queries	0.0828	47.9287	141	0.0006
Looping result	0.0011	0.6264	139	0.0000
Template Total	0.1501	86.9	1	0.1501
Template load	0.0008	0.4596	1	0.0008
Template processing	0.1493	86.4456	1	0.1493
Override
Cache load	0.0005	0.3103	1	0.0005
Sytem overhead
Fetch class attribute can translate value	0.0017	0.9854	1	0.0017
XML
Image XML parsing	0.0003	0.1459	1	0.0003
General
dbfile	0.0069	4.0154	20	0.0003
String conversion	0.0000	0.0030	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0041

2.3543

0.0002

Check MTime

0.0012

0.7163

0.0001

Mysql Total

Database connection

0.0008

0.4527

0.0008

Mysqli_queries

0.0828

47.9287

141

0.0006

Looping result

0.0011

0.6264

139

0.0000

Template Total

0.1501

86.9

0.1501

Template load

0.0008

0.4596

0.0008

Template processing

0.1493

86.4456

0.1493

Override

Cache load

0.0005

0.3103

0.0005

Sytem overhead

Fetch class attribute can translate value

0.0017

0.9854

0.0017

XML

Image XML parsing

0.0003

0.1459

0.0003

General

dbfile

0.0069

4.0154

0.0003

String conversion

0.0000

0.0030

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

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

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/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
	JS	0	extension/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

Cache

Type

Packlevel

SourceFiles

CSS

extension/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

extension/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:

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

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs