[Trac] Re: file is encrypted or is not a database
2007/10/19, Emmanuel Blot [EMAIL PROTECTED]: Well, this issue is an admin-level issue, not a user-level issue. The admin can read the TracFaq I believe. i can agree with this. i am both user and forced-to-be admin The error is cryptic I agree but that's an error that is raised by the underlying pysqlite Python module, not by Trac itself. Catching the error message and translating it into another error message might end up reporting a falsy error, hidding the real one. i see. * have a well documented (and easy to find) procedure on how to solve the issue, preferably pointed by the above suggested message Yes, the documentation needs to be reworked, but as it is managed as a wiki with public access you're free to help improving it. i'd love to help, but i have no idea on how to start migrating the DB, nor if there is any documentation about that. i checked already several times. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: file is encrypted or is not a database
thanks for your fast replies, guys (of 2 weeks ago). unfortunately i finally had not time to do that, so i had to do my deployment without trac. i would appreciate if you could please provide a link for solving that? i am also worried that if i upgrade trac and the database version i won't be able to access my projects unless i convert them. i don't want to sound complainer and lazy, but to gain widespread use of trac, i think this kind of issue should : * at the very least, warn about it clearlier (instead of the scary file is encrypted use something like trying to access a trac database with a wrong db version. please check this and that or read here * have a well documented (and easy to find) procedure on how to solve the issue, preferably pointed by the above suggested message 2007/10/3, Ulisses Reina Montenegro [EMAIL PROTECTED]: Check out the versions of SQLite Python bindings in both your laptop and production servers how to do that? 2007/10/3, Emmanuel Blot [EMAIL PROTECTED]: Thanks in advance. Search for database is encrypted on trac.edgewall.org (you can restrict the search to the wiki pages, this is a well-documented 'issue' with SQLite v2 vs. v3 mismatch) HTH, Manu --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: file is encrypted or is not a database
i'd love to help, but i have no idea on how to start migrating the DB, nor if there is any documentation about that. i checked already several times. I'm sure it's in the MailingList archive, but perhaps hard to find. You need sqlite (i.e. sqlite command line tool for v2 db) and sqlite3 (i.e. the same for v3 db). # always back up... cp trac.db trac.db.orig # dump the DB (v2) into a portable archive file sqlite trac.db .dump trac.sql # remove the exising DB file rm trac.db # create a new DB (v3) and reload it with the archive file sqlite3 trac.db .read trac.sql HTH, Manu --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: file is encrypted or is not a database
* at the very least, warn about it clearlier (instead of the scary file is encrypted use something like trying to access a trac database with a wrong db version. please check this and that or read here Well, this issue is an admin-level issue, not a user-level issue. The admin can read the TracFaq I believe. The error is cryptic I agree but that's an error that is raised by the underlying pysqlite Python module, not by Trac itself. Catching the error message and translating it into another error message might end up reporting a falsy error, hidding the real one. * have a well documented (and easy to find) procedure on how to solve the issue, preferably pointed by the above suggested message Yes, the documentation needs to be reworked, but as it is managed as a wiki with public access you're free to help improving it. Cheers, Manu --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: file is encrypted or is not a database
great! it worked! it has worked great. i had to do a trac-admin resync, but that was easy. i will see where this fits in the wiki and will try to prepare a page. thanks so much! 2007/10/19, Emmanuel Blot [EMAIL PROTECTED]: i'd love to help, but i have no idea on how to start migrating the DB, nor if there is any documentation about that. i checked already several times. I'm sure it's in the MailingList archive, but perhaps hard to find. You need sqlite (i.e. sqlite command line tool for v2 db) and sqlite3 (i.e. the same for v3 db). # always back up... cp trac.db trac.db.orig # dump the DB (v2) into a portable archive file sqlite trac.db .dump trac.sql # remove the exising DB file rm trac.db # create a new DB (v3) and reload it with the archive file sqlite3 trac.db .read trac.sql HTH, Manu --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: file is encrypted or is not a database
Marc I usually get errors like this when I have mismatched database and SQLite versions. Check out the versions of SQLite Python bindings in both your laptop and production servers. Cheers Ulisses Wed, 2007-10-03 at 19:18 +0200, marc gonzalez-carnicer wrote: hi, I have been working on a trac-managed project for several months. Now it's deployment time, and since corporate policies don't allow for remote access, I have to bring the trac server info to my laptop. I have done a hotcopy, tarred and bzip2'ed, and done the reverse procedure on my laptop. When I try to point to the trac server, I get the error on the subject displayed in the available projects page. Available Projects * 8293: Error (file is encrypted or is not a database) * project foo (project foo was created on the new server using trac-admin initenv) I start tracd like this : tracd -d --auth *,/home/svn/trac/pw.txt,tecsidel \ --env-parent-dir /home/svn/trac --port 3691 It is strange, I had done that (hotcopy and copy) before and it used to work. Could it be that paths on the old and new server are different? I tried recreating the same directory structure but it did not work. Original dir was /home/svn/trac, new is /home/marc/trac. Even if I create the new directory in /home/svn/trac it does not work. Even more strange. If I take the same hotcopy tarfile and I extract it on the old server, it works. The original server uses trac 0.10.3. The new server uses trac 0.10.4. Both have been installed using apt-get with kubuntu. I have googled file is encrypted or is not a database and found and read this link, but it has not been useful to me : http://trac.edgewall.org/ticket/2585. I have tried trac-admin upgrade as is suggested by the previous link with the following negative result : marc[trac]$ trac-admin 8293 upgrade Command failed: file is encrypted or is not a database If I create a project on the new server, I can browse it easily. It would appear on the available projects page. Conclusions : * the hotcopy tarfile is good (can be extracted on old server) * tracd works on both servers (new projects can be browsed) * it is not a firewall problem (can access trac from another pc) * are there any compatibility problems between trac 0.10.3 and 0.10.4? * anything related to pysql? how can i check? Thanks in advance. /marc --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: file is encrypted or is not a database
Thanks in advance. Search for database is encrypted on trac.edgewall.org (you can restrict the search to the wiki pages, this is a well-documented 'issue' with SQLite v2 vs. v3 mismatch) HTH, Manu --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---