Question 228760 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – Error while running AgensBrowser on windows

I am trying to run AgensBrowser on my Windows machine, I have already installed AgensGraph. First, I registered in the official website and was sent a link to download the Zip file, I extracted the contents in the Zip file and using my editor created a new file called agensbrowser.BAT and added this code java -jar agens-browser-web-1.0.jar --spring.config.name=agens-browser.config necessary to run the file, When I try to run the file as anexecutable by doing this ./agensbrowser.BAT, I keep getting this error.

==============================================
 AgensBrowser web v1.0 (since 2018-02-01)
==============================================

Exception in thread "main" java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
        at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:394)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:474)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:484)
        at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:494)
        at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:500)
        at net.bitnine.agensbrowser.bundle.persistence.outer.dao.MetaDao.checkAGVersion(MetaDao.java:45)
        at net.bitnine.agensbrowser.bundle.persistence.outer.dao.MetaDao$$FastClassBySpringCGLIB$$9eb80fed.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
        at net.bitnine.agensbrowser.bundle.persistence.outer.dao.MetaDao$$EnhancerBySpringCGLIB$$ac5739ad.checkAGVersion(<generated>)
        at net.bitnine.agensbrowser.bundle.persistence.outer.service.MetaService.checkAGVersion(MetaService.java:50)
        at net.bitnine.agensbrowser.bundle.persistence.outer.service.MetaService$$FastClassBySpringCGLIB$$e5626633.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
        at net.bitnine.agensbrowser.bundle.persistence.outer.service.MetaService$$EnhancerBySpringCGLIB$$d8203da.checkAGVersion(<generated>)
        at net.bitnine.agensbrowser.bundle.AgensBrowserBundleApplication.main(AgensBrowserBundleApplication.java:37)
        ... 8 more

I would really appreciate any help I can get.

Tags:

2

Answers


  1. 0

    It appears that you are using an old JDBC driver version that does not support that authentication method, you should upgrade your JDBC driver. The supported JDBC driver for SCRAM-SHA-256 encryption is 42.2.0 or above.

    Alternatively (remember this is a workaround and the best solution is to upgrade your JDBC driver for improved security), you can change the password_encryption to md5 in postgresql.conf and change scram-sha-256 to md5 in pg_hba.conf. After, changing these files you should alter your password to restore the md5 format, you can use the following command as an example:

    ALTER ROLE postgres WITH PASSWORD 'root';
    Login or Signup to reply.
  2. 0

    Here’s the issue is with the JDBC driver.

    • Your JDBC driver is not compatible with Postgresql version.
    • You need to update your JDBC driver.
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search