Starting with Python

References
[1] http://www.vogella.com/articles/Python/article.html

[2] Python http://www.python.org/

OT 639G

http://www.startimes.com/f.aspx?t=33257571

Linux Multimedia BackTrack-Ubuntu

RMVB
http://leandronunes.org/2009/04/22/rmvb-no-linux-sem-complicacao/
Codecshttp://www.vivaolinux.com.br/artigo/Rodando-videos-.rmvb-no-Linux


1) Mp3 Player (xmms)
http://tombott.com/install_xmms_on_ubuntu_8.04_8.10_9.04_9.10_10.04_last.fm_scrobble


1.1) if you have dependency problems

[1.1.a] http://howik.com/Install_XMMS_on_Ubuntu_10.04
[1.1.b] https://launchpad.net/ubuntu/hardy/i386/libglib1.2ldbl/1.2.10-19build1
[1.2.c] https://launchpad.net/ubuntu/+source/gtk+1.2/1.2.10-18.1build2/+build/484191

if xmms don't play mp3, showing next message:

** WARNING **: oss_open(): Failed to open audio device (/dev/dsp): No such file or directory

then, change preferences:


xmms --> Preferences --> Audio I/O Plugins --> OSS Driver 1.2.10 --> Configure --> Audio Device

was changed from "Default (Intel HD Audio play output)" to "Use alternate device: /dev/dsp0"


2) MPLAYER
http://www.backtrack-linux.org/forums/showthread.php?t=25037

2.1) MPlayer dependency

gtk http://www.gtk.org/download/linux.php
  |
 +-- glib http://ftp.acc.umu.se/pub/gnome/sources/glib/
       |
      +-- libffi https://launchpad.net/ubuntu/+source/libffi/3.0.9-1

 +-- atk http://ftp.gnome.org/pub/gnome/sources/atk/
 +-- cairo https://launchpad.net/ubuntu/+source/cairo/1.8.10-2ubuntu1
    + https://launchpad.net/ubuntu/+source/pixman/0.24.4-1
 +-- pango http://ftp.gnome.org/pub/gnome/sources/pango/
 +--
 +-- gdk pixbuf http://ftp.gnome.org/pub/gnome/sources/gdk-pixbuf/

PHP & IIS7.5 Topics

My Server have:
  1) Windows 2008 R2
  2) IIS 7.5

I Installed using next resources:

[1]  PHP http://windows.php.net/download/
[2]  Microsoft 2008 C++ Runtime http://www.microsoft.com/en-us/download/details.aspx?id=30679


References:
[1] (Guide) http://www.iisunderground.com/installing-php-on-iis/
[2] http://sqlfromhell.wordpress.com/2009/12/21/instalando-o-php-no-iis-7-5/
[3] Include WordPress  http://zousu.com/wp/install-wordpress-with-iis-7-php-mysql/

Ringtones

Best ringtone Guitar/Violin/Instrumental

Resources:

[1] http://www.zedge.net/ringtones/

Who using my port 80/8080/8085/Other?

Windows Plataform

> netstat -aon  | grep "LIST"
> netstat -aon  | grep ":80" | grep "LIST"

*Get pid (Process id) and execute next command

>tasklist | grep "xxxx" 

* xxxx is pid value

Resume for W7


>netstat -aon  | grep ":80" | findstr "LIST"
>tasklist | findstr "xxxx" 
Linux Plataform
#lsof

or

#netstat -tulpn | grep :80

..continue


Notes:
If you mean MS-DOS then there's only FIND, as far as I know. But it's an ancient OS not used anymore.
If you mean NT(XP/2K/7/Vista)'s Command Prompt you can use find, findstr and grep if you download GnuWin32.
The basic differences are that findstr has some regex support. Grep supports regex best.

References:
[1] http://superuser.com/questions/300815/command-prompt-msdos-windows-7-grep-equivalent

Tools for Video Edit

1) Any Video Converter Ultimate
     flv/mp4 -> mpg/avi (common requirement)

2) Virtual Dub [Video Editor +/- Audio stream]
     http://www.free-codecs.com/virtualdub-mpeg2_download.htm

3) Audacity [Audio Editor]+ Pluging (Center Pan Remover/Vocal remover )
     http://audacity.sourceforge.net/

Vocal/Voice Remove Apps

I think Audicity pluging is best of below list

References
[1] http://mp3.about.com/od/essentialsoftware/tp/Top_Vocal_Removers.htm

Windows 7 Language Packs Offline

Both resources have reference to same files, then i think that's ok.


Resources:
[1] Windows 7 RTM  http://www.askvg.com/direct-download-link-official-links-to-download-mui-language-packs-for-windows-vista-and-7-both-32-bit-and-64-bit-versions-including-sp1-sp2/
[2] Windows 7 http://www.rtwincustomize.net/index.php?option=com_content&id=1360

Panoramics on line/off line (Panoramicas)

Referencias
[1] http://www.canaltotal.com/programas-para-montar-panoramicas/

jQuery Download using form+iframe

References
[1] http://www.djbp.co.uk/downloading-using-post/

Transport Layer Protection - ASP.NET

Tools:
[1] asafaweb.com

References:
[1] OWASP Top 10 for .NET developers part 9: Insufficient Transport Layer Protection 
      http://www.troyhunt.com/2011/11/owasp-top-10-for-net-developers-part-9.html
[2] ASP.NET session hijacking with Google and ELMAH
      http://www.troyhunt.com/2012/01/aspnet-session-hijacking-with-google.html
[3] Ramping up ASP.NET session security
      http://www.dotnetnoob.com/2013/07/ramping-up-aspnet-session-security.html

Arquitecturas multi tenant

Referencia:
[1] http://www.gravitar.biz/index.php/tecnologia_negocios/arquitecturas-multi-tenant/

SalesForce Security Revision - SSL Configuration Vulnerability

Resources:
[1] Setting Tool https://www.nartac.com/Products/IISCrypto/Default.aspx
[2] Scanner https://www.ssllabs.com/ssldb/index.html (Used by SalesForce Security Revision process)
[3] SSL Info http://www.serversniff.net

Asp.Net Insecure Session Cookie Handling Vulnerability

Add next code in c:\inetpub\wwwroot\web.config


    <system.web>
      <httpCookies
             httpOnlyCookies="true"
             requireSSL="true" />
    </system.web>


References:
[1] http://www.codeproject.com/Articles/291562/Asp-net-web-application-Security-Review-Dos-Dont
[2] http://forums.asp.net/t/1756774.aspx
[3] http://www.enterprisenetworkingplanet.com/netsecur/ten-tips-to-make-your-ssl-secure.html
[4] https://www.owasp.org/index.php/HttpOnly
[5] http://xss.cx/examples/dork/programming/ssl-cookie-without-secure-flag-set-example.html#1.7

IIS Custom Errors

1. Make html with custom message, and save that on any directory
    c:\inetpub\wwwroot\custom_errors\404.html
    c:\inetpub\wwwroot\custom_errors\500.html

2. Alter web.config of c:\inetpub\wwwroot, add next content.

<system.webServer> 

<httpErrors errorMode="Custom" existingResponse="Auto" defaultResponseMode="ExecuteURL">
  <clear />
  <error statusCode="404" path="/custom_errors/404.html" responseMode="ExecuteURL" />
  <error statusCode="500" path="/custom_errors/500.html" responseMode="ExecuteURL" /> 

</httpErrors> 

</system.webServer> 

References:
[1] http://stackoverflow.com/questions/434272/iis7-overrides-customerrors-when-setting-response-statuscode
[2] http://stackoverflow.com/questions/619895/how-can-i-properly-handle-404-in-asp-net-mvc
[3] http://stackoverflow.com/questions/717628/asp-net-mvc-404-error-handling

Aficionado al dibujo a Lapiz ( Como iniciar )

Referencias:
http://www.dibujemos.com

Generating Unique Key ID for Computer

Reference:
[1] http://sowkot.blogspot.com/2008/08/generating-unique-keyfinger-print-for.html

Claro Habla Gratis

Envia un SMS con el sgte formato(No te cobran los 3 primeros minutos):

La estructura del SMS (sin costo) al 779 es HG(espacio)(número voz 1)(coma)(número voz 2)(coma)(número SMS).

Nota: El número SMS puede ser también uno de los primeros y la recarga es de S/.15 mínimo al mes.


referencia:
[1] http://www.claro.com.pe/wps/wcm/connect/pe/claro-2013-peru/pc/personas/movil/prepago/promociones/habla-gratis

MS Access Client GUI (For Sql Commands)

References:
[1] http://www.albahari.com/  (Parallel programing/Threading and more )
[2] Query Express http://www.albahari.com/queryexpress.aspx
[3] LinqPad http://www.linqpad.net/

API Key Google Maps

https://code.google.com/apis/console#sthash.FclYhbcs.dpuf

https://code.google.com/apis/console#sthash.FclYhbcs.dpuf

https://code.google.com/apis/console#sthash.FclYhbcs.dpuf

Ir a:

ttps://code.google.com/apis/console#sthash.FclYhbcs.dpuf

https://code.google.com/apis/console#sthash.FclYhbcs.dpuf

https://code.google.com/apis/console#sthash.FclYhbcs.dpuf

https://code.google.com/apis/console#sthash.FclYhbcs.dpuf

https://code.google.com/apis/console#sthash.FclYhbcs.dpuf

https://code.google.com/apis/console#sthash.FclYhbcs.dpuf

https://code.google.com/apis/console

Referencias:

[1] http://www.nonomartinez.com/2012/03/13/como-crear-una-api-key-para-google-maps-v3

MoSync over W7

MoSync no yet support 64bits, then after installation you get message related to jvm.dll

Solution:
Install standalone Java 32bits, over C:\Program Files(x86)\Java, then after installation of moSync you need create new shortcut.

C:\MoSync>C:\mosync\eclipse\mosync.exe -vm "C:\Progra~2\Java\jdk1.6.0_17\jre\bin\server\jvm.dll" eclipse.vm="C:\Progra~2\Java\jdk1.6.0_17\jre\bin\server\jvm.dll
" java.home="C:\Progra~2\Java\jdk1.6.0_17\jre" java.runtime.version=1.6

Nod32 best serials

Validos
Vencimiento U                  C
25/03/2014 EAV-84218011 fk3tv8p57v

Serial 1
http://actualizatu-nod32.blogspot.com/
Otros
http://serialnod32gratis.blogspot.com.br
http://nod32-serial.blogspot.com/
http://www.archivogeek.com/windows/software/username-y-password-serial-para-nod32/

Series

[1] http://www.exvagos.com
     Frasier Temporadas 1-11

VMWare resume problem

    1) Delete .VMSS files.
    2) Delete any .lck directories.

[References]
[1] http://serverfault.com/questions/27219/vmware-6-5-virtual-machine-fails-to-resume-after-suspend

Xcode 4.2 installation requeriments on vmware 7.1.4

Monoprocesador ACPI de PC
CPUID : AMD Sempron(tm) 140 Processor
Velocidad de reloj original  2700 MHz
Memoria del sistema 2048 MB  (DDR3-1333 DDR3 SDRAM)
Placa de video ATI Radeon HD 5450  (1024 MB)

Note:
a) Parameters for start -v cpus=1 busratio=4
b) For others machines try use cpu-z and divide Score speed / Bus speed ~  busratio


1) Install Mac OSX Snow Leopard 10.6.6 Intel AMD Vmware Image
http://thepiratebay.se/torrent/6120172

2) OSX Snow Leopard 10.6.7 update (Xcode 4.2 works with OSX 10.6.7)
http://download.info.apple.com/Mac_OS_X/041-4916.20110321.Sx74f/MacOSXUpd10.6.7.dmg


3) Download and Install Xcode 4.2
http://thepiratebay.se/torrent/6721955
   3.1) Enable Root user
          * Go -> /System/Library/CoreServices/
          * Launch “Directory Utility” and Unlock using the padlock icon and entering the administrator password (empty for this case).
          * Edit -> Enable Root User
   3.2) if fail xcode installation, then change system date before to 03-2012
          #date 0101000012 (01 of January of 2012)
4) After installation(for execute)

open -a /Developer/Applications/Xcode.app

or

open -a Xcode.app

References:

[1] http://osxdaily.com/2011/03/21/mac-os-x-10-6-7-update-download/
[2] Enable root http://osxdaily.com/2012/01/09/enable-root-user-account-os-x-lion/

SSL Certificates and IIS7

Resources:
[1] http://www.digicert.com/csr-creation-microsoft-iis-7.htm
[2] http://support.godaddy.com/help/article/5343/instrucciones-para-generacion-de-solicitud-para-firma-de-certificado-csr?locale=es
[3] https://www.globalsign.com/support/install/install_iis7.php
[4] http://weblogs.asp.net/scottgu/archive/2007/04/06/tip-trick-enabling-ssl-on-iis7-using-self-signed-certificates.aspx

[3] Comparison http://en.wikipedia.org/wiki/Comparison_of_SSL_certificates_for_web_servers
[4] 90 days free http://www.instantssl.com/ssl-certificate-products/free-ssl-certificate.html
[5] http://www.godaddy.com/ssl/ssl-certificates.aspx?isc=sshl5la05&ci=8979

Flip Book Maker

Free Alternatives


[1] http://www.boxoft.com/flip-book-maker (Windows/Max)
[2] * http://www.flippdf.com/free-page-flip-book-maker/ 

Private Alternatives
[1] http://www.flipsnack.com (Online)
[2] kvisoft flipbook maker pro

Host File Browser

Some times you need explore your files in your host server, here you have tools for that.


References:
 [1] http://www.vonloesch.de/filebrowser.html
 [2] Download  http://www.4shared.com/zip/B2XFPfrI/jspbrowser.html

CRM Companies

Below we have referenced the top online CRM companies providing services today.

References:


[1] http://crm-software-review.toptenreviews.com/
[2] http://www.thetoptens.com/best-online-crm-companies/

jQuery MultiSelect work using jQuery 1.9.1 and jQuery-ui-1.10.3

Version 1.13 - 08/19/2012
==============================================
- Fixed: jQuery 1.8 compatibility

We using multiselect, that work fine using jquery 1.8-ui, but we need migrate jquery to  jQuery 1.9.1 and jQuery-ui-1.10.3.

for that we changed source jquery.multiselect.filter.js (line 29)

   instance = (this.instance=$(this.element).data("echMultiselect")),/*fix for jquery 1.10.3*/ /*multiselect")),*/


References:


[1] http://www.erichynds.com/examples/jquery-ui-multiselect-widget/demos/

jQuery Addons

jQuery Contdown
http://keith-wood.name/countdown.html

Tree View con jQuery
http://bassistance.de/jquery-plugins/jquery-plugin-treeview/

Tooltip
[1] http://patelshailesh.com/index.php/css-tooltip-on-mouse-hover
[2] http://www.queness.com/resources/html/tooltip/jquery-tooltip-queness.html
[3] http://www.filamentgroup.com/examples/fg-tooltip/

C# Windows Services and Logs

References:

[1] http://www.codeproject.com/Articles/14353/Creating-a-Basic-Windows-Service-in-C
[1.1]  http://www.codeproject.com/Articles/3990/Simple-Windows-Service-Sample
[2] http://blog.themobilebrand.com/technology/tutorial-building-a-windows-service-application/
[3] http://www.c-sharpcorner.com/UploadFile/mahesh/window_service11262005045007AM/window_service.aspx

[4] C# log4net http://www.eyecatch.no/blog/2012/08/logging-with-log4net-in-c-sharp/
[5] C# log4net http://www.codeproject.com/Questions/377372/Log4net-not-working-No-Logs-created

[6] Windows event log http://msdn.microsoft.com/en-us/library/6s7642se.aspx

Audio Streaming

References
[1] Shoutcast DSP + Winamp  http://howto.slserver.com/?cat=10
[2] GStreamer http://gstreamer.freedesktop.org/features/
[3] Share speaker player http://www.extendoffice.com/product/share-speaker-player.html

C# Send/Read SMS using MT6225(Chine) Cellular

Code works over Windows XP/Sp2 + VS2008, problem is on Windows 7/x64


First you need download/install driver for Windows 7 from [1], after that download c# sample from [2].
for understand code, you need know At commands, that code only send AT command to Comx for interchange information with the cellular phone.
Same usually commands:

AT 
  (if result is OK, then connection is good)
AT+CMGF=1
    (Set message format  0:New/1:Read)
AT+CMGF?
    (Read current setting)
AT+CMGF=?
    (Show list possible values) 
AT+CMGL="ALL"
    (List of all messages)

Classic sequence:
AT+CMGF=1
AT+CMGL="ALL"

References:
[1] MT6225 for W7/x64 Driver http://hotfile.com/dl/42358552/cb0f022/MTK6227_Driver__For_XP__Vista.rar
[2] C# Source Code for test http://www.elguille.info/colabora/NET2006/mauro_melgar_envio_sms.htm
[3] AT Commands http://www.telit.com/module/infopool/download.php?id=542

Crear Instalador / Make installer tools

Resources:
[1] NSIS  http://nsis.sourceforge.net/Main_Page
[2] WiX http://sourceforge.net/projects/wix/
[3] Advanced Installer http://www.advancedinstaller.com/
[4] Inno Setup http://www.jrsoftware.org/isinfo.php
[5] http://www.createinstall.com/cifree/

Report Viewer/Crystal Report Resources

Resources:

[1] Crystal Reports Redistributable 64 bit http://cdm.codeplex.com/releases/view/99744
[2] Crystal Reports for VS2008 http://cdm.codeplex.com/downloads/get/141449
[3] Crystal Components searcher https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/bobj_download/main.htm
[4] http://geeks.ms/blogs/fernandezja/archive/2007/08/19/setup-project-insertar-crystal-report-merge-module.aspx

[5] Microsoft Report Viewer 2012 Runtime http://www.4shared.com/rar/eO4YZbTM/Microsoft_Report_Viewer_2012_R.html

[6] http://geeks.ms/blogs/fernandezja/archive/2007/08/19/setup-project-insertar-crystal-report-merge-module.aspx

Resolve/Prevent Reflected XSS All Clients on (ASP.NET MVC)

Resources
[1] http://www.slideshare.net/denimgroup/xss-remediation
[2] https://www.owasp.org/index.php/Reviewing_Code_for_Cross-site_scripting
[3] Event 1046 - Cross-Site Scripting Filter http://msdn.microsoft.com/en-us/library/dd565647%28v=vs.85%29.aspx
[4] http://weblogs.asp.net/scottgu/archive/2010/04/06/new-lt-gt-syntax-for-html-encoding-output-in-asp-net-4-and-asp-net-mvc-2.aspx
[5] http://msdn.microsoft.com/en-us/magazine/hh708755.aspx
[6] Microsoft Web Protection Library http://wpl.codeplex.com/

Replicate mySQL Database

References:
[1] http://top-performance.blogspot.com.br/2012/03/how-to-setup-mysql-replication-in-11.html
[2] http://www.rackspace.com/knowledge_center/article/mysql-replication-masterslave

Salesforce tools for pass security revision

Resources:

Burp Suite (free edition)
[1] http://portswigger.net/burp/download.html

Proveedores de hosting económicos

Recursos:
[1] http://www.microeb.net/hosting.php
[2] http://www.aqphost.com/general/hosting/planes-hosting-linux.html
[3] Dominio 10.95 €+Hosting Gratis (10Mb) https://www.cdmon.com/cas/dominios/
[4] Top webpages http://www.alexa.com/
[5] Enlazar un dominio y blogspot.com http://tirandodeblog.blogspot.com/2009/10/usar-un-dominio-propio-en-blogger.html

Unix commands over Windows

Downloads:
[1] classic commands http://sourceforge.net/projects/unxutils/

Extend USB with UTP (20mts) Solved!

White Orange & Orange <=> Red
White Green <=> White
Green <=> Green
Rest <=> Black.


References:

[1] http://www.instructables.com/id/How-to-Extend-yout-USB-using-UTP/step2/The-making-of-Part-1/
[2] http://tutallerdebricolaje.com/como-hacer-un-alargador-o-extensor-usb/
[3] http://forums.hardwarezone.com.sg/mass-order-corner-251/mo-power-over-ethernet-poe-convertor-turn-any-ip-camera-into-poe-device-3826552.html

