Ir para o conteúdo

 Voltar a Banco de Tal...
Tela cheia

Problemas no Login

11 de Julho de 2013, 15:39 , por Desconhecido - | Ninguém seguindo este artigo por enquanto.
Visualizado 54 vezes

Boa tarde Luciano,

 Segue o log... 

 

11/07/2013 15:28:38,419 |  | ERROR | JDBCExceptionReporter (logExceptions:101) | Could not create connection to database server. Attempted reconnect 3 times. Giving up.

11/07/2013 15:28:38,420 |  | ERROR | CDException (gerarLog:264) | 034509 | ST: br.gov.camara.negocio.exception.DAOException.dispararExcecao(DAOException.java:96)
11/07/2013 15:28:38,421 |  | ERROR | CDException (gerarLog:264) | 034509 | ST: br.gov.camara.negocio.DAO.obterListaPorHQL(DAO.java:286)
11/07/2013 15:28:38,421 |  | ERROR | CDException (gerarLog:264) | 034509 | ST: br.gov.camara.negocio.DAO.obter(DAO.java:257)
11/07/2013 15:28:38,422 |  | ERROR | CDException (gerarLog:264) | 034509 | ST: br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
11/07/2013 15:28:38,422 |  | ERROR | CDException (gerarLog:264) | 034509 | ST: br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
11/07/2013 15:28:38,423 |  | ERROR | CDException (gerarLog:264) | 034509 | ST: br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
11/07/2013 15:28:38,423 |  | ERROR | CDException (gerarLog:268) | 034509 | GM: (...) Ocorreu um erro inesperado. CAUSA: Cannot open connection. | class br.gov.camara.negocio.exception.DAOException
11/07/2013 15:28:42,428 |  | WARN | JDBCExceptionReporter (logExceptions:100) | SQL Error: 0, SQLState: 08001
11/07/2013 15:28:42,429 |  | ERROR | JDBCExceptionReporter (logExceptions:101) | Could not create connection to database server. Attempted reconnect 3 times. Giving up.
11/07/2013 15:28:42,429 |  | ERROR | FabricaSessaoHibernate (fecharSessao:248) | Ocorreu um erro tentando realizar a transação (por causa do Ingres que abre uma automaticamente) para a conexão 'conexaoPadrao': org.hibernate.exception.JDBCConnectionException: Cannot open connection
br.gov.camara.hibernate.exception.HibernateExceptionCD: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at br.gov.camara.hibernate.ConexaoJDBC.resolverFaltaAutocommit(ConexaoJDBC.java:61)
at br.gov.camara.hibernate.FabricaSessaoHibernate.fecharSessao(FabricaSessaoHibernate.java:244)
at br.gov.camara.hibernate.HibernateUtilCD.fecharSessao(HibernateUtilCD.java:271)
at br.gov.camara.negocio.DAO.desconectar(DAO.java:114)
at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:127)
at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at br.gov.camara.hibernate.ConexaoJDBC.resolverFaltaAutocommit(ConexaoJDBC.java:52)
... 37 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2299)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2220)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor80.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 40 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor77.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:350)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2393)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2238)
... 53 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
... 55 more
11/07/2013 15:28:42,437 |  | ERROR | FabricaSessaoHibernate (fecharSessao:275) | ...Ocorreu o seguinte erro executando o flush para a conexão 'conexaoPadrao': 0) org.hibernate.exception.JDBCConnectionException: Cannot open connection.

