Finally, I have had some time to finish the Scheme code that generates the MySQL client auth protocol messages. The SHA1 implementation seems to work fine, although it’s quite slow: The specification contains a test case that consists of calculating the hash value of one million a characters. This test took 35 minutes on a 3 GHz Pentium III processor… So, you probably don’t want to replace /sbin/sha1 with the Scheme implementation yet…

However, for small messages, such as the MySQL passwords, the implementation is fast enough. Next on my list: Generating query messages and reading replies. Doesn’t look too complicated. Here’s my code (as a darcs repository):

http://www-pu.informatik.uni-tuebingen.de/users/knauel/sw/myscsh/

Technorati Tags: , ,