Re: Connecting to Remote Database Question

2019-12-13 Thread Jacques Le Roux
Why would you want to do that? I don't know if it's possible. In general, passing parameters in URL is not recommended for security reason Jacques Le 13/12/2019 à 09:49, Bagas Sanjaya a écrit : But can DB username and password be specified also on connection URL? On 13/12/19 14.48, Pawan

Re: Connecting to Remote Database Question

2019-12-13 Thread Bagas Sanjaya
But can DB username and password be specified also on connection URL? On 13/12/19 14.48, Pawan Verma wrote: Hello Bagas, In entityengine.xml file, select data source as per your desired database, in your case it is postgres. You have to mention JDBC URI/URL, database name, user name and

Re: Connecting to Remote Database Question

2019-12-12 Thread Pawan Verma
Hello Bagas, In entityengine.xml file, select data source as per your desired database, in your case it is postgres. You have to mention JDBC URI/URL, database name, user name and password to connect to the database. Example: jdbc-uri="jdbc:postgresql:///" jdbc-username="" jdbc-password="" HTH!

Re: Connecting to Remote Database Question

2019-12-12 Thread Bagas Sanjaya
So should I also specify DB user name and password in JDBC URI/URL? On 12/12/19 22.40, Rishi Solanki wrote: Postgres do have example in entityengine.xml. Need to change localhost from IP address with user name and password. Best Regards, -- Rishi Solanki *CTO, Mindpath Technology* Intelligent

Re: Connecting to Remote Database Question

2019-12-12 Thread Rishi Solanki
Postgres do have example in entityengine.xml. Need to change localhost from IP address with user name and password. Best Regards, -- Rishi Solanki *CTO, Mindpath Technology* Intelligent Solutions cell: +91-98932-87847 http://www.mindpathtech.com On Thu, Dec 12, 2019 at 7:01 PM Bagas Sanjaya

Re: Connecting to Remote Database Question

2019-12-12 Thread Bagas Sanjaya
OK, but I use Postgres instead. So should I specify DB user name and password in connection URL, or should they be skipped? On 12/12/19 19.31, Jacques Le Roux wrote: You have examples in entityengine.xml, just use the DNS or IP address.Look for jdbc-uri= in entityengine.xml. You might also

Re: Connecting to Remote Database Question

2019-12-12 Thread Jacques Le Roux
You have examples in entityengine.xml, just use the DNS or IP address.Look for jdbc-uri= in entityengine.xml. You might also change the port... Since OFBiz simply covers the JDBC driver you may refer to https://stackoverflow.com/questions/14657036/how-to-connect-to-a-remote-database-with-jdbc

Connecting to Remote Database Question

2019-12-12 Thread Bagas Sanjaya
Hello all, How can I connect my OFBiz instance to remote database instance? Bagas -- An old man doll... just what I always wanted! - Clara