Linux::Network configuration::CentOS

1) Configure by console interfaces
system-config-network
system-config-securitylevel-tui
/etc/init.d/network restart
/etc/init.d/NetworkManager restart
service network restart

2) Working by scripts
2.1) Static

vi /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=none
BROADCAST=192.168.1.255
HWADDR=00:11:22:33:44:55
IPADDR=192.168.1.x
NETMASK= 255.255.255.0
NETWORK= 192.168.1.0
ONBOOT=yes
GATEWAY= 192.168.1.y
TYPE=Ethernet

2.2) DHCP
DEVICE=eth0
BOOTPROTO=dhcp
ONBOOT=yes

vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=www.kusaconsultores.com
GATEWAY=192.168.1.1

vi /etc/resolv.conf
nameserver 200.48.225.130
nameserver 200.48.225.146

/etc/init.d/network restart

References:
[1]http://rm-rf.es/como-configurar-tarjetas-de-red-en-red-hat-enterprise-centos-y-fedora-core/
[2]route
http://systemadmin.es/2009/04/anadir-rutas-route-add-en-centos

Trying Mount W7 Image (Ghost) over VMWare

Problem:
I need start Virtual Machine with W7, so  i don't have DVD Installer, but i have W7 image (created with Norton Ghost).

I Think make one iso file with W7 image for mount that, next mount ghost boot tool for restore from W7 iso file, but ghost not read files from iso mounted.

One alternative is mount USB as Hard Disk, but now my usb have only 4Gb (image file is ~ 7Gb )
I Think too mount iso image over virtual drive using winmount http://www.winmount.com/winmount-free.html


 VMware vCenter Converter StandAlone (tool for convert your physical computer to virtual machine)

thinking more, then i choice one solution very very crazy.

I try shrink my physical partition for add one aditional partition using Computer Management, Disk Managment (10Gb), then attach that new partition on VMWare Disk and try  restore image with Ghost.

So,  Microsoft Windows Server 2008 R2 – Media is write protected. For resolve that you need execute next commands.

cmd
diskpart 
list disk
select disk N
attributes disk clear readonly


* Too i try put .gho file into .iso for mount then restore, for that i need use iso editor, por example poweriso:
http://www.poweriso.com/download.htm  (v5.6)
Name: TEAM CRUDE
Key   : MIT68-I7WLE-CAGZN-DJYPR-PVNE4

* Alternatives
http://www.magiciso.com/download.htm
http://www.minidvdsoft.com/isocreator/

* Ghost32 ( For Convert .gho to .vmdk )

>ghost64 -clone,mode=restore,src=AmdW7-100.GHO,dst=toW7-100.vmdk -batch -sure

[1] http://www.mediafire.com/download/s2xp8f734b5a5xa/Ghost32_ghost64_11.5.1_Symantec.rar
[2] Convert .gho to .vmdk using ghost32 http://www.gregoryaubry.com/virtualisation-2/converting-image-file-format-from-gho-to-vmdk-and-from-vmdk-to-gho-symantec-connect/

*Plop BootManager (force boot from USB on VMware) http://www.plop.at/en/bootmanager/download.html

* System Repair Disk (ISO) http://www.windowsreinstall.com/winre/createfromiso/#Downloads


* http://www.filecrop.com (for search resources)

Sql Server 2008 Mirroring Tips

Problem:
  *, **, ***
Solution:


Common Error Messages:
1) The server network address TCP:// can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.



References:
[1]Mirroring vs Replication and Others http://nilebride.wordpress.com/2011/07/24/log-shipping-vs-mirroring-vs-replication/
[2] Introduction http://www.guillesql.es/Articulos/database_Mirroring_SQL_Server_2005_2008.aspx

[3] High Recomended http://www.mssqltips.com/sqlservertip/1705/implementing-database-mirroring-in-sql-server-2005-across-domains/

[4] Resume http://blog.capside.com/2012/04/10/como-configurar-db-mirroring-utilizando-certificados-sql-server-2008-r2-db-mirroring-untrusted-servers-using-certificates/
[5] Mirroring 2008 using GUI http://www.databasejournal.com/features/mssql/article.php/3828341/Database-Mirroring-in-SQL-Server-2008.htm
[6] *  http://blog.sqlauthority.com/2010/01/11/the-server-network-address-tcpsqlserver5023-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-that-the-ports-for-the-local-and-remote-endpoints-are-operational-microso/
[7] ** http://www.gknzcfc.net/subsite/server-tcp-provider-failed-to-listen-on-1433-tcp-port-is-already-in-use.html
[8] *** https://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/
[9] SQL Server Data Encryption http://selfhandle.com/post/2011/08/05/How-to-enableremove-Transparent-Data-Encryption-%28TDE%29.aspx

Nucom model R5000UNv2 Settings (Enable VNC ports by telnet)

Problem:
I need open vnc port 5900/5901 but i don't acces to GUI console(Web), only i have access to network by ssh. Then i need login to router and try set that with commands.


Syntax:

natp add <name> <WAN Interface> <TCP/UDP|TCP|UDP> <External Port(start:end)>
              <Internal Port(start:end)> <ipaddr>

 
