Skip to content

Instantly share code, notes, and snippets.

local/a52dec 0.7.4-8
A free library for decoding ATSC A/52 streams
local/aalib 1.4rc5-11
A portable ASCII art graphic library
local/abs 2.4.4-2
Utilities to download and work with the Arch Build System (ABS)
local/ack 2.14-1
A Perl-based grep replacement, aimed at programmers with large trees of heterogeneous source code
local/acl 2.2.52-2
Access control list utilities, libraries and headers
@iperdomo
iperdomo / geojson-import.log
Created July 8, 2015 13:11
CartoDB geojson import
2015-07-08 12:55:42 UTC: Running on server cartodb.akvotest.org with PID: 1372
2015-07-08 12:55:42 UTC: new_importer()
2015-07-08 12:55:42 UTC: Fetching datasource public_url metadata for item id /home/cartodb/cartodb/public/uploads/26e5519ad5a171f9b690/output.geojson
2015-07-08 12:55:42 UTC: File will be downloaded from /home/cartodb/cartodb/public/uploads/26e5519ad5a171f9b690/output.geojson
2015-07-08 12:55:42 UTC: Before importer run
2015-07-08 12:55:42 UTC: Starting import for /home/cartodb/cartodb/public/uploads/26e5519ad5a171f9b690/output.geojson
2015-07-08 12:55:42 UTC: Unpacking /home/cartodb/cartodb/public/uploads/26e5519ad5a171f9b690/output.geojson
2015-07-08 12:55:42 UTC: Filename: /tmp/imports/20150708-1372-1cwrblc/output.geojson Size (bytes): 17439
2015-07-08 12:55:42 UTC: Importing data from /tmp/imports/20150708-1372-1cwrblc/output.geojson
2015-07-08 12:55:42 UTC: File-based import load
@iperdomo
iperdomo / DataImport.txt
Last active August 29, 2015 14:24
CartoDB troubleshooting
=== DataImport["a0c970a2-b932-42d1-ac02-0d923c3d72e1"].log.entries
2015-07-07 09:53:22 UTC: Running on server cartodb.akvotest.org with PID: 25427
2015-07-07 09:53:22 UTC: new_importer()
2015-07-07 09:53:22 UTC: Fetching datasource public_url metadata for item id /home/cartodb/cartodb/public/uploads/0ab2cc5e5d4b0b72af5a/RAW_DATA-108172492.xls
2015-07-07 09:53:22 UTC: File will be downloaded from /home/cartodb/cartodb/public/uploads/0ab2cc5e5d4b0b72af5a/RAW_DATA-108172492.xls
2015-07-07 09:53:22 UTC: Before importer run
2015-07-07 09:53:22 UTC: Starting import for /home/cartodb/cartodb/public/uploads/0ab2cc5e5d4b0b72af5a/RAW_DATA-108172492.xls
2015-07-07 09:53:22 UTC: Unpacking /home/cartodb/cartodb/public/uploads/0ab2cc5e5d4b0b72af5a/RAW_DATA-108172492.xls
2015-07-07 09:53:22 UTC: Filename: /tmp/imports/20150707-25427-wlx3ax/raw_data-108172492.xls Size (bytes): 273920
@iperdomo
iperdomo / jonas.log
Created July 2, 2015 21:04
PG log 2
2015-07-02 18:54:35 CEST LOG: duration: 0.552 ms statement: SELECT * FROM "users" WHERE ("username" = 'akvoflow-3') LIMIT 1
2015-07-02 18:54:35 CEST LOG: duration: 0.179 ms statement: SELECT * FROM "users" WHERE ("id" = '1a7a9916-5913-4739-a0db-72ebcbfe3789')
2015-07-02 18:54:35 CEST LOG: duration: 0.137 ms statement: SELECT * FROM "shared_entities" WHERE (("recipient_id" IN ('1a7a9916-5913-4739-a0db-72ebcbfe3789')) AND ("entity_type" = 'vis'))
2015-07-02 18:54:35 CEST LOG: duration: 0.165 ms statement: SELECT COUNT(*) AS "count" FROM "visualizations" WHERE (("user_id" = '1a7a9916-5913-4739-a0db-72ebcbfe3789') AND ("name" = 'jonas') AND ("type" = 'table')) LIMIT 1
2015-07-02 18:54:35 CEST LOG: duration: 0.150 ms statement: SELECT * FROM "visualizations" WHERE (("user_id" = '1a7a9916-5913-4739-a0db-72ebcbfe3789') AND ("name" = 'jonas') AND ("type" = 'table')) LIMIT 300 OFFSET 0
2015-07-02 18:52:23 CEST LOG: duration: 0.410 ms statement: SELECT * FROM "users" WHERE ("username" = 'akvoflow-3') LIMIT 1
2015-07-02 18:52:23 CEST LOG: duration: 0.195 ms statement: SELECT * FROM "users" WHERE ("id" = '1a7a9916-5913-4739-a0db-72ebcbfe3789')
2015-07-02 18:52:23 CEST LOG: duration: 0.192 ms statement: SELECT * FROM "shared_entities" WHERE (("recipient_id" IN ('1a7a9916-5913-4739-a0db-72ebcbfe3789')) AND ("entity_type" = 'vis'))
2015-07-02 18:52:23 CEST LOG: duration: 0.258 ms statement: SELECT COUNT(*) AS "count" FROM "visualizations" WHERE (("user_id" = '1a7a9916-5913-4739-a0db-72ebcbfe3789') AND ("name" = 'untitled_table') AND ("type" = 'table')) LIMIT 1
2015-07-02 18:52:23 CEST LOG: duration: 0.246 ms statement: SELECT * FROM "visualizations" WHERE (("user_id" = '1a7a9916-5913-4739-a0db-72ebcbfe3789') AND ("name" = 'untitled_table') AND ("type" = 'table')) LIMIT 300 OFFSET 0
2015-07-02 18:52:23 CEST LOG: duration: 0.210 ms statement: SELECT * FROM "user_tables" WHERE ("map_id"
/*
* Copyright 2015 Google Inc. All Rights Reserved.
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
@iperdomo
iperdomo / appengine-web.xml
Created January 26, 2015 10:44
Sample Akvo FLOW appengine-web.xml
<?xml version="1.0" encoding="utf-8"?>
<appengine-web-app xmlns="http://appengine.google.com/ns/1.0">
<application>akvoflowsandbox</application>
<version>1</version>
<sessions-enabled>true</sessions-enabled>
<threadsafe>true</threadsafe>
<auto-id-policy>legacy</auto-id-policy>
<static-files>
<include path="/**.png" expiration="1000d 5h" />
<include path="/**.jpg" expiration="1000d 5h" />
@iperdomo
iperdomo / server.log
Last active August 29, 2015 14:14
Trying Akvo FLOW on CapeDwarf 2.0.0.CR5
12:27:17,742 INFO [org.jboss.modules] (main) JBoss Modules version 1.3.3.Final
12:27:17,957 INFO [org.jboss.msc] (main) JBoss MSC version 1.2.2.Final
12:27:18,029 INFO [org.jboss.as] (MSC service thread 1-6) JBAS015899: JBoss Capedwarf 2.0.0.CR5 (WildFly 8.2.0.Final) starting
12:27:18,038 DEBUG [org.jboss.as.config] (MSC service thread 1-6) Configured system properties:
[Standalone] =
awt.toolkit = sun.awt.X11.XToolkit
file.encoding = UTF-8
file.encoding.pkg = sun.io
file.separator = /
java.awt.graphicsenv = sun.awt.X11GraphicsEnvironment
@iperdomo
iperdomo / notify-gae.py
Created January 23, 2015 10:24
Small GAE notification script
#!/bin/env python
import time
import requests
base = 'https://xxx.appspot.com/processor'
with open('some-file.txt', 'r') as f:
i = 1
for line in f:
@iperdomo
iperdomo / backup.sh
Created October 21, 2014 21:23
Backup S3 data
#!/bin/bash
set -e
CFG="${1}" # akvo-flow-server-config repo clone
BKP="${2}" # backup folder
LST="/tmp/instances.txt" # list of instances
rm -rf "${LST}"