Thanks Tim,
Such feedback is valuable for us in order to tune and maintain our
documentation.
I completely agree, and most of us do, that having a plethoric documentation is
not a good thing.
I also see that's it's harder to maintain a well structured and up to date
documentation than to add bricks here and there.
We want to make an effort in this direction in 2018, I hope we will get
something better.
Help is appreciated, notably about installers, because active committers
already have a lot to do with the rest.
This said I totally agree and understand your point of view about installation. It could be indeed that we are missing attention because we neglect
this aspect. Actually it's not hard to imagine, just a bit of empathy is enough...
Jacques
Le 15/12/2017 à 14:22, Boyden, Timothy a écrit :
I have to agree, the documentation for setting up OFBiz with an external
database is about as clear as mud. For one there are multiple Wiki documents
that describe different methods to accomplish the task, rather than one
officially accepted method. For example, I tried to follow the Linux (CentOS)
version of this Wiki page
(https://cwiki.apache.org/confluence/display/OFBIZ/Setup+OFBiz+version+16.11.02+with+PostgreSQL+on+Windows)
and the compile command did not properly download and load the driver.
However, I had success following the older approach of manually adding the JDBC
driver jar file to ${ofbiz install dir}/framework/entity/lib/jdbc as described
in this Wiki page (
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup).
Of course, the jar file keeps getting wiped out if you run the cleanAll
command. That took a few install attempts to realize, as I fought with DB
permission issues.
I think more attention in the startup documentation needs to address this
issue, rather than a passing comment, that it can (and is even recommended)
that the software be setup with an external DBMS.
The worst thing you can have, when trying to appeal to ERP solution evaluators,
is a software solution that is frustrating to install. A Demo site that doesn't
work is the first red flag, but I give that a pass, as we really need to see
the software with our own data, in order to fully evaluate it.
That is why I am recommending that Yum, Apt, Windows, etc... installers be made
available with appropriate install options for clean install and demo install.
The software should be installable from software repositories, just like any
other modern Linux or Windows application. I have been implementing ERP systems
for over 10 years now, and if I didn't like a challenge, would have given up on
OFBiz after the first failed install attempt, following the published startup
instructions. The last thing an ERP system implementer needs on a go-live
weekend, is issues installing the software in the live environment. They
already have a huge task ahead of them, getting the business's data loaded in
the system.
Regards,
Tim Boyden
-----Original Message-----
From: Rishi Solanki [mailto:[email protected]]
Sent: Friday, December 15, 2017 7:05 AM
To: ofbizuser <[email protected]>
Subject: Re: Ofbiz to postgresSql connection problem
Bashir,
Are you able to connect postgres version mentioned with specific mentioned
driver in pure java class .... please note that here I'm asking to not use
OFBiz and connect.
If so then we can look into it further.
Also please share the OFBiz version and other driver version you are trying
with.
HTH!
Rishi Solanki
Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co
On Thu, Dec 14, 2017 at 5:42 AM, [email protected] <
[email protected]> wrote:
Hi Im new to ofbiz and i have some problem in connecting ofbiz to
postgresql version 10, i couldnt find the latest JDBC driver Version
42.1.4 in Jcenter, .
i tried other driver from the Jcenter the connection was failed and
couldn't connect to database.
waiting for your help.
