Mailing List Archive


Back to the month index Back to the list index
john barbour (soporte@red-sol.conicyt.cl)
Tue, 25 Nov 1997 16:38:36 -0400 

Message-Id: <3.0.1.32.19971125163836.006a6b78@redesol.cl>
Date: Tue, 25 Nov 1997 16:38:36 -0400
From: john barbour <soporte@red-sol.conicyt.cl>
Subject: apache compile

Hi there people

We are having a problem compiling in the mod_auth_msql module into the
latest release of Apache, I was wondering if anyone could help...

We have tried the apache compile several times, but when we do a 'make' and
it comes to the mod_auth_msql module, it spits out an error that msql.h
could not be found.

We looked at Configuration and added in EXTRA-LIBS the path to msql.h
(/usr/local/msql2.0.3/include) but it gave us the error 'Linking not made'.
Same thing happened when we added it in EXTRA-INCLUDES. I made a soft link
to it, but still no luck.

I copied msql.h to the compile directory but the same error.

Then we edited mod_auth_msql.c so and put in the *full path* to msql.h
instead of <msql.h> which is there by default. With this modification, it
found msql.h OK but then spat out these errors:

(starting log half way through telnet session)

gcc -c -Iregex -O2 -DLINUX=2 mod_access.c
gcc -c -Iregex -O2 -DLINUX=2 mod_auth.c
gcc -c -Iregex -O2 -DLINUX=2 mod_auth_msql.c
gcc -c -Iregex -O2 -DLINUX=2 mod_browser.c
gcc -o httpd alloc.o http_main.o http_core.o http_config.o
http_request.o htt
p_log.o http_protocol.o rfc1413.o util.o util_script.o modules.o buff.o
md5c.o u
til_md5.o explain.o http_bprintf.o util_date.o util_snprintf.o mod_env.o
mod_log
_config.o mod_mime.o mod_negotiation.o mod_include.o mod_dir.o mod_cgi.o
mod_asi
s.o mod_imap.o mod_actions.o mod_userdir.o mod_alias.o mod_access.o
mod_auth.o m
od_auth_msql.o mod_browser.o regex/libregex.a
mod_auth_msql.o: In function `do_msql_query':
mod_auth_msql.o(.text+0x1b5): undefined reference to `msqlConnect'
mod_auth_msql.o(.text+0x1c7): undefined reference to `msqlErrMsg'
mod_auth_msql.o(.text+0x20e): undefined reference to `msqlSelectDB'
mod_auth_msql.o(.text+0x21b): undefined reference to `msqlErrMsg'
mod_auth_msql.o(.text+0x26b): undefined reference to `msqlQuery'
mod_auth_msql.o(.text+0x285): undefined reference to `msqlErrMsg'
mod_auth_msql.o(.text+0x2b1): undefined reference to `msqlStoreResult'
mod_auth_msql.o(.text+0x2c9): undefined reference to `msqlErrMsg'
mod_auth_msql.o(.text+0x306): undefined reference to `msqlClose'
mod_auth_msql.o(.text+0x35a): undefined reference to `msqlFetchRow'
mod_auth_msql.o(.text+0x39b): undefined reference to `msqlErrMsg'
mod_auth_msql.o(.text+0x3e1): undefined reference to `msqlFreeResult'
mod_auth_msql.o(.text+0x3ec): undefined reference to `msqlClose'
make: *** [httpd] Error 1

Very strange.

At compile time we had both msql2d (version 2.0.3) and the httpd daemons
running.

Any ideas would be much appreciated.

Thanks,

john barbour

*********************************************
Asesor técnico Fono: +56 2 697 4912
REDESOL Fax: +56 2 698 8237
http://www.redesol.cl
From gasha@crp.riga.lv Tue Nov 25 14:55:34 1997
Received: from stoat.riga.lv (root@stoat.riga.lv [194.8.12.138])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id OAA24151
        for <msql-list@services.bunyip.com>; Tue, 25 Nov 1997 14:55:29 -0500 (EST)
