[CentOS] Unable to lauch php-script to truncate database
Keith Roberts
keith at karsites.net
Mon Nov 12 20:12:36 UTC 2012
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]
-----------------------------------------------------------
More information about the CentOS
mailing list