<?xml version="1.0"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>Transition Technology: Ticket #778: need access to Parrot</title>
    <link>http://localhost:8080/trac/ticket/778</link>
    <description>&lt;p&gt;
i need a publicly available &lt;a class="wiki" href="http://localhost:8080/trac/wiki/WordPress"&gt;WordPress&lt;/a&gt; demo install to play with. should this be on Parrot? what (sub)domain can i use?
&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/778</link>
    </image>
    <generator>Trac 0.12.5</generator>
    <item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Wed, 27 Aug 2014 12:19:31 GMT</pubDate>
      <title></title>
      <link>http://localhost:8080/trac/ticket/778#comment:1</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/778#comment:1</guid>
      <description>
        &lt;p&gt;
What sub-domain would you like? something.transitionnetwork.org? If so what is the "something"?
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Wed, 27 Aug 2014 12:23:54 GMT</pubDate>
      <title></title>
      <link>http://localhost:8080/trac/ticket/778#comment:2</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/778#comment:2</guid>
      <description>
        &lt;p&gt;
Do you need HTTPS for the site?
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Wed, 27 Aug 2014 13:01:20 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/778#comment:3</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/778#comment:3</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.0&lt;/em&gt; to &lt;em&gt;0.25&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
For now I have created a WP site which can be accessed here:
&lt;/p&gt;
&lt;ul&gt;&lt;li&gt;&lt;a class="ext-link" href="http://annesley.parrot.webarch.net/"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;http://annesley.parrot.webarch.net/&lt;/a&gt;
&lt;/li&gt;&lt;li&gt;&lt;a class="ext-link" href="http://annesley.parrot.transitionnetwork.org/"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;http://annesley.parrot.transitionnetwork.org/&lt;/a&gt;
&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;
The script for automatically sending the login details to Annesley failed as the server's GPG private key had expired, I'll sort that out another time.
&lt;/p&gt;
&lt;p&gt;
Annesley did you get a email with the WP login details? Let me know if not and I'll reset the password.
&lt;/p&gt;
&lt;p&gt;
You should be able to login using SFTP to annesley@… and the site is in ~/sites/default and there is PHPMyAdmin access here:
&lt;/p&gt;
&lt;ul&gt;&lt;li&gt;&lt;a class="ext-link" href="https://parrot.transitionnetwork.org/phpmyadmin/"&gt;&lt;span class="icon"&gt;​&lt;/span&gt;https://parrot.transitionnetwork.org/phpmyadmin/&lt;/a&gt;
&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;
You can get the MySQL username / password from the wp-config.php file if you don't have them.
&lt;/p&gt;
&lt;p&gt;
Sorry the script documented here &lt;a class="wiki" href="http://localhost:8080/trac/wiki/ParrotServer#AddingaNewWordPressSite"&gt;ParrotServer#AddingaNewWordPressSite&lt;/a&gt; did work as expected -- this was because of the GPG issue.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>annesley</dc:creator>

      <pubDate>Wed, 27 Aug 2014 13:57:44 GMT</pubDate>
      <title></title>
      <link>http://localhost:8080/trac/ticket/778#comment:4</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/778#comment:4</guid>
      <description>
        &lt;p&gt;
hi chris,
&lt;/p&gt;
&lt;p&gt;
got the SFTP connection up and running but am now getting a "Could not connect to host Socket error: Success." error message and SFTP is now failing.
&lt;/p&gt;
&lt;p&gt;
the WP email did not contain the password:
Username: annesley
Password: The password you chose during the install.
&lt;/p&gt;
&lt;p&gt;
thanks
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>chris</dc:creator>

      <pubDate>Wed, 27 Aug 2014 14:05:30 GMT</pubDate>
      <title>hours, totalhours changed</title>
      <link>http://localhost:8080/trac/ticket/778#comment:5</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/778#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.25&lt;/em&gt; to &lt;em&gt;0.5&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
Replying to &lt;a href="http://localhost:8080/trac/ticket/778#comment:4" title="Comment 4 for Ticket #778"&gt;annesley&lt;/a&gt;:
&lt;/p&gt;
&lt;blockquote class="citation"&gt;
&lt;p&gt;
got the SFTP connection up and running but am now getting a "Could not connect to host Socket error: Success." error message and SFTP is now failing.
&lt;/p&gt;
&lt;/blockquote&gt;
&lt;p&gt;
It looks like you had several password failures and then several public key authentication connections, then the deny hosts scripts picked up on the failures and added your IP to /etc/hosts.deny, I have now added it to /etc/hosts.allow so you should be able to connect OK using SFTP and public key authentication again.
&lt;/p&gt;
&lt;blockquote class="citation"&gt;
&lt;p&gt;
the WP email did not contain the password:
Username: annesley
Password: The password you chose during the install.
&lt;/p&gt;
&lt;/blockquote&gt;
&lt;p&gt;
I'll send you a new one off-list and also the MySQL passwd.
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>annesley</dc:creator>

      <pubDate>Wed, 27 Aug 2014 14:18:37 GMT</pubDate>
      <title>status changed; resolution set</title>
      <link>http://localhost:8080/trac/ticket/778#comment:6</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/778#comment:6</guid>
      <description>
          &lt;ul&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;/ul&gt;
        &lt;p&gt;
ok, all working. thanks :)
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>ed</dc:creator>

      <pubDate>Mon, 08 Sep 2014 12:36:47 GMT</pubDate>
      <title>milestone changed</title>
      <link>http://localhost:8080/trac/ticket/778#comment:7</link>
      <guid isPermaLink="false">http://localhost:8080/trac/ticket/778#comment:7</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;milestone&lt;/strong&gt;
                changed from &lt;em&gt;TNv3&lt;/em&gt; to &lt;em&gt;Maintenance&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
moving to maintenance milestone as this is a maintenance task
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item>
 </channel>
</rss>