file is encrypted or is not a database

[anonymous]

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?

[stepan@…]

sorry. forgot to add my email.

[Noah Kantrowitz]

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

[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

[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.

[anonymous]

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?