i--storm
i--storm
/ db-setup.sql
Last active
April 29, 2019 16:49
— forked from gka/db-setup.sql
load geoip database into mysql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DROP TABLE IF EXISTS location; | |
| CREATE TABLE `location` ( | |
| `geoname_id` bigint(20) NOT NULL, | |
| `locale_code` varchar(5) DEFAULT NULL, | |
| `continent_code` varchar(5) DEFAULT NULL, | |
| `continent_name` varchar(50) DEFAULT NULL, | |
| `country_iso_code` varchar(5) DEFAULT NULL, | |
| `country_name` varchar(50) DEFAULT NULL, | |
| `subdivision_1_iso_code` varchar(5) DEFAULT NULL, |
i--storm
/ gelfsender.sh
Last active
January 11, 2017 10:51
— forked from gm3dmo/gelfsender.sh
Send a log message to a gelf server using the shell.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # This script can be used to raise a graylog2/gelf message | |
| # gzip it and send it to a graylog server using netcat (nc) | |
| grayloghost='000.000.000.000' #Graylog Server IP or host here | |
| hostname='gelftester' | |
| short_message='test message short version' | |
| full_message='longer test message. dont\n worry be happy' | |
| level=1 | |
| facility='gelftester' |