Sometime ago I wrote an article about updating MAC Addresses before (Convert MAC address in MS Excel or OO Spreadsheet) so the subject is not new :-). But this time I’ll try to explain how to Convert MAC addresses in MS Access. The standard format for printing MAC addresses in human-friendly form is six groups of two hexadecimal digits, separated by hyphens (-) or colons (:), in transmission order, e.g. 01-23-45-67-89-ab, 01:23:45:67:89:ab. In this article I’ll give you examples of how to add, remove or change the separator for MAC addresses in MS Access.
Author: Winko Erades van den Berg
FON 2200 having a blinking power LED
A few months ago I wasn’t able to connect to the FON network. Being a Fonero I logged on at the FON website and noticed the following message at my personal page “Your roaming privileges are temporally put on hold”. My FON router (a FON2200) did not appear to be online!? When I got home I noticed just one sad blinking power LED, instead of three happy blinking LEDs (power, Internet and wlan)… I tried to reset my FON router, disconnected it from the power supply, I even tried magical spells, etc. but that didn’t help at all. As a last resort I contacted the FON support team, they told me my device was broken and needed to be replaced. They were really nice and even offered me a discount if I wanted to buy a new router. I love the concept of FON but was discouraged by the prize of the new router, so I waited…
Last week I had some time to “Google” the problem of my FON 2200. In a blog someone offered the suggestion it was a broken PSU (meaning a broken Power Supply Unit). So I “Googled” further and came with the following solution. I made my FON 2200 USB powered 🙂
Prerequisites (what you need to get it working):
- Hardware
- FON 2200 or FON 2100 router
- old transformer
- old USB cable
- Soldering Iron
- Solder
- Wire cutters
- Knife
- Tape or heat shrink tubing
Step 1 – Preparing the cables
From the old FON 2200 transformer, cut the plug off (I tried to end up with as much length of the cable as possible).
Split the wires apart and strip about 1 cm of the insulation on both wires.
Take the plug from an old USB cable by carefully stripping off the outer black insulation, be very careful not to cut into the inner wires.
Normally you will have a black, a red, a white and a green wire. The black wire is ground and the red wire is 5v DC.
BE CAREFULL WITH THIS, THE GREEN WIRE CAN BE THE 5 V AND THE RED CAN BE GROUND IN SOME CABLES!!!
You might want to check your cable using a multimeter. The others are for USB signals and can be cut off.
The USB cable wires are very fine compared to the wires of the power cable, they will break very easily, so be very careful when stripping the insulation off them.
Step 2 – Assemble the new cable
Before you go any further you need to confirm which cable is ground and which is 5v.
The easiest way to do this is using a multimeter.
The outside of the connector needs to be ground, and the inside 5v.
If you want to use heat shrink tubing, now is the time to bring it in place!
Once you know which wire is which, twist together the wires and solder them.
Make sure to isolate bare ends either with heat shrink tubing or using (plastic) tape.
Step 3 – We have lift off
After this I hooked up my FON router and after about 1 minute I had three happy LEDs and a confirmed connection from the FON website 🙂
In stead of soldering you can of course just buy a new transformer…
Suggestions for improving this article are welcome, please let me know and drop me a line.
Installing Squeezelite player on a Raspberry Pi
After running Squeezelite for some time, I thought it was time to update my Raspberry Pi to Jessie and start with a clean installation. So I downloaded the Jessie Lite image from the Raspberry Pi project site into my Downloads folder on my Ubuntu machine.
Time to open up a Terminal window and get to work…
In short we will do the following:
- Write Raspbian image to SD card
- Logon to the Raspbian Operating System
- Setup a Wireless connection to your AccessPoint
- Finalize the Raspberry Configuration
- Install rpi-update and update the Raspberry Pi firmware
- Install the Squeezelite player
- Edit the Squeezelite config file to prevent crackles from sound
- Adjust the sound volume of your Raspberry Pi
Write raspbian image to SD card
There is an excellent description on how to install Raspbian, have a look here. I used gparted to remove the old partitions from my SD card. After that I was ready to install a fresh copy Raspbian Jessie Lite.
| cd Downloads/Raspbian dd bs=4M if=./2016-05-27-raspbian-jessie.img of=/dev/sde |
When ready you can connect the Raspberry Pi with the UTP cable to your network and power it up. I used Zenmap to figure out the IP -address of the Raspberry Pi.
Logon to the Rasbian Operating System
$ ssh pi@ip-address
password: raspberry
Setup Wireless a connection to your AccessPoint
I’ve been using the TL-WN725N Wireless-N USB adapter from TP-LINK on all my Raspberry Pi projects. If you want to use WiFi, you need to configure your WPA settings (assuming you use WPA2 on your Access Point).
| sudo nano /etc/wpa_supplicant/wpa_supplicant.conf |
add following lines:
| network={ ssid=”The_ESSID_from_your_AccesPoint” psk=”Your_WiFi_password” } |
Finalize the Raspberry Configuration
By using the raspi-config script it is easy to configure several things on your Raspberry Pi without digging too much into the OS.
| sudo raspi-config |
– expand filesystem
– change hostname
– change password
You need to reboot the Raspberry Pi to complete the configuration. You can now disconnect the your Pi from the UTP cable. It’s quite likely that your IP address changed during the reboot, so you might need to figure out the new IP address (see above). Logon to the Raspberry Pi again using ssh (also, see above).
Install rpi-update and update the Raspberry Pi firmware
You might want to update the Raspberry Pi firmware, to be able to do that you need to install rpi-update.
| sudo apt-get install rpi-update sudo rpi-update |
Install Squeezelite player
Next thing up, is installing the Squeezelite player and some extra codecs…
| sudo apt-get update sudo apt-get upgrade sudo apt-get install squeezelite sudo apt-get install libflac-dev |
Edit the squeezelite config file to prevent crackles from sound
The Raspberry Pi is not the fastest computer around, so you need to help it a bit. You can help your Pi by increasing the ALSA buffer size.
| sudo nano /etc/default/squeezelite |
Edit following line:
| # SB_EXTRA_ARGS=”” |
and change it into (be aware of losing the hashtag!):
| SB_EXTRA_ARGS=”-a 180″ |
Adjust the sound volume of your Raspberry Pi
Make sure you have the right audio volume level on your Raspberry Pi. Ensure that the playback level has zero gain => PCM [db gain: 0.00]. Tweak the gain-level by using the arrow keys up and down, in the end you will reach the zero db gain 🙂
| alsamixer |
You can now reboot your Raspberry Pi and enjoy your music!
Suggestions for improving this article are welcome, please let me know and drop me a line .
Using Wiican makes gaming easier in Linux
A month ago I stumbled upon a program called Wiican. Wiican is a fantastic program, or to put it more correctly it’s a bunch of extremely powerful scripts, that makes your life easier using your Wii Mote in Linux.
Having my holidays within sight, I really didn’t have time to give it a close look before I took of to France. “Luckily” I had some time during my holidays (read: I had some rainy days) to experiment and discover the power of Wiican.
So after a bit of fiddling I came up with a script that to use your Wiimote in First Person Shooter (FPS) games like Assaultcube, Sauerbraten, Warsow), etc.
Prerequisites (what you need to get it working):
- Hardware
- Computer running Ubuntu
- Network connection
- Software
- Wiican installed (I’ll describe the installation of Wiican in a different article, because at this moment the installation struggles with some dependencies issues)
- Download and unzip the Wiican script I wrote
- Import the script within Wiican (details will follow when I’m back from my holidays)
- Start the script
- Hookup your WiiMote
- Start fragging some bots
Or you can try to write your own script within Wiican…
Script contents:
| Name : CUBE Game Gamepad Comment : Control CUBE games using the Wiimote Authors : Winko Erades Version : 0.3# Wiimote accelerometer as mouse XY axis Plugin.acc.X = REL_Y Plugin.acc.Y = – REL_X# Wiimote buttons for movement Wiimote.Up = KEY_LEFT Wiimote.Down = KEY_RIGHT Wiimote.Left = KEY_DOWN Wiimote.Right = KEY_UP # Wiimote buttons for shooting and jumping |
And now start fragging!!! 🙂
Suggestions for improving this article are welcome, please let me know and drop me a line.
Upgrading your SqueezeCenter server on Ubuntu
In a previous article I tried to explain the installation of the Squeezebox Server on the Tonido Plug. In this article I’ll try to explain how to perform an upgrade of your existing Squeezecenter Server on Tonido (or Ubuntu as the Tonido Plug is based on Ubuntu 9.04).
What you’re going to do is actually remove the old installation of the Squuezecenter server and install a new copy of the Squuezecenter server.
Prerequisites (what you need to get it working):
- Hardware
- Computer
- TonidoPlug (optionally)
- Internet connection
- Software
- Windows users might need Putty
The first thing you need to do is remove the ‘old’ installation of the Squuezecenter server, by SSH-ing (Windows user might want to use Putty) the following command:
| apt-get purge –yes squeezeboxserver |
Next thing is cleaning up your Ubuntu installation by entering:
| apt-get autoclean |
You might want to update your Ubuntu installation by using the following commands:
| apt-get update apt-get upgrade |
Now you are ready to install the latest version of Squuezecenter server (Check the Squeezebox server version and location, by locating the latest version using your internet browser).
| wget http://downloads.slimdevices.com/SqueezeboxServer_v7.5.3/squeezeboxserver_7.5.3_all.deb dpkg -i squeezeboxserver_7.5.3_all.deb apt-get -f install |
Now your Squeezebox Server should be upgraded, you can check it by locating it in your internet browser
http://YourSqueezeboxServerName:9000/
or
http://YourSqueezeboxServerIpAddress:9000/
If needed you can manually stop or start your Squeezebox Server
| /etc/init.d/squeezeboxserver stop /etc/init.d/squeezeboxserver start |
Suggestions for improving this article are welcome, please let me know and drop me a line !