A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=818 ====================================================================== Reported By: ttessier Assigned To: ====================================================================== Project: DBMail Issue ID: 818 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: new target: ====================================================================== Date Submitted: 04-Dec-09 03:29 CET Last Modified: 04-Dec-09 23:07 CET ====================================================================== Summary: SQLITE database query failing Description: The query interface for sqlite is giving me an sqlite3_get_table failed: ======================================================================
---------------------------------------------------------------------- (0002950) paul (administrator) - 04-Dec-09 09:26 http://www.dbmail.org/mantis/view.php?id=818#c2950 ---------------------------------------------------------------------- The error message indicates a problem with the database file. This is explained by access problems on the directory containing the database file, since sqlite wants to create temporary journal and lock files while updating. ---------------------------------------------------------------------- (0002951) ttessier (reporter) - 04-Dec-09 14:56 http://www.dbmail.org/mantis/view.php?id=818#c2951 ---------------------------------------------------------------------- This is access problems on the directory itself? Let me explain then what I have done so far.. I have created the file, updated the file using the command line client chown'd the file to dbmail:dbmail ( the user and group in dbmail.conf I have set ) placed the path and file as the db parameter in dbmail.conf now I am going to chown dbmail:dbmail the sqlite mail directory - and that should work? ---------------------------------------------------------------------- (0002952) ttessier (reporter) - 04-Dec-09 15:14 http://www.dbmail.org/mantis/view.php?id=818#c2952 ---------------------------------------------------------------------- Ok, so if I am having usermap problems now, I believe this is related to this "bug" which is merely user error correct? As something might have broken inside the users module if the dbmailuser/group was not able to access this properly. Just a thought, but would it be possible to check the user/group/perms of an sqlite installation dir and dbfile on startup and pump out a warning? ---------------------------------------------------------------------- (0002953) ttessier (reporter) - 04-Dec-09 23:07 http://www.dbmail.org/mantis/view.php?id=818#c2953 ---------------------------------------------------------------------- Paul, you can close this, I am opening another ticket regarding something else, or is there a way I can email or chat with you directly regarding something Issue History Date Modified Username Field Change ====================================================================== 04-Dec-09 03:29 ttessier New Issue 04-Dec-09 09:26 paul Note Added: 0002950 04-Dec-09 14:56 ttessier Note Added: 0002951 04-Dec-09 15:14 ttessier Note Added: 0002952 04-Dec-09 23:07 ttessier Note Added: 0002953 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
