World: r3wp

addad "s" to below line in mysql-protochol.r otherwise "s" get set 
in global space

b0: b1: b2: b3: int: int24: long: string: field: len: byte: s: none

read-field: [
		(null-flag: false)
		read-length s: (either null-flag 
[field: none]
			[field:	sys-copy/part s len s: skip s len]) :s
	]

james: use the 'ping command: insert db [ping] (see driver documentation 
for more info on this command).

Will: thanks, fix added.

Doc, will there be a new version of the mysql driver somewhere punlicly 
available? I get a can't connect on softinnov.org?

*publicly

This one should work : http://softinnov.net/tmp/mysql-protocol.r

still beta, need some more testing to make it 1.0

the link is dead

http://softinnov.org/tmp/mysql-protocol.r

was the bad handshake problem ever solved? I'm getting it here.

Workaround found for v4+ servers version, still testing for v3.x 
 versions.

so no hope for 5.0 just yet?

It should work correctly for 5.0.

would this be with support for old passwords enabled?

The driver detects the server version, if it is 4 or above, it use 
the new passswords, if it is 3.x, it uses old passwords.

If you want v5 with old password, I have to provide an option to 
allow that.

I had old passwords enabled because I thought it didn't support that 
:-)

:-)

but I still get the bad handshake

Which server version ? How password was created ?

server 5.0.21

I used mysql-admin to create the user. I don't know which method 
it uses

Thanks, I'll try with 5.0.21 + mysql-admin.

looks like mysql-admin doesn't use PASSWORD() to create passwords

that's the problem

works when I set it with PASSWORD()

hope that helps a bit

Sure it helps, thanks!

I'll try to release an updated version this weekend that fix such 
case.

excellent

dumb question.. is this a valid query?

select i1.id,i1.ip,i1.session from isa i1,isa i2 where i1.ip=i2.ip 
and i1.session<>i2.session order by i1.ip
about 70'000 records in isa
running this query seams to crash/block the mysql server..

not a well constructed query. unless my mental parser isn't working. 
You are asking for each and every row where it doesn't match the 
current row... now I don't think that is your true intent ...

that would be something like 70,000 * 70,000 results

valid but not like useful , (or likely to finish soon)

stating what you actually want to accomplish could help

Henrik: Can yo give me the mysqladmin command line you're using to 
create a new user ?

mysql-admin is a GUI client.

I'll see if I can find some docs on it. it's the client you can download 
from mysql.com

Ok, so you mean MySQL Administrator (and not the mysqladmin.exe command 
line tool).

it's called "mysql-admin" under linux. looks like your name is correct.

http://dev.mysql.com/downloads/administrator/1.1.html<--- that one

Tried creating a user using that tool under WinXP and OSX, then I 
tried connecting with mysql-protocol.r => no problem...

if you look in your user table, what length is the encrypted password?

*63D85DCA15EAFFC58C908FD2FAE50CCBC60C4EA2

ok, mine are only about 16 chars long

so it's simply a different encryption scheme for some reason

when I created it from the console, I got a properly encrypted password 
like yours

16 chars are old passwords IIRC

I think the client is confused about that. The error log for it says 
that old passwords are not supported for 5.0. I initially tried to 
turn old passwords on, because I didn't think mysql-protocol.r supported 
newer ones.