Forums / Install & configuration / Hard to install on virtual web host

Hard to install on virtual web host

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

ma zi

Sunday 15 February 2004 8:12:29 am

On many virtual web hosts,I can't use username and passwor to chose my database,I can only use username,password and database name to connect it.How can I install the ezpublish?

Jan Borsodi

Tuesday 02 March 2004 7:30:39 am

Do you mean you can only connect to a specific database on the database server?

What kind of database server are you connecting to (MySQL or PostgreSQL)?

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

ma zi

Wednesday 10 March 2004 3:03:31 am

Yes.
Mysql

Joakim Stai

Tuesday 16 March 2004 3:43:56 am

I think I have the same problem.
When I enter the username and password for my mySQL account on my webhost's server and press Next in the Setup wizard I get this error:

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

But when I attempt to log into the database in my own php script, it works perfectly.. with same username and password. Does eZ publish require some special database priveleges to be able to work? Please help..

See for yourself..
http://www.haugetun.fhs.no/ezpublish/index.php
Username: haugetunfhsno
Password: publish (temporary password for mySQL only)

Kåre Køhler Høvik

Tuesday 16 March 2004 3:58:42 am

Could you please try this patch, and tell us if it works.

--- lib/ezdb/classes/ezmysqldb.php      (revision 5508)
+++ lib/ezdb/classes/ezmysqldb.php      (working copy)
@@ -624,6 +624,11 @@
         $databases = array();
         $i = 0;
         $numRows = mysql_num_rows( $databaseArray );
+        if ( count( $numRows ) == 0 )
+        {
+            return false;
+        }
+
         while ( $i < $numRows )
         {
             $databases[] = mysql_db_name($databaseArray, $i);

( insert the lines after + into lib/ezdb/classes/ezmysqldb.php at line ca 627 )

--
Kåre Høvik

Kåre Høvik

Joakim Stai

Tuesday 16 March 2004 5:33:41 am

I tried your patch, and it didn't work on eZp 3.3-1. See my last post here:
http://www.ez.no/community/forum/install_configuration/any_trick_to_force_the_assistant_to_accept_an_existing_database_

eZ debug

Timing: Jan 19 2025 00:12:00
Script start
Timing: Jan 19 2025 00:12:00
Module start 'content'
Timing: Jan 19 2025 00:12:01
Module end 'content'
Timing: Jan 19 2025 00:12:01
Script end

Main resources:

Total runtime0.9088 sec
Peak memory usage4,096.0000 KB
Database Queries71

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0073 587.8359180.8203
Module start 'content' 0.00730.8975 768.6563645.8125
Module end 'content' 0.90480.0039 1,414.468846.0859
Script end 0.9087  1,460.5547 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00290.3173140.0002
Check MTime0.00120.1311140.0001
Mysql Total
Database connection0.00090.103310.0009
Mysqli_queries0.850393.5609710.0120
Looping result0.00080.0869690.0000
Template Total0.864095.120.4320
Template load0.00230.253820.0012
Template processing0.861794.817020.4308
Template load and register function0.00030.034410.0003
states
state_id_array0.00260.289510.0026
state_identifier_array0.01121.234120.0056
Override
Cache load0.00190.2078300.0001
Sytem overhead
Fetch class attribute can translate value0.00110.122740.0003
Fetch class attribute name0.00150.170180.0002
XML
Image XML parsing0.00130.141740.0003
class_abstraction
Instantiating content class attribute0.00000.001880.0000
General
dbfile0.00120.1300240.0000
String conversion0.00000.000730.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
6content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
9content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 25
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs