[Read More...]

0 If you are receiving the following error code while Horde webmail login.

Horde "A fatal error has occurred Could not connect to database for SQLSessionHandler. Details have been logged for the administrator"

Solution::

NOTE: You can fix it only if you have a root user privileges which means this will be helpful for VPS , Semi-dedicated Servers and Dedicated servers.

1. Check the Horde webmail configuration file
Code:

#vi /usr/local/cpanel/base/horde/config/conf.php

2. You can find the following entry in the conf.php
Code:

$conf['sql']['hostspec'] = 'localhost';$conf['sql']['username'] = 'horde';$conf['sql']['password'] = '';$conf['sql']['protocol'] = 'tcp';$conf['sql']['database'] = 'horde';

3. Try to connect the database horde using the following method
#mysql -uhorde -p

You should obtain the Error.
Code:

"ERROR 1045 (28000): Access denied for user'horde'@'localhost' (using password: YES)"

4. Grant the privilege to the database using the mysql command prompt
Code:

#mysql> grant all privileges on horde.* to horde@localhost identified by '';

You can now login into the Horde Webmail now..!!!

Second solution is that, You can also try checking configuration file /etc/my.cnf and remove skip-innodb if its in there. Restart mysql service to ensure that the error has been fixed and Horde Webmail login works..

Another solution is to repair the table named “SessionHandler” in Horde Database from mysql command Prompt as follows.
Code:

#mysql#mysql> use horde;#mysql> repair table horde_sessionhandler;

These Fixes must fix your Horde webmail login problem..

[Read More...]

0 Change Linux timezone

If you are using Fedora / RHEL / Cent OS Linux
Type the redhat-config-date command at the command line to start the time and date properties tool.

# redhat-config-date

OR type setup and select time zone configuration (good for remote ssh text based Linux server sessiob)

# setup

Now, just follow on screen instructions to change timezone

Set timezone using /etc/localtime configuration file [any Linux distro]

Often /etc/localtime is a symlink to the file localtime or to the correct time zone file in the system time zone directory.

Generic procedure to change timezone

Change directory to /etc
# cd /etc

Create a symlink to file localtime:
# ln -sf /usr/share/zoneinfo/EST localtime
OR some distro use /usr/share/zoneinfo/dirname/zonefile format (Red hat and friends)
# ln -sf /usr/share/zoneinfo/EST localtime
OR if you want to set up it to IST (Asia/Calcutta):
# ln -sf /usr/share/zoneinfo/Asia/Calcutta localtime
Please mote that in above example you need to use directory structure i.e. if you want to set the timezone to Calcutta (India) which is located in the Asia directory you will then have to setup using as above.

Use date command to verify that your timezone is changed:
$ date
Output:

Tue Aug 27 14:46:08 EST 2006

Use of environment variable
You can use TZ environment variable to display date and time according to your timezone:
$ export TZ=America/Los_Angeles
$ date

[Read More...]

0 How to remove the blocked ip using iptables

1. First check that ip is blocked or not
2. iptables –L –n | grep

DROP all – 125.99.10.123 216.240.157.91

3. to unblock the ip give the command

iptables -D INPUT -s 125.99.10.123 -d 216.240.157.91 -j DROP

Now the ip is unblocked.

[Read More...]