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_