Re: Unable to lauch php-script to truncate database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Mon, 12 Nov 2012, Johan Vermeulen wrote:

> To: CentOS mailing list <centos@xxxxxxxxxx>
> From: Johan Vermeulen <jvermeulen@xxxxxxxxxxxxxx>
> Subject:  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]
-----------------------------------------------------------
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux