Mailing List Archive


Back to the month index Back to the list index
Bill Krueger (r2d2@koyote.com)
Tue, 29 Apr 1997 17:49:17 -0500 

Message-Id: <199704292243.RAA01396@ns1.koyote.com>
From: "Bill Krueger" <r2d2@koyote.com>
Subject: Re: [mSQL] Help with acl - please
Date: Tue, 29 Apr 1997 17:49:17 -0500

In your insert statement, you INSERT INTO foo, which is the name of your
database. You must insert into tables only. first create a table, then
insert values into it.

                    Sincerely,

                    Bill Krueger
                    r2d2@koyote.com
                    kruegerrw@gvl.esys.com
                    Slacker Hacker

----------
> From: Andy Mitchell <afm@biotech.ufl.edu>
> To: msql-list@Bunyip.Com
> Subject: [mSQL] Help with acl - please
> Date: Tuesday, April 29, 1997 8:47 AM
>
> 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!

--------------------------------------------------------------------------
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!