Hello everyone,
My problem is that I cannot execute a php script in CLI. This
test script is supposed to connect to mysql and retrieve some simple results
Systeme: OpenBSD 3.9
Packages installed: php5-core-5.2.17,
php5-extensions-5.2.17,
php5-gd-5.2.17, php5-mysql-5.2.17, php5-snmp-5.2.17,
mysql-server-5.1.54p3, mysql-client-5.1.54p0
Preparation
-----------------
mysqld is started like this
# /usr/local/bin/mysqld_safe --user=_mysql
--pid-file=/var/mysql/mysql.pid &
I have configured /etc/my.cnf in my base
system like this
[mysqld]
socket = /var/www/var/run/mysql/mysql.sock
Once mysqld is started I have the mysql.sock created in /var/www/var/run/mysql
# ls /var/www/var/run/mysql/
mysql.sock
I hard linked it to /var/run/mysql/
#
ln /var/www/var/run/mysql/mysql.sock /var/run/mysql/mysql.sock
I have
downloaded adodb5 and placed it in /var/www, then adapted this code for test
purpose
<?php
include('../adodb5/adodb.inc.php');
$conn =
&ADONewConnection('mysql');
$conn->PConnect('localhost','cacti','cactipw','cactidb');
$sql = 'select
hostname,description from host;';
$recordSet = &$conn->Execute($sql);
if
(!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF) {
print $recordSet->fields[0].' '.$recordSet->fields[1].'<BR>';
$recordSet->MoveNext();
}
$recordSet->Close();
$conn->Close();
?>
I also
copied /etc/my.cnf in /var/www/etc but changed the path for the client
[client]
socket = /var/run/mysql/mysql.sock
The tests
-------------
Case 1: The script is ran without any chroot consideration => Works
#
/usr/local/bin/php /var/www/htdocs/adotest.php
127.0.0.1 System1<BR>1.1.1.1
System2<BR>
Case 2: The script is ran through the apache chrooted server
using the url http://localhost/adotest.php => Works
127.0.0.1 System1
1.1.1.1
System2
Case 3: The script is ran in command line and simulates a user
running it in the chroot (/var/www) => Fails
# /usr/sbin/chroot /var/www
/bin/php /htdocs/adotest.php
PHP Fatal error: Call to undefined function
mysql_pconnect() in /adodb5/drivers/adodb-mysql.inc.php on line 383
Fatal
error: Call to undefined function mysql_pconnect() in
/adodb5/drivers/adodb-mysql.inc.php on line 383
Note that: the adotest.php
script was able to include /adodb5/drivers/adodb-mysql.inc.php
I thought
that maybe there is something wrong with connecting to mysql
inside the
chroot so I copied the mysql client inside the chroot
(/var/www) and the
associated dynamic libraries.
But everything worked when I tried to connect
to the database
# /bin/mysql -u cacti -p
Enter password:
Welcome to the MySQL
monitor. Commands end with ; or \g.
Your MySQL connection id is 6
I've
searched for a long time and I have no clue why it's working when the script
is executed by Apache and not working when executed in cli inside chroot
/var/www. Does anyone have an idea on how to solve this ?
If you want to test
just download adodb5 and place it in /var/www
http://sourceforge.net/projects/adodb/files/adodb-php5-only/adodb-514-for-php
5/adodb514.zip/download
Place the php script adotest.php in /var/www/htdocs
Thank you
