Skip to content

Instantly share code, notes, and snippets.

@eby
eby / mysqldumpsplitter.sh
Created August 27, 2014 14:41
Extract individual tables from mysqldump database SQL files
#!/bin/sh
# http://kedar.nitty-witty.com
#SPLIT DUMP FILE INTO INDIVIDUAL TABLE DUMPS
# Text color variables
txtund=$(tput sgr 0 1) # Underline
txtbld=$(tput bold) # Bold
txtred=$(tput setaf 1) # Red
txtgrn=$(tput setaf 2) # Green
txtylw=$(tput setaf 3) # Yellow
txtblu=$(tput setaf 4) # Blue
@eby
eby / nginx_auth_pam.md
Last active August 29, 2015 13:57
nginx auth_pam and satisfy any

Ran into the same issue as kvspb/nginx-auth-ldap#7 but with auth_pam instead of auth_ldap (using pam for ldap auth though)

  • auth_pam will prompt if on it's own
  • auth_pam will not prompt if satisfy any and IP limits

Used the solution to issue 7 and added a blank basic auth file. IP and PAM work.

            satisfy any;
 allow 192.168.100.0/24;
@eby
eby / php_default_font_path.txt
Created December 17, 2013 16:42
php bundled gd default font paths
The font search path for GD (bundled with PHP) includes the following directories on Linux and similar systems:
/usr/X11R6/lib/X11/fonts/TrueType
/usr/X11R6/lib/X11/fonts/truetype
/usr/X11R6/lib/X11/fonts/TTF
/usr/share/fonts/TrueType
@eby
eby / xcrun.md
Last active December 16, 2015 00:39
gem build fails on osx complains about xcode-select / xcrun

When installing certain gems it complained about xcode files (I only installed command line tools)

  • give it the path to the command line tools

    xcode-select --switch /usr/bin

  • replace xcrun with bash script to get rid of "failed to exec real xcrun" error

    #!/bin/bash

@eby
eby / gist:3865643
Created October 10, 2012 13:26
sphinx char map
charset_table = 0..9, a..z, A..Z->a..z,U+2B,U+2032,U+2160->1,U+2161->2,U+2162->3,U+2163->4,U+2164->5,U+2165->6,U+2166->7,U+2167->8,U+2168->9,U+2169->x, \
U+00C0->a, U+00C1->a, U+00C2->a, U+00C3->a, U+00C4->a, U+00C5->a, U+00E0->a, U+00E1->a, U+00E2->a, U+00E3->a, U+00E4->a, U+00E5->a, U+0100->a, U+0101->a, U+0102->a, U+0103->a, U+010300->a, U+0104->a, U+0105->a, U+01CD->a, U+01CE->a, U+01DE->a, U+01DF->a, U+01E0->a, U+01E1->a, U+01FA->a, U+01FB->a, U+0200->a, U+0201->a, U+0202->a, U+0203->a, U+0226->a, U+0227->a, U+023A->a, U+0250->a, U+04D0->a, U+04D1->a, U+1D2C->a, U+1D43->a, U+1D44->a, U+1D8F->a, U+1E00->a, U+1E01->a, U+1E9A->a, U+1EA0->a, U+1EA1->a, U+1EA2->a, U+1EA3->a, U+1EA4->a, U+1EA5->a, U+1EA6->a, U+1EA7->a, U+1EA8->a, U+1EA9->a, U+1EAA->a, U+1EAB->a, U+1EAC->a, U+1EAD->a, U+1EAE->a, U+1EAF->a, U+1EB0->a, U+1EB1->a, U+1EB2->a, U+1EB3->a, U+1EB4->a, U+1EB5->a, U+1EB6->a, U+1EB7->a, U+2090->a, U+2C65->a, \
U+0180->b, U+0181->b, U+0182->b, U+0183->b, U+0243->b, U+0253->b, U+0299->b, U+16D2->b,
@eby
eby / db.json
Created January 27, 2012 20:04
database record
{
"_id": "db-referenceusa",
"lang": "eng",
"title": "ReferenceUSA",
"notes": [
"Find phone numbers and addresses of people, businesses, and doctors and dentists."
],
"subjects": [
"Business Directory",
"Phone Numbers",
@eby
eby / gist:1097313
Created July 21, 2011 14:33
sopac_lists structure
CREATE TABLE IF NOT EXISTS `sopac_lists` (
`list_id` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL,
`title` varchar(128) default NULL,
`description` varchar(256) default NULL,
`public` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`list_id`),
KEY `uid` (`uid`)
)

1 Overview

  • Title of plan; Author; Date; Revision; etc.
  • Project name; Award information; Funding Agencies; etc; reference to main proposal

2 Expected Data

2.1 Data

  • What data gets created by the project, and what form?
  • What raw data is generated, what processed data is generated?
  • What data is expected to be managed by the project for sharing and later archiving?
<?php
$locum_lib_dir = '/usr/local/lib/locum';
$bib = "1188529";
require_once($locum_lib_dir . '/locum-client.php');
$then = microtime();
// Data Set repair
$locum = new locum_client;
$now = microtime();
echo sprintf("Started Locum: %f", $now-$then);

cygwin ssh setup

  • login as domain user
  • cygwin install w/ openssh package selected
  • mkpasswd -d >> /etc/passwd
  • mkgroup -d >> /etc/group
  • ssh-host-config
  • yes to seperation, rename user to cygserver, add as service
  • net start sshd