Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-es-ayuda by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group