[pgpool-general: 2546] Re: pid not found

[Lachezar Dobrev]

  Are you using a Debian or derivative?
  Under Debian /var/run is sym-linked to /run, which is a mounted
temporary in-memory file system, that does not survive between
reboots. Typically such /var/run/whatever stuff is handled by an
/etc/init.d/whatever script that is used to manage the service.

  What I can suggest as an UGLY work-around is to use /tmp/pgpool/
instead of /var/run/pgpool.

2014-02-06 16:45 GMT+02:00 Gintautas Sulskus <gingaz at gmail.com>:
> Well, permissions seem to be fine. This occurs after the first
> post-installation reboot.
> The only action I perform are:
> 1. install & cofing pgool according the tutorial
> 2. install and condig pgpoolAdmin according the tutorial
> 3. set load balancing & replication mode in pgpoolAdmin
> 4. shut down one node to see how pgpool(Admin) behaves
> 5. "sudo reboot"
> 6. kaput :)
>
>
> Gintas
>
>
> On Thu, Feb 6, 2014 at 12:06 PM, Gintautas Sulskus <gingaz at gmail.com> wrote:
>>
>> after reboot I perform:
>> sudo mkdir /var/run/pgpool (pgpool dir is deleted after every "sudo
>> reboot")
>> sudo chmod 777 /var/run/pgpool/ -R
>> sudo chown www-data /var/run/pgpool/ -R
>>
>> Then pgpool complains about missing pgpool.pid.
>> I think this is not a correct thing to do but I create pid file:
>> sudo touch /var/run/pgpool/pgpool.pid
>> sudo chmod 777 /var/run/pgpool/ -R
>> sudo chown www-data /var/run/pgpool/ -R
>>
>> Then it throws "pcp_stop_pgpool command error occurred." error and stops
>> reacting to any command.
>>
>> I will take a look at relevant permissions. All this started after reboot.
>>
>> Gintas
>>
>>
>> On Thu, Feb 6, 2014 at 9:50 AM, Yugo Nagata <nagata at sraoss.co.jp> wrote:
>>>
>>> On Thu, 6 Feb 2014 09:33:42 +0000
>>> Gintautas Sulskus <gingaz at gmail.com> wrote:
>>>
>>> > Thanks, Yugo.
>>> >
>>> > However, now I keep getting  "pgpool start failed. pgpool.pid not
>>> > found" when
>>> > i try to launch pgpool from pgpoolAdmin.
>>> > Any ideas?
>>>
>>> Is pid_file_name's value 'var/run/pgpool/pgpool.pid'?
>>>
>>> >
>>> > pgpool is not running.
>>> >
>>> > Regards,
>>> > Gintas
>>> >
>>> >
>>> > On Thu, Feb 6, 2014 at 8:25 AM, Yugo Nagata <nagata at sraoss.co.jp>
>>> > wrote:
>>> >
>>> > > Hi,
>>> > >
>>> > > On Thu, 6 Feb 2014 07:41:22 +0000
>>> > > Gintautas Sulskus <gingaz at gmail.com> wrote:
>>> > >
>>> > > > Hello,
>>> > > >
>>> > > > whenever I reboot my machine /var/run.pgpool dir gets removed and
>>> > > > is not
>>> > > > recreated on startup.
>>> > > > If I create it manually and perform chmod 755 pgpoolAdmin
>>> > > > complains:
>>> > > >
>>> > > > pgpool start failed. pgpool.pid not found
>>> > > >
>>> > > > 2014-02-06 07:33:31 ERROR: pid 1473: could not open pid file as
>>> > > > /var/run/pgpool/pgpool.pid. reason: Permission denied
>>> > >
>>> > > If you use pgpoolAdmin, apache user should have permission to write
>>> > > to /var/run/pgpool directory.Try
>>> > >
>>> > >  $ chomod 777 /var/run/pgpool
>>> > >
>>> > > or
>>> > >
>>> > >  $ chown apache /var/run/pgpool
>>> > >
>>> > > >
>>> > > > Do you know what is the cause and what is the best way to solve it?
>>> > > >
>>> > > > I'm running Ubuntu 10.04.4 LTS 64 bit.
>>> > > >
>>> > > > Best Regards,
>>> > > > Gintas
>>> > >
>>> > >
>>> > > --
>>> > > Yugo Nagata <nagata at sraoss.co.jp>
>>> > >
>>> >
>>> >
>>> >
>>> > --
>>> > Best Regards,
>>> > Gintautas Sulskus
>>>
>>>
>>> --
>>> Yugo Nagata <nagata at sraoss.co.jp>
>>
>>
>>
>>
>> --
>> Best Regards,
>> Gintautas Sulskus
>
>
>
>
> --
> Best Regards,
> Gintautas Sulskus
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>