1 2 Previous Next 15 Replies Latest reply on Jan 15, 2009 1:41 AM by beve Go to original post
      • 15. Re: Exception on jms_secured example.
        beve

        Hi,

        does your messaging application-policy in conf/login-config.xml look like this:

        <application-policy name="messaging">
         <authentication>
         <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
         <module-option name="unauthenticatedIdentity">guest
         </module-option>
         <module-option name="dsJndiName">java:/DefaultDS
         </module-option>
         <module-option name="principalsQuery">SELECT PASSWD FROM JBM_USER WHERE USER_ID=?
         </module-option>
         <module-option name="rolesQuery">SELECT ROLE_ID, 'Roles' FROM JBM_ROLE WHERE USER_ID=?
         </module-option>
         </login-module>
         </authentication>
         </application-policy><!--- - - - --><!--Loaded from orignal file: old/login-config.xml-->
        

        then you will need to add the following properties to deploy/jboss-messaging.sar/dbname-persistence-service.xml:
        POPULATE.TABLES.15 = INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('gatewayuser', 'gwpassword')
        POPULATE.TABLES.16 = INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('gatewayrole','gatewayuser')
        POPULATE.TABLES.17 = INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('esbuser', 'esbpassword')
        POPULATE.TABLES.18 = INSERT INTO JMS_ROLES (ROLEID, USERID) VALUES ('esbrole','esbuser')
        POPULATE.TABLES.19 = INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('esbuser2', 'esbpassword')
        

        Just add this to the 'SqlProperties' section. Can you give that a try?

        regards,

        /Daniel

        1 2 Previous Next