Re: Can't install ReviewBoard with rb-site
Which version of MySQL are you using? I find it hard to believe that I'm the only one with that problem. --Dirk On Saturday, July 27, 2013 6:08:07 AM UTC+2, Christian Hammond wrote: We haven't hit it (we use utf-8), so I don't have an answer ready for you. We'll have to figure out some solution that won't be a total pain. Christian -- Christian Hammond - chi...@chipx86.com javascript: Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com On Jul 25, 2013, at 5:04 AM, Dirk Best sta...@gmail.com javascript: wrote: I've changed the reviewboard database to latin1 and it installs fine now (because the key is now less than 1000 bytes). Am I supposed to use latin1? --Dirk On Wednesday, July 24, 2013 1:59:29 AM UTC+2, Dirk Best wrote: MySQL works fine for a number of applications on the same server, installed is version 5.1.70. This is the table it tries to create: CREATE TABLE `hostingsvcs_hostingserviceaccount` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `service_name` varchar(128) NOT NULL, `hosting_url` varchar(255), `username` varchar(128) NOT NULL, `data` longtext NOT NULL, `visible` bool NOT NULL, `local_site_id` integer, UNIQUE (`service_name`, `hosting_url`, `username`, `local_site_id`) ) There is a key over the columns `service_name`, `hosting_url`, `username` and `local_site_id`. Sum of those is 128+255+128 = 511 * 3 (because of UTF-8). --Dirk On Wednesday, July 24, 2013 1:13:43 AM UTC+2, Christian Hammond wrote: We have no keys approaching anything near that size. I have no idea what it'd ever give you that. Is there something funky with your MySQL configuration? Christian Dirk Best wrote: Thanks for your help, I've uninstalled everything the package manager installed and used your installation instructions. The installation goes a lot further now, but stops here: Creating table hostingsvcs_hostingserviceaccount Traceback (most recent call last): File /usr/bin/rb-site, line 9, in module load_entry_point('ReviewBoard==1.7.11', 'console_scripts', 'rb-site')() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1937, in main command.run() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1405, in run self.show_install_status() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1684, in show_install_status site.sync_database) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 885, in step func() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 370, in sync_database self.run_manage_command(syncdb, params) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 560, in run_manage_command execute_manager(reviewboard.settings, [__file__, cmd] + params) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 459, in execute_manager utility.execute() File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 382, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 196, in run_from_argv self.execute(*args, **options.__dict__) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 232, in execute output = self.handle(*args, **options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 371, in handle return self.handle_noargs(**options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/syncdb.py, line 102, in handle_noargs cursor.execute(statement) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py, line 114, in execute return self.cursor.execute(query, args) File /usr/lib64/python2.7/site-packages/MySQLdb/cursors.py, line 174, in execute self.errorhandler(self, exc, value) File /usr/lib64/python2.7/site-packages/MySQLdb/connections.py, line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.DatabaseError: (1071, 'Specified key was too long; max key length is 1000 bytes') This seems to be a mysql limit? --Dirk On Tuesday, July 23, 2013 8:45:30 PM UTC+2, Christian Hammond wrote: Your rb-site is linked to rbssh instead. Something is very wrong with
Re: Can't install ReviewBoard with rb-site
I ran into this problem when I tried to upgrade past 1.7.7.1. Very curious about the answer. Eric Sent from my iPad On Jul 25, 2013, at 5:04 AM, Dirk Best star...@gmail.com wrote: I've changed the reviewboard database to latin1 and it installs fine now (because the key is now less than 1000 bytes). Am I supposed to use latin1? --Dirk On Wednesday, July 24, 2013 1:59:29 AM UTC+2, Dirk Best wrote: MySQL works fine for a number of applications on the same server, installed is version 5.1.70. This is the table it tries to create: CREATE TABLE `hostingsvcs_hostingserviceaccount` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `service_name` varchar(128) NOT NULL, `hosting_url` varchar(255), `username` varchar(128) NOT NULL, `data` longtext NOT NULL, `visible` bool NOT NULL, `local_site_id` integer, UNIQUE (`service_name`, `hosting_url`, `username`, `local_site_id`) ) There is a key over the columns `service_name`, `hosting_url`, `username` and `local_site_id`. Sum of those is 128+255+128 = 511 * 3 (because of UTF-8). --Dirk On Wednesday, July 24, 2013 1:13:43 AM UTC+2, Christian Hammond wrote: We have no keys approaching anything near that size. I have no idea what it'd ever give you that. Is there something funky with your MySQL configuration? Christian Dirk Best wrote: Thanks for your help, I've uninstalled everything the package manager installed and used your installation instructions. The installation goes a lot further now, but stops here: Creating table hostingsvcs_hostingserviceaccount Traceback (most recent call last): File /usr/bin/rb-site, line 9, in module load_entry_point('ReviewBoard==1.7.11', 'console_scripts', 'rb-site')() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1937, in main command.run() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1405, in run self.show_install_status() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1684, in show_install_status site.sync_database) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 885, in step func() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 370, in sync_database self.run_manage_command(syncdb, params) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 560, in run_manage_command execute_manager(reviewboard.settings, [__file__, cmd] + params) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 459, in execute_manager utility.execute() File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 382, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 196, in run_from_argv self.execute(*args, **options.__dict__) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 232, in execute output = self.handle(*args, **options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 371, in handle return self.handle_noargs(**options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/syncdb.py, line 102, in handle_noargs cursor.execute(statement) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py, line 114, in execute return self.cursor.execute(query, args) File /usr/lib64/python2.7/site-packages/MySQLdb/cursors.py, line 174, in execute self.errorhandler(self, exc, value) File /usr/lib64/python2.7/site-packages/MySQLdb/connections.py, line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.DatabaseError: (1071, 'Specified key was too long; max key length is 1000 bytes') This seems to be a mysql limit? --Dirk On Tuesday, July 23, 2013 8:45:30 PM UTC+2, Christian Hammond wrote: Your rb-site is linked to rbssh instead. Something is very wrong with the package you installed. You'll need to uninstall it and use our installation instructions instead. Christian Dirk Best wrote: Hi Christian, here is the output of rb-site --help: crest ~ # rb-site --help Usage: rb-site [options] [user@]hostname [command] I've installed ReviewBoard using the
Re: Can't install ReviewBoard with rb-site
We haven't hit it (we use utf-8), so I don't have an answer ready for you. We'll have to figure out some solution that won't be a total pain. Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com On Jul 25, 2013, at 5:04 AM, Dirk Best star...@gmail.com wrote: I've changed the reviewboard database to latin1 and it installs fine now (because the key is now less than 1000 bytes). Am I supposed to use latin1? --Dirk On Wednesday, July 24, 2013 1:59:29 AM UTC+2, Dirk Best wrote: MySQL works fine for a number of applications on the same server, installed is version 5.1.70. This is the table it tries to create: CREATE TABLE `hostingsvcs_hostingserviceaccount` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `service_name` varchar(128) NOT NULL, `hosting_url` varchar(255), `username` varchar(128) NOT NULL, `data` longtext NOT NULL, `visible` bool NOT NULL, `local_site_id` integer, UNIQUE (`service_name`, `hosting_url`, `username`, `local_site_id`) ) There is a key over the columns `service_name`, `hosting_url`, `username` and `local_site_id`. Sum of those is 128+255+128 = 511 * 3 (because of UTF-8). --Dirk On Wednesday, July 24, 2013 1:13:43 AM UTC+2, Christian Hammond wrote: We have no keys approaching anything near that size. I have no idea what it'd ever give you that. Is there something funky with your MySQL configuration? Christian Dirk Best wrote: Thanks for your help, I've uninstalled everything the package manager installed and used your installation instructions. The installation goes a lot further now, but stops here: Creating table hostingsvcs_hostingserviceaccount Traceback (most recent call last): File /usr/bin/rb-site, line 9, in module load_entry_point('ReviewBoard==1.7.11', 'console_scripts', 'rb-site')() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1937, in main command.run() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1405, in run self.show_install_status() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1684, in show_install_status site.sync_database) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 885, in step func() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 370, in sync_database self.run_manage_command(syncdb, params) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 560, in run_manage_command execute_manager(reviewboard.settings, [__file__, cmd] + params) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 459, in execute_manager utility.execute() File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 382, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 196, in run_from_argv self.execute(*args, **options.__dict__) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 232, in execute output = self.handle(*args, **options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 371, in handle return self.handle_noargs(**options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/syncdb.py, line 102, in handle_noargs cursor.execute(statement) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py, line 114, in execute return self.cursor.execute(query, args) File /usr/lib64/python2.7/site-packages/MySQLdb/cursors.py, line 174, in execute self.errorhandler(self, exc, value) File /usr/lib64/python2.7/site-packages/MySQLdb/connections.py, line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.DatabaseError: (1071, 'Specified key was too long; max key length is 1000 bytes') This seems to be a mysql limit? --Dirk On Tuesday, July 23, 2013 8:45:30 PM UTC+2, Christian Hammond wrote: Your rb-site is linked to rbssh instead. Something is very wrong with the package you installed. You'll need to uninstall it and use our installation instructions instead. Christian Dirk Best wrote: Hi Christian, here is the output of rb-site
Re: Can't install ReviewBoard with rb-site
I've changed the reviewboard database to latin1 and it installs fine now (because the key is now less than 1000 bytes). Am I supposed to use latin1? --Dirk On Wednesday, July 24, 2013 1:59:29 AM UTC+2, Dirk Best wrote: MySQL works fine for a number of applications on the same server, installed is version 5.1.70. This is the table it tries to create: CREATE TABLE `hostingsvcs_hostingserviceaccount` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `service_name` varchar(128) NOT NULL, `hosting_url` varchar(255), `username` varchar(128) NOT NULL, `data` longtext NOT NULL, `visible` bool NOT NULL, `local_site_id` integer, UNIQUE (`service_name`, `hosting_url`, `username`, `local_site_id`) ) There is a key over the columns `service_name`, `hosting_url`, `username` and `local_site_id`. Sum of those is 128+255+128 = 511 * 3 (because of UTF-8). --Dirk On Wednesday, July 24, 2013 1:13:43 AM UTC+2, Christian Hammond wrote: We have no keys approaching anything near that size. I have no idea what it'd ever give you that. Is there something funky with your MySQL configuration? Christian Dirk Best wrote: Thanks for your help, I've uninstalled everything the package manager installed and used your installation instructions. The installation goes a lot further now, but stops here: Creating table hostingsvcs_hostingserviceaccount Traceback (most recent call last): File /usr/bin/rb-site, line 9, in module load_entry_point('ReviewBoard==1.7.11', 'console_scripts', 'rb-site')() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1937, in main command.run() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1405, in run self.show_install_status() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1684, in show_install_status site.sync_database) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 885, in step func() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 370, in sync_database self.run_manage_command(syncdb, params) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 560, in run_manage_command execute_manager(reviewboard.settings, [__file__, cmd] + params) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 459, in execute_manager utility.execute() File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 382, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 196, in run_from_argv self.execute(*args, **options.__dict__) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 232, in execute output = self.handle(*args, **options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 371, in handle return self.handle_noargs(**options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/syncdb.py, line 102, in handle_noargs cursor.execute(statement) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py, line 114, in execute return self.cursor.execute(query, args) File /usr/lib64/python2.7/site-packages/MySQLdb/cursors.py, line 174, in execute self.errorhandler(self, exc, value) File /usr/lib64/python2.7/site-packages/MySQLdb/connections.py, line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.DatabaseError: (1071, 'Specified key was too long; max key length is 1000 bytes') This seems to be a mysql limit? --Dirk On Tuesday, July 23, 2013 8:45:30 PM UTC+2, Christian Hammond wrote: Your rb-site is linked to rbssh instead. Something is very wrong with the package you installed. You'll need to uninstall it and use our installation instructions instead. Christian Dirk Best wrote: Hi Christian, here is the output of rb-site --help: crest ~ # rb-site --help Usage: rb-site [options] [user@]hostname [command] I've installed ReviewBoard using the Gentoo package manager. I have both python 2.7 and 3.2 installed. --Dirk On Tuesday, July 23, 2013 8:17:29 PM
Re: Can't install ReviewBoard with rb-site
Thanks for your help, I've uninstalled everything the package manager installed and used your installation instructions. The installation goes a lot further now, but stops here: Creating table hostingsvcs_hostingserviceaccount Traceback (most recent call last): File /usr/bin/rb-site, line 9, in module load_entry_point('ReviewBoard==1.7.11', 'console_scripts', 'rb-site')() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1937, in main command.run() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1405, in run self.show_install_status() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1684, in show_install_status site.sync_database) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 885, in step func() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 370, in sync_database self.run_manage_command(syncdb, params) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 560, in run_manage_command execute_manager(reviewboard.settings, [__file__, cmd] + params) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 459, in execute_manager utility.execute() File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 382, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 196, in run_from_argv self.execute(*args, **options.__dict__) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 232, in execute output = self.handle(*args, **options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 371, in handle return self.handle_noargs(**options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/syncdb.py, line 102, in handle_noargs cursor.execute(statement) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py, line 114, in execute return self.cursor.execute(query, args) File /usr/lib64/python2.7/site-packages/MySQLdb/cursors.py, line 174, in execute self.errorhandler(self, exc, value) File /usr/lib64/python2.7/site-packages/MySQLdb/connections.py, line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.DatabaseError: (1071, 'Specified key was too long; max key length is 1000 bytes') This seems to be a mysql limit? --Dirk On Tuesday, July 23, 2013 8:45:30 PM UTC+2, Christian Hammond wrote: Your rb-site is linked to rbssh instead. Something is very wrong with the package you installed. You'll need to uninstall it and use our installation instructions instead. Christian Dirk Best wrote: Hi Christian, here is the output of rb-site --help: crest ~ # rb-site --help Usage: rb-site [options] [user@]hostname [command] I've installed ReviewBoard using the Gentoo package manager. I have both python 2.7 and 3.2 installed. --Dirk On Tuesday, July 23, 2013 8:17:29 PM UTC+2, Christian Hammond wrote: Hi Dirk, Not sure why you're getting that error at all. That looks to be coming from rbssh, but rb-site does not invoke rbssh. I'm wondering if something funky is going on with your Python setup. Can you run rb-site --help and see what the help output is? Does it say rb-site, or rbssh? Also, how did you install Review Board, and what version of Python are you running? Christian Dirk Best wrote: When trying to install ReviewBoard I simply get this: rb-site install /var/www/mysite Unknown exception during connect: [Errno -2] Name or service not known (class 'socket.gaierror') Is that the correct command? System info: Gentoo Linux with kernel 3.9.5-hardened, ReviewBoard 1.7.7.1. -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard...@googlegroups.com javascript: For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
Re: Can't install ReviewBoard with rb-site
We have no keys approaching anything near that size. I have no idea what it'd ever give you that. Is there something funky with your MySQL configuration? Christian Dirk Best wrote: Thanks for your help, I've uninstalled everything the package manager installed and used your installation instructions. The installation goes a lot further now, but stops here: Creating table hostingsvcs_hostingserviceaccount Traceback (most recent call last): File /usr/bin/rb-site, line 9, in module load_entry_point('ReviewBoard==1.7.11', 'console_scripts', 'rb-site')() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1937, in main command.run() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1405, in run self.show_install_status() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1684, in show_install_status site.sync_database) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 885, in step func() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 370, in sync_database self.run_manage_command(syncdb, params) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 560, in run_manage_command execute_manager(reviewboard.settings, [__file__, cmd] + params) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 459, in execute_manager utility.execute() File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 382, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 196, in run_from_argv self.execute(*args, **options.__dict__) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 232, in execute output = self.handle(*args, **options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 371, in handle return self.handle_noargs(**options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/syncdb.py, line 102, in handle_noargs cursor.execute(statement) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py, line 114, in execute return self.cursor.execute(query, args) File /usr/lib64/python2.7/site-packages/MySQLdb/cursors.py, line 174, in execute self.errorhandler(self, exc, value) File /usr/lib64/python2.7/site-packages/MySQLdb/connections.py, line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.DatabaseError: (1071, 'Specified key was too long; max key length is 1000 bytes') This seems to be a mysql limit? --Dirk On Tuesday, July 23, 2013 8:45:30 PM UTC+2, Christian Hammond wrote: Your rb-site is linked to rbssh instead. Something is very wrong with the package you installed. You'll need to uninstall it and use our installation instructions instead. Christian Dirk Best wrote: Hi Christian, here is the output of rb-site --help: crest ~ # rb-site --help Usage: rb-site [options] [user@]hostname [command] I've installed ReviewBoard using the Gentoo package manager. I have both python 2.7 and 3.2 installed. --Dirk On Tuesday, July 23, 2013 8:17:29 PM UTC+2, Christian Hammond wrote: Hi Dirk, Not sure why you're getting that error at all. That looks to be coming from rbssh, but rb-site does not invoke rbssh. I'm wondering if something funky is going on with your Python setup. Can you run rb-site --help and see what the help output is? Does it say rb-site, or rbssh? Also, how did you install Review Board, and what version of Python are you running? Christian Dirk Best wrote: When trying to install ReviewBoard I simply get this: rb-site install /var/www/mysite Unknown exception during connect: [Errno -2] Name or service not known (class 'socket.gaierror') Is that the correct command? System info: Gentoo Linux with kernel 3.9.5-hardened, ReviewBoard 1.7.7.1. -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ http://www.reviewboard.org/donate/ http://www.reviewboard.org/donate/ http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ http://www.reviewboard.org/users/ http://www.reviewboard.org/users/ http://www.reviewboard.org/users/
Re: Can't install ReviewBoard with rb-site
MySQL works fine for a number of applications on the same server, installed is version 5.1.70. This is the table it tries to create: CREATE TABLE `hostingsvcs_hostingserviceaccount` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `service_name` varchar(128) NOT NULL, `hosting_url` varchar(255), `username` varchar(128) NOT NULL, `data` longtext NOT NULL, `visible` bool NOT NULL, `local_site_id` integer, UNIQUE (`service_name`, `hosting_url`, `username`, `local_site_id`) ) There is a key over the columns `service_name`, `hosting_url`, `username` and `local_site_id`. Sum of those is 128+255+128 = 511 * 3 (because of UTF-8). --Dirk On Wednesday, July 24, 2013 1:13:43 AM UTC+2, Christian Hammond wrote: We have no keys approaching anything near that size. I have no idea what it'd ever give you that. Is there something funky with your MySQL configuration? Christian Dirk Best wrote: Thanks for your help, I've uninstalled everything the package manager installed and used your installation instructions. The installation goes a lot further now, but stops here: Creating table hostingsvcs_hostingserviceaccount Traceback (most recent call last): File /usr/bin/rb-site, line 9, in module load_entry_point('ReviewBoard==1.7.11', 'console_scripts', 'rb-site')() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1937, in main command.run() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1405, in run self.show_install_status() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 1684, in show_install_status site.sync_database) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 885, in step func() File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 370, in sync_database self.run_manage_command(syncdb, params) File /usr/lib64/python2.7/site-packages/ReviewBoard-1.7.11-py2.7.egg/reviewboard/cmdline/rbsite.py, line 560, in run_manage_command execute_manager(reviewboard.settings, [__file__, cmd] + params) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 459, in execute_manager utility.execute() File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/__init__.py, line 382, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 196, in run_from_argv self.execute(*args, **options.__dict__) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 232, in execute output = self.handle(*args, **options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/base.py, line 371, in handle return self.handle_noargs(**options) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/management/commands/syncdb.py, line 102, in handle_noargs cursor.execute(statement) File /usr/lib64/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py, line 114, in execute return self.cursor.execute(query, args) File /usr/lib64/python2.7/site-packages/MySQLdb/cursors.py, line 174, in execute self.errorhandler(self, exc, value) File /usr/lib64/python2.7/site-packages/MySQLdb/connections.py, line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.DatabaseError: (1071, 'Specified key was too long; max key length is 1000 bytes') This seems to be a mysql limit? --Dirk On Tuesday, July 23, 2013 8:45:30 PM UTC+2, Christian Hammond wrote: Your rb-site is linked to rbssh instead. Something is very wrong with the package you installed. You'll need to uninstall it and use our installation instructions instead. Christian Dirk Best wrote: Hi Christian, here is the output of rb-site --help: crest ~ # rb-site --help Usage: rb-site [options] [user@]hostname [command] I've installed ReviewBoard using the Gentoo package manager. I have both python 2.7 and 3.2 installed. --Dirk On Tuesday, July 23, 2013 8:17:29 PM UTC+2, Christian Hammond wrote: Hi Dirk, Not sure why you're getting that error at all. That looks to be coming from rbssh, but rb-site does not invoke rbssh. I'm wondering if