After creating a database named reviewboard and creating a UID called "rbadmin" to have full access to it, I added rights for rbadmin to have full rights to it:
mysql> USE reviewboard; Database changed mysql> GRANT ALL PRIVILEGES ON reviewboard TO 'rbdbuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) Tried to run: rb-site install /var/www/reviewboard ...and got: * Installing the site... Building site directories ... OK Building site configuration files ... OK Creating database ... Creating table django_admin_log Traceback (most recent call last): File "/usr/bin/rb-site", line 9, in <module> load_entry_point('ReviewBoard==1.5.4', 'console_scripts', 'rb- site')() File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ rbsite.py", line 1626, in main command.run() File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ rbsite.py", line 1177, in run self.show_install_status() File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ rbsite.py", line 1436, in show_install_status site.sync_database) File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ rbsite.py", line 703, in step func() File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ rbsite.py", line 339, in sync_database self.run_manage_command("syncdb", params) File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ rbsite.py", line 397, in run_manage_command execute_manager(reviewboard.settings, [__file__, cmd] + params) File "/usr/lib/python2.6/site-packages/django/core/management/ __init__.py", line 438, in execute_manager utility.execute() File "/usr/lib/python2.6/site-packages/django/core/management/ __init__.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/lib/python2.6/site-packages/django/core/management/ base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/usr/lib/python2.6/site-packages/django/core/management/ base.py", line 220, in execute output = self.handle(*args, **options) File "/usr/lib/python2.6/site-packages/django/core/management/ base.py", line 351, in handle return self.handle_noargs(**options) File "/usr/lib/python2.6/site-packages/django/core/management/ commands/syncdb.py", line 99, in handle_noargs cursor.execute(statement) File "/usr/lib/python2.6/site-packages/django/db/backends/mysql/ base.py", line 86, in execute return self.cursor.execute(query, args) File "/usr/lib/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1142, "CREATE command denied to user 'rbdbuser'@'localhost' for table 'django_admin_log'") Thanks for your help. What can I fix to finish this correctly? Where can I go to find more granular instructions for this installation? Once I have this test box working, is there a set of instructions I can find for upgrading it to version 1.5.5? On Apr 13, 12:30 am, Gilles Moris <gilles.mo...@free.fr> wrote: > On Tuesday 12 April 2011 11:29:54 pm Dean wrote: > > > > > On SL6: > > LSB Version: :core-4.0-ia32:core-4.0-noarch:graphics-4.0- > > ia32:graphics-4.0-noarch:printing-4.0-ia32:printing-4.0-noarch > > Distributor ID: Scientific > > Description: Scientific Linux release 6.0 (Carbon) > > Release: 6.0 > > Codename: Carbon > > > I added mysql, mysql-server, httpd. I installed the EPEL epel- > > release-6-5.noarch.rpm. > > Installed Reviewboard. Installed memcached and MySQL-python and then > > used: > > > rb-site install /var/www/reviewboard... > > > and got: > > * Installing the site... > > Building site directories ... OK > > Building site configuration files ... OK > > Creating database ... Traceback (most recent call last): > > File "/usr/bin/rb-site", line 9, in <module> > > load_entry_point('ReviewBoard==1.5.4', 'console_scripts', 'rb- > > site')() > > File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ > > rbsite.py", line 1626, in main > > command.run() > > File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ > > rbsite.py", line 1177, in run > > self.show_install_status() > > File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ > > rbsite.py", line 1436, in show_install_status > > site.sync_database) > > File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ > > rbsite.py", line 703, in step > > func() > > File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ > > rbsite.py", line 339, in sync_database > > self.run_manage_command("syncdb", params) > > File "/usr/lib/python2.6/site-packages/reviewboard/cmdline/ > > rbsite.py", line 397, in run_manage_command > > execute_manager(reviewboard.settings, [__file__, cmd] + params) > > File "/usr/lib/python2.6/site-packages/django/core/management/ > > __init__.py", line 438, in execute_manager > > utility.execute() > > File "/usr/lib/python2.6/site-packages/django/core/management/ > > __init__.py", line 379, in execute > > self.fetch_command(subcommand).run_from_argv(self.argv) > > File "/usr/lib/python2.6/site-packages/django/core/management/ > > base.py", line 191, in run_from_argv > > self.execute(*args, **options.__dict__) > > File "/usr/lib/python2.6/site-packages/django/core/management/ > > base.py", line 219, in execute > > self.validate() > > File "/usr/lib/python2.6/site-packages/django/core/management/ > > base.py", line 249, in validate > > num_errors = get_validation_errors(s, app) > > File "/usr/lib/python2.6/site-packages/django/core/management/ > > validation.py", line 102, in get_validation_errors > > connection.validation.validate_field(e, opts, f) > > File "/usr/lib/python2.6/site-packages/django/db/backends/mysql/ > > validation.py", line 14, in validate_field > > db_version = self.connection.get_server_version() > > File "/usr/lib/python2.6/site-packages/django/db/backends/mysql/ > > base.py", line 313, in get_server_version > > self.cursor() > > File "/usr/lib/python2.6/site-packages/django/db/backends/ > > __init__.py", line 75, in cursor > > cursor = self._cursor() > > File "/usr/lib/python2.6/site-packages/django/db/backends/mysql/ > > base.py", line 297, in _cursor > > self.connection = Database.connect(**kwargs) > > File "/usr/lib/python2.6/site-packages/MySQLdb/__init__.py", line > > 81, in Connect > > return Connection(*args, **kwargs) > > File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line > > 187, in __init__ > > super(Connection, self).__init__(*args, **kwargs2) > > _mysql_exceptions.OperationalError: (1049, "Unknown database > > 'reviewboard'") > > > This was a test run on a 3GB RAM machine with a fresh install of SL v > > 6 for i386. Am I still missing something? > > > Thanks for your help. > > You have to create an empty database before directly from mysql. rb-site > install will not do it for you. > > Regards. > Gilles. -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en