Re: [Sqlgrey-users] Sqlgrey dies while creating mysql tables

[Juraj V. <ju...@eq...>]

Hello,

 perl -MDBI -le 'my $db=DBI->connect("DBI:mysql:database=sqlgrey;host=localhost","myuser","mypass",undef) or die "Error:$DBI::errstr".$db->disconnect()'

 passed without failure and output nothing. Then I tried to create the table, with very interesting result:

perl -MDBI -le 'my $db=DBI->connect("DBI:mysql:database=sqlgrey;host=localhost","u_sqlgrey","greysql",undef); $db->do("CREATE TABLE from_awl (sender_name varchar(64) NOT NULL, sender_domain varchar(255) NOT NULL, src varchar(39) NOT NULL, first_seen timestamp NOT NULL, last_seen timestamp NOT NULL, PRIMARY KEY (src, sender_domain, sender_name))");$db->disconnect();'
DBD::mysql::db do failed: Specified key was too long; max key length is 1000 bytes at -e line 1.

According to http://bugs.mysql.com/bug.php?id=4541 , it seems the culprit is that I have utf8 database....

Juraj

On Wednesday 10 January 2007 20:57, Winfried Neessen wrote:
(snip)
> `---
> please open a shell an execute this line an send us what error that is
> returned by it:
>
> ,---
>
> | perl -MDBI -le 'my
> | $db=DBI->connect("DBI:mysql:database=sqlgrey;host=localhost","youruser","
> |yourpass",undef) or die "Error: $DBI::errstr"$db->disconnect()'
>
> `---
>
> Regards
> Winfried