Error while running AgensBrowser on windows

Question

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.

Does this answer your question? [Unable to connect to Postgres DB due to the authentication type 10 is not supported](https://stackoverflow.com/questions/64210167/unable-to-connect-to-postgres-db-due-to-the-authentication-type-10-is-not-suppor) Specifically see the jdbc upgrade answer here: https://stackoverflow.com/a/64211633/13808319 — Mike Organek, Aug 11 '23 at 15:29

score 0 · Answer 1 · answered Aug 12 '23 at 12:53

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';

score -1 · Answer 2 · answered Aug 12 '23 at 17:13

-1

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.

answered Aug 12 '23 at 17:13

adil shahid

125
4

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - [From Review](/review/low-quality-posts/34926599) – Máté Juhász Sep 02 '23 at 18:59

Error while running AgensBrowser on windows

2 Answers2