Hi, I am trying to set up MySQL with openssl on linux 9.
first, I installed openss-0.9.7.b at default location usr/local/ssl second, I installed MySQL using source installation, config --with-vio --with-openssl then, I followed every step on manual 4.3.10.3 Setting Up SSL Certificates for MySQL last, I modified my.cnf file [mysqld] ... ssl-ca=/openssl/cacert.pem ssl-cert=/openssl/server-cert.pem ssl-key=/openssl/server-key.pem [client] ... ssl-ca=/openssl/cacert.pem ssl-cert=/openssl/client-cert.pem ssl-key=/openssl/client-key.pem Everything went very smoothly up to this point, then I start to try to start MySQL from /etc/init.d/ using ./mysql start something weird happened: [shell]# Starting mysqld daemon with databases from /usr/local/mysql/data Enter PEM pass phrase: BUT, MySQL just started without waiting for me to enter PEM pass phrase even it asked for it... And when I tried to connect to MySQL, both user I set up earlier, one require SSL, the other does not, can not connect to MySQL. [shell]# bin/mysql -u user -p Enter password: Enter PEM pass phrase: I got one line of error msg: "ERROR 2026: SSL connection error", this time it did wait for me to enter PEM pass phrase and I entered the PEM pass phrase I used when I set up the /openssl/client-key.pem. Anyone can help? I am in the dark here. Thanks in advance. Xinyi __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]