Hl Stats web showing 0/0 players - Page 3

sixten_8_9@ · *Last edited by sixten_8_9@; 01-05-2014 at 08:04.*

Quote:

Originally Posted by shubhamgulati12

It only shows this much log...
It shuts down after this..
Is there a problem in the following lines:

This one u don't need
this is only country u are from/flags

2014-01-04 13:07:01: - ERROR: GeoIP method set to binary file lookup but /home1/bloggin5/perl//GeoLiteCity/GeoLiteCity.dat NOT FOUND

but this one make it so perl shutdown:

BASTARDrcon: send gîÍ:27033 : Operation not permitted at /home1/bloggin5/perl//BASTARDrcon.pm line 108.

not 100% sure how to fix it.

shubhamgulati12 · *Last edited by shubhamgulati12; 01-05-2014 at 08:13.*

Latest message observed @ logs:

Quote:

2014-01-05 18:00:02: - MYSQL: Connecting to MySQL database 'database_name' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18:00:02: - CONFIG: Reading database config...
2014-01-05 18:00:02: - CONFIG: I have found the following server configs in database:
2014-01-05 18:00:02: - S_CONFIG: 103.2.238.230:27019
2014-01-05 18:00:02: - S_CONFIG: 103.2.238.205:27033
2014-01-05 18:00:02: - ERROR: GeoIP method set to binary file lookup but /home1/bloggin5/perl//GeoLiteCity/GeoLiteCity.dat NOT FOUND
2014-01-05 18:00:02: - HLSTATSX: HLstatsX:CE 1.6.19 starting...
2014-01-05 18:00:02: - UDP: Opening UDP listen socket on port 27500 ... ok
2014-01-05 18:00:02: - HLSTATSX: Tracking Trend of the stats are enabled
2014-01-05 18:00:02: - HLSTATSX: Maximum Skill Change on all servers are 25 points
2014-01-05 18:00:02: - HLSTATSX: Minimum Skill Change on all servers are 2 points
2014-01-05 18:00:02: - HLSTATSX: Minimum Players Kills on all servers are 50 kills
2014-01-05 18:00:02: - HLSTATSX: Players chat logging is enabled
2014-01-05 18:00:02: - HLSTATSX: Broadcasting public chat is disabled
2014-01-05 18:00:02: - HLSTATSX: Event queue size is set to 10
2014-01-05 18:00:02: - HLSTATSX: HLstatsX:CE is now running (NameTrack mode, debug level 1)
2014-01-05 18:02:01: - HLSTATSX: No data since 120 seconds
2014-01-05 18:04:01: - HLSTATSX: No data since 120 seconds
2014-01-05 18:05:04: - HLSTATSX: Lost database connection. Trying to reconnect...
2014-01-05 18:05:04: - MYSQL: Connecting to MySQL database 'database_name' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18:05:04: - HLSTATSX: Insert new server trend timestamp
2014-01-05 18:06:02: - HLSTATSX: No data since 120 seconds
2014-01-05 18:08:03: - HLSTATSX: No data since 120 seconds
2014-01-05 18:10:03: - HLSTATSX: No data since 120 seconds
2014-01-05 18:10:05: - HLSTATSX: Lost database connection. Trying to reconnect...
2014-01-05 18:10:05: - MYSQL: Connecting to MySQL database 'database_name' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18:10:05: - HLSTATSX: Insert new server trend timestamp
2014-01-05 18:12:04: - HLSTATSX: No data since 120 seconds
2014-01-05 18:14:04: - HLSTATSX: No data since 120 seconds
2014-01-05 18:15:05: - HLSTATSX: Lost database connection. Trying to reconnect...
2014-01-05 18:15:05: - MYSQL: Connecting to MySQL database 'database_name' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18:15:05: - HLSTATSX: Insert new server trend timestamp
2014-01-05 18:16:05: - HLSTATSX: No data since 120 seconds
2014-01-05 18:18:06: - HLSTATSX: No data since 120 seconds
2014-01-05 18:20:06: - HLSTATSX: Lost database connection. Trying to reconnect...
2014-01-05 18:20:06: - MYSQL: Connecting to MySQL database 'database_name' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18:20:06: - HLSTATSX: Insert new server trend timestamp
2014-01-05 18:20:06: - HLSTATSX: No data since 120 seconds
2014-01-05 18:22:07: - HLSTATSX: No data since 120 seconds
2014-01-05 18:24:07: - HLSTATSX: No data since 120 seconds
2014-01-05 18:25:06: - HLSTATSX: Lost database connection. Trying to reconnect...
2014-01-05 18:25:06: - MYSQL: Connecting to MySQL database 'database_name
' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18:25:06: - HLSTATSX: Insert new server trend timestamp
2014-01-05 18:26:08: - HLSTATSX: No data since 120 seconds
2014-01-05 18:28:09: - HLSTATSX: No data since 120 seconds
2014-01-05 18:28:55: - PROXY, Reload request from 127.0.0.1:59601:
2014-01-05 18:28:56: - CONTROL: Command received: RELOAD
2014-01-05 18:28:56: 127.0.0.1:59601 - CONTROL: Sent 29 bytes to frontend at '127.0.0.1:59601'
2014-01-05 18:28:56: 127.0.0.1:59601 - CONTROL: Re-Reading Configuration by request from Frontend...
2014-01-05 18:28:56: 127.0.0.1:59601 - CONFIG: Reading database config...
2014-01-05 18:28:56: 127.0.0.1:59601 - HLSTATSX: Lost database connection. Trying to reconnect...
2014-01-05 18:28:56: 127.0.0.1:59601 - MYSQL: Connecting to MySQL database 'database_name' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18:28:56: 127.0.0.1:59601 - CONFIG: I have found the following server configs in database:
2014-01-05 18:28:56: 127.0.0.1:59601 - S_CONFIG: 103.2.238.230:27019
2014-01-05 18:28:56: 127.0.0.1:59601 - S_CONFIG: 103.2.238.205:27033
2014-01-05 18:28:56: 127.0.0.1:59601 - ERROR: GeoIP method set to binary file lookup but /home1/bloggin5/perl//GeoLiteCity/GeoLiteCity.dat NOT FOUND
2014-01-05 18

