You know you’re using the right password, so why can’t you log into Webmail? One common issue users see on courier-IMAP systems when trying to log into Horde is: Notice: (null)(): Retrying LOGIN authentication after AUTHENTICATE LOGIN failed (errflg=1) in Unknown on line 0 Notice: (null)(): Retrying LOGIN authentication after AUTHENTICATE LOGIN failed (errflg=1) in… Continue reading Webmail Authentication Fails – cPanel
Useful MySQL Commands
These command assume you are running a cPanel MySQL installation and logged into the server as a root user where you can do a mysql -u root without having to specify a password. Import a database: mysql -u root db_name < file.sql Dump a Database (with special characters): mysqldump -Q –add-drop-table db_name > file.sql Dump… Continue reading Useful MySQL Commands
MySQL Root Login Failure
When trying to log into the MySQL shell as root you get an access denied error. To fix: Add this line to /etc/my.cnf and restart MySQL: skip-grant-tables Follow these steps to reset the MySQL root password: mysql -u root mysql> FLUSH PRIVILEGES; mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY ‘password’ WITH GRANT… Continue reading MySQL Root Login Failure
Missing MySQL Socket (mysql.sock) Error
If you get some variation of the error below: error: ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ You need to recreate the MySQL socket symlink in /tmp: ln -s /var/lib/mysql/mysql.sock /tmp/ If you have magically disappearing mysql.sock file, it could point to a memory issue or disk space issue on the /tmp partition.
Missing libmysqlclient.so.14 Error
This is a common error when dealing with command line software that uses MySQL: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory Usually this simple command will correct the problem: cp /usr/lib/mysql/libmysqlclient.so.14 /usr/lib
Quick PEAR Usage Tutorial
To find out what packages are installed, you can run a list: pear list-all To update the PEAR repositories: pear channel-update pear.php.net To install a package, for instance, XML_RPC: pear download XML_RPC pear install XML_RPC Note on installations: you don’t always have to download the module first, but, on dedicated server environments where /tmp is… Continue reading Quick PEAR Usage Tutorial
Install Ruby on Rails with cPanel
Packaged in with cPanel 11 is a new Ruby installer that will seamlessly install and integrate Ruby in your system and cPanel. To install, simple run this command: /scripts/installruby Once this is installed, you can test that it is functional by running: ruby -v If you’re more old-fashioned or are running a version of cPanel… Continue reading Install Ruby on Rails with cPanel
Installing suPHP on cPanel
I wrote this tutorial a while back and figured it would be good to post because suPHP is growing more popular as an alternative to phpSuExec. The instructions assume that you are on a Linux cPanel server and are familiar with how to install PHP, but do not want to use EasyApache’s suPHP installer in… Continue reading Installing suPHP on cPanel
Installing Ruby on cPanel
Here’s how to install Ruby on Rails on a cPanel system: Update: These instructions were modified for Ruby 1.8.6, since 1.8.5 is no longer available! First install Ruby: wget ftp://ftp.ruby-lang.org/pub/ruby/1.8/ruby-1.8.6.tar.gz tar -xvzf ruby-1.8.6.tar.gz cd ruby-1.8.6 ./configure make make install Now, install the Gems and Rails: wget http://rubyforge.org/frs/download.php/11289/rubygems-0.9.0.tgz tar -xvzf rubygems-0.9.0.tgz cd rubygems-0.9.0 ruby setup.rb gem… Continue reading Installing Ruby on cPanel
cPanel PEAR Installer Errors
A new feature in cPanel 11/x3 is the PEAR module installer that allows users to install their own PEAR modules locally in their account. I’ve heard that a lot of servers with existing PHP installations have had problems getting this to work, and instead are prompted with this error: X-Powered-By: PHP/5.2.3 Content-type: text/html Parse error:… Continue reading cPanel PEAR Installer Errors