Streama fails to use MySQL Database

[airsay]

Issue description I am trying to test run Streama using MySQL Database as back end. I have correctly (I believe) setup application.yml to use a different port and MySQL as data source. While the port change takes effect, Streama however still uses the the inbuil H2 database instead of MySQL

Steps to Reproduce Create Streama database on MySQL Server backend Configure application.yml (actual content included in ENVIRONMENT INFORMATION below) Run Streama (java -jar streama-1.6.0-FINAL.war)

Expected Behaviour

Streama is expected to connect to MySQL , create requisite tables and use Database specified in application.yml

Actual Behaviour Streama uses in built H2 Database (evidenced by creation of streama.mv.db & streama.trace.db). No tables are created in the MySQL Database specified in application.yml

Environment Information Operating System: Ubuntu Server 18.10 x64 Server running MySQL Server 5.7.24 Streama version: v1.6.0 FINAL Custom streama build, describe customizations or provide link to fork (If Applicable):

application.yml Content environments: production: dataSource:

        #driverClassName: 'com.mysql.jdbc.Driver'
        driverClassName: 'com.mysql.cj.jdbc.Driver'

        #url: jdbc:mysql://localhost/streama
        url: jdbc:mysql://localhost/streama?useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false

        username: admin
        password: admin

server: port: 6789

Container Version (If Applicable): /

[EchoDev]

Try to use this

environments:
     production:
        dataSource:
            dbCreate: update
            driverClassName:  'com.mysql.cj.jdbc.Driver'
            url: jdbc:mysql://localhost:----insert-port---/streamadb?useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false
            username: streamausername
            password: streampass 

[airsay]

Hi @EchoDev thanks for your response. Got around to trying this both on the 1.6.0 and 1.6.1. Doesn't work. Streama still doesn't use MySQL even though it runs on the port specified in application.yml. I tried both http://localhost:mysqlPort and http://server-ip:mysqlPort.

[EchoDev]

Can you tell us how your set up looks like? In what folder do you have the application.yml, what commands are you using, what is the console output etc. I can compare to what it looks like on my end.

[airsay]

Streama 1.6.1.war and application.yml are both in /root/streama

I'm running streama by issuing the following command

cd /root/streama java -jar streama-1.6.1.war

Or

cd /root/streama . /streama-1.6.1.war

[dularion]

can you paste the contents of your entire application.yml pls?

[airsay]

application.yml Content

       environments:
             production:
                   dataSource:
                          dbCreate
                          driverClassName: 'com.mysql.cj.jdbc.Driver'
                          url: jdbc:mysql://localhost:3306/streama?useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false 
                          username: mysqlusername
                          password: *******
       server:
              port: xxxx

[airsay]

Bump