Fiz a instalação do Geplanes seguindo o manual da versão 3.0 ,mas tive problemas quando executo o comando de criação das tabelas:
c:\Program Files\PostgreSQL\8.3\bin>psql.exe -U postgres -f
*Erro:c:\Program Files\PostgreSQL\8.3\bin>psql.exe is not a valid Win32
applicattion*
c:\Temp\geplanes-3.0.sql -d geplanes_bsc
Nessa linha de comando não apresenta nenhum erro quando executo ela,mas ele abre o arquivo geplanes-3.0.sql que estar dentro de c:\Temp\ num arquivo txt e na tela e não tenho certeza se essas tabelas foram criadas.
Quando subo o jboos não apresenta nenhum erro,mas ao testar a aplicação
http://localhost:8080/geplanes_bsc recebo a mensagem abaixo de retorno:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres")); nested exception is org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"))
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:96)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:370)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)
br.com.linkcom.neo.persistence.QueryBuilder.list(QueryBuilder.java:789)
br.com.linkcom.neo.persistence.GenericDAO.findAll(GenericDAO.java:607)
br.com.linkcom.neo.persistence.GenericDAO.findAll(GenericDAO.java:595)
br.com.linkcom.sgm.service.ParametrosSistemaService.getParametrosSistema(ParametrosSistemaService.java:36)
br.com.linkcom.sgm.util.GeplanesUtils.getLogoEmpresaId(GeplanesUtils.java:240)
org.apache.jsp.login_jsp._jspService(login_jsp.java:133)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
br.com.linkcom.neo.authorization.AuthenticationControlFilter.dispachError(AuthenticationControlFilter.java:320)
br.com.linkcom.neo.authorization.AuthenticationControlFilter.doAuth(AuthenticationControlFilter.java:264)
br.com.linkcom.neo.authorization.AuthenticationControlFilter.doFilter(AuthenticationControlFilter.java:97)
br.com.linkcom.neo.core.web.NeoFilter.doFilterInternal(NeoFilter.java:103)
br.com.linkcom.sgm.util.RequestFilter.doFilterInternal(RequestFilter.java:45)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.5.20
Agradeço a atenção se puderem me ajudar.
Autor: Tiago Emanuel