On Mon, 12 Nov 2012, Johan Vermeulen wrote: > To: CentOS mailing list <centos at centos.org> > From: Johan Vermeulen <jvermeulen at cawdekempen.be> > Subject: [CentOS] Unable to lauch php-script to truncate database > > 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 Hello Johan. Looks like you are trying to include files outside of your include_path settings as above. To include a php file, it has to be within the paths set in the include_path directive. Try changing your include path to the following: include_path='.:/usr/share/pear:/usr/share/php:/var/www/html/nubuilder/db' see if that does the trick. Keith ----------------------------------------------------------- Websites: http://www.karsites.net http://www.php-debuggers.net http://www.raised-from-the-dead.org.uk All email addresses are challenge-response protected with TMDA [http://tmda.net] -----------------------------------------------------------