AlliedModders - Connection to database failed: Could not find driver "mysql"

AlliedModders (https://forums.alliedmods.net/index.php)

- General (https://forums.alliedmods.net/forumdisplay.php?f=58)

- - Connection to database failed: Could not find driver "mysql" (https://forums.alliedmods.net/showthread.php?t=341323)

Connection to database failed: Could not find driver "mysql"

Hello,
I just want to use a Sticker plugin on my Server but it doesnt work with the Database.

[csgo_weaponstickers.smx] (WeaponStickers) Connection to database failed: Could not find driver "mysql"

Also get this error

Unable to load extension "dbi.mysql.ext": libz.so.1: cannot open shared object file: No such file or directory

PHP Code:


		
			
"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"                ""
    }

    "csgo_weaponstickers"
    {
        "driver"            "mysql"
        "host"                "176.**.1**.***"
        "database"            "db_********"
        "user"                "db_*********"
        "pass"                "**********"
        //"timeout"            "0"
        "port"                "3306"
    }


}

and when I type sm exts list then this is the Output:

"Automatic Updater" (1.11.0.6927) by AlliedModders LLC: Updates SourceMod gamedata files
"Webternet" (1.11.0.6927) by AlliedModders LLC: Extension for interacting with URLs
"CS Tools" (1.11.0.6927) by AlliedModders LLC: CS extended functionality
"BinTools" (1.11.0.6927) by AlliedModders LLC: Low-level C/C++ Calling API
"SDK Tools" (1.11.0.6927) by AlliedModders LLC: Source SDK Tools
"PTaH" (1.1.3) by Phoenix (˙·٠●Феникс●٠·˙): Additional CS:GO Hooks and Natives
"SDK Hooks" (1.11.0.6927) by AlliedModders LLC: Source SDK Hooks
"Top Menus" (1.11.0.6927) by AlliedModders: Creates sorted nested menus
"Regex" (1.11.0.6927) by AlliedModders LLC: Provides regex natives for plugins
"REST in Pawn" (1.2.1) by Tsunami: Provides HTTP and JSON natives for plugins
"Client Preferences" (1.11.0.6927) by AlliedModders: Saves client preference settings
"SQLite" (1.11.0.6927) by AlliedModders LLC: SQLite Driver
"DHooks" (1.11.0.6927) by AlliedModders LLC: Dynamic Hooks
Thanks for help.

Btw all the people that want to answer it with:
"apt-get install lib32z1" im not the owner of the server. The owner is a company

TY

Re: Connection to database failed: Could not find driver "mysql"

talk to company if they include mysql database or use free host
https://www.freemysqlhosting.net/

Re: Connection to database failed: Could not find driver "mysql"

Just note, that you could get your server banned from CSGO for using that unapproved plug-in. https://www.mail-archive.com/csgo_se.../msg11235.html

With that said, why not just use sqlite?

Code:

"Databases"

{

    "driver_default"        "sqlite"

    

    // 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"                ""

    }



    "csgo_weaponstickers"

    {

        "driver"            "sqlite"

        "host"                "localhost"

        "database"            "db_********"

        "user"                "root"

        "pass"                ""

        //"timeout"            "0"

        "port"                "3306"

    }





}

Re: Connection to database failed: Could not find driver "mysql"

You do need "apt-get install lib32z1" (if linux Debian).
for that, you need SSH access (root or sudo).

If not..
Try to change web/VDS providers.

Re: Connection to database failed: Could not find driver "mysql"

I've also encountered this error on CentOS 8.
Maybe you can try "yum install zlib.i686" or "sudo yum install zlib.i686"