Raised This Month: $51 Target: $400
 12% 

MySQL Loading Admins Issue


Post New Thread Reply   
AlliedModders Forum Index > SourceMod > General
 
Thread Tools Display Modes
Author Message
Krillin
Senior Member
Krillin's Avatar
Join Date: Jul 2004
Old 02-04-2011 , 11:15   MySQL Loading Admins Issue
Reply With Quote #1
I am having the strangest problem lately with Source MOD granting access to admins in the MySQL database.

I am not getting ANY errors about data connections. I can update the database with a test admin, and look at the database and it is there.

Existing Admins in the database are NOT getting their access as programmed.

MySQL database is hosted on the same machine as the server (localhost or 127.0.0.1).

This worked briefly a few nights ago. When I restarted the machine and the servers I get the same results, no one has admin access.

I am also using AMXX for databasing admins on HL1 server and they are working 100%, no problems or issues.

Debian 10.04 (lenny)
MODS Listed Below
Code:
meta version
Metamod:Source version 1.8.5
Build ID: 752:3e48f4adf523
Loaded As: Valve Server Plugin
Compiled on: Dec 19 2010
Plugin interface version: 15:14
SourceHook version: 5:5
http://www.metamodsource.net/
Code:
Listing 6 plugins:
  [01] sbsrc (4.2.0) by IceMatrix, Live
  [02] SourceMod (1.3.6) by AlliedModders LLC
  [03] CS:S Tools (1.3.6) by AlliedModders LLC
  [04] BinTools (1.3.6) by AlliedModders LLC
  [05] SDK Tools (1.3.6) by AlliedModders LLC
  [06] SDK Hooks (1.3.0) by Tsunami
Code:
sm version
 SourceMod Version Information:
    SourceMod Version: 1.3.6
    SourcePawn Engine: SourcePawn 1.1, jit-x86 (build 1.3.6)
    SourcePawn API: v1 = 4, v2 = 3
    Compiled on: Oct 30 2010 18:49:41
    Build ID: 3065:8036343199ca
    http://www.sourcemod.net/
Code:
[SM] Listing 25 plugins:
  01 "Admin Menu" (1.3.6) by AlliedModders LLC
  02 "Fun Votes" (1.3.6) by AlliedModders LLC
  03 "Player Commands" (1.3.6) by AlliedModders LLC
  04 "Hide Chat Triggers" (1.0.0.0) by AlliedModders LLC
  05 "Admin Help" (1.3.6) by AlliedModders LLC
  06 "Basic Votes" (1.3.6) by AlliedModders LLC
  07 "SM Bot Tools" (1.2) by AMP
  08 "Sound Commands" (1.3.6) by AlliedModders LLC
  09 "SQL Admin Manager" (1.3.4) by AlliedModders LLC
  10 "MapChooser" (1.3.4) by AlliedModders LLC
  11 "RandomCycle" (1.3.4) by AlliedModders LLC
  12 "Reserved Slots" (1.3.6) by AlliedModders LLC
  13 "Basic Comm Control" (1.3.6) by AlliedModders LLC
  14 "Basic Chat" (1.3.6) by AlliedModders LLC
  15 "Basic Info Triggers" (1.3.6) by AlliedModders LLC
  16 "Kigen's Anti-Cheat" (1.2.1.6) by CodingDirect LLC
  17 "Anti-Flood" (1.3.6) by AlliedModders LLC
  18 "Basic Commands" (1.3.6) by AlliedModders LLC
  19 "RCON Lock" (0.6.7) by devicenull
  20 "SourceBans" (1.4.7) by InterWave Studios Development Team
  21 "Fun Commands" (1.3.6) by AlliedModders LLC
  22 "Client Preferences" (1.3.6) by AlliedModders LLC
  23 "Map Nominations" (1.3.4) by AlliedModders LLC
  24 "SQL Admins (Threaded)" (1.3.4) by AlliedModders LLC
  25 "Nextmap" (1.3.6) by AlliedModders LLC
Code:
es_load

[EventScripts] Loaded:
[EventScripts]   [ enabled] corelib
[EventScripts]   [ enabled] corelib/testlib
[EventScripts]   [ enabled] corelib/interfaces
[EventScripts]   [ enabled] corelib/linkedlist
[EventScripts]   [ enabled] corelib/repeat
[EventScripts]   [ enabled] corelib/score
[EventScripts]   [ enabled] corelib/xalias
[EventScripts]   [ enabled] corelib/textlib
[EventScripts]   [ enabled] corelib/playergetset
[EventScripts]   [ enabled] corelib/getbotname
[EventScripts]   [ enabled] corelib/damage
[EventScripts]   [ enabled] corelib/playervar
[EventScripts]   [ enabled] corelib/sqlitelib
[EventScripts]   [ enabled] corelib/statlog
[EventScripts]   [ enabled] corelib/quickcmd
[EventScripts]   [ enabled] corelib/queue
[EventScripts]   [ enabled] corelib/vecmath
[EventScripts]   [ enabled] corelib/services
[EventScripts]   [ enabled] corelib/foreach
[EventScripts]   [ enabled] corelib/average
[EventScripts]   [ enabled] corelib/keyfilter
[EventScripts]   [ enabled] corelib/uniqueid
[EventScripts]   [ enabled] corelib/timelib
[EventScripts]   [ enabled] corelib/keygroupsort
[EventScripts]   [ enabled] corelib/keygrouprand
[EventScripts]   [ enabled] corelib/keyrand
[EventScripts]   [ enabled] corelib/exp
[EventScripts]   [ enabled] corelib/isnumerical
[EventScripts]   [ enabled] corelib/escinject
[EventScripts]   [ enabled] corelib/getplayercount
[EventScripts]   [ enabled] corelib/usermsglib
[EventScripts]   [ enabled] corelib/inrange
[EventScripts]   [ enabled] corelib/entitylib
[EventScripts]   [ enabled] corelib/es_install
[EventScripts]   [ enabled] corelib/es_checkversion
[EventScripts]   [ enabled] corelib/es_mexec
[EventScripts]   [ enabled] corelib/clientcmd
[EventScripts]   [ enabled] extendedevents
[EventScripts]        name: ExtendedEvents
[EventScripts]     version: 4
[EventScripts]         url: http://addons.eventscripts.com/addons/view/extendedevents
[EventScripts]    basename: extendedevents
[EventScripts]      author: SuperDave
[EventScripts]   [ enabled] superhero
[EventScripts]        name: Superhero
[EventScripts]     version: 0.3.1
[EventScripts]         url: http://superhero-source.com
[EventScripts]   [ enabled] superhero/heroes
[EventScripts]   [ enabled] superhero/heroes/Agent Zero
[EventScripts]   [ enabled] superhero/heroes/Blade
[EventScripts]   [ enabled] superhero/heroes/Dazzler
[EventScripts]   [ enabled] superhero/heroes/Dracula
[EventScripts]   [ enabled] superhero/heroes/Flash
[EventScripts]   [ enabled] superhero/heroes/General
[EventScripts]   [ enabled] superhero/heroes/Goku
[EventScripts]   [ enabled] superhero/heroes/HobGoblin
[EventScripts]   [ enabled] superhero/heroes/Invisible Man
[EventScripts]   [ enabled] superhero/heroes/Iron Man
[EventScripts]   [ enabled] superhero/heroes/Jubilee
[EventScripts]   [ enabled] superhero/heroes/Morph
[EventScripts]   [ enabled] superhero/heroes/Mystique
[EventScripts]   [ enabled] superhero/heroes/Nightcrawler
[EventScripts]   [ enabled] superhero/heroes/Poison Ivy
[EventScripts]   [ enabled] superhero/heroes/Punisher
[EventScripts]   [ enabled] superhero/heroes/Robin
[EventScripts]   [ enabled] superhero/heroes/Superman
[EventScripts]   [ enabled] superhero/heroes/Wolverine
[EventScripts]   [ enabled] superhero/admins
[EventScripts]------------------------
Code:
"Databases"

