<?xml version="1.0"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>Transition Technology: Ticket #475: Generate a new SSL certificate</title>
    <link>http://localhost:8080/trac/ticket/475</link>
    <description>&lt;p&gt;
We need a new certificate for *.transitionnetwork.org and we need to document how to get one and how to set it up and we might as well do this on the on the &lt;a class="wiki" href="http://localhost:8080/trac/wiki/SecurityInfo"&gt;wiki:SecurityInfo&lt;/a&gt; page.
&lt;/p&gt;
&lt;p&gt;
See the notes for the existing live server &lt;a class="wiki" href="http://localhost:8080/trac/wiki/NewLiveServer#HTTPS"&gt;wiki:NewLiveServer#HTTPS&lt;/a&gt;
&lt;/p&gt;
</description>
    <language>en-us</language>
    <image>
      <title>Transition Technology</title>
      <url>/trac/chrome/site/TransitionNetwork-Logo-Web-Small.jpg</url>
      <link>http://localhost:8080/trac/ticket/475</link>
    </image>
    <generator>Trac 0.12.5</generator>
    <item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Tue, 22 Jan 2013 16:11:08 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/475#comment:1</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/475#comment:1</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.2&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.2&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Tue, 22 Jan 2013 16:43:39 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/475#comment:2</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/475#comment:2</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.2&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;0.2&lt;/em&gt; to &lt;em&gt;0.4&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
Generating a new CSR on penguin:
&lt;/p&gt;
&lt;pre class="wiki"&gt;cd /etc/ssl/transitionnetwork.org
mkdir 2013
chmod 700 2013
cd 2013
openssl req -nodes -newkey rsa:2048 -keyout transitionnetwork.org.key -out transitionnetwork.org.csr
&lt;/pre&gt;&lt;p&gt;
The only field that needs to be completed is the Common Name and we don't want a password set:
&lt;/p&gt;
&lt;pre class="wiki"&gt;Generating a 2048 bit RSA private key
.........+++
................................+++
writing new private key to 'transitionnetwork.org.key'
-----
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [AU]:
State or Province Name (full name) [Some-State]:
Locality Name (eg, city) []:
Organization Name (eg, company) [Internet Widgits Pty Ltd]:
Organizational Unit Name (eg, section) []:
Common Name (eg, YOUR name) []:*.transitionnetwork.org
Email Address []:
Please enter the following 'extra' attributes
to be sent with your certificate request
A challenge password []:
An optional company name []:
&lt;/pre&gt;&lt;p&gt;
This generates the following two files:
&lt;/p&gt;
&lt;pre class="wiki"&gt;transitionnetwork.org.csr
transitionnetwork.org.key
&lt;/pre&gt;&lt;p&gt;
The key must be kept on the server and should only be readable by root, the csr should be pasted into the interface at &lt;a class="ext-link" href="https://gandi.net/"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;https://gandi.net/&lt;/a&gt;
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>ed</dc:creator>

      <pubDate>Wed, 23 Jan 2013 09:25:13 GMT</pubDate>
      <title></title>
      <link>http://localhost:8080/trac/ticket/475#comment:3</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/475#comment:3</guid>
      <description>
        &lt;p&gt;
