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)
mysql> show GRANTS FOR 'squid'
-> ;
+------------------------------------------------------------------------------------------------------+
| Grants for squid@% |
+------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'squid'@'%' IDENTIFIED BY PASSWORD '*AFD42D37182BDB40880BEF624CC64B0F4A1E35B4' |
| GRANT SELECT ON `squid`.* TO 'squid'@'%' |
+------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
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" --user "squid" --password "squid" --table "user" --usercol "user" --passwdcol "password" --cond "" --plaintext
DBD::mysql::st execute failed: Table 'squid.user' doesn't exist at /lib/squid/basic_db_auth line 215, <> line 1.
DBD::mysql::st execute failed: MySQL server has gone away at /lib/squid/basic_db_auth line 218, <> line 1.
ERR database error
DBD::mysql::st execute failed: Table 'squid.user' doesn't exist at /lib/squid/basic_db_auth line 215, <> line 2.
DBD::mysql::st execute failed: MySQL server has gone away at /lib/squid/basic_db_auth line 218, <> line 2.
ERR database error
DBD::mysql::st execute failed: Table 'squid.user' doesn't exist at /lib/squid/basic_db_auth line 215, <> line 3.
DBD::mysql::st execute failed: MySQL server has gone away at /lib/squid/basic_db_auth line 218, <> line 3.
ERR database error
DBD::mysql::st execute failed: Table 'squid.user' doesn't exist at /lib/squid/basic_db_auth line 215, <> line 4.
DBD::mysql::st execute failed: MySQL server has gone away at /lib/squid/basic_db_auth line 218, <> line 4.
ERR database error
^C
Selinux , iptables are down on both mahcines .
Any other things we need to look @ ??????
The question is being asked , is it suid or mysql issue??
Wt other thing need to check ?
==========
squid -v
Squid Cache: Version 3.5.1
Service Name: squid
configure options: '--prefix=/usr' '--includedir=/include' '--mandir=/share/man' '--infodir=/share/info' '--sysconfdir=/etc' '--enable-cachemgr-hostname=drx' '--localstatedir=/var' '--libexecdir=/lib/squid' '--disable-maintainer-mode' '--disable-dependency-tracking' '--disable-silent-rules' '--srcdir=.' '--datadir=/usr/share/squid' '--sysconfdir=/etc/squid' '--mandir=/usr/share/man' '--enable-inline' '--enable-async-io=8' '--enable-storeio=ufs,aufs,diskd,rock' '--enable-removal-policies=lru,heap' '--enable-delay-pools' '--enable-cache-digests' '--enable-underscores' '--enable-icap-client' '--enable-follow-x-forwarded-for' '--enable-auth' '--enable-basic-auth-helpers=LDAP,MSNT,NCSA,PAM,SASL,SMB,YP,DB,POP3,getpwnam,squid_radius_auth,multi-domain-NTLM' '--enable-ntlm-auth-helpers=smb_lm' '--enable-digest-auth-helpers=ldap,password' '--enable-negotiate-auth-helpers=squid_kerb_auth' '--enable-esi' '--disable-translation' '--with-logdir=/var/log/squid' '--with-pidfile=/var/run/squid.pid' '--with-filedescriptors=131072' '--with-large-files' '--with-default-user=squid' '--enable-linux-netfilter' '--enable-ltdl-convenience' '--enable-ssl' '--enable-ssl-crtd' '--enable-arp-acl' 'CXXFLAGS=-DMAXTCPLISTENPORTS=20000' '--with-openssl' '--enable-snmp'
[root@squid ~]#
==================================
Thanks again for help
-----Original Message-----
From: squid-users [mailto:squid-users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Amos Jeffries
Sent: Monday, February 9, 2015 4:15 PM
To: squid-users@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: squid authentication to remote sql server
On 10/02/2015 5:01 p.m., Ahmad wrote:
> Hi ,
>
> I followed the article in :
>
> http://wiki.squid-cache.org/ConfigExamples/Authenticate/Mysql
>
>
>
>
>
> I need to connect squid to external sql server , what do I need to
> modify in the helper command ?
>
>
>
> I think that the command below :
>
> ""auth_param basic program /usr/local/squid/libexec/squid_db_auth
> --user someuser --password xxxx --plaintext --persist
>
>
>
> Shoud include the ip & port of the sql server .
>
The Data Source Name (--dsn) parameter is the option string passed to the Perl DBI module for locating the database to use.
It takes the syntax:
"DSN:" driver ":" params
The params bit depends on what database driver (type) is. The "mysql"
driver uses semi-colon separated key=value pairs.
So you can write something like:
--dsn "DSN:mysql:host=example.com;port=3306;database=squid"
Amos
_______________________________________________
squid-users mailing list
squid-users@xxxxxxxxxxxxxxxxxxxxx
http://lists.squid-cache.org/listinfo/squid-users
_______________________________________________
squid-users mailing list
squid-users@xxxxxxxxxxxxxxxxxxxxx
http://lists.squid-cache.org/listinfo/squid-users
