Run OFBiz with MySQL

最新推荐文章于 2022-09-02 18:54:10 发布
原创 最新推荐文章于 2022-09-02 18:54:10 发布 · 1.7k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql #java #svn #download #jdbc #ant

本文详细介绍了使用MySQL运行OFBiz的步骤，包括用SVN下载OFBiz源码、创建数据库和用户、设置OFBiz环境、修改配置文件、从SVN构建项目，还提供了快速简易的安装设置方法，涉及Java、MySQL、SVN、Ant等技术。

**************************************************
*** 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:
    <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.odbc" datasource-name="localderbyodbc"/>
    </delegator>
to:
    <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="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"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </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"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </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"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </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"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </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安装与配置)

开源电商 OFBiz (Mysql)Idea安装过程及问题(中文乱码，500 GenericEntityException jdbc，Visitor错误处理)
泥人儿的博客
09-14 1672
开源电商 OFBiz (Mysql)安装过程及问题OFBiz是一个非常著名的电子商务平台，是一个非常著名的开源项目，提供了创建基于最新J2EE/XML规范和技术标准，构建大中型企业级、跨平台、跨数据库、跨应用服务器的多层、分布式电子商务类WEB应用系统的框架。 OFBiz最主要的特点是OFBiz提供了一整套的开发基于Java的web应用程序的组件和工具。包括实体引擎, 服务引擎, 消息引擎, 工作流
ofbiz连接本地mysql的配置教程
diyagea的博客
11-29 3895
配置教程如下： 将mysql的jar包导入到ofbiz的 " framework/entity/lib/jdbc " 目录下 修改 " framework/entity/config/“ 目录下的 entityengine.xml 配置文件  entityengine.xml 该文件是负责ofbiz的数据库连接和实体类映射配置 在entity
run ofbiz with mysql5.5+
04-13 371
创建表空间mysql>create database ofbiz_mysql;mysql>grant all on *.* to ofbiz@localhost identified by 'ofbiz' with grant option;修改配置文件去掉 table-type="InnoDB" 属性。table-type属性在 mysql5.5 以后版本被engine替代，而且mysql5.5 以后默认的存储引擎就是InnoDB，因此去掉该参数没有任何副作用。下载 mysql jdbc 驱动ant ru
ofbiz与mysql_ofbiz 安装以及使用mysql数据库
weixin_28953819的博客
02-08 314
一.安装安装需要eclipse ，以及eclipse中的javacc和svn插件svn地址：http://svn.apache.org/repos/asf/ofbiz/branches/release13.07下载后会报错，在javabulidpath中将missing的移除，并将项目中framework下的entity下的config文件夹加载进来然后编译json.jj,parser.jj...
ofbiz 安装以及使用mysql数据库
sky_fate的专栏
10-14 2276
一.安装 安装需要eclipse ，以及eclipse中的javacc和svn插件 svn地址：http://svn.apache.org/repos/asf/ofbiz/branches/release13.07 下载后会报错，在java bulid path 中将missing的移除，并将项目中framework下的entity下的config文件夹加载进来 然后编译json.jj
ofbiz结合mysql安装教程
lchunp的专栏
04-28 1672
ofbiz结合mysql安装，下面是安装步骤。  一：安装mysql。  详细参照mysql的基本安装方法  http://blog.youkuaiyun.com/lchunp/article/details/8862016，主要是要在mysql里面建立OFBiz所需要的数据库名称和用户，我们可以利用Navicat连接mysql，并且新建立一个数据库ofbiz。我使用的是root用户，密码是:admin
ofbiz修改mysql_如何将OFBIZG的默认数据库更改mysql的方法(只求参考 )
weixin_39999586的博客
02-06 138
ofbiz自带的数据库是Derby,这是一种小型的适合与测试系统的数据库,但不适合在产品级系统中使用,所以通常我们需要将ofbiz迁移到其它数据库上,下面我就以如何迁移至mysql为例,向大家讲述数据库迁移过程,迁移至其它数据库的过程类似.第一步:修改entityengine.xml文件.该文件的位置是ofbiz_home\framework\entity\config\entityengine....
ofbiz12.04更换数据库为mysql
program_thinker的专栏
10-06 1298
ofbiz自带数据库为derby，只适合于内部ce
ofbiz mysql 序列_如何将OFBIZ(opentaps)默认数据库迁移至mysql
weixin_33905037的博客
02-19 122
如何将OFBIZ(opentaps)默认数据库迁移至mysql.ofbiz自带的数据库是Derby,这是一种小型的适合与测试系统的数据库,但不适合在产品级系统中使用,所以通常我们需要将ofbiz迁移到其它数据库上,下面我就以如何迁移至mysql为例,向大家讲述数据库迁移过程,迁移至其它数据库的过程类似.第一步:修改entityengine.xml文件.该文件的位置是ofbiz_homeframew...
ofbiz切换到mysql
junmail的专栏
09-15 279
ofbiz自带的数据库是Derby，以下列出如何将ofbiz数据库 从derby迁移至mysql的步骤。迁移至其它数据库也可参考。 第一步:修改entityengine.xml文件. 该文件的位置：ofbiz_home\framework\entity\config\entityengine.xml首先，在该文件的找到以下代码:&lt;delegator name="default" ent...
ofbiz-16.11.02安装及配置采坑记录
weixin_40624269的博客
10-23 1640
绝对深坑！ 当输入gradlew ofbiz运行之后，如果走到 &amp;gt; Building 91% &amp;gt; :ofbiz 就不动了，并不是配置有问题，而是ofbiz他娘的已经启动了（浪费我接近一天时间）！ 有这么坑的吗？好歹给个successful提示啊！ 好了，吐槽完毕，言归正传： 其实如果不是要迁移数据库，ofbiz安装还是很简单的，解压，配置环境变量（也可以不配置），运行 gradlew...
基于Binlog、FlinkCDC、Doris实现实时数据同步
何以问_的博客
09-02 4714
基于Flink CDC 并结合 Apache Doris Flink Connector 及 Doris Stream Load的两阶段提交，实现MySQL数据库分库分表实时高效的接入到 Apache Doris 数据仓库中进行分析。
import nmap import socket import requests import paramiko import threading import argparse from datetime import datetime from bs4 import BeautifulSoup from urllib.parse import urljoin class VulnerabilityScanner: def __init__(self, target, ports=None, threads=10): """ 初始化漏洞扫描器 参数: target (str): 目标IP或域名 ports (str): 要扫描的端口范围，如 '1-1000' threads (int): 线程数 """ self.target = target self.ports = ports or '1-1000' self.threads = threads self.results = { 'target': target, 'start_time': datetime.now().isoformat(), 'open_ports': [], 'services': {}, 'vulnerabilities': [] } self.lock = threading.Lock() def validate_target(self): """验证目标地址是否有效""" try: socket.gethostbyname(self.target) return True except socket.gaierror: print(f"[!] 无法解析目标: {self.target}") return False def port_scan(self): """使用nmap进行端口扫描""" if not self.validate_target(): return False print(f"[*] 开始扫描 {self.target} 的端口 {self.ports}...") try: nm = nmap.PortScanner() nm.scan(hosts=self.target, ports=self.ports, arguments=f'-T4 --min-parallelism {self.threads}') for host in nm.all_hosts(): for proto in nm[host].all_protocols(): ports = nm[host][proto].keys() for port in sorted(ports): service = nm[host][proto][port]['name'] state = nm[host][proto][port]['state'] if state == 'open': with self.lock: self.results['open_ports'].append(port) self.results['services'][port] = { 'protocol': proto, 'service': service, 'product': nm[host][proto][port].get('product', ''), 'version': nm[host][proto][port].get('version', '') } print(f"[+] 发现开放端口: {port}/{proto} - {service}") return True except nmap.PortScannerError as e: print(f"[!] Nmap扫描错误: {e}") return False except Exception as e: print(f"[!] 扫描过程中发生错误: {e}") return False def check_weak_passwords(self, port, service): """检测常见服务的弱口令""" common_credentials = { 'ssh': [('root', 'root'), ('admin', 'admin'), ('root', 'password')], 'ftp': [('anonymous', ''), ('admin', 'admin')], 'telnet': [('root', 'root'), ('admin', 'admin')], 'mysql': [('root', ''), ('root', 'root')] } if service not in common_credentials: return print(f"[*] 正在检测 {service.upper()} 弱口令...") if service == 'ssh': ssh = paramiko.SSHClient() ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy()) for username, password in common_credentials[service]: try: ssh.connect(self.target, port=port, username=username, password=password, timeout=5) ssh.close() with self.lock: self.results['vulnerabilities'].append({ 'type': 'weak_password', 'port': port, 'service': service, 'credentials': f"{username}:{password}", 'severity': 'high' }) print(f"[!] 发现弱口令: {service} - {username}:{password}") break except: continue # 可以添加其他服务的弱口令检测逻辑 def check_sql_injection(self, url): """检测SQL注入漏洞""" if not url.startswith(('http://', 'https://')): url = f"http://{url}" print(f"[*] 正在检测 {url} 的SQL注入漏洞...") test_payloads = [ "'", "\"", "' OR '1'='1", "\" OR \"1\"=\"1", "' OR 1=1--", ] 怎么使用
最新发布
06-18
scan_report = scanner.run_scan() # 或异步执行 scanner.start_async_scan() while not scanner.is_complete(): print(f"进度: {scanner.get_progress()}%") time.sleep(2) report = scanner.get_results() ``` ...
Run Shark with MySQL
Asirxing的专栏
10-20 2188
***************************************************** How to run Shark with MySQL                   *****************************************************###############################################
Run JBPM3.0.x with MySQL
Asirxing的专栏
10-19 2187
***************************************************** How to run JBPM with MySQL                   *****************************************************################################################
在JBoss+MySQL环境下运行obe
Asirxing的专栏
10-29 1798
***************************************************** 在JBoss+MySQL环境下运行obe             ***************************************************** 我按照obe文档的说明试着在JBoss+MySQL环境下运行obe程序，在部署obe程序后启动JBoss，总是一堆的异
准确编译obe的cvs源程序
Asirxing的专栏
10-19 1671
***************************************************** 准确编译 obe 的 cvs源程序                      *****************************************************#####################################################
我的blog开通了，主题是基于J2EE的工作流
Asirxing的专栏
10-19 1246
我的blog开通了，主题是基于J2EE的工作流
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值