Archive for May, 2008

Newer Entries »


Remote access to MySQL on cPanel server

Wednesday, May 14th, 2008

For users who may wish to access a MySQL database from a remote location. You need to know the basics that MySQL uses port 3306. It is assumed that you already have a database under your cPanel hosting account. To ensure you can connect remotely you will also need to add the relevant Access Host.

Now, you have to grant permissions for this click on “MySQL database” icon under cPanel. When you scroll down you will see heading “Access Host” the default host is “localhost” which you can see over there. In the box there you can add the IP address that you want to allow connection from.

If you want all IP addresses within a range to work you can use a wildcard (%) symbol, for example:

192.168.1.% will allow any user from 192.168.1.1 to 192.168.1.255 to connect.

The wildcard symbol on its own will allow any user to connect, assuming that they have the username and password for a database.

That’s it!

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.

Posted in MySQL | No Comments »


Disk usage on cPanel server

Tuesday, May 13th, 2008

On a Linux system for a system administrator it is necessary to check disk usage on the server and make sure that the disk space does not get 100% and cause problem for the users, so as a routine you should always check for disk space.

The command to check disk space on the complete server is:

root@server# df –h

If a particular partition is consuming too much disk space and you need to find which folder under that partition is using it, for example the partition is /var you can use the command:

root@server# cd /var

root@server# du –sh *

This will display the size of each directory under the /var partition.

So, be proactive and keep your server always healthy.

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.

Posted in cPanel | No Comments »


How to set default WYSISWYG editor in Joomla

Friday, May 9th, 2008

To find editors that are already installed check this: Click Installers->Mambots and see the list if your favourite editor is available there.

Steps to change the default WYSIWYG editor:

Log in to your administrator panel.
Click Site > Global Configuration.
Under the first tab (“Site”), find the parameter labelled “Default WYSIWYG Editor:”.
Select your default editor from the drop-down list.
Click the “Save” button in the toolbar.

Steps for changing a WYSIWYG Editor for a Specific User

Log in to your administrator panel. (as super administrator)
Click on Site->User Manager.
Click the name of the user for which you want to set the editor.
On the right side of the page, you will see the parameter labelled “User Editor”.
In the drop-down list, select the editor for that user.
For me, you would selece “No WYSIWYG Editor”.
For someone who wants to use the default editor, you would simply selct “- Select Editor -”.
Otherwise, you would select a specfic editor from the list.

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.

Posted in General | 1 Comment »


Exim configuration and messages in mail queue – cPanel server

Wednesday, May 7th, 2008

You may wonder how to check exim configuration in one command on a cPanel server, so here is the command to check exim configurations:

root@server# exim -bP

Now, you need to check the summary of messages in the mail queue it contains (Count, Volume, Oldest, Newest, and Domain) here is the command:

root@server# exim -bp | exiqsumm

If you want to print message ID of all the messages in the mail queue, here is the command:

root@server# exiqgrep –i

That’s it!

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.

Posted in Exim | No Comments »


Monitor MySQL processes on linux server

Tuesday, May 6th, 2008

If you need to monitor MySQL and want to see the database used at that particular time, as well as the state and time you can use the following command to check it:

root@server# mysqladmin processlist

Or

root@server# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 121572 to server version: 4.1.22-standard

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> SHOW FULL PROCESSLIST;

That’s it!

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.

Posted in MySQL | No Comments »


Find an inode of a file

Monday, May 5th, 2008

In computing, an inode is a data structure on a traditional Unix-style file system such as UFS. An inode stores basic information about a regular file, directory, or other file system object.

Now in linux you want to check the inode of a file, so the command to find inode of a file is:

root@server # ls -li test.php

426137 -rw-r–r– 1 root root 0 May 05 03:14 test.php

Here, 426137 is the inode of the file test.php

Isn’t it easy?

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.

Definition source: en.wikipedia.org/wiki/Inode

Posted in General | No Comments »


Import and export mysql database

Friday, May 2nd, 2008

On a cPanel server, if you need to import a SQL file into a database – here is the command to get this done:

mysql cpanelusername_database < sqlfilename.sql

And, if you want to export the database to a sql file – the command to do this is:

mysqldump cpanelusername_datbase > databasename.sql

That’s it!

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.

Posted in MySQL | No Comments »


Domain not showing in cPanel – WHM > List accounts

Thursday, May 1st, 2008

You have added a domain on your cPanel dedicated server and when you checked “list accounts” under your Webhost Manager (WHM) the domain is not listed, however you can see the hosted domain on your server using SSH. This is because your domain database has not been updated. Just execute the following command on your cPanel server to get this fixed.

root@server# /scripts/updateuserdomains

And, now check it under your WHM > List accounts. You will see the domain listed there.

That’s it!

This article is released by SupportFacility.Com — the leaders in providing outsourced technical support, live chat support & help desk support for web hosts. Interested ? Opt for a trial now.

Posted in cPanel | 1 Comment »


Newer Entries »