Install ezpublish on oracle database

Author Message

slavache che

Thursday 16 April 2009 1:13:59 am

Hi im trying install ezpublish on oracle database.Im read install file before installation and create neccesary steps and setup install im view to 35% Inicialisation DB-mysql.Please how to install?
Sorry my bad english

Gaetano Giunta

Thursday 16 April 2009 3:01:57 am

Hi. I am not sure I understand fully the procedure you are following for the setup:
are you first installing eZ Publish on mysql to afterwards migrate the installed database to Oracle?
If so, what error do you get when the setup wizard halts at 35% ?
Please note that in that case, the error would not be related to oracle at all, since you are still installing the mysql version. You can look up in the forums to see if you find any similar problems - for example, you might need to raise the memory limit and execution time in php.ini...

Principal Consultant International Business
Member of the Community Project Board

slavache che

Thursday 16 April 2009 4:06:32 am

Thanks im trying clean install cms on oracle db.Not migrate.How this? 35% installer says select mysql db not oracle.
Im add settings/override/site.ini.append.php next:
[DatabaseSettings]
DatabaseImplementation=ezoracle
User=<user>
Password=<password>
Database=<instance>

HOW CLEAN INSTALL WITH ORACLE?

Gaetano Giunta

Friday 17 April 2009 8:40:17 am

Maybe it is not clear enough from the instructions, but currently it is _not_ supported to use the setup wizard to install eZ Publish on Oracle.

So you have two choices:

1 - install from scratch using the setup wizard on a mysql db, then migrate the installation to oracle and throw away the mysql db, or
2 - install from scratch on oracle using the installation script from command line instead of the setup wizard

option 1 has one advantage: to allows you to have the ezwebin and/or ezflow extensions if needed. Thise will be hard to install later if you choose method 2

Principal Consultant International Business
Member of the Community Project Board

Gaetano Giunta

Friday 17 April 2009 8:44:07 am

[from email response:]
<i>
Thanks! Im using Windows 2003 server as host how install on Windows like command line?
</i>

Unfortunately at the moment the automated installation script is only available for unix servers.

So you need to read the installation docs here: http://ez.no/doc/extensions/database/1_8/installation

At step 9 you need to do the "manual installation" as described here: http://ez.no/doc/extensions/database/1_8/installation/manual_initialization

At point 4 in that page, follow the instructions for "Creating a clean database"

Principal Consultant International Business
Member of the Community Project Board

Yannick Modah Gouez

Monday 30 May 2011 6:44:09 am

"

1 - install from scratch using the setup wizard on a mysql db, then migrate the installation to oracle and throw away the mysql db

"

Is there a documented way of doing so ?

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 03:08:37
Script start
Timing: Jan 18 2025 03:08:37
Module start 'layout'
Timing: Jan 18 2025 03:08:37
Module start 'content'
Timing: Jan 18 2025 03:08:38
Module end 'content'
Timing: Jan 18 2025 03:08:38
Script end

Main resources:

Total runtime0.9496 sec
Peak memory usage4,096.0000 KB
Database Queries68

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0051 589.4688152.6406
Module start 'layout' 0.00510.0021 742.109439.4766
Module start 'content' 0.00720.9408 781.5859604.9688
Module end 'content' 0.94800.0016 1,386.554716.1406
Script end 0.9496  1,402.6953 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00310.3261160.0002
Check MTime0.00120.1279160.0001
Mysql Total
Database connection0.00080.083610.0008
Mysqli_queries0.893694.1056680.0131
Looping result0.00090.0910660.0000
Template Total0.917696.620.4588
Template load0.00180.193020.0009
Template processing0.915896.439020.4579
Template load and register function0.00030.036510.0003
states
state_id_array0.00080.081410.0008
state_identifier_array0.00170.181020.0009
Override
Cache load0.00160.1649410.0000
Sytem overhead
Fetch class attribute can translate value0.00090.089830.0003
Fetch class attribute name0.00170.176270.0002
XML
Image XML parsing0.00060.067430.0002
class_abstraction
Instantiating content class attribute0.00000.002490.0000
General
dbfile0.00100.1104160.0001
String conversion0.00000.000640.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
6content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/quote.tpldatatype/ezxmltext/quote.tplextension/ezwebin/design/ezwebin/override/templates/datatype/ezxmltext/quote.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 25
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs