Dear All,
we have some Nubuilder databases on a Centos6.3 server:
[root@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@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@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(a)cawdekempen.be
Opensource Software is the future.