Mailing List Archive


Back to the month index Back to the list index
Mario Sergio Fujikawa Ferreira (lioux@GNS.com.br)
Sat, 4 Jan 1997 14:46:00 -0200 (EDT) 

From: Mario Sergio Fujikawa Ferreira <lioux@GNS.com.br>
Message-Id: <199701041646.OAA18695@srv1-bsb.GNS.com.br>
Subject: Re: [mSQL] Strange Database Access Denied
Date: Sat, 4 Jan 1997 14:46:00 -0200 (EDT)

> You might consider the possibility that since it is running as "nobody",
> it may never function properly (I am assuming that the "radius server" is a
> web server here) since nobody, belonging to "nogroup" has very little
> access to everything on the system. Plus, you never sent the ACL file for us
> to see if it is a permission thing with msql.

        Sorry for the lack of information, yet following the thread here goes the missing data:

        Msql daemon runs as msql user and minerva group.
        Radius daemon runs as radius user and radius group.
        I am a plain user, so that I have no extra permissions, but those that everyone else on this system would have: including the radius user.
        Here goes the permissions for my Minerva home files:

drwxr-xr-x 7 root minerva 512 Jan 2 11:03 .
drwxr-xr-x 17 root wheel 512 Dec 10 22:05 ..
drwxr-x--x 2 root minerva 512 Dec 2 16:07 bin
dr-xr-x--- 5 root minerva 512 Nov 21 22:33 debug
drwxr-x--- 2 root minerva 512 Dec 2 16:07 doc
drwxr-x--- 2 root minerva 512 Dec 2 16:07 include
drwxr-x--- 2 root minerva 512 Dec 2 16:07 lib
-r-xr-x--- 1 msql minerva 193 Jan 3 00:11 msql.acl
-rwx------ 1 root minerva 195 Dec 2 16:07 msql.acl.sample
lrwxr-xr-x 1 root minerva 43 Jan 2 11:03 msqldb -> /usr/local/export/850MB/Minerva/msql/msqldb
-rwxr-x--- 1 root minerva 865 Dec 2 16:07 run_daemon

Minerva/bin:
total 208
drwxr-x--x 2 root minerva 512 Dec 2 16:07 .
drwxr-xr-x 7 root minerva 512 Jan 2 11:03 ..
-rwxr-x--x 1 root minerva 28672 Dec 2 16:08 msql
-rwxr-x--- 1 root minerva 32768 Dec 2 16:08 msqladmin
-rwsr-x--x 1 msql minerva 90112 Dec 2 16:08 msqld
-rwxr-x--- 1 root minerva 28672 Dec 2 16:08 msqldump
-rwxr-x--- 1 root minerva 28672 Dec 2 16:08 relshow

Minerva/include:
total 8
drwxr-x--- 2 root minerva 512 Dec 2 16:07 .
drwxr-xr-x 7 root minerva 512 Jan 2 11:03 ..
-rwxr----- 1 root minerva 2433 Dec 2 16:07 msql.h

Minerva/lib:
total 64
drwxr-x--- 2 root minerva 512 Dec 2 16:07 .
drwxr-xr-x 7 root minerva 512 Jan 2 11:03 ..
-rwxr----- 1 root minerva 60312 Dec 2 16:07 libmsql.a

        The Database directory permissions:

drwxr-x--- 4 msql minerva 512 Dec 13 13:56 /usr/local/export/850MB/Minerva/msql/msqldb
        

                Here goes my acl files:

#
# Access control for mSQL
#
# Entries are of the form
#

database=extrato_online
read=www,root,lioux,-*
write=root,lioux,radius,-*
host=srv1-bsb.gns.com.br
access=local
option=rfc931

                What I need is the radius user being able to insert entries on the database, something it is being unable to perform.
                I hope this is a simple permission problem.
                Here goes my version info:

Version Details :-

        msqladmin version 1.0.16
        mSQL connection Localhost via UNIX socket
        mSQL server version 1.0.16
        mSQL protocol version 6
        mSQL TCP socket 4333
        mSQL UNIX socket /tmp/msql.sock
        mSQL root user msql
        Host Architecture FreeBSD-2.1.6-RELEASE-i386

                Thanks,
                        Mario Ferreira.
--------------------------------------------------------------------------
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!