Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 12 Sep 1997 16:58:33 -0400 (EDT)
From:      spork <spork@super-g.com>
To:        hackers@freebsd.org
Subject:   www-sql on FreeBSD (fwd)
Message-ID:  <Pine.BSF.3.96.970912164926.3657B-100000@super-g.inch.com>

next in thread | raw e-mail | index | archive | help
  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.
  Send mail to mime@docserver.cac.washington.edu for more info.

--298516987-887655712-874066241=:943
Content-Type: TEXT/PLAIN; CHARSET=US-ASCII
Content-ID: <Pine.BSF.3.96.970912101433.24821D@shell.inch.com>

Hello -hackers,

I'd asked about this before, but I have more information now, so I'll ask
again;)  Some quick background on the issue first:

mySQL is a great database; the licenseing and permormance is much better
than mSQL from Hughes.

One of the most popular tools (for web use) with msql is w3-msql, which
provides an easy way to build a web<->database interface.

The problem is that while mySQL works fine on FBSD, the associated w3-msql
equivalent, www-sql, was developed on Linux, and doesn't compile under
FreeBSD.  I mailed the author, and got the reply shown below about
problems with a missing(?!) regex lib or somesuch.

Not being a C hacker(TM) myself, I'm asking if anyone on this list would
be interested in:

a) trying to patch it up to work on FBSD and
b) sending the author patches so that he can integrate them into www-sql

Most likely the mySQL people would like to hear about this as well, as
many people are porting their msql dbs to mysql, and are stumbling at the
www-sql point.

Thanks much,

Charles


[below is the reply from www-sql's author]
If you would like the below-mentioned tarfile, please email me privately
and I'll send it to you.
---------- Forwarded message ----------
Date: Fri, 12 Sep 1997 20:10:41 +0800 (WST)
From: James Henstridge <james@daa.com.au>
To: Charles Sprickman <spork@inch.com>
Subject: Re: www-sql on FreeBSD

Hi,

I have only had one conversation with someone else who uses FreeBSD, and
they had the same problem.  The problem seems to be that FreeBSD
doesn't have a regex library.  Since I don't have a system running
FreeBSD, I was only able to give him limited help.

I sent him an archive, containing some files that I thought might help.
The expression evaluator used in www-sql is simply the GNU version of the
shell command expr, with its user interface knocked off.  In the hope that
it might be of some use, I have included the original `expr.c' as found in
the GNU sh-utils package, and a diff against it to get an `expr.c' that
will work with www-sql.

As the problem is with the regular expression libraries, I have also
included the regex headers from my Linux system, in the hope that you may
be able to use them.

As far as I know, the library may have a different name.  As a suggestion,
It may be a good idea to get the source for the `expr' used on your
computer, and check it against the source I sent you.

I hope this helps,

James Henstridge.

P.S. - Please reply telling me if you have any success or failure.  This
  is the only way I can get www-sql working properly on systems like
  FreeBSD.  The other guy who mailed me never got back to me, so I wasn't
  able to solve the problem then.

--
Email: james@daa.com.au
WWW:   http://www.daa.com.au/~james/


On Wed, 10 Sep 1997, Charles Sprickman wrote:

> Hi,
> 
> I thought I'd ask you before hitting the mysql mailing list, whether
> you've had any reports of success on FreeBSD 2.2.2?
> 
> After running configure, I type "make" and get this:
> 
> bash$ make
> gcc -g -O2 -I/usr/local/include -I. -DHAVE_CONFIG_H  -c cgi.c -o cgi.o
> gcc -g -O2 -I/usr/local/include -I. -DHAVE_CONFIG_H  -c expr.c -o expr.o
> expr.c: In function `docolon':
> expr.c:366: storage size of `re_buffer' isn't known
> expr.c:367: storage size of `re_regs' isn't known
> expr.c:377: warning: assignment makes pointer from integer without a cast
> *** Error code 1
> 
> Stop.
> 
> ???  If you have any suggestions (or diffs:) I'd appreciate it...
> 
> I've also attached the Makefile and config.h generated by configure.
> 
> Thanks for any help you can give,
> 
> Charles
> 
> ~~~~~~~~~					~~~~~~~~~~~
> Charles Sprickman 				Internet Channel
> INCH System Administration Team			(212)243-5200
> spork@inch.com					access@inch.com
> 

--298516987-887655712-874066241=:943--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.970912164926.3657B-100000>