This site is a testing version, but all data is shared with the live forum.


Raised This Month: $ Target: $400
 0% 

MYSQL connection on linux


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
dram
Member
Join Date: Mar 2011
Old 05-05-2013 , 07:01   MYSQL connection on linux
Reply With Quote #1

Hello.

I have installed and configured mysql server & client on my linux debian 6.

But hlds, can't connect to mysql, to localhost or public host.

Where is the problem ?

I can connect using

mysql -h localhost -u userINplugin -p

Why hlds cant ?


amxx modules


name version author status
[ 1] MySQL 1.8.2-dev AMX Mod X Dev Team running

Last edited by dram; 05-05-2013 at 08:28.
dram is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 05-05-2013 , 11:03   Re: MYSQL connection on linux
Reply With Quote #2

Error message?
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
dram
Member
Join Date: Mar 2011
Old 05-05-2013 , 11:19   Re: MYSQL connection on linux
Reply With Quote #3

hmm - cannot connect

i thinking about this


meta list
Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.8.2-d ini Start ANY
[ 2] MySQL RUN - mysql_amxx_i386. v1.8.2-d pl1 ANY ANY
[ 3] SQLite RUN - sqlite_amxx_i386 v1.8.2-d pl1 ANY ANY
[ 4] Fun RUN - fun_amxx_i386.so v1.8.2-d pl1 ANY ANY
[ 5] Engine RUN - engine_amxx_i386 v1.8.2-d pl1 ANY ANY
[ 6] FakeMeta RUN - fakemeta_amxx_i3 v1.8.2-d pl1 ANY ANY
[ 7] Ham Sandwich RUN - hamsandwich_amxx v1.8.2-d pl1 ANY ANY
[ 8] CSX RUN - csx_amxx_i386.so v1.8.1.3 pl1 ANY ANY
[ 9] CStrike RUN - cstrike_amxx_i38 v1.8.1.3 pl1 ANY ANY

ANY ?

Other meta mod?
dram is offline
AmineKyo
فوق سريرك
Join Date: Oct 2011
Location: Morocco
Old 05-05-2013 , 11:26   Re: MYSQL connection on linux
Reply With Quote #4

I don't know why are you using AMX1.8.2-Devbuild, update your server and update to the official AMX/MM
__________________
AmineKyo is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 05-05-2013 , 11:47   Re: MYSQL connection on linux
Reply With Quote #5

Quote:
Originally Posted by YamiKaitou View Post
Error message?
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
dram
Member
Join Date: Mar 2011
Old 05-05-2013 , 12:56   Re: MYSQL connection on linux
Reply With Quote #6

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

else
public ip

Can't connect to MySQL server on 'xxx.eu' (111) (2003)

Last edited by dram; 05-05-2013 at 13:36.
dram is offline
alexinno
Senior Member
Join Date: Mar 2007
Location: C:\
Old 05-05-2013 , 13:45   Re: MYSQL connection on linux
Reply With Quote #7

create a symbolic link for the mysql socket in /tmp folder

look in my.cnf or whatever is the name for the mysql configuration file on your distribution where is the default location for the socket and use the ln -s .... command
Code:
man ln
if you don'k know how to use it
__________________

[IMG]http://img188.**************/img188/5787/banner2rcw.png[/IMG]
alexinno is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 05-05-2013 , 13:53   Re: MYSQL connection on linux
Reply With Quote #8

Don't create a link, us the IP instead of the DNS name
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 05-05-2013 , 19:41   Re: MYSQL connection on linux
Reply With Quote #9

First, check the firewall or....

Add directly in .sma file a cvars:

amx_sql_host
amx_sql_user
amx_sql_pass
amx_sql_db
amx_sql_type

And Recompile.

Its solve my problem with a connections in MySQL

__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
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 16:27.


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