On 11/12/2012 12:38 PM, Johan Vermeulen wrote: > 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. > include "./config.php"; <==that is only working from within the correct directory -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 262 bytes Desc: OpenPGP digital signature URL: <http://lists.centos.org/pipermail/centos/attachments/20121112/755e8c9f/attachment-0004.sig>