<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Steps for enabling the access of apache user to postgres server: (Proved in CentOS)<br>
<br>
Usually, the apache user is no login user. You need edit the file /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>
<br>
mkdir /var/www/.ssh
<br>
chown apache /var/www/.ssh
<br>
su - apache
<br>
ssh-keygen<br>
<br>
<br>
Finally, copy the generated file id_rsa.pub, to postgres user home directory 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 postgresql server.<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;">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 CentOS<br>> httpd). This step is used if you going to use the pgpoolAdmin tool, because<br>> this tool is developed in PHP running under apache server, for this reason<br>> the user "apache" needs permission over the pgpool's configuration 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 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>-- <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>