Hello
I'm having a problem with this PHP5 script running under Nginx +
PHP5-FPM and PDO-SQLite3:
=================
<?php
try
{
$dbh = new PDO('sqlite:dummy.sqlite');
$dbh->exec("CREATE TABLE IF NOT EXISTS table (id INTEGER PRIMARY
KEY AUTOINCREMENT, name VARCHAR(255))");
$dbh->exec("INSERT INTO table (name) VALUES ('dummy')");
$dbh = null;
} catch(PDOException $e) {
echo $e->getMessage();
}
?>
=================
The script successfully creates the database file... but it remains
empty, with no error message reported.
FWIW, Nginx spawns child processes (threads?) as www-data, PHP5-FPM
does the same, and the www directory is owned by www-data:
=================
# ps aux | grep -i -e nginx -e php5 | grep -v grep
root nginx: master process /usr/sbin/nginx
www-data nginx: worker process
root /usr/bin/php5-fpm --fpm-config /etc/php5/fpm/php5-fpm.conf
www-data /usr/bin/php5-fpm --fpm-config /etc/php5/fpm/php5-fpm.conf
=================
# ll /var/www/nginx-default/
drwxr-xr-x 6 www-data www-data 4096 2010-07-27 14:24 ./
drwxr-xr-x 3 root root 4096 2010-07-27 13:00 ../
-rw-r--r-- 1 www-data www-data 0 2010-07-27 14:21 dummy.sqlite
-rw-r--r-- 1 www-data www-data 565 2010-07-27 14:24
sqlite3_pdo_test.php
=================
Thank you for any hint.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
