-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Heh. Pure SQL database is VERY bad idea to store any security credentials or ACL's. They too easy to hack. 11.02.15 2:32, Amos Jeffries пишет: > On 11/02/2015 7:24 p.m., Ahmad wrote: >> Thank you amos , but I have an issue with connection : Here is my >> mysql info : ======== grant select on squid.* to 'squid'@'%' >> identified by 'squid'; ===================== mysql> show >> databases; +--------------------+ | Database | >> +--------------------+ | information_schema | | mysql >> | | squid | +--------------------+ 3 rows in set >> (0.00 sec) >> >> mysql> use squid Database changed mysql> ; ERROR: No query >> specified >> >> mysql> show tables; +-----------------+ | Tables_in_squid | >> +-----------------+ | passwd | +-----------------+ 1 row >> in set (0.00 sec) >> >> mysql> select from * passwd; ERROR 1064 (42000): You have an >> error in your SQL syntax; check the manual that corresponds to >> your MySQL server version for the right syntax to use near 'from >> * passwd' at line 1 mysql> select * from passwd; >> +--------+----------+---------+-----------+---------------------+ >> >> | user | password | enabled | fullname | comment | >> +--------+----------+---------+-----------+---------------------+ >> >> | Nikesh | test | 1 | Test User | for testing purpose | >> +--------+----------+---------+-----------+---------------------+ >> >> 1 row in set (0.00 sec) >> > <snip> > >> mysql> =========================================== >> >> now on the squid box , I do the conection below : >> >> here is the connection from remote squid: >> /lib/squid/basic_db_auth --dsn >> "DBI:mysql:database=squid:host=x.x189.177" > > No *semi-colons* in the driver parameters bit. > > --dsn "DBI:mysql:host=x.x189.177;port=3306;database=squid" > > > NP: I also like to order them by significance just in case they > are processed in-order. > > Amos _______________________________________________ squid-users > mailing list squid-users@xxxxxxxxxxxxxxxxxxxxx > http://lists.squid-cache.org/listinfo/squid-users > -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBAgAGBQJU2m16AAoJENNXIZxhPexGIr8IALMxa6Gfh9qGLtE+LPLOozfb YB5U/+QvNMV9/BD4wYD9B9/jTi9DGXOp7QvkG+OM3xB6etR1hOA0/Ppt1OOWY8co Mc4QZhWNHXP+iLoajI6yIeXYQu6I8Hj3rYUbetf80M8j5TiIMivJjNpejGOJcJ76 6j0qwDbvfl/pV7q8qs+b4+gax7oqC8Zc5jHJM8uKwr8tknHfuGlqVTY7QPbYBX+G an2HlaIr/gSY6p3drPCsvY3faprp24o8xuXNEex56558mOAw8dV8R7/7NVfd2bIJ Mig+rYa4BPCEPu9Q8FELOwkiSaYl8c0LsQVvNyx7lptNNywcuj5IETxggflNHyY= =vMtZ -----END PGP SIGNATURE----- _______________________________________________ squid-users mailing list squid-users@xxxxxxxxxxxxxxxxxxxxx http://lists.squid-cache.org/listinfo/squid-users
