Community Blogs

He's GNUing the Distance, He's GNUing for Speed: My Top 7 Favorite Games for Debian GNU/Linux

Often times when I talk with fellow computer enthusiasts, usually Microsoft users, I am met with derisive shouts proclaiming GNU/Linux to be devoid of quality games. With that in mind, I decided to voice my opinion on what I consider to be some of the best games available for the Debian GNU/Linux operating system.While most people choose five or ten for their top lists, I decided to go with seven as it is my lucky number. For my pricing descriptions, I shall borrow from Free Software Foundation founder Richard Stallman's classic quote, "'Free as in Freedom,' not 'Free as in Free Beer'" to denote titles that are financially free to download.

7.) Armagetron
For Debian-based systems:# apt-get install armagetronad
Price: "Free as in Free Beer"

An oldie-but-a-goodie, this Free Software title evokes the excitement of the original 1982 Tron film's light-cycle grid battles. Despite its minimalistic control scheme, it continues to thrill gamers like me who enjoy all the twists and turns that come from such a frenetic title.

6.) Osmos
Price: Pay what you want

I did not originally know what to make of this innocuous puzzle game when I purchased it as part of the second Humble Indie Bundle, as you play a microscopic organism intent on expansion. As the days went by, I found it to be a deceptively captivating release as well as a welcome bit of respite during my lunch hour at work.

5.) World of Goo
Price: Pay what you want

With my mother being a mechanical engineer, I grew up appreciating the logic and care that goes into building sound structures. This game is a problem-solving physics game where you must surmount obstacles of varying degrees of difficulty with exponentially increasing levels of ingenuity. A very whimsical title for gamers of all ages, it was available from the Humble Indie Bundle #2 in December of 2010 as a bonus game for earlier purchasers.   

4.) Braid
Price: Pay what you want

A delightful game betwixt Super Mario Brothers and Prince of Persia, Braid allows users to rewind time to prevent painful mistakes. This quantum quality underscores the game's story, which showcases the trials of a man named Tim as he attempts to reconcile a past relationship with a princess. With a combination of beautiful art direction and calming musical accompaniment, this was one of main reasons I purchased the Humble Indie Bundle #2 in December of 2010.

3.) Revenge of the Titans
Price: Pay what you want

This past week, I was home sick for several days with nothing to do but rest, work on college classwork and experiment on a Humble Indie Bundle title I purchased called Revenge of the Titans. Save for being sick, it was one of the most enjoyable experiences I've had in years playing tower defense real-time strategy games on PC.

2.) Frozen Bubble
For Debian-based systems:# apt-get install frozen-bubble
Price: "Free as in Free Beer"

With the crazed tempo of most modern PC and console games, it is a delight to find such an engaging title in the form of Frozen Bubble. With no blood, gore or violence to speak of, its a puzzle game suitable for any gamer. I have had much jocularity with my siblings over this release, and I intend to keep playing it for years to come.

1.) Nexuiz/(Xonotic)
Price: "Free as in Free Beer"

In contrast to the adorable penguins of Frozen Bubble is that of the first-person shooter Nexuiz (hereafter forked as Xonotic due to licensing issues) I have had many a goodhearted frag-fest with other fans of this FLOSS title over the years, including a memorable game of "hide-and-seek" involving rocket launchers. As soon as Xonotic sees its first official release, the fork shall be with me.

If you have not already installed these games via terminal or purchased them, I hope you will give them a chance. Until then, GNU yourself a favor and enjoy your favorite games on the only operating system that is free as in free speech and free as in free beer.


Pinguy OS LTS Update: 10.04.2 [Ubuntu Remaster]

An update for Pinguy OS 10.04 LTS was released today: 10.04.2. For those who are not familiar with Pinguy OS: it's an Ubuntu remaster with a lot of useful default applications "built to have eye candy (Gloobus Preview, GNOME Do, Docky, Nautilus Elementary) and for every part of it to be user-friendly". It comes with a lot of applications we've featured on WebUpd8 so if you want a ready-to-use Linux distro, you should really try Pinguy OS. I like to call it "Ubuntu after a week of customization" but lately it's getting way past "a week".

Pinguy OS 10.04.2 comes with some of the features from 10.10 that were missing in 10.04 like the Sound Menu applet or the new Ubuntu Software Center. Pinguy OS also comes with a new default application: TeamViewer 6, a popular application for remote control, desktop sharing and file transfer between computers.

Full story: Pinguy OS LTS Update: 10.04.2 [Ubuntu Remaster]

Read more... Comment (0)

Useful Mysql Commands

