Control Hubs: Bringing It All Together - Smart Home Automation with Linux and Raspberry Pi - page 253

Figure 7-7. The photo frame can operate as a slide show on kiosk machines
By clicking the main image, this app can work in the full browser window, making it suitable as an interactive
photo frame for those times when a machine is not being used as a control panel. You can cycle through the images
using hotspots on the left and right of the image, while the lower portion returns you to non-full-screen mode.
The Internet has a lot of available images to fit the frame, including those for the culture vultures at
http://www.most-famous-paintings.org .
Information
These applets provide information about the real world, which is also useful and valid when outside the house. There
is potential overlap from these and your lifestyle, but it's a good enough distinction for now!
Moonbeam is an applet that relies on MySQL to store a list of bookmarks, each with multiple tags. It is similar
to http://del.icio.us , except that all data is held on your own server. To prepare the database, you can run the
build/applets/moonbeam/createdb.sql script using your existing root account:
$ mysql -u your_username -h your_machine_name -p < createdb.sql
Then enter your password to build an empty database. You can populate it with sample links by adding the same
credentials to the config.php file in the same directory and running the following:
php init.php
You can then add this account information to the Moonbeam's web configuration at conf/moonbeam/config.php
and use the applet as normal. If you want to create an alternate user to access the Moonbeam database (which is
recommended), then log into MySQL and enter the following:
CREATE USER 'moonbeam'@'localhost' IDENTIFIED BY 'some_pass';
GRANT SELECT on moonbeam.* TO 'moonbeam'@'localhost';