tech.safesquid.com

Posted: **Fri Nov 19, 2021 9:29 pm**

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=

: Screenshot (80).png (258.49 KiB) Viewed 2693 times

STEPS I HAVE FOLLOWED :

1. CREATED ONE TEST USER IN MYSQL DATABASE SAFESQUID WITH COLUMN LOGIN_NAME AND PASSWORD IN USER TABLE ;

: Screenshot (78).png (88.78 KiB) Viewed 2693 times

2. MADE CONFIG FILE IN /etc/pam_mysql.conf file

: Screenshot (77).png (70 KiB) Viewed 2693 times

3. Added pam_mysql.so in /etc/pam.d/safesquid file

: Screenshot (81).png (121.85 KiB) Viewed 2676 times

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)

: Screenshot (83).png (175.92 KiB) Viewed 2643 times

Please guide me what mistake i have doing.

Posted: **Mon Nov 22, 2021 7:51 pm**

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))]

: Screenshot (82).png (238.38 KiB) Viewed 2675 times

Posted: **Mon Dec 06, 2021 9:31 am**

Looks like the database on MySQL needs to be given proper permissions.
Did you validate the credemtials for user@localhost?

Recommend use of pamtester for validating PAM related setup.
http://pamtester.sourceforge.net/

Posted: **Mon Dec 06, 2021 11:37 am**

Hello Sir ,
I have tried with default user table of mysql

I am able to log in mysql by using those user and password in my local system

I will show share screen shot with you