Subject: Re: [Condor-users] Quill problem - Unable to find password from file
Hi Condor Users,
The following sentence in the documentation
"The .pgpass file contains exactly one line." misled me
causing the error. I corrected the file introducing the CRLF at the end
of that exactly one line and condor_quill and condor_dbmsd are now working.
Klaus
kschwarz@xxxxxxxxxxxxxx Sent by: condor-users-bounces@xxxxxxxxxxx
11/12/2009 17:25
Please respond to
Condor-Users Mail List <condor-users@xxxxxxxxxxx>
To
condor-users@xxxxxxxxxxx
cc
Subject
[Condor-users] Quill problem - Unable
to find password from file
Hi Condor Users,
I am trying to setup quill and dbmsd daemons on a Windows machine. I am
using Condor 7.2.4.
I have installed PostgresSQL 8.4 following their installation procedure.
I have also configured postgresql.conf,
and condor_config parameters as described in the Condor 7.2.4 documentation.
pg_hba.conf was changed as follow:
# TYPE DATABASE USER CIDR-ADDRESS
METHOD
# IPv4 local connections:
#host all all
127.0.0.1/32 md5
host all postgres
127.0.0.1/32 md5
host all quillreader 127.0.0.1
255.0.0.0 md5
host all quillwriter 127.0.0.1
255.0.0.0 md5
Find attached the condor_config_val -dump command result.
C:\condor\spool\.pgpass is set as follow:
pc284419.corp.ad.emb:5432:quillcm:quillwriter:theactualpasswordhere
See the following log files:
MasterLog
----------------
12/11 16:49:57 UnsetEnv(NET_REMAP_ENABLE): SetEnvironmentVariable failed,
errno=203
12/11 16:49:57 ******************************************************
12/11 16:49:57 ** Condor (CONDOR_MASTER) STARTING UP
12/11 16:49:57 ** C:\condor\bin\condor_master.exe
12/11 16:49:57 ** SubsystemInfo: name=MASTER type=MASTER(2) class=DAEMON(1)
12/11 16:49:57 ** Configuration: subsystem:MASTER local:<NONE> class:DAEMON
12/11 16:49:57 ** $CondorVersion: 7.2.4 Jun 15 2009 BuildID: 159529 $
12/11 16:49:57 ** $CondorPlatform: INTEL-WINNT50 $
12/11 16:49:57 ** PID = 2188
12/11 16:49:57 ** Log last touched time unavailable (No such file or directory)
12/11 16:49:57 ******************************************************
12/11 16:49:57 Using config source: C:\condor\condor_config
12/11 16:49:57 Using local config sources:
12/11 16:49:57 C:\condor/condor_config.local
12/11 16:49:57 \\SMBSJK05\grid_env\CONDOR\1-start\condor_config.master.PC284419
12/11 16:49:57 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.1.WINNT
12/11 16:49:57 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.INTEL.WINNT
12/11 16:49:57 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.common
12/11 16:49:57 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.2
12/11 16:49:57 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\PC284419\condor_config.thishost
12/11 16:49:57 DaemonCore: Command Socket at <10.3.28.8:15345>
12/11 16:49:57 Started DaemonCore process "C:\Condor/bin/condor_collector.exe",
pid and pgroup = 444
12/11 16:50:00 Started DaemonCore process "C:\Condor/bin/condor_negotiator.exe",
pid and pgroup = 3176
12/11 16:50:00 Started DaemonCore process "C:\Condor/bin/condor_schedd.exe",
pid and pgroup = 3920
12/11 16:50:00 Started DaemonCore process "C:\Condor/bin/condor_startd.exe",
pid and pgroup = 2632
12/11 16:50:00 Started DaemonCore process "C:\Condor/bin/condor_dbmsd.exe",
pid and pgroup = 2364
12/11 16:50:00 Started DaemonCore process "C:\Condor/bin/condor_quill.exe",
pid and pgroup = 3596
12/11 16:50:00 The QUILL (pid 3596) exited with status 4
12/11 16:50:00 Sending obituary for "C:\Condor/bin/condor_quill.exe"
12/11 16:50:22 restarting C:\Condor/bin/condor_quill.exe in 10 seconds
12/11 16:50:22 The DBMSD (pid 2364) died due to exception ACCESS_VIOLATION
12/11 16:50:22 Sending obituary for "C:\Condor/bin/condor_dbmsd.exe"
12/11 16:50:43 restarting C:\Condor/bin/condor_dbmsd.exe in 10 seconds
12/11 16:50:43 bind failed: WSAError = 10048
12/11 16:50:43 bind failed: WSAError = 10048
12/11 16:50:43 bind failed: WSAError = 10048
12/11 16:50:43 bind failed: WSAError = 10048
12/11 16:50:43 bind failed: WSAError = 10048
12/11 16:50:43 Started DaemonCore process "C:\Condor/bin/condor_quill.exe",
pid and pgroup = 2096
12/11 16:50:46 The QUILL (pid 2096) exited with status 4
12/11 16:50:46 Sending obituary for "C:\Condor/bin/condor_quill.exe"
12/11 16:51:08 restarting C:\Condor/bin/condor_quill.exe in 11 seconds
12/11 16:51:08 Started DaemonCore process "C:\Condor/bin/condor_dbmsd.exe",
pid and pgroup = 3296
12/11 16:51:10 The DBMSD (pid 3296) died due to exception ACCESS_VIOLATION
12/11 16:51:10 Sending obituary for "C:\Condor/bin/condor_dbmsd.exe"
12/11 16:51:32 restarting C:\Condor/bin/condor_dbmsd.exe in 11 seconds
12/11 16:51:32 Started DaemonCore process "C:\Condor/bin/condor_quill.exe",
pid and pgroup = 2308
12/11 16:51:35 The QUILL (pid 2308) exited with status 4
12/11 16:51:35 Sending obituary for "C:\Condor/bin/condor_quill.exe"
QuillLog
------------
12/11 16:50:00 ******************************************************
12/11 16:50:00 ** condor_quill.exe (CONDOR_QUILL) STARTING UP
12/11 16:50:00 ** C:\Condor\bin\condor_quill.exe
12/11 16:50:00 ** SubsystemInfo: name=QUILL type=DAEMON(10) class=DAEMON(1)
12/11 16:50:00 ** Configuration: subsystem:QUILL local:<NONE> class:DAEMON
12/11 16:50:00 ** $CondorVersion: 7.2.4 Jun 15 2009 BuildID: 159529 $
12/11 16:50:00 ** $CondorPlatform: INTEL-WINNT50 $
12/11 16:50:00 ** PID = 3596
12/11 16:50:00 ** Log last touched time unavailable (No such file or directory)
12/11 16:50:00 ******************************************************
12/11 16:50:00 Using config source: C:\condor\condor_config
12/11 16:50:00 Using local config sources:
12/11 16:50:00 C:\condor/condor_config.local
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\1-start\condor_config.master.PC284419
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.1.WINNT
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.INTEL.WINNT
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.common
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.2
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\PC284419\condor_config.thishost
12/11 16:50:00 DaemonCore: Command Socket at <10.3.28.8:53168>
12/11 16:50:00 Will use UDP to update collector PC284419.corp.ad.emb <10.3.28.8:9618>
12/11 16:50:00 FileLock object is updating timestamp on: C:\condor/log/sql.log
12/11 16:50:00 main_init() called
12/11 16:50:00 configuring tt options from config file
12/11 16:50:00 Using Polling Period = 10
12/11 16:50:00 Using logs 12/11 16:50:00 C:\condor/log/schedd_sql.log 12/11
16:50:00 C:\condor/log/sql.log 12/11 16:50:00
12/11 16:50:00 ERROR "Unable to find password from file C:\condor/spool/.pgpass
with prefix pc284419.corp.ad.emb:5432:quillcm:quillwriter:
" at line 93 in file ..\src\condor_c++_util\dbms_utils.cpp
12/11 16:50:46 ******************************************************
12/11 16:50:46 ** condor_quill.exe (CONDOR_QUILL) STARTING UP
12/11 16:50:46 ** C:\Condor\bin\condor_quill.exe
12/11 16:50:46 ** SubsystemInfo: name=QUILL type=DAEMON(10) class=DAEMON(1)
12/11 16:50:46 ** Configuration: subsystem:QUILL local:<NONE> class:DAEMON
12/11 16:50:46 ** $CondorVersion: 7.2.4 Jun 15 2009 BuildID: 159529 $
12/11 16:50:46 ** $CondorPlatform: INTEL-WINNT50 $
12/11 16:50:46 ** PID = 2096
12/11 16:50:46 ** Log last touched 12/11 15:50:00
12/11 16:50:46 ******************************************************
12/11 16:50:46 Using config source: C:\condor\condor_config
12/11 16:50:46 Using local config sources:
12/11 16:50:46 C:\condor/condor_config.local
12/11 16:50:46 \\SMBSJK05\grid_env\CONDOR\1-start\condor_config.master.PC284419
12/11 16:50:46 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.1.WINNT
12/11 16:50:46 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.INTEL.WINNT
12/11 16:50:46 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.common
12/11 16:50:46 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.2
12/11 16:50:46 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\PC284419\condor_config.thishost
12/11 16:50:46 DaemonCore: Command Socket at <10.3.28.8:25365>
12/11 16:50:46 Will use UDP to update collector PC284419.corp.ad.emb <10.3.28.8:9618>
12/11 16:50:46 FileLock object is updating timestamp on: C:\condor/log/sql.log
12/11 16:50:46 main_init() called
12/11 16:50:46 configuring tt options from config file
12/11 16:50:46 Using Polling Period = 10
12/11 16:50:46 Using logs 12/11 16:50:46 C:\condor/log/schedd_sql.log 12/11
16:50:46 C:\condor/log/sql.log 12/11 16:50:46
12/11 16:50:46 ERROR "Unable to find password from file C:\condor/spool/.pgpass
with prefix pc284419.corp.ad.emb:5432:quillcm:quillwriter:
" at line 93 in file ..\src\condor_c++_util\dbms_utils.cpp
12/11 16:51:34 ******************************************************
12/11 16:51:34 ** condor_quill.exe (CONDOR_QUILL) STARTING UP
12/11 16:51:34 ** C:\Condor\bin\condor_quill.exe
12/11 16:51:34 ** SubsystemInfo: name=QUILL type=DAEMON(10) class=DAEMON(1)
12/11 16:51:34 ** Configuration: subsystem:QUILL local:<NONE> class:DAEMON
12/11 16:51:34 ** $CondorVersion: 7.2.4 Jun 15 2009 BuildID: 159529 $
12/11 16:51:34 ** $CondorPlatform: INTEL-WINNT50 $
12/11 16:51:34 ** PID = 2308
12/11 16:51:34 ** Log last touched 12/11 15:50:46
12/11 16:51:34 ******************************************************
12/11 16:51:34 Using config source: C:\condor\condor_config
12/11 16:51:34 Using local config sources:
12/11 16:51:34 C:\condor/condor_config.local
12/11 16:51:34 \\SMBSJK05\grid_env\CONDOR\1-start\condor_config.master.PC284419
12/11 16:51:34 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.1.WINNT
12/11 16:51:34 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.INTEL.WINNT
12/11 16:51:34 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.common
12/11 16:51:34 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.2
12/11 16:51:34 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\PC284419\condor_config.thishost
12/11 16:51:34 DaemonCore: Command Socket at <10.3.28.8:51451>
12/11 16:51:34 Will use UDP to update collector PC284419.corp.ad.emb <10.3.28.8:9618>
12/11 16:51:34 FileLock object is updating timestamp on: C:\condor/log/sql.log
12/11 16:51:34 main_init() called
12/11 16:51:34 configuring tt options from config file
12/11 16:51:34 Using Polling Period = 10
12/11 16:51:35 Using logs 12/11 16:51:35 C:\condor/log/schedd_sql.log 12/11
16:51:35 C:\condor/log/sql.log 12/11 16:51:35
12/11 16:51:35 ERROR "Unable to find password from file C:\condor/spool/.pgpass
with prefix pc284419.corp.ad.emb:5432:quillcm:quillwriter:
" at line 93 in file ..\src\condor_c++_util\dbms_utils.cpp
DbmsdLog
----------------
12/11 16:50:00 ******************************************************
12/11 16:50:00 ** condor_dbmsd.exe (CONDOR_DBMSD) STARTING UP
12/11 16:50:00 ** C:\Condor\bin\condor_dbmsd.exe
12/11 16:50:00 ** SubsystemInfo: name=DBMSD type=DAEMON(10) class=DAEMON(1)
12/11 16:50:00 ** Configuration: subsystem:DBMSD local:<NONE> class:DAEMON
12/11 16:50:00 ** $CondorVersion: 7.2.4 Jun 15 2009 BuildID: 159529 $
12/11 16:50:00 ** $CondorPlatform: INTEL-WINNT50 $
12/11 16:50:00 ** PID = 2364
12/11 16:50:00 ** Log last touched time unavailable (No such file or directory)
12/11 16:50:00 ******************************************************
12/11 16:50:00 Using config source: C:\condor\condor_config
12/11 16:50:00 Using local config sources:
12/11 16:50:00 C:\condor/condor_config.local
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\1-start\condor_config.master.PC284419
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.1.WINNT
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.INTEL.WINNT
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.common
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.2
12/11 16:50:00 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\PC284419\condor_config.thishost
12/11 16:50:00 DaemonCore: Command Socket at <10.3.28.8:52000>
12/11 16:50:00 Will use UDP to update collector PC284419.corp.ad.emb <10.3.28.8:9618>
12/11 16:50:00 FileLock object is updating timestamp on: C:\condor/log/sql.log
12/11 16:50:00 main_init() called
12/11 16:50:00 Will use UDP to update collector PC284419.corp.ad.emb <10.3.28.8:9618>
12/11 16:50:00 ERROR "Unable to find password from file C:\condor/spool/.pgpass
with prefix pc284419.corp.ad.emb:5432:quillcm:quillwriter:
" at line 93 in file ..\src\condor_c++_util\dbms_utils.cpp
12/11 16:51:10 ******************************************************
12/11 16:51:10 ** condor_dbmsd.exe (CONDOR_DBMSD) STARTING UP
12/11 16:51:10 ** C:\Condor\bin\condor_dbmsd.exe
12/11 16:51:10 ** SubsystemInfo: name=DBMSD type=DAEMON(10) class=DAEMON(1)
12/11 16:51:10 ** Configuration: subsystem:DBMSD local:<NONE> class:DAEMON
12/11 16:51:10 ** $CondorVersion: 7.2.4 Jun 15 2009 BuildID: 159529 $
12/11 16:51:10 ** $CondorPlatform: INTEL-WINNT50 $
12/11 16:51:10 ** PID = 3296
12/11 16:51:10 ** Log last touched 12/11 15:50:00
12/11 16:51:10 ******************************************************
12/11 16:51:10 Using config source: C:\condor\condor_config
12/11 16:51:10 Using local config sources:
12/11 16:51:10 C:\condor/condor_config.local
12/11 16:51:10 \\SMBSJK05\grid_env\CONDOR\1-start\condor_config.master.PC284419
12/11 16:51:10 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.1.WINNT
12/11 16:51:10 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.INTEL.WINNT
12/11 16:51:10 \\SMBSJK05\grid_env\CONDOR\2-main\condor_config.common
12/11 16:51:10 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\condor_config.pool.2
12/11 16:51:10 \\SMBSJK05\grid_env\CONDOR\3-pool\TESTE\PC284419\condor_config.thishost
12/11 16:51:10 DaemonCore: Command Socket at <10.3.28.8:11071>
12/11 16:51:10 Will use UDP to update collector PC284419.corp.ad.emb <10.3.28.8:9618>
12/11 16:51:10 FileLock object is updating timestamp on: C:\condor/log/sql.log
12/11 16:51:10 main_init() called
12/11 16:51:10 Will use UDP to update collector PC284419.corp.ad.emb <10.3.28.8:9618>
12/11 16:51:10 ERROR "Unable to find password from file C:\condor/spool/.pgpass
with prefix pc284419.corp.ad.emb:5432:quillcm:quillwriter:
" at line 93 in file ..\src\condor_c++_util\dbms_utils.cpp
Could someone help me fix this?
Thanks,
Klaus This message is intended solely for the
use of its addressee and may contain privileged or confidential information.
All information contained herein shall be treated as confidential and shall
not be disclosed to any third party without Embraer’s prior written approval.
If you are not the addressee you should not distribute, copy or file this
message. In this case, please notify the sender and destroy its contents
immediately.
Esta mensagem é para uso exclusivo de seu destinatário e pode conter informações
privilegiadas e confidenciais. Todas as informações aqui contidas devem
ser tratadas como confidenciais e não devem ser divulgadas a terceiros
sem o prévio consentimento por escrito da Embraer. Se você não é o destinatário
não deve distribuir, copiar ou arquivar a mensagem. Neste caso, por favor,
notifique o remetente da mesma e destrua imediatamente a mensagem.[attachment
"condor_config_val_dump.txt" deleted by Klaus Schwarzmeier/ENGENHARIA/SJK/EMBRAER]
_______________________________________________
Condor-users mailing list
To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with
a
subject: Unsubscribe
You can also unsubscribe by visiting
https://lists.cs.wisc.edu/mailman/listinfo/condor-users
The archives can be found at:
https://lists.cs.wisc.edu/archive/condor-users/
This message is intended solely for the
use of its addressee and may contain privileged or confidential information.
All information contained herein shall be treated as confidential and shall
not be disclosed to any third party without Embraer’s prior written approval.
If you are not the addressee you should not distribute, copy or file this
message. In this case, please notify the sender and destroy its contents
immediately.
Esta mensagem é para uso exclusivo de seu destinatário e pode conter informações
privilegiadas e confidenciais. Todas as informações aqui contidas devem
ser tratadas como confidenciais e não devem ser divulgadas a terceiros
sem o prévio consentimento por escrito da Embraer. Se você não é o destinatário
não deve distribuir, copiar ou arquivar a mensagem. Neste caso, por favor,
notifique o remetente da mesma e destrua imediatamente a mensagem.
![[Computer Systems Lab]](https://www-auth.cs.wisc.edu/pics/csl_logo.gif){kind=logo}