mysqli with SSL via .env file settings |
Hello,
After reading the relevant docs, I am still having difficulty getting CI to connect to my mysql database with SSL enabled. Does this have to do with my .env formatting? Code: #-------------------------------------------------------------------- I've set ownership on the cert files to myuser:apacheuser and the permissions to 440. These are the same cert files I have downloaded and used successfully connecting to this server with Sequel Pro. What am I missing? Thanks! Evan
I got it. Posting for others:
1) Paths to cert files in `.env` do not need quotes! They're not parsed correctly with quotes, removing them allowed the values to be stored. 2) Increasing my logging threshold to '8' in /App/Config/Logger.php revealed that the mysqli driver was not loading. This led me to discover that when I bumped to php7.4 on this box, php7.4-mysql hadn't been configured correctly. A quick `dpkg -configure` sorted it out. |
Welcome Guest, Not a member yet? Register Sign In |