| -- | |
| -- GEOIP IN POSTGRESQL | |
| -- | |
| -- We use two approaches. First using PostgreSQL inet and cidr types and indexing (PostgreSQL 9.4 and later), | |
| -- and then using ip4r (https://github.com/RhodiumToad/ip4r). | |
| -- The performance of ip4r indexes is significantly better than PostgreSQL's own index. | |
| -- An operation that took 42s using ip4r took 47 minutes using PostgreSQL's cidr index. | |
| -- |
| ## Sublime Text 3 Serial key build is 3176 | |
| > * Added these lines into /etc/hosts | |
| 127.0.0.1 www.sublimetext.com | |
| 127.0.0.1 license.sublimehq.com | |
| > * Used the license key | |
| ----- BEGIN LICENSE ----- |
| <?php | |
| class Craft3ValetDriver extends ValetDriver | |
| { | |
| /** | |
| * Determine if the driver serves the request. | |
| * | |
| * @param string $sitePath | |
| * @param string $siteName | |
| * @param string $uri |
| <?php | |
| if (isset($_SERVER['HTTPS']) && (strcasecmp($_SERVER['HTTPS'],'on') === 0 || $_SERVER['HTTPS'] == 1)) | |
| { | |
| $protocol = 'https://'; | |
| } | |
| else if ( ! empty($_SERVER['HTTP_X_FORWARDED_PROTO'])) | |
| { | |
| $protocol = $_SERVER['HTTP_X_FORWARDED_PROTO'] . '://'; | |
| } |
This gist assumes:
| <?xml version="1.0" encoding="utf-8"?> | |
| <service> | |
| <short>Zabbix-Agent</short> | |
| <description>Zabbix Agent listening port</description> | |
| <port protocol="tcp" port="10050" /> | |
| </service> |
| b.barracudacentral.org | |
| bl.deadbeef.com | |
| bl.emailbasura.org | |
| bl.spamcannibal.org | |
| bl.spamcop.net | |
| blackholes.five-ten-sg.com | |
| blacklist.woody.ch | |
| bogons.cymru.com | |
| cbl.abuseat.org | |
| cdl.anti-spam.org.cn |
