Additional detail - existing passwords seem to work. I started a brand new project and created and admin user and could not log in. I looked at the database record for that user and the password is encrypted
Any help would be greatly appreciated.
KJ Plunkert
I recently upgraded to Phprunner 8. Now an app that was working in phprunner 7 is not working. It will not let users log in.
I am using mysql 5.5 encryption is enabled (see below)
Your MySQL connection id is 36
Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)
mysql> show variables like "%ssl%";
mysql> +---------------+----------------------------+
-> | Variable_name | Value |
-> +---------------+----------------------------+
-> | have_openssl | YES |
-> | have_ssl | YES |
-> | ssl_ca | /etc/mysql/ca-cert.pem |
-> | ssl_capath | |
-> | ssl_cert | /etc/mysql/client-cert.pem |
-> | ssl_cipher | |
-> | ssl_key | /etc/mysql/client-key.pem |
-> +---------------+----------------------------+
I the encryption is turned on for the password field in both the admin user and user table for the password field only. I added an admin user to the app from inside phprunner. The password field encrypts fine. I can not log into that account.
Does anyone have any ideas?
Best Regards
K Plunkert