How to Install and Configure Apache log analizer, AWstats on Fedora 16

In this post, i will share the quick steps to install and Configure Apache log analizer, AWstats on Fedora 16 linux server. AWStats is an open source and featureful Web analytics reporting tool and server logfile analyzer, that suitable for analyzing data from Internet services such as web, streaming media, mail and FTP servers that shows you the statistics including visits, unique visitors, pages, hits, rush hours, os, browsers, search engines, keywords, robots visits, broken links and more.

AWstats Features :

  • Apache log file analyzer
  • Mail log file analyzer
  • FTP log file analyzer
  • Html static or dynamic reporting
  • Can process splitted log file for clusters
  • High speed
  • High log format size
  • Can be enhanced by plugins

To install AWstats, simply run the following command :

 
[root@fedora16 ~]# yum install awstats -y

Example :

[root@fedora16 ~]# yum install awstats -y
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package awstats.noarch 0:7.0-6.fc16 will be installed
--> Processing Dependency: perl(Switch) for package: awstats-7.0-6.fc16.noarch
--> Processing Dependency: perl(LWP::UserAgent) for package: awstats-7.0-6.fc16.noarch
--> Running transaction check
---> Package perl-Switch.noarch 0:2.16-1.fc16 will be installed
---> Package perl-libwww-perl.noarch 0:6.02-3.fc16 will be installed
--> Processing Dependency: perl(HTTP::Cookies) >= 6 for package: perl-libwww-perl-6.02-3.fc16.noarch
--> Processing Dependency: perl(File::Listing) >= 6 for package: perl-libwww-perl-6.02-3.fc16.noarch
--> Processing Dependency: perl(HTTP::Daemon) >= 6 for package: perl-libwww-perl-6.02-3.fc16.noarch
--> Processing Dependency: perl(WWW::RobotRules) >= 6 for package: perl-libwww-perl-6.02-3.fc16.noarch
--> Processing Dependency: perl(HTTP::Negotiate) >= 6 for package: perl-libwww-perl-6.02-3.fc16.noarch
--> Running transaction check
---> Package perl-File-Listing.noarch 0:6.02-3.fc16 will be installed
---> Package perl-HTTP-Cookies.noarch 0:6.00-3.fc16 will be installed
---> Package perl-HTTP-Daemon.noarch 0:6.00-3.fc16 will be installed
---> Package perl-HTTP-Negotiate.noarch 0:6.00-3.fc16 will be installed
---> Package perl-WWW-RobotRules.noarch 0:6.01-3.fc16 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================
 Package                     Arch           Version               Repository                   Size
====================================================================================================
Installing:
 awstats                     noarch         7.0-6.fc16            updates                     1.1 M
Installing for dependencies:
 perl-File-Listing           noarch         6.02-3.fc16           Fedora16-Repository          11 k
 perl-HTTP-Cookies           noarch         6.00-3.fc16           Fedora16-Repository          25 k
 perl-HTTP-Daemon            noarch         6.00-3.fc16           Fedora16-Repository          19 k
 perl-HTTP-Negotiate         noarch         6.00-3.fc16           Fedora16-Repository          16 k
 perl-Switch                 noarch         2.16-1.fc16           fedora                       21 k
 perl-WWW-RobotRules         noarch         6.01-3.fc16           Fedora16-Repository          17 k
 perl-libwww-perl            noarch         6.02-3.fc16           Fedora16-Repository         199 k

Transaction Summary
====================================================================================================
Install       8 Packages

Total download size: 1.4 M
Installed size: 4.1 M
Downloading Packages:
(1/8): awstats-7.0-6.fc16.noarch.rpm                                         | 1.1 MB     00:32
(6/8): perl-Switch-2.16-1.fc16.noarch.rpm                                    |  21 kB     00:00
----------------------------------------------------------------------------------------------------
Total                                                                38 kB/s | 1.4 MB     00:39
Running Transaction Check
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Installing : perl-HTTP-Negotiate-6.00-3.fc16.noarch                                           1/8
  Installing : perl-HTTP-Daemon-6.00-3.fc16.noarch                                              2/8
  Installing : perl-HTTP-Cookies-6.00-3.fc16.noarch                                             3/8
  Installing : perl-File-Listing-6.02-3.fc16.noarch                                             4/8
  Installing : perl-WWW-RobotRules-6.01-3.fc16.noarch                                           5/8
  Installing : perl-libwww-perl-6.02-3.fc16.noarch                                              6/8
  Installing : perl-Switch-2.16-1.fc16.noarch                                                   7/8
  Installing : awstats-7.0-6.fc16.noarch                                                        8/8

Installed:
  awstats.noarch 0:7.0-6.fc16

Dependency Installed:
  perl-File-Listing.noarch 0:6.02-3.fc16          perl-HTTP-Cookies.noarch 0:6.00-3.fc16
  perl-HTTP-Daemon.noarch 0:6.00-3.fc16           perl-HTTP-Negotiate.noarch 0:6.00-3.fc16
  perl-Switch.noarch 0:2.16-1.fc16                perl-WWW-RobotRules.noarch 0:6.01-3.fc16
  perl-libwww-perl.noarch 0:6.02-3.fc16

Complete!

Change the awstats virtualhost configuration file for fedora16.ehowstuff.local

[root@fedora16 ~]# vi /etc/awstats/awstats.fedora16.ehowstuff.local.conf

Modify at line 122 for log format in httpd.conf is ‘combined’ Set here ‘1’ and line 168 to set IP address to exclude :

..
..
LogFormat=1
..
..
..
HostAliases="localhost 127.0.0.1 REGEX[fedora16\.ehowstuff\.local$] REGEX[^192\.168\.1\.]"
..
..

Modify awstat main configuration file, awstats.conf :

 
[root@fedora16 ~]# vi /etc/httpd/conf.d/awstats.conf

Add Alias “Alias /report “/usr/share/awstats/wwwroot/”” and “Allow 192.168.1.0/24” :

Alias /awstatsclasses "/usr/share/awstats/wwwroot/classes/"
Alias /awstatscss "/usr/share/awstats/wwwroot/css/"
Alias /awstatsicons "/usr/share/awstats/wwwroot/icon/"
ScriptAlias /awstats/ "/usr/share/awstats/wwwroot/cgi-bin/"
Alias /report "/usr/share/awstats/wwwroot/"

#
# This is to permit URL access to scripts/files in AWStats directory.
#

    Options None
    AllowOverride None
    Order allow,deny
    Allow from 127.0.0.1 192.168.1.0/24

# Additional Perl modules

    SetEnv PERL5LIB /usr/share/awstats/lib:/usr/share/awstats/plugins

Restart the Apache httpd service :

[root@fedora16 ~]# systemctl restart httpd.service

Generate reports

[root@fedora16 ~]# /usr/share/awstats/wwwroot/cgi-bin/awstats.pl -config=fedora16.ehowstuff.local -update

Output :

