Results 1 to 1 of 1
I've been trying to enable it, the mysql site says if you have it disabled, when you run this:
SHOW VARIABLES LIKE 'have_openssl';
which we do, you need to enable ...
- 05-21-2009 #1Just Joined!
- Join Date
- Feb 2009
- Posts
- 9
SSL on mysql
I've been trying to enable it, the mysql site says if you have it disabled, when you run this:
SHOW VARIABLES LIKE 'have_openssl';
which we do, you need to enable it, by running this:
shell> mysqld --ssl-ca=cacert.pem \
--ssl-cert=server-cert.pem \
--ssl-key=server-key.pem
I have created the certificates and the my.cnf points, via a full path to them, when I run the above I get the follwing error:
090521 12:11:47 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
090521 12:11:47 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
090521 12:11:48 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
090521 12:11:48 [ERROR] Do you already have another mysqld server running on port: 3306 ?
090521 12:11:48 [ERROR] Aborting
090521 12:11:49 [Note] mysqld: Shutdown complete
No searches have returned any useful results, my thoughts are that it means mysql is still running, but to my knowledge is that it is not, if i run it again after the above 'Shutdown complete' message, I get the same result.
I'm on an ubuntu Jaunty and 5.0.75-0ubuntu10
Thanks


Reply With Quote