blog

PPTP DD-WRT and Mac OS

Startup command on the router:

sed -i -e 's/mppe .*/mppe required,stateless/' /tmp/pptpd/options.pptpd


» deekayen's blog · 1 attachment

Viewing tab delimited files in Mac OS

I kept trying to open TSV (tab separated values) files in NeoOffice or OpenOffice, but they open those files by default in Writer as a document instead of a spreadsheet. Since I just want to view the TSV files to verify they're formatted correctly from my various programming projects, I wanted a simple TSV viewer.

There are plenty of software options that offer *demos* but I found ViewCSVTAB that is listed on Macupdate as freeware. The problem with TSV files is that ViewCSVTAB thinks it should parse .txt files as .tsv. Since I don't want to change my file names every time to get them checked in ViewCSVTAB, I used vi to hack the source and change instances of txt to tsv. Now the attached version will allow you to select .tsv files as the TAB file to parse and preview.

For CSV files, this doesn't interpret or strip quotes from around values in quoted CSV files. It strictly replaces commas as columns.


» deekayen's blog · 1 attachment

Drupal on Snow Leopard

Drupal 6 probably won't ever work right on PHP 5.3.0, which is what Snow Leopard packs by default. My feeling is that since Ubuntu LTS still runs PHP 5.2, Drupal 7 won't work at production level on PHP 5.3.0 either. For that reason, here is my PHP 5.2.10 install instructions for Snow Leopard. It will trash your built-in Snow Leopard install.

For my own selfish reasons, in case I want 5.3.0 back later, here is the configuration line from phpinfo() in the default install of 5.3.0 in Snow Leopard.

/var/tmp/apache_mod_php/apache_mod_php-53~1/php/configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --disable-dependency-tracking --sysconfdir=/private/etc --with-apxs2=/usr/sbin/apxs --enable-cli --with-config-file-path=/etc --with-libxml-dir=/usr --with-openssl=/usr --with-kerberos=/usr --with-zlib=/usr --enable-bcmath --with-bz2=/usr --enable-calendar --with-curl=/usr --enable-exif --enable-ftp --with-gd --with-jpeg-dir=/BinaryCache/apache_mod_php/apache_mod_php-53~1/Root/usr/local --with-png-dir=/BinaryCache/apache_mod_php/apache_mod_php-53~1/Root/usr/local --enable-gd-native-ttf --with-ldap=/usr --with-ldap-sasl=/usr --enable-mbstring --enable-mbregex --with-mysql=mysqlnd --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd --with-mysql-sock=/var/mysql/mysql.sock --with-iodbc=/usr --enable-shmop --with-snmp=/usr --enable-soap --enable-sockets --enable-sysvmsg --enable-sysvsem --enable-sysvshm --with-xmlrpc --with-iconv-dir=/usr --with-xsl=/usr --with-pcre-regex=/usr

...and to backgrade:

Install the latest JPEG library.
Install latest libmcrypt.
Install MySQL 5.0.

Yes, I realize the database isn't the latest version, but it meshes with Ubuntu LTS for the moment.

./configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-apxs2=/usr/sbin/apxs --enable-cli --with-zlib-dir=/usr --enable-mbstring --enable-mbregex --enable-sockets --with-curl=/usr --with-config-file-path=/etc --sysconfdir=/private/etc --with-mysql-sock=/tmp/mysqld.sock --with-pear=/Library/PHP --without-iconv --without-openssl --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --with-pdo-mysql=/usr/local/mysql/bin/mysql_config --with-mcrypt --with-xmlrpc --with-bz2 --with-zlib-dir=/usr --with-jpeg-dir=/usr/local/lib --with-png-dir=/usr/X11R6 --with-freetype-dir=/usr/X11R6 --with-xpm-dir=/usr/X11R6 --with-gd --enable-ftp --enable-exif --with-kerberos=/usr --with-iodbc=/usr --enable-bcmath --enable-calendar --enable-shmop --enable-soap --enable-sockets --enable-sysvmsg --enable-sysvsem --enable-sysvshm --with-xsl=/usr

Add -lresolv on EXTRA_LIBS in Makefile, or you'll get an error with dns.o right at the end of the compile.

make
sudo make install


Topics:
» deekayen's blog

Rebecca's first line of PHP code

This is what Rebeeca added to a docblock in my local copy of the db_maintenance module for Drupal. It started as "* Implement hook_help()."

31````````````````````````````````````````````q     `                 `q1ÅA````````````CSS                      q1q`z ` * Implement hook_help().zzQE3QQQQQQAQ3AAAAADD         `  GDEQWZZÅZZB1AXSa` n                               `1 ```  E2AEEEEEEE


Topics:
» deekayen's blog

My D6 module usage stats

I'm reviewing my modules to determine each of their popularity for #D7CX. I also use this window before a major release to decide if any of my modules should just shrivel up and blow away into the dust of history.

The following table is the list of modules where I am the node author, or lead maintainer simpler terms.

Project Users
node privacy byrole 2373
Similar Entries 1889
Countdown 1015
Atom 712
URL List 473
Troll 344
User Read-Only 268
Field Actions 223
Jammer 199
Session Limit 141
Anti Existing Field 77
Workflow Named Transitions 74
.mobi loader 69
.mobi 53
Workflow Private Comments 49
Log Search 41
Bookmarks with login reminders 31
Randomizer 9
State Reference 5
Advogato Import 0

Project Users
Masquerade 2924
DB Maintenance 2892
SaveGuard 1866
Submit Again 723
Redirect 403 to User Login 445
Inactive User 393
Login Security 308
Password policy 295
Frameprevention 111
Google Pagerank 87
Arooga 29


Topics: ·
» deekayen's blog
Syndicate content
recreation