phpesp-general

[phpesp-general] Weird refusal to install

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

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?

I set DEBUG to true, but the debug screen confirms all the settings 
correctly but doesn't give anything about the actual error (like the 
error return from the call to set_dbschema, which seems to be what 
triggers the "Install FAILED"). Am I missing some vital component of 
PHP? Like an XML parser for /scripts/db/schema.xml? I'm not a MySQL 
person, so most of the stuff in db_update.inc is opaque to me.

I also checked the mysql_populate.sql file (although installation 
doesn't appear to have gotten that far anyway), and it uses DROP and 
CREATE, which are not enabled for the phpesp db user or database in 
mysql_create.sql.

Incidentally, what is
$ESPCONFIG['adodb_pathto_db'] = "/var/www/phpESP/scripts/db/esp.dbm";
for? This is in the config on the old machine as well, and seems to be 
ignored, because that file path doesn't exist (and can't anyway, because 
apache doesn't have write access to /var/www, and in any event it's 
missing the /html/ from the path; but the old system works fine anyway!)

///Peter

Re: [phpesp-general] Weird refusal to install

[Franky V. L. <lie...@te...>]

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 set DEBUG to true, but the debug screen confirms all the settings 
> correctly but doesn't give anything about the actual error (like the 
> error return from the call to set_dbschema, which seems to be what 
> triggers the "Install FAILED"). Am I missing some vital component of 
> PHP? Like an XML parser for /scripts/db/schema.xml? I'm not a MySQL 
> person, so most of the stuff in db_update.inc is opaque to me.
> 
> I also checked the mysql_populate.sql file (although installation 
> doesn't appear to have gotten that far anyway), and it uses DROP and 
> CREATE, which are not enabled for the phpesp db user or database in 
> mysql_create.sql.
> 
> Incidentally, what is
> $ESPCONFIG['adodb_pathto_db'] = "/var/www/phpESP/scripts/db/esp.dbm";
> for? This is in the config on the old machine as well, and seems to
> be ignored, because that file path doesn't exist (and can't anyway,
> because apache doesn't have write access to /var/www, and in any
> event it's missing the /html/ from the path; but the old system works
> fine anyway!)

the dbm file is for when you use sqlite as db driver (never tested it
yet though, but it should work ...)

Franky

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

But that's exactly what I did. I just created the empty db using 
mysql_create.sql (steps 5 and 6). If you omit this, you can't even start.

You seem to be referring to mysql_populate.sql, which should not be run 
by hand, as it should get done through the web install interface.

The problem is that it's not even getting this far: it's gagging on 
whatever it tries to do with schema.xml

> The web based install will do the rest. 

But it doesn't. It gives me the error above.

> 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.

But the web based install tries to do all kinds of stuff with schema.xml 
and that's what's failing.

///Peter

Re: [phpesp-general] Weird refusal to install

[Franky V. L. <lie...@te...>]

On Thu, Jan 8, 2009 at 1:10 PM, Peter Flynn <pf...@uc...> wrote:

> 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).
>>
>
> But that's exactly what I did. I just created the empty db using
> mysql_create.sql (steps 5 and 6). If you omit this, you can't even start.
>
> You seem to be referring to mysql_populate.sql, which should not be run by
> hand, as it should get done through the web install interface.
>
> The problem is that it's not even getting this far: it's gagging on
> whatever it tries to do with schema.xml
>

oops ... sorry, that's what I meant :-) You got it right, and the README is
correct :-)
Since this fails, do you have any logging in apache? You might need to bump
up the php loglevel (in the php.ini file) first.
For comparing, I'll try a fresh install this evening.

Franky

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

Re: [phpesp-general] Weird refusal to install

[Franky V. L. <lie...@te...>]

On Mon, Mar 16, 2009 at 12:51 PM, Peter Flynn <pf...@uc...> wrote:

> Franky Van Liedekerke wrote:
> > On Wed, 07 Jan 2009 10:23:50 +0000
> > Peter Flynn <pf...@uc...> wrote:
> >
>
>
> 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;
>
>
heh ... I never used that script myself on mysql 5 :-)
I'm going to remove that script and change the INSTALL instructions to just
create a mysql user yourself ... much safer and more in line with other
programs.

Franky

Re: [phpesp-general] Weird refusal to install

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

Franky Van Liedekerke wrote:
> 
> 
> On Mon, Mar 16, 2009 at 12:51 PM, Peter Flynn <pf...@uc... 
> <mailto:pf...@uc...>> wrote:
> 
>     Franky Van Liedekerke wrote:
>      > On Wed, 07 Jan 2009 10:23:50 +0000
>      > Peter Flynn <pf...@uc... <mailto:pf...@uc...>> wrote:
>      >
> 
> 
>     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;
> 
> 
> heh ... I never used that script myself on mysql 5 :-)
> I'm going to remove that script and change the INSTALL instructions to 
> just create a mysql user yourself ... much safer and more in line with 
> other programs.

No need to remove it: if you just add the privs needed (actually I think 
only ADD is required) it should be fine as it stands.

///Peter