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 --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/>> > > > > -~----------~----~----~----~------~----~------~--~--- > > > > 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 > > <http://groups.google.com/group/reviewboard?hl=en> > > > <http://groups.google.com/group/reviewboard?hl=en > > <http://groups.google.com/group/reviewboard?hl=en>> > > > > --- > > > > You received this message because you are subscribed to the Google > > > > Groups "reviewboard" group. > > > > To unsubscribe from this group and stop receiving emails from it, > > > send > > > > an email to reviewboard...@googlegroups.com <javascript:>. > > > > For more options, visit > > https://groups.google.com/groups/opt_out > > <https://groups.google.com/groups/opt_out> > > > <https://groups.google.com/groups/opt_out > > <https://groups.google.com/groups/opt_out>>. > > > > > > > > > > > > > > -- > > > Christian Hammond - chi...@chipx86.com <javascript:> > > > Review Board - http://www.reviewboard.org > > > Beanbag, Inc. - http://www.beanbaginc.com > > > > > > > -- > > Christian Hammond - chi...@chipx86.com <javascript:> > > Review Board - http://www.reviewboard.org > > Beanbag, Inc. - http://www.beanbaginc.com > > > > -- > Christian Hammond - chi...@chipx86.com > Review Board - http://www.reviewboard.org > Beanbag, Inc. - http://www.beanbaginc.com > > -- > 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 > --- > You received this message because you are subscribed to the Google Groups > "reviewboard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > -- 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 --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.