Mailing List Archive


Back to the month index Back to the list index
Thomas Hintze (hintzet@uni-trier.de)
Wed, 08 Jan 1997 14:03:33 +0000 

Message-Id: <32D3A935.74CA@uni-trier.de>
Date: Wed, 08 Jan 1997 14:03:33 +0000
From: Thomas Hintze <hintzet@uni-trier.de>
Subject: Re: [mSQL] IS W3-MSQL JUST FOR EXPERTS,HUGHES?

Projeto CINEMA BRASIL wrote:

>
> PLEASE could any kind member of this list forward me a simple example with:
> 1 - A STEP-BY-STEP install procedure
> 2 - A pre-prepared database with let's say 30 fields x 30 columns
> in tab-delimited plain text format
> 3 - instructions of how to IMPORT this text database into the mSQL dB
> 4 - HTML pages of form search and RESULT
>

Pedro,

I had some difficulties too in configuring the w3-msql interface.
I think you are right when you are saying the w3-msql documentation
should be better. BUT, in my opinion Bambi and all those volunteers
have done a GREAT JOB by having done many alpha- beta- or whatsoever
tests for _us_ to get the programm running. And since the program
is for FREE (o.k. at least for us educational guys) we should have a bit
of patience and a bit more trying and testing on our own.
AND I think we should assisst Bambi in making the whole project
even better, like i.e. writing an appropriate instruction for others.
Or would you like to buy a well (?) documentated commercial SQL database
from i.e. M$ for only about 1600 US $.

So here is what finally worked for me installing w3-msql:

1. Goto '/your/path/to/msql/misc/'
   and change the paths in the script 'setup_www' to
   the paths of your system:

   My path is: '/usr/local/Msql/misc/setup_www'

   Should look in the script like:

        =========================================================
        #!/usr/local/Msql/bin/lite

        /*
        ** Create the empty databases
        */

        echo ("Creating the empty databases ...");
        if (system("/usr/local/Msql/bin/msqladmin create w3-msql") != 0)
        {
                fatal("Error creating databases");
                exit(1);
        }

        if (system("/usr/local/Msql/bin/msqladmin create bookmarks") != 0)
        {
                fatal("Error creating databases");
                exit(1);
        }

        [...]
        ======================================================

2. Execute '/your/path/to/msql/misc/setup_www'

3. Before you start working with databases I would recommend to
   try the well known 'HELLO WORLD' first, to see
   whether the interface is setup correctly. So you can use
   2 simple HTML files I have included:
        
        - 'go_hello.html' is the calling script:

        ==========================================================
        
        <HTML>
        <HEAD><TITLE>GO HELLO - Script calling Hello World</TITLE></HEAD>
        <BODY>
        <P>
        Start the w3-msql test programm "Hello World"
        </P>
        <P>
        <FORM METHOD=GET ACTION="/cgi-bin/w3-msql/bookmarks/hello.html">
        Press a key.
        <INPUT TYPE=SUBMIT VALUE="Submit it">
        <INPUT TYPE=RESET VALUE="No submission">
        </FORM>
        </P>
        </BODY>
        </HTML>
        ========================================================

        I put the sample files in the dir 'bookmarks' below my
        the servers root. Should be i.e. '~/bookmarks' with your ISP.

        Be sure only to use GET in your <FORM METHOD=...> statement.
        POST leads to a runtime error (thanks Ben :-).
        

         - as you can see above a file 'hello.html' is called:

        ==========================================================
        <HTML>
        <HEAD><TITLE>Hello World from W3-mSQL Interface/TITLE></HEAD>
        <BODY>
        <CENTER>
        <H1>w3-mSQL says:</H1>
        <P>

        <!
        $sock = msqlConnect();
        if ($sock < 0)
        {
                fatal("Error : $ERRMSG\n");
        }
        /*
        This is how you can insert comments (C-style)
        */
        echo("Hello World\n");
>

        </P>
        <\CENTER>
        </BODY>
        </HTML>
        ========================================================

         The ouput in your browser window should look like this:

                W3-msql says:

                Hello world

        Depending on the server configuration you probably
        have to do something with the 'msqlConnect()'. Porbably
        inserting the servers' address. But I am not totally sure
        about this.
        

4. If all this works well, try the sample database 'bookmarks'
   which comes shipped with msql-sources.

To import ASCII 'databases' you can use 'msqlimport'. If you
want to know how the relevant file must be formatted, just
'msqlexport' a sample database like bookmarks.

Hope this helps

        Thomas 

-- 
*--------------------------------------------------------*
* Dr. Thomas Hintze   | phone:++49 (0)651 47163          *
* Kurfuerstenstr. 13  | fax:++49 (0)651 201-3809         *
* D-54295 Trier       | e-mail: hintzet@uni-trier.de     *
* Germany             | http://www.hintze-online.com/sos *
*--------------------------------------------------------*
--------------------------------------------------------------------------
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!