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 <javascript:> 
> 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.


Reply via email to