구차니의 잡동사니 모음

$ wget --no-check-certificate --header="Accept-Encoding: gzip" https://localhost/php_test/phpinfo.php

--2017-01-23 15:40:12--  https://localhost/php_test/phpinfo.php

Resolving localhost (localhost)... ::1, 127.0.0.1

Connecting to localhost (localhost)|::1|:443... connected.

WARNING: The certificate of ‘localhost’ is not trusted.

WARNING: The certificate of ‘localhost’ hasn't got a known issuer.

The certificate's owner does not match hostname ‘localhost’

HTTP request sent, awaiting response... 200 OK

Length: 24808 (24K) [text/html]

Saving to: ‘phpinfo.php’

phpinfo.php                  100%[===============================================>]  24.23K  --.-KB/s   in 0.007s

2017-01-23 15:40:12 (3.63 MB/s) - ‘phpinfo.php’ saved [24808/24808] 

$ file phpinfo.php

phpinfo.php: gzip compressed data, from Unix

$ sudo apt-cache search letsencrypt

$ sudo apt-get install python-letsencrypt-apache

Reading package lists... Done

Building dependency tree

Reading state information... Done

E: Unable to locate package python-letsencrypt-apache 

$ sudo apt-cache search mantis

mantis - web-based bug tracking system 

$ apt-cache show mantis

Package: mantis

Version: 1.2.11-1.2

Installed-Size: 9448

Maintainer: Silvia Alvarez <sils@powered-by-linux.com>

Architecture: all

Depends: debconf, apache2 | httpd, apache2-utils, libapache2-mod-php5 | php5-cli, libphp-adodb, libphp-phpmailer, ucf (>= 0.28), libnusoap-php, libjs-prototype, libjs-scriptaculous, debconf (>= 0.5) | debconf-2.0

Recommends: php5-mysql, mysql-client

Suggests: php5-cli, mysql-server

Size: 2209794

SHA256: 1567627701256a697dd38a95fc88fe02d4cdd0f89905fdbfa413eee640453079

SHA1: 050016bb4073dbe90bf88023bc4c252f43b3336c

MD5sum: 4dded7f3b7844774939c749f9ebb98d0

Description: web-based bug tracking system

Description-md5: ae5ff8aea61e9158d762aeafe05bdd78

Homepage: http://www.mantisbt.org

Tag: devel::bugtracker, devel::lang:sql, implemented-in::php, interface::web,

 network::server, role::program, works-with::bugs, works-with::db

Section: web

Priority: optional

Filename: pool/main/m/mantis/mantis_1.2.11-1.2_all.deb

page_id

Uniquely identifying primary key. This value is preserved across edits, renames, and, as of MediaWiki 1.27, deletions, via an analogous field in the archive table (introduced in MediaWiki 1.11). For example, for this page, page_id = 10501. [1][2] This field can be accessed by WikiPage::getId(), Title::getArticleID(), etc.

page_latest

This is a foreign key to rev_id for the current revision. It may be 0 during page creation. It needs to link to a revision with a valid revision.rev_page, or there will be the "The revision #0 of the page named 'Foo' does not exist" error when one tries to view the page. Can be obtained via WikiPage::getLatest(). 

rev_id

This field holds the primary key for each revision. page_latest is a foreign key to this field.

rev_page

This field holds a reference to the page to which this revision pertains. The number in this field is equal to the page_id field of said page. This should never be invalid; if it is, that revision won't show up in the page history. If page.page_latest links to a revision with an invalid rev_page, this will cause the "The revision #0 of the page named 'Foo' does not exist" error.

rev_text_id

This is a foreign key to old_id in the text table. (The text table is where the actual bulk text is stored.) It's possible for multiple revisions to use the same text—for instance, revisions where only metadata is altered, or where a rollback is done to a previous version. 

The text table holds the wikitext of individual page revisions. If using Postgres or Oracle, this table is named pagecontent. 

mysql> SET @s = 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';

mysql> PREPARE stmt2 FROM @s;

mysql> SET @a = 6;

mysql> SET @b = 8;

mysql> EXECUTE stmt2 USING @a, @b;

+------------+

| hypotenuse |

+------------+

|         10 |

+------------+

mysql> DEALLOCATE PREPARE stmt2;