Search Site

Feed Section

Friday, January 18, 2013

TechSource: Best Finance Software for Ubuntu

TechSource: Best Finance Software for Ubuntu


Best Finance Software for Ubuntu

Posted: 17 Jan 2013 05:52 PM PST

If you are too prissy about your finances then the old pen and paper method of bookkeeping doesn't work that well in this technology age. You often tend to misplace those papers and yeah, it's tedious writing every single detail out. Many users, these days, are moving towards finance software that helps them make their work easier. These tools help you organize your finances and make sure that all your bills, expenses and payments are manageable.

Though there are a lot of finance software available for Windows and Mac, our very own Ubuntu isn't that far behind when it comes to tools that help you manage your money. There are a lot of great finance software available for Ubuntu that you can start using right away.

So, without much ado, here are some of the best finance software for Ubuntu:


Darhon Finance

Darhon is a personal finance program that helps you track your credit cards, bank accounts and investments. It is very user-friendly and can handle multiple currencies, bank reconciliations, split transactions and more. You can then generate customized reports and graphs for better visualization of your finances. Darhon also comes with a powerful search functionality that helps you filter your transactions and export them to a text file or print them in PDF. Most important of all, the free tool, though not open-source, does let you set up your budget and plan your expenses accordingly.

License: Proprietary
Price: Free



wxBanker

wxBanker is a free, open-source application that makes it easier to track balances in accounts. Once installed, you can add, edit and remove transactions and accounts without much trouble. Moreover, you can also make transfers, search for transactions, and view of a graph of balances over time. wxBanker comes with an integrated calculator that makes it easier to do quick calculations.

If you want, you can also install the latest version of the application by installing the PPA. To do that, simply open the terminal (Ctrl + Alt + T) and paste in the following commands:

sudo add-apt-repository ppa:wxbanker-users/ppa
sudo apt-get update && sudo apt-get install wxbanker


For other users who always swear by the most stable version possible, there is the Ubuntu Software Center that can take care of their need.

License: Open Source
Price: Free



Grisbi

Grisbi is a personal accounting software that can handle multiple accounts, currencies and users. Not only does it help you manage your money using third-party expenditure and receipt categories, it also helps you manage budgetary lines, financial years, and other important information. This makes it suitable for both personal and associative accounting. If you use the aforementioned GnuCash and don't like it very much then you can easily switch to Grisbi by importing GnuCash files into it. Grisbi also supports importing accounts from QIF and OFX files. As for the reports, you can print them using LaTeX or export them via HTML (which can later be printed).

License: Open Source
Price: Free



GnuCash

GnuCash is probably one of the most popular money-managing applications out there for Linux. Suitable for small-business owners and individuals, this open-source application allows you to track your finances in multiple accounts and also keeps running and reconciled balances. The application supports customer, vendor, and employee processing and has a nicely designed interface. Moreover, users can also import data from Quicken QIF files and OFX files.

License: Open Source
Price: Free



Moneydance

Moneydance is a proprietary tool for personal finance that is available for Windows, Mac, Linux, and iOS. It handles online banking, bill payment, account management, budgeting, and investment tracking pretty well. Furthermore, Moneydance also supports multiple currencies thus making it easier for handling bigger transactions.

Moneydance also comes with a graphing tool that helps users generate visual reports of their income and expenses. You can customize the graph type, the date range, and any settings thus letting you get the graph you desire. Graphs can then be printed or saved as an image into PNG files.

License: Proprietary
Price: License needed for usage



You may also check out our other list of some of the best free and open-source finance and accounting software for Linux: Free and Open Source Finance/Accounting Software for Linux


Written by: Abhishek, a regular TechSource contributor and a long-time FOSS advocate.

Thursday, January 17, 2013

[HowtoForge] Newsletter 01/17/2013

HowtoForge Newsletter 01/17/2013
================================

*** Version 1.3 of the ISPConfig 3 Manual ***
=============================================

The next update of the ISPConfig 3 Manual is available in PDF format (version 1.3 for ISPConfig >= 3.0.4; Date: 10/25/2011).

Version 1.3 for ISPConfig >= 3.0.4 (Date: 10/25/2011)
Author: Falko Timme
333 pages

The manual can be downloaded from these two links:

http://www.ispconfig.org/ispconfig-3/ispconfig-3-manual/
http://www.howtoforge.com/download-the-ispconfig-3-manual


*********************************************
*********************************************


ISPConfig Monitor App for Android Phones
========================================

With the ISPConfig Monitor App, you can check your server status and find out if all services are running as expected. You can check TCP and UDP ports and ping your servers. In addition to that you can use this app to request details from servers that have ISPConfig installed; these details include everything you know from the Monitor module in the ISPConfig Control Panel (e.g. services, mail and system logs, mail queue, CPU and memory info, disk usage, quota, OS details, RKHunter log, etc.).

Download/Usage
==============

For download and usage instructions, please visit http://www.ispconfig.org/ispconfig-3/ispconfig-monitor-app-for-android/ .


*********************************************
********************************************


*** HowtoForge Now Has Its own Facebook Page ***
================================================

We at HowtoForge are proud to announce that our new Facebook page is now available under http://www.facebook.com/howtoforge. As most of you probably have a Facebook account, we want to use this additional channel to post updates and get feedback from you. Therefore we would like you to "Like" our page, share it with your friends, post comments, etc.

http://www.facebook.com/howtoforge
********************************************************************


New HOWTOs:
===========

* Installing Debian Wheezy (testing) With debootstrap From A Grml Live Linux
* How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
* Creating An NFS-Like Standalone Storage Server With GlusterFS 3.2.x On Ubuntu 12.10
* How To Install A Streaming Audio Server With Icecast 2.3.3 On CentOS 6.3 x86_64 Linux
* How To Automatically Add A Disclaimer To Outgoing Emails With alterMIME (Postfix On Debian Squeeze)
* Distributed Storage Across Four Storage Nodes With GlusterFS 3.2.x On CentOS 6.3

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Installing Debian Wheezy (testing) With debootstrap From A Grml Live Linux
==========================================================================

This tutorial explains how to install Debian Wheezy (testing) with the help of debootstrap from a Grml Live Linux system (like it is used as a rescue system at Webtropia). This should work - with minor changes - for other Debian and Ubuntu versions as well. By following this guide, it is possible to configure the system to your needs (OS version, partitioning, RAID, LVM, etc.) instead of depending on the few pre-configured images that your server provider offers.

You can find the document here:
-------------------------------
http://www.howtoforge.com/installing-debian-wheezy-testing-with-debootstrap-from-a-grml-live-linux




How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
===============================================================

mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on an Ubuntu 12.10 server.

You can find the document here:
-------------------------------
http://www.howtoforge.com/how-to-back-up-mysql-databases-with-mylvmbackup-on-ubuntu-12.10




Creating An NFS-Like Standalone Storage Server With GlusterFS 3.2.x On Ubuntu 12.10
===================================================================================

This tutorial shows how to set up a standalone storage server on Ubuntu 12.10. Instead of NFS, I will use GlusterFS here. The client system will be able to access the storage as if it was a local filesystem. GlusterFS is a clustered file-system capable of scaling to several peta-bytes. It aggregates various storage bricks over Infiniband RDMA or TCP/IP interconnect into one large parallel network file system. Storage bricks can be made of any commodity hardware such as x86_64 servers with SATA-II RAID and Infiniband HBA.

You can find the document here:
-------------------------------
http://www.howtoforge.com/creating-an-nfs-like-standalone-storage-server-with-glusterfs-3.2.x-on-ubuntu-12.10




How To Install A Streaming Audio Server With Icecast 2.3.3 On CentOS 6.3 x86_64 Linux
=====================================================================================

This tutorial explains creating your own streaming audio server with Icecast (OGG/MP3). Icecast was designed to stream any audio file if a appropiate streaming client is available. For OGG/Vorbis you can use ices and for MP3 icegenerator. Here is a small tutorial how to set up Icecast for streaming OGG/Vorbis and MP3.

You can find the document here:
-------------------------------
http://www.howtoforge.com/how-to-install-a-streaming-audio-server-with-icecast-2.3.3-on-centos-6.3-x86_64-linux




How To Automatically Add A Disclaimer To Outgoing Emails With alterMIME (Postfix On Debian Squeeze)
===================================================================================================

This tutorial shows how to install and use alterMIME. alterMIME is a tool that can automatically add a disclaimer to emails. In this article I will explain how to install it as a Postfix filter on Debian Squeeze.

You can find the document here:
-------------------------------
http://www.howtoforge.com/how-to-automatically-add-a-disclaimer-to-outgoing-emails-with-altermime-postfix-on-debian-squeeze




Distributed Storage Across Four Storage Nodes With GlusterFS 3.2.x On CentOS 6.3
================================================================================

This tutorial shows how to combine four single storage servers (running CentOS 6.3) to one large storage server (distributed storage) with GlusterFS. The client system (CentOS 6.3 as well) will be able to access the storage as if it was a local filesystem. GlusterFS is a clustered file-system capable of scaling to several peta-bytes. It aggregates various storage bricks over Infiniband RDMA or TCP/IP interconnect into one large parallel network file system. Storage bricks can be made of any commodity hardware such as x86_64 servers with SATA-II RAID and Infiniband HBA.

You can find the document here:
-------------------------------
http://www.howtoforge.com/distributed-storage-across-four-storage-nodes-with-glusterfs-3.2.x-on-centos-6.3


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

You can now support HowtoForge by becoming a subscriber:

HowtoForge Subscription
=======================

*** New! We now accept RBS WorldPay payments in addition to PayPal. ***

For a monthly fee of 5 EUR or 25 EUR for half a year, you can become a HowtoForge supporter and help us cover our costs (servers, bandwidth, etc.) and support ISPConfig development. In return, you receive the following benefits:

