You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Craig Parker <cr...@fossfolks.com> on 2017/08/26 07:14:36 UTC
Play Area -- Second OFBiz Instance
I've got OFBiz up and running on my Linux laptop with a MySQL backend.
Is it possible to have another instance running somehow at the same time
that uses a different DB? Well, maybe three different DBs -- looks like
I'm currently using ofbiz, ofbizolap, and ofbiztenant.
What I'm aiming for is to have a "live" and a "play" area eventually. If
I want to go try something, I want to keep from breaking my install.
Initially though, I want to have the default data in one, and the other
a blank slate.
Right now the install is sitting in /ofbiz and being started up with a
bash script via systemctl. I've not tried it yet, but I'm wondering if
I have to create the three new DBs, and duplicate what I have in /ofbiz
to something like /ofbiz-play, then create a similar startup script that
fires up things in that /ofbiz-play directory.
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@gmail.com>.
Yes . you may use port-offset feature to bind the instance to different
port numbers concurrently
in the same host.
BTW: you can play with derby also , as nuking old data is easy ( rm -rf
<derbyfiles> ) .
with mysql/pgsql you have to put more effort in emptying the database.
HTH!
regds
mallah.
On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com> wrote:
> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
> it possible to have another instance running somehow at the same time that
> uses a different DB? Well, maybe three different DBs -- looks like I'm
> currently using ofbiz, ofbizolap, and ofbiztenant.
>
> What I'm aiming for is to have a "live" and a "play" area eventually. If I
> want to go try something, I want to keep from breaking my install.
>
> Initially though, I want to have the default data in one, and the other a
> blank slate.
>
> Right now the install is sitting in /ofbiz and being started up with a
> bash script via systemctl. I've not tried it yet, but I'm wondering if I
> have to create the three new DBs, and duplicate what I have in /ofbiz to
> something like /ofbiz-play, then create a similar startup script that fires
> up things in that /ofbiz-play directory.
>
>
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@gmail.com>.
Hi Craig ,
below is the diff version , it show what was changed from the stock version.
https://pastebin.com/MzJ0V47n
Note: I had used a separate db schema for ofbiz , in case you are not using
schema ignore below
- schema-name="public"
+ schema-name="ofbiz"
in diff.
HTH!
regds
mallah.
On Sun, Aug 27, 2017 at 11:09 AM, Rajesh Mallah <ma...@gmail.com>
wrote:
>
> regarding blank database:
>
> you may keep the db in shutdown state for a while and attempt to operate
> the ofbiz instance
> if it still operates and does not complaint of db being down , it may mean
> that its using the
> embedded database derby only.
>
> please check on following
>
> (1) Did you change the delegator tags in entityengine.xml ?
> (2) after changing entityengine.xml i had to run gradlew to make below 2
> identical
>
> ./framework/entity/config/entityengine.xml
> ./build/resources/main/entityengine.xml
>
> I think the runtime uses the latter.
>
> I hope you have come across the below link
>
> https://cwiki.apache.org/confluence/display/OFBIZ/How+
> to+migrate+OFBiz+from+Derby+to+MySQL+database
>
> which i used to configure my postgres with ofbiz .
>
>
> Also : working version of my entityengine.xml ( with passwords masked)
>
> https://pastebin.com/17XcW0Bb
>
>
> >> " I'm not sure what to make of the http lines in Rajesh's reply. ... "
>
> the http lines were created by conversion of links (created by gmail)
> to text/plain by the mailing list software (ezmlm) ( i use gmail
> composing)
> it was not typed by me.
>
> Hope it helps.
>
> regds
> mallah.
>
>
> On Sun, Aug 27, 2017 at 10:02 AM, Craig Parker <cr...@fossfolks.com>
> wrote:
>
>> Well, I've got two instances, but they're using the same db. I loaded
>> demo data from within /ofbiz and was able to launch with said demo data. I
>> shut down ofbiz, then moved to /test-ofbiz, ran ./gradlew "ofbiz
>> --load-data readers=seed,seed-initial,demo" and my test_xxx DBs are
>> still blank. I fired up the regular instance of ofbiz (on port 8443) and
>> have a blank DB. Here's a snippet of my entityengine.xml. I've got three
>> new DBs setup, test_xxx (where xxx are the same as my regular install). I'm
>> not sure what to make of the http lines in Rajesh's reply. Those wouldn't
>> have anything to do with gradle writing to the DB anyway, would they?
>>
>> Everyone's PostgreSQL comments are duly noted, by the way. I'd been
>> contemplating moving at some point anyway (heard years ago it's better at
>> maintaining connections over a network than MySQL-- not sure if that's
>> still true) but since I'm this far along, and trying to keep track of
>> making it work for the sake of documentation, I'm going to keep trucking
>> down this road for the moment.
>>
>> <datasource name="localmysql"
>> helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"
>> field-type-name="mysql"
>> check-on-start="true"
>> add-missing-on-start="true"
>> check-pks-on-start="false"
>> use-foreign-keys="true"
>> join-style="ansi-no-parenthesis"
>> alias-view-columns="false"
>> drop-fk-use-foreign-key-keyword="true"
>> table-type="InnoDB"
>> character-set="latin1"
>> collate="latin1_general_cs">
>> <read-data reader-name="tenant"/>
>> <read-data reader-name="seed"/>
>> <read-data reader-name="seed-initial"/>
>> <read-data reader-name="demo"/>
>> <read-data reader-name="ext"/>
>> <read-data reader-name="ext-test"/>
>> <read-data reader-name="ext-demo"/>
>> <inline-jdbc
>> jdbc-driver="com.mysql.jdbc.Driver"
>> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true"
>> jdbc-username="ofbiz"
>> jdbc-password="password"
>> isolation-level="ReadCommitted"
>> pool-minsize="2"
>> pool-maxsize="250"
>> time-between-eviction-runs-millis="600000"/>
>> </datasource>
>>
>>
>> On 08/26/2017 04:46 AM, Rajesh Mallah wrote:
>>
>>> the db_name has to be specified properly in the jdbc-uri
>>>
>>> eg:
>>>
>>> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true
>>> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
>>> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbizolap?autoReconnect=true
>>> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
>>>
>>>
>>> an so on.
>>>
>>>
>>> On Sat, Aug 26, 2017 at 2:12 PM, Craig Parker <cr...@fossfolks.com>
>>> wrote:
>>>
>>> <inline-jdbc
>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>>>
>>>>
>>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>>>> sections? I've tried and failed, but just not sure yet if this is what's
>>>> screwy, or something else.
>>>>
>>>>
>>>>
>>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>>>
>>>> Hi Craig,
>>>>>
>>>>> You can use portoffset feature
>>>>> Please reade README.md file for example
>>>>>
>>>>> Thanks & Regards
>>>>> --
>>>>> Deepak Dixit
>>>>> www.hotwaxsystems.com
>>>>> www.hotwax.co
>>>>>
>>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>>>> wrote:
>>>>>
>>>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend.
>>>>> Is
>>>>>
>>>>>> it possible to have another instance running somehow at the same time
>>>>>> that
>>>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>>>
>>>>>> What I'm aiming for is to have a "live" and a "play" area eventually.
>>>>>> If
>>>>>> I
>>>>>> want to go try something, I want to keep from breaking my install.
>>>>>>
>>>>>> Initially though, I want to have the default data in one, and the
>>>>>> other a
>>>>>> blank slate.
>>>>>>
>>>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering
>>>>>> if I
>>>>>> have to create the three new DBs, and duplicate what I have in /ofbiz
>>>>>> to
>>>>>> something like /ofbiz-play, then create a similar startup script that
>>>>>> fires
>>>>>> up things in that /ofbiz-play directory.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>
>
Re: Play Area -- Second OFBiz Instance
Posted by Craig Parker <cr...@fossfolks.com>.
This was in fact the problem. I've gone through the setup a few times
now, starting fresh on a few different PCs, and forgot to set my
laptop's OFBiz instance(s) to use MySQL in the first place. :P
I can run both now, fire each up with systemctl, and they both run when
I boot. This old laptop has to work hard to get them going initially,
but they run...
On 08/27/2017 01:39 AM, Rajesh Mallah wrote:
> regarding blank database:
>
> you may keep the db in shutdown state for a while and attempt to operate
> the ofbiz instance
> if it still operates and does not complaint of db being down , it may mean
> that its using the
> embedded database derby only.
>
> please check on following
>
> (1) Did you change the delegator tags in entityengine.xml ?
> (2) after changing entityengine.xml i had to run gradlew to make below 2
> identical
>
> ./framework/entity/config/entityengine.xml
> ./build/resources/main/entityengine.xml
>
> I think the runtime uses the latter.
>
> I hope you have come across the below link
>
> https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OFBiz+from+Derby+to+MySQL+database
>
> which i used to configure my postgres with ofbiz .
>
>
> Also : working version of my entityengine.xml ( with passwords masked)
>
> https://pastebin.com/17XcW0Bb
>
>
>>> " I'm not sure what to make of the http lines in Rajesh's reply. ..."
> the http lines were created by conversion of links (created by gmail)
> to text/plain by the mailing list software (ezmlm) ( i use gmail composing)
> it was not typed by me.
>
> Hope it helps.
>
> regds
> mallah.
>
>
> On Sun, Aug 27, 2017 at 10:02 AM, Craig Parker<cr...@fossfolks.com> wrote:
>
>> Well, I've got two instances, but they're using the same db. I loaded demo
>> data from within /ofbiz and was able to launch with said demo data. I shut
>> down ofbiz, then moved to /test-ofbiz, ran ./gradlew "ofbiz --load-data
>> readers=seed,seed-initial,demo" and my test_xxx DBs are still blank. I
>> fired up the regular instance of ofbiz (on port 8443) and have a blank DB.
>> Here's a snippet of my entityengine.xml. I've got three new DBs setup,
>> test_xxx (where xxx are the same as my regular install). I'm not sure what
>> to make of the http lines in Rajesh's reply. Those wouldn't have anything
>> to do with gradle writing to the DB anyway, would they?
>>
>> Everyone's PostgreSQL comments are duly noted, by the way. I'd been
>> contemplating moving at some point anyway (heard years ago it's better at
>> maintaining connections over a network than MySQL-- not sure if that's
>> still true) but since I'm this far along, and trying to keep track of
>> making it work for the sake of documentation, I'm going to keep trucking
>> down this road for the moment.
>>
>> <datasource name="localmysql"
>> helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"
>> field-type-name="mysql"
>> check-on-start="true"
>> add-missing-on-start="true"
>> check-pks-on-start="false"
>> use-foreign-keys="true"
>> join-style="ansi-no-parenthesis"
>> alias-view-columns="false"
>> drop-fk-use-foreign-key-keyword="true"
>> table-type="InnoDB"
>> character-set="latin1"
>> collate="latin1_general_cs">
>> <read-data reader-name="tenant"/>
>> <read-data reader-name="seed"/>
>> <read-data reader-name="seed-initial"/>
>> <read-data reader-name="demo"/>
>> <read-data reader-name="ext"/>
>> <read-data reader-name="ext-test"/>
>> <read-data reader-name="ext-demo"/>
>> <inline-jdbc
>> jdbc-driver="com.mysql.jdbc.Driver"
>> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true"
>> jdbc-username="ofbiz"
>> jdbc-password="password"
>> isolation-level="ReadCommitted"
>> pool-minsize="2"
>> pool-maxsize="250"
>> time-between-eviction-runs-millis="600000"/>
>> </datasource>
>>
>>
>> On 08/26/2017 04:46 AM, Rajesh Mallah wrote:
>>
>>> the db_name has to be specified properly in the jdbc-uri
>>>
>>> eg:
>>>
>>> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true
>>> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
>>> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbizolap?autoReconnect=true
>>> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
>>>
>>>
>>> an so on.
>>>
>>>
>>> On Sat, Aug 26, 2017 at 2:12 PM, Craig Parker<cr...@fossfolks.com>
>>> wrote:
>>>
>>> <inline-jdbc
>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>>>
>>>>
>>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>>>> sections? I've tried and failed, but just not sure yet if this is what's
>>>> screwy, or something else.
>>>>
>>>>
>>>>
>>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>>>
>>>> Hi Craig,
>>>>> You can use portoffset feature
>>>>> Please reade README.md file for example
>>>>>
>>>>> Thanks & Regards
>>>>> --
>>>>> Deepak Dixit
>>>>> www.hotwaxsystems.com
>>>>> www.hotwax.co
>>>>>
>>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker<cr...@fossfolks.com>
>>>>> wrote:
>>>>>
>>>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend.
>>>>> Is
>>>>>
>>>>>> it possible to have another instance running somehow at the same time
>>>>>> that
>>>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>>>
>>>>>> What I'm aiming for is to have a "live" and a "play" area eventually.
>>>>>> If
>>>>>> I
>>>>>> want to go try something, I want to keep from breaking my install.
>>>>>>
>>>>>> Initially though, I want to have the default data in one, and the
>>>>>> other a
>>>>>> blank slate.
>>>>>>
>>>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering
>>>>>> if I
>>>>>> have to create the three new DBs, and duplicate what I have in /ofbiz
>>>>>> to
>>>>>> something like /ofbiz-play, then create a similar startup script that
>>>>>> fires
>>>>>> up things in that /ofbiz-play directory.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@gmail.com>.
regarding blank database:
you may keep the db in shutdown state for a while and attempt to operate
the ofbiz instance
if it still operates and does not complaint of db being down , it may mean
that its using the
embedded database derby only.
please check on following
(1) Did you change the delegator tags in entityengine.xml ?
(2) after changing entityengine.xml i had to run gradlew to make below 2
identical
./framework/entity/config/entityengine.xml
./build/resources/main/entityengine.xml
I think the runtime uses the latter.
I hope you have come across the below link
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OFBiz+from+Derby+to+MySQL+database
which i used to configure my postgres with ofbiz .
Also : working version of my entityengine.xml ( with passwords masked)
https://pastebin.com/17XcW0Bb
>> " I'm not sure what to make of the http lines in Rajesh's reply. ... "
the http lines were created by conversion of links (created by gmail)
to text/plain by the mailing list software (ezmlm) ( i use gmail composing)
it was not typed by me.
Hope it helps.
regds
mallah.
On Sun, Aug 27, 2017 at 10:02 AM, Craig Parker <cr...@fossfolks.com> wrote:
> Well, I've got two instances, but they're using the same db. I loaded demo
> data from within /ofbiz and was able to launch with said demo data. I shut
> down ofbiz, then moved to /test-ofbiz, ran ./gradlew "ofbiz --load-data
> readers=seed,seed-initial,demo" and my test_xxx DBs are still blank. I
> fired up the regular instance of ofbiz (on port 8443) and have a blank DB.
> Here's a snippet of my entityengine.xml. I've got three new DBs setup,
> test_xxx (where xxx are the same as my regular install). I'm not sure what
> to make of the http lines in Rajesh's reply. Those wouldn't have anything
> to do with gradle writing to the DB anyway, would they?
>
> Everyone's PostgreSQL comments are duly noted, by the way. I'd been
> contemplating moving at some point anyway (heard years ago it's better at
> maintaining connections over a network than MySQL-- not sure if that's
> still true) but since I'm this far along, and trying to keep track of
> making it work for the sake of documentation, I'm going to keep trucking
> down this road for the moment.
>
> <datasource name="localmysql"
> helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"
> field-type-name="mysql"
> check-on-start="true"
> add-missing-on-start="true"
> check-pks-on-start="false"
> use-foreign-keys="true"
> join-style="ansi-no-parenthesis"
> alias-view-columns="false"
> drop-fk-use-foreign-key-keyword="true"
> table-type="InnoDB"
> character-set="latin1"
> collate="latin1_general_cs">
> <read-data reader-name="tenant"/>
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <read-data reader-name="demo"/>
> <read-data reader-name="ext"/>
> <read-data reader-name="ext-test"/>
> <read-data reader-name="ext-demo"/>
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true"
> jdbc-username="ofbiz"
> jdbc-password="password"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000"/>
> </datasource>
>
>
> On 08/26/2017 04:46 AM, Rajesh Mallah wrote:
>
>> the db_name has to be specified properly in the jdbc-uri
>>
>> eg:
>>
>> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true
>> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
>> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbizolap?autoReconnect=true
>> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
>>
>>
>> an so on.
>>
>>
>> On Sat, Aug 26, 2017 at 2:12 PM, Craig Parker <cr...@fossfolks.com>
>> wrote:
>>
>> <inline-jdbc
>>> jdbc-driver="com.mysql.jdbc.Driver"
>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>>
>>>
>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>>> sections? I've tried and failed, but just not sure yet if this is what's
>>> screwy, or something else.
>>>
>>>
>>>
>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>>
>>> Hi Craig,
>>>>
>>>> You can use portoffset feature
>>>> Please reade README.md file for example
>>>>
>>>> Thanks & Regards
>>>> --
>>>> Deepak Dixit
>>>> www.hotwaxsystems.com
>>>> www.hotwax.co
>>>>
>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>>> wrote:
>>>>
>>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend.
>>>> Is
>>>>
>>>>> it possible to have another instance running somehow at the same time
>>>>> that
>>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>>
>>>>> What I'm aiming for is to have a "live" and a "play" area eventually.
>>>>> If
>>>>> I
>>>>> want to go try something, I want to keep from breaking my install.
>>>>>
>>>>> Initially though, I want to have the default data in one, and the
>>>>> other a
>>>>> blank slate.
>>>>>
>>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering
>>>>> if I
>>>>> have to create the three new DBs, and duplicate what I have in /ofbiz
>>>>> to
>>>>> something like /ofbiz-play, then create a similar startup script that
>>>>> fires
>>>>> up things in that /ofbiz-play directory.
>>>>>
>>>>>
>>>>>
>>>>>
>
Re: Play Area -- Second OFBiz Instance
Posted by Craig Parker <cr...@fossfolks.com>.
Well, I've got two instances, but they're using the same db. I loaded
demo data from within /ofbiz and was able to launch with said demo data.
I shut down ofbiz, then moved to /test-ofbiz, ran ./gradlew "ofbiz
--load-data readers=seed,seed-initial,demo" and my test_xxx DBs are
still blank. I fired up the regular instance of ofbiz (on port 8443) and
have a blank DB. Here's a snippet of my entityengine.xml. I've got three
new DBs setup, test_xxx (where xxx are the same as my regular install).
I'm not sure what to make of the http lines in Rajesh's reply. Those
wouldn't have anything to do with gradle writing to the DB anyway, would
they?
Everyone's PostgreSQL comments are duly noted, by the way. I'd been
contemplating moving at some point anyway (heard years ago it's better
at maintaining connections over a network than MySQL-- not sure if
that's still true) but since I'm this far along, and trying to keep
track of making it work for the sake of documentation, I'm going to keep
trucking down this road for the moment.
<datasource name="localmysql"
helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"
field-type-name="mysql"
check-on-start="true"
add-missing-on-start="true"
check-pks-on-start="false"
use-foreign-keys="true"
join-style="ansi-no-parenthesis"
alias-view-columns="false"
drop-fk-use-foreign-key-keyword="true"
table-type="InnoDB"
character-set="latin1"
collate="latin1_general_cs">
<read-data reader-name="tenant"/>
<read-data reader-name="seed"/>
<read-data reader-name="seed-initial"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<read-data reader-name="ext-test"/>
<read-data reader-name="ext-demo"/>
<inline-jdbc
jdbc-driver="com.mysql.jdbc.Driver"
jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true"
jdbc-username="ofbiz"
jdbc-password="password"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>
</datasource>
On 08/26/2017 04:46 AM, Rajesh Mallah wrote:
> the db_name has to be specified properly in the jdbc-uri
>
> eg:
>
> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true
> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbizolap?autoReconnect=true
> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
>
> an so on.
>
>
> On Sat, Aug 26, 2017 at 2:12 PM, Craig Parker <cr...@fossfolks.com> wrote:
>
>> <inline-jdbc
>> jdbc-driver="com.mysql.jdbc.Driver"
>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>
>>
>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>> sections? I've tried and failed, but just not sure yet if this is what's
>> screwy, or something else.
>>
>>
>>
>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>
>>> Hi Craig,
>>>
>>> You can use portoffset feature
>>> Please reade README.md file for example
>>>
>>> Thanks & Regards
>>> --
>>> Deepak Dixit
>>> www.hotwaxsystems.com
>>> www.hotwax.co
>>>
>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>> wrote:
>>>
>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
>>>> it possible to have another instance running somehow at the same time
>>>> that
>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>
>>>> What I'm aiming for is to have a "live" and a "play" area eventually. If
>>>> I
>>>> want to go try something, I want to keep from breaking my install.
>>>>
>>>> Initially though, I want to have the default data in one, and the other a
>>>> blank slate.
>>>>
>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>> bash script via systemctl. I've not tried it yet, but I'm wondering if I
>>>> have to create the three new DBs, and duplicate what I have in /ofbiz to
>>>> something like /ofbiz-play, then create a similar startup script that
>>>> fires
>>>> up things in that /ofbiz-play directory.
>>>>
>>>>
>>>>
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@gmail.com>.
Offtopic:
you may consider to using Postgres also for new setups.
note: this has nothing to do with the problem in hand.
regds
mallah.
On Sat, Aug 26, 2017 at 2:16 PM, Rajesh Mallah <ma...@gmail.com>
wrote:
>
> the db_name has to be specified properly in the jdbc-uri
>
> eg:
>
> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true
> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
> jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbizolap?autoReconnect=true
> <http://127.0.0.1/ofbiz?autoReconnect=true>"...
>
> an so on.
>
>
> On Sat, Aug 26, 2017 at 2:12 PM, Craig Parker <cr...@fossfolks.com> wrote:
>
>> <inline-jdbc
>> jdbc-driver="com.mysql.jdbc.Driver"
>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>
>>
>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>> sections? I've tried and failed, but just not sure yet if this is what's
>> screwy, or something else.
>>
>>
>>
>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>
>>> Hi Craig,
>>>
>>> You can use portoffset feature
>>> Please reade README.md file for example
>>>
>>> Thanks & Regards
>>> --
>>> Deepak Dixit
>>> www.hotwaxsystems.com
>>> www.hotwax.co
>>>
>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>> wrote:
>>>
>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
>>>> it possible to have another instance running somehow at the same time
>>>> that
>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>
>>>> What I'm aiming for is to have a "live" and a "play" area eventually.
>>>> If I
>>>> want to go try something, I want to keep from breaking my install.
>>>>
>>>> Initially though, I want to have the default data in one, and the other
>>>> a
>>>> blank slate.
>>>>
>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>> bash script via systemctl. I've not tried it yet, but I'm wondering if
>>>> I
>>>> have to create the three new DBs, and duplicate what I have in /ofbiz to
>>>> something like /ofbiz-play, then create a similar startup script that
>>>> fires
>>>> up things in that /ofbiz-play directory.
>>>>
>>>>
>>>>
>>
>
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@gmail.com>.
the db_name has to be specified properly in the jdbc-uri
eg:
jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbiz?autoReconnect=true
<http://127.0.0.1/ofbiz?autoReconnect=true>"...
jdbc-uri="jdbc:mysql://127.0.0.1/test_ofbizolap?autoReconnect=true
<http://127.0.0.1/ofbiz?autoReconnect=true>"...
an so on.
On Sat, Aug 26, 2017 at 2:12 PM, Craig Parker <cr...@fossfolks.com> wrote:
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>
>
> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
> sections? I've tried and failed, but just not sure yet if this is what's
> screwy, or something else.
>
>
>
> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>
>> Hi Craig,
>>
>> You can use portoffset feature
>> Please reade README.md file for example
>>
>> Thanks & Regards
>> --
>> Deepak Dixit
>> www.hotwaxsystems.com
>> www.hotwax.co
>>
>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>> wrote:
>>
>> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
>>> it possible to have another instance running somehow at the same time
>>> that
>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>
>>> What I'm aiming for is to have a "live" and a "play" area eventually. If
>>> I
>>> want to go try something, I want to keep from breaking my install.
>>>
>>> Initially though, I want to have the default data in one, and the other a
>>> blank slate.
>>>
>>> Right now the install is sitting in /ofbiz and being started up with a
>>> bash script via systemctl. I've not tried it yet, but I'm wondering if I
>>> have to create the three new DBs, and duplicate what I have in /ofbiz to
>>> something like /ofbiz-play, then create a similar startup script that
>>> fires
>>> up things in that /ofbiz-play directory.
>>>
>>>
>>>
>
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@gmail.com>.
Yes I just concluded testing it , it was unnecessary . Thanks
regds
mallah.
On Sat, Aug 26, 2017 at 11:42 PM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Rajesh,
>
> Just FYI, you don't need to use
>
> rm -Rfv ./runtime/data # only for Derby database.
>
> ./gradlew cleanAll
>
> will do it anyway. It uses cleanData
>
> Jacques
>
>
> Le 26/08/2017 à 10:54, Rajesh Mallah a écrit :
>
>> my ../refresh.sh
>>
>> #!/bin/bash
>> rm -Rfv ./runtime/data # only for Derby database.
>> ./gradlew cleanAll
>> ./gradlew
>> ./gradlew "ofbiz --load-data readers=seed,seed-initial,demo"
>> # ./gradlew loadAdminUserLogin -PuserLoginId=admin
>> java -jar build/libs/ofbiz.jar
>>
>>
>> Note: the above does not use port-offset as my needs were different.
>> having a shell script files helps in iterating the create - test -
>> destroy
>> cycles.
>>
>> regds
>> mallah.
>>
>>
>>
>> On Sat, Aug 26, 2017 at 2:19 PM, Jacques Le Roux <
>> jacques.le.roux@les7arts.com> wrote:
>>
>> Sincerely Craig if it's for test, as suggested Rajesh it would be easier
>>> for you to use Derby with portoffset. Then tackle MySQL with portoffset,
>>> hint each instance needs its set of DBs
>>>
>>> Jacques
>>>
>>>
>>>
>>> Le 26/08/2017 à 10:42, Craig Parker a écrit :
>>>
>>> <inline-jdbc
>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>>>
>>>>
>>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>>>> sections? I've tried and failed, but just not sure yet if this is what's
>>>> screwy, or something else.
>>>>
>>>>
>>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>>>
>>>> Hi Craig,
>>>>>
>>>>> You can use portoffset feature
>>>>> Please reade README.md file for example
>>>>>
>>>>> Thanks & Regards
>>>>> --
>>>>> Deepak Dixit
>>>>> www.hotwaxsystems.com
>>>>> www.hotwax.co
>>>>>
>>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>>>> wrote:
>>>>>
>>>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend.
>>>>> Is
>>>>>
>>>>>> it possible to have another instance running somehow at the same time
>>>>>> that
>>>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>>>
>>>>>> What I'm aiming for is to have a "live" and a "play" area eventually.
>>>>>> If I
>>>>>> want to go try something, I want to keep from breaking my install.
>>>>>>
>>>>>> Initially though, I want to have the default data in one, and the
>>>>>> other
>>>>>> a
>>>>>> blank slate.
>>>>>>
>>>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering
>>>>>> if
>>>>>> I
>>>>>> have to create the three new DBs, and duplicate what I have in /ofbiz
>>>>>> to
>>>>>> something like /ofbiz-play, then create a similar startup script that
>>>>>> fires
>>>>>> up things in that /ofbiz-play directory.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>
Re: Play Area -- Second OFBiz Instance
Posted by Paul Mandeltort <pa...@marcospec.com>.
Also look into docker, you can side step all of the configuration headaches and just containerize the whole mess.
--P
> On Aug 27, 2017, at 10:24 PM, Rajesh Mallah <ma...@redgrape.tech> wrote:
>
> Hi Aditya,Thanks for the confirm.
> RegdsMallah
>
> Sent from my Samsung Galaxy smartphone.<div>
> </div><div>
> </div><!-- originalMessage --><div>-------- Original message --------</div><div>From: Aditya Sharma <ad...@hotwaxsystems.com> </div><div>Date: 8/28/17 09:52 (GMT+05:30) </div><div>To: user@ofbiz.apache.org </div><div>Subject: Re: Play Area -- Second OFBiz Instance </div><div>
> </div>Hi Rajesh,
>
> Yes, cleanAll, cleanData or any other gradle target will only clean data
> when you are using embedded derby database as these targets are implemented
> to clean all DB data under directory runtime/data only. For all the other
> databases (mysql, postgresql etc) you need to manually drop the database.
>
> Thanks and Regards,
>
> *Aditya Sharma* | Enterprise Software Engineer
> HotWax Systems <http://www.hotwaxsystems.com/>
> <https://www.linkedin.com/in/aditya-sharma-78291810a/>
>
> On Mon, Aug 28, 2017 at 9:36 AM, Rajesh Mallah <ma...@gmail.com>
> wrote:
>
>> Hi Jacques ,
>>
>> is it true that cleanData only cleans embedded derby database ?
>> with remote postgresql server i feel it does not .
>>
>> regds
>> mallah.
>>
>>
>> On Sat, Aug 26, 2017 at 11:42 PM, Jacques Le Roux <
>> jacques.le.roux@les7arts.com> wrote:
>>
>>> Rajesh,
>>>
>>> Just FYI, you don't need to use
>>>
>>> rm -Rfv ./runtime/data # only for Derby database.
>>>
>>> ./gradlew cleanAll
>>>
>>> will do it anyway. It uses cleanData
>>>
>>> Jacques
>>>
>>>
>>>> Le 26/08/2017 à 10:54, Rajesh Mallah a écrit :
>>>>
>>>> my ../refresh.sh
>>>>
>>>> #!/bin/bash
>>>> rm -Rfv ./runtime/data # only for Derby database.
>>>> ./gradlew cleanAll
>>>> ./gradlew
>>>> ./gradlew "ofbiz --load-data readers=seed,seed-initial,demo"
>>>> # ./gradlew loadAdminUserLogin -PuserLoginId=admin
>>>> java -jar build/libs/ofbiz.jar
>>>>
>>>>
>>>> Note: the above does not use port-offset as my needs were different.
>>>> having a shell script files helps in iterating the create - test -
>>>> destroy
>>>> cycles.
>>>>
>>>> regds
>>>> mallah.
>>>>
>>>>
>>>>
>>>> On Sat, Aug 26, 2017 at 2:19 PM, Jacques Le Roux <
>>>> jacques.le.roux@les7arts.com> wrote:
>>>>
>>>> Sincerely Craig if it's for test, as suggested Rajesh it would be easier
>>>>> for you to use Derby with portoffset. Then tackle MySQL with
>> portoffset,
>>>>> hint each instance needs its set of DBs
>>>>>
>>>>> Jacques
>>>>>
>>>>>
>>>>>
>>>>> Le 26/08/2017 à 10:42, Craig Parker a écrit :
>>>>>
>>>>> <inline-jdbc
>>>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>>>>>
>>>>>>
>>>>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>>>>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>>>>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>>>>>> sections? I've tried and failed, but just not sure yet if this is
>> what's
>>>>>> screwy, or something else.
>>>>>>
>>>>>>
>>>>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>>>>>
>>>>>> Hi Craig,
>>>>>>>
>>>>>>> You can use portoffset feature
>>>>>>> Please reade README.md file for example
>>>>>>>
>>>>>>> Thanks & Regards
>>>>>>> --
>>>>>>> Deepak Dixit
>>>>>>> www.hotwaxsystems.com
>>>>>>> www.hotwax.co
>>>>>>>
>>>>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>> I've got OFBiz up and running on my Linux laptop with a MySQL
>> backend.
>>>>>>> Is
>>>>>>>
>>>>>>>> it possible to have another instance running somehow at the same
>> time
>>>>>>>> that
>>>>>>>> uses a different DB? Well, maybe three different DBs -- looks like
>> I'm
>>>>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>>>>>
>>>>>>>> What I'm aiming for is to have a "live" and a "play" area
>> eventually.
>>>>>>>> If I
>>>>>>>> want to go try something, I want to keep from breaking my install.
>>>>>>>>
>>>>>>>> Initially though, I want to have the default data in one, and the
>>>>>>>> other
>>>>>>>> a
>>>>>>>> blank slate.
>>>>>>>>
>>>>>>>> Right now the install is sitting in /ofbiz and being started up
>> with a
>>>>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering
>>>>>>>> if
>>>>>>>> I
>>>>>>>> have to create the three new DBs, and duplicate what I have in
>> /ofbiz
>>>>>>>> to
>>>>>>>> something like /ofbiz-play, then create a similar startup script
>> that
>>>>>>>> fires
>>>>>>>> up things in that /ofbiz-play directory.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>
>>
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@redgrape.tech>.
Hi Aditya,Thanks for the confirm.
RegdsMallah
Sent from my Samsung Galaxy smartphone.<div>
</div><div>
</div><!-- originalMessage --><div>-------- Original message --------</div><div>From: Aditya Sharma <ad...@hotwaxsystems.com> </div><div>Date: 8/28/17 09:52 (GMT+05:30) </div><div>To: user@ofbiz.apache.org </div><div>Subject: Re: Play Area -- Second OFBiz Instance </div><div>
</div>Hi Rajesh,
Yes, cleanAll, cleanData or any other gradle target will only clean data
when you are using embedded derby database as these targets are implemented
to clean all DB data under directory runtime/data only. For all the other
databases (mysql, postgresql etc) you need to manually drop the database.
Thanks and Regards,
*Aditya Sharma* | Enterprise Software Engineer
HotWax Systems <http://www.hotwaxsystems.com/>
<https://www.linkedin.com/in/aditya-sharma-78291810a/>
On Mon, Aug 28, 2017 at 9:36 AM, Rajesh Mallah <ma...@gmail.com>
wrote:
> Hi Jacques ,
>
> is it true that cleanData only cleans embedded derby database ?
> with remote postgresql server i feel it does not .
>
> regds
> mallah.
>
>
> On Sat, Aug 26, 2017 at 11:42 PM, Jacques Le Roux <
> jacques.le.roux@les7arts.com> wrote:
>
> > Rajesh,
> >
> > Just FYI, you don't need to use
> >
> > rm -Rfv ./runtime/data # only for Derby database.
> >
> > ./gradlew cleanAll
> >
> > will do it anyway. It uses cleanData
> >
> > Jacques
> >
> >
> > Le 26/08/2017 à 10:54, Rajesh Mallah a écrit :
> >
> >> my ../refresh.sh
> >>
> >> #!/bin/bash
> >> rm -Rfv ./runtime/data # only for Derby database.
> >> ./gradlew cleanAll
> >> ./gradlew
> >> ./gradlew "ofbiz --load-data readers=seed,seed-initial,demo"
> >> # ./gradlew loadAdminUserLogin -PuserLoginId=admin
> >> java -jar build/libs/ofbiz.jar
> >>
> >>
> >> Note: the above does not use port-offset as my needs were different.
> >> having a shell script files helps in iterating the create - test -
> >> destroy
> >> cycles.
> >>
> >> regds
> >> mallah.
> >>
> >>
> >>
> >> On Sat, Aug 26, 2017 at 2:19 PM, Jacques Le Roux <
> >> jacques.le.roux@les7arts.com> wrote:
> >>
> >> Sincerely Craig if it's for test, as suggested Rajesh it would be easier
> >>> for you to use Derby with portoffset. Then tackle MySQL with
> portoffset,
> >>> hint each instance needs its set of DBs
> >>>
> >>> Jacques
> >>>
> >>>
> >>>
> >>> Le 26/08/2017 à 10:42, Craig Parker a écrit :
> >>>
> >>> <inline-jdbc
> >>>> jdbc-driver="com.mysql.jdbc.Driver"
> >>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
> >>>>
> >>>>
> >>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
> >>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
> >>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
> >>>> sections? I've tried and failed, but just not sure yet if this is
> what's
> >>>> screwy, or something else.
> >>>>
> >>>>
> >>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
> >>>>
> >>>> Hi Craig,
> >>>>>
> >>>>> You can use portoffset feature
> >>>>> Please reade README.md file for example
> >>>>>
> >>>>> Thanks & Regards
> >>>>> --
> >>>>> Deepak Dixit
> >>>>> www.hotwaxsystems.com
> >>>>> www.hotwax.co
> >>>>>
> >>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
> >>>>> wrote:
> >>>>>
> >>>>> I've got OFBiz up and running on my Linux laptop with a MySQL
> backend.
> >>>>> Is
> >>>>>
> >>>>>> it possible to have another instance running somehow at the same
> time
> >>>>>> that
> >>>>>> uses a different DB? Well, maybe three different DBs -- looks like
> I'm
> >>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
> >>>>>>
> >>>>>> What I'm aiming for is to have a "live" and a "play" area
> eventually.
> >>>>>> If I
> >>>>>> want to go try something, I want to keep from breaking my install.
> >>>>>>
> >>>>>> Initially though, I want to have the default data in one, and the
> >>>>>> other
> >>>>>> a
> >>>>>> blank slate.
> >>>>>>
> >>>>>> Right now the install is sitting in /ofbiz and being started up
> with a
> >>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering
> >>>>>> if
> >>>>>> I
> >>>>>> have to create the three new DBs, and duplicate what I have in
> /ofbiz
> >>>>>> to
> >>>>>> something like /ofbiz-play, then create a similar startup script
> that
> >>>>>> fires
> >>>>>> up things in that /ofbiz-play directory.
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>
> >
>
Re: Play Area -- Second OFBiz Instance
Posted by Aditya Sharma <ad...@hotwaxsystems.com>.
Hi Rajesh,
Yes, cleanAll, cleanData or any other gradle target will only clean data
when you are using embedded derby database as these targets are implemented
to clean all DB data under directory runtime/data only. For all the other
databases (mysql, postgresql etc) you need to manually drop the database.
Thanks and Regards,
*Aditya Sharma* | Enterprise Software Engineer
HotWax Systems <http://www.hotwaxsystems.com/>
<https://www.linkedin.com/in/aditya-sharma-78291810a/>
On Mon, Aug 28, 2017 at 9:36 AM, Rajesh Mallah <ma...@gmail.com>
wrote:
> Hi Jacques ,
>
> is it true that cleanData only cleans embedded derby database ?
> with remote postgresql server i feel it does not .
>
> regds
> mallah.
>
>
> On Sat, Aug 26, 2017 at 11:42 PM, Jacques Le Roux <
> jacques.le.roux@les7arts.com> wrote:
>
> > Rajesh,
> >
> > Just FYI, you don't need to use
> >
> > rm -Rfv ./runtime/data # only for Derby database.
> >
> > ./gradlew cleanAll
> >
> > will do it anyway. It uses cleanData
> >
> > Jacques
> >
> >
> > Le 26/08/2017 à 10:54, Rajesh Mallah a écrit :
> >
> >> my ../refresh.sh
> >>
> >> #!/bin/bash
> >> rm -Rfv ./runtime/data # only for Derby database.
> >> ./gradlew cleanAll
> >> ./gradlew
> >> ./gradlew "ofbiz --load-data readers=seed,seed-initial,demo"
> >> # ./gradlew loadAdminUserLogin -PuserLoginId=admin
> >> java -jar build/libs/ofbiz.jar
> >>
> >>
> >> Note: the above does not use port-offset as my needs were different.
> >> having a shell script files helps in iterating the create - test -
> >> destroy
> >> cycles.
> >>
> >> regds
> >> mallah.
> >>
> >>
> >>
> >> On Sat, Aug 26, 2017 at 2:19 PM, Jacques Le Roux <
> >> jacques.le.roux@les7arts.com> wrote:
> >>
> >> Sincerely Craig if it's for test, as suggested Rajesh it would be easier
> >>> for you to use Derby with portoffset. Then tackle MySQL with
> portoffset,
> >>> hint each instance needs its set of DBs
> >>>
> >>> Jacques
> >>>
> >>>
> >>>
> >>> Le 26/08/2017 à 10:42, Craig Parker a écrit :
> >>>
> >>> <inline-jdbc
> >>>> jdbc-driver="com.mysql.jdbc.Driver"
> >>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
> >>>>
> >>>>
> >>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
> >>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
> >>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
> >>>> sections? I've tried and failed, but just not sure yet if this is
> what's
> >>>> screwy, or something else.
> >>>>
> >>>>
> >>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
> >>>>
> >>>> Hi Craig,
> >>>>>
> >>>>> You can use portoffset feature
> >>>>> Please reade README.md file for example
> >>>>>
> >>>>> Thanks & Regards
> >>>>> --
> >>>>> Deepak Dixit
> >>>>> www.hotwaxsystems.com
> >>>>> www.hotwax.co
> >>>>>
> >>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
> >>>>> wrote:
> >>>>>
> >>>>> I've got OFBiz up and running on my Linux laptop with a MySQL
> backend.
> >>>>> Is
> >>>>>
> >>>>>> it possible to have another instance running somehow at the same
> time
> >>>>>> that
> >>>>>> uses a different DB? Well, maybe three different DBs -- looks like
> I'm
> >>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
> >>>>>>
> >>>>>> What I'm aiming for is to have a "live" and a "play" area
> eventually.
> >>>>>> If I
> >>>>>> want to go try something, I want to keep from breaking my install.
> >>>>>>
> >>>>>> Initially though, I want to have the default data in one, and the
> >>>>>> other
> >>>>>> a
> >>>>>> blank slate.
> >>>>>>
> >>>>>> Right now the install is sitting in /ofbiz and being started up
> with a
> >>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering
> >>>>>> if
> >>>>>> I
> >>>>>> have to create the three new DBs, and duplicate what I have in
> /ofbiz
> >>>>>> to
> >>>>>> something like /ofbiz-play, then create a similar startup script
> that
> >>>>>> fires
> >>>>>> up things in that /ofbiz-play directory.
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>
> >
>
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@gmail.com>.
Hi Jacques ,
is it true that cleanData only cleans embedded derby database ?
with remote postgresql server i feel it does not .
regds
mallah.
On Sat, Aug 26, 2017 at 11:42 PM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Rajesh,
>
> Just FYI, you don't need to use
>
> rm -Rfv ./runtime/data # only for Derby database.
>
> ./gradlew cleanAll
>
> will do it anyway. It uses cleanData
>
> Jacques
>
>
> Le 26/08/2017 à 10:54, Rajesh Mallah a écrit :
>
>> my ../refresh.sh
>>
>> #!/bin/bash
>> rm -Rfv ./runtime/data # only for Derby database.
>> ./gradlew cleanAll
>> ./gradlew
>> ./gradlew "ofbiz --load-data readers=seed,seed-initial,demo"
>> # ./gradlew loadAdminUserLogin -PuserLoginId=admin
>> java -jar build/libs/ofbiz.jar
>>
>>
>> Note: the above does not use port-offset as my needs were different.
>> having a shell script files helps in iterating the create - test -
>> destroy
>> cycles.
>>
>> regds
>> mallah.
>>
>>
>>
>> On Sat, Aug 26, 2017 at 2:19 PM, Jacques Le Roux <
>> jacques.le.roux@les7arts.com> wrote:
>>
>> Sincerely Craig if it's for test, as suggested Rajesh it would be easier
>>> for you to use Derby with portoffset. Then tackle MySQL with portoffset,
>>> hint each instance needs its set of DBs
>>>
>>> Jacques
>>>
>>>
>>>
>>> Le 26/08/2017 à 10:42, Craig Parker a écrit :
>>>
>>> <inline-jdbc
>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>>>
>>>>
>>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>>>> sections? I've tried and failed, but just not sure yet if this is what's
>>>> screwy, or something else.
>>>>
>>>>
>>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>>>
>>>> Hi Craig,
>>>>>
>>>>> You can use portoffset feature
>>>>> Please reade README.md file for example
>>>>>
>>>>> Thanks & Regards
>>>>> --
>>>>> Deepak Dixit
>>>>> www.hotwaxsystems.com
>>>>> www.hotwax.co
>>>>>
>>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>>>> wrote:
>>>>>
>>>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend.
>>>>> Is
>>>>>
>>>>>> it possible to have another instance running somehow at the same time
>>>>>> that
>>>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>>>
>>>>>> What I'm aiming for is to have a "live" and a "play" area eventually.
>>>>>> If I
>>>>>> want to go try something, I want to keep from breaking my install.
>>>>>>
>>>>>> Initially though, I want to have the default data in one, and the
>>>>>> other
>>>>>> a
>>>>>> blank slate.
>>>>>>
>>>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering
>>>>>> if
>>>>>> I
>>>>>> have to create the three new DBs, and duplicate what I have in /ofbiz
>>>>>> to
>>>>>> something like /ofbiz-play, then create a similar startup script that
>>>>>> fires
>>>>>> up things in that /ofbiz-play directory.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>
Re: Play Area -- Second OFBiz Instance
Posted by Jacques Le Roux <ja...@les7arts.com>.
Rajesh,
Just FYI, you don't need to use
rm -Rfv ./runtime/data # only for Derby database.
./gradlew cleanAll
will do it anyway. It uses cleanData
Jacques
Le 26/08/2017 à 10:54, Rajesh Mallah a écrit :
> my ../refresh.sh
>
> #!/bin/bash
> rm -Rfv ./runtime/data # only for Derby database.
> ./gradlew cleanAll
> ./gradlew
> ./gradlew "ofbiz --load-data readers=seed,seed-initial,demo"
> # ./gradlew loadAdminUserLogin -PuserLoginId=admin
> java -jar build/libs/ofbiz.jar
>
>
> Note: the above does not use port-offset as my needs were different.
> having a shell script files helps in iterating the create - test -
> destroy
> cycles.
>
> regds
> mallah.
>
>
>
> On Sat, Aug 26, 2017 at 2:19 PM, Jacques Le Roux <
> jacques.le.roux@les7arts.com> wrote:
>
>> Sincerely Craig if it's for test, as suggested Rajesh it would be easier
>> for you to use Derby with portoffset. Then tackle MySQL with portoffset,
>> hint each instance needs its set of DBs
>>
>> Jacques
>>
>>
>>
>> Le 26/08/2017 à 10:42, Craig Parker a écrit :
>>
>>> <inline-jdbc
>>> jdbc-driver="com.mysql.jdbc.Driver"
>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>>
>>>
>>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>>> sections? I've tried and failed, but just not sure yet if this is what's
>>> screwy, or something else.
>>>
>>>
>>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>>
>>>> Hi Craig,
>>>>
>>>> You can use portoffset feature
>>>> Please reade README.md file for example
>>>>
>>>> Thanks & Regards
>>>> --
>>>> Deepak Dixit
>>>> www.hotwaxsystems.com
>>>> www.hotwax.co
>>>>
>>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>>> wrote:
>>>>
>>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
>>>>> it possible to have another instance running somehow at the same time
>>>>> that
>>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>>
>>>>> What I'm aiming for is to have a "live" and a "play" area eventually.
>>>>> If I
>>>>> want to go try something, I want to keep from breaking my install.
>>>>>
>>>>> Initially though, I want to have the default data in one, and the other
>>>>> a
>>>>> blank slate.
>>>>>
>>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>>> bash script via systemctl. I've not tried it yet, but I'm wondering if
>>>>> I
>>>>> have to create the three new DBs, and duplicate what I have in /ofbiz to
>>>>> something like /ofbiz-play, then create a similar startup script that
>>>>> fires
>>>>> up things in that /ofbiz-play directory.
>>>>>
>>>>>
>>>>>
>>>
Re: Play Area -- Second OFBiz Instance
Posted by Rajesh Mallah <ma...@gmail.com>.
my ../refresh.sh
#!/bin/bash
rm -Rfv ./runtime/data # only for Derby database.
./gradlew cleanAll
./gradlew
./gradlew "ofbiz --load-data readers=seed,seed-initial,demo"
# ./gradlew loadAdminUserLogin -PuserLoginId=admin
java -jar build/libs/ofbiz.jar
Note: the above does not use port-offset as my needs were different.
having a shell script files helps in iterating the create - test -
destroy
cycles.
regds
mallah.
On Sat, Aug 26, 2017 at 2:19 PM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Sincerely Craig if it's for test, as suggested Rajesh it would be easier
> for you to use Derby with portoffset. Then tackle MySQL with portoffset,
> hint each instance needs its set of DBs
>
> Jacques
>
>
>
> Le 26/08/2017 à 10:42, Craig Parker a écrit :
>
>> <inline-jdbc
>> jdbc-driver="com.mysql.jdbc.Driver"
>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>>
>>
>> If I've created three new DBs, each with a test_ prefix (test_ofbiz,
>> test_ofbizolap, and test_ofbiztenant) has this got to say: ...
>> 127.0.0.1/test_ofbiz... in each of the three relevant datasource
>> sections? I've tried and failed, but just not sure yet if this is what's
>> screwy, or something else.
>>
>>
>> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>>
>>> Hi Craig,
>>>
>>> You can use portoffset feature
>>> Please reade README.md file for example
>>>
>>> Thanks & Regards
>>> --
>>> Deepak Dixit
>>> www.hotwaxsystems.com
>>> www.hotwax.co
>>>
>>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com>
>>> wrote:
>>>
>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
>>>> it possible to have another instance running somehow at the same time
>>>> that
>>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>>
>>>> What I'm aiming for is to have a "live" and a "play" area eventually.
>>>> If I
>>>> want to go try something, I want to keep from breaking my install.
>>>>
>>>> Initially though, I want to have the default data in one, and the other
>>>> a
>>>> blank slate.
>>>>
>>>> Right now the install is sitting in /ofbiz and being started up with a
>>>> bash script via systemctl. I've not tried it yet, but I'm wondering if
>>>> I
>>>> have to create the three new DBs, and duplicate what I have in /ofbiz to
>>>> something like /ofbiz-play, then create a similar startup script that
>>>> fires
>>>> up things in that /ofbiz-play directory.
>>>>
>>>>
>>>>
>>
>>
>
Re: Play Area -- Second OFBiz Instance
Posted by Jacques Le Roux <ja...@les7arts.com>.
Sincerely Craig if it's for test, as suggested Rajesh it would be easier for you to use Derby with portoffset. Then tackle MySQL with portoffset, hint
each instance needs its set of DBs
Jacques
Le 26/08/2017 à 10:42, Craig Parker a écrit :
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
>
>
> If I've created three new DBs, each with a test_ prefix (test_ofbiz, test_ofbizolap, and test_ofbiztenant) has this got to say:
> ...127.0.0.1/test_ofbiz... in each of the three relevant datasource sections? I've tried and failed, but just not sure yet if this is what's screwy,
> or something else.
>
>
> On 08/26/2017 03:36 AM, Deepak Dixit wrote:
>> Hi Craig,
>>
>> You can use portoffset feature
>> Please reade README.md file for example
>>
>> Thanks & Regards
>> --
>> Deepak Dixit
>> www.hotwaxsystems.com
>> www.hotwax.co
>>
>> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com> wrote:
>>
>>> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
>>> it possible to have another instance running somehow at the same time that
>>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>>
>>> What I'm aiming for is to have a "live" and a "play" area eventually. If I
>>> want to go try something, I want to keep from breaking my install.
>>>
>>> Initially though, I want to have the default data in one, and the other a
>>> blank slate.
>>>
>>> Right now the install is sitting in /ofbiz and being started up with a
>>> bash script via systemctl. I've not tried it yet, but I'm wondering if I
>>> have to create the three new DBs, and duplicate what I have in /ofbiz to
>>> something like /ofbiz-play, then create a similar startup script that fires
>>> up things in that /ofbiz-play directory.
>>>
>>>
>
>
Re: Play Area -- Second OFBiz Instance
Posted by Craig Parker <cr...@fossfolks.com>.
<inline-jdbc
jdbc-driver="com.mysql.jdbc.Driver"
jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"...
If I've created three new DBs, each with a test_ prefix (test_ofbiz,
test_ofbizolap, and test_ofbiztenant) has this got to say:
...127.0.0.1/test_ofbiz... in each of the three relevant datasource
sections? I've tried and failed, but just not sure yet if this is what's
screwy, or something else.
On 08/26/2017 03:36 AM, Deepak Dixit wrote:
> Hi Craig,
>
> You can use portoffset feature
> Please reade README.md file for example
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
>
> On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com> wrote:
>
>> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
>> it possible to have another instance running somehow at the same time that
>> uses a different DB? Well, maybe three different DBs -- looks like I'm
>> currently using ofbiz, ofbizolap, and ofbiztenant.
>>
>> What I'm aiming for is to have a "live" and a "play" area eventually. If I
>> want to go try something, I want to keep from breaking my install.
>>
>> Initially though, I want to have the default data in one, and the other a
>> blank slate.
>>
>> Right now the install is sitting in /ofbiz and being started up with a
>> bash script via systemctl. I've not tried it yet, but I'm wondering if I
>> have to create the three new DBs, and duplicate what I have in /ofbiz to
>> something like /ofbiz-play, then create a similar startup script that fires
>> up things in that /ofbiz-play directory.
>>
>>
Re: Play Area -- Second OFBiz Instance
Posted by Deepak Dixit <de...@hotwaxsystems.com>.
Hi Craig,
You can use portoffset feature
Please reade README.md file for example
Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
www.hotwax.co
On Sat, Aug 26, 2017 at 12:44 PM, Craig Parker <cr...@fossfolks.com> wrote:
> I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
> it possible to have another instance running somehow at the same time that
> uses a different DB? Well, maybe three different DBs -- looks like I'm
> currently using ofbiz, ofbizolap, and ofbiztenant.
>
> What I'm aiming for is to have a "live" and a "play" area eventually. If I
> want to go try something, I want to keep from breaking my install.
>
> Initially though, I want to have the default data in one, and the other a
> blank slate.
>
> Right now the install is sitting in /ofbiz and being started up with a
> bash script via systemctl. I've not tried it yet, but I'm wondering if I
> have to create the three new DBs, and duplicate what I have in /ofbiz to
> something like /ofbiz-play, then create a similar startup script that fires
> up things in that /ofbiz-play directory.
>
>
Re: Play Area -- Second OFBiz Instance
Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Craig,
I'm not sure if this might be an overkill for you, but I usually write a
little docker-compose file to fire up OFBiz with postgres. I can have 5
instances running on my laptop each with its own database, ip address,
network stack, etc. I can start or terminate any instance with one line and
all instances are completely isolated from each other. Even better, I don't
have to install any database on my computer.
Of course the price you have to pay is learning docker which takes some
time to understand but the benefits are worth it in my opinion. Deployment
becomes consistent in any machine whether be it production, staging or your
local machine.
On Aug 26, 2017 10:14 AM, "Craig Parker" <cr...@fossfolks.com> wrote:
I've got OFBiz up and running on my Linux laptop with a MySQL backend. Is
it possible to have another instance running somehow at the same time that
uses a different DB? Well, maybe three different DBs -- looks like I'm
currently using ofbiz, ofbizolap, and ofbiztenant.
What I'm aiming for is to have a "live" and a "play" area eventually. If I
want to go try something, I want to keep from breaking my install.
Initially though, I want to have the default data in one, and the other a
blank slate.
Right now the install is sitting in /ofbiz and being started up with a bash
script via systemctl. I've not tried it yet, but I'm wondering if I have
to create the three new DBs, and duplicate what I have in /ofbiz to
something like /ofbiz-play, then create a similar startup script that fires
up things in that /ofbiz-play directory.