To login (from unix shell) use -h only if needed.

# [mysql dir]/bin/mysql -h hostname -u root -p

Create a database on the sql server.

mysql> create database [databasename];

List all databases on the sql server.

mysql> show databases;

Switch to a database.

mysql> use [db name];

To see all the tables in the db.

mysql> show tables;

To see database's field formats.

mysql> describe [table name];

To delete a db.

mysql> drop database [database name];

To delete a table.

mysql> drop table [table name];

Show all data in a table.

mysql> SELECT * FROM [table name];

Returns the columns and column information pertaining to the designated table.

mysql> show columns from [table name];

Show certain selected rows with the value "whatever".

mysql> SELECT * FROM [table name] WHERE [field name] = "whatever";

Show all records containing the name "Bob" AND the phone number '3444444'.

mysql> SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444';

Show all records not containing the name "Bob" AND the phone number '3444444' order by the phone_number field.

mysql> SELECT * FROM [table name] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number;

Show all records starting with the letters 'bob' AND the phone number '3444444'.

mysql> SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444';

Show all records starting with the letters 'bob' AND the phone number '3444444' limit to records 1 through 5.

mysql> SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444' limit 1,5;

Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with a.

mysql> SELECT * FROM [table name] WHERE rec RLIKE "^a";

Show unique records.

mysql> SELECT DISTINCT [column name] FROM [table name];

Show selected records sorted in an ascending (asc) or descending (desc).

mysql> SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;

Return number of rows.

mysql> SELECT COUNT(*) FROM [table name];

Sum column.

mysql> SELECT SUM(*) FROM [table name];

Join tables on common columns.

mysql> select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;

Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
mysql> flush privileges;

Change a users password from unix shell.

# [mysql dir]/bin/mysqladmin -u username -h -p password 'new-password'

Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

# mysql -u root -p
mysql> SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');
mysql> flush privileges;

Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

Set a root password if there is on root password.

# mysqladmin -u root password newpassword

Update a root password.

# mysqladmin -u root -p oldpassword newpassword

Allow the user "bob" to connect to the server from localhost using the password "passwd". Login as root. Switch to the MySQL db. Give privs. Update privs.

# mysql -u root -p
mysql> use mysql;
mysql> grant usage on *.* to bob@localhost identified by 'passwd';
mysql> flush privileges;

Give user privilages for a db. Login as root. Switch to the MySQL db. Grant privs. Update privs.

# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N');
mysql> flush privileges;
mysql> grant all privileges on databasename.* to username@localhost;
mysql> flush privileges;

To update info already in a table.

mysql> UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user';

Delete a row(s) from a table.

mysql> DELETE from [table name] where [field name] = 'whatever';

Update database permissions/privilages.

mysql> flush privileges;

Delete a column.

mysql> alter table [table name] drop column [column name];

Add a new column to db.

mysql> alter table [table name] add column [new column name] varchar (20);

Change column name.

mysql> alter table [table name] change [old column name] [new column name] varchar (50);

Make a unique column so you get no dupes.

mysql> alter table [table name] add unique ([column name]);

Make a column bigger.

mysql> alter table [table name] modify [column name] VARCHAR(3);

Delete unique from table.

mysql> alter table [table name] drop index [colmn name];

Load a CSV file into a table.

mysql> LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY ' ' (field1,field2,field3);

Dump all databases for backup. Backup file is sql commands to recreate all db's.

# [mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sql

Dump one database for backup.

# [mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql

Dump a table from a database.

# [mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

Restore database (or database table) from backup.

# [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql

Create Table Example 1.

mysql> CREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3),officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups VARCHAR(15),datestamp DATE,timestamp time,pgpemail VARCHAR(255));

Create Table Example 2.

mysql> create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastnamevarchar(50) default 'bato');


FTP file transfer with an automated bash script

This is a really quick blog post, I don't wanna bother you with a complete article related to FTP, this morning I've had to automate a batch job, this job needs to transfer local data to a remote FTP server here's what I've done:


ftp -n -v $HOST << EOT
cd upload
ls -la

The script automatically connects to a remote server "" with a defined username/password pair (remoteusername, remotepasswd) and execute some commands in the middle, in my case :

cd upload
ls -la

but of course you can customize with your own commands

This is not a tech article and not even something cool, just useful as a quick tip for a newbie, hope it helps..




Happy Programmer Day

The programmer day is celebrated on the 256th (0x100th) day of each year (September 13 during common years and on September 12 on leap years). The number 256 (28) was chosen because it is the number of distinct values that can be represented with an eight-bit byte

This particular day was proposed by Valentin Balt, an employee of Parallel Technologies web design company. As early as 2002 he tried to gather signatures for a petition to the Government of Russia to recognize the day as the official programmers' day.On July 24, 2009, the Ministry of Mass Communications of Russia issued a draft of an executive order on a new professional holiday, Programmers' Day. On September 11, 2009, President of Russia Dmitry Medvedev signed the decree.

So, this is a happy day for all the programmers, because in a non-official way, this day is celebrated around the world, so you can go and celebrate, or (the most real option) is to keep working on your desk and just change your msn title :D

Source: Wikipedia


Linux User Groups in Russia

Hi all!

Here I wish tell about features the LUG's in Russia. Who I talked in my first post( I
is a coordinator a Ekaterinburg LUG( in Russia. Our community was created on 19 Feb. 2008 year. For that time we conducted several activities and conferences about OpenSource and his application in academic and state organizations(you can see our
reports about our fests here[in Russian]:

It should be noted that our community is among the five most active in Russia, but we not have a sponsors to carry out our activities at a higher level. Yes, we arended audience in Institutes, but it is rather difficult. At the moment we are very actively looking for sponsors, but so far our attempts have not yielded tangible results. I would be glad to share experiences and learn from others about the holding of conferences and fests.

You also can contact me for this e-mail address: remalloc {at} gmail {d0T} com.


Plese, sorry for my bad English...


Best regards, Kirill Shirshov also know as remalloc


First post

This is the first post in this blog, to get things going. I will try to post as often as i can. I mainly post at my external blog but i will try to post the same things here so that users can follow my writings here instead of at my blog.

I am a Debian user and a C developer. I am using software like VIM/GVIM, Subversion, Geany, Anjuta, and others to do my work etc. This is what i will blog about when i have the time.

Favorite subjects would be C, NCurses, GTK+, Subversion, administration of Linux systems (Debian) and a few other things. I am also a science geek which i write about in my external blog. This i wont blog about here but i mention it because it will take a lot of my time and it will make it difficult for me to post reguarly about linux and programming.

I have been using Linux since 1997...


U.K. Officials Suggest To Use Linux

U.K. Officials Suggest to dump all the Microsoft software and start using Linux and Open Office. The Linux and GNU software offer a free or a very low cost alternatives to Microsoft software, so why to expend on a system which is expensive if you can have it free or at low cost. In words of Prime Minister David Cameron:

In terms of spending less, what about migrating the whole of government (the NHS, education etc.) from Microsoft products to Linux and open-source software like Openoffice.

Source: Business Week News



I was at the mall today, looking at all the fancy new games (and old ones) on the Wii. I found pretty ridiculous that some 3 year old games were at the same price as some of this year's.

Back in high school and college, I used to "invest" in video games (both money and time), more than I did today. But even then, I don't remember spending that much money. I have a Xbox at home - not the 360 one, the old brick. It sits in the basement, acting as a media center these days. I recall buying old games on it at ridiculously low prices - the lowest being 2$. But from the looks of thing, I don't think I'll be doing that on the Wii - unless I end up with some mini game compilation.

It makes me think of how much it costs to like Star Trek. I remember shopping for the Voyager series - about 60$ per season. And there are 7 of them. Let me say, at that price, the lure of torrents is very strong. I can resist, but for many, resistance is futile. I mean, it takes a lot of motivation to spend that much on a TV show that started in 1995, even if I loved it.

I instead turned my eyes on music - I got the soundtracks of The Elder Scrolls III and IV (Morrowind and Oblivion for the quick ones). For about 16 bucks, I'd say it was a pretty good deal. The music is just great - if you liked the game and its music, you'll certainly love the soundtrack.

That being said, there seems to be some cool items in the store - I'll have to check that back some day. People stopping by to ask you about fresh kernels? Priceless.


Iphone Can Relieve Stress

[video: 450x300]

Speechless, all is true. I need to download that app :D


The Best 75 Tux Wallpapers

Well, not all in life is programming, and after have the best software of the world (yes, I'm talking about Linux), you can give a new look to your desktop with this collection of 75 of the best (in the author words) wallpapers featuring Tux, enjoy!!!

Source: Designora

Page 4 of 15

Upcoming Linux Foundation Courses

  1. LFD211 Introduction to Linux for Developers
    08 Dec » 09 Dec - Virtual
  2. LFS220 Linux System Administration
    08 Dec » 11 Dec - Virtual
  3. LFD331 Developing Linux Device Drivers
    15 Dec » 19 Dec - Virtual

View All Upcoming Courses

Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board