yorch @ web [in]

Check standards or quirks mode on IE6

yorch — Mon, 19 Dec 2011 15:12:04 +0000

To check if a given website is running on standards or quirks mode on IE6, enter the following text on the URL and press enter: javascript:alert(document.compatMode) Depending of what you get, you can tell which mode you are running: CSS1Compat: Standards Mode BackCompat: Quirks Mode

Redirect WWW to non-WWW using Apache (htaccess)

yorch — Sat, 19 Nov 2011 17:32:53 +0000

The easiest way to redirect all your traffic from a WWW address (like www.domain.com) to a non-WWW (like domain.com) is using the following code: RewriteEngine On RewriteCond %{HTTP_HOST} ^www\.(.+)$ [NC] RewriteRule ^(.*)$ http://%1/$1 [R=301,L] With this code, you don’t need to hard-code the name of the domain into the .htaccess file. Apart from the fact [...]

Recursively copy from a FTP server

yorch — Fri, 18 Nov 2011 22:50:38 +0000

In Linux (and also in the World of Windows), there is a small great tool called wget (you probably already know it, it’s pretty popular). I have been using it for some years know as it is very convenient for downloading files (or even entire HTML websites) from the command line (specially when you manage [...]

Nginx newest version on Ubuntu Lucid 10.04 LTS

yorch — Mon, 14 Nov 2011 23:26:49 +0000

Some time ago I wrote a post regarding this same topic (installing an updated version of Nginx instead of the one that is on the official Ubuntu repositories) but for Hardy (8.04). Now, it is the turn of the latest Long-Term-Support version of this Linux distribution. In this case, we need to use this repository: [...]

Windows 7 failing to copy large files through network

yorch — Thu, 13 Oct 2011 19:30:47 +0000

I have faced problems copying large files (several hundreds megs) over a Windows Network between two Windows 7 boxes. During the copy, the process just freeze forever, and when trying to cancel it, it just tries forever without success. At first I tough it was a antivirus/firewall issue, but disabling the software on both machines [...]

Two ways to check if a Registry Key exists using VBScript

yorch — Wed, 05 Oct 2011 21:15:46 +0000

The first one is using the method RegRead from WScript.Shell. If the given key is not found, it will rise an error, so we need to use an On Error Resume Next (which I don’t really like). We would need to pass to the function a string like HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ (note the trailing \) if we [...]

Android useful links (iPhone SMS to Android, ADB driver install, hacking)

yorch — Fri, 30 Sep 2011 14:17:22 +0000

Here are some links I found useful: iPhone SMS to Android Converter (step by step how to migrate your SMS from iPhone to Android) [Tutorial] ADB Driver Android 1.0 Install (helped me install the ADB driver for my HTC Desire by modifying the INF file) FAQ Android Hacking (glossary of terms) How to remove Sense applications

Android FAQ – HBOOT and rooting

yorch — Thu, 29 Sep 2011 18:36:12 +0000

I found this information on AndroidForums and it is very helpful, so just wanted to keep it (maybe it helps someone else also): What’s HBOOT? It’s immediately loaded when the phone is switched on. It’s mostly responsible for checking and initialising the hardware and starting the phone’s software, for flashing official software releases (RUUs via Fastboot), [...]

Denyhost: Permanently whitelist a host

yorch — Sun, 04 Sep 2011 00:29:14 +0000

Thanks to this site, I found an easy way to whitelist a host when using denyhosts. Just need to create a file called allowed-hosts with the IP addressses you want to whitelist inside /var/lib/denyhosts (or the work directory in your box). In my case, I found very useful to whitelist the localhost address (127.0.0.1) to [...]

Install updated version of nginx on Ubuntu Hardy 8.04LTS

yorch — Thu, 26 May 2011 14:26:59 +0000

Nginx is a great web server to handle tons of traffic with relative low resources, it beats Apache big time. I have started using it as a Reverse Proxy, Load Balancer, Web Cache and static files web server (like images, javascript and CSS) in front of Apache (for PHP processing). I’m more than amazed with [...]

Change timezone on PHP

yorch — Wed, 23 Mar 2011 00:04:05 +0000

There are some methods that allows you to change the timezone of the PHP (5.1+) scripts (ie, when the date is not shown due to a different timezone of the server). The first one is by modifying the php.ini file of the web server (if you are allowed to). We just need to add the following line: [...]

Debian/Ubuntu’s apt behind a proxy

yorch — Thu, 27 Jan 2011 22:10:30 +0000

To allow the Advanced Packaging Tool, or just APT for friends to do its job when the box is behind a proxy, we can use one of the following options. From the command line (this will only work for the session we are working on): export http_proxy=http://username:password@server:port Or if the proxy does not require a username: [...]

Enable or Disable Check Constraints on SQL Server

yorch — Mon, 22 Nov 2010 21:07:21 +0000

I found a very handy SQL script on this post, that allows you to enable or disable all constraints on a database. The only problem I had was that my database uses schemas to organize the tables, so the script failed to work. I made a modification on the script to solve the problem, so [...]

Count the total number of records on a MySQL database or per table

yorch — Fri, 12 Nov 2010 00:43:49 +0000

To count the total number of records on a MySQL database, we could run the following command: SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{tablename}'; If we need to know the number of records per each table, we can run: SELECT TABLE_NAME, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{tablename}'; Source: Stack Overflow

Duplicate a MySQL database on a single line

yorch — Fri, 12 Nov 2010 00:13:21 +0000

On this article, it is shown a very convenient way to duplicate a complete MySQL database using a single line of code: $ mysqladmin create {dest_db_name} -u {username} --password={password} && \ mysqldump -u {username} --password={password} {source_db_name} | \ mysql -u {username} --password={password} {dest_db_name} Where: {dest_db_name}: Name of the destination database. {source_db_name}: Name of the database [...]

Nginx and Munin

yorch — Sun, 07 Nov 2010 02:49:32 +0000

To be allowed to show Nginx graphs on the Munin report, it is required to enable nginx status and to listen on: http://127.0.0.1/nginx_status To do this, we just need to add the following code on /etc/nginx/sites-enabled/default or into any other site file (like create a new one /etc/nginx/sites-available/status and then make symbolic link to site-enabled [...]

Install VMWare ESXi using a USB flash drive

yorch — Thu, 04 Nov 2010 03:23:31 +0000

Today, I decided to try the VMWare ESXi, the free bare metal virtualization product of VMWare, on an old Pentium 4 3.2GHz PC (with 2.5GB of RAM), and run on top of it, some Ubuntu servers. I was not able to use the latest version (4.x) of the ESXi as it only works on 64-bit [...]

No DEFAULT or UI configuration directive found

yorch — Thu, 04 Nov 2010 02:33:36 +0000

When I tried to run the VMWare ESXi installer from a USB stick (after creating the installer on a USB from the ISO), I got the following error: SYSLINUX 3.85 2010-02-20 CBIOS Copyright (c) 1994-2010 H. Peter Anvin et al No DEFAULT or UI configuration directive found! boot: The solution was pretty simple thanks to [...]

Remove duplicated whitespaces on C#

yorch — Thu, 28 Oct 2010 21:14:20 +0000

The Trim method on C# only removes whitespaces at the beginning and at the end of a string, but it does not remote duplicated whitespaces inside the string (like the Trim function on VB for Apps), which is very handy sometimes. One of the ways to do it on C#, is using Regular Expressions. This [...]

Concatenate text on NVelocity

yorch — Thu, 28 Oct 2010 14:24:21 +0000

There is no operator to concatenate two strings in NVelocity (the .Net version of Velocity) like we can do on other languages like C# or PHP, with the plus (+) operator for the first one and dot (.) for the second one. For example, in C# we would do: string strHello = "Hello " + [...]

Adobe Lightroom basics

yorch — Mon, 25 Oct 2010 03:16:02 +0000

Lightroom is all about non-destructive editing – so don’t try to save over your originals. Lightroom doesn’t ‘contain’ files, it just holds data about them – so don’t go deleting your originals thinking that they’re safely stored in Lightroom. Lightroom’s backups don’t back up your originals – you still need to do that. Lightroom’s catalog is just [...]

Disable cron log on syslog and enable cron.log

yorch — Sun, 17 Oct 2010 20:31:29 +0000

By default, Ubuntu logs all cron activity directly to syslog (/var/log/syslog), instead to a dedicated file like /var/log/cron.log. In my opinion, it is best to keep them separate if you have several cron jobs running on your server. To enable this behavior, what we must do is edit the syslog configuration file /etc/syslog.conf, and modify the [...]

Fixing WMI Service (root\cimv2 namespace missing)

yorch — Sun, 26 Sep 2010 15:24:36 +0000

I was working on a VBScript code that uses the Windows Management Instrumentation (WMI) to query the running processes on the local machine, something like this: strComputer = "." strProcess2Kill = "something.exe" Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colProcess = objWMIService.ExecQuery("Select * from Win32_Process Where Name = " & [...]

Como instalar Drupal en otros idiomas distintos al inglés

yorch — Tue, 27 Jul 2010 01:35:29 +0000

Hasta hace poco, el primer paso para instalar la traducción al español (o cualquier otra) del CMS Drupal era descargarla desde la sección Translations en la página del proyecto, pero esto ha cambiado con la introducción de Drupal Localize, un sub-sitio donde se está concentrando todo el trabajo de traducción al resto de idiomas distintos [...]

Guía para comer chifa en Toronto

yorch — Mon, 26 Jul 2010 23:42:38 +0000

El Chifa es como se le llama a la comida china en el Perú, aunque se diferencia de esta comida oriental en la fusión con el paladar e ingredientes peruanos, que a nuestro gusto, la hace exquisita (por supuesto que la cocina china típica es una maravilla por si sola). En Toronto abundan los restaurantes [...]

Microsoft .Net vs Java Movie Trailer

yorch — Wed, 30 Jun 2010 19:23:48 +0000

http://www.youtube.com/watch?v=fzza-ZbEY70

Call a WebService from VBScript

yorch — Tue, 29 Jun 2010 23:32:27 +0000

While I was writing some code on VBScript to avoid manual tasks that we currently do with a bunch of files, I needed to automatically upload some information extracted from all these files to a SQL database. One way to do it is using a Web Service that receives the data and store it into [...]

Convert a String to a Stream

yorch — Tue, 29 Jun 2010 22:55:50 +0000

In C#, to convert a String into a Stream object, we need to use the GetBytes method (from the Encoding.ASCII package), this way: byte[] bytes = Encoding.ASCII.GetBytes(xmlContent); And then, use that byte array when instantiate a Stream (for example, MemoryStream or FileStream): MemoryStream stream = new MemoryStream(bytes);

Windows 7 bug affecting Subversion

yorch — Wed, 23 Jun 2010 19:33:17 +0000

There is a bug on Windows 7 (and Windows Server 2008 R2) that relates to corrupted files error messages and affects several SVN’s operations (like commit and update). The detailed error message you can get is something similar to: svn: Can't move '[repo]\.svn\tmp\entries' to '[repo]\.svn\entries': The file or directory is corrupted and unreadable. And you [...]

Forbid access to svn directories on Apache Web Server

yorch — Sat, 29 May 2010 00:48:40 +0000

Using Subversion to deploy and maintain updated web applications like WordPress, Joomla or even your development on a web server is very handy. One of the downsides I have found to this solution is that your web root will have hidden .svn directories all over the place (one per each directory on your application). This directories will not [...]

Resolving troubleshooting with Munin

yorch — Wed, 14 Apr 2010 16:54:49 +0000

This are some problems that you may encounter after installing Munin: Apache modules are not tracking, so they are not showing statistics, you may want to check Munin logs (specifically /var/log/munin/munin-node.log) to see what is going on. If you got something like Can’t locate object method “new” via package “LWP::UserAgent”, you need to install the [...]

Install Munin on Ubuntu Server

yorch — Tue, 06 Apr 2010 15:35:11 +0000

Munin is a small tool for monitoring resources on servers. I think it is very useful, specially on small VPS, that needs to save resources. Reports are written as HTML files, so we will need a Web Server like Apache to see this reports. First, we install it and add some extra plugins: $ sudo [...]

Install VirtualBox Guest Additions on Ubuntu Server

yorch — Tue, 06 Apr 2010 04:19:09 +0000

On my work, I have a box with WinXP, running Virtual Box as a host, and a Ubuntu Server 9.10 box as a guest. My problem is that the firewall on the corporate network does not allow Ubuntu to update the date and time against any NTP server (like pool.ntp.org or ntp.ubuntu.com). So, I need [...]

Configuring a Linux Server – Part 1: Sudoer user and SSH

yorch — Tue, 30 Mar 2010 00:34:36 +0000

This will be a series of posts about configuring a Linux server (I’m working with Ubuntu, but should work with minor changes with other distributions), mainly because I have done this several times now by reviewing different websites and blogs, so I wanted to do a guide that works for me (and maybe for others [...]

Nullmailer keeps trying to send unsuccessful mails on Ubuntu

yorch — Fri, 26 Feb 2010 05:33:07 +0000

I have noticed that my Ubuntu box is lately always trying to reach a SMTP server (detected through Wireshark tool). After reviewing the list of running processes that contains the word mail (running ps aux | grep mail on console), I found a couple of them called Nullmailer that seems the responsible of that and indeed, [...]

Configure Clientexec to send mail using Google Apps

yorch — Fri, 26 Feb 2010 03:56:55 +0000

If you use Clientexec as your hosting company’s management and support web application, and Google Apps for your emailing (or even just GMail), then, it is possible to configure Clientexec to send mails through Google SMTP server. Unfortunately, it is not straightforward because the default Clientexec SMTP mailer (at least until 3.2.3 version of this software) [...]

Even pigeons ride the subway on Toronto

yorch — Sat, 20 Feb 2010 18:44:59 +0000

http://www.youtube.com/watch?v=75-ZWi422gg

Instalar nuevos locales en Ubuntu

yorch — Sun, 14 Feb 2010 18:52:45 +0000

Durante la migración de la web de DeChalaca desde el servicio Grid-Service de MediaTemple hacia un nuevo VPS, el último punto que quedó por resolver fue que las fechas en la web se mostraban en inglés (aunque el Joomla estaba configurado para que lo hagan en español). El problema era que el servidor, un flamante [...]

Convertir un IList en un Array

yorch — Thu, 28 Jan 2010 23:27:33 +0000

Existen algunas formas de hacerlo, acá les dejo un par. Primera forma: //list es del tipo IList ArrayList arr = new ArrayList(list); Item[] items = (Item[])arr.ToArray(typeof(Item)); Otra forma: Item[] items = new Item[list.Count]; list.CopyTo(items, 0);

Determinar la versión exacta del SQL Server

yorch — Fri, 15 Jan 2010 15:03:48 +0000

Para determinar cuál es la versión exacta de un servidor SQL Server (ya sea 2000, 2005 ó 2008), basta con ejecutar la siguiente consulta: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition') En mi caso, la consulta me devuelve algo como esto: 9.00.3080.00 SP2 Developer Edition Para versiones anteriores de SQL Server, podemos utilizar esta otra consulta: SELECT @@VERSION [...]

Reinstalar Grub luego de instalar Windows

yorch — Wed, 30 Dec 2009 02:15:19 +0000

Luego de haber instalado Windows 7 hace algunos meses, en un equipo donde tenía tanto el Windows XP como Ubuntu 9.04, quedó inaccesible este último. Esto debido a que el instalador de Windows no reconoce otro sistema operativo que no sea propio de Microsoft (a diferencia de Linux). Se debe tomar en cuenta NO utilizar [...]

Quitar una cadena de texto de muchos registros usando SQL

yorch — Wed, 30 Dec 2009 00:41:37 +0000

En una aplicación en la que estoy trabajando, surgió la necesidad de actualizar muchos registros de la base de datos, específicamente, lo que necesitaba era quitar un texto común dentro de un mismo campo para muchos registros. Para ser más explícito, tenía algo como esto dentro de una tabla en la base de datos: id [...]

Miles, bueno, mil íconos web gratuitos

yorch — Fri, 06 Nov 2009 21:17:02 +0000

FatCow nos ofrece un paquete con 1000 íconos web llamado Farm-Fresh para utilizar en nuestras aplicaciones y sitios web. Podemos descargarlo gratuitamente ya que tiene la licencia Creative Commons Attribution 3.0 License, lo que significa que podemos usarlos para cualquier propósito (open source, privado o comercial) con solo mencionarlo en los créditos. Puedes bajarlos desde acá. [...]

SpeedCrunch, un buen reemplazo para la calculadora de Windows, e incluso de Linux.. y si, de Mac también

yorch — Fri, 06 Nov 2009 21:03:28 +0000

SpeedCrunch es una aplicación de escritorio bastante interesante, ya que es una calculadora muy completa y con características que la hacen muy práctica, por ejemplo: Histórico de las últimas operaciones y resultados. Hasta 50 decimales (bueno, creo que yo nunca he usado más de 6, como mucho). Permite utilizar variables (ilimitadamente, o bueno, hasta que [...]

Quitar todos los directorios .svn de una copia de trabajo de Subversion

yorch — Fri, 09 Oct 2009 12:46:24 +0000

Hace un rato me vi en la necesidad de borrar todos los directorios .svn (aquellos que coloca Subversion en cada directorio de nuestra copia de trabajo para llevar el control de cambios). El problema era que esta copia de trabajo tiene una estructura de directorios bastante extensa, por lo que hacerlo manualmente no era una [...]

La frase geek del día

yorch — Fri, 11 Sep 2009 22:40:45 +0000

I would love to change the world, but they won’t give me the source code.

La frase geek del día

yorch — Thu, 10 Sep 2009 23:52:14 +0000

1f u c4n r34d th1s u r34lly n33d t0 g37 l41d

Vulnerabilidad en WordPress 2.8

yorch — Wed, 12 Aug 2009 22:46:49 +0000

Ayer se encontró una vulnerabilidad en WordPress (hasta la versión 2.8.3) que permite al atacante resetear la contraseña del usuario administrador sin ninguna confirmación o autenticación (generar automáticamente una nueva contraseña y enviarla a la cuenta de correo de dicho usuario). Si bien esto no implica que el atancante obtenga acceso a WP, puede causar [...]

Como hacer un sitio web rentable

yorch — Sun, 09 Aug 2009 17:01:58 +0000

Mientras buscaba tips sobre como colocar mejor los anuncios de publicidad (por ejemplo, los Google AdSense), encontré este link con 6 episodios en video (en inglés) sobre como hacer rentable un sitio web. Están muy buenos. Estos son los episodios: Be the Master of Your Own Domain! Hook Up With a Web Host Why WordPress [...]

Excelente video a favor del respeto al discapacitado

yorch — Thu, 06 Aug 2009 20:31:40 +0000

httpv://www.youtube.com/watch?v=KZe3byizbGc