PostBooks ERP On Ubuntu 7.04

Want to support HowtoForge? Become a subscriber!
 
Submitted by o.meyer (Contact Author) (Forums) on Thu, 2007-08-23 16:44. :: Ubuntu | Desktop

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


Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.
Submitted by Lipu (not registered) on Thu, 2009-02-26 08:21.

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

 

Submitted by Nicholas Henry (not registered) on Mon, 2009-02-23 19:06.

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
 

Submitted by MarkW (not registered) on Sat, 2009-02-14 04:00.

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

Submitted by Elconas (registered user) on Sat, 2008-04-05 12:07.

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  

Submitted by o.meyer (registered user) on Tue, 2007-08-28 09:17.

I added this step to the howto.

Olli

Submitted by pyrophor (registered user) on Mon, 2007-08-27 22:52.

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

Submitted by spottraining (registered user) on Mon, 2007-08-27 19:27.

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.