rejetto forum

Log to db

Guest · 25 · 14666

0 Members and 1 Guest are viewing this topic.

Offline rejetto

  • Administrator
  • Tireless poster
  • *****
    • Posts: 13510
    • View Profile
Quote
What would work best, is log output that indicates real downloads and uploads, different from the pages. Kinda like the "fully uploaded/downloaded" in the regular log.

that's quite possible, indeed %z will show you only fully uploaded, and i can make it show an information about the file being fully downloaded

Quote
Would it be possible to add
Code: [Select]
%{format}t and maybe failed logins and bans to apache?

can you point me to documentation of the format?

Quote
Also, could someone check the ban to regular log? It doesn't seem to be working here.

can you tell me how to reproduce the problem?


Offline r][m

  • Tireless poster
  • ****
    • Posts: 347
    • View Profile
Quote
can you point me to documentation of the format?
These probably won't be very helpful but its where I read of this.
http://www.cs.washington.edu/lab/sw/apache/manual/mod/mod_log_config.html
http://publib.boulder.ibm.com/httpserv/manual60/programs/rotatelogs.html
Quote
can you tell me how to reproduce the problem?
I'm testing with my LAN Ip. I get the "Banned" page, and I have Banned checked in the
"Log What" menu, for regular log, but there was no log entry of the occurance. I'm using
my own template.
Can't think what else to check at the moment.


Offline r][m

  • Tireless poster
  • ****
    • Posts: 347
    • View Profile
Log file update
I found a free log analyzer prog that works, then I found out why the
others I tried didn't. It was a apache log thing, not HFS.
I'm using WebLog Expert Lite from
http://www.weblogexpert.com/
Apache log must be like this.
%h %l %u %t "%r" %>s %b "%{Referer}i" "%{User-Agent}i"
Its out put is .htm so it can be included as a page, but it must be
updated manually. It shows a great deal of info but not user names, just IP.
Found another - Analog 6.0 - that is extremely configurable, and will show
and chart user.
I plan to test others.
Now I wonder if new symbols are added in apache style log, will these progs be able
to use them?
The bad news is that these analyzers need the quotes (") to work
so I'm stuck with a string like "GET /Main/ HTTP/1.1".  The data base that I'm
also working with (Access) uses quotes in its language so it wont break it down furthur.
 Looking for a Access work around for that.


Offline rejetto

  • Administrator
  • Tireless poster
  • *****
    • Posts: 13510
    • View Profile
i think today i will publish the new beta build, with enhanced apache log support
Posted on: 24 July 2008, 12:45:13
r][m check the new build and let me know


Offline r][m

  • Tireless poster
  • ****
    • Posts: 347
    • View Profile
Quote
r][m check the new build and let me know
Code: [Select]
%>s "%{Referer}i" and "%{User-Agent}i" didn't work in 193 ?
All I seemed to get from %z was -   No uploaded file info
Maybe I don't understand how to use %z?
Went back to 192 for the moment and everything works again.


Offline rejetto

  • Administrator
  • Tireless poster
  • *****
    • Posts: 13510
    • View Profile

Offline r][m

  • Tireless poster
  • ****
    • Posts: 347
    • View Profile
Quote
sorry, recheck with latest one
No problem, part of developing and testing I think  ;D
Apache log format in 194 works as
%h %l %u %t "%r" %>s %b "%{Referer}i" "%{User-Agent}i" %z
Putting %z last allows log analyzer progs to still work. Any
where else in the format causes problems. Of course log analyzer prog
doesn't recognize %z, but Analog 6.0 can use a custom log format, so...I'll work on it,
db doesn't care as long as it finds a space.
Results look like:
192.168.1.140 - user [27/Jul/2008:13:01:56 -0500] "POST /Server/Up_Load/ HTTP/1.1" 200 550 "http.//192.168.1.140:xxxx/Server/Up_Load/~upload" "Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Avant Browser)" Blue Oyster Cult- Don't Fear The Reaper.ape
Thanks
r][m


Offline r][m

  • Tireless poster
  • ****
    • Posts: 347
    • View Profile
I notice HFS only returns Status 200 in apache log, even though
a 401 or 403 error page had been returned ? (testing on lan)
Is this expected behavior, or would it be possible for HFS to log
errors?
r][m
« Last Edit: August 15, 2008, 03:40:20 PM by r][m »


Offline rejetto

  • Administrator
  • Tireless poster
  • *****
    • Posts: 13510
    • View Profile
it may be related to the "only served requests" in the log menu.
check it.


Offline r][m

  • Tireless poster
  • ****
    • Posts: 347
    • View Profile
Quote
it may be related to the "only served requests" in the log menu.
check it.
Sorry, should have known that.
It works now. Many thanks.