Postgres::Drop connections

--List all of the open connections to a given database
select * from pg_stat_activity where datname='database';

--Drop all of the open connections to a given database:
select pg_terminate_backend(procpid) from pg_stat_activity where datname='database';
--More samples
select * from pg_stat_activity where date(backend_start)='2011-04-19';
select pg_terminate_backend(procpid) from pg_stat_activity where date(backend_start)='2011-04-19';

--One sample more specific
select * from pg_stat_activity where backend_start < '2011-05-04 10:00' and waiting=false order by backend_start desc
select pg_terminate_backend(procpid) from pg_stat_activity where backend_start < '2011-05-04 10:00' and waiting=false

select pg_terminate_backend(procpid) from pg_stat_activity where backend_start < '2011-08-05 07:00' and datname='' and waiting=false

References:
http://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE
http://www.postgresql.org/docs/8.4/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE

Microsoft IIS(Internet Information Services)::Activar soporte SSL

[1]http://www.adictosaltrabajo.com/tutoriales/tutoriales.php?pagina=iisssl

Default Setting of SMTP

Gmail
Outing Server:smtp.googlemail.com
port:465
Connection Security:SSL/TLS

Cuenta Interbancaria - CCI

BBVA - Banco Continental
http://www.bbvabancocontinental.com/tlpu/jsp/pe/esp/home/codccci.jsp
ViaBCP
http://www.viabcp.com/connect/pdf/servicios_empresas/conversor/conozca.asp

Network Security Tools

Wireshark
Ethercap
Winpcap


Resources:
[0] http://wiki.wireshark.org/FrontPage
[1]http://seguridadyredes.nireblog.com/post/2008/03/24/analisis-de-red-con-wireshark-filtros-de-captura-y-visualizacian
[2]http://www.soportederedes.com/2007/06/wireshark-101-filtros-de-visualizacin.html
[3] Yahoo http://wiki.wireshark.org/YMSG
[4] AIM http://wiki.wireshark.org/AIM
[5] MSN http://wiki.wireshark.org/MSNMS?action=show&redirect=MSN
[6] Cain http://shetoldme.com/Technology/How-To-Dump-Windows-Password-Using-Pwdump

Windows Security Crack Tools

ophcrack
http://www.bujarra.com/?p=1002

Publishing ASP:NET MVC2 on Windows Server 2008+ISS7

http://arturito.net/2011/01/21/publishing-asp-net-mvc2-application-on-windows-server-2008-iis-7-with-visual-studio-2008-on-platform-net-3-5-sp1/

Amy MacDonald

2007 This is the life
http://linkto.net/?2952626344cf0f4eeeae854.45628949
2010 A curious thing
http://linkto.net/?19645296464cf0f5026f0bb4.43062513

.NET Dynamic Reports

http://www.gotreportviewer.com/DynamicMatrix.zip
Render Report
http://weblogs.asp.net/rajbk/archive/2006/03/02/How-to-render-client-report-definition-files-_28002E00_rdlc_2900_-directly-to-the-Response-stream-without-preview.aspx

iPhone Developers::Resources

XCode under Windows
http://www.ifans.com/forums/showthread.php?t=267007
http://ipodtoucher55.blogspot.com/2010/12/installing-ios-sdk-and-xcode-on-windows.html

Tutorials
http://www.cristalab.com/tutoriales/fundamentos-de-programacion-para-iphone-c260l/
http://www.scribd.com/doc/12684298/Building-PhotoKast-Creating-an-iPhone-app-in-one-month
http://iproyectoiphone.blogspot.com/

Hello World on iPhone
http://developer.apple.com/library/ios/#documentation/IDEs/Conceptual/xcode_quick_start/000-About_Xcode/introduction.html#//apple_ref/doc/uid/TP40010575
http://developer.apple.com/library/ios/navigation/

How to connect to a MySQL database from an iPhone?
http://stackoverflow.com/questions/468618/how-to-connect-to-a-mysql-database-from-an-iphone

Mysql and Objective-C
http://www.karlkraft.com/index.php/2010/06/02/mysql-and-objective-c/

