Category Archives: Open Source

Open Source-related

OpenLayers 5.3.0 and “SyntaxError: missing : in conditional expression”

Just a PSA for Openstreetmap Openlayers 5.3.0 API users. The rawgit CDN ol.js file appears to contain a malformed ternary operation that causes browsers to not create the ol object, breaking map programs. The Firefox web console says: SyntaxError: missing … Continue reading

Posted in Open Source | Leave a comment

Perl Sample Code for Geolocation Lookups with MaxMind GeoLite2

There’s been a lot of changes with MaxMind’s GeoIP database: You must register for an account to download databases. The database format was changed from GeoIP to GeoIP2. The free databases are called GeoLite2. Older lookup APIs no longer work, … Continue reading

Posted in Open Source, Perl, Tech | Leave a comment

Meetup: New Security Features in Redis 6

Redis Labs Security Product Manager Jamie Scott talked at the Redis Meetup today about “New Security Features in Redis 6 Open Source.” Because of the Corona virus, the lecture was streamed on Youtube instead of presented to a live audience … Continue reading

Posted in Open Source, Tech, User Groups | Leave a comment

tcpdump Tips

I tend to use tcpdump when working on remote servers with multiple services running. Thus it’s important to specify exactly which hosts and ports I want to see, or end up buried in output. Here’s a canonical example of looking … Continue reading

Posted in Open Source, Tech | Leave a comment

Migrating SQLite Databases to MySQL

Recently I had to migrate a relatively simple (no FKs or views) Grafana 4 database of about 20 tables and 80,000 rows from sqlite3 to mysql5.6. Below are some notes I made on the 3 methods I tried. First up … Continue reading

Posted in MySQL, Open Source, Tech | Leave a comment