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

Reply via email to