[squid-users] squid authentication to remote sql server

[snakeeyes]

Hi Amos , 

Shoudnt the user tested is the user that I gave him the grant ???

I mean I gave grant for user/pwd ==>squid/squid

Now how to test it ?

Shoudnt I test with squid/squid ?? or test with user in db ???
I mean I used :
/lib/squid/basic_db_auth --dsn "DBI:mysql:database=squid:xx189.177" --user "squid" --password "squid" --table "squid" --usercol "user" --passwdcol "password"


Shoud I use :

/lib/squid/basic_db_auth --dsn "DBI:mysql:database=squid:xx189.177" --user "Nikesh" --password "test" --table "squid" --usercol "user" --passwdcol "password"

??

Anyway I used both methods above and didn’t work and gave me error login

Also I created another user with small letter and tried with same string above and still error login.

I logged locally to the mysql and applied the command :
/lib/squid/basic_db_auth --dsn "DBI:mysql:database=squid:xx189.177" --user "squid" --password "squid" --table "squid" --usercol "user" --passwdcol "password"


And still not working !!!

In access.log ==> is says access denied 


Wt do  you think Amos ?

Try another squid verson ? or wt ?


-----Original Message-----
From: Amos Jeffries [mailto:squid3 at treenet.co.nz] 
Sent: Friday, February 13, 2015 1:54 PM
To: snakeeyes; squid-users at lists.squid-cache.org
Subject: Re: [squid-users] squid authentication to remote sql server

On 14/02/2015 5:35 p.m., snakeeyes wrote:
> Hi Amos , can you chk below plz ?
> 
> 
> mysql> select * from squid ;
> +--------+----------+---------+-----------+---------------------+
> | user   | password | enabled | fullname  | comment             |
> +--------+----------+---------+-----------+---------------------+
> | Nikesh | test     |       1 | Test User | for testing purpose |
> +--------+----------+---------+-----------+---------------------+
> 1 row in set (0.00 sec)
> 
> 
> ==========================
> here is tesing from the remote squid machine using the helper :
> /lib/squid/basic_db_auth --dsn "DBI:mysql:database=squid:xx189.177" --user "squid" --password "squid" --table "squid" --usercol "user" --passwdcol "password"
> 
> ERR unknown login
> ERR unknown login
> ERR unknown login
> 

The username tested for does not exist in the database.

You dont show what input you typed, so I cannot be certain why the manual test gives that result. However looking at your access.log lines...

> Agia I put the user/pwd in y browser with ni luck , each time it refuse my connection .
> 
> Here is access.log :
> 1423799039.114   1072 192.168.1.6 TCP_DENIED/407 4197 CONNECT developer.mozilla.org:443 nikesh HIER_NONE/- text/html

This user has logged in with username "nikesh". The database contains "Nikesh" with an upper case 'N' character.

Try with typing the same case, and if that dont work with lower case username in the database.

Amos