Hi Dockimbel, Petr, Anton,
Thanks so much to all for your help with this issue.=20
One mystery remains (why I still have the "Bad handshake" on the
local-machine mySql) but at least I could have a version running.
As for the "null dates" error, as I already had it with the former
version of mysql-protocol.r, I "patched" it this way. Does it make sense
that a null date be converted to a none value?=20
conv-model: [
...
date [attempt [to date!]]
time [to time!]
datetime [attempt [to date!]]
...
]
Alain.
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part
de [EMAIL PROTECTED]
Envoy=E9 : mardi 7 f=E9vrier 2006 02:47
=C0 : [EMAIL PROTECTED]
Objet : [REBOL] Re: RE : Re: RE : Re: RE : Re: R: fixes - Re: MySQL
1.0.0 beta driver released .... (BUG REPORT)
Hi Alain,
I'm guilty for the "probe" left in the last beta uploaded on our
website.=3D I've fixed that.
About your handshake issue, I've tried to reproduce that with MySQLd
v4.1=3D -16-nt (couldn't find a 1-14 version). I saw no error during the
handshake proce=3D ss (with or without password). Yet, I've used tables
from my 3.x install wit=3D h v4+ servers, so it may impact the relevance
of my validating tests...
Conversion error: the error you get when reading the first record from
th=3D e result of your query is caused by REBOL not allowing null dates
("0000-00=3D -00 00:00:00"). I'm open to suggestions on how should the
driver act upon suc=3D h not LOAD-able date, besides catching the error.
Thanks for your report,
--
DocKimbel.
Selon Alain Goy=3DC3=3DA9 <[EMAIL PROTECTED]>:
>
> No, I'm not using an empty password, and my "old_passwords" variable=20
> is=3D
=3D3D
> OFF...
>
> But here is something new: I installed the same mySql version on=20
> anothe=3D
r =3D3D
> machine (Windows server 2003) and (accessing it over the LAN with the=20
> =3D3D same Rebol) now it works better... Except for the rubbish=20
> printouts =3D3D which are still here:
>
> >> do %mysql-protocol.r
> Script: "MySQL Protocol" (25-Jan-2006)
> MySQL protocol loaded
> >> ; good password:
> >> db: open mysql://root:[EMAIL PROTECTED]/cist
> connecting to: 10.10.10.14 =
[EMAIL PROTECTED]@[EMAIL PROTECTED]@=3D3DC3=3D3D85z0=3D3DC2=3D3D81^U=20
> =3D3D=20
> =
=3D3DC5=3D3DA0#=3D3DC2=3D3DB2=3D3DC3=3D3DAB^X:=3D3DC3=3D3DBF=3D3DC3=3D3D9=
A=3D3DC3=3D3DA0^XBYX=3D
> 3D=3D
[EMAIL PROTECTED]@}
> >> insert db "SELECT * FROM staff"
> =3D3D3D=3D3D3D none
> >> first db
> ** Script Error: Invalid argument: 0000-00-00 00:00:00
> ** Where: convert-types
> ** Near: change at row 17 to
>
>
> Alain.
>
>
>
>
> -----Message d'origine-----
> De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part
> =3D
=3D3D
> de Petr Krenzelok
> Envoy=3D3DC3=3D3DA9 : lundi 6 f=3D3DC3=3D3DA9vrier 2006 19:38 =
=3D3DC3=3D3D80 :=20
> [EMAIL PROTECTED] Objet : [REBOL] Re: RE : Re: RE : Re: R: fixes -=20
> Re: MySQL 1.0.0 beta =3D3D driver released .... (BUG REPORT)
>
>
>
> Alain Goy=3D3D3DE9 wrote:
> > Hi Anton,
> >
> > This is MySQL 4.1.14-nt ...
> > =3D3D3D20
> Hmm, strange a bit, worked for me, although can't remember right now,=20
> =3D3D as=3D3D3D20 I installed 5.x in the meantime. Are you using empty =
> password=3D
? =3D3D
> Or are=3D3D3D20 you using "old_password" setting in mySQL?
>
> -pekr-
>
> > Alain.
--=20
To unsubscribe from the list, just send an email to=20
lists at rebol.com with unsubscribe as the subject.
--
To unsubscribe from the list, just send an email to
lists at rebol.com with unsubscribe as the subject.
