[squid-users] Re: spaces with helpers

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
Received on Fri May 07 2010 - 22:00:01 MDT