CRIN Trac: Ticket #117: Install Newrelic on Crin2

hours changed; totalhours set

chris — Thu, 18 May 2017 10:53:26 GMT

hours changed from 0 to 0.25
totalhours set to 0.25

Following the instructions, we already had a /etc/apt/sources.list.d/newrelic.list file containing "deb http://apt.newrelic.com/debian/ newrelic non-free" so the gpg key will also be there so:

apt-get install newrelic-sysmond
nrsysmond-config --set license_key=XXX
systemctl start newrelic-sysmond

So there should soon be some stats...

chris — Tue, 23 May 2017 11:53:38 GMT

The firewall needs updating on Crin1 to allow incoming connections from New Relic:

https://docs.newrelic.com/docs/apm/new-relic-apm/getting-started/networks

hours, totalhours changed

chris — Tue, 23 May 2017 12:24:39 GMT

hours changed from 0 to 0.25
totalhours changed from 0.25 to 0.5

Looking at the networks page, it is mostly about outging traffic and none is blocked, there is also:

If you want to configure your firewall to allow New Relic to access your monitoring URL

I assume that "monitoring URL" is going to use HTTP or HTTPS? In which case that isn't an issue either as we allow port 80 and 443 traffic to the server, it is a web server after all...

So I can't see that we need to do anything?

Peter -- have I missed something here?

peter — Tue, 23 May 2017 13:20:06 GMT

Hi Chris. Have we restarted php-fpm?
On Tue, 23 May 2017 at 13:24 CRIN Trac <trac@trac.crin.org> wrote:
> #117: Install Newrelic on Crin2
> ------------------------------------+-----------------------------------
>                  Reporter:  chris   |                Owner:  chris
>                      Type:  defect  |               Status:  new
>                  Priority:  major   |            Milestone:  Maintenance
>                 Component:  crin2   |              Version:
>                Resolution:          |             Keywords:
> Estimated Number of Hours:  0       |  Add Hours to Ticket:  0.25
>                 Billable?:  1       |          Total Hours:  0.25
> ------------------------------------+-----------------------------------
> Changes (by chris):
>
>  * hours:  0 => 0.25
>  * totalhours:  0.25 => 0.5
>
>
> Comment:
>
>  Looking at the [https://docs.newrelic.com/docs/apm/new-relic-apm/getting-
>  started/networks networks page], it is mostly about outging traffic and
>  none is blocked, there is also:
>
>  > If you want to configure your firewall to allow New Relic to access your
>  monitoring URL
>
>  I assume that "monitoring URL" is going to use HTTP or HTTPS? In which
>  case that isn't an issue either as we allow port 80 and 443 traffic to the
>  server, it is a web server after all...
>
>  So I can't see that we need to do anything?
>
>  Peter -- have I missed something here?
>
> --
> Ticket URL: <https://trac.crin.org/trac/ticket/117#comment:3>
> CRIN Trac <https://trac.crin.org/trac>
> Trac project for CRIN website and servers.
>

peter — Tue, 23 May 2017 13:31:34 GMT

We are missing the newrelic.ini file.
The mods-available is pointing to a file that does not exist.
I'll see what we need to put in it.
lrwxrwxrwx 1 root root 33 May 14  2016 20-newrelic.ini ->
../../mods-available/newrelic.ini
On Tue, 23 May 2017 at 14:20 CRIN Trac <trac@trac.crin.org> wrote:
> #117: Install Newrelic on Crin2
> ------------------------------------+-----------------------------------
>                  Reporter:  chris   |                Owner:  chris
>                      Type:  defect  |               Status:  new
>                  Priority:  major   |            Milestone:  Maintenance
>                 Component:  crin2   |              Version:
>                Resolution:          |             Keywords:
> Estimated Number of Hours:  0       |  Add Hours to Ticket:  0
>                 Billable?:  1       |          Total Hours:  0.5
> ------------------------------------+-----------------------------------
>
> Comment (by peter):
>
>  {{{
>  Hi Chris. Have we restarted php-fpm?
>
>  On Tue, 23 May 2017 at 13:24 CRIN Trac <trac@trac.crin.org> wrote:
>
>  > #117: Install Newrelic on Crin2
>  > ------------------------------------+-----------------------------------
>  >                  Reporter:  chris   |                Owner:  chris
>  >                      Type:  defect  |               Status:  new
>  >                  Priority:  major   |            Milestone:  Maintenance
>  >                 Component:  crin2   |              Version:
>  >                Resolution:          |             Keywords:
>  > Estimated Number of Hours:  0       |  Add Hours to Ticket:  0.25
>  >                 Billable?:  1       |          Total Hours:  0.25
>  > ------------------------------------+-----------------------------------
>  > Changes (by chris):
>  >
>  >  * hours:  0 => 0.25
>  >  * totalhours:  0.25 => 0.5
>  >
>  >
>  > Comment:
>  >
>  >  Looking at the [https://docs.newrelic.com/docs/apm/new-relic-
>  apm/getting-
>  >  started/networks networks page], it is mostly about outging traffic and
>  >  none is blocked, there is also:
>  >
>  >  > If you want to configure your firewall to allow New Relic to access
>  your
>  >  monitoring URL
>  >
>  >  I assume that "monitoring URL" is going to use HTTP or HTTPS? In which
>  >  case that isn't an issue either as we allow port 80 and 443 traffic to
>  the
>  >  server, it is a web server after all...
>  >
>  >  So I can't see that we need to do anything?
>  >
>  >  Peter -- have I missed something here?
>  >
>  > --
>  > Ticket URL: <https://trac.crin.org/trac/ticket/117#comment:3>
>  > CRIN Trac <https://trac.crin.org/trac>
>  > Trac project for CRIN website and servers.
>  >
>  }}}
>
> --
> Ticket URL: <https://trac.crin.org/trac/ticket/117#comment:4>
> CRIN Trac <https://trac.crin.org/trac>
> Trac project for CRIN website and servers.
>

