the permanent TODO

January 25, 2010

mounting an NFS filesystem

Filed under: tech — {Francisco,François} Varas @ 9:00 am

Imagine you want to share all your music at home, avoiding annoying VoD servers. Here’s the trick:

Server: 192.168.0.11
Clients: 192.168.0.0/24 (this means: “everybody in this network”)

in the server:

  • apt-get install nfs-kernel-server
  • then edit /etc/exports
    • add the line:
    • /home/invitado/ 192.168.0.13(rw,no_root_squash)
  • exportfs -a

in the client(s):
192.168.0.11:/home/invitado /mnt/storage2 nfs nfsvers=3,intr,timeo=5 0 0
If you find weird RPC errors and are unable to mount NFS, edit /etc/default/portmap and comment the line OPTIONS=”", which makes portmap to listen locally.
If you are using nfs-user-server, avoid “nfsvers=3″ in the client conf.

January 18, 2010

dumb apache2 iptables security

Filed under: tech — Tags: , , — {Francisco,François} Varas @ 9:00 am

This is an aggressive script that will -j DROP anything that moves.

This is the regexp list (noisily named “regexp-list.ib” in my filesystem):

#file containing idiotblocker's database
w00tw00t
php.my.admin

This is the script:

for i in `grep -iv ^# regexp-list.ib`
do for a in `grep -i $i /var/log/apache2/access.log | awk -F'-' '{print $1}' |sort -n | uniq`
do echo "$a found and screwed with iptables"
iptables -A INPUT -s $a -j DROP
done
done

January 11, 2010

building packages from the source with apt-get

Filed under: Uncategorized — {Francisco,François} Varas @ 9:00 am

want to build gkrellm from the source?
if you see something weird in the code below, IT’S A JOKE
If you don’t see anything weird, nevermind…life goes on

c:\>su [troll] not sudo, sudo is for newbies [/troll]
c:\>cd /usr/scr
c:\>apt-get build-dep gkrellm
c:\>apt-get source mplayer --build
you can safely go for an orange juice can now
c:\>dpkg -i gkrellm_2.3.2-5_i386.deb

And, of course this procedure will work for other packages.

Have a nice day!

January 4, 2010

forgot the name of your mysql database?

Filed under: Uncategorized — {Francisco,François} Varas @ 9:00 am

you will search for existent mysql databases:

sweet@home:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2745
Server version: 5.0.51a-24+lenny2 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| wp-database |
+--------------------+
3 rows in set (0.00 sec)

mysql> Bye

then:

sweet@home:~$ mysql -u root -p wp-database
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2747
Server version: 5.0.51a-24+lenny2 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
+-----------------------+
| Tables_in_xxxxxx |
+-----------------------+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_terms |
| wp_usermeta |
| wp_users |
+-----------------------+
11 rows in set (0.00 sec)

mysql> Bye

Powered by WordPress