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.

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 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.

A fantastico installation is pretty straight forward. First thing you need to do is obtain a Fantastico license from Netenburg.

One of the most common issues when installing fantastico is a buggy wget install on the server, so a working wget version will need to be installed. Another common issue is cPanels internal php may break, but we will discuss the fix to that later on.

I came across an issue for the first time where the cPanel icon was missing in the list accounts section. After digging around WHM, I found where the function was disabled.

• Log into WHM

• Select “Tweak Settings”

• Uncheck the box next to “Disable login with root or reseller password into the users’ cPanel interface. Also disable switch account dropdown in themes with switch account feature”

• Click save

After hitting save, you can go back to the list account section and the cPanel icon will be back.

Upgrading MySQL versions is a quick and easy process, not much work involved. Always be sure to make a backup before you start though, just in case the upgrade fails or some other unforeseen issue arises.

cp -Rpf /var/lib/mysql /var/lib/mysql.BAK
Login to WHM –> Tweak Settings –> MySQL -> 5.0  and Save settings
/scripts/mysqlup –force
/scripts/perlinstaller –force Bundle::DBD::mysql
/scripts/realperlinstaller –force DBD::mysql
Recompile PHP

You’re done