ezOracle issue --allow-root-user parameter doesn't work when running script

Monday 31 January 2011 11:27:56 pm

I am following the Oracle installation README and am at the part where I am to run "ora-initialize.sh" to test the Oracle DB. The root user has all the needed ENV variables set correctly and the script fails at:

Testing PHPs Oracle support [ Success ]
Looking for eZ Publish installation [ Success ]
Testing eZOracle extensionRunning scripts as root may be dangerous.
If you think you know what you are doing, you can run this script with the
root account by appending the parameter --allow-root-user.

Appending "--allow-root-user" does nothing. Also tried "--php-exec=/usr/bin/php --allow-root-user" to no avail. Fine, so I "su oracle" and set all variables again. This time the script tells me that:

./ora-initialize.sh: line 185: /var/www/htdocs/extension/ezoracle/scripts/.ezoracle_test.php: Permission denied
Testing PHPs Oracle supportrm: cannot remove `/var/www/htdocs/extension/ezoracle/scripts/.ezoracle_test.php': No such file or directory
[ Failure ]
Your PHP installation does not have support for Oracle (OCI8)
compiled in and enabled.

Now I know that PHP has OCI8 support. I compiled it, it's being loaded in php.ini and I can connect to my local instance from php/apache.

I am very new to EzPublish (my first day in fact) and I'm not one to ask for help without exhausting available resources. My DB is already configured with tablespace/user. I just need to get past this step!

Thanks in advance for any help.

Tuesday 01 February 2011 10:24:22 am

ps: I added a check for anough fs permissions for creating temp files in the latest svn version at http://svn.projects.ez.no/ezoracle/trunk/extension/ezoracle/bin/shell/ora-initialize.sh.

Can you please test?

Principal Consultant International Business
Member of the Community Project Board

Tuesday 01 February 2011 9:44:19 pm

Issue #017904 has been created. Although based on the SVN script you may have already resolved it.

I'm not a very patient individual so I decided to give the Manual installation a try based on:

http://doc.ez.no/var/doc/storage/generated/database_extension_2_0.pdf -- I was able to successfully create the first 2 functions with (i.e.): sqlplus username/password@XE @extension/ezoracle/sql/{SQL file}

I'm at Creating a clean database and this is what I get:

# php bin/php/ezsqlinsertschema.php --allow-root-user --type=oracle --user=orc**** --password=pass*** share/db_schema.dba XE
With great power comes great responsibility.
You have 10 seconds to break the script (press Ctrl-C).
Could not initialize database:
* Tried database 'XE' locally with user 'orc*****' and with a password
* No database handler was found for 'oracle'

I found issue http://issues.ez.no/IssueView.php?Id=15109 and it shows a fix for this in 2.0.1 of the extension. I think I'm running 2.0.3 with eZP 4.3-full. The same error above occurs when using "--type=ezoracle".

So I read your suggestions here: http://projects.ez.no/ezoracle/forum/general/pb_using_script_ezsqlinsertschema_php_to_install_oracle_11g

I have (and I tried the generate with different modifications of this file - see above):

# cat settings/override/site.ini.append.php
<?php
[ExtensionSettings]
ActiveExtensions[]
ActiveExtensions[]=ezoracle
?>

# php ./bin/php/ezpgenerateautoloads.php
Scanning for PHP-files.
Scan complete. Found 266 PHP files.
Searching for classes (tokenizing).
Found 102 classes, added 102 of them to the autoload array.

# cat var/autoload/ezp_extension.php | grep -i oracle
'eZDBFileHandlerOracleBackend' => 'extension/ezoracle/clusterfilehandlers/dbbackends/oracle.php',
'eZDFSFileHandlerOracleBackend' => 'extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php',
'eZOracleDB' => 'extension/ezoracle/ezdb/dbms-drivers/ezoracledb.php',
'eZOracleSchema' => 'extension/ezoracle/ezdb/dbms-schema/ezoracleschema.php',
'ezoracleInfo' => 'extension/ezoracle/ezinfo.php',

I think all my problems stem from not having the extension enabled properly. What am I missing here?