Page 1 of 1

auto parse

Posted: Sat May 16, 2009 6:48 pm
by strike
hi, i am reposting this thread cause for some reason it was deleted.


i am trying to find out how to auto parse the files from my server. i know there is an option in the maiun config but it doesn't seem to actually work.. here is my info


UTStatsDB version current
Operating system and version linux
Database type and version MySQL version: 5.0.27-std
PHP version 5.2.6
Web server and version hosted
Unreal Tournament version current
Stat logger type and version utstats current

hope this is good.. i didn't post those specs on the first post but i didn't realize i was supposed to..

Re: auto parse

Posted: Sat May 16, 2009 7:06 pm
by Panther
If you're talking about UT3 then the best solution on a Linux platform is via a cron job (or possibly two, depending on the configuration). Simply run the logs.php script using the command-line arguments. If your web server and UT server are running as the same user this is simple, if not, then the permissions must first be changed for the log files to be accessible by the web server.

Re: auto parse

Posted: Sun May 17, 2009 11:50 am
by Welx
Simply run the logs.php script using the command-line arguments. If your web server and UT server are running as the same user this is simple, if not, then the permissions must first be changed for the log files to be accessible by the web server.
How do you run the logs.php and what are the command-line arguments to use to parse the logs?
Are there instructions available somewhere (no instructions came with UTStatsDB)?

I'm trying to run the logs in my own Windows-based PC.

Welx

Re: auto parse

Posted: Sun May 17, 2009 2:14 pm
by Panther
Documentation is in the docs directory in the standard release or www/docs in the standalone version.
In Windows you would use the task scheduler to auto-parse logs.

Re: auto parse

Posted: Mon May 18, 2009 6:31 am
by strike
i did look in the docs folder but found nothing to help out.

maybe if you tell me witch one i should lok at and what i'm missing if possible?

thank you

Re: auto parse

Posted: Mon May 18, 2009 9:24 am
by Panther
i did look in the docs folder but found nothing to help out.

maybe if you tell me witch one i should lok at and what i'm missing if possible?
I highly recommend reading all of them.

Re: auto parse

Posted: Tue May 19, 2009 4:11 am
by FlyveHest
On a Windows box, you will need an external tool to "trigger" the parse, I use cURL, which works perfectly (note, cURL can do a LOT more than just trigger a webpage, but, its small, efficient, and works.

You can get it here

http://curl.haxx.se/latest.cgi?curl=win32-nossl

Then, make a bat file that looks somewhere along the lines of this

Code: Select all

curl http://<URL-TO-STATS-SITE>/logs.php?pass=<LOG-PARSE-PASSWORD>
Use Task Scheduler to make the bat file run every so often, and hey-presto, automatic parsing.

Re: auto parse

Posted: Tue May 19, 2009 4:17 am
by Panther
There's usually no need to go through the web server - simply run PHP directly.

Code: Select all

php logs.php pass=<LOG-PARSE-PASSWORD> nohtml

Re: auto parse

Posted: Tue May 19, 2009 5:55 pm
by strike
thank you for the help but i have no clue when it comes to this kinda stuff..thats why i was asking for a bit more. but i understand any help i get i am greatful for anyways ..

Re: auto parse

Posted: Fri May 22, 2009 1:02 pm
by horndog
There's usually no need to go through the web server - simply run PHP directly.

Code: Select all

php logs.php pass=<LOG-PARSE-PASSWORD> nohtml
Will that work on a non host machine with out php installed and with no access to www file tree?

Re: auto parse

Posted: Fri May 22, 2009 1:26 pm
by Panther
Will that work on a non host machine with out php installed and with no access to www file tree?
Not really.

Re: auto parse

Posted: Wed Dec 23, 2009 12:40 am
by shumm
Please help.
If to do, the statistics gathers
(http://xxx.xxxxx.xxx/admin.php?action=parselogs)

At use auto parse
(php logs.php pass=ххххххххх nohtml)

error

Code: Select all

Processing log 'Stats-7777-20091223.092136.log'...*Error in database query: 'REPLACE INTO ut_players VALUES ( 12, 'RAWLEX', 0, 2,8,2,0,0, 0,0, 0,0,0,0, 0,0,0, '', '', '187563331', '94.41.143.45', 20000, 0, 1,14137, 0,000141472731131,0,000565890924524,1, 0,0,1, 0,0,0,0,0,0,0, 0,0,0, 0,0,0, 0,0,0, 0,0,0, 0,0,0, 0,0,0, 0,0,0,0, 0,0,0, 0, 0,0,0, 0,0,0)' 1136: Column count doesn't match value count at row 1 Error saving player data in database.

Re: auto parse

Posted: Fri Jan 29, 2010 6:38 am
by CVROY
shumm, try this

Code: Select all

http://your-url-here/utstats/logs.php?pass=parse-password
That will parse the logs providing that they are on you web server in the logs directory you specified in the logs configuration of utstatsdb. In the same log configuration section you can set it up in there to pull your logs via FTP from your game server to your logs directory on your web server using the above command as well.