Red Hat Bugzilla – Bug 201545
postgres role tinyerp needed?
Last modified: 2007-11-30 17:11:39 EST
Description of problem:
As I tried to start the tinyerp-server it told me that there is no user tinyerp
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. install tinyerp-server
2. make the init as user postgres: tinyerp-server --init=all
3. /etc/init.d/tinyerp-server start
error message that role tinyerp does not exist
Maybe creation of user or hint in README files.
tinyerp-server package installs a config file in /etc/tinyerp-server.conf with
all default values. The docs at http://tinyerp.org about database access are a
bit unclear as I see. So, you should create one db user, one database that is
owned by this user, try all with the PostgreSQL command line client psql and
then set these values to the variables (db_*) in the config file. You should
also be familiar with PostgreSQL administration at least a bit.
I will try to prepare some Fedora oriented post-installation notes and include
them in the next package version.
And here are the steps:
as a root run: su -c "psql template1" postgres
then in psql client:
create user tinyerp;
create database terp with owner "tinyerp";
again as root:
service tinyerp-server start
This works with the default config file for TinyERP and also default setup of
PostgreSQL. At least on my FC4 machine.
I think I also might have used wrong template.