Database initialization problems -

Previous topic

Install & configuration

Next topic

Author	Message
Justin Jeffrey	Tuesday 21 October 2003 6:42:26 am I'm having problems with the instal script. I get the following error after adding my database info: The selected selected user has not got access to any databases. Change user or create a database for the user. The database definately exists and has been accessible to other scripts. I think this may be something to do with the scipt looking for any available databases which I think my server (Donhost FreeBSD) doesn't allow. As a test, I tried to overide the setup.ini and site.ini and ran kernel_schema.sql and cleandata.sql into the databse and tested the site with the instal script turned off (CheckValidity=false) which just resulted in an error.
Kåre Køhler Høvik	Monday 27 October 2003 5:07:09 am Is denying listing of databases a common problem using shared hosting ? To fix your problem you need to enter kernel/setup/steps/<ez_database_init.php, ez_site_details.php> and add the databases you wish to use manually to the $availDatabases variabel. (must be array, containing database names as text elements) Kåre Høvik
ej concept	Wednesday 29 October 2003 11:14:01 am I attempted to follow your directions...but i'm not sure what you mean. Quote- "kernel/setup/steps/<ez_database_init.php, ez_site_details.php> and add the databases you wish to use manually to the $availDatabases variabel. (must be array, containing database names as text elements)" can you show me what it should look like? thanks!

Author

Message

Justin Jeffrey

Tuesday 21 October 2003 6:42:26 am

I'm having problems with the instal script. I get the following error after adding my database info:

The selected selected user has not got access to any databases. Change user or create a database for the user.

The database definately exists and has been accessible to other scripts.

I think this may be something to do with the scipt looking for any available databases which I think my server (Donhost FreeBSD) doesn't allow.

As a test, I tried to overide the setup.ini and site.ini and ran kernel_schema.sql and cleandata.sql into the databse and tested the site with the instal script turned off (CheckValidity=false) which just resulted in an error.

Kåre Køhler Høvik

Monday 27 October 2003 5:07:09 am

Is denying listing of databases a common problem using shared hosting ?

To fix your problem you need to enter kernel/setup/steps/<ez_database_init.php, ez_site_details.php> and add the databases you wish to use manually to the $availDatabases variabel. (must be array, containing database names as text elements)

Kåre Høvik

ej concept

Wednesday 29 October 2003 11:14:01 am

I attempted to follow your directions...but i'm not sure what you mean.

Quote-
"kernel/setup/steps/<ez_database_init.php, ez_site_details.php> and add the databases you wish to use manually to the $availDatabases variabel. (must be array, containing database names as text elements)"

can you show me what it should look like?

thanks!

eZ debug

Timing:	Jan 19 2025 01:18:07
Script start
Timing:	Jan 19 2025 01:18:07
Module start 'layout'
Timing:	Jan 19 2025 01:18:07
Module start 'content'
Timing:	Jan 19 2025 01:18:07
Module end 'content'
Timing:	Jan 19 2025 01:18:07
Script end

Main resources:

Total runtime	0.5358 sec
Peak memory usage	4,096.0000 KB
Database Queries	59

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	590.3984	152.6406
Module start 'layout'	0.0066	0.0031	743.0391	39.4766
Module start 'content'	0.0097	0.5242	782.5156	563.2266
Module end 'content'	0.5339	0.0018	1,345.7422	12.1406
Script end	0.5357		1,357.8828

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.6670	16	0.0002
Check MTime	0.0014	0.2529	16	0.0001
Mysql Total
Database connection	0.0015	0.2735	1	0.0015
Mysqli_queries	0.4861	90.7360	59	0.0082
Looping result	0.0006	0.1134	57	0.0000
Template Total	0.5027	93.8	2	0.2514
Template load	0.0026	0.4782	2	0.0013
Template processing	0.5002	93.3557	2	0.2501
Template load and register function	0.0002	0.0359	1	0.0002
states
state_id_array	0.0012	0.2225	1	0.0012
state_identifier_array	0.0015	0.2731	2	0.0007
Override
Cache load	0.0020	0.3727	18	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.1488	3	0.0003
Fetch class attribute name	0.0010	0.1846	4	0.0002
XML
Image XML parsing	0.0007	0.1275	3	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0016	4	0.0000
General
dbfile	0.0015	0.2834	15	0.0001
String conversion	0.0000	0.0024	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 11 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs