-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 (facepalm) 11.02.15 13:40, snakeeyes пишет: > Hi amos I hadded squi/squid in the table > > mysql> show tables -> ; +-----------------+ | Tables_in_squid | > +-----------------+ | passwd | +-----------------+ 1 row > in set (0.00 sec) > > mysql> select * from passwd; > +--------+----------+---------+-----------+---------------------+ | > user | password | enabled | fullname | comment | > +--------+----------+---------+-----------+---------------------+ | > Nikesh | test | 1 | Test User | for testing purpose | | > squid | squid | 1 | Test User | for testing purpose | > +--------+----------+---------+-----------+---------------------+ 2 > rows in set (0.00 sec) > > mysql> > > > > still has same error ? > > > > how can u help me ? login with md5 or wt ?? Of course, no. > > > -----Original Message----- From: Amos Jeffries > [mailto:squid3@xxxxxxxxxxxxx] Sent: Tuesday, February 10, 2015 1:29 > PM To: Ahmad; squid-users@xxxxxxxxxxxxxxxxxxxxx Subject: Re: > squid authentication to remote sql server > > 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@xxxxxxxxxxxxxxxxxxxxx > http://lists.squid-cache.org/listinfo/squid-users > -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBAgAGBQJU2nx0AAoJENNXIZxhPexGt0cH/3JsKrG62EZryBe6fAjtxxXW mJ505t31637yV5ajjn52jN+drwj+Xm+BvW/I9zaM9Xj3apf8cw6V0wM/JTNjdsr3 VFt+QHH8ZOIy+TpMbriEcl0VIxG1F9TRi7WR/O6DbLe3uyhKbj4pdsgYTs/aho8i uzwWMDnnejWrN0ekT4YuC5ewTwild6rmJUxbwxWlHOLAsPut1ZqWPp0/3UPgElDJ B/8pUIUq05BAaoK2TQwHsobyYUltVyLUK2DFgzd3uGf2Kkpfp1Z1MGrG8tkQKKcj FBSwWijRot4Or//EgQWx9qMaq78XHJHCkPwJCJ7qWPHcOxR337m1dTfxdD5y0b8= =bc1A -----END PGP SIGNATURE----- _______________________________________________ squid-users mailing list squid-users@xxxxxxxxxxxxxxxxxxxxx http://lists.squid-cache.org/listinfo/squid-users
