Raised This Month: $ Target: $400
 0% 

Problem with mysql .


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
vayn2k
Junior Member
Join Date: Dec 2016
Location: Denmark
Old 12-15-2016 , 16:48   Problem with mysql .
Reply With Quote #1

Have big probelm with my server making database for sourcebans and store, want both on diffrent database but they wont connect, tryed local host and 127.0.0.1 not working.

Setup here

database.cfg
Quote:
"Databases"
{
"driver_default" "mysql"

// When specifying "host", you may use an IP address, a hostname, or a socket file path

"sourcebans"
{
"driver" "default"
"host" "31.220.21.12"
"database" "younggam_bans"
"user" "younggam_sbans"
"pass" "*********"
//"timeout" "0"
"port" "3306"
}

"store"
{
"driver" "default"
"host" "31.220.21.12"
"database" "younggam_storeweb"
"user" "younggam_store"
"pass" "*******"
//"timeout" "0"
"port" "3306"
}

"stroage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}
What is wrong and the 31.220.21.12 is my mysql server ?. Mysql works perfect other wise.

Also have picture of Console..

http://imgur.com/a/u68GO


It says store.smx is problem but is it because of wrong script in smx ?

is use store by Zephyrus

Last edited by vayn2k; 12-19-2016 at 04:12.
vayn2k is offline
WildCard65
Veteran Member
Join Date: Aug 2013
Location: Canada
Old 12-15-2016 , 21:58   Re: Problem with mysql .
Reply With Quote #2

What error means is "dbi.mysql.ext" failed to load, run "sm exts list" to find load error.
__________________
WildCard65 is offline
vayn2k
Junior Member
Join Date: Dec 2016
Location: Denmark
Old 12-16-2016 , 03:49   Re: Problem with mysql .
Reply With Quote #3

Quote:
Originally Posted by WildCard65 View Post
What error means is "dbi.mysql.ext" failed to load, run "sm exts list" to find load error.
Here is it after i useed sm exts list. no mysql registered.

Quote:
[SM] Displaying 15 extensions:
[01] Automatic Updater (1.8.0.5963): Updates SourceMod gamedata files
[02] Webternet (1.8.0.5963): Extension for interacting with URLs
[03] CS Tools (1.8.0.5963): CS extended functionality
[04] BinTools (1.8.0.5963): Low-level C/C++ Calling API
[05] SDK Tools (1.8.0.5963): Source SDK Tools
[06] Regex (1.8.0.5963): Provides regex natives for plugins
[07] Client Preferences (1.8.0.5963): Saves client preference settings
[08] SQLite (1.8.0.5963): SQLite Driver
[09] SDK Hooks (1.8.0.5963): Source SDK Hooks
[10] <FAILED> file "store_sm.ext.so": /home/tcagame/admin/1/csgo/addons/sourcemod/extensions/store_sm.ext.so: cannot open shared object file: No such file or directory
[11] Top Menus (1.8.0.5963): Creates sorted nested menus
[12] GeoIP (1.8.0.5963): Geographical IP information
[13] <FAILED> file "steamtools.ext.so": /home/tcagame/admin/1/csgo/addons/sourcemod/extensions/steamtools.ext.so: cannot open shared object file: No such file or directory
[14] <FAILED> file "curl.ext.so": /home/tcagame/admin/1/csgo/addons/sourcemod/extensions/curl.ext.so: undefined symbol: _ZNSs9_M_mutateEjjj
[15] <FAILED> file "socket.ext.so": /home/tcagame/admin/1/csgo/addons/sourcemod/extensions/socket.ext.so: cannot open shared object file: No such file or directory

Last edited by vayn2k; 12-16-2016 at 03:49.
vayn2k is offline
vayn2k
Junior Member
Join Date: Dec 2016
Location: Denmark
Old 12-16-2016 , 04:22   Re: Problem with mysql .
Reply With Quote #4

its not installed
vayn2k is offline
WildCard65
Veteran Member
Join Date: Aug 2013
Location: Canada
Old 12-16-2016 , 07:43   Re: Problem with mysql .
Reply With Quote #5

try "sm exts load dbi.mysql.ext", it will either fail or succeed, if it fails, "sm exts list" will say why.
__________________
WildCard65 is offline
quake84
Junior Member
Join Date: Aug 2014
Location: Poland
Old 12-16-2016 , 08:21   Re: Problem with mysql .
Reply With Quote #6

Also I'd censor out the login data unless the server is firewalled...
__________________
...
quake84 is offline
vayn2k
Junior Member
Join Date: Dec 2016
Location: Denmark
Old 12-19-2016 , 04:13   Re: Problem with mysql .
Reply With Quote #7

get the Fail

Quote:
[SM] Extension dbi.mysql.ext.so failed to load: libz.so.1: cannot open shared object file: No such file or directory
vayn2k is offline
vayn2k
Junior Member
Join Date: Dec 2016
Location: Denmark
Old 12-19-2016 , 04:13   Re: Problem with mysql .
Reply With Quote #8

Can it be that the mysql isnt installed on my vps ?
vayn2k is offline
WildCard65
Veteran Member
Join Date: Aug 2013
Location: Canada
Old 12-19-2016 , 16:57   Re: Problem with mysql .
Reply With Quote #9

No, it means 32bit zlib is not installed (a dependency of the pre-compiled static mysql binaries SM use).
__________________
WildCard65 is offline
micazoid
Veteran Member
Join Date: Oct 2010
Location: Munich - Germany
Old 12-21-2016 , 16:14   Re: Problem with mysql .
Reply With Quote #10

https://forums.alliedmods.net/showpo...5&postcount=33
__________________
micazoid is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 22:44.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode