Webhosting Terms

Heading Issues

DNS ISSUE
1.Updating nameserver for the domain
2.checking and modifing MX for a domain
3.setup url forwarding for a domain
4.Creating subdomains
5.Ponting IP for a domain

EMAIL ISSUE
1. checking account quota for the domain
2. checking the mail quota and correcting
3. Correcting the nmaeserver mismatch error
4. checking and correcting the MX for the domain
5. Checking and correcting the catch all problem for an account via cpanel
6. Updating the step to create emial account via cpanel
7. Updating the step to checkthe mail quota via cpanel
8. Updating the step to configure the outlook express
9. Updating the step to use the mail filter option via cpanel
10. Updating the step to configure spam assassin via cpanel
11. Updating the step to enable spam assasin for the account via cpanel
12. clearing frozen messages in mail queue for the eamil to work
13. Clearing or removing session files in tmp folder to email access error problem
14. Empty the mail account that consumes space as per the customer request

APACHE ISSUES Turn automatic directory listings on or off
To set up Apache to require a username and password to access certain documents
To prevent people from "stealing" the images from my web site
set up a virtual host in Apache
Directives in Apache
Setup SSL
Log analyze in apache
Redirect rules in apache
Scriptalias
.htaccess rules
Apache error codes

GENERAL ISSUE
1. Sending welcome mail fro the login details
2. Suspending and unsuspending an account via WHM
3. Terminate an Account via WHM
4. Quota Modification for an account via WHM
5. Checking the space usage of the account
MYSQL ISSUE
6. Update step to "Changing your cPanel account password"
7. Install FrontPage Extensions via WHM
8. UNInstall FrontPage Extensions via WHM
9. View Bandwidth Usage and correcting the bandwidth for a domain via WHM
10. Password modification for an account via WHM
Basic Issues 11. Modify an Account via WHM
12. Checking ssl access for a account via WHM
13. Update step to "Creating additional FTP accounts"
14. Update step to "Creating a subdomain"

1.Update the step to "Creating a MySQL database"
2.Update the step to "Managing a MySQL database in PHPMyAdmin"
3.Checking mysql access
4.Giving privileges to database

1. Enabling Shell access for a domain.
Heading 2. Enabling Awstats, webaliazer and analog stats.
3. Changing Username for a domain.
General Installations/Up gradation. 4. Increasing diskquota and bandwidth for a domain.
5. Reset Cpanel passsword for particular domain.
6. Suspend/unsuspend an Account.
7. Enable/disable reseller privileges.
8. Adding/deleting subdomain and parked domain

Level II Issues

Issues

a. Installing Chkrootkit
b. Installing Rootkit Hunter
c. Installing APF and BFD
d. Installing SIM (System Integrity Monitor)
e. Installing PRM (Process Resource Monitor)
f. Installing LES (Linux Environment Security)
g. LSM (Linux Socket Monitor)
h. Installing Mod_Throttle on cPanel server
Apache i. Imapd Installation
j. Streaming server Installations
k. Securing the /tmp Directory
l. Php Installation/Upgradation
j. Reseting the admin password in plesk Manually
k. eaccelerator Installation
l. Various types of quota Issues.
m. Enabling/Disabling phpsuexec
h. Installations of 3rd party tool via fantastico.

a. Upgrading the apache
Mail b. Configuring the modules in plesk server
c. Compiling the modules in apache
d. General Apache Tweaking
e. Internal server error
f. Page not found error
g. Redirecting a page to some other page using htaccess
i. Enabling and disabling mod_security using htaccess
j. Enable/disable safe_mode , allow_url_fopen, upload_max_filesize,
l. register_globals for php using .htaccess

a. Tweaking the exim configuration file
b. Handling issue like Maximum mails per/hr for a domain
c. Preventing the user "nobody" from sending out mail to remote addresses
FTP d. RBL configuration
e. Local delivery error
f. Mail delivery failed error
g.Clearing frozen mails and mails older than 5days using exim commands
DNS h.Enabling BoxTrapper Spam Trap in the server
i.Enabling SpamAssassin Spam Filter options in server
j.Creating Spam filter rule, enabling spamassasin and Configuring spam assasin to control the amount of Spam mails
k.Blacklisting a domain and adding a domain in white list
l.Email timing out

Mysql a. Converting pro-ftp to pure-ftp and vice versa
b.Creating ftp user for a particular directory
c.FTP - 550 login error