{

	"driver_default"		"mysql"

	

	"default"

	{

		"driver"			"default"

		"host"				"127.0.0.1"

		"database"			"sourcemod"

		"user"				"sourcemod"

		"pass"				"<snipped>"

		//"timeout"			"0"

		"port"  			"3306"

	}



	"sourcebans"

	{

		"driver"			"default"

		"host"				"10.0.0.5"

		"database"			"sourcebans"

		"user"				"kwsb"

		"pass"				"<snipped>"

		//"timeout"			"0"

		"port"				"3306"

	}

	"storage-local"

	{

		"driver"			"sqlite"

		"database"			"sourcemod-local"

	}



	"clientprefs"

	{

		"driver"			"sqlite"

		"host"				"127.0.0.1"

		"database"			"clientprefs-sqlite"

		"user"				"sourcemod"

		"pass"				"<snipped>"

		//"timeout"			"0"

		//"port"		        "0"

	}

}
On this server I can not use admin.cfg file. Everytime I do, something keeps emptying out the file as seen below:
Code:
"Admins"
{
}
I keep replacing this file with the one from the 1st server, but every time it gets replaced with above. I think ES is doing this and cannot figure out why or how.

This is the current database data.
Code:
1, 'steam', '2403201', '*', 'z', 'Krillin', 0
2, 'steam', '2405868', '*', 'bcdefghijklmopqrst', 'Vegeta', 0
3, 'steam', '22465272', '*', 'bcdefghijklmopqrst', 'Princess', 0
sm_who reports:
Code:
sm_who
    Name                     Username           Admin access
 1. Krillin 99.135.58.49                        none
Thanks,
Krillin
__________________
Krillin's World Server(s) Operator
Krillin is offline
Krillin
Senior Member
Krillin's Avatar
Join Date: Jul 2004
Old 02-04-2011 , 11:55   Re: MySQL Loading Admins Issue
Reply With Quote #2
I just connected to our GGM:SM server and I was granted access using the same database and configuration as above with the exception of ES not installed on this server.

However, the difference also is the server specs above is also -insecure.

Can someone please explain to me why 'insecure' servers are VERY problematic lately? Why is VALVe punishing 'insecure' servers?

This is the only thing I can track this problem down to be. Is valve must have done something to the engine to prevent 'mods' from functioning properly on 'insecure' servers.

Can anyone else confirm this? I do not have the knowledge or resources to really confirm this. Except to know that the gameserver and database run on the same machine. Yet I have different functionality from secure to insecure servers.

Things that make you go WTF is this sh!t?!
__________________
Krillin's World Server(s) Operator
Krillin is offline
voogru
Inspector Javert
voogru's Avatar
Join Date: Oct 2004
Old 02-05-2011 , 01:11   Re: MySQL Loading Admins Issue
Reply With Quote #3
Code:
1, 'steam', '2403201', '*', 'z', 'Krillin', 0
2, 'steam', '2405868', '*', 'bcdefghijklmopqrst', 'Vegeta', 0
3, 'steam', '22465272', '*', 'bcdefghijklmopqrst', 'Princess', 0
These don't look like steamids to me...

If you're automatically adding the STEAM_0:X:* to these, be warned that these are two seperate steamids.

STEAM_0:0:2403201
STEAM_0:1:2403201

Quote:
Originally Posted by Krillin View Post
I just connected to our GGM:SM server and I was granted access using the same database and configuration as above with the exception of ES not installed on this server.
Why don't you try not loading ES and see what happens instead of going on ranting about valve trying to cripple insecure servers?
voogru is offline
Reply
AlliedModders Forum Index > SourceMod > General

« Previous Thread | Next Thread »


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 23:38.

DMCA - Archive - Top

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode