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 [EMAIL PROTECTED]
TO UNSUBSCRIBE FROM THIS MAILING LIST. Trouble? E-mail to [EMAIL PROTECTED]
