- 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
throttled=0x0
temp=72.0'C
frequency(45)=1200000000
total used free shared buff/cache available
Mem: 731Mi 297Mi 118Mi 27Mi 316Mi 345Mi
Swap: 2.0Gi 346Mi 1.6Gi
-----
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 :
01/06/2018
In cell B2 :
=IF(
MONTH(DATE(YEAR(B$1);MONTH(B$1);CELL("row";B2)-CELL("row";B$1)))=MONTH(B$1);
DATE(YEAR(B$1);MONTH(B$1);CELL("row";B2)-CELL("row";B$1));"")
Then you just have to drag-n-drop down and right (or left).
To highlight saturdays and sundays :
=IF(ISBLANK(B2)=FALSE;OR(IF(WEEKDAY(B2)=7;TRUE;FALSE);IF(WEEKDAY(B2)=1;TRUE;FALSE));FALSE)
Here is the result :
2- Number of days in one month
Put a date in cell B1. Then in another cell, formula is :
=DAY(DATE(YEAR(B1);MONTH(B1)+1;0))
It will return the number of days of the month in cell B1.
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.
Procedure:
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/optware-install.sh
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 !
French ISP provides free website hosting.To enjoy this service, you must be in France to connect to FTP server ftpperso.free.fr.
If you are not in France, find a proxy located in France :
https://hidester.com/fr/listeproxy/
Then in FileZilla, go to Edit >> Settings >> Connection >> FTP >> Generic proxy. Then configure. You might need to test different proxy...
Besides that :
- create specific ".htaccess" file to activate PHP5.
- create folder "sessions" in root folder to be able to use sessions.