Create/Update database for config "/etc/awstats/awstats.fedora16.ehowstuff.local.conf" by AWStats version 7.0 (build 1.971)
From data in log file "/var/log/httpd/access_log"...
Phase 1 : First bypass old records, searching new record...
Searching new records from beginning of log file...
Jumped lines in file: 0
Parsed lines in file: 0
 Found 0 dropped records,
 Found 0 comments,
 Found 0 blank records,
 Found 0 corrupted records,
 Found 0 old records,
 Found 0 new qualified records.

Generate HTML from reports :

[root@fedora16 ~]# /usr/share/awstats/wwwroot/cgi-bin/awstats.pl -config=fedora16.ehowstuff.local -output -staticlink > /usr/share/awstats/wwwroot/index.html

Change cron’s setting :

[root@fedora16 ~]# vi /etc/cron.hourly/awstats
#!/bin/bash
exec /usr/share/awstats/tools/awstats_updateall.pl now         -configdir="/etc/awstats"         -awstatsprog="/usr/share/awstats/wwwroot/cgi-bin/awstats.pl" >/dev/null
exit 0

Change to the following. Uncomment and add the following lines. The new cron’ setting should as below :

#!/bin/bash
#exec /usr/share/awstats/tools/awstats_updateall.pl now         -configdir="/etc/awstats"         -awstatsprog="/usr/share/awstats/wwwroot/cgi-bin/awstats.pl" >/dev/null
/usr/share/awstats/wwwroot/cgi-bin/awstats.pl -config=fedora16.ehowstuff.local -update > /dev/null
/usr/share/awstats/wwwroot/cgi-bin/awstats.pl -config=fedora16.ehowstuff.local -output -staticlink > /usr/share/awstats/wwwroot/index.html
exit 0

How to Install WordPress Blog on Fedora 16

In this post, i will share with you on how to install WordPress blog on Fedora 16 server. WordPress is an open-source blogging platform. It’s a free blogging tool and content management system (CMS) based on PHP and MySQL. Follow this howto guides to install the WordPress on Fedora 16. This post assumed that apache and mysql has been setup on this server. If not, proceed to the following Apache and MySQL installation howto :

1. Login as a root and download latest wordpress file :

[root@fedora16 ~]# wget http://wordpress.org/latest.tar.gz

Enter documentroot “/var/www/html”

[root@fedora16 ~]# cd /var/www/html
[root@fedora16 blog]# pwd
/var/www/html

2. Extract the lates.tar.gz files to current directory. In this post, i will extract wordpress file into documentroot “/var/www/html” :

[root@fedora16 html]# tar xvzf /root/latest.tar.gz

3. Rename extracted wordpress to blog for easier and better naming :

[root@fedora16 html]# mv wordpress blog

4. Now it’s turn to create wordpress database. Login to your mySQl database ;

[root@fedora16 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.14 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

5. Create Database name “wordpressdb” :

mysql> CREATE DATABASE wordpressdb;
Query OK, 1 row affected (0.07 sec)

6. Create user “wordpressuser” with password “wordpresspassword” :

mysql> CREATE USER 'wordpressuser'@'localhost' IDENTIFIED BY 'wordpresspassword';
Query OK, 0 rows affected (0.00 sec)

7. Grant all privileges to “wordpressdb” to user ” wordpressuser” from localhost access :

mysql> GRANT ALL PRIVILEGES ON wordpressdb.* to wordpressuser@localhost;
Query OK, 0 rows affected (0.00 sec)

8. Check and verify the granted access for user “wordpressuser” :

mysql> SHOW GRANTS FOR 'wordpressuser'@'localhost';
+----------------------------------------------------------------------------------------------------------------------+
| Grants for wordpressuser@localhost                                                                                   |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wordpressuser'@'localhost' IDENTIFIED BY PASSWORD '*E62D3F829F44A91CC231C76347712772B3B9DABC' |
| GRANT ALL PRIVILEGES ON `wordpressdb`.* TO 'wordpressuser'@'localhost'                                               |
+----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>

9. For better security, make wordpress folder readable only from browser :

[root@fedora16 ~]# chmod 755 /var/www/html/blog/

10. Go to your web server terminal or ssh to web server. Copy and rename wp-config-sample.php to wp-config.php:

[root@fedora16 ~]# cp /var/www/html/blog/wp-config-sample.php /var/www/html/blog/wp-config.php

11. Modify the wp-config.php:

[root@fedora16 ~]# vi /var/www/html/blog/wp-config.php

12. Change below line to above:

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'wordpressdb');

/** MySQL database username */
define('DB_USER', 'wordpressuser');

/** MySQL database password */
define('DB_PASSWORD', 'wordpresspassword');

13. To configure wordpress, navigate the browser to http://servername/blog/

wordpress

14. Please complete the form Click “Install WordPress”

Site Title : Blog Title
Username : Prefered username
Password, twice : Your password
Your E-mail : Your Email

wordpress

15. To login, navigate the browser to http://servername/blog/wp-login.php

How to Open the File in Read Only Mode on Linux

Question :
How to open a file on read only mode on linux?

Answer :
This command has been tested on Redhat Enterprise linux 6 (RHEL6) server. To open the file with vim in read only mode on linux, you need to run “vim -R” as below. Vim is enhanced version of vi editor that viewing the text file with coloring. “vim -R” is good command if you want to avoid accidentally deleted any important line as in read only.

Example :

[root@rhel6 ~]# vim -R /etc/passwd

read only mode

How to Stop and Remove Sendmail on Fedora 16

sendmailSendmail is a general purpose internetwork email routing facility that supports many kinds of mail-transfer and -delivery methods, including the Simple Mail Transfer Protocol (SMTP) used for email transport over the Internet. In certain cases, you has to stop and remove the sendmail service on your server. It could be you want to install other smtp service such as postfix. In order to make postfix smoothly running, sendmail should be stop and removed. This post will show you on how to stop and remove sendmail on linux Fedora 16 server.

Command to stop sendmail service :

[root@fedora16 ~]# service sendmail stop
'Redirecting to /bin/systemctl  stop sendmail.service

Simply run this command to remove sendmail package on your server :

[root@fedora16 ~]# yum remove sendmail -y

Examples :

[root@fedora16 ~]# yum remove sendmail
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package sendmail.i686 0:8.14.5-6.fc16 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================
 Package               Arch              Version                     Repository                Size
====================================================================================================
Removing:
 sendmail              i686              8.14.5-6.fc16               @anaconda-0              1.5 M

Transaction Summary
====================================================================================================
Remove        1 Package

Installed size: 1.5 M
Is this ok [y/N]: y
Downloading Packages:
Running Transaction Check
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing    : sendmail-8.14.5-6.fc16.i686                                                      1/1

Removed:
  sendmail.i686 0:8.14.5-6.fc16

Complete!

How to Kill Procees on Fedora 16

In this post i will share on how ot kill the procees on linux fedora 16 server. This post assumed you already installed Fedora 16 and you try to install mysql using yum command. However, you has accidemtly canceled it without proper command. Therefore you are require to kill the procees. Follow this step to kill the process.

Check the process id :

[root@fedora16 ~]# ps -ef | grep yum
root      1715  1167  2 17:21 pts/0    00:00:01 /usr/bin/python /usr/bin/yum install mysql
root      1723  1167  0 17:21 pts/0    00:00:00 grep --color=auto yum

You may find manual for kill command as below :

[root@fedora16 ~]# man kill
NAME
       kill - terminate a process

SYNOPSIS
       kill [-s signal|-p] [-q sigval] [-a] [--] pid...
       kill -l [signal]

As an example, kill process id 1715 :

[root@fedora16 ~]# kill -9 1715

Verify the process whether it’s killed or still running :

[root@fedora16 ~]# ps -ef | grep yum
root      1726  1167  0 17:22 pts/0    00:00:00 grep --color=auto yum
[4]-  Killed                  yum install mysql

How to Configure and Create Apache httpd VirtualHost on Fedora 16

In this post, i will show on how to configure apache httpd and create VirtualHost on linux Fedora 16 server. Assumed that you already install apache httpd server.

1. Modify httpd.conf as below :

[root@fedora16 ~]# vim /etc/httpd/conf/httpd.conf

Update Admin’s address :

ServerAdmin root@fedora16.ehowstuff.local

Uncomment the serverName as below :

ServerName fedora16.ehowstuff.local:80

Add file name that can be access, example : index.php :

DirectoryIndex index.html index.html.var index.php

2. Uncomment NameVirtualHost :

# Use name-based virtual hosting.
#
NameVirtualHost *:80
#

3. Create Virtual host :

<VirtualHost *:80>
    ServerAdmin admin@fedora16.ehowstuff.local
    DocumentRoot /var/www/html/fedora16.ehowstuff.local
    ServerName fedora16.ehowstuff.local
    ErrorLog logs/fedora16.ehowstuff.local-error_log
    CustomLog logs/fedora16.ehowstuff.local-access_log common
</VirtualHost>

4. Create sample index.html file on DocumentRoot of your virtualHost :

[root@fedora16 ~]# vi /var/www/html/fedora16.ehowstuff.local/index.html
<html>
<body>
<div style="width: 100%; font-size: 40px; font-weight: bold; text-align: center;">
Test Page for Fedora.ehowstuff.local
</div>
</body>
</html>

5. Start httpd service :

[root@fedora16 ~]# systemctl restart httpd.service

6. Enable port 80 to go through linux iptables firewall :

[root@fedora16 ~]# vi /etc/sysconfig/iptables

Add this line :

-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT

7. Restart iptables to take effect :

[root@fedora16 ~]# systemctl restart iptables.service

How to Search for Available PHP5 Modules on Fedora 16

PHP: Hypertext Preprocessor is a widely used, free and open-source server-side scripting language that was especially designed for web development to produce dynamic web pages and can be embedded into HTML. PHP applications are commonly found with the filename extensions .php, .php4, or .php5. PHP does not included in Fedora 16 with minimum type of installation. You have to install it manually if you really need it. Before start to install PHP, you can search for available PHP5 modules in the yum repository using the following command :

[root@fedora16 ~]# yum search php

or

[root@fedora16 ~]# yum search php | more
=============================== N/S Matched: php ===============================
cups-php.i686 : Common Unix Printing System - php module
eclipse-phpeclipse.noarch : PHP Eclipse plugin
gphpedit.i686 : A PHP source editor for GNOME 2
graphviz-php.i686 : PHP extension for graphviz
groonga-php.i686 : PHP language binding for groonga
ice-php.i686 : PHP runtime for developping Ice applications
ice-php-devel.i686 : PHP tools for developping Ice applications
kdevelop-php.i686 : Php language plugin for KDevelop
mod_suphp.i686 : An apache2 module for executing PHP scripts with the
               : permissions of their owners
nntpgrab-php.i686 : PHP module which allows PHP scripts to communicate with
                  : NNTPGrab
perl-PHP-Serialization.noarch : Converts between PHP's serialize() output and
                              : the equivalent Perl structure
php.i686 : PHP scripting language for creating dynamic web sites
php-Kohana.noarch : The Swift PHP Framework
php-LightweightPicasaAPI.noarch : A lightweight API for Picasa in PHP
php-PHPMailer.noarch : PHP email transport class with a lot of features
php-Smarty.noarch : Template/Presentation Framework for PHP
php-ZendFramework.noarch : Leading open-source PHP framework
php-ZendFramework-Search-Lucene.noarch : Apache Lucene engine PHP port
php-adodb.noarch : Database abstraction layer for PHP
php-bartlett-PHP-Reflect.noarch : Adds the ability to reverse-engineer PHP
php-bcmath.i686 : A module for PHP applications for using the bcmath library
php-captchaphp.noarch : PHP very user-friendly CAPTCHA solution
php-channel-pdepend.noarch : PHP Depend PEAR channel
php-channel-phpmd.noarch : PHP Mess Detector PEAR channel
php-channel-phpunit.noarch : Adds phpunit channel to PEAR
php-cli.i686 : Command-line interface for PHP
php-common.i686 : Common files for PHP
php-dba.i686 : A database abstraction layer module for PHP applications
php-deepend-Mockery.noarch : Mockery is a simple but flexible PHP mock object
                           : framework
php-devel.i686 : Files needed for building PHP extensions
php-digidoc.i686 : PHP bindings for libdigidocpp
php-doctrine-Doctrine.noarch : PHP Object Relational Mapper
php-domxml-php4-php5.noarch : XML transition from PHP4 domxml to PHP5 dom module
php-eaccelerator.i686 : PHP accelerator, optimizer, encoder and dynamic content
                      : cacher
php-email-address-validation.noarch : A PHP class for validating email addresses
php-embedded.i686 : PHP library for embedding in applications
php-ezc-Database.noarch : A lightweight database layer on top of PHP's PDO
php-ezc-File.noarch : Provides support for file operations which are not covered
                    : by PHP
php-facedetect.i686 : PHP extension to access the OpenCV library
php-fpdf.noarch : PHP class to generate PDF Files
php-fpdf-doc.noarch : Documentation for php-fpdf
php-fpm.i686 : PHP FastCGI Process Manager
php-gd.i686 : A module for PHP applications for using the gd graphics library
php-getid3.noarch : The PHP media file parser
php-gettext.noarch : Gettext emulation in PHP
php-hkit.noarch : Simple PHP5 API for extracting common microformats from a page
php-idn.i686 : PHP API for GNU LibIDN
php-imap.i686 : A module for PHP applications that use IMAP
php-interbase.i686 : A module for PHP applications that use Interbase/Firebird
                   : databases
