ANT vs Gradle (confused) Database setup and other configurations

[Clifford Williams]

First let me say I have not been in this list for a while. My interest in OFBiz has been renewed.

1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB) successfully following the documentation. Now that I would like to work with the latest code 16.11 I followed the Gradle docs which state the same process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc directory. The system works perfectly fine with the derby database but I cannot find any way to use an alternate database? (Like I said, confused)

2. IP configurations: I was able to get OFBiz (ant and gradle) to respond to my hostname properly by modifying ${ofbiz install dir}/framework/webapp/config/url.properties and set the host name for 8443 and 8080. I see many posts and web articles referencing ${ofbiz install dir}/framework/base/config/ofbiz-containers.xml to set the IP address of the system. i.e. to configure OFBiz with NGINX. Editing this file I see no reference to <property name=“address” value=“0.0.0.0”/> in this file.

#1 is probably the most pressing for us. As we see this a required for a production system.

[taher]

Hi Clifford,

For the database part, the only thing you need to do is add a dependency to
the mysql/postgres/whatever database driver in build.gradle and off you go.
Search in Jcenter for the database driver suitable for the database
installed on your production system.

For example, under the dependencies section you can add something like this
for mysql:

runtime 'mysql:mysql-connector-java:5.1.36'

Of course you need to make sure the connector is compatible with _your_
version of the database installed

Cheers,

Taher Alkhateeb

On Nov 22, 2016 7:27 PM, "Clifford Williams" <[hidden email]>
wrote:

> First let me say I have not been in this list for a while. My interest in
> OFBiz has been renewed.
>
> 1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB)
> successfully following the documentation. Now that I would like to work
> with the latest code 16.11 I followed the Gradle docs which state the same
> process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc
> directory. The system works perfectly fine with the derby database but I
> cannot find any way to use an alternate database? (Like I said, confused)
>
> 2. IP configurations: I was able to get OFBiz (ant and gradle) to respond
> to my hostname properly by modifying ${ofbiz install
> dir}/framework/webapp/config/url.properties and set the host name for
> 8443 and 8080. I see many posts and web articles referencing ${ofbiz
> install dir}/framework/base/config/ofbiz-containers.xml to set the IP
> address of the system. i.e. to configure OFBiz with NGINX. Editing this
> file I see no reference to <property name=“address” value=“0.0.0.0”/> in
> this file.
>
> #1 is probably the most pressing for us. As we see this a required for a
> production system.
>
>
>

[valery chenzo]

Hi Clifford,

 

>1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB) successfully following the documentation. Now that I would like to work with the latest code 16.11 I followed the Gradle docs which state >the same process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc directory. The system works perfectly fine with the derby database but I cannot find any way to use an alternate database? (Like I said, >confused)

 

simple add a mysql connector dependency to your build.gradle file and you are good to go. If you have a custom module add the following to the build.gradle file

 

pluginLibsRuntime "mysql:mysql-connector-java:5.1.36"

 

else just add

 

runtime "mysql:mysql-connector-java:5.1.36"

 

to the main build.gradle file.

 

 

From: Clifford Williams <[hidden email]>
Reply-To: <[hidden email]>
Date: Tuesday, November 22, 2016 at 08:27
To: <[hidden email]>
Subject: ANT vs Gradle (confused) Database setup and other configurations

 

First let me say I have not been in this list for a while. My interest in OFBiz has been renewed.

 

1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB) successfully following the documentation. Now that I would like to work with the latest code 16.11 I followed the Gradle docs which state the same process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc directory. The system works perfectly fine with the derby database but I cannot find any way to use an alternate database? (Like I said, confused)



2. IP configurations: I was able to get OFBiz (ant and gradle) to respond to my hostname properly by modifying ${ofbiz install dir}/framework/webapp/config/url.properties and set the host name for 8443 and 8080. I see many posts and web articles referencing ${ofbiz install dir}/framework/base/config/ofbiz-containers.xml to set the IP address of the system. i.e. to configure OFBiz with NGINX. Editing this file I see no reference to <property name=“address” value=“0.0.0.0”/> in this file.



#1 is probably the most pressing for us. As we see this a required for a production system.

 

 

[Paul Piper]

Perhaps it is also worth to checkout www.scipioerp.com - we have not migrated to gradle and it is meant for production run :)

[taher]

We crossed on wire Valery, thank you for helping out :)

On Nov 22, 2016 8:04 PM, "Valery Ngah" <[hidden email]> wrote:

