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