[ts-gen] foreign key constraint fails during setup.sql

[Bill Pippin]

To whom it may concern --- I'm reposting the following story of how
a user got the shim to work on a mac.

I'm taking this liberty since: the message is part of a dialog that
began on-list; the text indicates that it is meant for public
readership; it's such an excellent story of how to get the shim
running on a mac; in the sources, where my email address is listed,
I warn that "msgs may gate to the list"; and such dissemination is,
after all, the price of free support.  By the way, for those who
need privacy, please email to our commercial email support address,
support at trading-shim.com .

------- Forwarded Message follows --------------------------------------

Bill,

Thanks for the detailed analysis your suspicion of a lib problem set  
me off looking into the libs.

After a few dead ends like trying on a clean machine. I started  
questioning the MYSQL libs and the Mysql installation turned out to be  
the problem.

The mac packages for Mysql from Mysql DB (now Sun) specifically:
http://dev.mysql.com/downloads/mysql/5.1.html#macosx-dmg
Do not work for shim and who knows probably other things.

>From here is an attempt at a better installation report for shim
on Mac.  

Instead if one installs the mysql package from macport project:
http://www.macports.org/	and then

1.  sudo port install mysql5

Here is a howto on that;
http://systems.takizo.com/2008/06/09/
install-mysql5-server-on-apple-mac-leopard-with-macports/

2.  Shim needs a change to my.cnf which is strangely is expected
to be in /opt/local for this distribution
[mysqld]
transaction-isolation = SERIALIZABLE

Then for shim one needs three changes to the Makefile, all simply  
pointing to the location of mysql:

3.
"
CPPFLAGS := -I/opt/local/include/mysql5/mysql

SQL      := $(shell /opt/local/lib/mysql5/bin/mysql_config --libs)
TWO      := $(filter %/mysql,$(SQL))	\
             $(filter %client,$(SQL))
LIB      := $(TWO) -lm -L/opt/local/lib/mysql5/mysql
"

4.  make the shim and checked by running it and got the help output.

5.  Source the setup.sql from the mysql client as per the instructions
in  the doc directory, start TWS (I used my paper account) and then
enable API and local  connections.

6.  Started the shim with shim --data

I got a allow connection question from TWS twice and then the shim was  
up and running with the paper account. ;-)

- - Ric