Wednesday, July 13, 2011

php photo gallery::without database

http://phpgraphy.sourceforge.net/
http://www.sgal.org/
http://sourceforge.net/projects/ifoto/
http://yapig.sourceforge.net/
http://qdig.sourceforge.net/

Distancia de Arequipa a otros lugares

http://www.lacasademargott.com/es/arequipa-distancias.htm

Tuesday, June 28, 2011

C.C. Catch::You Shot A Hole In My Soul

He's a midnight dream romancer
He's the only lonely dancer
Oh, only love breaks my heart
He's the nearest thing to heaven
Stole my heart and tried to say then
Oh, only love breaks my heart

You shot a hole in my soul
It's the kind out of love I know
You shot a hole in my soul
Hold on tight, don't let go
You get always what you want from me
You can make it easy, can't you see
You shot a hole, hole, hole
Hole in my soul

Dreams go on forever and ever
Good things do not last forever
Heaven can wait but I can't
But I'd do it once again, babe
I think tomorrow it's too late, babe
Oh, only love breaks my heart

Monday, June 20, 2011

W810::Habilitar MMS y WAP

Primero:
Menú--> Ajustes--> Conectividad --> Comunic. de datos--> Cuentas de datos--> Nueva cuenta--> Datos GPRS--> Nombre: WAP GPRS
APN: wap.claro.pe
Nombre de usuario: claro
Contraseña: claro
(GUARDAR)
Segundo:
Menú--> Ajustes--> Conectividad--> Ajustes Internet--> Perfiles Internet--> Nuevo perfil-->
Nombre: Claro WAP
Conectar usando: (seleccionas la cuenta que creaste) WAP GPRS
(GUARDAR)
Tercero:
Seleccionas el perfil que creaste (Claro WAP) y le das MÁS. Luego seleccionas AJUSTES.
Verificas que en Uso de Proxy diga SI
Dirección de proxy: 192.168.231.30
Número de puerto: 80 //por defecto es 8080 me imagino que se quedaria asi si es que el tipo de navegación fuera http
(GUARDAR)
Para que esté activo el perfil recuerda de “seleccionarlo”.


Configuracion MMS

Primero:
Menú--> Ajustes--> Conectividad--> Comunic. de datos--> Cuentas de datos--> Nueva cuenta--> Datos GPRS--> Nombre: MMS GPRS
APN: mms.claro.pe
Nombre de usuario: claro
Contraseña:claro
(GUARDAR)
Segundo:
Menú--> Ajustes--> Conectividad--> Ajustes Internet--> Perfiles Internet--> Nuevo perfil-->
Nombre: Claro MMS
Conectar usando: (seleccionas la cuenta que creaste) MMS GPRS
(GUARDAR)
Tercero:
Seleccionas el perfil que creaste (Claro MMS) y le das MÁS. Luego AJUSTES.
Verificas que en Uso de Proxy diga SI
Dirección de proxy: 213.26.205.1
Número de puerto: 80
(GUARDAR)
Menú--> Mensajes--> Ajustes--> Msj con imagen--> Perfil MMS--> Nuevo perfil-->
Nombre Perfil MMS: Multimedia
Servidor de msjs: http://claro/servlets/mms
Perfil de internet: Claro MMS
(GUARDAR)
Referencias:
http://www.topsony.com/forum_es/general-f96/configuracion-wap-y-mms-para-claro-peru-t14503.html

Monday, June 13, 2011

Offensive Security

Verify
nmap -sV -PN -p 445,137,139 --script=smb-check-vulns.nse


Meterpreter common commands


meterpreter > getprivs
meterpreter > migrate 2976
meterpreter > bglist

meterpreter > use -l
meterpreter > ?


meterpreter > bgrun keylogrecorder -c 1 -t 15
meterpreter> run keylogrecorder -c 1 -l -t 5
-c 1 to record a login session, "-l" to force logoff, and "-t 5" to deliver the keystrokes every 5 sec.

Basic meterpreter



Meterpreter Cllient commands
http://en.wikibooks.org/wiki/Metasploit/MeterpreterClient

Vulnerabilidad StickyKeys (sethc.exe)
http://foro.infiernohacker.com/index.php?topic=1867.0

Tools
http://www.md5decrypter.co.uk/

REG
http://ss64.com/nt/reg.html

Meterpreter REG
http://carnal0wnage.attackresearch.com/2007/06/defating-nod32-av.html

examples:
[1] Keylogging
http://www.offensive-security.com/metasploit-unleashed/Keylogging
[2] http://tekjournal.wordpress.com/2011/01/08/login-keystroke-recording/
[3] http://pctechtips.org/metasploit-getting-user-password-with-keylogrecorder/
[4] http://www.offensive-security.com/metasploit-unleashed/Meterpreter_Screen_Capture
[5] http://exploit.co.il/hacking/screenspy-meterpreter-script-review/

modules:
http://www.metasploit.com/modules/auxiliary/analyze/jtr_crack_fast


references:
[1] http://www.blueliv.com/downloads/Meterpreter_cheat_sheet_v0.1.pdf
[2] http://www.question-defense.com/2009/12/21/getting-started-with-meterpreter
[3] Custom exploit
http://www.pentester.es/2009/11/por-que-no-consigo-shell-con-mi.html

Thursday, June 09, 2011

Games

NEED FOR SPEED(TM) III: HOT PURSUIT

Tuesday, June 07, 2011

Windows::Network commands(cmd)

net user

net user guest
net user invitado


To enable the Guest account for network access:

net user guest /active:yes
net user invitado /active:yes

To disable the Guest account for network access:

net user guest /active:no
net user invitado /active:no


netstat

References
[1] netstat http://commandwindows.com/netstat.htm

SQL Server::SQLCMD

cd C:\Archivos de programa\Microsoft SQL Server\100\Tools\Binn
C:..>SQLCMD -s 192.168.1.30 -U sa -P pass


sp_databases
use

sp_help tablename
select * from SYSOBJECTS where TYPE = 'U' order by NAME


references:
[1] http://msdn.microsoft.com/en-us/library/ms180944.aspx
[2] http://msdn.microsoft.com/en-us/library/ms165702.aspx

Wednesday, June 01, 2011

Hiren's BootUSB

1. Download USB Disk Storage Format

2. Download Grub4Dos Installer

3.Run USB Disk Storage Format
4.Run Grub4Dos Installer
  4.1 Disk
  4.2 Refresh
  4.3 While disk (MBR)
  4.4 Install
