[squid-users] squid authentication to remote sql server

[Yuri Voinov]

-----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 at lists.squid-cache.org 
> 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-----