Success! Many thanks! It's now working on a Scientific Linux v6 32-bit prototype box. I expect to have them drive it around a bit and then build a 64-bit server for it.
I'm heading over to the documentation to see if I can upgrade it to v 1.5.5 Is there any advice you might have for doing this? On Apr 14, 1:32 am, Gilles Moris <[email protected]> wrote: > On Thursday 14 April 2011 02:10:42 am Dean wrote: > > > 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) > > First you start talking about a "rbadmin" user but then seems to actually > create and use a "rbdbuser". May be you mixed both ? > > Another possibility is that you had a syntax error in your GRANT query. When > you want to grant access to all tables, the syntax is reviewboard.* . Without > the ".*", you may just referring to the reviewboard table in the current > database. > mysql> GRANT ALL PRIVILEGES ON reviewboard.* TO 'rbdbuser'@'localhost' ... > > Regards. > Gilles. > > > 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 <[email protected]> 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 [email protected] For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
