I aqpologize this is a little off-topic, as it's about running MySQL through Stunnel.
I'm running MySQL 4.1.7 on Windows 2K Server, and have Stunnel running on that box in server mode, configured to receive encrypted data on port 3307, and output on standard MySQL port 3306. The stunnel client connects, but doesn't pass data. I keep getting "Socket closed on read" after a connection is negotiated. My server-side startup command and log file are below. I've been fighting this for hours, and can't get anywhere. Any guidance would be greatly appreciated.
stunnel-3.26 -p stunnel.pem -d 3307 -r localhost:3306 -o log.txt -D 7
2004.11.02 09:23:59 LOG5[632:1020]: Using 'localhost.3306' as tcpwrapper service name
2004.11.02 09:23:59 LOG7[632:1020]: RAND_status claims sufficient entropy for the PRNG
2004.11.02 09:23:59 LOG7[632:1020]: Seeded PRNG with RAND_screen
2004.11.02 09:23:59 LOG6[632:1020]: PRNG seeded successfully
2004.11.02 09:23:59 LOG7[632:1020]: Using Diffie-Hellman parameters from stunnel.pem
2004.11.02 09:23:59 LOG6[632:1020]: Diffie-Hellman initialized with 512 bit key
2004.11.02 09:23:59 LOG7[632:1020]: Certificate: stunnel.pem
2004.11.02 09:23:59 LOG5[632:1020]: stunnel 3.26 on x86-pc-mingw32-gnu WIN32 with OpenSSL 0.9.5 28 Feb 2000
2004.11.02 09:23:59 LOG5[632:1020]: FD_SETSIZE=4096, file ulimit=-1 (unlimited) -> 2000 clients allowed
2004.11.02 09:23:59 LOG7[632:1020]: SO_REUSEADDR option set on accept socket
2004.11.02 09:23:59 LOG7[632:1020]: localhost.3306 bound to 0.0.0.0:3307
2004.11.02 09:24:23 LOG7[632:1020]: localhost.3306 accepted FD=728 from xx.xx.71.2:55252
2004.11.02 09:24:23 LOG7[632:904]: localhost.3306 started
2004.11.02 09:24:23 LOG5[632:904]: localhost.3306 connected from xx.xx.71.2:55252
2004.11.02 09:24:23 LOG7[632:904]: localhost.3306 connecting 127.0.0.1:3306
2004.11.02 09:24:23 LOG7[632:904]: Remote FD=712 initialized
2004.11.02 09:24:23 LOG7[632:904]: Stunnel manual RSA blinding enabled
2004.11.02 09:24:23 LOG6[632:904]: Negotiated ciphers: EDH-RSA-DES-CBC3-SHA SSLv3 Kx=DH Au=RSA Enc=3DES(168) Mac=SHA1
2004.11.02 09:24:23 LOG7[632:904]: Socket closed on read
2004.11.02 09:24:23 LOG7[632:904]: SSL write shutdown (output buffer empty)
2004.11.02 09:24:23 LOG7[632:904]: SSL closed on SSL_read
2004.11.02 09:24:23 LOG7[632:904]: Socket write shutdown (output buffer empty)
2004.11.02 09:24:23 LOG5[632:904]: Connection closed: 165 bytes sent to SSL, 27 bytes sent to socket
2004.11.02 09:24:23 LOG7[632:904]: localhost.3306 finished (0 left)
Thank you for your time,
David
I'm running MySQL 4.1.7 on Windows 2K Server, and have Stunnel running on that box in server mode, configured to receive encrypted data on port 3307, and output on standard MySQL port 3306. The stunnel client connects, but doesn't pass data. I keep getting "Socket closed on read" after a connection is negotiated. My server-side startup command and log file are below. I've been fighting this for hours, and can't get anywhere. Any guidance would be greatly appreciated.
stunnel-3.26 -p stunnel.pem -d 3307 -r localhost:3306 -o log.txt -D 7
2004.11.02 09:23:59 LOG5[632:1020]: Using 'localhost.3306' as tcpwrapper service name
2004.11.02 09:23:59 LOG7[632:1020]: RAND_status claims sufficient entropy for the PRNG
2004.11.02 09:23:59 LOG7[632:1020]: Seeded PRNG with RAND_screen
2004.11.02 09:23:59 LOG6[632:1020]: PRNG seeded successfully
2004.11.02 09:23:59 LOG7[632:1020]: Using Diffie-Hellman parameters from stunnel.pem
2004.11.02 09:23:59 LOG6[632:1020]: Diffie-Hellman initialized with 512 bit key
2004.11.02 09:23:59 LOG7[632:1020]: Certificate: stunnel.pem
2004.11.02 09:23:59 LOG5[632:1020]: stunnel 3.26 on x86-pc-mingw32-gnu WIN32 with OpenSSL 0.9.5 28 Feb 2000
2004.11.02 09:23:59 LOG5[632:1020]: FD_SETSIZE=4096, file ulimit=-1 (unlimited) -> 2000 clients allowed
2004.11.02 09:23:59 LOG7[632:1020]: SO_REUSEADDR option set on accept socket
2004.11.02 09:23:59 LOG7[632:1020]: localhost.3306 bound to 0.0.0.0:3307
2004.11.02 09:24:23 LOG7[632:1020]: localhost.3306 accepted FD=728 from xx.xx.71.2:55252
2004.11.02 09:24:23 LOG7[632:904]: localhost.3306 started
2004.11.02 09:24:23 LOG5[632:904]: localhost.3306 connected from xx.xx.71.2:55252
2004.11.02 09:24:23 LOG7[632:904]: localhost.3306 connecting 127.0.0.1:3306
2004.11.02 09:24:23 LOG7[632:904]: Remote FD=712 initialized
2004.11.02 09:24:23 LOG7[632:904]: Stunnel manual RSA blinding enabled
2004.11.02 09:24:23 LOG6[632:904]: Negotiated ciphers: EDH-RSA-DES-CBC3-SHA SSLv3 Kx=DH Au=RSA Enc=3DES(168) Mac=SHA1
2004.11.02 09:24:23 LOG7[632:904]: Socket closed on read
2004.11.02 09:24:23 LOG7[632:904]: SSL write shutdown (output buffer empty)
2004.11.02 09:24:23 LOG7[632:904]: SSL closed on SSL_read
2004.11.02 09:24:23 LOG7[632:904]: Socket write shutdown (output buffer empty)
2004.11.02 09:24:23 LOG5[632:904]: Connection closed: 165 bytes sent to SSL, 27 bytes sent to socket
2004.11.02 09:24:23 LOG7[632:904]: localhost.3306 finished (0 left)
Thank you for your time,
David