Showing posts with label Issues-Solutions. Show all posts
Showing posts with label Issues-Solutions. Show all posts

ESTABLISH CONNECTION FOR USER

Issue:

PLAYBOOK: site.yml *************************************************************
1 plays in /scm/etc/ansible/site.yml

PLAY [web-servers] *************************************************************

TASK [setup] *******************************************************************
<127.0.0.1> ESTABLISH CONNECTION FOR USER: root on PORT 2222 TO 127.0.0.1
fatal: [127.0.0.1]: UNREACHABLE! => {"changed": false, "msg": "[Errno 111] Connection refused", "unreachable": true}
        to retry, use: --limit @/scm/etc/ansible/site.retry

PLAY RECAP *********************************************************************
127.0.0.1                  : ok=0    changed=0    unreachable=1    failed=0

[root@vagrant-centos65]# vi inventory/dev
[root@vagrant-centos65]# ansible-playbook -vvvv -i /scm/inventory/dev /scm/etc/ansible/site.yml "--check"
Using /etc/ansible/ansible.cfg as config file
[DEPRECATION WARNING]: Instead of sudo/sudo_user, use become/become_user and make sure become_method is 'sudo' (default).
This feature will be removed in a future
release. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.
Loaded callback default of type stdout, v2.0

PLAYBOOK: site.yml *************************************************************
1 plays in /scm/etc/ansible/site.yml

PLAY [web-servers] *************************************************************

TASK [setup] *******************************************************************
<127.0.0.1> ESTABLISH CONNECTION FOR USER: root on PORT 22 TO 127.0.0.1
fatal: [127.0.0.1]: UNREACHABLE! => {"changed": false, "msg": "No authentication methods available", "unreachable": true}
        to retry, use: --limit @/scm/etc/ansible/site.retry

PLAY RECAP *********************************************************************
127.0.0.1                  : ok=0    changed=0    unreachable=1    failed=0


Solutions: Just add the value as mention in dev host file and try it will work.

dev

local ansible_ssh_port=2222 ansible_ssh_host=127.0.0.1 ansible_connection=local

[web-servers]
127.0.0.1



org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback

Issue:


HTTP Status 500 - Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [INSERT INTO project (id, name, start_date, end_date, description, bash_path, def_init) VALUES (1, ?, ?, ?, ?, 'NO')]; Parameter index out of range (5 > number of parameters, which is 4).; nested exception is java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).

type Exception report
message Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [INSERT INTO project (id, name, start_date, end_date, description, bash_path, def_init) VALUES (1, ?, ?, ?, ?, 'NO')]; Parameter index out of range (5 > number of parameters, which is 4).; nested exception is java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [INSERT INTO project (id, name, start_date, end_date, description, bash_path, def_init) VALUES (1, ?, ?, ?, ?, 'NO')]; Parameter index out of range (5 > number of parameters, which is 4).; nested exception is java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).
 org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)
 org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
 org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [INSERT INTO project (id, name, start_date, end_date, description, bash_path, def_init) VALUES (1, ?, ?, ?, ?, 'NO')]; Parameter index out of range (5 > number of parameters, which is 4).; nested exception is java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).
 org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
 org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
 org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
 org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)
 org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909)
 org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
 org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:980)
 com.tutorialbyexample.dao.ProjectDAOImpl.save(ProjectDAOImpl.java:36)
 com.tutorialbyexample.controller.ProjectController.saveProject(ProjectController.java:59)
 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 java.lang.reflect.Method.invoke(Method.java:498)
 org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
 org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
 org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
 org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
 org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
 org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
 org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
 org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
 org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).
 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
 com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3688)
 com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3670)
 com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4491)
 org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:391)
 org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:235)
 org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:166)
 org.springframework.jdbc.core.ArgumentPreparedStatementSetter.doSetValue(ArgumentPreparedStatementSetter.java:66)
 org.springframework.jdbc.core.ArgumentPreparedStatementSetter.setValues(ArgumentPreparedStatementSetter.java:47)
 org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:914)
 org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:909)
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
 org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909)
 org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
 org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:980)
 com.tutorialbyexample.dao.ProjectDAOImpl.save(ProjectDAOImpl.java:36)
 com.tutorialbyexample.controller.ProjectController.saveProject(ProjectController.java:59)
 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 java.lang.reflect.Method.invoke(Method.java:498)
 org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
 org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
 org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
 org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
 org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
 org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
 org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
 org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
 org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
note The full stack trace of the root cause is available in the Apache Tomcat/8.5.4 logs.

Apache Tomcat/8.5.4


Solutions:
Add the aditional ? in insert statement:

INSERT INTO project (id, name, start_date, end_date, description, bash_path, def_init) VALUES (1, ?, ?, ?, ?,?, 'NO')

java.lang.IllegalArgumentException: Page directive: invalid value for import

Issue:

HTTP Status 500 - org.apache.jasper.JasperException: Unable to compile class for JSP


type Exception report
message org.apache.jasper.JasperException: Unable to compile class for JSP
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: org.apache.jasper.JasperException: Unable to compile class for JSP
 org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:556)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:385)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
root cause
org.apache.jasper.JasperException: Unable to compile class for JSP
 org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:677)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
root cause
java.lang.IllegalArgumentException: Page directive: invalid value for import
 org.apache.jasper.compiler.Node$PageDirective.validateImport(Node.java:628)
 org.apache.jasper.compiler.Node$PageDirective.addImport(Node.java:611)
 org.apache.jasper.compiler.Parser.parsePageDirective(Parser.java:348)
 org.apache.jasper.compiler.Parser.parseDirective(Parser.java:469)
 org.apache.jasper.compiler.Parser.parseFileDirectives(Parser.java:1769)
 org.apache.jasper.compiler.Parser.parse(Parser.java:135)
 org.apache.jasper.compiler.ParserController.doParse(ParserController.java:242)
 org.apache.jasper.compiler.ParserController.parseDirectives(ParserController.java:119)
 org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:194)
 org.apache.jasper.compiler.Compiler.compile(Compiler.java:374)
 org.apache.jasper.compiler.Compiler.compile(Compiler.java:354)
 org.apache.jasper.compiler.Compiler.compile(Compiler.java:341)
 org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:662)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.65 logs.

Apache Tomcat/7.0.65



Solution:

Remove ; form import statement.