a. Updating the bind ver.
b. SPF Record Creation
c. Creating a new DNS Zone
d. Changing A record Entry
e. Nameserver mismatch error.
General Issues
a. Upgrading Mysql
b. Handling version conflict error
c. Handling Privileges Issues'
d.Creating mysql backup
e.Restoring Mysql backup
f.Repairing tables using Myisamchk
g.Mysql connection error
h.Deleting a table in database

a. Generating CSR
b. Installing SSL Cert
Heading c. Handling some critical cpanel/plesk related Issue's
Exim + Sendmail + Qmai d. Deleting unwanted logs and reduce disk space.
e. Domain not listed in WHM
f. Blocking/unblocking IP via apf & iptables.
g. Restore backup for a domain
h. Updating awstats manually.


Level III Issues (Server Administration)

Issues
a. Editing configuration files
b. Reinstalling
c. Changing Outgoing port number
d. Integrating RBL with mail servers
e. Modifying Open relay and closed relay
f. Editing configuration files of Anti Spam softwares( MailScanner,ClamAv,SpamAssassin)
FTP Servers g.Proving and Protecting Email Sender Identity using Domainkeys
h. Imap configuration
i.Dovecot configurationMail service not working:
DNS Servers j.exim corruption
k.DNS issues
l.Permission issues
m.localhost errors due to corrupted sendmail.mc/sendmail.cf.
Apache n.Email authentication problem in outlook, unable to login horde or squirrel mail in cpanel servers


a. Enabling Ftp Resume Uploads
b. Enable FXP with PureFTP

a. Open DNS
b. Unable to start/stop named due to /etc/named.conf or zone file misconfiguration
FreeBSD c. Named not loading due to RNDC

a. Editing configuration which affects serverwide
Installations b. Upgradation
c. Configuring Dual httpd
d. Lighttpd configuration
e. Tweaking apache
f. Internal server error due to file extension configuration in apache
g.Unable to start/stop apache due to corrupted httpd.conf.

a. To configure a FreeBSD IPFW firewall
b. Kernel setup

a. Imapd
b. Nagios Installation and configuration
c. Installing Bind
d. Installing Apache
e. Installing Mysql
f. Installing PHP
g.Installing Qmail
h. Squirrelmail, webmin installations
I.Installing Shoutcast (Streaming software)
j.Icecast Installation
k.APF, BFD installation
l.SIM, PRM installation
m.ntegrating various modules with Apache
n.Installing Nagios
Other tasks o.Installing Lighthttpd
p.MRTG, Eaccelerator, Zendoptimizer installations
q.Installing LAMP
r.Installing Apache, PHP, Mysql in a Directadmin server
s.Upgrading/degrading PHP, Mysql
u.Installing Rkhunter, chkrootkit for checking server vulnerabilities
t.Configuring multiple interface in the server
v.Cpanel server setup
w.Installing perl modules for cpanel servers using CPAN or WHM

a. Server Migration
b. Taking backups and restoring
c. Mounting second drive
d. Cluster setup
e. Server Intial Setup
PHP f. Mysql Synchronization
g. Load Balancer configuration
h. Synchronization of two servers
Mysql I. Roundrobin Configuration
j. Tweaking sysctl conf, Apache, Mysql, FTP
k. rsync
l. Adding gateway and ips
Cpanel errors m. Load Monitoring Script
n. MRTG, RTG
Server Wide General issues
a. Recompiling PHP
b. PHP issues in plesk server

a. Unable to start/stop Mysql
b. Mysql tweaking
Mail Servers c. Error while upgrading/degrading Mysql

a. Unable to run /scripts/upcp

a. Unable to load the domains outside the server/network
b. Server tweaking
c. Kernel tweaking
d. debugging dos attack servers
e. debugging hacked servers
Server Security:(Linux,Freebsd)
a. Tuning the configuration files.
b. Reinstalling the already installed mail servers.
c. Working with the mail redirections
d. Installing and upgrading the addon modules
e. Configuring POPb4SMTP and SMTPb4POP
f. Installing DOVECOT and configuring it.
g.Trouble shooting in all the above-mentioned topic.
h. Up gradation of the already installed addon modules.

a. Ugrading the latest available packages.
b. Tuning the linux kernel.
c. Checking the services and servers installed in the primary server.
d. Kernel upgradation - recompilation.
e. Checking the server's performance.
f. Identifying the vulnerable scripts in the server.
g. Disabling the unwanted services.
h. Using proper security chains.
I. Checking the server's open ports.
j. Installing and configuring the 3rd party security modules.
k. Tuning various installed services like mysql, ftp etc...
l. Log analysis and Securing ssh etc..
m. Monitoring the server's resource usage.
n. Server crash analysis.
o. Server hack analysis.

Outlook Configuration Settings

Please follow the below steps for configuring the outlook express.

1.In Microsoft Outlook, from the E-mail Accounts menu, select Tools.
2.On the E-mail Accounts wizard window, select Add a new e-mail account,
and then click Next.
3.For your server type, select POP3 or IMAP, and then click Next.
4.On the Internet E-mail Settings (POP3/IMAP) window, enter your
information as follows:

-->Your Name
Your first and last name.
-->E-mail Address
Your email address.For example (test@atake.com.cn)
-->User Name
Your email address, again.
-->Password
Your email account password.
-->Incoming mail server (POP3)
POP, Pop.secureserver.net or IMAP, imap.secureserver.net.
-->Outgoing mail server (SMTP)
Smtpout.secureserver.net

Click More Settings.

5. On the Internet E-mail Settings window, go to the Outgoing Server tab.
6. Select My outgoing server (SMTP) requires authentication.
7. Select Use same settings as my incoming mail server.
8. Click Ok. Click Next. Click Finish.

Good Link for Learning IIS

A very good link to get started with IIS

http://www.iis.net/

Make Win Server administration easier using Windows Power Shell.

http://technet.microsoft.com/hi-in/library/ee221100%28en-us%29.aspx
http://technet.microsoft.com/en-us/scriptcenter/dd742419.aspx
http://support.microsoft.com/kb/968929

Windows Power Shell is available for Win2003 and Win2008R2

A very nice way to start learning Windows.

Commands for Remove the Mail queues in Exim

Commands for remove frozen mail queues in Exim

exiqgrep -i -f | xargs exim -Mrm
exim -bp | grep "frozen" | awk {'print$3'} | xargs exim -Mrm
exim -bp | grep "<>" | awk {'print$3'} | xargs exim -Mrm
exim -bp | grep "nobody" | awk {'print$3'} | xargs exim -Mrm
exim -bp | grep "bounce" | awk {'print$3'} | xargs exim -Mrm

exiqgrep -i -f | xargs exim -Mrm
exim -bp | grep "frozen" | awk {'print$3'} | xargs exim -Mrm
exim -bp | grep "<>" | awk {'print$3'} | xargs exim -Mrm
exim -bp | grep "nobody" | awk {'print$3'} | xargs exim -Mrm
exim -bp | grep "bounce" | awk {'print$3'} | xargs exim -Mrm

Free SSL Certificate - StartSSL

Israeli vendor StartSSL offers free SSL server certificates that are
valid for a year. Usually we purchase SSL certs from vendors like
Verisign, Thawte etc. For more info just follow the link

http://www.h-online.com/security/features/SSL-for-free-step-by-step-906862.html

MYSQL Password Reset

Checking My sql version
=======================
mysql -V
mysql Ver 14.12 Distrib 5.0.86, for pc-linux-gnu (i686) using readline 5.1

Reset Mysql Password for mysql Ver 14.12
=========================================

mysql>set password for 'teachersdb_Ads'@'localhost' = password('98m4@9er');

For some other versions
=======================

UPDATE user SET Password=PASSWORD('1q2w3e4r') WHERE User=’teachersdb_Ads’;

For mysql login:
================
mysql -u username -p password

To set All privileges to My sql DB
===================================
GRANT ALL PRIVILEGES ON teachersdb_Ads.* TO teachersdb_Ads @'174.37.6.90' IDENTIFIED BY '4645bvg6dgdr'

You will start by logging into your server via ssh and logging into your MySQL entering the following:

mysql –uadmin –p`cat /etc/psa/.psa.shadow`


Grant Privilege

GRANT SELECT ON database.* TO username@'localhost' IDENTIFIED BY 'password';

To enable more options you would separate them with a comma. So to enable SELECT, INSERT, and DELETE your syntax would look like this;

GRANT SELECT, INSERT, DELETE ON database.* TO username@'localhost' IDENTIFIED BY 'password';

Once you have given the desired privileges for your user, you will need to run this command within the MySQL command prompt;

FLUSH PRIVILEGES;

To see a list of the privileges that have been granted to a specific user;

select * from mysql.user where User='user' \G

Virtuozzo Panel Issues

Virtuozzo Issues

Issue:
In Parallels Virtuozzo panel all the cPanel accounts shows that their disk usage is Zero.

Fix:

vi /etc/vz/conf/101.conf

QUOTAUGIDLIMIT="0"

change it to QUOTAUGIDLIMIT="1000"


then,

vzctl restart 101