A client opened a ticket since they were receiving the following error when trying to install a script via fantasticrap…I mean fantastico.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘linuxnoo’@'localhost’ (using password: YES) in /tmp/cpanel_phpengine.1304688239.24500MvupN_eQWd on line 1642
Access denied for user ‘linuxnoo’@'localhost’ (using password: YES)

This issue is caused by a mismatch in the cPanel password and the MySQL users password. You can verify this in SSH by running the following.

mysql> use mysql;
mysql> select user,password,password('YourPassword') from user where user='YourCpanelUser';
+----------+-----------------------------+-----------------------+
| user     | password  | password('--')          |
+----------+-----------------------------+-----------------------+
| linuxnoo | *E6.....3F | *B6.....3A |
+----------+-----------------------------+-----------------------+
2 rows in set (0.00 sec)

As you can see above, the two password fields do not match so we need to update this.

mysql> update user set password=password('bNEQL13dvJ') where user='linuxnoo' limit 2;
mysql> select user,password,password('bNEQL13dvJ') from user where user='linuxnoo';
+----------+-------------------------------------------+-------------------------------------------+
| user     | password                                  | password('bNEQL13dvJ')                    |
+----------+-------------------------------------------+-------------------------------------------+
| linuxnoo | *E6D911C8973EEDDA0CE0618EFB493E704776DB3F | *E6D911C8973EEDDA0CE0618EFB493E704776DB3F |
+----------+-------------------------------------------+-------------------------------------------+
2 rows in set (0.00 sec)

After the password update try to install again and it should work just fine.

Long time no post…I know. I recently had to do a cpnginx install since our 3rd level team was a little short at the time. Nonetheless, it’s a pretty straight forward install.

root@grumpy [/]# cd /usr/local/src
root@grumpy [/usr/local/src]# wget http://nginxcp.com/latest/nginxadmin.tar
root@grumpy [/usr/local/src]# tar xf nginxadmin.tar
root@grumpy [/usr/local/src]# cd publicnginx
root@grumpy [/usr/local/src/publicnginx]# ./nginxinstaller install

The uninstall is just as simple.

root@grumpy [/]# cd /usr/local/src
root@grumpy [/usr/local/src]# wget http://nginxcp.com/latest/nginxadmin.tar
root@grumpy [/usr/local/src]# tar xf nginxadmin.tar
root@grumpy [/usr/local/src]# cd publicnginx
root@grumpy [/usr/local/src/publicnginx]# ./nginxinstaller uninstall

Unfortunately things didn’t go smooth on the first install, and I ran into a few errors which were caused by an out of date python install.

Did you know that if you have cPanel/WHM on your server, you also have a bunch of serverside commands that you can use?  These are good for advanced users, or the people who prefer to manage their servers in a hurry via the command line rather than waiting for a web interface to load.

Nearly everything that you can do in the WHM backend can be performed via command line.  These scripts are located in your server’s /scripts/ directory.  Only use scripts that have been verified by cPanel, or that you know yourself are safe as an unsafe script may damage your server.

Long list of scripts after the break…

Just got this e-mail from cPanel ^_^

We are pleased to announce the release of cPanel & WHM 11.30

This release is available immediately in the EDGE and CURRENT release tier.  cPanel & WHM 11.30 will soon be available in all public release tiers.

This version includes:

• Over 600 maintenance and bug fixes
• Over 30 feature improvements and additions
• Over 150 product optimizations for performance and usability

For a full list of changes, please see our product change logs:

http://go.cpanel.net/changelog

In order to receive immediate notification of build availability, including updates for individual release tiers, please subscribe to our Releases Mailing List here:

http://go.cpanel.net/releaselist

To report concerns or issues related to your cPanel & WHM system, please contact our support team:

http://www.cpanel.net/support.html

For general discussions related to cPanel & WHM, please visit the official cPanel forums:

http://forums.cpanel.net/

cPanel is also very excited to announce our first ever formal partnership with CloudLinux.

To more effectively serve your needs, licensing for cPanel and CloudLinux can be done through one location.  We’re also offering direct support for CloudLinux in the event you’re in need of help.  By unifying our licensing systems and integrating direct support, we’ve made it easy for you to use cPanel with Cloudlinux.

Curious about how cPanel with CloudLinux will help you better serve your customers?  Visit http://go.cpanel.net/cl or contact cs@cpanel.net for more information.

Installing/upgrading perl is a pretty straight forward task and is necessary for cPanel to function properly.

root@ohhai [~]# wget http://layer1.cpanel.net/perl588installer.tar.gz
root@ohhai [~]# tar -xvzf perl588installer.tar.gz
root@ohhai [~]# cd perl588installer
root@ohhai [~]# ./install

If I remember correctly, the install takes 25-30 minutes to complete depending on your server setup.

I’ve finally found some time to start working on this site again. Changed the theme, made some entries to the /var/ section of the site, added twittergrid, and working on a few more cheatsheets. Check back for some more updates.

Added a list of cheat sheets that I’ve posted to the nav bar for easier searching. I will continue to update the list as I post more.

Came across this issue at work where a client was receiving this message when trying to enter webmail, even though the e-mail account and cPanel account were not over quota.

Internal Server Error

User ‘useraccount’ is over quota.

This happens when the users ‘overquota’ status is cached and can be fixed by removing the users folder located at the following.

/var/cpanel/overquota/username

I came across this nice cheatsheet that lists all of the cPanel ports and what services they work with, so I figured I would post it up here for my own personal use, if no one else needs it.

I had a client contact me earlier this morning because one of their clients was receiving the following error on their VPS when trying to run OpenVPN.

Note: Cannot open TUN/TAP dev /dev/net/tun: Permission denied (errno=13)
Note: Attempting fallback to kernel 2.2 TUN/TAP interface
Cannot open TUN/TAP dev /dev/tun0: No such file or directory (errno=2)

I’ve never run into this issue before, but was able to find an awesome tutorial on the OpenVZ website.

First, make sure the tun module has been already loaded on the hardware node:

# lsmod | grep tun

If it is not there, use the following command to load tun module:

# modprobe tun

To make sure that tun module will be automatically loaded on every reboot you can also add it or into /etc/modules.conf (on RHEL see /etc/sysconfig/modules/ directory) or into /etc/sysconfig/vz-scripts/VEID.mount.

echo 'modprobe tun' /etc/sysconfig/vz-scripts/VEID.mount

Allow your container to use the tun/tap device by running the following commands on the host node:

vzctl set VEID --devices c:10:200:rw --save
vzctl set VEID --capability net_admin:on --save

And create the character device file inside the container (execute the following on the host node):

vzctl exec VEID mkdir -p /dev/net
vzctl exec VEID mknod /dev/net/tun c 10 200
vzctl exec VEID chmod 600 /dev/net/tun

Enter cat /dev/net/tun to test whether the TUN/TAP device is available:

• If you receive the message cat: /dev/net/tun: File descriptor in bad state your TUN/TAP device is ready for use.
• If you receive the message cat: /dev/net/tun: No such device the TUN/TAP device was not successfully created.