How to enable epel repository

For CentOS 6, 64bit

1. Download the rpm of epel.
# wget http://ftp-srv2.kddilabs.jp/Linux/distributions/fedora/epel/6/x86_64/epel-release-6-x.noarch.rpm
check the latest epel version.

2. Install the package.
# rpm -ivh epel-release-6-7.noarch.rpm

3. Edit epel conf file to enable epel repository.

# vi /etc/yum.repos.d/epel.repo
[epel]
name=Extra Packages for Enterprise Linux 5 - $basearch
#baseurl=http://dl.fedoraproject.org/pub/epel/5/$basearch
mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-5&arch=$basearch
failovermethod=priority
enabled=1
priority=2

4. check if epel repository is working.
# yum install geoip

Brightness control software for iMac

Shades

http://www.macupdate.com/app/mac/23370/shades

It's pretty useful!!

Cacti got graphs, But no values.

Cacti about NaN's in their graphs
http://docs.cacti.net/manual:087:4_help.2_debugging#not_nan_but_0_zero_values

Cacti Repodata

For CentOS/RHEL 6.x, 64bit

http://apt.sw.be/redhat/el6/en/x86_64/rpmforge/RPMS/

phpMyAdmin Error: Cannot load mcrypt extension

For CentOS 6.2 64bit
The solution is below.


# rpm -ivh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-5.noarch.rpm
# yum update
# yum install php-mcrypt
# /usr/sbin/apachectl restart

sed in vi.

:%s/old_string/new_string/g

Cloned Red Hat/CentOS/Scientific Linux Virtual Machines and “Device eth0 does not seem to be present” Message

See this link.
or just delete /etc/udev/rules.d/70-persistent-net.rules and reboot the virtual machine.
Then you can see eth0. :)

Cacti plugin installation problem

When you applied the pa.sql to cacti database, you might face the following error.

ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 12

To get around this, you have to edit pa.sql and replace the word TYPE to ENGINE like this.

:%s/TYPE/ENGINE/g

Then excute the sql file.:)

Infinite Redirect Loop when selecting group in Google Groups

I recently encountered the infinite redirect loop when I accessed my Google Groups website. I didn't know why. I tried with another PC and it was good. Also tried with Google Chrome. Then it was good. Just one PC with Firefox is not good. Upgrading Firefox to version 3.6.3 didn't resolve the problem.Finally I deleted all cookies and could connect to my Google groups website. 
 I referred the following website.
http://support.mozilla.com/no/forum/1/700930

How to grant select privileges to all tables in database in PostgreSQL

After a couple of research, I figured out the command that grants select privileges to all tables of the database in PostgreSQL.

 select 'grant select on '||schemaname||'.'||tablename||' to username;' from pg_tables where schemana
me in ('public');

Also in the case of views it would be the following.

 select 'grant select on '||schemaname||'.'||viewname||' to username;' from pg_views where schemaname
 in ('public');

You'll get the list of SQL statements to grant all tables the privileges you want like following.

                          ?column?
------------------------------------------------------------
 grant select on public.table_a to username;
 grant select on public.table_s to username;
 grant select on public.table_d to username;
 grant select on public.table_f to username;
 grant select on public.table_g to username;
........

(xx rows)

Then, excute those SQL statements.
That's it.:)

I referred the following post.
http://bensbrain.blogspot.com/2004/08/postgres-grant-on-all-tables-in.html