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@xxxxxxxxxxxxx] Sent: Friday, February 13, 2015 1:54 PM To: snakeeyes; squid-users@xxxxxxxxxxxxxxxxxxxxx Subject: Re: 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 _______________________________________________ squid-users mailing list squid-users@xxxxxxxxxxxxxxxxxxxxx http://lists.squid-cache.org/listinfo/squid-users
