SERP Hacker support forum - serposcope

Ebouilleur

Member

Registered: 2022-11-17

Posts: 1

Can't connect to Mysql 8

Hello,

I install Serposcope on a new server, and I couldn't connect with mysql8.
When I lunch the serposcope java, i have this error :
Can't establish connection to database
java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'paspegase'@'pegase' (using password: NO)

In the config file I put :
serposcope.db.url=jdbc:mysql://localhost/paspegase?user=paspegase&password=mypassword&allowMultiQueries=true

"paspegase" is my DB name and also my login
I try with root the error

For information, the connexion with phpmyadmin is working.. so I dont have idea. And you ?

Thanks a lot

Log :
[2022-11-18 17:45:13,206] [NinjaJetty] INFO c.SerposcopeConf - serposcope.version : 2.15.0
[2022-11-18 17:45:13,206] [NinjaJetty] INFO c.SerposcopeConf - serposcope.datadir : /root/serposcope
[2022-11-18 17:45:13,206] [NinjaJetty] INFO c.SerposcopeConf - serposcope.logdir : /serposcope/log/
[2022-11-18 17:45:13,206] [NinjaJetty] INFO c.SerposcopeConf - serposcope.db.url : jdbc:mysql://localhost/serposcope?user=test&password=test&allowMultiQueries=true
[2022-11-18 17:45:13,206] [NinjaJetty] INFO c.SerposcopeConf - serposcope.db.debug : true
[2022-11-18 17:45:13,206] [NinjaJetty] INFO c.SerposcopeConf - serposcope.listenAddress : 0.0.0.0
[2022-11-18 17:45:13,206] [NinjaJetty] INFO c.SerposcopeConf - serposcope.listenPort : 7134
[2022-11-18 17:45:14,451] [NinjaJetty] ERROR c.s.s.d.d.DataSourceProvider - Can't establish connection to database
java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'test'@'pegase' (using password: NO)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:135) ~[serposcope.jar:na]
at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101) ~[serposcope.jar:na]
at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:91) ~[serposcope.jar:na]
at org.mariadb.jdbc.Driver.connect(Driver.java:109) ~[serposcope.jar:na]
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:na]
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251) ~[java.sql:na]
at com.serphacker.serposcope.di.db.DataSourceProvider.get(DataSourceProvider.java:40) ~[serposcope.jar:na]
at com.serphacker.serposcope.di.db.DataSourceProvider.get(DataSourceProvider.java:21) ~[serposcope.jar:na]
at com.google.inject.internal.ProviderInternalFactory.provision(ProviderInternalFactory.java:81) ~[serposcope.jar:na]
at com.google.inject.internal.InternalFactoryToInitializableAdapter.provision(InternalFactoryToInitializableAdapter.java:53) ~[serposcope.jar:na]
at com.google.inject.internal.ProviderInternalFactory.circularGet(ProviderInternalFactory.java:61) ~[serposcope.jar:na]
at com.google.inject.internal.InternalFactoryToInitializableAdapter.get(InternalFactoryToInitializableAdapter.java:45) ~[serposcope.jar:na]
at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46) ~[serposcope.jar:na]
at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1103) ~[serposcope.jar:na]
at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40) ~[serposcope.jar:na]
at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:145) ~[serposcope.jar:na]
at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41) ~[serposcope.jar:na]
at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:205) ~[serposcope.jar:na]
at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:199) ~[serposcope.jar:na]
at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092) ~[serposcope.jar:na]
at com.google.inject.internal.InternalInjectorCreator.loadEagerSingletons(InternalInjectorCreator.java:199) ~[serposcope.jar:na]
at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:180) ~[serposcope.jar:na]
at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:110) ~[serposcope.jar:na]
at com.google.inject.Guice.createInjector(Guice.java:96) ~[serposcope.jar:na]
at ninja.Bootstrap.initInjector(Bootstrap.java:218) ~[serposcope.jar:na]
at ninja.Bootstrap.boot(Bootstrap.java:99) ~[serposcope.jar:na]
at ninja.servlet.NinjaServletListener.createNinjaBootstrap(NinjaServletListener.java:131) ~[serposcope.jar:na]
at ninja.servlet.NinjaServletListener.getInjector(NinjaServletListener.java:109) ~[serposcope.jar:na]
at com.google.inject.servlet.GuiceServletContextListener.contextInitialized(GuiceServletContextListener.java:47) ~[serposcope.jar:na]
at ninja.servlet.NinjaServletListener.contextInitialized(NinjaServletListener.java:61) ~[serposcope.jar:na]
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800) ~[serposcope.jar:na]
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444) ~[serposcope.jar:na]
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:791) ~[serposcope.jar:na]
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294) ~[serposcope.jar:na]
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741) ~[serposcope.jar:na]
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) ~[serposcope.jar:na]
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132) ~[serposcope.jar:na]
at org.eclipse.jetty.server.Server.start(Server.java:387) ~[serposcope.jar:na]
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) ~[serposcope.jar:na]
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61) ~[serposcope.jar:na]
at org.eclipse.jetty.server.Server.doStart(Server.java:354) ~[serposcope.jar:na]
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) ~[serposcope.jar:na]
at ninja.standalone.NinjaJetty.doStart(NinjaJetty.java:161) ~[serposcope.jar:na]
at ninja.standalone.AbstractStandalone.start(AbstractStandalone.java:197) ~[serposcope.jar:na]
at ninja.standalone.AbstractStandalone.run(AbstractStandalone.java:94) ~[serposcope.jar:na]
at serposcope.lifecycle.Daemon.start(Daemon.java:19) ~[serposcope.jar:na]
at serposcope.lifecycle.Daemon.main(Daemon.java:15) ~[serposcope.jar:na]
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not connect: Access denied for user 'test'@'pegase' (using password: NO)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:569) ~[serposcope.jar:na]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:503) ~[serposcope.jar:na]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:382) ~[serposcope.jar:na]
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:839) ~[serposcope.jar:na]
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:479) ~[serposcope.jar:na]
at org.mariadb.jdbc.Driver.connect(Driver.java:104) ~[serposcope.jar:na]
... 43 common frames omitted

Last edited by Ebouilleur (2022-11-18 17:36:56)