World: r3wp

which mysql version? I've only seen it on 4.1 and up

4.0.16

the copy copy thing fixes it for 5.0, it seems

Ok, will try to reproduce that with a 5+ version

Just tried with v5.0.19, no problem :

is that with the fix?

>> db: open mysql://[root-:-localhost]/test
>> insert db "insert into regions values ('557', 'test')"
== none
>> insert db "select * from empty"
Yes, let me try without it

maybe it needs to get "dirty" with a few selects first... I don't 
know

Tried with several SELECT clauses, tried using partial reading with 
copy/part, still no problem...

With or without using a fresh block! value for empty set

Do you have a small example that doesn't work for you ?

I'll see if I can figure something out...

sorry, I can't make a simple example right now. no time. :-(

I'm getting the Error 1043 Bad Handshake problem accessing My-SQL 
5.0.18 on Windows/XP using mysql-protocol.r via  localhost: that 
Alain Goyé reported on the mailing list:

>> db: open mysql://root:?@localhost/fundamentals
Password: *********
connecting to: localhost
>> insert db "SELECT * FROM books"
** User Error: ERROR 1043 : Bad handshake
** Near: insert db "SELECT * FROM books"

It works fine from another machine over the LAN.

Any pointers on how to overcome this?

Sorry, it's a password related problem that I can duplicate remotely. 
Further investigation needed.

try changing the  Privileges to 'No password' for the user and see 
if the error still exists?

Works fine .

I've just realised that I' have old_passwords set on and am using 
the latest version of Mysql-protocol.r :-(

it should work too though ...

it should distinguish, if the password is old or new style ....

but not sure, maybe Doc removed the "old" functionality, although 
I doubt it ...

I solved the problem by installing the 0.99 version of mysql-protocol.r. 
It was quicker than trying to get XAMPP to accept a MySQL revised 
configuration file.

Thanks for your help, Yek Soon and Petr.

What do you all use to check if a port is open? Instead of getting 
a port not open when trying to read the "inserted" SQL results. RIght 
now I'm using error? try [ a: copy db] where db is the object with 
the results. I don't know, it doesn't seem to work all that well.

.

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.