My previously posted XSLT and RSS block approach has the problem that there's nothing to force the GUI to update even though the RSS block is updating. DW put me on to CMcN who created an RSS feed block widget which addresses exactly our need (i.e. get title of each of N items from the RSS feed and make each a link using the link element for that item in the RSS).
Remaining problem is that the "see blog" generated at the bottom of the list by their widget uses the value of the link element for the overall feed. In the first place, our RSS feed generator assumed the call would be coming from other pages on our site, so generated a relative URL when invoked from the Cascade site; secondly, even if it generated the correct URL, that would be to the URL feed and not to the home page in our hcmc account for the blogs interface, so I manually edited the code generating the RSS to generate a hard-coded link to the home page for the blog. That should fix the problem.
Yesterday my encrypted home dir ran out of space and ecryptfs got into a problem where it could not write changes (including deletions I was making to reclaim space), and it became unmountable. All my data was safe on another mounted volume, so today I rebuilt the machine with a fresh install of Ubuntu and reconfigured everything. All seems to be working well again; there will be a few things I haven't remembered to install, but much more that I had installed and would never have needed again. I've reconfigured docker to store stuff on the spinning disk (it was a docker container that cause the problem), and made some other similar tweaks to keep the home dir size under control. Managed to do other work as all this was going on, too, using the laptop and the desktop.
Created a test page which displays titles of 10 most recent Announcements from the blog with a link on each to the posting in the blog.
Remaining issue is how to integrate the XSLT format block used for this with the format blocks used by default so that I can integrate my stuff with existing elements, rather than have to dedicate e.g. the entire related content section of the page to my stuff.
1) Create RSS listener to create XML
Started with http://www.hannonhill.com/kb/XML-Feed-Block/index.html
Selected New/Default/Block, check "Feed", click Submit
Specified parent folder (e.g. Assets/Blocks)
Entered system name and display name (e.g. "BlogRSS")
Entered URL of RSS feed (e.g. http://hcmc.uvic.ca/blogs/inc/CONTROL/hcmc_stats/report.php?standalone=1&chkShowDate=1&chkShowBlog=1&chkShowPost=1&chkShowStatus=1&chkShowMins=1&category_name=Announcements&order_by=post_date_desc&show_rss=1)
Clicked Submit button
2) Create Content block to hold RSS reader block
Copy Assets/Blocks/Template/related-content to Assets/Blocks/Template/related-content-RSS
Edit Assets/Blocks/Template/related-content-RSS set Column block content to RSS Listener block created in step 1
Click submit
3) Create XSL to process XML
Started with instructions at http://www.hannonhill.com/kb/XSLT-Formats/index.html
Selected New/Default/Format, check XSLT, click Submit
Did not select an asset type
Entered XSLT in edit box:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="xs" version="2.0"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xsl:template match="/">
<div>
<h4>Blog Posts</h4>
<p>See <a href="http://hcmc.uvic.ca/blogs">all blog posts</a>.</p>
<ul>
<xsl:for-each select="//item">
<xsl:if test="position() <= 10">
<xsl:variable name="hyperlink"><xsl:value-of select="./link"/></xsl:variable>
<li><class="external" a href="{$hyperlink}"><xsl:value-of select="title"/></a></li>
</xsl:if>
</xsl:for-each>
</ul>
</div>
</xsl:template>
</xsl:stylesheet>
Specified parent folder (e.g. Assets/Blocks)
Clicked Submit button
4) Assemble elements
My test is to put the formatted RSS into the right column
Selected Page (e.g. RSSTEST)
Selected Edit/Outputs
In 02-Related-Content, set Block to Content block containing RSS feed created in step 2
In 02-Related_Content, set Format to XSL block created in step 3
Click Submit
Later note: It proved simpler and cleaner to symlink /var/lib/docker to a location with lots of space on my spinning disk. Normally when I test this docker container, I want it to start from nothing (i.e. preserve no data from previous runs) so there's no advantage to mounting external storage.
After many iterations of build, run, watch jobs fail, figure out missing packages, tweak scripts, and round again, I have five jobs building successfully, and another four remain to be tested. I was running my docker instance with local data like this:
docker run --name teijenkins -p 8080:8080 -p 50000:50000 -v /var/jenkins_home tei-jenkins
but that was problematic because the image was exploding in size as it checked stuff out and built jobs, and I ran out of space on my SSD. I copied the contents of the /var/jenkins_home directory to my spinning disk and I'll be trying this instead:
docker run --name teijenkins -p 8080:8080 -p 50000:50000 -v /home/mholmes/WorkData/tei/jenkins_home:/var/jenkins_home jenkins
but I have to free up enough space to run the image in the first place. Working on that now.
Working again on a docker version of teijenkins, I've decided to base it off the official jenkins:stable image, which in turn inherits from openjdk:jdk-8, which comes ultimately from debian jessie. It's going OK: I have all the required stuff for TEI builds installing correctly, rnv building, and Jenkins running, but I'm failing to pre-install the Jenkins plugins we need right now.
Once you have an instance running, this is how to attach to it and get a shell (assuming the running instance default app is not a shell that you can use, as is the case with a Jenkins server):
sudo docker exec -i -t teijenkins /bin/bash
where "teijenkins" is the name of the running instance, set by using e.g.:
docker run --name teijenkins -p 8080:8080 -p 50000:50000 -v /var/jenkins_home tei-jenkins
The attempt to build a Jenkins server using a pure shell-script approach, which worked for Ubuntu 14.04, is now problematic for 16.04 and in particular for current versions of Jenkins, so I'm taking a different tack and trying to create a Docker image. Early steps are going well; it remains to be seen if I can get the whole thing to work, but in the meantime the learning is generally useful.
Reminding myself of the 3 steps to ensure UTF gets from form via php to mysql database and back via php to report:
1) In each php page put the following meta tag in the head element
<meta charset="utf-8"/>
2) Immediately after creating the object that connects to the DB tell it to use UTF8
mysqli
$mysqliConn = new mysqli($DBHost, $DBUser, $DBPass, $DBDatabase);
$mysqliConn->query('SET NAMES utf8');
$mysqliConn->query('SET CHARACTER SET utf8');
PDO
$conn = new PDO("mysql:host=$servername;dbname=$dbname;charset=utf8", $username, $password);
$conn->exec("set names utf8");
3) In the database (and each table) make sure the character encoding / collation is something like utf8_unicode_ci
As we move towards deploying standalone eXist/Jetty applications for our projects, we're figuring out how best to configure them. One issue is that we're probably going to want to point the subdomain (graves.uvic.ca or whatever) at the /apps/graves/ subfolder, but we're still going to need access to some of the default eXist applications such as eXide and the dashboard. This can be accomplished by adding the following line to the webapp/WEB-INF/controller-config.xml file:
<root pattern="/apps/graves/apps" path="xmldb:exist:///db/apps/"/>
Add it as the first entry before similar entries. The effect of this is to leave all the existing graves app functionality handled by the apps/graves/controller.xql, but hand anything accessed on /apps/graves/apps to the appropriate app controller. My testing with eXist 3 RC1 confirms that this works; it should mean that on going live, the dashboard (for instance) would be accessible on graves.uvic.ca/apps/dashboard (and we can access it over TLS for better security when logging in).
Due to a bug in the svn client in Jenkins, svn externals cannot be handled, so I had to set the Jenkins jobs to "ignore externals" (the default), and then check for the presence of the external file(s) at the beginning of the build process; if they're missing, ant will do an svn export using exec to put it where we need it. Curses. But working now.