Nov 23

The MySQL® server is currently offline

While going to cPanel >> Mysql database I was getting following error:

Error!

The MySQL® server is currently offline


contact@webhostingsupport.info

Post to Twitter

On checking server side I found that mysql service is online and still cPanel was throwing the error.

FIX:

This issue is mainly caused when mysql root password is not set on the server.
To fix the issue Login to WHM as root and go to SQL Services >> MySQL Root Password and reset the password.

 

Now try creating Mysql database from cPanel.

 

 


contact@webhostingsupport.info

Post to Twitter

Nov 14

Restart Ruby On Rails service.

How To Restart Ruby On Rails for a specific Web Application ?

1) Go to the Document Root of the rails application and execute following commands.

 

root@server[~] cd /home/username

root@server[~] cd rails_apps

root@server[~] cd demo (Application name)

root@server[~] mongrel_rails mongrel::restart


contact@webhostingsupport.info

Post to Twitter

Nov 03

MySQLCouldn’t find MySQL manager

Restarting mysql was giving following error


[root@server]# /etc/init.d/mysql restart
MySQL manager or server PID file could not be found! [FAILED] Starting MySQLCouldn't find MySQL manager (/var/lib/bin/mysql) or server (/var/lib/bin/mysqld_safe)
FIX:
Comment out or remove the basedir directive from /etc/my.cnf file 

[mysql.server ]
server=mysql
#basedir=/var/lib


Then restart mysql

That's all :) 

contact@webhostingsupport.info

Post to Twitter

Nov 01

sample python script

You can use following python script to check whether python is running correctly on your server.

1) Create a script with extension py say sample.py and add following code to it.

 

#!/usr/bin/python

import cgi

print("<Content-Type: text/html\n")

print("ok")

 

2) Access script in the browser.

http://www.your-site-name.com/sample.py

3) Output of this script should be “OK” If you see complete code in the browser then this indicate that code is not being compiled by python. to fix this create a .htaccess file and add following code.

AddHandler cgi-script .cgi .py .pl

 

 


contact@webhostingsupport.info

Post to Twitter

Oct 24

Install shoutcast

SHOUTcast is a application for streaming media over the Internet.

Following are the steps to install SHOUTCAST.

1) SSH to the server as root

2) Add user and password for shoutcast.

 

# adduser shoutcast
# passwd shoutcast

3) Now ssh to shoutcast user ans do following.

# wget ftp://ftp.skynet.be/mirror1/tucows.skynet.be/linux/files/shoutcast-1-9-2-linux-glibc6.tar.gz

# tar -zxvf shoutcast-1-9-2-linux-glibc6.tar.gz
# rm -rf shoutcast-1-9-2-linux-glibc6.tar.gz
# mv shoutcast-1-9-2-linux-glibc6 shoutcast
# cd shoutcast

4) Configuring shoutcas for MaxUser, Password ans Port.

# vi pico sc_serv.conf OR nano sc_serv.conf
and configure settings corresponding to
MaxUser
Password
PortBase

5) uncomment AdminPassword and set an admin password of your choice. this password can be used to access shoutcast admin panel.

6) Save the file and start shoutcast.

./sc_serv sc_serv.conf


contact@webhostingsupport.info

Post to Twitter

Older posts «

» Newer posts