#telnet 192.168.1.1


> wan show   # for show wan interfaces

> natp show table # for show current settings

> natp add vncport ppp0 TCP/UDP 5901:5901 5901:5901 192.168.1.100

ready!

Notes:
* Try use TP-Link W8960N for bandwidth control.
* If router mac is AABBCCDDEEFF try use BBAADDCCFFEE and user admin (Probably work)

References:
[1] http://www.adslzone.net/postt276042.html

Alternatives to dyndns (dyn.com)

dyndns.org/.com -> dyn.com (you need log to panel at least one time /month)

Alternatives:
 a) https://dynu.com
 b) http://freedns.afraid.org



References

[1] Server Software/Dns & DDns Providers http://www.dyndnsservices.com/tech.htm
[2] Providers list http://dnslookup.me/dynamic-dns/

Impresora Ticketera

POS-D, SP-POS76IIRC
http://poshttp://www.blogger.com/img/blank.gif-d.com/

Driver
http://www.4shared.com/rar/3kcX-tck/Driver-posd-matricial_SP76II.html

Deprecated, then use generic driver on W7 and others different to XP.

Tools Resource:
[1] Adding generic values https://pos-x.com/support-article/printer-installation-workaround-thermal/

[2] PDF Printer https://www.pdfforge.org/pdfcreator/download

Smtp Server over Windows 7

Remote Server Administration Tools for Windows® 7 with SP1
http://www.microsoft.com/en-us/download/details.aspx?id=7887

hMailServer





http://www.hmailserver.com/index.php?page=download

SQL Server same versions and limits

SQL Server 2008 Express has a 4 GB limit on database size 
SQL Server 2008 R2 Express has 10 GB.

Windows Server 2008 R2 Evaluation (180 days)

http://www.microsoft.com/downloads/details.aspx?familyid=BA571339-5436-4CF5-9C37-6ED7DAB6F781&displaylang=en

Sunat: impuesto por cuarta categoría/recibo por honorarios.

Declarar recibos por honorarios en PDT 601

Calcule su impuesto por cuarta categoría. http://mass.pe/node/305

SUNAT - RECIBOS POR HONORARIOS - EJERCICIO 2013

http://www.khronos.com.pe/SUNAT-RECIBOS-POR-HONORARIOS.html

Ejemplos: http://www.forosperu.net/showthread.php?t=174125 (Leer respuestas)

Php Mvc

References
[1] http://anantgarg.com/2009/03/13/write-your-own-php-mvc-framework-part-1/
[2] http://www.ajaxline.com/10-best-php-frameworks-and-cms

http://stackoverflow.com/questions/11770104/cms-routing-in-mvc
http://stackoverflow.com/questions/7361638/does-anyone-know-a-good-php-cms-built-on-a-mvc-framework

http://codereview.stackexchange.com/questions/14550/mvc-structured-cms

Emulate Virtual CD/DVD-RW

Alternatives

  A) TotalMounter http://www.kernsafe.com/download/totalmounter.aspx
  B)  Phantom Drive http://zonadictoz.org/programas/38436/emular-virtual-cd-rw-dvd-rw-bluray.html

References:
[1] Best Free CD-DVD Emulation Software http://www.techsupportalert.com/best-free-cd-emulator.htm

free Spotify

1. Download Spotify http://www.spotify.com/download/?autodl
    If not download first download TunnelBear and try Download Spotify
2. Download TunnelBear (Windows/Mac/Android/iPhone/etc), VPN with Limit 500mb/Month
   http://www.tunnelbear.com/download/

3. Install TunnelBear and Spotify
4. Start TunnelBear(is necessary have one login, that is free), after started you computer is part of VPN on EEUU,UK, etc.
5. Start Spotify, Login (waith 1/2minutes, spotify verify your geolocation by IP). After you login, close TunnelBear.
6. Search and Play some music.

Note:

Same times spotify verify your geolocation and that is disabled, for enable you only need start again TunnelBear for get new IP on virtual VPN, login into Spotify and wait 1/2 minutes and close TunnelBear.

Google Maps Custom Location(Marker) Icon

Resources
[1] http://mapicons.nicolasmollet.com/markers/friends-family/home/
[2]  Shadow marker http://www.cycloloco.com/shadowmaker/shadowmaker.htm
[3]  Custom overlay dialog http://a32.me/2012/03/position-custom-and-fancy-overlay-dialog-on-google-maps-v3/
[3] Test only code using google maps http://jsfiddle.net/ymLvv/
[3] https://www.geocoderpro.com/en/resources/map-icons-marker-pins/
[4] http://weblogs.asp.net/raduenuca/archive/2011/11/12/pin-my-friends-application-using-google-maps-and-facebook-apis-part-1-introduction.aspx
[5] Library places https://developers.google.com/maps/documentation/javascript/places

Ip Camera (Camaras Ip) - Surveillance (Video Vigilancia)

