From user-return-55916-archive-asf-public=cust-asf.ponee.io@ofbiz.apache.org Thu Dec 12 13:31:16 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 077B818061A for ; Thu, 12 Dec 2019 14:31:15 +0100 (CET) Received: (qmail 69331 invoked by uid 500); 12 Dec 2019 13:31:15 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 69314 invoked by uid 99); 12 Dec 2019 13:31:14 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Dec 2019 13:31:14 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id F404D180F8C for ; Thu, 12 Dec 2019 13:31:13 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.301 X-Spam-Level: * X-Spam-Status: No, score=1.301 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_SORBS_WEB=1.5, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id qWXEBSL0lZKn for ; Thu, 12 Dec 2019 13:31:12 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=2607:f8b0:4864:20::535; helo=mail-pg1-x535.google.com; envelope-from=bagasdotme@gmail.com; receiver= Received: from mail-pg1-x535.google.com (mail-pg1-x535.google.com [IPv6:2607:f8b0:4864:20::535]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id 9A8047DDAC for ; Thu, 12 Dec 2019 13:31:11 +0000 (UTC) Received: by mail-pg1-x535.google.com with SMTP id b137so1160691pga.6 for ; Thu, 12 Dec 2019 05:31:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:references:to:from:message-id:date:user-agent:mime-version :in-reply-to:content-language:content-transfer-encoding; bh=W84vHxBfPxWVOAf7RZl5Ni3Uk8FihBBjGGat6wFYp0Q=; b=rrk04y5pfQS/FNXRY+Rywsx+nuYejZ6oWj+bJ0XAWrc7DScZJtWHrL6fqWGQoL2ZKR gjTjreYvozN0CHD5V5E2W9qF7oRxmUZxOw7nkaRvm3rS1hmTqbFvyUeFCtDhfGnn87ex 0daIhzlqJcKTm9b69h8w8AX+CKN1E4sM52XZ2/DzwWuPXi/HZ5CViMB/v74v7qHXA4d3 H2tNlcii1aqML34yLS0llbtQoq+jJi+RhWcO+fXyL1PKPmyrDh7h0EmQzY7pJnbvgraN kbK0fDwzczmr4TPOWFT3KoGLIeqwTIACgeXVxSHnNbO4vzXZTdtXO/cJB/8cmXr9q3vU 2lMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:references:to:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=W84vHxBfPxWVOAf7RZl5Ni3Uk8FihBBjGGat6wFYp0Q=; b=qgwG83KiUaAK9T2YvMdKyHb8yrBXa2dvCTwvAgdhochHb8TW0WNVPqK+1x+qIBumlZ ep7dlemrRiu0W73qUo7IU6+HPLKap529Lw0T9uG4uJtmLN0DVBzFCG6DEa3BS7DWclXF X/punoWjoL2pSj4jk8q0Y2zXkY8uFDRr5423yDoftqz72GQLmBkXj+gdAzzJQ6jF7GhE QFok7axrShl2lUBXYdXlaHX3GObLPHVzK1E0m0u/RNHi5VUOYtb73FFZuk2zDw1IthCC i7InKm287g8+v9MOJAIVQYiP0NvC5TsilCy7K9R8t/kt8pqi7QUbpFkz1B8yT75Y5Dhi AgUA== X-Gm-Message-State: APjAAAXFYYA8+rKXkhLDrU99FW+4tDBwEE89KhOhJJ+Eeii27J7QdQx6 f+jCXLC7J3OT5hArCR7BscpOR5Qy X-Google-Smtp-Source: APXvYqwwP160pU+YcbGpo+ZSx+3bwd//yPWrSGHfMqdEA1XpFrHcPUMxdfWUtj9C7VNyvLlxBpSUDQ== X-Received: by 2002:a63:7b44:: with SMTP id k4mr10426863pgn.140.1576157463899; Thu, 12 Dec 2019 05:31:03 -0800 (PST) Received: from [192.168.43.80] (subs32-116-206-28-15.three.co.id. [116.206.28.15]) by smtp.gmail.com with ESMTPSA id e20sm7169000pff.96.2019.12.12.05.31.02 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 12 Dec 2019 05:31:03 -0800 (PST) Subject: Re: Connecting to Remote Database Question References: <6f770165-4d46-a4e0-6f73-61a8a3827a53@gmail.com> To: user@ofbiz.apache.org From: Bagas Sanjaya X-Forwarded-Message-Id: <6f770165-4d46-a4e0-6f73-61a8a3827a53@gmail.com> Message-ID: <1be642d7-24ee-34d5-b46a-cd1098cb1169@gmail.com> Date: Thu, 12 Dec 2019 20:31:01 +0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:72.0) Gecko/20100101 Thunderbird/72.0 MIME-Version: 1.0 In-Reply-To: <6f770165-4d46-a4e0-6f73-61a8a3827a53@gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit 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 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 > > > or > > https://vladmihalcea.com/jdbc-driver-connection-url-strings/ > > HTH > > Jacques > > Le 12/12/2019 à 12:48, Bagas Sanjaya a écrit : >> Hello all, >> >> How can I connect my OFBiz instance to remote database instance? >> >> Bagas >> -- An old man doll... just what I always wanted! - Clara -- An old man doll... just what I always wanted! - Clara