Unable to do Guvnor Authentiation with MySQL
by Sumeet Karawal
Hi,
Has anybody encountered the similar problem, could someone please help me
on this.
TIA,
Sumeet
Mailto: sumeet.karawal(a)tcs.com
----- Forwarded by Sumeet Karawal/MUM/TCS on 01/11/2012 05:16 PM -----
From: Sumeet Karawal <sumeet.karawal(a)tcs.com>
To: rules-users(a)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(a)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(a)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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
14 years, 4 months
Executing a subset of rules.
by Stephen Masters
Hi folks,
I'm curious on what would be best practice with regards configuring things so that only a subset of rules is evaluated in certain situations.
I have a knowledge base that is designed to evaluate a whole variety of rules relating to whether a trade can be carried out. I would like to generate a 'report' of what banks I can trade with based on their current ratings. i.e. Based on rules like "Do not place funds in a counterparty (bank) below Moodys A2 rating." However there are numerous other rules such as "Do not place more than 20% of a fund in a single currency".
To generate the report I was going to set up a batch of dummy trades for evaluation and 'ask' the rules engine whether I am allowed to trade. However, specifically for the purposes of this report I don't want to see failures caused by anything other than a counterparty ratings rule.
I was thinking that one option would be to organise my packages so that I have an isolated 'counterparty ratings' package. That way I could load that specific set of rules into a counterparty ratings reporting session, and not others.
Does that seem a reasonable way of doing things? Or are there better ways of doing this?
Thanks in advance for any thoughts...
Steve
Stephen Masters
http://about.me/stephen-masters
stephen.masters(a)me.com
14 years, 4 months
MVEL curly braces position - bug or feature?
by nickS
Hi
I've been learning drools ands I saw that there is a Fibonacci example, so I
thought I'd write my own using mvel as the dialect and then compare it to
the model solution.
However, I couldn't get mine working. It parsed but the behaviour was very
odd. It kept ignoring the modify block in my recurse rule and consequently
it went into an infinite loop. I compared it to the 'approved' solution and
the two were pretty much the same, except that it worked and mine didn't.
After a lot of checking I noticed that I had started my curly brace on a new
line after modify but the example had continued straight after the closing
brace of the modify.
Works //
modify ( f ){
value = 1
};
or
modify ( f ){value = 1 };
Doesn't Work //
modify ( f )
{
value = 1
};
Does anyone know if this is a bug or a feature?
--
View this message in context: http://drools.46999.n3.nabble.com/MVEL-curly-braces-position-bug-or-featu...
Sent from the Drools: User forum mailing list archive at Nabble.com.
14 years, 4 months
Gwt Console in JBPM
by srinivasasanda
Hi,
I'm using JBPM5.1 installer,with JBOSS 5.1.0GA,Drools 5.3
I'm integrating Drools with JBPM.Before that,this is issue arised with
JBPM5.I've dowloaded the source code for jbpm console in
*https://github.com/bpmc/bpm-console*.I followed instructions and succesfuly
made 2 war files gwt-console.war,gwt-console-server.war.
But,When I'm deploying them in my JBOSS,it is generating exception and I'm
unable to open the console.The server log is
2012-01-10 12:47:17,303 INFO
[org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy,
ctxPath=/default-bpm-console
2012-01-10 12:47:18,156 ERROR [org.reflections.Reflections] (main) could not
create Vfs.Dir from url. ignoring the exception and continuing
org.reflections.ReflectionsException: could not create Dir using
org.jboss.errai.bus.server.service.metadata.VFSUrlType from url
vfszip:/D:/jbpm-installer/jboss-5.1.0.GA/server/default/deploy/gwt-console.war/WEB-INF/classes/..
When I'm opening http://localhost:8080/jbpm-console:It is generating 404
page not found error.Please suggest me how to achieve it.Even I posted in
other forums,but couldnt able to get solution.Could you please suggest me
--
View this message in context: http://drools.46999.n3.nabble.com/Gwt-Console-in-JBPM-tp3647313p3647313.html
Sent from the Drools: User forum mailing list archive at Nabble.com.
14 years, 4 months
Template Key in DSL
by srinivasasanda
Hi,
I created a rule template.I also created the DSL.
When the Person occupation is {s} = Person(occupation == "{s}").
In the rule template I inserted DSL statement and it is displayed as When
the person occupation is----
Now,I need to Load Template Data.But as there is no template key,I'm unable
to add rows in load template data option.Please suggest me how to load
template data in the rule template with DSL.
Thanks
--
View this message in context: http://drools.46999.n3.nabble.com/Template-Key-in-DSL-tp3634710p3634710.html
Sent from the Drools: User forum mailing list archive at Nabble.com.
14 years, 4 months
Where could I get drools binary or source versioning 5.3.2.final?
by Miles Wen
Hello,
I submitted some issues to the issue tracker and browsed the issue tracker
site. Found that there is a bug fix version for drools 5.3 final which
named '5.3.2.final'. But I can't find where to download it.I searched for
the droolsjbpm/drools github repos too, but still couldn't find.
So if somebody knows where to find the drools 5.3.2.final version, please
tell me.
Thanks.
--
Regards.
Miles. Wen
14 years, 4 months
does "dialect" really have an effect?
by ronalbury
Drools 5.3
Given the following rule:
rule "EasyApp Family Term Rider Max Value"
dialect "java"
#ruleflow-group "values-group"
when
$ea : EasyApp(
getFoo1AsBoolean()==true
&& (getFoo2AsInt() > 25000
|| getFoo2AsInt() > getFoo3().getCurrentAmtAsInt()/5))
)
then
$ea.addError(drools.getRule().getName());
end
The method getFoo3().getCurrentAmtAsInt() returns null, and so I get a null
pointer error. I can accept that. However, the traceback shows I am deep in
MVEL code:
Caused by: java.lang.NullPointerException
at org.mvel2.ast.IntDiv.getReducedValueAccelerated(IntDiv.java:16)
at
org.mvel2.compiler.ExecutableAccessor.getValue(ExecutableAccessor.java:38)
at
org.mvel2.ast.Substatement.getReducedValueAccelerated(Substatement.java:43)
at
org.mvel2.ast.BinaryOperation.getReducedValueAccelerated(BinaryOperation.java:116)
at org.mvel2.ast.Or.getReducedValueAccelerated(Or.java:31)
at org.mvel2.MVELRuntime.execute(MVELRuntime.java:87)
at
org.mvel2.compiler.CompiledExpression.getValue(CompiledExpression.java:122)
at
org.mvel2.compiler.CompiledExpression.getValue(CompiledExpression.java:115)
at org.mvel2.MVEL.executeExpression(MVEL.java:930)
at
org.drools.base.mvel.MVELPredicateExpression.evaluate(MVELPredicateExpression.java:100)
at
org.drools.rule.PredicateConstraint.isAllowed(PredicateConstraint.java:291)
... 17 more
I know you can use java syntax inside MVEL ... does Drools even look at the
dialect, or does it always just run everything in MVEL?
--
View this message in context: http://drools.46999.n3.nabble.com/does-dialect-really-have-an-effect-tp36...
Sent from the Drools: User forum mailing list archive at Nabble.com.
14 years, 4 months