> Hi Clifford,
>
>
>
> >1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB)
> successfully following the documentation. Now that I would like to work
> with the latest code 16.11 I followed the Gradle docs which state >the same
> process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc
> directory. The system works perfectly fine with the derby database but I
> cannot find any way to use an alternate database? (Like I said, >confused)
>
>
>
> simple add a mysql connector dependency to your build.gradle file and you
> are good to go. If you have a custom module add the following to the
> build.gradle file
>
>
>
> pluginLibsRuntime "mysql:mysql-connector-java:5.1.36"
>
>
>
> else just add
>
>
>
> runtime "mysql:mysql-connector-java:5.1.36"
>
>
>
> to the main build.gradle file.
>
>
>
>
>
> From: Clifford Williams <[hidden email]>
> Reply-To: <[hidden email]>
> Date: Tuesday, November 22, 2016 at 08:27
> To: <[hidden email]>
> Subject: ANT vs Gradle (confused) Database setup and other configurations
>
>
>
> First let me say I have not been in this list for a while. My interest in
> OFBiz has been renewed.
>
>
>
> 1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB)
> successfully following the documentation. Now that I would like to work
> with the latest code 16.11 I followed the Gradle docs which state the same
> process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc
> directory. The system works perfectly fine with the derby database but I
> cannot find any way to use an alternate database? (Like I said, confused)
>
>
>
> 2. IP configurations: I was able to get OFBiz (ant and gradle) to respond
> to my hostname properly by modifying ${ofbiz install
> dir}/framework/webapp/config/url.properties and set the host name for
> 8443 and 8080. I see many posts and web articles referencing ${ofbiz
> install dir}/framework/base/config/ofbiz-containers.xml to set the IP
> address of the system. i.e. to configure OFBiz with NGINX. Editing this
> file I see no reference to <property name=“address” value=“0.0.0.0”/> in
> this file.
>
>
>
> #1 is probably the most pressing for us. As we see this a required for a
> production system.
>
>
>
>
>
>

[Clifford Williams]

Wow, I had not expedited a response so quickly form so many. Truly impressed.

Will follow these instructions and report back my progress.

Thank you all.

On Nov 22, 2016, at 09:08 AM, Taher Alkhateeb <[hidden email]> wrote:

We crossed on wire Valery, thank you for helping out :)

On Nov 22, 2016 8:04 PM, "Valery Ngah" <[hidden email]> wrote:

Hi Clifford,

>1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB)

successfully following the documentation. Now that I would like to work

with the latest code 16.11 I followed the Gradle docs which state >the same

process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc

directory. The system works perfectly fine with the derby database but I

cannot find any way to use an alternate database? (Like I said, >confused)

simple add a mysql connector dependency to your build.gradle file and you

are good to go. If you have a custom module add the following to the

build.gradle file

pluginLibsRuntime "mysql:mysql-connector-java:5.1.36"

else just add

runtime "mysql:mysql-connector-java:5.1.36"

to the main build.gradle file.

From: Clifford Williams <[hidden email]>

Reply-To: <[hidden email]>

Date: Tuesday, November 22, 2016 at 08:27

To: <[hidden email]>

Subject: ANT vs Gradle (confused) Database setup and other configurations

First let me say I have not been in this list for a while. My interest in

OFBiz has been renewed.

1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB)

successfully following the documentation. Now that I would like to work

with the latest code 16.11 I followed the Gradle docs which state the same

process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc

directory. The system works perfectly fine with the derby database but I

cannot find any way to use an alternate database? (Like I said, confused)

2. IP configurations: I was able to get OFBiz (ant and gradle) to respond

to my hostname properly by modifying ${ofbiz install

dir}/framework/webapp/config/url.properties and set the host name for

8443 and 8080. I see many posts and web articles referencing ${ofbiz

install dir}/framework/base/config/ofbiz-containers.xml to set the IP

address of the system. i.e. to configure OFBiz with NGINX. Editing this

file I see no reference to <property name=“address” value=“0.0.0.0”/> in

this file.

#1 is probably the most pressing for us. As we see this a required for a

production system.

[Clifford Williams]

I did just that today. Impressive interface.

This is a side project by a few folks currently in the construction industry. Our goal is to create a Job Cost system and use OFBiz so as not to have to re-invent the wheel for all the other accounting functions.

On Nov 22, 2016, at 09:07 AM, Paul Piper <[hidden email]> wrote:

Perhaps it is also worth to checkout http://www.scipioerp.com - we have not migrated
to gradle and it is meant for production run :)



