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