Hi, all. I found the causes of my problems. One is that libsqlora8 need to be configured with '--with-threads=posix' option because cyrus imapd runs in multithreaded way. The other is that environment variables for OCI connection need to provided to the `master' process. The first problem is very clear. However, the second problem is still in question. When I tested some getenv() function in `master.c', I found that every environment variable such `ORACLE_HOME' or `LD_LIBRARY_PATH' was missing, though I set those variables for the cyrus user. Therefore, I added some test codes in the main() function of master.c using `putenv()' function to add some environment variables ($ORA_HOME, $TNS_ADMIN, $LD_LIBRARY_PATH, etc.), then it finally worked fine! My question is why `master' process eliminates the environment variables for the cyrus user. Is it intended for some reason? Could anybody comment on my question? Thanks in advance. -Woonsan Ko --- Woon-San Ko <woon_san@xxxxxxxxx> wrote: > Hi, all. > > I am going to explain my problem and want to hear some advices. > > I have been modifying plugins/sql.c to use oracle. > So I changed sql.c, configure.in, and configure (by autoconf). > I adopted libsqlora8 (http://www.poitschke.de/libsqlora8/) library to easily use OCI. > > When I tested with my stand alone test program using libsqlora8, it works very fine. > But when I added some valid code into sql.c, it does not work. > > After tedious digging, I found that the OCIEnvCreate (in OCI) function failed returning -1. > So, the sqlo_server_attach (in libsqlora8) function could not succeed. > > I am not advanced programmer in this field. I guessed the problem might be a security problem or > an environmental problem. > I tried to configure all environment variables for oracle for the cyrus user, by both shell > environment settings and programmatic way (by adding some putenv() codes in > cyrus-imapd/master/master.c, just for test.), but all failed. > > I could not catch any clue. (I'm using cyrus-imapd-2.2.13, cyrus-sasl-2.1.22, GNU/Linux 2.6.11 > and > Oracle 10g.) > > Could anybody give me some advice? > > TIA. > > -Woonsan Ko > > > > ____________________________________________________________________________________ > Sponsored Link > > Mortgage rates near 39yr lows. > $310k for $999/mo. Calculate new payment! > www.LowerMyBills.com/lre > ____________________________________________________________________________________ Sponsored Link Online degrees - find the right program to advance your career. www.nextag.com
