Bonita_history and Bonita_journal in Oracle DB

Submitted by rafael.vianna on Fri, 11/01/2013 - 12:49
1
0
-1

Hi all,

I'm trying to implement a BOS server with tomcat and I'm having a very bad time with that. Just to get things better, I'm trying use an oracle DB.

So, I've found that I don't know how to create those 2 databases that are needed: Bonita_History and Bonita_journal.

I mean, I know how to create the database for sure but since oracle is not like e.g. MySQL I'm doubt about creating 2 owners (Bonita_history and Bonita_journal) in the same instance or if I create 2 differente instances, both with the owner 'Bonita' and create a DB for each one in 2 separated instances... I really don't know and the documentation doesn't help that much.

Thanks in advance for any pointers.

6 answers

Submitted by emmanuel.duchas... on Tue, 11/12/2013 - 11:57
1
+1
-1

Hi,

If you want to use AD (I guess you mean Active Directory) with BonitaBPM, the simplest solution is to ask for a trial version of BonitaBPM Subscription pack v6.1 (limited in time). For that, just contact us at http://www.bonitasoft.com/be-part-of-it/contact-us .
You will then be able to use external authentication mechanism. See documentation here for more details on configuring it with BonitaBPM version 6.x

Hope this helps you,
Emmanuel

Submitted by rafael.vianna on Wed, 11/06/2013 - 18:01
1
0
-1

Hi Antoine,

Thanks for answer.

I can send the logs, sure.

Download at SpeedyShare

I'll try the bundle for 6.1 into another VM, for sure.

Thanks for your time.

Submitted by antoine.mottier on Wed, 11/06/2013 - 12:47
1
0
-1

Hi,

I want to let you know that with 6.1 release we update the Tomcat bundle documentation with more details and steps by step setup.

If you still have some trouble (not matter if it's v5 or v6), can you share: the log files locatted in Tomcat logs folder and also your configuration files (e.g. a zip of Bonita home folder)?

Regards.

Antoine Mottier, Bonitasoft consultant

Submitted by rafael.vianna on Tue, 11/05/2013 - 19:12
1
0
-1

Ok, now I managed to make eveything working just fine with this 6 months old tutorial: http://community.bonitasoft.com/blog/full-open-source-setup-bonita-open-...

I took some time because there are some stuff to do that are not in the tutorial. I still can't get this idea that anyone that wanna use Bonita must be an expert at XML and Tomcat but ok...

After all, I'm now stucked at this problem:

I can load Bonita portal through http://localhost:8080/bonita just fine. Problem happens when I try to login with admin and bpm password. The screen changes to that:

org.ow2.bonita.util.BonitaRuntimeException: Bonita Error: bp_Pa_1
errors during parsing of environment:
error : couldn't interpret the dom model : org.hibernate.HibernateException: Could not find datasource

org.ow2.bonita.util.Misc.showProblems(Misc.java:1975)
org.ow2.bonita.env.BonitaEnvironmentParser.parseEnvironmentFactoryFromXmlString(BonitaEnvironmentParser.java:88)
org.ow2.bonita.env.GlobalEnvironmentFactory.getEnvironmentFactory(GlobalEnvironmentFactory.java:112)
org.ow2.bonita.facade.APIInterceptor.invoke(APIInterceptor.java:186)
sun.proxy.$Proxy0.generateTemporaryToken(Unknown Source)
org.bonitasoft.console.security.server.api.impl.CredentialsEncryptionAPIImpl.generateTemporaryToken(CredentialsEncryptionAPIImpl.java:157)
org.bonitasoft.console.security.server.CredentialsEncryptionServlet.doPost(CredentialsEncryptionServlet.java:127)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.bonitasoft.forms.server.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)

Any directions from here?

Submitted by rafael.vianna on Mon, 11/04/2013 - 18:05
1
0
-1

Hi Emmanuel,

Thanks for the answer.

I tried to follow that bundle for tomcat but since I'm kinda new working with tomcat and bonita, I couldn't manage to make it work. Actually, I couldn't even get where the tomcat works with bonita in that bundle tutorial. Also, I couldn't figure out what do I need to have installed in advance on my server.

About the new version, I could use. No problem. But I need to make it work with AD. And I can't get it on the community version of 6.0.4. And to convince my staff to get a Teamwork version of Bonita, I must show something in the community edition first.

And I can work just fine with bonita, but the infrastructure around is getting on my knees: Tomcat, Connectors, Groovy...

At this very moment I'm trying a tutorial I've found for tomcat 6 and Bonita 5.10 with postgree and Ubuntu. Since it's a good tutorial, I'm doing it just fine. But I'll not work neither with postgree nor with Ubuntu.

Any perspective of a better explanation on that bundle tutorial?

Submitted by emmanuel.duchas... on Mon, 11/04/2013 - 17:38
1
0
-1

Hi,

Bonita_History and Bonita_journal are Bonita v5.x fonctionalities.
As you seem to be starting using Bonita, why don't you use BonitaBPM 6.x? This is the last release of Bonita and only has one schema for the whole Database. It will be simpler to use on that point.
You can use http://documentation.bonitasoft.com/tomcat-bundle#specify_vendor to get started with using Oracle with Bonita.

HTH, and have fun with BonitaBPM.

Emmanuel

Notifications