Caros colegas,
Já estou a alguns dias :( tomando um erro no JAAS e não consigo resolver. Já tentei diversos tutoriais e exemplos da internet e nada. Abaixo seguem os meus arquivos, o erro e o log do JBOSS.
Página de erro gerada em anexo
Configurações do Realm no JBOSS
...
<security-domain name="PCPRealm" cache-type="default">
<authentication>
<login-module code="Database" flag="required">
<module-option name="dsJndiName" value="PCPTestDS"/>
<module-option name="principalsQuery" value="select password from usuario where username=?"/>
<module-option name="rolesQuery" value="select role, 'Roles' from usuario where username=?"/>
</login-module>
</authentication>
</security-domain>
...
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
id="WebApp_ID"
version="3.0">
<display-name>PCP</display-name>
<!-- Arquivo incial -->
<welcome-file-list>
<welcome-file>/pages/public/login.xhtml</welcome-file>
</welcome-file-list>
<!-- Definição do Servlet -->
<servlet>
<servlet-name>Faces Servlet</servlet-name>
<servlet-class>javax.faces.webapp.FacesServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- Mapeamento do Servlet -->
<servlet-mapping>
<servlet-name>Faces Servlet</servlet-name>
<url-pattern>/faces/*</url-pattern>
<url-pattern>*.jsf</url-pattern>
<url-pattern>*.xhtml</url-pattern>
</servlet-mapping>
<!-- Papeis de acesso -->
<security-role>
<role-name>ADMIN</role-name>
</security-role>
<security-role>
<role-name>USER</role-name>
</security-role>
<!-- Restrições de segurança aos recursos -->
<security-constraint>
<display-name>Admin area</display-name>
<web-resource-collection>
<web-resource-name>faces</web-resource-name>
<url-pattern>/pages/protected/admin/*</url-pattern>
<http-method>GET</http-method>
<http-method>POST</http-method>
</web-resource-collection>
<auth-constraint>
<role-name>ADMIN</role-name>
</auth-constraint>
<user-data-constraint>
<transport-guarantee>NONE</transport-guarantee>
</user-data-constraint>
</security-constraint>
<!-- Configurações do login -->
<login-config>
<auth-method>FORM</auth-method>
<form-login-config>
<form-login-page>/pages/public/login.xhtml</form-login-page>
<form-error-page>/pages/public/loginError.xhtml</form-error-page>
</form-login-config>
</login-config>
</web-app>
faces-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<faces-config version="2.0"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xi="http://www.w3.org/2001/XInclude"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-facesconfig_2_0.xsd">
<navigation-rule>
<navigation-case>
<from-outcome>logout</from-outcome>
<to-view-id>/pages/public/login.xhtml</to-view-id>
<redirect/>
</navigation-case>
</navigation-rule>
<navigation-rule>
<from-view-id>/pages/public/login.xhtml</from-view-id>
<navigation-case>
<from-outcome>OK</from-outcome>
<to-view-id>/pages/protected/admin/admin.xhtml</to-view-id>
</navigation-case>
<navigation-case>
<from-outcome>Error</from-outcome>
<to-view-id>/pages/public/login.xhtml</to-view-id>
</navigation-case>
</navigation-rule>
<application>
<resource-bundle>
<base-name>messages</base-name>
<var>msgs</var>
</resource-bundle>
</application>
</faces-config>
jboss-web.xml
<?xml version="1.0" encoding="UTF-8"?>
<jboss-web>
<!-- URL de acesso -->
<context-root>pcp</context-root>
<!-- Recurso de segurança -->
<security-domain>java:/jaas/PCPRealm</security-domain>
</jboss-web>
UsuarioManagedBean
package br.com.snclavalinmarte.pcp.bean;
import javax.ejb.EJB;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpServletRequest;
import br.com.snclavalinmarte.pcp.entity.Usuario;
import br.com.snclavalinmarte.pcp.services.UsuarioService;
@SessionScoped
@ManagedBean
public class UsuarioManagedBean
{
@EJB
private UsuarioService usuarioService;
// ******************** Atributos ********************
private Usuario usuario;
public Usuario getUser()
{
if(usuario == null)
{
ExternalContext context = FacesContext.getCurrentInstance().getExternalContext();
String username = context.getUserPrincipal().getName();
usuario = usuarioService.findUserByUsername(username);
}
return usuario;
}
public boolean isUserAdmin()
{
return getRequest().isUserInRole("ADMIN");
}
public String logOut()
{
getRequest().getSession().invalidate();
return "logout";
}
protected HttpServletRequest getRequest()
{
return (HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext().getRequest();
}
}
login.xhtml
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
xmlns:f="http://java.sun.com/jsf/core"
xmlns:h="http://java.sun.com/jsf/html"
xmlns:ui="http://java.sun.com/jsf/facelets">
<h:head>
<h:outputStylesheet library="css" name="main.css" />
</h:head>
<h:body>
<p>Login to access secure pages:</p>
<form method="post" action="j_security_check">
<h:messages layout="table" errorStyle="background: #AFEEEE;" infoStyle="background: #AFEEEE;" globalOnly="true" />
<h:panelGrid columns="2">
<h:outputLabel value="Username: " /><input type="text" id="j_username" name="j_username" />
<h:outputLabel value="Password: " /><input type="password" id="j_password" name="j_password" />
<h:panelGrid columns="1">
<input type="submit" name="submit" value="Login" />
</h:panelGrid>
</h:panelGrid>
<br />
</form>
</h:body>
</html>
JBOSS: boot.log
18:16:25,714 INFO [org.jboss.modules] JBoss Modules version 1.1.1.GA
18:16:25,972 INFO [org.jboss.msc] JBoss MSC version 1.0.2.GA
18:16:26,027 INFO [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting
18:16:26,032 DEBUG [org.jboss.as.config] Configured system properties:
awt.toolkit = sun.awt.windows.WToolkit
file.encoding = UTF-8
file.encoding.pkg = sun.io
file.separator = \
java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment
java.awt.headless = true
java.awt.printerjob = sun.awt.windows.WPrinterJob
java.class.path = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\jboss-modules.jar
java.class.version = 51.0
java.endorsed.dirs = C:\Program Files\Java\jre7\lib\endorsed
java.ext.dirs = C:\Program Files\Java\jre7\lib\ext;C:\Windows\Sun\Java\lib\ext
java.home = C:\Program Files\Java\jre7
java.io.tmpdir = C:\Users\marcelo\AppData\Local\Temp\
java.library.path = C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;native;C:\Program Files\Common Files\Microsoft Shared\Microsoft Online Services;C:\Program Files (x86)\Common Files\Microsoft Shared\Microsoft Online Services;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\WIDCOMM\Bluetooth Software\;C:\Program Files\WIDCOMM\Bluetooth Software\syswow64;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\Intel\Services\IPT\;C:\Program Files (x86)\NTRU Cryptosystems\NTRU TCG Software Stack\bin\;C:\Program Files\NTRU Cryptosystems\NTRU TCG Software Stack\bin\;C:\Program Files\Dell\Dell Data Protection\Access\Advanced\Wave\Gemalto\Access Client\v5\;C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\12.0\DLLShared\;C:\Program Files (x86)\Roxio\OEM\AudioCore\;C:\Users\marcelo\Desenvolvimento\maven\bin;C:\Program Files\Java\jre7\bin;C:\Program Files\SafeNet\Authentication\SAC\x32;C:\Program Files\SafeNet\Authentication\SAC\x64;C:\Program Files\MySQL\MySQL Server 5.5\bin;C:\Program Files (x86)\OpenSSH\bin;C:\Users\marcelo\Desenvolvimento\maven\bin;.
java.net.preferIPv4Stack = true
java.runtime.name = Java(TM) SE Runtime Environment
java.runtime.version = 1.7.0_10-b18
java.specification.name = Java Platform API Specification
java.specification.vendor = Oracle Corporation
java.specification.version = 1.7
java.util.logging.manager = org.jboss.logmanager.LogManager
java.vendor = Oracle Corporation
java.vendor.url = http://java.oracle.com/
java.vendor.url.bug = http://bugreport.sun.com/bugreport/
java.version = 1.7.0_10
java.vm.info = mixed mode
java.vm.name = Java HotSpot(TM) 64-Bit Server VM
java.vm.specification.name = Java Virtual Machine Specification
java.vm.specification.vendor = Oracle Corporation
java.vm.specification.version = 1.7
java.vm.vendor = Oracle Corporation
java.vm.version = 23.6-b04
javax.management.builder.initial = org.jboss.as.jmx.PluggableMBeanServerBuilder
javax.xml.datatype.DatatypeFactory = __redirected.__DatatypeFactory
javax.xml.parsers.DocumentBuilderFactory = __redirected.__DocumentBuilderFactory
javax.xml.parsers.SAXParserFactory = __redirected.__SAXParserFactory
javax.xml.stream.XMLEventFactory = __redirected.__XMLEventFactory
javax.xml.stream.XMLInputFactory = __redirected.__XMLInputFactory
javax.xml.stream.XMLOutputFactory = __redirected.__XMLOutputFactory
javax.xml.transform.TransformerFactory = __redirected.__TransformerFactory
javax.xml.validation.SchemaFactory:http://www.w3.org/2001/XMLSchema = __redirected.__SchemaFactory
javax.xml.xpath.XPathFactory:http://java.sun.com/jaxp/xpath/dom = __redirected.__XPathFactory
jboss.bind.address = localhost
jboss.home.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1
jboss.host.name = mte039
jboss.modules.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\modules
jboss.modules.system.pkgs = org.jboss.byteman
jboss.node.name = mte039
jboss.qualified.host.name = mte039
jboss.server.base.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\standalone
jboss.server.config.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\standalone\configuration
jboss.server.data.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\standalone\data
jboss.server.deploy.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\standalone\data\content
jboss.server.log.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\standalone\log
jboss.server.name = mte039
jboss.server.temp.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\standalone\tmp
line.separator =
logging.configuration = file:/C:/Users/marcelo/Desenvolvimento/jboss-as-7.1.1/standalone/configuration/logging.properties
module.path = C:/Users/marcelo/Desenvolvimento/jboss-as-7.1.1/modules
org.jboss.boot.log.file = C:/Users/marcelo/Desenvolvimento/jboss-as-7.1.1/standalone/log/boot.log
org.jboss.resolver.warning = true
org.xml.sax.driver = __redirected.__XMLReaderFactory
os.arch = amd64
os.name = Windows 7
os.version = 6.1
path.separator = ;
sun.arch.data.model = 64
sun.boot.class.path = C:\Program Files\Java\jre7\lib\resources.jar;C:\Program Files\Java\jre7\lib\rt.jar;C:\Program Files\Java\jre7\lib\sunrsasign.jar;C:\Program Files\Java\jre7\lib\jsse.jar;C:\Program Files\Java\jre7\lib\jce.jar;C:\Program Files\Java\jre7\lib\charsets.jar;C:\Program Files\Java\jre7\lib\jfr.jar;C:\Program Files\Java\jre7\classes
sun.boot.library.path = C:\Program Files\Java\jre7\bin
sun.cpu.endian = little
sun.cpu.isalist = amd64
sun.desktop = windows
sun.io.unicode.encoding = UnicodeLittle
sun.java.command = org.jboss.modules.Main -mp C:/Users/marcelo/Desenvolvimento/jboss-as-7.1.1/modules -jaxpmodule javax.xml.jaxp-provider org.jboss.as.standalone -b localhost --server-config=standalone.xml
sun.java.launcher = SUN_STANDARD
sun.jnu.encoding = Cp1252
sun.management.compiler = HotSpot 64-Bit Tiered Compilers
sun.os.patch.level = Service Pack 1
sun.rmi.dgc.client.gcInterval = 3600000
sun.rmi.dgc.server.gcInterval = 3600000
user.country = BR
user.dir = C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\bin
user.home = C:\Users\marcelo
user.language = pt
user.name = marcelo
user.script =
user.timezone = America/Sao_Paulo
user.variant =
18:16:26,151 DEBUG [org.jboss.as.config] VM Arguments: -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:55810 -Xms64m -Xmx512m -XX:MaxPermSize=256m -Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true -Dorg.jboss.boot.log.file=C:/Users/marcelo/Desenvolvimento/jboss-as-7.1.1/standalone/log/boot.log -Dlogging.configuration=file:/C:/Users/marcelo/Desenvolvimento/jboss-as-7.1.1/standalone/configuration/logging.properties -Djboss.home.dir=C:/Users/marcelo/Desenvolvimento/jboss-as-7.1.1 -Dfile.encoding=UTF-8
18:16:27,094 INFO [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-http)
18:16:27,094 INFO [org.xnio] XNIO Version 3.0.3.GA
18:16:27,108 INFO [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA
18:16:27,117 INFO [org.jboss.remoting] JBoss Remoting version 3.2.3.GA
18:16:27,133 INFO [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers
JBOSS: server.log
18:16:27,139 INFO [org.jboss.as.configadmin] (ServerService Thread Pool -- 26) JBAS016200: Activating ConfigAdmin Subsystem
18:16:27,158 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinispan subsystem.
18:16:27,185 INFO [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013101: Activating Security Subsystem
18:16:27,200 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension
18:16:27,210 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011940: Activating OSGi Subsystem
18:16:27,221 INFO [org.jboss.as.security] (MSC service thread 1-5) JBAS013100: Current PicketBox version=4.0.7.Final
18:16:27,222 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem
18:16:27,266 INFO [org.jboss.as.connector] (MSC service thread 1-6) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final)
18:16:27,292 INFO [org.jboss.as.naming] (MSC service thread 1-4) JBAS011802: Starting Naming Service
18:16:27,348 INFO [org.jboss.as.mail.extension] (MSC service thread 1-4) JBAS015400: Bound mail session [java:jboss/mail/Default]
18:16:27,416 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
18:16:27,435 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
18:16:27,447 TRACE [org.jboss.security.jacc.DelegatingPolicy] (MSC service thread 1-5) Loaded JACC permissions: true
18:16:27,455 TRACE [org.jboss.security.jacc.DelegatingPolicy] (MSC service thread 1-5) loaded policy context classclass javax.security.jacc.PolicyContext
18:16:27,506 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (MSC service thread 1-7) CallbackHandler: org.jboss.security.auth.callback.JBossCallbackHandler@9e2d687
18:16:27,519 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (MSC service thread 1-1) CallbackHandler: org.jboss.security.auth.callback.JBossCallbackHandler@240f931d
18:16:27,507 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (MSC service thread 1-4) CallbackHandler: org.jboss.security.auth.callback.JBossCallbackHandler@4b63dcfc
18:16:27,506 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (MSC service thread 1-5) CallbackHandler: org.jboss.security.auth.callback.JBossCallbackHandler@794d71b3
18:16:27,506 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (MSC service thread 1-6) CallbackHandler: org.jboss.security.auth.callback.JBossCallbackHandler@b723e23
18:16:27,550 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-8) JBoss Web Services - Stack CXF Server 4.0.2.GA
18:16:27,908 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-8) JBAS015012: Started FileSystemDeploymentService for directory C:\Users\marcelo\Desenvolvimento\jboss-as-7.1.1\standalone\deployments
18:16:27,941 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found pcp.war in deployment directory. To trigger deployment create a file called pcp.war.dodeploy
18:16:28,025 INFO [org.jboss.as.remoting] (MSC service thread 1-5) JBAS017100: Listening on /127.0.0.1:9999
18:16:28,025 INFO [org.jboss.as.remoting] (MSC service thread 1-7) JBAS017100: Listening on localhost/127.0.0.1:4447
18:16:28,054 INFO [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-6) Starting Coyote HTTP/1.1 on http-localhost-127.0.0.1-8080
18:16:28,224 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) JBAS010400: Bound data source [java:/PCPTestDS]
18:16:28,229 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) JBAS010400: Bound data source [java:/PCPDS]
18:16:28,228 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) JBAS010400: Bound data source [java:/CrudDS]
18:16:28,638 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "pcp.war"
18:16:28,801 INFO [org.jboss.as.jpa] (MSC service thread 1-3) JBAS011401: Read persistence.xml for PCPTestDS
18:16:28,914 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named AreaService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/AreaService!br.com.snclavalinmarte.pcp.services.AreaService
java:app/pcp/AreaService!br.com.snclavalinmarte.pcp.services.AreaService
java:module/AreaService!br.com.snclavalinmarte.pcp.services.AreaService
java:global/pcp/AreaService
java:app/pcp/AreaService
java:module/AreaService
18:16:28,933 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named ControleAcessoService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/ControleAcessoService!br.com.snclavalinmarte.pcp.services.ControleAcessoService
java:app/pcp/ControleAcessoService!br.com.snclavalinmarte.pcp.services.ControleAcessoService
java:module/ControleAcessoService!br.com.snclavalinmarte.pcp.services.ControleAcessoService
java:global/pcp/ControleAcessoService
java:app/pcp/ControleAcessoService
java:module/ControleAcessoService
18:16:28,956 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named ClassificacaoProfissionalService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/ClassificacaoProfissionalService!br.com.snclavalinmarte.pcp.services.ClassificacaoProfissionalService
java:app/pcp/ClassificacaoProfissionalService!br.com.snclavalinmarte.pcp.services.ClassificacaoProfissionalService
java:module/ClassificacaoProfissionalService!br.com.snclavalinmarte.pcp.services.ClassificacaoProfissionalService
java:global/pcp/ClassificacaoProfissionalService
java:app/pcp/ClassificacaoProfissionalService
java:module/ClassificacaoProfissionalService
18:16:28,982 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named CentroCustoService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/CentroCustoService!br.com.snclavalinmarte.pcp.services.CentroCustoService
java:app/pcp/CentroCustoService!br.com.snclavalinmarte.pcp.services.CentroCustoService
java:module/CentroCustoService!br.com.snclavalinmarte.pcp.services.CentroCustoService
java:global/pcp/CentroCustoService
java:app/pcp/CentroCustoService
java:module/CentroCustoService
18:16:29,009 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named UsuarioService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/UsuarioService!br.com.snclavalinmarte.pcp.services.UsuarioService
java:app/pcp/UsuarioService!br.com.snclavalinmarte.pcp.services.UsuarioService
java:module/UsuarioService!br.com.snclavalinmarte.pcp.services.UsuarioService
java:global/pcp/UsuarioService
java:app/pcp/UsuarioService
java:module/UsuarioService
18:16:29,029 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named FolhaPontoService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/FolhaPontoService!br.com.snclavalinmarte.pcp.services.FolhaPontoService
java:app/pcp/FolhaPontoService!br.com.snclavalinmarte.pcp.services.FolhaPontoService
java:module/FolhaPontoService!br.com.snclavalinmarte.pcp.services.FolhaPontoService
java:global/pcp/FolhaPontoService
java:app/pcp/FolhaPontoService
java:module/FolhaPontoService
18:16:29,050 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named ClienteService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/ClienteService!br.com.snclavalinmarte.pcp.services.ClienteService
java:app/pcp/ClienteService!br.com.snclavalinmarte.pcp.services.ClienteService
java:module/ClienteService!br.com.snclavalinmarte.pcp.services.ClienteService
java:global/pcp/ClienteService
java:app/pcp/ClienteService
java:module/ClienteService
18:16:29,073 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named DisciplinaService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/DisciplinaService!br.com.snclavalinmarte.pcp.services.DisciplinaService
java:app/pcp/DisciplinaService!br.com.snclavalinmarte.pcp.services.DisciplinaService
java:module/DisciplinaService!br.com.snclavalinmarte.pcp.services.DisciplinaService
java:global/pcp/DisciplinaService
java:app/pcp/DisciplinaService
java:module/DisciplinaService
18:16:29,094 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named AtividadeService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/AtividadeService!br.com.snclavalinmarte.pcp.services.AtividadeService
java:app/pcp/AtividadeService!br.com.snclavalinmarte.pcp.services.AtividadeService
java:module/AtividadeService!br.com.snclavalinmarte.pcp.services.AtividadeService
java:global/pcp/AtividadeService
java:app/pcp/AtividadeService
java:module/AtividadeService
18:16:29,115 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named FaixaSalarialService in deployment unit deployment "pcp.war" are as follows:
java:global/pcp/FaixaSalarialService!br.com.snclavalinmarte.pcp.services.FaixaSalarialService
java:app/pcp/FaixaSalarialService!br.com.snclavalinmarte.pcp.services.FaixaSalarialService
java:module/FaixaSalarialService!br.com.snclavalinmarte.pcp.services.FaixaSalarialService
java:global/pcp/FaixaSalarialService
java:app/pcp/FaixaSalarialService
java:module/FaixaSalarialService
18:16:29,408 INFO [org.jboss.as.jpa] (MSC service thread 1-3) JBAS011402: Starting Persistence Unit Service 'pcp.war#PCPTestDS'
18:16:29,451 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(getPolicyConfiguration) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:29,481 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) ctor, contextID=pcp.war
18:16:29,488 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(getPolicyConfiguration) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:29,520 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) commit:pcp.war
18:16:29,527 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(commit) = State(name=inService
on: getContextID go to: inService
on: inService go to: inService
on: delete go to: deleted
on: getPolicyConfiguration go to: open)
18:16:29,575 INFO [org.hibernate.annotations.common.Version] (MSC service thread 1-3) HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
18:16:29,588 INFO [org.hibernate.Version] (MSC service thread 1-3) HHH000412: Hibernate Core {4.0.1.Final}
18:16:29,594 INFO [org.hibernate.cfg.Environment] (MSC service thread 1-3) HHH000206: hibernate.properties not found
18:16:29,600 INFO [org.hibernate.cfg.Environment] (MSC service thread 1-3) HHH000021: Bytecode provider name : javassist
18:16:29,625 INFO [org.hibernate.ejb.Ejb3Configuration] (MSC service thread 1-3) HHH000204: Processing PersistenceUnitInfo [
name: PCPTestDS
...]
18:16:29,897 INFO [org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator] (MSC service thread 1-3) HHH000130: Instantiating explicit connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
18:16:29,950 INFO [org.hibernate.dialect.Dialect] (MSC service thread 1-3) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
18:16:29,972 INFO [org.hibernate.engine.transaction.internal.TransactionFactoryInitiator] (MSC service thread 1-3) HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jta.CMTTransactionFactory
18:16:29,984 INFO [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (MSC service thread 1-3) HHH000397: Using ASTQueryTranslatorFactory
18:16:30,022 INFO [org.hibernate.validator.util.Version] (MSC service thread 1-3) Hibernate Validator 4.2.0.Final
18:16:30,429 INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-3) HHH000228: Running hbm2ddl schema update
18:16:30,435 INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-3) HHH000102: Fetching database metadata
18:16:30,445 INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-3) HHH000396: Updating schema
18:16:30,547 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.controleacesso_permissoes
18:16:30,554 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [permissoes_id, controleacesso_id]
18:16:30,561 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: [fkc46794cfbe062401]
18:16:30,568 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [fkc46794cf4d2ad161, fkc46794cfbe062401]
18:16:30,594 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.usuario_controleacesso
18:16:30,602 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [usuario_id, controleacesso_id]
18:16:30,607 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: [fk6985d8e513c72233, fk6985d8e5be062401]
18:16:30,616 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [fk6985d8e513c72233, fk6985d8e5be062401]
18:16:30,678 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.area
18:16:30,686 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id, sigla, ativo, descricao]
18:16:30,694 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: []
18:16:30,701 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [descricao_unique, primary, sigla_unique, id_unique]
18:16:30,734 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.atividade
18:16:30,740 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id, id_disciplina, ativo, descricao]
18:16:30,746 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: [fk_atividade_disciplina]
18:16:30,755 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [fk_atividade_disciplina, primary, ativa_unique, id_unique]
18:16:30,794 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.centro_custo
18:16:30,800 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id, id_area, ativo, id_cliente]
18:16:30,805 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: [fk_centrocusto_area, fk_centrocusto_cliente]
18:16:30,815 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [primary, fk_centrocusto_cliente, fk_area]
18:16:30,858 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.classificacao_profissional
18:16:30,866 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id, ativo, descricao]
18:16:30,873 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: []
18:16:30,877 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [descricao_unique, primary, id_unique]
18:16:30,910 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.cliente
18:16:30,918 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id, ativo, nome, cnpj]
18:16:30,928 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: []
18:16:30,935 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [nome_unique, primary, cnpj_unique, id_unique]
18:16:30,984 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.controle_acesso
18:16:30,992 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id, papel]
18:16:31,000 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: []
18:16:31,007 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [primary, id_unique]
18:16:31,062 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.disciplina
18:16:31,071 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id, id_area, ativo, descricao]
18:16:31,080 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: [fk_disciplina_area]
18:16:31,085 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [descricao_unique, fk_disciplina_area, primary, ativa_unique, id_unique]
18:16:31,131 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.faixa_salarial
18:16:31,140 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id, ativo, faixa, maximo, descricao, media, minimo]
18:16:31,150 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: []
18:16:31,157 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [primary, id_unique]
18:16:31,201 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.folha_ponto
18:16:31,210 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id_centrocusto, id, id_usuario, id_atividade]
18:16:31,222 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: [fk_folhaponto_atividade, fk_folhaponto_usuario, fk_folhaponto_centrocusto]
18:16:31,232 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [fk_centrocusto, primary, fk_atividade, fk_usuario, id_unique]
18:16:31,283 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.permissoes
18:16:31,289 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [sistema, id]
18:16:31,293 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: []
18:16:31,298 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [primary]
18:16:31,336 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000261: Table found: pcp_teste.usuario
18:16:31,341 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000037: Columns: [id_controleacesso, id_classificacaoprofissional, id_disciplina, id_faixasalarial, dataadmissao, password, datademissao, matricula, id, username, email, ativo, role, nome]
18:16:31,351 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000108: Foreign keys: [fk_usuario_disciplina, fk_usuario_classificacaoprofissional, fk_usuario_faixasalarial, fk_usuario_controleacesso]
18:16:31,359 INFO [org.hibernate.tool.hbm2ddl.TableMetadata] (MSC service thread 1-3) HHH000126: Indexes: [fk_usuario_controleacesso_idx, fk_classificacaoprofissional, matricula_unique, primary, fk_faixasalarial, fk_disciplina, username_index, username_unique, email_unique, id_unique]
18:16:31,374 INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-3) HHH000232: Schema update complete
18:16:31,569 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service thread 1-1) Inicializando Mojarra 2.1.7-jbossorg-1 (20120227-1401) para o contexto '/pcp'
18:16:32,923 INFO [org.jboss.web] (MSC service thread 1-1) JBAS018210: Registering web context: /pcp
18:16:32,929 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(getPolicyConfiguration) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:32,964 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=ADMIN, p=("javax.security.jacc.WebResourcePermission" "/pages/protected/admin/*" "GET,POST")
18:16:32,976 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,007 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToUncheckedPolicy, p=("javax.security.jacc.WebResourcePermission" "/pages/protected/admin/*")
18:16:33,018 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToUncheckedPolicy) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,049 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToUncheckedPolicy, p=("javax.security.jacc.WebUserDataPermission" "/pages/protected/admin/*" "GET,POST")
18:16:33,060 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToUncheckedPolicy) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,082 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToUncheckedPolicy, p=("javax.security.jacc.WebUserDataPermission" "/pages/protected/admin/*")
18:16:33,089 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToUncheckedPolicy) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,110 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToUncheckedPolicy, p=("javax.security.jacc.WebResourcePermission" "/:/pages/protected/admin/*")
18:16:33,117 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToUncheckedPolicy) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,136 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToUncheckedPolicy, p=("javax.security.jacc.WebUserDataPermission" "/:/pages/protected/admin/*")
18:16:33,143 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToUncheckedPolicy) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,162 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToUncheckedPolicy, p=("javax.security.jacc.WebUserDataPermission" "/")
18:16:33,168 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToUncheckedPolicy) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,187 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=ADMIN, p=("javax.security.jacc.WebRoleRefPermission" "jsp" "ADMIN")
18:16:33,193 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,212 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=USER, p=("javax.security.jacc.WebRoleRefPermission" "jsp" "USER")
18:16:33,218 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,236 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=ADMIN, p=("javax.security.jacc.WebRoleRefPermission" "default" "ADMIN")
18:16:33,243 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,261 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=USER, p=("javax.security.jacc.WebRoleRefPermission" "default" "USER")
18:16:33,267 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,285 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=ADMIN, p=("javax.security.jacc.WebRoleRefPermission" "Faces Servlet" "ADMIN")
18:16:33,292 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,310 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=USER, p=("javax.security.jacc.WebRoleRefPermission" "Faces Servlet" "USER")
18:16:33,317 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,335 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=ADMIN, p=("javax.security.jacc.WebRoleRefPermission" "" "ADMIN")
18:16:33,341 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,360 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=USER, p=("javax.security.jacc.WebRoleRefPermission" "" "USER")
18:16:33,366 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,384 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=ADMIN, p=("javax.security.jacc.WebRoleRefPermission" "jsp" "ADMIN")
18:16:33,390 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,409 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=USER, p=("javax.security.jacc.WebRoleRefPermission" "jsp" "USER")
18:16:33,416 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,434 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=ADMIN, p=("javax.security.jacc.WebRoleRefPermission" "default" "ADMIN")
18:16:33,441 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,459 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=USER, p=("javax.security.jacc.WebRoleRefPermission" "default" "USER")
18:16:33,465 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,484 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=ADMIN, p=("javax.security.jacc.WebRoleRefPermission" "Faces Servlet" "ADMIN")
18:16:33,491 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,509 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) addToRole, roleName=USER, p=("javax.security.jacc.WebRoleRefPermission" "Faces Servlet" "USER")
18:16:33,516 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(addToRole) = State(name=open
on: addToExcludedPolicy go to: open
on: inService go to: open
on: getContextID go to: open
on: removeExcludedPolicy go to: open
on: commit go to: inService
on: removeRole go to: open
on: addToUncheckedPolicy go to: open
on: delete go to: deleted
on: getPolicyConfiguration go to: open
on: addToRole go to: open
on: linkConfiguration go to: open
on: removeUncheckedPolicy go to: open)
18:16:33,535 TRACE [org.jboss.security.jacc.JBossPolicyConfiguration] (MSC service thread 1-1) commit:pcp.war
18:16:33,538 TRACE [org.jboss.security.util.state.StateMachine] (MSC service thread 1-1) nextState(commit) = State(name=inService
on: getContextID go to: inService
on: inService go to: inService
on: delete go to: deleted
on: getPolicyConfiguration go to: open)
18:16:33,549 INFO [org.jboss.as] (MSC service thread 1-1) JBAS015951: Admin console listening on http://127.0.0.1:9990
18:16:33,554 INFO [org.jboss.as] (MSC service thread 1-1) JBAS015874: JBoss AS 7.1.1.Final "Brontes" started in 8161ms - Started 301 of 380 services (76 services are passive or on-demand)
18:16:33,608 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "pcp.war"
18:18:42,945 TRACE [org.jboss.security.SecurityRolesAssociation] (http-localhost-127.0.0.1-8080-1) Setting threadlocal:null
18:18:42,977 TRACE [org.jboss.security.SecurityRolesAssociation] (http-localhost-127.0.0.1-8080-1) Setting threadlocal:null
18:18:51,346 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (http-localhost-127.0.0.1-8080-1) Begin isValid, principal:marcelo.magalhaes, cache entry: null
18:18:51,361 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (http-localhost-127.0.0.1-8080-1) defaultLogin, principal=marcelo.magalhaes
18:18:51,369 TRACE [org.jboss.security.auth.login.XMLLoginConfigImpl] (http-localhost-127.0.0.1-8080-1) Begin getAppConfigurationEntry(PCPRealm), size=5
18:18:51,380 TRACE [org.jboss.security.auth.login.XMLLoginConfigImpl] (http-localhost-127.0.0.1-8080-1) End getAppConfigurationEntry(PCPRealm), authInfo=AppConfigurationEntry[]:
[0]
LoginModule Class: org.jboss.security.auth.spi.DatabaseServerLoginModule
ControlFlag: LoginModuleControlFlag: required
Options:
name=principalsQuery, value=select password from usuario where username=?
name=dsJndiName, value=PCPTestDS
name=rolesQuery, value=select role, 'Roles' from usuario where username=?
18:18:51,400 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) initialize
18:18:51,404 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) Security domain: PCPRealm
18:18:51,410 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) DatabaseServerLoginModule, dsJndiName=PCPTestDS
18:18:51,415 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) principalsQuery=select password from usuario where username=?
18:18:51,421 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) rolesQuery=select role, 'Roles' from usuario where username=?
18:18:51,427 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) suspendResume=true
18:18:51,433 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) login
18:18:51,437 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) suspendAnyTransaction
18:18:51,443 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) Excuting query: select password from usuario where username=?, with username: marcelo.magalhaes
18:18:51,465 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) Obtained user password
18:18:51,470 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) resumeAnyTransaction
18:18:51,476 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) User 'marcelo.magalhaes' authenticated, loginOk=true
18:18:51,482 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) commit, loginOk=true
18:18:51,488 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) getRoleSets using rolesQuery: select role, 'Roles' from usuario where username=?, username: marcelo.magalhaes
18:18:51,498 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) suspendAnyTransaction
18:18:51,503 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) Excuting query: select role, 'Roles' from usuario where username=?, with username: marcelo.magalhaes
18:18:51,512 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) Assign user to role ADMIN
18:18:51,516 TRACE [org.jboss.security.auth.spi.DatabaseServerLoginModule] (http-localhost-127.0.0.1-8080-1) resumeAnyTransaction
18:18:51,522 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (http-localhost-127.0.0.1-8080-1) defaultLogin, lc=javax.security.auth.login.LoginContext@569dcc7, subject=Subject(1385128954).principals=org.jboss.security.SimplePrincipal@648571232(marcelo.magalhaes)org.jboss.security.SimpleGroup@1360551197(CallerPrincipal(members:marcelo.magalhaes))org.jboss.security.SimpleGroup@1360551197(Roles(members:ADMIN))
18:18:51,539 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (http-localhost-127.0.0.1-8080-1) updateCache, inputSubject=Subject(1385128954).principals=org.jboss.security.SimplePrincipal@648571232(marcelo.magalhaes)org.jboss.security.SimpleGroup@1360551197(CallerPrincipal(members:marcelo.magalhaes))org.jboss.security.SimpleGroup@1360551197(Roles(members:ADMIN)), cacheSubject=Subject(1563220984).principals=org.jboss.security.SimplePrincipal@648571232(marcelo.magalhaes)org.jboss.security.SimpleGroup@1360551197(CallerPrincipal(members:marcelo.magalhaes))org.jboss.security.SimpleGroup@1360551197(Roles(members:ADMIN))
18:18:51,562 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (http-localhost-127.0.0.1-8080-1) Inserted cache info: org.jboss.security.authentication.JBossCachedAuthenticationManager$DomainInfo@2c1da692
18:18:51,571 TRACE [org.jboss.security.authentication.JBossCachedAuthenticationManager] (http-localhost-127.0.0.1-8080-1) End isValid, true
18:18:51,580 TRACE [org.jboss.security.SecurityRolesAssociation] (http-localhost-127.0.0.1-8080-1) Setting threadlocal:null
Pelo log do JBOSS percebo que ele fez validação correta do usuário, mas depois nada acontece e caio na página de erro em anexo. O que acho estranho nisso tudo é que em momento algum indico qual classe (no caso até coloquei aqui a minha classe UsuarioManagedBean) irá ser executada após o login com sucesso. Tenho quase certeza que meu problema está no “redirecionamento” após o login, que no caso deveria ir para a página: /pages/protected/admin/admin.xhtml
Alguem ai pode me dar uma luz :idea: … estou no escuro a dias :shock: :shock: :shock: