Mailing List Archive


Back to the month index Back to the list index
Web Master (huntsman@www.nisu.flinders.edu.au)
Wed, 29 Jan 1997 10:41:17 +1030 (CST) 

Message-Id: <199701290011.KAA22453@www.nisu.flinders.edu.au>
Date: Wed, 29 Jan 1997 10:41:17 +1030 (CST)
From: Web Master <huntsman@www.nisu.flinders.edu.au>
Subject: Re: [mSQL] ACL file problem

On 29 Jan, dragon wrote:

<SNIP system details>

> mSQL root user jpe
>
> Hi there. I just now loaded this thing onto the system and am having
> problems installing it. The files were extracted from the tar file, by
> root, in the /usr directory. In both /usr, and /usr/bin I have msql.acl
> files created. The both are as follows:

<SNIP acl details>
 
> Currently I have 777 set for file permissions, this will change after it
> is working properly.
>
> When I run the msqld as root, this is what I see:
>
> Warning : Couldn't open ACL file: No such file or directory

Where is mSQL installed? The default is /usr/local/Minerva, where msqld
will expect to find the acl file.

>
> Now, of course, seeing this as only a warning, I then attempt, again as
> root to do the msqladmin create test, and this is what I get:
>
> mSQL Command failed!
> Server error = Permission denied

Correct - you have set the user jpe as the root user for msql - that is
the only user that can operate msqladmin (except the version option)

> So, now that I am compleatly confussed and not sure of what I did wrong,
> HELP!!! I can't find anything in the msql*.ps file about what I did
> wrong, so I am writting to you folks.
>
> Please advise and thanks in advance!

Essentially, you have to run the msqld daemon as root - generally you
would do this through your startup .rc file. Then you need to be the
defined root user to create or drop databases, and you need to be a
user defined in the acl file to do whatever you are defined to do with
whatever database - the absence of an acl file means universal access.
See page 15 of the .ps manual for database administration, page 17 for
access control. You might also check out the FAQ at

ftp://bond.edu.au/pub/Minerva/msql/faq.txt

> "If it does not say UNIX on it,,, then it is a toy!!!"
Oy - wot about Linux!! and FreeBSD and etc.....

Hope this helps. 

-- 
David Robley

WEBMASTER                          | http://www.nisu.flinders.edu.au/
NATIONAL INJURY SURVEILLANCE UNIT  | Phone +61 8 8374 0970
ADELAIDE, SOUTH AUSTRALIA          | Fax   +61 8 8374 0702

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