-----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@xxxxxxxxxxxxxxxxxxxxx > 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----- _______________________________________________ squid-users mailing list squid-users@xxxxxxxxxxxxxxxxxxxxx http://lists.squid-cache.org/listinfo/squid-users
