Run OFBiz with MySQL - 王朝网络宽屏版

**************************************************

*** How to run OFBiz with MySQL ***

**************************************************

##################################################

### Download ofbiz source with svn

##################################################

Anonymous (Guest) Access

To connect to the OFBiz SVN Respository for anonymous checkout use your SVN client command line tool:

$ svn co http://svn.ofbiz.org/svn/ofbiz/trunk ofbiz

##################################################

### Create Database&User for OFBiz

##################################################

mysql>create database ofbiz_mysql;

mysql>grant all on *.* to ofbiz_mysql@localhost identified by 'ofbiz_mysql' with grant option;

mysql>create database ofbiz_odbc_mysql;

mysql>grant all on *.* to ofbiz_odbc_mysql@localhost identified by 'ofbiz_odbc_mysql' with grant option;

##################################################

### Set OFBiz Environment

##################################################

----------------------------------------------------------------------------------------------------

set JAVA_HOME=C:\j2sdk1.4.2_04

set CLASSPATH=C:\j2sdk1.4.2_04\lib\dt.jar;C:\j2sdk1.4.2_04\lib\tools.jar;.

----------------------------------------------------------------------------------------------------

#############################################################################

### Modify the [%OFBIZ_HOME%\framework\entity\config\entityengine.xml] file

#############################################################################

----------------------------------------------------------------------------------------------------

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

modify the follow segment:

<group-map group-name="org.ofbiz" datasource-name="localderby"/>

<group-map group-name="org.ofbiz.odbc" datasource-name="localderbyodbc"/>

</delegator>

to:

<group-map group-name="org.ofbiz" datasource-name="localmysql"/>

<group-map group-name="org.ofbiz.odbc" datasource-name="odbcmysql"/>

</delegator>

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

addition,modify the follow segment:

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

<datasource name="localmysql"

helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"

field-type-name="mysql"

check-on-start="true"

add-missing-on-start="true"

check-pks-on-start="false"

use-foreign-keys="true"

join-style="ansi-no-parenthesis"

alias-view-columns="true"

drop-fk-use-foreign-key-keyword="true"

table-type="InnoDB"

character-set="latin1"

collate="latin1_general_cs">

<read-data reader-name="seed"/>

<read-data reader-name="demo"/>

<read-data reader-name="ext"/>

<inline-jdbc

jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"

jdbc-username="ofbiz"

jdbc-password="ofbiz"

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="20"/>

</datasource>

to:

<datasource name="localmysql"

helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"

field-type-name="mysql"

check-on-start="true"

add-missing-on-start="true"

check-pks-on-start="false"

use-foreign-keys="true"

join-style="ansi-no-parenthesis"

alias-view-columns="true"

drop-fk-use-foreign-key-keyword="true"

table-type="InnoDB"

character-set="latin1"

collate="latin1_general_cs">

<read-data reader-name="seed"/>

<read-data reader-name="demo"/>

<read-data reader-name="ext"/>

<inline-jdbc

jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://localhost/ofbiz_mysql?autoReconnect=true"

jdbc-username="ofbiz_mysql"

jdbc-password="ofbiz_mysql"

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="20"/>

</datasource>

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

another,modify the follow segment:

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

<datasource name="odbcmysql"

helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"

field-type-name="mysql"

check-on-start="true"

add-missing-on-start="true"

check-pks-on-start="false"

use-foreign-keys="true"

join-style="ansi-no-parenthesis"

alias-view-columns="true"

drop-fk-use-foreign-key-keyword="true"

table-type="InnoDB"

character-set="latin1"

collate="latin1_general_cs">

<read-data reader-name="seed"/>

<inline-jdbc

jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true"

jdbc-username="ofbiz"

jdbc-password="ofbiz"

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="20"/>

</datasource>

to:

<datasource name="odbcmysql"

helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"

field-type-name="mysql"

check-on-start="true"

add-missing-on-start="true"

check-pks-on-start="false"

use-foreign-keys="true"

join-style="ansi-no-parenthesis"

alias-view-columns="true"

drop-fk-use-foreign-key-keyword="true"

table-type="InnoDB"

character-set="latin1"

collate="latin1_general_cs">

<read-data reader-name="seed"/>

<inline-jdbc

jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://localhost/ofbiz_odbc_mysql?autoReconnect=true"

jdbc-username="ofbiz_odbc_mysql"

jdbc-password="ofbiz_odbc_mysql"

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="20"/>

</datasource>

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

----------------------------------------------------------------------------------------------------

##################################################

### Building From SVN

##################################################

----------------------------------------------------------------------------------------------------

1、When building from SVN you will need to have Ant 1.5 or later (see http://ant.apache.org) installed

and setup properly in addition to a Java 1.4 or newer J2SDK (NOT just the JRE, need to full SDK) as

mentioned above.

2、In the directory where you want OFBiz to be, do a SVN checkout of the ofbiz module on the java.net

servers. For example:

svn co http://svn.ofbiz.org/svn/ofbiz/trunk ofbiz

For information on connecting to SVN click here (svn.ofbiz.org).

3、Now go into the "ofbiz" directory and run "ant". It will compile all modules and leave you an executable

jar (ofbiz.jar) in the "ofbiz" directory.

4、To load the seed data, run "ant run-install", or "$JAVA_HOME/bin/java -jar ofbiz.jar install",

or "%JAVA_HOME%\bin\java -jar ofbiz.jar install"

5、To start the server run "ant run", or "$JAVA_HOME/bin/java -jar ofbiz.jar",

or "%JAVA_HOME%\bin\java -jar ofbiz.jar"

6、Another build option in the Ant build script that is useful is "ant clean". That will clean out all built

classes allowing you to run "ant" again to get a clean build. If you are running into funny errors after

updating from SVN in the future, give this clean build process a try first.

----------------------------------------------------------------------------------------------------

##################################################

### Quick & Easy Setup

##################################################

----------------------------------------------------------------------------------------------------

You can get up and running quickly by downloading the OFBiz Complete distribution and following some

simple instructions. For more options and explanations, see the rest of this document.

1、Download and install the Java 2 v1.4 or later JDK/J2SDK (not the JRE, need the full SDK) from Sun's

Java site, and make sure your JAVA_HOME environment variable is set to this JDK after installation

(NOTE that for Mac OS X no JVM setup is needed, just make sure you are up to date with the Java 1.4 series

with the OS X Software Update facility).

2、Download the OFBiz Apps archive and unzip it in the directory of your choice. This should create one

sub-directory: ofbiz. This will be the OFBIZ_HOME location.

3、Start OFBiz with embedded Jetty by going into the ofbiz directory and then running "startofbiz.bat" (or

"%JAVA_HOME%\bin\java -jar ofbiz.jar") for Windows, or "./startofbiz.sh" (or "$JAVA_HOME/bin/java -jar ofbiz.jar")

for Linux/Unix. For OS X you can just run "java -jar ofbiz.jar" and you don't need to setup the JAVA_HOME

or anything because it is already there.

4、Open a browser and go to http://127.0.0.1:8080/ecommerce for the ecommerce application or

https://127.0.0.1:8443/webtools for the WebTools application or https://127.0.0.1:8443/catalog

for the Catalog Manager application.

5、The default administrative account is username: "admin", password: "ofbiz".

6、Have fun with it! You are running on a Java database. For more discussion of databases, read the section below

on that topic.

7、For more detailed options and configuration information, read on!

----------------------------------------------------------------------------------------------------

参考网址：

http://svn.ofbiz.org/

http://www.supcode.com/Article/html/4/50/2005/03/07/038245534451.shtml (OFBIZ安装与配置)