aiccu: add IPv6 connectivity to your machine
Article submitted by Caspar Clemens Mierau. Guess what? We still need you to submit good articles about software you like! It’s time: no reason should prevent you from adding IPv6 connectivity to your machine. Of course it’s still an issue, as most ISPs don’t provide native IPv6. So in most cases the easiest way for you [...]

Article submitted by Caspar Clemens Mierau. Guess what? We still need you to submit good articles about software you like!

It’s time: no reason should prevent you from adding IPv6 connectivity to your machine. Of course it’s still an issue, as most ISPs don’t provide native IPv6. So in most cases the easiest way for you is to set up a tunnel to an IPv6 broker. There are currently several free brokers. I’ll show a simple way of getting IPv6 connectivity with the aiccu and SixXS.

Apply for an account

First you have to apply for an account on SixXS. Please note: as a kind of ISP, Sixxs really need valid information from you. You may give them a link to your Xing or LinkedIn profile.

Your application will be checked and (probably) approved. Wait for the mail. After that go to the SixXS website, request a new tunnel, and pick an entry point near you. This step also needs to be approved. Wait for the mail (it takes up to a day).

Set up aiccu

Now let’s get it running. Install the package aiccu (apt-get install aiccu). During installation you will be asked, which broker you are using. SixXS is already preconfigured, so choose it and input your account information. If everything is fine, aiccu will check SixXS and ask for your tunnel information.

Open a terminal and run ifconfig sixxs—it should show a new network interface with an IPv6 address. Now let’s check IPv6. Open Firefox and go to http://www.kame.net/. If the turtle logo is moving, your are using IPv6, if it does not, you don’t.

The SixXS credit system

You should understand the SixXS credit system. It’s used to limit users in repeating bad actions and to make sure they maintain their tunnels. For example if a static tunnel is down it will cost you some credits, thus you better keep it up. One could see the credit system as a bank, you got a credit limit and you can’t go over it and buy everything you want, but when you earn credits because your tunnel is up you can do a lot with it.

Security issues

Note that all your IPv6 traffic will be directed through the broker, so you have to take care of the security.

IPv6 content

Check http://www.sixxs.net/misc/coolstuff/ for interesting IPv6 content: high traffic news servers, the IPv6 freenode server and so on. Always keep in mind, that not every application is ready for IPv6 and many applications need to be configured for IPv6. With Debian/Ubuntu you should be able to use at least Firefox, Thunderbird, Pan, and Irssi.

aiccu is available in Debian since Etch, and in Ubuntu since Feisty

Happy networking!



