problems with ezoracle extension installation

Next topic

Author	Message
luca maroni	Wednesday 04 April 2007 3:17:52 am Hello to everybody, I have a little problem using ezoracle extension I installed ezpublish with windows installer (apache-mysql-php-ezpublish) on a Pentium III 700 Mhz, 1 GB RAM, windows server 2003 (this PC is a bit obsolete but I hope to change it with a new one asap ) I also using the default site to do some test and all is working well with mySQL DB The problmem is that I need to run eZPublish with Oracle and so I need to install ezoracle extension, to try it I have done: - I installed oracle Express Edition on the same machine - I created a DB user with DBA rights - I installed ezoracle extension and enabled it on ezpublish setup page - I duplicated MySQL schema and data on oracle DB - I changed ezpublish site.ini to connect ezpublish with oracle db The site seems working well. You can navigate it and view the data. But ... there is always a "but" ;-): - When I try to access the edit form, the system doesn’t show any fields to manage the content. There is no error but also any fields to manage the content. - also if you try to create a new object the system gives the error below <i>You don't have permission to access this area. Possible reasons for this are: Your current user does not have the proper privileges to access this page. You misspelled some parts of your URL, try changing it.</i> I follow the installation documentation on the website but I'm not able to understand what is missing or wrong in my installation. anyone can help me? any suggestion is very welcome. Thanks a lot Luca
SatyaPrasad Alamuru	Wednesday 29 August 2007 6:11:59 am Hi, V are new to the world of CMS. While trying to install eZpublish with Oracle, every thing went fine with but while loginf to user site its say's access denied. Any help on this would be of great help. One more observation is that the script db_schema.dba, do not have sequences created for auto_number in mysql and also triggers were not defined. So got some errors while registering a new user, could solve that by creating sequences and triggers manually. Is that fine or do we need to do some thing else???? Thanks
Sergiy Pushchin	Thursday 06 September 2007 5:27:01 am All triggers and sequences should have been created automaticaly. Have you used conversion script or did you initialized clean DB? Dba files do not contain triggers and sequences they are automaticaly created when you initialize database from dba file.
SatyaPrasad Alamuru	Friday 07 September 2007 6:34:32 am We followed migration method. Initially Installed with MYSQL and then executed the php files in oracle Extension ezoracle\scripts 1. mysql2oracle-schema.php -- Gave table Scripts 2. mysql2oracle-data.php -- Gave Insert Statements Created New Oracle Schema with all required permissions and then ran scripts got from above php files. So sequenses and triggers did not get created. Please let us know if we missed out some things. Can you please suggest the method for instaling oracle with ezPublish as we dont have apache or php module or mysql running on the oracle data base server, so migration method may not work.
Sergiy Pushchin	Friday 07 September 2007 7:41:46 am 1. mysql2oracle-schema.php -- Gave table Scripts This one should give triggers and sequences definitions as well..
SatyaPrasad Alamuru	Saturday 08 September 2007 6:42:26 am Thanks for the response. Can you please send the latest script mysql2oracle-schema.php. we are using 3.9.2 version.

eZ debug

Timing:	Jan 18 2025 11:23:28
Script start
Timing:	Jan 18 2025 11:23:28
Module start 'layout'
Timing:	Jan 18 2025 11:23:28
Module start 'content'
Timing:	Jan 18 2025 11:23:28
Module end 'content'
Timing:	Jan 18 2025 11:23:28
Script end

Main resources:

Total runtime	0.6634 sec
Peak memory usage	4,096.0000 KB
Database Queries	68

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	588.1641	152.6563
Module start 'layout'	0.0055	0.0037	740.8203	39.5078
Module start 'content'	0.0091	0.6525	780.3281	580.9609
Module end 'content'	0.6617	0.0017	1,361.2891	16.1094
Script end	0.6634		1,377.3984

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.5377	16	0.0002
Check MTime	0.0015	0.2218	16	0.0001
Mysql Total
Database connection	0.0008	0.1275	1	0.0008
Mysqli_queries	0.6035	90.9669	68	0.0089
Looping result	0.0006	0.0904	66	0.0000
Template Total	0.6251	94.2	2	0.3125
Template load	0.0021	0.3128	2	0.0010
Template processing	0.6230	93.9042	2	0.3115
Template load and register function	0.0002	0.0293	1	0.0002
states
state_id_array	0.0013	0.1985	1	0.0013
state_identifier_array	0.0012	0.1734	2	0.0006
Override
Cache load	0.0018	0.2731	53	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0797	3	0.0002
Fetch class attribute name	0.0011	0.1608	7	0.0002
XML
Image XML parsing	0.0007	0.1098	3	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0032	8	0.0000
General
dbfile	0.0008	0.1218	16	0.0001
String conversion	0.0000	0.0012	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
11	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
10	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 31 Number of unique templates used: 6

Time used to render debug report: 0.0003 secs