On 15/02/2015 8:25 a.m., snakeeyes wrote:
> Hi Amos ,
>
> Shoudnt the user tested is the user that I gave him the grant ???
The 'user' who got a SQL "GRANT" is the software user whch is allowed to
acccess the DB contents. That should only be Squid and/or your sysadmin
who changes users records.
g ==> is says access denied
Wt do you think Amos ?
Try another squid verson ? or wt ?
-Original Message-
From: Amos Jeffries [mailto:squ...@treenet.co.nz]
Sent: Friday, February 13, 2015 1:54 PM
To: snakeeyes; squid-users@lists.squid-cache.
On 14/02/2015 5:35 p.m., snakeeyes wrote:
> Hi Amos , can you chk below plz ?
>
>
> mysql> select * from squid ;
> ++--+-+---+-+
> | user | password | enabled | fullname | comment |
> ++--+-+---+---
http://yahoo.com/
nikesh HIER_NONE/- text/html
1423799270.459 1556 192.168.1.6 TCP_DENIED/407 4194 GET http://yahoo.com/
nikesh HIER_NONE/- text/html
Any help ??
Should shoud I try more ?
-Original Message-
From: Amos Jeffries [mailto:squ...@treenet.co.nz]
Sent: Tuesday,
On 11/02/2015 8:40 p.m., snakeeyes wrote:
> Hi amos
> I hadded squi/squid in the table
>
> mysql> show tables
> -> ;
> +-+
> | Tables_in_squid |
> +-+
> | passwd |
> +-+
> 1 row in set (0.00 sec)
>
> mysql> select * from passwd;
> +
?
>
>
>
> how can u help me ? login with md5 or wt ??
Of course, no.
>
>
> -Original Message- From: Amos Jeffries
> [mailto:squ...@treenet.co.nz] Sent: Tuesday, February 10, 2015 1:29
> PM To: Ahmad; squid-users@lists.squid-cache.org Subject: Re:
> [squid-users] squi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Amos, MD5 insufficient. As minimum, SHA256 with salt. New Oracle RDBMS
use SHA to store user's password.
And don't forget about SQL Injection and password cracking farms..
11.02.15 3:28, Amos Jeffries пишет:
> On 11/02/2015 8:17 p.m., Ahmad w
id-cache.org
Subject: Re: [squid-users] squid authentication to remote sql server
On 11/02/2015 8:17 p.m., Ahmad wrote:
> Thank you amos , I fixed the table thing , but I have new error now :
>
> /lib/squid/basic_db_auth --dsn
> "DBI:mysql:host=x.xx..189.177;port=3306;database=squid&
On 11/02/2015 8:17 p.m., Ahmad wrote:
> Thank you amos , I fixed the table thing , but I have new error now :
>
> /lib/squid/basic_db_auth --dsn
> "DBI:mysql:host=x.xx..189.177;port=3306;database=squid" --user "squid"
> --password "squid" --table "passwd" --usercol "user" --passwdcol "password"
ad; squid-users@lists.squid-cache.org
Subject: Re: [squid-users] squid authentication to remote sql server
Replying again because I missed the --table parameter value earlier.
On 11/02/2015 7:24 p.m., Ahmad wrote:
> Thank you amos , but I have an issue with co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
As I think, this is around DB. Not squid. :) Just misconfiguration.
11.02.15 2:44, Amos Jeffries пишет:
> On 11/02/2015 9:35 a.m., Yuri Voinov wrote:
>> Wow, it just cannot connect with DB?!
>
>
> Maybe, maybe not, maybe its connecting to the localh
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/02/2015 9:35 a.m., Yuri Voinov wrote:
> Wow, it just cannot connect with DB?!
>
Maybe, maybe not, maybe its connecting to the localhost instead of
remote (he had a localhost test earlier). I just spotted table names
were different too.
Amos
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Heh. Pure SQL database is VERY bad idea to store any security
credentials or ACL's. They too easy to hack.
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
Replying again because I missed the --table parameter value earlier.
On 11/02/2015 7:24 p.m., Ahmad wrote:
> Thank you amos , but I have an issue with connection :
> mysql> select * from passwd;
===> notice the TABLE NAME.
> ++--+-+---+-+
-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'@'%'
>> i
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 |
> +-
'
> '--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'
> '--e
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&#x
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 co
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/squ
20 matches
Mail list logo