FlameRobin: A GUI to Administer Firebird/Interbase SQL servers
Article submitted by Anton Kavalenka. Firebird SQL server is popular because it is free, open, lightweight and secure. Firebird is based on the Interbase SQL server, and can be accessed by the same client libraries. FlameRobin is a X-platform GUI application that makes the life of Firebird/Interbase admins easier. It’s a very light-weight solution (implemented [...]

Article submitted by Anton Kavalenka.

Firebird SQL server is popular because it is free, open, lightweight and secure. Firebird is based on the Interbase SQL server, and can be accessed by the same client libraries.

FlameRobin FlameRobin is a X-platform GUI application that makes the life of Firebird/Interbase admins easier. It’s a very light-weight solution (implemented with wxWidgets) as opposed to Tora, which tries to be universal, but is very huge and takes a while to load. FlameRobin starts almost instantly, but being lightweight doesn’t mean to be poor in features. Some of them are:

  • Create and drop database entities like tables, views, procedures, indices, domains, constraints, triggers, generators, etc.
  • Powerful SQL Editor
  • Perform SQL queries and view results in Unicode-aware GUI. Queries can be built by drag-and-dropping table columns in the SQL editor.
  • Manage several server connections
  • Perform queries on system tables RDB$xxxx (system tables)
  • Manage database rights
  • Get the DDL as text for automated table creation.
  • Event monitoring. You can subscribe to one or multiple events and control when and how many of each event happened in the database.
  • Create all the TABLES, DOMAINS, CONSTRAINTS, USERS, TRIGGERS, PROCEDURES etc, needed for database functionality.
  • FlameRobin always displays the SQL statement it’s going to run, so you always know what is happening in your database and no under-the-hood mechanism obscures your actions.
  • Editable data grid, you can modify existing data inside the grid and also add and remove rows. Blob values can be updated from files.
  • FlameRobin can have multiple log files for a given database, one for each statement, making it easy to build update scripts for production databases.

Using Firebird and FlameRobin included in Debian it is possible to backup a database from Windows, restore it on Linux and take off SQL server load from workstation. This is the only way to move database between 32-bit and 64-bit architecture. It is a feature of Firebird (or maybe bug). On the same architectures database files can be simply copied.

SQL EditorThe SQL Editor has syntax highlighting and auto-completion. SQL statements can be entered, load, saved and executed. You can prepare a query and view the execution plan without executing it.

Availability

FlameRobin is available in Debian since Etch and in Ubuntu since feisty.



aria2: high speed command line download utility
Bonus article this week, submitted by Anthony Bryan and Tatsuhiro Tsujikawa. If you’re a frequent downloader and comfortable on the command line, then you need to try out aria2. aria2 is a cross platform download utility, similar to graphical download managers except that it uses less system resources. aria2 has a number of invaluable features such as [...]

Bonus article this week, submitted by Anthony Bryan and Tatsuhiro Tsujikawa.

If you’re a frequent downloader and comfortable on the command line, then you need to try out aria2. aria2 is a cross platform download utility, similar to graphical download managers except that it uses less system resources.

aria2 has a number of invaluable features such as download resuming, BitTorrent and Metalink support, segmented downloading, downloading a single file from one or multiple servers (including integrated BitTorrent and HTTP/FTP transfers), downloading many files at the same time, automatic error recovery/repair (BitTorrent and Metalink downloads only), etc.

aria2 is a command line application, but don’t let that scare you off. You can use aria2fe, a graphical front end, if that makes you more comfortable.

Keep in mind that aria2 is more for heavy downloading, and if you want a webspider then wget would be a better choice.

How to use it

The easiest way to invoke aria2 is by typing aria2c URL/fileName

$ aria2c http://host/image.iso

The URL can be either a regular URL to a file, a URL to a .torrent file, or a URL to a .metalink file. For BitTorrent and Metalink downloads, there are extra options available such as throttling upload speed, only downloading selected files, changing listening ports, and seed time and ratio. To pause a download, press Ctrl-C. You can resume the transfer by running aria2c with the same argument in the same directory.

Downloading identical files from multiple sources

aria2 supports multiple URLs for the same file. You can specify them on the command line (space separated) and aria2 will download from multiple URLs at the same time.

$ aria2c http://host/image.iso http://mirror/image.iso

This command will split the download between multiple servers. aria2 can even download the same file from BitTorrent and FTP/HTTP at the same time, while the data downloaded from FTP/HTTP is uploaded to the BitTorrent swarm.

Repairing damaged downloads

aria2 can repair downloads with errors by using the information in .torrent or .metalink files.

$ aria2c -M test.metalink --check-integrity=true

The -M option specifies a local file called test.metalink to get the information to repair the download.

Parameterized URLs

You can specify set of parts. The following command will download part of the same file from 3 servers, don’t forget to escape the parameter to avoid shell expansion.

$ aria2c -P 'http://{host1,host2,host3}/file.iso'

You can specify numeric sequence using []. This command will download image000.png through image100.png from the same server.

$ aria2c -Z -P 'http://host/image[000-100].png'

The -Z option is required if the all URIs don’t point to the same file, such as the above example.

Other options

aria2 has a lot more options, you can for instance use:

  • -T filename.torrent to specify a local .torrent file.
  • -M filename.metalink to specify a local .metalink file.
  • -i textfile will download all the URLs listed in a textfile.
  • -s for example -s2 will download a file using 2 connections.
  • -j for example -j5 will download 5 files concurrently.

aria2 has many other options. To read the man page, type:

$ man aria2c

Availability

aria2 is available on most Linux distributions. Official Debian and Ubuntu package are available:

  • Debian: stable, testing and unstable
  • Ubuntu: feisty, gutsy, and hardy.

Community & developers

aria2 is actively maintained and developed by Tatsuhiro Tsujikawa. Bug reports, feature requests, and forums are found on SourceForge.

Links

  • aria2 Homepage
  • Download page for source, Mac OS X and Windows binaries
  • SourceForge: aria2 bug reports and feature requests
  • SourceForge: aria2 forums
  • aria2 on Wikipedia
  • Metalink Homepage


  • DevTodo: a reminder/task program aimed at developers.
    Article submitted by Raman Pandarinathan. DevTodo is a simple command-line-based package to keep todo lists. Lists are prioritized and hierarchical. Each task in the list has a priority (very high, low, medium etc.) and a given task can be linked to another todo database, making the list hierarchical. The lists are stored as an XML file [...]

    Article submitted by Raman Pandarinathan.

    DevTodo is a simple command-line-based package to keep todo lists. Lists are prioritized and hierarchical. Each task in the list has a priority (very high, low, medium etc.) and a given task can be linked to another todo database, making the list hierarchical. The lists are stored as an XML file (.todo) in the current directory, so if you manage multiple projects, you can have different todo lists and DevTodo will update the information based on your current working directory.

    As the Todo list is stored in an XML file, you can use an XSLT template to export it to other formats. In Debian, you can find templates to export to HTML and PDF in /usr/share/devtodo.

    Managing your todo lists

    DevTodo in action

    Basic commands are:

    • todo displays the list of tasks pending in the order of priority.
    • tda adds a task to the list. The optional argument -g links the task to another task (creates a subtask).
    • tdd marks a task as complete (done) with comments.
    • tde edit a task.
    • tdr removes a task completely.

    With the use of some small shell scripts, when you cd into a directory with a .todo in it, DevTodo can display the Todo items for that directory. There are scripts for bash and tcsh in /usr/share/doc/devtodo/examples. To enable it under bash, add this to your .bashrc:

     if [ -f /usr/share/doc/devtodo/examples/scripts.sh ]; then   . /usr/share/doc/devtodo/examples/scripts.sh fi 

    Pros and Cons

    • Pros
      • Simple command line interface.
      • Easy storage using XML.
      • Fast and elegant.
      • Oriented towards developers.
    • Cons
      • No GUI.
      • No recent development (last commit was at the end of 2007), upstream seems to be inactive.
      • No calendaring.

    Availability

    DevTodo is available in Debian since Sarge and in Ubuntu (universe) since Dapper.



    ddclient: getting access to home servers despite having a dynamic IP
    Article submitted by Toni Zimmer. There will be a day when you need access to your Debian box from another place than home, for example to get files from your home server with scp or if you’re running a webserver, an irc proxy, a ftp server, a mail server… Most likely your ISP gives you a dynamic [...]

    Article submitted by Toni Zimmer.

    There will be a day when you need access to your Debian box from another place than home, for example to get files from your home server with scp or if you’re running a webserver, an irc proxy, a ftp server, a mail server…

    Most likely your ISP gives you a dynamic IP address. This problem can be solved by getting a static DNS name, so you can connect to your home even if your IP keeps changing. First of all you have to create an account with your favourite dyndns provider. I use dyndns.org but there are others, such as easydns.com, dslreports.com or zoneedit.com. You can use others if you know ddclient supports its protocol.

    There you can specify the hostname (combined with a domain name) for your computer. You can enable mail routing if you want to setup a home mail server.

    When you install ddclient you will be asked for the dyndns service provider where you created your account. After that you must enter the complete (or fully qualified) domain name of your computer (something like dpotd.gotdns.org) and your account name (including the password, which will be stored in plaintext in /etc/ddclient.conf!). Now you have to chose the interface that connects you to internet. ddclient will get your IP address from there, so you shouldn’t be behind a NAT. Afterwards you will be asked if you want to start ddclient when connecting with PPP and if you want ddclient to run on system startup or not (probably you will use the first or the second choice). If you choose to run ddclient on startup, you can enter a delay between address checks (default are five minutes, so every five minutes your system will tell your current IP address to your dyndns service provider).

    Your settings are stored in /etc/ddclient.conf and look like this:

    # Configuration file for ddclient generated by debconf # # /etc/ddclient.conf  pid=/var/run/ddclient.pid protocol=dyndns2 use=if, if=eth0 server=members.dyndns.org login=dyndnsloginname password='dyndnsloginpassword' dpotd.gotdns.org

    If everything is okay, wait a couple of minutes for the DNS information to populate and then you will be able to do something like ssh dpotd.gotdns.org or w3m dpotd.gotdns.org

    ddlient is available in Debian since Sarge and in Ubuntu (universe) since Dapper.



    email-reminder: Never forget a birthday or an anniversary again!
    Article submitted by Fran�ois Marier. Guess what? We still need you to submit good articles about software you like! Email-Reminder is a simple tool to define events for which you want to receive a reminder by email. These reminders (sent out daily by a small cronjob) can be either on the day of the event and/or [...]

    Article submitted by Fran�ois Marier. Guess what? We still need you to submit good articles about software you like!

    Email-Reminder is a simple tool to define events for which you want to receive a reminder by email. These reminders (sent out daily by a small cronjob) can be either on the day of the event and/or a few days beforehand.

    Events can be:

    • birthdays
    • anniversaries
    • weekly, monthly and yearly events

    Sample Reminders

    Here is an example of what you get in your inbox for an upcoming birthday:

     From: Email-Reminder Date: Tue, 12 May 2007 04:00:22 -0400 (EDT) To: Francois Marier  Subject: Trent Reznor’s birthday  Hi Francois,  I just want to remind you that Trent Reznor is turning 42 in 5 days.  You can reach Trent Reznor at trent@example.com.  Have a good day!  – Sent by Email-Reminder 

    And here is one on the day of an anniversary:

     From: Email-Reminder Date: Tue, 29 Jul 1996 04:00:11 -0400 (EDT) To: Francois Marier  Subject: 15th anniversary of Prince Charles and Lady Diana  Hi Francois,  I just want to remind you that the 15th anniversary (Crystal) of Prince Charles and Lady Diana is today.  Have a good day!  – Sent by Email-Reminder 

    Event Definition

    Events for each user are defined in an XML file (~/email-reminders) in that user’s home directory, click here to see a sample file. You don’t actually have to define each event by hand in the XML file though. Email-Reminder comes with a simple GTK user interface:

    email-reminder GUI 1 email-reminder GUI 2

    Availability

    Email-Reminder has been in Debian since Sarge and in Ubuntu since Dapper. It is licensed under the GPL.

    More Information

    You can find out more about Email-Reminder by visiting its homepage and subscribing to its news feed.

    If you want to get involved, see the roadmap and feel free to contribute some patches!



    mythtv: A personal TV recorder
    Article submitted by Karl Erlandson. Do you think there are better alternatives to the packages posted here? Help us! Submit good articles about software you like! No one likes to sit at home and wait for their favorite show to come on anymore and many have turned to buying hardware to record them for later viewing. [...]

    Article submitted by Karl Erlandson. Do you think there are better alternatives to the packages posted here? Help us! Submit good articles about software you like!

    No one likes to sit at home and wait for their favorite show to come on anymore and many have turned to buying hardware to record them for later viewing. Popular solutions to this problem include the expensive and proprietary TiVo and cable/satellite boxes with built-in TV recorders.

    MythTV aims to solve these problems without the need to rent a cable box ($15/month) or buy a TiVo (~$200). An older computer can be used and all that needs to be purchased is a simple TV card, which can be found for under $30 on eBay. An HDTV card will cost you more, and will also require a more recent computer. If your TV card doesn’t come with a remote control, a controller will have to be purchased separately.

    As of last year, the TV guide info used for MythTV in North America is no longer free. Unfortunately, if you live in the USA or Canada, you now have to pay a subscription fee if you want to access the TV guide info, but the cost is negligible at $20/year and going down with every new subscriber. There is a free trial period available. If you live in another country, you may find TV listings for your country in XMLTV.

    Features

    MythTV main menuWhat MythTV gives you that those other boxes don’t is freedom, it’s open source so you can do whatever you want with your machine. For example, you can set it to automatically skip commercials (a feature that surprisingly works!).

    MythTV can be divided into two main programs, the Backend and the Frontend. The Backend refers to the program that actually records programs and must be installed on a computer that has a TV tuner. The Frontend program allows you to view content from the Backend. Importantly, the Frontend program can be installed on the Backend or as a stand-alone program on any computer. With a Frontend only install, you can watch what you’ve recorded in any room of your house. They will also have the ability to watch live TV (with options to pause, rewind, fast forward).

    MythTV also offers many recording options with the ability to record a show daily, weekly, once, only in a certain timeslot, etc. Since it is open source, various improvements have been added. An interesting plugin was developed that overcomes the problem of recording sports when games go on longer than scheduled. This program actually checks the web to see if the game it is recording has gone into extra time and adjusts the recording time to end later.

    Mythtv browsing through the video library

    MythTV will organize your music and video libraries and allow all that downloaded content to be played on your home entertainment system. Album and DVD art can be automatically downloaded from IMDB. I have to say that the music system could use a lot of work.

    MythTV web interfaceOther options include the ability to schedule your recordings over the internet, watch your shows over the internet, display weather alerts, and notify you of new emails on screen.

    Availability

    MythTV is not available as a Debian package due to licensing/legal issues, but it is on debian-multimedia. To enable this repository, add this to your /etc/apt/sources.list:

    deb http://www.debian-multimedia.org/ stable main 

    (instead of stable, put “testing” or “unstable” if you use that flavors of Debian). Now run apt-get update. The MythTV wiki provides instructions to install it in Debian stable (Etch), Debian unstable (Sid) and Ubuntu. The Ubuntu community has its own set of installation instructions. I found the KnoppMythWiki very useful in setting up my machine. They also offer a MythTV distribution.



    EasyTag: a graphical interface to managing your music files’ tags
    Article submitted by Dominique Cimafranca. EasyTag is a graphical utility to edit the descriptive ID3 tags for your music files. One will think primarily of MP3 files, but it also does other formats, such as Ogg, FLAC, MP4/AAC, MusePack, Monkey’s Audio files and WavPack files (APE tag). EasyTag’s screen real estate is divided into three windows. The [...]

    Article submitted by Dominique Cimafranca.

    EasyTag is a graphical utility to edit the descriptive ID3 tags for your music files. One will think primarily of MP3 files, but it also does other formats, such as Ogg, FLAC, MP4/AAC, MusePack, Monkey’s Audio files and WavPack files (APE tag).

    EasyTag main windowEasyTag’s screen real estate is divided into three windows. The left window shows you the directories of your file system. The middle window shows you the music files in your currently selected directory. The right window is further subdivided into top and bottom information boxes: the top shows you the technical information about the file (bit rate, frequency, mode, size, and time), and the bottom shows you the actual ID3 fields.

    The ID3 fields are pretty complete as they let you fill in all the relevant info you could want to put in, e.g., title, artist, album, year, genre, personal comments. You can also attach a photo to the file.

    Once you start up EasyTag, it will search your home directory for any and all music format files. This behavior is either helpful or annoying; if it’s the latter, you can simply stop the search and go to the directory of your choice. It will resume the search from there.

    Tagging files

    There are three ways to tag music files with EasyTag:

    • Manually.
    • Automatically with the “Fill Tag” scanner.
    • Automatically via CDDB, which is a database for software applications to look up audio CD information over the Internet.

    Manual tagging is pretty much self-explanatory (and tedious.)

    The mask editor dialogAutomatic Fill Tag relies on the filenames of your music files to automatically fill in the ID3 entries. EasyTag has a couple dozen formats that cover almost every imaginable case.

    Automatic CDDB tagging only works if files are sorted per album and if the actual CDDB entry exists. You don’t actually have to have the CD on hand: you can search for the album ID through EasyTag. Once found, it will label the files for you.

    All in all, a great way to manage and maintain information on your music files.

    Availability

    EasyTag is available in Debian since at least Sarge and in Ubuntu (universe) since Dapper.



    Debian- administration .org on rinetd
    Unusual non-article ahead: Debian-administration.org has a nice article about rinetd entitled “Easily forwarding arbitrary TCP connections with rinetd”, go and check it, it is an interesting package I didn’t know about!

    Unusual non-article ahead:

    Debian-administration.org has a nice article about rinetd entitled “Easily forwarding arbitrary TCP connections with rinetd”, go and check it, it is an interesting package I didn’t know about!



    mrxvt: Fast, light multitabbed terminal emulator
    Article submitted by Hugo Carrer. As any other Debian user I love writing obscure commands on my terminal. I love too having so many open terminals that I have to come up with a special system to find the one where my favorite obscure command is running on. To be able to enjoy this I need a [...]

    Article submitted by Hugo Carrer.

    As any other Debian user I love writing obscure commands on my terminal. I love too having so many open terminals that I have to come up with a special system to find the one where my favorite obscure command is running on.

    To be able to enjoy this I need a very fast multitabbed terminal emulator: mrxvt.

    Some of the things I like the most about mrxvt are for example,

    • It is very fast and light.
    • Fast pseudo-transparency.
    • Background with your favorite images.
    • Highly configurable keyboard shortcuts.
    • You can have the same command typed on every tab at the same time. This feature is disabled by default. you can enable it by editing /etc/mrxvt/mrxvtrc and uncommenting the ToggleBroadcast macro (around line 171). After that, Ctrl+Shift+d toggles input broadcasting to all tabs.
    • Automatic or “by-hand” tab labeling.
    • It is independent of your desktop (no KDE or GNOME needed).
    • Did I mention that is very fast and light?

    After installing it would look something like this:

    a just installed mrxvt

    You can change this rather old fashioned look by copying the example config file from
    /usr/share/doc/mrxvt-common/examples/mrxvtrc.sample.gz
    And placing it in ~/.mrxvtrc

    The file is full of comments helping you with the meaning of each option. Of course you can find all available options in the man page. Some useful shortcuts are Ctrl+Shift+t to open a new tab and Ctrl+Shift+m to show the menu.

    So, after playing, trying and tweaking for a little while you can get a futuristic look for your terminals. Like this one of me sketching this article on an emacs session inside mrxvt (Note all those beautiful tabs up there)

    mrxvt in action

    Downsides? Well it depends on the kind of user,

    • No UTF-8 support.
    • It has no config menu.
    • You have to remember the shortcuts or read the config file every now and then.
    • And as with anything worth doing, to get things working the way you want to you’ll have to read through the man page and maybe scratch your head once or twice but it’ll work.

    To sum up, it’s the perfect application to config during those boring rainy weekends and then show off to your friends at work.

    mrxvt is available in Debian stable and in Ubuntu too.


 

0 评论: