On 11/02/2015 8:17 p.m., Ahmad wrote: > Thank you amos , I fixed the table thing , but I have new error now : > > /lib/squid/basic_db_auth --dsn > "DBI:mysql:host=x.xx..189.177;port=3306;database=squid" --user "squid" > --password "squid" --table "passwd" --usercol "user" --passwdcol "password" > --cond "" --plaintext > > ERR unknown login > ERR unknown login > ERR unknown login > ERR unknown login > ERR unknown login > > > Wt do u think ?? > Mysql issue ?
Input issue. Thats a user:password combination being presented that does not exist in the table. Though it might be mysql interpreting the "password" in queries as the built-in password() function. I renamed that column to "token" in my auth DB. And like Yuri pointed out a DB of passwords in clear-text is not the greatest of security. At minimum use salted MD5 for the final setup. Amos _______________________________________________ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
