[Devel] [ openser-Bugs-1605410 ] Installation problems while creating mysql dbase

[SourceForge.net]

Bugs item #1605410, was opened at 2006-11-29 09:56
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1605410&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: packaging
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Installation problems while creating mysql dbase

Initial Comment:
Trying to execute scripts/mysqldb.sh:

omega1 scripts # sh ./mysqldb.sh create
MySql password for root:
creating database openser ...
ERROR 1071 (42000) at line 106: Specified key was too long; max key length is 1000 bytes

The problem is in primary key of 'location' table:

omega1 scripts # mysql -u root -h localhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1212 to server version: 4.1.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> connect test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id:    1213
Current database: test

mysql> CREATE TABLE location (
    ->   username varchar(64) NOT NULL default '',
    ->   domain varchar(128) NOT NULL default '',
    ->   contact varchar(255) NOT NULL default '',
    ->   received varchar(255) default NULL,
    ->   path varchar(255) default NULL,
    ->   expires datetime NOT NULL default '2020-05-28 21:32:15',
    ->   q float(10,2) NOT NULL default '1.0',
    ->   callid varchar(255) NOT NULL default 'Default-Call-ID',
    ->   cseq int(11) NOT NULL default '42',
    ->   last_modified datetime NOT NULL default "1900-01-01 00:00",
    ->   flags int(11) NOT NULL default '0',
    ->   user_agent varchar(255) NOT NULL default '',
    ->   socket varchar(128) default NULL,
    ->   methods int(11) default NULL,
    ->   PRIMARY KEY(username, domain, contact)
    -> ) TYPE=MyISAM;
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

OS/mySQL versions:

omega1 scripts # uname -a
Linux omega1 2.6.15-gentoo-r5 #1 SMP Thu May 4 10:27:42 Local time zone must be set--see zic m x86_64 AMD Opteron(tm) Processor 248 AuthenticAMD GNU/Linux


omega1 scripts # mysqladmin version -p
Enter password:
mysqladmin  Ver 8.41 Distrib 4.1.20, for pc-linux-gnu on x86_64
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          4.1.20-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 20 days 14 min 38 sec

Threads: 7  Questions: 146329  Slow queries: 0  Opens: 59  Flush tables: 1  Open tables: 19  Queries per second avg: 0.085


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1605410&group_id=139143