http://mac.tuxfinder.com/wordpress Just another geek's nest Thu, 11 Feb 2010 10:44:38 +0000 http://backend.userland.com/rss092 en http://www.iptel.org/files/sip_tutorial.pdf http://mac.tuxfinder.com/wordpress/2010/02/11/all-you-ever-wanted-to-know-about-sip/ This is how I wrote a simple SOAP server in C++ using gsoap on my Debian Lenny server. Preparing things gsoap can be easily installed with the usual apt-get install gsoap My service will be defined based on O'Reilly's sample HelloService.wsdl which is available in Web Services Essential Generating the skeleton files The header file ... http://mac.tuxfinder.com/wordpress/2009/12/22/writing-a-simple-soap-client-server-in-c-using-gsoap/ Josh Berkus's excellent blog has the answer: SELECT idstat.relname AS table_name, indexrelname AS index_name, idstat.idx_scan AS times_used, pg_size_pretty(pg_relation_size(idstat.relname)) AS table_size, pg_size_pretty(pg_relation_size(indexrelname)) AS index_size, n_tup_upd + n_tup_ins + n_tup_del as num_writes, indexdef AS definition FROM pg_stat_user_indexes AS idstat JOIN pg_indexes ON indexrelname = indexname JOIN pg_stat_user_tables AS tabstat ON idstat.relname = tabstat.relname WHERE idstat.idx_scan < 200 AND indexdef !~* 'unique' ORDER BY ... http://mac.tuxfinder.com/wordpress/2009/11/11/how-to-identify-un-used-indexes-in-postgresql/ Mark James rules http://mac.tuxfinder.com/wordpress/2009/10/05/free-icons/ Here is an interesting tutorial which helped me a bit in this nebulous topic of DIV positioning: http://www.barelyfitz.com/screencast/html-training/css/positioning/ http://mac.tuxfinder.com/wordpress/2009/08/21/div-made-easy-at-least/ IPv4 adresses are typically bigint data - they are 32-bits data usually written as 4 blocks of 8 bits for practical reasons. My version of postgresl doesn't know how to translate this bigint natively into an inet, so I'm using the following trick: select ((3221226219 & x'ff000000'::bigint >> 24 ) || ... http://mac.tuxfinder.com/wordpress/2009/08/17/how-to-convert-a-bigint-into-an-inet-in-postgresql/ Assuming tmp is already under version control: cp -rp tmp tmp .bak svn rm tmp svn propset svn:ignore tmp . svn ci -m "Removing tmp from version control." mv tmp .bak tmp svn st http://mac.tuxfinder.com/wordpress/2009/08/14/how-to-ignore-a-directory-in-subversion/ Rebuilding a Debian Package is a straigthfoward process. First get the source and the build dependencies... sudo apt-get install dpkg-dev apt-get source pgadmin3 sudo apt-get build-dep pgadmin3 Then start the build itself: cd pgadmin3 debuild -us -uc http://mac.tuxfinder.com/wordpress/2009/07/24/rebuilding-a-debian-package/ On top of Tivoli, HP OV, BMV... why not Intermapper (http://www.intermapper.com) ? http://mac.tuxfinder.com/wordpress/2009/06/29/monitoring-tools/ Goal: This process shows how to create a bootable CFCard that can be used to boot a PC Engines Alix board. The OS chosen is Debian Lenny. Setup: One Alix 1d board One 4 GB Compact Flash Card - although 300 MB should be enough One Lenny x86 PC to do the setup Prepare the CF ... http://mac.tuxfinder.com/wordpress/2009/06/11/installing-linux-debian-lenny-on-an-alix-board/