Re: [CentOS] Unable to lauch php-script to truncate database
On Tue, 13 Nov 2012, Johan Vermeulen wrote: *snip* Hello All, Hello Keith, thanks a million for the responses, I'm already happy to understand where the EM are coming from. The config.php are in each database; /[root@caw-server2 db]# ls 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_activiteitreg_onthaal reg_sollicitatie/ so for instance reg_bib ( witch has a library ) has config.php : /[root@caw-server2 reg_bib]# ls background_logo.jpgconfig.php database.php index.php background_stripe.png cron.phpfavicon.ico/ Following your advise, I changed the include enty to : include /var/www/html/nubuilder/db/reg_bib/config.php; this seems to work without EM, I'm now checking if this indeed truncated the files. That's another way to do it - because that should overide the setting in the php.ini file. 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@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Unable to lauch php-script to truncate database
On Mon, 12 Nov 2012, Mark LaPierre wrote: *snip* 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 *snip* Are you changing your active directory to /var/www/html/nubuilder/db in your shell script first? It looks like your shell script is getting a listing of that directory and then trying to execute your PHP script in that directory which is failing because the parent process that called the PHP script is not currently in the directory where the PHP script is trying to find the files it is supposed to be working with. See where it says, failed to open stream: No such file? the other thing to bear in mind are: ; open_basedir, if set, limits all file operations to the defined directory and below. ; This directive makes most sense if used in a per-directory ; or per-virtualhost web server configuration file. ; This directive is *NOT* affected by whether Safe Mode is turned On or Off. ; http://www.php.net/manual/en/ini.sect.safe-mode.php#ini.open-basedir ;open_basedir = http://www.php.net/manual/en/ini.core.php#ini.include-path These two directives work together to limit what files you allow PHP access to. BTW - exactly where is the config.php file located you are trying to include? Kind Regards, 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@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Unable to lauch php-script to truncate database
Op 13-11-12 11:04, Keith Roberts schreef: On Mon, 12 Nov 2012, Mark LaPierre wrote: *snip* 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 *snip* Are you changing your active directory to /var/www/html/nubuilder/db in your shell script first? It looks like your shell script is getting a listing of that directory and then trying to execute your PHP script in that directory which is failing because the parent process that called the PHP script is not currently in the directory where the PHP script is trying to find the files it is supposed to be working with. See where it says, failed to open stream: No such file? the other thing to bear in mind are: ; open_basedir, if set, limits all file operations to the defined directory and below. ; This directive makes most sense if used in a per-directory ; or per-virtualhost web server configuration file. ; This directive is *NOT* affected by whether Safe Mode is turned On or Off. ; http://www.php.net/manual/en/ini.sect.safe-mode.php#ini.open-basedir ;open_basedir = http://www.php.net/manual/en/ini.core.php#ini.include-path These two directives work together to limit what files you allow PHP access to. BTW - exactly where is the config.php file located you are trying to include? Kind Regards, 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@centos.org http://lists.centos.org/mailman/listinfo/centos Hello All, Hello Keith, thanks a million for the responses, I'm already happy to understand where the EM are coming from. The config.php are in each database; /[root@caw-server2 db]# ls 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_activiteitreg_onthaal reg_sollicitatie/ so for instance reg_bib ( witch has a library ) has config.php : /[root@caw-server2 reg_bib]# ls background_logo.jpgconfig.php database.php index.php background_stripe.png cron.phpfavicon.ico/ Following your advise, I changed the include enty to : include /var/www/html/nubuilder/db/reg_bib/config.php; this seems to work without EM, I'm now checking if this indeed truncated the files. again many thanks ! Greetings,J. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[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_activiteitreg_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
/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.
--
Johan Vermeulen
IT-medewerker
Caw De Kempen
johan.vermeu...@cawdekempen.be
Opensource Software is the future.
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Unable to lauch php-script to truncate database
On 11/12/2012 12:38 PM, Johan Vermeulen wrote:
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_activiteitreg_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
/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
signature.asc
Description: OpenPGP digital signature
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Unable to lauch php-script to truncate database
On Mon, 12 Nov 2012, Johan Vermeulen wrote:
To: CentOS mailing list centos@centos.org
From: Johan Vermeulen jvermeu...@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_activiteitreg_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@centos.org
http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Unable to lauch php-script to truncate database
On 11/12/2012 01:38 PM, Johan Vermeulen wrote:
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_activiteitreg_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
/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.
Are you changing your active directory to /var/www/html/nubuilder/db in
your shell script first? It looks like your shell script is getting a
listing of that directory and then trying to execute your PHP script in
that directory which is failing because the parent process that called
the PHP script is not currently in the directory where the PHP script is
trying to find the files it is supposed to be working with. See where
it says, failed to open stream: No such file?
--
_
°v°
/(_)\
^ ^ Mark LaPierre
Registerd Linux user No #267004
https://linuxcounter.net/
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
