[squid-users] squid authentication to remote sql server

Amos Jeffries squid3 at treenet.co.nz
Tue Feb 10 20:32:00 UTC 2015


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


More information about the squid-users mailing list