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.