php-intl.i686 : Internationalization extension for PHP applications
php-laconica.noarch : PHP tool for microblogging
php-layers-menu.noarch : Hierarchical PHP based DHTML menu system
php-ldap.i686 : A module for PHP applications that use LDAP
php-libdmtx.i686 : PHP bindings for libdmtx
php-libguestfs.i686 : PHP bindings for libguestfs
php-libpuzzle.i686 : PHP extension for libpuzzle
php-libvirt.i686 : PHP language binding for Libvirt
php-libvirt-doc.noarch : Document of php-libvirt
php-magickwand.i686 : PHP API for ImageMagick
php-manual-en.noarch : Documentation for the PHP programming language
php-mapi.i686 : The PHP MAPI extension by Zarafa
php-mapserver.i686 : PHP/Mapscript map making extensions to PHP
php-markdown.noarch : Markdown implementation in PHP
php-mbstring.i686 : A module for PHP applications which need multi-byte string
                  : handling
php-mcrypt.i686 : Standard PHP module provides mcrypt library support
php-mssql.i686 : MSSQL database module for PHP
php-mysql.i686 : A module for PHP applications that use MySQL databases
php-mysqlnd.i686 : A module for PHP applications that use MySQL databases
php-nusoap.noarch : SOAP Toolkit for PHP
php-oauth.noarch : PHP Authentication library for desktop to web applications
php-odbc.i686 : A module for PHP applications that use ODBC databases
php-pdb.noarch : PHP classes for manipulating Palm OS databases
php-pdepend-PHP-Depend.noarch : PHP_Depend design quality metrics for PHP
                              : package
php-pdo.i686 : A database access abstraction module for PHP applications
php-pear.noarch : PHP Extension and Application Repository framework
php-pear-Auth.noarch : Authentication provider for PHP
php-pear-Auth-OpenID.noarch : PHP OpenID
php-pear-Auth-radius.noarch : RADIUS support for php-pear-Auth
php-pear-Auth-samba.noarch : Samba support for php-pear-Auth
php-pear-Benchmark.noarch : Framework to benchmark PHP scripts or function calls
php-pear-CAS.noarch : Central Authentication Service client library in php
php-pear-Cache-Lite.noarch : Fast and Safe little cache system for PHP
php-pear-Console-Color.noarch : Easily use ANSI console colours from PHP
                              : applications
php-pear-Event-Dispatcher.noarch : Dispatch notifications using PHP callbacks
php-pear-HTML_Template_PHPLIB.noarch : PHP template system based on preg_*
php-pear-Log.noarch : Abstracted logging facility for PHP
php-pear-Net-Curl.noarch : OO interface to PHP's cURL extension
php-pear-Net-FTP.noarch : Provides an OO interface to the PHP FTP functions plus
                        : some additions
php-pear-Net-IDNA2.noarch : PHP library for punycode encoding and decoding
php-pear-PHP-CodeSniffer.noarch : PHP coding standards enforcement tool
php-pear-PHP-Compat.noarch : Provides missing functionality for older versions
                           : of PHP
php-pear-PhpDocumentor.noarch : The complete documentation solution for PHP
php-pear-PhpDocumentor-docs.noarch : Documentation for PhpDocumentor
php-pear-SOAP.noarch : Simple Object Access Protocol (SOAP) Client/Server for
                     : PHP
php-pear-Services-Twitter.noarch : PHP interface to Twitter's API
php-pear-XML-Parser.noarch : XML parsing class based on PHP's bundled expat
php-pecl-apc.i686 : APC caches and optimizes PHP intermediate code
php-pecl-gearman.i686 : PHP wrapper to libgearman
php-pecl-igbinary.i686 : Replacement for the standard PHP serializer
php-pecl-mailparse.i686 : PHP PECL package for parsing and working with email
                        : messages
php-pecl-mongo.i686 : PHP MongoDB database driver
php-pecl-oauth.i686 : PHP OAuth consumer extension
php-pecl-parsekit.i686 : PHP Opcode Analyser
php-pecl-rrd.i686 : PHP Bindings for rrdtool
php-pecl-selinux.i686 : SELinux binding for PHP scripting language
php-pecl-xdebug.i686 : PECL package for debugging PHP scripts
php-pgsql.i686 : A PostgreSQL database module for PHP
php-php-gettext.noarch : Gettext emulation in PHP
php-phpSmug.noarch : PHP wrapper for the SmugMug API
php-phpmd-PHP-PMD.noarch : PHPMD - PHP Mess Detector
php-phpunit-DbUnit.noarch : DbUnit port for PHP/PHPUnit
php-phpunit-PHP-CodeBrowser.noarch : PHP_CodeBrowser for integration in Hudson
                                   : and CruiseControl
php-phpunit-PHP-CodeCoverage.noarch : PHP code coverage information
php-phpunit-PHP-Timer.noarch : PHP Utility class for timing
php-phpunit-PHP-TokenStream.noarch : Wrapper around PHP tokenizer extension
php-phpunit-PHPUnit.noarch : The PHP Unit Testing framework
php-phpunit-PHPUnit-MockObject.noarch : Mock Object library for PHPUnit
php-phpunit-PHPUnit-Selenium.noarch : Selenium RC integration for PHPUnit
php-phpunit-bytekit.noarch : A command-line tool built on the PHP Bytekit
                           : extension
php-phpunit-phpcpd.noarch : Copy/Paste Detector (CPD) for PHP code
php-phpunit-phpdcd.noarch : Dead Code Detector (DCD) for PHP code
php-phpunit-phploc.noarch : A tool for quickly measuring the size of a PHP
                          : project
php-process.i686 : Modules for PHP script using system process interfaces
php-pspell.i686 : A module for PHP applications for using pspell interfaces
php-recode.i686 : A module for PHP applications for using the recode library
php-redland.i686 : PHP modules for the Redland RDF library
php-shout.i686 : PHP module for communicating with Icecast servers
php-simplepie.noarch : Simple RSS Library in PHP
php-snmp.i686 : A module for PHP applications that query SNMP-managed devices
php-soap.i686 : A module for PHP applications that use the SOAP protocol
php-swift-Swift.noarch : Free Feature-rich PHP Mailer
php-symfony-symfony.noarch : Open-Source PHP Web Framework
php-tidy.i686 : Standard PHP module provides tidy library support
php-voms-admin.noarch : Web based interface to control VOMS parameters written
                      : in PHP
php-xapian.i686 : Files needed for developing PHP scripts which use Xapian
php-xml.i686 : A module for PHP applications which use XML
php-xmlrpc.i686 : A module for PHP applications which use the XML-RPC protocol
php-xmpphp.noarch : XMPPHP is the successor to Class.Jabber.PHP
php-zipstream.noarch : Streaming dynamic zip from PHP without writing to the
                     : disk
phpFlickr.noarch : PHP client for the Flickr web service
phpTodo.noarch : PHP todo list manager
phpdoc.noarch : Command-line utility for PhpDocumentor
phpesp.noarch : PHP-based survey web application
rrdtool-php.i686 : PHP RRDtool bindings
sphinx-php.i686 : PHP API for Sphinx
syck-php.i686 : YAML module for php
uuid-php.i686 : PHP support for Universally Unique Identifier library
zorba-php.i686 : PHP language binding for zorba
bouml.i686 : UML2 tool box for C++, Java, IDL, PHP and Python
entertrack.noarch : Web-based artifact tracking/management system written in PHP
lighttpd-fastcgi.i686 : FastCGI module and spawning helper for lighttpd and PHP
                      : configuration