MySQL.framework for iPhone
http://www.eval-art.com/2009/06/22/mysqlframework-for-iphone/

CocoaMySQL
http://sourceforge.net/projects/cocoamysql/files/CocoaMySQL%20source/CocoaMySQL%20source%20v0.7b4%20%28BETA%29/

MySQL on MAC OS X
http://developer.apple.com/internet/opensource/osdb.html
iMy (mySQL client for iphone)
http://www.spanware.com/iphonedb/iMy/iMy.html
iAMPS (webserver on your iPhone)
http://iamps.byethost24.com/index.php?postid=15

iPhone & Web Service

How can I connect iPhone and web service and get XML data?
http://stackoverflow.com/questions/352676/how-can-i-connect-iphone-and-web-service-and-get-xml-data

iPhone Programming Tutorial – Intro to SOAP Web Services
http://www.icodeblog.com/2008/11/03/iphone-programming-tutorial-intro-to-soap-web-services/

Creating an iPhone-based Web
http://blogs.oreilly.com/iphone/2008/09/creating-an-iphone-based-web-s.html

http://es.w3support.net/index.php?db=so&id=352676

Disable Popup at Yahoo Messenger started

1. Login using the Yahoo messenger.
2. Go to Messenger >> Preferences >> General category.
3. Uncheck [ ] Show Yahoo! Messenger Insider.

References
[1]http://txpress.blogspot.com/2007/03/remove-yahoo-messenger-insider-popup.html

My Theme Resources

Install Java + Tomcat on Linux CentOS

I. Installing Java

#yum install jpackage-utils

#wget url/jdk-6u13-linux-i586-rpm.bin [1]

#chmod +x jdk-6u13-linux-i586-rpm.bin

#./jdk-6u13-linux-i586-rpm.bin

#java -version

II. Installing Tomcat

#wget http://apache.mirror.testserver.li/tomcat/tomcat-6/v6.0.32/bin/apache-tomcat-6.0.32.tar.gz

#cp apache-tomcat-6.0.32.tar.gz /var/

#cd /var

#tar -zxvf apache-tomcat-6.0.32.tar.gz

# ln -s /var/apache-tomcat-6.0.32 tomcat

#/var/tomcat/bin/startup.sh

References:
[1]Java Download http://www.oracle.com/technetwork/java/javase/downloads/index.html
[2]Java + Tomcat + startup in CentOS
http://wiki.openbluedragon.org/wiki/index.php/Apache_Tomcat_on_CentOS/RedHat
[3]Java 6 + Tomcat in CentOS
http://www.satollo.net/how-to-install-tomcat-and-java-6-on-centos-5-2
[4]Java SE
http://www.oracle.com/technetwork/java/javase/downloads/index.html
[5]Tomcat (download core tar.gz)
http://tomcat.apache.org/download-60.cgi
[6]Mirror
http://apache.mirror.testserver.li/tomcat/tomcat-6/v6.0.32/bin/apache-tomcat-6.0.32.tar.gz

CSS Templates

http://www.woothemes.com/themes/

Videos Graciosos

http://video.latam.msn.com/watch/video/gato-cansado-se-desmaya/1jb3dt5rq

http://video.latam.msn.com/watch/video/sonrie-cuando-le-dicen/1jbyn00k1

http://video.latam.msn.com/watch/video/perro-ladra-mas-bajo-a-pedido/1jb65jo8z

http://video.latam.msn.com/watch/video/precision-japonesa/1jb7ufffb

http://video.latam.msn.com/watch/video/carrera-de-31-piernas/1jb3la8c6

http://video.latam.msn.com/watch/video/gato-contra-perro-en-camara-lenta/1jbatlyp9

http://video.latam.msn.com/watch/video/la-mejor-imitadora-de-animales-del-mundo/p4fej3h3

CSS::Best Button stylized

http://www.dynamicdrive.com/style/csslibrary/item/css_oval_buttons/
http://www.oscaralexander.com/tutorials/how-to-make-sexy-buttons-with-css.html
http://halmatferello.com/lab/pure-css-buttons/#

