pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan not connect to database in Workgroup-Net on Windows-XP
8+ messages / 3 participants
[nested] [flat]
* Can not connect to database in Workgroup-Net on Windows-XP
@ 2007-01-11 10:11 Josef Springer <Josef.Springer@joops.com>
0 siblings, 1 reply; 8+ messages in thread
From: Josef Springer @ 2007-01-11 10:11 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Hi folks,
i have a workgroup (not a classic server) with Windows-XP-machines:
the database server machine contains the line
host all all 0.0.0.0 0.0.0.0 md5
in the file pg_hba.conf
and
listen_addresses = '*'
in the file postgresql.conf.
the 'client's host file contain the line
nnn.nnn.nnn.nnn Labor where nnn.nnn.nnn.nnnn is the IP-adress of the
database server machine and Labor is the machine's name.
If i start PGAdmin III on the 'client' machine i can not connect to the
database on the Labor no matter wether i use the machine's name or the
IP-adress.
What to do ?
mit freundlichen Gru"?en / best regards,
Josef Springer
(Gescha"ftsleitung/Management)
[Postal]
Address
Josef.Springer@joops.com
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
[Phone]
Office
+49 (0)89 600 6920
[Phone]
Fax
+49 (0)89 600 69220
[Web]
Web
http://www.joops.com
[JOOPS]
-- the software company --
Attachments:
Drafts (image/jpeg, 770B) download
view image
Drafts (image/jpeg, 802B) download
view image
Drafts (image/jpeg, 802B) download
view image
Drafts (image/jpeg, 807B) download
view image
Drafts (image/jpeg, 7.6K) download
view image
* Re: Can not connect to database in Workgroup-Net on Windows-XP
@ 2007-01-11 10:54 Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
parent: Josef Springer <Josef.Springer@joops.com>
0 siblings, 3 replies; 8+ messages in thread
From: Andy Shellam (Mailing Lists) @ 2007-01-11 10:54 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; +Cc: pgsql-admin
Firstly it would be helpful to say what error you're getting on the
client side.
At a quick guess, I would say it's because you've got 2 "0.0.0.0"
declarations in your pg_hba.conf - you only need the one - like this:
host all all 0.0.0.0/0 md5
Regards,
Andy.
Josef Springer wrote:
> Hi folks,
>
> i have a workgroup (not a classic server) with Windows-XP-machines:
>
> the database server machine contains the line
> host all all 0.0.0.0
> 0.0.0.0 md5
> in the file pg_hba.conf
> and
> listen_addresses = '*'
> in the file postgresql.conf.
>
> the 'client's host file contain the line
> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress of
> the database server machine and /Labor /is the machine's name.
>
> If i start PGAdmin III on the 'client' machine i can not connect to
> the database on the /Labor/ no matter wether i use the machine's name
> or the IP-adress.
>
> What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> Postal
> Address
> _Josef.Springer@joops.com _
> Orlando-di-Lasso Str. 2
> D-85640 Putzbrunn
> Phone
> Office
> +49 (0)89 600 6920
>
>
> Phone
> Fax
> +49 (0)89 600 69220
>
>
> Web
> Web
> http://www.joops.com
>
>
>
>
> JOOPS
> *-- the software company --*
>
>
>
>
>
> !DSPAM:37,45a60e36137102078430163!
--
Andy Shellam
NetServe Support Team
the Mail Network
"an alternative in a standardised world"
p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Can not connect to database in Workgroup-Net on Windows-XP
@ 2007-01-11 12:48 Josef Springer <Josef.Springer@joops.com>
parent: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2 siblings, 0 replies; 8+ messages in thread
From: Josef Springer @ 2007-01-11 12:48 UTC (permalink / raw)
To: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>; +Cc: pgsql-admin
Hi Andi,
i get an error message "Can not connect to database..." or similar. I
will ask the customer.
The system at another customer runs with host all all
0.0.0.0/0 md5
Josef
Andy Shellam (Mailing Lists) wrote:
> Firstly it would be helpful to say what error you're getting on the
> client side.
> At a quick guess, I would say it's because you've got 2 "0.0.0.0"
> declarations in your pg_hba.conf - you only need the one - like this:
>
> host all all 0.0.0.0/0 md5
>
> Regards,
>
> Andy.
>
> Josef Springer wrote:
>
>> Hi folks,
>>
>> i have a workgroup (not a classic server) with Windows-XP-machines:
>>
>> the database server machine contains the line
>> host all all 0.0.0.0
>> 0.0.0.0 md5
>> in the file pg_hba.conf
>> and
>> listen_addresses = '*' in the file postgresql.conf.
>>
>> the 'client's host file contain the line
>> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress
>> of the database server machine and /Labor /is the machine's name.
>>
>> If i start PGAdmin III on the 'client' machine i can not connect to
>> the database on the /Labor/ no matter wether i use the machine's name
>> or the IP-adress.
>>
>> What to do ?
>>
>> mit freundlichen Grüßen / best regards,
>> Josef Springer
>> (Geschäftsleitung/Management)
>>
>> Postal
>> Address
>> _Josef.Springer@joops.com _
>> Orlando-di-Lasso Str. 2
>> D-85640 Putzbrunn
>> Phone
>> Office
>> +49 (0)89 600 6920
>>
>>
>> Phone
>> Fax
>> +49 (0)89 600 69220
>>
>>
>> Web
>> Web
>> http://www.joops.com
>>
>>
>>
>>
>> JOOPS
>> *-- the software company --*
>>
>>
>>
>>
>>
>> !DSPAM:37,45a60e36137102078430163!
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Can not connect to database in Workgroup-Net on Windows-XP
@ 2007-01-11 14:48 Josef Springer <Josef.Springer@joops.com>
parent: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2 siblings, 0 replies; 8+ messages in thread
From: Josef Springer @ 2007-01-11 14:48 UTC (permalink / raw)
To: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>; +Cc: pgsql-admin
Hi Andy,
here ist the error mesage trying to connect:
"Zum Server ist keine Verbindung möglich,
oder Login/Passwort sind falsch.
Die Anmeldung wurde abgelehnt."
Josef
Andy Shellam (Mailing Lists) wrote:
> Firstly it would be helpful to say what error you're getting on the
> client side.
> At a quick guess, I would say it's because you've got 2 "0.0.0.0"
> declarations in your pg_hba.conf - you only need the one - like this:
>
> host all all 0.0.0.0/0 md5
>
> Regards,
>
> Andy.
>
> Josef Springer wrote:
>
>> Hi folks,
>>
>> i have a workgroup (not a classic server) with Windows-XP-machines:
>>
>> the database server machine contains the line
>> host all all 0.0.0.0
>> 0.0.0.0 md5
>> in the file pg_hba.conf
>> and
>> listen_addresses = '*' in the file postgresql.conf.
>>
>> the 'client's host file contain the line
>> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress
>> of the database server machine and /Labor /is the machine's name.
>>
>> If i start PGAdmin III on the 'client' machine i can not connect to
>> the database on the /Labor/ no matter wether i use the machine's name
>> or the IP-adress.
>>
>> What to do ?
>>
>> mit freundlichen Grüßen / best regards,
>> Josef Springer
>> (Geschäftsleitung/Management)
>>
>> Postal
>> Address
>> _Josef.Springer@joops.com _
>> Orlando-di-Lasso Str. 2
>> D-85640 Putzbrunn
>> Phone
>> Office
>> +49 (0)89 600 6920
>>
>>
>> Phone
>> Fax
>> +49 (0)89 600 69220
>>
>>
>> Web
>> Web
>> http://www.joops.com
>>
>>
>>
>>
>> JOOPS
>> *-- the software company --*
>>
>>
>>
>>
>>
>> !DSPAM:37,45a60e36137102078430163!
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Can not connect to database in Workgroup-Net on Windows-XP
@ 2007-01-15 07:37 Josef Springer <Josef.Springer@joops.com>
parent: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2 siblings, 1 reply; 8+ messages in thread
From: Josef Springer @ 2007-01-15 07:37 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Hi folks,
i have a workgroup (not a classic server) with Windows-XP-machines:
the database server machine contains the line
host all all 0.0.0.0 0.0.0.0 md5
in the file pg_hba.conf
and
listen_addresses = '*'
in the file postgresql.conf.
The clients' host file contain the line
nnn.nnn.nnn.nnn Labor where nnn.nnn.nnn.nnnn is the IP-adress of
the database server machine and /Labor /is the machine's name.
If i start PGAdmin III on the 'client' machine i can not connect to
the database on the machine Labor no matter wether i use the machine's name
or the IP-adress. Instead i get the message
"Zum Server ist keine Verbindung möglich,
oder Login/Passwort sind falsch.
Die Anmeldung wurde abgelehnt."
Please help me. What to do ?
mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)
[Postal]
Address
Josef.Springer@joops.com
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
[Phone]
Office
+49 (0)89 600 6920
[Phone]
Fax
+49 (0)89 600 69220
[Web]
Web
http://www.joops.com
[JOOPS]
-- the software company --
Attachments:
Postal.jpg (image/jpeg, 770B) download
view image
Phone.jpg (image/jpeg, 802B) download
view image
Phone.jpg (image/jpeg, 802B) download
view image
Web.jpg (image/jpeg, 807B) download
view image
Image120.jpg (image/jpeg, 7.6K) download
view image
* Re: Can not connect to database in Workgroup-Net on Windows-XP
@ 2007-01-15 09:46 Shoaib Mir <shoaibmir@gmail.com>
parent: Josef Springer <Josef.Springer@joops.com>
0 siblings, 1 reply; 8+ messages in thread
From: Shoaib Mir @ 2007-01-15 09:46 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; +Cc: pgsql-admin
I can understand the exact error as its not in english :) but it seems like
an authentication problem. Please change 'md5' to 'trust' in pg_hba.conf
file and then use:
pg_ctl -D <path to data folder> reload
That will reload the settings for authentication.
Now once the settings are reloaded try reconnecting to the database and it
should go fine this time....
----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Josef Springer <Josef.Springer@joops.com> wrote:
>
> Hi folks,
>
> i have a workgroup (not a classic server) with Windows-XP-machines:
>
> the database server machine contains the line
> *host all all 0.0.0.0 0.0.0.0 md5*
> in the file pg_hba.conf
> and
> *listen_addresses = '*' *
> in the file postgresql.conf.
>
> The clients' host file contain the line
> *nnn.nnn.nnn.nnn Labor* where nnn.nnn.nnn.nnnn is the IP-adress of
> the database server machine and /Labor /is the machine's name.
>
> If i start PGAdmin III on the 'client' machine i can not connect to
> the database on the machine Labor no matter wether i use the machine's
> name
> or the IP-adress. Instead i get the message
>
> * "Zum Server ist keine Verbindung möglich, *
>
> * oder Login/Passwort sind falsch.*
>
> * Die Anmeldung wurde abgelehnt."*
>
>
> Please help me. What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> [image: Postal]
> Address
> *Josef.Springer@joops.com*
> Orlando-di-Lasso Str. 2
> D-85640 Putzbrunn
> [image: Phone]
> Office
> +49 (0)89 600 6920
>
>
> [image: Phone]
> Fax
> +49 (0)89 600 69220
>
>
> [image: Web]
> Web
> http://www.joops.com
>
>
>
> [image: JOOPS]
> *-- the software company --*
>
>
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Can not connect to database in Workgroup-Net on Windows-XP
@ 2007-01-15 10:03 Josef Springer <Josef.Springer@joops.com>
parent: Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Josef Springer @ 2007-01-15 10:03 UTC (permalink / raw)
To: Shoaib Mir <shoaibmir@gmail.com>; +Cc: pgsql-admin
Hi Mir,
thanks for your quick answer. We will try this.
For my unterstanding: Why should i use trust instead of md5 ? A
configuration at another customer (with a domain setting) using md5
works fine ?
mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)
[Postal]
Address
Josef.Springer@joops.com
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
[Phone]
Office
+49 (0)89 600 6920
[Phone]
Fax
+49 (0)89 600 69220
[Web]
Web
http://www.joops.com
[JOOPS]
-- the software company --
Shoaib Mir wrote:
> I can understand the exact error as its not in english :) but it seems
> like an authentication problem. Please change 'md5' to 'trust' in
> pg_hba.conf file and then use:
>
> pg_ctl -D <path to data folder> reload
>
> That will reload the settings for authentication.
>
> Now once the settings are reloaded try reconnecting to the database
> and it should go fine this time....
>
> ----------------
> Shoaib Mir
> EnterpriseDB ( www.enterprisedb.com <http://www.enterprisedb.com; )
>
> On 1/15/07, Josef Springer <Josef.Springer@joops.com
> <mailto:Josef.Springer@joops.com> > wrote:
>
> Hi folks,
>
> i have a workgroup (not a classic server) with Windows-XP-machines:
>
> the database server machine contains the line
> host all all 0.0.0.0 <http://0.0.0.0; 0.0.0.0
> <http://0.0.0.0; md5
> in the file pg_hba.conf
> and
> listen_addresses = '*'
> in the file postgresql.conf.
>
> The clients' host file contain the line
> nnn.nnn.nnn.nnn Labor where nnn.nnn.nnn.nnnn is the IP-adress of
> the database server machine and /Labor /is the machine's name.
>
> If i start PGAdmin III on the 'client' machine i can not connect to
> the database on the machine Labor no matter wether i use the
> machine's name
> or the IP-adress. Instead i get the message
>
> "Zum Server ist keine Verbindung möglich,
>
> oder Login/Passwort sind falsch.
>
> Die Anmeldung wurde abgelehnt."
>
>
>
> Please help me. What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> [Postal]
> Address
> Josef.Springer@joops.com <mailto:Josef.Springer@joops.com>
> Orlando-di-Lasso Str. 2
> D-85640 Putzbrunn
> [Phone]
>
> Office
> +49 (0)89 600 6920
>
>
> [Phone]
>
> Fax
> +49 (0)89 600 69220
>
>
> [Web]
>
> Web
> http://www.joops.com
>
>
>
> [JOOPS]
> -- the software company --
>
>
>
>
>
>
>
Attachments:
Postal.jpg (image/jpeg, 770B) download
view image
Phone.jpg (image/jpeg, 802B) download
view image
Phone.jpg (image/jpeg, 802B) download
view image
Web.jpg (image/jpeg, 807B) download
view image
Image120.jpg (image/jpeg, 7.6K) download
view image
* Re: Can not connect to database in Workgroup-Net on Windows-XP
@ 2007-01-15 10:15 Shoaib Mir <shoaibmir@gmail.com>
parent: Josef Springer <Josef.Springer@joops.com>
0 siblings, 0 replies; 8+ messages in thread
From: Shoaib Mir @ 2007-01-15 10:15 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; +Cc: pgsql-admin
The error you are getting is because of the password not been passed
correctly so 'trust' will let you get in the server without specifying the
correct password, once you are in now you can change the password as you
like using ALTER USER command. Once its done change it back to md5 as it was
before.
--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Josef Springer <Josef.Springer@joops.com> wrote:
>
> Hi Mir,
>
> thanks for your quick answer. We will try this.
> For my unterstanding: Why should i use *trust *instead of *md5 * ? A
> configuration at another customer (with a *domain *setting) using *md5 *works
> fine ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> [image: Postal]
> Address
> *Josef.Springer@joops.com*
> Orlando-di-Lasso Str. 2
> D-85640 Putzbrunn
> [image: Phone]
> Office
> +49 (0)89 600 6920
>
>
> [image: Phone]
> Fax
> +49 (0)89 600 69220
>
>
> [image: Web]
> Web
> http://www.joops.com
>
>
>
> [image: JOOPS]
> *-- the software company --*
>
>
>
>
> Shoaib Mir wrote:
>
> I can understand the exact error as its not in english :) but it seems
> like an authentication problem. Please change 'md5' to 'trust' in
> pg_hba.conf file and then use:
>
> pg_ctl -D <path to data folder> reload
>
> That will reload the settings for authentication.
>
> Now once the settings are reloaded try reconnecting to the database and it
> should go fine this time....
>
> ----------------
> Shoaib Mir
> EnterpriseDB ( www.enterprisedb.com )
>
> On 1/15/07, Josef Springer <Josef.Springer@joops.com > wrote:
> >
> > Hi folks,
> >
> > i have a workgroup (not a classic server) with Windows-XP-machines:
> >
> > the database server machine contains the line
> > *host all all 0.0.0.0 0.0.0.0 md5*
> > in the file pg_hba.conf
> > and
> > *listen_addresses = '*' *
> > in the file postgresql.conf.
> >
> > The clients' host file contain the line
> > *nnn.nnn.nnn.nnn Labor* where nnn.nnn.nnn.nnnn is the IP-adress of
> > the database server machine and /Labor /is the machine's name.
> >
> > If i start PGAdmin III on the 'client' machine i can not connect to
> > the database on the machine Labor no matter wether i use the machine's
> > name
> > or the IP-adress. Instead i get the message
> >
> > * "Zum Server ist keine Verbindung möglich, *
> >
> > * oder Login/Passwort sind falsch.*
> >
> > * Die Anmeldung wurde abgelehnt."*
> >
> >
> > Please help me. What to do ?
> >
> > mit freundlichen Grüßen / best regards,
> > Josef Springer
> > (Geschäftsleitung/Management)
> >
> > [image: Postal]
> > Address
> > * Josef.Springer@joops.com *
> > Orlando-di-Lasso Str. 2
> > D-85640 Putzbrunn
> > [image: Phone]
> > Office
> > +49 (0)89 600 6920
> >
> >
> > [image: Phone]
> > Fax
> > +49 (0)89 600 69220
> >
> >
> > [image: Web]
> > Web
> > http://www.joops.com
> >
> >
> >
> > [image: JOOPS]
> > *-- the software company --*
> >
> >
> >
> >
> >
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2007-01-15 10:15 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-11 10:11 Can not connect to database in Workgroup-Net on Windows-XP Josef Springer <Josef.Springer@joops.com>
2007-01-11 10:54 ` Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-01-11 12:48 ` Josef Springer <Josef.Springer@joops.com>
2007-01-11 14:48 ` Josef Springer <Josef.Springer@joops.com>
2007-01-15 07:37 ` Josef Springer <Josef.Springer@joops.com>
2007-01-15 09:46 ` Shoaib Mir <shoaibmir@gmail.com>
2007-01-15 10:03 ` Josef Springer <Josef.Springer@joops.com>
2007-01-15 10:15 ` Shoaib Mir <shoaibmir@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox