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

[Gonzalo F. <eat...@gm...>]

what is the MYSQL Version?

some critical changes in the latests version impact in the table
creation an data manipulation.
It looks like the connection is ok, but NOT the table creation. Have you
checked any mysql error in /var/log?

Juan Pablo Bagnon wrote:
> Im really a newbbie with MySql and i get LOADS of these:
>
> SQLgrey recovered DB:	SQLgrey established connection to:
> DBI:mysql:database=Sqlgrey;host=localhost
> SQLgrey database error:	SQLgrey encountered an SQL error and triggered a
> reconnection to: DBI:mysql:database=Sqlgrey;host=localhost
>
> Cluopd it be the same problem?
> How can i do it with mysql?
> I got this:
>
> character set latin1 
>
> character sets latin1 big5 czech euc_kr gb2312 gbk 
> latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru 
> latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian 
> koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 
>
>
>   
>> -----Original Message-----
>> From: sql...@li... 
>> [mailto:sql...@li...] On 
>> Behalf Of Dan Faerch
>> Sent: Thursday, January 11, 2007 17:03
>> To: SQLgrey users mailing-list
>> Subject: Re: [Sqlgrey-users] Sqlgrey dies while creating mysql tables
>>
>>
>> Ahh yes...
>>
>> Lionel helped someone not long ago who had problems, and it 
>> turned out 
>> to be a UNICODE problem. Here's a quote from the mailing list:
>>
>> "Hum, did you try to use a database with ASCII instead of UNICODE?
>> SQLgrey doesn't try to speak utf-8 with the database but only 
>> pure ASCII."
>>
>> Andrew wrote a helpfull mail on how to migrate to ASCII.
>>  From the maillinglist archives:
>> http://sourceforge.net/mailarchive/message.php?msg_id=37802061
>>
>>
>> On a side note. Since more ppl will have this problem, im thinking we 
>> should either support other encodings or at least warn on 
>> execution of 
>> sqlgrey.
>>
>> Anyone got some thoughts about either of theese?
>> - How hard is it to support all encodings
>> - How do we detect if database is ASCII
>>
>> If we get a real simple solution, ill try and implement it very soon.
>>
>> - Dan
>>
>>
>> Juraj Variny wrote:
>>     
>>> 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
>>>>     
>>>>         
>>>       
>> --------------------------------------------------------------
>> -----------
>>     
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the 
>>>       
>> chance to share your
>>     
>>> opinions on IT & business topics through brief surveys - 
>>>       
>> and earn cash
>>     
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge
>>     
> &CID=DEVDEV
>   
>> _______________________________________________
>> Sqlgrey-users mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>>
>>   
>>     
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>
>