Bug 201545 - postgres role tinyerp needed?
postgres role tinyerp needed?
Product: Fedora
Classification: Fedora
Component: tinyerp (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Dan Horák
Fedora Extras Quality Assurance
Depends On:
  Show dependency treegraph
Reported: 2006-08-07 05:43 EDT by Thilo Pfennig
Modified: 2007-11-30 17:11 EST (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2006-08-07 07:06:24 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Thilo Pfennig 2006-08-07 05:43:07 EDT
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):

How reproducible:


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
Actual results:

error message that role tinyerp does not exist

Expected results:

Maybe creation of user or hint in README files.

Additional info:
Comment 1 Dan Horák 2006-08-07 06:48:07 EDT
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.
Comment 2 Dan Horák 2006-08-07 07:06:24 EDT
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.
Comment 3 Thilo Pfennig 2006-08-07 08:50:35 EDT
I think I also might have used wrong template.
Comment 4 Thilo Pfennig 2006-08-07 08:50:52 EDT
fixed now.


Note You need to log in before you can comment on or make changes to this bug.