limph.noarch : A PHP5-compatible network host/service poller with web interface
php-IDNA_Convert.noarch : Provides conversion of internationalized strings to
                        : UTF8
php-ZendFramework-Auth-Adapter-Ldap.noarch : Zend Framework LDAP Authentication
                                           : Adapter
php-ZendFramework-Cache-Backend-Apc.noarch : Zend Framework APC cache backend
php-ZendFramework-Cache-Backend-Memcached.noarch : Zend Framework memcache cache
                                                 : backend
php-ZendFramework-Captcha.noarch : Zend Framework CAPTCHA component
php-ZendFramework-Db-Adapter-Firebird.noarch : Zend Framework database adapter
                                             : for InterBase
php-ZendFramework-Db-Adapter-Mysqli.noarch : Zend Framework database adapter for
                                           : mysqli
php-ZendFramework-Dojo.noarch : Zend Framework Dojo Toolkit integration
                              : component
php-ZendFramework-Feed.noarch : Live syndication feeds helper
php-ZendFramework-Gdata.noarch : Google Data APIs
php-ZendFramework-Ldap.noarch : Basic LDAP operations API
php-ZendFramework-Pdf.noarch : PDF file handling helper
php-ZendFramework-Services.noarch : Web service APIs for a number of providers
php-ZendFramework-Soap.noarch : SOAP web services server part helper
php-ZendFramework-demos.noarch : Demos for the Zend Framework
php-ZendFramework-extras.noarch : Zend Framework Extras (ZendX)
php-bartlett-PHP-CompatInfo.noarch : Find out version and the extensions
                                   : required for a piece of code to run
php-channel-bartlett.noarch : Adds bartlett channel to PEAR
php-channel-deepend.noarch : Survive The Deep End PEAR Channel
php-channel-doctrine.noarch : Adds doctrine project channel to PEAR
php-channel-ezc.noarch : Adds eZ Components channel to PEAR
php-channel-horde.noarch : Adds pear.horde.org channel to PEAR
php-channel-htmlpurifier.noarch : Adds htmlpurifier channel to PEAR
php-channel-pearplex.noarch : Adds the PearPlex channel to PEAR
php-channel-phing.noarch : Adds phing channel to PEAR
php-channel-swift.noarch : Adds swift mailer project channel to PEAR
php-channel-symfony.noarch : Adds symfony project channel to PEAR
php-enchant.i686 : Human Language and Character Encoding Support
php-ezc-Archive.noarch : A component for create, modify, and extract archive
                       : files of various formats
php-ezc-Authentication.noarch : Support for different means of identification
                              : and authentication
php-ezc-AuthenticationDatabaseTiein.noarch : Provides a Database filter for the
                                           : Authentication component
php-ezc-Base.noarch : Provides the basic infrastructure that all packages rely
                    : on
php-ezc-Cache.noarch : Provides a collection of lightweight classes to cache
                     : different kinds of data
php-ezc-Configuration.noarch : A component that allows you to use configuration
                             : files in different formats
php-ezc-ConsoleTools.noarch : A set of classes to do different actions with the
                            : console
php-ezc-DatabaseSchema.noarch : A set of classes that allow you to use
                              : information from a database schema
php-ezc-EventLog.noarch : Allows you to log events or audit trails
php-ezc-EventLogDatabaseTiein.noarch : Contains the database writer backend for
                                     : the EventLog component
php-ezc-Feed.noarch : This component handles parsing and creating RSS1, RSS2 and
                    : ATOM feeds
php-ezc-Graph.noarch : A component for creating pie charts, line graphs and
                     : other kinds of diagrams
php-ezc-Mail.noarch : A component construct and/or parse Mail messages
                    : conforming to the mail standard
php-ezc-PersistentObject.noarch : A component for store an arbitrary data
                                : structures to a fixed database table
php-ezc-PersistentObjectDatabaseSchemaTiein.noarch : Automatic generation of
     ...: PersistentObject from DatabaseSchema definitions
php-ezc-SystemInformation.noarch : Provides access to common system variables
php-ezc-Template.noarch : A fully functional Templating system
php-ezc-Webdav.noarch : Set up and run your own WebDAV server
php-feedcreator.noarch : Create RSS feeds
php-geshi.noarch : Generic syntax highlighter
php-horde-Horde-Exception.noarch : Horde Exception Handler
php-horde-Horde-Nls.noarch : Native Language Support (NLS)
php-horde-Horde-Translation.noarch : Horde translation library
php-horde-Horde-Url.noarch : Horde Url class
php-horde-Horde-Util.noarch : Horde Utility Libraries
php-pear-Auth-RADIUS.noarch : Wrapper Classes for the RADIUS PECL
php-pear-Auth-SASL.noarch : Abstraction of various SASL mechanism responses
php-pear-Auth-Yubico.noarch : Authentication class for verifying Yubico OTP
                            : tokens
php-pear-Auth_HTTP.noarch : Class providing HTTP authentication methods
php-pear-Cache.noarch : Framework for caching of arbitrary data
php-pear-CodeGen.noarch : Framework to create code generators that operate on
                        : XML descriptions
php-pear-CodeGen-PECL.noarch : Tool to generate PECL extensions from an XML
                             : description
php-pear-Console-CommandLine.noarch : A full featured command line options and
                                    : arguments parser
php-pear-Console-Getargs.noarch : Command-line arguments and parameters parser
php-pear-Console-ProgressBar.noarch : This class provides you with an
                                    : easy-to-use interface to progress bars
php-pear-Console-Table.noarch : Class that makes it easy to build console style
                              : tables
php-pear-Crypt-Blowfish.noarch : Quick two-way blowfish encryption
php-pear-Crypt-CHAP.noarch : Class to generate CHAP packets
php-pear-DB.noarch : PEAR: Database Abstraction Layer
php-pear-DB-DataObject.noarch : An SQL Builder, Object Interface to Database
                              : Tables
php-pear-DB-DataObject-FormBuilder.noarch : Automatically build HTML_QuickForm
                                          : objects
php-pear-DB-QueryTool.noarch : An OO-interface for easily retrieving and
                             : modifying data in a DB
php-pear-Date.noarch : Date and Time Zone Classes
php-pear-Date-Holidays.noarch : Driver based class to calculate holidays
php-pear-Date-Holidays-USA.noarch : Driver based class to calculate holidays in
                                  : USA
php-pear-File.noarch : Common file and directory routines
php-pear-File-Bittorrent2.noarch : Decode and Encode data in Bittorrent format
php-pear-File-Find.noarch : Class which facilitates the search of filesystems
php-pear-File-Passwd.noarch : Manipulate many kinds of password files
php-pear-File-SMBPasswd.noarch : Class for managing SAMBA style password files
php-pear-HTML-Common.noarch : Base class for other HTML classes
php-pear-HTML-QuickForm.noarch : Class for creating, validating, processing HTML
                               : forms
php-pear-HTML-QuickForm-ElementGrid.noarch : Meta-element which holds any other
                                           : element in a grid
php-pear-HTML-QuickForm-advmultiselect.noarch : Element for HTML_QuickForm that
                                              : emulate a multi-select
php-pear-HTML-Table.noarch : Class to easily design HTML tables
php-pear-HTML-Template-IT.noarch : Integrated Templates
php-pear-HTML_Javascript.noarch : Class for creating simple JS scripts
php-pear-HTTP.noarch : Miscellaneous HTTP utilities
php-pear-HTTP-Client.noarch : Easy way to perform multiple HTTP requests and
                            : process their results
php-pear-HTTP-OAuth.noarch : Implementation of the OAuth spec
php-pear-HTTP-Request.noarch : Provides an easy way to perform HTTP requests
php-pear-HTTP-Request2.noarch : Provides an easy way to perform HTTP requests
php-pear-HTTP-Upload.noarch : Secure managment of files submitted via HTML Forms
php-pear-Image-Canvas.noarch : Common interface to image drawing
php-pear-Image-Color.noarch : Manage and handles color data and conversions
php-pear-Image-Graph.noarch : Displays numerical data as a graph/chart/plot
php-pear-Image-GraphViz.noarch : Interface to AT&T's GraphViz tools
php-pear-MDB2.noarch : Database Abstraction Layer
php-pear-MDB2-Driver-mysql.noarch : MySQL MDB2 driver
php-pear-MDB2-Driver-mysqli.noarch : MySQL Improved MDB2 driver
php-pear-MDB2-Driver-pgsql.noarch : PostgreSQL MDB2 driver
php-pear-MDB2-Schema.noarch : Database Abstraction Layer
php-pear-Mail.noarch : Class that provides multiple interfaces for sending
                     : emails
php-pear-Mail-Mime.noarch : Classes to create MIME messages
php-pear-Mail-mimeDecode.noarch : Class to decode mime messages
php-pear-Math-Stats.noarch : Classes to calculate statistical parameters
php-pear-Net-DIME.noarch : Implements Direct Internet Message Encapsulation
                         : (DIME)
php-pear-Net-DNS.noarch : Resolver library used to communicate with a DNS server
php-pear-Net-IPv4.noarch : IPv4 network calculations and validation
php-pear-Net-POP3.noarch : Provides a POP3 class to access POP3 server
php-pear-Net-Ping.noarch : Execute ping
php-pear-Net-SMTP.noarch : Provides an implementation of the SMTP protocol
php-pear-Net-Sieve.noarch : Handles talking to a sieve server
php-pear-Net-Socket.noarch : Network Socket Interface
php-pear-Net-Traceroute.noarch : Execute traceroute
php-pear-Net-URL.noarch : Easy parsing of URLs
php-pear-Net-URL-Mapper.noarch : Simple and flexible way to build nice URLs for
                               : web applications
php-pear-Net-URL2.noarch : Class for parsing and handling URL
php-pear-Net-UserAgent-Detect.noarch : Extract information from an HTTP user
                                     : agent
php-pear-Numbers-Roman.noarch : Provides methods for converting to and from
                              : Roman Numerals
php-pear-Numbers-Words.noarch : Methods for spelling numerals in words
php-pear-OLE.noarch : Package for reading and writing OLE containers
php-pear-PEAR-Command-Packaging.noarch : Create RPM spec files from PEAR modules
php-pear-PHP-CompatInfo.noarch : Find out version and extensions required for a
                               : piece of code to run
php-pear-Pager.noarch : Data paging class
php-pear-Payment-Process.noarch : Unified payment processor
php-pear-Services-Weather.noarch : This class acts as an interface to various
                                 : online weather-services
php-pear-Spreadsheet-Excel-Writer.noarch : Package for generating Excel
                                         : spreadsheets
php-pear-Structures-DataGrid.noarch : Tabular structure for converting data
php-pear-Structures-DataGrid-DataSource-Array.noarch : DataSource driver using
                                                     : arrays
php-pear-Structures-DataGrid-DataSource-DataObject.noarch : DataSource driver
     ...: using PEAR::DB_DataObject
php-pear-Structures-DataGrid-DataSource-MDB2.noarch : DataSource driver using
     ...: PEAR::MDB2 and an SQL query
php-pear-Structures-DataGrid-DataSource-RSS.noarch : DataSource driver using RSS
                                                   : files
php-pear-Structures-DataGrid-Renderer-Pager.noarch : Renderer driver using
                                                   : PEAR::Pager
php-pear-Structures-DataGrid-Renderer-Smarty.noarch : Renderer driver using
                                                    : Smarty
php-pear-Text-Diff.noarch : Engine for performing and rendering text diffs
php-pear-Validate.noarch : Validation Class for Various Data Types
php-pear-Validate-Finance-CreditCard.noarch : Validation class for Credit Cards
php-pear-Var-Dump.noarch : Provides methods for dumping structured information
                         : about a variable
php-pear-XML-Beautifier.noarch : Class to format XML documents
php-pear-XML-RPC2.noarch : XML-RPC client/server library
php-pear-XML-RSS.noarch : RSS parser
php-pear-XML-Serializer.noarch : Swiss-army knife for reading and writing XML
                               : files
php-pear-phing.noarch : A project build system based on Apache Ant
php-pecl-apc-devel.i686 : APC developer files (header)
php-pecl-geoip.i686 : Extension to map IP addresses to geographic places
php-pecl-gmagick.i686 : Provides a wrapper to the GraphicsMagick library
php-pecl-igbinary-devel.i686 : Igbinary developer files (header)
php-pecl-imagick.i686 : Provides a wrapper to the ImageMagick library
php-pecl-lzf.i686 : Extension to handle LZF de/compression
php-pecl-memcache.i686 : Extension to work with the Memcached caching daemon
php-pecl-memcached.i686 : Extension to work with the Memcached caching daemon
php-pecl-mysqlnd-ms.i686 : A replication and load balancing plugin for mysqlnd
php-pecl-ncurses.i686 : Terminal screen handling and optimization package
php-pecl-radius.i686 : Radius client library
php-pecl-runkit.i686 : Mangle with user defined functions and classes
php-pecl-solr.i686 : Object oriented API to Apache Solr
php-pecl-sphinx.i686 : PECL extension for Sphinx SQL full-text search engine
php-pecl-ssh2.i686 : Bindings for the libssh2 library
php-pecl-yaml.i686 : Support for YAML 1.1 serialization using the LibYAML
                   : library
php-phpunit-File-Iterator.noarch : FilterIterator implementation that filters
                                 : files based on a list of suffixes
php-phpunit-PHP-Invoker.noarch : Utility class for invoking callables with a
                               : timeout
php-phpunit-PHPUnit-SkeletonGenerator.noarch : Tool that can generate skeleton
                                             : test classes
php-phpunit-Text-Template.noarch : Simple template engine
php-symfony-YAML.noarch : The Symfony YAML Component
phpMyAdmin.noarch : Handle the administration of MySQL over the World Wide Web
phpPgAdmin.noarch : Web-based PostgreSQL administration
phpldapadmin.noarch : Web-based tool for managing LDAP servers
phplogcon.noarch : A syslog data viewer for the web
phpwapmail.noarch : WAP-based e-mail client
squirrelmail.noarch : webmail client written in php
syck.i686 : YAML for C, Python, and PHP
tiquit.noarch : A PHP5-compatible help desk incident tracking/knowledgebase
              : system
toothchart.noarch : A PHP script which graphically shows how a baby's primary
                  : teeth have erupted

  Name and summary matches only, use "search all" for everything.

How to Install PHP on Fedora 16

PHP: Hypertext Preprocessor is a widely used, free and open-source server-side scripting language that was especially designed for web development to produce dynamic web pages and can be embedded into HTML. PHP applications are commonly found with the filename extensions .php, .php4, or .php5. PHP does not included in Fedora 16 with minimum type of installation. You have to install it manually if you really need it. In this post i will show the quick step to install PHP on linux Fedora 16 server. This post assumed that you have set up local yum repository using your DVDROM and had installed minimal installation type Fedora 16.

How to Setup Local Yum Repository from CD-ROM/DVD-ROM image on Fedora 16

Simply run yum command to install PHP. Please note that this will only installed basic php with php-cli and php-common only.

[root@fedora16 ~]# yum install php -y
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php.i686 0:5.3.10-1.fc16 will be installed
--> Processing Dependency: php-common(x86-32) = 5.3.10-1.fc16 for package: php-5.3.10-1.fc16.i686
--> Processing Dependency: php-cli(x86-32) = 5.3.10-1.fc16 for package: php-5.3.10-1.fc16.i686
--> Running transaction check
---> Package php-cli.i686 0:5.3.10-1.fc16 will be installed
--> Processing Dependency: libedit.so.0 for package: php-cli-5.3.10-1.fc16.i686
---> Package php-common.i686 0:5.3.10-1.fc16 will be installed
--> Running transaction check
---> Package libedit.i686 0:3.0-4.20110227cvs.fc16 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================
 Package            Arch         Version                          Repository                   Size
====================================================================================================
Installing:
 php                i686         5.3.10-1.fc16                    updates                     2.3 M
Installing for dependencies:
 libedit            i686         3.0-4.20110227cvs.fc16           Fedora16-Repository          85 k
 php-cli            i686         5.3.10-1.fc16                    updates                     2.2 M
 php-common         i686         5.3.10-1.fc16                    updates                     501 k

Transaction Summary
====================================================================================================
Install       4 Packages

Total download size: 5.1 M
Installed size: 16 M
Downloading Packages:
(2/4): php-5.3.10-1.fc16.i686.rpm                                            | 2.3 MB     00:27
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID a82ba4b7: NOKEY
Public key for php-5.3.10-1.fc16.i686.rpm is not installed
(3/4): php-cli-5.3.10-1.fc16.i686.rpm                                        | 2.2 MB     00:35
(4/4): php-common-5.3.10-1.fc16.i686.rpm                                     | 501 kB     00:06
----------------------------------------------------------------------------------------------------
Total                                                                73 kB/s | 5.1 MB     01:10
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-i386
Importing GPG key 0xA82BA4B7:
 Userid : Fedora (16) 
 Package: fedora-release-16-1.noarch (@anaconda-0)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-i386
Running Transaction Check
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : php-common-5.3.10-1.fc16.i686                                                    1/4
  Installing : libedit-3.0-4.20110227cvs.fc16.i686                                              2/4
  Installing : php-cli-5.3.10-1.fc16.i686                                                       3/4
  Installing : php-5.3.10-1.fc16.i686                                                           4/4

Installed:
  php.i686 0:5.3.10-1.fc16

Dependency Installed:
  libedit.i686 0:3.0-4.20110227cvs.fc16                 php-cli.i686 0:5.3.10-1.fc16
  php-common.i686 0:5.3.10-1.fc16

Complete!

How to Fix “Error: Cannot retrieve repository metadata (repomd.xml) for repository: fedora. Please verify its path and try again” Error When using Local DVD-ROM/CD-ROM Yum Repository on Fedora 16

Question :

I am using Local DVD-ROM/CD-ROM yum Repository on Fedora 16. But when i perform any yum command to install or update or remove the package/module, i get the following error :

Error: Cannot retrieve repository metadata (repomd.xml) for repository: fedora. 
Please verify its path and try again

Answer :
To fix the following error, follow this steps :

1. Create repo.disabled inside /etc/yum.repos.d :

[root@fedora16 ~]# mkdir /etc/yum.repos.d/repo.disabled

By default of minimal installation of Fedora 16 server, there are 3 file in /etc/yum.repos.d as below :

[root@fedora16 ~]# ls /etc/yum.repos.d/
fedora.repo  fedora-updates.repo  fedora-updates-testing.repo  repo.disabled

Note : repos.disabled is the folder that you created in step (1).

2. Then moved all these 3 repo files into “repo.disabled” folder :

[root@fedora16 ~]# mv /etc/yum.repos.d/fedora.repo /etc/yum.repos.d/repo.disabled
[root@fedora16 ~]# mv /etc/yum.repos.d/fedora-updates.repo /etc/yum.repos.d/repo.disabled
[root@fedora16 ~]# mv /etc/yum.repos.d/fedora-updates-testing.repo /etc/yum.repos.d/repo.disabled

3. Create files fedora16.repo under /etc/yum.repos.d and enter the following lines :

[root@fedora16 ~]# vi /etc/yum.repos.d/fedora16.repo

Enter these lines in fedora16.repo :

[Fedora16-Repository]
name=DVD-Fedora16 Repository
baseurl=file:///mnt
enabled=1
gpgcheck=0

Check What file and folder inside /etc/yum.repos.d :

[root@fedora16 ~]# ls -l /etc/yum.repos.d/
total 8
-rw-r--r--. 1 root root   92 Mar 18 00:09 fedora16.repo
drwxr-xr-x. 2 root root 4096 Mar 18 01:27 repo.disabled

4. Run yum clean all to clear up your yum cache directory :

[root@fedora16 ~]# yum clean all
Cleaning repos: Fedora16-Repository
Cleaning up Everything

5. Steps completed. You can start using yum command as usual.

How to Configure MySQL Database Server on Fedora 16

On previous post (Install MySQL) i already shows how to install MySQL server on Fedora 16. MySQL server is a popular choice of database server that can stores and retrieves data for the blog, websites and applications. MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a number of databases. For more information on MySQL, you can visit their website at www.mysql.com. This post will show you how to configure MySQL server on linux Fedora 16 server. This post assumed that you have set up local yum repository using your DVDROM and had installed minimal installation type Fedora 16.

1. How to configure mysql service run at boot on Fedora 16 :
To ensure that the mysql service run automatically at boot, please run this command :

[root@fedora16 ~]# systemctl enable mysqld.service

Example :

[root@fedora16 ~]# systemctl enable mysqld.service
ln -s '/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'

If you run chkconfig command, it will also return the same result as above :

[root@fedora16 ~]# chkconfig --levels 235 mysqld on
Note: Forwarding request to 'systemctl enable mysqld.service'.

or

[root@fedora16 ~]# chkconfig mysqld on
Note: Forwarding request to 'systemctl enable mysqld.service'.

2. How to start mysql service on Fedora 16 :

[root@fedora16 ~]# systemctl start mysqld.service

3. How to stop mysql service on Fedora 16 :

[root@fedora16 ~]# systemctl stop mysqld.service

4. How to restart mysql service on Fedora 16 :

[root@fedora16 ~]# systemctl restart mysqld.service

5. Configure basic security for MySQL server on Fedora 16.
As a root, simply run the following command :

[root@fedora16 ~]# mysql_secure_installation

Above command will perform the following task for you to ensure your MySQL server apply the basic security :
a) Set root password
b) Remove anonymous users
c) Disallow root login remotely
d) Remove test database and access to it
e) Reload privilege tables now

Examples :

[root@fedora16 ~]# mysql_secure_installation




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
 ... Success!

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...



All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

How to Install MySQL Database Server on Fedora 16

MySQL server is a popular choice of database server that can stores and retrieves data for the blog, websites and applications. MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a number of databases. For more information on MySQL, you can visit their website at www.mysql.com. In this post, i will show on how to install MySQL database server on linux Fedora 16 server. This post assumed that you have set up local yum repository using your DVDROM and had installed minimal installation type Fedora 16.

1. To install mysql service, simply run the following command :

[root@fedora16 ~]# yum install mysql mysql-server -y

Examples of mysql installation :

[root@fedora16 ~]# yum install mysql mysql-server -y
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i686 0:5.5.14-3.fc16 will be installed
---> Package mysql-server.i686 0:5.5.14-3.fc16 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================
 Package                Arch           Version                  Repository                     Size
====================================================================================================
Installing:
 mysql                  i686           5.5.14-3.fc16            Fedora16-Repository           4.2 M
 mysql-server           i686           5.5.14-3.fc16            Fedora16-Repository           7.8 M

Transaction Summary
====================================================================================================
Install       2 Packages

Total download size: 12 M
Installed size: 70 M
Downloading Packages:
----------------------------------------------------------------------------------------------------
Total                                                                51 MB/s |  12 MB     00:00
Running Transaction Check
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : mysql-5.5.14-3.fc16.i686                                                         1/2
  Installing : mysql-server-5.5.14-3.fc16.i686                                                  2/2

Installed:
  mysql.i686 0:5.5.14-3.fc16                    mysql-server.i686 0:5.5.14-3.fc16

Complete!

2. How to configure mysql service run at boot on Fedora 16 :
To ensure that the mysql service run automatically at boot, please run this command :

[root@fedora16 ~]# systemctl enable mysqld.service

Example :

[root@fedora16 ~]# systemctl enable mysqld.service
ln -s '/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'

If you run chkconfig command, it will also return the same result as above :

[root@fedora16 ~]# chkconfig --levels 235 mysqld on
Note: Forwarding request to 'systemctl enable mysqld.service'.

or

[root@fedora16 ~]# chkconfig mysqld on
Note: Forwarding request to 'systemctl enable mysqld.service'.

3. How to start mysql service on Fedora 16 :

[root@fedora16 ~]# systemctl start mysqld.service

How to Install Apache httpd on Linux Fedora 16 Server

This post will guide you how to install apache httpd service on linux Fedora 16. Apache HTTP is a popular web server for linux servers. Follow this steps to install apache httpd service.

Simply run this command :

[root@fedora16 ~]# yum install httpd -y
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package httpd.i686 0:2.2.21-1.fc16 will be installed
--> Processing Dependency: httpd-tools = 2.2.21-1.fc16 for package: httpd-2.2.21-1.fc16.i686
--> Processing Dependency: /etc/mime.types for package: httpd-2.2.21-1.fc16.i686
--> Processing Dependency: libaprutil-1.so.0 for package: httpd-2.2.21-1.fc16.i686
--> Processing Dependency: libapr-1.so.0 for package: httpd-2.2.21-1.fc16.i686
--> Processing Dependency: apr-util-ldap for package: httpd-2.2.21-1.fc16.i686
--> Running transaction check
---> Package apr.i686 0:1.4.5-1.fc16 will be installed
---> Package apr-util.i686 0:1.3.12-1.fc16 will be installed
---> Package apr-util-ldap.i686 0:1.3.12-1.fc16 will be installed
---> Package httpd-tools.i686 0:2.2.21-1.fc16 will be installed
---> Package mailcap.noarch 0:2.1.38-1.fc16 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================
 Package                Arch            Version                  Repository                    Size
====================================================================================================
Installing:
 httpd                  i686            2.2.21-1.fc16            Fedora16-Repository          811 k
Installing for dependencies:
 apr                    i686            1.4.5-1.fc16             Fedora16-Repository          103 k
 apr-util               i686            1.3.12-1.fc16            Fedora16-Repository           82 k
 apr-util-ldap          i686            1.3.12-1.fc16            Fedora16-Repository           16 k
 httpd-tools            i686            2.2.21-1.fc16            Fedora16-Repository           69 k
 mailcap                noarch          2.1.38-1.fc16            Fedora16-Repository           29 k

Transaction Summary
====================================================================================================
Install       6 Packages

Total download size: 1.1 M
Installed size: 3.4 M
Downloading Packages:
----------------------------------------------------------------------------------------------------
Total                                                               2.1 MB/s | 1.1 MB     00:00
Running Transaction Check
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : mailcap-2.1.38-1.fc16.noarch                                                     1/6
  Installing : apr-1.4.5-1.fc16.i686                                                            2/6
  Installing : apr-util-1.3.12-1.fc16.i686                                                      3/6
  Installing : httpd-tools-2.2.21-1.fc16.i686                                                   4/6
  Installing : apr-util-ldap-1.3.12-1.fc16.i686                                                 5/6
  Installing : httpd-2.2.21-1.fc16.i686                                                         6/6

Installed:
  httpd.i686 0:2.2.21-1.fc16

Dependency Installed:
  apr.i686 0:1.4.5-1.fc16                           apr-util.i686 0:1.3.12-1.fc16
  apr-util-ldap.i686 0:1.3.12-1.fc16                httpd-tools.i686 0:2.2.21-1.fc16
  mailcap.noarch 0:2.1.38-1.fc16

Complete!

Configure your system to start Apache at boot time :

[root@fedora16 ~]# systemctl enable httpd.service

Start Apache service :

[root@fedora16 ~]# systemctl start httpd.service