Opened 17 years ago

Closed 17 years ago

Last modified 13 years ago

#869 closed defect (fixed)

file is encrypted or is not a database — at Version 7

Reported by: anonymous Owned by: zerodeux
Priority: normal Component: TracReminderScript
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description (last modified by Ryan J Ollos)

Hi,

I just checked out TracReminderScript Revision 1486 and tried to do a test run on the 0.10 installation on tracker.linuxbios.org:

tracreminderscript/0.9/trac-reminder /srv/trac/LinuxBIOS stepan@linuxbios.org stepan@linuxbios.org
Unable to open database "/srv/trac/LinuxBIOS/db/trac.db": file is encrypted or is not a database

It's a normal sqlite database. Any chance to get this script to work with 0.10? Or is it just supposed to support 0.9?

Change History (6)

comment:1 Changed 17 years ago by stepan@…

sorry. forgot to add my email.

comment:2 Changed 17 years ago by Noah Kantrowitz

This means you are using the wrong version of the SQLite bindings.

comment:3 Changed 17 years ago by stepan@…

Thanks for the quick answer!

Which version should I use?

rpm -qa|grep sqlite
sqlite-32bit-3.2.2-5
sqlite-3.2.2-5
sqlite-devel-3.2.2-5
sqlite2-devel-2.8.16-5
sqlite2-32bit-2.8.16-5
sqlite2-2.8.16-5
python-sqlite-1.1.6-2

comment:4 Changed 17 years ago by Noah Kantrowitz

Sounds like the file is probably version 3, and you are using the version 2 program. sqlite is for v2, sqlite3 is for v3.

comment:5 Changed 17 years ago by anonymous

Resolution: fixed
Status: newclosed

Thank you very much. This did the job indeed.

Maybe this should be noted in a README or in the script header. Or could this even be probed? (ie. if sqlite3 is there, trac most likely used that one, so try that first)

Also, the example on the web page did not work for me:

trac-reminder /var/lib/mytrac notify@haxor.com boss@haxor.com 

This produced an error. I had to put a comma in there to make it work...

trac-reminder /var/lib/mytrac notify@haxor.com, boss@haxor.com 

This might be due to using exim here ... Worth a note on the page?

comment:7 Changed 13 years ago by Ryan J Ollos

Description: modified (diff)
Note: See TracTickets for help on using tickets.