Mailing List Archive


Back to the month index Back to the list index
Kenneth.Holmlund@tp.umu.se
Wed, 25 Sep 1996 9:12:39 METDST 

From: Kenneth.Holmlund@tp.umu.se
Message-Id: <199609250712.JAA01241@minerva.tp.umu.se>
Subject: Re: [mSQL] alternative admin tools?
Date: Wed, 25 Sep 1996 9:12:39 METDST

>
> > Hi,
> >
> > I'm the guy who recently was awarded stewardship of a big msql database
> > and I'm scrambling to learn msql. I have version 1.0.14 installed on my
> > own virtual server so i'm using that to learn msql, but the actual
> > database i'm supposed to be in charge of?...I do not and WILL NOT have
> > telnet access to the machine where the database resides. Can anyone point
> > me to an easily configurable cgi I can install so that I can add, modify
> > and delete records in this database via my browser?
> >
> >
> > thanks a million...
> >
Well, all you need is to do is to use the admin tools on your own
unix machine.
You have to make sure the databases you want access to are open
for editing from your remote machine and by you - this is done
in the msql.acl file.
"msql -h my.host.org mydb" should then do the trick.
Only thing you won't be able to do is to create/delete a complete
database (i.e. msqladmin create mydb).
This is usually a pretty rare thing to do and it can easily be fixed
through a password protected cgi-script that runs msqladmin (a shell
script would do fine).
You can of course also design rather advanced cgi administration
tool using for example PHP/FI (http://www.vex.net/php/) but often
it's convenient with direct msql access too.
Kenneth 

--
  _____________________________________
 / Kenneth Holmlund                    \ 
|  Dept. Theoretical Physics            |
|  Umee University                      |
|  S-901 87 Umee                        |
|  Sweden                               |
|  phone: +46-(0)90-167717              |
|  fax:   +46-(0)90-169556              |
|  email: Kenneth.Holmlund@TP.UmU.SE    |
|  web: http://www.tp.umu.se/~holmlund/ |
 \___________________________ _________/
--------------------------------------------------------------------------
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!