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