Re: [phpesp-general] Weird refusal to install

[Peter F. <pf...@uc...>]

Franky Van Liedekerke wrote:
> On Wed, 07 Jan 2009 10:23:50 +0000
> Peter Flynn <pf...@uc...> wrote:
> 
>> I'm trying to install phpESP 2.1.2 under RHEL5 with the default
>> Apache 2.2.3 and PHP 5.1.6. I have had an older version of phpESP
>> (1.8) running very successfully elsewhere under Fedora Core 4 for
>> years, so I'll eventually want to import all the old data; but the
>> problem right now is more baffling: installing the database, which
>> went perfectly on the old machine. Procedure was:
>>
>>   1. detar the installation into the web server document root
>>   2. check httpd.conf for .php (added AddType; SetOutputFilter not
>> used) 3. set the ownership of the whole phpESP directory tree to
>> apache 4. edit a phpESP.ini.php to set db_pass, date_format, and
>> emails 5. edit mysql_create.sql password to match the db_pass in [4]
>>   6. execute  mysql -u root -p < mysql_create.sql to set up database
>>   7. log in with Firefox and change phpESP's root password
>>   8. try to install, and I get
>>
>> Installing
>> [ Install FAILED ]
>> [ Initial data entering failed ]
>> [ Version delete FAILED ]
>> [ Version update FAILED ]
>>
>> I've obviously missed something, but what?
> 
> Heh ... seems I missed something in the INSTALL file. Just omit step 5
> and 6 (just create the db, don't enter any data in it). The web based
> install will do the rest. If drop/create tables is not permitted, just
> copy/paste the created sql statements from the web based install in a
> sql file and use that one.

I finally found it. The mysql_create.sql is broken as shipped, as it 
does not allow the phpesp user to create, drop, or alter, so it can 
never install the data. I used the following:

UPDATE db set create_priv='Y',drop_priv='Y',alter_priv='Y'
  where user='phpesp';

UPDATE user set select_priv='Y',insert_priv='Y',update_priv='Y',
  delete_priv='Y',create_priv='Y',drop_priv='Y',alter_priv='Y'
  where user='phpesp';

flush privileges;

///Peter