Need help with mysql saving
Moderator: Forum Moderator
Need help with mysql saving
SO im trying to set up mysql to have all the war3ft stuff save to it but this is what im getting in the log file.
L 08/18/2007 - 18:10:15: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
when i join the server, war3ft is running but i am not able to choose a race
this is what i have for the sql.cfg
amx_sql_host "66.55.132.**"
amx_sql_user "c47****"
amx_sql_pass "han**"
amx_sql_db "CS"
amx_sql_table "admins"
amx_sql_type "mysql"
--- Please enter the following information for support ---
War3ft Version: 3.0 RC8
Amxmodx Version: newest
Metamod Version:
amxx list:
amxx modules:
meta list:
L 08/18/2007 - 18:10:15: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
when i join the server, war3ft is running but i am not able to choose a race
this is what i have for the sql.cfg
amx_sql_host "66.55.132.**"
amx_sql_user "c47****"
amx_sql_pass "han**"
amx_sql_db "CS"
amx_sql_table "admins"
amx_sql_type "mysql"
--- Please enter the following information for support ---
War3ft Version: 3.0 RC8
Amxmodx Version: newest
Metamod Version:
amxx list:
amxx modules:
meta list:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
Hanz,
In your sql.cfg you posted admins as the table for the database. Thats how you setup your admins for the server through that cfg file. You need to change the war.cfg and for version 3.0 rc8 you dont use the "amx_sql_table "war3users" at all anymore, I guess the database makes the tables when you connect the server to it at startup.
Good luck.
Daver
In your sql.cfg you posted admins as the table for the database. Thats how you setup your admins for the server through that cfg file. You need to change the war.cfg and for version 3.0 rc8 you dont use the "amx_sql_table "war3users" at all anymore, I guess the database makes the tables when you connect the server to it at startup.
Good luck.
Daver
-
- Peon
- Posts: 12
- Joined: Sat Aug 18, 2007 6:58 pm
- Location: Dallas TX
- Contact:
Make sure you configured your modules.ini file and enable which form of saving your gonna use, but removing the ; in front of the line.
; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.so
; PostgreSQL
;pgsql_amxx_i386.so
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll
; SQLite
;sqlite_amxx.dll
;sqlite_amxx_i386.so
;sqlite_amxx_amd64.so
; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.so
; PostgreSQL
;pgsql_amxx_i386.so
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll
; SQLite
;sqlite_amxx.dll
;sqlite_amxx_i386.so
;sqlite_amxx_amd64.so
my module.ini file doesnt look like that
;;;
; 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
;;;
; 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
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
this is what i have for the sql.cfg
amx_sql_host "66.55.132.**"
amx_sql_user "c477521_******"
amx_sql_pass "han**"
amx_sql_db "c477521_CS"
amx_sql_table ""
amx_sql_type "mysql"
and war3ft.cfg
wc3_sql_dbhost "66.55.132.33:20**" // Host Name
wc3_sql_dbuser "c477521_*****" // User Name
wc3_sql_dbpass "*****" // Password
wc3_sql_dbname "c477521_CS" // Database Name
when i just tried using the password without c477521_ the server crashed on a map change, i checked the log file and it said this
14:28:07: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2013] Lost connection to MySQL server during query
amx_sql_host "66.55.132.**"
amx_sql_user "c477521_******"
amx_sql_pass "han**"
amx_sql_db "c477521_CS"
amx_sql_table ""
amx_sql_type "mysql"
and war3ft.cfg
wc3_sql_dbhost "66.55.132.33:20**" // Host Name
wc3_sql_dbuser "c477521_*****" // User Name
wc3_sql_dbpass "*****" // Password
wc3_sql_dbname "c477521_CS" // Database Name
when i just tried using the password without c477521_ the server crashed on a map change, i checked the log file and it said this
14:28:07: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2013] Lost connection to MySQL server during query
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
by gameserver you mean the clanserver mysql db? if so then i just edited the war3 and sql cfg files as well as setting everything up for the mysql db through clanservers.
i just tested it and xp saves and all that good stuff, no crashes, but still dont have my admin powers even though my log files are saying i connected as admin
i just tested it and xp saves and all that good stuff, no crashes, but still dont have my admin powers even though my log files are saying i connected as admin
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
- YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
- Contact:
Hanz can you post your exact war3.cfg data connections here, change the numbers if you like I just need to asee the connect info, cuz i cant connect to the database with gamesevers mysql database at all...HaNz_BrIx wrote:this is what i have for the sql.cfg
amx_sql_host "66.55.132.**"
amx_sql_user "c477521_******"
amx_sql_pass "han**"
amx_sql_db "c477521_CS"
amx_sql_table ""
amx_sql_type "mysql"
and war3ft.cfg
wc3_sql_dbhost "66.55.132.33:20**" // Host Name
wc3_sql_dbuser "c477521_*****" // User Name
wc3_sql_dbpass "*****" // Password
wc3_sql_dbname "c477521_CS" // Database Name
when i just tried using the password without c477521_ the server crashed on a map change, i checked the log file and it said this
14:28:07: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2013] Lost connection to MySQL server during query
Thx,
Daver