The Team Yuri Dario, working on the Unix sources with
EMX.
Fernando Lozano, documentation and support.
Mika Laitio, working on the ODBC-Interface for Sibyl and
on the GUI The file: msql2041b5.zip (243,7Kb) The new version of mSQL 2.0.4.1 build 5 for OS/2 is here!
Binaries has only been refreshed with a couple of minor changes new: now msqladmin
reports also build number. fixes: the money bug on types.c has been fixed.
As you may already imagine, Mark Prati had unfortunately to stop his work on mSQL
for OS/2, due to excess of work on his job. But he wish to come back to work with
us when he gets some spare time. Thanks for one of our first supporters!
mSQL is a lightweight client/server relational database that earned a great popularity
as a back-end for web sites. OS/2 Netlabs is supporting the effort to bring a new
port of this database to OS/2. OS/2 Netlabs is also using mSQL to build some web
sites, you will find some links soon!
README for EMX - 15/Nov/1998
Yuri Dario <mc6530@mclink.it>
http://www.geocities.com/SiliconValley/Peaks/4320
mSQL 2.0.4.1 for OS/2 Warp build 5
--------------------------------
HOW TO INSTALL:
---------------
Simply run
install.cmd [path]
where path is \public\msql2 if not specified.
You need a HPFS disk to run mSQL.
HOW TO TEST:
------------
1) start msql2d.exe
2) cd to your msql-2.0.4\src\tests directory
3) run rtest.cmd
4) look at rtest.src\*.diff: all diff files MUST have zero length; otherwise
you have got an error
Errors like 'Couldn't open data file for users' or 'Too many tables', requires
that you raise the handle limit of EMX runtime. You can do that using
SET EMXOPT=-h256 (or higher)
before running msql2d.exe
HOW TO COMPILE:
---------------
To compile mSQL 2.0.4 with emx, you need
- EMX 0.9c fix 4
- GNU Make 3.75 (rename to make.exe)
- GNU Patch 2.5
- KSH 5.2.7 (rename to sh.exe)
- GNU Bison
- a working ln.exe+cp.exe (or a similar .cmd)
Steps:
- untar original Unix distribution;
- unzip this file inside msql-2.0.x;
- apply patches to original distribution:
gnupatch -p 0 < patch.emx
- convert src\msql\Makefile.tmpl to Unix file format (0A as terminator),
otherwise makegen shell script will fail;
- enter src directory;
- create lib directory;
- run make;
- wait to complete all makes;
Configure is not needed, because config.h and site.mm are already included
in this zip.
Remember to install a Unix like shell in your path; I use ksh.exe renamed to sh.exe,
and saved in d:\bin
(that's because most unix scripts uses SHELL=/bin/sh)
For links, I use the attached script, that emulates ln and ln -s (shifting first
parameter): it works as a normal
copy (cp.exe).
Flags needed under EMX:
-Zsysv-signals enables signal management as in SystemV, otherwise emx
convention is used (and it is different from sysv).
-Zbin-files by default emx opens files in text mode: with this switch,
binary mode became the default
-Zcrtdll link dynamically with EMXLIBCM.DLL;
To remove debug info, add -s at the end of the LINK_ONLY_FLAGS macro
in src\site.mm and run make again.
BUGS:
-----
- needed at least SET EMXOPT=-h256 to run the server; otherwise mSQL returns
'too many open files error' when started from WPS
- something else?
- mSQL doesn't remove some .tmp files (sort.c): that's because mSQL tries to
rename an open file; this is allowed under Unix, but not under OS/2. Also
Unix deletes the file after closing it (and OS/2 don't do it).
The only drawback is that tmp files didn't get deleted (but mSQL works).
WHAT'S NEW IN THIS RELEASE:
---------------------------
2.0.4.1 build 5
- bug: fixed money bug on types.c
- added: msqladmin version now reports build number
2.0.4.1 build 4
- bug: fixed money bug on types.c
- added: msqladmin version now reports build number
- added msqlUserConnect()
- added pipe support to lite
- added profile management
- new mmap() emulation
- installation script
- dropped beta suffix
2.0.4.1 beta 3
- added msql.dll
- added import libraries for EMX and VAC++