contentbox integration with oracle on lucee server

Communities ColdBox HMVC
1

Can anyone help me here? I am stop at this point? I install following software in my machine successfully.

  • Virtual Machine (VM).
  • Ubuntu 12.04 32bit.
  • Oracle 10g Express edition 32bit.
  • Lucee (lucee-4.5.1.000-pl0-linux-installer.run)
  • Contentbox

After above all installation I go http://localhost:8888/lucee/admin/server.cfm for check configuration all are working fine. Next I go to this URL http://localhost:8888/contentbox/ for configuration contentbox with oracle database, when I go to create data source, there is not oracle database in dropdown list of database

(http://imgh.us/Snap_2.png ).

Can anyone help me at this point? Is contentbox possible integration with oracle?

2

Oracle does not currently work with ContentBox due to differences in how ORM behaves. (So much for ORM abstracting all that stuff, right??)

I’m sure it’s possible, but to be honest, I think you’re only the third person I know of who’s ever asked about using Oracle so we’ve had little reason to put effort into figuring it out.

George Murphy has been wanting Oracle to work for a while and may actually have it going. I’ll ping him and ask him to chime in on this thread. We’d certainly love to be able to support it. What would really be nice is if a company using Oracle would chip in to help cover the development costs of getting it working. ContentBox is open source so we do it all for free and we’re most interested in features that server the broad community unless, of course, someone is willing to sponsor!

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

3

Also, please keep your duplicates posts down. You put the same question on StackOverflow, as well as the ColdBox and ContentBox Google Group.

ideally, all ContentBox-related questions should go here:

https://groups.google.com/forum/?hl=en#!forum/contentbox

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

4

I will keep that in mind for future.

After trying the Oracle configuration, I have tried to do it with MySQL but after clicking on continue installation go the following issue.

Here is the error.

And here is my contentbox-installer folder directory snap.

I have downloaded it from http://www.ortussolutions.com/products/contentbox/download and facing this issue. Please help me.

Thanks!

5

I believe you have a tomcat mapping issue. How did you install lucee?

Tomcat on lucee only allow for ses urls in the root. You have a contbox folder.

Luis Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
P/F: 1-888-557-8057

6

You will need to add additional servlet mappings in web.xml for SES URLs to work in a subdirectory. This is a limitation of Lucee since it runs on stock Tomcat and not the modified version that Adobe CF runs on. Read more here on this thread:

https://groups.google.com/d/topic/contentbox/2z8Pyd3ZiOY/discussion

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

7

I have installed lucee from terminal (OS is Ubuntu). If I place my files in Root folder then luccee admin layout get disturbed and also I am unable to create data source after that. I have tried this thing to much time but still unable to get it resolve.

snap3.PNG
snap3.PNG1136×563 84.2 KB

8

That looks fine, the problem is tomcat. It does not support those type of SES urls out of the box, you must add every folder manually.

Open the file: /opt/lucee/tomcat/conf/web.xml and look for this:

/index.cfm/*

And add another one with the sub-directory you want:

/contbox/index.cfm/*

Also, you can try downloading CommandBox: www.ortussolutions.com/products/commandbox and just run the following commands:

$ mkdir mysite && cd mysite
$ box install contentbox && box server start —rewritesEnable

That’s it.

Luis Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
P/F: 1-888-557-8057
Direct: (909) 248-3408

ColdBox Platform: http://www.coldbox.org

ContentBox Platform: http://www.gocontentbox.org
Linked In: http://www.linkedin.com/pub/3/731/483

Social: twitter.com/ortussolutions | twitter.com/coldbox | twitter.com/lmajano | twitter.com/gocontentbox

9

Thanks. You way works for me and URL rewriting problem has been resolved now.

error.PNG
error.PNG1133×564 82.9 KB

10

Yep, this is where we would need your help in getting ContentBox certified for Oracle.

Luis Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
P/F: 1-888-557-8057
Direct: (909) 248-3408

ColdBox Platform: http://www.coldbox.org

ContentBox Platform: http://www.gocontentbox.org
Linked In: http://www.linkedin.com/pub/3/731/483

Social: twitter.com/ortussolutions | twitter.com/coldbox | twitter.com/lmajano | twitter.com/gocontentbox