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]

Reply via email to