[Trie1950gustrcom]

So i'm trying to use this plugin, Autospells,

it required me to update my databases.cfg, which i thought was simple enough,
but no matter what i put in it, it gave me this error.

L 04/24/2018 - 02:47:24: [SM] Exception reported: Can't find 'autospells' entry in sourcemod/configs/databases.cfg!
L 04/24/2018 - 02:47:24: [SM] Blaming: AutoSpells.smx()
L 04/24/2018 - 02:47:24: [SM] Call stack trace:
L 04/24/2018 - 02:47:24: [SM]   [0] SetFailState
L 04/24/2018 - 02:47:24: [SM]   [1] Line 102, C:\Program Files (x86)\Valve\Servers\TF2_1\tf\addons\sourcemod\scripting\AutoSpells.sp::Connect()
L 04/24/2018 - 02:47:24: [SM]   [2] Line 32, C:\Program Files (x86)\Valve\Servers\TF2_1\tf\addons\sourcemod\scripting\AutoSpells.sp::OnPluginStart()

can someone walk me through fixing this?
Also a few starting questions
#1. Is Databases.cfg setup by default or does it need configuring from the start
#2. How do i use databases.cfg

[ghostofmybrain]

Why not post what you have in databases? (You can redact sensitive information like IP and password.)

[Throst68]

Having the same problem. Is there a guide on how to setup databases.cfg or is it something i need a program/Server for like fast dl?

[ThatKidWhoGames]

Originally Posted by Trie1950gustrcom So i'm trying to use this plugin, Autospells, it required me to update my databases.cfg, which i thought was simple enough, but no matter what i put in it, it gave me this error. L 04/24/2018 - 02:47:24: [SM] Exception reported: Can't find 'autospells' entry in sourcemod/configs/databases.cfg! L 04/24/2018 - 02:47:24: [SM] Blaming: AutoSpells.smx() L 04/24/2018 - 02:47:24: [SM] Call stack trace: L 04/24/2018 - 02:47:24: [SM] [0] SetFailState L 04/24/2018 - 02:47:24: [SM] [1] Line 102, C:\Program Files (x86)\Valve\Servers\TF2_1\tf\addons\sourcemod\scripting\AutoSpells.sp::Connect() L 04/24/2018 - 02:47:24: [SM] [2] Line 32, C:\Program Files (x86)\Valve\Servers\TF2_1\tf\addons\sourcemod\scripting\AutoSpells.sp::OnPluginStart() can someone walk me through fixing this? Also a few starting questions #1. Is Databases.cfg setup by default or does it need configuring from the start #2. How do i use databases.cfg

Originally Posted by Throst68 Having the same problem. Is there a guide on how to setup databases.cfg or is it something i need a program/Server for like fast dl?

Have you guys tried to simply restart your server or change the map? That is when databases.cfg is reloaded. If you have tried this, that must mean you didn't set up your file properly.

Here is the structure to get it working with the AutoSpells plugin. Add this as an entry into the file:

"autospells"
{
	"host"				"database_host"
	"database"			"database_name"
	"user"				"database_username"
	"pass"				"database_password"
	//"timeout"			"0"
	//"port"			"0"
}

[Throst68]

Looks like OP Got banned, so i guess ill post my databases.cfg

It doesn't have any passwords or anything in it because i never tampered with it.
But i tried to include autospells into it and it just gave me his error.

"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}

	"autospells"
	{
     		"driver" 			"mysql"
     		"host" 				"localhost"
     		"database" 			"autospells" 
     		"user" 				"root"
     		"pass" 				"" 
     		//"timeout" 			"0"
     		"port 				"0"
	}
}

[Throst68]

Omg no i haven't if that's the true fix ill be so fucking mad at myself.

Well i tried restarting the server but no dice.

With that entry, do i put it as a subcatagory of Databases?
Or do i give it it's own section under it?

So i tried restarting, i added 3306 port, what else could be wrong?

"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}

	"autospells"
	{
     		"driver" 			"mysql"
     		"host" 				"localhost"
     		"database" 			"autospells" 
     		"user" 				"root"
     		"pass" 				"" 
     		//"timeout" 			"0"
     		"port 				"3306"
	}
}

Note, also i've never heard of MySQL, is this something that comes with sourcemod or do i have to set this up for autospells to work?

[ThatKidWhoGames]

Looking at your config entry, you have the port set to 0. MySQL default port is bound to 3306. Comment out the port part, save and restart your server or change the map.

[Throst68]

Is mySQL pre-installed?

[ThatKidWhoGames]

Originally Posted by Throst68 Omg no i haven't if that's the true fix ill be so fucking mad at myself. Well i tried restarting the server but no dice. With that entry, do i put it as a subcatagory of Databases? Or do i give it it's own section under it? So i tried restarting, i added 3306 port, what else could be wrong? "Databases" { "driver_default" "mysql" // When specifying "host", you may use an IP address, a hostname, or a socket file path "default" { "driver" "default" "host" "localhost" "database" "sourcemod" "user" "root" "pass" "" //"timeout" "0" //"port" "0" } "storage-local" { "driver" "sqlite" "database" "sourcemod-local" } "clientprefs" { "driver" "sqlite" "host" "localhost" "database" "clientprefs-sqlite" "user" "root" "pass" "" //"timeout" "0" //"port" "0" } "autospells" { "driver" "mysql" "host" "localhost" "database" "autospells" "user" "root" "pass" "" //"timeout" "0" "port "3306" } } Note, also i've never heard of MySQL, is this something that comes with sourcemod or do i have to set this up for autospells to work?

MySQL is a database server that you host. You need one to work with plugins that require a MySQL database.

[Throst68]

Originally Posted by ThatKidWhoGames MySQL is a database server that you host. You need one to work with plugins that require a MySQL database.

Ah, so how do i setup MySQL?
Is it a download or do i have to pay someone? (that would really suck)