Setup issues
Locked
 
|
I am attempting to setup OFBiz for my business.
I am a Linux developer of many years experience. I wanted a secure (SSL) setup, and I thought I would use Mariadb as I already use that for other software, and I would avoid duplication with another database. I stretched this further by wanting to have no demo data. I found it very difficult to accomplish all this. Much more difficult than I might have expected for a major apache project. However, I persevered, and after a whole weekend of work, I got it working to a first order. I have documented each step I took. HOWEVER: I CANNOT ADD A PARTY MAILING ADDRESS. There are no provinces listed for Canada. There are no states listed for the USA. I don't know other countries intimately, so I can't speak for them. As a result of being incomplete, I cannot add addresses at all. I initially thought this must be because I did not use the demo data. So, I repeated my work, but left the demo data in place. SAME PROBLEM. Then I thought that perhaps I should do the migration (to Mysql) AFTER setting up the initial data. That was BROKEN and wouldn't complete on import, and the resulting website wouldn't display properly. Then I thought it might be the database - perhaps it doesn't work with mysql. I would just do the straightforward install, and work with that. SAME PROBLEM. So here we are: 3 full days and I can't enter my first employee, even with the simplest install with default settings. Of course there is one fundamental lesson here: never just believe that something works just because it is from a reputable project that has been out there for years. I should have known better. -- Dominic Amann M 416-270-4587 |
|
|
Hi Dominic,
Province data and similar locality data is part of the seed data and loaded from the /framework/common/data/Geo*.xml files you should be able to spot that being loaded in your initial setup log output. It's been a while since I've spun up a clean instance, but the data is certainly there so it's just not being loaded for some reason. Hope that helps, Jason On 26/10/2020 16:55, Dominic Amann wrote: > I am attempting to setup OFBiz for my business. > > I am a Linux developer of many years experience. > > I wanted a secure (SSL) setup, and I thought I would use Mariadb as I > already use that for other software, and I would avoid duplication with > another database. I stretched this further by wanting to have no demo data. > > I found it very difficult to accomplish all this. Much more difficult than > I might have expected for a major apache project. However, I persevered, > and after a whole weekend of work, I got it working to a first order. I > have documented each step I took. > > HOWEVER: > > I CANNOT ADD A PARTY MAILING ADDRESS. There are no provinces listed for > Canada. There are no states listed for the USA. I don't know other > countries intimately, so I can't speak for them. As a result of being > incomplete, I cannot add addresses at all. > > I initially thought this must be because I did not use the demo data. So, I > repeated my work, but left the demo data in place. SAME PROBLEM. > > Then I thought that perhaps I should do the migration (to Mysql) AFTER > setting up the initial data. That was BROKEN and wouldn't complete on > import, and the resulting website wouldn't display properly. > > Then I thought it might be the database - perhaps it doesn't work with > mysql. I would just do the straightforward install, and work with that. > SAME PROBLEM. > > So here we are: 3 full days and I can't enter my first employee, even with > the simplest install with default settings. Of course there is one > fundamental lesson here: never just believe that something works just > because it is from a reputable project that has been out there for years. I > should have known better. > |
|
|
Yes, the data is there (in XML). I guess I need to go poking around in the
database to find out if it got into there during setup? Or perhaps check the pages of output during the "./gradlew loadAll " step... I'll do the latter first. On Mon, 26 Oct 2020 at 13:11, Jason RJ <[hidden email]> wrote: > Hi Dominic, > > Province data and similar locality data is part of the seed data and > loaded from the /framework/common/data/Geo*.xml files you should be able > to spot that being loaded in your initial setup log output. It's been a > while since I've spun up a clean instance, but the data is certainly > there so it's just not being loaded for some reason. > > Hope that helps, > > Jason > > > On 26/10/2020 16:55, Dominic Amann wrote: > > I am attempting to setup OFBiz for my business. > > > > I am a Linux developer of many years experience. > > > > I wanted a secure (SSL) setup, and I thought I would use Mariadb as I > > already use that for other software, and I would avoid duplication with > > another database. I stretched this further by wanting to have no demo > data. > > > > I found it very difficult to accomplish all this. Much more difficult > than > > I might have expected for a major apache project. However, I persevered, > > and after a whole weekend of work, I got it working to a first order. I > > have documented each step I took. > > > > HOWEVER: > > > > I CANNOT ADD A PARTY MAILING ADDRESS. There are no provinces listed for > > Canada. There are no states listed for the USA. I don't know other > > countries intimately, so I can't speak for them. As a result of being > > incomplete, I cannot add addresses at all. > > > > I initially thought this must be because I did not use the demo data. > So, I > > repeated my work, but left the demo data in place. SAME PROBLEM. > > > > Then I thought that perhaps I should do the migration (to Mysql) AFTER > > setting up the initial data. That was BROKEN and wouldn't complete on > > import, and the resulting website wouldn't display properly. > > > > Then I thought it might be the database - perhaps it doesn't work with > > mysql. I would just do the straightforward install, and work with that. > > SAME PROBLEM. > > > > So here we are: 3 full days and I can't enter my first employee, even > with > > the simplest install with default settings. Of course there is one > > fundamental lesson here: never just believe that something works just > > because it is from a reputable project that has been out there for > years. I > > should have known better. > > > -- Dominic Amann M 416-270-4587 |
|
|
You can use Webtools to see the data related to each entity in the database.
-----Ursprüngliche Nachricht----- From: Dominic Amann Sent: Monday, October 26, 2020 6:25 PM To: [hidden email] Subject: Re: Setup issues Yes, the data is there (in XML). I guess I need to go poking around in the database to find out if it got into there during setup? Or perhaps check the pages of output during the "./gradlew loadAll " step... I'll do the latter first. On Mon, 26 Oct 2020 at 13:11, Jason RJ <[hidden email]> wrote: > Hi Dominic, > > Province data and similar locality data is part of the seed data and > loaded from the /framework/common/data/Geo*.xml files you should be able > to spot that being loaded in your initial setup log output. It's been a > while since I've spun up a clean instance, but the data is certainly > there so it's just not being loaded for some reason. > > Hope that helps, > > Jason > > > On 26/10/2020 16:55, Dominic Amann wrote: > > I am attempting to setup OFBiz for my business. > > > > I am a Linux developer of many years experience. > > > > I wanted a secure (SSL) setup, and I thought I would use Mariadb as I > > already use that for other software, and I would avoid duplication with > > another database. I stretched this further by wanting to have no demo > data. > > > > I found it very difficult to accomplish all this. Much more difficult > than > > I might have expected for a major apache project. However, I persevered, > > and after a whole weekend of work, I got it working to a first order. I > > have documented each step I took. > > > > HOWEVER: > > > > I CANNOT ADD A PARTY MAILING ADDRESS. There are no provinces listed for > > Canada. There are no states listed for the USA. I don't know other > > countries intimately, so I can't speak for them. As a result of being > > incomplete, I cannot add addresses at all. > > > > I initially thought this must be because I did not use the demo data. > So, I > > repeated my work, but left the demo data in place. SAME PROBLEM. > > > > Then I thought that perhaps I should do the migration (to Mysql) AFTER > > setting up the initial data. That was BROKEN and wouldn't complete on > > import, and the resulting website wouldn't display properly. > > > > Then I thought it might be the database - perhaps it doesn't work with > > mysql. I would just do the straightforward install, and work with that. > > SAME PROBLEM. > > > > So here we are: 3 full days and I can't enter my first employee, even > with > > the simplest install with default settings. Of course there is one > > fundamental lesson here: never just believe that something works just > > because it is from a reputable project that has been out there for > years. I > > should have known better. > > > -- Dominic Amann M 416-270-4587 |
|
|
In reply to this post by dimonic
I can confirm that values were loaded from the relevant xml file for my
country. Beginning import from URL: file:/var/www/apache-ofbiz-17.12.04/framework/common /data/GeoData_CA.xml 2020-10-26 17:27:43,384 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds) 2020-10-26 17:27:43,424 |main |EntitySaxReader |I| Finished 26 values from file:/var/www/apache-ofbiz-17.12.04/framework/common/da ta/GeoData_CA.xml On Mon, 26 Oct 2020 at 13:25, Dominic Amann <[hidden email]> wrote: > Yes, the data is there (in XML). I guess I need to go poking around in the > database to find out if it got into there during setup? Or perhaps check > the pages of output during the "./gradlew loadAll " step... I'll do the > latter first. > > On Mon, 26 Oct 2020 at 13:11, Jason RJ <[hidden email]> wrote: > >> Hi Dominic, >> >> Province data and similar locality data is part of the seed data and >> loaded from the /framework/common/data/Geo*.xml files you should be able >> to spot that being loaded in your initial setup log output. It's been a >> while since I've spun up a clean instance, but the data is certainly >> there so it's just not being loaded for some reason. >> >> Hope that helps, >> >> Jason >> >> >> On 26/10/2020 16:55, Dominic Amann wrote: >> > I am attempting to setup OFBiz for my business. >> > >> > I am a Linux developer of many years experience. >> > >> > I wanted a secure (SSL) setup, and I thought I would use Mariadb as I >> > already use that for other software, and I would avoid duplication with >> > another database. I stretched this further by wanting to have no demo >> data. >> > >> > I found it very difficult to accomplish all this. Much more difficult >> than >> > I might have expected for a major apache project. However, I persevered, >> > and after a whole weekend of work, I got it working to a first order. I >> > have documented each step I took. >> > >> > HOWEVER: >> > >> > I CANNOT ADD A PARTY MAILING ADDRESS. There are no provinces listed for >> > Canada. There are no states listed for the USA. I don't know other >> > countries intimately, so I can't speak for them. As a result of being >> > incomplete, I cannot add addresses at all. >> > >> > I initially thought this must be because I did not use the demo data. >> So, I >> > repeated my work, but left the demo data in place. SAME PROBLEM. >> > >> > Then I thought that perhaps I should do the migration (to Mysql) AFTER >> > setting up the initial data. That was BROKEN and wouldn't complete on >> > import, and the resulting website wouldn't display properly. >> > >> > Then I thought it might be the database - perhaps it doesn't work with >> > mysql. I would just do the straightforward install, and work with that. >> > SAME PROBLEM. >> > >> > So here we are: 3 full days and I can't enter my first employee, even >> with >> > the simplest install with default settings. Of course there is one >> > fundamental lesson here: never just believe that something works just >> > because it is from a reputable project that has been out there for >> years. I >> > should have known better. >> > >> > > > -- > > > Dominic Amann > > M 416-270-4587 > -- Dominic Amann M 416-270-4587 |
|
|
Thanks Georg. I am looking at a _huge_ table of entities, 900+ references to "Geo". I need to narrow it down but I don't really know what I am looking for. I found this: On Mon, 26 Oct 2020 at 13:57, Dominic Amann <[hidden email]> wrote:
Dominic AmannM 416-270-4587 |
|
|
Here is the demo "Company" in display - note that it is in CA (california state). And here when I click Update, the State field is empty, and I cannot select a state. On Mon, 26 Oct 2020 at 14:21, Dominic Amann <[hidden email]> wrote:
Dominic AmannM 416-270-4587 |
|
|
This is default install, per the directions, demo data, current version
(17.12.04). It simply doesn't work. On Mon, 26 Oct 2020 at 14:25, Dominic Amann <[hidden email]> wrote: > Here is the demo "Company" in display - note that it is in CA (california > state). > > And here when I click Update, the State field is empty, and I cannot > select a state. > > > > On Mon, 26 Oct 2020 at 14:21, Dominic Amann <[hidden email]> > wrote: > >> Thanks Georg. I am looking at a _huge_ table of entities, 900+ references >> to "Geo". I need to narrow it down but I don't really know what I am >> looking for. >> >> I found this: >> >> >> >> On Mon, 26 Oct 2020 at 13:57, Dominic Amann <[hidden email]> >> wrote: >> >>> I can confirm that values were loaded from the relevant xml file for my >>> country. >>> >>> Beginning import from URL: >>> file:/var/www/apache-ofbiz-17.12.04/framework/common >>> /data/GeoData_CA.xml >>> 2020-10-26 17:27:43,384 |main |EntitySaxReader >>> |I| >>> Transaction Timeout set to 2 hours (7200 seconds) >>> 2020-10-26 17:27:43,424 |main |EntitySaxReader >>> |I| >>> Finished 26 values from >>> file:/var/www/apache-ofbiz-17.12.04/framework/common/da >>> ta/GeoData_CA.xml >>> >>> On Mon, 26 Oct 2020 at 13:25, Dominic Amann <[hidden email]> >>> wrote: >>> >>>> Yes, the data is there (in XML). I guess I need to go poking around in >>>> the database to find out if it got into there during setup? Or >>>> perhaps check the pages of output during the "./gradlew loadAll " step... >>>> I'll do the latter first. >>>> >>>> On Mon, 26 Oct 2020 at 13:11, Jason RJ <[hidden email]> wrote: >>>> >>>>> Hi Dominic, >>>>> >>>>> Province data and similar locality data is part of the seed data and >>>>> loaded from the /framework/common/data/Geo*.xml files you should be >>>>> able >>>>> to spot that being loaded in your initial setup log output. It's been >>>>> a >>>>> while since I've spun up a clean instance, but the data is certainly >>>>> there so it's just not being loaded for some reason. >>>>> >>>>> Hope that helps, >>>>> >>>>> Jason >>>>> >>>>> >>>>> On 26/10/2020 16:55, Dominic Amann wrote: >>>>> > I am attempting to setup OFBiz for my business. >>>>> > >>>>> > I am a Linux developer of many years experience. >>>>> > >>>>> > I wanted a secure (SSL) setup, and I thought I would use Mariadb as I >>>>> > already use that for other software, and I would avoid duplication >>>>> with >>>>> > another database. I stretched this further by wanting to have no >>>>> demo data. >>>>> > >>>>> > I found it very difficult to accomplish all this. Much more >>>>> difficult than >>>>> > I might have expected for a major apache project. However, I >>>>> persevered, >>>>> > and after a whole weekend of work, I got it working to a first >>>>> order. I >>>>> > have documented each step I took. >>>>> > >>>>> > HOWEVER: >>>>> > >>>>> > I CANNOT ADD A PARTY MAILING ADDRESS. There are no provinces listed >>>>> for >>>>> > Canada. There are no states listed for the USA. I don't know other >>>>> > countries intimately, so I can't speak for them. As a result of being >>>>> > incomplete, I cannot add addresses at all. >>>>> > >>>>> > I initially thought this must be because I did not use the demo >>>>> data. So, I >>>>> > repeated my work, but left the demo data in place. SAME PROBLEM. >>>>> > >>>>> > Then I thought that perhaps I should do the migration (to Mysql) >>>>> AFTER >>>>> > setting up the initial data. That was BROKEN and wouldn't complete on >>>>> > import, and the resulting website wouldn't display properly. >>>>> > >>>>> > Then I thought it might be the database - perhaps it doesn't work >>>>> with >>>>> > mysql. I would just do the straightforward install, and work with >>>>> that. >>>>> > SAME PROBLEM. >>>>> > >>>>> > So here we are: 3 full days and I can't enter my first employee, >>>>> even with >>>>> > the simplest install with default settings. Of course there is one >>>>> > fundamental lesson here: never just believe that something works just >>>>> > because it is from a reputable project that has been out there for >>>>> years. I >>>>> > should have known better. >>>>> > >>>>> >>>> >>>> >>>> -- >>>> >>>> >>>> Dominic Amann >>>> >>>> M 416-270-4587 >>>> >>> >>> >>> -- >>> >>> >>> Dominic Amann >>> >>> M 416-270-4587 >>> >> >> >> -- >> >> >> Dominic Amann >> >> M 416-270-4587 >> > > > -- > > > Dominic Amann > > M 416-270-4587 > -- Dominic Amann M 416-270-4587 |
|
|
In reply to this post by Georg Potthast 2
Georg Potthast-2 wrote
> You can use Webtools to see the data related to each entity in the > database. Yes, thanks. I found the relevant entities - in the database. But the field still want bring up the states/provinces, so I can't add addresses. Even the demo data won't show the state (in the update screen), only in the display screen. -- Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |