Home Technology OFBiz ERP - Apache Open For Business How to Install ofBiz on openSUSE 11 - Page 6
 
How to Install ofBiz on openSUSE 11 - Page 6
Written by Bill Harder   
Friday, 14 November 2008 08:16

Now we need to edit our database entries so that ofbiz will use mysql.  Launch Dolphin File Manager and navigate to "/opt/ofbiz/framework/entity/config"  Point to the file "entityengine.xml", right cllick - Open With - KWrite.  Scroll down to <delegator name="default" and locate the entry that says datasource-name="localderby"/>.  Change"localderby" to "localmysql".  Scroll about halfway down the file to the entry for  <datasource name="localmysql" and change the jdbc-username="ofbiz" to "ofbizadmin" and change the password to"*ofbiz01" or whatever you created in the steps prior.  Save and then exit the file.

In order for ofbiz to use mysql we need to copy the mysql-connector-java-3.1.12.jar to the ofbiz directory.   Adjust for version number changes.  Switch program to the Dolphin File Manager and navigate to /usr/share/java and right click on the mysql-connector-java-3.1.12.jar, right click, then click on Copy, then navigate to /opt/ofbiz/framework/entity/lib/jdbc, right click in the white window section and click on paste file.

Lets switch back to the Terminal Window and type "java -jar ofbiz.jar -install -readers=seed,seed-initial" and then press enter.  This will create the tables in the database and load the initial seed data that is required for the program to operate.  Upon completion you need to type "ant run" and press enter.  This will start the ofbiz program. When you see "NOTICE: BeanShell service ports are not secure. Please protect the ports" this means that the startup is complete and you can now go to Firefox web browser and type in "https://127.0.0.1:8443/webtools/control/main" and press enter.  This will get you to the main logon screen.



Last Updated on Tuesday, 16 December 2008 17:09