1. Download the ISPConfig 3 Manual (from http://www.howtoforge.com/download-the-ispconfig-3-manual).
2. Access the whole HowtoForge web site without any ads.
3. Download the results of our tutorials as VMware images (where available) (a list of downloadable VMware images is available here: http://www.howtoforge.com/list-of-downloadable-vmware-images).
4. Download our tutorials as PDF files.
5. View our tutorials as printer-friendly pages.
6. You will be marked as a "HowtoForge Supporter" in your forum posts.
7. Plus, you support the ISPConfig development.

If you have the free VMware Server or Player installed, you can import our VMware images and start playing around with the results of our tutorials immediately. It's a great way to track down problems with your own setup or simply to save time. ;-)

More details can be found on http://www.howtoforge.com/subscription.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Best Regards,

Your HowtoForge Team
Email: info@howtoforge.com
URL: http://www.howtoforge.com

To unsubscribe or update your records, click here: http://newsletter.howtoforge.com/howtoforge/user/update.php?email=matrixunix.ubuntu@blogger.com&code=d8531959c7da2982ec3a7f8f82a13961

Wednesday, January 16, 2013

TechSource: Biggest Apple Blunders that Made Android Shine

TechSource: Biggest Apple Blunders that Made Android Shine


Biggest Apple Blunders that Made Android Shine

Posted: 15 Jan 2013 06:50 PM PST

The Apple vs. Google skirmish has been hailed as the biggest battle in the tech industry. Even Eric Schmidt agrees that this is the ultimate fight the search giant is involved with. The war that began when Steve Jobs was the CEO of Apple has grown to become a never-ending race to a finish line that is nowhere to be seen. Both companies are constantly trying to come up with products that are better and smarter than the other. And, in that attempt, both have made some mistakes that negatively impact their dominance. While Android's errors have cost them a lot of money, Apple's mistakes have cost them a big chunk of market share, which once, it vaunted to its loyal consumers. 

Apple is a company that is considered to be a paragon when it comes to making quality products. Their design and their philosophy both reflect the meticulous attention its employees have paid in crafting each and every product. Whatever comes out of Cupertino, is usually considered as a benchmark in consumer satisfaction. That said, high pressure to compete with soaring tech giants like Google has forced the company to make some hasty and regretful decisions. Also, they have made terrible blunders thanks to their trademark obstinacy. Not only have these errors shook Apple's reputation, they have also given Android a chance to shine. With every mistake that Apple makes, Android is getting more and more popular. 

Let's take a look at some of the blunders that Apple has made in the past and how they have worked in Android's advantage. 


Being Too Closed

One of the best things about Android is its openness. Developers can make any apps they want and sell them directly in the Google Play Store. Apple on the other hand, likes to play it safe by carefully auditioning each and every app before it is sold in the Apple store. Not only has this irked many developers, this has also shifted their focus on the Android platform. Selling their apps on Android is much easier for them than doing so in the Apple ecosystem. Earlier, iPhone users used to boast about the number of apps they have in their app store; however, as more and more developers flocked to Android, it became irrelevant. 


Apple Maps

Apple Maps is perhaps the biggest blunder Apple has made in the recent years. The low-quality, unfinished, and bug-ridden application that came with Apple's latest update caused a great deal of trouble to its users. This was even more problematic as, at the time of the release of the crappy Apple Maps, Google Maps is not yet available on the iOS app store. This blunder has caused a lot of problems for Apple and its customers. In fact, Australian police have discouraged the use of Apple Maps citing it as risky for day-to-day usage. 


High Price

Apple is known for its high-priced devices. iPhone and iPad are no exceptions there. In the tough economy consumers want something that's cost effective and has a good quality. Android, thanks to its reasonable pricing, ticks all the checkboxes for many consumers. While the iPhone stays as a product for the upper class users, Android has managed to easily penetrate the market on both sides of the spectrum.  


Lack of Choices in Terms of Hardware

If you go for an iPhone or an iPad, there is not much to choose from in terms of hardware. You have to stick with whatever Apple makes. Well, we all know that Apple always makes high-quality hardware; however, we all have our individual tastes and preferences. Android is a platform that lets you choose your own device. Whether you want a 7-inch tablet or an Android-powered watch, you can choose whatever Android device you want. 


Lack of NFC Support

One of the biggest disappointments when the latest iPhone was released was the lack of NFC support. Although NFC isn't a technology that has become uber popular just yet, having it on the iPhone would have brought it head-to-head with many other Android devices that come loaded with NFC support. In fact, Google Wallet relies heavily on NFC thus bringing cardless payments to the masses. 


Written by: Abhishek, a regular TechSource contributor and a long-time FOSS advocate.

Monday, January 14, 2013

TechSource: Best Movie Collection Managers For Linux

TechSource: Best Movie Collection Managers For Linux


Best Movie Collection Managers For Linux

Posted: 13 Jan 2013 06:56 PM PST

If you are a movie buff you must own tons of movies, old and new. I own a lot of movies myself, some of them are on my computer and others are in my cupboard. While I love bragging about my huge collection of classics and blockbusters, one of the most tedious things I come across is the act of organizing. Call me lazy but organizing movies, especially if they're stored on your computer, seems like a herculean task for me. Lots of people crave that iTunes-esque automatic sorting of movies wherein you have all the information about the movies you own. Too bad, we're all FOSS fanboys here and as always we are not short of workarounds.

Personally, I love to have all my metadata intact be it music or photos. That's why I prefer using the collection managers that come with media players like Amarok for fetching metadata. For movies, though, you don't have many collection managers to boast of. On Linux, the choices are quite limited. There are barely any good movie collection managers on our favorite platform; however, some of them are quite good. Here's a list of the best ones in the genre:


Tellico

Tellico is a KDE-based collection manager for Linux. Not only does Tellico manage your movies, it also lets you organize your books, comic books, bibliographies, videos, coins, stamps, trading cards, wines, and more. Furthermore, you can create a custom collection of pretty much anything. Yes, anything includes Pokémons too.

Tellico stores the data in XML format. It can import data stored in CSV, RIS, BibTeX, and BibTeXML files and export data as CSV, HTML, BibTeX, BibTeXML, and PilotDB. Moreover, it can also fetch data online from Amazon, IMDB, CDDB, and other services. The simplicity and the versatility of the app make it a useful tool especially if you are running your own little library. The software is open source and can be freely downloaded from the project's website. 



Griffith

Griffith is a GTK-based media collection manager for Linux. This open-source application, once installed, lets you fetch film information from various online services like Allocine, IMDB, 7arte and more. You can also import data from CSV files. The stored data can then be integrated with a database and can be exported to CSV, PDF, XML or HTML files.

One of the best features of Griffith is that it lets you keep track of movies you've given out on loan. You can also sort or filter your library based on your preferences.



GCstar

GCstar is an open-source application for managing collection. The free software fetches each item from the Internet and lets you catalog your collections. Be it movies, games, comic books or pretty much anything, GCstar lets you store, organize, and search your collection easily.

The application is a replacement for GCfilms, a pure movie collection manager that is no longer being developed. GCstar replaced the app letting users manage pretty much everything including movies.


vMovieDB

vMovieDB is an open-source movie collection manager for Linux. It can manage various information about a particular movie such as title, year, media type, quality, subtitles, location, genre and movie image. You can see the movie rating, the movie tags, the movie comments, and more using this app. Finding information about a movie is even easier, thanks to the built-in IMDB search support. Once you are done choosing the movie, you can open it right from the application by selecting your favorite movie player.



XBMC

XBMC can also be used as a movie library manager. It intelligently fetches data about your local movies from the Internet and makes your favorite flicks easy to find. Not only does it bring all your movies together at one place, it also helps you sort them using genres, actors and more. Apart from being a good movie manager, XBMC serves as a perfect media center. It can play music, look up the weather, show a slideshow of photos, and much more. It is really worth a try even if you don't find it that great a movie manager.



Written by: Abhishek, a regular TechSource contributor and a long-time FOSS advocate.

Friday, January 11, 2013

TechSource: Good-looking Android Tablet Apps Worth Downloading

TechSource: Good-looking Android Tablet Apps Worth Downloading


Good-looking Android Tablet Apps Worth Downloading

Posted: 11 Jan 2013 01:25 AM PST

The blooming Android tablet scenario has managed to turn many heads. With the launch of the Nexus 7 and the Nexus 10, Google is taking this market as seriously as Apple does. Though the iPad is still the king of the castle, the Droids are rising slowly against the Cupertino monopoly. What makes Nexus tablets so special is that they offer the same amount of value as the iPad does. The very fact that these tablets come loaded with the latest operating system and apps make them even more competitive. Features like Google Now, panoramic camera, excellent graphics and more put Android tablets head-to-head against Apple's iPads and Kindle Fire HD.

That said, when compared to iPad, Google's slick new tablets fall short in the apps department. On Apple's iTunes store, you'll find a huge amount of apps that are specially designed for the iPad; however, on the Play Store, you'll find very few apps that fit well with the tablet form factor. Don't worry though. If you have just bought a new Android tablet, we won't let you be disappointed. We have a list of some of the best and good-looking Android apps out there that are specially designed for tablets.


Chameleon Launcher

Chameleon Launcher is a launcher that is specially designed for tablets. Providing users with a context-specific user interface, the application gives you an interactive home screen that puts your favorite activities in the forefront. The app also lets you create context rules based on your GPS locations, Wi-Fi connectivity, and more. Overall, the app gives your tablet a more interactive feel.



Evernote

One of the most revered productivity services also works great on tablets. Evernote, once installed, lets you collect information about almost everything then store and organize them on the cloud. Fans of the service store most of their life's important documents on it making it an indispensable part of the productivity toolset.



Flipboard

Flipboard is an amazing social magazine that lets you 'flip' through the latest news. Intelligently gathering the latest scoop from various sources including your social media feeds, the free app keeps you hooked with all the information you need. The app has been rated very highly by iOS and Android users alike, making it one of the most popular apps out there.



Google Currents

Google Currents is Google's answer to Flipboard. The app lets you browse news and other content in a stylish-yet-personal UI. The best part about this app is that it integrates tightly with your Google account thus letting you keep your reading history and bookmarks on the cloud. Apart from letting you browse and buy magazines, Google Currents also helps you keep track of the latest trends and breaking news.

Google Currents, when compared to other magazine apps, stands out due to its adaptability towards all sizes of devices. So, even if you're using a Nexus 7 or a Nexus 10, Google Currents will work perfectly with either of these devices. And yeah, it's totally free!




Drawing Pad

Drawing Pad lets you create your own masterpiece using crayons, colored pencils, roller pens and more. One of the best drawing apps out there, Drawing Pad works perfectly well with a tablet and is incredibly simple to use. Doesn't matter if you're bad at drawing, this app will let you express your creativity and share it with friends on favorite social networks. 



News360

This tablet edition of the popular News360 app lets you browse the latest news in a clean tiled interface. News360, once installed, can be personalized and then can be synchronized with the cloud. Picking up news from more than 30,000 sources, News360 serves as a great alternative to the almost-obsolete newspaper. 



Thursday, January 10, 2013

[HowtoForge] Newsletter 01/10/2013

HowtoForge Newsletter 01/10/2013
================================

*** Version 1.3 of the ISPConfig 3 Manual ***
=============================================

The next update of the ISPConfig 3 Manual is available in PDF format (version 1.3 for ISPConfig >= 3.0.4; Date: 10/25/2011).

Version 1.3 for ISPConfig >= 3.0.4 (Date: 10/25/2011)
Author: Falko Timme
333 pages

The manual can be downloaded from these two links:

http://www.ispconfig.org/ispconfig-3/ispconfig-3-manual/
http://www.howtoforge.com/download-the-ispconfig-3-manual


*********************************************
*********************************************


ISPConfig Monitor App for Android Phones
========================================

With the ISPConfig Monitor App, you can check your server status and find out if all services are running as expected. You can check TCP and UDP ports and ping your servers. In addition to that you can use this app to request details from servers that have ISPConfig installed; these details include everything you know from the Monitor module in the ISPConfig Control Panel (e.g. services, mail and system logs, mail queue, CPU and memory info, disk usage, quota, OS details, RKHunter log, etc.).

Download/Usage
==============

For download and usage instructions, please visit http://www.ispconfig.org/ispconfig-3/ispconfig-monitor-app-for-android/ .


*********************************************
********************************************


*** HowtoForge Now Has Its own Facebook Page ***
================================================

We at HowtoForge are proud to announce that our new Facebook page is now available under http://www.facebook.com/howtoforge. As most of you probably have a Facebook account, we want to use this additional channel to post updates and get feedback from you. Therefore we would like you to "Like" our page, share it with your friends, post comments, etc.

http://www.facebook.com/howtoforge
********************************************************************


New HOWTOs:
===========

* High-Availability Storage With GlusterFS 3.2.x On CentOS 6.3 - Automatic File Replication (Mirror) Across Two Storage Servers
* Options For User Auditing On Linux Platforms
* Install Openldap From Source And Configure Multi-Master Replication
* Using The btrfs Filesystem (With RAID1) With Ubuntu 12.10 On A Hetzner Server
* Configure Monit To Send SMS Instead Of Email
* Distributed Replicated Storage Across Four Storage Nodes With GlusterFS 3.2.x On CentOS 6.3
* Installing Adito/OpenVPN-ALS On CentOS
* How To Install Percona Server 5.5 On Ubuntu 12.10
* Set Up Rsnapshot, Archiving Of Snapshots And Backup Of MySQL Databases On Debian

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

High-Availability Storage With GlusterFS 3.2.x On CentOS 6.3 - Automatic File Replication (Mirror) Across Two Storage Servers
=============================================================================================================================

This tutorial shows how to set up a high-availability storage with two storage servers (CentOS 6.3) that use GlusterFS. Each storage server will be a mirror of the other storage server, and files will be replicated automatically across both storage servers. The client system (CentOS 6.3 as well) will be able to access the storage as if it was a local filesystem. GlusterFS is a clustered file-system capable of scaling to several peta-bytes. It aggregates various storage bricks over Infiniband RDMA or TCP/IP interconnect into one large parallel network file system. Storage bricks can be made of any commodity hardware such as x86_64 servers with SATA-II RAID and Infiniband HBA.

You can find the document here:
-------------------------------
http://www.howtoforge.com/high-availability-storage-with-glusterfs-3.2.x-on-centos-6.3-automatic-file-replication-mirror-across-two-storage-servers




Options For User Auditing On Linux Platforms
============================================

A variety of methods exist for auditing user activity in UNIX and Linux environments. Some of them come preinstalled within common distributions, some can be downloaded as freeware, and some are commercially available products. Here are some of the most popular methods for auditing. Each method is described, along with tips for how to make the best use of each method. In addition, guidance is provided to show what type of auditing each method is best suited for.

You can find the document here:
-------------------------------
http://www.howtoforge.com/options-for-user-auditing-on-linux-platforms




Install Openldap From Source And Configure Multi-Master Replication
===================================================================

Going forward to my previous document on setting up a Qmail Server with Openldap, I am now sharing a doc on how we can set up an Openldap in multi-master replication mode. So If you want more than one ldap-server for redundancy here we go.

You can find the document here:
-------------------------------
http://www.howtoforge.com/install-openldap-from-source-and-configure-multi-master-replication




Using The btrfs Filesystem (With RAID1) With Ubuntu 12.10 On A Hetzner Server
=============================================================================

This tutorial shows how to install Ubuntu 12.10 on the btrfs filesystem (with RAID1) on a Hetzner server with two hard drives. While Hetzner's installimage tool doesn't list btrfs as a supported filesystem and only supports software RAID with /dev/md devices, it is still possible to achieve this setup and use the built-in RAID support in btrfs instead of using /dev/md devices.

You can find the document here:
-------------------------------
http://www.howtoforge.com/using-the-btrfs-filesystem-with-raid1-with-ubuntu-12.10-on-a-hetzner-server




Configure Monit To Send SMS Instead Of Email
============================================

This tutorial helps you configure monit to send alert messages using SMS to your mobile phone when a service fails instead of traditional email notification. Because monit can send only emails but not SMS, we will use an email-to-sms gateway where monit will send its emails to, and the email-to-sms gateway will convert the emails to SMS messages.

You can find the document here:
-------------------------------
http://www.howtoforge.com/configure-monit-to-send-sms-instead-of-email




Distributed Replicated Storage Across Four Storage Nodes With GlusterFS 3.2.x On CentOS 6.3
===========================================================================================

This tutorial shows how to combine four single storage servers (running CentOS 6.3) to a distributed replicated storage with GlusterFS. Nodes 1 and 2 (replication1) as well as 3 and 4 (replication2) will mirror each other, and replication1 and replication2 will be combined to one larger storage server (distribution). Basically, this is RAID10 over network. If you lose one server from replication1 and one from replication2, the distributed volume continues to work. The client system (CentOS 6.3 as well) will be able to access the storage as if it was a local filesystem. GlusterFS is a clustered file-system capable of scaling to several peta-bytes. It aggregates various storage bricks over Infiniband RDMA or TCP/IP interconnect into one large parallel network file system. Storage bricks can be made of any commodity hardware such as x86_64 servers with SATA-II RAID and Infiniband HBA.

You can find the document here:
-------------------------------
http://www.howtoforge.com/distributed-replicated-storage-across-four-storage-nodes-with-glusterfs-3.2.x-on-centos-6.3




Installing Adito/OpenVPN-ALS On CentOS
======================================

OpenVPN-ALS, formerly known as Adito, is not to be confused with OpenVPN. They both brilliant tools that work in completely different things, but in a similar way. Confused? Excellent… OpenVPN-ALS (from now on known as Adito, because I find it less confusing) is a browser based SSL VPN that enables you to acess resources on your own network, even if you are behind a restrictive proxy and/or firewall.

You can find the document here:
-------------------------------
http://www.howtoforge.com/installing-adito-openvpn-als-on-centos




How To Install Percona Server 5.5 On Ubuntu 12.10
=================================================

Percona Server is a drop-in replacement for MySQL. It offers more performance and scalability than the default MySQL server coming with your Linux distribution, while it uses the same init scripts and command line tools which makes it easy to use. This tutorial explains how to install Percona Server 5.5 on Ubuntu 12.10.

You can find the document here:
-------------------------------
http://www.howtoforge.com/how-to-install-percona-server-5.5-on-ubuntu-12.10




Set Up Rsnapshot, Archiving Of Snapshots And Backup Of MySQL Databases On Debian
================================================================================

This howto will show you how to install and set up Rsnapshot, enable archiving of snapshots and how to back up MySQL databases on Debian.

You can find the document here:
-------------------------------
http://www.howtoforge.com/set-up-rsnapshot-archiving-of-snapshots-and-backup-of-mysql-databases-on-debian


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

You can now support HowtoForge by becoming a subscriber:

HowtoForge Subscription
=======================

*** New! We now accept RBS WorldPay payments in addition to PayPal. ***

For a monthly fee of 5 EUR or 25 EUR for half a year, you can become a HowtoForge supporter and help us cover our costs (servers, bandwidth, etc.) and support ISPConfig development. In return, you receive the following benefits:

1. Download the ISPConfig 3 Manual (from http://www.howtoforge.com/download-the-ispconfig-3-manual).
2. Access the whole HowtoForge web site without any ads.
3. Download the results of our tutorials as VMware images (where available) (a list of downloadable VMware images is available here: http://www.howtoforge.com/list-of-downloadable-vmware-images).
4. Download our tutorials as PDF files.
5. View our tutorials as printer-friendly pages.
6. You will be marked as a "HowtoForge Supporter" in your forum posts.
7. Plus, you support the ISPConfig development.

If you have the free VMware Server or Player installed, you can import our VMware images and start playing around with the results of our tutorials immediately. It's a great way to track down problems with your own setup or simply to save time. ;-)

More details can be found on http://www.howtoforge.com/subscription.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Best Regards,

Your HowtoForge Team
Email: info@howtoforge.com
URL: http://www.howtoforge.com

To unsubscribe or update your records, click here: http://newsletter.howtoforge.com/howtoforge/user/update.php?email=matrixunix.ubuntu@blogger.com&code=d8531959c7da2982ec3a7f8f82a13961

Wednesday, January 9, 2013

TechSource: How to Secure a MySQL Installation

TechSource: How to Secure a MySQL Installation


How to Secure a MySQL Installation

Posted: 08 Jan 2013 06:28 PM PST

MySQL is the world's most popular database management system and it is being used in many projects. Be it a simple media player or a huge server that logs thousands of users, this open-source database is known for its stability and performance. MySQL was named after co-founder Michael Widenius' daughter, My and as for the SQL part, the phrase stands for Structured Query Language. If you are using MySQL on a server, it is highly important that you secured the installation in order to avoid any loopholes. If left unsecured, an intruder might hack into the database causing havoc to the stored data.


To get started, simply login to your MySQL installation using the following command:

mysql -u root -p

Enter the password (Press enter if the root password is blank).


Step 1: Removing test databases


MySQL, when installed by default, comes with sample databases for testing purposes. Keeping them might pose a security risk, and hence we need to remove them. Enter the following commands to do that:

mysql> drop database test;
mysql> use mysql;
mysql> delete from db;
mysql> delete from user where not (host="localhost" and user="root");
mysql> flush privileges;

This will remove all other databases that are not root.


Step 2: Set a strong root password (Root password is empty by default)


Usually, MySQL password for root is empty by default. This is a huge security flaw. In order to set a root password, issue the following commands in the MySQL prompt:

mysql> UPDATE mysql.user SET Password = PASSWORD('astrongpassword')
                                ->        WHERE User = 'root';
mysql> FLUSH PRIVILEGES;

This will set a password to the root account. Do make sure you remember it well.


Step 3: Disable remote access to MySQL


We need to disable access to 3306 port, to which MySQL listens to. This is to avoid any remote attacks to the server. To do that, simply locate your my.cnf file. The configuration file is usually located in either of the following paths:

/etc/my.cnf
/etc/mysql/my.cnf
~/.my.cnf

Open the file and add the following line to the section that says [mysqld]: 

skip-networking

You can still remotely access the database using ssh, so don't worry about it.


Additional security tips:

 
Set a strong root password: I cannot emphasize this enough. Setting a root password isn't everything. You need a password that is hard to decipher. Try generating a random password from the command line with the following code:

$ date | md5sum


Don't use MySQL as root: Create a separate user and then use it to test, modify and add databases. Avoid logging in as root as much as possible.


Lockdown the data directory: Change the permission of the directory where database is stored so that only selected users can access it. You can do that using chown and chmod commands.


Periodically backup MySQL data: Even though the server might be relatively immune to attacks, it's still a good idea to backup your databases. You can use the mysqldump command to do that.

Here's a sample of the command in action:

mysql --u [username] --password=[password] [database name] < [dump file]


Written by: Abhishek, a regular TechSource contributor and a long-time FOSS advocate.