Custom database connection

Confluence User - 05 Apr, 2020

Hi guys,

 I am trying to connect joget to my custom database from mysql. I did according to this documentation Custom Database Configuration , but when i hit the localhost it gives error as

Sorry, access is forbidden for security reasons.

Please refresh the previous form before submitting it.


I have tried to change default properties file also created new property file. But not working for both

This is a content of my default property file:

workflowDriver=com.mysql.jdbc.Driver

workflowUrl=jdbc\:mysql\://127.0.0.2\:3306\jwdb?characterEncoding\=UTF-8&useSSL\=false&allowPublicKeyRetrieval\=true

workflowUser=root

profileName=

workflowPassword=


Am I doing something wrong in URL part? Password and user is appropriate.

I hv created connection in mysql with that host and port. Can you help me please?

server

12


06 Apr, 2020
confluenceUser
confluenceUser

Hi, based on the error message u provide i think it could be a security issue. Can you confirm that the db host, user and password? Or have u try to access the database with the user and password?

06 Apr, 2020
confluenceUser
confluenceUser

Yes DB host , user and password is correct .

06 Apr, 2020
confluenceUser
confluenceUser

Try fill in the correct password in the workflowPassword i.e (workflowPassword= password)

06 Apr, 2020
confluenceUser
confluenceUser

Yes I am putting password ..

06 Apr, 2020
confluenceUser
confluenceUser

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

06 Apr, 2020
confluenceUser
confluenceUser

Ok i try that..but can u tell me , my connection URL is right or not? means format of URL

06 Apr, 2020
confluenceUser
confluenceUser

Just now i used HeidiSQL and try to open same connection : 127.0.0.2 with user and password. It opened. Now what is the issue?

06 Apr, 2020
confluenceUser
confluenceUser

Custom JDBC URL.

Example: 

jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF8&useSSL=false
06 Apr, 2020
confluenceUser
confluenceUser

Still same issue.

07 Apr, 2020
confluenceUser
confluenceUser

Can anyone else will look into this. I need solution on this ASAP. PLS

07 Apr, 2020
confluenceUser
confluenceUser

There seems to be a missing forward slash after the port in your connection URL? It should be 3306/jwdb and not 3306\jwdb

07 Apr, 2020
confluenceUser
confluenceUser

Yes I used forward slash also ... Still same problem. Can you pls upload video tutorial for this or something useful for me which helps me to solve this problem....

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print