Mailing List Archive


Back to the month index Back to the list index
Andy Mitchell (afm@biotech.ufl.edu)
Tue, 29 Apr 1997 08:47:45 -0500 (EST) 

Date: Tue, 29 Apr 1997 08:47:45 -0500 (EST)
From: "Andy Mitchell" <afm@biotech.ufl.edu>
Message-Id: <199704291347.IAA25477@snarl.biotech.ufl.edu>
Subject: [mSQL] Help with acl - please

A couple days ago I asked about what I felt was improper behaviour
for the ACL in mSQL. I only received one answer ("it works ok for
me") which provided me with no additional information. So I guess
maybe my question was not clear. I'll try again, and if anyone has
a clue (as I obviously do not ;-), I'd love to hear it.

entry from msql.acl (which is being read - even used truss to be sure):

database=foo
read=*
write=wgf
host=snarl.biotech.ufl.edu
access=local
option=rfc931

My username is afm. uid's are different between user wgf and user afm.
Interaction with the database foo yields stuff like:

snarl{afm}218: msql foo
 
Welcome to the miniSQL monitor. Type \h for help.
 
 
mSQL > insert into foo values ('diane',25)\g
 
 
ERROR : Access Denied
 
 
mSQL > update footbl set age=99 where name clike 'and%'\g
 
Query OK. 1 row(s) modified or retrieved.

An update sure seems like a write to me....what am I missing? Please?

Thanks in advance - Andy

System info:

Version Details :-
 
        msqladmin version 2.0 Beta 4
        mSQL server version 2.0 Beta 4
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform Solaris-2.5.1-Sparc
 
Configuration Details :-
 
        Default config file /usr/local/msql-v2.4/msql.conf
        TCP socket 1114
        UNIX socket /usr/local/msql-v2.4/msql2.sock
        mSQL user msql
        Admin user root
        Install directory /usr/local/msql-v2.4
        PID file location /usr/local/msql-v2.4/msql2d.pid

BTW - same problem under 2.6

Andrew F. Mitchell "If two twins are beside themselves with
Network Systems joy, wouldn't they need seats for five?"
www.biotech.ufl.edu/~afm - JAH
afm@biotech.ufl.edu
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!