[pgpool-general: 574] Re: Encounter Configuration Problem

Thu May 31 21:43:01 JST 2012

Do you cannot see any node information in pgpoolAdmin? 

What say pgpool.log file? 

Do you can connect to postgresql servers trough pgpool? 

Regards. 

----- Mensaje original -----

> Hi,
> I had successfully ssh with ossac16 and ossac17 but i can't see the
> any node in node info

> On 5/31/12, Freddy Liaw <freddyliaw at softmy.net> wrote:
> > I had installed apache using this command apt-get install apache2
> > but the "apache" user didnt created
> >
> > On 5/30/12, Lazaro Ruben Garcia Martinez <lgarciam at uci.cu> wrote:
> >> Steps for enabling the access of apache user to postgres server:
> >> (Proved
> >> in
> >> CentOS)
> >>
> >> Usually, the apache user is no login user. You need edit the file
> >> /etc/passwd and change this line as root user:
> >>
> >> apache:x:48:48:Apache:/var/www:/sbin/nologin
> >>
> >> by
> >>
> >> apache:x:48:48:Apache:/var/www:/bin/bash
> >>
> >> Then, as root user, you need to execute these command:
> >>
> >> mkdir /var/www/.ssh
> >> chown apache /var/www/.ssh
> >> su - apache
> >> ssh-keygen
> >>
> >> Finally, copy the generated file id_rsa.pub, to postgres user home
> >> directory
> >> in the postgresql servers.
> >>
> >> ssh-copy-id -i ~/.ssh/id_rsa.pub postgres at server_address
> >>
> >> Then, try to copy any file as apache user from apache server to
> >> postgresql
> >> server.
> >>
> >> Regards.
> >>
> >> ----- Mensaje original -----
> >>
> >>> How to add /var/www/.ssh/id_rsa.pub to
> >>> /home/postggres/.ssh/authorized_keys on osspc17 and osspc18?
> >>
> >>> On 5/30/12, Lazaro Ruben Garcia Martinez <lgarciam at uci.cu> wrote:
> >>> > The user "apache" is created when you install the apache server
> >>> > (in
> >>> > CentOS
> >>> > httpd). This step is used if you going to use the pgpoolAdmin
> >>> > tool,
> >>> > because
> >>> > this tool is developed in PHP running under apache server, for
> >>> > this
> >>> > reason
> >>> > the user "apache" needs permission over the pgpool's
> >>> > configuration
> >>> > files.
> >>> >
> >>> > Regards.
> >>> >
> >>> > ----- Mensaje original -----
> >>> >
> >>> >> From here:
> >>> >> #cp /some/where/pgpool.conf /usr/local/etc
> >>> >> # chown apache /usr/local/etc/pgpool.conf
> >>> >> # cp /some/where/pcp.conf /usr/local/etc
> >>> >> # chown apache /usr/local/etc/pcp.conf
> >>> >
> >>> >> Do i need to create an apache user?
> >>> >> Sorry, i'm very new in this particular field.
> >>> >
> >>> >> On 5/29/12, Guillaume Lelarge <guillaume at lelarge.info> wrote:
> >>> >> > On Tue, 2012-05-29 at 16:17 +0800, Freddy Liaw wrote:
> >>> >> >> Hi,
> >>> >> >>
> >>> >> >> I am following this guide to do my configuration
> >>> >> >> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/index.html
> >>> >> >>
> >>> >> >> I get problem start from the Installing pgpool-II section
> >>> >> >
> >>> >> > If you want us to help you, you need to tell much more. Read
> >>> >> > this:
> >>> >> > http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
> >>> >> >
> >>> >> > That may help you to report problems in a better way.
> >>> >> >
> >>> >> > Regards.
> >>> >> >
> >>> >> >
> >>> >> > --
> >>> >> > Guillaume
> >>> >> > http://blog.guillaume.lelarge.info
> >>> >> > http://www.dalibo.com
> >>> >> >
> >>> >> >
> >>> >
> >>> >> --
> >>> >> Best Regards,
> >>> >> Freddy
> >>> >> _______________________________________________
> >>> >> pgpool-general mailing list
> >>> >> pgpool-general at pgpool.net
> >>> >> http://www.pgpool.net/mailman/listinfo/pgpool-general
> >>> >
> >>> >> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS
> >>> >> CIENCIAS
> >>> >> INFORMATICAS...
> >>> >> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
> >>> >
> >>> >> http://www.uci.cu
> >>> >> http://www.facebook.com/universidad.uci
> >>> >> http://www.flickr.com/photos/universidad_uci
> >>> >
> >>> >
> >>> > 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS
> >>> > CIENCIAS
> >>> > INFORMATICAS...
> >>> > CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
> >>> >
> >>> > http://www.uci.cu
> >>> > http://www.facebook.com/universidad.uci
> >>> > http://www.flickr.com/photos/universidad_uci
> >>
> >>> --
> >>> Best Regards,
> >>> Freddy
> >>
> >>> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS
> >>> CIENCIAS
> >>> INFORMATICAS...
> >>> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
> >>
> >>> http://www.uci.cu
> >>> http://www.facebook.com/universidad.uci
> >>> http://www.flickr.com/photos/universidad_uci
> >>
> >>
> >> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS
> >> INFORMATICAS...
> >> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
> >>
> >> http://www.uci.cu
> >> http://www.facebook.com/universidad.uci
> >> http://www.flickr.com/photos/universidad_uci
> >
> >
> > --
> > Best Regards,
> > Freddy
> >

> --
> Best Regards,
> Freddy

> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS
> INFORMATICAS...
> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION

> http://www.uci.cu
> http://www.facebook.com/universidad.uci
> http://www.flickr.com/photos/universidad_uci

10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION

http://www.uci.cu
http://www.facebook.com/universidad.uci
http://www.flickr.com/photos/universidad_uci
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120531/011ecd77/attachment-0001.html>