UTstatsDB 3.06 logs.php access error

General forum for discussions regarding UTStatsDB
seven69
Posts: 6
Joined: Thu Jun 11, 2009 7:58 am

UTstatsDB 3.06 logs.php access error

Postby seven69 » Thu Jun 11, 2009 8:07 am

Hi,

1- i recently installed UTStatsDB version 3.06 for UT2004 patched 3369
Linux-32bits
Php5
MySQL
Apache2

i read the documentation and it talks about an updatepass
what is this pass ?
in my statsdb.inc.php i've only got these lines:

<?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 = "utstatsdb"; // The MySQL database name or full path to SQLite database file.
$SQLus = "utstats"; // A MySQL user with SELECT,INSERT,UPDATE,DELETE,CREATE,INDEX,CREATE TEMPORARY TABLES grants.
$SQLpw = "my_SQLpass"; // The password for the above MySQL user.
$InitPass = "my_initPass"; // Required for initializing the database tables.

i've tried to add a line like this:
$UpdatePass = "my_updatepass"

but when i try http://localhost/logs.php?pass=my_updatepass
i have an error: "Access error"

my logs conf is set to /home/ut2004/UserLogs and this folder is set to 777

if i use the parse logs menu from admin.php i've got this message:

Setting permissions in directory '/home/ut2004/UserLogs/' for 'Stats_*':
Processing directory '/home/ut2004/UserLogs/' for 'Stats_*':
Processing log 'Stats_7777_2009_06_11_16_38_57.log'...incomplete.
0 of 1 logs processed - No new logs added.

and server is in the database,
but if i restart the server all logs right is 600

I've installed twice and it's the same problem :(

I also tried OLStats but it's the same problem with this updatepass...

2-at the home page i can't see my server :

Current Status for 127.0.0.1:7777
Server is Offline or Not Responding

Game server and stats are on the same server.

someone got an idea ?

thank you.

ps: sorry for my poor english

Panther
Site Admin
Posts: 500
Joined: Sat Dec 08, 2007 12:51 am
Contact:

Re: UTstatsDB 3.06 logs.php access error

Postby Panther » Thu Jun 11, 2009 11:45 am

The update password is set in the admin.php program under Main Config.

Make sure your server is configured to respond to queries.

seven69
Posts: 6
Joined: Thu Jun 11, 2009 7:58 am

Re: UTstatsDB 3.06 logs.php access error

Postby seven69 » Fri Jun 12, 2009 12:56 am

ooh i'm sorry i thought it was a "confirm password" :oops:

and for the rights on UserLogs is it normal that they are reset to rw------- root:root ?
because if i want to parse i have to chmod 777 -R and click on parse Logs

Panther
Site Admin
Posts: 500
Joined: Sat Dec 08, 2007 12:51 am
Contact:

Re: UTstatsDB 3.06 logs.php access error

Postby Panther » Fri Jun 12, 2009 1:11 am

and for the rights on UserLogs is it normal that they are reset to rw------- root:root ?
because if i want to parse i have to chmod 777 -R and click on parse Logs
Unlike UT3 (which is always 600), UT2004 follows the server user's umask setting. I highly advise against running the UT server as root and instead configure a non-privileged user who's primary group is the same as the web server and a umask setting of 002.

seven69
Posts: 6
Joined: Thu Jun 11, 2009 7:58 am

Re: UTstatsDB 3.06 logs.php access error

Postby seven69 » Fri Jun 12, 2009 4:04 am

it works fine thank you.

just a last question, i'm trying to use OLServQuery, the documentation says:
"OLStats comes with OLServQuery" i configured my ini file correctly
but server can't find OLStats.OLSQMUplink.
in olstats archive there's no file named OLServQuery is it normal ?

Panther
Site Admin
Posts: 500
Joined: Sat Dec 08, 2007 12:51 am
Contact:

Re: UTstatsDB 3.06 logs.php access error

Postby Panther » Fri Jun 12, 2009 6:35 am

The OLServQuery class is part of OLStats. Did you replace ServerActors=IpDrv.MasterServerUplink with ServerActors=OLStats.OLSQMSUplink in UT2004.ini?

Example changes:

Code: Select all

[Engine.GameEngine] ;ServerActors=IpDrv.MasterServerUplink ServerActors=OLStats.OLSQMSUplink [OLStats.OLSQMSUplink] bGameSpyQueries=True UdpGamespyQueryClass=OLStats.OLServQuery [OLStats.OLServQuery] bVerbose=false sReplyTo=TASGMEBHO ePType=PT_None


Return to “UTStatsDB”