PostBooks ERP On Ubuntu 7.04

Version 1.0
Author: Oliver Meyer <o [dot] meyer [at] projektfarm [dot] de>
Last edited 08/16/2007

This document describes how to set up PostBooks ERP on Ubuntu 7.04. The resulting system provides a powerful GUI-based ERP-system. Postbooks is licensed under the CPAL license (OSI-certified Common Public Attribution License).

This howto is meant as a practical guide; it does not cover the theoretical backgrounds. They are treated in a lot of other documents in the web.

This document comes without warranty of any kind! I want to say that this is not the only way of setting up such a system. There are many ways of achieving this goal but this is the way I take. I do not issue any guarantee that this will work for you!

 

1 Preparation

Set up a basic ubuntu 7.04 system and update it.

 

2 Get Postbooks

cd ~

wget http://mesh.dl.sourceforge.net/sourceforge/postbooks/PostBooks-2.2.0Beta3-Linux6.tar.bz2
wget http://mesh.dl.sourceforge.net/sourceforge/postbooks/postbooks_quickstart.backup
wget http://mesh.dl.sourceforge.net/sourceforge/postbooks/init.sql

tar xvfj PostBooks-2.2.0Beta3-Linux6.tar.bz2

 

3 Install PostgreSQL

sudo apt-get install postgresql-8.1 postgresql-contrib-8.1

 

4 Configure PostgreSQL

The default configuration of PostgreSQL on Debian and Debian-based distributions requires that the system-username is the same as the postgresql-username to connect to postgresql.

So we have to customize the pg_hba.conf:

sudo vi /etc/postgresql/8.1/main/pg_hba.conf

Near the end of the file you should see this:

# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5

Change it to:

# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
#local all all ident sameuser
local all all trust
# IPv4 local connections:
#host all all 127.0.0.1/32 md5
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5
host all all ::1/128 trust

Now restart Postgresql:

sudo /etc/init.d/postgresql-8.1 restart

 

5 Prepare Postgresql For Postbooks

cd ~

sudo su postgres

psql -U postgres -f init.sql template1
createdb -U mfgadmin mfg
pg_restore -U mfgadmin -d mfg postbooks_quickstart.backup -v

 

6 Create A Desktoplauncher

Right click on the Desktop and choose "Create Launcher..." from the menu.

In the new window choose:

Type: Application
Name: Postbooks (or something else)
Command: /home/%yourusername%/PostBooks/PostBooks
Comment: Insert something if you want
Icon: Select one if you want

Now you can start Postbooks via double-click on the icon.

Log in with the default-username "mfgadmin" and the default-password "mfgadmin".

Use this settings only to test!


 

A detailed user-guide is also available. Click here to download it.

 

7 Links

Share this page:

7 Comment(s)

Add comment

Comments

From: at: 2007-08-27 18:27:33

Hi

I was problem with 5 step. I get error:

suvi@suvi-laptop:~$ psql -U postgres -f init.sql template1
psql: FATAL:  Ident authentication failed for user "postgres"
suvi@suvi-laptop:~$
 

Solution was:

sudo su postgres

And then I make database, user and filled this with data. 

From: at: 2007-08-27 21:52:27

I had to do an extra step to get this working in step 5. I noted it in bold.

cd ~

su postgres

psql -U postgres -f init.sql template1
createdb -U mfgadmin mfg
pg_restore -U mfgadmin -d mfg postbooks_quickstart.backup -v

From: at: 2007-08-28 08:17:11

I added this step to the howto.

Olli

From: at: 2008-04-05 11:07:16

I just installed PostBook acording your documentation. On Ubuntu 7.10 I ran into problems. When trying to connect I get:

QSqlDatabase: QPSQL7 driver not loaded
QSqlDatabase: available drivers:

I ldd'd the problem down to two missing libraries:

ldd sqldrivers/libqsqlpsql.so
        libssl.so.4 => not found
        libcrypto.so.4 => not found

I locally linked the existing libssl (openssl) and librypto libraries to the local PostBook install dir:

user@ubuntu: /tmp/xtuple-2.3.1$ ln -s /usr/lib/libcrypto.so ./libcrypto.so.4
user@ubuntu: /tmp//xtuple-2.3.1$ ln -s /usr/lib/libssl.so./ libssl.so.4

Then PostBooks works.

-- Robert  

From: MarkW at: 2009-02-14 03:00:37

This deals with installation on Ubuntu 8.10 amd64 using Postbooks 3.2.1

Ensure that the various libraries are installed (ia32-libs, lib32readline5 and lib32ncurses5). cd to the xtuple base directory and then:
ln -s /usr/lib32/libcrypto.so.0.9.8 libcrypt
ln -s /lib32/libreadline.so.5 libreadline.so.4
ln -s /usr/lib32/libssl.so.0.9.8 libssl.so.4
ln -s /lib32/libncurses.so.5 libtermcap.so.2

From: Nicholas Henry at: 2009-02-23 18:06:57

This is what I had to do to get PostBooks 3.2.0 working on Ubuntu 8.10:

cd ~/Programs/xtuple-3.2.0/
ln -s /usr/lib/libcrypto.so.0.9.8 libcrypto.so.4
ln -s /lib/libreadline.so.5 libreadline.so.4
ln -s /usr/lib/libssl.so.0.9.8 libssl.so.4
ln -s /lib/libncurses.so.5 libtermcap.so.2
 

From: Lipu at: 2009-02-26 07:21:08

In the previous comment, it says 

Ensure that the various libraries are installed (ia32-libs, lib32readline5 and lib32ncurses5).
cd to the xtuple base directory and then:

ln -s /usr/lib32/libcrypto.so.0.9.8 libcrypt

...

I did not succeed with this command. Instead I tried this command. Then I restarted the Postbooks3.2.1, it worked. 

ln -s /usr/lib32/libcrypto.so.0.9.8 libcrypto.so.4