[질문] 데비안 etch -> lenny 업그레이드 후 Trac DB 문제..
글쓴이: marunguy / 작성시간: 화, 2009/02/17 - 3:38오후
안녕하세요.
데비안 5.0(lenny) 이 발표되어서 개발서버를 etch 에서 lenny 로 업그레이드 했습니다.
서브버전은 별 말썽없이 동작하는데 Trac 이 말썽이네요.
apache 1.x 에서 apache 2.x 로 바뀌면서 설정이 좀 바뀌어서
아예 trac 에 접속을 못했는데.
삽질끝에 접속은 되게 만들었는데 DB 파일에 문제가 있는듯합니다.
http://192.168.10.193/trac_main 에 접속하면.
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/trac/web/api.py", line 339, in send_error
'text/html')
File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 684, in render_template
data = self.populate_data(req, data)
File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 592, in populate_data
d['chrome'].update(req.chrome)
File "/usr/lib/python2.5/site-packages/trac/web/api.py", line 169, in __getattr__
value = self.callbacks[name](self)
File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 460, in prepare_request
for category, name, text in contributor.get_navigation_items(req):
File "/usr/lib/python2.5/site-packages/trac/ticket/web_ui.py", line 151, in get_navigation_items
if 'TICKET_CREATE' in req.perm:
File "/usr/lib/python2.5/site-packages/trac/perm.py", line 523, in has_permission
return self._has_permission(action, resource)
File "/usr/lib/python2.5/site-packages/trac/perm.py", line 537, in _has_permission
check_permission(action, perm.username, resource, perm)
File "/usr/lib/python2.5/site-packages/trac/perm.py", line 424, in check_permission
perm)
File "/usr/lib/python2.5/site-packages/trac/perm.py", line 282, in check_permission
get_user_permissions(username)
File "/usr/lib/python2.5/site-packages/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/perm.py", line 175, in get_user_permissions
cursor.execute("SELECT username,action FROM permission")
File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute
return self.cursor.execute(sql)
File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 58, in execute
args or [])
File "/usr/lib/python2.5/site-packages/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이런 에러가 발생하고.
trac-admin /var/trac/trac_main upgrade 하면.
pdp:/home/elecguy# trac-admin /var/trac/trac_main/ upgrade
Traceback (most recent call last):
File "/usr/bin/trac-admin", line 8, in <module>
load_entry_point('Trac==0.11.1', 'console_scripts', 'trac-admin')()
File "/usr/lib/python2.5/site-packages/trac/admin/console.py", line 1295, in run
return admin.onecmd(command)
File "/usr/lib/python2.5/site-packages/trac/admin/console.py", line 123, in onecmd
rv = cmd.Cmd.onecmd(self, line) or 0
File "/usr/lib/python2.5/cmd.py", line 219, in onecmd
return func(arg)
File "/usr/lib/python2.5/site-packages/trac/admin/console.py", line 1140, in do_upgrade
if not self.__env.needs_upgrade():
File "/usr/lib/python2.5/site-packages/trac/env.py", line 414, in needs_upgrade
if participant.environment_needs_upgrade(db):
File "/usr/lib/python2.5/site-packages/trac/env.py", line 485, in environment_needs_upgrade
dbver = self.env.get_version(db)
File "/usr/lib/python2.5/site-packages/trac/env.py", line 328, in get_version
(initial and 'initial_' or ''))
File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute
return self.cursor.execute(sql)
File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 58, in execute
args or [])
File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
return function(self, *args, **kwargs)
pysqlite2.dbapi2.DatabaseError: file is encrypted or is not a database이런 에러가 발생합니다.
제 생각엔 sqlite DB 파일 버전이 달라서 생기는 문제인듯 한데
마이그레션 하면 될듯 한데 어떻게 해야하는지요?
아니면 다른 문제일까요?
Forums:
자답입니다. sqlite,
자답입니다.
sqlite, sqlite3 를 설치하고 아래와 같이 하니 되네요.
sqlite OLD.DB .dump | sqlite3 NEW.DB댓글 달기