OFBiz › OFBiz - User

Play Area -- Second OFBiz Instance

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

19 messages Options

Craig Parker

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.

Rajesh Mallah

Re: Play Area -- Second OFBiz Instance

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 <[hidden email]> 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.
>
>

Deepak Dixit-3

Re: Play Area -- Second OFBiz Instance

In reply to this post by Craig Parker

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 <[hidden email]> wrote:

Craig Parker

Re: Play Area -- Second OFBiz Instance

<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 <[hidden email]> 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.
>>
>>

Rajesh Mallah

Re: Play Area -- Second OFBiz Instance

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 <[hidden email]> 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 <[hidden email]>
>> 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.
>>>
>>>
>>>
>

Rajesh Mallah

Re: Play Area -- Second OFBiz Instance

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 <[hidden email]>
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 <[hidden email]> 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 <[hidden email]>
>>> 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.
>>>>
>>>>
>>>>
>>
>

Jacques Le Roux

Re: Play Area -- Second OFBiz Instance

Administrator

In reply to this post by Craig Parker

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 <[hidden email]> 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.
>>>
>>>
>
>

Rajesh Mallah

Re: Play Area -- Second OFBiz Instance

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 <
[hidden email]> 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 <[hidden email]>
>>> 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.
>>>>
>>>>
>>>>
>>
>>
>

taher

Re: Play Area -- Second OFBiz Instance

In reply to this post by Craig Parker

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" <[hidden email]> 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.

Jacques Le Roux

Re: Play Area -- Second OFBiz Instance

Administrator

In reply to this post by Rajesh Mallah

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 <
> [hidden email]> 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 <[hidden email]>
>>>> 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.
>>>>>
>>>>>
>>>>>
>>>

Rajesh Mallah

Re: Play Area -- Second OFBiz Instance

Yes I just concluded testing it , it was unnecessary . Thanks

regds
mallah.

On Sat, Aug 26, 2017 at 11:42 PM, Jacques Le Roux <
[hidden email]> 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 <
>> [hidden email]> 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 <[hidden email]>
>>>>> 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.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>

Craig Parker

Re: Play Area -- Second OFBiz Instance

In reply to this post by Rajesh Mallah

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 <[hidden email]> 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 <[hidden email]>
>>> 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.
>>>>
>>>>
>>>>

Rajesh Mallah

Re: Play Area -- Second OFBiz Instance

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 <[hidden email]> 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 <[hidden email]>
>> 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 <[hidden email]>
>>>> 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.
>>>>>
>>>>>
>>>>>
>>>>>
>

Rajesh Mallah

Re: Play Area -- Second OFBiz Instance

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 <[hidden email]>
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 <[hidden email]>
> 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 <[hidden email]>
>>> 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 <[hidden email]>
>>>>> 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.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>
>

Rajesh Mallah

Re: Play Area -- Second OFBiz Instance

In reply to this post by Jacques Le Roux

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 <
[hidden email]> wrote:

Aditya Sharma

Re: Play Area -- Second OFBiz Instance

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 <[hidden email]>
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 <
> [hidden email]> 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 <
> >> [hidden email]> 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 <[hidden email]>
> >>>>> 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.
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>
> >
>

Rajesh Mallah-2

Re: Play Area -- Second OFBiz Instance

Hi Aditya,Thanks for the confirm.
RegdsMallah

Sent from my Samsung Galaxy smartphone.<div>
</div><div>
</div><div>-------- Original message --------</div><div>From: Aditya Sharma <[hidden email]> </div><div>Date: 8/28/17 09:52 (GMT+05:30) </div><div>To: [hidden email] </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 <[hidden email]>
wrote:

Craig Parker

Re: Play Area -- Second OFBiz Instance

In reply to this post by Rajesh Mallah

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<[hidden email]> 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<[hidden email]>
>>> 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<[hidden email]>
>>>>> 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.
>>>>>>
>>>>>>
>>>>>>
>>>>>>

marcopaul

Re: Play Area -- Second OFBiz Instance

In reply to this post by Rajesh Mallah-2

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 <[hidden email]> wrote:
>
> Hi Aditya,Thanks for the confirm.
> RegdsMallah
>
> Sent from my Samsung Galaxy smartphone.<div>
> </div><div>
> </div><div>-------- Original message --------</div><div>From: Aditya Sharma <[hidden email]> </div><div>Date: 8/28/17 09:52 (GMT+05:30) </div><div>To: [hidden email] </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 <[hidden email]>
> 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 <
>> [hidden email]> 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 <
>>>> [hidden email]> 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 <[hidden email]>
>>>>>>> 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.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>
>>