[pgpool-general: 4864] Re: Pgpool:Log is tracked in syslog

[Bo Peng]

Hi,

> Since the logs were going in the syslog I made a soft-link with the /var/log/pgpool2/pgpool.log file . Now I can see the logs in pgpooladmin.

oh, I see.It sounds good.

On Wed, 3 Aug 2016 12:13:03 +0000
Kanak Upadhyay <kupadhyay at xavient.com> wrote:

> Hi,
> Since the logs were going in the syslog I made a soft-link with the /var/log/pgpool2/pgpool.log file . Now I can see the logs in pgpooladmin.
> But the point of concern is why is it not taking the pgpool.conf parameters where I've defined the log directory.
> Anyways as for now it worked.
> Changing
>  log_destination = 'syslog'
> to
> log_destination = 'stderr'
> I can view the logs on the admin.
> 
> Thanks for the help Bo Peng :)
> 
> 
> Thanks and Regards,
> Kanak Upadhyay
> Xavient Information Systems
> 
> -----Original Message-----
> From: Kanak Upadhyay
> Sent: Wednesday, August 03, 2016 1:00 PM
> To: 'Bo Peng'
> Cc: pgpool-general at pgpool.net
> Subject: RE: [pgpool-general: 4854] Pgpool:Log is tracked in syslog
> 
> Have tried this to it shows the logs that are captured to start pgpool.
> Any connection made to the backend db nodes are not shown in this file.
> 
> 
> Thanks and Regards,
> Kanak Upadhyay
> Xavient Information Systems
> 
> 
> -----Original Message-----
> From: Bo Peng [mailto:pengbo at sraoss.co.jp]
> Sent: Wednesday, August 03, 2016 12:57 PM
> To: Kanak Upadhyay
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 4854] Pgpool:Log is tracked in syslog
> 
> 
> Please try to start Pgpoll-II using the following command.
> 
>   pgpool -n > /var/log/pgpool2/pgpool.log 2>&1 &
> 
> 
> On Wed, 3 Aug 2016 07:13:36 +0000
> Kanak Upadhyay <kupadhyay at xavient.com> wrote:
> 
> > No difference even after making it to 'stderr'.
> >
> >
> > Thanks and Regards,
> > Kanak Upadhyay
> > Xavient Information Systems
> >
> >
> > -----Original Message-----
> > From: Kanak Upadhyay
> > Sent: Wednesday, August 03, 2016 12:21 PM
> > To: 'Bo Peng'
> > Cc: pgpool-general at pgpool.net
> > Subject: RE: [pgpool-general: 4854] Pgpool:Log is tracked in syslog
> >
> > It is Ubuntu 16
> >
> >
> > Thanks and Regards,
> > Kanak Upadhyay
> > Xavient Information Systems
> >
> > -----Original Message-----
> > From: Bo Peng [mailto:pengbo at sraoss.co.jp]
> > Sent: Wednesday, August 03, 2016 12:21 PM
> > To: Kanak Upadhyay
> > Cc: pgpool-general at pgpool.net
> > Subject: Re: [pgpool-general: 4854] Pgpool:Log is tracked in syslog
> >
> > hi,
> >
> > > log_destination = 'syslog'
> >
> > You could try to set the parameter log_destination like
> >
> >   log_destination = 'stderr'
> >
> > Could you tell me your OS version?
> >
> > On Wed, 3 Aug 2016 05:56:49 +0000
> > Kanak Upadhyay <kupadhyay at xavient.com> wrote:
> >
> > > Hi,
> > > I have enabled logging in pgpool.conf And set the parameters as:
> > >
> > > log_destination = 'syslog'
> > > syslog_facility = 'LOCAL0'
> > > syslog_ident = 'pgpool'
> > > logdir='/var/log/pgpool2'
> > >
> > > It should make the logs in the following directory.
> > > But I can't find the logs here. I can view the logs in
> > > /var/log/syslog Even though I have given the permission as 777 in
> > > the pgpool2 directory in /var/log
> > >
> > > And also I want it to be displayed in pgpoolAdmin.
> > > As it is not displaying the logs.
> > > [cid:image001.png at 01D1ED79.B79A6630]
> > >
> > > Thanks and Regards,
> > > Kanak Upadhyay
> > >
> > > ***DISCLAIMER*** This communication & accompanying documents ("this e-mail") contains confidential and/or privileged information for exclusive use of the individual to whom it is addressed. If you are not the intended recipient, please immediately notify the company & delete this e-mail. Any unauthorized use or disclosure of this e-mail is strictly prohibited. Representations in this e-mail are subject to contract. As an e-mail user please be cautious of the technical & other vulnerabilities of the internet which may result in malicious and/or unauthorized access to / use / alteration of e-mails/e-mail IDs. Thank you.
> >
> >
> > --
> > Bo Peng <pengbo at sraoss.co.jp>
> > SRA OSS, Inc. Japan
> >
> > ***DISCLAIMER*** This communication & accompanying documents ("this e-mail") contains confidential and/or privileged information for exclusive use of the individual to whom it is addressed. If you are not the intended recipient, please immediately notify the company & delete this e-mail. Any unauthorized use or disclosure of this e-mail is strictly prohibited. Representations in this e-mail are subject to contract. As an e-mail user please be cautious of the technical & other vulnerabilities of the internet which may result in malicious and/or unauthorized access to / use / alteration of e-mails/e-mail IDs. Thank you.
> >
> 
> 
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
> 
> ***DISCLAIMER*** This communication & accompanying documents ("this e-mail") contains confidential and/or privileged information for exclusive use of the individual to whom it is addressed. If you are not the intended recipient, please immediately notify the company & delete this e-mail. Any unauthorized use or disclosure of this e-mail is strictly prohibited. Representations in this e-mail are subject to contract. As an e-mail user please be cautious of the technical & other vulnerabilities of the internet which may result in malicious and/or unauthorized access to / use / alteration of e-mails/e-mail IDs. Thank you.
> 


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan