[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend and jBPM 3.2.3
regarding the roles... there were already topics in this forum, articles in the wiki and in this getting started link I mailed (afaik) View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4181006#4181006 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4181006 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend and jBPM 3.2.3
First http://docs.jboss.org/jbpm/v3.2/userguide/html/ is better to be used. Docs cleaning up is currently going on Besides that: anonymous wrote : Is Chapter 8 out of sync with 3.2.3 or have I done something incorrectly? Yes, even in the 3.2 docs Better to read: http://wiki.jboss.org/wiki/JbpmContributedDocs (the 3.2.2. getting started), chapter 3.5 http://wiki.jboss.org/wiki/JbpmDbCompatibility View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4180732#4180732 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4180732 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend and jBPM 3.2.3
Thank you for your time, kukeltje; I ended up using pages 68-71 of the Business Processing Modelling using jBPM 3.2.2 Guide, available via those links that you had provided. I am currently migrating jBPM to a PostgreSQL database, and have made some clarifications to the Guide, which I'll make available on the wiki once I organise access to it; I'm pretty sure that migrating jBPM to a database other than the in-built one (Hypersonic) is a pretty common task. One thing that wasn't too clear, and something I believe is preventing a log in to the jBPM-console using the new database, is how to populate the JBPM_ID_GROUP, JBPM_ID_USER, and JBPM_MEMBERSHIP tables (logically, not technically). From what I understand, a user who wants to, at least, log into the console needs, at least, a 'user' role. While I understand the (primary key-foreign key) relationships between the tables, it was unclear to me as to: - the purpose of the TYPE_ field of the JBPM_ID_GROUP. Any chance you could make clear as to whether or not values in that table field could be preventing valid logins to the console? I understand that one of the steps involved in migrating jBPM to another database, involves editing the application-policy of the login-config.xml (found in JBPM_JPDL_HOME/server/server/jbpm/conf/). Instructions for that step read: ... So before creating a datasource make sure that the datasource has been deployed on the server and the jndi has got registered to the server and is specified appropriately with the login-config.xml Otherwise most of the time a login violation occurs at the jBPM console due to inappropriate jndi specification. Am I correct in understanding that to mean that my new database should be up and running on the server, before I mess around with login-config.xml? I have a feeling I've misinterpreted that instruction. Below is a quotation of my login-config.xml. Any help you could provide, would be much appreciated. anonymous wrote : | application-policy name = jbpm | | login-module code=org.jboss.security.auth.spi.DatabaseServerLoginModule |flag=required |module-option name=dsJndiNamejava:/JbpmDSpostgresql/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 | | /application-policy | Kindest regards, Dan Rowley View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4180910#4180910 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4180910 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend and jBPM 3.2.3
My jbpm-ds.xml file also contains: datasources | | local-tx-datasource | jndi-nameJbpmDSpostgresql/jndi-name | connection-urljdbc:postgresql://localhost:5432/jBPMdb/connection-url | driver-classorg.postgresql.Driver/driver-class | user-namepostgres/user-name | passwordadmin/password | metadata | type-mappingPostgreSQL 8.3/type-mapping | /metadata | /local-tx-datasource | | /datasources danrowley wrote : Thank you for your time, kukeltje; I ended up using pages 68-71 of the Business Processing Modelling using jBPM 3.2.2 Guide, available via those links that you had provided. I am currently migrating jBPM to a PostgreSQL database, and have made some clarifications to the Guide, which I'll make available on the wiki once I organise access to it; I'm pretty sure that migrating jBPM to a database other than the in-built one (Hypersonic) is a pretty common task. | | One thing that wasn't too clear, and something I believe is preventing a log in to the jBPM-console using the new database, is how to populate the JBPM_ID_GROUP, JBPM_ID_USER, and JBPM_MEMBERSHIP tables (logically, not technically). From what I understand, a user who wants to, at least, log into the console needs, at least, a 'user' role. While I understand the (primary key-foreign key) relationships between the tables, it was unclear to me as to: | | - the purpose of the TYPE_ field of the JBPM_ID_GROUP. | | Any chance you could make clear as to whether or not values in that table field could be preventing valid logins to the console? | | I understand that one of the steps involved in migrating jBPM to another database, involves editing the application-policy of the login-config.xml (found in JBPM_JPDL_HOME/server/server/jbpm/conf/). Instructions for that step read: | | ... So before creating a datasource make sure that the datasource has been deployed on the server and the jndi has got registered to the server and is specified appropriately with the login-config.xml Otherwise most of the time a login violation occurs at the jBPM console due to inappropriate jndi specification. | | Am I correct in understanding that to mean that my new database should be up and running on the server, before I mess around with login-config.xml? I have a feeling I've misinterpreted that instruction. | | Below is a quotation of my login-config.xml. | | Any help you could provide, would be much appreciated. | | anonymous wrote : | | application-policy name = jbpm | | | | login-module code=org.jboss.security.auth.spi.DatabaseServerLoginModule | |flag=required | |module-option name=dsJndiNamejava:/JbpmDSpostgresql/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 | | | | /application-policy | | | | Kindest regards, | | Dan Rowley View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4180911#4180911 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4180911 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend and jBPM 3.2.3
After inspecting the SELECT statement in my login-config.xml, I realised that the TYPE_ field of the JBPM_ID_GROUP should contain values of security-role. I'll make this explicit in the Wiki contribution I'll be making soon. I hope this has helped others, Dan Rowley danrowley wrote : My jbpm-ds.xml file also contains: | | datasources | | | | local-tx-datasource | | jndi-nameJbpmDSpostgresql/jndi-name | | connection-urljdbc:postgresql://localhost:5432/jBPMdb/connection-url | | driver-classorg.postgresql.Driver/driver-class | | user-namepostgres/user-name | | passwordadmin/password | | metadata | | type-mappingPostgreSQL 8.3/type-mapping | | /metadata | | /local-tx-datasource | | | | /datasources | | | danrowley wrote : Thank you for your time, kukeltje; I ended up using pages 68-71 of the Business Processing Modelling using jBPM 3.2.2 Guide, available via those links that you had provided. I am currently migrating jBPM to a PostgreSQL database, and have made some clarifications to the Guide, which I'll make available on the wiki once I organise access to it; I'm pretty sure that migrating jBPM to a database other than the in-built one (Hypersonic) is a pretty common task. | | | | One thing that wasn't too clear, and something I believe is preventing a log in to the jBPM-console using the new database, is how to populate the JBPM_ID_GROUP, JBPM_ID_USER, and JBPM_MEMBERSHIP tables (logically, not technically). From what I understand, a user who wants to, at least, log into the console needs, at least, a 'user' role. While I understand the (primary key-foreign key) relationships between the tables, it was unclear to me as to: | | | | - the purpose of the TYPE_ field of the JBPM_ID_GROUP. | | | | Any chance you could make clear as to whether or not values in that table field could be preventing valid logins to the console? | | | | I understand that one of the steps involved in migrating jBPM to another database, involves editing the application-policy of the login-config.xml (found in JBPM_JPDL_HOME/server/server/jbpm/conf/). Instructions for that step read: | | | | ... So before creating a datasource make sure that the datasource has been deployed on the server and the jndi has got registered to the server and is specified appropriately with the login-config.xml Otherwise most of the time a login violation occurs at the jBPM console due to inappropriate jndi specification. | | | | Am I correct in understanding that to mean that my new database should be up and running on the server, before I mess around with login-config.xml? I have a feeling I've misinterpreted that instruction. | | | | Below is a quotation of my login-config.xml. | | | | Any help you could provide, would be much appreciated. | | | | anonymous wrote : | | | application-policy name = jbpm | | | | | | login-module code=org.jboss.security.auth.spi.DatabaseServerLoginModule | | |flag=required | | |module-option name=dsJndiNamejava:/JbpmDSpostgresql/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 | | | | | | /application-policy | | | | | | | Kindest regards, | | | | Dan Rowley View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4180912#4180912 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4180912 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend
EhCache? what jBPM version are you using? I'd expect to see property name=hibernate.cache.provider_classorg.hibernate.cache.HashtableCacheProvider/property in hibernate.cfg.xml, as this is the default cache provider setting in the recent versions. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4134483#4134483 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4134483 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend
After searching on google i found that i should also add the following in the hibernate.cfg.xml file: org.hibernate.cache.EhCacheProvider However this still doesnt solve the problem and i get the same exception. Any help would be mostly appreciated since i am stuck at this point and dont know what else to try! View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4133680#4133680 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4133680 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend
hypersonic is on if it is configured in the jboss config. It's great that you modified the files, but if you do not post what their content is, we can NEVER see what might be wrong. Also , how did you deploy jBPM, is the hibernate.cfg you think you use actually used? etc..etc...etc.. there are lots of things you can and should try yourself which we cannot do for you. So please post more info View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3966328#3966328 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3966328 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend
Thx for answering; I just found : http://www.jboss.com/index.html?module=bbop=viewtopict=86232 Going to invest that way I give myself till tommorrow to find how to make it works; else I'll probably post one more time here ^^ Regards Stephane View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3966331#3966331 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3966331 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Switching the Database Backend
http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmDbCompatibility View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3966336#3966336 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3966336 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user