TinyERP

From Organic Design wiki
Info.svg TinyERP appears to have been discontinued.


TinyERP looks very good from the documentation, but unfortunately is too difficult to install. So far I haven't been able to install it successfully on either Debian or Ubuntu using either the local interface or the web interface.

Installation Notes

First install TinyERP and Postgres from root user,

mkdir /usr/lib/postgresql/x.x/main
chown postgres:postgres /usr/lib/postgresql/x.x/main

# Debian
apt-get install tinyerp-server
apt-get install postgresql postgresql-client
apt-get install python2.4 python2.4-psycopg python2.4-libxml2
    python2.4-xml python2.4-libxslt1 python-reportlab
    python2.4-imaging python-pyparsing graphviz python-tz

# Ubuntu 7.04
apt-get install tinyerp-server
apt-get install postgresql-8.2 postgresql-client-8.2
apt-get install python2.5-imaging python-pyparsing graphviz python-tz

The Debian apt-get got postgres client and server sets up the postgres user and sets the data location up in a directory called main in the same location as the directory of the running binary. Set the password for the postgres user while still logged in as root. The postgres data location must be initialised first by logging back in as the postgres user (or use su posthres from root user) and then initialise the data directory (see pgdocs), eg:

/usr/lib/postgresql/7.4/bin/initdb -D /usr/lib/postgresql/7.4/main
/etc/init.d/postgresql-7.4 restart

If this succeeds you can create the tinyerp db and user as follows (see SetupAPostgresqlUserAndDatabase). This operation must still be done from the postgres user.

createuser -U postgres --no-createdb --no-adduser -P terp
createdb -U postgres -O terp --encoding=UNICODE terp

TinyERP should now be able to run, try restarting it with the following:

/etc/init.d/tinyerp-server restart

Setting up for Web Access

see WebClientInstallLinux

apt-get install python2.4-setuptools python-turbogears
apt-get install build-essential
apt-get install python2.4-dev
apt-get install python2.4-numeric
apt-get install python2.4-numeric-ext
apt-get install libfreetype6-dev
apt-get install libpng12-dev
apt-get install python-matplotlib
apt-get install python-numpy

Download the latest eTiny extract to a dir like /var/www/eTiny-0.0.1, set the configuration in eTiny-0.0.1/tinyerp/config/app.cfg to:

tiny.server = "localhost"
tiny.port = 8070
tiny.protocol = "http" 

Run the eTiny-1.0.0/start-tinyerp.py script (needs to be manually added to /etc/init.d.

Current Situation

It's all installed and its http server is able to run, but there's not enough resource for Apache to work at the same time. It serves on port 8080, but currently crashes with a bunch of python errors. --Nad 23:09, 4 August 2007 (NZST)

Config and Debugging

The default TinyERP server config is in /etc/default/tinyerp-server. --verbose and --logfile options can be added to the command options at the end.

See also