peter — Tue, 23 May 2017 13:45:04 GMT

PHP Startup: Unable to load dynamic library
'/usr/lib/php5/20131226/newrelic.so'
We are also missing the main object file for the php plugin.
On Tue, 23 May 2017 at 14:31 CRIN Trac <trac@trac.crin.org> wrote:
> #117: Install Newrelic on Crin2
> ------------------------------------+-----------------------------------
>                  Reporter:  chris   |                Owner:  chris
>                      Type:  defect  |               Status:  new
>                  Priority:  major   |            Milestone:  Maintenance
>                 Component:  crin2   |              Version:
>                Resolution:          |             Keywords:
> Estimated Number of Hours:  0       |  Add Hours to Ticket:  0
>                 Billable?:  1       |          Total Hours:  0.5
> ------------------------------------+-----------------------------------
>
> Comment (by peter):
>
>  {{{
>  We are missing the newrelic.ini file.
>  The mods-available is pointing to a file that does not exist.
>  I'll see what we need to put in it.
>
>
>  lrwxrwxrwx 1 root root 33 May 14  2016 20-newrelic.ini ->
>  ../../mods-available/newrelic.ini
>
>
>
>
>  On Tue, 23 May 2017 at 14:20 CRIN Trac <trac@trac.crin.org> wrote:
>
>  > #117: Install Newrelic on Crin2
>  > ------------------------------------+-----------------------------------
>  >                  Reporter:  chris   |                Owner:  chris
>  >                      Type:  defect  |               Status:  new
>  >                  Priority:  major   |            Milestone:  Maintenance
>  >                 Component:  crin2   |              Version:
>  >                Resolution:          |             Keywords:
>  > Estimated Number of Hours:  0       |  Add Hours to Ticket:  0
>  >                 Billable?:  1       |          Total Hours:  0.5
>  > ------------------------------------+-----------------------------------
>  >
>  > Comment (by peter):
>  >
>  >  {{{
>  >  Hi Chris. Have we restarted php-fpm?
>  >
>  >  On Tue, 23 May 2017 at 13:24 CRIN Trac <trac@trac.crin.org> wrote:
>  >
>  >  > #117: Install Newrelic on Crin2
>  >  >
>  ------------------------------------+-----------------------------------
>  >  >                  Reporter:  chris   |                Owner:  chris
>  >  >                      Type:  defect  |               Status:  new
>  >  >                  Priority:  major   |            Milestone:
>  Maintenance
>  >  >                 Component:  crin2   |              Version:
>  >  >                Resolution:          |             Keywords:
>  >  > Estimated Number of Hours:  0       |  Add Hours to Ticket:  0.25
>  >  >                 Billable?:  1       |          Total Hours:  0.25
>  >  >
>  ------------------------------------+-----------------------------------
>  >  > Changes (by chris):
>  >  >
>  >  >  * hours:  0 => 0.25
>  >  >  * totalhours:  0.25 => 0.5
>  >  >
>  >  >
>  >  > Comment:
>  >  >
>  >  >  Looking at the [https://docs.newrelic.com/docs/apm/new-relic-
>  >  apm/getting-
>  >  >  started/networks networks page], it is mostly about outging traffic
>  and
>  >  >  none is blocked, there is also:
>  >  >
>  >  >  > If you want to configure your firewall to allow New Relic to
>  access
>  >  your
>  >  >  monitoring URL
>  >  >
>  >  >  I assume that "monitoring URL" is going to use HTTP or HTTPS? In
>  which
>  >  >  case that isn't an issue either as we allow port 80 and 443 traffic
>  to
>  >  the
>  >  >  server, it is a web server after all...
>  >  >
>  >  >  So I can't see that we need to do anything?
>  >  >
>  >  >  Peter -- have I missed something here?
>  >  >
>  >  > --
>  >  > Ticket URL: <https://trac.crin.org/trac/ticket/117#comment:3>
>  >  > CRIN Trac <https://trac.crin.org/trac>
>  >  > Trac project for CRIN website and servers.
>  >  >
>  >  }}}
>  >
>  > --
>  > Ticket URL: <https://trac.crin.org/trac/ticket/117#comment:4>
>  > CRIN Trac <https://trac.crin.org/trac>
>  > Trac project for CRIN website and servers.
>  >
>  }}}
>
> --
> Ticket URL: <https://trac.crin.org/trac/ticket/117#comment:5>
> CRIN Trac <https://trac.crin.org/trac>
> Trac project for CRIN website and servers.
>

peter — Tue, 23 May 2017 13:55:04 GMT

I have it working:
Ran the agent install again.
 sudo apt-get install newrelic-php5

chris — Tue, 23 May 2017 14:05:01 GMT

Thanks Peter, I hasn't installed the newrelic-php5 package, only the newrelic-sysmond package, see ticket:117#comment:1.

chris — Thu, 25 May 2017 10:28:13 GMT

Hi Peter

Any interesting stats so far?

Would it also be worth installing on Crin1? Or is there enough data in /var/log/mysql/mysql-slow.log to work with already?