Bug 201545 - postgres role tinyerp needed?
Summary: postgres role tinyerp needed?
Keywords:
Status: CLOSED NEXTRELEASE
Alias: None
Product: Fedora
Classification: Fedora
Component: tinyerp
Version: 5
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Dan Horák
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2006-08-07 09:43 UTC by Thilo Pfennig
Modified: 2007-11-30 22:11 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2006-08-07 11:06:24 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)

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.


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