Resources:
[1] Apexis Download http://www.apexis.com.cn/en/download.html
[2] Store in Perú http://tienda.gratelperu.com/
[3] Catalog in spain http://www.twistedtienda.com/camaras-ip-apexis-c-136_143.html
[4] Webcam to Network/Internet http://forums.logitech.com/t5/Webcam-General-Discussion/Windows-Media-Encoder-9-amp-Your-Logitech-Webcam/m-p/132190
[5] Webcam to Home Network VLC http://www.computeractive.co.uk/ca/step-by-step/1931353/stream-webcam-video-home-network
[6] Make own project http://hpwren.ucsd.edu/news/20060712/
[7] http://www.dragonjar.org/convierte-tu-webcam-en-una-camara-de-vigilancia.xhtml
[8] http://nokitel.im/index.php/2011/02/20/convert-usb-webcam-to-ip-camera/

Extend Usb using RJ45
 [1] http://www.forosdeelectronica.com/f15/aporte-crear-alargador-usb-cable-utp-cable-red-rj45-economico-45604/
 [2] http://www.malditonerd.com/howto-extender-un-cable-usb-por-utp-usb-a-rj45/
Software
[1] Webcam stream http://ip-webcam.appspot.com/

VMWare Tools : WinMount & VMWare Converter

[1] Montar archivoa VMDK http://www.winmount.com/mount_vmdk.html

[2] Virtualizar servidor físico a VMWare http://www.bujarra.com/ProcedimientoVMWareConverter.html

Registro de Software en Indecopi

En el 2008 [3] Pagar un derecho de solicitud equivalía al 32.50 % de la UIT= S/. 1137.5 nuevos soles
Hoy en dia 2013 [1,2] tiene un costo de 390.50 nuevos soles equivalente al 10.85%.
Válido por 10 años.


Referencias
[1] Indecopi http://www.serviciosalciudadano.gob.pe/bus/PSC_Tramite_Historico.asp?id_entidad=10006&id_hist=579&Tramite=8919
[2] Indecopi http://www.indecopi.gob.pe/0/modulos/JER/JER_Interna.aspx?ARE=0&PFL=9&JER=121
[3] 2008 http://lpviii.blogspot.com/2008/09/software-propietario.html

W7 No se puede tener acceso ( recurso compartido )

Ademas de compartir el recurso y agregar los permisos se requiere lo sgte:

 

1) Centro de Redes y recursos compartidos 

  1.1) Cambiar configuración de uso compartido avanzado,       

    1.1.1) Casa o trabajo (perfil actual), 

           Dentro en la opción Uso compartido con protección de contraseña, 

           Activar la opción Desactivar el uso compartido con protección con contraseña.

 

 

 

ApexPage - Button Edit and Delete with Refresh

Reference
[1] http://salesforcesource.blogspot.com/2009/09/edit-and-delete-command-for-your.html

ApexPage dataTable

 
<apex:dataTable value="{!myCollection}" var="item">
  <apex:column >  <apex:outputField value="{!item.field1__c}"/>  </apex:column>

  <apex:column >  <apex:outputField value="{!item.field2__c}"/>  </apex:column>

  <apex:column >  <apex:outputField value="{!item.field3__c}"/>  </apex:column> 

</apex:dataTable>      
      
      

References:
[1] http://blog.jeffdouglas.com/2010/04/02/visualforce-row-counter-for-iteration-components/

Alternative Browsers Based on Mozilla Firefox

Portable browsers
http://portableapps.com/apps/internet

Browsers based on firefox

[1] http://www.howtogeek.com/108608/6-alternative-browsers-based-on-mozilla-firefox/

