Eclipse Community Forums: Eclipse Process Manager (Stardust) » Audit Trail Database Schema in Production

Home » Archived » Eclipse Process Manager (Stardust) » Audit Trail Database Schema in Production(Mysql Database schema for Stardust in Production)

Audit Trail Database Schema in Production [message #1471863]

Thu, 13 November 2014 06:58

Eclipse User

Hi,

I am trying to setup a MySql database as an audit trail database for running Stardust in remote usage in Production. I thought Stardust would have its own database schema and tables which it uses to run the processes. But the documentation http://help.eclipse.org/luna/index.jsp?topic=%2Forg.eclipse.stardust.docs.deployment%2Fhtml%2Fdeploymentconcepts%2Ftoc.html does not specify a schema or DDL.

Can I leave the schema blank like in the case of derby or I have to necessarily give a custom schema? Can anyone provide me pointers to giving a custom schema?

Please help!

Thanks,
Shuchi

Re: Audit Trail Database Schema in Production [message #1471874 is a reply to message #1471863]

Thu, 13 November 2014 07:09

Eclipse User

Hi Shuchi,

You need to setup audiTrail database. Please refer below link which descibes setup steps for MySql:
http://help.eclipse.org/luna/topic/org.eclipse.stardust.docs.deployment/html/audittraildatabasesetup/mysql.html?cp=60_7_7_2_5

-Thanks,
RajKumar

Re: Audit Trail Database Schema in Production [message #1472158 is a reply to message #1471874]

Thu, 13 November 2014 11:50

Eclipse User

Hi Rajkumar,

The below sysconsole command mentions <dbschema> to be specified by the user:

sysconsole -v -r <jdbcDriver> -dbtype MYSQL -dbschema <dbschema> -l jdbc:mysql://<host>:<port>/<dbName> -d <user> -s <password> createschema

What should I give for this field?

Thanks,
Shuchi

Re: Audit Trail Database Schema in Production [message #1472181 is a reply to message #1472158]

Thu, 13 November 2014 12:16

Eclipse User

Hi,

the -dbschema is an optional parameter. If you leave it out, the tables will be created under the user that is used for the authentication to the database.

Note also that there is another command which allows you to write the SQL commands to create the schema into a file.

sysconsole -dbType MYSQL ddl -file mysql-schema.sql

It requires less parameters, because it's not talking directly to the DB. You can take the resulting file and use it spool it into the mysql client yourself ... in case this seems easier to you.

Regards,

Jan

Re: Audit Trail Database Schema in Production [message #1472995 is a reply to message #1472181]

Fri, 14 November 2014 03:52

Eclipse User

Hi Jan,

I am running the following command:

sysconsole.sh -v -r com.mysql.jdbc.Driver -dbtype MYSQL -l jdbc:mysql://localhost:3306/vendor_scaling_workflow?user=root&password=123&useUnicode=true&characterEncoding=UTF-8 -d root -s 123 createschema

As per your suggestion, I have ommitted dbschema. For running this command, I have set the variables CARNOT_HOME to $MY_WORKSPACE/sysconsole directory, CARNOT_WORK to $MY_WORKSPACE/sysconsole/etc and CARNOT_CLASSPATH to $MY_WORKSPACE/sysconsole/lib. I have also copied the Mysql connector jar to the lib directory. Now when I am running the above command, I am getting the following error:

Error: Could not find or load main class org.eclipse.stardust.engine.cli.sysconsole.Main

Is there something else that I have to set?

Thanks,
Shuchi

Re: Audit Trail Database Schema in Production [message #1475753 is a reply to message #1472995]

Sun, 16 November 2014 09:24

Eclipse User

I was able to resolve the issue. Main-Class field was not set in the manifest of org.eclipse.stardust.engine.cli.sysconsole package, I created a manifest.txt and set the Main-Class field inside it, it is working now Smile

Re: Audit Trail Database Schema in Production [message #1476440 is a reply to message #1475753]

Sun, 16 November 2014 23:17

Eclipse User

I created https://bugs.eclipse.org/bugs/show_bug.cgi?id=451784
to make this easier in the future.

Previous Topic:	Stardust 1.0 to 2.0.1 upgrade
Next Topic:	Not able to access the Infinity artifactory to download archetype

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 02:42:19 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter