Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001154Openbravo ERPK. Packagingpublic2007-04-30 12:572008-11-25 21:47
Reporteruser11 
Assigned Tojpabloae 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0001154: No admin password for PostgreSQL in Ubuntu/Debian
DescriptionIn Ubuntu/Debian, there is no admin password for PostgreSQL.

Under this distributions you have to setup a password (a pain in the neck) to make the installer happy and make possible to continue with the next installation screen.

Solution: It should be possible to enter a blank password . May be should warn user that in some distros the user has a password and may be necessary.

Jordi,
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-12 10:04jpabloaeProjectOpenbravo ERP => @5@
2008-06-12 11:56jpabloaeCategoryA.Installation & Platform => Installer
2008-11-13 06:51jpabloaeStatusnew => closed
2008-11-13 06:51jpabloaeNote Added: 0010225
2008-11-13 06:51jpabloaeResolutionopen => out of date
2008-11-25 21:41pjuvaraSticky IssueNo => Yes
2008-11-25 21:43pjuvaraProject@5@ => Openbravo ERP
2008-11-25 21:45pjuvaraCategoryInstaller => K. Packaging
2008-11-25 21:47pjuvaraSticky IssueYes => No

Notes
(0004743)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1710008 [^]
(0001016)
jpabloae   
2007-04-30 22:59   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1603191
Originator: NO

This is a common issue in most default PostgreSQL installations. A possible workaround for the users:
1) Edit pg_hba.conf (located in /var/lib/postgresql/data or similar) and replace all the "password" or "md5" strings by "trust". Eg:

local all all md5
into
local all all trust

2) Restart postresql: /etc/init.d/postgresql restart
3) Change postgres' password:

psql -d postgres -U postgres
alter role postgres with password 'new_password';
\q

4) Open pg_hba.conf again and replace all the "trust" strings by "md5".
5) Restart postgresql.
(0001017)
user71   
2007-05-24 15:48   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1318257
Originator: NO

You can simple change PostgresSQL admin password.
$ sudo su - postgres
$ alter role postgres with password '123';
$ exit
(0001018)
user71   
2007-05-24 16:48   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1318257
Originator: NO

Pass something in previous post.
This is right way:
$ sudo su - postgres
$ psql -U postgres
# alter role postgres with password '123';
# \q
$ exit
(0001019)
user11   
2007-11-11 15:11   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1505407
Originator: YES

I'm re-opening this bug. The installer still does not work correctly. Jordi,
(0001020)
villind   
2007-12-12 14:22   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=61737
Originator: NO

I would suggest instead that there would be option to install to an existing database & database user. Then you don't need to care about this, but just expect that there is an existing database (or at least database user).

See feature request: https://sourceforge.net/tracker/index.php?func=detail&aid=1761370&group_id=162271&atid=823132 [^]
(0010225)
jpabloae   
2008-11-13 06:51   
Thank you for the bug report.

However, I close the issue because we are not having an installer for 2.50 and future releases.