mysqld in hosts.allow / hosts.deny ?

2007-09-06 Thread Pratchaya Chatuphian 
mysqld in hosts.allow / hosts.deny ?
===
Now, Can i use tcpwrapper with mysql on debian ?
If it can be used.
Which config. that i correct ?
( If i want to only allow from my LAN ( 192.168.2.x netmask 255.255.255.0 )

1.
hosts.allow
#
mysqld: 192.168.2.0/255.255.255.0


hosts.deny
#
mysqld: ALL



2.
hosts.allow
#
mysql: 192.168.2.0/255.255.255.0


hosts.deny
#
mysql: ALL



Thank you very much for advance.
Pratchaya


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]

Re: mysqld in hosts.allow / hosts.deny ?

2007-09-06 Thread Michael Shuler 
On 09/06/2007 05:43 AM, Pratchaya Chatuphian wrote:
 Now, Can i use tcpwrapper with mysql on debian ?

Yes (this is how I do a quick check on a binary w/o going to find
compiled options):

$ ldd /usr/sbin/mysqld | grep wrap
libwrap.so.0 = /lib/libwrap.so.0 (0xb7ec7000)

 If it can be used.
 Which config. that i correct ?
 ( If i want to only allow from my LAN ( 192.168.2.x netmask 255.255.255.0 )

It is the *daemon* that you wish to wrap that is the first argument in
hosts.[allow,deny] - in this case mysqld.  Your network/netmask looks
fine.  'man hosts.allow'

 1.
 hosts.allow
 #
 mysqld: 192.168.2.0/255.255.255.0
 
 
 hosts.deny
 #
 mysqld: ALL

-- 
Kind Regards,
Michael Shuler


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]