How to install roundcube on cPanel Server?

Web Hosting Tutorials, Web Hosting, Cpanel Hosting No Comments »

To install roundcube on a cPanel or Linux Server, you should know your MySQL root password. Replace your MySQL root password with Database Password.

If you have already used RoundCube installation before then make sure you have removed traces of it.

Follow the steps given below and remove any traces of it with,

cd /usr/local/cpanel/base
rm -rf roundcube*
mysql -p -e ‘drop database roundcube’;
chattr -i /usr/local/cpanel/base/frontend/x/webmaillogin.html
chattr -i /usr/local/cpanel/base/webmaillogin.cgi
/scripts/upcp

You will have to specify your root password when prompted.

Let us begin with installation

A) Download roundcube first from the given sourse and apply the proper permission to directories

cd /usr/local/cpanel/base
wget -O roundcube.tar.gz http://heanet.dl.sourceforge.net/sourceforge/roundcubemail/roundcubemail-0.1-rc1.tar.gz
tar -zxvf roundcube.tar.gz
rm -rf roundcube.tar.gz
mv -f roundcubemail-0.1-rc1 roundcube
cd roundcube
chmod -R 777 temp
chmod -R 777 logs

B) Create the database and install the intial sql file. The following commands will do this for you.
replace the mysql password in place of DATABASEPASSWORD

mysql -e “CREATE DATABASE roundcube;” -pDATABASEPASSWORD
mysql -e “use roundcube; source SQL/mysql.initial.sql;” -pDATABASEPASSWORD

C)Set the configuration as given below

cd config
mv db.inc.php.dist db.inc.php
mv main.inc.php.dist main.inc.php

Now open db.inc.php

nano db.inc.php

Find

$rcmail_config[’db_dsnw’] = ‘mysql://roundcube:pass@localhost/roundcubemail’;

Replace with

$rcmail_config[’db_dsnw’] = ‘mysql://root:DATABASEPASSWORD@localhost/roundcube’;

Now Open main.inc.php

nano main.inc.php

Find

$rcmail_config[’default_host’] = ‘’;

Replace with

$rcmail_config[’default_host’] = ‘localhost’;

D) Configure cPanel to show roundcube in the theme. Please note this is for the X theme(default) only!! If you use another theme please skip the next part and see below.

cd /usr/local/cpanel/base/roundcube/skins/default/images/
cp –reply=yes roundcube_logo.png /usr/local/cpanel/base/frontend/x/images/roundcube_logo.png
cp –reply=yes roundcube_logo.png /usr/local/cpanel/base/webmail/x/images/roundcube_logo.png
cd /usr/local/cpanel/base
wget http://www.hostgeekz.com/files/hostgeekz/HGpatch-roundcube-0.1-rc1
patch -p0


RoundCube——

***UPDATE***
Remember to chattr +i the files or add the patch to your /scripts/upcp.

chattr +i /usr/local/cpanel/base/frontend/x/webmaillogin.html
chattr +i /usr/local/cpanel/base/webmaillogin.cgi

That’s it! You may now access roundcube via http://domainname/webmail

By hostingcomments.com

MySQL Admin Commands and MySQl Administration

Web Hosting Tutorials, Web Hosting No Comments »
MySQL Admin Commands:* Statistics: [prompt]$ mysqladmin version
* List database environment: [prompt]$ mysqladmin variables
* Show if database is running: [prompt]$ mysqladmin ping
* Show databases available:[prompt]$ mysqlshow

OR

mysql> SHOW DATABASES;

* Delete database: mysql> drop database databasename;
* Show list of active threads in server:

[prompt]$ mysqladmin -h localhost -u root -p processlist

* Delete a database: [prompt]$ mysqladmin drop database-name
* Execute SQL from Linux command line interface:
[prompt]$ mysql -h localhost -u root -p -e “select host,db,user from db” mysql
* Execute SQL command file from Linux command line interface:

[prompt]$ mysql -h localhost -u root -p database-name

By hostingcomments.com

Setting UP Hostname For The Web Server….

Web Hosting Tutorials, Web Hosting No Comments »

This is for those who want to set up a hostname on their VPS or Dedicated Server. The Hostname should be FQDN- Fully Qualified Domain Name. The hostname is your server’s name that you want to set. Always set the hostname with the domain name that you own. Follow these steps:-

a.http://IP/whm edit dns zone .. select your domain

server IN A YourSeverIPHere
www.server IN A YourSeverIPHere
OR
if you are using shell then you can simply append following lines there in
# vi /var/named/domain.com.db

server IN A YourSeverIPHere
www.server IN A YourSeverIPHere

Save the file
#service named reload
#rndc reload domain.com

b.WHM >> Basic cPanel/WHM Setup >> Hostname

or
Login to shell /server as a root and fire this command the second parameter will the hostname that you want to set.
hostname server.domain.com

c.Check /etc/hosts file that it is set properly.

You need to add there

87.117.200.71(ex.IP) server.mydomain.com server

server.mydomain.com is the hostname for this VPS then must add above live there, modify there as per your requirement.

Just confirm that you have set that properly because changing the hostname will affect few services on your server if you have not done that properly or have done any spelling mistake while setting hostname of your server.

d.Fire hostname on your server if it shows the hostname then you have set it properly. Its done now.

by hostingcomments.com

How to Disable Telnet on Web Server?

Web Hosting Tutorials, Web Hosting No Comments »

Enabling telnet is of great security risk to web server. It should be turned off to avoid further problems. Telnet sends clear text passwords and user names trough logins and therefore it should be disabled on servers and replaced with SSH. TELNET server listens for incoming messages on port 23, and sends outgoing messages to port 23

Follow the steps given below to disable the telnet on server.

a. Login to your server through SSH and su to root.

b. Type pico /etc/xinetd.d/telnet

c. Look for the line: disable = no and replace with disable = yes

d. Now restart the inetd service: /etc/rc.d/init.d/xinetd restart

e. Turn off it through chkconfig as well because it can still start through that.
/sbin/chkconfig telnet off

f. Scan your server to ensure port 23 is closed.
nmap -sT -O localhost
Also run ps -aux | grep telnet and if you find anything other than “grep telnet” as result kill the process.

by hostingcomments.com

Ways to list the content of a tar file

Web Hosting Tutorials, Web Hosting No Comments »

You need to list the contents of a tar or tar.gz file on screen before extracting the all files.

Task: List the contents of a tar file

Use the following command:
$ tar -tvf file.tar
Task: List the contents of a tar.gz file

Use the following command:
$ tar -ztvf file.tar.gz
Task: List the contents of a tar.bz2 file

Use the following command:
$ tar -jtvf file.tar.bz2

by hostingcomments.com

Importace of RAID..

Web Hosting Tutorials, Web Hosting No Comments »

What is RAID?

RAID stands for Redundant Array of Inexpensive Disks. It was developed to link a large number of low cost hard drives to form a single large capacity storage device which can overcome old storage solutions in case of reliablity , storage capacity and performance. This is most widely used service for storage in enterprise and server markets.

Three main advantages of RAID

* Redundancy
* Increased Performance
* Lower Costs

The most vital factor in the development of RAID for server environment is Redundancy. This offers backup of data in storage array in the event of failure. If their is a failure in one of the hard drives,it can be swapped for a new hard drive without turning the systems off or even the redundant drive could be used. Redundancy mainly depends on the version of RAID used.

The performance can be noticed mainly when the specific versions of the RAID are used. Performance will also depend upon the number of hard drive used in the array and the controller.

Low cost is the main concern in all major IT departments. Cost was also the key issue when the RAID standards were developed. As compared to individual capacity hard drives ,RAID array is used to provide greater storage capacity for a system. Price differences between the highest capacity hard drives and lower capacity drivesare are the good examples of it.
Three drives of smaller capacity costs less than an individual high-capacity drive but provide more capacity.

