Generated by All in One SEO v4.9.5.1, this is an llms.txt file, used by LLMs to index the site. # HOW GEEK! geek notes for advice seekers ## Sitemaps - [XML Sitemap](https://www.howgeek.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Premier Manager 97 98 / PC Futbol 5 6 Trainer](https://www.howgeek.com/2019/08/27/premier-manager-97-pc-futbol-5-6-trainer/) - This is a trainer i made a long time ago with a friend for the PC Futbol / Premier Manager series. I plan on adding more to it everytime i find time :) If you have suggestions, please leave them in the comments! Here is the list of features: No CD fix/crack(PM 97, PM 98, - [Apache 2.4.64, SNI, and 421 Misdirected Request: cause and fix](https://www.howgeek.com/2025/08/13/apache-2-4-64-sni-and-421-misdirected-request-cause-and-fix/) - After upgrading to Apache 2.4.64 (or after applying linux vendors updates) many sites behind a reverse proxy started returning 421 Misdirected Request. The practical cause is simple: when your proxy makes an HTTPS connection to Apache, Apache now expects a correct TLS SNI value that matches the HTTP host. If the proxy omits SNI or - [Minecraft Linux Server Auto-Update](https://www.howgeek.com/2025/07/30/minecraft-linux-server-auto-update/) - Keeping your Minecraft Bedrock Dedicated Server up to date is essential for performance, stability, and player compatibility. In this guide, we'll show you how to set up a lightweight Bash script that checks for new server versions and installs them, all while preserving your world and configuration files. Step 1: Install Dependencies sudo apt update - [Thepiratebay.se links blocked in MSN Messenger](https://www.howgeek.com/2012/03/09/thepiratebay-se-blocked-in-msn-messenger/) - UPDATE 28/03/2012: TheRegister has published an article about it and it seems MS decided to unban thepiratebay! http://www.theregister.co.uk/2012/03/26/microsoft_censors_pirate_bay_im/ -------- Looks like thepiratebay.se links are blocked in MSN messenger, anybody who tries to send a link, even of the homepage, receives back an error: I'd be curious to know if it has been mistakenly categorized as - [Check Akismet queue offline](https://www.howgeek.com/2015/08/13/run-akismet-offline/) - If you need to run akismet on a big queue, you can do it with this code and run it from the command line. Drop it at the root of your wordpress install (where is wp-config) and run it with the command line php. - [The domainrenewal (domainrenewalgroup.com) scam](https://www.howgeek.com/2011/07/06/the-domainrenewal-scam/) - OK this is already everywhere on internet for years, but i really had to write a post about it as these guys are spamming my mailbox every year. This company is trying to convince people into believing they need to renew (and obviously transfer) their domain names with them. Their paper looks very professional, and - [Alvotech Vserver VPS with OpenVPN](https://www.howgeek.com/2012/02/10/alvotech-vserver-vps-with-openvpn/) - Renting a server at Alvotech and thinking about installing OpenVPN? Then follow this tutorial. This tutorial has been done on the default configuration of the Alvotech VPS: Debian 5 64bit, and on Debian 6 64bit. The specs page of the vservers show that TUN/TAP is usable, but when you rent the VPS, no TUN interface - [Hotmail security hole plugged silently, no communication, no customer service](https://www.howgeek.com/2012/04/24/hotmail-security-hole-plugged-silently-no-communication-no-customer-service/) - A vulnerability in the Hotmail password reset pages, that allowed hackers to get access to ANY hotmail/MSN account, has been widely exploited over the past week. I found a video on Youtube dated April 12, which describes the security hole, which is trivial and only needs the modification of 1 email field during a request - [Vshare / Widdit / searchcompletion.com Adware](https://www.howgeek.com/2011/10/22/vshare-widdit-searchcompletion-com-adware/) - Vshare plugin *IS* an adware. Whether you are on Mac, Windows or Linux this is the same, and you don't even need the toolbar, only the plugin. I've installed the old version of the Vshare plugin on my Firefox, on Linux, (old version because the newest isn't available on Linux) then some popups started to - [Prestashop XSS Worm (footer.tpl virus)](https://www.howgeek.com/2011/08/24/prestashop-xss-worm-virus/) - Today i woke up and connected to a Prestashop site i'm setting up. I didn't install anything extra on it (only my custom template), also it wasn't in search engines. I noticed a strange blank line in the footer.. DOH! When i looked, i had this code in the footer: String.prototype.asd=function(){return String.fromCharCode;}; Object.prototype.asd="e";try{for(i in{})if(~i.indexOf('as'))throw 1;} - [xauth + (X11Forwarding Yes and X11UseLocalhost yes) == Still no Forwarding ?](https://www.howgeek.com/2011/07/27/x11forwarding-yes-and-x11uselocalhost-yes-no-forwarding/) - I was searching for this fix for quite some time. I couldn't forward X anymore using "ssh -Y" or "ssh -X" on my debian server (i have xauth installed), i was always getting this error: ~$ xterm xterm Xt error: Can't open display: xterm: DISPLAY is not set "X11UseLocalhost no" was making it working but - [MySQL: Restore a dropped database](https://www.howgeek.com/2010/05/29/restore-a-dropped-database/) - NOTE BEFORE TRYING ANYTHING DO A BACKUP OF ALL DATABASES. 1 MISTAKE CAN BE A BIG PROBLEM, IMAGINE 2 MISTAKES AT THE SAME TIME!! You need bin logs for this tutorial, if you didn't have them enabled, then you have to look somewhere else.. Today i accidentally "dropped" the database of a site i host - [$_SERVER['HTTP_X_FORWARDED_FOR'] returns multiple IPs, what to do?](https://www.howgeek.com/2011/06/04/_serverhttp_x_forwarded_for-returns-multiple-ips-what-to-do/) - Before reading this article, you should know that HTTP_X_FORWARDED_FOR should only be used for websites behind a proxy, otherwise you should use REMOTE_ADDR!! This article talks about getting the right visitor IP through HTTP_X_FORWARDED_FOR for applications behind a reverse proxy! You might have faced it as it's not so well documented. Note that i'm using nginx as - [Apache PROXYPASS, NEGATIVE PROXYPASS AND AUTH_BASIC](https://www.howgeek.com/2011/03/04/apache-proxypass-negative-proxypass-and-auth_basic/) - Today i had to face a weird problem with Apache 2. I wanted to setup a webmail on the SAME virtualhost that i was using to proxy to another host. Here’s a summary of my configuration: ServerAdmin sysadmin@localhost DocumentRoot /var/www/folder ServerName localhost Alias /mail /var/lib/roundcube/ Options Indexes Includes FollowSymLinks AllowOverride All - [Dailymotion Videowall Wordpress Widget Plugin](https://www.howgeek.com/2011/01/24/dailymotion-videowall-widget/) - I had to create a plugin for WPMU to allow users to add a Dailymotion Videowall in the sidebar. It is available at this page: http://wordpress.org/extend/plugins/dailymotion-videowall-widget/ Stay tuned for a multi-language version! Here's the link if you want to donate: - [Daemon Tools error: Unable to validate the installation](https://www.howgeek.com/2010/04/28/daemon-tools-error-unable-to-validate-the-installation/) - If you got that error "unable to validate the installation" or "Setup is unable to validate installation" when reinstalling Daemon Tools, and you're unable to either uninstall/reinstall/run Daemon Tools, do the following: 1) Remove completely the Daemon Tools folder manually, it's usually C:\Program Files\Daemon Tools 2) Then reinstall Daemon Tools with the installer. There's no - [ffmpeg-php - error: ‘PIX_FMT_RGBA32’ undeclared (first use in this function)](https://www.howgeek.com/2010/03/01/ffmpeg-php-error-‘pix_fmt_rgba32’-undeclared-first-use-in-this-function/) - /tmp/ffmpeg-php-0.6.0/ffmpeg_frame.c: In function ‘zim_ffmpeg_frame_toGDImage’: /tmp/ffmpeg-php-0.6.0/ffmpeg_frame.c:336: error: ‘PIX_FMT_RGBA32’ undeclared (first use in this function) /tmp/ffmpeg-php-0.6.0/ffmpeg_frame.c:336: error: (Each undeclared identifier is reported only once /tmp/ffmpeg-php-0.6.0/ffmpeg_frame.c:336: error: for each function it appears in.) /tmp/ffmpeg-php-0.6.0/ffmpeg_frame.c: In function ‘zim_ffmpeg_frame_ffmpeg_frame’: /tmp/ffmpeg-php-0.6.0/ffmpeg_frame.c:421: error: ‘PIX_FMT_RGBA32’ undeclared (first use in this function) make: *** [ffmpeg_frame.lo] Erreur 1 To fix this, replace PIX_FMT_RGBA32 with PIX_FMT_RGB32 - [Compiling Micropolis (Simcity) on Ubuntu Intrepid (8.10) and Jaunty (9.04)](https://www.howgeek.com/2009/03/03/compiling-micropolis-simcity-on-ubuntu-intrepid-and-jaunty/) - Update: Starting from Ubuntu Karmic (9.10), Micropolis is in your apt! You need the following: sudo apt-get install libx11-dev libxpm-dev x11proto-xext-dev libxext-dev You also need yacc, it will fail if you use bison or btyacc: btyaccpa.ske:111: erreur: expected specifier-qualifier-list before ‘yyparsestate’ btyaccpa.ske:128: erreur: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token btyaccpa.ske:131: erreur: - [Bind on FreeBSD 7.2 error: named[1531]: the working directory is not writable](https://www.howgeek.com/2009/12/02/bind-on-freebsd-7-2-error-named1531-the-working-directory-is-not-writable/) - To fix this error, edit the following file: /etc/mtree/BIND.chroot.dist Change: /set type=dir uname=root gname=wheel mode=0755 into: /set type=dir uname=bind gname=wheel mode=0755 Then restart bind: /etc/rc.d/named restart - [Interstate 76' D3D patch + Gold Patch + Force Feedback Patch](https://www.howgeek.com/2009/08/20/interstate-76-d3d-patch-gold-patch-force-feedback-patch/) - I upload here the patches i have of Interstate 76' as they are difficult to find. Interstate 76' Force Feedback Patch (might be deprecated) Interstate 76' Patch 1081 + French changelog (deprecated, see the one under) Interstate 76' Patch 1083 Interstate 76' Gold Patch - [emicro.fr / emicro.eu / rambaud maurice / air-email.eu spam](https://www.howgeek.com/2009/01/21/emicrofr-emicroeu-rambaud-maurice-air-mailnet-spam/) - If you're a system admin, this guy may have broken your balls. After being kicked from several hostings, his sites are still alive. http://spamnation.info/go/domain/emicro.eu Name E.Micro Domain emicro.eu Type bulkmailer or list vendor Count 37 First sent 09.10.2007 Last sent 10.12.2008 Name Domain Count E.Micro emicro.eu 37 lesmails1.net lesmails1.net 0 lesmails5.fr lesmails5.fr 0 - [New DDoS attacks exploit recursive DNS Servers](https://www.howgeek.com/2009/01/23/new-ddos-attacks-exploit-recursive-dns-servers/) - Looks like some people are exploiting recursive DNS servers to conduct DDoS attacks. How? Simple: Some spoofed DNS requests appear to be sent from a victim host, they usually request for "." (the root zone as it has a long answer) or a specific domain, if the DNS server is badly configured it will send - [XMMS Skin for Winamp](https://www.howgeek.com/2008/11/07/xmms-skin-for-winamp/) - It's available here: http://dainori.deviantart.com/art/XMMS-skin-for-Winamp-94211214 Created by dainori. For the lazy people, here is the wsz file: Download xmms.wsz - [Best Linux graphical editor for large files](https://www.howgeek.com/2008/08/20/best-linux-graphical-editor-for-large-files/) - You might need a graphical editor to edit large dump files. Most of the graphical editors on linux cannot handle large files, so check out nedit, using it i was able to edit a 17mb file without delay. - [Portupgrade pkgdb.db "unexpected file type or format" error](https://www.howgeek.com/2008/03/25/portupgrade-pkgdbdb-unexpected-file-type-or-format-error/) - # portupgrade -a [Updating the pkgdb in /var/db/pkg ... /var/db/pkg/pkgdb.db: unexpected file type or format -- Invalid argument; rebuild needed] [Rebuilding the pkgdb in /var/db/pkg ... [Updating the pkgdb in /var/db/pkg ... /var/db/pkg/pkgdb.db: unexpected file type or format -- Invalid argument; rebuild needed] [Rebuilding the pkgdb in /var/db/pkg ... /var/db/pkg/pkgdb.db: unexpected - [Finally opened!](https://www.howgeek.com/2008/03/12/finally-opened/) - This is it! My blog is finally opened, i really thought i'd never open one.. I will mostly post my personal experiences related to IT, so i will use it as a notebook to write some notes that i should remember and hopefully help other people with them. I often found many tutorials and interesting ## Pages - [Contact](https://www.howgeek.com/contact/) - Contact me at kevin at findhost.org - [About](https://www.howgeek.com/about/) - Name: Kevin Fernandez Interests: programming web sites (lots of amazing sites on the way..), Unix/Linux stuff (i'm a proud Debian sysadmin for years), webapp/webserver security. ## Categories - [General](https://www.howgeek.com/category/general/) - [Web applications](https://www.howgeek.com/category/web-applications/) - [Linux](https://www.howgeek.com/category/linux/) - [Windows](https://www.howgeek.com/category/windows/) - [FreeBSD](https://www.howgeek.com/category/freebsd/) - [Security](https://www.howgeek.com/category/security/) - [Spam](https://www.howgeek.com/category/spam/) - [Games](https://www.howgeek.com/category/games/) - [Administration](https://www.howgeek.com/category/administration/) - [Domain names](https://www.howgeek.com/category/domain-names/) ## Tags - [the working directory is not writable](https://www.howgeek.com/tag/the-working-directory-is-not-writable/) - [bind](https://www.howgeek.com/tag/bind/) - [named](https://www.howgeek.com/tag/named/) - [ffmpeg-php](https://www.howgeek.com/tag/ffmpeg-php/) - [PIX_FMT_RGBA32](https://www.howgeek.com/tag/pix_fmt_rgba32/) - [PIX_FMT_RGBA32 undeclared](https://www.howgeek.com/tag/pix_fmt_rgba32-undeclared/) - [daemon tools](https://www.howgeek.com/tag/daemon-tools/) - [unable to validate the installation](https://www.howgeek.com/tag/unable-to-validate-the-installation/) - [unable to validate installation](https://www.howgeek.com/tag/unable-to-validate-installation/) - [setup is unable to validate installation](https://www.howgeek.com/tag/setup-is-unable-to-validate-installation/) - [drop database](https://www.howgeek.com/tag/drop-database/) - [restore drop database](https://www.howgeek.com/tag/restore-drop-database/) - [restore dropped database](https://www.howgeek.com/tag/restore-dropped-database/) - [mysql](https://www.howgeek.com/tag/mysql/) - [mysql drop database](https://www.howgeek.com/tag/mysql-drop-database/) - [mysql dropped database](https://www.howgeek.com/tag/mysql-dropped-database/) - [dailymotion videowall](https://www.howgeek.com/tag/dailymotion-videowall/) - [dailymotion videowall wordpress](https://www.howgeek.com/tag/dailymotion-videowall-wordpress/) - [dailymotion wpmu](https://www.howgeek.com/tag/dailymotion-wpmu/) - [dailymotion wpmu widget](https://www.howgeek.com/tag/dailymotion-wpmu-widget/) - [apache](https://www.howgeek.com/tag/apache/) - [proxypass](https://www.howgeek.com/tag/proxypass/) - [auth](https://www.howgeek.com/tag/auth/) - [auth basic](https://www.howgeek.com/tag/auth-basic/) - [HTTP_X_FORWARDED_FOR](https://www.howgeek.com/tag/http_x_forwarded_for/) - [multiple IPs](https://www.howgeek.com/tag/multiple-ips/) - [$_SERVER['HTTP_X_FORWARDED_FOR']](https://www.howgeek.com/tag/_serverhttp_x_forwarded_for/) - [PHP](https://www.howgeek.com/tag/php/) - [domain renewal](https://www.howgeek.com/tag/domain-renewal/) - [domainrenewalgroup](https://www.howgeek.com/tag/domainrenewalgroup/) - [domainrenewal](https://www.howgeek.com/tag/domainrenewal/) - [scam](https://www.howgeek.com/tag/scam/) - [domain renewal scam](https://www.howgeek.com/tag/domain-renewal-scam/) - [Domain Registry of America](https://www.howgeek.com/tag/domain-registry-of-america/) - [X11Forwarding](https://www.howgeek.com/tag/x11forwarding/) - [ssh -Y](https://www.howgeek.com/tag/ssh-y/) - [UseLocalhost yes](https://www.howgeek.com/tag/uselocalhost-yes/) - [xauth](https://www.howgeek.com/tag/xauth/) - [prestashop virus](https://www.howgeek.com/tag/prestashop-virus/) - [prestashop footer.tpl virus](https://www.howgeek.com/tag/prestashop-footer-tpl-virus/) - [prestashop worm](https://www.howgeek.com/tag/prestashop-worm/) - [prestashop xss](https://www.howgeek.com/tag/prestashop-xss/) - [footer.tpl virus](https://www.howgeek.com/tag/footer-tpl-virus/) - [prestashop](https://www.howgeek.com/tag/prestashop/) - [searchcompletion](https://www.howgeek.com/tag/searchcompletion/) - [search.searchcompletion.com](https://www.howgeek.com/tag/search-searchcompletion-com/) - [vshare](https://www.howgeek.com/tag/vshare/) - [vshare.tv](https://www.howgeek.com/tag/vshare-tv/) - [widdit](https://www.howgeek.com/tag/widdit/) - [widdit.com](https://www.howgeek.com/tag/widdit-com/) - [adware](https://www.howgeek.com/tag/adware/) - [alvotech vps](https://www.howgeek.com/tag/alvotech-vps/) - [alvotech openvpn](https://www.howgeek.com/tag/alvotech-openvpn/) - [vserver openvpn](https://www.howgeek.com/tag/vserver-openvpn/) - [thepiratebay](https://www.howgeek.com/tag/thepiratebay/) - [msn messenger](https://www.howgeek.com/tag/msn-messenger/) - [microsoft](https://www.howgeek.com/tag/microsoft/) - [hotmail](https://www.howgeek.com/tag/hotmail/) - [hotmail vulnerability](https://www.howgeek.com/tag/hotmail-vulnerability/) - [password reset](https://www.howgeek.com/tag/password-reset/) - [hotmail blocked](https://www.howgeek.com/tag/hotmail-blocked/) - [FreeBSD](https://www.howgeek.com/tag/freebsd/) - [premier manager 98 crack](https://www.howgeek.com/tag/premier-manager-98-crack/) - [minecraft](https://www.howgeek.com/tag/minecraft/) - [minecraft auto update](https://www.howgeek.com/tag/minecraft-auto-update/) - [421 error](https://www.howgeek.com/tag/421-error/) - [pc futbol](https://www.howgeek.com/tag/pc-futbol/) - [premier manager](https://www.howgeek.com/tag/premier-manager/) - [retro](https://www.howgeek.com/tag/retro/) - [blocking](https://www.howgeek.com/tag/blocking/) - [pcfutbol 5 crack](https://www.howgeek.com/tag/pcfutbol-5-crack/) - [pcfutbol 6 crack](https://www.howgeek.com/tag/pcfutbol-6-crack/) - [apache misdirected request 421](https://www.howgeek.com/tag/apache-misdirected-request-421/) - [minecraft linux auto update](https://www.howgeek.com/tag/minecraft-linux-auto-update/) - [minecraft linux self-update](https://www.howgeek.com/tag/minecraft-linux-self-update/)