Web Designes::Best Samples

Blue
http://zoomerang.custhelp.com/app/home/session/L2F2LzEvc2lkL2RweXltTHBr/kw/Salesforce/r_id/132385
Soft Green
http://www.1stwebdesigner.com/tutorials/css-menu-button-tutorials/

Dark orange
http://freeyourdesign.com/css/css-gradient-background-fade/

Dark
http://www.csselite.com/advertise

Star Girls

Olivia Munn
http://www.perfectpeople.net/photo-picture-image/132277/olivia-munn.htm
http://ricasgarcia.deviantart.com/art/Olivia-Munn-179616076
http://www.1920x1200.net/tag/1280x800/page/21/
http://www.1920x1200.net/2010/08/26/olivia-munn-7/
Travieza
http://www.8thos.com/threads/olivia-munn.1766/
http://bolichodogremio.blogspot.com.br/2009/09/olivia-munn-iron-man-2.html

Sasha Grey
http://efersoto.blogspot.com/2010/12/oda-al-universo-de-una-dama.html
Denise Milani
http://www.theplace2.ru/photos/gallery.php?id=2537&page=3

Asiatics
http://zengallery.blogspot.com.br/


Latinas
Azalia Alfaro
http://www.dogguie.com/dogguie-lectores-la-bella-y-sensual-azalia/
http://www.facebook.com/profile.php?id=100001438061662

India
http://www.hotbollywoodwomen.com/2010/08/vidya-balan-beautiful-face.html
http://www.hotbollywoodwomen.com/2009/10/bollywood-actress-best-butt-competition.html
http://indianpicwallpaper.blogspot.com/2010/06/kareena-kapoor-beautiful-style.html

Portal Cautivo

[1] pfsense http://www.pfsense.org/


http://es.wikipedia.org/wiki/Portal_cautivo

http://blyx.com/public/wireless/nocatbox/nocatbox-howto-es.pdf

ASP.NET MVC and HTTPS

Enable SSL or HTTPS in IIS 7

1. Open IIS from Administrative Tools.
2. Navigate to Sites>Default Web Site. Or select the web site you want to enable SSL or HTTPS.
3. In the right pane, Click Binding.
4. Default is setup Port 80. You can click Add and to HTTPS or port 443.
5. Continue the instruction to complete the settigns.


Referencias:
[1]Adding HTTPS/SSL support to ASP.NET MVC routing
http://blog.stevensanderson.com/2008/08/05/adding-httpsssl-support-to-aspnet-mvc-routing/
[2]Requiring SSL For ASP.NET MVC Controllers
http://weblogs.asp.net/dwahlin/archive/2009/08/25/requiring-ssl-for-asp-net-mvc-controllers.aspx
[3]SSL pages under ASP.NET MVC
http://stackoverflow.com/questions/156748/ssl-pages-under-asp-net-mvc
[4]http://es.wikipedia.org/wiki/Hypertext_Transfer_Protocol_Secure
[5]Enabling SSL on IIS 7.0 Using Self-Signed Certificates http://weblogs.asp.net/scottgu/archive/2007/04/06/tip-trick-enabling-ssl-on-iis7-using-self-signed-certificates.aspx
[6] Configure IIS http://learn.iis.net/page.aspx/144/how-to-set-up-ssl-on-iis-7/
[7] IIS 7 SSL Certificate Installation http://www.digicert.com/ssl-certificate-installation-microsoft-iis-7.htm
[8] Enable SSL on IIS 7 (Spanish) http://thinkingindotnet.wordpress.com/2007/04/06/trucos-habilitar-ssl-en-iis-70-usando-certificados-firmados-por-nosotros/
[9] IIS7 - How to Install GoDaddy SSL Certificate http://www.netometer.com/video/tutorials/iis7-godaddy-ssl-certificate/
[10] Self-Signed Certificates on IIS 7 – the Easy Way and the Most Effective Way http://www.robbagby.com/iis/self-signed-certificates-on-iis-7-the-easy-way-and-the-most-effective-way/