Three typical forms of RAID use for desktop computer systems are RAID 0, RAID1 and RAID5. RAID 0, RAID 1 versions are available and one of the two technically is not a form of RAID.

RAID provides variety of benefits for systems which depends upon the version implemented. Most users like to use RAID0 to increase the performance and to avoid loss of storage space. This is mainly because redundancy is not an issue for the average user. Most computer systems will only offer either RAID 0 or 1. The costs of implementing a RAID 0+1 or RAID 5 system generally are too expensive for the average user and are only found in high-end workstation or server level systems.

Run Command Shortcuts for Windows..

Web Hosting Tutorials, Web Hosting No Comments »

These are some quick and easy steps that you can use while you use the run prompt or command prompt. This you can use as a shortcut rather than using mmc control.

Accessibility Controls: access.cpl

Add Hardware Wizard: hdwwiz.cpl

Add/Remove Programs: appwiz.cpl

Administrative Tools: control admintools

Automatic Updates: wuaucpl.cpl

Bluetooth Transfer Wizard: fsquirt

Calculator: calc

Certificate Manager: certmgr.msc

Character Map: charmap

Check Disk Utility: chkdsk

Clipboard Viewer: clipbrd

Command Prompt: cmd

Component Services: dcomcnfg

Computer Management: compmgmt.msc

Date and Time Properties: timedate.cpl

DDE Shares: ddeshare

Device Manager: devmgmt.msc

Direct X Control Panel (If Installed)*: directx.cpl

Direct X Troubleshooter: dxdiag

Disk Cleanup Utility: cleanmgr

Disk Defragment: dfrg.msc

Disk Management: diskmgmt.msc

Disk Partition Manager: diskpart

Display Properties: control desktop

Display Properties: desk.cpl

Display Properties (w/Appearance Tab Preselected): control color

Dr. Watson System Troubleshooting Utility: drwtsn32

Driver Verifier Utility: verifier

Event Viewer: eventvwr.msc

File Signature Verification Tool: sigverif

Findfast: findfast.cpl

Folders Properties: control folders

Fonts: control fonts

Fonts Folder: fonts

Free Cell Card Game: freecell

Game Controllers: joy.cpl

Group Policy Editor (XP Prof): gpedit.msc

Hearts Card Game: mshearts

Iexpress Wizard: iexpress

Indexing Service: ciadv.msc

Internet Properties: inetcpl.cpl

IP Configuration (Display Connection Configuration): ipconfig /all

IP Configuration (Display DNS Cache Contents): ipconfig /displaydns

IP Configuration (Delete DNS Cache Contents): ipconfig /flushdns

IP Configuration (Release All Connections): ipconfig /release

IP Configuration (Renew All Connections): ipconfig /renew

IP Configuration (Refreshes DHCP & Re-Registers DNS): ipconfig /registerdns

IP Configuration (Display DHCP Class ID): ipconfig /showclassid

IP Configuration (Modifies DHCP Class ID): ipconfig /setclassid

Java Control Panel (If Installed): jpicpl32.cpl

Java Control Panel (If Installed): javaws

Keyboard Properties: control keyboard

Local Security Settings: secpol.msc

Local Users and Groups: lusrmgr.msc

Logs You Out Of Windows: logoff

Microsoft Chat: winchat

Minesweeper Game: winmine

Mouse Properties: control mouse

Mouse Properties: main.cpl

Network Connections: control netconnections

Network Connections: ncpa.cpl

Network Setup Wizard: netsetup.cpl

Notepad: notepad

Nview Desktop Manager (If Installed): nvtuicpl.cpl

Object Packager: packager

ODBC Data Source Administrator: odbccp32.cpl

On Screen Keyboard: osk

Opens AC3 Filter (If Installed): ac3filter.cpl

Password Properties: password.cpl

Performance Monitor: perfmon.msc

Performance Monitor: perfmon

Phone and Modem Options: telephon.cpl

Power Configuration: powercfg.cpl

Printers and Faxes: control printers

Printers Folder: printers

Private Character Editor: eudcedit

