You really don't want to use SQLite. This is only intended for development,
and will not support a real user base of any size.
If you do use SQLite, the directory containing the database needs to be
writable by www-data.
Christian
--
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com
On Tue, Jan 21, 2014 at 5:55 AM, nav...@launchyard.com wrote:
On upgradin the site like :
rb-site upgrade /home/naveen/venv-review/reviewboard
got the following database error (using sqlite3) :
Updating database. This may take a while.
The log output below, including warnings and errors,
can be ignored unless upgrade fails.
-- begin log output --
Creating tables ...
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)
No evolution required.
--- end log output ---
Resetting in-database caches.
Traceback (most recent call last):
File /home/naveen/venv-review/bin/rb-site, line 9, in module
load_entry_point('ReviewBoard==1.7.21', 'console_scripts', 'rb-site')()
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/ReviewBoard-1.7.21-py2.7.egg/reviewboard/cmdline/rbsite.py,
line 2027, in main
command.run()
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/ReviewBoard-1.7.21-py2.7.egg/reviewboard/cmdline/rbsite.py,
line 1860, in run
site.run_manage_command(fixreviewcounts)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/ReviewBoard-1.7.21-py2.7.egg/reviewboard/cmdline/rbsite.py,
line 562, in run_manage_command
execute_manager(reviewboard.settings, [__file__, cmd] + params)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/core/management/__init__.py,
line 459, in execute_manager
utility.execute()
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/core/management/__init__.py,
line 382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/core/management/base.py,
line 196, in run_from_argv
self.execute(*args, **options.__dict__)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/core/management/base.py,
line 232, in execute
output = self.handle(*args, **options)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/core/management/base.py,
line 371, in handle
return self.handle_noargs(**options)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/ReviewBoard-1.7.21-py2.7.egg/reviewboard/reviews/management/commands/fixreviewcounts.py,
line 16, in handle_noargs
starred_public_request_count=None)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/db/models/manager.py,
line 185, in update
return self.get_query_set().update(*args, **kwargs)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/db/models/query.py,
line 536, in update
rows = query.get_compiler(self.db).execute_sql(None)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/db/models/sql/compiler.py,
line 988, in execute_sql
cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/db/models/sql/compiler.py,
line 818, in execute_sql
cursor.execute(sql, params)
File
/home/naveen/venv-review/local/lib/python2.7/site-packages/Django-1.4.10-py2.7.egg/django/db/backends/sqlite3/base.py,
line 344, in execute
return Database.Cursor.execute(self, query, params)
*django.db.utils.DatabaseError: attempt to write a readonly database*
the sqlite database file has been given access to server (www-data) like :
sudo chown www-data /home/naveen/venv-review/*reviewboard*
/data/reviewboard.db
Does www-data should have read/write access of site , *reviewboard*, if
it is the case ?
--
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups
reviewboard group.
To unsubscribe from this group and stop receiving emails from it, send an
email to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at
