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

[SourceForge.net]

Bugs item #1605410, was opened at 2006-11-29 19:56
Message generated for change (Comment added) made by bogdan_iancu
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: tools
Group: None
>Status: Closed
>Resolution: Invalid
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
>Assigned to: Bogdan (bogdan_iancu)
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


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

>Comment By: Bogdan (bogdan_iancu)
Date: 2006-11-29 20:19

Message:
Logged In: YES 
user_id=1275325
Originator: NO

Hi,

actually it is not a bug in openser, but a bug related to mysql. This was
already reporded some time ago and thanks to Norman Brandinger
<norm at goes.com>, here is the answer:

"Perhaps the problem is related to the fact that UTF-8 uses 3-bytes to
save a character.
This issue was discussed at: http://bugs.mysql.com/bug.php?id=4541

If the datbase encoding is UTF-8, then this will be important to you."

visit also:
http://openser.org/pipermail/users/2006-November/007738.html

regards,
bogdan

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

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