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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

MySql 4.0.24

I have turned log and log-error to try to catch any mysql complaint.

> -----Original Message-----
> From: sql...@li...=20
> [mailto:sql...@li...] On=20
> Behalf Of Gonzalo Fernandez
> Sent: Thursday, January 11, 2007 21:14
> To: SQLgrey users mailing-list
> Subject: Re: [Sqlgrey-users] Sqlgrey dies while creating mysql tables
>=20
>=20
> what is the MYSQL Version?
>=20
> 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=20
> creation. Have you
> checked any mysql error in /var/log?
>=20
> 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=3DSqlgrey;host=3Dlocalhost
> > SQLgrey database error:	SQLgrey encountered an SQL=20
> error and triggered a
> > reconnection to: DBI:mysql:database=3DSqlgrey;host=3Dlocalhost
> >
> > Cluopd it be the same problem?
> > How can i do it with mysql?
> > I got this:
> >
> > character set latin1=20
> >
> > character sets latin1 big5 czech euc_kr gb2312 gbk=20
> > latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru=20
> > latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian=20
> > koi8_ukr win1251ukr greek win1250 croat cp1257 latin5=20
> >
> >
> >  =20
> >> -----Original Message-----
> >> From: sql...@li...=20
> >> [mailto:sql...@li...] On=20
> >> Behalf Of Dan Faerch
> >> Sent: Thursday, January 11, 2007 17:03
> >> To: SQLgrey users mailing-list
> >> Subject: Re: [Sqlgrey-users] Sqlgrey dies while creating=20
> mysql tables
> >>
> >>
> >> Ahh yes...
> >>
> >> Lionel helped someone not long ago who had problems, and it=20
> >> turned out=20
> >> 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=20
> >> 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=3D37802061
> >>
> >>
> >> On a side note. Since more ppl will have this problem, im=20
> thinking we=20
> >> should either support other encodings or at least warn on=20
> >> execution of=20
> >> 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=20
> very soon.
> >>
> >> - Dan
> >>
> >>
> >> Juraj Variny wrote:
> >>    =20
> >>> Hello,
> >>>
> >>>  perl -MDBI -le 'my=20
> >>>      =20
> >> =
$db=3DDBI->connect("DBI:mysql:database=3Dsqlgrey;host=3Dlocalhost","
> >> myuser","mypass",undef) or die=20
> "Error:$DBI::errstr".$db->disconnect()'
> >>    =20
> >>>  passed without failure and output nothing. Then I tried to=20
> >>>      =20
> >> create the table, with very interesting result:
> >>    =20
> >>> perl -MDBI -le 'my=20
> >>>      =20
> >> =
$db=3DDBI->connect("DBI:mysql:database=3Dsqlgrey;host=3Dlocalhost","
> >> u_sqlgrey","greysql",undef); $db->do("CREATE TABLE from_awl=20
> >> (sender_name varchar(64) NOT NULL, sender_domain varchar(255)=20
> >> NOT NULL, src varchar(39) NOT NULL, first_seen timestamp NOT=20
> >> NULL, last_seen timestamp NOT NULL, PRIMARY KEY (src,=20
> >> sender_domain, sender_name))");$db->disconnect();'
> >>    =20
> >>> DBD::mysql::db do failed: Specified key was too long; max=20
> >>>      =20
> >> key length is 1000 bytes at -e line 1.
> >>    =20
> >>> According to http://bugs.mysql.com/bug.php?id=3D4541 , it=20
> >>>      =20
> >> seems the culprit is that I have utf8 database....
> >>    =20
> >>> Juraj
> >>>
> >>> On Wednesday 10 January 2007 20:57, Winfried Neessen wrote:
> >>> (snip)
> >>>  =20
> >>>      =20
> >>>> `---
> >>>> please open a shell an execute this line an send us what=20
> >>>>        =20
> >> error that is
> >>    =20
> >>>> returned by it:
> >>>>
> >>>> ,---
> >>>>
> >>>> | perl -MDBI -le 'my
> >>>> |=20
> >>>>        =20
> >> =
$db=3DDBI->connect("DBI:mysql:database=3Dsqlgrey;host=3Dlocalhost","
> >> youruser","
> >>    =20
> >>>> |yourpass",undef) or die "Error: $DBI::errstr"$db->disconnect()'
> >>>>
> >>>> `---
> >>>>
> >>>> Regards
> >>>> Winfried
> >>>>    =20
> >>>>        =20
> >>>      =20
> >> --------------------------------------------------------------
> >> -----------
> >>    =20
> >>> Take Surveys. Earn Cash. Influence the Future of IT
> >>> Join SourceForge.net's Techsay panel and you'll get the=20
> >>>      =20
> >> chance to share your
> >>    =20
> >>> opinions on IT & business topics through brief surveys -=20
> >>>      =20
> >> and earn cash
> >>    =20
> >> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge
> >>    =20
> > &CID=3DDEVDEV
> >  =20
> >> _______________________________________________
> >> Sqlgrey-users mailing list
> >> Sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
> >>
> >>  =20
> >>    =20
> >
> >
> >=20
> --------------------------------------------------------------
> -----------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the=20
> chance to share your
> > opinions on IT & business topics through brief surveys -=20
> and earn cash
> >=20
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge
&CID=3DDEVDEV
> _______________________________________________
> 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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>
>  =20

-------------------------------------------------------------------------=

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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
_______________________________________________
Sqlgrey-users mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users