HCMC Blogs

engl: postgres db connection fails

Posted by on 25 Sep 2009 in Activity log

JJ reported that the experimental map was not working. Martin and Greg did first bit of work to confirm the bug report, as I was out of the office. I then looked into the code and the first instance where the site attempts to make a connection to the postgres db throws the error. The connection to the db is identical to the one used by vihistory and the vihistory site is working. We've changed nothing in our code or our database since the last time the site was working. We suspect the problem is a result of the migration over the past month or so of a lot of central services. Emailed a query to sys-adin. Heard back the next day. They said the problem was at their end and they had fixed it.

For example if I try to go to http://mapoflondon.uvic.ca/imap/htdocs/admin/admin.php, I get
--------------------------
Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "142.104.21.173", user "london", database "london", SSL off in /home1t/london/www/imap/htdocs/session.inc on line 62

Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /home1t/london/www/imap/htdocs/session.inc on line 63
Could not connect:
--------------------------

We have other sites which seem to be working. For example, http://vihistory.uvic.ca/content/maps/imapbasic.php?map=vicbird1889 uses the same technology and exact same connection values and is working.

phil: updated pdf file

Posted by on 25 Sep 2009 in Activity log

LW sent a bunch of modified doc files to rebuild the department handout pdf file. I assembled them into one big doc file and then turned that into a pdf. Uploaded both the docx and the pdf file to the dept website.

set up restricted folder for English faculty

Posted by on 25 Sep 2009 in Activity log

Correspond with LS of English regarding setup of a folder whose access is restricted to members of the department of English. Originally thought we'd create a new account for the purpose (got a secondary account issued for the purpose), but then he decided to include it in the English department site in the english account. That account is generated from a Content Management System, so he contacted Mario to make appropriate changes in the CMS and send those out to the english account. I then modified the .htaccess file Mario had included to get the appropriate behaviour. Tested and seems to be working. Reported back to LS and Mario.

Academic Women Caucus new website maintainer

Posted by on 25 Sep 2009 in Activity log

Met with Xue D, who is the person hired by the AWC to maintain the content on their site for this year. Went over the structure of the site, the php block at the top of each page, how the navigation system works (each section has a php file included, then a method is called to specify which element is hilited).

issue forgotten passwords

Posted by on 25 Sep 2009 in Activity log

Over the week fielded a handful of requests for passwords for the teachers notes section of Canadian Mysteries site. As usual, logged in to the database using phpmyadmin (details in usual place), opened the tg_users table and did an sql query based on the email address to find the record.

Academic Women Caucus website update

Posted by on 25 Sep 2009 in Activity log

Helped Judy make changes to text of Academic Women's Caucus website. Took a few minutes to find the correct page as the request did not specify clearly.

MDH: 53.5 + 1.5 = 55 hours G&T

Posted by on 24 Sep 2009 in G&T Hours

Working on three projects at once; wanted to get to a point where the Adaptive DB project might get its last major feature finished tomorrow. Fingers crossed...

Some temporary technical delays

Posted by on 24 Sep 2009 in Activity log

I had hoped to complete 1847 today, but we encountered some technical glitches as a result of my desk-move at the HCMC. Luckily, all is solved and we are back under way. I predict that by mid-Monday (Sep. 28), I should be finished the bulk of 1847, with only the usual tweaks to complete. Considering the interruptive scan-editing, and an office reset, this timeline looks good, in my estimation.

Thanks to Martin and Greg for getting things sorted so quickly!

Set up the framework for creating the filter SQL from custom fields

Posted by on 24 Sep 2009 in Activity log

The custom field and MdhRecord code is now complete to the point where the MdhRecord is calling the MdhCustomFieldSet object asking for its SQL filter string, and the function which creates the filter string is in place; I just need to finish the inner loop which goes through the custom fields and creates the individual SQL clauses. That's for tomorrow.

Set up Olason text for markup

Posted by on 24 Sep 2009 in Activity log

There are two more articles to prepare for vol 18; the first is Olason, which I've set up, completing the headers, framework, and first paragraph, and adding commented-out biblio items and one complete <biblStruct> (to make the file valid).