Hi Martin,
There is a minor issue, if ORACLE_HOME is not set, the DBI module fails to get a handle on the database and dies with an error that is not intuitive to the user. A more user friendly error message would be great, but this is low priority...
DEBUG: OpenCA::DBI->errno: returning local errorcode 11111 OpenCA: General error trapped 700: The compilation of the command cmdGenDB faile d. Can't call method "prepare" on an undefined value at /home/cmn090/lib/perl5/O penCA/DBI.pm line 2520.<br> Compilation failed in require at ./openca_start line 62.
OpenCA::DBI should never reach this position if DBH is not defined. Can you send me a full debug trace of the things which happened during cmdGenDB please? DBH is only once defined in the function connect. There we check the handle. After this function DBH should always be defined. So the bug looks like a Oracle specific problem or a general design bug in OpenCA::DBI.
Concerning environment variables I am using the following section in DBI.conf.template now and it works without externally setting the environment. Not sure if this 'number 1' thing is OK, though.
This is a counter for the number of the options. When I started with XML then I don't know how to count the number of options :)
You may want to include the following in the database configuration template to make modification easier for new installs.
<environment> [...] <vendor> <type>Oracle</type> <number>1</number> <option> <name>ORACLE_HOME</name> <value>/opt/oracle/OraHome</value> </option> </vendor>
Commited.
Michael -- ------------------------------------------------------------------- Michael Bell Email: [EMAIL PROTECTED] ZE Computer- und Medienservice Tel.: +49 (0)30-2093 2482 (Computing Centre) Fax: +49 (0)30-2093 2704 Humboldt-University of Berlin Unter den Linden 6 10099 Berlin Email (private): [EMAIL PROTECTED] Germany http://www.openca.org
------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
