All-in-one installer could warn if existing postgres install needs additional config

[arnavnegi]

The GTK client of OpenERP uses Postgres as database engine for its server setup in a all in one installation setup. But the connection needs a user with superadmin privileges to create a new db to start using the resident OpenERP GTK client. This calls for either configuration of existing postgres DB for openERP database instances or a new postgres installation in case the resident user doesn't have Postgres installed. But in my case there was no configuration step for existing postgres DB (I had one installed) in installation process. All the settings and connection to DB was possible only after contacting the support team, as the team suggested that i manually create a superadmin user named as openpg in my postgres for which i had to check the config file open-erp.conf which was configured in conf file which was part of installer. Here there is no wizard provided between GTK and postgres by the installer.

[Olivier Dony (Odoo) (odo-openerp)]

Indeed, if postgres is already installed the current all-in-one installer does not warn that you need to setup the proper access rights in postgres. In fact it assumes that another all-in-one was previously installed and the user knows how this works.

We could add a warning message during installation if we don't install postgres, so that the user verifies that the configuration is correct.

Assigning to Stephane who has rewritten the all-in-one installer already (maybe it's already supported)

[Olivier Dony (Odoo) (odo-openerp)]

After confirmation from Stephane, the new All-In-One installer shows a configuration screen for setting up the postgres parameters if it detects that postgres is already installed (and stores these parameters in the conf file)
This is available as of the upcoming 6.0-rc2 or as a beta (see community mailing-list for link to beta installer)

[arnavnegi (arnav-negi)]

Olivier,

I assume this configuration is part of installer in further released beta builds and should ask for postgres credentials. Here a small concern : the privilege given to user created during installer will be discouraged by the Postgres until and unless we create it using postgres admin account. So is it that installer asks for postgres admin details too? Further for older installers there should be an option for configuring the DB connection post installer.

Thanks for prompt response
Arnav Negi

--- On Wed, 12/8/10, Olivier Dony (OpenERP) <email address hidden> wrote:

From: Olivier Dony (OpenERP) <email address hidden>
Subject: [Bug 685948] Re: All-in-one installer could warn if existing postgres install needs additional config
To: <email address hidden>
Date: Wednesday, December 8, 2010, 3:15 PM

After confirmation from Stephane, the new All-In-One installer shows a configuration screen for setting up the postgres parameters if it detects that postgres is already installed (and stores these parameters in the conf file)
This is available as of the upcoming 6.0-rc2 or as a beta (see community mailing-list for link to beta installer)

** Changed in: openobject-server
       Status: Confirmed => Fix Released

** Changed in: openobject-server
    Milestone: None => 6.0-rc2

--
You received this bug notification because you are a direct subscriber
of the bug.
https://bugs.launchpad.net/bugs/685948

Title:
  All-in-one installer could warn if existing postgres install needs additional config

Status in OpenObject Server:
  Fix Released

Bug description:
  The GTK client of OpenERP uses Postgres as database engine for its server setup in a all in one installation setup. But the connection needs a user with superadmin privileges to create a new db to start using the resident OpenERP GTK client. This calls for either configuration of existing postgres DB for openERP database instances or a new postgres installation in case the resident user doesn't have Postgres installed. But in my case there was no configuration step for existing postgres DB (I had one installed) in installation process. All the settings and connection to DB was possible only after contacting the support team, as the team suggested that i manually create a superadmin user named as openpg in my postgres for which i had to check the config file open-erp.conf which was configured in conf file which was part of installer. Here there is no wizard provided between GTK and postgres by the installer.

To unsubscribe from this bug, go to:
https://bugs.launchpad.net/openobject-server/+bug/685948/+subscribe