Re: Can't open SQLite DB... but only when using mod_php??

Well the directory that houses the database should be writable. Running the script from command line it gives you write access probably but it won't work using mod_php because the web server probably can't write. Try it and give us some feedback. -- Thodoris O/H Chris έγραψε: > Markus Wolff - NorthClick wrote: >> Hey there, >> >> I'm trying to open an SQLite3 database from a PHP very simple PHP >> script: >> >> $db = dirname(__FILE__).'/frontend.db'; >> $pdo = new PDO('sqlite:'.$db); >> $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); >> $pdo->query("SELECT * FROM page LIMIT 1"); >> echo "Deleting pages\n"; $pdo->query("DELETE FROM page"); >> echo "Deleting websites\n"; >> $pdo->query("DELETE FROM website"); >> >> The database file contains no data whatsoever, just the table >> definitions (in case you were wondering, this is a stripped-down version >> of a larger script for debugging purposes, hence the seemingly idiotic >> DELETE statements that won't do any good in an empty database anyway, >> but I digress...). >> >> When executed on the command line, this works perfectly. When I execute >> the same script via Apache and mod_php, I'm getting this exception: >> >> PDOException: SQLSTATE[HY000]: General error: 1 SQL logic error or >> missing database in /home/mwolff/webs/markus/cms/test.php on line 8 >> >> Getting experimental, I've tried to change the calls for the DELETE >> statements from $pdo->query() to $pdo->exec(), just to see what happens. >> Well, what happens is that I'm getting a different error: >> >> PDOException: SQLSTATE[HY000]: General error: 14 unable to open database >> file in /home/mwolff/webs/markus/cms/test.php on line 6 >> >> Argh... what can possibly be wrong here? The script works from the >> commandline, with the exact same PHP version (Debian package, PHP >> 5.2.0-8+etch7, and we also tried upgrading to the latest Debian package >> of 5.2.4, to no avail). >> >> It can't be file permissions, I've even tried to set the database file >> to 777... no change at all. > > My guess is still permissions. If you try a raw fopen instead of using > pdo, what happens? > > <?php > error_reporting(E_ALL); > ini_set('display_errors', true); > $fp = fopen(dirname(__FILE__).'/frontend.db', 'r'); > if ($fp) { > echo "Opened db<br/>\n"; > } else { > echo "Unable to open db<br/>\n"; > } > fclose($fp); > ?> >