Mailing List Archive


Back to the month index Back to the list index
Bill Wilson (atijapan@gol.com)
Wed, 11 Sep 1996 05:05:13 +0900 (JST) 

Date: Wed, 11 Sep 1996 05:05:13 +0900 (JST)
Message-Id: <199609102005.FAA00892@gol1.gol.com>
From: atijapan@gol.com (Bill Wilson)
Subject: [mSQL] Newbe - wdb/w3-msql permission denied error

Been fighting this problem for over a month, and now posting on the mail list.

I have installed msql on a server (bsdi/NCSA) for which I do not have root p
ermissions. msql is running as:
% cd usr/local/etc/httpd/msql/bin
% ./msqladmin version
Version Details :-

        msqladmin version 1.0.10
        mSQL connection Localhost via UNIX socket
        mSQL server version 1.0.10
        mSQL protocol version 6
        mSQL TCP socket 4333
        mSQL UNIX socket /tmp/msql.sock
        mSQL root user connpro

There is another msql installation running on the same host as:
%msqladmin version
Version Details :-

        msqladmin version 1.0.14
        mSQL connection localhost via TCP/IP
        mSQL server version 1.0.14
        mSQL protocol version 6
        mSQL TCP socket 1112
        mSQL UNIX socket /dev/msql
        mSQL root user root

I can do simple manipulations in shell to the ordinary user "connpro" instal
lation of msql by entering the dir where the msql exe's reside by typing "./
***" at the command prompt (for instance "./relshow test") The same command
without the "./" calls on the "root" installation of msql and thus gives an
"Access to database denied". The access denied problem also occurs when usin
g cgi scripts to access the db, as they seem to be calling on the root intal
lation rather than the user installation?? The particular scripts I am using
 are WDB and w3-msql. I have the acl permissions set to allow anyone, and th
eir family, access the db.

Is there anyway to check which installation WDB or w3-msql is calling? Am I
completely off track this problem? I have done just about everything I can t
hink of and haven't found a solution so far. Any point in the right directio
n would be greatly appreciated.

Bill Wilson

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