[jboss-user] [JBoss jBPM] - Re: jbpm 3.2.GA and mysql
I was able to make it run
using this approach:
- execute in mysql the incomplete jbpm.jpdl.mysql.sql provided in the starter kit
- manually create the missing tables
create table JBPM_ID_GROUP (
| ID_ bigint not null auto_increment,
| CLASS_ char( 1) not null,
| NAME_ varchar(255),
| TYPE_ varchar(255),
| PARENT_ bigint,
| primary key (ID_));
| create table JBPM_ID_MEMBERSHIP (
| ID_ bigint not null auto_increment,
| CLASS_ char(1) not null,
| NAME_ varchar(255),
| ROLE_ varchar(255),
| USER_ bigint,
| GROUP_ bigint,
| primary key ( ID_));
| create table JBPM_ID_PERMISSIONS (
| ENTITY_ bigint not null,
| CLASS_ varchar(255),
| NAME_ varchar(255),
| ACTION_ varchar(255));
| create table JBPM_ID_USER (
| ID_ bigint not null auto_increment,
| CLASS_ char(1 ) not null,
| NAME_ varchar(255),
| EMAIL_ varchar(255),
| PASSWORD_ varchar(255),
| primary key (ID_));
| alter table JBPM_ID_GROUP add constraint FK_ID_GRP_PARENT foreign key (PARENT_)
references JBPM_ID_GROUP;
| alter table JBPM_ID_MEMBERSHIP add constraint FK_ID_MEMSHIP_GRP foreign key (GROUP_)
references JBPM_ID_GROUP;
| alter table JBPM_ID_MEMBERSHIP add constraint FK_ID_MEMSHIP_USR foreign key (USER_)
references JBPM_ID_USER;
- manually insert the missing data
| INSERT INTO JBPM_ID_GROUP
VALUES(1,'G','participant','security-role',NULL);
| INSERT INTO JBPM_ID_GROUP
VALUES(2,'G','administrator','security-role',NULL);
| INSERT INTO JBPM_ID_GROUP
VALUES(3,'G','hr','organisation',NULL);
| INSERT INTO JBPM_ID_GROUP
VALUES(4,'G','sales','organisation',NULL);
| INSERT INTO JBPM_ID_GROUP
VALUES(5,'G','manager','security-role',NULL);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(1,'M',NULL,NULL,2,2);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(2,'M',NULL,NULL,3,1);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(3,'M',NULL,NULL,3,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(4,'M',NULL,NULL,2,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(5,'M',NULL,NULL,1,4);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(6,'M',NULL,'boss',2,4);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(7,'M',NULL,NULL,2,5);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(8,'M',NULL,NULL,2,1);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(9,'M',NULL,NULL,1,1);
| INSERT INTO JBPM_ID_USER VALUES(1,'U','cookie monster','[EMAIL
PROTECTED]','cookie monster');
| INSERT INTO JBPM_ID_USER VALUES(2,'U','ernie','[EMAIL
PROTECTED]','ernie');
| INSERT INTO JBPM_ID_USER VALUES(3,'U','bert','[EMAIL
PROTECTED]','bert');
| INSERT INTO JBPM_ID_USER VALUES(4,'U','grover','[EMAIL
PROTECTED]','grover');
- open the jbpm-enterprise.ear
open the jbpm-configs.tar in it and change the hibernate-cfg.xml
for customizing the dialect mysql
- change in jboss the login-config.xml module
to include the authentication versus the jbpm db
| <application-policy name = "jbpm">
| <authentication>
| <login-module
code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
| flag="required">
| <module-option
name="dsJndiName">java:/JbpmDS</module-option>
| <module-option name="principalsQuery">
| SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_=?
| </module-option>
| <module-option name="rolesQuery">
| SELECT g.NAME_ ,'Roles'
| FROM JBPM_ID_USER u,
| JBPM_ID_MEMBERSHIP m,
| JBPM_ID_GROUP g
| WHERE g.TYPE_='security-role'
| AND m.GROUP_ = g.ID_
| AND m.USER_ = u.ID_
| AND u.NAME_=?
| </module-option>
| </login-module>
| </authentication>
| </application-policy>
|
security domain should be jbpm as verified in jboss-web.xml of the jbpm-console.war
....now its running...
hope this helps some other unlucky guy who is working with the
unsable documentation of jbpm!
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4056853#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...