Database server problem

Author Message

Ted Striker

Friday 30 January 2004 1:47:11 am

Hello there

I'm trying to run eZPublish 3.3 on my server, but I get the following error at the very start:

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

I gues that the problem can be that my server allows me access to a unique database named "db_name_com" running on MySQL Server, and I don't know how to tell eZPublish to access this database, something like:

Host: mysql.host.com
Username: mysql_username
Password: mysqlpassword
Database: mysqldb_name

How can I solve this problem, any idea? Thanx a lot.

Can you feel it Mr. Anderson? Closing in on you? Oh I can, I really should thank you after all. It was, after all, it was your life that taught me the purpose of all life. Purpose of life is to end.

Björn Dieding@xrow.de

Friday 30 January 2004 3:27:39 am

if the db is on the same server use localhost

and check mysql if it allows exeternal connections

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Ted Striker

Friday 30 January 2004 3:37:13 am

Thanx for the answer,

but the MySQL server is not in the same machine, I guess, it works using somthing like "sql.server.com" host name and I have a username that allows me to access a single database (no space or table number restrictions), but eZPublish does not connect. Any ideas? I want to make eZPublish run :)

Thanx again.

Can you feel it Mr. Anderson? Closing in on you? Oh I can, I really should thank you after all. It was, after all, it was your life that taught me the purpose of all life. Purpose of life is to end.

Bård Farstad

Monday 02 February 2004 12:30:30 am

Mabye you need to specify the socket for mysql. Try to do a search for mysql.sock and enter the path for this in the eZ publish socket settings.

--bård

Documentation: http://ez.no/doc

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 19 2025 00:15:46
Script start
Timing: Jan 19 2025 00:15:46
Module start 'layout'
Timing: Jan 19 2025 00:15:46
Module start 'content'
Timing: Jan 19 2025 00:15:47
Module end 'content'
Timing: Jan 19 2025 00:15:47
Script end

Main resources:

Total runtime0.6952 sec
Peak memory usage4,096.0000 KB
Database Queries62

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0053 587.9297152.6250
Module start 'layout' 0.00530.0028 740.554739.4453
Module start 'content' 0.00810.6856 780.0000594.1250
Module end 'content' 0.69370.0015 1,374.125012.1719
Script end 0.6952  1,386.2969 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00320.4607160.0002
Check MTime0.00130.1846160.0001
Mysql Total
Database connection0.00090.123610.0009
Mysqli_queries0.637191.6365620.0103
Looping result0.00070.0953600.0000
Template Total0.663995.520.3319
Template load0.00210.295920.0010
Template processing0.661895.187420.3309
Template load and register function0.00020.024010.0002
states
state_id_array0.00130.184110.0013
state_identifier_array0.00070.102020.0004
Override
Cache load0.00170.2496260.0001
Sytem overhead
Fetch class attribute can translate value0.00060.089630.0002
Fetch class attribute name0.00100.144970.0001
XML
Image XML parsing0.00360.511930.0012
class_abstraction
Instantiating content class attribute0.00000.001980.0000
General
dbfile0.00330.4678290.0001
String conversion0.00000.001440.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
4content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
5content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 16
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs