[PHP-DB] PHP 5.1.2 with embedded-mysqli
Hi,
I am trying to use php with libmysqld. I manage to compile php on windows
2000 with cygwin because I am used to deal with Unix systems.
I have compiled php using --with-mysqli --enable-embedded-mysqli
--with-xsl options (cgi version). Then I have tried the php examples in
php-src/ext/mysqli/tests/ on a innodb DB that works.
With a binary version of php 5.1.2 (doesn't include libmysqld) I can
access to the DB without problems using this script (table test on
database test is innoDB) :
?php
$link = mysqli_connect(127.0.0.1, root, , test, 3306);
if (mysqli_connect_errno()) {
printf(Echec de la connexion : %s\n, mysqli_connect_error());
exit();
}
$result = mysqli_query($link, SELECT * FROM test);
while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) {
printf (ID: %s Name: %s br /, $row[0], $row[1]);
}
?
But when I try with my own php with mysqli embedded (on the same DB and
mysqld is down) with this script (just tring to connect) :
?php
if (!extension_loaded('mysqli')){
die('skip mysqli extension not available');
}
$driver = new mysqli_driver();
if (!$driver-embedded) {
echo 'Mysqli embedded disabled';
} else {
$path = /cygdrive/c/Program Files/EasyPHP1-8/mysql/data;
$host = $user = $passwd = NULL;
$args = array(
--datadir=$path,
--innodb_data_home_dir=$path,
--innodb_data_file_path=ibdata1:100M:autoextend,
--innodb_force_recovery=4,
--innodb_log_group_home_dir=/cygdrive/c/Program
Files/EasyPHP1-8/mysql/logs/,
--innodb_log_files_in_group=2,
--innodb_log_archive=1,
--innodb_log_arch_dir=/cygdrive/c/Program
Files/EasyPHP1-8/mysql/logs/,
--innodb_lock_wait_timeout=10,
--log-error=$path/testrun.log
);
$driver-embedded_server_start(TRUE, $args, NULL);
var_dump($driver);
$driver-embedded_server_end();
}
?
I'm getting a seg fault :
$ php test_embedded.php
060405 10:35:26 [Warning] Setting lower_case_table_names=2 because file
system for /cygdrive/c/Program Files/EasyPHP1-8/mysql/data/ is case
insensitive
Segmentation fault (core dumped)
On the log file (testrun.log) I get this error :
InnoDB: Fatal error: cannot read from file. OS error number 17.
InnoDB: Error: tried to read 16384 bytes at offset 0 0.
InnoDB: Was only able to read -1.
I've checked the permissions, everyone has the rights to
write/read/execute all the files (on windows/cygwin)
Both php (compiled and binary version) have the same innodb options...
So what's going on ? Is my own php miss configured ?
Thank you very much.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP 5.1.2 with embedded mysqli on windows
Hi,
I am trying to use php with libmysqld. I manage to compile php on windows 2000
with cygwin because I am used to deal with Unix systems.
I have compiled php using --with-mysqli --enable-embedded-mysqli --with-xsl
options (cgi version). Then I have tried the php examples in
php-src/ext/mysqli/tests/ on a innodb DB that works.
With a binary version of php 5.1.2 (doesn't include libmysqld) I can access to
the DB without problems using this script (table test on database test is
innoDB) :
?php
$link = mysqli_connect(127.0.0.1, root, , test, 3306);
if (mysqli_connect_errno()) {
printf(Echec de la connexion : %s\n, mysqli_connect_error());
exit();
}
$result = mysqli_query($link, SELECT * FROM test);
while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) {
printf (ID: %s Name: %s br /, $row[0], $row[1]);
}
?
But when I try with my own php with mysqli embedded (on the same DB and mysqld
is down) with this script (just tring to connect) :
?php
if (!extension_loaded('mysqli')){
die('skip mysqli extension not available');
}
$driver = new mysqli_driver();
if (!$driver-embedded) {
echo 'Mysqli embedded disabled';
} else {
$path = /cygdrive/c/Program Files/EasyPHP1-8/mysql/data;
$host = $user = $passwd = NULL;
$args = array(
--datadir=$path,
--innodb_data_home_dir=$path,
--innodb_data_file_path=ibdata1:100M:autoextend,
--innodb_force_recovery=4,
--innodb_log_group_home_dir=/cygdrive/c/Program
Files/EasyPHP1-8/mysql/logs/,
--innodb_log_files_in_group=2,
--innodb_log_archive=1,
--innodb_log_arch_dir=/cygdrive/c/Program
Files/EasyPHP1-8/mysql/logs/,
--innodb_lock_wait_timeout=10,
--log-error=$path/testrun.log
);
$driver-embedded_server_start(TRUE, $args, NULL);
var_dump($driver);
$driver-embedded_server_end();
}
?
I'm getting a seg fault :
$ php test_embedded.php
060405 10:35:26 [Warning] Setting lower_case_table_names=2 because file system
for /cygdrive/c/Program Files/EasyPHP1-8/mysql/data/ is case
insensitive
Segmentation fault (core dumped)
On the log file (testrun.log) I get this error :
InnoDB: Fatal error: cannot read from file. OS error number 17.
InnoDB: Error: tried to read 16384 bytes at offset 0 0.
InnoDB: Was only able to read -1.
I've checked the permissions, everyone has the rights to write/read/execute all
the files (on windows/cygwin)
Both php (compiled and binary version) have the same innodb options...
So what's going on ? Is my own php miss configured ?
Thank you very much.
--
Jean-Philippe Braun
http://patapon.info
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