Received: from crp.UUCP (Received: from crp.UUCP (root@localhost)
        by stoat.riga.lv (8.8.8/8.8.8) with UUCP id VAA11552
        for msql-list@services.bunyip.com; Tue, 25 Nov 1997 21:54:19 +0200 (EET)
Received: by crp.riga.lv id AA13866
  (5.65.kiae-1 for Multiple recipients of list <msql-list@services.bunyip.com>); Tue, 25 Nov 1997 21:42:10 +0200
Date: Tue, 25 Nov 1997 21:42:09 +0200 (GMT)
From: Gatis Visnevskis <gasha@crp.riga.lv>
To: Steve McWilliams <stevemc@access.digex.net>
Cc: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: your mail
In-Reply-To: <199711242341.SAA19700@access5.digex.net>
Message-Id: <Pine.SOL.3.91.971125213545.13840A-100000@crp>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

 Hi

I now where is the problem. Netscape remember, from where html file was
received. Then it executes applet, and is watching for secutity
exception. Problem is that netscape DON't remember address when it reads
file://xxx.html

So you NEED http server, or you may try this for anonymous FTP server.

I think this is not a bug, since Netscape runs in most cases on Mac or
PC, where connecting to your own port isn't normal.

Gasha.

Makefile: You shouldn't need to change anything below this line

On Mon, 24 Nov 1997, Steve McWilliams wrote:

> 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 mlemos@acm.org Tue Nov 25 14:55:39 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 OAA24161
        for <msql-list@services.bunyip.com>; Tue, 25 Nov 1997 14:55:38 -0500 (EST)
Received: from mail.ua.pt (mail.ua.pt [193.136.80.103])
        by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id OAA16424
        for <msql-list@Bunyip.Com>; Tue, 25 Nov 1997 14:55:36 -0500 (EST)
Received: from modem01b.relay.ua.pt (mlemos@modem01b.relay.ua.pt [193.136.168.65])
        by mail.ua.pt (8.8.8/8.8.8) with SMTP id TAA09113
        for <msql-list@Bunyip.Com>; Tue, 25 Nov 1997 19:11:58 GMT
Date: 25 Nov 97 15:14:43 +0000
From: "Manuel Lemos" <mlemos@acm.org>
Subject: Re: Data Inconsistencies
To: "Jeff Ober" <msql-list@Bunyip.Com>
In-Reply-To: <01BCF97A.132BDFA0@dragon.protocorp.com>
Message-ID: <1814.268T2192T9144893@acm.org>
MIME-Version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7bit
Reply-to: mlemos@acm.org (Manuel Lemos)
X-Mailer: THOR 2.5a (Amiga;TCP/IP)

Hello Jeff,

On 25-Nov-97 13:14:39, you wrote:

>I can use the database normally, or so it appears. However, at certain
>times, I cannot narrow down what is happening at the times, data disappears,
>reappears, or corrupts. For example, in a simple table with 3 fields, one
>record duplicates itself 10 or 12 times. Large chunks of data disappear: A
>table will have all records after a specific record suddenly delete. And
>deleted data reappears: A table that has 4 records, I delete record #3
>today, and it will be back tomorrow. This has even happened with entire
>tables!

>Is there something I'm missing on using these tables? Is there some process
>that I must do to REALLY delete a record from a table (other than DELETE
>FROM...)? Is there anything I can check on the server end (the ISP claims
>everything is OK there)? Does anyone have a hint of what I can do to use
>this database without random changes, losses, and re-creations?

Maybe beg to get the serious bug fixed or simply dump MSQL. I have the
same problems that you describe when using MSQL 2.0.3 unser HP-UX and
AmigaOS/ixemul. Usually I start getting problems when I use indices for
tables even when they are unique. MSQL is very slow as it is, if you don't
use indices it becomes useless for databases with large number of records.

I am surprised that a lot of people still use it and don't notice the
problems which doesn't mean they don't have them. I've been considering
switching to another database, but I need to have the source code to build
it on the machines I use. So far I have tried PostgreSQL, but I hadn't
enough time to test it thorougly.

Regards,
Manuel Lemos

E-mail: mailto:mlemos@acm.org
URL: http://sweet.ua.pt/~mlemos
PGP key: finger://mlemos@zeus.ci.ua.pt 

--