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 
>>> >     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...@googlegroups.com <javascript:>
> 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...@googlegroups.com <javascript:>.
> 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.


Reply via email to