Wednesday, May 29, 2013

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

Thursday, May 23, 2013

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)

Wednesday, May 22, 2013

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


Monday, May 20, 2013

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




Friday, May 17, 2013

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/









Friday, May 03, 2013

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)

Thursday, April 18, 2013

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

Wednesday, April 17, 2013

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.



Friday, April 12, 2013

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/

Ubuntu Forware port 80

  #!/bin/bash iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8069 iptables -t nat -A PREROUTING -i eth0 -p tc...