Hard to install on virtual web host

Hard to install on virtual web host

Sunday 15 February 2004 8:12:29 am - 5 replies

Author Message

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_

You must be logged in to post messages in this topic!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.