Postgres CentOS iptables

# iptables -F
# iptables -L
# service iptables save
# service iptables restart
# iptables -L

references:
[1] http://www.cyberciti.biz/faq/turn-on-turn-off-firewall-in-linux/

Postgres CentOS

Install PostgreSql Server

Login as the root user and enter the command:
# yum install postgresql postgresql-server

Start Postgresql

Type the following two command:
# chkconfig postgresql on
# service postgresql start

Connect to Postgresql Server

Connect to server using
# su - postgres

Connect using psql command line tool:
$ psql -d template1 -U postgres

Open TCP port 5432

Finally make sure iptables allows remote access to Postgresql database server:
Open /etc/sysconfig/iptables file:
# vi /etc/sysconfig/iptables
Append following line before COMMIT line to open port 5432:

-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j ACCEPT

Save and close the file. Restart the firewall:
# service iptables restart

wget http://yum.pgsqlrpms.org/reporpms/8.4/pgdg-centos-8.4-2.noarch.rpm
rpm -Uhv pgdg-centos-8.4-2.noarch.rpm
if don't work see url: http://yum.pgsqlrpms.org/reporpms/8.4

Adds
======
#su postgres
psql -d template1 -U postgres (enter the template1 service database)
alter user postgres with password 'postgres_password'; (run query to change the password)
/sbin/service postgresql restart

nmap -P0 -p 5432 192.168.1.2 (if don't have nmap --> #yum install nmap)
Here are the important lines from pg_hba.conf:
Some where you will have a file called postgresql.conf
#listen_addresses = 'localhost' --> '*' and uncomment


References:
[0]http://www.ixavi.com/2010/01/instalar-postgresql-8-3-en-centos-desde-yum/
[1]http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html
[2]http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/
[3]http://www.postgresql.org/docs/7.4/interactive/sql-alteruser.html
[4] http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/

jQuery multiple months on datepicker

http://www.eyecon.ro/datepicker/

Face detection

Source code repository for face detection
http://en.pudn.com/search_db.asp?keyword=face

ASP.NET C# Upload from URL

using System.Net;
WebClient wc = new WebClient();

wc.DownloadFile("http://sourcefile.ext", "drive:\\path\\targetfile.ext");



References:
[1] http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=115

SQL Manager for PostgreSQL

SQL Manager 2007 for PostgreSQL 4.5.0.8
http://www.megaupload.com/?d=3D0YCHSD

FATAL: sorry, too many clients already

Edit postgresql.conf,then on next lines increment values

max_connections = 8
shared_buffers = 16

queries for diagnostic current sessions.

1) Select * from pg_stat_activity;
2) Select count(*) as cnt, usename, current_query FROM pg_stat_activity Group by usename,current_query Order by cnt DESC;

Indice de masa corportal

Indice de masa corporal
http://www.buenasalud.com/tools/bmicalc.cfm

Otro medidor gráfico
http://www.bmivisualizer.com

Pruebas:
[1]
http://www.bmivisualizer.com/body_masses/generate_bmi?utf8=%E2%9C%93&locale=en&body_mass[unit_measurment]=M&body_mass[gender]=Male&body_mass[age]=35&body_mass[height]=1.66&body_mass[feet]=&body_mass[inches]=&body_mass[weight]=76&commit=Calculate+BMI

Condorito

http://issuu.com/ericm814/docs/v2/condorito_n1-1955


http://www.mcanime.net/foro/viewtopic.php?t=80082

http://www.atp.com.ar/post/Comics_%2F_Anime/76634/Coleccion_Condorito_completa__parte_1.html
http://www.atp.com.ar/post/Comics_%2F_Anime/76635/Coleccion_Condorito_completa__parte_2.html
http://www.atp.com.ar/post/Comics_%2F_Anime/76636/Coleccion_Condorito_completa__parte_3.html

Disable Yahoo Messenger Adds

First mode(Execute regedit)
[HKEY_CURRENT_USER\Software\Yahoo\pager\Locale]
Enable Messenger Ad = 0
restart yahoo messenger
Second mode

on file C:\WINDOWS\system32\drivers\etc\hosts

add next line

127.0.0.1 insider.msg.yahoo.com

Make Toolbar for Browser

conduit
http://www.conduit.com/ (toolbar editor)

http://davidwalsh.name/firefox-toolbar

Bloquear paginas web OpenDNS

http://www.surcultural.info/2008/06/como-bloquear-paginas-pornograficas-gratis/

http://es.kioskea.net/faq/410-opendns-un-dns-rapido-y-util

Jasper Report Netbeans todo lo necesario

http://www.blogger.com/home?pli=1


Lo unico que hay que saber aparte de descargar el software es crear una Libreria y agregar los .jar necesario ubicados en la carpeta de instalación:
[1] C:\Archivos de programa\JasperSoft\iReport-2.0.2\lib o
[2] C:\Archivos de programa\JasperSoft\iReport-3.7.6\ireport\modules\ext


Tutoriales
http://chuwiki.chuidiang.org/index.php?title=Ejemplo_b%C3%A1sico_con_Jasper_Report
http://mundobyte.wordpress.com/2008/01/06/creacion-de-reportes-en-java-parte-iii/
http://javatutoriales.blogspot.com/2009/02/creacion-de-reportes-con-jasperrepots-y.html
http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/samples.html

Recursos:
[1] jasper software http://sourceforge.net/projects/jasperreports
[2] ireport software http://sourceforge.net/projects/ireport/files/iReport%20%28classic%29/

SQL Server Analysis Service

Working with Microsoft Analysis Services (SSAS) / MSOLAP / MDX Queries
http://developer.klipfolio.com/developer/cookbook_item/item-64


Running the Analysis Services Deployment Wizard
http://msdn.microsoft.com/en-us/library/ms174817.aspx

Building a SQL Server Analysis Services .ASDatabase file from a Visual Studio SSAS Project
http://agilebi.com/ddarden/2009/05/31/building-a-sql-server-analysis-services-asdatabase-file-from-a-as-project/

Resources
[1] http://sqlsrvanalysissrvcs.codeplex.com/
[2] SQL Server software
http://www.todotegusta.com/2010/05/microsoft-sql-server-2008-r2-standard-edition-x86-y-x64/

Keylogger Apps

Perfect keylogger v1.7.5
http://www.intercambiosvirtuales.org/software/blazingtools-perfect-keylogger-v1-7-5-0-espia-sin-que-se-enteren-lo-que-sucede-en-una-pc

Referencias:
[1]http://www.elhacker.net/Textos1.html

Data Mining with C#

Data Mining with C# and ADO.NET
http://www.devsource.com/c/a/Languages/Data-Mining-with-C-and-ADONET/
Data Mining SDK
http://datamining.codeplex.com/

http://www.sqldev.org/sql-server-analysis-services/c-using-adomd-to-connect-to-olap-cube-10707.shtml

Another plataform
http://www.cs.waikato.ac.nz/ml/weka/

Other references:
Spanish
http://bernardorobelo.blogspot.com/2010/02/modelos-y-ejemplos-de-data-mining.html
http://alejandroesteban.wordpress.com/