Mailing List Archive


Back to the month index Back to the list index
Christopher Cavnor (ccavnor@sprynet.com)
Mon, 24 Nov 1997 15:28:56 -0800 

Message-ID: <347A0DB8.56A5@sprynet.com>
Date: Mon, 24 Nov 1997 15:28:56 -0800
From: Christopher Cavnor <ccavnor@sprynet.com>
Subject: Help!!!

Has anyone tried to install the WIN32 port of msql? I have installed it,
but I am getting access violations when I try to create a new database.
My msql.acl file looks like this:

#access control for MSQL
database=test
read=root
write=root
access=local,remote

I installed a host file that simply reads:

127.0.0.1 localhost

and my setup details follow:

Version Details :-

        msqladmin version 1.016
        mSQL server version 1.016
        mSQL protocol version 6
        mSQL connection Localhost via TCP/IP socket
        host architecture WIN32 (WIN95) 32 bit

Configuration Details :-

        Default config file /msql
        TCP socket 1112
        mSQL root chris
        Install directory /msql
        PID file location /msql

I am really stumped and I am working on a deadline, so if anyone can
offer a few hints it would be highly appreciated!

Thanks in advance,

Chris
mailto:ccavnor@sprynet.com
From stevemc@access.digex.net Mon Nov 24 18:42:01 1997
Received: from access5.digex.net (qlsMlEzxwxNYg@access5.digex.net [205.197.245.196])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id SAA25078
        for <msql-list@services.bunyip.com>; Mon, 24 Nov 1997 18:42:01 -0500 (EST)
Received: (from Received: (from stevemc@localhost)
          by access5.digex.net (8.8.4/8.8.4)
          id SAA19700 for msql-list@services.bunyip.com; Mon, 24 Nov 1997 18:41:58 -0500 (EST)
Date: Mon, 24 Nov 1997 18:41:58 -0500 (EST)
From: Steve McWilliams <stevemc@access.digex.net>
Message-Id: <199711242341.SAA19700@access5.digex.net>
To: msql-list@services.bunyip.com

Hello,

I have another JDBC<-->mSQL question for all you gurus out there:

   How can I get a JDBC applet to work with the Netscape 4.04 security manager?

Here are the details:

* I am running Netscape on the same platform as my mSQL server (a Linux 2.0.29
  host named 'sneezy')
* my html page is a LOCAL FILE on sneezy (URL 'file:/tmp/myPage.html')
* my applet is a LOCAL CLASS file on sneezy ('myApplet.class')
* my applet tries to opens a JDBC<-->mSQL connection using the following URL
  'jdbc:msql://sneezy:6543/test_db'

Note that 'sneezy' seems to be a necessary part of the JDBC connection URL,
even though its entirely a local connection.

Everything works fine if I use 'appletviewer'. The problem is that with
Netscape, its security manager throws an exception when the applet tries to
open the connection to the mSQL server. The message is:

   "Coultn't connct to 'sneezy' with origin 'local-classpath-classes'.

I guess it thinks that the applet is trying to open a connection to a host
which is different than the applet's original host (even though 'sneezy'
is the same host in both cases).

Note that I do not have an HTTP server running on sneezy. If I did I would
try loading my html page using 'html://sneezy/myPage.html', which would
probably fix this problem.

I've hunted around in the Netscape docs and various FAQs but do not see a
solution yet.

Any ideas?

Thanks in advance,
stevemc@access.digex.net
From adamneat@ipax.com.au Mon Nov 24 19:50:40 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id TAA29197
        for <msql-list@services.bunyip.com>; Mon, 24 Nov 1997 19:50:39 -0500 (EST)
Received: from kryten.ipax.com.au (kryten.ipax.com.au [203.29.72.3])
        by mocha.bunyip.com (8.8.5/8.8.5) with SMTP id TAA13257
        for <msql-list@bunyip.com>; Mon, 24 Nov 1997 19:50:36 -0500 (EST)
Received: from michy.noc.ipax.com.au (michy.noc.ipax.com.au [203.29.72.6]) by kryten.ipax.com.au (8.6.11/8.6.9) with SMTP id HAA09175; Tue, 25 Nov 1997 07:31:00 +1100
Message-Id: <199711242031.HAA09175@kryten.ipax.com.au>
Comments: Authenticated sender is <adamneat@mail01.ipax.com.au>
From: "Adam Neat" <adamneat@ipax.com.au>
Organization: IPAX Systems
To: msql-list@bunyip.com
Date: Tue, 25 Nov 1997 13:38:14 +0000
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: what does this mean?
Reply-to: adamneat@ipax.com.au
CC: adamneat@ipax.com.au
Priority: normal
X-mailer: Pegasus Mail for Win32 (v2.54)

Hello

can someone tell me what this is all about? Ive seen this error in the
archives and all of a sudden when doing a insert into blah command via
a CGI file, this appeared:

Welcome to the miniSQL monitor. Type \h for help. mSQL > ERROR : Error
reading table "CUSTOMERS" definition (No such file or directory) mSQL
> Bye!

Could anyone shed some light?

Regards

Adam
+-------------------------------------------------+
| Adam Neat |NOC Tel: 03-9887-1984 |
| National Systems Manager |NOC Fax: 03-9801-8533 |
| IPAX Systems - Australia |http://www.ipax.com.au|
| Mobile: 0414-348-187 |adamneat@ipax.com.au |
+-------------------------------------------------+
From joh@shore.net Mon Nov 24 19:56:29 1997
Received: from relay1.shore.net (root@relay1.shore.net [192.233.85.129])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id TAA29335
        for <msql-list@services.bunyip.com>; Mon, 24 Nov 1997 19:56:28 -0500 (EST)
Received: from northshore.shore.net (joh@shell1.shore.net [192.233.85.1])
        by relay1.shore.net (8.8.7/8.8.7) with ESMTP id TAA00172;
        Mon, 24 Nov 1997 19:56:27 -0500 (EST)
Received: (from Received: (from joh@localhost)
        by northshore.shore.net (8.8.7/8.8.7) id TAA08677;
        Mon, 24 Nov 1997 19:56:24 -0500 (EST)
Date: Mon, 24 Nov 1997 19:56:23 -0500 (EST)
From: Jean-Olivier Holingue <joh@shore.net>
To: Bill Harris <billh@airmail.net>
cc: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: mod_auth_msql.c
In-Reply-To: <347A0700.59E2B600@airmail.net>
Message-ID: <Pine.SUN.3.96.971124195433.7817A-100000@northshore.shore.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

It works wery well; but I suggest you get the one modified by Vivek Khera;
check http://www.kcilink.com

HTH
Jean-Olivier Holingue
joh@shore.net

On Mon, 24 Nov 1997, Bill Harris wrote:

> Does anyone know if the mod_auth_msql.c module for apache supports
> 2.0.x ? I haven't tried to compile it yet, do I just change the
> include and library paths to build it for 2.0.x?
>
> Bill
> --
> ----------------------------------------------------------------------
> Bill Harris KC5YZQ
> Internet America (SYSTEMS)
>