I am trying to configure the DB connection which can be used from the ETL server. The help file shows that the encrypted credentials can be stored in the clover.properties file and parameter can be used in the connection. It doesnt work :( Do I need to enclose the parameter in quotes ?
-
Hi Sameerj365,
from your post, I am not sure what does not work. Could you please describe the issue more closely? It would also be very helpful to know what you have done. In order to set secure parameters, you need to work with Server sandbox (since secure parameters are designed for Server projects only) and have master password set. The master password can be set in Server GUI under Configuration / Secure Parameters. When the master password is set, you should be able to set the secure parameter (see the encrypted password).
SecureParameters.png
Now when we have configured the secure parameter we can select it in DB Connection dialog in Password attribute's drop-down menu:
DBConenctionDialog.png -
Thnk You.. I generated the encrypted password using secure cfg jar and defined it in clover.properties.
I have few questions:
(a) instead of defining at graph level if i keep it in config file then why the parameter substitution doesnt work while defining the new db connection?
(b) is there a way to hide it so that it is not even visible in the server console.
Regards -
Hi,
now I think I understand the question. The password created this way cannot be used for this purpose (please refer to our documentation - it is only used to "encrypt values persisted in the database table secure_param_passwd"). However, I have created a new ticket for this improvement: https://bug.javlin.eu/browse/CLO-4067
What you might take into consideration is using appropriate user/group settings. You can disable Secure params admin permission for a group. This way you can expose the master password to authorized users only.
For more information about user/group settings, please see our documentation.
For user settings: http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.server.docs/docs/users.html
For group settings: http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.server.docs/docs/groups.html
Hope this helps. -
Hi,
I have created a new ticket for this improvement: https://bug.javlin.eu/browse/CLO-4067
Please let me know if there is any update on the ticket which you have raised. -
Hi,
We are very sorry but we unfortunately do not have capacity for such notification of individual users. Our bug tracker does not support change notifications for unregistered users.
However, you can very easily use an external service like https://www.changedetection.com/ for watching this URL: https://bug.javlin.eu/browse/CLO-4067
Thank you for your understanding.
Regards, -
I am now trying to create a connection to my Local DB from the Clover Server. However, I always received this message: "Can't connect to DB: Network error IOException: Connection refused: connect"
Please help -
Hi Danny
I would like to know if the Database server is on the same machine as the Clover Server or if it's on the same machine as the Designer. I assume you want set up a connection which can be used in graphs for data output. In case you want to set up an external system DB for your Clover Server, please let me know.
Thank you.
Best regards
Please sign in to leave a comment.
Comments 8