FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Ubuntu > Ubuntu User

 
 
LinkBack Thread Tools
 
Old 05-15-2012, 11:25 AM
"J. Bakshi"
 
Default revolver postgresql issue

Hello,

I am using revolver solo version 8.4.6
The system is working fine. I need to communicate the postgresql
remotely, but the port 9977 which postgresql uses for revolver is bind
to the localhost only.

At postgresql.conf there is already

listen_addresses = '*'

and at pg_hba.conf I have added the following

host all all 0.0.0.0/0 trust
host all all 192.168.0.1/24 password
host all revolverserver 192.168.1.154 trust

The winxp box has firewall disabled. Still the port 9977 is not visible from any
other PC of the same LAN. How can I open the port then for all ?

Thanks

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 05-15-2012, 11:26 AM
"J. Bakshi"
 
Default revolver postgresql issue

Hello,

I am using revolver solo version 8.4.6
The system is working fine. I need to communicate the postgresql
remotely, but the port 9977 which postgresql uses for revolver is bind
to the localhost only.

At postgresql.conf there is already

listen_addresses = '*'

and at pg_hba.conf I have added the following

host all all 0.0.0.0/0 trust
host all all 192.168.0.1/24 password
host all revolverserver 192.168.1.154 trust

The winxp box has firewall disabled. Still the port 9977 is not visible from any
other PC of the same LAN. How can I open the port then for all ?

Thanks


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: 20120515165657.27c7793f@shiva.selfip.org">http://lists.debian.org/20120515165657.27c7793f@shiva.selfip.org
 
Old 05-15-2012, 12:02 PM
Johann Spies
 
Default revolver postgresql issue

On Tue, May 15, 2012 at 01:26:57PM +0200, J. Bakshi wrote:
>
> I am using revolver solo version 8.4.6
> The system is working fine. I need to communicate the postgresql
> remotely, but the port 9977 which postgresql uses for revolver is bind
> to the localhost only.
>
> At postgresql.conf there is already
>
> listen_addresses = '*'

This means: listen an all interfaces - not on localhost only.

> and at pg_hba.conf I have added the following
>
> host all all 0.0.0.0/0 trust
> host all all 192.168.0.1/24 password
> host all revolverserver 192.168.1.154 trust
>
> The winxp box has firewall disabled. Still the port 9977 is not visible from any
> other PC of the same LAN. How can I open the port then for all ?

Where is the configuration to make Postgresql listen on port 9977? That
is not a normal postgresql setup. Normally it will listen on port 5432.

Regards
Johann
--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

"Let not your heart be troubled: ye believe in God,
believe also in me." John 14:1
E-pos vrywaringsklousule

Hierdie e-pos mag vertroulike inligting bevat en mag regtens geprivilegeerd wees en is slegs bedoel vir die persoon aan wie dit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie dokument geensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis en vee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit uit hierdie e-pos en/of die oopmaak van enige lês aangeheg by hierdie e-pos nie.

E-mail disclaimer

This e-mail may contain confidential information and may be legally privileged and is intended only for the person to whom it is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail. The University does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any files attached to this e-mail.


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: 20120515120250.GC32502@sun.ac.za">http://lists.debian.org/20120515120250.GC32502@sun.ac.za
 
Old 05-15-2012, 12:10 PM
"J. Bakshi"
 
Default revolver postgresql issue

On Tue, 15 May 2012 14:02:50 +0200
Johann Spies <jspies@sun.ac.za> wrote:

> On Tue, May 15, 2012 at 01:26:57PM +0200, J. Bakshi wrote:
> >
> > I am using revolver solo version 8.4.6
> > The system is working fine. I need to communicate the postgresql
> > remotely, but the port 9977 which postgresql uses for revolver is bind
> > to the localhost only.
> >
> > At postgresql.conf there is already
> >
> > listen_addresses = '*'
>
> This means: listen an all interfaces - not on localhost only.
>
> > and at pg_hba.conf I have added the following
> >
> > host all all 0.0.0.0/0 trust
> > host all all 192.168.0.1/24 password
> > host all revolverserver 192.168.1.154 trust
> >
> > The winxp box has firewall disabled. Still the port 9977 is not visible from any
> > other PC of the same LAN. How can I open the port then for all ?
>
> Where is the configuration to make Postgresql listen on port 9977? That
> is not a normal postgresql setup. Normally it will listen on port 5432.
>

Yes, revolver software use port 9977 for postgresql. This can be changed easily,
but the problem is it is binded to localhost only even after

listen_addresses = '*'


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: 20120515174012.496bb1df@shiva.selfip.org">http://lists.debian.org/20120515174012.496bb1df@shiva.selfip.org
 
Old 05-15-2012, 01:15 PM
Johann Spies
 
Default revolver postgresql issue

On Tue, May 15, 2012 at 02:10:12PM +0200, J. Bakshi wrote:

> Yes, revolver software use port 9977 for postgresql. This can be changed easily,
> but the problem is it is binded to localhost only even after
>
> listen_addresses = '*'

Then you must configure postresql to listen at 9977. Note that there is
a difference between 'listen_addresses' and 'ports'. The first
involves the network configuration of you computer.

Hint: Search in postgresql.conf for a line that begins with

ports =

In your case you could configure that section to :

# - Connection Settings -

listen_addresses = 'localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
port = 9977 # (change requires restart)


Regards
Johann


--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

"Let not your heart be troubled: ye believe in God,
believe also in me." John 14:1
E-pos vrywaringsklousule

Hierdie e-pos mag vertroulike inligting bevat en mag regtens geprivilegeerd wees en is slegs bedoel vir die persoon aan wie dit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie dokument geensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis en vee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit uit hierdie e-pos en/of die oopmaak van enige lês aangeheg by hierdie e-pos nie.

E-mail disclaimer

This e-mail may contain confidential information and may be legally privileged and is intended only for the person to whom it is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail. The University does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any files attached to this e-mail.


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: 20120515131522.GF32502@sun.ac.za">http://lists.debian.org/20120515131522.GF32502@sun.ac.za
 

Thread Tools




All times are GMT. The time now is 10:24 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org