Thread: weird problem with pgadmin & postgres on debian

<tt>hello there, <br /><br /> (it's the first time i use a mailing list...wow!)<br /> So, here's my problem: <br /><br
/>I've installed postgresql on debian as well as pgadmin(everything updated to last version).<br /> Now, when i try to
accessmy server on localhost with pgadmin, i cannot enter because it asks me the password. But i have no password, as
it'sjust a first-time learning-purpose install! If i simply leave the password field empty, it rejects my login(</tt>
<pre><font><fontface="Arial, Helvetica, sans-serif">"Error connecting to the server: fe_sendauth: no password
supplied"</font></font></pre><tt>). But, if i try to access the server with 'psql testdatabase' from a terminal, i am
ableto enter, and work normally.<br /><br /> I've also installed postgresql & pgadmin on windows xp (database
differentfrom the linux one) and pgadmin acts normally, letting me login and managing databases without any problem.<br
/><br/> What's wrong?<br /><br /> thx<br /><br /></tt> 

<tt>ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it,
don'tnow why but it works, maybe it's a problem of user rights, but i'm too noob to know :P</tt><br /><br /><br /><br
/><br/><br /> ----------------------------------------------------------------<br /><blockquote><tt>hello there,
</tt><br/><tt></tt><br /><tt>(it's the first time i use a mailing list...wow!)</tt><br /><tt>So, here's my problem:
</tt><br/><tt></tt><br /><tt>I've installed postgresql on debian as well as pgadmin(everything updated to last
version).</tt><br/><tt>Now, when i try to access my server on localhost with pgadmin, i cannot enter because it asks me
thepassword. But i have no password, as it's just a first-time learning-purpose install! If i simply leave the password
fieldempty, it rejects my login(</tt> <pre><font><font face="Arial, Helvetica, sans-serif">"Error connecting to the
server:fe_sendauth: no password supplied"</font></font></pre> <tt>). But, if i try to access the server with 'psql
testdatabase'from a terminal, i am able to enter, and work normally.</tt><br /><tt></tt><br /><tt>I've also installed
postgresql& pgadmin on windows xp (database different from the linux one) and pgadmin acts normally, letting me
loginand managing databases without any problem.</tt><br /><tt></tt><br /><tt>What's wrong?</tt><br /><tt></tt><br
/><tt>thx</tt><br/></blockquote><tt><br /></tt> 

Are you sure you're starting the same installation/cluster? Manually/init shouldn't make any difference if so.

Regards, Dave

-----Original Message-----
From: "Alessandro @ GMail"<neurotrotter@gmail.com>
Sent: 18/03/06 13:12:01
To: "pgadmin-support@postgresql.org"<pgadmin-support@postgresql.org>
Subject: Re: [pgadmin-support] weird problem with pgadmin & postgres on debian

ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it, don't
nowwhy but it works, maybe it's a problem of user rights, but i'm too noob to know :P 





----------------------------------------------------------------

hello there, (it's the first time i use a mailing list...wow!)So, here's my problem: I've installed postgresql on
debianas well as pgadmin(everything updated to last version).Now, when i try to access my server on localhost with
pgadmin,i cannot enter because it asks me the password. But i have no password, as it's just a first-time
learning-purposeinstall! If i simply leave the password field empty, it rejects my login( "Error connecting to the
server:fe_sendauth: no password supplied"). But, if i try to access the server with 'psql testdatabase' from a
terminal,i am able to enter, and work normally.I've also installed postgresql & pgadmin on windows xp (database
differentfrom the linux one) and pgadmin acts normally, letting me login and managing databases without any
problem.What'swrong?thx 






-----Unmodified Original Message-----
ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it, don't
nowwhy but it works, maybe it's a problem of user rights, but i'm too noob to know :P 





----------------------------------------------------------------

hello there, (it's the first time i use a mailing list...wow!)So, here's my problem: I've installed postgresql on
debianas well as pgadmin(everything updated to last version).Now, when i try to access my server on localhost with
pgadmin,i cannot enter because it asks me the password. But i have no password, as it's just a first-time
learning-purposeinstall! If i simply leave the password field empty, it rejects my login( "Error connecting to the
server:fe_sendauth: no password supplied"). But, if i try to access the server with 'psql testdatabase' from a
terminal,i am able to enter, and work normally.I've also installed postgresql & pgadmin on windows xp (database
differentfrom the linux one) and pgadmin acts normally, letting me login and managing databases without any
problem.What'swrong?thx 

mmm i think you're right and it's not the same installation as i have not defined the PGDATA environment variable yet,
soi don't know what he started at boot time...(i run the db with the -D option right now)<br /><br /> another thing i
forgotto say is that the first time i put the data folder in my user home(/home/alex/.postgres/data) instead of
/usr/local/pgsql/data/...but user postgres should be a SU so it shouldn't make any difference, or am i wrong? <br />
theni changed the folder to /usr/local/pgsql/data/ but pgadmin refused still to connect. Only after i slaughtered
/etc/init.d/postgresql-8.1i was able to connect with pgadmin...<br /><br /> thx<br /> Alessandro<br /><br /> Dave Page
wrote:<blockquote cite="mid006d01c64a92$a8eaaeb0$6a01a8c0@valehousing.co.uk" type="cite"><pre wrap="">Are you sure
you'restarting the same installation/cluster? Manually/init shouldn't make any difference if so.
 

Regards, Dave

-----Original Message-----
From: "Alessandro @ GMail"<a class="moz-txt-link-rfc2396E"
href="mailto:neurotrotter@gmail.com"><neurotrotter@gmail.com></a>
Sent: 18/03/06 13:12:01
To: <a class="moz-txt-link-rfc2396E"
href="mailto:pgadmin-support@postgresql.org">"pgadmin-support@postgresql.org"</a><aclass="moz-txt-link-rfc2396E"
href="mailto:pgadmin-support@postgresql.org"><pgadmin-support@postgresql.org></a>
Subject: Re: [pgadmin-support] weird problem with pgadmin & postgres on debian

ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it, don't
nowwhy but it works, maybe it's a problem of user rights, but i'm too noob to know :P
 





----------------------------------------------------------------

hello there, (it's the first time i use a mailing list...wow!)So, here's my problem: I've installed postgresql on
debianas well as pgadmin(everything updated to last version).Now, when i try to access my server on localhost with
pgadmin,i cannot enter because it asks me the password. But i have no password, as it's just a first-time
learning-purposeinstall! If i simply leave the password field empty, it rejects my login( "Error connecting to the
server:fe_sendauth: no password supplied"). But, if i try to access the server with 'psql testdatabase' from a
terminal,i am able to enter, and work normally.I've also installed postgresql & pgadmin on windows xp (database
differentfrom the linux one) and pgadmin acts normally, letting me login and managing databases without any
problem.What'swrong?thx
 






-----Unmodified Original Message-----
ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it, don't
nowwhy but it works, maybe it's a problem of user rights, but i'm too noob to know :P
 





----------------------------------------------------------------

hello there, (it's the first time i use a mailing list...wow!)So, here's my problem: I've installed postgresql on
debianas well as pgadmin(everything updated to last version).Now, when i try to access my server on localhost with
pgadmin,i cannot enter because it asks me the password. But i have no password, as it's just a first-time
learning-purposeinstall! If i simply leave the password field empty, it rejects my login( "Error connecting to the
server:fe_sendauth: no password supplied"). But, if i try to access the server with 'psql testdatabase' from a
terminal,i am able to enter, and work normally.I've also installed postgresql & pgadmin on windows xp (database
differentfrom the linux one) and pgadmin acts normally, letting me login and managing databases without any
problem.What'swrong?thx
 



 </pre></blockquote><br />

---

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Alessandro @ GMail
Sent: 18 March 2006 17:26
To: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] weird problem with pgadmin & postgres on debian

mmm i think you're right and it's not the same installation as i have not defined the PGDATA environment variable yet, so i don't know what he started at boot time...(i run the db with the -D option right now)

another thing i forgot to say is that the first time i put the data folder in my user home(/home/alex/.postgres/data) instead of /usr/local/pgsql/data/ ...but user postgres should be a SU so it shouldn't make any difference, or am i wrong?
then i changed the folder to /usr/local/pgsql/data/ but pgadmin refused still to connect. Only after i slaughtered /etc/init.d/postgresql-8.1 i was able to connect with pgadmin...