Visual Studio 6.0 Over W7

 - Copy setup/vs98ent.stf  /acmsetup.stf- Copy setup/* to /- Execute /acmsetup.exe 
Note: The file vs98ent.stf or vs98pro.stf

Install Service Pack 6 de VS6.0

Change vb98pro.stf or vs98ent.stf  to acmsetup.stf
Execute acmsetup.exe for start installation  Other tip (Aboout Java)  Install the Sun Java VM (Well Oracle now)
Edit the file Setupwiz.ini, and change the line

VmPath=ie4\msjavx86.exe

to (in my case)

VmPath="C:\Program Files\Java\jre6\bin\java.exe"

VS2008 over W7 Error: gencomp320

Method 1:

That problem is because InfoPath Component of Office 2007. Then you need remove that.


over   Start/Run type:

msiexec /x {30120000-0044-0C0A-0000-0000000FF1CE}


Method 2:
1. Go to the Add/Remove Programs control panel by clicking on the Start menu, choosing Run, typing appwiz.cpl and clicking OK
2. Locate the item named Microsoft Visual Studio Web Authoring Component and choose to uninstall it
3. Try to run VS 2008 setup again

C# Read/Write INI Files

[DllImport("kernel32")]
private static extern long WritePrivateProfileString(string section,string key,string val,string filePath); 

[DllImport("kernel32")]
private static extern int GetPrivateProfileString(string section,string key,string def, StringBuilder retVal, int size,string filePath);

References
[1] http://www.codeproject.com/Articles/1966/An-INI-file-handling-class-using-C
[2] http://jachman.wordpress.com/2006/09/11/how-to-access-ini-files-in-c-net/
[3] http://code.google.com/p/ini-parser/

C# Export to Excel

References:
[1] EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx). http://epplus.codeplex.com/
[2] C# Class for Export DataTable To Excel with Interop http://alandjackson.wordpress.com/2011/01/07/c-export-to-excel-with-interop/
[3] Version of POI Java project at http://poi.apache.org/. POI is an open source project which can help you read/write xls, doc, ppt files. http://npoi.codeplex.com/releases
[4] Sample of NPOI http://www.leniel.net/2009/07/creating-excel-spreadsheets-xls-xlsx-c.html#sthash.5qgu3AiY.dpbs
[5] Good sample for export to excel file http://www.codeproject.com/Articles/20228/Using-C-to-Create-an-Excel-Document

mySQL Store procedures

CREATE DEFINER = 'root'@'%' PROCEDURE `queryf2`(
        IN id varchar(8)
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN 
   START TRANSACTION; 
   SELECT * FROM PRODUCTOS_STOCK ps where ps.IdSucursal=id; 
   COMMIT; 
END;

references:


[1] Stored Procedure that returns random rows from a table
      http://www.it-iss.com/mysql/mysql-stored-procedure-that-returns-random-rows-from-a-table/

VS2010 Over Windows XP SP2

Using regedit go to:

HKEY_LOCAL_MACHINE\SYSTEM\ CurrentControlSet\ Control\ Windows

chnage CSDVersion from “0×00000200” (SP2) to the Windows XP SP3 value of “0×00000300”

After that, is possible install VS2010


References:

[1] http://syed-wajih.blogspot.com/2011/05/convert-windows-xp-sp2-into-sp3-without.html

Linux Burning CD/DVD

#mount -t iso9660 /dev/sr0 /media/cdrom/


root@bt:/mnt/shared# cdrecord --scanbus
scsibus0:
        0,0,0     0) 'ATA     ' 'ST340014A       ' '8.54' Disk
        0,1,0     1) 'HL-DT-ST' 'DVD-RAM GSA-H55N' '1.03' Removable CD-ROM
        0,2,0     2) *

scsibus4:
        4,0,0   400) 'SMI     ' '  Reader        ' '1.00' Removable Disk
        4,1,0   401) *
        4,2,0   402) *

#cdrecord -v -eject speed=8 dev=0,1,0 filename.iso

References

[1] Software(Rpm/Deb) http://pkgs.org/download/cdrecord
[2] http://www.andrews-corner.org/burning.html
[2] http://www.brandonhutchinson.com/Burning_CDs_with_cdrecord.html
[3] http://www.ibm.com/developerworks/library/l-cdburn/index.html
[4] GUI Apps http://www.techdrivein.com/2011/03/9-good-cd-and-dvd-burning-tools-for.html

mySql Innodb recovery

InnoDB (.ibdata, .ibd and .frm) 
MyISAM (.myd, .myi and .frm) 


[1] https://launchpad.net/percona-data-recovery-tool-for-innodb
[2] http://blog.shiraj.com/2012/10/extract-data-from-mysql-ibdata1-data-file/
[3] http://linuxrnd.blogspot.com/2011/12/mysql-recover-data-using-ibdata1.html
[4] http://getasysadmin.com/2012/08/recover-mysql-innodb-database-from-ibdata1-and-frm/

Linux(Fedora) Enable mySql remote connection

Verify Service
#service mysqld status
#service iptables status

Add mySql deamon everytime

#chkconfig --level 2345 mysqld on

Firewall
#vi /etc/sysconfig/iptables


-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 21 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT  #mySQL Port

On MySQL


#mysql -u root

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit

References
[1] http://linuxers.org/howto/how-install-mysql-server-fedora

Linux Fix NTFS and Video Setting

Enable fsck.ntfs

ln -s /usr/bin/ntfsfix /usr/sbin/fsck.ntfs

ln -s /usr/bin/ntfsfix /usr/sbin/fsck.ntfs-3g

[root@lucas]# fsck /dev/sdb1

On BT5

The following worked with no fuss:

# Xorg -configure
# cp /root/xorg.conf.new /etc/X11/xorg.conf
# startx

And that’s it!

On BT4

Note to self.  To fix the screen resolution for X on a host running BackTrack on VirtualBox…

Modify the “Screen” section in /etc/X11/xorg.conf to read as follows:

Section "Screen"
Identifier           "Default Screen"
Monitor             "Configured Monitor"
Device               "Configured Video Device"
DefaultDepth     24
SubSection "Display"
Depth    24
Modes   "1024x768" "800x600"
EndSubSection
EndSection

Linux RAID 1(Mirroring/Espejo)

The two disks have next configuration (RAID Partition and RAID Volumen)

/boot (500mb)
/swap ( N  + 2GB), N is your RAM size.
/ (max free)

Note: If you have message Only RAID0 arrays can contain growable members

 try use 1024*N for / partition, N for max free space.

References:

[1] http://www.unixmen.com/install-raid-1-in-fedoracentosrhel/
[2] http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch26_:_Linux_Software_RAID#.UOyvTNelsdA
[3] http://www.ping.co.il/node/1/
[4] http://docs.fedoraproject.org/es-ES/Fedora/13/html/Installation_Guide/Create_Software_RAID-x86.html
[5] Reset Fedora Password (3 Modes) https://fedoraproject.org/wiki/How_to_reset_a_root_password