5. Copy grldr and menu.lst (from HBCD folder) to the usb drive
6. Copy everything from CD(Hiren's BootCD) to USB Drive
7. reboot

References:
[1] Download iso http://www.hirensbootcd.org/download/
[2] http://www.hiren.info/pages/bootcd-on-usb-disk

Default Ports

PuertoDesc.EstadoObservaciones
20FTPcerradoUtilizado por FTP
21FTPcerradoUtilizado por FTP
22SSHabiertoSecure Shell.
23TELNETcerradoAcceso remoto
25SMTPcerradoServidor de correo SMTP
53DNScerradoServidor DNS
79FINGERcerradoServidor de información de usuarios de un PC
80HTTPabiertoServidor web
110POP3cerradoServidor de correo POP3
119NNTPcerradoServidor de noticias
135DCOM-scmcerradoSolo se puede cerrar a través de un cortafuegos
139NETBIOScerradoCompartición de Ficheros a través de una red
143IMAPcerradoServidor de correo IMAP
389LDAPcerradoLDAP. Tambien Puede ser utilizado por Neetmeting
443HTTPScerradoServidor web seguro
445MSFT DScerradoServer Message Block.
631IPPcerradoServidor de Impresion
1433MS SQLcerradoBase de Datos de Microsoft
3306MYSQLcerradoBase de Datos. MYSQL
5000UPnPcerradoEn windows está activado este puerto por defecto.

Wednesday, May 25, 2011

nmap::usages

nmap -sV -PN -p 445,137,139 --script=smb-check-vulns.nse

Tuesday, May 24, 2011

Windows.:Hidden user account

http://juliorestrepo.wordpress.com/2008/09/19/trucos-regedit-como-ocultar-una-cuenta-de-usuario-de-la-pantalla-de-bienvenida-de-windows-xp/

Friday, May 20, 2011

TV

KWorld page
http://us.kworld-global.com/main/index.aspx?flag=1


Resources:
[1] Other Driver http://www.nodevice.com/driver/PVR-TV_305UDE/get44169.html
[2] Original Driver http://www.kworld-global.com/main/support_down.aspx?mnuid=1255&modid=14&flag=1

Thursday, May 19, 2011

PsTools::Remote tools

Share resource

NET SHARE sharename=drive:path /REMARK:"text" [/CACHE:Manual | Automatic | No ]
NET SHARE temp=c:\tmp /REMARK:"temporal files"

Drop share.
NET SHARE {sharename | devicename | drive:path} /DELETE
NET SHARE temp

Show resources
net view \\192.168.1.x


Open remote console

psexec \\IP -u USER -p PASSWORD


If Access denied(Acceso denegado) results, then:

Start, Control Panel, Administrative Tools,Local Security Policy.
Open the Local Policies, Security Options.

Accounts: Limit local account use of blank passwords to console logon only set to Disabled.

if don't work try:

Network access: Sharing and security model for local accounts set to "Classic - local users authenticate as themselves".


Notes(Remote Computer):

a) Debe tener habilitada la opción de "Compartir impresoras y archivos" (Inicio -> Ejecutar.... ncpa.cpl)
b) Debe tener deshabilitada la opción "Utilizar uso compartido simple de archivos"
c) Si tiene habilitado algún firewall debe permitir las conexiones por los puertos NetBIOS.
d) La máquina remota debe correr win NT, 2000, XP Pro, Vista o Server 2003
e) Tener usuario y contraseña válidos en la máquina remota
f) La máquina remota debe tener habilitado el recurso IPC$ y ADMIN$
g) La máquina remota debe tener iniciados los servicios NetLogon y Server

resources:
[1] psTools Download http://technet.microsoft.com/en-us/sysinternals/bb897553
[2] HOW TO: Restore Administrative Shares That Have Been Deleted http://support.microsoft.com/kb/318755
[3] Windows XP Professional File Sharing http://www.practicallynetworked.com/sharing/xp_filesharing/index.htm
[4] How to use the Simple File Sharing feature to share files in Windows XP http://support.microsoft.com/kb/304040

Wednesday, May 18, 2011

JavaScript::Add Extensions

Array.prototype.newMethod = function () {

return “this is an extended method for javascript array”;

};http://www.blogger.com/img/blank.gif

var js_array = new Array();

alert(js_array.newMethod());


references:
[1] Extend array functions http://blog.programmingsolution.net/javascript/javascript-array-extension/
[2] http://stackoverflow.com/questions/477700/array-functions-in-jquery

Wednesday, May 11, 2011

EMS SQL Manager configure for connect to Oracle

tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = x.x.x.x )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = ipc)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)




sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

USE_DEDICATED_SERVER = ON

USE_CMAN = TRUE

Tuesday, May 10, 2011

TeamViewer::Change ID after cloning

if you clone hardisk with Teamviewer is possible have same id's on many computer for regenerate ids's remove using regedit next key:

for 64 bit Windows 7:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TeamViewer\VersionX
for 32 bit Windows 7:
HKEY_LOCAL_MACHINE\SOFTWARE\TeamViewer\VersionX

References:
http://eatrocks.com/?p=166

Tuesday, May 03, 2011

VMWare 7.0::Snow Leopard 10.6.1-10.6.2

two comments:
first you need VMWare 7.0 and Snow Leopard iso.

second on boot: -v cpus=1 busratio=20


notes:

for active partition if not

after push F8 on boot prompt: -v -s cpus=1 busratio=20
and next you have prompt #fdisk -e /dev/rdisk0
:print --to display a list of partitions on the disk.
:flag n --n is the partition where you installed Mac OS X.


references
[1] http://cyberwarez.info/forum/showthread.php/2582692-CW-UPLOAD-MAC-OSX-Collection-2011?p=3775422&viewfull=1
[2] http://www.chw.net/foro/hackintosh-f179/887315-no-puedo-instalar-mac-os-leopard.html
[3] http://bobhood.wordpress.com/2009/06/12/installing-ideneb-1-4-under-vmware-6-5-2/
[4] http://cyberwarez.info/forum/showthread.php/2582692-CW-UPLOAD-MAC-OSX-Collection-2011?p=3775422&viewfull=1
[5] http://ayudalinux.wordpress.com/2007/02/03/instalar-macosx86-1045-sobre-vmware/
[6] OSx86 – How To install Mac OS X on VMware Server & AMD 64 http://asendure.wordpress.com/2006/10/01/osx86-how-to-install-mac-os-x-on-vmware-server-amd-64/

Friday, April 29, 2011

Linux Fonts

Step 1: Download fonts from [1]
Step 2: unzip and copy to default fonts path
$cp -r /home/user/Desktop/Downloads/fontfolder /usr/share/fonts/
Step 3: Update fonts cache
$fc-cache /usr/share/fonts/fontfolder/

Resources:

[1] fonts http://www.portalplanetasedna.com.ar/fuentes1.htm

Thursday, April 28, 2011

Ghost::How to Clone Partition from Intel to Amd processor.

boot from windows xp cdrom, and select install(F8) and next repair(After copying the installation data to the drive, you should boot once again from the cdrom - not from your harddisk)
on second boot select Repair on first screen, login and execute next commands.

cd c:\windows\system32\drivers
c:\windows\system32\drivers>del intelide.sys
c:\windows\system32\drivers>del intelppm.sys

exit and wait reboot

Note:
I try delete files after clone(using external boot cd) and reset then works fine.

References:
[1]http://www.cpuhack.com/wordpress/?p=142
[2]using register mode http://support.microsoft.com/kb/314082

ASP.NET::The timeout period

The timeout period elapsed prior to completion of the operation or the server is not responding.

try below options, set command timeout parameter to 0. It will execute till the end. By default it will timeout in 30 secs.

Using Code:

sqlCommand.CommandTimeout = 0;

Using Connection String: Check the timeout in connection string, try setting it to max...
data source="ServerName;initial catalog=DataBaseName;uid=ID;pwd=Password;Connect Timeout=120"

Using Sql Server:On the SQL Server also you can set timeout of a query. Check with SQL Server DBA's to know the Query time out set on servers.

Using IIS: On IIS also you have timeout setting. In IIS --> Website tab --> Connection time out box . Set the max timeout value (in secs) IIS should maintain idle connection .

check all these possibilities

Wednesday, April 27, 2011

OpenSUSE::Install JRE1.6

Step 1:Download JRE from [2]
#wget ....
Step 2: Executing installer
#chmod +x jre-6-linux-i586.bin
#./jre-6-linux-i586.bin
Step 3:Move directory to common
#mv jre1.6.0 /usr/lib/jvm

Step 4:Set new Java to "alternatives of java":
#update-alternatives --install "/usr/bin/java" "java" "/usr/lib/jvm/jre1.6.0/bin/java" 1
Step 5:Verify version
#java -version
references:

[1] Instalar JAVA JRE 1.6.0 en Firefox http://www.ubuntu-es.org/node/33116
[2] JRE repository
EShttp://www.java.com/es/download/linux_manual.jsp
ENhttp://www.java.com/en/download/linux_manual.jsp

