<?xml version="1.0"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>CRIN Trac: Ticket #102: Security certificate issue</title>
    <link>https://trac.crin.org/trac/ticket/102</link>
    <description>&lt;p&gt;
Hi Chris,
&lt;/p&gt;
&lt;p&gt;
I'm having trouble browsing to the stage site today on crin4 - I'm getting:
&lt;/p&gt;
&lt;p&gt;
SEC_ERROR_EXPIRED_CERTIFICATE
&lt;/p&gt;
&lt;p&gt;
.. trying to view stage.crin.org
&lt;/p&gt;
&lt;p&gt;
Are you able to help there?
&lt;/p&gt;
&lt;p&gt;
Many thanks,
Russell
&lt;/p&gt;
</description>
    <language>en-us</language>
    <image>
      <title>CRIN Trac</title>
      <url>https://trac.crin.org/trac/chrome/site/logo.gif</url>
      <link>https://trac.crin.org/trac/ticket/102</link>
    </image>
    <generator>Trac 1.0.2</generator>
    <item>
      
        <dc:creator>russell</dc:creator>

      <pubDate>Fri, 10 Mar 2017 12:30:42 GMT</pubDate>
      <title>component changed</title>
      <link>https://trac.crin.org/trac/ticket/102#comment:1</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:1</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;component&lt;/strong&gt;
                changed from &lt;em&gt;backups&lt;/em&gt; to &lt;em&gt;crin4&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Fri, 10 Mar 2017 12:47:03 GMT</pubDate>
      <title>hours changed; totalhours set</title>
      <link>https://trac.crin.org/trac/ticket/102#comment:2</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:2</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0&lt;/em&gt; to &lt;em&gt;0.25&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                set to &lt;em&gt;0.25&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
I think the problem was that Nginx needs a restart before a new cert is used and the Let's Encryypt certs are only valid for three months, I have restarted Nginx and it looks OK:
&lt;/p&gt;
&lt;ul&gt;&lt;li&gt;&lt;a class="ext-link" href="https://www.ssllabs.com/ssltest/analyze.html?d=dev.crin.org"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;https://www.ssllabs.com/ssltest/analyze.html?d=dev.crin.org&lt;/a&gt;
&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;
I have added this root crontab:
&lt;/p&gt;
&lt;pre class="wiki"&gt;# restart nginx as certbot doesn't
01 01 01 * * service nginx restart
&lt;/pre&gt;&lt;p&gt;
If/when I rebuild the servers with Debian stretch then I'd switch to using acme.sh for the certs as it can also restart services:
&lt;/p&gt;
&lt;ul&gt;&lt;li&gt;&lt;a class="ext-link" href="https://github.com/Neilpang/acme.sh"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;https://github.com/Neilpang/acme.sh&lt;/a&gt;
&lt;/li&gt;&lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>russell</dc:creator>

      <pubDate>Fri, 10 Mar 2017 13:00:24 GMT</pubDate>
      <title></title>
      <link>https://trac.crin.org/trac/ticket/102#comment:3</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:3</guid>
      <description>
        &lt;p&gt;
Thanks Chris
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>russell</dc:creator>

      <pubDate>Tue, 25 Apr 2017 10:36:35 GMT</pubDate>
      <title></title>
      <link>https://trac.crin.org/trac/ticket/102#comment:4</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:4</guid>
      <description>
        &lt;p&gt;
Hi Chris,
&lt;/p&gt;
&lt;p&gt;
It looks a bit like this has happened again:
&lt;/p&gt;
&lt;p&gt;
dev.crin.org uses an invalid security certificate. The certificate expired on 22 April 2017 00:02. The current time is 25 April 2017 11:30. Error code: SEC_ERROR_EXPIRED_CERTIFICATE
&lt;/p&gt;
&lt;p&gt;
Do we think that restart's not sorting it out?
&lt;/p&gt;
&lt;p&gt;
Thanks,
Russell
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Tue, 25 Apr 2017 10:56:44 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>https://trac.crin.org/trac/ticket/102#comment:5</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:5</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0&lt;/em&gt; to &lt;em&gt;0.15&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;0.25&lt;/em&gt; to &lt;em&gt;0.4&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
Sorry about this, a nginx restart has solved the problem, the crontab was set to run on the first of each month, I have changed this to every night, which isn't a perfect solution but should work.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>russell</dc:creator>

      <pubDate>Fri, 23 Jun 2017 13:55:17 GMT</pubDate>
      <title></title>
      <link>https://trac.crin.org/trac/ticket/102#comment:6</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:6</guid>
      <description>
        &lt;p&gt;
Hi Chris,
&lt;/p&gt;
&lt;p&gt;
I'm seeing that expired certificate again:
&lt;a class="ext-link" href="https://dev.crin.org/"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;https://dev.crin.org/&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
Would we expect that to roll round on cron tonight?
&lt;/p&gt;
&lt;p&gt;
Thanks,
Russell
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Fri, 23 Jun 2017 14:07:21 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>https://trac.crin.org/trac/ticket/102#comment:7</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:7</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0&lt;/em&gt; to &lt;em&gt;0.25&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;0.4&lt;/em&gt; to &lt;em&gt;0.65&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
I restarted Nginx and it is OK now:
&lt;/p&gt;
&lt;ul&gt;&lt;li&gt;&lt;a class="ext-link" href="https://www.ssllabs.com/ssltest/analyze.html?d=dev.crin.org"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;https://www.ssllabs.com/ssltest/analyze.html?d=dev.crin.org&lt;/a&gt;
&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;
I'm not sure why this root crontab isn't doing the trick:
&lt;/p&gt;
&lt;p&gt;
&lt;tt&gt;01 01 * * * service nginx restart&lt;/tt&gt;
&lt;/p&gt;
&lt;p&gt;
I should probably switch the server over to use &lt;tt&gt;acme.sh&lt;/tt&gt;:
&lt;/p&gt;
&lt;ul&gt;&lt;li&gt;&lt;a class="ext-link" href="https://github.com/Neilpang/acme.sh"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;https://github.com/Neilpang/acme.sh&lt;/a&gt;
&lt;/li&gt;&lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>russell</dc:creator>

      <pubDate>Fri, 23 Jun 2017 14:13:10 GMT</pubDate>
      <title></title>
      <link>https://trac.crin.org/trac/ticket/102#comment:8</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:8</guid>
      <description>
        &lt;p&gt;
Thanks Chris,
&lt;/p&gt;
&lt;p&gt;
We seem to have a very old version of the dev. site there, presume that's from the DB recovery. I'll resync dev from live and rebuild.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>russell</dc:creator>

      <pubDate>Fri, 23 Jun 2017 14:19:32 GMT</pubDate>
      <title></title>
      <link>https://trac.crin.org/trac/ticket/102#comment:9</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:9</guid>
      <description>
        &lt;p&gt;
prod &amp;gt; dev DB sync underway.
&lt;/p&gt;
&lt;p&gt;
It will take a long time.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Wed, 23 Aug 2017 16:38:50 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>https://trac.crin.org/trac/ticket/102#comment:10</link>
      <guid isPermaLink="false">https://trac.crin.org/trac/ticket/102#comment:10</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0&lt;/em&gt; to &lt;em&gt;0.25&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;0.65&lt;/em&gt; to &lt;em&gt;0.9&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
This issue still hasn't been solved, I have just restarted Nginx to solve it for the next 6 weeks...
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item>
 </channel>
</rss>