Mailing List Archive


Back to the month index Back to the list index
Brian Lavender (brian@brie.com)
Thu, 10 Apr 1997 02:37:43 -0700 

Message-Id: <2.2.32.19970410093743.00718ff8@popd.ix.netcom.com>
Date: 	Thu, 10 Apr 1997 02:37:43 -0700
From: Brian Lavender <brian@brie.com>
Subject: [mSQL] good/bad install? Running tests and command line operation

Configuration is at end before the sig.
>From looking at the following have I installed msql correctly?
I have been reading a book regarding sql and it shows commands entered from
a prompt. How do I do that?
Plus if you can answer the questions embedded below in my results that would
be great. Configuration is at the end.

When I fire up the server I get the error shown (Fig 1). When I was
building msql I accepted the default at the following question
Directory for PID file? [/var/adm]

After running setup I edited the site.mm file so the variable looked like
this as recommended in the faq
EXTRA_LIB=

 When I executed the command
brie.com$ /usr/dom/xbrie/brian/Minerva/bin/msqladmin create test

I received the response
Database "test" created.

Does this mean an empty table "test" has been created or is this a database
that comprises a set of tables? I looked at the next test in the readme
file. The problem is I don't see any file named sample.msql and there is no
tests directory. Did I miss something? The command will not work obviously.

brie.com$ /usr/dom/xbrie/brian/Minerva/bin/msql test < sample.msql

Thanks,
Brian

(Fig 1)
brie.com$ /usr/dom/xbrie/brian/Minerva/bin/msqld&
[1] 1931
brie.com$
 
mSQL Server 1.0.16 starting ...
 
Couldn't open PID file: Permission denied
Warning : Couldn't open ACL file: No such file or directory
Without an ACL file global access is Read/Write

Configuration

IRIX cube 6.2 03131015 IP22

SGI - I am not sure of the processor

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 brian
        Host Architecture IRIX-6.2-IP22
----------------
Brian Lavender
Brie Web Publishing
Owner
Napa, CA
(707) 226-8891

Brie Business Directory - Napa Valley http://www.brie.com/bbd

"Sometimes our only obstacle is the one in our minds."

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