Coffee|Code: Dan Scott's blog

Programming Historian · Added quantifiable properties per Philipp Zumstein

User-agent: *
Disallow: /

proxy_cache_path /tmp/nginx_cache levels=1:2 keys_zone=my_cache:10m max_size=1g
                 inactive=60m use_temp_path=off;
proxy_cache_key $scheme$http_host$request_uri;

server {
    listen 80;
    server_name clients.concat.ca;

    include /etc/nginx/concat_ssl.conf;
    include /etc/nginx/osrf_sockets.conf;

    location / {
        proxy_pass https://localhost:7443;

        rewrite ^/?$ /updates/manualupdate.html permanent;

        include /etc/nginx/concat_headers.conf;
    }
}
listen 443 ssl http2;
ssl_certificate /etc/apache2/ssl/server.crt;
ssl_certificate_key /etc/apache2/ssl/server.key;

if ($scheme != "https") {
    return 301 https://$host$request_uri;
}

# generate with openssl dhparam -out dhparams.pem 2048
ssl_dhparam /etc/apache2/dhparams.pem;

# From https://mozilla.github.io/server-side-tls/ssl-config-generator/
ssl_prefer_server_ciphers on;
ssl_session_timeout 1d;
ssl_session_cache shared:SSL:50m;
ssl_session_tickets off;

# intermediate configuration. tweak to your needs.
ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
ssl_ciphers 'ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS';

# HSTS (ngx_http_headers_module is required) (15768000 seconds = 6 months)
add_header Strict-Transport-Security max-age=15768000;

# OCSP Stapling ---
# fetch OCSP records from URL in ssl_certificate and cache them
ssl_stapling on;
ssl_stapling_verify on;
location /osrf-websocket-translator {
    proxy_pass https://localhost:7682;
    proxy_set_header X-Real-IP $remote_addr;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

    # Needed for websockets proxying.
    proxy_http_version 1.1;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection "upgrade";

    # Raise the default nginx proxy timeout values to an arbitrarily
    # high value so that we can leverage osrf-websocket-translator's
    # timeout settings.
    proxy_connect_timeout 5m;
    proxy_send_timeout 1h;
    proxy_read_timeout 1h;
}
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;

proxy_cache my_cache;
proxy_cache_use_stale error timeout http_500 http_502 http_503 http_504;
proxy_cache_lock on;

rewrite ^/?$ /eg/opac/home permanent;
manifest.json
{
  "name": "Forest VR",
  "icons": [
    {
      "src": "./assets/images/icons/android-chrome-144x144.png",
      "sizes": "144x144",
      "type": "image/png"
    }
  ],
  "theme_color": "#ffffff",
  "background_color": "#ffffff",
  "start_url": "./index.html",
  "display": "standalone",
  "orientation": "landscape"
}

<link>
<head>
<link rel="manifest" href="manifest.json">

staticFileGlobs
swConfig = {
  cacheId: packageJson.name,
  runtimeCaching: [{
    urlPattern: /^https:\/\/cdn\.rawgit\.com\//,
    handler: 'cacheFirst'
  },{
    urlPattern: /^https:\/\/aframe\.io\//,
    handler: 'cacheFirst'
  },{
    urlPattern: /\/assets\/sounds\//,
    handler: 'cacheFirst'
  }],
  staticFileGlobs: [
    'assets/fonts/fabrica-webfont.woff',
    'assets/images/bg.jpg',
    'assets/images/tree_icon.png',
    'assets/models/**.dae',
    'bundle.css',
    'bundle.js',
    'index.html'
  ]
}

writeServiceWorkerFile()
function writeServiceWorkerFile(callback) {
  swConfig = {...}
  swPrecache.write('service-worker.js', swConfig, callback);
}

gulp.task('generate-service-worker', ['scripts', 'styles'], function(callback) {
  writeServiceWorkerFile(callback);
});

generate-service-worker task
gulp.task('deploy',['scripts','styles','generate-service-worker'])

<script>
<head>
google.ca
getContents()
The concept of “deliberate practice” was introduced by Ericsson et al

LISA: OK EasyWriter, insert footnote: Ericsson deliberate practice
AIRA: [positions a list of three papers that LISA might want to cite, in order of likelihood based on all of this data, right under her cursor]
LISA: [mutters] Yep, let’s get that a bit closer to 6,000 citations.
/**
* A custom function that checks for an ISBN in Evergreen
*
* Returns "Yes" if there is a match, or "No" if there is no match
*/

function checkForISBN(isbn) {
  var hostname = 'https://example.org';
  var urlBase = hostname + '/opac/extras/sru';

  /* Supply a numeric or shortname library identifier
  * to restrict the search to that part of the organization
  */
  var libraryID = '103';
  if (libraryID) {
    urlBase += '/' + libraryID;
  }
  urlBase += '?version=1.1&operation=searchRetrieve&maximumRecords=1&query=';
  var q = encodeURIComponent('identifier|isbn:' + isbn);
  var url = urlBase + q;
  var response = UrlFetchApp.fetch(url);
  if (response.getContentText().search('1') > -1) {
    return "Yes";
  }
  return "No";
}

=CheckForISBN(C2)
#ERROR
#ERROR
200 OK
200
404 Not Found
410 Gone
302 Moved temporarily
404 Not Found
200 OK
302 Found
Location:
404 Not Found
404
302 Found
302 Found
200 OK
200 OK
404 Not Found
200 OK
robots.txt
@resource
author
@resource
about
<link rel="">
robots.txt
User-Agent: *
Disallow /

/library/*
/licensed/*
robots.txt
Book
Organization
publisher
author
datePublished
isbn
Product
Offer
Recipe
Action
potentialAction
BorrowAction
LendAction
PizzaOrderPreferences
 <p vocab="http://schema.org/" typeof="PizzaOrderPreferences">  And <a href="http://doodle.com/exampleblahblah" property="url">order pizza here</a>.</p><p>If our pizza order doesn't get gamed, that just shows how few people visit my blog!
</p>

http://schema.org/Offer
`Offer
`itemOffered
Offer
`Product
Book
Movie
MusicAlbum
Product
additionalType
Offer
seller
Organization
Library
sku
serialNumber
availableAtOrFrom
Place
Library
seller
availability
businessFunction
http://purl.org/goodrelations/v1#LeaseOut
price
domainIncludes
$0
json_encode()
$0
264 #1 $a Cambridge : $b Elsevier, $c 2013 $0 [1]http://dbpedia.org/resource/Cambridge,_Massachusetts $0 [2]http://dbpedia.org/resource/Elsevier

SplDoublyLinkedList::add()
-beta
pear install File_MARC

text-transform: uppercase
Book
MusicRecording
MusicAlbum
name
ISBN
publisher
publication date
author
contributor
keywords
@about
@href
@resource
@about
application/xml
text.html
<!-- http://schema.org/datePublished --><owl:DatatypeProperty rdf:about="http://schema.org/datePublished">    <rdfs:label xml:lang="en">datePublished</rdfs:label>    <rdfs:comment xml:lang="en">Date of first broadcast/publication.</rdfs:comment>    <rdfs:range rdf:resource="http://www.w3.org/2000/01/rdf-schema#Literal"/>    <rdfs:domain>        <owl:Class>            <owl:unionOf rdf:parseType="Collection">                <rdf:Description rdf:about="http://schema.org/CreativeWork"/>            </owl:unionOf>        </owl:Class>    </rdfs:domain></owl:DatatypeProperty>

<rdf:Description rdf:about="http://schema.org/datePublished"> <rdf:type rdf:resource="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property"/>    <rdfs:label xml:lang="en">Date Published</rdfs:label>  <rdfs:comment xml:lang="en">Date of first broadcast/publication.</rdfs:comment>    <rdfs:domain rdf:resource="http://schema.org/CreativeWork"/>  <rdfs:range rdf:resource="http://www.w3.org/2001/XMLSchema#date"/>    <rdfs:isDefinedBy rdf:resource="http://schema.org/CreativeWork"/></rdf:Description>

<rdf:Description rdf:nodeID="node180s0ohklx169">    <rdf:type rdf:resource="http://www.w3.org/2002/07/owl#Class"/></rdf:Description><rdf:Description rdf:nodeID="node180s0ohklx170">   <rdf:first rdf:resource="http://schema.org/Distance"/>    <rdf:rest rdf:nodeID="node180s0ohklx171"/></rdf:Description><rdf:Description rdf:nodeID="node180s0ohklx171">   <rdf:first rdf:resource="http://schema.org/QuantitativeValue"/>   <rdf:rest rdf:resource="http://www.w3.org/1999/02/22-rdf-syntax-ns#nil"/></rdf:Description><rdf:Description rdf:nodeID="node180s0ohklx169">    <owl:unionOf rdf:nodeID="node180s0ohklx170"/></rdf:Description><rdf:Description rdf:about="http://schema.org/depth">   <rdfs:range rdf:nodeID="node180s0ohklx169"/>  <rdfs:isDefinedBy rdf:resource="http://schema.org/Product"/></rdf:Description>

"datePublished": {      "comment": "Date of first broadcast/publication.",       "comment_plain": "Date of first broadcast/publication.",       "domains": [        "CreativeWork"      ],       "id": "datePublished",       "label": "Date Published",       "ranges": [        "Date"      ]    },

comment
url
id
...<head>...<meta content="initial-scale=1.0,width=device-width" name="viewport"><style>@media only screen and (max-width: 600px) {    #header {        padding: 0px;        margin: 0px;    }    .facet_sidebar {        display: none;    }    ...}</style><head>...

sites/all/modules
Foo illustration.JPG
Foo info.JPG
Foo.JPG
panels_pane
configuration
a:5:{s:11:"admin_title";s:5:"RACER";s:5:"title";s:0:"";s:4:"body";s:639:"<p><img width="225" height [...]}

s
#!/bin/perluse strict;use warnings;foreach (<DATA>) {    chomp();    my $i = 0;    my $body = 0;    my @fixed;    my @row = split /\t/;    my $pid = $row[1];    my $configuration = $row[0];    my @chunks = split /";s:/, $configuration;    foreach my $chunk (@chunks) {        if (!$i++) {            push @fixed, $chunk;            next;        }        if ($chunk =~ m/"body/) {            $body = 1;            push @fixed, $chunk;            next;        }        if ($body) {            my ($length, $content) = $chunk =~ m/^(\d+):"(.+)$/;          for (my $j = 0; $j < 50; $j++) {            $content =~ s{(/pictures/[^\./]+?)%20}{$1_}g;         }            $content =~ s{%20}{+}g;            $length = length($content);            $chunk = "$length:\"$content";            $body = 0;        }        push @fixed, $chunk;    }    print 'UPDATE panels_pane SET configuration = $ashes$' .         join('";s:', @fixed) . '$ashes$' . " WHERE pid = $pid;\n";}__DATA__

COPY (SELECT configuration, pid FROM panels_pane WHERE configuration ~ '%20') TO 'conf_pids.out';
file/path
file
ts_headline()
ts_rewrite()
setenforce 0
/var/log/messages
/var/log/audit/audit.log
setsebool httpd_can_network_connect on

unconfined_t
# Mark web content as, well, web contentchcon -R --type=httpd_sys_content_t /openils/lib/javascriptchcon -R --type=httpd_sys_content_t /openils/var/webchcon -R --type=httpd_sys_content_t /openils/var/templates*chcon -R --type=httpd_sys_content_t /openils/var/datachcon -R --type=httpd_sys_content_t /openils/var/xslchcon --type=httpd_sys_content_t /openils/conf/opensrf_core.xmlchcon --type=httpd_sys_content_t /openils/conf/fm_IDL.xml # Mark the custom Apache modules chcon --user=system_u --type=httpd_modules_t /usr/lib64/httpd/modules/mod_xmlent.so chcon --user=system_u --type=httpd_modules_t /usr/lib64/httpd/modules/osrf_*# Mark the dynamic libraries we need to load# "-h" changes the context of symlinks as well as fileschcon -h --type=lib_t /openils/lib/*# Mark executable scriptschcon -t httpd_sys_script_exec_t /openils/bin/openurl_map.pl chcon -t httpd_sys_script_exec_t /openils/bin/offline-blocked-list.pl # Might not have been necessarychcon -R --user=system_u /usr/local/share/perl5/chcon --user=system_u /etc/httpd/conf.d/eg.conf chcon --user=system_u /etc/httpd/startup.pl chcon --user=system_u /etc/httpd/eg_vhost.conf chcon -R --user=system_u /etc/httpd/ssl/

chcon
semanage
opensrf
User
/etc/httpd/conf/httpd.conf
apache
/openils/var/log
Open-ILS/examples/evergreen-rsyslog.conf
/etc/rsyslog.d/
rsyslogd
systemctl restart rsyslog.service
/etc/httpd/eg_vhost.conf
/openils/conf/opensrf_core.xml
opensrf
setenforce 0
yum install mod_wsgi python-webpy
/etc/httpd/conf/httpd.conf
WSGIScriptAlias
chcon -R httpd_user_content_t patron-load
setsebool -P httpd_can_connect_ldap=1
Unmarshal
xml.Decoder
ioutil.FileRead
go fmt <filename>
items
user/dbs/openlibrary-read-api
OpenLibraryLinks
result_common.js
Cache-control
Shift
Refresh
Reload
make package
marc_record_001.phpt
<?phprequire 'File/MARC.php';$marc = new File_MARC_Record();$marc->appendField(new File_MARC_Data_Field('100', array(        new File_MARC_Subfield('a', 'Doe, John'),    ), null, null));$marc->appendField(new File_MARC_Data_Field('245', array(        new File_MARC_Subfield('a', 'Main title: '),        new File_MARC_Subfield('b', 'subtitle'),        new File_MARC_Subfield('c', 'author')    ), null, null));print "Yes, we do pretty print\n";print $marc . "\n";print "Yes, we write MARC21";$fh = fopen('marcy.mrc', 'w');fwrite($fh, $marc->toRaw());fclose($fh);print "... written.\n\n";print "Yes, we write MARCXML\n";print $marc->toXML() . "\n\n";print "Yes, we write MARC-in-JSON\n";print $marc->toJSON() . "\n\n";print "Yes, we even write the MARC-HASH JSON serialization\n";print $marc->toJSONHash() . "\n\n";?>

bash$ $ php marcy.php Yes, we do pretty printLDR                         100    _aDoe, John245    _aMain title:        _bsubtitle       _cauthorYes, we write MARC21... written.Yes, we write MARCXML<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"> <record>  <leader>00099na   2200049   4500  <datafield tag="100" ind1=" " ind2=" ">   <subfield code="a">Doe, John  </datafield>  <datafield tag="245" ind1=" " ind2=" ">   <subfield code="a">Main title:    <subfield code="b">subtitle   <subfield code="c">author  </datafield> </record></collection>Yes, we write MARC-in-JSON{"leader":"00099     2200049   4500","fields":[  {"100":{"ind1":" ","ind2":" ","subfields":[    {"a":"Doe, John"}]}},  {"245":{"ind1":" ","ind2":" ","subfields":[    {"a":"Main title: "},    {"b":"subtitle"},    {"c":"author"}]}}]}Yes, we even write the MARC-HASH JSON serialization{"type":"marc-hash","version":[1,0],"leader":"00099     2200049   4500",  "fields":[    ["100"," "," ",[["a","Doe, John"]]],    ["245"," "," ",[["a","Main title: "],["b","subtitle"],["c","author"]]]]}

telnet xxx.xxx.xxx.xxx 419

xxx.xxx.xxx.xxx
419
192.168.8.23
Trying 192.168.8.23...Connected to 192.168.8.23.Escape character is '^]'.220 welcome to ftp world

Trying 192.168.8.23...Connected to 192.168.8.23.Escape character is '^]'.421 Connection RefusedConnection closed by foreign host.

Trying 192.168.8.23...telnet: Unable to connect to remote host: Connection timed out

open-ils.resolver
pear install File_MARC-beta
asset.call_number_classification
asset.call_number_classification
asset.call_number_classification
0
0
0
/opac/extras/browse
/opac/extras/startwith
0
subfield
SELECT rsr.id, rsr.title   FROM metabib.full_rec mfr    INNER JOIN metabib.rec_descriptor mrd ON mfr.record = mrd.record    INNER JOIN asset.call_number acn ON acn.record = mrd.record    INNER JOIN reporter.super_simple_record rsr ON rsr.id = mrd.record    INNER JOIN actor.org_unit aou ON aou.id = acn.owning_lib  WHERE mfr.tag = '260'     AND mfr.subfield = 'b'    AND mfr.value ilike 'Human Kinetics%'    AND mrd.bib_level = 's'    AND aou.shortname = 'OSUL';

CREATE TABLE scratchpad.urls_to_delete (id BIGINT);INSERT INTO scratchpad.urls_to_delete   SELECT acn.record    FROM asset.uri au      INNER JOIN asset.uri_call_number_map aucnm ON au.id = aucnm.uri      INNER JOIN asset.call_number acn ON aucnm.call_number = acn.id      INNER JOIN actor.org_unit aou ON acn.owning_lib = aou.id    WHERE au.href ILIKE '%/search.ebscohost.com/direct.asp?db=rch%'      AND aou.shortname = 'OSUL';BEGIN; UPDATE biblio.record_entry  SET marc = regexp_replace(    marc,    E'<datafield tag="856" ind1="4" ind2="0"><subfield code="z">Available online from Ebsco.*?search.ebscohost.com/direct.asp\\?db=rch.*?</datafield>',    ''  )  WHERE id IN (SELECT id FROM scratchpad.urls_to_delete);

python-qt4-dbus
RuntimeError: To make asynchronous calls, receive signals or export objects, D-Bus connections must be attached to a main loop by passing mainloop=... to the constructor or calling dbus.set_default_main_loop(...)
liveusb/gui.py
if not self.parent.opts.noverify:                # Verify the MD5 checksum inside of the ISO image                # if not self.live.verify_iso_md5():                #    return

python-parted
command="/bin/false",no-port-forwarding,no-agent-forwarding,permitopen="carbon:6001" <key-type> <key> <name>

ssh -f -N -L 6001:carbon.example.com:6001 sipuser@sip.example.com

C:\cygwin\bin\run.exe -p /bin ssh -f -N -L 6001:carbon.example.com:6001 sipuser@sip.example.com

search.relevance_ranking
full_match
first_word
word_order
config.metabib_field
search.relevance_adjustment
-- Clone the title|proper index to create a keyword|title index-- 6 = the title|proper indexINSERT INTO config.metabib_field (field_class, name, xpath, weight, format, search_field, facet_field)  SELECT 'keyword', 'title', xpath, weight, format, search_field, facet_field    FROM config.metabib_field    WHERE id = 6;-- Populate the keyword|title index with a set of index entries cloned-- from the metabib.title_field_entry table;-- 6 = the title|proper indexINSERT INTO metabib.keyword_field_entry (source, field, value)  SELECT source, 17, value    FROM metabib.title_field_entry    WHERE field = 6;-- Bump the relevance when the first search term appears first in the title in a keyword search-- 17 = our new keyword|title indexINSERT INTO search.relevance_adjustment (active, field, bump_type, multiplier)   VALUES (true, 17, 'first_word', 5);

first_word
word_order
keyword|title
keyword|title
keyword|keyword
-- Boost the relevance for search terms appearing in the title in general-- 17 = our new keyword|title indexUPDATE config.metabib_field  SET weight = 10  WHERE id = 17;

author
title
series
subject
keyword
keyword
title
abbreviated
//mods32:mods/mods32:titleInfo[mods32:title and (@type='abbreviated')]
translated
//mods32:mods/mods32:titleInfo[mods32:title and (@type='translated')]
alternative
//mods32:mods/mods32:titleInfo[mods32:title and (@type='alternative')]
uniform
//mods32:mods/mods32:titleInfo[mods32:title and (@type='uniform')]
proper
//mods32:mods/mods32:titleInfo[mods32:title and (@type='proper')]
|
title|uniform: canada
SELECT * FROM config.metabib_field;

a
config.metabib_field
INSERT INTO config.metabib_field (field_class, name, xpath, weight, format, search_field, facet_field)  VALUES ('keyword', 'identifier',     '//marcxml:datafield[@tag="010" or @tag="020" or @tag="022"]/marcxml:subfield[@code="a"]',     1, 'marcxml', true, false);

open-ils.storage
open-ils.ingest
osrf_ctl.sh -a restart_perl
opensrf-perl.pl
metabib.full_rec
-- Get the ID from the row that you just inserted for the new index;-- we'll use this in the INSERT statementSELECT id   FROM config.metabib_field  WHERE field_class = 'keyword' AND name = 'identifier';-- Let's say the ID was 18; we'll use that to identify the index in the SELECT statementINSERT INTO metabib.keyword_field_entry (field, source, value)  SELECT 18, record, agg_text(value)   FROM metabib.full_rec  WHERE tag IN ('010', '020', '022')  AND subfield = 'a'  GROUP BY 1, 2;

keyword|identifier: some_identifier
/openils/lib/perl5/OpenILS/Application/SuperCat.pm
--- old/OpenILS/WWW/SuperCat.pm        2010-03-09 17:26:20.000000000 -0500+++ new/OpenILS/WWW/SuperCat.pm     2010-03-10 00:11:58.000000000 -0500@@ -1410,6 +1410,7 @@     'bib.titlealternative'  => 'title',     'bib.titleseries'       => 'series',     'eg.series'             => 'title',+    'eg.identifier'             => 'keyword|identifier',      # Author/Name class:     'eg.author'             => 'author',@@ -1438,7 +1439,7 @@     'srw.serverchoice'      => 'keyword',      # Identifiers:-    'dc.identifier'         => 'keyword',+    'dc.identifier'         => 'keyword|identifier',      # Dates:     'bib.dateissued'        => undef,@@ -1497,6 +1498,7 @@                        subject         => ['subject'],                        keyword         => ['keyword'],                        series          => ['series'],+                       identifier      => ['keyword|identifier'],                },                dc => {                        title           => ['title'],@@ -1504,7 +1506,7 @@                        contributor     => ['author'],                        publisher       => ['keyword'],                        subject         => ['subject'],-                       identifier      => ['keyword'],+                       identifier      => ['keyword|identifier'],                        type            => [undef],                        format          => [undef],                        language        => ['lang'],

eg.identifier
dc.identifier
keyword|identifier
/etc/init.d/apache reload
eg.identifier
<database name="FOOBAR">     <zurl>http://localhost/opac/extras/sru/FOOBAR/holdings</zurl>     <option name="sru">get</option>     <charset>marc-8</charset>     <search>       <querytype>cql</querytype>       <map use="4"><index>eg.title</index></map>       <map use="7"><index>eg.identifier</index></map>       <map use="8"><index>eg.identifier</index></map>       <map use="9"><index>eg.identifier</index></map>       <map use="21"><index>eg.subject</index></map>       <map use="1003"><index>eg.creator</index></map>       <map use="1018"><index>eg.publisher</index></map>       <map use="1035"><index>eg.keyword</index></map>       <map use="1016"><index>eg.keyword</index></map>     </search>   </database>

if (defined($ISSN)) {    $searchString .= "keyword|identifier: $ISSN";  }   elsif (defined($ISBN)) {    $ISBN =~ s/-//g; # Most of our ISBNs are normalized to no hyphens    $searchString .= "keyword|identifier: $ISBN";  }

pg_dump --data-only --table config.z3950_source --table config.z3950_attr evergreen > config_z3950.sql

psql
BEGIN;\i config_z3950.sqlCOMMIT;

config.z3950_attr
1
/openils/var/web/xul/server/cat/z3950.js
CREATE TABLE scratchpad.osul_export (record BIGINT); INSERT INTO scratchpad.osul_export   SELECT record FROM (    SELECT DISTINCT ON (mrd.item_type, mrd.item_form, mrd.bib_level, mrd.lit_form, mrd.cat_form, mrd.vr_format)         mrd.record, mrd.item_type, mrd.item_form, mrd.bib_level, mrd.lit_form, mrd.cat_form, mrd.vr_format     FROM biblio.record_entry bre       INNER JOIN asset.call_number acn ON acn.record = bre.id       INNER JOIN asset.copy ac ON ac.call_number = acn.id      INNER JOIN metabib.rec_descriptor mrd ON mrd.record = bre.id     WHERE bre.deleted IS FALSE AND acn.deleted IS FALSE AND ac.deleted IS FALSE AND acn.owning_lib = 103    ORDER BY mrd.item_type, mrd.item_form, mrd.bib_level, mrd.lit_form, mrd.cat_form, mrd.vr_format  ) AS formats  ORDER BY record;

INSERT INTO scratchpad.osul_export  SELECT bre.id   FROM biblio.record_entry bre    INNER JOIN asset.call_number acn ON acn.record = bre.id    INNER JOIN asset.copy ac ON ac.call_number = acn.id    INNER JOIN reporter.super_simple_record rsr ON rsr.id = bre.id  WHERE bre.deleted IS FALSE AND acn.deleted IS FALSE AND ac.deleted IS FALSE AND acn.owning_lib = 103    AND bre.id NOT IN (      SELECT record        FROM scratchpad.osul_export    ) AND substring(bre.id::text from (length(bre.id::text)) for 1)::int = 8    AND bre.id % 17 = 0  ORDER BY rsr.author DESC  LIMIT 1800;

scratchpad.osul_export
Open-ILS/src/support-scripts/marc_export
PKG_CHECK_MODULES()
configure.ac
PKG_CHECK_MODULES syntax error near unexpected token 'DEPS,'
pkg-config
pg_dump
pg_dump --no-owner --schema-only --table biblio.record_entry \    --table serial.record_entry evergreen > bre_sre_schema.dump

psql -f bre_sre_schema.ddl -d periodicals

pg_dump --no-owner --data-only --table biblio.record_entry \    --table serial.record_entry evergreen \    > bre_sre_data.ddl

psql -f bre_sre_data.dump -d periodicals

ALTER TABLE biblio.record_entry     ALTER COLUMN marc     SET DATA TYPE XML USING marc::XML;

holdings.conifer
xpath()
unnest()
CREATE TABLE holdings.conifer (    record BIGINT,     issn TEXT,     coverage TEXT,     call_number TEXT);INSERT INTO holdings.conifer (record, issn)    SELECT bre.id, UNNEST(XPATH('//*[local-name()="datafield"][@tag="022"]' ||            '/*[local-name()="subfield"][@code="a"]/text()', bre.marc))        FROM biblio.record_entry bre INNER JOIN serial.record_entry sre        ON sre.record = bre.id        WHERE sre.owning_lib = 103;

asset.call_number
UPDATE holdings.conifer     SET call_number = UNNEST(      XPATH(        '//*[local-name()="datafield"][@tag="852"]/' ||            '*[local-name()="subfield"][@code="h"]/text()',         (            SELECT sre.marc::xml            FROM serial.record_entry sre              INNER JOIN holdings.conifer hc ON hc.record = sre.record            WHERE hc.record = holdings.conifer.record            LIMIT 1        )      )    );

Open-ILS/src/perlmods/OpenILS/Utils/MFHD/*
/usr/local/share/perl/5.10.0
OpenILS::Utils::MFHD::*
CREATE OR REPLACE FUNCTION holdings.parse_mfhd ( xml TEXT ) RETURNS TEXT AS $_$    use MARC::Record;    use MARC::File::XML;    use MFHD;    my $xml = shift;    my $text;    my $captions;    my $marc = MARC::Record->new_from_xml( $xml );    my $mfhd = MFHD->new($marc);    foreach my $field ($marc->field('866')) {        my $holdings = $field->subfield('a');        if ($holdings) {            my $public_note = $field->subfield('z');            if ($public_note) {                $text .= "$holdings - $public_note";            } else {                $text .= "$holdings";            }        }    }    foreach my $cap_id ($mfhd->captions('853')) {        my @curr_holdings = $mfhd->holdings('863', $cap_id);        next unless scalar @curr_holdings;        foreach (@curr_holdings) {            if ($captions) {                $captions .= ', ';            }            $captions .= $_->format();        }    }    if ($text and $captions) {        $text = "$text / $captions";    } else {        $text = "$text$captions";    }    return $text;$_$ LANGUAGE PLPERLU;

UPDATE holdings.conifer SET coverage = (    SELECT holdings.parse_mfhd(marc)    FROM serial.record_entry    WHERE serial.record_entry.record = holdings.conifer.record    LIMIT 1);

CREATE OR REPLACE FUNCTION holdings.print_coverage(marc_record BIGINT)    RETURNS TEXT AS $$    DECLARE         r RECORD;        coverage TEXT;    BEGIN        -- If coverage is NULL to begin with, then concatenating to it results in NULL        coverage := '';        -- RAISE NOTICE 'marc_record = %', marc_record;        -- Loop over the serial records attached to the targeted bib record        FOR r IN SELECT marc FROM serial.record_entry             WHERE record = marc_record            ORDER BY id        LOOP            coverage := coverage || holdings.parse_mfhd(r.marc);            -- RAISE NOTICE 'r.marc = %', r.marc;        END LOOP;        -- RAISE NOTICE 'coverage = %', coverage;        RETURN coverage;    END$$ LANGUAGE 'plpgsql';

UPDATE holdings.conifer SET coverage = (    SELECT holdings.print_coverage(record)        FROM serial.record_entry        WHERE serial.record_entry.record = holdings.conifer.record        LIMIT 1    );

-- Set the display to expanded format for easy reading\x-- Basic report for perusalSELECT hsfx.issn AS "ISSN", hsfx.title AS "Title",        hsfx.collection AS "SFX Collection",        hsfx.coverage AS "Electronic Coverage",        hc.coverage AS "Print Coverage", hc.call_number AS "Call Number"    FROM holdings.sfx hsfx        INNER JOIN holdings.conifer hc ON hsfx.issn = hc.issn    WHERE (hsfx.collection ILIKE '%JStor%' OR hsfx.collection LIKE '%Scholars%')        AND hc.coverage > ''    LIMIT 5;

-[ RECORD 1 ]-------+--------------------------------------------------------------------------ISSN                | 0142-2774Title               | Journal of Occupational BehaviorSFX Collection      | JSTOR Arts and Sciences 4Electronic Coverage | Available from 1980 until 1987. Print Coverage      | Vol. 1 No.  - Vol. 8 No. 4 (1980-1987)Call Number         | DESM-PER-[ RECORD 2 ]-------+--------------------------------------------------------------------------ISSN                | 0741-6261Title               | The Rand Journal of EconomicsSFX Collection      | JSTOR Arts and Sciences 2Electronic Coverage | Available from 1984 until 2006. Print Coverage      | V.17 (1986) - v.23 (1992)Call Number         | DESM-PER-[ RECORD 3 ]-------+--------------------------------------------------------------------------ISSN                | 0002-8614Title               | Journal of the American Geriatrics SocietySFX Collection      | Scholars PortalElectronic Coverage | Available from 2001 volume: 49 issue: 1 until 2009 volume: 57 issue: 10. Print Coverage      | Vol. 1 - 37 (1953-1989)Call Number         | DESM-PER-[ RECORD 4 ]-------+--------------------------------------------------------------------------ISSN                | 0023-7639Title               | Land EconomicsSFX Collection      | JSTOR Arts and Sciences 7Electronic Coverage | Available from 1948 until 2005. Print Coverage      | v.62 (1986) - v.68 (1992)Call Number         | DESM-PER-[ RECORD 5 ]-------+--------------------------------------------------------------------------ISSN                | 0090-2616Title               | Organizational dynamicsSFX Collection      | Scholars PortalElectronic Coverage | Available from 1995 volume: 23 issue: 3 until 2009 volume: 38 issue: 3. Print Coverage      | Vol. 15 No.  - Vol. 23 No. 5 (Summer 1986-Spring 1995)Call Number         | DESM-PER

-- Set delimiter to TAB (CTRL-V )\f '^V'-- Set the output to being unaligned\a-- Dump the output to a file\o /tmp/periodicals.tsv-- Generate URLs for quick catalogue lookupsSELECT 'http://laurentian.concat.ca/opac/en-CA/skin/lul/xml/rdetail.xml?r='             || hc.record || '&l=105&d=1' AS "URL",        hsfx.issn AS "ISSN", hsfx.title AS "Title",        hsfx.collection AS "SFX Collection",        hsfx.coverage AS "Electronic Coverage", hc.coverage AS "Print Coverage",        hc.call_number AS "Call Number"    FROM holdings.sfx_complete hsfx        INNER JOIN holdings.conifer hc ON hsfx.issn = hc.issn    WHERE (hsfx.collection ILIKE '%JStor%' OR hsfx.collection LIKE '%Scholars%')        AND hc.coverage > '';

serial.bib_summary
serial.record_entry
:%s/^I^I/^I\\N^I/g:%s/^I^I/^I\\N^I/g:%s/^I$/^I\\N/

-- I don't want a huge scrolling list of errors if there's something wrong in the dataSET ON_ERROR_STOP = 1;-- I typically get something wrong the first time, so this avoids having to manually-- drop and re-rcreate the schema the second and subsequent timesDROP SCHEMA IF EXISTS holdings CASCADE;-- This is PostgreSQL, so we can use schemas. Yay!CREATE SCHEMA holdings;-- Note that I have no idea what many of these fields are, and frankly don't careCREATE TABLE holdings.sfx (title_key TEXT, title TEXT, misc1 TEXT, issn TEXT,     ejournal_id TEXT, collection TEXT, coverage TEXT, eissn TEXT, complete_title TEXT,     target TEXT, misc2 TEXT, misc3 TEXT, misc4 TEXT, misc5 TEXT, misc6 TEXT,     misc7 TEXT, misc8 TEXT, target_parser TEXT, target_id BIGINT, service_id BIGINT,     misc_id BIGINT, category TEXT, misc9 TEXT, misc10 TEXT, misc11 TEXT,     publisher TEXT, pub_place TEXT, pub_date TEXT, item_type TEXT, active TEXT,     misc12 TEXT, misc13 TEXT, misc14 TEXT, language TEXT, title2 TEXT, misc15 TEXT);-- The COPY command bulk-loads the data from the subsequent lines into the tableCOPY holdings.sfx (title_key, title, misc1, issn, ejournal_id, collection, coverage, eissn,     complete_title, target, misc2, misc3, misc4, misc5, misc6, misc7, misc8, target_parser,     target_id, service_id, misc_id, category, misc9, misc10, misc11, publisher, pub_place,     pub_date, item_type, active, misc12, misc13, misc14, language, title2, misc15) FROM STDIN;-- All of the TXT data follows

psql -f datafile.txt -d holdings

-- Create indexes on the ISSN and E-ISSNCREATE INDEX holdings_sfx_issn_idx ON holdings.sfx(issn);CREATE INDEX holdings_sfx_eissn_idx ON holdings.sfx(eissn);-- Create index on the collection, because we'll limit some queries on this basisCREATE INDEX holdings_sfx_collection_idx ON holdings.sfx(collection);-- Update the statistics on the tableANALYZE;

sudo aptitude install nginx
/etc/nginx/sites-available/evergreen
/etc/nginx/sites-enabled/evergreen
/etc/apache2/ports.conf
/etc/apache2/eg_vhost.conf
package Parsers::TargetParser::Evergreen::Conifer;use Parsers::TargetParser;use base qw(Parsers::TargetParser);use strict;sub getHolding {  my ($this,$genRequestObj) = @_;    my $objectType = $genRequestObj->{'objectType'};  my $ISBN = $genRequestObj->{'ISBN'};  my $eISBN = $genRequestObj->{'eISBN'};  my $ISSN = $genRequestObj->{'ISSN'};  my $eISSN = $genRequestObj->{'eISSN'};  my $CODEN = $genRequestObj->{'CODEN'};  my $bookTitle = $genRequestObj->{'bookTitle'};  my $journalTitle = $genRequestObj->{'journalTitle'};  # Canonical search results URL for simple searches:  # http://laurentian.concat.ca/opac/en-CA/skin/lul/xml/rresult.xml?rt=keyword&tp=keyword&t=0895-2779&l=105&d=2&f=&av=  my $svc = $this->{svc};  my $egHost = $svc->parse_param('eg_host');  my $egLocale = $svc->parse_param('eg_locale');  my $egSkin = $svc->parse_param('eg_skin');  my $egOrgUnit = $svc->parse_param('eg_org_unit');  my $egDepth = $svc->parse_param('eg_depth');  my $path = "http://${egHost}/opac/${egLocale}/skin/${egSkin}/xml/rresult.xml?l=${egOrgUnit}&d=${egDepth}";  my $searchString = '&rt=keyword&tp=keyword&t=';  if (defined($ISSN)) {    if ($ISSN =~ m/x/i) {      # Current indexer doesn't deal well with ISSNs containing an X, so break it up      $ISSN =~ s/^(\d{4})-?(\d+)x/$1 -$2 x/i;      $searchString .= $ISSN;    } else {      $searchString .= "\"$ISSN\"";      # format 9999-9999 for MARC    }  }   elsif (defined($ISBN)) {    # Evergreen doesn't force ISBNs to be stripped of hyphens, so take whatever    $searchString .= "\"$ISBN\"";  }  elsif (defined($journalTitle)) {    # Restrict searches to title index, with bibliographic level = s    $searchString .= "ti:${journalTitle}&bl=s";  }  elsif (defined($bookTitle)) {    # Restrict searches to title index, with bibliographic level = m    $searchString .= "ti:${bookTitle}&bl=m";  }  return ($path . $searchString);}1;

conifer=# SELECT aou.name, count(au.id)
FROM actor.org_unit aou
INNER JOIN actor.usr au
ON aou.id = au.home_ou
GROUP BY aou.name
ORDER BY 2 DESC;

name                                       | count
-------------------------------------------+-------
Leddy Library                              | 19468
J.N. Desmarais Library                     | 11921
Algoma University, Wishart Library         |  2431
University of Sudbury                      |  1100
Hearst, Bibliothèque Maurice-Saulnier      |  1043
Huntington College Library                 |   834
Paul Martin Law Library                    |   592
Northern Ontario School of Medicine (West) |   284
HRSRH Health Sciences Library              |   261
Northern Ontario School of Medicine (East) |   224
Xstrata Process Support Centre Library     |   122
NOHIN                                      |   121
Instructional Media Centre                 |     9
Laboratoire de didactiques, E.S.E.         |     7
Vale Inco                                  |     4
Mines Library, Willet Green Miller Centre  |     2
Art Gallery of Sudbury                     |     1
Curriculum Resource Centre                 |     1
Sault Area Hospital                        |     1
Centre Franco-Ontarien de Folklore         |     1
Conifer                                    |     1
(21 rows)

conifer=# SELECT aou.name, count(ac.barcode)
FROM actor.org_unit aou
INNER JOIN asset.copy ac
ON aou.id = ac.circ_lib
GROUP BY aou.name
ORDER BY 2 DESC;

name                                       |  count
-------------------------------------------+---------
Leddy Library                              | 1373197
J.N. Desmarais Library                     |  614380
Paul Martin Law Library                    |  229391
Algoma University, Wishart Library         |  115156
University of Sudbury                      |   42154
Hearst, Bibliothèque Maurice-Saulnier      |   34276
Huntington College Library                 |   12517
Laboratoire de didactiques, E.S.E.         |   10284
Mining and the Environment Database        |    9940
HRSRH Health Sciences Library              |    7512
Music Resource Centre                      |    7511
Xstrata Process Support Centre Library     |    5477
Centre Franco-Ontarien de Folklore         |    4365
Northern Ontario School of Medicine (East) |    3779
Northern Ontario School of Medicine (West) |    3301
NOHIN                                      |    2647
Mines Library, Willet Green Miller Centre  |    2617
Curriculum Resource Centre                 |    2583
Sault Area Hospital                        |    2515
Art Gallery of Sudbury                     |    2237
Hearst Timmins, Centre de Ressources       |    2202
Hearst Kapuskasing, Centre de Ressources   |    2007
Vale Inco                                  |    1106
Instructional Media Centre                 |    1095
(24 rows)

pg_dump -U evergreen --data-only --table actor.org_unit_type \    --table actor.org_unit > orgunits.sql

BEGIN;SET CONSTRAINTS ALL DEFERRED;DELETE FROM actor.org_unit;DELETE FROM actor.org_unit_type;\i orgunits.sqlCOMMIT

SELECT setval('biblio.autogen_tcn_value_seq',     (select max(id) from biblio.record_entry) + 100);SELECT setval('biblio.record_entry_id_seq',     (select max(id) from biblio.record_entry) + 100);

wget http://pypi.python.org/packages/2.4/s/setuptools/setuptools-0.6c9-py2.4.eggsudo sh setuptools-0.6c9-py2.4.eggsudo easy_install pymarc

cat holdings.lst | python marc8_to_utf8.py

python parse_unicorn.py

grep -v '|z' holdings_utf8.lst > holdings_clean.lstgrep -v '|z' holdings_clean.lst > holdings_clean.lst2mv holdings_clean.lst2 holdings_clean.lst

psql -f Open-ILS/src/extras/import/import_staging_table.sql

psql -f holdings_eg_clean.sql

SELECT item_type, COUNT(item_type)FROM staging_itemsGROUP BY item_typeORDER BY item_type; item_type  | item_count ------------+------------ ATLAS      |        162 AUDIO      |        792 AUD_VISUAL |       1790 AV         |         69 AV-EQUIP   |        182 BOOK       |        996 BOOKS      |     581592 BOOK_ART   |          1 BOOK_RARE  |       4949 BOOK_SHWK  |          5 BOOK_WEB   |      49163 COMPUTER   |         33...(40 rows)

SELECT location, COUNT(location)FROM staging_itemsGROUP BY locationORDER BY location;  location  | count  ------------+-------- ALGO-ACH   |     13 ALGO-ATLAS |    148 ALGO-AV    |   1837...(212 rows)

UPDATE staging_itemsSET item_type = 'BOOK'WHERE item_type IN ('BOOKS', 'BOOK_ART', 'BOOK_RARE', 'BOOK_SHWK', 'BOOK_WEB', 'REF-BOOK');

-- Laurentian Music Resource CentreUPDATE staging_itemsSET owning_lib = 'LUMUSIC'WHERE location = 'DESM-MRC';-- Hearst - Kapuskasing locationUPDATE staging_itemsSET owning_lib = 'KAP'WHERE location LIKE 'HRSTK%';-- Hearst - Timmins locationUPDATE staging_itemsSET owning_lib = 'TIMMINS'WHERE location LIKE 'HRSTT%';

psql -f generate_copies.sql

psql -f quick_metarecord_map.sql

-- Create a new transcendant resource; -- this autogenerates an ID of 4 in a default, untouched systemINSERT INTO config.bib_source (quality, source, transcendant)VALUES (10, 'Electronic resource', 't');-- Make the electronic full text resources (856 40) transcendant-- by setting their bib record source to the new bib_source value of 4UPDATE biblio.record_entry SET source = 4 WHERE id IN (    SELECT DISTINCT(record)     FROM metabib.full_rec     WHERE tag = '856' AND ind1 = '4' AND ind2 = '0');

dbs@dbs-laptop:~/source/Evergreen-rel_1_4$ svn diff Open-ILS/src/perlmods/Index: Open-ILS/src/perlmods/OpenILS/Application/SuperCat.pm===================================================================--- Open-ILS/src/perlmods/OpenILS/Application/SuperCat.pm   (revision 11952)+++ Open-ILS/src/perlmods/OpenILS/Application/SuperCat.pm    (working copy)@@ -143,6 +143,18 @@    # and stash a transformer    $record_xslt{rss2}{xslt} = $_xslt->parse_stylesheet( $rss_xslt ); +   # parse the FGDC xslt ...+   my $fgdc_xslt = $_parser->parse_file(+       OpenSRF::Utils::SettingsClient+          ->new+           ->config_value( dirs => 'xsl' ).+        "/MARC21slim2FGDC.xsl"+  );+  # and stash a transformer+   $record_xslt{fgdc}{xslt} = $_xslt->parse_stylesheet( $fgdc_xslt );+  $record_xslt{fgdc}{docs} = 'http://www.fgdc.gov/metadata/csdgm/index_html';+ $record_xslt{fgdc}{schema_location} = 'http://www.fgdc.gov/metadata/fgdc-std-001-1998.xsd';+  register_record_transforms();     return 1;

{   "status" : 200,   "payload" : [      [         {            "__c" : "ccs",            "__p" : [               null, null, null, "f", 3, "Lost", "f"            ]         },         {            "__c" : "ccs",            "__p" : [               null, null, null, "t", 0, "Available", "t"            ]         },         {            "__c" : "ccs",            "__p" : [               null, null, null, "t", 1, "Checked out", "t"            ]         },         {            "__c" : "ccs",            "__p" : [               null, null, null, "f", 2, "Bindery", "t"            ]         }      ]   ]}

{   "status" : 200,   "payload" : [      [         [            "127",            "663.42 JACKSON, MICHAEL",            {               "0" : 1            }         ],         [            "130",            "663.42 JACKSON, MICHAEL",            {               "0" : 1            }         ],         [            "125",            "663.42 JACKSON, MICHAEL",            {               "0" : 1            }         ],         [            "34",            "R 641.23 JACKSON, MICHAEL",            {               "0" : 1            }         ]      ]   ]}

<class id="ccs" controller="open-ils.cstore"   oils_obj:fieldmapper="config::copy_status" oils_persist:tablename="config.copy_status">  <fields oils_persist:primary="id" oils_persist:sequence="config.copy_status_id_seq">    <field name="isnew" oils_obj:array_position="0" oils_persist:virtual="true" />    <field name="ischanged" oils_obj:array_position="1" oils_persist:virtual="true" />    <field name="isdeleted" oils_obj:array_position="2" oils_persist:virtual="true" />    <field name="holdable" oils_obj:array_position="3"       oils_persist:virtual="false" reporter:datatype="bool"/>    <field name="id" oils_obj:array_position="4"       oils_persist:virtual="false" reporter:selector="name" reporter:datatype="id"/>    <field name="name" oils_obj:array_position="5"       oils_persist:virtual="false"  reporter:datatype="text" oils_persist:i18n="true"/>    <field name="opac_visible" oils_obj:array_position="6"       oils_persist:virtual="false" reporter:datatype="bool"/>  </fields>

bash$ srfshsrfsh# introspect open-ils.search... (truncated for legibility) ...Received Data: {  "__c":"OpenILS_Application",  "__p":{    "api_level":1,    "stream":0,    "object_hint":"OpenILS_Application_Search_Biblio",    "package":"OpenILS::Application::Search::Biblio",    "remote":0,    "api_name":"open-ils.search.biblio.copy_counts.summary.retrieve",    "signature":{      "params":[              ],      "desc":"returns an array of these: [         org_id,         callnumber_label,         ,         ,        ...      ]       where statusx is a copy status name.  the statuses are sorted by id.",      "return":{        "desc":null,        "type":null,        "class":null      }          },    "server_class":"open-ils.search",    "notes":"\treturns an array of these:\n\t\t[       org_id,       callnumber_label,       ,       ,      ...    ]    \n\t\twhere statusx is a copy status name.  the statuses are sorted\n\t\tby id.\n",    "method":"copy_count_summary",    "argc":0  }

{   "status" : 200,   "payload" : [      [         [            "125",            "663.42 JACKSON, MICHAEL",            {               "0" : 1            }         ]      ]   ]}

curl -d service=open-ils.search   -d locale=en-US \  -d method=open-ils.search.biblio.copy_counts.summary.retrieve \  -d param=8526 -d param=1 -d param=0 \  http://dev.gapines.org/osrf-gateway-v1 | json_xs -t json-pretty

5 ∗/4 ∗ ∗ ∗ rm -fr /home/dan/.macromedia/Flash_Player/#SharedObjects 5 ∗/4 ∗ ∗ ∗ rm -fr /home/dan/.macromedia/Flash_Player/macromedia.com/support/flashplayer/sys/

evergreen=# SELECT relfilenode, relname, relpagesevergreen-# FROM pg_class WHERE relname LIKE '%vector%'; relfilenode |                   relname                    | relpages -------------+----------------------------------------------+----------      648864 | authority_full_rec_index_vector_idx          |    59282      649137 | metabib_title_field_entry_index_vector_idx   |    29766      649149 | metabib_author_field_entry_index_vector_idx  |    20125      649161 | metabib_subject_field_entry_index_vector_idx |    23481      649173 | metabib_keyword_field_entry_index_vector_idx |    90709      649185 | metabib_series_field_entry_index_vector_idx  |     8682      649210 | metabib_full_rec_index_vector_idx            |   452980(7 rows)

# cd /var/lib/postgresql/main/base/16385# du -hs 649185* 649210* 1065608*68M 6491851.1G   6492101.1G   649210.11.1G 649210.21.1G 10656081.1G  1065608.11.1G    1065608.2842M    1065608.3# du -hs 649207*1.1G 6492071.1G   649207.11.1G 649207.2467M 649207.3

# cd /var/lib/postgresql/main/base/16385# cat 648864* > /dev/null# cat 649137* > /dev/null# cat 649149* > /dev/null# cat 649161* > /dev/null# cat 649173* > /dev/null# cat 649185* > /dev/null# cat 649210* > /dev/null

# - Memory -#shared_buffers = 1000                  # min 16 or max_connections*2, 8KB each#temp_buffers = 1000                    # min 100, 8KB each#max_prepared_transactions = 5          # can be 0 or more# note: increasing max_prepared_transactions costs ~600 bytes of shared memory# per transaction slot, plus lock space (see max_locks_per_transaction).#work_mem = 1024                        # min 64, size in KB#maintenance_work_mem = 16384           # min 1024, size in KB#max_stack_depth = 2048                 # min 100, size in KB# - Free Space Map -#max_fsm_pages = 20000                  # min max_fsm_relations*16, 6 bytes each#max_fsm_relations = 1000               # min 100, ~70 bytes each

# shared_buffers: much of our performance depends on sorting, so we'll set it 100X the default# some tuning guides suggest cranking this up to as much 30% of your available RAMshared_buffers = 100000 # 8K * 100000 = ~ 0.8 GB# work_mem: how much RAM each concurrent process is allowed to claim before swapping to disk# your workload will probably have a large number of concurrent processeswork_mem=524288 # 512 MB# max_fsm_pages: increased because PostgreSQL demanded itmax_fsm_pages = 200000

sysctl -w kernel.shmmax=8589934592

# Set SHMMAX to 8GB for PostgreSQL#kernel.shmmax=8589934592

# -- in /etc/sysctl.conf --# Set SHMMAX to 8GB for PostgreSQLkernel.shmmax=8589934592

# -- in /etc/postgresql/8.1/main/postgresql.conf --# Crank up shared_buffers and work_memshared_buffers = 10000work_mem=8388608 # 8 GB, equal to our kernel.shmmaxmax_fsm_pages = 200000

20-odd library folk from various libraries8 vendor presentations~4 hours per presentation= 640 person-hours

#code4lib
ext/filter
magic_quotes
register_globals
include
register_globals
register_globals
magic_quotes
/db/
cannot open root device or unknown block
pear install File_MARC-alpha

500 - Internal Server Error
__destruct()
file()
stream_get_line()
const END_OF_RECORD = "\x1D";const MAX_RECORD_LENGTH = 99999;...$this->source = fopen($source, 'rb');...$record = stream_get_line($source, MAX_RECORD_LENGTH, END_OF_RECORD);

<link rel="alternate" type="application/rss+xml" title="RSS feed"    href="http://blogname.diaryland.com/index.rss" />

http://blogname.diaryland.com/index.rss

During current Hold'em session you were dealt 58 hands and saw flop: - 2 out of 7 times while in big blind (28%) - 1 out of 9 times while in small blind (11%) - 4 out of 42 times in other positions (9%) - a total of 7 out of 58 (12%) Pots won at showdown - 2 of 4 (50%) Pots won without showdown - 4

db2: error while loading shared libraries: libibmc++.so.1:   cannot open shared object file: No such file or directory

p {  margin-top: 1em;  padding-top: 1em;}

[Edited 2006-01-03 for markup and typo]

localhost php4 # ls -l /opt/photos/db2base -ddrwxrwxrwx  3 dan db2iadm1 72 Oct 18 10:35 /opt/photos/db2base

fdisk /mbr
fdisk /mbr
expand F:\i386\DHCPCSVC.DL_ DHCPCSVC.DLL

Property	Value
instance of	public library, academic library, college library, research library, library
country	Canada
official website	URL for the general website for the library--not the catalogue
inception	Date the library was founded

Property	Value
stated in	Link to the Wikidata item for the journal, newspaper, or other media source.
title	Title of the article
reference URL	If the article is online, provide the complete URL
publication date	Date the article was published
retrieved	Date that you retrieved the article

Property	Value
coordinate location	You can enter coordinates in a variety of latitude/longitude forms. If you do not know the coordinates of the library, try finding it in OpenStreetMap: Open https://www.openstreetmap.org and search for the name of the library Select the library from the results Right-click the library on the map and select Show address. The coordinates will be displayed. Copy and paste the coordinates into the Wikidata values field. You can also try finding the coordinates via Google Maps through https://www.maps.ie/coordinates.html
located at street address	Full street address, including postal code
located in the administrative territorial entity	City or town
phone number	Format: +1-416-555-5555
email	Format: mailto:example.user@example.com

Property	Value
collection or exhibition size	# of items in the collection
visitors per year	# of people that come through the gates

Property	Value
catalog	Link to the Wikidata item (instance of "online public access catalog") that describes the library catalogue
image	Link to an image in Wikimedia Commons
named after	Link to the Wikidata item for the library's namesake (if applicable)
parent organization	If this library is one branch of a library network, link it to the Wikidata item for the parent system
member of	Link the library to any organizations of which it is a member

Property	Value
International Standard Identifier for Libraries	The ISIL code for Canadian libraries is "CA-" followed by the LAC library symbol; for example, "CA-OSUL"
Libraries.org ID	Numeric identifier found in the https://libraries.org directory; for example, 1144
VIAF ID	The library might be included as a Corporate Name
Twitter username	If the library has a Twitter account...
Facebook	If the library has a Facebook account...
Pinterest	If the library has a Pinterest account...
Cage Match tag team ID	If your library is really into wrestling… Wait, what?

Property	Value
instance of	online public access catalog
official website	URL for the catalogue
software engine	Identifies the software on which the catalogue runs
operator	Link to the Wikidata item for the library


Date	Time	Title	Description (may be abridged)	Presenters
Thursday, January 29	9:05 am	It.s Just a Little Bit of Programming Isn.t It?	“Follow the progress of the Library @ Mohawk.s development of the open source ILS Evergreen. Hear the trials and tribulations and learn from the mistakes and successes that have occurred along the way . we are truly a learning organization on this project. We went live in summer 2008 . come and hear about where we.ve been, where we are and where we hope to be soon.”	Robert Soulliere, Systems Librarian; Cynthia Williamson, Collection & Access Librarian, Mohawk College of Applied Arts and Technology
Thursday, January 29	3:45 pm	Project Conifer: Evergreen library system for Ontario Universities	“Find out how the Evergreen open source library system, originally developed for a public library consortium, is being adapted for academic libraries by three Ontario universities. Discussion will focus on the challenges, successes and mistakes (err, .learning opportunities.) of the project.”	John Fink, Digital Technologies Development Librarian, McMaster University; Dan Scott, Systems Librarian, Laurentian University
Friday, January 30	9:05 am	Evergreen exposed: hacking the open source library system	“Join an Evergreen developer on a tour of the architecture and source code of the Evergreen library system [...] Get ready to get your hands dirty with Evergreen . this will be a session filled with code!”	William Erickson, Vice President, Software Development & Integration, Equinox Software Inc; Dan Scott, Systems Librarian, Laurentian University
Saturday, January 31	10:40 am	Multilingual Language Issues of Open Source ILS	“Discover the Chinese version of Evergreen along with various multilingual issues related MARC standards, encoding, indexing, searching, and sorting especially associated with Chinese language.”	Jason Zou, Systems Librarian, Lakehead University; Guoying (Grace) Liu, Systems Librarian, Leddy Library, University of Windsor

Coffee|Code: Dan Scott's blog

Linked Data: Introductory Resources

Introductions and overviews

Publishing linked data

Knowledge graphs

Reasoning and inferences

Linked Data for Production - 2018 Workshop

LD4P Wikidata panel

Surfacing Knowledge, Building Relationships: Indigenous Communities, ARL and Canadian Libraries

Accessing Wikidata: read and write

Wikidata in Libraries: a broader view

Discussion

LD4P day 2

OCLC embraces Wikibase

UC Davis strips it all down to URIs

Creating and editing libraries in Wikidata

Adding a library to Wikidata

Editing a library in Wikidata

Adding a reference

More library properties

Location properties

Quantifiable properties

Linking properties

Identifier properties

Adding a catalogue

Voilà - Canada's new union catalogue is anti-discovery

Voilà is not open for use

Voilà is linkless data

Voilà doesn't use authorities?

OCLC membership requirements

Domain name is worldcat.org

No social media metadata

Our nginx caching proxy setup for Evergreen

/etc/nginx/sites-enabled/evergreen.conf

/etc/nginx/concat_ssl.conf

/etc/nginx/concat_headers.conf

/etc/nginx/concat_headers.conf

Enriching catalogue pages in Evergreen with Wikidata

Wikidata, Canada 150, and music festival data

Wikidata workshop for librarians

Evergreen as a Progressive Web App?

Truly progressive WebVR apps are available offline!

Describe your app with a Web App Manifest

Create a service worker to handle offline requests

Register the service worker

Host your app with HTTPS

Check for success with Lighthouse

Check for success with your mobile web browser

Conclusion

schema.org, Wikidata, Knowledge Graph: strands of the modern semantic web

Concerns about copyright term extensions proposed for TPP

Google Scholar's broken Recaptcha hurts libraries and their users

PHP's File_MARC gets a new release (1.1.3)

Chromebooks and privacy: not always at odds

Library stories: 2020 vision: "Professional research tools"

Querying Evergreen from Google Sheets with custom functions via Apps Script

FibreOp PVR update (late 2015) causes Slingbox "Weak or no video signal" problem (SOLVED)

That survey about EZProxy

"The Librarian" - an instruction session in the style of "The Martian"

We screwed up: identities in loosely-coupled systems

Research across the Curriculum

Abstract

Preamble

Inspiration

Emphasizing the academic discussion

Library and Archives Canada: Planning for a new union catalogue

Basic question: What form does LAC envision the solution taking?

Privacy of Canadian citizens

Privacy of Canadian citizens, part 2

Open data

Contemporary features: are we achieving the stated goals?

Canadian resource visibility

Standards support (MARC21, RDA, ISO etc.)

Mobile support

Linked open data

Application programming interface (API)

Updating the NUC

Library catalogues and HTTP status codes

Dear database vendor: defending against sci-hub.org scraping is going to be very difficult

Putting the "Web" back into Semantic Web in Libraries 2014