Re: [squid-users] Re: spaces with helpers

Luis Daniel Lucio Quiroz wrote:
> Le vendredi 7 mai 2010 16:45:11, Luis Daniel Lucio Quiroz a �crit :
>> /usr/lib64/squid/squid_db_auth --dsn=DBI:mysql:joomla:localhost --user=root
>> -- table=jos15_users --usercol=username --passwdcol=password
>> --cond=block=0 -- plaintext --sql='select jos15_users.password from
>> jos15_users INNER JOIN jos15_acctexp_subscr ON jos15_users.id =
>> jos15_acctexp_subscr.userid WHERE (jos15_acctexp_subscr.status LIKE
>> "Active" OR jos15_acctexp_subscr.status LIKE "Excluded") AND
>> jos15_users.username = ?'
>>
>> this helper in command line works, but when writing it to squid it fails.
>> I know it is bause i add the --sql param but i dont gethow shall i escape
>> that sentense to make it work inside squid
>>
>> any help please?
>>
>> LD
> odd
> this should be documented
>
> spaces should need to be escaped \
> --sql=select\ jos15_users.password\ from\ jos15_users\ INNER\ JOIN\
> jos15_acctexp_subscr\ ON\ jos15_users.id\ =\ jos15_acctexp_subscr.userid\
> WHERE\ \(jos15_acctexp_subscr.status\ LIKE\ \"Active\"\ OR\
> jos15_acctexp_subscr.status\ LIKE\ \"Excluded\"\)\ AND\ jos15_users.username\
> \=\ \?
>
> this is how it works

Shell escaping is only needed if you use incorrect shell quoting.

Note the word shell in all the above.

double quote " for shell parameter quoting around the values passed to
each parameter or they will be broken into multiple parameters.

single quote ' for SQL syntax internal quoting.

What you wrote in your first email was the same as:

squid_db_auth
  --dsn "DBI:mysql:joomla:localhost"
  --user "root"
  --table "jos15_users INNER JOIN jos15_acctexp_subscr ON
jos15_users.id=jos15_acctexp_subscr.userid"
  --usercol jos15_users.username
  --passwdcol jos15_users.password
  --cond "(jos15_acctexp_subscr.status='Active' OR
jos15_acctexp_subscr.status='Excluded') AND block=0"
  --plaintext

Amos

-- 
Please be using
   Current Stable Squid 2.7.STABLE9 or 3.1.3