wanna know how can i connect user database that on phpmyadmin database?
got this script but when im going to create user using mysql it was succesful but trying to create in phpmyadmin panel it was not although i guess they're sharing same database.auth sufficient pam_mysql.so \
user=openvpn passwd=openvpn host=localhost db=openvpn \
table=user usercolumn=username passwdcolumn=password \
where=active>online sqllog=0 crypt=1
account required pam_mysql.so \
user=openvpn passwd=openvpn host=localhost db=openvpn \
table=user usercolumn=username passwdcolumn=password \
where=active>online sqllog=0 crypt=1
thanks i hope someone could translate what's wrong.
here's the log on /var/log/auth.log
Sep 11 12:30:40 tiger sshd[11999]: pam_env(sshd:setcred): Unable to open env file: /etc/default/locale: No such file or directory
Sep 11 12:32:50 tiger sshd[8029]: pam_unix(sshd:session): session closed for user root
Sep 11 12:32:50 tiger sshd[8029]: pam_env(sshd:setcred): Unable to open env file: /etc/default/locale: No such file or directory
Sep 11 12:33:31 tiger sshd[23665]: Accepted password for root from x.x.x.x port 2767 ssh2
Sep 11 12:33:31 tiger sshd[23665]: pam_env(sshd:setcred): Unable to open env file: /etc/default/locale: No such file or directory
Sep 11 12:33:31 tiger sshd[23665]: pam_unix(sshd:session): session opened for user root by (uid=0)
Sep 11 12:33:35 tiger sshd[25688]: pam_env(sshd:setcred): Unable to open env file: /etc/default/locale: No such file or directory