Reset vtiger default admin password

UPDATE vtiger_users SET user_hash = ‘21232f297a57a5a743894a0e4a801fc3′,
user_password = ‘adpexzg3FUZAk’,
confirm_password = ‘adoY/6Mlw8kqg’ WHERE user_name = ‘admin’

This will set the admin password to ‘admin’ again.

403 permissions problem after installing Nagios on virtualmin

If the websites are managed with VirtualMin. Each site has its own user name, group and home folder.

For example, site www.sampleweb.com under VirtualMin has user name and groups sampleweb as well as home folder /home/sampleweb.
The document root of the site is /home/sampleweb/public_html.

If the Nagios is installed on the same server, it change the apache group and all the websites start returning 

403 error permission denied.

To resolve this add the user group again to apache for example :

/usr/sbin/usermod -a -G sampleweb apache

retstart apache and you will be back in business

IMPORTANT : THE NAGIOS INSTALLATION IS NOT RECOMMEND ON HOSTING SERVERS, AND THIS SHOULD BE DONE ON A PLAIN INSTALLATION ONLY, OTHERWISE IT LEADS TO SEVERAL PROBLEMS LIKE ONE ABOVE.

Free Isapi Rewrite Filter

Ionic’s Isapi Rewrite Filter

Ionic’s Isapi Rewrite Filter, aka IIRF, is a small, cheap, easy to use, URL rewriting ISAPI filter that combines a good price (free!) with good features. It is fast and powerful. It works on IIS 5.0, 5.1, 6.0, and 7.0. If you use IIS, you can download IIRF and get started right now.

Micro SQL Admin for SQL 2008 and 2005

Micro SQL Admin is a tiny tool written in PHP intended for MS SQL Server 2008 and 2005 administration over the World Wide Web.

It is FREE!

DOWNLOAD HERE

How to install the Micro SQL Admin:

1. Install SQL Server 2005 Driver for PHP.

2. Place index.php to any folder of your website. Be sure there are correct permissions to run PHP. You can rename index.php if you wish.

Create addional FTP accounts using SSH in Plesk

Login to the server as ‘root’ user and create a system user (for example USER_NAME) with home directory you need, for example:
# /usr/sbin/useradd -d $HTTPD_VHOSTS_D/your_domain/some/location -s /bin/false USER_NAME

Set the password for this user using ‘passwd’ command.

Add this user into ‘psacln’ group:
# /usr/sbin/usermod -G psacln USER_NAME

The user will be ‘chroot’-ed to his home because ‘psacln’ group is listed in /etc/ftpchroot. Set read/write permissions for this user on his home directory, for example:
# chmod 755 $HTTPD_VHOSTS_D/your_domain/some/location
# chown USER_NAME:psacln $HTTPD_VHOSTS_D/your_domain/some/location

And set execute permission on the domain’s httpdocs folder:

# chmod 751 $HTTPD_VHOSTS_D/your_domain/httpdocs

$HTTPD_VHOSTS_D – have to be replaced with the real path to the Plesk virtual hosts in the all examples above.

What is my ip address: Check your public ip

www.myipy.com

Country state city database

GeoWorldMap is a database that contains the cities of the world with their country, region, latitude, longitude and more.

http://www.geobytes.com/GeoWorldMap.zip