To begin with Raspberry Pi 3

Written by pmd - - no comments
  • Virtual Keyboard:
    • sudo apt-get install matchbox-keyboard
    • sudo apt-get install florence at-spi2-core [link]
  • Configure remote access for SSH and VNC: sudo raspi-config
  • Change pi password: sudo raspi-config
  • "Install" SFTP server: actually already done when activating SSH

Display basic stuff :

$ while true; do uptime; vcgencmd get_throttled; vcgencmd measure_temp; vcgencmd measure_clock arm; free -h; echo '-----'; sleep 10; done
              total        used        free      shared  buff/cache   available
Mem:          731Mi       297Mi       118Mi        27Mi       316Mi       345Mi
Swap:         2.0Gi       346Mi       1.6Gi

Excel tricks

Written by pmd - - no comments

1- Generate a calendar in Excel

Here is how to generate a calendar in Excel. Using Excel 2010 in my case.

In cell B1 (by example), put a date :


In cell B2 :


Then you just have to drag-n-drop down and right (or left).

To highlight saturdays and sundays :


Here is the result :<image>

2- Number of days in one month

Put a date in cell B1. Then in another cell, formula is :


It will return the number of days of the month in cell B1.

How to install Transmission on WNR3500L

Written by pmd - - no comments

How to set up Optware on WRT3500L with firmware Tomato Firmware 1.28.0000 MIPSR2-138 K26 USB miniVPN by shibby.
How to install Transmission BitTorrent client on external drive plug on USB of WNR3500L. 

First, you should have a partition in ext2/ext3 in order to be able to install Optware on it (you cannot install optware directly on you router memory neither on FAT and NTFS partitions). 

In administration interface of your router, go to section "USB and NAS >> USB Support". Make sure ext2/ext3 File Systems Support is checked.

I plugged in my router one HDD of 250GB. 249GB formatted in NTSF. 1GB formatted in ext3 called <harddisk label> where I will install different packages such as Transmission.

1. make sure mounted usb harddisk is detected. ls /tmp/mnt/<harddisk> should be present
2. cd /tmp/mnt/<harddisk>
3. mkdir /tmp/mnt/<harddisk>/opt
4. mount -o bind /tmp/mnt/<harddisk>/opt /opt
5. cd /opt
6. install your optware, sh /usr/sbin/
7. update optware, ipkg update and ipkg upgrade
8. install transmission, ipkg install transmission
9. you can list all packages available with ipkg list

Then, go enable BitTorrent in router adminitration, section "USB and NAS >> BitTorrent Client".

Once it's started you can monitor Transmission via http :

Et voila !

Connect to from anywhere

Written by pmd - - no comments

French ISP provides free website hosting.To enjoy this service, you must be in France to connect to FTP server

If you are not in France, find a proxy located in France :

Then in FileZilla, go to Edit >> Settings >> Connection >> FTP >> Generic proxy. Then configure. You might need to test different proxy...


Besides that :

  1. create specific ".htaccess" file to activate PHP5.
  2. create folder "sessions" in root folder to be able to use sessions.


DDNS on WNR3500L

Written by pmd - - no comments

How to set up DDNS on WRT3500L with firmware Tomato Firmware 1.28.0000 MIPSR2-138 K26 USB miniVPN by shibby.

Two services in case one falls :


In block named Dynamic DNS, I choose Use external IP checker because I do not get my Internet connection from my WAN port. 
I set auto-refresh at 1 day even though I'm not sure what it really means.

How to use no-ip :

  1. create free account on
  2. choose as service in Dynamic DNS 1 options and configure. 

How to use dtdns :

  1. create free account on
  2. read
  3. choose Custom URL as service in Dynamic DNS 2 options and configure. 
  4. example :

It works like a charm !

How to double check from command line ? Here :

# wget -qO-
Rss feed of the articles