1 year ago

HTTPS not working with MYSQL

Posted 1 year ago by byterbit

HTTPS not working with MYSQL.

I just got a SSL certificate for my Ubuntu hosted Laravel site. Now I can’t log in on HTTPS (Larvel auth uses MYSQL)

I can still log in using just the IP address. What must I do? I assume I must adjust Laravel to use secure MYSQL? Or not? This is my primary question.

In fishing around (can’t find anything definitive on Laravel sites) on how to deal with this:

  1. Using the the mysql_ssl_rsa_setup utility I made MYSQL certificates and keys. This looks OK but I still cant log in on HTTPS

So I looked into changing the database config file and I added

'options' => array( PDO::MYSQL_ATTR_SSL_CA => '/var/lib/mysql/ca-cert.pem', PDO::MYSQL_ATTR_SSL_CERT => '/var/lib/mysql/client-cert.pem', PDO::MYSQL_ATTR_SSL_KEY => '/var/lib/mysql/client-key.pem' )

but I still cant log in on a HTTPS URL. Again, am I on the right track at all? In using HTTPS must I now then use secure MYSQL?

Please sign in or create an account to participate in this conversation.