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....
_________________________________________________________________
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 |