Make sure that your witango user has access to read your system odbc.ini file.
The witangoctl script assumes the standard install location of the witangod file. If it is in a different place, just open the script with a text editor and change the variable assignment for the path.
I think that is it.
Robert.
On Thursday, July 17, 2003, at 11:39 AM, Robert Garcia wrote:
It is possible for Apple to see the system dsn's. It has everything to do with how the environment variables are set when witango is started.
First, you need to know the location of the odbc.ini file that your version of the odbc manager/framework is using to store sys dsn's. For me it is:
/library/ODBC/odbc.ini
I am using the latest version of the iODBC manager from openlink, I don't like apple's odbc manager at all. But either will work. The next step is making sure that the ODBCINI environment variable is set to this location when Wtiango starts. So if you start the terminal, you would to something like:
setenv ODBCINI= /library/ODBC/odbc.ini sudo witangod
However, you want witango to start from the startup items folder and see your system dsn's, right? So, the issue is that the standard terminal opens up in tsch mode, and environment variables are set using the above method. However, the startup items scripts are run in bash mode and the environment variables are sent differently. Like so:
ODBCINI= /library/ODBC/odbc.ini export ODBCINI
So all you have to do, is add the above lines to your startup items script before the line that starts witangod. Then your server will see the system dsn's, and will not see the user dsn's. Make Sense?
The only thing different accross installations is where your location of the system ODBC.ini file is.
Also, I didn't like the fact that if I wanted to restart the witango server, I had to set the environment variable, and sometimes restarting didn't work.
So I hacked the apachectl script and made it work with witango. It is very cool. If you put the witangoctl script in your in your /usr/sbin/ folder, then you can call the script from any location when you open the terminal, no worries on changing the directory first, the script takes care of all of that for you. You can type this from any terminal, from any directory:
sudo witangoctl start //starts the server sudo witangoctl restart //restarts the server sudo witangoctl stop //stops the server
There are other features in the script left over from the apachectl script that I am not using at all. It is a quick hack and only works right if you installation is all up and running correctly. Feel free to modify it and send me it back if you don't mind.
I am attaching a modified startup items file, and the witangoctl script. they are both stuffed, and should retain there 'executable' attribute. But you need to make sure both of these files are set to be executable.
I posted this to the beta list many moons ago. I went around with Andre from StoneSteps and Witango and got no help on these issues, and ended up spending a whole 3 day weekend figuring it all out. I don't want to even tell you how many different ways I tried to set the env vars properly. I also sent this information in to witango a long time ago, but they have not modified there startup items or added any info in their docs.
Hope this helps. Sorry you didn't see my earlier post.
Robert.
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf<witangoOSXServerHelp.sit>
On Thursday, July 17, 2003, at 10:58 AM, Roland Dumas wrote:
As a user process, witango seems not to have access to system DSNs. This is where the errors come from that have had me stumped for the last week or more. Therefore the DSN on the server must be a user >> DSN.
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
