[rules-users] Unable to do Guvnor Authentiation with MySQL

Wed Jan 11 01:21:16 EST 2012

Hi,

Has anybody encountered the similar problem, could someone please help me
on this.

TIA,
Sumeet
Mailto: sumeet.karawal at tcs.com

----- Forwarded by Sumeet Karawal/MUM/TCS on 01/11/2012 05:16 PM -----

  From:       Sumeet Karawal <sumeet.karawal at tcs.com>                                                                             

  To:         rules-users at lists.jboss.org                                                                                         

  Date:       01/09/2012 08:18 PM                                                                                                 

  Subject:    [rules-users] Unable to do Guvnor Authentiation with MySQL                                                          

  Sent by:    rules-users-bounces at lists.jboss.org                                                                                 

Hi All,

I am trying to enable authentication in Guvnor using MySQL. I am using
MySQL 5.1, Guvnor 5.2 and JBoss AS 5.0.4

I searched over a lot of docs and tried to do as mentioned below :

   I have created a GuvnorDB in MySQL with two tables
		 create table Principals(principal_id VARCHAR(64),password
VARCHAR
(64));
		 create table roles(principal_id VARCHAR(64),user_role VARCHAR
(64),role_group VARCHAR(64));

and have entered some values accordingly (admin, admin123)  and (admin,
admin, admin);

   My components.xml in drools-guvnor.war is as follows :

<?xml version="1.0" encoding="UTF-8"?>
<components xmlns="http://jboss.com/products/seam/components"
    xmlns:core="http://jboss.com/products/seam/core"
xmlns:security="http://jboss.com/products/seam/security"
    xmlns:web="http://jboss.com/products/seam/web"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:transaction="http://jboss.com/products/seam/transaction"
    xsi:schemaLocation="http://jboss.com/products/seam/core
http://jboss.com/products/seam/core-2.0.xsd
                 http://jboss.com/products/seam/security
http://jboss.com/products/seam/security-2.0.xsd
                 http://jboss.com/products/seam/components
http://jboss.com/products/seam/components-2.0.xsd
                 http://jboss.com/products/seam/web
http://jboss.com/products/seam/web-2.0.xsd
                 http://jboss.com/products/seam/transaction
http://jboss.com/products/seam/transaction-2.0.xsd">

    <core:init transaction-management-enabled="false" />
    <transaction:no-transaction />

    <component name="repositoryConfiguration">

        <!-- JackRabbit  -->

        <property name="properties">

<key>org.drools.repository.configurator</key><value>org.drools.repository.jackrabbit.JackrabbitRepositoryConfigurator</value>

        </property>

    </component>

    <!-- SECURITY IDENTITY CONFIGURATION -->

   <security:identity authenticate-method="#{authenticator.authenticate}"
        jaas-config-name="mysql"/>

    <!-- SECURITY AUTHORIZATION CONFIGURATION -->

    <component name="org.jboss.seam.security.roleBasedPermissionResolver">
        <property name="enableRoleBasedAuthorization">true</property>
    </component>

</components>

   I have also changed my login-config.xml accordingly and added a
   application policy :

<application-policy name="mysql">
 <authentication>
 <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
flag="required">
 <module-option name="dsJndiName">java:/MySqlDS</module-option>
 <module-option name="principalsQuery">select password from principals
where principal_id=?</module-option>
 <module-option name="principalsQuery">select user_role,'Roles' from roles
where principal_id=?</module-option>

 </login-module>
 </authentication>
 </application-policy>

   I have also created a mysql-ds.xml and saved it in the default/deploy
   folder; its contents :

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
    <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/GuvnorDB</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password></password>

<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>

    <metadata>
    <type-mapping>mySQL</type-mapping>
    </metadata>
    </local-tx-datasource>getting an exceptiogetting
</datasources>

   After all these changes, when I run guvnor and try to login, I am
   getting an exception thrown at the console:

01:36:41,212 INFO  [STDOUT] INFO  10-01 01:36:41,211
(SecurityServiceImpl.java:login:57) 		  Logging in user [admin]
01:36:41,360 INFO  [STDOUT] ERROR 10-01 01:36:41,357
(SecurityServiceImpl.java:login:77) 		  Unable to login.
javax.security.auth.login.FailedLoginException: Password Incorrect/Password
Required
		 at
org.jboss.security.auth.spi.UsernamePasswordLoginModule.login
(UsernamePasswordLoginModule.java:213)
		 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
		 at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:57)
		 at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:43)
		 at java.lang.reflect.Method.invoke(Method.java:616)
		 at javax.security.auth.login.LoginContext.invoke
(LoginContext.java:784)
		 at javax.security.auth.login.LoginContext.access$000
(LoginContext.java:203)
		 at javax.security.auth.login.LoginContext$4.run
(LoginContext.java:698)
		 at javax.security.auth.login.LoginContext$4.run
(LoginContext.java:696)
		 at java.security.AccessController.doPrivileged(Native Method)
		 at javax.security.auth.login.LoginContext.invokePriv
(LoginContext.java:695)
		 at javax.security.auth.login.LoginContext.login
(LoginContext.java:594)
		 at org.jboss.seam.security.Identity.authenticate
(Identity.java:335)
		 at org.jboss.seam.security.Identity.authenticate
(Identity.java:324)
		 at org.drools.guvnor.server.security.SecurityServiceImpl.login
(SecurityServiceImpl.java:75)
		 at org.drools.guvnor.server.SecurityServiceServlet.login
(SecurityServiceServlet.java:71)
		 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
		 at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:57)......
		 .................

I tried a lot but not getting through on how to do this.

It would really helpful if somebody could guide me on this.

Thanks & Regards,
Sumeet
Mailto: sumeet.karawal at tcs.com

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

_______________________________________________
rules-users mailing list
rules-users at lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users