0:06: - HLSTATSX: Lost database connection. Trying to reconnect...
2014-01-05 18

0:06: - MYSQL: Connecting to MySQL database 'database_name' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18

0:06: - HLSTATSX: Insert new server trend timestamp
2014-01-05 18

0:55: - HLSTATSX: No data since 120 seconds
2014-01-05 18

2:55: - HLSTATSX: No data since 120 seconds
2014-01-05 18

4:56: - HLSTATSX: No data since 120 seconds
2014-01-05 18

5:06: - HLSTATSX: Lost database connection. Trying to reconnect...
2014-01-05 18

5:06: - MYSQL: Connecting to MySQL database 'database_name' on 'localhost' as user 'user_name' ... connected ok
2014-01-05 18

5:06: - HLSTATSX: Insert new server trend timestamp
2014-01-05 18

6:56: - HLSTATSX: No data since 120 seconds

sixten_8_9@ · *Last edited by sixten_8_9@; 01-05-2014 at 08:17.*

Quote:

Originally Posted by shubhamgulati12

Latest message observed @ logs:

looks like it working now
now u only need to fix ip adress

hmm, not 100% for sure but think u need to change

this ip.
127.0.0.1

shubhamgulati12 · *Last edited by shubhamgulati12; 01-05-2014 at 08:47.*

Quote:

Originally Posted by sixten_8_9@

looks like it working now
now u only need to fix ip adress

hmm, not 100% for sure but think u need to change

this ip.
127.0.0.1

where & which file [server side or web side..?]
1 more thing which is confusing is the mysql port and daemon port.
Where do we have to add the daemon port [27500] and where do we have to add the mysql port [3306] ..??

sixten_8_9@ · 01-05-2014 , 08:55 Re: Hl Stats web showing 0/0 players

Quote:

Originally Posted by shubhamgulati12

where & which file [server side or web side..?]
1 more thing which is confusing is the mysql port and daemon port.
Where do we have to add the daemon port [27500] and where do we have to add the mysql port [3306] ..??

daemon port u use in

cfg
command:logaddress_add

but u need to add u ip adress to

ex:

logaddress_add 119.18.51.78:27500

shubhamgulati12 · *Last edited by shubhamgulati12; 01-05-2014 at 08:59.*

Quote:

Originally Posted by sixten_8_9@

daemon port u use in

cfg

I have already added that
and the output of logaddress_add shows:
current: 119.18.51.78:27500
So, I don't think there is a problem over there, but where do we have to fill the mysql port?

sixten_8_9@ · 01-05-2014 , 09:03 Re: Hl Stats web showing 0/0 players

Quote:

Originally Posted by shubhamgulati12

I have already added that
and the output of logaddress_add shows:
current: 119.18.51.78:27500
So, I don't think there is a problem over there, but where do we have to fill the mysql port?

are u settings:
mysql on localhost only?
if it is then lan ip only work.

shubhamgulati12 · *Last edited by shubhamgulati12; 01-05-2014 at 09:05.*

Quote:

Originally Posted by sixten_8_9@

are u settings:
mysql on localhost only?
if it is then lan ip only work.

yea in config.php I added localhost to following:

Quote:

// DB_ADDR - The address of the database server, in host:port format.
// (You might also try setting this to e.g. ":/tmp/mysql.sock" to
// use a Unix domain socket, if your mysqld is on the same box as
// your web server.)
define("DB_ADDR", "localhost");

Should I change localhost to 119.18.51.78: 3306?

sixten_8_9@ · 01-05-2014 , 09:09 Re: Hl Stats web showing 0/0 players

Quote:

Originally Posted by shubhamgulati12

yea in config.php I added localhost to following:

Should I change localhost to 119.18.51.78: 3306?

didn't mean there

i mean in

http://localhost/phpmyadmin/

shubhamgulati12 · 01-05-2014 , 09:11 Re: Hl Stats web showing 0/0 players

Quote:

Originally Posted by sixten_8_9@

i mean in
http://localhost/phpmyadmin/

Same..