Monday, April 25, 2011

Web Security

Articles : How to hack a website (Basic sql injection)
http://www.ecademy.com/node.php?id=76050

references:
http://www.thc.org/thc-hydra/

Enable/Disable Firefox Cookies

on url address put about:config and search next item.
network.cookie.alwaysAcceptSessionCookies //verify value is true


References:
http://support.mozilla.com/es/kb/Habilitar%20y%20deshabilitar%20cookies

Tuesday, April 19, 2011

Spring MVC

Spring MVC Fast Tutorial (with sources for download)
http://maestric.com/doc/java/spring

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

Friday, April 15, 2011

Default Setting of SMTP

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

Thursday, March 31, 2011

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

Wednesday, March 30, 2011

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

Monday, March 28, 2011

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

Wednesday, March 23, 2011

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

Tuesday, March 22, 2011

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/

Thursday, March 17, 2011

Salesforce::Override save method of Opportunity

Apex Class
====================================================================================

public class OpportunityEditControllerExtension {

public String status;
public String getStatus() {return status;}

public opportunity oppo;
private final ApexPages.StandardController controller;

//initializes the private member variables
public OpportunityEditControllerExtension(ApexPages.StandardController stdController)
{
controller= stdController;
this.oppo= (opportunity)controller.getRecord();
}


public PageReference mysave()
{
try{
update oppo;
}
catch(DmlException ex){
ApexPages.addMessages(ex);
}
status='Updated...';
//PageReference sc = new ApexPages.StandardController(oppo).view();
//return sc;
return null;
}
}
====================================================================================

Apex Page
====================================================================================
<apex:page standardcontroller="opportunity" extensions="OpportunityEditControllerExtension" >
<apex:form >
<apex:pageblock >
<apex:pageBlockButtons >
<apex:commandbutton value="Save" action="{!mysave}" rerender="resultsPanel" status="status"/>

<apex:inputfield value="{!opportunity.name}"/>
<apex:inputfield value="{!opportunity.amount}"/>
<apex:inputfield value="{!opportunity.closedate}"/>

<apex:actionStatus id="status" startText="Fetching map..."/>
<apex:outputPanel id="resultsPanel">





Salesforce::Apex Page::Add extensions

Load another objetcts
http://stackoverflow.com/questions/3552779/salesforce-softphone-relate-call-to-records-in-two-different-objects


Adding Custom List Buttons using Standard List Controllers
http://www.salesforce.com/us/developer/docs/pages/Content/pages_controller_sosc_custom_button.htm

Tuesday, March 15, 2011

Servlet::Make PDF

http://www.geek-tutorials.com/java/itext/servlet_jsp_output_pdf.php


iText->Códigos de Barra
http://www.itextpdf.com/themes/keyword.php?id=373
Other methods
http://www.bokai.com/BarcodeJSP/
http://stackoverflow.com/questions/1700597/barcode-image-generator-in-java

Salesforce::Class for Retrieve data from another URL using JSON

1) You need register url of repository.



2) Apex Class
=====================================================================================

public class JsonSecondController {
String name;
public PageReference test() {
return null;
}
public PageReference submit() {
return null;
}

public String getName() { return name;}
public void setName(String nname) { name=nname;}



public List getOptions()
{

List defaultResult= new List();
defaultResult.add(new SelectOption('','---'));

list lvalues;
try
{
String values=getJsonString('342096656648874');
lvalues=JSONObject.jsonarray ( new JSONObject.JSONTokener( values ) );
}
catch(Exception e)
{
return defaultResult;
}
return getSelectOptions(lvalues);
}


private String getJsonString(String id) {

String json;
HttpRequest req = new HttpRequest();
Http http = new Http();
req.setMethod('GET');
// generate the url for the request
String url = 'http://datarepository/page.aspx/GetIndustries/'+id;
req.setEndpoint(url);// add the endpoint to the request
req.setCompressed(true);
HTTPResponse resp = http.send(req);
json = resp.getBody().replace('\n', '');

try {
//System.debug('Respond code: ' + resp.getStatus());
return json;
} catch (JSONObject.JSONException e) {
return 'Error parsing JSON response: '+e;
}

}
private List getSelectOptions(list l)
{
List elements=new List();
for (Integer i = 0; i < l.size(); i++){
JSONObject v = l.get(i).obj;
String value=v.getValue('Value').str;
String label=v.getValue('Text').str;
elements.add(new SelectOption(value,label));
}

return elements;
}


}

