i am using the cloud version of the software; i am trying to access our mysql database in a different ip address; how to do this?

i am giving jdbc string as 

jdbc:mysql://xxx.com/saierp?characterEncoding=UTF8

getting the following error when i click OK "Fail to retreve column"

i would like to get  a detailed error message; i also want to know from which ip address this request is done so I can add to my mysql database

thanks

  • No labels

6 Comments

  1. Hugo

    Hi there,

    You will need to make sure that your database is accessible from outside (internet). If not, you will first need to get your server administrator to unblock a certain port, then configure your MySQL to listen to that port and/or outside traffic or specific IP (to prevent abuse/attack).

    Once you have done all of that, then, from your Joget cloud account, configure the jdbc connection path accordingly to connect to your database.

    Hope this helps.

    PS: Just a quick clarification, if you are trying to point to the database that is tied to your cloud account, simply choose "Default Datasource"

    Thanks.

    Hugo

    1. raj

      I am able to logon from another machine with the same credentials; looks like the jdbc is giving error but i dont know excatly what the error is; i can email to support the credentials and they can check

      thanks

      1. Hugo

        Hi Raj,

        Please try again and tell us the date/time so that we can try to check on the server log.

        Thanks.

        1. raj

          I tried at 11:26 AM PST on March 3, 2015

          1. Hugo

            Hi Raj,

            I can't find relevant log on that day but could find some errors way back on 21 March (when you first posted this topic) itself.

            JdbcDataListBinder  - org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'brahmins'@'localhost' (using password: YES))

            It seems that in your Datalist binder settings you are not specifying your DB server address correctly.

            If you want to, you can drop me an email of your screenshot of your configuration if the information is not suitable for public's eyes.

            Thanks.

            1. raj

              check your email thanks