AlliedModders - [Fixed] Mysql cannot connect to local database

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

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

- - [Fixed] Mysql cannot connect to local database (https://forums.alliedmods.net/showthread.php?t=255395)

[Fixed] Mysql cannot connect to local database

Hello AM, Martin here.
I was put my server on hold for a while, but i start this year and i have problem with MySQL connection.

Spoiler

And here is Full log from main console:

Code:

Protocol version 48

Exe version 1.1.2.7 (cstrike)

Exe build: 13:13:28 Aug 29 2013 (6153)

couldn't exec language.cfg

Server IP address 188.254.188.225:27015

No IPX Support.

   

   Metamod version 1.21.1-am  Copyright (c) 2001-2013 Will Day <[email protected]>

   Metamod comes with ABSOLUTELY NO WARRANTY; for details type `meta gpl'.

   This is free software, and you are welcome to redistribute it

   under certain conditions; type `meta gpl' for details.

   



   AMX Mod X version 1.8.3-dev+4526 Copyright (c) 2004-2014 AMX Mod X Development Team 

   AMX Mod X comes with ABSOLUTELY NO WARRANTY; for details type `amxx gpl'.

   This is free software and you are welcome to redistribute it under 

   certain conditions; type 'amxx gpl' for details.

  

[WHB] Version: 1.5.370 Windows

[WHB] Success: Build HLDS version defined Windows "6153"

couldn't exec config.cfg

L 01/14/2015 - 09:08:35: [AMXX] Plugin file open error (plugin "csdm_off.amxx")

# Loaded 3 admins from file

[AMXX] executed. 

# Error No.2003: Can't connect to MySQL server on 'localhost' (10061)

Connection to Steam servers successful.

   VAC secure mode is activated.

AMX Mod X 1.8.3-dev+4526 (http://www.amxmodx.org)

Authors:

        David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko

        Felix "SniperBeamer" Geyer, Jonny "Got His Gun" Bergstrom

        Lukasz "SidLuke" Wlasinski, Christian "Basic-Master" Hammacher

        Borja "faluco" Ferrer, Scott "DS" Ehlert

Compiled: Jan 14 2015 03:49:57

Built from: https://github.com/alliedmodders/amxmodx/commit/7f9d677Build ID: 4526:7f9d677Core mode: JIT+ASM32

Metamod v1.21.1-am  2013-09-26 (5:13)

by Will Day <[email protected]>

   http://www.metamod.org/

compiled: Sep 26 2013, 22:35:52  (msc optimized)

Currently loaded plugins:

      description      stat pend  file              vers      src  load  unlod

 [ 1] AMX Mod X        RUN   -    amxmodx_mm.dll    v1.8.3-d  ini  Start ANY  

 [ 2] WHBlocker        RUN   -    whblocker.dll     v1.5.370  ini  Chlvl ANY  

 [ 3] Admin Free Look  RUN   -    adminfreelook_am  v1.5.3    pl1  ANY   ANY  

 [ 4] FakeMeta         RUN   -    fakemeta_amxx.dl  v1.8.3-d  pl1  ANY   ANY  

 [ 5] Ham Sandwich     RUN   -    hamsandwich_amxx  v1.8.3-d  pl1  ANY   ANY  

 [ 6] CStrike          RUN   -    cstrike_amxx.dll  v1.8.3-d  pl1  ANY   ANY  

 [ 7] Engine           RUN   -    engine_amxx.dll   v1.8.3-d  pl1  ANY   ANY  

 [ 8] MySQL            RUN   -    mysql_amxx.dll    v1.8.3-d  pl1  ANY   ANY  

8 plugins, 8 running

Currently loaded modules:

      name                    version     author               status     

 [ 1] Admin Free Look         1.5.3       Arkshine             running    

 [ 2] FakeMeta                1.8.3-dev+  AMX Mod X Dev Team   running    

 [ 3] Ham Sandwich            1.8.3-dev+  AMX Mod X Dev Team   running    

 [ 4] CStrike                 1.8.3-dev+  AMX Mod X Dev Team   running    

 [ 5] Engine                  1.8.3-dev+  AMX Mod X Dev Team   running    

 [ 6] RegEx                   1.8.3-dev+  AMX Mod X Dev Team   running    

 [ 7] MySQL                   1.8.3-dev+  AMX Mod X Dev Team   running    

 [ 8] Sockets                 1.8.3-dev+  HLSW Dev Team        running    

8 modules, 8 correct

Currently loaded plugins:

       name                    version     author            file             status   

 [  1] Admins                  1.8.3-dev+  AMXX Dev Team     admins.amxx      running  

 [ 15] unknown                 unknown     unknown           csdm_off.amxx    bad load 

( 15) Load fails: Plugin file open error (plugin "csdm_off.amxx")

15 plugins, 14 running

Edit: Also tried with dbTuple code bellow

Spoiler

Code:

/* Plugin generated by AMXX-Studio */
#include <amxmodx>
#include <amxmisc>
#include <sqlx>

#define PLUGIN "Player Status in DB"
#define VERSION "0.73"
#define AUTHOR "SandStriker"

#define MAX_NAME_LENGTH 31
#define MAX_ERR_LENGTH 128
#define MAX_QUERY_LENGTH 1024
#define MAX_LENGTH 31

//Database setting pointers
new g_dbhost,g_dbuser,g_dbpass,g_dbname,g_tbname

//Database Handles
new Handle:g_dbt,Handle:g_dbc

//Table name
new g_ptbname[MAX_LENGTH+1]

#define TASK_ID 6218742

public plugin_init() {
    register_plugin(PLUGIN, VERSION, AUTHOR)
    g_dbhost = register_cvar("amx_sql_host","127.0.0.1")
    g_dbuser = register_cvar("amx_sql_user","root")
    g_dbpass = register_cvar("amx_sql_pass","")
    g_dbname = register_cvar("psd_sql_db","xweb_csdb")
    g_tbname = register_cvar("psd_tbname","test")
    // Add your code here...
    set_task(1.0,"plugin_core",0,"",0,"",0)
}
public plugin_core()
{
    new host[64],user[32],pass[32],db[32],error[MAX_ERR_LENGTH+1],ercode
    get_pcvar_string(g_dbhost, host, 63)
    get_pcvar_string(g_dbuser, user, 31)
    get_pcvar_string(g_dbpass, pass, 31)
    get_pcvar_string(g_dbname, db, 31)
    get_pcvar_string(g_tbname, g_ptbname,31)
    
    g_dbt = SQL_MakeDbTuple(host,user,pass,db)
    g_dbc = SQL_Connect(g_dbt,ercode,error,127)
    
    if(g_dbc == Empty_Handle)
    {
        server_print("[PSD] Error No.%d: %s", ercode,error)
        }else {
        server_print("[PSD] Connecting successful.")
        init_database()
        //init_insert()
        //sql_disconnect()
        //set_task(get_pcvar_num(g_uptime)*60.0,"UpdateInServer",TASK_ID,"",0,"b")
    }
    return PLUGIN_CONTINUE
}
public plugin_end() {
    if(task_exists(TASK_ID))
        remove_task(TASK_ID)
    sql_disconnect()
    return PLUGIN_CONTINUE
}
//Disconnect MySQL server
sql_disconnect() {
    SQL_FreeHandle(g_dbc)
    SQL_FreeHandle(g_dbt)
    server_print("[PSD] Closing connection...")
    return PLUGIN_CONTINUE
}

//Create Table
init_database() {
    new Handle:result
    new QUERY[MAX_QUERY_LENGTH]
    formatex(QUERY,MAX_QUERY_LENGTH,
    "CREATE TABLE IF NOT EXISTS `%s` (`authid` VARCHAR( 32 ) NOT NULL, `name` VARCHAR( 32 ) NOT NULL , `date` TIMESTAMP( 10 ) NOT NULL , `score` INT NOT NULL ,`kills` INT NOT NULL , `teamkills` INT NOT NULL, `deaths` INT NOT NULL , `hits` INT NOT NULL , `shots` INT NOT NULL , `headshots` INT NOT NULL , `efficiency` DOUBLE (19,2) DEFAULT NULL, `accuracy` double(19,2) default NULL,`accuracyHS` double(19,2) default NULL,`kdrate` double(19,2) default NULL, PRIMARY KEY(`authid`))", g_ptbname)
    result = SQL_PrepareQuery(g_dbc, QUERY)
    SQL_Execute(result)
    
    formatex(QUERY,MAX_QUERY_LENGTH,"ALTER TABLE `%s` ADD `kdrate` double(19,2) default NULL",g_ptbname)
    result = SQL_PrepareQuery(g_dbc, QUERY)
    SQL_Execute(result)
    
    SQL_FreeHandle(result)
    return PLUGIN_CONTINUE
}

/*
CheckError(Handle:result)
{
new err[MAX_ERR_LENGTH+1]
SQL_QueryError(result,err,MAX_ERR_LENGTH)
server_print("[PSD] Error: %s",err)
}
*/

~Thanks for your help. - Sorry if thread is not in right place, but the issue appers only with hlds.exe (tested home/work pc's)
- Recompiled .sma's with latest 1.8.3-dev-git4526-base-windows
My plugins do not overlap, i just use one for db!

Re: [Problem] Mysql cannot connect to local database

Have you tried it with a default installation of the officially supported version of AMX Mod X (version 1.8.2)? (no 3rd party plugins, just all the default ones)

Re: [Problem] Mysql cannot connect to local database

Are you sure you pass correct values in SQL_MakeDbTuple? Just check again in case.

Re: [Problem] Mysql cannot connect to local database

~ I try with 1.8.2 result bellow. ~ no success that's rules out AmxmodX ~
~ Values are correct, changed pass and still..no connection.

Spoiler

Code:

Protocol version 48

Exe version 1.1.2.7 (cstrike)

Exe build: 13:13:28 Aug 29 2013 (6153)

couldn't exec language.cfg

Server IP address 188.254.188.225:27015

No IPX Support.

   

   Metamod version 1.21.1-am  Copyright (c) 2001-2013 Will Day <[email protected]>

   Metamod comes with ABSOLUTELY NO WARRANTY; for details type `meta gpl'.

   This is free software, and you are welcome to redistribute it

   under certain conditions; type `meta gpl' for details.

   



   AMX Mod X version 1.8.2 Copyright (c) 2004-2006 AMX Mod X Development Team 

   AMX Mod X comes with ABSOLUTELY NO WARRANTY; for details type `amxx gpl'.

   This is free software and you are welcome to redistribute it under 

   certain conditions; type 'amxx gpl' for details.

  

[WHB] Version: 1.5.370 Windows

[WHB] Success: Build HLDS version defined Windows "6153"

couldn't exec config.cfg

L 01/14/2015 - 14:39:37: -------- Mapchange to de_dust2 --------

L 01/14/2015 - 14:39:38: [nextmap.amxx] WARNING: Couldn't find a valid map or the file doesn't exist (file "mapcycle.txt")

Executing AMX Mod X Configuration File 

Scrolling message displaying frequency: 10:00 minutes

[AMXX] SQL error: can't connect: 'Can't connect to MySQL server on '127.0.0.1' (10061)'

[AMXX] Loaded 1 admin from file

Connection to Steam servers successful.

   VAC secure mode is activated.

Menu item 17 added to Menus Front-End: "Plugin Cvars" from plugin "pluginmenu.amxx"

Menu item 18 added to Menus Front-End: "Plugin Commands" from plugin "pluginmenu.amxx"

AMX Mod X 1.8.2 (http://www.amxmodx.org)

Authors:

        David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko

        Felix "SniperBeamer" Geyer, Jonny "Got His Gun" Bergstrom

        Lukasz "SidLuke" Wlasinski, Christian "Basic-Master" Hammacher

        Borja "faluco" Ferrer, Scott "DS" Ehlert

Compiled: Feb 14 2013, 00:56:37

Build ID: 1.8.2 61:2ae84f7c0a97

Core mode: JIT+ASM32

Metamod v1.21.1-am  2013-09-26 (5:13)

by Will Day <[email protected]>

   http://www.metamod.org/

compiled: Sep 26 2013, 22:35:52  (msc optimized)

Currently loaded modules:

      name                    version     author               status     

 [ 1] MySQL                   1.8.2       AMX Mod X Dev Team   running    

1 modules, 1 correct

Currently loaded plugins:

      description      stat pend  file              vers      src  load  unlod

 [ 1] AMX Mod X        RUN   -    amxmodx_mm.dll    v1.8.2    ini  Start ANY  

 [ 2] WHBlocker        RUN   -    whblocker.dll     v1.5.370  ini  Chlvl ANY  

 [ 3] MySQL            RUN   -    mysql_amxx.dll    v1.8.2    pl1  ANY   ANY  

3 plugins, 3 running

Currently loaded plugins:

       name                    version     author            file             status   

 [  1] Admin Base (SQL)        1.8.2       AMXX Dev Team     admin.amxx       running  

 [  2] Admin Commands          1.8.2       AMXX Dev Team     admincmd.amxx    running  

 [  3] Admin Help              1.8.2       AMXX Dev Team     adminhelp.amxx   running  

 [  4] Slots Reservation       1.8.2       AMXX Dev Team     adminslots.amxx  running  

 [  5] Multi-Lingual System    1.8.2       AMXX Dev Team     multilingual.am  running  

 [  6] Menus Front-End         1.8.2       AMXX Dev Team     menufront.amxx   running  

 [  7] Commands Menu           1.8.2       AMXX Dev Team     cmdmenu.amxx     running  

 [  8] Players Menu            1.8.2       AMXX Dev Team     plmenu.amxx      running  

 [  9] Maps Menu               1.8.2       AMXX Dev Team     mapsmenu.amxx    running  

 [ 10] Plugin Menu             1.8.2       AMXX Dev Team     pluginmenu.amxx  running  

 [ 11] Admin Chat              1.8.2       AMXX Dev Team     adminchat.amxx   running  

 [ 12] Anti Flood              1.8.2       AMXX Dev Team     antiflood.amxx   running  

 [ 13] Scrolling Message       1.8.2       AMXX Dev Team     scrollmsg.amxx   running  

 [ 14] Info. Messages          1.8.2       AMXX Dev Team     imessage.amxx    running  

 [ 15] Admin Votes             1.8.2       AMXX Dev Team     adminvote.amxx   running  

 [ 16] NextMap                 1.8.2       AMXX Dev Team     nextmap.amxx     running  

 [ 17] Nextmap Chooser         1.8.2       AMXX Dev Team     mapchooser.amxx  running  

 [ 18] TimeLeft                1.8.2       AMXX Dev Team     timeleft.amxx    running  

 [ 19] Pause Plugins           1.8.2       AMXX Dev Team     pausecfg.amxx    running  

 [ 20] Stats Configuration     1.8.2       AMXX Dev Team     statscfg.amxx    running  

20 plugins, 20 running

~ To add i have all frameworks installed (atleast for xp) and i don't recive any errors and startup hlds.exe
~ I will try to search for alternative (uwamp,wamp) maybe i try xamp or something , meanwhile connection is still refused.

Re: [Problem] Mysql cannot connect to local database

I'm asking if values are well retrieved from cvars and passed in SQL_MakeDbTuple.
For example, if you have SQL_MakeDbTuple(host,user,pass,db), I want you output host/user/pass/db with server_print() or log_amx(), to make sure you pass proper values.

Re: [Problem] Mysql cannot connect to local database

Sorry for mine misunderstanding from 48hours i sleep only 8. Now let's continue.

I tested both SQL_MakeStdTuple and SQL_MakeDbTuple.

MakeStdTuple

Spoiler

MakeDbTuple

Spoiler

Code:

/* Plugin generated by AMXX-Studio */
#include <amxmodx>
#include <amxmisc>
#include <sqlx>

#define PLUGIN "Player Status in DB"
#define VERSION "0.73"
#define AUTHOR "SandStriker"

#define MAX_NAME_LENGTH 31
#define MAX_ERR_LENGTH 128
#define MAX_QUERY_LENGTH 1024
#define MAX_LENGTH 31

//Database setting pointers
new g_dbhost,g_dbuser,g_dbpass,g_dbname,g_tbname

//Database Handles
new Handle:g_dbt,Handle:g_dbc

//Table name
new g_ptbname[MAX_LENGTH+1]

#define TASK_ID 6218742

public plugin_init() {
    register_plugin(PLUGIN, VERSION, AUTHOR)
    g_dbhost = register_cvar("amx_sql_host","127.0.0.1")
    g_dbuser = register_cvar("amx_sql_user","root")
    g_dbpass = register_cvar("amx_sql_pass","****")
    g_dbname = register_cvar("psd_sql_db","xweb_csdb")
    g_tbname = register_cvar("psd_tbname","test")
    // Add your code here...
    set_task(1.0,"plugin_core",0,"",0,"",0)
}
public plugin_core() {
    new host[64],user[32],pass[32],db[32],error[MAX_ERR_LENGTH+1],ercode
    get_pcvar_string(g_dbhost, host, 63)
    get_pcvar_string(g_dbuser, user, 31)
    get_pcvar_string(g_dbpass, pass, 31)
    get_pcvar_string(g_dbname, db, 31)
    get_pcvar_string(g_tbname, g_ptbname,31)
    
    g_dbt = SQL_MakeDbTuple(host,user,pass,db)
    g_dbc = SQL_Connect(g_dbt,ercode,error,127)
    
    if(g_dbc == Empty_Handle)
    {
        server_print("[PSD] Error No.%d: %s", ercode,error)
        server_print("DbTuple host in server: %s",g_dbhost)
        server_print("DbTuple user in server: %s",g_dbuser)
        server_print("DbTuple pass in server: %s",g_dbpass)
        server_print("DbTuple dbname in server: %s",g_dbname)
        server_print("DbTuple tbname in server: %s",g_tbname)
        log_amx("DbTuple host in server: %s",g_dbhost)
        log_amx("DbTuple user in server: %s",g_dbuser)
        log_amx("DbTuple pass in server: %s",g_dbpass)
        log_amx("DbTuple dbname in server: %s",g_dbname)
        log_amx("DbTuple tbname in server: %s",g_tbname)
    }
    else {
        server_print("[PSD] Connecting successful.")
        init_database()
        //init_insert()
        //sql_disconnect()
        //set_task(get_pcvar_num(g_uptime)*60.0,"UpdateInServer",TASK_ID,"",0,"b")
    }
    return PLUGIN_CONTINUE
}
init_database() {
    new Handle:result
    new QUERY[MAX_QUERY_LENGTH]
    formatex(QUERY,MAX_QUERY_LENGTH,
    "CREATE TABLE IF NOT EXISTS `%s` (`authid` VARCHAR( 32 ) NOT NULL, `name` VARCHAR( 32 ) NOT NULL , `date` TIMESTAMP( 10 ) NOT NULL , `score` INT NOT NULL ,`kills` INT NOT NULL , `teamkills` INT NOT NULL, `deaths` INT NOT NULL , `hits` INT NOT NULL , `shots` INT NOT NULL , `headshots` INT NOT NULL , `efficiency` DOUBLE (19,2) DEFAULT NULL, `accuracy` double(19,2) default NULL,`accuracyHS` double(19,2) default NULL,`kdrate` double(19,2) default NULL, PRIMARY KEY(`authid`))", g_ptbname)
    result = SQL_PrepareQuery(g_dbc, QUERY)
    SQL_Execute(result)
    
    formatex(QUERY,MAX_QUERY_LENGTH,"ALTER TABLE `%s` ADD `kdrate` double(19,2) default NULL",g_ptbname)
    result = SQL_PrepareQuery(g_dbc, QUERY)
    SQL_Execute(result)
    
    SQL_FreeHandle(result)
    return PLUGIN_CONTINUE
}

Re: [Problem] Mysql cannot connect to local database

Clean reinstall of Windows seems to fixed it. (problem-clsed)
~btw maybe the new updates git4537 are helped too.
Thanks for the help.