Menu ▾ ▴

Failed (Connection error 'or' database not initialized)

Community Support
Jeff Hollman
2020-08-10
2020-08-14

  • Jeff Hollman

    Jeff Hollman - 2020-08-10

    I am installing on Ubuntu 20.04 server. I tunneled using MobaSSHTunnel to get the setup started but I cannot get it to connect to my database. I have tried localhost:3306 and the actual server address of my server and it will not connect.

    Do I need to create a separate tunnel to get to the database server? If so, can someone tell me how to configure it?

    Any help is much appreciated.

     
    Thumbnail
    estimate.PNG

    • Wanhive

      Wanhive - 2020-08-12

      Hello Jeff,

      During database initialization, the application attempts to create (if don't exist) the database and the tables. This step will fail if the given database user doesn't have sufficient permissions.

      Make sure that the user credentials you provided has full access to the database (estimate in your case) at the given address (localhost in your case) and then try to initialize the database.

       

  • Jeff Hollman

    Jeff Hollman - 2020-08-12

    Thanks for the input. I changed the username to root to make sure it had permissions and it gives me the same error.

    I think it may have something to do with the ssh tunneling. Just not sure what to change. I have tried the settings in the picture and I have tried the ip address of the actual server which is the same as my ssh server ip.

     
    Thumbnail
    tunnel.PNG

    • Wanhive

      Wanhive - 2020-08-13

      Hello Jeff,

      Just finished testing the application on Ubuntu 20.04 LTS.

      Looks like the old mysql driver shipped with the ESTIMATE (it is version 5.1.33) is not supported by the current version of MySQL server. Replacing the MySQL driver with the most recent release resolved the issue.

      Thanks for bringing this issue to our notice.

      UPDATE: We have released ESTIMATE version 2.1.1 to fix this issue. The newer version is shipped with MySQL java connector 8.0.21 and has been optimized for Apache Tomcat server 9.0.

       

      Last edit: Wanhive 2020-08-13

  • Jeff Hollman

    Jeff Hollman - 2020-08-14

    First of all, I would like to thank you for helping me try to get this going. But it is still not working. I have attached my catalina log files to see if you can figure it out. I did get an error that it couldn't create the database, so I created it manually.

     
    Thumbnail
    catalina.log.png
    Thumbnail
    catalina.out.png

    • Wanhive

      Wanhive - 2020-08-14

      Hello Jeff,

      The error is being caused by the InvalidConnectionAttributeException due to some sort of Time Zone issue (EDT). This is a known bug in several MySQL drivers and JDBC.

      https://bugs.mysql.com/bug.php?id=85816

      Setting the MySQL server time zone to UTC or something which Java 8 recognizes resolves the issue.

      NOTE: Kindly use the newly released WAR (version 2.1.1).

       

      Last edit: Wanhive 2020-08-14

  • asjai fdfsgvf

    asjai fdfsgvf - 2021-12-24
    Post awaiting moderation.

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB