MySQL is easiest to install on Red Hat systems using the RPM packages. To install MySQL in the same directory as the RPM packages use the command:
# rpm -Uvh *.rpm

Note: You most likely need to do this as the root user. Either log in or su to root.

After MySQL is installed you need to set the root password. To do this use the following commanding changing my_password to the password you want for the root user to access MySQL.
# mysqladmin -u root password ‘my_password’

Note: If the MySQL service is not running, you may have to start it by hand before trying to set the password. It should start automatically when the computer boots. The command to start MySQL is:
# /etc/rc.d/init.d/mysqld start

You can test the MySQL installation by doing the following:

# mysql mysql (connect to mysql database)
Enter Password:
mysql> SELECT * FROM user; (grab some data out of user table)

This should return the data in the user table. Type exit to leave.

This can be done with .htaccess, visitors must input username and password before they can access the protected directory.

Step 1.
Create the file “.htaccess” with the following content under the directory you want to protect, you can specify the password in any place as long as Apache can access it.

AuthUserFile /home/account/passwd/.htpasswd
AuthGroupFile /dev/null
AuthName “Title”
AuthType Basic

Step 2.
Generate the password file “.htpasswd” under the directory /home/account/passwd/ with the following command:
# htpasswd -c .htpasswd user_name

You will be reminded to input password for the user “user_name”, this command can be called multi times to generate multi users.

Step 3.
This step may not be necessary. If there is an entry about the directory you want to protect in Apache configuration file, make sure AllowOverride has the option authconfig.

For example, when protecting Awstats pages, the Apache configuration file should be modified as following:

Options None
AllowOverride authconfig
Order allow,deny
Allow from all

Restart Apache
# /usr/local/sbin/apachectl restart

If you are not aware of my.cnf files configuration and want to use mysql server to optimize your database usage then replace this configuration file.
————————————————————————————
[mysqld]
socket = /var/lib/mysql/mysql.sock
safe-show-database
old-password=1
max_connections=500
interactive_timeout=100
wait_timeout=30
connect_timeout=30
thread_cache_size=8
key_buffer=32M
join_buffer=8M
max_allowed_packet=32M
table_cache=1024
sort_buffer=32M
record_buffer=8M
thread_cache_size=128
max_user_connections=30

thread_concurrency=4
myisam_sort_buffer_size=64M
query_cache_limit=2M
query_cache_size=32M
query_cache_type=1

old-passwords = 1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=32M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_bufer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

Robots.txt file is a simple text file which is responsible for preventing crawling of your site’s pages. Suppose you have certain pages which are not SE friendly such as pages including repeated keywords, some hidden tags with keywords and some other bugs which may be responsible for getting your site banned from search engines.

The robots.txt file is a simple text file which can be created using Notepad.
It should be saved at root directory of your site. eg.http://www.yoursitename.com/robots.txt.

Format :
User-agent: robot or spider name
Disallow: files or directories.

If you want to exclude all the search engine spiders from your entire domain, Just use this tiny code, but be sure you need it.
User-agent: *
Disallow: /

If you want to prevent your certain directories, you can specify them in Disallow field.
User-agent: *
Disallow: /directoryname1/
Disallow: / directoryname2/

Similarly if you want to restrict specific files then type in the path of the files.
User-agent: *
Disallow: / directoryname1/filename.html

If you don’t want certain spiders crawling your site, which are not useful for you or are just eating up your bandwidth, you can specify them in User-agent. Eg. You don’t want bot of Alta vista (Scooter) from crawl your whole site use following code.
User-Agent: Scooter
Disallow: /

While using robots.txt file you should be careful, It may stop your specified pages from appearing in search engines.There are many hundreds of bots and spiders crawling the Internet, most of them respect your robot.txt file while some may not.

Note :

(*) You can include comments in your robots.txt file, by putting a pound-sign (#) at the front of the line to be commented.
(*) You can find the names of robots which are crawling around your site in your log file..

Sometimes we get some errors while using outlook express but we can’t understand what they mean and what could be the solution for that.

Following are the usual errors codes with their solutions ;

0×800CCC00 - Authentication did not load.
Solution :
*) Try closing and restarting Outlook express
*) If still getting same error, wait 20-30 minutes for a server reset of your account then try again.
*) It could be a corruption of the user account in Outlook Express. Try setting up a second identity and see if it works.

0×800CCC01 - INVALID CERTIFICATE CONTENT
0×800CCC02 INVALID CERTIFICATE DATE
Solution :
*) Get your certificate re-issued by your authority server.

0×800CCC03 - USER ALREADY CONNECTED
Solution :
*) Close all connections on all machines, wait 20-30 minutes and try again.
*) If you are not logged in on another machine or poplocked then someone may be using/downloading from your account or something is wrong with your account.
*) Sometimes due to improper disconnection your account gets ‘Poplocked’ so to get out of it either wait 20-30 minutes for it to time out or get somebody to shell into the mail server and stop the mail task that is running on the account.

0×800CCC05 NOT CONNECTED TO SERVER
0×800CCC0D CANT FIND HOST - Cannot locate server
Solution :
*) You may have typed wrong mail server in your account settings or the server may be down.
*) Reboot the computer and try again.
*) Data may not be moving across the network properly. Check DNS numbers, remove and then reinstall TCP/IP in Control Panel > Network.

0×800CCC0A MESSAGE DOWNLOAD INCOMPLETE
0×800CCC19 TIMEOUT
Solution :
*) This error may be due to corruption of pop3uidl file. Close the Internet connection and all programs. Search for the file ‘pop3uidl and delete it. Reconnect and it should work.

0×800CCC0F CONNECTION DROPPED
Solution :
*) may be modem or network cable was disconnected. If this happens frequently then try updating the modem drivers or adding an Init string.

0×800CCC10 INVALID ADDRESS - Address not known on server
Solution :
*) Check the spelling in the TO: field of the e-mail. Delete the old message from the Outbox and then try it again.

0×800CCC12 SOCKET READ ERROR - Unable to send Winsock request
Solution :
*) Remove the TCP/IP protocol and reinstall it. In windows, go into Network from the Control Panel. NOTE: You may need your Windows CD for this task!

0×800CCC16 INVALID ACCOUNT - User account not recognized
Solution :
*) Check the spelling of the account name and re-enter the password taking care to spell it correctly.

0×800CCC18 SICILY LOGON FAILED - Logon attempt failed
Solution :
*) Check account information, making sure account is not case sensitive, close Outlook Express, restart the computer and try reconnecting.
*) Create a different identity and see if it will logon on from this identity with the same information.
*) Make sure the account is still active with the ISP.

0×800CCC1A SECURE CONNECT FAILED - Unable to connect using SSL
Solution :
*) Your ISP may not require an SSL connection. Turn off SSL in the e-mail account properties and try again.

What is Web-Based Email ?

Web-Based Email is an Internet-based email system that lets you send and receive
email messages from a Web browser. All you need to use Web-Based Email is an Internet
connection and the Internet Explorer Web browser (Internet Explorer v5.5 or later).
How do I access my Web-Based Email account ?
You can log on to your Web-Based Email account from your Web browser by going
to the Web address for your account. The Web address is the same as your domain
name, except you replace “www” with “email”. For example, if your Web address
is “www.example.com”, your email address is “email.example.com”.

Hi All

Recently after revising hosting plans, RSHosting is now ready for the second round of adding powerfull tool’s / software’s that will enhance Reseller Hosting.

Have you ever came across a situation were your client is a complete novice and do not have any clue of how to build a website? And just because you could not help them they had canceled or switched to some other company offering a tool that can build their website in few clicks.

Think of a tool that will help your client’s to build their website with no pain of learning html tags / strugling with frontpage.

We’re highly considering offering the RV Site Builder (RVSkin product). This Site Builder can be accessed directly through cPanel and there is no hassle of adding users, publish settings, etc. Just simply click on the icon, build your site, and save!

Before we introduce this tool we’re very interested in what our customers have to say since you and your clients will be the ones using it on a day to day basis.

Please check the demo of RV Site Builder at — http://www.rvsitebuilder.com/index.p…ebuilder/demo/

Based on your response we would decide further on offering RV Site builder at minimal cost.

Waiting for your feed back …

RSHosting sheds its skin with introducing new features, increasing hosting resources limits, enhancing support with live chat, etc..

1) Disk space and Bandwidth increase for both US and UK reseller plans:

Disk space increased by 100%:
We have considered this requirement on the highest priority as I had already come across many clients who always claim that when it comes to resources RSHosting is quite expensive as compared to other hosting companies.
I am sure after receiving our excellent services and 10 min guaranteed support, people who know the term “quality service”, will not mind paying for the top notch service they receive.

But when I try to step into your shoes as a client, I would be happy if RSHosting would offer more disk space and bandwidth with the existing price structure. Hence, we have decided to increase the disk space limits for all the US and UK plans by 100%.

There won’t be any change in the existing prices, instead the disk space limits for the reseller plans will be doubled from their existing respective limits.

Bandwidth increase:
With the increase in disk space as mentioned above, we have also decided to increase the Monthly transfer limit (bandwidth) by 10 GB for the respective reseller plan as listed on http://rshosting.com/plans/
This applies for both US and UK reseller plans and the clients hosted on them.

Hence the new plans for US and UK servers with effective from April 1st, 2007 would be:
Plan 1:
Disk space: 2GB
Monthly transfer: 30GB
Maximum cPanel accounts: 40
Monthly charge for UK servers: £20
Monthly charge for US servers: $20
Setup fee: $0

Plan 2:
Disk space: 4GB
Monthly transfer: 45GB
Maximum cPanel accounts: 60
Monthly charge for UK servers: £30
Monthly charge for US servers: $30
Setup fee: $0

Plan 3:
Disk space: 6GB
Monthly transfer: 60GB
Maximum cPanel accounts: 80
Monthly charge for UK servers: £40
Monthly charge for US servers: $40
Setup fee: $0

Plan 4:
Disk space: 8GB
Monthly transfer: 75GB
Maximum cPanel accounts: 100
Monthly charge for UK servers: £50
Monthly charge for US servers: $50
Setup fee: $0

Plan 5:
Disk space: 10GB
Monthly transfer: 90GB
Maximum cPanel accounts: 120
Monthly charge for UK servers: £60
Monthly charge for US servers: $60
Setup fee: $0

Ref : http://www.rshosting.com/plans/

Q. How do I have disk space and bandwidth increased to new limits?
The procedure to avail the above increased disk space and bandwidth limit is simple. You just need to open a ticket on our helpdesk at http://rshosting.com/support and let us know your main reseller domain and the server it is hosted on.
As the resources increase is server wide for all clients, it might take us 24 - 72 hours for us to process your request. We would be grateful for your patience during this time.

——————————————————————————-

2) PHP5 and Ruby on Rails support available:
As per the recent poll, we observed PHP5 and Ruby on Rails to be the most awaited feature by the existing RSHosting clients. Hence we have installed PHP5 and Ruby on Rails on one of the US and UK servers.
If you wish to move a particular account from your reseller account to the server with PHP5 and Ruby on Rails support, you will need to open a ticket with us at http://rshosting.com/support.
We will then move the requested account to different server with php5 or ruby on rails support. The account migration process will not need any change w.r.t the nameservers and won’t experience any downtime during the migration process.

There won’t be any additional cost to avail the php5 and ruby on rails support for a limited number of accounts under your respective reseller account.
But if you wish to avail the php5 and ruby on rails support for your entire reseller account and all the accounts under it, there will be a nominal one time charge of $10 for US server clients and £10 for UK server clients. This process will need migration of all your accounts to the respective US or UK servers and you will need to change the nameserver IP’s in this case. Downtime may vary w.r.t to the nameserver IP propagation in this case.

Considering the number of requests that we expect to avail php5 and ruby on rails support, we will be processing them one by one and will inform you in your ticket about the approximate time when the features will be enabled. We hope you to be patient in this migration process.

——————————————————————————-

3) Remote Backups available:
We have introduced remote backup services based on rsync technology for all servers.
Rsync greatly improves efficiency when compared to traditional remote backup methods. By synchronizing only those files that have changed since the last backup, using rsync results in large bandwidth savings. When combined with on-the-fly compression, performing daily rsync backup can result in less data transfer than it would take to perform two backups using the .tar.gz method in a given month.

Listed below are few of the features for Remote Backup services:
» Automated Daily, Weekly & Monthly backup using rsync.
» SSH encryption - Encrypted data transfer for Security.
» On-the-fly compression
» Easy restore incase of data loss or failure of hosting account.
» FTP access
» Unlimited Bandwidth
» Instant Setup
» No setup fee

You can purchase the Remote Backup services as per the following remote backup packages:
a) RB1 - 10GB - $5/month
b) RB2 - 100GB - $20/month
c) RB3 - 1TB - $150/month

——————————————————————————-

4) Live Chat Support available:
We have introduced Live Chat support feature from 8.00hrs GMT to 17.00hrs GMT.

As a primary stage we have introduced this feature for Sales and Billing support for limited 9hr shift. But soon we will be offering 24/7 technical and sales live chat and cover it 365 days a year.

You can chat with our Sales and Billing representative by accessing the URL http://rshosting.com/support

——————————————————————————-

5) Free Enom Reseller accounts:
We are now offering FREE Enom reseller accounts to all our existing resellers and the new signups. You will get a life time Enom reseller account with the help of which you will be able to sell your customers domains, transfer domains, and even setup a whois form to run off your site allowing for real time whois checks to see if the domain is available.

Your price on domains will be $7.95 a year.

Opening an Enom account from Enom.com would charge you $500 as startup fee, and your rate for domains would be $8.95 a year.

But we have now started offering one Enom reseller account per reseller client on RSHosting.com for free!!
You can also keep the Enom reseller account with you, should decide to leave our hosting.

To avail the FREE Enom reseller account, you must first signup with any of our reseller hosting packages mentioned at http://www.rshosting.com/plans/ and then contact our Sales Department at http://www.rshosting.com/support/

——————————————————————————-

For any further questions, doubts or any difficulties you are most welcome to contact us at http://rshosting.com/support and we will get back to you at the earliest.

Thank you.