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
