To enable http to https :
<@ofbizUrl secure=”${request.isSecure()?string}”>
Showing posts with label ofBiz. Show all posts
Showing posts with label ofBiz. Show all posts
Wednesday, November 25, 2015
HOW TO SET MAXIMUM UPLOAD FILE SIZE IN OFBIZ
To customize file upload size in ofBiz you have to change or configure this in general.properties.
find http.upload.max.sizethreshold and assign your desire upload file size.
like 40K
http.upload.max.sizethreshold=40960
OFBIZ ADMIN USER CREATION (COMMAND LINE)
* To install : sudo ant run-install-seed
* Create admin user : sudo ant create-admin-user-login
* When prompted, enter the user login name “admin”
* Password will be “ofbiz”
OFBIZ SUDO ANT START NOT WORKING
Log error:
Incompatible minimum and maximum heap sizes specified
Go to your project folder and edit build.xml with code of under the below:
<property name="site.dir" value="../site"/> <property name="memory.initial.param" value="-Xms2048M"/> <property name="memory.max.param" value="-Xmx2048M"/> <property name="pos.memory.max.param" value="-Xmx2048M"/> <property name="memory.maxpermsize.param" value="-XX:MaxPermSize=2048m"/>
HIDE URL PORT NUMBER OF OFBIZ APPLICATION
To hide the url port number in ofBiz application follow instruction under the below:
* Open framework/base/config/ofbiz-containers.xml
* Find port number which you want to hide
* Replace with 443
* Open framework/base/config/ofbiz-containers.xml
* Find port number which you want to hide
* Replace with 443
My one is
<property name="port" value="443"/>
under
<property name="https-connector" value="connector">
HOW TO MIGRATE OFBIZ FROM DERBY TO MYSQL DATABASE
Step - I
C:\mysql-5.5.23-winx64\bin>mysql -u root
mysql>create database ofbiz;
mysql>create database ofbizolap;
mysql>create database ofbiztenant;
mysql>use mysql;
mysql>select database();
mysql>create user ofbiz@localhost;
mysql>create user ofbizolap@localhost;
mysql>create user ofbiztenant@localhost;
mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
mysql>update user set password=PASSWORD("ofbizolap") where User='ofbizolap';
mysql>update user set password=PASSWORD("ofbiztenant") where User='ofbiztenant';
mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by 'ofbiz';
mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by 'ofbizolap';
mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by 'ofbiztenant';
C:\mysql-5.5.23-winx64\bin>mysql -u root
mysql>create database ofbiz;
mysql>create database ofbizolap;
mysql>create database ofbiztenant;
mysql>use mysql;
mysql>select database();
mysql>create user ofbiz@localhost;
mysql>create user ofbizolap@localhost;
mysql>create user ofbiztenant@localhost;
mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
mysql>update user set password=PASSWORD("ofbizolap") where User='ofbizolap';
mysql>update user set password=PASSWORD("ofbiztenant") where User='ofbiztenant';
mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by 'ofbiz';
mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by 'ofbizolap';
mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by 'ofbiztenant';
Step - II
Use webtools to export all data to XML:
a. Start OfBiz
b. Navigate to http://localhost:8080/catalog/
c. Go to Applications>WebTools
d. Go to section 'Entity XML Tools' and click the link 'XML Data Export All' - export the data to a directory of your choice
Use webtools to export all data to XML:
a. Start OfBiz
b. Navigate to http://localhost:8080/catalog/
c. Go to Applications>WebTools
d. Go to section 'Entity XML Tools' and click the link 'XML Data Export All' - export the data to a directory of your choice
Step - III
1. Stop OfBiz server
2. Create a backup of <ofbiz-dir>/framework/entity/config/entityengine.xml
3. Edit entityengine.xml as follows:
a. Add the following datasources below the datasource 'localmysql'
1. Stop OfBiz server
2. Create a backup of <ofbiz-dir>/framework/entity/config/entityengine.xml
3. Edit entityengine.xml as follows:
a. Add the following datasources below the datasource 'localmysql'
b. Replace derby with mysql in default, default-no-eca and test delegators as follows:
c. Save this file
Step -IV
1. Open ofbiz/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java in eclipse and replace sqlBuf.append(" TYPE ") with sqlBuf.append(" ENGINE ")
2. Save the file and run ofbiz/build.xml
Note: This is required because TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. The older TYPE option was synonymous with the new option ENGINE
1. Open ofbiz/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java in eclipse and replace sqlBuf.append(" TYPE ") with sqlBuf.append(" ENGINE ")
2. Save the file and run ofbiz/build.xml
Note: This is required because TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. The older TYPE option was synonymous with the new option ENGINE
Step -V
1. Run the following command from command prompt:
ofbiz-dir>java -jar ofbiz.jar -install
2. Start OfBiz
1. Run the following command from command prompt:
ofbiz-dir>java -jar ofbiz.jar -install
2. Start OfBiz
ref: https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OfBiz+from+Derby+to+MySQL+database
Subscribe to:
Posts (Atom)