• Categories
  • Recent
  • Tags
  • Popular
  • Register
  • Login
  • Categories
  • Recent
  • Tags
  • Popular
  • Register
  • Login

Mysql connection not working for me

Scheduled Pinned Locked Moved Troubleshooting
10 Posts 3 Posters 4.6k Views 1 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    njbuch
    last edited by njbuch 17 Apr 2017, 08:42

    I have tried to change my setup to use mysql for storage instead of the embedded one.

    Changed the lines in configuration file to:

    # MySQL settings
    mcc.db.type=MYSQL
    mcc.db.url=jdbc:mysql://localhost:3306/hcdb
    mcc.db.username=my_user
    mcc.db.password=my_password
    

    I have created the database already which is called 'hcdb' and the user is having ultimate DBA elevated permissions.

    But the jdbc connection seems to mess up the database name....here is from the log-file:

    2017-04-17 10:31:24,611 ERROR [main] [org.mycontroller.standalone.db.DataBaseUtils:118] Migration exception,
    org.flywaydb.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource (jdbc:mysql://localhost:3306/hcdb&logger=org.mycontroller.standalone.loggers.LoggerMySql)
     for user 'njb': Unknown database 'hcdb&logger=org.mycontroller.standalone.loggers.LoggerMySql'
            at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:412)
            at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:370)
            at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:50)
            at org.flywaydb.core.Flyway.execute(Flyway.java:1326)
            at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
            at org.mycontroller.standalone.db.DataBaseUtils.runDatabaseMigration(DataBaseUtils.java:116)
            at org.mycontroller.standalone.StartApp.startServices(StartApp.java:251)
            at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:108)
            at org.mycontroller.standalone.StartApp.main(StartApp.java:95)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'hcdb&logger=org.mycontroller.standalone.loggers.LoggerMySql'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
            at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
            at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)
            at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
            at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
            at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:409)
            ... 8 common frames omitted
    
    
    J 1 Reply Last reply 17 Apr 2017, 13:02 Reply Quote 0
    • J Offline
      jkandasa @njbuch
      last edited by 17 Apr 2017, 13:02

      @njbuch Could you please post MyController version? Status >> About on GUI

      1 Reply Last reply Reply Quote 0
      • N Offline
        njbuch
        last edited by 17 Apr 2017, 16:02

        As its not starting, it is kind of difficult, but it is a snapshot built by me around 3.feb 2017....

        Other info you might want?

        1 Reply Last reply Reply Quote 0
        • N Offline
          njbuch
          last edited by njbuch 17 Apr 2017, 20:18

          Ok, I took the latest snapshot from your Gdrive unpacked, and only modified the MYSQL section, and then tried starting it. Working fine 👍

          But restoring from a backup into the mysql deletes the configuration changes, and restores into the default database.

          How to move old data into the new database?

          BTW version is now:
          MyController Version 0.0.3.Final-SNAPSHOT
          Database schema revision 1.03.06 - 2017 Mar 03
          Database type MySQL
          Database version 5.7.18
          Git commit:branch a4f4e01b94a3a63566b37db97f08de957e6df2f7:development
          Built on 2017-04-05T12:15:52+0530
          Build JDK 1.8.0_121
          Build tool Apache Maven 3.3.9

          J 1 Reply Last reply 18 Apr 2017, 01:36 Reply Quote 0
          • J Offline
            jkandasa @njbuch
            last edited by 18 Apr 2017, 01:36

            @njbuch Backup/restore of database backup(expect H2DB) not supported by MyController. You have to manage backup/restore of your backup manually.

            If the database is other than H2DB backup/restore only configurations and scripts.

            But restoring from a backup into the mysql deletes the configuration changes, and restores into the default database.

            Yes, it will do. As your previous backup contains old configuration different. I request you do one backup after you do change on configuration. And use that backup from that point.

            1 Reply Last reply Reply Quote 0
            • N Offline
              njbuch
              last edited by 19 Apr 2017, 11:44

              Ok, so what you are saying is that I can

              • take a backup of a system running h2db.
              • install a new SNAPSHOT version
              • then I can unzip the backup file, and
              • copy the mycontroller.properties file AND the resources folder to a new install in the conf folder.
              • Modify the properties to point to a mysql database
              • run the script.sql file inside the zipped database file on the mysql
              • run the new server
              J 1 Reply Last reply 20 Apr 2017, 03:08 Reply Quote 0
              • J Offline
                jkandasa @njbuch
                last edited by 20 Apr 2017, 03:08

                @njbuch

                • take a backup of a system running h2db.
                • install a new SNAPSHOT version
                • then I can unzip the backup file, and
                • copy the mycontroller.properties file AND the resources folder to a new install in the conf folder.
                • Modify the properties to point to a mysql database

                Till this level looks good.

                • run the script.sql file inside the zipped database file on the MySQL

                You cannot run script.sql(h2 db) backup on MySql. it will return an exception. For now, there is no solution to copy data when we switch database.

                • run the new server
                1 Reply Last reply Reply Quote 0
                • N Offline
                  njbuch
                  last edited by 21 Apr 2017, 10:15

                  Ok, would the approach mentioned here http://stackoverflow.com/questions/11359813/how-to-convert-h2database-database-file-to-mysql-database-sql-file using SquirrelSQL maybe work?

                  J R 2 Replies Last reply 21 Apr 2017, 10:25 Reply Quote 0
                  • J Offline
                    jkandasa @njbuch
                    last edited by 21 Apr 2017, 10:25

                    @njbuch might work. I never tried. Kindly report your experience 🙂

                    1 Reply Last reply Reply Quote 0
                    • R Offline
                      ragflyer @njbuch
                      last edited by 20 Jan 2018, 17:42

                      @njbuch Have you had any success?

                      1 Reply Last reply Reply Quote 0
                      • First post
                        Last post

                      0

                      Online

                      631

                      Users

                      532

                      Topics

                      3.4k

                      Posts
                      Copyright © 2015-2025 MyController.org | Contributors | Localization