Func132
New to forums
Posts: 11 https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Tue May 19, 2015 11:54 am
Post
by Func132 » Tue May 19, 2015 11:58 am
i have a vps that im hosting css server on
anyway, i want to install store 1.1.1 alpha it needs to connect to a mysql database
but when i launch it it doesn't connect it says "[Store] Connection to SQL database has failed, Reason: Could not find driver "mysql" "
i tried at home and works for me
!
i hope someone helps!
Thanks..
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja » Tue May 19, 2015 12:00 pm
Looks like you have an extra quote in your driver definition in databases.cfg
it is probably currently set to:
"driver" "mysql" "
When it should be:
"driver" "mysql"
Not a NFO employee
Func132
New to forums
Posts: 11 Joined: Tue May 19, 2015 11:54 am
Post
by Func132 » Tue May 19, 2015 12:02 pm
no its "mysql"
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja » Tue May 19, 2015 12:03 pm
Can you post your entire databases.cfg, censoring any sensitive information?
Not a NFO employee
Func132
New to forums
Posts: 11 Joined: Tue May 19, 2015 11:54 am
Post
by Func132 » Tue May 19, 2015 12:13 pm
"store"
{
"driver" "mysql"
"host" "********"
"database" "******"
"user" "******"
"pass" "****"
}
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja » Tue May 19, 2015 12:15 pm
Please run "sm exts list" in your server console and post the output(you may use rcon sm exts list, but not sm_rcon, sm_rcon may cut off the output).
Not a NFO employee
Func132
New to forums
Posts: 11 Joined: Tue May 19, 2015 11:54 am
Post
by Func132 » Tue May 19, 2015 12:19 pm
[SM] Displaying 16 extensions:
[01] Automatic Updater (1.6.4-dev+4624): Updates SourceMod gamedata files
[02] Webternet (1.6.4-dev+4624): Extension for interacting with URLs
[03] CS Tools (1.6.4-dev+4624): CS extended functionality
[04] BinTools (1.6.4-dev+4624): Low-level C/C++ Calling API
[05] SDK Tools (1.6.4-dev+4624): Source SDK Tools
[06] Client Preferences (1.6.4-dev+4624): Saves client preference settings
[07] SQLite (1.6.4-dev+4624): SQLite Driver
[08] SDK Hooks (1.6.4-dev+4624): Source SDK Hooks
[09] SMJansson (2.3.1/3): JSON parser/writer
[10] <FAILED> file "soundlib.ext.so": /css_server/cstrike/addons/sourcemod/extensions/soundlib.ext.so: cannot open shared object file: No such file or directory
[11] Regex (1.6.4-dev+4624): Provides regex natives for plugins
[12] Top Menus (1.6.4-dev+4624): Creates sorted nested menus
[13] <FAILED> file "flashtools.ext.so": /css_server/cstrike/addons/sourcemod/extensions/flashtools.ext.so: cannot open shared object file: No such file or directory
[14] <FAILED> file "socket.ext.so": /css_server/cstrike/addons/sourcemod/extensions/socket.ext.so: cannot open shared object file: No such file or directory
[15] GeoIP (1.6.4-dev+4624): Geographical IP information
[16] <FAILED> file "dbi.mysql.ext.so": libz.so.1: cannot open shared object file: No such file or directory
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja » Tue May 19, 2015 12:23 pm
Run "apt-get install ia32-libs" as root. Reboot the server, re-run sm exts list, and post new output. This should fix the mysql driver not loading.
Not a NFO employee
Func132
New to forums
Posts: 11 Joined: Tue May 19, 2015 11:54 am
Post
by Func132 » Tue May 19, 2015 12:32 pm
it says " lib32z1 lib32ncurses5 lib32bz2-1.0 "
when i try to install ia32-libs
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja » Tue May 19, 2015 12:33 pm
Any more detail? It is fine to let those packages install.
Not a NFO employee
Func132
New to forums
Posts: 11 Joined: Tue May 19, 2015 11:54 am
Post
by Func132 » Tue May 19, 2015 1:15 pm
i contacted the store developer and he says
its a sourcemod issue
any ideas.?
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja » Tue May 19, 2015 1:16 pm
I gave you the solution.
Which linux distro are you on?
Not a NFO employee
Func132
New to forums
Posts: 11 Joined: Tue May 19, 2015 11:54 am
Post
by Func132 » Tue May 19, 2015 1:18 pm
distro?
im using ubuntu x64
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja » Tue May 19, 2015 1:20 pm
Func132 wrote: distro?
im using ubuntu x64
What is the exact output of the command I asked you to run as root earlier?
Not a NFO employee
Func132
New to forums
Posts: 11 Joined: Tue May 19, 2015 11:54 am
Post
by Func132 » Tue May 19, 2015 1:24 pm
i didn't understand you very well
but i think that's what you want?
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
lib32z1 lib32ncurses5 lib32bz2-1.0