trac-admin upgrade from 0.9.6 to 0.11.3 fails

[marco.weber@…]

My Server is a Ubuntu Linux 8.04. I've installed trac 0.11 with easy_install.
Newly created trac environments do work.
But my old trac environments ( from a 0.9.6 Trac ) don't work with trac 0.11, because i cannot upgrade. :(

When i try to do an upgrade i get the following error on the shell:

root@xyz:~# trac-admin /trac-projects/myOldTracProject upgrade

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/api.py", line 367, in send_error
    'text/html')
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/chrome.py", line 708, in render_template
    data = self.populate_data(req, data)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/chrome.py", line 618, in populate_data
    d['chrome'].update(req.chrome)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/api.py", line 194, in __getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/web/chrome.py", line 476, in prepare_request
    for category, name, text in contributor.get_navigation_items(req):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/ticket/web_ui.py", line 163, in get_navigation_items
    if 'TICKET_CREATE' in req.perm:
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 524, in has_permission
    return self._has_permission(action, resource)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 538, in _has_permission
    check_permission(action, perm.username, resource, perm)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 425, in check_permission
    perm)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 282, in check_permission
    get_user_permissions(username)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 357, in get_user_permissions
    for perm in self.store.get_user_permissions(username):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/perm.py", line 175, in get_user_permissions
    cursor.execute("SELECT username,action FROM permission")
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/Trac-0.11.3-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
DatabaseError: file is encrypted or is not a database

[Emmanuel Blot]

Two reasons to close this ticket as invalid:

1. This is an installation issue, so re-read NewTicketGuidelines
2. This is a frequent duplicate, and searching for the error would have given you a long list of duplicates

Finally, check out PySqlite#DatabaseError:fileisencryptedorisnotadatabase

[anonymous]

In my opinion, the trac-admin upgrade tool should be capable of upgrading 0.9.x environments to 0.11.x ( currently it does just display an error message ) …

However, i would be glad, to get a bit help on how to proceed. The links you've provided me didn't help. I'm still unable to upgrade my old trac environments.

This link didn't help me ​http://trac.edgewall.org/wiki/0.10/TracUpgrade.

Please help meee with better links ;)

[Christian Boos]

You'll first need to convert your SQLite 2 database to a SQLite 3 database, as explained in details in 0.10/TracUpgrade.