SUSE LINUX Enterprise & openSUSE Community
มีนาคม 21, 2019, 12:21:43 AM *
ยินดีต้อนรับคุณ, บุคคลทั่วไป กรุณา เข้าสู่ระบบ หรือ ลงทะเบียน
ส่งอีเมล์ยืนยันการใช้งาน?

เข้าสู่ระบบด้วยชื่อผู้ใช้ รหัสผ่าน และระยะเวลาในเซสชั่น
ข่าว:
 
   หน้าแรก   ช่วยเหลือ ค้นหา เข้าสู่ระบบ สมัครสมาชิก  

[Why we need your support] SUSE and openSUSE are trademarks of Attachmate Group, Inc. - WE ARE NOT IN ANY WAY ASSOCIATED WITH SUSE AND ATTACHMATE GROUP. SUSEThailand.com is a SUSE Linux user and community found in Thailand but not limited to other country suse linux user to join in. Currently active contents (How to's, Scripts, Tips, Tricks, Tutorials, Linux Command Line, and Troubleshooting) this suse linux how to's and expert support are SUSE Linux.
หน้า: [1]   ลงล่าง
  พิมพ์  
ผู้เขียน
หัวข้อ: Install ADempiere Server on openSUSE 11  (อ่าน 5256 ครั้ง)
0 สมาชิก และ 1 บุคคลทั่วไป กำลังดูหัวข้อนี้
Sontaya
Administrator
Expert : ผู้เชี่ยวชาญ
*****

Karma: +1/-0
ออฟไลน์ ออฟไลน์

กระทู้: 1931


Administrator


เว็บไซต์
« เมื่อ: สิงหาคม 23, 2009, 08:54:43 PM »


Installing ADempiere EPR on openSUSE 11

- Download Source code from https://adempiere.svn.sourceforge.net/svnroot/adempiere
- Compiler by Eclipse GALILEO (Eclipse IDE for Java Developers), Using Java SE 1.6 (JDK1.6.0)
- Setting Java Environment using Java SE 1.6
- Installing PostgreSQL from YaST. (V. 8.3.7)

1. Create User ADempiere
$ createuser adempiere
(y)

OR.
$ createuser -sdrlIPE adempiere
Options:
  -s, --superuser           role will be superuser
  -d, --createdb            role can create new databases
  -r, --createrole          role can create new roles
  -l, --login               role can login (default)
  -I, --no-inherit          role does not inherit privileges
  -P, --pwprompt            assign a password to new role
  -E, --encrypted           encrypt stored password


2. Set password of User ADempiere
- Login as postgres user
$ su postgresql

- open "psql" in command prompt.
$ psql
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# Alter user adempiere with password 'adempiere';
ALTER ROLE
postgres=# \q  

3. Create Database ADempiere

$ createdb adempiere -E UTF8 -O adempiere -U adempiere
Password: adempiere
Options:
   -E, --encoding
   -O, --owner
   -U, --user

4. Connect to Database as ADempiere

$ psql -U adempiere
Password for user adempiere:
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

adempiere=#


5. Install Adempiere

- Extract the file to /opt and then go to /opt/Adempiere, run RUN_setup.sh
$ cd /opt/Adempiere
$ ./RUN_setup.sh


- Import Database
1. Use script ("root" user)
$ cd /opt/Adempiere/utils
$ ./RUN_ImportAdempiere.sh


- Migration database 353a-trunk
$ /home/sontaya/workspace/adempiereTrunk/migration
$ cp postgresql.properties.template postgresql.properties
$ vi postgresql.properties


postgresql.home=/usr/sbin

#PostgreSQL pgdata folder
postgresql.pgdata=/var/lib/pgsql/data

#adempiere database name
postgresql.database=adempiere

#adempiere database login
postgresql.user=adempiere

#adempiere database password
postgresql.password=adempiere

postgresql.host=localhost
postgresql.port=5432

$ ./migrate_postgresql.sh 353a-trunk commit | psql -U adempiere -d adempiere > 353a-trunk.lst


- Start the Adempiere Server
$ cd /opt/Adempiere/utils
$ ./RUN_Server2.sh


- Run Adempiere
$ cd /opt/Adempiere
$ ./RUN_Adempiere.sh


e.g.

   
       Username: GardenAdmin / Password: GardenAdmin

       Username: GardenUser / Password: GardenUser
  
       Username: SuperUser / Password: System
  
       Username: System / Password: ⇒ System
================================================================================
Adempiere Trouble Shooting:

1). Error connecting: jdbc:postgresql://localhost:5432/template1


Details: When I run RUN_setup.sh for setting Adempiere and then try Test connection.

Solution: vi /var/lib/pgsql/data/postgresql.conf
- Uncomment
listen_addresses = 'localhost'
port = 5432

- Modify /var/lib/pgsql/data/pg_hba.conf

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         127.0.0.2/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5
host    adempiere   adempiere   0.0.0.0/0             md5


- Check Adempiere Server Setup
 Database User : adempiere
 DB Admin Password : masterkey
 Database Password : adempiere


2). Error: nulljava.lang.ClassNotFoundException: org.eevolution


Details: When I login to system by GardenAdmin user.
Ref: http://sourceforge.net/tracker/index.php?func=detail&aid=2583992&group_id=176962&atid=879332

org.eevolution.model.LiberoValidator needs to be disabled by default since
libero is developed as extension.


I added fix for postgresql.
- download filename "418_disable_eevolutionvalidator.sql"

Solution:

$ su postgres
$ psql -U adempiere
Password for user adempiere: adempiere
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

adempiere=# UPDATE AD_ModelValidator SET Updated=TO_TIMESTAMP('2009-02-10 19:56:37','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0,IsActive='N' WHERE AD_ModelValidator_ID=50000;
UPDATE 1
adempiere=# \q

Ref. http://www.adempiere.com/index.php/Adempiere_install_Suse
« แก้ไขครั้งสุดท้าย: สิงหาคม 07, 2010, 11:11:07 AM โดย Sontaya » แจ้งลบกระทู้นี้หรือติดต่อผู้ดูแล   บันทึกการเข้า

ageLOC Technology
หน้า: [1]   ขึ้นบน
  พิมพ์  
 
กระโดดไป:  

(@)2007 SUSE Linux user community found in Thailand. This site is not an official openSUSE and SUSE website, and is not in any way affiliated with or endorsed by SUSE Linux GmbH or Novell. openSUSE and SUSE are trademarks of Novell, Inc. in the United States and other countries.
Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!
หน้านี้ถูกสร้างขึ้นภายในเวลา 0.042 วินาที กับ 20 คำสั่ง (Pretty URLs adds 0.008s, 2q)