<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Do you cannot see any node information in pgpoolAdmin?<br><br>What say pgpool.log file?<br><br>Do you can connect to postgresql servers trough pgpool?<br><br>Regards.<br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">Hi,<br> I had successfully ssh with ossac16 and ossac17 but i can't see the<br>any node in node info<br><br>On 5/31/12, Freddy Liaw <freddyliaw@softmy.net> wrote:<br>> I had installed apache using this command apt-get install apache2<br>> but the "apache" user didnt created<br>><br>> On 5/30/12, Lazaro Ruben Garcia Martinez <lgarciam@uci.cu> wrote:<br>>> Steps for enabling the access of apache user to postgres server: (Proved<br>>> in<br>>> CentOS)<br>>><br>>> Usually, the apache user is no login user. You need edit the file<br>>> /etc/passwd and change this line as root user:<br>>><br>>> apache:x:48:48:Apache:/var/www:/sbin/nologin<br>>><br>>> by<br>>><br>>> apache:x:48:48:Apache:/var/www:/bin/bash<br>>><br>>> Then, as root user, you need to execute these command:<br>>><br>>> mkdir /var/www/.ssh<br>>> chown apache /var/www/.ssh<br>>> su - apache<br>>> ssh-keygen<br>>><br>>> Finally, copy the generated file id_rsa.pub, to postgres user home<br>>> directory<br>>> in the postgresql servers.<br>>><br>>> ssh-copy-id -i ~/.ssh/id_rsa.pub postgres@server_address<br>>><br>>> Then, try to copy any file as apache user from apache server to<br>>> postgresql<br>>> server.<br>>><br>>> Regards.<br>>><br>>> ----- Mensaje original -----<br>>><br>>>> How to add /var/www/.ssh/id_rsa.pub to<br>>>> /home/postggres/.ssh/authorized_keys on osspc17 and osspc18?<br>>><br>>>> On 5/30/12, Lazaro Ruben Garcia Martinez <lgarciam@uci.cu> wrote:<br>>>> > The user "apache" is created when you install the apache server (in<br>>>> > CentOS<br>>>> > httpd). This step is used if you going to use the pgpoolAdmin tool,<br>>>> > because<br>>>> > this tool is developed in PHP running under apache server, for this<br>>>> > reason<br>>>> > the user "apache" needs permission over the pgpool's configuration<br>>>> > files.<br>>>> ><br>>>> > Regards.<br>>>> ><br>>>> > ----- Mensaje original -----<br>>>> ><br>>>> >> From here:<br>>>> >> #cp /some/where/pgpool.conf /usr/local/etc<br>>>> >> # chown apache /usr/local/etc/pgpool.conf<br>>>> >> # cp /some/where/pcp.conf /usr/local/etc<br>>>> >> # chown apache /usr/local/etc/pcp.conf<br>>>> ><br>>>> >> Do i need to create an apache user?<br>>>> >> Sorry, i'm very new in this particular field.<br>>>> ><br>>>> >> On 5/29/12, Guillaume Lelarge <guillaume@lelarge.info> wrote:<br>>>> >> > On Tue, 2012-05-29 at 16:17 +0800, Freddy Liaw wrote:<br>>>> >> >> Hi,<br>>>> >> >><br>>>> >> >> I am following this guide to do my configuration<br>>>> >> >> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/index.html<br>>>> >> >><br>>>> >> >> I get problem start from the Installing pgpool-II section<br>>>> >> ><br>>>> >> > If you want us to help you, you need to tell much more. Read<br>>>> >> > this:<br>>>> >> > http://wiki.postgresql.org/wiki/Guide_to_reporting_problems<br>>>> >> ><br>>>> >> > That may help you to report problems in a better way.<br>>>> >> ><br>>>> >> > Regards.<br>>>> >> ><br>>>> >> ><br>>>> >> > --<br>>>> >> > Guillaume<br>>>> >> > http://blog.guillaume.lelarge.info<br>>>> >> > http://www.dalibo.com<br>>>> >> ><br>>>> >> ><br>>>> ><br>>>> >> --<br>>>> >> Best Regards,<br>>>> >> Freddy<br>>>> >> _______________________________________________<br>>>> >> pgpool-general mailing list<br>>>> >> pgpool-general@pgpool.net<br>>>> >> http://www.pgpool.net/mailman/listinfo/pgpool-general<br>>>> ><br>>>> >> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>>>> >> INFORMATICAS...<br>>>> >> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>>>> ><br>>>> >> http://www.uci.cu<br>>>> >> http://www.facebook.com/universidad.uci<br>>>> >> http://www.flickr.com/photos/universidad_uci<br>>>> ><br>>>> ><br>>>> > 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>>>> > INFORMATICAS...<br>>>> > CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>>>> ><br>>>> > http://www.uci.cu<br>>>> > http://www.facebook.com/universidad.uci<br>>>> > http://www.flickr.com/photos/universidad_uci<br>>><br>>>> --<br>>>> Best Regards,<br>>>> Freddy<br>>><br>>>> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>>>> INFORMATICAS...<br>>>> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>>><br>>>> http://www.uci.cu<br>>>> http://www.facebook.com/universidad.uci<br>>>> http://www.flickr.com/photos/universidad_uci<br>>><br>>><br>>> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>>> INFORMATICAS...<br>>> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>>><br>>> http://www.uci.cu<br>>> http://www.facebook.com/universidad.uci<br>>> http://www.flickr.com/photos/universidad_uci<br>><br>><br>> --<br>> Best Regards,<br>> Freddy<br>><br><br><br>-- <br>Best Regards,<br>Freddy<br><br>10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br><br>http://www.uci.cu<br>http://www.facebook.com/universidad.uci<br>http://www.flickr.com/photos/universidad_uci<br></blockquote><br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>