[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

msql acls trouble



Hi!

    I'm newbie in sql databases. I recently installed msqland I've got some
troubles with acls.
My /etc/msql.acl looks like this:

==============
# SuppressMail=no
# Port=4333
# Configured=yes
# MailTo=tomek
# Debug=general:query:error:key:trace

database=*
read=*
write=msql
access=local

database=test
read=*
write=tomek,-*
host=*.se.com.pl
option=ident
access=remote,local
===============

I think it means: "user tomek can write to database 'test' from any host in
domain se.com.pl, and locally, others can onlu read". But it does'nt work
for me. User tomek can only read from databse and only if I try local access
(msql test).  All write querys fail. 
If I invoke msql with hostname (msql -h rabarbar.se.com.pl
test) I get "ERROR : Access to database denied"

logs:

local access (msql test, user tomek)

[msqld] Mon Mar 16 21:08:35 1998
[msqld] Query =  insert into test values ('1','test')


[msqld] Command Processed!
 
But msql says ERROR : Access Denied

which hostanme (msql -h rabarbar.se.com.pl)

[rabarbar:tomek:~]$ msql -h rabarbar.se.com.pl test

ERROR : Access to database denied
[rabarbar:tomek:~]$


[msqld] New connection received on 7
[msqld] Host = rabarbar.se.com.pl
[msqld] User = tomek
[msqld] Command on sock 7 = 2 (Init DB)
[msqld] DBName = test
[msqld] Command Processed!
[msqld] Command read on sock 7 failed!
[msqld] Command on sock 7 = 1 (Quit)
[msqld] DB QUIT!
[msqld] Command Processed!

Any ideas?

-- 
                                                       * Tomek
(setq disclaimer 'standard) (setq NIC 'AT144-ORG)
(setq pgp-fp "53B8A68AD35A64AF A61DD53E9E5A1C0F") 


--
E-mail the word "unsubscribe" to debian-user-request@lists.debian.org
TO UNSUBSCRIBE FROM THIS MAILING LIST. Trouble? E-mail to listmaster@lists.debian.org


Reply to: