Error al inciar Pyreplica.....

From: maria teresa tarquino chavez <veneca30(at)hotmail(dot)com>
To: FORO POSTGRES <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Error al inciar Pyreplica.....
Date: 2009-12-18 13:15:59
Message-ID: BAY120-W358167B0A61EEBDFD636D2D6850@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola lista, tengo el siguiente problema estoy configurando pyreplica con maestro-esclavo mi esclavo lo tengo en mi localhost y el maestro en otro servidor, ya ejecute en mi maestro el scrip sql master-install.sql y mi somedb.conf con los parametros que indica el archivo de instalacion, ahora cuando ejecuto:
root(at)servidor-desktop:/usr/local/pyreplica# python pyreplica.py
"dbname=db_control_seguimiento user=postgres host=172.16.1.208"
"dbname=db_control_seguimiento user=postgres host=localhost"

me genera este error:

Thu Dec 17 14:41:22 2009 Opening origin (master) connection
Thu Dec 17 14:41:22 2009 connect(): FATAL ERROR: fe_sendauth: no password supplied

Traceback (most recent call last):
File "pyreplica.py", line 221, in <module>

main_loop(DSN0,DSN1,is_killed=lambda:False, skip_user='', slave_field=FIELD, keepalive = True)
File "pyreplica.py", line 153, in main_loop
con0, con1 = connect(dsn0, dsn1, debug)
File "pyreplica.py", line 133, in connect

con0 = psycopg2.connect(dsn0,connection_factory=tpc.TwoPhaseCommitConnection)
File "/usr/local/pyreplica/tpc.py", line 27, in __init__
connection.__init__(self,*args,**kwargs)
psycopg2.OperationalError: fe_sendauth: no password supplied

y si ejecuto:

/etc/usr/local/pyreplica.py star en mi log se genera lo siguiente:

controlseguimiento Thu Dec 17 14:34:11 2009 Opening origin (master) connection
controlseguimiento Thu Dec 17 14:34:11 2009 Opening replica (slave) connection
controlseguimiento Thu Dec 17 14:34:46 2009 Opening origin (master) connection

controlseguimiento Thu Dec 17 14:34:46 2009 Opening replica (slave) connection

mi somedb.conf esta asi

[MAIN]
# name of replica set (first field of log file entries)
NAME=controlseguimiento
# master database connection string:

DSN0=dbname=db_control_seguimiento user=postgres password=123456 host=172.16.1.208
# slave database connection string:
DSN1=dbname=db_control_seguimiento user=postgres password=123456 host= localhost
# in multimaster setup, set the replication postgres user

SKIP_USER=pyreplica
# in multi-slave setup, set the slave column to mark data as replicated
SLAVE_FIELD=replicated
# send a trivial query to keep alive the connection (optional)
KEEPALIVE=true
# optional debug level (0: none, 1: normal, 2: verbose, 3: very verbose)

DEBUG_LEVEL=1

lo siguiente esta comentado porque todavia no tengo el correo
# email notification config (optional):
#[SMTP]
#SERVER=somehost.somewhere.com
# login is optional:
#USERNAME=no-reply(at)somewhere(dot)com

#PASSWORD=secret
#START_SUBJECT=[PyReplica] Starting db_control_seguimiento replication
#START_SUBJECT=[PyReplica] Starting db_control_seguimiento replication
#STOP_SUBJECT=[PyReplica] Stopping db_control_segumiento replication

#ERROR_SUBJECT=[PyReplica] Starting db_control_seguimiento replication (ERROR)
#WARNING_SUBJECT=[Replica] WARNING on db_control_seguimiento replication
#FROM_ADDR=no-reply(at)somewhere(dot)com

#TO_ADDRS=hostmaster(at)somewhere(dot)com;dbadmin(at)somewhere(dot)com

si alguien me puede ayudar por favor....


_________________________________________________________________

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Mariano Reingart 2009-12-18 14:39:56 Re: Error al inciar Pyreplica.....
Previous Message Alvaro Herrera 2009-12-18 03:24:43 Re: Problemas con permisos para aplicaciones locales