Bug 201545

Summary:	postgres role tinyerp needed?
Product:	[Fedora] Fedora	Reporter:	Thilo Pfennig <tpfennig>
Component:	tinyerp	Assignee:	Dan Horák <dan>
Status:	CLOSED NEXTRELEASE	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	5	CC:	extras-qa
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2006-08-07 11:06:24 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Thilo Pfennig 2006-08-07 09:43:07 UTC

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):
tinyerp-server-3.3.0-2.fc5

How reproducible:

always

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 10:48:07 UTC

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 11:06:24 UTC

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";
\q

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 12:50:35 UTC

I think I also might have used wrong template.

Comment 4 Thilo Pfennig 2006-08-07 12:50:52 UTC

fixed now.

ty.