Hello/Hi/Greetings,

Ok. I'm dealing with the Apache error/access log files.

I have successfully got pipes working with the Errorlog directive.

What I'm not getting to work is the values in the %_ variables. My sql statement is posting to the database %a, %u %s and %b....

What I need is the values held by these variables.

ErrorLog  "|/www/cgi-bin/httpd-error.pl"       This line of code works. Tosses out control to the perl program specified.

my $sql    =    'Insert into httpd_errors (Remote_Host, User_id, Hyphen, Current_Action) VALUES( "%a", "%u", "%s", "%b")';   

This line of code does not post the values of the variables %a to the database. What it does post to the database is %a , %u, %s, %b  .....as literals.

I'm looking for the key to making sure I can post the contents of variables %a, %u, %s and %b.    Do you have a line of code like this that does work ?

I'd like to see it . In the meantime, I'll go look at perl.


Piwigo version: 10.1
PHP version: 7.2
MySQL version: 5.7