Logs — 1 entry tagged ‘x509’

→ Sadly, most of the hyperlinks on older posts are broken, or may point to a different page. That's today's web for you.

Trusting a Certificate with Keychain Access

Posted in daily on 05 Oct 2007

PHP Debug stuff

$version : Array ( [build] => 1.0 [css] => 2.96 [js] => 2.71 [plugin-js] => 2.34 [manifest] => 1.14 [pt-sans-narrow] => 17a [roboto-condensed] => 25a [site] => STAGING )

$div : Array ( [slug] => logs [separator] => | [url] => /logs )

$site : Array ( [root] => /home/clients/99e12c480b346ec84343a6e460d0caf0/dev.davidroessli.com/html [title] => David Roessli Ø Empty Set [desc] => My name is David Roessli, and I make websites on a Mac. Welcome to my personal weblog [content] => /home/clients/99e12c480b346ec84343a6e460d0caf0/dev.davidroessli.com/html/content/ [assets] => /home/clients/99e12c480b346ec84343a6e460d0caf0/dev.davidroessli.com/html/assets [config] => /home/clients/99e12c480b346ec84343a6e460d0caf0/dev.davidroessli.com/html/../config/ [logs] => /home/clients/99e12c480b346ec84343a6e460d0caf0/dev.davidroessli.com/html/../log/ [domain] => staging.davidroessli.com [protocol] => https:// [url] => https://staging.davidroessli.com )

$page : Array ( [url] => /logs/tag/x509/ [pagination] => [canonical] => https://staging.davidroessli.com/logs/ [title] => Logs and archives tagged ‘x509’ [description] => The archives of all my posts since 2000 )

Debug Message - Perch Runway 3.2
[25] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched route: logs/tag/[slug:tag]
Using master page: /templates/pages/blog/archive.php
Page arguments: Array ( [0] => /logs/tag/x509 [tag] => x509 [1] => x509 )
[33] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
Fetching from cache: perch_blog_tagdacfecb5a1413921782c67757772bafb
[1] SELECT * FROM perch3_blog_tags WHERE tagSlug='x509' LIMIT 1
Caching: perch_blog_tagdacfecb5a1413921782c67757772bafb
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl LEFT JOIN perch3_blog_posts_to_tags p2t ON tbl.postID=p2t.postID LEFT JOIN perch3_blog_tags t ON p2t.tagID=t.tagID WHERE ( tagSlug IN ('x509') AND postStatus='Published' AND postDateTime<='2025-12-31 01:59:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 100000
Using template: /templates/blog/post_minimal.html
[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
Fetching from cache: perch_blog_tagdacfecb5a1413921782c67757772bafb
[1] SELECT * FROM perch3_blog_tags WHERE tagSlug='x509' LIMIT 1
Caching: perch_blog_tagdacfecb5a1413921782c67757772bafb
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl LEFT JOIN perch3_blog_posts_to_tags p2t ON tbl.postID=p2t.postID LEFT JOIN perch3_blog_tags t ON p2t.tagID=t.tagID WHERE ( tagSlug IN ('x509') AND postStatus='Published' AND postDateTime<='2025-12-31 01:59:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 20
[1] SELECT FOUND_ROWS() AS `count`
[1] Using template: /templates/blog/post_in_list.html
[1] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC
[1] SELECT * FROM perch3_pages WHERE pagePath='/logs' LIMIT 1
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
Request time: 0.5574
Process time: 0.5571
Memory: 4.1877

Debug Message - Perch Runway 3.2

[25] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC

Matched route: logs/tag/[slug:tag]

Using master page: /templates/pages/blog/archive.php

Page arguments:

Array
(
    [0] => /logs/tag/x509
    [tag] => x509
    [1] => x509
)

[33] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0

Fetching from cache: perch_blog_tagdacfecb5a1413921782c67757772bafb

[1] SELECT * FROM perch3_blog_tags WHERE tagSlug='x509' LIMIT 1

Caching: perch_blog_tagdacfecb5a1413921782c67757772bafb

[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl LEFT JOIN perch3_blog_posts_to_tags p2t ON tbl.postID=p2t.postID LEFT JOIN perch3_blog_tags t ON p2t.tagID=t.tagID WHERE ( tagSlug IN ('x509') AND postStatus='Published' AND postDateTime<='2025-12-31 01:59:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 100000

Using template: /templates/blog/post_minimal.html

[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC

[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC

Fetching from cache: perch_blog_tagdacfecb5a1413921782c67757772bafb

[1] SELECT * FROM perch3_blog_tags WHERE tagSlug='x509' LIMIT 1

Caching: perch_blog_tagdacfecb5a1413921782c67757772bafb

[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl LEFT JOIN perch3_blog_posts_to_tags p2t ON tbl.postID=p2t.postID LEFT JOIN perch3_blog_tags t ON p2t.tagID=t.tagID WHERE ( tagSlug IN ('x509') AND postStatus='Published' AND postDateTime<='2025-12-31 01:59:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 20

[1] SELECT FOUND_ROWS() AS `count`

[1] Using template: /templates/blog/post_in_list.html

[1] SELECT * FROM perch3_categories ORDER BY catTreePosition ASC

[1] SELECT * FROM perch3_pages WHERE pagePath='/logs' LIMIT 1

Using template: /templates/pages/attributes/default.html

Using sub-template: /templates/pages/attributes/seo.html

Request time: 0.5574

Process time: 0.5571

Memory: 4.1877