Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
0 votes
1 view

Good day,

I have recently installed Knowage 6.0, but I am not able to login the following default user credentials:
biadmin
bidemo
bitest
biuser
demo_admin

After login attempt, I am forwarded to the following page:
http://localhost:8080/knowage/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE
displaying the following.

Ooooooops! User or password invalid, Retry!

Please advise accordingly.

br

Stefan
in Installer by (150 points)

2 Answers

+1 vote
 
Best answer
Hi Stefan
    'OPTION SQL_SELECT_LIMIT=DEFAULT' is the clue: I think you should update the MySQL JDBC driver, replacing file Knowage-Server-CE\bin\mysql-connector-java-5.1.33-bin.jar.
Here's an hint https://stackoverflow.com/questions/15669270/option-sql-select-limit-default but you can google it and find your way...

Best regards,

Francesco
by (3.8k points)
selected by
Good Morning,
I installed Knowage from Docker "knowagelabs / knowage-server-docker". I used the docker-compose.yml in the example, making the adjustments according to my needs.
But, when I try to login using the user "biadmin", there is an error "Ooooooops! User or password invalid, Retry!".
I have already changed the mysql connector to the suggested version, and even then the error remains.
The docker-compose used is this:

------------------------------------------------------------------------------------

version: "3.6"

services:

  knowage:
    image: knowagelabs/knowage-server-docker:7.1
    depends_on:
      - knowagedb
    ports:
      - "8000:8080"
    networks:
      default:
        ipv4_address: 172.20.0.20
    environment:
      - DB_USER=admin
      - DB_PASS=mydb7
      - DB_DB=dbase
      - DB_HOST=172.20.0.21
      - DB_PORT=3306
 
  knowagedb:
    image: mysql:5.7.29
    ports:
      - "3306:3306"
    networks:
      default:
        ipv4_address: 172.20.0.21
    environment:
      - MYSQL_USER=admin
      - MYSQL_PASSWORD=mydb7
      - MYSQL_DATABASE=dbase
      - MYSQL_ROOT_PASSWORD=mydb777
    volumes:
      - "/mnt/knowage/db:/var/lib/mysql"

volumes:
  db:

networks:
  default:
    external:
      name: Sete

---------------------------------------------------------------------------

LOG KnowAGE

root@8e9d0aefe393:/# nano /home/knowage/apache-tomcat-8.5.37/logs/knowage.log
  GNU nano 2.7.4                       File: /home/knowage/apache-tomcat-8.5.37/logs/knowage.log

        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1132)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
        at org.apache.catalina.core.ContainerBase.access$000(ContainerBase.java:129)
        at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:150)
        at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:140)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
[http-nio-8080-exec-5] 29 Mar 2020 12:33:38,215 ERROR it.eng.spagobi.commons.services.LoginModule.service:218 - userName/pwd unc$

----------------------------------------------------------

If I try to create a new user using the "Sign up" option, it gives an error, but checking within MySQL, I see that the users were created. That is, the connection to the bank is correct.

What do I do to correct this problem?
0 votes

Dear Stefan,

Can you provide us more info. ?

  • Did you use the installer ?
  • Are you using MySQL ?
  • Are you using Windows ?

Please check the knowage.log if there is any error.

Best Regards

Angelo

by (20.7k points)
Good day,

Thank you for the prompt reply, please refer to the below mentioned answers:

Did you use the installer ? Yes, Knowage-6.0.0-CE-Installer-Windows-JVM64bit-20170616
Are you using MySQL ? Yes, 5.7.14-log
Are you using Windows ? Windows Server 2012 Std.

Knowage-6.0.0-CE-Installer-Windows-JVM64bit-20170616


Please check the knowage.log if there is any error:

[http-bio-8080-exec-6] 26 Jun 2017 12:00:23,650 ERROR it.eng.spagobi.security.InternalSecurityServiceSupplierImpl.checkAuthentication:95 - severity [ERROR] description [Generic Error]
it.eng.spago.error.EMFUserError: severity [ERROR] description [Generic Error]
    at it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.loadSbiUserByUserId(SbiUserDAOHibImpl.java:283)
    at it.eng.spagobi.security.InternalSecurityServiceSupplierImpl.checkAuthentication(InternalSecurityServiceSupplierImpl.java:89)
    at it.eng.spagobi.commons.services.LoginModule.service(LoginModule.java:287)
    at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
    at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
    at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
    at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
    at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:436)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at it.eng.spagobi.utilities.filters.AntiInjectionFilter.doFilter(AntiInjectionFilter.java:45)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:148)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:94)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)
Hi Stefan,
    more sensitive information should be below the excerpt of the log you pasted.
Could you please provide that data?
Best regards,

Francesco
I hoe this will contain more info:

[http-bio-8080-exec-6] 26 Jun 2017 15:02:49,392 ERROR it.eng.spagobi.commons.services.LoginModule.service:289 - userName/pwd uncorrect
[http-bio-8080-exec-11] 26 Jun 2017 15:02:55,167 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
[http-bio-8080-exec-11] 26 Jun 2017 15:02:55,167 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
[http-bio-8080-exec-11] 26 Jun 2017 15:02:55,167 ERROR it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.loadSbiUserByUserId:282 - could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.loader.Loader.doList(Loader.java:2536)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
    at org.hibernate.loader.Loader.list(Loader.java:2271)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
    at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
    at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
    at it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.getSbiUserByUserId(SbiUserDAOHibImpl.java:827)
    at it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.loadSbiUserByUserId(SbiUserDAOHibImpl.java:279)
    at it.eng.spagobi.security.InternalSecurityServiceSupplierImpl.checkAuthentication(InternalSecurityServiceSupplierImpl.java:89)
    at it.eng.spagobi.commons.services.LoginModule.service(LoginModule.java:287)
    at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
    at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
    at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
    at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
    at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:436)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at it.eng.spagobi.utilities.filters.AntiInjectionFilter.doFilter(AntiInjectionFilter.java:45)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:148)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:94)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1439)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
    at org.hibernate.loader.Loader.doQuery(Loader.java:802)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    at org.hibernate.loader.Loader.doList(Loader.java:2533)
    ... 47 more
Hi,

Thanks a million, after downgrading to mysql-connector-java-5.1.25-bin, I am able to access knowage again.

br

Stefan

Hi there

I have installed 6.2.1 CE version. I have the same problem.

I installed Maria DB Embedded version and installed windows 64 bit operation system.

How do I solve this problem?
Thanks.
...