Pentaho Report Designer Database connection with variable on preview

Question

I set the db credentials in kettle.properties, i set the variables with credentials in data source successfully but when i click preview it gives me this error, it seems that it can't recognize the variable This is how I declared the variables in kettle.properties How can I solve?

Answer 1

1.I just use mysql instance, your kettle.properties is right. 2.Have you try to ping url of your db and login in your centos or ubuntu?

3.I think the most important problem is network and authority of db in whitelist.

4.My kettle