Raised This Month: $ Target: $400
 0% 

SQL I need fast help!


Post New Thread Reply   
 
Thread Tools Display Modes
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 15:14   Re: SQL I need fast help!
Reply With Quote #11

Database cant connect to game but why :/
skullboypl is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 15:40   Re: SQL I need fast help!
Reply With Quote #12

https://db4free.net/ i made and it isn't work in game :/ What version sm is work with Mysql ?
skullboypl is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 15:49   Re: SQL I need fast help!
Reply With Quote #13

Details: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 11/17/2016 - 15:45:29: [shopsms.smx] Error: 201. An error occured while connecting to database.
Details: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 11/17/2016 - 15:46:40: [shopsms.smx] Error: 201. An error occured while connecting to database.
Details: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
skullboypl is offline
Meitis
Member
Join Date: Jan 2014
Old 11-18-2016 , 05:05   Re: SQL I need fast help!
Reply With Quote #14

Execute this on your dedi as root:

Code:
apt-get install lib32z1
https://forums.alliedmods.net/showpo...5&postcount=33

Last edited by Meitis; 11-18-2016 at 05:06.
Meitis is offline
shavit
AlliedModders Donor
Join Date: Dec 2011
Location: Israel
Old 11-18-2016 , 10:49   Re: SQL I need fast help!
Reply With Quote #15

Quote:
Originally Posted by Mitchell View Post
Probably missing linux files for MySQL extension to work. I had this issue before (Ubuntu) but I couldn't figure it out, ended up just reinstalling a different OS (Debian 7 x64) and it started working fine.
Code:
sudo apt-get install lib32z1
that's a solution
i wouldn't switch from a distro i like (such as ubuntu) unless it's necessary :p
if anything, would do arch because pacman is apparently really good
__________________
retired

Last edited by shavit; 11-18-2016 at 10:50.
shavit is offline
Mitchell
~lick~
Join Date: Mar 2010
Old 11-18-2016 , 12:27   Re: SQL I need fast help!
Reply With Quote #16

Quote:
Originally Posted by shavit View Post
Code:
sudo apt-get install lib32z1
that's a solution
i wouldn't switch from a distro i like (such as ubuntu) unless it's necessary :p
if anything, would do arch because pacman is apparently really good
I only switch because I was missing a ton more libraries that was needed to install lib32z1 plus my vds was restricting the install space.
Mitchell is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-18-2016 , 13:47   Re: SQL I need fast help!
Reply With Quote #17

lib32z1 is already the newest version.


and still
Details: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
skullboypl is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-18-2016 , 14:27   Re: SQL I need fast help!
Reply With Quote #18

ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

GG

Please close
skullboypl is offline
thedudeguy1
Senior Member
Join Date: Oct 2014
Location: 127.0.0.1
Old 11-20-2016 , 18:56   Re: SQL I need fast help!
Reply With Quote #19

Quote:
Originally Posted by skullboypl View Post
Please close
Be sure to mark your thread as solved so others can find a solution faster if they have the same problem as you.
Edit the first post of the thread in the full editor, and you can select Solved as a thread prefix in the top-left.

P.S. I had that issue as well. It seemed like it was so much less of a simple fix than it really was.
__________________
A computer is like an Old Testament god, with a lot of rules and no mercy. -Joseph Campbell
thedudeguy1 is offline
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 11-20-2016 , 19:30   Re: SQL I need fast help!
Reply With Quote #20

You can put the path to the .sock file instead of "localhost" as the host in the databases.cfg as well by the way. If you don't have access to the command line.
__________________
Peace-Maker 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 09:14.


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