> > On 19 Nov 2009, at 8:05am, Artur Reilin wrote: > >> My host have sqlite support vor sqlite 2.8.17 and i can use it. But i >> have >> to give chMod 0777 to the directory where i use sqlite. Not only on the >> directory, that contains the sqlite database. let me show it: >> >> /index.php (uses sqlite database) >> /data/data.sqlite (sqlite database) >> >> If i give chMod 0777 to /data/ and the files in this folder, it wouldn't >> work and get me an "malformed database - cannot create temp tables". >> >> I need to gibe chMod to the directory which contains the index.php file. >> That's a big security risk and i don't want to give chMod to the main >> directory. >> >> Is this normal and can i change this? > > You do not actually need 0777. Your problem is that the user which is > creating and using the database is the user that runs Apache, not > yourself. So find out which user Apache runs under. This might be > perhaps www or _www or _apache. Make sure that that user has the rights > over this directory. Then Apache (running the .php script) which have > enough access to use the database file. > > Simon.
The user which runs php (or has the highest rights) is called nobody. The support said me, that i need to set the directory to this user, but it also don't work. I get the same error as before. I can try it again, but the last time it didn't work. I also wondering why my oop version of my script didn't work, but the prozedural one does. They have pdo drivers like mine xampp server, but they don't have the sqlite3 drivers. Perhaps this also happens because of the malformed database error... With best wishes Artur Reilin sqlite.yuedream.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