wildcard ssl certificate ordered from gandi, going through the steps
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Wed, 23 Jan 2013 09:53:16 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/475#comment:4</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/475#comment:4</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.35&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.75&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
Thanks Ed.
&lt;/p&gt;
&lt;p&gt;
Note for future reference, when entering the CSR at gandi select "Apache/mod-ssl" for the CSR type.
&lt;/p&gt;
&lt;p&gt;
For the verification option we have use the admin@ email address in the past.
&lt;/p&gt;
&lt;p&gt;
Once the certificate has geen generated download it and save it in /etc/ssl/transitionnetwork.org/2013/ as &lt;tt&gt;transitionnetwork.org.crt&lt;/tt&gt; and then generate a &lt;tt&gt;.pem&lt;/tt&gt; file (this might not be needed if we are no longer using apache):
&lt;/p&gt;
&lt;pre class="wiki"&gt;cat transitionnetwork.org.crt &amp;gt; transitionnetwork.org.pem
cat transitionnetwork.org.key &amp;gt;&amp;gt; transitionnetwork.org.pem
&lt;/pre&gt;&lt;p&gt;
Generate the gandi.pem file (this only need don't once, it's not needed every year):
&lt;/p&gt;
&lt;pre class="wiki"&gt;wget http://crt.gandi.net/GandiStandardSSLCA.crt -O GandiStandardSSLCA.crt
wget http://crt.usertrust.com/UTNAddTrustServer_CA.crt -O UTNAddTrustServer_CA.crt
wget http://crt.usertrust.com/AddTrustExternalCARoot.crt -O AddTrustExternalCARoot.crt
openssl x509 -inform DER -in GandiStandardSSLCA.crt -out GandiStandardSSLCA.pem
openssl x509 -inform DER -in AddTrustExternalCARoot.crt -out AddTrustExternalCARoot.pem
openssl x509 -inform DER -in UTNAddTrustServer_CA.crt -out UTNAddTrustServer_CA.pem
cat GandiStandardSSLCA.pem &amp;gt; gandi.pem
cat AddTrustExternalCARoot.pem &amp;gt;&amp;gt; gandi.pem
cat UTNAddTrustServer_CA.pem &amp;gt;&amp;gt; gandi.pem
&lt;/pre&gt;&lt;p&gt;
Generate the chained pem file for nginx (CHECK FOR WHITESPACE PROBLEMS!):
&lt;/p&gt;
&lt;pre class="wiki"&gt;cat transitionnetwork.org.crt &amp;gt; transitionnetwork.org.chained.pem
cat GandiStandardSSLCA.pem &amp;gt;&amp;gt; transitionnetwork.org.chained.pem
cat UTNAddTrustServer_CA.pem &amp;gt;&amp;gt; transitionnetwork.org.chained.pem
cat AddTrustExternalCARoot.pem &amp;gt;&amp;gt; transitionnetwork.org.chained.pem
&lt;/pre&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Wed, 23 Jan 2013 10:16:47 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/475#comment:5</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/475#comment:5</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0.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.75&lt;/em&gt; to &lt;em&gt;1.0&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
Hi Ed
&lt;/p&gt;
&lt;p&gt;
When you copied the "Transition Network" zone file to "Transition Network 1" and added the sub-domain for the SSL certificate verification you also, inadvertently, made it so I can't edit it.
&lt;/p&gt;
&lt;p&gt;
I think that I need to perhaps raise a ticket with gandi regarding the way permissions work on the zone files.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Wed, 23 Jan 2013 10:23:22 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/475#comment:6</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/475#comment:6</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.1&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;1.0&lt;/em&gt; to &lt;em&gt;1.1&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
OK, this is simply the way gandi works, each time one of us makes an update to a zone file when the other person edited it last we have to copy it (creating a new name for it) and then editi it and then set the domain names to use the new file:
&lt;/p&gt;
&lt;blockquote class="citation"&gt;
&lt;p&gt;
To edit a zone, you need to be logged in under the zonefile' owner. Otherwise you need to first make a copy of the zone so that you own the copy, then you can make changes.
&lt;/p&gt;
&lt;p&gt;
You can see directly from the domain's control panel whether or not the handle you are logged in under can edit a zone.
&lt;/p&gt;
&lt;p&gt;
The solution is to proceed by creating a copy of the zone and then following the instructions here to go through with the normal zonefile edit process.
&lt;/p&gt;
&lt;p&gt;
&lt;a class="ext-link" href="http://wiki.gandi.net/en/dns/faq#cannot-change-zone-file"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;http://wiki.gandi.net/en/dns/faq#cannot-change-zone-file&lt;/a&gt;
&lt;/p&gt;
&lt;/blockquote&gt;
&lt;p&gt;
That is a bit annoying as it means that the zone files names will have to keep changing...
&lt;/p&gt;
&lt;p&gt;
But at least we now know how to do it, I'll update the wiki page &lt;a class="wiki" href="http://localhost:8080/trac/wiki/DomainNames"&gt;wiki:DomainNames&lt;/a&gt; to reflect this
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>ed</dc:creator>

      <pubDate>Wed, 23 Jan 2013 10:54:59 GMT</pubDate>
      <title></title>
      <link>http://localhost:8080/trac/ticket/475#comment:7</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/475#comment:7</guid>
      <description>
        &lt;p&gt;
i'm handing over to chris to keep it simple as discussed on phone
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Fri, 25 Jan 2013 15:17:56 GMT</pubDate>
      <title>hours, status, description, totalhours changed; resolution set</title>
      <link>http://localhost:8080/trac/ticket/475#comment:8</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/475#comment:8</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;hours&lt;/strong&gt;
                changed from &lt;em&gt;0.0&lt;/em&gt; to &lt;em&gt;0.44&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;
                changed from &lt;em&gt;new&lt;/em&gt; to &lt;em&gt;closed&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;resolution&lt;/strong&gt;
                set to &lt;em&gt;fixed&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;description&lt;/strong&gt;
              modified (&lt;a href="/trac/ticket/475?action=diff&amp;amp;version=8"&gt;diff&lt;/a&gt;)
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;totalhours&lt;/strong&gt;
                changed from &lt;em&gt;1.1&lt;/em&gt; to &lt;em&gt;1.54&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
I have installed the new certs on puffin and penguin, hopefully I won't need to install the new cert on kiwi or quince as they will have been switched off before 16th Feb.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item>
 </channel>
</rss>