Archive

Archive for the ‘Useful stuff’ Category

Count number of open files in LINUX

December 9th, 2009 No comments

lsof | wc -l

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]
Categories: Linux Tags:

Make phone call with Iphone API

November 30th, 2009 No comments

NSURL *phoneNumberURL = [NSURL URLWithString:@"tel:8005551234"];
[[UIApplication sharedApplication] openURL:phoneNumberURL];

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]
Categories: XCode / C Tags:

URL escaping in Javascript

November 16th, 2009 No comments

Though normally you can use the escape function for this, note to full URL encode an actual URL, use encodeURIComponent instead … saves a lot of headaches when deailing with ajax ….

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]
Categories: Javascript Tags:

Get useragent in JSP file

October 28th, 2009 No comments

request.getHeader("user-agent");

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]
Categories: Java, Uncategorized Tags:

Notes on installing pgbouncer

September 15th, 2009 No comments

.. this is me just dumping my brain from the office after installing pgbouncer. FYI it works great, and really does improve the speed for db generated web pages. Don’t take this as THE install method, this is just notes so I can remember how to do it again :P

Get the source from pgfoundry ( I put it in /usr/local )
wget http://pgfoundry.org/frs/download.php/2284/pgbouncer-1.3.1.tgz

Unpack it
gunzip -c pgbouncer-1.3.1.tgz | tar -xv

Get / unpack / make libevent if not already installed
wget http://www.monkey.org/~provos/libevent-1.4.12-stable.tar.gz
gunzip -c libevent-1.4.12-stable.tar.gz | tar -xv
cd libevent-1.4.12-stable
./configure
make
make install

Back to pgbouncer
cd pgbouncer-1.3.1
./configure
make
make install

Move the ini and user files to /etc so I know where they are
mv etc/pgbouncer.ini /etc/
mv userlist.txt /etc/

Edit the userlist.txt to add user
Edit the pgbouncer.ini to point to new locations
auth_file = /etc/userlist.txt
logfile = /var/log/pgbouncer.log
pidfile = /tmp/pgbouncer.pid

Add libevent module ( fixed library not found error )
vi /etc/ld.so.conf.d/libevent-i386.conf

add line
/usr/local/lib

Run ldconfig to take new settings
ldconfig

I added the following to the START of postgresql in /etc/init.d
$SU -l postgres -c "pgbouncer -d /etc/pgbouncer.ini"

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]
Categories: Linux Tags: