[swarmachine]

Hello am useing ezyro.com unlimited hosting as free unlimted mysql database and am tryng to set mysql on/with [zp50_rank_sqlvault + admin_sq ]

Correct mode : Zombie_Plague [New_Modes]

Also getting error:

L 01/11/2018 - 17:18:25: -------- Mapchange to de_dust2_3x3 -------- L 01/11/2018 - 17:18:26: [admin_sql.amxx] Failed to set affinity from sqlite to mysql. L 01/11/2018 - 17:27:00: -------- Mapchange to de_dust2 -------- L 01/11/2018 - 17:27:23: [admin_sql.amxx] Login: "M A S S E F F E C T<5><STEAM_ID_LAN><>" became an admin (account "loopback") (access "abcdefghijklmnopqrstuv") (address "loopback") L 01/11/2018 - 17:27:24: [admin_sql.amxx] Login: "M A S S E F F E C T<5><STEAM_ID_LAN><>" became an admin (account "loopback") (access "abcdefghijklmnopqrstuv") (address "loopback")

tryed to run with http://www.rainbowspuppiessunshine.c...test/index.php
mysql database test got error Can't connect to MySQL server on 'sql301.ezyro.com' (13)

Config SQL

Spoiler

// SQL configuration file
// File location: $moddir/addons/amxmodx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

// *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use.

amx_sql_host "sql301.ezyro.com"
amx_sql_user "CANT_SHOW"
amx_sql_pass "CANT_SHOW"
amx_sql_db "CANT_SHOW_user"
amx_sql_table "admins"
amx_sql_type "mysql"
amx_sql_timeout "60"

modules list - note if I enable mysql or sqllite at same on localhost, yes am trying to run on localhost, it freezes for some seconds don't know why.

Spoiler

;;;
; To enable a module, remove the semi-colon (;) in front of its name.
; If it's not here, simply add it its name, one per line.
; You don't need to write the _amxx part or the file extension.
;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time. Use ;;
;; amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;

mysql
sqlite

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;
;; Put third party modules below here. ;;
;; You can just list their names, without the _amxx ;;
;; or file extension. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;



;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;
;; These modules will be auto-detected and loaded ;;
;; as needed. You do not need to enable them here ;;
;; unless you have problems. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;

;fun
;engine
;fakemeta
;geoip
;sockets
;regex
;nvault
;cstrike
;csx
;hamsandwich

LOGS

I'll try more to run with pod-bots see if it would work : if still wouldn't work admin and rank system ill post here ...

EDIT BACK WITH LOGS

Spoiler

L 01/11/2018 - 17:50:06: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2003): Can't connect to MySQL server on 'sql301.ezyro.com' (10060)
L 01/11/2018 - 17:50:13: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2003): Can't connect to MySQL server on 'sql301.ezyro.com' (10053)
L 01/11/2018 - 17:50:14: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:14: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:14: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:14: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:15: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:15: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:15: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:15: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:16: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:16: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:16: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:16: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:17: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:17: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:17: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:17: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:18: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:50:18: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_get_data() (2005): Unknown MySQL server host 'sql301.ezyro.com' (0)
L 01/11/2018 - 17:541: [zp50_rank_sqlvault.amxx] Connection failed in sqlv_connect() (2003): Can't connect to MySQL server on 'sql301.ezyro.com' (10060)

is it host falt ?

-------
Final notes.

Is this way working and if not how to fix it ?

Drop that.

ill use xamp as alternatyve mysql database as free one's don't give a thing.
SOLVED (kinda)!