Probably as an answer to release of Mysql 5.x, Oracle10G XE is released. Are there any plans of Oracle10G XE being as supported database for GT products?

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

Stumbled On First step;
DBD::Oracle wouldn't install :/ .mk file issue

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

With patch for Makefile.PL from the author (TIM) of DBD::Oracle, DBD::Oracle installed fine. Stubled on next step. Doing a test install of GMail against oracle xe while setting up db it gives:


Error: The environment variable ORACLE_HOME is not defined. It must be defined for the script to connect properly
ORACLE_HOME is defined (otherwise i guess DBD::Oracle wouldn't install).
Where am i goofing?

TIA
HyTC

SetEnv ORACLE_HOME /path/to/oracle in httpd.conf doesn't correct the error.

perl -MDBI -e 'DBI->connect("DBI:Oracle:host=localhost;sid=XE", "username", "password")'

works fine

perl -MDBI -e 'DBI->connect("DBI:Oracle:host=localhost;sid=XE", "username", "wrongpassword")'

throws ORA-01017 correctly. So gmail doesn't install on OracleXE

Any clues?

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

Have run out of ideas. Everything else works fine with php scripts. It's just that gmail wouldn't install despite adding it to httpd.conf. It always gives the same error:


Error: The environment variable ORACLE_HOME is not defined. It must be defined for the script to connect properly

Any ideas from GT?
Or is it that it wouldn't install on OracleXE.




Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

Hi,

Are you installing from shell or from the web? If from the web, are you sure your SetEnv directive is in the proper place? Try placing the following test.cgi in the same directory as install.cgi:


Cheers,

Alex
--
Gossamer Threads Inc.

Installed from web
Gave up after all recommendations including the SetEnv stuff in httpd.conf. It failed on admin/admin.cgi at the database setup stage. Getting it back again in httpd.conf and running the script gives

ORA_HOME: ''
Connecting ...
Failed: ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.)


Had tested with a recompiled php and everything worked fine.

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

Hi,

Your suexec is stripping out the environment, so the cgi is not getting the ORA_HOME environment variable. You need to either modify suexec to pass this environment variable through, don't use suexec, or modify all the .cgi to include:

$ENV{ORA_HOME} = '/path/to/ora/home';

at the beginning.

Cheers,

Alex
--
Gossamer Threads Inc.

Went for last option.
(1) included in test.cgi : status quo
(2) included in admin.cgi : status quo

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================