=====================================================================================


2) Apex Page
=====================================================================================

<apex:page controller="JsonSecondController">
<apex:form >

<apex:selectList id="idindustry" value="{!name}" size="1">
<apex:selectOptions value="{!Options}"/>



<apex:commandButton value="Test" action="{!test}" rerender="out" status="status"/>

<apex:outputPanel id="out">
<apex:actionstatus id="status" startText="testing...">





=====================================================================================

References:

[1] JSONObject http://www.embracingthecloud.com/CommentView,guid,6ca59b34-f896-48a2-b1bf-33ffbe96b4ec.aspx
[2] http://wiki.developerforce.com/index.php/Building_Android_Applications_with_the_Force.com_REST_API
[3] JSON Validator page http://www.jsonlint.com/

Monday, March 14, 2011

JasperReport::Export to Text

CHAR_WIDTH = REPORT_WIDTH / MAX_CHAR_PER_ROW=524 / 80 = 6.55 //6
CHAR_HEIGHT = REPORT_HEIGHT / MAX_CHAR_PER_COL =524 / 44 = 11.9 //11//10


JRTextExporter exporter = new JRTextExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, "c:\\textreport1.txt");
exporter.setParameter(JRTextExporterParameter.CHARACTER_WIDTH, new Integer(6));
exporter.setParameter(JRTextExporterParameter.CHARACTER_HEIGHT, new Integer(11));
exporter.exportReport();



References
[1]http://www.coderanch.com/t/62982/open-source/Jasper-Report-Text-Exporter
[2] http://www.cepeu.edu.py/LIBROS_ELECTRONICOS_3/lpcu089%20-%2001.pdf
[3] http://chuwiki.chuidiang.org/index.php?title=Ejemplo_b%C3%A1sico_con_Jasper_Report

PostgreSql Date Format

If you need change date format into postgres database, need execute next commands

SET DATESTYLE TO Postgres,US;
or
SET DATESTYLE TO iso,dmy --dd/mm/yyyy

this setting apply to current session; for permanent change modify postgresq.conf, section Locale and Formatting:

datestyle = 'iso, mdy'

Now you need reestart database

#service postgresql restart


Reload config settings without restarting database
If you are making modifications to the file postgresql.conf (or similar), and you want to new settings to take effect without needing to restart the entire database, there are two ways to accomplish this.

Option 1: From the command-line shell
#su - postgres
$/usr/bin/pg_ctl reload

Option 2: Using SQL

SELECT pg_reload_conf();

Using either option will not interrupt any active queries or connections to the database.

References:
[1] SET http://www.commandprompt.com/ppbook/r28464
[2] http://heatware.net/databases/postgresql-reload-config-without-restarting/

Thursday, February 17, 2011

Wireless::Proveedores de Equipos

http://www.digitalstoreperu.com/tienda/category.php?id_category=18

Precios
http://www.diazcomunicaciones.com/tienda

Wireless Metrics

dBm is defined as power ratio in decibel (dB) referenced to one milliwatt (mW). It is an abbreviation for dB with respect to 1 mW and the "m" in dBm stands for milliwatt.

