[PauleroniSG]

I have a motd set up to run. The Cvar is set to let the motd be shown but it does not pop up.
I have figured out it has something todo with my databases.cfg
I cannot change some of my plugins from sqllite to MySQL
current databases (working but no motd)

Spoiler

"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"
	}
	"cksurf"
	{
		"driver"			"sqlite"
		"database"			"cksurf-local"
		"user"				"root"
		"pass"				""
	}
	    "store"
    {
        "driver"        "mysql"
        "host"          "<your-database-host>"
        "database"		"<your-database-name>"
        "user"		    "<username>"
        "pass"		    "<password>"
    }
}

and the broken database.cfg (which allows motd but breaks plugins)

Spoiler

"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"			"default"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"clientprefs-default"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	"cksurf"
	{
		"driver"			"default"
		"database"			"cksurf-local"
		"user"				"root"
		"pass"				""
	}
	    "store"
    {
        "driver"        "mysql"
        "host"          "<your-database-host>"
        "database"		"<your-database-name>"
        "user"		    "<username>"
        "pass"		    "<password>"
    }

I am new to running a server and do not know the issues.
If anyone can help it would be appreciated

[Franc1sco]

Change this

	    "store"
    {
        "driver"        "mysql"
        "host"          "<your-database-host>"
        "database"		"<your-database-name>"
        "user"		    "<username>"
        "pass"		    "<password>"
    }

To this

	    "store"
    {
        "driver"        "sqlite"
        "database"		"store"
    }

Or atleast put valid user, password, database and host if you want to use mysql.

[PauleroniSG]

I don't really have a problem with the store persay. It's turning cksurf into MySQL that is the problem.
When i do the databases break and don't work.
I'll give it a try
UPDATE: Still no MOTD popping up
updated database.cfg

"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"
	}
	"cksurf"
	{
		"driver"			"sqlite"
		"database"			"cksurf-local"
		"user"				"root"
		"pass"				""
	}
	    "store"
    {
        "driver"        "mysql"
        "host"          "default"
        "database"		"store"
        "user"		    "root"
        "pass"		    ""
    }
}

[PauleroniSG]

Okay. So my motd is working but at the expens of cksurf not working.
Remote SQL is broken.
database.cfg

"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"
	}
	"cksurf"
	{
		"driver"			"default"
		"host"				"23.229.192.135"
		"database"			"surftimes"
		"user"				"storagebot"
		"pass"				"pass"
	}
	    "store"
    {
        "driver"        "mysql"
        "host"          "default"
        "database"		"store"
        "user"		    "root"
        "pass"		    ""
    }
	"mostactive" // dont edit
	{
		"driver"			"mysql" // dont edit
		"host"				"23.229.192.135" // edit this
		"database"			"mostactive" // edit (optional)
		"user"				"storagebot" // edit this
		"pass"				"pass" // edit this
		//"timeout"			"0"
		"port"			"27025" // edit this
	}
}

and error log

Spoiler

L 08/19/2017 - 21:27:06: SourceMod error session started
L 08/19/2017 - 21:27:06: Info (map "surf_kitsune") (file "errors_20170819.log")
L 08/19/2017 - 21:27:06: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 08/19/2017 - 21:27:06: [SM] Blaming: mostactive.smx
L 08/19/2017 - 21:27:06: [SM] Call stack trace:
L 08/19/2017 - 21:27:06: [SM]   [0] SQL_TQuery
L 08/19/2017 - 21:27:06: [SM]   [1] Line 209, D:\Code\MostActive\gameserver\addons\sourcemod\scripting\mostactive.sp::CheckSQLSteamID
L 08/19/2017 - 21:27:06: [SM]   [2] Line 280, D:\Code\MostActive\gameserver\addons\sourcemod\scripting\mostactive.sp::OnClientPostAdminCheck
L 08/19/2017 - 21:27:20: [mostactive.smx] Database failure: [2003]: Can't connect to MySQL server on '23.229.192.135' (10060)
L 08/19/2017 - 21:27:20: [SM] Exception reported: Databases dont work
L 08/19/2017 - 21:27:20: [SM] Blaming: mostactive.smx
L 08/19/2017 - 21:27:20: [SM] Call stack trace:
L 08/19/2017 - 21:27:20: [SM]   [0] SetFailState
L 08/19/2017 - 21:27:20: [SM]   [1] Line 93, D:\Code\MostActive\gameserver\addons\sourcemod\scripting\mostactive.sp::OnSQLConnect