UTStats not Parsing

SilicaStorm · Postby **SilicaStorm** » Mon Aug 04, 2008 10:00 am

I have UT3 on a GameServers.com - 212.187.247.124:7777
I have a webserver at http://www.drewzdungeons.net (different location)

1) I can see the logs being created in /UTGame/Logs/
2) the tables are created on websever: http://www.drewzdungeons.net/utstatsuk/index.php
3) uploaded OLSendLog.php on the webserver into the directory - http://www.drewzdungeons.net/utstatsuk/

Code: Select all

[OLStats.MutOLGameStats]
bExportRawLog=True
bExportHTMLLogs=True
bLogBots=True
bLogChat=True
bLogPickups=True
bLogVehicleDeaths=True
bLogSecurityInfo=True
bLogPings=True
bLogAccuracy=True
bAdvancedVoteLogging=False
bMasterServerStats=True
bRunUTStatsDBParser=True
ParserURL=http://www.drewzdungeons.net/utstatsuk/logs.php
ParserPass=password
bUploadLogs=True
UploadURL=http://www.drewzdungeons.net/utstatsuk/OLSendLog.php
UploadPass=password
MinPlayers=1
MinHumans=1
KeepBotRecords=True

In the admin web interface after logging in; I click "Parse Logs" and get the following error messages:

Processing directory './Logs/' for 'Stats-*':

Warning: opendir(./Logs/) [function.opendir]: failed to open dir: No such file or directory in /home/andre4/public_html/utstatsuk/logs.php on line 584

Warning: readdir(): supplied argument is not a valid Directory resource in /home/andre4/public_html/utstatsuk/logs.php on line 585

Warning: closedir(): supplied argument is not a valid Directory resource in /home/andre4/public_html/utstatsuk/logs.php on line 597
No log files to process.

This is the config of statsdb.inc.php

Code: Select all

<?php
$dbtype = "MySQL";      // Database type - currently supported: MySQL SQLite
$dbpre = "ut";         // Prefix to be prepended to all database table names.
$SQLhost = "localhost"; // The MySQL database host.
$SQLport = 3306;        // TCP port or Linux socket to use (/var/lib/mysql/mysql.sock)
$SQLdb = "andre4_utstatsdbuk";   // The MySQL database name or full path to SQLite database file.
$SQLus = "andre4_unreal";     // A MySQL user with SELECT,INSERT,UPDATE,DELETE,CREATE,INDEX,CREATE TEMPORARY TABLES grants.
$SQLpw = "password";   // The password for the above MySQL user.
$InitPass = "password"; // Required for initializing the database tables.

// Optionally you can include the following line modified with the path to a file 
// outside of your web path with the above information in it:
// require("/path_to_file/statsdb.inc.php");
?>

and from /utstatsuk/error_log

[02-Aug-2008 11:16:13] *Error in database query: 'SELECT value FROM utconfig WHERE conf='AdminPass' LIMIT 1'
[02-Aug-2008 11:16:13] 1146: Table 'andre4_utstatsdbuk.utconfig' doesn't exist
[02-Aug-2008 11:16:24] *Error in database query: 'SELECT COUNT(*) FROM utconfig'
[02-Aug-2008 11:16:24] 1146: Table 'andre4_utstatsdbuk.utconfig' doesn't exist

GamesServers.log

ScriptLog: START MATCH
ScriptLog: Num Matches Played: 0
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:GetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Attempt to assign variable through None
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:GetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Attempt to assign variable through None
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:GetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Attempt to assign variable through None
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:GetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Attempt to assign variable through None
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:GetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Attempt to assign variable through None
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:GetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Accessed array 'UT3Stats_5.pl_data' out of bounds (10/10)
ScriptWarning: UT3Stats DM-Xiao.TheWorld:PersistentLevel.UT3Stats_5 (Function UT3Stats.UT3Stats:SetLastScore:0017) Attempt to assign variable through None
ScriptLog: UT3Stats: Closing log file.
ScriptLog: ProcessServerTravel: ?Restart
Log: SeamlessTravel to: DM-Xiao
Log: ClearAllAnimSetLinkupCaches - Took 9.61ms
Log: Primary PhysX scene will be in software.
Log: Creating Primary PhysX Scene.
Log: Bringing World EnvyEntry.TheWorld up for play (30) at 2008.08.04-12.52.58
Log: Bringing up level for play took: 0.002852
ScriptWarning: UT3ChatLogger EnvyEntry.TheWorld:PersistentLevel.UT3ChatLogger_11 (Function UT3Stats.UT3ChatLogger:Broadcast:004C) Accessed None 'utstats'
Log: ClearAllAnimSetLinkupCaches - Took 10.17ms
Log: Game class is 'UTDeathmatch'
Log: Primary PhysX scene will be in software.
Log: Creating Primary PhysX Scene.
PerfWarning: InstanceGeom: 4.528008 ms - 391 Convex, Terrain 0.000000 ms, PerTriSM 0.291068 ms, InitArticulated 0.000000 ms, BodyInst Alloc 10.820925 ms, InitBody 72.366301 ms
PerfWarning: NxActor Creation: 37.620943 ms
Log: Bringing World DM-Xiao.TheWorld up for play (30) at 2008.08.04-12.53.07
Log: Creating file: ..\UTGame\Logs\Stats-20080804.125307.log
ScriptLog: Mutators UTGame.UTMutator_LowGrav
ScriptLog: -- MAPVOTE is ENABLED!!!!!
ScriptLog: Web Server Created http://212.187.247.124:9000 Port: 9000 MaxCon 18 ExpirationSecs 86400 Enabled True
WebAdmin: Starting UT3 WebAdmin v1.4 - 2008-06-03 19:29:29 +0000
WebAdmin: Creating IWebAdminAuth instance from: BasicWebAdminAuth
WebAdmin: Creating ISessionHandler instance from: SessionHandler
WebStats: Starting UT3 WebStats v0.2
ScriptLog: Cut down URL ?MaxPlayers=10?NumPublicConnections=10?NumOpenPublicConnections=10?numplay=10?AccessControl=UT3Stats.UT3Stats?U?game=UTGame.UTDeathmatch?mutator=UTGame.UTMutator_LowGrav?Name=Player?team=255
ScriptLog: Cut down URL ?MaxPlayers=10?NumPublicConnections=10?NumOpenPublicConnections=10?numplay=10?AccessControl=UT3Stats.UT3Stats?U?game=UTGame.UTDeathmatch?mutator=UTGame.UTMutator_LowGrav?Name=Player?team=255
Log: Bringing up level for play took: 0.318583
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTBot_116
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTBot_116
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTBot_115
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTBot_115
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTBot_114
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTBot_114
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTBot_113
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTBot_113
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTBot_112
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTBot_112
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTBot_111
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTBot_111
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTBot_110
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTBot_110
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTBot_109
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTBot_109
ScriptLog: Cut down URL ?MaxPlayers=10?NumPublicConnections=10?NumOpenPublicConnections=10?numplay=10?AccessControl=UT3Stats.UT3Stats?U?game=UTGame.UTDeathmatch?mutator=UTGame.UTMutator_LowGrav?Name=Player?team=255
ScriptLog: Cut down URL ?MaxPlayers=10?NumPublicConnections=10?NumOpenPublicConnections=10?numplay=10?AccessControl=UT3Stats.UT3Stats?U?game=UTGame.UTDeathmatch?mutator=UTGame.UTMutator_LowGrav?Name=Player?team=255
Warning: KActor_1 has unsupported physics mode 4
Warning: KActor_0 has unsupported physics mode 4
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTPlayerController_17
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTPlayerController_17
SeamlessTravel: >> GameInfo::HandleSeamlessTravelPlayer: UTPlayerController_18
SeamlessTravel: << GameInfo::HandleSeamlessTravelPlayer: UTPlayerController_18
ScriptLog: START MATCH

Any assistance to what I need to complete this would be most greatful!

Special thanks to Panther and Starbuck...

Regards,

Drew

UTStatsDB v 3.02
OS Linix
MySQL v 5.0.5a
PHP v 4.4.7
Apache 1.3.39

Dungeons of Drew - DMLG - UAE
http://www.drewzdungeons.net

Starbuck · Postby **Starbuck** » Mon Aug 04, 2008 9:02 pm

Processing directory './Logs/' for 'Stats-*':

Warning: opendir(./Logs/) [function.opendir]: failed to open dir: No such file or directory in /home/andre4/public_html/utstatsuk/logs.php on line 584