dBm is different from dB. dBm represents absolute power, whereas dB is a ratio of two values and is used to represent gain or attenuation. For example, 3 dBm means 2 mW, and 3 dB means a gain of 2. Similarly, -3 dBm means 0.5 mW, whereas -3 dB means attenuation of 2.

The formula to calculate dBm from mW is:

dBm = 10 log10( P )
1mW

Table of dBm and mW
http://www.guatewireless.org/internetworking/redes/wireless/tabla-de-relacion-entre-dbm-y-potencia-de-transmision-wlan/

Friday, February 04, 2011

Postgres Auditory

Trace connections
select * from pg_stat_activity;

select client_addr,count(*) from pg_stat_activity group by client_addr;

select datname,client_addr,count(*) from pg_stat_activity group by datname,client_addr;

Test times of count(*)

EXPLAIN ANALYZE SELECT COUNT(*) FROM remitos;

Obtain rows(tuples) info

select * from pg_class where relname = 'remitos' and relkind = 'r';
select * from pg_stat_all_tables where relname = 'remitos';

and look at the n_tup_ins, n_tup_del, ...


references:
http://www.postgresonline.com/journal/archives/134-Terminating-Annoying-Back-Ends.html

Thursday, February 03, 2011

Salesforce Test Visual Apex Pages

1) Page.existingPageName

2) PageReference pageRef = new PageReference('partialURL');
PageReference pageRef = new PageReference('/apex/HelloWorld');

3) PageReference pageRef = new PageReference('fullURL');
PageReference pageRef = new PageReference('http://www.google.com');

4) PageReference pageRef = ApexPages.currentPage();

Executing page:
https://c.na7.visual.force.com/apex/SecondAccount


References

Displaying JIRA related information in Salesforce.com
http://www.customware.net/repository/pages/viewpage.action?pageId=62455956

Wednesday, February 02, 2011

Wireless Punto a Punto :: Requisitos x distancia

Enlace punto a punto(requisitos x distancias):

Enlace 3Km entre 02 locales:
02 Antenas Hyperlink de 15 dBi (U$ 73 c/u)
02 AP(AccessPoint) TRENDnet de 54 Mbps (U$ 107 c/u)
02 pigtail de 60 cm (U$ 25 c/u)

Puede lograr enlaces de hasta 7Km usando AP(TRENDnet , DLINK , LINKsys , Edimax)


Enlace 8Km:
02 Antenas Hyperlink de 24 dBi (U$ 107 c/u)
02 AccessPoint(AP) Trendnet de 54 Mbps (U$ 110 c/u)
02 pigtail de 2 metros (U$ 34 c/u)


Enlace 1Km:
02 Antena Hyperlink Flat Panel de 14 dBi (U$ 45 c/u)
02 AP TP-LINK 54 Mbps (U$ 79 c/u)
02 Pigtail de 60 cm. (U$ 22 c/u)


Referencias
http://www.ds3comunicaciones.com/
http://www.opcionweb.com/index.php/2008/03/04/tipos-de-antenas-wifi/

Saturday, January 15, 2011

Thursday, January 13, 2011

Reciclar encendedores

http://www.dogguie.com/reciclando-viejos-encendedores-desechables/?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+dogguie+%28Dogguie%3A+curiosidades%2C+rarezas+y+humor%29

Monday, January 10, 2011

Funny links II

Transformers
http://www.dogguie.com/transformers-hechos-con-chatarra/

http://dailyartcocktail.com/what-happens-when-cartoons-meet-art/?utm_source=wahoha.com&utm_medium=referral&utm_campaign=wahoha

http://www.usfunny.info/2011/01/indecent-behavior-of-couples-in-street.html

http://www.antaresonline.com/2011/01/07/the-best-butt-on-the-web/
http://www.sharenator.com/Wind_versus_Miniskirts/#/wind_vs_miniskirt3-13.html

Friday, January 07, 2011

PostgreSQL json fields

select name->'es_PE',* from product_template where name->>'es_PE' like '%MEGACI%'   References: [1] https:/...