Scenario : - MYSQL PAM Authentication in SAFESQUID.
PROBLEM : -
(/VAR/AUTH.LOGS)
Nov 20 02:17:47 swg safesquid: pam_unix(safesquid:auth): check pass; user unknown
Nov 20 02:17:47 swg safesquid: pam_unix(safesquid:auth): authentication failure; logname=root uid=999 euid=999 tty= ruser= rhost=
STEPS I HAVE FOLLOWED :
- CREATED ONE TEST USER IN MYSQL DATABASE SAFESQUID WITH COLUMN LOGIN_NAME AND PASSWORD IN USER TABLE ;
- MADE CONFIG FILE IN /etc/pam_mysql.conf file
- Added pam_mysql.so in /etc/pam.d/safesquid file
I have also changed the owner of pam_mysql.conf owner ssquid;
Last Step Created Access Restriction Rule on safesquid.cfg
Configure → Application setup → Access Restriction
IP address = 192.168.163.164
Pam Authentication = TRUE
username = test (this user is in SAFESQUID Database user table)
Please guide me what mistake i have doing.
this Error I am getting in auth.log
Nov 23 01:10:02 swg safesquid: message repeated 7 times: [ pam_mysql - MySQL error (Access denied for user ‘root’@‘localhost’ (using password: YES))]
Nov 23 01:12:50 swg safesquid: pam_mysql - MySQL error (Access denied for user ‘root’@‘localhost’ (using password: YES))
Nov 23 01:13:00 swg safesquid: message repeated 8 times: [ pam_mysql - MySQL error (Access denied for user ‘root’@‘localhost’ (using password: YES))]
