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 <gilles.mo...@free.fr> 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 <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

Reply via email to