Service Virtualization

Expand all | Collapse all

DevTest Mysql 8.0.11 DB configuration issue

Jump to Best Answer
  • 1.  DevTest Mysql 8.0.11 DB configuration issue

    Posted 05-22-2018 07:30 AM

    Hi,

     

    I have installed DevTest 10.3 and want to configure Mysql DB for Enterprise Dashboard and Registry server. For Enterprise Dashboard it worked fine, however while trying to start the registry server getting the below error message ...

     

    2018-05-22 10:42:24,226Z (12:42) [main] ERROR com.itko.lisa.utils.JpaUtil - Exception raised checking table existence: 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 'HAVING TABLE_TYPE IN ('TABLE',null,null,null,null) ORDER BY TABLE_TYPE, TABLE_SC' at line 1
    java.sql.SQLSyntaxErrorException: 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 'HAVING TABLE_TYPE IN ('TABLE',null,null,null,null) ORDER BY TABLE_TYPE, TABLE_SC' at line 1
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1019)
    at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.executeMetadataQuery(DatabaseMetaDataUsingInfoSchema.java:62)
    at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.getTables(DatabaseMetaDataUsingInfoSchema.java:835)
    at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getTables(NewProxyDatabaseMetaData.java:2938)
    at com.itko.lisa.utils.JpaUtil.allTablesExist(JpaUtil.java:653)
    at com.itko.lisa.utils.JpaUtil.<init>(JpaUtil.java:490)
    at com.itko.lisa.utils.JpaUtil.getDradisUtil(JpaUtil.java:406)
    at com.itko.lisa.dradis.comm.JpaUtilWrapper.getAnnotations(JpaUtilWrapper.java:24)
    at com.itko.lisa.dradis.comm.DradisCommContext.doEnterpriseDashboardHandshake(DradisCommContext.java:133)
    at com.itko.lisa.coordinator.TestRegistryImpl.initialize(TestRegistryImpl.java:280)
    at com.itko.lisa.coordinator.TestRegistryImpl.<init>(TestRegistryImpl.java:239)
    at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2163)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
    at com.exe4j.runtime.WinLauncher.main(Unknown Source)
    at com.install4j.runtime.launcher.WinLauncher.main(Unknown Source) 

     

    1. Mysql version is 8.0.11

    2. mysql-connector-java-8.0.11.jar is placed in {{LISA_HOME}}/lib/shared folder

    3. site.properties file has been modified with proper DB details

     

    Kindly suggest a solution for this.



  • 2.  Re: DevTest Mysql 8.0.11 DB configuration issue
    Best Answer

    Posted 05-22-2018 09:24 AM

    We have not certified  Mysql version 8.0  for DevTest yet.  



  • 3.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 05-24-2018 06:00 AM

    Hi,

     

    I have now installed MySQL server 5.7, and both the Enterprise Dashboard and Registry is getting connected to it properly with any error message, however now I cannot able to login to Workstation or Portal with "admin" or any other default credentials.The error message is shared below...

     

    2018-05-24 08:35:33,859Z (10:35) [ServerRequestResponder 2] WARN com.itko.lisa.net.RemoteMethodExec - InvocationTargetException on invoke authenticate
    java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.itko.lisa.net.RemoteMethodExec.execute(RemoteMethodExec.java:57)
    at com.itko.lisa.net.ServerRequestHandler.processRMIMessage(ServerRequestHandler.java:533)
    at com.itko.lisa.net.ServerRequestHandler.access$600(ServerRequestHandler.java:70)
    at com.itko.lisa.net.ServerRequestHandler$5.run(ServerRequestHandler.java:451)
    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:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: org.springframework.security.authentication.BadCredentialsException: Authentication failed for user [username=admin]
    at com.ca.dts.security.authentication.internal.NamedDelegatingAuthenticationProvider.doAuthentication(NamedDelegatingAuthenticationProvider.java:75)
    at com.ca.dts.security.authentication.AbstractDevTestAuthenticationProvider.authenticate(AbstractDevTestAuthenticationProvider.java:195)
    at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:174)
    at com.itko.lisa.test.LisaSecurityManager.authenticate(LisaSecurityManager.java:821)
    at com.itko.lisa.test.LisaSecurityManager.authenticate(LisaSecurityManager.java:773)
    at com.itko.lisa.coordinator.TestRegistryImpl.authenticate(TestRegistryImpl.java:2279)
    ... 13 more
    Caused by: org.springframework.security.authentication.BadCredentialsException: Bad credentials
    at org.springframework.security.authentication.dao.DaoAuthenticationProvider.additionalAuthenticationChecks(DaoAuthenticationProvider.java:99)

     

    The issue is quite similar to this (Authentication failed for user [username=admin] ). I followed the resolution steps provided in the link, but no luck.

     

    Kindly suggest...



  • 4.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 05-24-2018 09:16 AM

    Looks like  the character set is not UTF-8 ,  as you are getting  " authentication.BadCredentialsException"  

    Please open a ticket with CA support. We can look at the issue in a Webex. 

     

    Thanks

     

    Shiney 



  • 5.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 05-24-2018 10:45 AM

    Hi Shiney,

     

    Thanks for your quick response.

    The character set is in utf8 only as shared below. 

     

     

    I will log a ticket, it will be better if we can have a WebEx session.



  • 6.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 05-24-2018 01:41 PM

    From the screenshot  ,  it looks like your mySQL instance is not UTF-8,  it should look like 

     

     

    Please go over  this link.  and follow the steps as suggested. 

    Tech Tips: MySQL Cookbook for DevTest 9.1.0 and Later 



  • 7.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 05-30-2018 10:40 AM

    Hello Saikat,

     

    Did Shiney's responses help you?

     

    Thank you,

    Heloisa



  • 8.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 05-31-2018 05:37 AM

    Hi Maria,

     

    Yes, it gave me the idea what is causing the issue. However the issue exactly didn't solved.

     

    Thanks & Regards,

    SAIKAT GHOSH



  • 9.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 06-01-2018 11:42 AM

    What further issue are you getting?



  • 10.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 06-04-2018 09:18 AM

    Saikat,  could you please elaborate what you are facing now? Or  you could open a support ticket and we can look at it in a webex. 

     

    Thanks

     

    Shiney. 



  • 11.  Re: DevTest Mysql 8.0.11 DB configuration issue

    Posted 06-06-2018 08:45 AM

    Hi Shiney,

     

    As per your shared screenshot I changed mySQL instance to UTF-8 for all the Variable_name reflecting in your screenshot, however once I restart the MySQL server, again the instances are going back to as reflecting below in the screenshot, not sure what causing it...

    Sorry for the delayed response !!! 

     

     

    Thanks & Regards,

    SAIKAT GHOSH