Re: Re[6]: lug-bg: mysql remote connection problem

[erinin@email.domain.hidden (Hristo Erinin)]

Zdrasti,

On Thu, 5 Jun 2003 09:08:13 +0300
Tosho Yankov <lug-bg_at_campus-bg.com> wrote:

<em class="quotelev1">> Purvo da se izvinq che ne sym dal pulno info za mashinata. eto go>

N.p. :)
Ima edin dokument na ESR koito spored men e nezamenim, ako
imash problem i iskash da popitash v niakoi mail-list za reshenie:
http://www.catb.org/~esr/faqs/smart-questions.html
Tozi dokument e cenen spored men, zashtoto uvelichava neimoverno
shansovete niakoi da uspee/zhelae da ti pomogne. Da ne govorim che 
ne gubish vremeto na horata bez da ima nuzhda :). Niakoi den shte se
hvana da go preveda na BG, ako ne e preveden vse oshte.

<em class="quotelev1">> 
<em class="quotelev1">> ( uslovno ste nareka mashinite taka :
<em class="quotelev1">> tazi na koqto iskam da se zakacha server, a drugata ot koqto se
<em class="quotelev1">> opitvam da se zakacha klient )
<em class="quotelev1">> server :
<em class="quotelev1">>  mysqladmin -p version

[cut]

<em class="quotelev1">> 
<em class="quotelev1">> klinet:  mysql -V
<em class="quotelev1">> mysql  Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu (i386)
<em class="quotelev1">> 
<em class="quotelev1">> eto rezulatat ot telnet server 3306:
<em class="quotelev1">> 
<em class="quotelev1">> telnet free 3306
<em class="quotelev1">> Trying 217.xxx.xxx.xxx...
<em class="quotelev1">> Connected to free.
<em class="quotelev1">> Escape character is '^]'.
<em class="quotelev1">> Connection closed by foreign host.
<em class="quotelev1">> 

Eto go kliucha ot palatkata!
Otvori /etc/hosts.{allow,deny} i si opishi/otpishi IP-to na klienta
v niakoi ot tezi failove. V sluchaia problemyt e che mysqld e kompiliran
s tcpwrappers support, a ti imash niakakvi pravila spored koito niamash
pravo da se connect ot IP-to na klienta ti. Mozhesh da proverish dali e taka
s tcpdmatch(8):

$ /usr/sbin/tcpdmatch mysqld [IP-to/hostname na klienta]
warning: mysqld: no such process name in /etc/inetd.conf
client:   address  [client IP]
server:   process  mysqld
matched:  /etc/hosts.deny line 3
access:   denied

Drug variant za deny e ako imash PARANOID v hosts.deny.
[quote]
The PARANOID wildcard matches any host whose name does not match its
address.
[/quote]

<p>Osven tova citiram ot http://www.fluidthoughts.com/howto/mysql-basics/

[quote]
When granting access to a user on a remote server, be sure to edit your /etc/hosts.allow file to allow access to the various hostnames and IPs you're granting access to like this:

mysqld: localhost 192.168.0.

Otherwise you may encounter this error:

ERROR 2013: Lost connection to MySQL server during query
[/quote]

:-)))

[cut]
<em class="quotelev1">> ami .. dano sym dal pulno info.

Dostatychno :))

Pozdravi ;-))


-- 
Best Regards,
Hristo Erinin
Spectrum Net Jsc.
+35929657615
	
============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================