On Mon, 12 Nov 2012, Johan Vermeulen wrote:
To: CentOS mailing list centos@centos.org From: Johan Vermeulen jvermeulen@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@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
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] -----------------------------------------------------------