[squid-users] squid authentication to remote sql server

[Yuri Voinov]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Wow, it just cannot connect with DB?!

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

iQEcBAEBAgAGBQJU2muCAAoJENNXIZxhPexGwVUH/3GLWgF+hvm2EKIFI5FN/GI0
tPf7+GmRn+/5Aq3qVJxPUll363Q5jxw8eCRG17Z1W/oqsncjZW3VNYbBUwtCLazj
5MsRaMYkQdhmgLhkRCH2uTiOKfeen76BySrhYm6lb09A9be40JbMwhpVwBAyREdj
Dx7u4LFdgUyEWPTOLXxZmZ+3vaO1egidxhf55+yUOXKyuUVFqlSc3bVRiIqUaPq8
qCxSwVDJrUcXB5UOLSttugftTh3zmm/HVg9JDC6G6N2CL6vm8jmCntIKvO5YcQrH
eIcjbnSlFbuvOPe1kOMyP+zqgciCscGdv9XKVUySDILdrWEKs+aazJ9HSQVvBIY=
=Hz+L
-----END PGP SIGNATURE-----