Quicktime (If Installed): QuickTime.cpl

Regional Settings: intl.cpl

Registry Editor: regedit

Registry Editor: regedit32

Remote Desktop: mstsc

Removable Storage: ntmsmgr.msc

Removable Storage Operator Requests: ntmsoprq.msc

Resultant Set of Policy (XP Prof): rsop.msc

Scanners and Cameras: sticpl.cpl

Scheduled Tasks: control schedtasks

Security Center: wscui.cpl

Services: services.msc

Shared Folders: fsmgmt.msc

Shuts Down Windows: shutdown

Sounds and Audio: mmsys.cpl

Spider Solitare Card Game: spider

SQL Client Configuration: cliconfg

System Configuration Editor: sysedit

System Configuration Utility: msconfig

System File Checker Utility (Scan Immediately): sfc /scannow

System File Checker Utility (Scan Once At Next Boot): sfc /scanonce

System File Checker Utility (Scan On Every Boot): sfc /scanboot

System File Checker Utility (Return to Default Setting): sfc /revert

System File Checker Utility (Purge File Cache): sfc /purgecache

System File Checker Utility (Set Cache Size to size x): sfc /cachesize=x

System Properties: sysdm.cpl

Task Manager: taskmgr

Telnet Client: telnet

User Account Management: nusrmgr.cpl

Utility Manager: utilman

Windows Firewall: firewall.cpl

Windows Magnifier: magnify

Windows Management Infrastructure: wmimgmt.msc

Windows System Security Tool: syskey

Windows Update Launches: wupdmgr

Windows XP Tour Wizard: tourstart

Ways to repair a corrupt MySQL Table..

Web Hosting Tutorials, Cpanel Hosting No Comments »

Different ways to repair a corrupt MySQL table :=>

1] Check the permission and ownership of database i.e. it should be same below

drwx—— 2 mysql mysql cpanelusername_dbname.

2] If the permissions are correct but some error occurs then it seems that your database table may be corrupts then there are following way to repair the DB

a) Go to whm >>SQL Services >> Repair a Database >> select database name and click Repair Database.

b) Go to cpanel >> mysql section MySQL Account Maintenance >> search database then click on Repair.

3] You can get it repaired it through shell when mysqld server is running

i) login in mysql to that particular user by using following command

mysql>mysql –u databaseusername –p databasename

ii) select particular database

mysql> use databasename;

iii) Check whether database table is corrupted or not. If following command output shows null value then it should be corrupt otherwise it is fine

mysql>show table status like ‘table name’\G; Or
mysql>check table tablename ;

iv)If it is corrupts then use the following command to repair that particular database table.

mysql>repair table tablename;

4] Get it repaired through shell when mysqld server is not running

Repairing MyISAM mySQL Tables/Databases:

# cd /var/lib/mysql/DBNAME

# myisamchk tablename.MYI

Repairing ISAM mySQL Tables/Databases:

# cd /var/lib/mysql/DBNAME
isamchk tablename.MYI
where

-c –> check database is corrupted or not
-r –> recorver
-o –> optimise the database

Sites pictures are boxed Xs (can’t see the images on the site)

Web Hosting Tutorials, Web Hosting, Cpanel Hosting No Comments »

Just comment the rule for :

RewriteRule .*\.(jpg|jpeg|gif|png|bmp)$ http://www.domain.com [R,NC] in your .htaccess.   Images will start working.

Jailshell

Web Hosting Tutorials, Web Hosting, Cpanel Hosting No Comments »

What is jailshell?

Jailshell is a very limited shell that allows clients to logon to your server via SSH. It limits them to their home directories, keeping the rest of your files on your server from being viewed.

How to enable jailshell from WHM?

You can enable jailshell as the default shell for new and modified accounts by going to Tweak Settings under Server Setup on the WHM main page. Scroll down to “System” and check the box next to ” Use jailshell as the default shell for all new accounts and modified accounts”.


WordPress Theme & Icons by N.Design Studio
Entries RSS Comments RSS Login