Announcement

  •  » Off topic
  •  » For those playing with the Apache 2.4 web server and mysql.

#1 2020-08-10 06:58:53

Alexander83706
Member
Boise
2019-07-07
67

For those playing with the Apache 2.4 web server and mysql.

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

Offline

 
  •  » Off topic
  •  » For those playing with the Apache 2.4 web server and mysql.

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2020 · Contact