trading-shim Frequently Asked Questions
Certain recurring questions tend to come up in mailing list and support
contexts; the links below address or point to further resources about
the most common areas of inquiry.Show Categories

Walkthrough of basic 'shim' database setup

Let's set up a mysql database to test in. We need a mysql userid, which
should be other than the mysql 'root' account, with basic 'USAGE' rights in
the day to day operation of the shim. Here, we also grant 'SUPER' privleges
to the end user account here, as we are in a testing mode, and need to force
in this global right, to turn on options for ACID transaction processing to
be strictly observed. The 'SUPER' rights may be removed from the account
once the database is set up, but it is convenient yo leave in place on a
testing developmental box. Note also, that for simplicity on a testing box,
we do not key a password on the mysql 'USAGE' rights account.
Note: this is a set of instructions for shim versions issued prior to
March 2007; After February, 2007, the second set of instructions, wheich are
more granular as to security matters, would apply:

Then we edit /src/once.c , and src/data.c ; and
bin/includes for your site specific values.

The file: once.c has entries for the host IP (no hostname to network IP
lookup is presently performed -- use numeric IP's for now), and port (the
default is: 7496) to connect to a running TWS instance at.

The file: data.c has similar entries for the database server, dataset,
userid, and optional password keying, and more.

So now we start the TWS, enable socket connections [Configure|API], and set
the permitted (wrapper enabled Host IP list) to include the 'locahost' value
of '127.0.0.1', and the other IP's of the units permitted to conenct to that
TWS instance [Configure|APITrusted IP addresses], [Create], (values),
[Apply]

[herrold@couch shim-070202]$ ./shim --data
The trading shim has finished program initialization, including the
construction of successful connections to the database and IB tws.
quit;
[herrold@couch shim-070202]$

Success -- setting up logging, as into a pipe, so that we can watch the
shim's interaction with the TWS comes next.Last modified: Tue, 27 Mar 2007 18:23:53 -0400