Mailing List Archive


Back to the month index Back to the list index
William Quay (wquay@web-savvy.com)
Wed, 12 Nov 1997 05:56:50 -0500 

Message-ID: <34698B72.16645F5E@web-savvy.com>
Date: Wed, 12 Nov 1997 05:56:50 -0500
From: William Quay <wquay@web-savvy.com>
Subject: W3-msql problem doing insert

Hi Everyone,

I am new to mSQL & w3-msql, so please excuse me if some of these
questions are not-too-bright. I will learn!

The doc my ISP has made available is a bit sketchy, so perhaps that is
the problem, too...

Here's my immediate problem/question:

I can set up web-based forms to query my database(s), but get an error
               (ERROR : Access Denied)
when I try to do an update.

It seems like this is a privileges problem? My msql.acl looks like this:

# Enable read & write for everyone, but only local
database=*
read=*
write=*
access=local
host=*
# test above

# For any other database, I let only myself read and write them:
# database=*
# read=*
# write=websavvy
# access=local
# host=*
# the above seems to work for read access, but not for web updates

The w3-msql code looks like this:

<!
   $sock = msqlConnect("localhost");
   if ($sock < 0)
   {
     echo("Error : $ERRMSG\n");
   }
   if (msqlSelectDB($sock, "areacodes") < 0)
    {
      fatal("Error : $ERRMSG\n");
    }
        
   if (msqlQuery($sock, "insert into areacodes values
(999,'999','999','9')") < 0)
    {
      echo("ERROR : $ERRMSG\n");
    }
      else
    {
      echo("<B>success</B>\n");
    }
>

Guidance, anyone?

TIA!

Bill Quay
From jmm@rccn.net Wed Nov 12 07:04:42 1997
Received: from wep.rccn.net (phobos.rccn.net [193.136.7.17])
        by services.bunyip.com (8.8.5/8.8.5) with SMTP id HAA01349
        for <msql-list@services.bunyip.com>; Wed, 12 Nov 1997 07:04:41 -0500 (EST)
Received: from dione.rccn.net by phobos.rccn.net with SMTP (PP);
          Wed, 12 Nov 1997 12:02:35 +0000
Message-ID: <34698EAC.4AA86E11@rccn.net>
Date: Wed, 12 Nov 1997 12:10:36 +0100
From: Joao Mendes Moreira <jmm@rccn.net>
Organization: FCCN
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
To: yuq-msql@wayx.com
CC: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: H~e~l~p~,how can I REALLY delete!!!!!!!!!!!
X-Priority: 3 (Normal)
References: <3.0.32.19971112131911.006867c4@marcus>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

yuq-msql@wayx.com wrote:
>
> hi,all
>
> It is me again.why no one answered me?My customer are going to kill me
> tomorrow if I can not REALLY delete !
>
> This time ,my question is about delete.
> Does the statement "Delete from <tablename> where <logic conditions>
> "REALLY delete the contents physcially?I found the delete statement is
> something LOGICALLY,it doesn't REALLY REMOVE those rows from physcial
> files.How can I REALLY DELETE those rows ,so I can reduce the file size?

        Hi,

        Please try this:

        Dump the database for posterior restore (with msql commands).
        Backup the database filesystem for safety reasons.

        Drop the database.(with msql commands)
        Restore it.

        I use to do this with informix-SE systems. It is healthy for the indexs
to ...
        
        Good Luck,
        Joao Moreira

P.S.: You can always create a new database from the ascii file for
experimental reasons ..

>
> thanks
> any advice please mail to yuq-msql@wayx.com
> you are higly appreciately.
> johnny.
From ali@cafe.sdc.uwo.ca Wed Nov 12 08:58:15 1997
Received: from cafe.sdc.uwo.ca (cafe.sdc.uwo.ca [129.100.95.69])
        by services.bunyip.com (8.8.5/8.8.5) with SMTP id IAA02857
        for <msql-list@services.bunyip.com>; Wed, 12 Nov 1997 08:58:14 -0500 (EST)
Received: from ali by cafe.sdc.uwo.ca with smtp (Exim 1.71 #2)
        id 0xVdIm-0007Px-00; Wed, 12 Nov 1997 08:57:52 -0500
Date: Wed, 12 Nov 1997 08:57:51 -0500 (EST)
From: "A. R. M." <ali@cafe.sdc.uwo.ca>
To: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: Is 2.0.3 Stable Now?
In-Reply-To: <710.255T868T3621662@thule.no>
Message-ID: <Pine.SGI.3.95.971112085512.28058A-100000@cafe.sdc.uwo.ca>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Wed, 12 Nov 1997, Petter Nilsen wrote:

->ali@cafe.sdc.uwo.ca (A. R. M.) wrote:
->
->> Since I haven't seen any complaints in the past few days about 2.0.3, I
->> assume it's stable now, right?
->
->Hmm, well, here it aborts with "received sig 11" whenever a connection is made
->to it. Intel Linux 2.0.30 here. 2.0.2 works here, but the infamous bug in the
->debugging on api is still present, making it useless for debugging.

Well, I went ahead and installed 2.0.3 on both:
SGI IRIX 6.2 and
486 Linux 2.0.2

Works fine. Without any indices though. Indices kill the darn thing when I
try to "update". So, I dropped them. _Slightly_ slower (a second?) but
works fine.