11/07/2013 15:28:42,437 |  | ERROR | CDException (gerarLog:264) | 403439 | ST: br.gov.camara.negocio.exception.DAOException.dispararExcecao(DAOException.java:96)
11/07/2013 15:28:42,438 |  | ERROR | CDException (gerarLog:264) | 403439 | ST: br.gov.camara.negocio.DAO.desconectar(DAO.java:118)
11/07/2013 15:28:42,438 |  | ERROR | CDException (gerarLog:264) | 403439 | ST: br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:127)
11/07/2013 15:28:42,438 |  | ERROR | CDException (gerarLog:264) | 403439 | ST: br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
11/07/2013 15:28:42,438 |  | ERROR | CDException (gerarLog:264) | 403439 | ST: br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
11/07/2013 15:28:42,438 |  | ERROR | CDException (gerarLog:264) | 403439 | ST: br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
11/07/2013 15:28:42,439 |  | ERROR | CDException (gerarLog:268) | 403439 | GM: (...) Ocorreu um erro inesperado. CAUSA: 0) org.hibernate.exception.JDBCConnectionException: Cannot open connection.
. | class br.gov.camara.negocio.exception.DAOException
11/07/2013 15:28:42,439 |  | ERROR | UnidadeAutenticadoraBT (autenticarUsuario:102) | autenticarUsuario(String strLoginUsuario = M10001, String strSenhaUsuario = senha) - catch
br.gov.camara.negocio.exception.DAOException: 0) org.hibernate.exception.JDBCConnectionException: Cannot open connection.

at br.gov.camara.negocio.exception.DAOException.dispararExcecao(DAOException.java:96)
at br.gov.camara.negocio.DAO.desconectar(DAO.java:118)
at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:127)
at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: br.gov.camara.hibernate.exception.HibernateExceptionCD: 0) org.hibernate.exception.JDBCConnectionException: Cannot open connection.

at br.gov.camara.hibernate.exception.HibernateExceptionCD.dispararExcecao(HibernateExceptionCD.java:57)
at br.gov.camara.hibernate.FabricaSessaoHibernate.fecharSessao(FabricaSessaoHibernate.java:279)
at br.gov.camara.hibernate.HibernateUtilCD.fecharSessao(HibernateUtilCD.java:271)
at br.gov.camara.negocio.DAO.desconectar(DAO.java:114)
... 34 more
Caused by: org.hibernate.HibernateException: 0) org.hibernate.exception.JDBCConnectionException: Cannot open connection.

at br.gov.camara.hibernate.FabricaSessaoHibernate.fecharSessao(FabricaSessaoHibernate.java:268)
... 36 more
11/07/2013 15:28:42,440 |  | ERROR | CDException (gerarLog:264) | 344380 | ST: br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:105)
11/07/2013 15:28:42,440 |  | ERROR | CDException (gerarLog:264) | 344380 | ST: br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
11/07/2013 15:28:42,440 |  | ERROR | CDException (gerarLog:264) | 344380 | ST: br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
11/07/2013 15:28:42,440 |  | ERROR | CDException (gerarLog:264) | 344380 | ST: org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
11/07/2013 15:28:42,441 |  | ERROR | CDException (gerarLog:264) | 344380 | ST: org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
11/07/2013 15:28:42,441 |  | ERROR | CDException (gerarLog:264) | 344380 | ST: org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
11/07/2013 15:28:42,441 |  | ERROR | CDException (gerarLog:268) | 344380 | GM: (...) Ocorreu um erro tentando autenticar o usuário | class br.gov.camara.seguranca.exception.SegurancaException
11/07/2013 15:28:42,441 |  | INFO | AutenticacaoSequencia (validarLogonEfetuarLogon:271) | Logon inválido | M10001

Autor: yuri cavalcante


22 comentários

  • F24dd96a3b3343b99b684fc44d2e5b71?only path=false&size=50&d=404Luciano Dias(usuário não autenticado)
    11 de Julho de 2013, 16:25

     

    Oi Yuli,

    O problema que aparece no log é de conexão com o banco de dados: "Could not create connection to database server. Attempted reconnect 3 times. Giving up." e "Caused by: java.net.ConnectException: Connection refused".

    Você especificou o usuário e senha no arquivo de configuração hibernate-config.xml? Normalmente, assim que você inicia o Tomcat aparece no log se houve algum problema de conexão.

    Verifique se não é isso.

    Um abraço,

    Luciano.

    • 08bb081fc0dfb8eeb4c891139661898c?only path=false&size=50&d=404yuri cavalcante(usuário não autenticado)
      11 de Julho de 2013, 17:04

       

      Oi Juciano,

       Obrigado pela a forma, eu ja tinha configurado o banco no hibernate-config.xml.

      O problema era no tomcat que não estava reconhecendo a configuração...

       Vou testar o sistema e se surgir alguma duvida, entrarei em contato com você...

       Abraço... 

Essa comunidade não possui posts nesse blog