I don't use Witango 5.5 for production on OS X, I use windows for
production. But I develop on OS X, and have setup several OS X
servers running witango.
You should install the latest ODBC SDK from Openlink at http://
www.openlinksw.com/
I use drivers from Actual Technologies http://
www.actualtechnologies.com/ to successfully connect to MS SQL, and
MySQL from OS X, panther or tiger.
The ODBC Manager in Openlink's SDK is free, and the drivers from
actual are almost free, $30.
I have not tested actual drivers in prod environment, so I have no
idea how they will hold up under load. For production environment, I
would probably recommend shelling out the dough for Openlink MySQL,
and/or MS SQL drivers.
This is from memory, but to get to work on Witango,
1. Install clean witango 55, and make sure it is running by serving
tml or taf files.
2. Install Openlink ODBC manager.
3. Install Actual Drivers, and setup DSNs you need, test with driver
GUI.
4. Now you need to connect from witango to db, witango should include
these lines in witango startup file:
# Set up environment for ODBC driver manager so we know which
config files the driver manager will use
ODBCINI=/Library/ODBC/odbc.ini
export ODBCINI
ODBCINSTINI=/Library/ODBC/odbcinst.ini
export ODBCINSTINI
This sets up environment variables so that witango will see your
SYSTEM DSNs, not your user DSNs.
Do not start or restart witango unless you set these vars in a shell
script of something. So, best way to start/stop witango, is to use
the system starter, like:
sudo SystemStarter start "WITANGO55"
you can exchange start|stop|restart in above command. This will use
the witango 55 startup item script and make sure the ODBC environment
vars are always set correctly. If you wish for witango server to see
a users user DSNs, then you would have to change these vars to point
to the appropriate places.
Also, change witango.ini file to point to:
ODBCDMLIBRARY=/usr/lib/libiodbc.dylib
I believe that should do it.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Jul 4, 2005, at 4:18 PM, Richard Bates wrote:
Please - suggestions to getting Witango Server v5.5 working with
Apache v1.3 and MySQL v4.1.12 on OS X v10.4.1
I've tried various ODBC drivers, but none with success:
- MySQL ODBC v3.51.11
- Actual ODBC Driver for OpenBase
- OpenLink MySQL
I've added the lines in /Library/StartupItems/Witango_5.5/
Witango_5.5 so that ODBCINI and ODBCINSTINI variables are exported.
I think I've got closest to success with the OpenLink driver.
When I use /Applications/iODBC/iODBC Test.command I can
successfully execute SQL commands on the database via the OpenLink
driver
The witangoevents.log includes the line
[ 192] 2005-07-04 18:07:58 START INFO ODBC Interface:
Enabled
which I guess is good.
Now trying to access this database - called 'family' - via a
simple .taf file with a 'search' command, with Witango debug turned
on, I get:
[Application File] [7] START /~rjsb/family.taf
WitangoServer
[Results Action] [7] Results
[Search Action] [9] Search : family
[Datasource] [9] No existing connection to the data
source found, creating a new connection. DSN: odbc.family; User:
root;
[Error] [4683] -4 Unable to connect to the specified
data source. OpenLink MySQL Lite Driver
[Datasource] [4683] Unable to open a connection to
odbc.family due to an unknown error during connection
[Datasource] [4684] Total Connection in Datasource Pool:
0; Max connections for the host: 0; Current connections in use for
the host:
[Error] [4684] -4 Unable to connect to the specified
data source. Verify that data source is properly configured and
that database server is online.
Please - what I'm doing wrong.
Thanks very much.
Richard
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
