Any trick to force the assistant to accept an existing database ?

Monday 17 November 2003 11:43:06 am

Hello,

I tried EzPublish 3.2-3 at home, on the standard version of easy Php (that is on windows). It works perfectly well. Now I'm trying to install it on my host server (on Linux)... and headache.

I do need the assistant. I can not perform the command line steps of the manual installation, since my access to the host server is limited to FTP.

But the assistant stops at the MySQL form. It rejects me, with : "The selected selected user has not got access to any databases".

Indeed, the User name I give HAS access to ONE database. I can check it easily through PhpMyAdmin, and even use it with other PHP programs.

I feel the informations I give to the the EzPublish assistant are OK : server name, MySQL User, and Passwd. Note that if I try to modify them, the answer becomes : "The database would not accept the connection, please review your settings and try again".

It seems that the assistant attempts to CREATE a new database.

The hosting company allows me to create or drop databases, one by one, through a management board, but NOT through MySQL requests.
The hosting company creates artificially a "User" and a "Password" for each database. It grants rghts to this User, only for this Database. Hence, the same User is not allowed to create a new database.

I triend to insist by overriding the site.ini, setu.ini, and so on. Same error message, no matter what.

Well, I need to force the assistant of EzPublish3 to accept an existing database.

Anybody knows how to achieve that ? Thank you in advance

Gab

Monday 17 November 2003 6:46:47 pm

I found a way to do so... but after wizard completion, It ends up with error Kernel 20.

Thank you to check upper message in the forum. Give me a clue before I drop frozen !!!

Tuesday 02 March 2004 12:00:32 am

Hi

The problem is probably that your hosting provider does not allow listing of databases in MySQL using 'show tables'. This command is being run to check connection, and list databases later in the installation.

This seems to be a somewhat widespread problem, so we'll try to fix it in the next 3.3 release and future 3.4 releases.

In the current 3.3-3 version there is no othersolution than manualy editing :
lib/classes/ezdb/ezmysldb.php
set eZMySQLDB::availableDatabases() to always return false.

--
Kåre Høvik

Kåre Høvik

Thursday 04 March 2004 1:08:37 pm

changed the code in the 3.3.3 and still no luck still getting

The selected selected user has not got access to any databases. Change user or create a database for the user.
i can login to phpmyadmin just fine so i know i have the access

if you want to use the url and hosting as a test bed lets do it i just need to get this working

Monday 15 March 2004 3:14:32 am

Hi

Before I commit this patch, could some with the problem please try to see if this fixes anything.

--- 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);

Thanks for the help.

--
Kåre Høvik

Kåre Høvik

Tuesday 16 March 2004 5:50:34 am

Hi

try to replace the function availableDatabases() with this :

    function availableDatabases()
    {
        $databaseArray = mysql_list_dbs( $this->DBConnection );

        if ( $this->errorNumber() != 0 )
        {
            return null;
        }

        $databases = array();
        $i = 0;
        $numRows = mysql_num_rows( $databaseArray );
        if ( count( $numRows ) == 0 )
        {
            return false;
        }

        while ( $i < $numRows )
        {
            $databases[] = mysql_db_name($databaseArray, $i);
            ++$i;
        }
        return $databases;
    }

in lib/ezdb/classes/ezmysqldb.php

If does not work try this :

    function availableDatabases()
    {
        return false;
    }

Please let me know what works/does not work

--
Kåre Høvik

Kåre Høvik

Tuesday 23 March 2004 6:55:54 pm

Hi
I have just experienced similar problems. I couldn't create multiple sites (templates?) when installing and kept sending me back to the db initialization box. In the end I simply proceeded with the 'plain' template, but when I tried to acess both admin and user pages I got a:

kernel (50)
* No database connection could be made, the system might not behave properly.

Don't really know what to do, I spent a long time ftp-ing the files over a dialup modem, and I don't really want to go through re-writing scripts because I don't know much about how to do so.

Cheers,
Daniel

Also:
The user and admin pages come up as my_site/ezP-folder/index.php which is not secure? I did ftp the .htaccess file asd instructed but with no joy