Difference between revisions of "How to install Adempiere on CentOS 5.1 (Xen) with Postgres"
(→Set up adempiere) |
(note security and staleness matter) |
||
Line 1: | Line 1: | ||
+ | = Preliminary Matter = | ||
+ | |||
+ | WARNING: This page is out of date as of 22 October 2009, referring to stale CentOS version. CentOS at the 5.1 point release level has many well known (and repaired) security holes. It also uses a 'non-CentOS' PostGreSQL, and a java known to have security issues | ||
+ | --[[User:RussHerrold|RussHerrold]] 07:26, 23 October 2009 (PDT) | ||
+ | |||
+ | ---- | ||
+ | |||
= Summary = | = Summary = | ||
We are going to create a new xen host with a LVM backend and then install adempiere on it. | We are going to create a new xen host with a LVM backend and then install adempiere on it. |
Latest revision as of 07:26, 23 October 2009
Contents
- 1 Preliminary Matter
- 2 Summary
- 3 Set up xen host (from Dom0)
- 3.1 Boot Installer
- 3.2 Install Screen 1
- 3.3 Installer Screen 2
- 3.4 Installer Screen 3
- 3.5 Installer Screen 4
- 3.6 Installer Screen 5
- 3.7 Installer Screen 6
- 3.8 Installer Screen 7
- 3.9 Installer Screen 8
- 3.10 Installer Screen 9
- 3.11 Installer Screen 10
- 3.12 Installer Screen 11
- 3.13 Installer Screen 12
- 3.14 Installer Screen 13
- 3.15 Installer Screen 14
- 3.16 Installer Screen 15
- 3.17 Installer Screen 16
- 3.18 Installer Screen 17
- 3.19 Installer Screen 18
- 3.20 Installer Screen 19
- 3.21 Installer Screen 20
- 3.22 Installer Screen 21
- 3.23 Kickstart
- 4 File Overlays
- 5 Install Adempiere
- 6 Set up user
- 7 Set up adempiere
- 8 Notes
- 9 External Links
Preliminary Matter
WARNING: This page is out of date as of 22 October 2009, referring to stale CentOS version. CentOS at the 5.1 point release level has many well known (and repaired) security holes. It also uses a 'non-CentOS' PostGreSQL, and a java known to have security issues --RussHerrold 07:26, 23 October 2009 (PDT)
Summary
We are going to create a new xen host with a LVM backend and then install adempiere on it.
Set up xen host (from Dom0)
lvcreate --name bilby01-root --size 6G VolGroup00 virt-install -n bilby01 -r 1024 --nographics -l http://www.mirrorservice.org/sites/mirror.centos.org/5.1/os/i386 -f /dev/VolGroup00/bilby01-root
- Note: choose your mirror from http://www.centos.org/modules/tinycontent/index.php?id=13
Boot Installer
Starting install... Retrieving CentOS... 98 kB 00:00 Retrieving vmlinuz... 100% |=========================| 2.0 MB 00:00 Retrieving initrd.img... 100% |=========================| 5.0 MB 00:00 Creating domain... 0 B 00:05 Linux version 2.6.18-53.el5xen (mockbuild@builder6.centos.org) (gcc version 4.1.2 20070626 (Red Hat 4.1.2-14)) #1 SMP Mon Nov 12 03:26:12 EST 2007 BIOS-provided physical RAM map: Xen: 0000000000000000 - 0000000040800000 (usable) 304MB HIGHMEM available. 727MB LOWMEM available. Using x86 segment limits to approximate NX protection ACPI in unprivileged domain disabled Built 1 zonelists. Total pages: 264192 Kernel command line: method=http://www.mirrorservice.org/sites/mirror.centos.org/5.1/os/i386 Enabling fast FPU save and restore... done. Enabling unmasked SIMD FPU exception support... done. Initializing CPU#0 CPU 0 irqstacks, hard=c0727000 soft=c0707000 PID hash table entries: 4096 (order: 12, 16384 bytes) Xen reported: 930.956 MHz processor. Console: colour dummy device 80x25 Dentry cache hash table entries: 131072 (order: 7, 524288 bytes) Inode-cache hash table entries: 65536 (order: 6, 262144 bytes) Software IO TLB disabled vmalloc area: ee000000-f4ffe000, maxmem 2d7fe000 Memory: 1025448k/1056768k available (2049k kernel code, 22324k reserved, 844k data, 168k init, 311304k highmem) Checking if this processor honours the WP bit even in supervisor mode... Ok. Calibrating delay using timer specific routine.. 2329.06 BogoMIPS (lpj=4658133) Security Framework v1.0.0 initialized SELinux: Initializing. selinux_register_security: Registering secondary module capability Capability LSM initialized as secondary Mount-cache hash table entries: 512 CPU: L1 I cache: 16K, L1 D cache: 16K CPU: L2 cache: 256K Checking 'hlt' instruction... OK. SMP alternatives: switching to UP code Freeing SMP alternatives: 13k freed Brought up 1 CPUs checking if image is initramfs... it is Freeing initrd memory: 6848k freed Grant table initialized NET: Registered protocol family 16 ACPI Exception (utmutex-0262): AE_BAD_PARAMETER, Thread C06D7AA0 could not acquire Mutex [2] [20060707] ACPI Exception (utmutex-0262): AE_BAD_PARAMETER, Thread C06D7AA0 could not acquire Mutex [2] [20060707] Brought up 1 CPUs PCI: setting up Xen PCI frontend stub ACPI: Interpreter disabled. Linux Plug and Play Support v0.97 (c) Adam Belay pnp: PnP ACPI: disabled xen_mem: Initialising balloon driver. usbcore: registered new driver usbfs usbcore: registered new driver hub PCI: System does not support PCI PCI: System does not support PCI NetLabel: Initializing NetLabel: domain hash size = 128 NetLabel: protocols = UNLABELED CIPSOv4 NetLabel: unlabeled traffic allowed by default NET: Registered protocol family 2 IP route cache hash table entries: 32768 (order: 5, 131072 bytes) TCP established hash table entries: 131072 (order: 8, 1048576 bytes) TCP bind hash table entries: 65536 (order: 7, 524288 bytes) TCP: Hash tables configured (established 131072 bind 65536) TCP reno registered audit: initializing netlink socket (disabled) audit(1207046064.831:1): initialized highmem bounce pool size: 64 pages VFS: Disk quotas dquot_6.5.1 Dquot-cache hash table entries: 1024 (order 0, 4096 bytes) Initializing Cryptographic API ksign: Installing public key data Loading keyring - Added public key 74432F7696771E6E - User ID: CentOS (Kernel Module GPG key) io scheduler noop registered io scheduler anticipatory registered io scheduler deadline registered io scheduler cfq registered (default) pci_hotplug: PCI Hot Plug PCI Core version: 0.5 rtc: IRQ 8 is not free. Non-volatile memory driver v1.2 Linux agpgart interface v0.101 (c) Dave Jones RAMDISK driver initialized: 16 RAM disks of 16384K size 4096 blocksize Xen virtual console successfully installed as xvc0 Linux version 2.6.18-53.el5xen (mockbuild@builder6.centos.org) (gcc version 4.1.2 20070626 (Red Hat 4.1.2-14)) #1 SMP Mon Nov 12 03:26:12 EST 2007 BIOS-provided physical RAM map: Xen: 0000000000000000 - 0000000040800000 (usable) 304MB HIGHMEM available. 727MB LOWMEM available. Using x86 segment limits to approximate NX protection ACPI in unprivileged domain disabled Built 1 zonelists. Total pages: 264192 Kernel command line: method=http://www.mirrorservice.org/sites/mirror.centos.org/5.1/os/i386 Enabling fast FPU save and restore... done. Enabling unmasked SIMD FPU exception support... done. Initializing CPU#0 CPU 0 irqstacks, hard=c0727000 soft=c0707000 PID hash table entries: 4096 (order: 12, 16384 bytes) Xen reported: 930.956 MHz processor. Console: colour dummy device 80x25 Dentry cache hash table entries: 131072 (order: 7, 524288 bytes) Inode-cache hash table entries: 65536 (order: 6, 262144 bytes) Software IO TLB disabled vmalloc area: ee000000-f4ffe000, maxmem 2d7fe000 Memory: 1025448k/1056768k available (2049k kernel code, 22324k reserved, 844k data, 168k init, 311304k highmem) Checking if this processor honours the WP bit even in supervisor mode... Ok. Calibrating delay using timer specific routine.. 2329.06 BogoMIPS (lpj=4658133) Security Framework v1.0.0 initialized SELinux: Initializing. selinux_register_security: Registering secondary module capability Capability LSM initialized as secondary Mount-cache hash table entries: 512 CPU: L1 I cache: 16K, L1 D cache: 16K CPU: L2 cache: 256K Checking 'hlt' instruction... OK. SMP alternatives: switching to UP code Freeing SMP alternatives: 13k freed Brought up 1 CPUs checking if image is initramfs... it is Freeing initrd memory: 6848k freed Grant table initialized NET: Registered protocol family 16 ACPI Exception (utmutex-0262): AE_BAD_PARAMETER, Thread C06D7AA0 could not acquire Mutex [2] [20060707] ACPI Exception (utmutex-0262): AE_BAD_PARAMETER, Thread C06D7AA0 could not acquire Mutex [2] [20060707] Brought up 1 CPUs PCI: setting up Xen PCI frontend stub ACPI: Interpreter disabled. Linux Plug and Play Support v0.97 (c) Adam Belay pnp: PnP ACPI: disabled xen_mem: Initialising balloon driver. usbcore: registered new driver usbfs usbcore: registered new driver hub PCI: System does not support PCI PCI: System does not support PCI NetLabel: Initializing NetLabel: domain hash size = 128 NetLabel: protocols = UNLABELED CIPSOv4 NetLabel: unlabeled traffic allowed by default NET: Registered protocol family 2 IP route cache hash table entries: 32768 (order: 5, 131072 bytes) TCP established hash table entries: 131072 (order: 8, 1048576 bytes) TCP bind hash table entries: 65536 (order: 7, 524288 bytes) TCP: Hash tables configured (established 131072 bind 65536) TCP reno registered audit: initializing netlink socket (disabled) audit(1207046064.831:1): initialized highmem bounce pool size: 64 pages VFS: Disk quotas dquot_6.5.1 Dquot-cache hash table entries: 1024 (order 0, 4096 bytes) Initializing Cryptographic API ksign: Installing public key data Loading keyring - Added public key 74432F7696771E6E - User ID: CentOS (Kernel Module GPG key) io scheduler noop registered io scheduler anticipatory registered io scheduler deadline registered io scheduler cfq registered (default) pci_hotplug: PCI Hot Plug PCI Core version: 0.5 rtc: IRQ 8 is not free. Non-volatile memory driver v1.2 Linux agpgart interface v0.101 (c) Dave Jones RAMDISK driver initialized: 16 RAM disks of 16384K size 4096 blocksize
Install Screen 1
Welcome to CentOS +---------+ Choose a Language +---------+ | | | What language would you like to use | | during the installation process? | | | | Catalan ^ | | Chinese(Simplified) : | | Chinese(Traditional) # | | Croatian : | | Czech : | | Danish : | | Dutch : | | English v | | | | +----+ | | | OK | | | +----+ | | | | | +---------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 2
Welcome to CentOS +----------------+ Configure TCP/IP +----------------+ | | | [*] Enable IPv4 support | | ( ) Dynamic IP configuration (DHCP) | | (*) Manual configuration | | | | [ ] Enable IPv6 support | | (*) Automatic neighbor discovery (RFC 2461) | | ( ) Dynamic IP configuration (DHCP) | | ( ) Manual configuration | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +----------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 3
Welcome to CentOS +--------------+ Manual TCP/IP Configuration +---------------+ | | | Enter the IPv4 and/or the IPv6 address and prefix | | (address / prefix). For IPv4, the dotted-quad netmask | | or the CIDR-style prefix are acceptable. The gateway and | | name server fields must be valid IPv4 or IPv6 addresses. | | | | IPv4 address: 91.186.7.233____ / 255.255.255.0___ | | Gateway: 91.186.7.1_______________________________ | | Name Server: 217.112.88.10____________________________ | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +------------------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 4
Welcome to CentOS +----------------------------+ Retrieving +----------------------------+ | | | Retrieving images/minstg2.img... | | | +----------------------------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 5
Welcome to CentOS +-----------------+ Warning +-----------------+ | | | The partition table on device xvda was | | unreadable. To create new partitions it | | must be initialized, causing the loss of | | ALL DATA on this drive. | | | | This operation will override any previous | | installation choices about which drives | | to ignore. | | | | Would you like to initialize this drive, | | erasing ALL DATA? | | | | +-----+ +----+ | | | Yes | | No | | | +-----+ +----+ | | | | | +---------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 6
Welcome to CentOS +-------------------------+ Partitioning Type +-------------------------+ | | | Installation requires partitioning of your hard drive. The | | default layout is reasonable for most users. You can either | | choose to use this or create your own. | | | | Remove all partitions on selected drives and create default layout. | | Remove linux partitions on selected drives and create default layout. | | Use free space on selected drives and create default layout. | | Create custom layout. | | | | Which drive(s) do you want to use for this installation? | | [*] xvda 6142 MB (Xen Virtual Block Device) ^ | | # | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +-----------------------------------------------------------------------+ <Space>,<+>,<-> selection | <F2> Add drive | <F12> next screen
Installer Screen 7
Welcome to CentOS +-------------+ Warning +-------------+ | | | You have chosen to remove all | | Linux partitions (and ALL DATA on | | them) on the following drives: | | | | /dev/xvda | | | | Are you sure you want to do this? | | | | +----+ +-----+ | | | No | | Yes | | | +----+ +-----+ | | | | | +-------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 8
Welcome to CentOS +-------+ Review Partition Layout +-------+ | | | Review and modify partitioning layout? | | | | +-----+ +----+ | | | Yes | | No | | | +-----+ +----+ | | | | | +-----------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 9
Welcome to CentOS +----+ Configure Network Interface +-----+ | | | Would you like to configure the eth0 | | network interface in your system? | | | | +-----+ +----+ | | | Yes | | No | | | +-----+ +----+ | | | | | +----------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 10
Welcome to CentOS ++ Network Configuration for eth0 ++ | | | Xen Virtual Ethernet | | 00:16:3E:2E:D3:37 | | | | [*] Activate on boot | | [*] Enable IPv4 support | | [ ] Enable IPv6 support | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +----------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 11
Welcome to CentOS +-----+ IPv4 Configuration for eth0 +-----+ | | | Xen Virtual Ethernet | | 00:16:3E:2E:D3:37 | | | | ( ) Dynamic IP configuration (DHCP) | | (*) Manual address configuration | | | | IP Address Prefix (Netmask) | | 91.186.7.233____ / 255.255.255.0___ | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +-----------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 12
Welcome to CentOS +------------+ Miscellaneous Network Settings +------------+ | | | Gateway: 91.186.7.1_______________________________ | | Primary DNS: 217.112.88.10____________________________ | | Secondary DNS: _________________________________________ | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +----------------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 13
Welcome to CentOS +--------------------+ Hostname Configuration +--------------------+ | | | If your system is part of a larger network where hostnames are | | assigned by DHCP, select automatically via DHCP. Otherwise, | | select manually and enter a hostname for your system. If you | | do not, your system will be known as 'localhost.' | | | | ( ) automatically via DHCP | | (*) manually ilby1.akunaservices.com_ | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +------------------------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 14
Welcome to CentOS +-------+ Time Zone Selection +-------+ | | | What time zone are you located in? | | | | [*] System clock uses UTC | | | | America/Montevideo ^ | | America/Montreal # | | America/Montserrat : | | America/Nassau : | | America/New_York v | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +-------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 15
Welcome to CentOS +--------------+ Root Password +---------------+ | | | Pick a root password. You must type it | | twice to ensure you know what it is and | | didn't make a mistake in typing. Remember | | that the root password is a critical part | | of system security! | | | | Password: *************___________ | | Password (confirm): *************___________ | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +----------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 16
Welcome to CentOS +----------------------+ Package selection +----------------------+ | | | The default installation of CentOS includes a set of software | | applicable for general internet usage. What additional tasks | | would you like your system to include support for? | | | | [ ] Desktop - Gnome ^ | | [ ] Desktop - KDE # | | [ ] Server : | | [ ] Server - GUI v | | | | [ ] Customize software selection | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +-----------------------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 17
Welcome to CentOS +----------------------+ Dependency Check +-----------------------+ | | | Checking dependencies in packages selected for installation... | | | | 0% | | | +-----------------------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 18
Welcome to CentOS +---------+ Installation to begin +----------+ | | | A complete log of your installation will | | be in /root/install.log after rebooting | | your system. You may want to keep this | | file for later reference. | | | | +----+ +------+ | | | OK | | Back | | | +----+ +------+ | | | | | +--------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 19
Welcome to CentOS +------------------+ Package Installation +------------------+ | | | Name : | | Size : | | Summary: | | | | | | Status:+---------+ Install Starting +----------+ | | | | | | | Starting install process. This may | | | | take several minutes... | | | | | Time | | Total +---------------------------------------+ | | Complet | | Remaining: 355 575M | | | | 0% | | | +------------------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 20
Welcome to CentOS +------------------+ Package Installation +------------------+ | | | Name : glibc-common-2.5-18-i386 | | Size : 65076k | | Summary: Common binaries and locale data for glibc | | | | | | Status: | | | | 0% | | | | Packages Bytes Time | | Total : 355 575M 0:19:55 | | Completed: 9 4M 0:00:10 | | Remaining: 346 571M 0:19:45 | | | | 0% | | | +------------------------------------------------------------+ <Tab>/<Alt-Tab> between elements | <Space> selects | <F12> next screen
Installer Screen 21
Welcome to CentOS +----------------------+ Complete +-----------------------+ | | | Congratulations, your CentOS installation is complete. | | | | Remove any media used during the installation process | | and press <Enter> to reboot your system. | | | | | | +--------+ | | | Reboot | | | +--------+ | | | | | +---------------------------------------------------------+ <Enter> to reboot
Kickstart
# Kickstart file automatically generated by anaconda. install url --url http://www.mirrorservice.org/sites/mirror.centos.org/5.1/os/i386 lang en_US.UTF-8 network --device eth0 --bootproto static --ip 91.186.7.233 --netmask 255.255.255.0 --gateway 91.186.7.1 --nameserver 217.112.88.10,217.112.87.147 --hostname bilby1.akunaservices.com rootpw --iscrypted $1$3fg67£KXBqK7AH$mP4U5G6v5DPEFhhjOyogFTDRt8FIw1 firewall --enabled --port=22:tcp authconfig --enableshadow --enablemd5 selinux --enforcing timezone --utc Europe/London bootloader --location=mbr --driveorder=xvda --append="console=xvc0" # The following is the partition information you requested # Note that any partitions you deleted are not expressed # here so unless you clear all partitions first, this is # not guaranteed to work #clearpart --linux --drives=xvda #part /boot --fstype ext3 --size=100 --ondisk=xvda #part pv.2 --size=0 --grow --ondisk=xvda #volgroup VolGroup00 --pesize=32768 pv.2 #logvol / --fstype ext3 --name=LogVol00 --vgname=VolGroup00 --size=1024 --grow #logvol swap --fstype swap --name=LogVol01 --vgname=VolGroup00 --size=1000 --grow --maxsize=1984 %packages @editors @text-internet @dialup @core @base device-mapper-multipath -sysreport
File Overlays
We overlay files at this point such as:
- ssh banner
- scripts to blacklist ssh hack attempts
- transfer ssh keys
update os packages
- Not required
yum remove squid postgresql php httpd Deployment_Guide-en-US bind fetchmail mutt samba
- Required for Adempiere (See note #1)
yum install -y make gcc tar readline readline-devel zlib zlib-devel libxslt identd
- Finally make sure we are up to date
yum -y update
- import RPMForge
yum install -y yum-priorities rpm --import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm
or
rpm -Uhv http://apt.sw.be/redhat/el5/en/x86_64/rpmforge/RPMS//rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm
NOTE: fine tuning the rest of this ....
- turn selinux off
vi /etc/sysconfig/selinux
- add exclusion to yum
vi /etc/yum.conf
add this line
exclude=postgresql*
Install Adempiere
Install Java
This install is for the x86_64 package - you should get one to match your architecture.
wget http://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/VerifyItem-Start/jdk-6u12-linux-x64-rpm.bin?BundledLineItemUUID=Ku5IBe.lSKIAAAEgsIQ0eDjI&OrderID=.VJIBe.ll00AAAEgo4Q0eDjI&ProductID=cJtIBe.pCiYAAAEeQWpTv_YP&FileName=/jdk-6u12-linux-x64-rpm.bin chmod +x jdk-6u12-linux-x64-rpm.bin ./jdk-6u12-linux-x64-rpm.bin
Install Postgres
PostgreSQL Server 8.3 (See note #2)
wget http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/binary/v8.3.1/linux/rpms/redhat/rhel-5-i386/postgresql-libs-8.3.1-1PGDG.rhel5.i686.rpm rpm -Uvh postgresql-libs-8.3.1-1PGDG.rhel5.i686.rpm wget http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/binary/v8.3.1/linux/rpms/redhat/rhel-5-i386/postgresql-8.3.1-1PGDG.rhel5.i686.rpm rpm -Uvh postgresql-8.3.1-1PGDG.rhel5.i686.rpm wget http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/binary/v8.3.1/linux/rpms/redhat/rhel-5-i386/postgresql-server-8.3.1-1PGDG.rhel5.i686.rpm rpm -Uvh postgresql-server-8.3.1-1PGDG.rhel5.i686.rpm
x86_64
wget http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/binary/v8.3.6/linux/rpms/redhat/rhel-5-x86_64/postgresql-8.3.6-1PGDG.rhel5.x86_64.rpm wget http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/binary/v8.3.6/linux/rpms/redhat/rhel-5-x86_64/postgresql-libs-8.3.6-1PGDG.rhel5.x86_64.rpm wget http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/binary/v8.3.6/linux/rpms/redhat/rhel-5-x86_64/postgresql-server-8.3.6-1PGDG.rhel5.x86_64.rpm rpm -Uvh postgresql*
service postgresql initdb vi /var/lib/pgsql/data/pg_hba.conf
add a line for your ip address
host all all 192.168.1.100 ident sameuser
PostgreSQL Driver
wget http://jdbc.postgresql.org/download/postgresql-8.3-603.jdbc3.jar mv postgresql-8.3-603.jdbc3.jar /var/lib/pgsql/
Set up user
- set a password for postgres
passwd postgres vi /var/lib/pgsql/.bash_profile
- Add these two lines before the path
export JAVA_HOME=/usr/java/jdk1.5.0_15/ export ADEMPIERE_HOME=/usr/local/adempiere/Adempiere
- And add Java to the path
PATH=$PATH:$HOME/bin:$JAVA_HOME/bin
- Add adempiere user
useradd adempiere passwd adempiere su - adempiere
vi ~/.bash_profile
- Add these two lines before the path
export JAVA_HOME=/usr/java/jdk1.5.0_15/ export ADEMPIERE_HOME=/usr/local/adempiere/Adempiere
- And add Java to the path
PATH=$PATH:$HOME/bin:$JAVA_HOME/bin
Test Java setup
java -version java version "1.5.0_15" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_15-b04) Java HotSpot(TM) Client VM (build 1.5.0_15-b04, mixed mode, sharing)
Indicates that Java is installed, is the correct version and is in the path
PLJava 1.4
wget http://pgfoundry.org/frs/download.php/1598/pljava-i686-pc-linux-gnu-pg8.3-1.4.0.tar.gz
or
wget http://pgfoundry.org/frs/download.php/1591/pljava-x86_64-unknown-linux-gnu-pg8.3-1.4.0.tar.gz
mkdir /home/adempiere/pljava mv pljava-i686-pc-linux-gnu-pg8.3-1.4.0.tar.gz /home/adempiere cd /home/adempiere tar zxvf pljava-i686-pc-linux-gnu-pg8.3-1.4.0.tar.gz vi /var/lib/pgsql/data/postgresql.conf
- Add the following lines to created file.
dynamic_library_path = '\$libdir:/home/adempiere/pljava' custom_variable_classes = 'pljava' pljava.classpath = '/home/adempiere/pljava/pljava.jar'
- Java configuration file.
echo '/usr/java/jdk1.5.0_15/jre/lib/i386' > /etc/ld.so.conf.d/java.conf echo '/usr/java/jdk1.5.0_15/jre/lib/i386/client' >> /etc/ld.so.conf.d/java.conf echo '/usr/java/jdk1.5.0_15/jre/lib/i386/native_threads' >> /etc/ld.so.conf.d/java.conf
Postgres
- Create a user and assign to created database.
su - postgres
- Initialise Postgres
initdb -E UTF8 -d data createuser -P -E UTF8 -d adempiere Enter password for new role: Enter it again: Shall the new role be a superuser? (y/n) y createdb -E UTF8 -O adempiere adempiere psql -d adempiere -U adempiere < Adempiere_pg.dmp 2>&1 > install.log
Set up adempiere
su - adempiere
- Install pljava
java -cp $CLASSPATH org.postgresql.pljava.deploy.Deployer -database template1 -install
- Download Adempiere
- unpack
tar zxvf Adempiere_350.tar.gz cd Adempiere
- Create AdempiereEnv.properties
You can do this by copying the AdempiereEnvTemplate.properties to AdmepiereEnv.properties and editing in your values. My example is as follows:
echo " #AdempiereEnv.properties #Wed Apr 02 00:05:27 BST 2008 ADEMPIERE_FTP_SERVER=localhost ADEMPIERE_FTP_PREFIX=my ADEMPIERE_DATE_VERSION=2008-03-26 ADEMPIERE_DB_PASSWORD=fr456yhhy57re3234trgr42223 ADEMPIERE_JNP_PORT=1099 ADEMPIERE_DB_SYSTEM=$jfor&4jdj32kdk3kkjfgj54 ADEMPIERE_CERT_COUNTRY=GB ADEMPIERE_CERT_ORG_UNIT=Akuna Ltd ADEMPIERE_MAIL_SERVER= ADEMPIERE_DB_NAME=adempiere ADEMPIERE_KEYSTORECODEALIAS=adempiere ADEMPIERE_KEYSTOREPASS=jdf439c345fgh2&*332jdki235dedee1jkf1\!j23 ADEMPIERE_ADMIN_EMAIL=support@localdomain.tld ADEMPIERE_CERT_LOCATION=Fulham ADEMPIERE_HOME=/home/adempiere/Adempiere ADEMPIERE_MAIN_VERSION=Release 3.5.0 ADEMPIERE_CERT_CN=adempiere.weir.lan ADEMPIERE_FTP_PASSWORD=user@host.com ADEMPIERE_MAIL_USER= ADEMPIERE_DB_USER=adempiere ADEMPIERE_JAVA_OPTIONS=-Xms64M -Xmx768M ADEMPIERE_APPS_TYPE=jboss ADEMPIERE_APPS_SERVER=adempiere.weir.lan ADEMPIERE_DB_PORT=5432 ADEMPIERE_FTP_USER=anonymous ADEMPIERE_KEYSTOREWEBALIAS=adempiere ADEMPIERE_DB_PATH=postgresql ADEMPIERE_SSL_PORT=8443 ADEMPIERE_WEB_ALIAS=adempiere.weir.lan ADEMPIERE_WEB_PORT=8000 ADEMPIERE_CERT_ORG=Akuna Ltd ADEMPIERE_DB_URL=jdbc\:postgresql\://adempiere.weir.lan\:5432/adempiere ADEMPIERE_APPS_DEPLOY=/home/adempiere/Adempiere/jboss/server/adempiere/deploy ADEMPIERE_DB_SERVER=adempiere.weir.lan ADEMPIERE_KEYSTORE=/home/adempiere/Adempiere/keystore/myKeystore JAVA_HOME=/usr/java/jdk1.6.0_12 ADEMPIERE_MAIL_PASSWORD= ADEMPIERE_DB_TYPE=postgresql ADEMPIERE_DB_VERSION=2008-03-26 ADEMPIERE_JAVA_TYPE=sun ADEMPIERE_CERT_STATE=London " > AdempiereEnv.properties
- Run the setup
./RUN_silentsetup.sh
- Start server
cd utils nohup ./RUN_Server2.sh &
- check the startup log
tail -f /var/log/nohup.out
Notes
- 1 - The identd server is required otherwise you (or at least I) ran in to authentication issues - I probably need to understand pg_hba.conf a little better
- 2 - I was going to set this box up to compile from svn but I was unable to sort out dependencies on subversion (conflict in apr-utils with the centos postgresql packages). I therefore handed off the svn update and compile to a separate box