MySQL Forums
Forum List  »  Security

Re: SSL don't work
Posted by: Blue Phaz
Date: February 13, 2014 08:49AM

> Start the server in a command prompt console (check the --console option to mysqld.exe) and see if the error is gone. If this works this means that whatever user is running the mysqld service can't open the keys.

foo.bat:
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --console

console output:
C:\Users\Administrator\Desktop>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld"
--defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --console
2014-02-13 16:10:10 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).

error log:
2014-02-13 16:10:10 180640 [Note] Plugin 'FEDERATED' is disabled.
2014-02-13 16:10:10 180640 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2014-02-13 16:10:10 258d0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-02-13 16:10:10 180640 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-13 16:10:10 180640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-02-13 16:10:10 180640 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-13 16:10:10 180640 [Note] InnoDB: Not using CPU crc32 instructions
2014-02-13 16:10:10 180640 [Note] InnoDB: Initializing buffer pool, size = 57.0M
2014-02-13 16:10:10 180640 [Note] InnoDB: Completed initialization of buffer pool
2014-02-13 16:10:10 180640 [Note] InnoDB: Highest supported file format is Barracuda.
2014-02-13 16:10:10 180640 [Note] InnoDB: The log sequence numbers 8526943 and 8526943 in ibdata files do not match the log sequence number 8527003 in the ib_logfiles!
2014-02-13 16:10:10 180640 [Note] InnoDB: Database was not shutdown normally!
2014-02-13 16:10:10 180640 [Note] InnoDB: Starting crash recovery.
2014-02-13 16:10:10 180640 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-02-13 16:10:10 180640 [Note] InnoDB: Restoring possible half-written data pages
2014-02-13 16:10:10 180640 [Note] InnoDB: from the doublewrite buffer...
2014-02-13 16:10:11 180640 [Note] InnoDB: 128 rollback segment(s) are active.
2014-02-13 16:10:11 180640 [Note] InnoDB: Waiting for purge to start
2014-02-13 16:10:11 180640 [Note] InnoDB: 5.6.14 started; log sequence number 8527003
SSL error: Unable to get private key from 'C:/server-key.pem'
2014-02-13 16:10:11 180640 [Warning] Failed to setup SSL
2014-02-13 16:10:11 180640 [Warning] SSL error: Unable to get private key
2014-02-13 16:10:11 180640 [Note] Server hostname (bind-address): '*'; port: 2013
2014-02-13 16:10:11 180640 [Note] IPv6 is available.
2014-02-13 16:10:11 180640 [Note] - '::' resolves to '::';
2014-02-13 16:10:11 180640 [Note] Server socket created on IP: '::'.
2014-02-13 16:10:11 180640 [Note] Event Scheduler: Loaded 0 events
2014-02-13 16:10:11 180640 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld: ready for connections.
Version: '5.6.14-log' socket: '' port: 2013 MySQL Community Server (GPL)



Edited 4 time(s). Last edit at 02/13/2014 09:11AM by Blue Phaz.

Options: ReplyQuote


Subject
Views
Written By
Posted
5035
February 06, 2014 12:44PM
2244
February 07, 2014 08:23AM
2269
February 07, 2014 09:43AM
2142
February 07, 2014 10:07AM
2800
February 13, 2014 07:13AM
2240
February 13, 2014 07:47AM
2283
February 13, 2014 08:10AM
2230
February 13, 2014 08:33AM
Re: SSL don't work
2433
February 13, 2014 08:49AM
2119
February 13, 2014 09:08AM
2186
February 13, 2014 09:24AM
2148
February 14, 2014 02:16AM
2211
February 19, 2014 07:28AM
1949
February 19, 2014 08:15AM
2687
February 19, 2014 09:17AM
1950
February 19, 2014 09:32AM
3628
February 19, 2014 09:57AM
2208
February 19, 2014 10:00AM
2643
February 20, 2014 02:40AM
2189
February 20, 2014 02:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.