[CentOS] Unable to lauch php-script to truncate database

Mon Nov 12 18:38:16 UTC 2012
Johan Vermeulen <jvermeulen at cawdekempen.be>

Dear All,

we have some Nubuilder databases on a Centos6.3 server:

[root at caw-server2 db]# ls /var/www/html/nubuilder/db
reg_begeleidingsteam  reg_jww_archief   reg_personeel     reg_straathoekwerk
reg_bib               reg_jww_dossiers  reg_resident      reg_vrijwilligers
reg_drughulp          reg_jww_dvd       reg_signaleren
reg_jac_activiteit    reg_onthaal       reg_sollicitatie

in each database I have placed a executable file cron.php

-------------------------------------------------------------------------------------------------------------------

<?php

   include "./config.php"; //nuBuilder config file
     $conn = mysql_connect($DBHost, $DBUser, $DBPassword);
     mysql_select_db($DBName,$conn);

     /**************************************************************
     emptying zzsys_trap and zzsys_variable tables
     **************************************************************/
       $sql = "TRUNCATE TABLE zzsys_trap";
       mysql_query($sql);
       $sql = "TRUNCATE TABLE zzsys_variable";
       mysql_query($sql);

     /**************************************************************
     Deleting temp tables
     **************************************************************/
     $result=mysql_query("SHOW TABLES FROM $DBName ") or die(mysql_error());
     if(mysql_num_rows($result)>0)
     {
       while($row=mysql_fetch_row($result))
       {
         if(substr($row[0], 0, 3) === '___' && strrev(substr($row[0], 0, 
3) === '___'))
         {
             $sql = "DROP TABLE $row[0]";
             mysql_query($sql);
         }
       }
     }
?>

------------------------------------------------------------------------------------------------------------------------------

for each file I can easily execute the file cron.php :

[root at caw-server2 reg_bib]# php cron.php

with the desired effect.

*However *when I try to execute the cron.php files from a script :

----------------------------------------------------------------------------------------------------------------------------

#!/bin/bash
for i in `ls /var/www/html/nubuilder/db`
do
php /var/www/html/nubuilder/db/$i/cron.php
done
exit 0

------------------------------------------------------------------------------------------------------------------------------

or just try to execute the script from an absolute path:
[root at caw-server2 jvermeulen]# php 
/var/www/html/nubuilder/db/reg_bib/cron.php
PHP Warning:  include(./config.php): failed to open stream: No such file 
or directory in /var/www/html/nubuilder/db/reg_bib/cron.php on line 3
PHP Warning:  include(): Failed opening './config.php' for inclusion 
(include_path='.:/usr/share/pear:/usr/share/php') in 
/var/www/html/nubuilder/db/reg_bib/cron.php on line 3
PHP Notice:  Undefined variable: DBHost in 
/var/www/html/nubuilder/db/reg_bib/cron.php on line 4
PHP Notice:  Undefined variable: DBUser in 
/var/www/html/nubuilder/db/reg_bib/cron.php on line 4
PHP Notice:  Undefined variable: DBPassword in 
/var/www/html/nubuilder/db/reg_bib/cron.php on line 4

I get a shipload of EM.

I don't understand why this works but not from an absolute path.

Any help would be greatly appreciated.

greetings, J.

-- 
Johan Vermeulen
IT-medewerker
Caw De Kempen
johan.vermeulen at cawdekempen.be


Opensource Software is the future.