WebShop/UnderDevelopment/OfBiz (2005-05-13 13:39:34)

Only for developers - or rather ofbiz enthusiasts

WebShop/UnderDevelopment/OfBiz/TestCases lists the functionality we use.

[Screenshot] of OfBiz running on my laptop.

Apache/Tomcat/OfBiz running on my laptop

MaxDB running on my garage computer

Mozilla running on my livingroom computer

Progress was MUCH slower than I wanted, but the best part is it's running all together with Apache and Tomcat, and to sweeten the deal, I finally understand it! -Jason

Now to populate the DB with all the products... and keep a good system of categories.


should I install a local ofbiz on my home system?

Only if you plan to play with versions, features, upgrades, etc.

It's very easy (takes 15 mins besides some svn download time) if


Ofbiz steps

These are just notes, check the ofbiz.org docs. I'll help if you run into problems.

The original configuration refers to derby database, you want to change it to postgres (maybe maxdb or oracle, but not mysql): \n

 cat /opt/ofbiz-postgres.patch
--- ofbiz-old/components/entity/config/entityengine.xml 2004-10-21 03:14:27.000000000 +0200
+++ ofbiz/components/entity/config/entityengine.xml     2004-10-21 10:59:02.000000000 +0200
@@ -33,4 +33,4 @@
     <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
-        <group-map group-name="org.ofbiz" datasource-name="localderby"/>
+        <group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
     </delegator>


Ofbiz via Apache

Since IP address (and sometimes even domain names) are a limited resource, and stupidly configured firewalls/proxies often refuse to access https://domain...:8443/ (https through port 8443 or actually any other ports than 443), it is desirable to connect to the application server that is behind an Apache server. The apache connects to the container (which is by default not tomcat, but jetty as shipped in ofbiz).

On the biztest machine I had to stop tomcat so ofbiz can run. However, I cannot do that on the new (faster CPU + mem + network!!), production machine. I changed port 8009 to 18009 in base/config/ofbiz-containers...whatever.xml but it still has a cannot bind error when trying to listen. (I'm not very familier with these, is it IIOP or ??)

Suggestions?

Anyone got ofbiz running, and accessed via apache https ? Jason ? Please point to link of "how" and recommend anything to watch out for.

Usually where httpd.conf is. Not sure what is needed. I thought about this:\nÿ2ÿ

The machine is Debian of course.

Assume /opt/ofbiz is a symlink to an uptodate svn ofbiz checked out & compiled.


Mass registration of products

Everything is so nice with the XML formats and import-export tools in webtools. Also check entity-data maintenance, where every attribute can be viewed or changed (with the right permissions, but we use fulladmin now)


self-registration of new parties

Because of the work-effort module, it would be nice if


Shopkeepers, please update your stock ASAP

After some practicing, you'll find that ofbiz is very intuitive. We use products, facility, inventory, party and inventory transfer.

We'll use more and more features, like work effort management, manufacturing, and who knows..

Let me know if you have problems.

Speed - after moved from my home PC to a machine with superior network connection (and some free RAM).

Speed improved. The earlier 512 MByte system (with poor network connectivity) was tight for an SAP-like system with DB + application + webserver + girlfriend using it as a desktop.

Speed will be even better once we use the apache not the internal webserver.


Article master

Jason will

I thought that you planned to do the article master on your (garage?) machine and import into the system through XML (or through the EntitySync gizmo that I couldn't fully understand yet).

If you run into foreign key exceptions (likely with the category because of the parent category key) you can drop all foreign keys, import, than recreate fk (takes 1.5 minutes each).


Migration from current shop to ofbiz

I expect the following advantages:


User rights in the test sys

I think we want to import products (and most data) into the test systems, but not the users. It's fine to have some shared usernames for testing (or same users but different passwords). The passwords shouldn't be public :-) I wiped the standard passwords of course.


Ofbiz upgrade

I'm thinking of setting oscommerce (current shop) stock to all 10000 at the time of the stock update, so ofbiz stock-adjustments can take that into account later (somehow).

WebShop/UnderDevelopment/OfBiz/VersionUpgrade