Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 181549

Summary: app-office/tinyerp-client-4.0.3 and tinyerp-server-4.0.3 fail to connect
Product: Gentoo Linux Reporter: MickKi <confabulate>
Component: Current packagesAssignee: Cédric Krier <cedk>
Status: RESOLVED INVALID    
Severity: major    
Priority: High    
Version: unspecified   
Hardware: x86   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description MickKi 2007-06-10 17:35:59 UTC
When launching the client it returns:
=======================================
No database found, you must create one!
=======================================

Neither admin nor demo logins work.

Reproducible: Always

Steps to Reproduce:
1.Emerge dev-db/postgresql-8.0.13
2.Emerge app-office/tinyerp-server-4.0.3
3.Emerge app-office/tinyerp-client-4.0.3
4.Complete the ebuild post install config scripts; e.g. # emerge --config =app-office/tinyerp-server-4.0.3
5.Launch tinyerp-client
6.Fails to connect with error: "No database found, you must create one!"


Expected Results:  
It should offer to login with a choice of databases (in this case the default db terp).

The # emerge --config =app-office/tinyerp-server-4.0.3 post-install script creates a database called terp, but under the user name postgres (superuser).

To fix it I had to run:
===============================================
$ su postgres
Password:************
$ cd
$ psql -l
        List of databases
   Name    |  Owner   | Encoding  
-----------+----------+-----------
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
 terp      | postgres | SQL_ASCII
(3 rows)
$ dropdb -U postgres terp
DROP DATABASE
$ createdb -U terp terp
CREATE DATABASE
$ $ psql -l
        List of databases
   Name    |  Owner   | Encoding  
-----------+----------+-----------
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
 terp      | terp     | SQL_ASCII
(3 rows)
$ exit
$ su
Password:************
# /etc/init.d/tinyerp-server start
===============================================
Comment 1 Cédric Krier gentoo-dev 2007-06-10 21:45:00 UTC
You can create the database in the client menu.
This is the normal behavior of the application.
Comment 2 MickKi 2007-06-11 05:54:31 UTC
Thanks Cedric, it wasn't clear to me and could not see it in the Docs that this is what I had to do to connect first time. It would be more straight forward if the post-install config script created the necessary database and user to enable first time connections.  From different forums I see that I am not alone in having difficulty with this.  Since this is perhaps more of a feature request than a bug, I apologise for the noise.
-- 
Regards,
Mick