Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] K. Packagingminoralways2007-04-30 12:572008-11-25 21:47
Reporteruser11View Statuspublic 
Assigned Tojpabloae 
PrioritynormalResolutionout of dateFixed in Version2.40
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0001154: 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.

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
jpabloae (reporter)
2007-04-30 22:59
edited on: 2008-06-12 09:18

Logged In: YES
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
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';

4) Open pg_hba.conf again and replace all the "trust" strings by "md5".
5) Restart postgresql.
2007-05-24 15:48
edited on: 2008-06-12 09:18

Logged In: YES
Originator: NO

You can simple change PostgresSQL admin password.
$ sudo su - postgres
$ alter role postgres with password '123';
$ exit
2007-05-24 16:48
edited on: 2008-06-12 09:18

Logged In: YES
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
2007-11-11 15:11
edited on: 2008-06-12 09:18

Logged In: YES
Originator: YES

I'm re-opening this bug. The installer still does not work correctly. Jordi,
villind (developer)
2007-12-12 14:22
edited on: 2008-06-12 09:18

Logged In: YES
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: [^]

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: [^]
jpabloae (reporter)
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.

- Issue History
Date Modified Username Field Change
2008-06-12 10:04 jpabloae Project Openbravo ERP => @5@
2008-06-12 11:56 jpabloae Category A.Installation & Platform => Installer
2008-11-13 06:51 jpabloae Status new => closed
2008-11-13 06:51 jpabloae Note Added: 0010225
2008-11-13 06:51 jpabloae Resolution open => out of date
2008-11-25 21:41 pjuvara Sticky Issue No => Yes
2008-11-25 21:43 pjuvara Project @5@ => Openbravo ERP
2008-11-25 21:45 pjuvara Category Installer => K. Packaging
2008-11-25 21:47 pjuvara Sticky Issue Yes => No

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker