I got the same error when I upgraded from SQLite 3.2.8 to SQLite 3.3.4 and PySqlite from 2.0.x to 2.1.3. SQLite wasn't the problem, but rather PySqlite. It was still using the older version of SQLite which was installed in /usr/lib, rather than the newer version in /usr/local/lib. It might be worth looking into.
-Lauren -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Knesek Sent: Wednesday, March 22, 2006 10:08 AM To: [email protected] Subject: Re: [Trac] SQLLite "Error: file is encrypted or is not a database" I'll try it. Thanks. On Mar 22, 2006, at 12:05 PM, Emmanuel Blot wrote: > Trac does not make use of sqlite3 (or sqlite) to access the DB: this > is a CLI tool, for human beings. > Trac uses pysqlite to access (and create) the database, which relies > on sqlite libraries I believe. > > Therefore, you may have libraries for sqlite v2 kind of DB (used by > Trac) and sqlite3 (used by you) on the same machine. > > Try to install sqlite (that is, the v2 tool) on your machine to check > whether you can access you DB from the command line... > > HTH, > Manu > > On 3/22/06, Doug Knesek <[EMAIL PROTECTED]> wrote: >> That's what I thought. But the trac.db file is being created by >> trac- >> admin - and the only version of sqlite I have installed on the >> computer is 3.2.8. >> >> Does trac use some other mechanism to create the database? >> >> On Mar 22, 2006, at 11:49 AM, Emmanuel Blot wrote: >> >>> Search for the terms in the search engine of the Trac site: >>> >>> You probably have a conflict between a Sqlite v2 database that you >>> try to access with the v3 tool. >>> >>> On 3/22/06, Doug Knesek <[EMAIL PROTECTED]> wrote: >>>> Does anyone know why I can't access the database tables created by >>>> Trac. Here is what happens: >>>> >>>> db$ sudo sqlite3 trac.db >>>> SQLite version 3.2.8 >>>> Enter ".help" for instructions >>>> sqlite> .tables >>>> Error: file is encrypted or is not a database >>>> sqlite> >>>> >>>> Thanks, >>>> -Doug >>>> >>>> _______________________________________________ >>>> Trac mailing list >>>> [email protected] >>>> http://lists.edgewall.com/mailman/listinfo/trac >>>> >>> >>> >>> -- >>> Manu >>> _______________________________________________ >>> Trac mailing list >>> [email protected] >>> http://lists.edgewall.com/mailman/listinfo/trac >> >> _______________________________________________ >> Trac mailing list >> [email protected] >> http://lists.edgewall.com/mailman/listinfo/trac >> > > > -- > Manu > _______________________________________________ > Trac mailing list > [email protected] > http://lists.edgewall.com/mailman/listinfo/trac _______________________________________________ Trac mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac _______________________________________________ Trac mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac
