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
