HLStatsX:CE/SourceBans Questions/Issues

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
User avatar
shanemkelley
New to forums
New to forums
Posts: 1
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Sat Mar 11, 2017 11:05 pm
Location: In the Man Cave
Contact:

HLStatsX:CE/SourceBans Questions/Issues

Post by shanemkelley »

I have a couple of questions/problems I was wondering if someone could help me with. First being I have stats hosted with NFO for one of my servers and is there a way to point my domain to it so it shows stats.gaming2gamers.com or gaming2gamers.com/stats I want the domain to show mine if possible avoiding a redirect. My second question is I have sourcebans hosted where my website is hosted but I can't get the database.cfg host to point to my website host. Sourcemod Logs shows this error
[L 03/12/2017 - 00:56:39: [sourcebans.smx] Database failure: [1045]: Access denied for user 'ommited'@'v-72-5-195-198.managed-vds.premium-chicago.nfoservers.com' (using password: YES)]
When in the databases.cfg I put my eternal host ip in every box almost and still won't connect to that host.
"Databases"
{
"driver_default" "mysql"

// When specifying "host", you may use an IP address, a hostname, or a socket file path

"sourcebans"
{
"driver" "mysql"
"host" "216.172.184.192"
"database" "omitted"
"user" "omitted"
"pass" "omitted"
//"timeout" "0"
//"port" "3306"
}

"storage-local"
{
"driver" "mysql"
"database" "216.172.184.192"
}

"clientprefs"
{
"driver" "sqlite"
"host" "216.172.184.192"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}
If anyone has any ideas that would be awesome.
“Everything you want is out there waiting for you to ask. Everything you want also wants you. But you have to take action to get it.”
Jack Canfield
User avatar
TimeX
Staff
Staff
Posts: 1730
Joined: Thu Jul 22, 2004 12:24 am
Location: Big Bear, CA

Re: HLStatsX:CE/SourceBans Questions/Issues

Post by TimeX »

There is a way to use your own domain with the stats, but it requires some setup on your end and ours. If you haven't already, please go ahead and open a help request with us and we can guide you through on what needs to be done.

As for the database issue. Is this for a database on our web hosting services? The reason I ask is the IP you have entered doesn't seem to match anything I can fine, and also does not match the error message you pasted.
TimeX
natan
New to forums
New to forums
Posts: 6
Joined: Fri Feb 13, 2015 4:54 am

Re: HLStatsX:CE/SourceBans Questions/Issues

Post by natan »

Mysql connect funtions are getting old.

Now we have to use PDO with the last release of PHP.


(Guys from NFO.... Build an Addon for installing Sourcebans & HlstatsX on your webhosting plans)
or

if anybody have some knowledge about how to fix. is welcome :twisted:
User avatar
Edge100x
Founder
Founder
Posts: 12945
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: HLStatsX:CE/SourceBans Questions/Issues

Post by Edge100x »

natan,

mysql_* functions were removed in PHP 7 but mysqli can be used instead, if you don't want to switch to PDO.

We don't allow HLstatsX hosting on our webhosting plans.

Sourcebans works but under PHP 7 it requires that this change be made in its init.txt file:

Code: Select all

$GLOBALS['db'] = ADONewConnection("mysqli://".DB_USER.':'.DB_PASS.'@'.DB_HOST.':'.DB_PORT.'/'.DB_NAME);
becomes:

Code: Select all

$GLOBALS['db'] = ADONewConnection("mysqli");
$GLOBALS['db']->connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
natan
New to forums
New to forums
Posts: 6
Joined: Fri Feb 13, 2015 4:54 am

Re: HLStatsX:CE/SourceBans Questions/Issues

Post by natan »

Sourcebans stills working fine in PHP 7.

Technically my webhosting was "linked" to a VPS database (where hlstatsX is working)


I only install the Software in webhosting but the queries was sended to VPS.

now unfortunatelly i have to use: IPAddress/stats/hlstats.php
P.D. Did you remove support for HlstatsX/Webhosting due to Daemon ?
User avatar
Edge100x
Founder
Founder
Posts: 12945
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: HLStatsX:CE/SourceBans Questions/Issues

Post by Edge100x »

natan wrote: Fri Sep 15, 2017 7:37 pm Sourcebans stills working fine in PHP 7.
It seems to depend on the version used. We had several customers who needed to apply a fix =\.
Technically my webhosting was "linked" to a VPS database (where hlstatsX is working)

I only install the Software in webhosting but the queries was sended to VPS.

now unfortunatelly i have to use: IPAddress/stats/hlstats.php
P.D. Did you remove support for HlstatsX/Webhosting due to Daemon ?
We haven't supported HLStatsX on webhosting from the beginning due to its requirement for a daemon and because we have our own HLStatsX service. We haven't changed anything about it recently (no changes were consciously made that would break existing installations).
natan
New to forums
New to forums
Posts: 6
Joined: Fri Feb 13, 2015 4:54 am

Re: HLStatsX:CE/SourceBans Questions/Issues

Post by natan »

Thanks for your answer.

I think im a 0,00001% of your costumers that has that "issue"
but i can live with it :D

:wink:
Post Reply