Re: Hello3-error while loading seed data
Sorry for the noise. I was redirecting to the user mailing list. Thanks and Regards, *Aditya Sharma* | Enterprise Software Engineer HotWax Systems <http://www.hotwaxsystems.com/> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore, M.P 452010 Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/> On Mon, Apr 29, 2019 at 6:41 PM Aditya Sharma < aditya.sha...@hotwaxsystems.com> wrote: > Hi Arshitha, > > It would be better if you could please subscribe to user ML first. > See also why here http://ofbiz.apache.org/mailing-lists.html > > > Please check the database for the table definition. > > Thanks and Regards, > *Aditya Sharma* | Enterprise Software Engineer > HotWax Systems <http://www.hotwaxsystems.com/> > Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, > Indore, M.P 452010 > Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/> > > > > On Mon, Apr 29, 2019 at 6:35 PM Arshitha K M wrote: > >> Hello Aditya Sharma, >> thank you for your email, I have checked the entity definition nothing >> found as you mentioned in your mail. >> Best regards, >> Arshitha K.M >> >> >> >> >> On Mon 29 Apr, 2019, 3:47 PM Aditya Sharma, < >> aditya.sha...@hotwaxsystems.com> wrote: >> >>> Hi Arshitha, >>> >>> I suspect that either you have defined the entity at two places or maybe >>> previously you had an entity with the same name but with field >>> HelloHobbyId as "not null". >>> >>> HTH >>> >>> Thanks and Regards, >>> *Aditya Sharma* | Enterprise Software Engineer >>> HotWax Systems <http://www.hotwaxsystems.com/> >>> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, >>> Indore, M.P 452010 >>> Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/> >>> >>> >>> >>> On Mon, Apr 29, 2019 at 3:30 PM Jacques Le Roux < >>> jacques.le.r...@les7arts.com> wrote: >>> >>>> Hi, >>>> >>>> Your message has been moderated. >>>> >>>> Please subscribe to the user ML for such questions and then use your >>>> email client >>>> See also why here http://ofbiz.apache.org/mailing-lists.html >>>> >>>> You will get a better support , it's more fair to share with everybody >>>> and people can answer you on the ML rather than directly to you >>>> The wider the audience the better the answers you might get >>>> >>>> Also it's more work for moderators who have to accept your messages as >>>> long as you have not subscribed. >>>> I'll personally no longer accept them (other moderators still could) >>>> >>>> Thanks >>>> >>>> Jacques >>>> >>>> Le 29/04/2019 à 09:45, Arshitha K M a écrit : >>>> > hi, >>>> > I am new to ofbiz. I met trouble during loading the seed >>>> data(hello3), >>>> > >>>> > The Following Errors Occurred: >>>> > ERROR: parsing file: ERROR parsing Entity Xml file: >>>> > org.xml.sax.SAXException: A transaction error occurred reading >>>> > dataorg.ofbiz.entity.GenericEntityException: >>>> > org.ofbiz.entity.GenericEntityException: >>>> > org.ofbiz.entity.GenericEntityException: Error while inserting: >>>> > [GenericEntity:HelloHobby][createdStamp,2019-04-29 >>>> > 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29 >>>> > >>>> 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29 >>>> > 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29 >>>> > 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the >>>> > following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION, >>>> > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, >>>> CREATED_TX_STAMP) >>>> > VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a >>>> NULL >>>> > value.)) >>>> > the entity i want to load seed data is having only two columns >>>> HelloHobbyId >>>> > and Description,i did'nt get that,why error message showing as >>>> > 'HelloPersonId' cannot accept a null value. >>>> > >>>> > I tried to load seed data into another entity HelloPerson and that was >>>> > successful. >>>> > Could you please help me to fix the error. >>>> > >>>> >>>
Re: Hello3-error while loading seed data
Hi Arshita, Could you please share the entity definitions? If you are modifying entity definition, please make sure to alter the database table. As ofbiz does not alter the table if pk is added or modified, or column size changed. You need to run a manual query to alter the table. Kind Regards, Deepak Dixit DIRECTOR OF PRODUCT ENGINEERING mobile: +91 9826754548 email: deepak.di...@hotwax.co *www.hotwax.co <http://www.hotwax.co/>* On Mon, Apr 29, 2019 at 3:47 PM Aditya Sharma < aditya.sha...@hotwaxsystems.com> wrote: > Hi Arshitha, > > I suspect that either you have defined the entity at two places or maybe > previously you had an entity with the same name but with field > HelloHobbyId as "not null". > > HTH > > Thanks and Regards, > *Aditya Sharma* | Enterprise Software Engineer > HotWax Systems <http://www.hotwaxsystems.com/> > Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, > Indore, > M.P 452010 > Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/> > > > > On Mon, Apr 29, 2019 at 3:30 PM Jacques Le Roux < > jacques.le.r...@les7arts.com> wrote: > > > Hi, > > > > Your message has been moderated. > > > > Please subscribe to the user ML for such questions and then use your > email > > client > > See also why here http://ofbiz.apache.org/mailing-lists.html > > > > You will get a better support , it's more fair to share with everybody > > and people can answer you on the ML rather than directly to you > > The wider the audience the better the answers you might get > > > > Also it's more work for moderators who have to accept your messages as > > long as you have not subscribed. > > I'll personally no longer accept them (other moderators still could) > > > > Thanks > > > > Jacques > > > > Le 29/04/2019 à 09:45, Arshitha K M a écrit : > > > hi, > > > I am new to ofbiz. I met trouble during loading the seed data(hello3), > > > > > > The Following Errors Occurred: > > > ERROR: parsing file: ERROR parsing Entity Xml file: > > > org.xml.sax.SAXException: A transaction error occurred reading > > > dataorg.ofbiz.entity.GenericEntityException: > > > org.ofbiz.entity.GenericEntityException: > > > org.ofbiz.entity.GenericEntityException: Error while inserting: > > > [GenericEntity:HelloHobby][createdStamp,2019-04-29 > > > 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29 > > > > > > 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29 > > > 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29 > > > 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the > > > following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION, > > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > > CREATED_TX_STAMP) > > > VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a > NULL > > > value.)) > > > the entity i want to load seed data is having only two columns > > HelloHobbyId > > > and Description,i did'nt get that,why error message showing as > > > 'HelloPersonId' cannot accept a null value. > > > > > > I tried to load seed data into another entity HelloPerson and that was > > > successful. > > > Could you please help me to fix the error. > > > > > >
Re: Hello3-error while loading seed data
Hi Arshitha, I suspect that either you have defined the entity at two places or maybe previously you had an entity with the same name but with field HelloHobbyId as "not null". HTH Thanks and Regards, *Aditya Sharma* | Enterprise Software Engineer HotWax Systems <http://www.hotwaxsystems.com/> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore, M.P 452010 Linkedin: *Aditya Sharma* <https://www.linkedin.com/in/aditya-p-sharma/> On Mon, Apr 29, 2019 at 3:30 PM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi, > > Your message has been moderated. > > Please subscribe to the user ML for such questions and then use your email > client > See also why here http://ofbiz.apache.org/mailing-lists.html > > You will get a better support , it's more fair to share with everybody > and people can answer you on the ML rather than directly to you > The wider the audience the better the answers you might get > > Also it's more work for moderators who have to accept your messages as > long as you have not subscribed. > I'll personally no longer accept them (other moderators still could) > > Thanks > > Jacques > > Le 29/04/2019 à 09:45, Arshitha K M a écrit : > > hi, > > I am new to ofbiz. I met trouble during loading the seed data(hello3), > > > > The Following Errors Occurred: > > ERROR: parsing file: ERROR parsing Entity Xml file: > > org.xml.sax.SAXException: A transaction error occurred reading > > dataorg.ofbiz.entity.GenericEntityException: > > org.ofbiz.entity.GenericEntityException: > > org.ofbiz.entity.GenericEntityException: Error while inserting: > > [GenericEntity:HelloHobby][createdStamp,2019-04-29 > > 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29 > > > 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29 > > 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29 > > 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the > > following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION, > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_TX_STAMP) > > VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL > > value.)) > > the entity i want to load seed data is having only two columns > HelloHobbyId > > and Description,i did'nt get that,why error message showing as > > 'HelloPersonId' cannot accept a null value. > > > > I tried to load seed data into another entity HelloPerson and that was > > successful. > > Could you please help me to fix the error. > > >
Re: Hello3-error while loading seed data
Hi, Your message has been moderated. Please subscribe to the user ML for such questions and then use your email client See also why here http://ofbiz.apache.org/mailing-lists.html You will get a better support , it's more fair to share with everybody and people can answer you on the ML rather than directly to you The wider the audience the better the answers you might get Also it's more work for moderators who have to accept your messages as long as you have not subscribed. I'll personally no longer accept them (other moderators still could) Thanks Jacques Le 29/04/2019 à 09:45, Arshitha K M a écrit : hi, I am new to ofbiz. I met trouble during loading the seed data(hello3), The Following Errors Occurred: ERROR: parsing file: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading dataorg.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:HelloHobby][createdStamp,2019-04-29 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.)) the entity i want to load seed data is having only two columns HelloHobbyId and Description,i did'nt get that,why error message showing as 'HelloPersonId' cannot accept a null value. I tried to load seed data into another entity HelloPerson and that was successful. Could you please help me to fix the error.
Re: Hello3-error while loading seed data
Please check your entity definition and compare that against what you want to inject in the table. Best regards, Pierre Smits *Apache Trafodion <https://trafodion.apache.org>, Vice President* *Apache Directory <https://directory.apache.org>, PMC Member* Apache Incubator <https://incubator.apache.org>, committer *Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges) since 2008* Apache Steve <https://steve.apache.org>, committer On Mon, Apr 29, 2019 at 11:24 AM Arshitha K M wrote: > hi, > I am new to ofbiz. I met trouble during loading the seed data(hello3), > > The Following Errors Occurred: > ERROR: parsing file: ERROR parsing Entity Xml file: > org.xml.sax.SAXException: A transaction error occurred reading > dataorg.ofbiz.entity.GenericEntityException: > org.ofbiz.entity.GenericEntityException: > org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:HelloHobby][createdStamp,2019-04-29 > 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29 > > 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29 > 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29 > 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the > following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) > VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL > value.)) > the entity i want to load seed data is having only two columns HelloHobbyId > and Description,i did'nt get that,why error message showing as > 'HelloPersonId' cannot accept a null value. > > I tried to load seed data into another entity HelloPerson and that was > successful. > Could you please help me to fix the error. >
Hello3-error while loading seed data
hi, I am new to ofbiz. I met trouble during loading the seed data(hello3), The Following Errors Occurred: ERROR: parsing file: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading dataorg.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:HelloHobby][createdStamp,2019-04-29 12:59:49.86(java.sql.Timestamp)][createdTxStamp,2019-04-29 12:59:49.82(java.sql.Timestamp)][description,Reading(java.lang.String)][helloHobbyId,READING(java.lang.String)][lastUpdatedStamp,2019-04-29 12:59:49.86(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-29 12:59:49.82(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.HELLO_HOBBY (HELLO_HOBBY_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Column 'HELLO_PERSON_ID' cannot accept a NULL value.)) the entity i want to load seed data is having only two columns HelloHobbyId and Description,i did'nt get that,why error message showing as 'HelloPersonId' cannot accept a null value. I tried to load seed data into another entity HelloPerson and that was successful. Could you please help me to fix the error.
Re: Seed Data
Le 09/02/2018 à 02:18, Mike a écrit : Best practices was to create all your seed data in hot-deploy and load custom data using ONLY xml seed data. Almost, better to have this data differentiated from seed as "ext" data. See entity-data-reader in framework/entity/config/entityengine.xml HTH Jacques
Re: Seed Data
It can be done, and it'll be real tricky. Best practices was to create all your seed data in hot-deploy and load custom data using ONLY xml seed data. If you needed to edit (i.e. via the GUI), track down the change you made and edit an existing xml file (or create a new one) in hot-deploy that matches the edit. There are enough examples in demo to load any sort of data you need. If you have been making dozens of config changes via the GUI and NOW you want to start with empty accounting, then you might be in for a LOT of work. It IS possible, but you'll be spending countless hours tracing down the dependencies. You can try to delete a record via SQL using recursive or cascade options, but it may end up deleting data you want/need. Make a backup. On Thu, Feb 8, 2018 at 12:29 AM, wrote: > Hi we are trying to delete all transactional data, inventory data, and > other items only leaving parties and financial set up data. Is there > any issue in writing a script to delete all data? Should we be > concerned with breaking any dependencies? Any best practices for doing > this? > > Thanks, > > James >
Seed Data
Hi we are trying to delete all transactional data, inventory data, and other items only leaving parties and financial set up data. Is there any issue in writing a script to delete all data? Should we be concerned with breaking any dependencies? Any best practices for doing this? Thanks, James
Re: Seed data
James, As Deepak mentioned use different readers for your application and put your own data files on custom readers. Edit the data to as per your requirement and load. Rishi Solanki Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxsystems.com www.hotwax.co On Tue, Aug 22, 2017 at 6:51 PM, wrote: > How do others launch a live database with much of the chart of account > mapping complete? Even if there are customers that can be deleted we > would need no transactional data in the system > > Original Message > Subject: Re: Seed data > From: Deepak Dixit > Date: Tue, August 22, 2017 5:26 am > To: user@ofbiz.apache.org > > Hi James, > > You can use readers to load data as required. You can define your own > readers for custom component. > gradlew "ofbiz --load-data readers=seed,seed-initial,ext" > > > Thanks & Regards > -- > Deepak Dixit > www.hotwaxsystems.com > www.hotwax.co > > On Mon, Aug 21, 2017 at 10:00 PM, wrote: > > > Is it possible to upload seed data with all configurations except > > products, purchase orders, customers, and vendors. > > > > Thanks, > > > > James > > >
RE: Seed data (Best Practices)
Is there a best practice document that installs the system with the demo data then allows you to remove all transactional data? My main concern is to already have the GL Account mappings done and then we can just replace the name of the GLs instead of going through a financial mapping from scratch? Any help is greatly appreciated Original Message Subject: RE: Seed data From: Date: Tue, August 22, 2017 6:21 am To: user@ofbiz.apache.org How do others launch a live database with much of the chart of account mapping complete? Even if there are customers that can be deleted we would need no transactional data in the system Original Message Subject: Re: Seed data From: Deepak Dixit Date: Tue, August 22, 2017 5:26 am To: user@ofbiz.apache.org Hi James, You can use readers to load data as required. You can define your own readers for custom component. gradlew "ofbiz --load-data readers=seed,seed-initial,ext" Thanks & Regards -- Deepak Dixit www.hotwaxsystems.com www.hotwax.co On Mon, Aug 21, 2017 at 10:00 PM, wrote: > Is it possible to upload seed data with all configurations except > products, purchase orders, customers, and vendors. > > Thanks, > > James >
RE: Seed data
How do others launch a live database with much of the chart of account mapping complete? Even if there are customers that can be deleted we would need no transactional data in the system Original Message Subject: Re: Seed data From: Deepak Dixit Date: Tue, August 22, 2017 5:26 am To: user@ofbiz.apache.org Hi James, You can use readers to load data as required. You can define your own readers for custom component. gradlew "ofbiz --load-data readers=seed,seed-initial,ext" Thanks & Regards -- Deepak Dixit www.hotwaxsystems.com www.hotwax.co On Mon, Aug 21, 2017 at 10:00 PM, wrote: > Is it possible to upload seed data with all configurations except > products, purchase orders, customers, and vendors. > > Thanks, > > James >
Re: Seed data
Hi James, You can use readers to load data as required. You can define your own readers for custom component. gradlew "ofbiz --load-data readers=seed,seed-initial,ext" Thanks & Regards -- Deepak Dixit www.hotwaxsystems.com www.hotwax.co On Mon, Aug 21, 2017 at 10:00 PM, wrote: > Is it possible to upload seed data with all configurations except > products, purchase orders, customers, and vendors. > > Thanks, > > James >
Re: Seed data
Those are files in the ofbiz-component.xml files that you cant find in the concerned components. It clearly depends on your need so I let you decide on this... Jacques Le 22/08/2017 à 13:53, ja...@productive1.com a écrit : Jaques - Do you have the file names we should comment out? Original Message Subject: Re: Seed data From: Jacques Le Roux Date: Mon, August 21, 2017 10:48 am To: user@ofbiz.apache.org By commenting them out in ofbiz-component files yes. I see no other ways Jacques Le 21/08/2017 à 18:30, ja...@productive1.com a écrit : Is it possible to upload seed data with all configurations except products, purchase orders, customers, and vendors. Thanks, James
RE: Seed data
Jaques - Do you have the file names we should comment out? Original Message Subject: Re: Seed data From: Jacques Le Roux Date: Mon, August 21, 2017 10:48 am To: user@ofbiz.apache.org By commenting them out in ofbiz-component files yes. I see no other ways Jacques Le 21/08/2017 à 18:30, ja...@productive1.com a écrit : > Is it possible to upload seed data with all configurations except > products, purchase orders, customers, and vendors. > > Thanks, > > James >
Re: Seed data
By commenting them out in ofbiz-component files yes. I see no other ways Jacques Le 21/08/2017 à 18:30, ja...@productive1.com a écrit : Is it possible to upload seed data with all configurations except products, purchase orders, customers, and vendors. Thanks, James
Seed data
Is it possible to upload seed data with all configurations except products, purchase orders, customers, and vendors. Thanks, James
Re: Accounting seed data for Canada
Hi Parminder As far as I know I don't think we do (but maybe we have a Canadian user that has already setup OFBiz that can respond to you :-) Otherwise our main demo accounting master template is US based but can be tailored or even replaced with whatever you need. I'm not sure what the Canadian requirements are but if you are talking about grouping of accounts into a specific coding structure for reporting then perhaps take a look at USTaxAccountGroups.xml (extracted a few lines from the file we include with OFBiz below) and create a Canadian version Another option could be to include a categorisation on the GL Account itself.. Hope this helps. Thanks Sharan On 2017-06-12 23:18 (+0200), "Parminder S. Lehal" wrote: > Is there accounting seed data available for Canadian CRA including GIFI > codes?
Accounting seed data for Canada
Is there accounting seed data available for Canadian CRA including GIFI codes?
Re: Trying to use seed data
You do not get any user accounts or seed data if you run: ./ant run-install-extseed So to add accounts, you can run: run ./ant create-admin-user-login And enter the username of the account you want to create. The default password is ofbiz and it will prompt you to change it on login. Then start OfBiz: ./ant run Tim Stoel > From: Jackie Gleason > Reply-To: "user@ofbiz.apache.org" > Date: Wed, 17 Aug 2011 15:27:15 -0400 > To: "user@ofbiz.apache.org" > Subject: Trying to use seed data > > So when I load Seed Data, I get a user not found error. Am I doing something > wrong? Does seed data not include users? Do I need to use a full install w/ > demo data to get users? How do I set up a new user if I don't want to > install demo data? > > Thanks
Trying to use seed data
So when I load Seed Data, I get a user not found error. Am I doing something wrong? Does seed data not include users? Do I need to use a full install w/ demo data to get users? How do I set up a new user if I don't want to install demo data? Thanks
Re: every web appl has a 'websiteId' in the seed data why?
in Tenant you would need a property for each tenant. you can not change the the property default on the fly like you can using the website.visualThemeSetId to let that happen. So the Themes selection would not work. I personally would like to see the visualThemeSetId moved to preferences. it is good to have the property as default if the website has not been added. the WebsiteID in xml is used to find the productstore. to try this out change the website ID and restart then go to the ecommerce site. for the backend the productstore is used also. Hans Bakker sent the following on 8/2/2011 9:58 AM: > Ok I did some more study... > > the website records are not required unless a related productStore is > required. > > we even could go that far to say that the websiteId in the web.xml is > not required if the WebSite record is removed. > > Further I do not see a relation between Tenant and WebSite > > Nothing to do with general properties, what i said earlier, in there is > the VISUAL_THEME and not the VISUAL_THEME_SET > > So let me know if somebody had any other objections removing the Website > record in all backend webapps. > > Regards, > Hans > > On Tue, 2011-08-02 at 14:19 +0700, Hans Bakker wrote: >> I looked in the emaillist history and the only reason that came up is >> the definition of the theme. (i missed that thread) >> >> However, >> most webapps are backend applications which can use the general >> properties file when the website record is missing. >> >> The reason i want it removed is that in a production environment the >> website list is pretty long so it is difficult to find a website which >> is really used. >> >> Therefore my proposal to remove the website records for all back end >> webapplications and the trunk front end should be demo data. >> >> Regards, >> Hans >> >> >> On Tue, 2011-08-02 at 00:11 -0700, BJ Freeman wrote: >>> I ask this on the Dev a few months ago, Erwan de FERRIERES told me this >>> is why. >>> I am assuming that in a tenant mode this adds more flexibility. >>> >>> Hans Bakker sent the following on 8/1/2011 10:52 PM: We have a default theme in general.properties so website record not mandatory? On Mon, 2011-08-01 at 22:19 -0700, BJ Freeman wrote: > visualThemeSetId="BACKOFFICE"/> > > > Hans Bakker sent the following on 8/1/2011 8:38 PM: >> We are now using the content part of the system more and more and are >> wondering why every webapp has its website? >> >> I deleted in webtools the website for accounting and everything seems to >> be still working ok. >> >> If there are no good reasons to keep it i would like to suggest to >> remove all these websites except for cmssite, WebStore and WebStoreClone >> and move these to the demo data. >> >> regards, >> Hans >> >> >
Re: every web appl has a 'websiteId' in the seed data why?
The websiteId in the web.xml files was a good information to have... (I mean to know that it can be used from there) Jacques From: "Hans Bakker" Ok I did some more study... the website records are not required unless a related productStore is required. we even could go that far to say that the websiteId in the web.xml is not required if the WebSite record is removed. Further I do not see a relation between Tenant and WebSite Nothing to do with general properties, what i said earlier, in there is the VISUAL_THEME and not the VISUAL_THEME_SET So let me know if somebody had any other objections removing the Website record in all backend webapps. Regards, Hans On Tue, 2011-08-02 at 14:19 +0700, Hans Bakker wrote: I looked in the emaillist history and the only reason that came up is the definition of the theme. (i missed that thread) However, most webapps are backend applications which can use the general properties file when the website record is missing. The reason i want it removed is that in a production environment the website list is pretty long so it is difficult to find a website which is really used. Therefore my proposal to remove the website records for all back end webapplications and the trunk front end should be demo data. Regards, Hans On Tue, 2011-08-02 at 00:11 -0700, BJ Freeman wrote: > I ask this on the Dev a few months ago, Erwan de FERRIERES told me this > is why. > I am assuming that in a tenant mode this adds more flexibility. > > Hans Bakker sent the following on 8/1/2011 10:52 PM: > > We have a default theme in general.properties so website record not > > mandatory? > > > > On Mon, 2011-08-01 at 22:19 -0700, BJ Freeman wrote: > >> >> visualThemeSetId="BACKOFFICE"/> > >> > >> > >> Hans Bakker sent the following on 8/1/2011 8:38 PM: > >>> We are now using the content part of the system more and more and are > >>> wondering why every webapp has its website? > >>> > >>> I deleted in webtools the website for accounting and everything seems to > >>> be still working ok. > >>> > >>> If there are no good reasons to keep it i would like to suggest to > >>> remove all these websites except for cmssite, WebStore and WebStoreClone > >>> and move these to the demo data. > >>> > >>> regards, > >>> Hans > >>> > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates.
Re: every web appl has a 'websiteId' in the seed data why?
Ok I did some more study... the website records are not required unless a related productStore is required. we even could go that far to say that the websiteId in the web.xml is not required if the WebSite record is removed. Further I do not see a relation between Tenant and WebSite Nothing to do with general properties, what i said earlier, in there is the VISUAL_THEME and not the VISUAL_THEME_SET So let me know if somebody had any other objections removing the Website record in all backend webapps. Regards, Hans On Tue, 2011-08-02 at 14:19 +0700, Hans Bakker wrote: > I looked in the emaillist history and the only reason that came up is > the definition of the theme. (i missed that thread) > > However, > most webapps are backend applications which can use the general > properties file when the website record is missing. > > The reason i want it removed is that in a production environment the > website list is pretty long so it is difficult to find a website which > is really used. > > Therefore my proposal to remove the website records for all back end > webapplications and the trunk front end should be demo data. > > Regards, > Hans > > > On Tue, 2011-08-02 at 00:11 -0700, BJ Freeman wrote: > > I ask this on the Dev a few months ago, Erwan de FERRIERES told me this > > is why. > > I am assuming that in a tenant mode this adds more flexibility. > > > > Hans Bakker sent the following on 8/1/2011 10:52 PM: > > > We have a default theme in general.properties so website record not > > > mandatory? > > > > > > On Mon, 2011-08-01 at 22:19 -0700, BJ Freeman wrote: > > >> > >> visualThemeSetId="BACKOFFICE"/> > > >> > > >> > > >> Hans Bakker sent the following on 8/1/2011 8:38 PM: > > >>> We are now using the content part of the system more and more and are > > >>> wondering why every webapp has its website? > > >>> > > >>> I deleted in webtools the website for accounting and everything seems to > > >>> be still working ok. > > >>> > > >>> If there are no good reasons to keep it i would like to suggest to > > >>> remove all these websites except for cmssite, WebStore and WebStoreClone > > >>> and move these to the demo data. > > >>> > > >>> regards, > > >>> Hans > > >>> > > > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates.
Re: every web appl has a 'websiteId' in the seed data why?
I know you used the web.xml to put in virtual host, but I opted to us the website entity for the same reason of tenants. this does not effect the trunk, but would conflict if websites were removed in commits. I hope what ever your doing take tenants into account. How ever a Tenant data load would allow for both to exist. That is where I put my tenant specific stuff. Hans Bakker sent the following on 8/2/2011 12:19 AM: > I looked in the emaillist history and the only reason that came up is > the definition of the theme. (i missed that thread) > > However, > most webapps are backend applications which can use the general > properties file when the website record is missing. > > The reason i want it removed is that in a production environment the > website list is pretty long so it is difficult to find a website which > is really used. > > Therefore my proposal to remove the website records for all back end > webapplications and the trunk front end should be demo data. > > Regards, > Hans > > > On Tue, 2011-08-02 at 00:11 -0700, BJ Freeman wrote: >> I ask this on the Dev a few months ago, Erwan de FERRIERES told me this >> is why. >> I am assuming that in a tenant mode this adds more flexibility. >> >> Hans Bakker sent the following on 8/1/2011 10:52 PM: >>> We have a default theme in general.properties so website record not >>> mandatory? >>> >>> On Mon, 2011-08-01 at 22:19 -0700, BJ Freeman wrote: >>> visualThemeSetId="BACKOFFICE"/> Hans Bakker sent the following on 8/1/2011 8:38 PM: > We are now using the content part of the system more and more and are > wondering why every webapp has its website? > > I deleted in webtools the website for accounting and everything seems to > be still working ok. > > If there are no good reasons to keep it i would like to suggest to > remove all these websites except for cmssite, WebStore and WebStoreClone > and move these to the demo data. > > regards, > Hans > >>> >
Re: every web appl has a 'websiteId' in the seed data why?
I have the same opinion. The website data are useful for theme with tenant but not on seed data. Nicolas Le 02/08/2011 09:19, Hans Bakker a écrit : I looked in the emaillist history and the only reason that came up is the definition of the theme. (i missed that thread) However, most webapps are backend applications which can use the general properties file when the website record is missing. The reason i want it removed is that in a production environment the website list is pretty long so it is difficult to find a website which is really used. Therefore my proposal to remove the website records for all back end webapplications and the trunk front end should be demo data. Regards, Hans On Tue, 2011-08-02 at 00:11 -0700, BJ Freeman wrote: I ask this on the Dev a few months ago, Erwan de FERRIERES told me this is why. I am assuming that in a tenant mode this adds more flexibility. Hans Bakker sent the following on 8/1/2011 10:52 PM: We have a default theme in general.properties so website record not mandatory? On Mon, 2011-08-01 at 22:19 -0700, BJ Freeman wrote: Hans Bakker sent the following on 8/1/2011 8:38 PM: We are now using the content part of the system more and more and are wondering why every webapp has its website? I deleted in webtools the website for accounting and everything seems to be still working ok. If there are no good reasons to keep it i would like to suggest to remove all these websites except for cmssite, WebStore and WebStoreClone and move these to the demo data. regards, Hans -- Nicolas MALIN Consultant Tél : 06.17.66.40.06 Site projet : http://www.neogia.org/ --- Société LibrenBerry Tél : 02.48.02.56.12 Site : http://www.librenberry.net/
Re: every web appl has a 'websiteId' in the seed data why?
I looked in the emaillist history and the only reason that came up is the definition of the theme. (i missed that thread) However, most webapps are backend applications which can use the general properties file when the website record is missing. The reason i want it removed is that in a production environment the website list is pretty long so it is difficult to find a website which is really used. Therefore my proposal to remove the website records for all back end webapplications and the trunk front end should be demo data. Regards, Hans On Tue, 2011-08-02 at 00:11 -0700, BJ Freeman wrote: > I ask this on the Dev a few months ago, Erwan de FERRIERES told me this > is why. > I am assuming that in a tenant mode this adds more flexibility. > > Hans Bakker sent the following on 8/1/2011 10:52 PM: > > We have a default theme in general.properties so website record not > > mandatory? > > > > On Mon, 2011-08-01 at 22:19 -0700, BJ Freeman wrote: > >> >> visualThemeSetId="BACKOFFICE"/> > >> > >> > >> Hans Bakker sent the following on 8/1/2011 8:38 PM: > >>> We are now using the content part of the system more and more and are > >>> wondering why every webapp has its website? > >>> > >>> I deleted in webtools the website for accounting and everything seems to > >>> be still working ok. > >>> > >>> If there are no good reasons to keep it i would like to suggest to > >>> remove all these websites except for cmssite, WebStore and WebStoreClone > >>> and move these to the demo data. > >>> > >>> regards, > >>> Hans > >>> > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates.
Re: every web appl has a 'websiteId' in the seed data why?
I ask this on the Dev a few months ago, Erwan de FERRIERES told me this is why. I am assuming that in a tenant mode this adds more flexibility. Hans Bakker sent the following on 8/1/2011 10:52 PM: > We have a default theme in general.properties so website record not > mandatory? > > On Mon, 2011-08-01 at 22:19 -0700, BJ Freeman wrote: >> > visualThemeSetId="BACKOFFICE"/> >> >> >> Hans Bakker sent the following on 8/1/2011 8:38 PM: >>> We are now using the content part of the system more and more and are >>> wondering why every webapp has its website? >>> >>> I deleted in webtools the website for accounting and everything seems to >>> be still working ok. >>> >>> If there are no good reasons to keep it i would like to suggest to >>> remove all these websites except for cmssite, WebStore and WebStoreClone >>> and move these to the demo data. >>> >>> regards, >>> Hans >>> >
Re: every web appl has a 'websiteId' in the seed data why?
We have a default theme in general.properties so website record not mandatory? On Mon, 2011-08-01 at 22:19 -0700, BJ Freeman wrote: > visualThemeSetId="BACKOFFICE"/> > > > Hans Bakker sent the following on 8/1/2011 8:38 PM: > > We are now using the content part of the system more and more and are > > wondering why every webapp has its website? > > > > I deleted in webtools the website for accounting and everything seems to > > be still working ok. > > > > If there are no good reasons to keep it i would like to suggest to > > remove all these websites except for cmssite, WebStore and WebStoreClone > > and move these to the demo data. > > > > regards, > > Hans > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates.
Re: every web appl has a 'websiteId' in the seed data why?
Hans Bakker sent the following on 8/1/2011 8:38 PM: > We are now using the content part of the system more and more and are > wondering why every webapp has its website? > > I deleted in webtools the website for accounting and everything seems to > be still working ok. > > If there are no good reasons to keep it i would like to suggest to > remove all these websites except for cmssite, WebStore and WebStoreClone > and move these to the demo data. > > regards, > Hans >
every web appl has a 'websiteId' in the seed data why?
We are now using the content part of the system more and more and are wondering why every webapp has its website? I deleted in webtools the website for accounting and everything seems to be still working ok. If there are no good reasons to keep it i would like to suggest to remove all these websites except for cmssite, WebStore and WebStoreClone and move these to the demo data. regards, Hans -- http://www.antwebsystems.com : Quality OFBiz support for competitive rates
Re: Customizing seed data
in every folder there is ofbiz-component.xml in it is a list of the seed data files for each folder. look for reader-name="seed" = BJ Freeman Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Doaa Abd El-Hady sent the following on 12/30/2010 1:32 AM: Please I need to know where can I get the seed data files and change it?
Re: Customizing seed data
They are under 'data' folder of every application. HTH On Thu, Dec 30, 2010 at 10:32 AM, Doaa Abd El-Hady < engdoaa.abdelh...@yahoo.com> wrote: > > Please I need to know where can I get the seed data files and change it? > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Customizing-seed-data-tp2250144p3168075.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > -- - Jonatan Soto
Re: Customizing seed data
Please I need to know where can I get the seed data files and change it? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Customizing-seed-data-tp2250144p3168075.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Customizing seed data
Thanks for your help Abhai, much appreciated! On Wed, Jun 16, 2010 at 6:13 PM, Abhai Chaudhary < abhai_chaudh...@mindtree.com> wrote: > I came across a similar scenario when business decision was taken to not to > use parts of inventory, parts of accounting and entire fulfillment > applications of Ofbiz and using only the e-commerce (Order, PO and Product > modules apart from general framework). We decided to integrate Ofbiz with > third party commercial solutions in real time for our inventory and > accounting needs. This was challenging as modules we were intending to use > had lot of dependencies on other modules by the way of data processing and > ECA's. My advice, if you do not want to use a particular module or some > data, follow the procedure > > 1) Identify the entities you are using > 2) Examine the seed data related to those entities, remove the instance > data and NOT the entity definition data (usually available in > "*typedata.xml"). > 3) Make sure you do not touch *typedata.xml" or any setup data, if you make > a mistake here, there are high chances you may end up in failing ECA's > 4) Examine the services you are using and associated ECA's, if required > disable those ECA's (Important when you do not want to use a module linked > thru ECA's) >(Example, while receiving the inventory, there are a few accounting > entries created, so you have dependency on accounting setup data. Solution, > provide the data or disable the ECA, though I would avoid disabling the ECA > unless I am very sure it does not impact any other use case). > 5) If you add yr business specific entity attributes, extend the entity > rather than adding the attribute to default schema. > > > -Abhai > > > -Original Message- > From: BJ Freeman [mailto:bjf...@free-man.net] > Sent: Thursday, June 10, 2010 6:13 AM > To: user@ofbiz.apache.org > Subject: Re: Customizing seed data > > from a maintainence point of view you would have to do that every time > you upgraded the code since the update would overwrite all your mods. > Unless there is something that may cause confusion I just leave it in. > > > > = > BJ Freeman > http://bjfreeman.elance.com > Strategic Power Office with Supplier Automation < > http://www.businessesnetwork.com/automation/viewforum.php?f=52> > Specialtymarket.com <http://www.specialtymarket.com/> > > Systems Integrator-- Glad to Assist > > Chat Y! messenger: bjfr33man > Linkedin > < > http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro > > > > > Jonatan Soto sent the following on 6/10/2010 2:20 AM: > > Hi, > > > > i am currently setup a production + development environment and I want to > > know if there is a guideline of how to customize seed data. I understand > > that seed data is maintained along the ofbiz code but for me doesn't make > > sense to have a very large list of languages, currencies, uom's and so > on, > > so I think it's a good practice to 'eliminate' everything the business is > > not gonna use. Please correct me if I'm wrong. > > > > As I could checked it out I saw I possible approach where I may convert > seed > > data to ext data and comment it out the data I will never use. Am I > right? > > > > Best regards, > > > > Jonatan Soto > > > > > http://www.mindtree.com/email/disclaimer.html > -- - Jonatan Soto
RE: Customizing seed data
I came across a similar scenario when business decision was taken to not to use parts of inventory, parts of accounting and entire fulfillment applications of Ofbiz and using only the e-commerce (Order, PO and Product modules apart from general framework). We decided to integrate Ofbiz with third party commercial solutions in real time for our inventory and accounting needs. This was challenging as modules we were intending to use had lot of dependencies on other modules by the way of data processing and ECA's. My advice, if you do not want to use a particular module or some data, follow the procedure 1) Identify the entities you are using 2) Examine the seed data related to those entities, remove the instance data and NOT the entity definition data (usually available in "*typedata.xml"). 3) Make sure you do not touch *typedata.xml" or any setup data, if you make a mistake here, there are high chances you may end up in failing ECA's 4) Examine the services you are using and associated ECA's, if required disable those ECA's (Important when you do not want to use a module linked thru ECA's) (Example, while receiving the inventory, there are a few accounting entries created, so you have dependency on accounting setup data. Solution, provide the data or disable the ECA, though I would avoid disabling the ECA unless I am very sure it does not impact any other use case). 5) If you add yr business specific entity attributes, extend the entity rather than adding the attribute to default schema. -Abhai -Original Message- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: Thursday, June 10, 2010 6:13 AM To: user@ofbiz.apache.org Subject: Re: Customizing seed data from a maintainence point of view you would have to do that every time you upgraded the code since the update would overwrite all your mods. Unless there is something that may cause confusion I just leave it in. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> Jonatan Soto sent the following on 6/10/2010 2:20 AM: > Hi, > > i am currently setup a production + development environment and I want to > know if there is a guideline of how to customize seed data. I understand > that seed data is maintained along the ofbiz code but for me doesn't make > sense to have a very large list of languages, currencies, uom's and so on, > so I think it's a good practice to 'eliminate' everything the business is > not gonna use. Please correct me if I'm wrong. > > As I could checked it out I saw I possible approach where I may convert seed > data to ext data and comment it out the data I will never use. Am I right? > > Best regards, > > Jonatan Soto > http://www.mindtree.com/email/disclaimer.html
Re: Customizing seed data
from a maintainence point of view you would have to do that every time you upgraded the code since the update would overwrite all your mods. Unless there is something that may cause confusion I just leave it in. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> Jonatan Soto sent the following on 6/10/2010 2:20 AM: Hi, i am currently setup a production + development environment and I want to know if there is a guideline of how to customize seed data. I understand that seed data is maintained along the ofbiz code but for me doesn't make sense to have a very large list of languages, currencies, uom's and so on, so I think it's a good practice to 'eliminate' everything the business is not gonna use. Please correct me if I'm wrong. As I could checked it out I saw I possible approach where I may convert seed data to ext data and comment it out the data I will never use. Am I right? Best regards, Jonatan Soto
Customizing seed data
Hi, i am currently setup a production + development environment and I want to know if there is a guideline of how to customize seed data. I understand that seed data is maintained along the ofbiz code but for me doesn't make sense to have a very large list of languages, currencies, uom's and so on, so I think it's a good practice to 'eliminate' everything the business is not gonna use. Please correct me if I'm wrong. As I could checked it out I saw I possible approach where I may convert seed data to ext data and comment it out the data I will never use. Am I right? Best regards, Jonatan Soto
Re: Seed Data Load very slow in Ubuntu 10.04
Still, my ant run-install-seed takes: BUILD SUCCESSFUL Total time: 6 minutes 48 seconds real6m48.884s user1m37.250s sys 0m8.061s using java version "1.6.0_18" OpenJDK Runtime Environment (IcedTea6 1.8) (6b18-1.8-0ubuntu1) OpenJDK Server VM (build 14.0-b16, mixed mode and BUILD SUCCESSFUL Total time: 7 minutes 29 seconds real7m29.793s user2m20.877s sys 0m14.233s using Sun JVM java version "1.6.0_20" Java(TM) SE Runtime Environment (build 1.6.0_20-b02) Java HotSpot(TM) Server VM (build 16.3-b01, mixed mode) So- Sun JVM is slower - wow, what a surprise :) I run ubuntu 10.04 on my laptop with all updates, ext4 fs, 2.6.32-21-generic-pae, 4 gb ram, 7200 rpm sata hdd, Ofbiz trunk branch with all default options, PostgreSQL 8.4.3 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 32-bit, I haven't timed the run-install procedure before, but i think the time was pretty much the same. It would be interesting to perform the same tests using ubuntu 10.04 and ext3 for example. According to this benchmark http://www.phoronix.com/scan.php?page=article&item=ext4_btrfs_nilfs2&num=3 postgre runs slightly faster on ext3 as compared to ext4, but the difference is not that huge. -- deyan On Mon, 2010-05-03 at 12:32 +0300, Deyan Tsvetanov wrote: > Sorry, I hit ctrl + enter too quickly :) > > http://www.phoronix.com/scan.php?page=article&item=linux_perf_regressions&num=1 > > So - don't use the 2.6.32 kernel for production yet :) > > > On Mon, 2010-05-03 at 12:24 +0300, Deyan Tsvetanov wrote: > > http://www.phoronix.com/scan.php?page=article&item=ubuntu_lucid_alpha2&num=3 > > > > PostgreSQL's performance continues to suffer dramatically under Ubuntu > > 10.04 LTS and it is not expected that it will change at all for this > > next Ubuntu release. This major drop in the number of transactions being > > carried out per second is due to an EXT4 file-system change designed to > > provide better data safety but with a significant performance penalty. > > This matter is talked about in Autonomously Finding Performance > > Regressions In The Linux Kernel. The PostgreSQL performance also suffers > > in Fedora 13 and any other Linux distributions using the Linux 2.6.32 > > kernel. Even with Fedora 13 being much earlier into its development > > cycle and carrying some debugging options by default (along with using > > SELinux), Fedora 13 Rawhide performed quite closely to Ubuntu 10.04 > > Alpha 2 in this test. > > > > > > > > On Mon, 2010-05-03 at 14:37 +0530, Ravindra Mandre wrote: > > > I am also facing the same problem that Kranti reported above. > > > I also using Ubuntu 10.04. > > > > > > Regards > > > Ravindra Mandre > > > > > > On Mon, May 3, 2010 at 2:17 PM, Jonatan Soto > > > wrote: > > > > > > > I am using Ubuntu 9.10 with ext4 and it works great. > > > > > > > > On Mon, May 3, 2010 at 10:42 AM, Kranti Agrawal > > > >wrote: > > > > > > > > > Hi, > > > > > > > > > > I installed Ubuntu 10.04 LTS yesterday with ext4 as the default file > > > > > system. > > > > > The seed data load is very very slow. It takes around 30 mins to load. > > > > > In ubuntu 8.04 LTS, it took around 2-3 mins max. > > > > > Is it due to the ext4 file system? or anything else? > > > > > > > > > > Regards, > > > > > Kranti Agrawal > > > > > Student, IIIT Bangalore > > > > > krantiagrawal.blogspot.com > > > > > > > > > > > > > > >
Re: Seed Data Load very slow in Ubuntu 10.04
Sorry, I hit ctrl + enter too quickly :) http://www.phoronix.com/scan.php?page=article&item=linux_perf_regressions&num=1 So - don't use the 2.6.32 kernel for production yet :) On Mon, 2010-05-03 at 12:24 +0300, Deyan Tsvetanov wrote: > http://www.phoronix.com/scan.php?page=article&item=ubuntu_lucid_alpha2&num=3 > > PostgreSQL's performance continues to suffer dramatically under Ubuntu > 10.04 LTS and it is not expected that it will change at all for this > next Ubuntu release. This major drop in the number of transactions being > carried out per second is due to an EXT4 file-system change designed to > provide better data safety but with a significant performance penalty. > This matter is talked about in Autonomously Finding Performance > Regressions In The Linux Kernel. The PostgreSQL performance also suffers > in Fedora 13 and any other Linux distributions using the Linux 2.6.32 > kernel. Even with Fedora 13 being much earlier into its development > cycle and carrying some debugging options by default (along with using > SELinux), Fedora 13 Rawhide performed quite closely to Ubuntu 10.04 > Alpha 2 in this test. > > > > On Mon, 2010-05-03 at 14:37 +0530, Ravindra Mandre wrote: > > I am also facing the same problem that Kranti reported above. > > I also using Ubuntu 10.04. > > > > Regards > > Ravindra Mandre > > > > On Mon, May 3, 2010 at 2:17 PM, Jonatan Soto > > wrote: > > > > > I am using Ubuntu 9.10 with ext4 and it works great. > > > > > > On Mon, May 3, 2010 at 10:42 AM, Kranti Agrawal > > >wrote: > > > > > > > Hi, > > > > > > > > I installed Ubuntu 10.04 LTS yesterday with ext4 as the default file > > > > system. > > > > The seed data load is very very slow. It takes around 30 mins to load. > > > > In ubuntu 8.04 LTS, it took around 2-3 mins max. > > > > Is it due to the ext4 file system? or anything else? > > > > > > > > Regards, > > > > Kranti Agrawal > > > > Student, IIIT Bangalore > > > > krantiagrawal.blogspot.com > > > > > > > > >
Re: Seed Data Load very slow in Ubuntu 10.04
Version of Java I use: java version "1.6.0_17" Java(TM) SE Runtime Environment (build 1.6.0_17-b04) Java HotSpot(TM) Server VM (build 14.3-b01, mixed mode) Regards, Kranti Agrawal Student, IIIT Bangalore krantiagrawal.blogspot.com On Mon, May 3, 2010 at 2:54 PM, Deyan Tsvetanov wrote: > > http://www.phoronix.com/scan.php?page=article&item=ubuntu_lucid_alpha2&num=3 > > PostgreSQL's performance continues to suffer dramatically under Ubuntu > 10.04 LTS and it is not expected that it will change at all for this > next Ubuntu release. This major drop in the number of transactions being > carried out per second is due to an EXT4 file-system change designed to > provide better data safety but with a significant performance penalty. > This matter is talked about in Autonomously Finding Performance > Regressions In The Linux Kernel. The PostgreSQL performance also suffers > in Fedora 13 and any other Linux distributions using the Linux 2.6.32 > kernel. Even with Fedora 13 being much earlier into its development > cycle and carrying some debugging options by default (along with using > SELinux), Fedora 13 Rawhide performed quite closely to Ubuntu 10.04 > Alpha 2 in this test. > > > > On Mon, 2010-05-03 at 14:37 +0530, Ravindra Mandre wrote: > > I am also facing the same problem that Kranti reported above. > > I also using Ubuntu 10.04. > > > > Regards > > Ravindra Mandre > > > > On Mon, May 3, 2010 at 2:17 PM, Jonatan Soto >wrote: > > > > > I am using Ubuntu 9.10 with ext4 and it works great. > > > > > > On Mon, May 3, 2010 at 10:42 AM, Kranti Agrawal < > krantionl...@gmail.com > > > >wrote: > > > > > > > Hi, > > > > > > > > I installed Ubuntu 10.04 LTS yesterday with ext4 as the default file > > > > system. > > > > The seed data load is very very slow. It takes around 30 mins to > load. > > > > In ubuntu 8.04 LTS, it took around 2-3 mins max. > > > > Is it due to the ext4 file system? or anything else? > > > > > > > > Regards, > > > > Kranti Agrawal > > > > Student, IIIT Bangalore > > > > krantiagrawal.blogspot.com > > > > > > > > > >
Re: Seed Data Load very slow in Ubuntu 10.04
http://www.phoronix.com/scan.php?page=article&item=ubuntu_lucid_alpha2&num=3 PostgreSQL's performance continues to suffer dramatically under Ubuntu 10.04 LTS and it is not expected that it will change at all for this next Ubuntu release. This major drop in the number of transactions being carried out per second is due to an EXT4 file-system change designed to provide better data safety but with a significant performance penalty. This matter is talked about in Autonomously Finding Performance Regressions In The Linux Kernel. The PostgreSQL performance also suffers in Fedora 13 and any other Linux distributions using the Linux 2.6.32 kernel. Even with Fedora 13 being much earlier into its development cycle and carrying some debugging options by default (along with using SELinux), Fedora 13 Rawhide performed quite closely to Ubuntu 10.04 Alpha 2 in this test. On Mon, 2010-05-03 at 14:37 +0530, Ravindra Mandre wrote: > I am also facing the same problem that Kranti reported above. > I also using Ubuntu 10.04. > > Regards > Ravindra Mandre > > On Mon, May 3, 2010 at 2:17 PM, Jonatan Soto wrote: > > > I am using Ubuntu 9.10 with ext4 and it works great. > > > > On Mon, May 3, 2010 at 10:42 AM, Kranti Agrawal > >wrote: > > > > > Hi, > > > > > > I installed Ubuntu 10.04 LTS yesterday with ext4 as the default file > > > system. > > > The seed data load is very very slow. It takes around 30 mins to load. > > > In ubuntu 8.04 LTS, it took around 2-3 mins max. > > > Is it due to the ext4 file system? or anything else? > > > > > > Regards, > > > Kranti Agrawal > > > Student, IIIT Bangalore > > > krantiagrawal.blogspot.com > > > > >
Re: Seed Data Load very slow in Ubuntu 10.04
Le 03/05/2010 11:07, Ravindra Mandre a écrit : I am also facing the same problem that Kranti reported above. I also using Ubuntu 10.04. Regards Ravindra Mandre On Mon, May 3, 2010 at 2:17 PM, Jonatan Sotowrote: I am using Ubuntu 9.10 with ext4 and it works great. On Mon, May 3, 2010 at 10:42 AM, Kranti Agrawal wrote: Hi, I installed Ubuntu 10.04 LTS yesterday with ext4 as the default file system. The seed data load is very very slow. It takes around 30 mins to load. In ubuntu 8.04 LTS, it took around 2-3 mins max. Is it due to the ext4 file system? or anything else? Regards, Kranti Agrawal Student, IIIT Bangalore krantiagrawal.blogspot.com I haven't migrated yet, but which jvm are you using ? -- Erwan de FERRIERES www.nereide.biz
Re: Seed Data Load very slow in Ubuntu 10.04
I am also facing the same problem that Kranti reported above. I also using Ubuntu 10.04. Regards Ravindra Mandre On Mon, May 3, 2010 at 2:17 PM, Jonatan Soto wrote: > I am using Ubuntu 9.10 with ext4 and it works great. > > On Mon, May 3, 2010 at 10:42 AM, Kranti Agrawal >wrote: > > > Hi, > > > > I installed Ubuntu 10.04 LTS yesterday with ext4 as the default file > > system. > > The seed data load is very very slow. It takes around 30 mins to load. > > In ubuntu 8.04 LTS, it took around 2-3 mins max. > > Is it due to the ext4 file system? or anything else? > > > > Regards, > > Kranti Agrawal > > Student, IIIT Bangalore > > krantiagrawal.blogspot.com > > >
Re: Seed Data Load very slow in Ubuntu 10.04
I am using Ubuntu 9.10 with ext4 and it works great. On Mon, May 3, 2010 at 10:42 AM, Kranti Agrawal wrote: > Hi, > > I installed Ubuntu 10.04 LTS yesterday with ext4 as the default file > system. > The seed data load is very very slow. It takes around 30 mins to load. > In ubuntu 8.04 LTS, it took around 2-3 mins max. > Is it due to the ext4 file system? or anything else? > > Regards, > Kranti Agrawal > Student, IIIT Bangalore > krantiagrawal.blogspot.com >
Seed Data Load very slow in Ubuntu 10.04
Hi, I installed Ubuntu 10.04 LTS yesterday with ext4 as the default file system. The seed data load is very very slow. It takes around 30 mins to load. In ubuntu 8.04 LTS, it took around 2-3 mins max. Is it due to the ext4 file system? or anything else? Regards, Kranti Agrawal Student, IIIT Bangalore krantiagrawal.blogspot.com
Re: Installing a Theme / Missing Seed Data
The idea with "seed" data is that it is maintained along with the code. Because of that it generally shouldn't be edited directly in the database, and always maintained in files. That also means that whenever you update code on an instance with an existing database you should also update the seed data (if no seed data changes have been made this won't hurt anything, if seed data changes have been made it'll help a lot). -David On Mar 15, 2010, at 12:16 AM, Sam Hamilton wrote: > I just found this page on the wiki - > http://cwiki.apache.org/confluence/display/OFBTECH/Revisions+Requiring+Data+Migration > > I know its not quite data migration - but would it make sense to update > this if there is a need to install seed data when moving forward with > code updates - like adding a new visual theme? > > Or asking the question differently - can there be any harm done to a > vanilla system with no code changes to run ant run-install-seed say once > a month? > > thanks > Sam > > > On 15/03/2010 13:33, Adrian Crum wrote: >> --- On Sun, 3/14/10, Sam Hamilton wrote: >>> Hi List, >>> >>> I have a test server that runs against a mysql database for >>> which I have >>> been getting updates from SVN for the last 6 months. >>> Well recently the new theme Tomahawk was release and I SVN >>> up but still >>> the theme didn't show up, so I googled and found out that >>> you needed to >>> ./ ant run-install-seed to make the new theme work - which >>> it did and >>> now my test server is running the great new theme. >> >> Sometimes new features will require installing seed data. That is quite >> common - especially for visual themes. >> >> -Adrian >> >> >> >> >
Re: Installing a Theme / Missing Seed Data
I just found this page on the wiki - http://cwiki.apache.org/confluence/display/OFBTECH/Revisions+Requiring+Data+Migration I know its not quite data migration - but would it make sense to update this if there is a need to install seed data when moving forward with code updates - like adding a new visual theme? Or asking the question differently - can there be any harm done to a vanilla system with no code changes to run ant run-install-seed say once a month? thanks Sam On 15/03/2010 13:33, Adrian Crum wrote: > --- On Sun, 3/14/10, Sam Hamilton wrote: >> Hi List, >> >> I have a test server that runs against a mysql database for >> which I have >> been getting updates from SVN for the last 6 months. >> Well recently the new theme Tomahawk was release and I SVN >> up but still >> the theme didn't show up, so I googled and found out that >> you needed to >> ./ ant run-install-seed to make the new theme work - which >> it did and >> now my test server is running the great new theme. > > Sometimes new features will require installing seed data. That is quite > common - especially for visual themes. > > -Adrian > > > >
Re: Installing a Theme / Missing Seed Data
--- On Sun, 3/14/10, Sam Hamilton wrote: > Hi List, > > I have a test server that runs against a mysql database for > which I have > been getting updates from SVN for the last 6 months. > Well recently the new theme Tomahawk was release and I SVN > up but still > the theme didn't show up, so I googled and found out that > you needed to > ./ ant run-install-seed to make the new theme work - which > it did and > now my test server is running the great new theme. Sometimes new features will require installing seed data. That is quite common - especially for visual themes. -Adrian
Re: Installing a Theme / Missing Seed Data
Thanks David - that helps alot Cheers Sam On 15/03/2010 12:36, David E Jones wrote: > > On Mar 14, 2010, at 10:27 PM, Sam Hamilton wrote: > >> Hi List, >> >> I have a test server that runs against a mysql database for which I have >> been getting updates from SVN for the last 6 months. >> Well recently the new theme Tomahawk was release and I SVN up but still >> the theme didn't show up, so I googled and found out that you needed to >> ./ ant run-install-seed to make the new theme work - which it did and >> now my test server is running the great new theme. >> >> Can someone tell me why that process is not handled by the normal boot >> up process which would create missing entities in the database? > > The normal process only creates missing tables and columns. It doesn't adjust > column sizes, column types, remove renamed or removed fields, or any other > database maintenance things. It also doesn't look at all seed data to make > sure it is up to date and inconsistent with what is in the files. > > -David >
Re: Installing a Theme / Missing Seed Data
On Mar 14, 2010, at 10:27 PM, Sam Hamilton wrote: > Hi List, > > I have a test server that runs against a mysql database for which I have > been getting updates from SVN for the last 6 months. > Well recently the new theme Tomahawk was release and I SVN up but still > the theme didn't show up, so I googled and found out that you needed to > ./ ant run-install-seed to make the new theme work - which it did and > now my test server is running the great new theme. > > Can someone tell me why that process is not handled by the normal boot > up process which would create missing entities in the database? The normal process only creates missing tables and columns. It doesn't adjust column sizes, column types, remove renamed or removed fields, or any other database maintenance things. It also doesn't look at all seed data to make sure it is up to date and inconsistent with what is in the files. -David
Installing a Theme / Missing Seed Data
Hi List, I have a test server that runs against a mysql database for which I have been getting updates from SVN for the last 6 months. Well recently the new theme Tomahawk was release and I SVN up but still the theme didn't show up, so I googled and found out that you needed to ./ ant run-install-seed to make the new theme work - which it did and now my test server is running the great new theme. Can someone tell me why that process is not handled by the normal boot up process which would create missing entities in the database? thanks Sam
Re: Cannot login using seed data
I have found another docs: http://docs.ofbiz.org/display/~jacopoc/Quick+Start+Guide+1+-+Getting+and+Running+OFBiz+in+5+steps It tells that to install seed only, by using: ant run-install-extseed create-admin-user-login But I do not have ext data to cover the demo data. Why not run ant run-install-seed instead? What is seed-initial? From http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide Definition: Seed Initial Data is data that is only required the first time the system is loaded like the password of the admin user. Later if you want to update the seed data, you normally do not want the password of admin set back to the 'ofbiz' value. But I have tested and cannot login using admin/ofbiz. Could somebody clarify it/teach me? Regards, Terence Vikas Mayur-3 wrote: > > admin user is now part of demo data. Please see the mailing archive > for the reasons. > > If you just want to install seed data then try to use the ant target > create-admin-user-login. > > Vikas > > On Aug 27, 2009, at 5:51 PM, ngterry wrote: > >> >> Hi, >> >> Enclosed please find my ofbiz.log >> >> After loading the seed data, I can view the login page but cannot >> login >> using admin/ofbiz. >> >> I have executed the command to load the seed data: >> #$JAVA_HOME/bin/java -jar ofbiz.jar -install -readers=seed,seed- >> initial >> >> after that, I can find 818 tables in the PostgreSQL 8.3.3 database. >> >> How do I solve the issue? >> >> Regards, >> Terence >> >> http://www.nabble.com/file/p25167547/ofbiz.log ofbiz.log >> >> >> -- >> View this message in context: >> http://www.nabble.com/Cannot-login-using-seed-data-tp25167547p25167547.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > > > > -- View this message in context: http://www.nabble.com/Cannot-login-using-seed-data-tp25167547p25184920.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Cannot login using seed data
admin user is now part of demo data. Please see the mailing archive for the reasons. If you just want to install seed data then try to use the ant target create-admin-user-login. Vikas On Aug 27, 2009, at 5:51 PM, ngterry wrote: Hi, Enclosed please find my ofbiz.log After loading the seed data, I can view the login page but cannot login using admin/ofbiz. I have executed the command to load the seed data: #$JAVA_HOME/bin/java -jar ofbiz.jar -install -readers=seed,seed- initial after that, I can find 818 tables in the PostgreSQL 8.3.3 database. How do I solve the issue? Regards, Terence http://www.nabble.com/file/p25167547/ofbiz.log ofbiz.log -- View this message in context: http://www.nabble.com/Cannot-login-using-seed-data-tp25167547p25167547.html Sent from the OFBiz - User mailing list archive at Nabble.com. smime.p7s Description: S/MIME cryptographic signature
Cannot login using seed data
Hi, Enclosed please find my ofbiz.log After loading the seed data, I can view the login page but cannot login using admin/ofbiz. I have executed the command to load the seed data: #$JAVA_HOME/bin/java -jar ofbiz.jar -install -readers=seed,seed-initial after that, I can find 818 tables in the PostgreSQL 8.3.3 database. How do I solve the issue? Regards, Terence http://www.nabble.com/file/p25167547/ofbiz.log ofbiz.log -- View this message in context: http://www.nabble.com/Cannot-login-using-seed-data-tp25167547p25167547.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can not change seed data
AccountingEntityLabels.xml Regards Scott On 11/08/2009, at 11:20 PM, gintare2009 wrote: No, I've checked 100 times... When I do update not for "description" column of seed data in "AcctgTransType" entity or do insert new entry in it, changes reflected OK, but not with "description" column... yanick wrote: Field displayed in drop-box is same which you updated? It seems you updated other column. ya Dňa Po, 2009-08-10 o 23:25 -0700, gintare2009 napísal: I've cleared cash, but it does not work and the problem stays as it was... yanick wrote: Hi, this value is probably cached, try clear cache: https://localhost:8443/webtools/control/FindUtilCache direct link to clear: https://localhost:8443/webtools/control/FindUtilCacheClearAll ya -- View this message in context: http://www.nabble.com/Can-not-change-seed-data-tp24902835p24915688.html Sent from the OFBiz - User mailing list archive at Nabble.com. smime.p7s Description: S/MIME cryptographic signature
Re: Can not change seed data
No, I've checked 100 times... When I do update not for "description" column of seed data in "AcctgTransType" entity or do insert new entry in it, changes reflected OK, but not with "description" column... yanick wrote: > > Field displayed in drop-box is same which you updated? It seems you > updated other column. > > ya > > Dňa Po, 2009-08-10 o 23:25 -0700, gintare2009 napísal: >> >> I've cleared cash, but it does not work and the problem stays as it >> was... >> >> >> >> yanick wrote: >> > >> > Hi, >> > this value is probably cached, try clear cache: >> > https://localhost:8443/webtools/control/FindUtilCache >> > direct link to clear: >> > https://localhost:8443/webtools/control/FindUtilCacheClearAll >> > >> > ya >> > >> > >> > >> > > > > -- View this message in context: http://www.nabble.com/Can-not-change-seed-data-tp24902835p24915688.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can not change seed data
Field displayed in drop-box is same which you updated? It seems you updated other column. ya Dňa Po, 2009-08-10 o 23:25 -0700, gintare2009 napísal: > > I've cleared cash, but it does not work and the problem stays as it was... > > > > yanick wrote: > > > > Hi, > > this value is probably cached, try clear cache: > > https://localhost:8443/webtools/control/FindUtilCache > > direct link to clear: > > https://localhost:8443/webtools/control/FindUtilCacheClearAll > > > > ya > > > > > > >
Re: Can not change seed data
I've cleared cash, but it does not work and the problem stays as it was... yanick wrote: > > Hi, > this value is probably cached, try clear cache: > https://localhost:8443/webtools/control/FindUtilCache > direct link to clear: > https://localhost:8443/webtools/control/FindUtilCacheClearAll > > ya > > > -- View this message in context: http://www.nabble.com/Can-not-change-seed-data-tp24902835p24912318.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can not change seed data
Hi, this value is probably cached, try clear cache: https://localhost:8443/webtools/control/FindUtilCache direct link to clear: https://localhost:8443/webtools/control/FindUtilCacheClearAll ya Dňa Po, 2009-08-10 o 19:24 +0300, Gintare Ragaisiene napísal: > Hello, > >I have my ofbiz with external mysql. And I have default accounting entity > "AcctgTransType" with default seed data in it. In the form of > "FindAcctgTrans" screen those data are used in drop-down box. The problem > arises when: > 1. I go to webtools; > 2. update one of the seed data entries "description" attribute; > 3. push "Back to the find scree" button in webtools; > 4. see updated descrition (for example "Amortization" updated to > "Amortization123") - it's OK > but then > 5. go to the "FindAcctgTrans" screen that I have mentioned previosly; > 6. do refresh in the browser; > 7. no success to see "Amortization123" in the drop-down box, only old > "Amortization" ir here > > Why changes in database of entities not reflecting in UI ? > > > Gintare
Can not change seed data
Hello, I have my ofbiz with external mysql. And I have default accounting entity "AcctgTransType" with default seed data in it. In the form of "FindAcctgTrans" screen those data are used in drop-down box. The problem arises when: 1. I go to webtools; 2. update one of the seed data entries "description" attribute; 3. push "Back to the find scree" button in webtools; 4. see updated descrition (for example "Amortization" updated to "Amortization123") - it's OK but then 5. go to the "FindAcctgTrans" screen that I have mentioned previosly; 6. do refresh in the browser; 7. no success to see "Amortization123" in the drop-down box, only old "Amortization" ir here Why changes in database of entities not reflecting in UI ? Gintare
Re: setup issues without demo data - only seed data
As BJ said you will need to approach the opentaps forum for more specific help. In general OFBiz terms seed data is just the basics for types and such, it will not provide a fully functional catalog/ecommerce/facility management system etc. The best approach is to take all the "demo" xml files and go through them one at a time and modify/duplicate them and remove the contents to suit your needs. You'll learn a lot about the data structures and relationships and it's quite easy to decide on removing some data i.e. is obviously a product you may not want where as you will need to load some catalogue payment types to get check out working. If you export your existing database to individual entity named xml files you can also quickly compare what you may not have set up when looking through the demo xml files. Ray Jeremy Taylor wrote: > Hi, > > I have been struggling to get a working configuration of opentaps/ofbiz using > the 1.0.2 download when not loading demo data. If I run the "ant > run-install-seed" command to populate the database, features do not work out > of > the box. The OFBiz Basic Production Setup guide discusses loading only seed > data, however it does not seem to include enough information to configure all > features to work. I have not found a configuration document describing this, > but it seems like it would be common to want to start this way. Am I missing > something? Is there a better path to have a clean database without demo data? > > I have gotten the initial store setup and catalog/categories populated. I can > see products on the ecommerce store front. If I click to view a product, I am > taken out of the store and back to the general ofbiz portal links. If I try to > add the product to the cart, the same thing happens. If I search the catalog, > same thing. > > Obviously, there is some configuration that has not occurred that it needs for > those features to work, but I see no errors through the interface or in the > ofbiz.log or console.log. > > Can anyone point out the issue here or point me in the direction of a path > that > reaches the goal of a working setup without demo data? > > Thanks much, > > Jeremy > >
Re: setup issues without demo data - only seed data
where your using opentaps, with ofbiz it is in the hot-deploy. I suggest you ask you question here http://sourceforge.net/forum/?group_id=145855 if you take out opentaps then we can help here. Jeremy Taylor sent the following on 10/21/2008 12:22 PM: > Hi, > > I have been struggling to get a working configuration of opentaps/ofbiz using > the 1.0.2 download when not loading demo data. If I run the "ant > run-install-seed" command to populate the database, features do not work out > of > the box. The OFBiz Basic Production Setup guide discusses loading only seed > data, however it does not seem to include enough information to configure all > features to work. I have not found a configuration document describing this, > but it seems like it would be common to want to start this way. Am I missing > something? Is there a better path to have a clean database without demo data? > > I have gotten the initial store setup and catalog/categories populated. I can > see products on the ecommerce store front. If I click to view a product, I am > taken out of the store and back to the general ofbiz portal links. If I try to > add the product to the cart, the same thing happens. If I search the catalog, > same thing. > > Obviously, there is some configuration that has not occurred that it needs for > those features to work, but I see no errors through the interface or in the > ofbiz.log or console.log. > > Can anyone point out the issue here or point me in the direction of a path > that > reaches the goal of a working setup without demo data? > > Thanks much, > > Jeremy > > >
setup issues without demo data - only seed data
Hi, I have been struggling to get a working configuration of opentaps/ofbiz using the 1.0.2 download when not loading demo data. If I run the "ant run-install-seed" command to populate the database, features do not work out of the box. The OFBiz Basic Production Setup guide discusses loading only seed data, however it does not seem to include enough information to configure all features to work. I have not found a configuration document describing this, but it seems like it would be common to want to start this way. Am I missing something? Is there a better path to have a clean database without demo data? I have gotten the initial store setup and catalog/categories populated. I can see products on the ecommerce store front. If I click to view a product, I am taken out of the store and back to the general ofbiz portal links. If I try to add the product to the cart, the same thing happens. If I search the catalog, same thing. Obviously, there is some configuration that has not occurred that it needs for those features to work, but I see no errors through the interface or in the ofbiz.log or console.log. Can anyone point out the issue here or point me in the direction of a path that reaches the goal of a working setup without demo data? Thanks much, Jeremy
Re: Seed Data Only
Thanks, the picture is starting to make sense . ;) Bruno Busco wrote: > > Has you can read in the build.xml file... > > description="This loads ONLY the seed data (not seed-initial, > demo, > ext* or anything else); meant for use after an update of the code to > reload > the seed data as it is generally maintained along with the code and needs > to > be in sync for operation"> > > description="This loads seed, seed-initial and ext data; meant for > manual/generic testing, development, or going into production with a > derived > system based on stock OFBiz where the ext data basically replaces the demo > data"> > > -Bruno > > 2008/6/19 Wicus <[EMAIL PROTECTED]>: > >> >> Running:- >> >> $./ant run-install-seed >> >> doesn't allow me to login regardless of username (admin) password (ofbiz) >> - >> Error: >> >> The following error occurred during login: The account for user login id >> "admin" has been disabled.since 2008-06-19 13:57:26.998.It will be >> re-enabled 2008-06-19 14:02:26.998. >> >> After running:- >> >> $./ant run-install-extseed >> >> I can login with admin / ofbiz >> >> Thanks Hans >> >> >> >> Hans Bakker wrote: >> > >> > >> > I just updated the production setup guide, please check: >> > http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production >> > +Setup+Guide >> > >> > On Thu, 2008-06-19 at 04:29 -0700, Wicus wrote: >> >> >> >> Hi, >> >> >> >> When installing ofbiz with only seed data, what admin username / >> password >> >> should be used? >> >> >> >> Thanks >> > >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Seed-Data-Only-tp18006120p18007901.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/Seed-Data-Only-tp18006120p18012586.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Seed Data Only
Has you can read in the build.xml file... -Bruno 2008/6/19 Wicus <[EMAIL PROTECTED]>: > > Running:- > > $./ant run-install-seed > > doesn't allow me to login regardless of username (admin) password (ofbiz) - > Error: > > The following error occurred during login: The account for user login id > "admin" has been disabled.since 2008-06-19 13:57:26.998.It will be > re-enabled 2008-06-19 14:02:26.998. > > After running:- > > $./ant run-install-extseed > > I can login with admin / ofbiz > > Thanks Hans > > > > Hans Bakker wrote: > > > > > > I just updated the production setup guide, please check: > > http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production > > +Setup+Guide > > > > On Thu, 2008-06-19 at 04:29 -0700, Wicus wrote: > >> > >> Hi, > >> > >> When installing ofbiz with only seed data, what admin username / > password > >> should be used? > >> > >> Thanks > > > > > > > > -- > View this message in context: > http://www.nabble.com/Seed-Data-Only-tp18006120p18007901.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > >
Re: Seed Data Only
Running:- $./ant run-install-seed doesn't allow me to login regardless of username (admin) password (ofbiz) - Error: The following error occurred during login: The account for user login id "admin" has been disabled.since 2008-06-19 13:57:26.998.It will be re-enabled 2008-06-19 14:02:26.998. After running:- $./ant run-install-extseed I can login with admin / ofbiz Thanks Hans Hans Bakker wrote: > > > I just updated the production setup guide, please check: > http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production > +Setup+Guide > > On Thu, 2008-06-19 at 04:29 -0700, Wicus wrote: >> >> Hi, >> >> When installing ofbiz with only seed data, what admin username / password >> should be used? >> >> Thanks > > > -- View this message in context: http://www.nabble.com/Seed-Data-Only-tp18006120p18007901.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Seed Data Only
I just updated the production setup guide, please check: http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production +Setup+Guide On Thu, 2008-06-19 at 04:29 -0700, Wicus wrote: > > Hi, > > When installing ofbiz with only seed data, what admin username / password > should be used? > > Thanks
Seed Data Only
Hi, When installing ofbiz with only seed data, what admin username / password should be used? Thanks -- View this message in context: http://www.nabble.com/Seed-Data-Only-tp18006120p18006120.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: AW: AW: WG: SHA / SHA1 seed data and password encryption
Hi David, --On Mittwoch, 30. April 2008 02:29 -0600 David E Jones <[EMAIL PROTECTED]> wrote: No, the keystore is only used for 2-way encryption. It seems that old EntityKeyStore data are affected from the new hash method. The keyName in the EntityKeyStore was hashed formerly by old hash method? regards Sebastian
Re: AW: AW: WG: SHA / SHA1 seed data and password encryption
BTW there are already Jira issues open about all that https://issues.apache.org/jira/browse/OFBIZ-1525 Precisely about this issue https://issues.apache.org/jira/browse/OFBIZ-1151 This discussion should be better in dev ML... Thanks Jacques From: "David E Jones" <[EMAIL PROTECTED]> On Apr 30, 2008, at 2:25 AM, Sebastian Schirmer wrote: Hi David, thanks for the new hash implementation. We are going to implement an auto conversion method additionally. This should write the new correct sha/md5 hash after login validation with the old (funny) hash. Is the keystore entity also affected to the new hash methods? No, the keystore is only used for 2-way encryption. BTW, on a side note, there is still no "salting" in this password encryption, not sure if that is something you guys have looked at or need but it is something that crossed my mind while looking at this again. -David --On Dienstag, 29. April 2008 09:09 -0600 David E Jones <[EMAIL PROTECTED] > wrote: Attached is the patch for the stuff I was working on last night. Unfortunately it doesn't just have the password improvements, but instead also has the generic audit log feature that I recently added to the entity engine. As has been mentioned a few times the ASF SVN repo is not open for commits, so those who want this or to get started with it can play with the attached patch (in a gzip file, BTW) until the SVN server is ready for commits again. BTW, if the attachment doesn't make it through I'll try again in a minute. -David -- Sebastian Schirmer ZYRES digital media systems GmbH Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Phone +49 (0)69 98 55 99 - 0 Fax +49 (0)69 98 55 99 - 11 Firmensitz: Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Registergericht: Amtsgericht Frankfurt am Main, HRB 76374 Geschäftsführer: Martin Wepper, Sebastian Schirmer http://www.zyres.com/ -- RFC|1855|2.1.1
Re: AW: AW: WG: SHA / SHA1 seed data and password encryption
On Apr 30, 2008, at 2:25 AM, Sebastian Schirmer wrote: Hi David, thanks for the new hash implementation. We are going to implement an auto conversion method additionally. This should write the new correct sha/md5 hash after login validation with the old (funny) hash. Is the keystore entity also affected to the new hash methods? No, the keystore is only used for 2-way encryption. BTW, on a side note, there is still no "salting" in this password encryption, not sure if that is something you guys have looked at or need but it is something that crossed my mind while looking at this again. -David --On Dienstag, 29. April 2008 09:09 -0600 David E Jones <[EMAIL PROTECTED] > wrote: Attached is the patch for the stuff I was working on last night. Unfortunately it doesn't just have the password improvements, but instead also has the generic audit log feature that I recently added to the entity engine. As has been mentioned a few times the ASF SVN repo is not open for commits, so those who want this or to get started with it can play with the attached patch (in a gzip file, BTW) until the SVN server is ready for commits again. BTW, if the attachment doesn't make it through I'll try again in a minute. -David -- Sebastian Schirmer ZYRES digital media systems GmbH Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Phone +49 (0)69 98 55 99 - 0 Fax +49 (0)69 98 55 99 - 11 Firmensitz: Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Registergericht: Amtsgericht Frankfurt am Main, HRB 76374 Geschäftsführer: Martin Wepper, Sebastian Schirmer http://www.zyres.com/ -- RFC|1855|2.1.1
Re: AW: AW: WG: SHA / SHA1 seed data and password encryption
Hi David, thanks for the new hash implementation. We are going to implement an auto conversion method additionally. This should write the new correct sha/md5 hash after login validation with the old (funny) hash. Is the keystore entity also affected to the new hash methods? Kind regards Sebastian --On Dienstag, 29. April 2008 09:09 -0600 David E Jones <[EMAIL PROTECTED]> wrote: Attached is the patch for the stuff I was working on last night. Unfortunately it doesn't just have the password improvements, but instead also has the generic audit log feature that I recently added to the entity engine. As has been mentioned a few times the ASF SVN repo is not open for commits, so those who want this or to get started with it can play with the attached patch (in a gzip file, BTW) until the SVN server is ready for commits again. BTW, if the attachment doesn't make it through I'll try again in a minute. -David -- Sebastian Schirmer ZYRES digital media systems GmbH Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Phone +49 (0)69 98 55 99 - 0 Fax +49 (0)69 98 55 99 - 11 Firmensitz: Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Registergericht: Amtsgericht Frankfurt am Main, HRB 76374 Geschäftsführer: Martin Wepper, Sebastian Schirmer http://www.zyres.com/ -- RFC|1855|2.1.1
Re: AW: AW: WG: SHA / SHA1 seed data and password encryption
Attached is the patch for the stuff I was working on last night. Unfortunately it doesn't just have the password improvements, but instead also has the generic audit log feature that I recently added to the entity engine. As has been mentioned a few times the ASF SVN repo is not open for commits, so those who want this or to get started with it can play with the attached patch (in a gzip file, BTW) until the SVN server is ready for commits again. BTW, if the attachment doesn't make it through I'll try again in a minute. -David pwcryptAndAudit.patch.gz Description: GNU Zip compressed data On Apr 29, 2008, at 6:38 AM, Martin Wepper wrote: Thanks for your proposal ...in ldap no prefix means clear text pw - maybe we should stick to this. we are working on it already (concept/ planning) and will hopefully introduce it in (few?) days. Martin -Ursprüngliche Nachricht- Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. April 2008 14:23 An: user@ofbiz.apache.org Betreff: Re: AW: WG: SHA / SHA1 seed data and password encryption That would immediately solve Martin's problem, and allow him to port in passwords from other softwares (that use standard hashing, period). Also, it wouldn't disrupt existing OFBiz passwords. I'm guessing (not sure) it might be dangerous to hash it multiple ways until we get a match, though. Best to hash it a single way only, which way it is will depend on the prefix. That is, the hash itself declares the hashing algo it needs, and only that algo will be hashed for that hash. No prefix (no declaration of hashing algo) will mean the default OFBiz style. What do you think? Jonathon David E Jones wrote: I played with this a little bit while working on some other stuff... The best solution seems to use something "standard" like the Apache Commons Codex Hex class, which is an easier/better way to do the hex encoding there. The problem is if we change wholesale anyone who updates OFBiz will suddenly have a bunch of useless password data... so I've modified the HashCrypt class to support doing it both ways, and changes the userLogin service to try hashing it both ways to see if either matches. It seems to be working fine so if there are no complaints it'll be in soon... well as soon as the SVN server is up for commits again! -David On Apr 28, 2008, at 11:18 PM, David E Jones wrote: Martin, I agree that is odd, and not a good thing, and I'm really not sure why it is there or how it got there in the first place. It sounds like the proposal is to remove HashCrypt.java lines 52-53, 82-84. Does that sound correct, and does it give more consistent results to what you are seeing elsewhere? If so, let's get rid of 'em! -David On Apr 28, 2008, at 10:51 PM, Martin Wepper wrote: Jonathon, Thanks for your comments. it I understand it right we can not introduce other hashes to ofbiz without introducing the algorithm used to encrypt these. Hashes are one way - so mangling them after being once created is -hopefully for sec reasons- impossible. Here we need the clear text pass again. So other systems we introduce these ofbiz haches to may not use these without the ofbiz encryption - that’s bad - as it should comply to the standard or clearly state that’s its different/wrong as it seems not to be sha1. Kind Regards Martin -Ursprüngliche Nachricht- Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. April 2008 04:12 An: user@ofbiz.apache.org Betreff: Re: WG: SHA / SHA1 seed data and password encryption Martin, A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java Yup. That's where the OFBiz-specific implementation (or rehashing) is. Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Impact on vulnerability? No. In fact, it's slightly more secure. However, the increase in security is only slight. Check out the phrase "security by obscurity". I think I mentioned this some months back on the ML or JIRA. I can't guess what other reason OFBiz would have for making the hash different from the rest of the world. Seeding the password would be a more appropriate strategy for increased security (see https://issues.apache.org/jira/browse/OFBIZ-1151 ). The incompatibility may not pose a problem (I hope). You can still migrate passwords from other systems (not OFBiz, eg osCommerce) into OFBiz. The reason is that OFBiz does not mangle the original SHA hash beyond recovery (I hope, but don't think so). You just have to take the SHA hashes from other systems, pass it through OFBiz's mangl
AW: AW: WG: SHA / SHA1 seed data and password encryption
Thanks for your proposal ...in ldap no prefix means clear text pw -maybe we should stick to this. we are working on it already (concept/planning) and will hopefully introduce it in (few?) days. Martin > -Ursprüngliche Nachricht- > Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 29. April 2008 14:23 > An: user@ofbiz.apache.org > Betreff: Re: AW: WG: SHA / SHA1 seed data and password encryption > > That would immediately solve Martin's problem, and allow him to port in > passwords from other > softwares (that use standard hashing, period). Also, it wouldn't > disrupt existing OFBiz passwords. > > I'm guessing (not sure) it might be dangerous to hash it multiple ways > until we get a match, > though. Best to hash it a single way only, which way it is will depend > on the prefix. That is, the > hash itself declares the hashing algo it needs, and only that algo will > be hashed for that hash. > > No prefix (no declaration of hashing algo) will mean the default OFBiz > style. > > What do you think? > > Jonathon > > David E Jones wrote: > > > > I played with this a little bit while working on some other stuff... > > > > The best solution seems to use something "standard" like the Apache > > Commons Codex Hex class, which is an easier/better way to do the hex > > encoding there. > > > > The problem is if we change wholesale anyone who updates OFBiz will > > suddenly have a bunch of useless password data... so I've modified > the > > HashCrypt class to support doing it both ways, and changes the > userLogin > > service to try hashing it both ways to see if either matches. > > > > It seems to be working fine so if there are no complaints it'll be in > > soon... well as soon as the SVN server is up for commits again! > > > > -David > > > > > > On Apr 28, 2008, at 11:18 PM, David E Jones wrote: > >> > >> Martin, > >> > >> I agree that is odd, and not a good thing, and I'm really not sure > why > >> it is there or how it got there in the first place. > >> > >> It sounds like the proposal is to remove HashCrypt.java lines 52-53, > >> 82-84. > >> > >> Does that sound correct, and does it give more consistent results to > >> what you are seeing elsewhere? > >> > >> If so, let's get rid of 'em! > >> > >> -David > >> > >> > >> On Apr 28, 2008, at 10:51 PM, Martin Wepper wrote: > >>> Jonathon, > >>> > >>> Thanks for your comments. > >>> it I understand it right we can not introduce other hashes to ofbiz > >>> without > >>> introducing the algorithm used to encrypt these. > >>> Hashes are one way - so mangling them after being once created is > >>> -hopefully > >>> for sec reasons- impossible. Here we need the clear text pass > again. > >>> > >>> So other systems we introduce these ofbiz haches to may not use > these > >>> without the ofbiz encryption - thats bad - as it should comply to > the > >>> standard or clearly state thats its different/wrong as it seems > not > >>> to be > >>> sha1. > >>> > >>> Kind Regards > >>> Martin > >>> > >>> > >>> > >>>> -Ursprüngliche Nachricht- > >>>> Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] > >>>> Gesendet: Dienstag, 29. April 2008 04:12 > >>>> An: user@ofbiz.apache.org > >>>> Betreff: Re: WG: SHA / SHA1 seed data and password encryption > >>>> > >>>> Martin, > >>>> > >>>>> A brief analysis shows that the implementation might start here > >>>> being > >>>>> problematic: > >>>>> > >>>>> getDigestHash in > >>>> trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java > >>>> > >>>> Yup. That's where the OFBiz-specific implementation (or rehashing) > is. > >>>> > >>>>> Conclusion: the hashes in customer dbs are not really compatible > >>>> with other > >>>>> sha1 implementations today, bad for SSO. > >>>>> Is there any impact on vulnerability of stored hashes created by > >>>> ofbiz? > >>>> > >>>> Impact on vulnerability? No. In fact, it's slightly more secure. &g
Re: AW: WG: SHA / SHA1 seed data and password encryption
That would immediately solve Martin's problem, and allow him to port in passwords from other softwares (that use standard hashing, period). Also, it wouldn't disrupt existing OFBiz passwords. I'm guessing (not sure) it might be dangerous to hash it multiple ways until we get a match, though. Best to hash it a single way only, which way it is will depend on the prefix. That is, the hash itself declares the hashing algo it needs, and only that algo will be hashed for that hash. No prefix (no declaration of hashing algo) will mean the default OFBiz style. What do you think? Jonathon David E Jones wrote: I played with this a little bit while working on some other stuff... The best solution seems to use something "standard" like the Apache Commons Codex Hex class, which is an easier/better way to do the hex encoding there. The problem is if we change wholesale anyone who updates OFBiz will suddenly have a bunch of useless password data... so I've modified the HashCrypt class to support doing it both ways, and changes the userLogin service to try hashing it both ways to see if either matches. It seems to be working fine so if there are no complaints it'll be in soon... well as soon as the SVN server is up for commits again! -David On Apr 28, 2008, at 11:18 PM, David E Jones wrote: Martin, I agree that is odd, and not a good thing, and I'm really not sure why it is there or how it got there in the first place. It sounds like the proposal is to remove HashCrypt.java lines 52-53, 82-84. Does that sound correct, and does it give more consistent results to what you are seeing elsewhere? If so, let's get rid of 'em! -David On Apr 28, 2008, at 10:51 PM, Martin Wepper wrote: Jonathon, Thanks for your comments. it I understand it right we can not introduce other hashes to ofbiz without introducing the algorithm used to encrypt these. Hashes are one way - so mangling them after being once created is -hopefully for sec reasons- impossible. Here we need the clear text pass again. So other systems we introduce these ofbiz haches to may not use these without the ofbiz encryption - that’s bad - as it should comply to the standard or clearly state that’s its different/wrong as it seems not to be sha1. Kind Regards Martin -Ursprüngliche Nachricht- Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. April 2008 04:12 An: user@ofbiz.apache.org Betreff: Re: WG: SHA / SHA1 seed data and password encryption Martin, A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java Yup. That's where the OFBiz-specific implementation (or rehashing) is. Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Impact on vulnerability? No. In fact, it's slightly more secure. However, the increase in security is only slight. Check out the phrase "security by obscurity". I think I mentioned this some months back on the ML or JIRA. I can't guess what other reason OFBiz would have for making the hash different from the rest of the world. Seeding the password would be a more appropriate strategy for increased security (see https://issues.apache.org/jira/browse/OFBIZ-1151 ). The incompatibility may not pose a problem (I hope). You can still migrate passwords from other systems (not OFBiz, eg osCommerce) into OFBiz. The reason is that OFBiz does not mangle the original SHA hash beyond recovery (I hope, but don't think so). You just have to take the SHA hashes from other systems, pass it through OFBiz's mangling, and you have successfully ported those passwords into OFBiz. Someone please correct me if I'm wrong here; codes in HashCrypt.getDigestHash() (package org.ofbiz.base.crypto). If OFBiz does mangle the original SHA hash beyond recovery, then you cannot migrate passwords to and from OFBiz systems. Then this would be wrong, and needs to be fixed. This does seem to be the case in StringUtil.encodeInt(). We also talked about a "pluggable security system" to easily replace that OFBiz-specific chunk. Not sure if this is done yet. Jonathon Martin Wepper wrote: Dear , hopefully I do miss a point, but ... today we are experiencing a quite annoying issue with sha hashes: Please have a look at this: I'm simply listing hashes, let's start with the hash in seed/demo for "ofbiz": 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by debian4/sha1sum 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum 1.7.0, algorithm=sha1 but: 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin in demo-seed-data
Re: AW: WG: SHA / SHA1 seed data and password encryption
The prefix is not a bad idea... I'm adding that to the new default scheme while I'm at it, and adding support to try the default configured hash, the old funny hex encode hash, and a hash based on the hash type in the prefix in the database/datasource. -David On Apr 29, 2008, at 1:50 AM, Sebastian Schirmer wrote: Hi Martin, we should replace the code with a proved method. The apache commons http://commons.apache.org/codec/apidocs/org/apache/commons/codec/digest/DigestUtils.html is good for a proved method. But our problems are still exists with existing productive data. We need the old hash methods still coexisting with the new hash methods. During a customer login a validation against the old hash must be possible. the used password digest should be also mentioned in front of the hash. For example {sha}xxx {sha256} {md5}xxx {ofbiz}xx <-- (ofbiz brocken hash) This stucture is used im many applications, like openldap and others und give us a way using more than one hash method at the same time. Kind regards Sebastian --On Montag, 28. April 2008 23:18 -0600 David E Jones <[EMAIL PROTECTED] > wrote: Martin, I agree that is odd, and not a good thing, and I'm really not sure why it is there or how it got there in the first place. It sounds like the proposal is to remove HashCrypt.java lines 52-53, 82-84. Does that sound correct, and does it give more consistent results to what you are seeing elsewhere? If so, let's get rid of 'em! -David On Apr 28, 2008, at 10:51 PM, Martin Wepper wrote: Jonathon, Thanks for your comments. it I understand it right we can not introduce other hashes to ofbiz without introducing the algorithm used to encrypt these. Hashes are one way - so mangling them after being once created is - hopefully for sec reasons- impossible. Here we need the clear text pass again. So other systems we introduce these ofbiz haches to may not use these without the ofbiz encryption - that's bad - as it should comply to the standard or clearly state that's its different/wrong as it seems not to be sha1. Kind Regards Martin -Ursprüngliche Nachricht- Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. April 2008 04:12 An: user@ofbiz.apache.org Betreff: Re: WG: SHA / SHA1 seed data and password encryption Martin, A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java Yup. That's where the OFBiz-specific implementation (or rehashing) is. Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Impact on vulnerability? No. In fact, it's slightly more secure. However, the increase in security is only slight. Check out the phrase "security by obscurity". I think I mentioned this some months back on the ML or JIRA. I can't guess what other reason OFBiz would have for making the hash different from the rest of the world. Seeding the password would be a more appropriate strategy for increased security (see https://issues.apache.org/jira/browse/OFBIZ-1151 ). The incompatibility may not pose a problem (I hope). You can still migrate passwords from other systems (not OFBiz, eg osCommerce) into OFBiz. The reason is that OFBiz does not mangle the original SHA hash beyond recovery (I hope, but don't think so). You just have to take the SHA hashes from other systems, pass it through OFBiz's mangling, and you have successfully ported those passwords into OFBiz. Someone please correct me if I'm wrong here; codes in HashCrypt.getDigestHash() (package org.ofbiz.base.crypto). If OFBiz does mangle the original SHA hash beyond recovery, then you cannot migrate passwords to and from OFBiz systems. Then this would be wrong, and needs to be fixed. This does seem to be the case in StringUtil.encodeInt(). We also talked about a "pluggable security system" to easily replace that OFBiz-specific chunk. Not sure if this is done yet. Jonathon Martin Wepper wrote: Dear , hopefully I do miss a point, but ... today we are experiencing a quite annoying issue with sha hashes: Please have a look at this: I'm simply listing hashes, let's start with the hash in seed/demo for "ofbiz": 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by debian4/sha1sum 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum 1.7.0, algorithm=sha1 but: 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin in demo-seed-data __xx__xx xx__xx__her
Re: AW: WG: SHA / SHA1 seed data and password encryption
Hi Martin, we should replace the code with a proved method. The apache commons http://commons.apache.org/codec/apidocs/org/apache/commons/codec/digest/DigestUtils.html is good for a proved method. But our problems are still exists with existing productive data. We need the old hash methods still coexisting with the new hash methods. During a customer login a validation against the old hash must be possible. the used password digest should be also mentioned in front of the hash. For example {sha}xxx {sha256} {md5}xxx {ofbiz}xx <-- (ofbiz brocken hash) This stucture is used im many applications, like openldap and others und give us a way using more than one hash method at the same time. Kind regards Sebastian --On Montag, 28. April 2008 23:18 -0600 David E Jones <[EMAIL PROTECTED]> wrote: Martin, I agree that is odd, and not a good thing, and I'm really not sure why it is there or how it got there in the first place. It sounds like the proposal is to remove HashCrypt.java lines 52-53, 82-84. Does that sound correct, and does it give more consistent results to what you are seeing elsewhere? If so, let's get rid of 'em! -David On Apr 28, 2008, at 10:51 PM, Martin Wepper wrote: Jonathon, Thanks for your comments. it I understand it right we can not introduce other hashes to ofbiz without introducing the algorithm used to encrypt these. Hashes are one way - so mangling them after being once created is - hopefully for sec reasons- impossible. Here we need the clear text pass again. So other systems we introduce these ofbiz haches to may not use these without the ofbiz encryption - that's bad - as it should comply to the standard or clearly state that's its different/wrong as it seems not to be sha1. Kind Regards Martin -Ursprüngliche Nachricht- Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. April 2008 04:12 An: user@ofbiz.apache.org Betreff: Re: WG: SHA / SHA1 seed data and password encryption Martin, A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java Yup. That's where the OFBiz-specific implementation (or rehashing) is. Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Impact on vulnerability? No. In fact, it's slightly more secure. However, the increase in security is only slight. Check out the phrase "security by obscurity". I think I mentioned this some months back on the ML or JIRA. I can't guess what other reason OFBiz would have for making the hash different from the rest of the world. Seeding the password would be a more appropriate strategy for increased security (see https://issues.apache.org/jira/browse/OFBIZ-1151 ). The incompatibility may not pose a problem (I hope). You can still migrate passwords from other systems (not OFBiz, eg osCommerce) into OFBiz. The reason is that OFBiz does not mangle the original SHA hash beyond recovery (I hope, but don't think so). You just have to take the SHA hashes from other systems, pass it through OFBiz's mangling, and you have successfully ported those passwords into OFBiz. Someone please correct me if I'm wrong here; codes in HashCrypt.getDigestHash() (package org.ofbiz.base.crypto). If OFBiz does mangle the original SHA hash beyond recovery, then you cannot migrate passwords to and from OFBiz systems. Then this would be wrong, and needs to be fixed. This does seem to be the case in StringUtil.encodeInt(). We also talked about a "pluggable security system" to easily replace that OFBiz-specific chunk. Not sure if this is done yet. Jonathon Martin Wepper wrote: Dear , hopefully I do miss a point, but ... today we are experiencing a quite annoying issue with sha hashes: Please have a look at this: I'm simply listing hashes, let's start with the hash in seed/demo for "ofbiz": 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by debian4/sha1sum 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum 1.7.0, algorithm=sha1 but: 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin in demo-seed-data __xx__xx xx__xx__here the ofbiz hash differs to other sha1 implementations Other examples: xx__xx__ 8cb2237d0679ca88db6464eac60da96345513964 = 12345 by "others" f3cd237d0679b5f7a4646495b90dd66345513964 = 12345 by ofbiz ____xxx_____xx__ 7c222fb2927d828af22f592134e8932480637c0d = 12345678 by others 7c222fcded7dfdf58d2f59213497ec24ff637c0d =
Re: AW: WG: SHA / SHA1 seed data and password encryption
I played with this a little bit while working on some other stuff... The best solution seems to use something "standard" like the Apache Commons Codex Hex class, which is an easier/better way to do the hex encoding there. The problem is if we change wholesale anyone who updates OFBiz will suddenly have a bunch of useless password data... so I've modified the HashCrypt class to support doing it both ways, and changes the userLogin service to try hashing it both ways to see if either matches. It seems to be working fine so if there are no complaints it'll be in soon... well as soon as the SVN server is up for commits again! -David On Apr 28, 2008, at 11:18 PM, David E Jones wrote: Martin, I agree that is odd, and not a good thing, and I'm really not sure why it is there or how it got there in the first place. It sounds like the proposal is to remove HashCrypt.java lines 52-53, 82-84. Does that sound correct, and does it give more consistent results to what you are seeing elsewhere? If so, let's get rid of 'em! -David On Apr 28, 2008, at 10:51 PM, Martin Wepper wrote: Jonathon, Thanks for your comments. it I understand it right we can not introduce other hashes to ofbiz without introducing the algorithm used to encrypt these. Hashes are one way - so mangling them after being once created is - hopefully for sec reasons- impossible. Here we need the clear text pass again. So other systems we introduce these ofbiz haches to may not use these without the ofbiz encryption - that’s bad - as it should comply to the standard or clearly state that’s its different/wrong as it seems not to be sha1. Kind Regards Martin -Ursprüngliche Nachricht- Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. April 2008 04:12 An: user@ofbiz.apache.org Betreff: Re: WG: SHA / SHA1 seed data and password encryption Martin, A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java Yup. That's where the OFBiz-specific implementation (or rehashing) is. Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Impact on vulnerability? No. In fact, it's slightly more secure. However, the increase in security is only slight. Check out the phrase "security by obscurity". I think I mentioned this some months back on the ML or JIRA. I can't guess what other reason OFBiz would have for making the hash different from the rest of the world. Seeding the password would be a more appropriate strategy for increased security (see https://issues.apache.org/jira/browse/OFBIZ-1151 ). The incompatibility may not pose a problem (I hope). You can still migrate passwords from other systems (not OFBiz, eg osCommerce) into OFBiz. The reason is that OFBiz does not mangle the original SHA hash beyond recovery (I hope, but don't think so). You just have to take the SHA hashes from other systems, pass it through OFBiz's mangling, and you have successfully ported those passwords into OFBiz. Someone please correct me if I'm wrong here; codes in HashCrypt.getDigestHash() (package org.ofbiz.base.crypto). If OFBiz does mangle the original SHA hash beyond recovery, then you cannot migrate passwords to and from OFBiz systems. Then this would be wrong, and needs to be fixed. This does seem to be the case in StringUtil.encodeInt(). We also talked about a "pluggable security system" to easily replace that OFBiz-specific chunk. Not sure if this is done yet. Jonathon Martin Wepper wrote: Dear , hopefully I do miss a point, but ... today we are experiencing a quite annoying issue with sha hashes: Please have a look at this: I'm simply listing hashes, let's start with the hash in seed/demo for "ofbiz": 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by debian4/sha1sum 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum 1.7.0, algorithm=sha1 but: 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin in demo-seed-data __xx__xx xx__xx__here the ofbiz hash differs to other sha1 implementations Other examples: xx__xx__ 8cb2237d0679ca88db6464eac60da96345513964 = 12345 by "others" f3cd237d0679b5f7a4646495b90dd66345513964 = 12345 by ofbiz ____xxx_____xx__ 7c222fb2927d828af22f592134e8932480637c0d = 12345678 by others 7c222fcded7dfdf58d2f59213497ec24ff637c0d = 12345678 by ofbiz ______xx__xxxx__ 2fb5e13419fc89246865e7a324f476ec624e8740 = abcdefg by others 2fca9e341983f624686598dc248b7693624ef840 = abcdefg
Re: AW: WG: SHA / SHA1 seed data and password encryption
Martin, Sorry, the chunk (below) I wrote in previous post is wrong. There is no way to port passwords between systems unless they all use the standard hashes and nothing else. Not even seeding. Seeding is a form of mangling of the password hashes. osCommerce employs seeding, so the passwords there cannot be ported over to OFBiz. Even if OFBiz correctly employs seeding, its passwords will also not be portable to other systems. The only way to port passwords between systems is to copy the mangling algo lock, stock, barrel. And now, in response to your post. > it I understand it right we can not introduce other hashes to ofbiz without > introducing the algorithm used to encrypt these. Absolutely right! > Hashes are one way - so mangling them after being once created is -hopefully > for sec reasons- impossible. Here we need the clear text pass again. Hashes are one-way, so they qualify to serve in password security systems. Mangling hashes in a fixed way (like OFBiz does) does not prevent dictionary attacks (a brute force attack that is rather cheap to execute). Mangling hashes in a random way (seeding/salting) makes dictionary attacks many times harder or more expensive. We can mangle hashes reversibly, but that would be pointless. What I had suggested (mangling hashes and still recovering original hash) is wrong. > So other systems we introduce these ofbiz haches to may not use these > without the ofbiz encryption Correct. > - that's bad - as it should comply to the standard or clearly state that's > its different/wrong as it seems not to be sha1. It's not bad, actually. That was my mistake for implying it is. There is really no standard way to salt/seed a hash. Some may append the salt to the end; some to front, some in middle. However, if there really is a standard way to do so, then yeah, portability of passwords is possible. In that case, then yes, it's bad of OFBiz not to follow such a standard (if it exists). As such, the only way to port passwords is to port the mangling algo. OFBiz's only missing (or not?) part in this is a "pluggable security architecture". It's not difficult to brute-force replace OFBiz's security, anyway. I haven't found the need to create a generic "pluggable architecture" for various security algos. Jonathon >> The incompatibility may not pose a problem (I hope). You can still >> migrate passwords from other systems (not OFBiz, eg osCommerce) >> into OFBiz. The reason is that OFBiz does not mangle the original >> SHA hash beyond recovery (I hope, but don't think so). You just >> have to take the SHA hashes from other systems, pass it through >> OFBiz's mangling, and you have successfully ported those passwords >> into OFBiz. Someone please correct me if I'm wrong here; codes in >> HashCrypt.getDigestHash() (package org.ofbiz.base.crypto). >> >> If OFBiz does mangle the original SHA hash beyond recovery, then >> you cannot migrate passwords to and from OFBiz systems. Then this >> would be wrong, and needs to be fixed. This does seem to be the >> case in StringUtil.encodeInt(). Martin Wepper wrote: Jonathon, Thanks for your comments. it I understand it right we can not introduce other hashes to ofbiz without introducing the algorithm used to encrypt these. Hashes are one way - so mangling them after being once created is -hopefully for sec reasons- impossible. Here we need the clear text pass again. So other systems we introduce these ofbiz haches to may not use these without the ofbiz encryption - that’s bad - as it should comply to the standard or clearly state that’s its different/wrong as it seems not to be sha1. Kind Regards Martin -----Ursprüngliche Nachricht- Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. April 2008 04:12 An: user@ofbiz.apache.org Betreff: Re: WG: SHA / SHA1 seed data and password encryption Martin, > A brief analysis shows that the implementation might start here being > problematic: > > getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java Yup. That's where the OFBiz-specific implementation (or rehashing) is. > Conclusion: the hashes in customer dbs are not really compatible with other > sha1 implementations today, bad for SSO. > Is there any impact on vulnerability of stored hashes created by ofbiz? Impact on vulnerability? No. In fact, it's slightly more secure. However, the increase in security is only slight. Check out the phrase "security by obscurity". I think I mentioned this some months back on the ML or JIRA. I can't guess what other reason OFBiz would have for making the hash different from the rest of the world. Seeding the password would be a more appropriate strategy for increased security (see https:
Re: AW: WG: SHA / SHA1 seed data and password encryption
Martin, I agree that is odd, and not a good thing, and I'm really not sure why it is there or how it got there in the first place. It sounds like the proposal is to remove HashCrypt.java lines 52-53, 82-84. Does that sound correct, and does it give more consistent results to what you are seeing elsewhere? If so, let's get rid of 'em! -David On Apr 28, 2008, at 10:51 PM, Martin Wepper wrote: Jonathon, Thanks for your comments. it I understand it right we can not introduce other hashes to ofbiz without introducing the algorithm used to encrypt these. Hashes are one way - so mangling them after being once created is - hopefully for sec reasons- impossible. Here we need the clear text pass again. So other systems we introduce these ofbiz haches to may not use these without the ofbiz encryption - that’s bad - as it should comply to the standard or clearly state that’s its different/wrong as it seems not to be sha1. Kind Regards Martin -Ursprüngliche Nachricht- Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. April 2008 04:12 An: user@ofbiz.apache.org Betreff: Re: WG: SHA / SHA1 seed data and password encryption Martin, A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java Yup. That's where the OFBiz-specific implementation (or rehashing) is. Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Impact on vulnerability? No. In fact, it's slightly more secure. However, the increase in security is only slight. Check out the phrase "security by obscurity". I think I mentioned this some months back on the ML or JIRA. I can't guess what other reason OFBiz would have for making the hash different from the rest of the world. Seeding the password would be a more appropriate strategy for increased security (see https://issues.apache.org/jira/browse/OFBIZ-1151 ). The incompatibility may not pose a problem (I hope). You can still migrate passwords from other systems (not OFBiz, eg osCommerce) into OFBiz. The reason is that OFBiz does not mangle the original SHA hash beyond recovery (I hope, but don't think so). You just have to take the SHA hashes from other systems, pass it through OFBiz's mangling, and you have successfully ported those passwords into OFBiz. Someone please correct me if I'm wrong here; codes in HashCrypt.getDigestHash() (package org.ofbiz.base.crypto). If OFBiz does mangle the original SHA hash beyond recovery, then you cannot migrate passwords to and from OFBiz systems. Then this would be wrong, and needs to be fixed. This does seem to be the case in StringUtil.encodeInt(). We also talked about a "pluggable security system" to easily replace that OFBiz-specific chunk. Not sure if this is done yet. Jonathon Martin Wepper wrote: Dear , hopefully I do miss a point, but ... today we are experiencing a quite annoying issue with sha hashes: Please have a look at this: I'm simply listing hashes, let's start with the hash in seed/demo for "ofbiz": 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by debian4/sha1sum 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum 1.7.0, algorithm=sha1 but: 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin in demo-seed-data __xx__xx xx__xx__here the ofbiz hash differs to other sha1 implementations Other examples: xx__xx__ 8cb2237d0679ca88db6464eac60da96345513964 = 12345 by "others" f3cd237d0679b5f7a4646495b90dd66345513964 = 12345 by ofbiz ____xxx_____xx__ 7c222fb2927d828af22f592134e8932480637c0d = 12345678 by others 7c222fcded7dfdf58d2f59213497ec24ff637c0d = 12345678 by ofbiz ______xx__xxxx__ 2fb5e13419fc89246865e7a324f476ec624e8740 = abcdefg by others 2fca9e341983f624686598dc248b7693624ef840 = abcdefg by ofbiz A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java ... int i1 = digestBytes[l]; if (i1 < 0) i1 = 127 + i1 * -1; StringUtil.encodeInt(i1, k, digestChars); ... The bit operations introduced in StringUtil.encodeInt do not comply to the way the int is calculated before. Example: Digest of -116 should result in 0x8c but in our ofbiz code it is resulting in 0xf3 But: -116 = 0b10001100 = 0x8c - ok for sha1 127 + -116*-1 = 243 = 0b0011 = 0xf3 for obfiz-sha The digest is calculated properly, but when converting to hex string the function seems to fail on negative byte/int values, only. This has
AW: WG: SHA / SHA1 seed data and password encryption
Jonathon, Thanks for your comments. it I understand it right we can not introduce other hashes to ofbiz without introducing the algorithm used to encrypt these. Hashes are one way - so mangling them after being once created is -hopefully for sec reasons- impossible. Here we need the clear text pass again. So other systems we introduce these ofbiz haches to may not use these without the ofbiz encryption - thats bad - as it should comply to the standard or clearly state thats its different/wrong as it seems not to be sha1. Kind Regards Martin > -Ursprüngliche Nachricht- > Von: Jonathon -- Improov [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 29. April 2008 04:12 > An: user@ofbiz.apache.org > Betreff: Re: WG: SHA / SHA1 seed data and password encryption > > Martin, > > > A brief analysis shows that the implementation might start here > being > > problematic: > > > > getDigestHash in > trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java > > Yup. That's where the OFBiz-specific implementation (or rehashing) is. > > > Conclusion: the hashes in customer dbs are not really compatible > with other > > sha1 implementations today, bad for SSO. > > Is there any impact on vulnerability of stored hashes created by > ofbiz? > > Impact on vulnerability? No. In fact, it's slightly more secure. > > However, the increase in security is only slight. Check out the phrase > "security by obscurity". I > think I mentioned this some months back on the ML or JIRA. I can't > guess what other reason OFBiz > would have for making the hash different from the rest of the world. > Seeding the password would be > a more appropriate strategy for increased security (see > https://issues.apache.org/jira/browse/OFBIZ-1151 ). > > The incompatibility may not pose a problem (I hope). You can still > migrate passwords from other > systems (not OFBiz, eg osCommerce) into OFBiz. The reason is that OFBiz > does not mangle the > original SHA hash beyond recovery (I hope, but don't think so). You > just have to take the SHA > hashes from other systems, pass it through OFBiz's mangling, and you > have successfully ported > those passwords into OFBiz. Someone please correct me if I'm wrong > here; codes in > HashCrypt.getDigestHash() (package org.ofbiz.base.crypto). > > If OFBiz does mangle the original SHA hash beyond recovery, then you > cannot migrate passwords to > and from OFBiz systems. Then this would be wrong, and needs to be > fixed. This does seem to be the > case in StringUtil.encodeInt(). > > We also talked about a "pluggable security system" to easily replace > that OFBiz-specific chunk. > Not sure if this is done yet. > > Jonathon > > Martin Wepper wrote: > > Dear , > > > > hopefully I do miss a point, but ... > > today we are experiencing a quite annoying issue with sha hashes: > > > > Please have a look at this: > > > > I'm simply listing hashes, let's start with the hash in seed/demo > for > > "ofbiz": > > > > 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by > debian4/sha1sum > > 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php > > 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum > 1.7.0, > > algorithm=sha1 > > but: > > 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin > in > > demo-seed-data > > __xx__xx xx__xx__here the ofbiz hash > differs to > > other sha1 implementations > > > > Other examples: > > xx__xx__ > > 8cb2237d0679ca88db6464eac60da96345513964 = 12345 by "others" > > f3cd237d0679b5f7a4646495b90dd66345513964 = 12345 by ofbiz > > > > ____xxx_____xx__ > > 7c222fb2927d828af22f592134e8932480637c0d = 12345678 by others > > 7c222fcded7dfdf58d2f59213497ec24ff637c0d = 12345678 by ofbiz > > > > ______xx__xxxx__ > > 2fb5e13419fc89246865e7a324f476ec624e8740 = abcdefg by others > > 2fca9e341983f624686598dc248b7693624ef840 = abcdefg by ofbiz > > > > > > A brief analysis shows that the implementation might start here being > > problematic: > > > > getDigestHash in > trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java > > > > ... > > int i1 = digestBytes[l]; > > if (i1 < 0) > > i1 = 127 + i1 * -1; > > StringUtil.encodeInt(i1, k, digestChars); > > ... > > > > The bit operations introduced in StringUtil.encodeInt do not comply > to the > >
Re: WG: SHA / SHA1 seed data and password encryption
Martin, > A brief analysis shows that the implementation might start here being > problematic: > > getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java Yup. That's where the OFBiz-specific implementation (or rehashing) is. > Conclusion: the hashes in customer dbs are not really compatible with other > sha1 implementations today, bad for SSO. > Is there any impact on vulnerability of stored hashes created by ofbiz? Impact on vulnerability? No. In fact, it's slightly more secure. However, the increase in security is only slight. Check out the phrase "security by obscurity". I think I mentioned this some months back on the ML or JIRA. I can't guess what other reason OFBiz would have for making the hash different from the rest of the world. Seeding the password would be a more appropriate strategy for increased security (see https://issues.apache.org/jira/browse/OFBIZ-1151 ). The incompatibility may not pose a problem (I hope). You can still migrate passwords from other systems (not OFBiz, eg osCommerce) into OFBiz. The reason is that OFBiz does not mangle the original SHA hash beyond recovery (I hope, but don't think so). You just have to take the SHA hashes from other systems, pass it through OFBiz's mangling, and you have successfully ported those passwords into OFBiz. Someone please correct me if I'm wrong here; codes in HashCrypt.getDigestHash() (package org.ofbiz.base.crypto). If OFBiz does mangle the original SHA hash beyond recovery, then you cannot migrate passwords to and from OFBiz systems. Then this would be wrong, and needs to be fixed. This does seem to be the case in StringUtil.encodeInt(). We also talked about a "pluggable security system" to easily replace that OFBiz-specific chunk. Not sure if this is done yet. Jonathon Martin Wepper wrote: Dear , hopefully I do miss a point, but ... today we are experiencing a quite annoying issue with sha hashes: Please have a look at this: I'm simply listing hashes, let's start with the hash in seed/demo for "ofbiz": 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by debian4/sha1sum 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum 1.7.0, algorithm=sha1 but: 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin in demo-seed-data __xx__xx xx__xx__here the ofbiz hash differs to other sha1 implementations Other examples: xx__xx__ 8cb2237d0679ca88db6464eac60da96345513964 = 12345 by "others" f3cd237d0679b5f7a4646495b90dd66345513964 = 12345 by ofbiz ____xxx_____xx__ 7c222fb2927d828af22f592134e8932480637c0d = 12345678 by others 7c222fcded7dfdf58d2f59213497ec24ff637c0d = 12345678 by ofbiz ______xx__xxxx__ 2fb5e13419fc89246865e7a324f476ec624e8740 = abcdefg by others 2fca9e341983f624686598dc248b7693624ef840 = abcdefg by ofbiz A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java ... int i1 = digestBytes[l]; if (i1 < 0) i1 = 127 + i1 * -1; StringUtil.encodeInt(i1, k, digestChars); ... The bit operations introduced in StringUtil.encodeInt do not comply to the way the int is calculated before. Example: Digest of -116 should result in 0x8c but in our ofbiz code it is resulting in 0xf3 But: -116 = 0b10001100 = 0x8c - ok for sha1 127 + -116*-1 = 243 = 0b0011 = 0xf3 for obfiz-sha The digest is calculated properly, but when converting to hex string the function seems to fail on negative byte/int values, only. This has been introduced in 2004-09-09 21:06:36 UTC (rev 3317) Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Martin -- Martin Wepper ZYRES digital media systems GmbH Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Phone +49 (0)69 98 55 99 - 0 Fax +49 (0)69 98 55 99 - 11 Firmensitz: Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Registergericht: Amtsgericht Frankfurt am Main, HRB 76374 Geschäftsführer: Sebastian Schirmer, Martin Wepper http://www.zyres.com/ --
WG: SHA / SHA1 seed data and password encryption
Dear , hopefully I do miss a point, but ... today we are experiencing a quite annoying issue with sha hashes: Please have a look at this: I'm simply listing hashes, let's start with the hash in seed/demo for "ofbiz": 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by debian4/sha1sum 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum 1.7.0, algorithm=sha1 but: 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin in demo-seed-data __xx__xx xx__xx__here the ofbiz hash differs to other sha1 implementations Other examples: xx__xx__ 8cb2237d0679ca88db6464eac60da96345513964 = 12345 by "others" f3cd237d0679b5f7a4646495b90dd66345513964 = 12345 by ofbiz ____xxx_____xx__ 7c222fb2927d828af22f592134e8932480637c0d = 12345678 by others 7c222fcded7dfdf58d2f59213497ec24ff637c0d = 12345678 by ofbiz ______xx__xxxx__ 2fb5e13419fc89246865e7a324f476ec624e8740 = abcdefg by others 2fca9e341983f624686598dc248b7693624ef840 = abcdefg by ofbiz A brief analysis shows that the implementation might start here being problematic: getDigestHash in trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java ... int i1 = digestBytes[l]; if (i1 < 0) i1 = 127 + i1 * -1; StringUtil.encodeInt(i1, k, digestChars); ... The bit operations introduced in StringUtil.encodeInt do not comply to the way the int is calculated before. Example: Digest of -116 should result in 0x8c but in our ofbiz code it is resulting in 0xf3 But: -116 = 0b10001100 = 0x8c - ok for sha1 127 + -116*-1 = 243 = 0b0011 = 0xf3 for obfiz-sha The digest is calculated properly, but when converting to hex string the function seems to fail on negative byte/int values, only. This has been introduced in 2004-09-09 21:06:36 UTC (rev 3317) Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Martin -- Martin Wepper ZYRES digital media systems GmbH Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Phone +49 (0)69 98 55 99 - 0 Fax +49 (0)69 98 55 99 - 11 Firmensitz: Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Registergericht: Amtsgericht Frankfurt am Main, HRB 76374 Geschäftsführer: Sebastian Schirmer, Martin Wepper http://www.zyres.com/ --
SHA / SHA1 seed data and password encryption
Dear , hopefully I miss a point, but today we are experiencing a quite interesting issue which might heavily influence the security of many ofbiz installations - but I'm not mathematician enough to see how/if this lowers the security of the saved hashes Please have a look at this: I'm simply listing hashes let's start with the hash in seed/demo for "ofbiz": 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by debian4/sha1sum 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz hashed by php 47b56994cbc2b6d10aa1be30f70165adb305a41a = ofbiz by java - Jacksum 1.7.0, algorithm=sha1 but: 47ca69ebb4bdc9ae0adec130880165d2cc05db1a = ofbiz password for admin in demo-seed-data __xx__xx xx__xx__here the ofbiz hash differs to other sha1 implementations Other examples: xx__xx__ 8cb2237d0679ca88db6464eac60da96345513964 = 12345 by "others" f3cd237d0679b5f7a4646495b90dd66345513964 = 12345 by ofbiz ____xxx_____xx__ 7c222fb2927d828af22f592134e8932480637c0d = 12345678 by others 7c222fcded7dfdf58d2f59213497ec24ff637c0d = 12345678 by ofbiz ______xx__xxxx__ 2fb5e13419fc89246865e7a324f476ec624e8740 = abcdefg by others 2fca9e341983f624686598dc248b7693624ef840 = abcdefg by ofbiz A brief analysis shows that the implementation might start here being problematic: getDigestHash trunk/base/src/base/org/ofbiz/base/crypto/HashCrypt.java ... int i1 = digestBytes[l]; if (i1 < 0) i1 = 127 + i1 * -1; StringUtil.encodeInt(i1, k, digestChars); ... The bit operations introduced in encodeInt do not comply to the way the int is calculated before. Example: Digest of -116 should result in 0x8c but in our ofbiz code it is resulting in 0xf3 But: -116 = 0b10001100 = 0x8c for sha1 127 + -116*-1 = 243 = 0b0011 = 0xf3 for obfiz-sha The digest is calculated properly, but when converting to hex string the function seems to fail on negative byte/int values, only. This has been introduced in 2004-09-09 21:06:36 UTC (rev 3317) Conclusion: the hashes in customer dbs are not really compatible with other sha1 implementations today, bad for SSO. Is there any impact on vulnerability of stored hashes created by ofbiz? Martin -- Martin Wepper ZYRES digital media systems GmbH Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Phone +49 (0)69 98 55 99 - 0 Fax +49 (0)69 98 55 99 - 11 Firmensitz: Eschersheimer Landstr. 5-7 60322 Frankfurt am Main Registergericht: Amtsgericht Frankfurt am Main, HRB 76374 Geschäftsführer: Sebastian Schirmer, Martin Wepper http://www.zyres.com/ --
Re: missing Uom seed data?
I can't see nay bottles anywhere. Do you mean bottle=75 cl (3/4 liter) ? In such case it could be added I guess. Jacques From: "Bilgin Ibryam" <[EMAIL PROTECTED]> Hi, I need to define UOM - bottle for some of the products but I cannot find it. There are already Barrel, Cup, Pint... but none of them is a bottle. Do i miss something or bottle is missing in Uom seed data? Bilgin -- View this message in context: http://www.nabble.com/missing-Uom-seed-data--tp16001748p16001748.html Sent from the OFBiz - User mailing list archive at Nabble.com.
missing Uom seed data?
Hi, I need to define UOM - bottle for some of the products but I cannot find it. There are already Barrel, Cup, Pint... but none of them is a bottle. Do i miss something or bottle is missing in Uom seed data? Bilgin -- View this message in context: http://www.nabble.com/missing-Uom-seed-data--tp16001748p16001748.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: seed data and demo data
The text in there was poorly written and didn't really use the "seed" term properly. I've changed that and added a definition of seed data. -David Eric Schwartz wrote: I am writing documentation for ofbiz and i am confused as to actually how the demo data and seed data is broken up. This is a snippet from the productions setup guide. Expert Recommendation: For smaller installations we recommend loading the demo data and modifying it rather than creating all of the data from scratch. For larger installations we recommend creating seed data files with your own settings, copied from the demo seed data, or simply creating all data from scratch. These can be added to the "ext" set of install data files, which is done by referencing those files in an ofbiz-component.xml file entity-resource tag with the attribute reader-name="ext". To load the "seed" and "ext" groups run something like: "java -jar ofbiz.jar -install -readers=seed,ext" to me this is clear. either modify the exisiting demo and seed data for your purposes or be brave and create new based on the exisiting files. my question is why out of the box is some data seed data and some data demo data. What determines if it should have a reader of demo or seed out of the box? What would make sense to me is that everything out of the box is demo and stuff you add should be seed. Please help me understand this.
Re: seed data and demo data
Hello Eric, Seed data would be the one that will not change between installations and that is needed for ofbiz to work properly like GeoData (countries, states and the like) units of currency like USD, EUR and the admin user account (without a user you will not be able to access ofbiz) Demo data is more concept-free and for demonstration purposes, it creates customers, suppliers, warehouses, products, etc ... -- Daniel Eric Schwartz escribió: > I am writing documentation for ofbiz and i am confused as to actually how > the demo data and seed data is broken up. This is a snippet from the > productions setup guide. > > Expert Recommendation: For smaller installations we recommend loading the > demo data and modifying it rather than creating all of the data from > scratch. > > For larger installations we recommend creating seed data files with your own > settings, copied from the demo seed data, or simply creating all data from > scratch. These can be added to the "ext" set of install data files, which is > done by referencing those files in an ofbiz-component.xml file > entity-resource tag with the attribute reader-name="ext". To load the "seed" > and "ext" groups run something like: > > "java -jar ofbiz.jar -install -readers=seed,ext" > > to me this is clear. either modify the exisiting demo and seed data for your > purposes or be brave and create new based on the exisiting files. my > question is why out of the box is some data seed data and some data demo > data. What determines if it should have a reader of demo or seed out of the > box? What would make sense to me is that everything out of the box is demo > and stuff you add should be seed. Please help me understand this. > >
seed data and demo data
I am writing documentation for ofbiz and i am confused as to actually how the demo data and seed data is broken up. This is a snippet from the productions setup guide. Expert Recommendation: For smaller installations we recommend loading the demo data and modifying it rather than creating all of the data from scratch. For larger installations we recommend creating seed data files with your own settings, copied from the demo seed data, or simply creating all data from scratch. These can be added to the "ext" set of install data files, which is done by referencing those files in an ofbiz-component.xml file entity-resource tag with the attribute reader-name="ext". To load the "seed" and "ext" groups run something like: "java -jar ofbiz.jar -install -readers=seed,ext" to me this is clear. either modify the exisiting demo and seed data for your purposes or be brave and create new based on the exisiting files. my question is why out of the box is some data seed data and some data demo data. What determines if it should have a reader of demo or seed out of the box? What would make sense to me is that everything out of the box is demo and stuff you add should be seed. Please help me understand this. -- Eric Schwartz Web Developer/IT Staff Steele Rubber Products 6180 E NC 150 HWY Denver, NC 28037 704-483-9343 ext 273 Fax: 704-483-6650
Re: Question about Loading of DEMO and SEED data.
seed data (without demo) is loaded with 'ant run-install-seed' When loading seed data, you should see an entry like this in the logs: 2007-06-27 22:13:25,206 (main) [EntityDataLoadContainer.java:110:INFO ] Install Argument - readers = seed While it loads data from each xml file, you will see entries in the log for [EntityDataLoadContainer.java:257:INFO ] which will include the name of the file that is being loaded. Krzysztof Podejma wrote: > demo is loaded only with ant run-install > > 2007/6/28, kpieleck <[EMAIL PROTECTED]>: >> >> >> 1. Do the xml files listed in the ofbiz-component.xml in hot-deploy >> always >> get loaded by the component on startup. >> 2. If they always get loaded, and their readername is "demo" - what is >> the >> best way to prevent the demo data from loading, (comment out the lines - >> or >> is there a switch somewhere else to prevent certain data types from >> loading?). >> 3. Do any logs show what data is loading on startup? >> >> Thanks for your help. >> >> -- >> View this message in context: >> http://www.nabble.com/Question-about-Loading-of-DEMO-and-SEED-data.-tf3995055.html#a11345473 >> >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> > -- Millcreek Systems, Inc. P.O. Box 9835 Salt Lake City, Utah 84109 Phone: 801.649.4903 Skype: millcreeksys (http://millcreeksys.com/skype/)
Re: Question about Loading of DEMO and SEED data.
demo is loaded only with ant run-install 2007/6/28, kpieleck <[EMAIL PROTECTED]>: 1. Do the xml files listed in the ofbiz-component.xml in hot-deploy always get loaded by the component on startup. 2. If they always get loaded, and their readername is "demo" - what is the best way to prevent the demo data from loading, (comment out the lines - or is there a switch somewhere else to prevent certain data types from loading?). 3. Do any logs show what data is loading on startup? Thanks for your help. -- View this message in context: http://www.nabble.com/Question-about-Loading-of-DEMO-and-SEED-data.-tf3995055.html#a11345473 Sent from the OFBiz - User mailing list archive at Nabble.com.
Question about Loading of DEMO and SEED data.
1. Do the xml files listed in the ofbiz-component.xml in hot-deploy always get loaded by the component on startup. 2. If they always get loaded, and their readername is "demo" - what is the best way to prevent the demo data from loading, (comment out the lines - or is there a switch somewhere else to prevent certain data types from loading?). 3. Do any logs show what data is loading on startup? Thanks for your help. -- View this message in context: http://www.nabble.com/Question-about-Loading-of-DEMO-and-SEED-data.-tf3995055.html#a11345473 Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: State Tax Authority Seed Data
We have dealers in almost every state, and they must be made tax-exempt. Tim Ruppert wrote: David they're often very particular to the company. Why do you need to charge sales state in every state? I've got all the counties in calfifornia mapped out if that is helpful, but my guess is that you guys will only need NC and potentially another state if you have another warehouse. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Jun 27, 2007, at 7:12 AM, David Shere wrote: I am attempting to create seed data for all of the tax authorities in the US. Looking roughly like this: partyTypeID="GOVERNMENT_AGENCY"/> I'm hoping that someone out there has this already typed up. If you do and if you could be gracious enough to provide it, I will be your friend forever and worship the ground you walk upon. -- David Shere Information Technology Services Steele Rubber Products www.SteeleRubber.com -- David Shere Information Technology Services Steele Rubber Products www.SteeleRubber.com
Re: State Tax Authority Seed Data
David they're often very particular to the company. Why do you need to charge sales state in every state? I've got all the counties in calfifornia mapped out if that is helpful, but my guess is that you guys will only need NC and potentially another state if you have another warehouse. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Jun 27, 2007, at 7:12 AM, David Shere wrote: I am attempting to create seed data for all of the tax authorities in the US. Looking roughly like this: I'm hoping that someone out there has this already typed up. If you do and if you could be gracious enough to provide it, I will be your friend forever and worship the ground you walk upon. -- David Shere Information Technology Services Steele Rubber Products www.SteeleRubber.com smime.p7s Description: S/MIME cryptographic signature
State Tax Authority Seed Data
I am attempting to create seed data for all of the tax authorities in the US. Looking roughly like this: partyTypeID="GOVERNMENT_AGENCY"/> I'm hoping that someone out there has this already typed up. If you do and if you could be gracious enough to provide it, I will be your friend forever and worship the ground you walk upon. -- David Shere Information Technology Services Steele Rubber Products www.SteeleRubber.com
"ant run-install " failed to install demo & seed data
Hi All, Just got the latest ofbiz yesterday from svn "co https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz" What I did: 1. cleaned up mysql database by creating a new schema & user/password 2. updated entityengine.xml to use localmysql & set add-missing-on-start="false" 3. tried to install demo & seed data by running "ant run-install" but could not make it work. I noticed that there is no table created under my schema. Previously I don't have such issue. Only with the latest OfBiz from SVN that I encountered this. I have looked at the instruction on how to run OfBiz I have tried the following sequence few times but the problem persist: 1. ant clean 2. ant run-install Are there any other changes required with the latest version of OfBiz? I have searched the Forum but nobody seems to have similar issue previously. Below is what I noticed in the console: [I noticed a number warnings] [java] 2007-06-22 13:39:23,703 (main) [ModelViewEntity.java:461:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: statusDelay of view-entity ExampleStatusDetail [java] 2007-06-22 13:39:23,796 (main) [ModelViewEntity.java:625:INFO ] Throwing out field alias in view entity InventoryItemAndLocation because one already exists with the alias name [facilityId] and field name [PR(Product).facilityId], existing field name is [II.facilityId] [java] 2007-06-22 13:39:23,796 (main) [ModelViewEntity.java:625:INFO ] Throwing out field alias in view entity InventoryItemAndLocation because one already exists with the alias name [comments] and field name [PR(Product).comments], existing field name is [II.comments] [java] 2007-06-22 13:39:23,843 (main) [ModelViewEntity.java:461:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemQuantityReportGroupByItem [It is checking database] [java] 2007-06-22 13:39:24,437 (main) [ GenericDelegator.java:182:INFO ] Doing database check as requested in entityengine.xml with addMissing=false [java] 2007-06-22 13:39:24,812 (main) [ DatabaseUtil.java:760:INFO ] Database Product Name is MySQL [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:761:INFO ] Database Product Version is 5.0.17-nt [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:769:INFO ] Database Driver Name is MySQL-AB JDBC Driver [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:770:INFO ] Database Driver Version is mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) [Getting table info and give warnings:] [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:853:INFO ] Getting Table Info From Database [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN ] Entity [AcctgTrans]has no table in the database [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN ] Entity [AcctgTransAttribute] has no table in the database [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN ] Entity [AcctgTransEntry] has no table in the database [Register Dispatcher] [java] 2007-06-22 13:39:25,437 (main) [ ServiceDispatcher.java:166:INFO ] Registered dispatcher: entity-default [java] 2007-06-22 13:39:25,500 (main) [ ModelServiceReader.java:208:INFO ] Loaded 47 Service definitions from file:/C:/MyAppl/OfBiz/framework/common/servicedef/services.xml [java] 2007-06-22 13:39:25,531 (main) [ ModelServiceReader.java:208:INFO ] Loaded 28 Service definitions from file:/C:/MyAppl/OfBiz/framework/common/servicedef/services_test.xml [It is loading data] [java] 2007-06-22 13:39:27,171 (main) [EntityDataLoadContainer.java:253:INFO ] =-=-=-=-=-=-= Doing a data load with the following files: [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO ] file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO ] file:/C:/MyAppl/OfBiz/framework/common/data/CommonSecurityData.xml [Start loading data but failed causing transaction rollback] [java] 2007-06-22 13:39:27,250 (main) [EntityDataLoadContainer.java:260:INFO ] =-=-=-=-=-=-= Starting the data load... [java] 2007-06-22 13:39:27,265 (main) [EntitySaxReader.java:195:INFO ] Beginning import from URL: file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml [java] 2007-06-22 13:39:27,281 (main) [EntitySaxReader.java:233:INFO ] Transaction Timeoutset to 2 hours (7200 seconds) [java] 2007-06-22 13:39:27,296 (main) [
Re: seed data for primary cattagory table
You'll find most demo data (if not all) in the ecommerce data directory, alternatively you should be able to search for "Demo*.xml" to find demo data files and then again you can also do a text search for "productCategory" or even the product category Id you know exists in the demo data to narrow it down more. Ray amit charaya wrote: > please can anybody tell me where is seed data for the table (entity) > productCategory in product application is located. > > thanks for help > >
seed data for primary cattagory table
please can anybody tell me where is seed data for the table (entity) productCategory in product application is located. thanks for help -- View this message in context: http://www.nabble.com/seed-data-for-primary-cattagory-table-tf3940093.html#a11175069 Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Recreating database using real data and seed data
Chris- Thank you! This will be much easier! -Dave Chris Howe wrote: You would do this through the entity-data-reader(s) In the ofbiz-component.xml in the ecommerce component for example you'll notice the demo data is defined as location="data/DemoProduct.xml"/> for your data you would simply add --- Dave Tenerowicz <[EMAIL PROTECTED]> wrote: We are finding that we need to recreate the database periodically in the course of development by re-loading the seed data . However, we also have some "real" catalog, category and product data included in the development instance for testing purposes. Currently we re-load the seed data, then re-import some actual representative "real" catalog/category/product data via XML data import. Is this the best way to do this? Is there some way to incorporate some "real" data into a copy of seed data so we don't have to do the multi step import each time? How are others dealing with this sort of thing? -- Dave Tenerowicz [EMAIL PROTECTED] Office: 303.493.6727 Mobile 303.906.6116 Fax 303.814.8330 Visit us at http://www.salmonllc.com -- Dave Tenerowicz [EMAIL PROTECTED] Office: 303.493.6727 Mobile 303.906.6116 Fax 303.814.8330 Visit us at http://www.salmonllc.com