08.27.07
Posted in howto, security, software at 6:06 pm by brainstorm
So you forgot your MySQL root password ? Don’t worry, logging in is easy as 1,2,3:
- Stop all running mysqld processes (/etc/init.d/mysqld stop or killall mysqld)
- # mysqld –skip-grant-tables
- $ mysql -uroot and you’re in, no password required
Till here, you’ll be able to operate with your DB…but, you’ll not be able to change your password right away:
mysql> SET PASSWORD FOR root = PASSWORD('will_not_forget_again');
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables
option so it cannot execute this statement
Here’s the workaround:
mysql> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE user
-> SET PASSWORD=PASSWORD('really:I_will_not_forget_again')
-> WHERE user="root";
Query OK, 2 rows affected (0.02 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
Thanks to netadmintools for this quick recipe 
Permalink
Posted in howto, inet, software, unix at 5:08 pm by brainstorm
La batalla continua indefinidament: es milloren els motors antispam (spamassassin, dspam…) i els spammers s’adapten, s’usen llistes negres remotes (RBL’s) i ells s’adapten… que un gif com attachment pot tenir pinta d’spam ? Doncs ells usen PDF’s… el compte de mai acabar :/
Doncs bé, fart de rebre una mitja de 10 spams diaris a l’Inbox vaig decidir implantar mesures dràstiques. Primer vaig probar amb greylisting (usant postgrey). El resultat va ser decepcionant: apenes filtrava un 10% més dels spams respecte a no tenir aquesta mesura.
La capacitat d’adaptació i perseverança dels spammers em recorda a uns personatges d’una sèrie de ciència ficció :-/… El cas és que finalment em vaig decantar per SPF… conclusió després de setmanes d’ús i revisió de logs exhaustiva: tant de bo ho hagués fet abans !
Read the rest of this entry »
Permalink
06.16.07
Posted in gadgets, howto, software, unix at 5:55 pm by brainstorm
If you’re switching between providers and want to keep your addressbook and sms’s, here is a simple way of doing so with gnokii:
$ gnokii --getsms AR 1 10 -d >> sms_archive
$ gnokii --getphonebook SM 1 200 > phonebook
The “AR” stands for “ARchive” and tells gnokii to search the SMS’s there, and not in the INbox (”IN” being another cellphone storage area). Following AR, there is the SMS range you want to save (sms 1st till 10th). Make sure you have a look at gnokii manpage if this is not working for you. For instance, on the following command, the “SM” is referring to the SIM card… perhaps you’re not storing your phonebook there, but in the internal mobile phone memory (”ME”).
Here I’m assuming that you have configured your /etc/gnokiirc properly. Just for the record, I’m using a bluetooth usb adapter.
As a result of this mini-howto, you have a plaintext copy of your phonebook and sms messages on your computer, isn’t it easy and convenient ? Sure, there are clearly better and comprehensive alternatives out there, like SyncML (OpenSync), but this solution suits my needs very quickly and it’s quite effortless.
Doing a backup of the photos is even simpler if you happen to have kblueetothd, one of the coolest KDE kioslaves: just drag&drop the pictures to your PC and you’re done !
Permalink
08.25.06
Posted in diy, hardware, howto at 2:39 am by brainstorm
Everything started with the following question:
Hi dude, tomorrow I’m going to Helsinki and I don’t remember this laptop’s password, can you help me ?
A few searches looking for the typical master or universal passwords didn’t help much (nope, “admin” does not work as a backdoor bios password as most sites say, really). The owner was really fed up with HP support and it was quite late at night, so calling nor sending emails were going to help either.
Searching a bit deeper on forums, people were complaining about the same problem without solution: “Cannot reset omnibook xe3 bios password”, and the well known common thrick to erase the bios password was futile (removing the CMOS battery for a while to erase the password and settings). According to some posts, the password was actually stored on a 24C16 EEPROM close to the BIOS chip… So there we go
Read the rest of this entry »
Permalink
06.27.06
Posted in gadgets, howto, unix at 8:49 pm by brainstorm
Sending sms via bluetooth with gentoo is “fairly” simple:
# emerge -pv gnokii
[ebuild R ] app-mobilephone/gnokii-0.6.10 +X +bluetooth -irda +mysql -nls -postgres +sms 0 kB
# emerge gnokii
(...)
Now tune your /etc/gnokiirc like this:
[global]
port =
model = 6510
initlength = default
connection = bluetooth
use_locking = yes
serial_baudrate = 19200
smsc_timeout = 10
[gnokiid]
bindir = /usr/sbin/
Then launch xgnokii, the gui is intuïtive enough. If you want to send the messages via cmdline, just use the example from gnokii’s manpage:
echo "This is a test message" | gnokii --sendsms +48501123456 -r
Read the rest of this entry »
Permalink
« Previous entries