Home

Trifon (An ADempiere founder)

Instructions how to run ADempiere on MySQL.

Prerequisites:

  • SUN JDK
  • MySQL 5.x

Change my.cnf file.

Set tables names to be lower case.

Enable recursive stored procedures.

Enable MySQL ANSI mode.

$ sudo vim /etc/mysql/my.cnf
lower_case_table_names=1
max_sp_recursion_depth=128
sql_mode='ANSI'

Restart MySQL server

$ sudo /etc/init.d/mysql restart

Create "adempiere" database

$ mysql -u root -p 
mysql> create database adempiere DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_bin;

Create "adempiere" MySQL DB user

$ mysql -u root -p 
mysql> GRANT ALL ON adempiere.* TO 'adempiere'@'localhost' IDENTIFIED BY 'adempiere';

Import Initial MySQL DB Seed(ADempiere version 3.6.0LTS)

$ mysql -u adempiere -p -h localhost adempiere < <ADEMPIERE_HOME>/data/Adempiere_mysql.dmp

Follow standard ADempiere installation process

$ <ADEMPIERE_HOME>/RUN_setup.sh

Start ADempiere Server

$ <ADEMPIERE_HOME>/utils/RUN_Server2.sh

Start ADempiere Swing client

$ <ADEMPIERE_HOME>/RUN_Adempiere.sh

::: Enjoy ADempiere! :::

The wiki uses Markdown syntax.


Discussion

  • Lee

    Lee - 2011-01-07

    Hi,

    I attempted to do the set-up but database port 3306 seems to display error all the time. I have installed mysql-server correctly (I haven't modified the default port, so I assume the port must be configured to 3306). Also phpmyadmin works just fine. I am on ubuntu machine.

    Help is very much appreciated.

     
  • Anonymous

    Anonymous - 2011-01-15

    Lee, you have to install like a root user. The problem with de ports and another things area related to the privs .. good luck

     
  • Anonymous

    Anonymous - 2011-01-15

    I have a big problem, I can't install on ubuntu, I have a problem to run de jarsigner on installation. The error is that de jarsigner is not found ..and is true. How can I fix this problem?

    I have some problems with de Ad_Table creation too.

     
  • Anonymous

    Anonymous - 2011-11-14

    please help me i install Adempiere_360-MySQL-1.1.tar and mysql version 5.5
    " error 1005 <HY000> at line 9330: can't create table 'adempiere.ad_wf_process' <errno: 150=""> ?

     
  • Anonymous

    Anonymous - 2012-08-16

    Hi all, when I run RUN_ImportAdempiere.bat. I got problem "The system cannot find specific files".

     
  • Rose

    Rose - 2013-08-10

    Hi , iam not able to Import Initial MySQL DB Seed since i dont have the Adempiere_Mysql.dmp file. From can I download this file?

     
  • Anonymous

    Anonymous - 2013-12-11
    Post awaiting moderation.
  • Anonymous

    Anonymous - 2016-04-25
    Post awaiting moderation.

Anonymous
Anonymous

Cancel  Add attachments