high performance ssd vps
sound byJbgmusic
If we have helped you in our small way, please consider buying us a cup of coffee to keep us going or exit by clicking our sponsored links. Thank you.

Enter Amount:

Thank for sponsoring our site.
Please login to Automatic Backlinks and activate this site.
JoomlaWatch Stats 1.2.9 by Matej Koval
Google PageRank Checker
Install Adempiere ERP on Ubuntu Karmic Koala - Setup Environment / Postgres PDF Print E-mail
Written by Administrator   
Sunday, 25 April 2010 20:16
Article Index
Install Adempiere ERP on Ubuntu Karmic Koala
Setup Environment / Postgres
Install Adempiere
All Pages


STEP 5: Setup the environment

Edit /etc/hosts and add a Fully Qualified Domain Name (fqdn) like adempiere.company.com to identify the adempiere machin

127.0.0.1 localhost
127.0.1.1 adempiere
192.168.0.1 adempiere.company.com <-- change to your ip address, add your ip as host, you need this to be able to access from outside your server

Add the ff at the end of your /etc/profile, so that whenever you login it will be set.

$ sudo nano /etc/profile <---- store here to declare variables globally

export JAVA_HOME="/usr/lib/jvm/java-6-sun" <---- declare JAVA_HOME environment variable
export ADEMPIERE_HOME="/opt/Adempiere" <---- declare ADEMPIERE_HOME environment variable

Edit your pg_hba.conf to reflect the changes in bold font.

$ sudo nano /etc/postgresql/8.4/main/pg_hba.conf <---- add your host in trusted list for Postgres

# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.0.161/24 trust <<<<---- use your ip address here

Edit your postgresql.conf. Look for listen_addresses and uncomment it i.e. remove the # (comment) and replace localhost by a '*' to allow it to listen to any hosts.

$ sudo nano /etc/postgresql/8.4/main/postgresql.conf

listen_addresses = '*' <---- to allow postgres to listen from other hosts

Restart Postgres
$ sudo /etc/init.d/postgresql-8.4 restart <--- restart to effect changes


$ sudo unzip Adempiere_342s.zip -d /opt <---- unzip Adempiere program to /opt directory, if you don't want to use /opt make sure to make necessary changes to      $ADEMPIERE_HOME

 

STEP 6: Setup up the Database (Postgres)

$ sudo su - postgres <--- switch to postgres user
$ /usr/bin/createdb adempiere <---- create adempiere database
$ /usr/bin/createuser adempiere <---- create user adempiere
$ echo "ALTER USER adempiere WITH passWORD 'yourpw';" | psql <---- create a password for user adempiere and pipe it to psql
$ psql -h localhost -d adempiere -U adempiere <      $ADEMPIERE_HOME/data/Adempiere_pg.dmp <--- import/create database schema to be used by Adempiere
$ exit <--- switch back to adempiere user

 



Last Updated on Wednesday, 06 October 2010 12:25
 
Comments (9)
error on database port
9 Thursday, 15 December 2011 13:40
danishfa
Dear,

I'm using Ubuntu 11.10 and everything is okay.
But when I run ./RUN_setup.sh
I see warning:
Error Port Database
(DB Server Port = 5432)

Can't I repair that and How?
Thanks

Regards,
I couldn't access my Adempiere installation
8 Thursday, 27 January 2011 00:57
Pekoi
I had to remove the libtcnative-1 package from my linux installation - used by previous Jboss versions.
Adempiere + Ubuntu
7 Thursday, 13 January 2011 00:09
pete_pablo
STEP 7: Install Adempiere:

...
1. If you have Apache installed, you may need to change the webport to 8080.
2. Enter adempiere.company.com for your apps directory/folder
3. Enter adempiere.company.com for your db directory/folder
....

what does it mean?

thx
error message
6 Thursday, 23 September 2010 04:44
Bob Meyers
There error message I got was:
psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "adempiere", database "adempiere", SSL on
FATAL: no pg_hba.conf entry for host "127.0.0.1", user "adempiere", database "adempiere", SSL off
error install
5 Thursday, 23 September 2010 04:40
Bob Meyers
I tried the above on two Ubuntu systems but neither worked. On the Ubuntu Lucid 10.04 I could not enter a "web port" without error. On the other a 9.10 Karmic I got error trying to run step 6 "psql" command, error message: "psql -h localhost -d adempiere -U adempiere nks for the very well written tutorial!

Nice tunes:)
Administrator's reply:
Nice catch
Friday, 24 September 2010 13:22
Administrator
Oops, my mistake. The unzip should be prior to that command, I have adjusted the article to reflect the change.
Error Email Admin
4 Sunday, 19 September 2010 21:44
clp3z
***o! I have an error on "Email Admin", how i should to do for solved it? I tried changing the file pg_hba.conf, but don't work, it show this message for console:

ConfigurationData.testPort: Open Socket adempiere.company.com/190.207.204.193:25 - Connection refused [15]
09:08:58.382 ConfigurationData.testMailServer: SMTP Server NOT available [15]
testPort[190.207.204.193, 110]
-----------> ConfigurationData.testPort: Open Socket adempiere.company.com/190.207.204.193:110 - Connection refused [15]
09:08:58.383 ConfigurationData.testMailServer: POP3 Server NOT available [15]
testPort[190.207.204.193, 143]
-----------> ConfigurationData.testPort: Open Socket adempiere.company.com/190.207.204.193:143 - Connection refused [15]
09:08:58.384 ConfigurationData.testMailServer: IMAP4 Server NOT available [15]
-----------> ConfigurationData.testMailServer: No active Mail Server [15]
-----------> ConfigurationData.testMail: Not verified EMail = info@XXUser

Thanks!
Works perfect.
3 Thursday, 05 August 2010 22:39
crazyabs
works perfect in ubuntu 10.04 and adempiere 3.6Lts

just to add. for the noobies like me. when using nano and editing the script. if you gonna save the file just press F2.... *** it took me a long time to know that. lol.
Adempiere + Ubuntu Lucid + Service Startup on Boot
2 Sunday, 16 May 2010 04:02
Ahmad H. Ashkanani
What an excellent tutorial. It worked like a charm on my Ubuntu 10.04. However,i was unable to setup Adempiere to start automatically upon PC startup. I have tried following up related material on the internt but i failed;It won't startup. Can you shed some light on the subject?Many thanks
Adempiere + Ubuntu Lucid + Service Startup on Boot
1 Sunday, 16 May 2010 04:00
Ahmad H. Ashkanani
Hi,
What an excellent tutorial. It worked like a charm on my Ubuntu 10.04. However,i was unable to setup Adempiere to start automatically upon PC startup. I have tried following up related material on the internt but i failed;It won't startup. Can you shed some light on the subject?Many thanks
Administrator's reply:
Service startup
Tuesday, 18 May 2010 21:49
Administrator
I have added the procedure to set it as a service at boot time

Add your comment

Your name:
Your email:
Subject:
Comment:
  The word for verification. Lowercase letters only with no spaces.
Word verification: