Thread: Bug: When installing pgpass.conf does not get created under XP

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size:
10.0pt;font-family:Arial">Hi there, I notice a bug in PGADMIN 1.6.3 when installing under on Windows XP box and the
useraccount used is not in English.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">More details:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-US"style="font-size: 
10.0pt;font-family:Arial">Windows XP 32bit / SP2 </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-US"style="font-size: 
10.0pt;font-family:Arial">User account </span></font><font face="Arial" size="2"><span lang="EL"
style="font-size:10.0pt;font-family:Arial">ΑθανάσιοςΣαμαράς </span></font><font face="Arial" size="2"><span
lang="EN-US"style="font-size:10.0pt;font-family:Arial">(Greek Name</span></font><font face="Arial" size="2"><span
lang="EL"style="font-size:10.0pt; 
font-family:Arial">, </span></font><font face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;font-family:Arial">mostprobably it will appear as????, but I assume that all the languages
apartEnglish must have the same issue)</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">Application data location: “C:\Documents and Settings\Αθανάσιος Σαμαράς\Application
Data\”</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">Result: Can not open any database in pgadmin III due to error message “can not open file
C:\Documentsand Settings\Αθανάσιος Σαμαράς\Application Data\postgresql\pgpass.conf” and the program crashes, sending
reportback.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">Reason: During installation the posgresql folder and pgpass.conf does not get
created.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">Workaround: go to application data and create the postgresql folder manually, create an empty
filecalled pgpass.conf, since it is under your account there should not be any problems with
privileges.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">Cheers</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">A.E.S.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">Sakis Samaras </span></font></div>

Athanasios E. Samaras wrote:
> Hi there, I notice a bug in PGADMIN 1.6.3 when installing under on
> Windows XP box and the user account used is not in English.
> 
> More details:
> 
> Windows XP 32bit / SP2
> 
> User account Αθανάσιος Σαμαράς (Greek Name, most probably it will appear
> as????, but I assume that all the languages apart English must have the
> same issue)
> 
> Application data location: “C:\Documents and Settings\Αθανάσιος
> Σαμαράς\Application Data\”
> 
> Result: Can not open any database in pgadmin III due to error message
> “can not open file C:\Documents and Settings\Αθανάσιος
> Σαμαράς\Application Data\postgresql\pgpass.conf” and the program
> crashes, sending report back.
> 
> Reason: During installation the posgresql folder and pgpass.conf does
> not get created.
> 
> Workaround: go to application data and create the postgresql folder
> manually, create an empty file called pgpass.conf, since it is under
> your account there should not be any problems with privileges.

It's normal for the file not to exist - pgAdmin should work fine in
those cases. Is it failing only when you try to save the password? This
should also work if the file isn't there (it'll create it), but I wonder
if it's somehow getting confused by unicode characters in your username.
That doesn't explain why it works if you create it though... unless
there's something broken in the create file code path.

Regards, Dave

It seems to me that the create fails, most probably because of the space in
the user name, probably you would like to escape the space and it should  be
just fine.

Cheers, Sakis


-----Original Message-----
From: Dave Page [mailto:dpage@postgresql.org]
Sent: Saturday, May 26, 2007 7:52 PM
To: Athanasios E. Samaras
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Bug: When installing pgpass.conf does not get
created under XP

Athanasios E. Samaras wrote:
> Hi there, I notice a bug in PGADMIN 1.6.3 when installing under on
> Windows XP box and the user account used is not in English.
>
> More details:
>
> Windows XP 32bit / SP2
>
> User account Αθανάσιος Σαμαράς (Greek Name, most probably it will appear
> as????, but I assume that all the languages apart English must have the
> same issue)
>
> Application data location: “C:\Documents and Settings\Αθανάσιος
> Σαμαράς\Application Data\”
>
> Result: Can not open any database in pgadmin III due to error message
> “can not open file C:\Documents and Settings\Αθανάσιος
> Σαμαράς\Application Data\postgresql\pgpass.conf” and the program
> crashes, sending report back.
>
> Reason: During installation the posgresql folder and pgpass.conf does
> not get created.
>
> Workaround: go to application data and create the postgresql folder
> manually, create an empty file called pgpass.conf, since it is under
> your account there should not be any problems with privileges.

It's normal for the file not to exist - pgAdmin should work fine in
those cases. Is it failing only when you try to save the password? This
should also work if the file isn't there (it'll create it), but I wonder
if it's somehow getting confused by unicode characters in your username.
That doesn't explain why it works if you create it though... unless
there's something broken in the create file code path.

Regards, Dave

Athanasios E. Samaras wrote:
> It seems to me that the create fails, most probably because of the space in
> the user name, probably you would like to escape the space and it should  be
> just fine.

That's not it - on a standard UK English XP install, the full path is
C:\Documents and Settings\<username>\Application Data\postgresql\pgpass.conf

To be sure, I also created a username containing a space and it worked
just fine.

Can you please send me your username in a UTF-8 text file (so that my
mail client doesn't mangle it) for testing?

Thanks, Dave

Athanasios E. Samaras wrote:
> Hi there,
> Sorry for the delay, but yesterday was a holiday in Greece...
> Please find attached the full path to system data.
> Hope it helps.

Thanks - it seems that the username gets mangled in the environment.
I've changed the code to avoid getting it that way and it seems to work
as expected now. Fix committed for the next release.

Regards, Dave