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.