openerp-india team mailing list archive

["Jigar Amin \(OpenERP\)" <914638@xxxxxxxxxxxxxxxxxx>]

Hello Ferdinand,
    Basically, the Database Option --db_user=DB_USER --db_password=DB_PASSWORD are not for the log-in in to specific database defined on command line Option --database=DB_NAME. 
Answer to your question in Comment#1 is :
    Use of this command lines options is done at database level, for connecting to the Postgresql Database Using Different user then system named user that we usually creates while OE configuration. Their can be certain way where you can use e.g. when you have existing Postgresql server with some Postgres User and you do not wanna create New User, So you can define that existing user name and Password.
   Database Specific Command line Argument:
    --db_user=<postgres_user> Default user will be taken Using "Utilities to get a password and/or the current user name (getpass)."
    --db_password=<postgresql_user_pwd> Default user password will be taken Using "Utilities to get a password and/or the current user name (getpass)."
    --db_host=<postgresql_host_address> if any Default is "localhost"
    --db_port=<postgresql_custom_port> by default 5432
    e.g. 
        --db_host=192.168.1.182 --db_port=5432 --db_user=kjo --db_password=<user_pwd>

    So Now OE Server to  talk to remote Postgresql Server Running at specified Point and that Postgresql Login Credentials will be taken from  --db_user and --db_password.
While The Option --db-template=DB_TEMPLATE is used to specify a custom database template to create a new database.

Hope This will Help you. I am setting this Bug to Invalid.
Thank You for Patient.

** Changed in: openobject-server
       Status: Confirmed => Invalid

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/914638

Title:
  Authentication failed : Can not login from command line

Status in OpenERP Server:
  Invalid

Bug description:
  none of the users is able to login

  /srv/openerp/instances/trunk/openobject-server/openerp-server
  --modules=xml_template --i18n-export=xml_template/i18n/de_DE.po
  --language=de_DE --config=/srv/openerp/.openerp_server_61_rc
  --database=blau61a --db_user=admin  --db_password=<my password>
  --stop-after-init


  Traceback (most recent call last):
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/sql_db.py", line 423, in borrow
      result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  OperationalError: FATAL:  Ident authentication failed for user "admin"

  [2012-01-11 08:38:08,615][blau61a] ERROR:root:Failed to initialize database `blau61a`.
  Traceback (most recent call last):
    File "/srv/openerp/instances/trunk/openobject-server/openerp-server", line 92, in preload_registry
      db, registry = openerp.pooler.get_db_and_pool(dbname, update_module=config['init'] or config['update'], pooljobs=False)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/pooler.py", line 33, in get_db_and_pool
      registry = RegistryManager.get(db_name, force_demo, status, update_module, pooljobs)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/modules/registry.py", line 138, in get
      update_module, pooljobs)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/modules/registry.py", line 150, in new
      registry = Registry(db_name)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/modules/registry.py", line 53, in __init__
      cr = self.db.cursor()
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/sql_db.py", line 468, in cursor
      return Cursor(self._pool, self.dbname, serialized=serialized)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/sql_db.py", line 176, in __init__
      self._cnx = pool.borrow(dsn(dbname))
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/sql_db.py", line 368, in _locked
      return fun(self, *args, **kwargs)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/sql_db.py", line 423, in borrow
      result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  OperationalError: FATAL:  Ident authentication failed for user "admin"

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/914638/+subscriptions