--
View this message in context: http://ofbiz.135035.n4.nabble.com/ANT-vs-Gradle-confused-Database-setup-and-other-configurations-tp4699508p4699514.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

[valery chenzo]

Missed that ☺

On 11/22/16, 09:07, "Taher Alkhateeb" <[hidden email]> wrote:

    We crossed on wire Valery, thank you for helping out :)
   
    On Nov 22, 2016 8:04 PM, "Valery Ngah" <[hidden email]> wrote:
   
    > Hi Clifford,
    >
    >
    >
    > >1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB)
    > successfully following the documentation. Now that I would like to work
    > with the latest code 16.11 I followed the Gradle docs which state >the same
    > process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc
    > directory. The system works perfectly fine with the derby database but I
    > cannot find any way to use an alternate database? (Like I said, >confused)
    >
    >
    >
    > simple add a mysql connector dependency to your build.gradle file and you
    > are good to go. If you have a custom module add the following to the
    > build.gradle file
    >
    >
    >
    > pluginLibsRuntime "mysql:mysql-connector-java:5.1.36"
    >
    >
    >
    > else just add
    >
    >
    >
    > runtime "mysql:mysql-connector-java:5.1.36"
    >
    >
    >
    > to the main build.gradle file.
    >
    >
    >
    >
    >
    > From: Clifford Williams <[hidden email]>
    > Reply-To: <[hidden email]>
    > Date: Tuesday, November 22, 2016 at 08:27
    > To: <[hidden email]>
    > Subject: ANT vs Gradle (confused) Database setup and other configurations
    >
    >
    >
    > First let me say I have not been in this list for a while. My interest in
    > OFBiz has been renewed.
    >
    >
    >
    > 1. Database Setup: I was able to setup OFBiz 13.07 to use MySql (MariaDB)
    > successfully following the documentation. Now that I would like to work
    > with the latest code 16.11 I followed the Gradle docs which state the same
    > process but there is no ${ofbiz install dir}/framework/entity/lib/jdbc
    > directory. The system works perfectly fine with the derby database but I
    > cannot find any way to use an alternate database? (Like I said, confused)
    >
    >
    >
    > 2. IP configurations: I was able to get OFBiz (ant and gradle) to respond
    > to my hostname properly by modifying ${ofbiz install
    > dir}/framework/webapp/config/url.properties and set the host name for
    > 8443 and 8080. I see many posts and web articles referencing ${ofbiz
    > install dir}/framework/base/config/ofbiz-containers.xml to set the IP
    > address of the system. i.e. to configure OFBiz with NGINX. Editing this
    > file I see no reference to <property name=“address” value=“0.0.0.0”/> in
    > this file.
    >
    >
    >
    > #1 is probably the most pressing for us. As we see this a required for a
    > production system.
    >
    >
    >
    >
    >
    >
   

[Paul Piper]

Then you are in luck - in terms of functionality we have not removed anything. We cleaned-up and added new features, fixed bugs and updated some core mechanics (the renderer is just one of the examples). Besides new functionalities, we put alot of effort into our releases. So give it a try and work with it as a developer - I am sure you will not be missing much.

Here's a link to the feature list, also outlining what is planned for future releases: http://www.scipioerp.com/community/download/release-notes/

Feedback is always appreciated and best regards,
Paul

[Clifford Williams]

Will do. One of the parts of 16 that I found interesting was there was a Project module. Although not really targeted towards construction does have basic project management. I know it looks more targeted towards Agile development projects but Agile can work for a construction project in some ways. We would need to add Cost Codes, Cost allocation models and Revenue recognition, etc. Having both project management and job cost within the ERP would be very strong for construction companies. 

On Nov 22, 2016, at 10:41 AM, Paul Piper <[hidden email]> wrote:

Then you are in luck - in terms of functionality we have not removed
anything. We cleaned-up and added new features, fixed bugs and updated some
core mechanics (the renderer is just one of the examples). Besides new
functionalities, we put alot of effort into our releases. So give it a try
and work with it as a developer - I am sure you will not be missing much.

Here's a link to the feature list, also outlining what is planned for future
releases: http://www.scipioerp.com/community/download/release-notes/

Feedback is always appreciated and best regards,
Paul



--
View this message in context: http://ofbiz.135035.n4.nabble.com/ANT-vs-Gradle-confused-Database-setup-and-other-configurations-tp4699508p4699521.html
Sent from the OFBiz - User mailing list archive at Nabble.com.