Warning: readdir(): supplied argument is not a valid Directory resource in /home/andre4/public_html/utstatsuk/logs.php on line 585

Warning: closedir(): supplied argument is not a valid Directory resource in /home/andre4/public_html/utstatsuk/logs.php on line 597
No log files to process.

Umm, do you have a Logs directory under your UT3Stats (utstatsuk) root? If so, does it have the appropriate permissions set?

SilicaStorm · Postby **SilicaStorm** » Tue Aug 05, 2008 8:00 am

Starbuck,

I have now created a new directory /utstatsuk/Logs/ and CHMOD 777

I then manually uploaded the Stats- logs into the new directory and proceeded to "Click" Parse Logs from the Admin panel.

The message I now recieve is :

Processing directory './Logs/' for 'Stats-*':
No log files to process.

On index.php pages shows:

Current Status for 212.187.247.124:7777
Server is Offline

http://www.drewzdungeons.net/utstatsuk/index.php

UTStatsDB v 3.02
OS Linix
MySQL v 5.0.5a
PHP v 4.4.7
Apache 1.3.39

Dungeons of Drew - DMLG - UAE
http://www.drewzdungeons.net

Starbuck · Postby **Starbuck** » Tue Aug 05, 2008 2:58 pm

The Game Port actually requires the Query Port - chances are yours is defaulted to 6500.. You can always use my UT3 Query Port Lookup Tool to double check.

The other piece of your configuration looks fine... another user posted a similar problem (but never posted whether he resolved it or not):
viewtopic.php?f=3&t=21&st=0&sk=t&sd=a&start=30#p150

All I can suggest is to double check your permissions and your paths (maybe even play around with some path variations - i.e. ./utstatsuk/Logs/).

SilicaStorm · Postby **SilicaStorm** » Tue Aug 05, 2008 6:18 pm

Starbuck,

Your Query Port Tool works great, confirmed mine port is 6500.

Made the corrective adjustment in UTStatsDB Query Configuration: to 6500

Still recieve a incorrect indication:

Current Status for 212.187.247.124:6500
Server is Offline

I have tried multiple config including ./utstatsuk/Logs/ in the admin panel - UTStatsDB Logs Configuration; but every other config returns multiple lines of errors.

When the Logs Config at ./Logs/ I recieve this message:

Processing directory './Logs/' for 'Stats-*':
No log files to process.

I attempted to grant CHMOD 777 to /utstatsuk/Logs/ to both directories, which gave a 500 Internal Error page message.

Is there a "File" I should modify the permission?

GameServers.com has a restriction of access only to 9000 - 9050; which they offer for use of WebAdmin.

Could the open ports of GameServers.com have an issue sending the files, as currently I am manually transfering the files via FTP client?

UTStatsDB v 3.02
OS Linix
MySQL v 5.0.5a
PHP v 4.4.7
Apache 1.3.39

Dungeons of Drew - DMLG - UAE
http://www.drewzdungeons.net

Starbuck · Postby **Starbuck** » Tue Aug 05, 2008 8:27 pm

You need the most updated version of UTSTATSDB from SVN Repository (to get the query stuff to work).

Read these posts:
viewtopic.php?f=3&t=20&p=95&hilit=svn#p95
viewtopic.php?f=3&t=6&p=20&hilit=svn#p20

A search on the forum for SVN will give you a couple other things.

SilicaStorm · Postby **SilicaStorm** » Fri Aug 08, 2008 9:06 pm

Starbuck,

You were a 100% correct!

The link provided for download by Panther on the first post of UT3 Test 2 was old files and should be removed or redirected to the SVN.

I had never heard or used TortoiseSVN; but once installed was easy to manage.

Again special thanks to Panther and Starbuck for their outstanding efforts for the UT3 community.

Now I will start working on having the log files sent from GameServer to the WebServer via OLSendLog.php

UTStatsDB v 3.02
OS Linix
MySQL v 5.0.5a
PHP v 4.4.7
Apache 1.3.39

Dungeons of Drew - DMLG - UAE
http://www.drewzdungeons.net

UTStats not Parsing

UTStats not Parsing

Re: UTStats not Parsing

Re: UTStats not Parsing

Re: UTStats not Parsing

Re: UTStats not Parsing

Re: UTStats not Parsing

Re: UTStats not Parsing