Problems with Joget V6 Database Connectivity external MySQL database

 
1
0
-1

I want to use a different external database for a project but I always get the same message, see image. How can I solve this?

    CommentAdd your comment...

    4 answers

    1.  
      2
      1
      0

      Hi - MySql is most likely listening on port 3306 - trying changing the port from 3307 to 3306 on the URL string.

      Cheers - Tony

      1. Cor

        Hoi Anthony, I have also tried that but unfortunately it did not work.

      CommentAdd your comment...
    2.  
      2
      1
      0

      Hi, can you check the catalina or tomcat LOG to see what the error is? I'm not sure in mysql but at least in postgres you have to make two adjustments: make the server "listen" to all ports and allow connections from the IP where Joget was installed. On the other hand, it is highly recommended that you generate a specific user (other than root) 

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Maybe you can use MySQL client like HeidiSQL to test a connection from Joget server to the external database first. Check if any firewall running on the external db server.

        And the URL should be in this format:

        jdbc:mysql://{external_db_ip_address}:{mysql_port}/{database_name}?characterEncoding=UTF-8

        1. Cor

          Hi Lee, I use this url: jdbc:mysql://127.0.0.1:3306/ivedis?characterEncoding=UTF-8, because Joget WorkFlow Professional and MySQL Workbench are running on the same local PC.

        2. Cor

          I have also used HeidiSQL to test my connection without any problems. Networktype : MySQL (TCP/IP) Hostnaam/IP: 127.0.0.1 Port: 3306 Database: Ivedis

        3. panda

          I think we need log file to see the error.

        CommentAdd your comment...
      2.  
        1
        0
        -1

        Hi Camilo,

        Thanks for your comment, I created multiple users in mysql and I used the image root to indicate that even the root account did not work.

        Both Joget and MySQL are installed locally and I have checked that MySQL server is listening to port 3306.

        But unfortunately I can not connect to the external database yet.

        1. Anders

          As Camilo suggested, try checking the tomcat logs first. There should be details on the exception that might identify the actual error.

        2. Anthony Sica

          Cor- just pointing out that you are trying to connect on port 3307 from joget and server is listening on port 3306. be sure to change your url accordingly.... Cheers - Tony

        CommentAdd your comment...