[squid-users] helperHandleRead: unexpected read

[Amos Jeffries]

On 1/11/19 7:15 pm, 499258179 wrote:
> Following is my php script, can u check for me, it is looks like  only one
> line stdout

How have you tested it?

Your explicit fwrite calls look okay for the expected outputs. But are
they actually the only things producing output?

With PHP any of the functions you call can produce things that the
engine puts on stdout (eg errors, but also debug info) if any one of the
many background config file(s) says to.


FWIW: Have you considered using the DB session helper bundled with Squid?

Something like the below should do the same as your current helper.
Double check the --cond syntax, it has been a while since I dealt with
MySQL timestamp math.


external_acl_type guests %un /usr/lib/squid/ext_sql_session_acl \
  --dsn DBI:mysql:database=test:localhost:3306 --persist \
  --user test --password test \
  --table MyGuests --uidcol username \
  --cond "NOW() < DATETIME_ADD(reg_date, INTERVAL 720 HOUR)"


Amos