To install the phpBB on addon domains perform the following steps.
1) Install the phpBB script to any top level directory under public_html
2) change the document root of the addon domain to the phpBB path
eg : /home/steve/public_html/phpbb in httpd.conf file
3) change the script path variable of the php_config table of the phpbb database.
If the script is installed on the directory phpbb under the steve directory it will have the path /phpbb/ change it to /.
(This now need to point to the document root of the domain as the script is installed on the document root ).
a) mysql > use steve_phpbb1;
b) mysql > update phpbb_config set script_path=’/’ where script_path=’\phpbb\’;
Cpanel scripts or addon software installations
To change the admin password of php nuke you can do the following :
1) First determine the database of php_nuke you can find this by the config.php file ex : /home/steve/nuke/config.php
2) Go to the mysql prompt by issuing the mysql command
a) use steve_nuke;
b) update nuke_authors set pwd=md5(’qwe123′) where aid=’admin’;
This will reset the admin password of the nuke to qwe123 where the admin user name is ‘admin’.
Cpanel scripts or addon software installations
To create any md5 encrypted password all we need to do is pass on the password with the “echo -n” command to the md5sum like given below.
[rsa@rsa4 ~]$ echo -n password | md5sum
5f4dcc3b5aa765d61d8327deb882cf99 -
The below line shows the md5 encrypted password for the text “password”.
Cpanel scripts or addon software installations
We can reset the admin password for advanced guest book go through the following
1) First check the guest book database name in the configuration file of Advanced Guset Book at the folloeing
/home/username/public_html/guestbook/admin/config.inc.php
2) To retrive the guestbook password select the guest book db in PHPMyAdmin and the table book_auth. While browsing it will show you the user name.
run this sql command to change the password at the SQL query box in PHPMyAdmin
update book_auth set password=PASSWORD(’pass’) where username=’user’;
where ‘pass’ is your password and ‘user’ is the user name.
Cpanel scripts or addon software installations
You can reset your Joomla administrator’s password through the script’s
MySQL Database.
The most convenient way to manage the database is through the phpMyAdmin
tool. Go to your cPanel and click on phpMyAdmin in the Databases box.
Once in the phpMyAdmin select the Joomla’s database from the drop-down
menu at left. The page will refresh and the database’s tables will be
displayed on it. Open the SQL tab (look at the top navigation bar).
In the text field write the following SQL query:
UPDATE `jos_users` SET `password` = MD5( ‘new_password’ ) WHERE
`jos_users`.`username` = “admin_username” LIMIT 1 ;
“new_password” - replace this with the new password you wish to use.
“admin_username” - replace this with the username the password should be
updated for.
Once you are ready, click on the GO button to submit the query. If
everything goes fine without errors, you should be able to login to Joomla
with the new password.
Cpanel scripts or addon software installations
Please go through the following steps to reset any password for wordpress blog from the mysql prompt. Make s
1). Get an MD5 hash of your password. (This should be done from the shell prompt not from mysql prompt)
On Unix: echo -n <password> | md5sum
2). use (name-of-database);
3). show tables;
4). SELECT ID, user_login, user_pass FROM (name-of-table-you-found);
5). UPDATE (name-of-table-you-found) SET user_pass=”(MD5-string-you-made)” WHERE ID = (id#-of-account-you-are-reseting-password-for);
6). And finally confirm that the password has been changed with the command given below
SELECT ID, user_login, user_pass FROM (name-of-table-you-found);
Cpanel scripts or addon software installations
Generally from cpanel mambo is installed under any folder of your root directory and accessed using that folder. When customer wants to directly access Mambo from his domain ‘example.com’ all you need to do is just follow the steps given below.
First of all take the backup of the existing public_html folder and create a new public_html folder.
1. From Cpanel install mambo specifying sub folder for example ‘mambo’ which can be accessed using the link below.
http://example.com/mambo
2. Copy all the files under the ‘mambo’ folder to the public_html folder and delete the folder ‘mambo’.
3. Now you need to edit the configuration.php file under ‘public_html’ folder as specified below.
4. Edit the line
/home/username/public_html/mambo to /home/username/public_html.
5. Also edit the line
$mosConfig_live_site http://domain.com/mambo to http://domain.com.
Just cut out the “mambo” 
Then save the file and you are ready to go. You can access Mambo directly from the link
http://example.com/
Note: It is recommended to take the confirmation before implementing this procedure
Cpanel scripts or addon software installations
If any of the client requested us to reset the Password of the phpBB forum, then we need to follow the steps to reset the password.
1)Login to the client’s account through shell and find out the database name of the phpbb forum.
#vi ~username/public_html/phpBB/config.php
2)You can find the database like username_phpbb1
3)mysql username_phpbb1
4)You can see all the tables of the database(username_phpbb1) using the following command at mysql prompt.
mysql> show tables;
5)View all the fields in the phpbb_users table using the following command.
mysql> desc phpbb_users;
6)You can see all the users of the phpBB forum using the command.
mysql> select * from phpbb_users;
7)Find out the Admin account using any of the fields like user_email or user_id or username. Here, I took the mail ID to find the admin account.
mysql> select * from phpbb_users where user_email=’admin@domainname’\G;
HINT:Most of the cases the admin user_id is either 1 or 2.
8)You can reset the encrypted password using the following command.
mysql> update phpbb_users set user_password=md5(’password’) where user_id=1;
Cpanel scripts or addon software installations
I have come accross an excellent list of all the cpanel /scripts also with a description. I have been looking for this quite a while and am wondering whether mods could make it a sticky for people looking in the future?
Common cPanel /Scripts
Install Zend Optimizer /scripts/installzendopt
Hostname A Entry Missing! /scripts/fixndc then restart bind and apache
Install Cron on New Server /scripts/installrpm anacron vixie-cron ; /etc/rc.d/init.d/crond start
Bandwidth issues /scripts/cleanbw
/scripts/fixwebalizer (To fix problem in webalizer that stop updating stats)
/scripts/fixcommonproblems
/scripts/fixeverything
Fixing Mail List MailMan /usr/local/cpanel/bin/convertmailman2
Reinstall MailMan /scripts/reinstallmailman
Fix Permissions on accounts: /scripts/fixhome
Edit mySQL conf file: pico /etc/my.cnf
Edit php.ini: pico /usr/local/lib/php.ini
Edit Apache Conf: pico /etc/httpd/conf/httpd.conf
Checking Real Time Top Processes Login to SSH and run: top
Run cpanel backup /scripts/cpbackup
To try and fix domain controller: /scripts/fixndc
Quotas /scripts/initquotas - takes a while to run
/scripts/resetquotas
/scripts/fixquotas - takes a while to run
/scripts/adddns Add a Dns Entry
/scripts/addfpmail Install Frontpage Mail Exts
/scripts/addservlets Add JavaServlets to an account (jsp plugin required)
/scripts/adduser Add a User
/scripts/admin Run WHM Lite
/scripts/apachelimits Add Rlimits (cpu and mem limits) to apache.
/scripts/dnstransfer Resync with a master DNS Server
/scripts/editquota Edit A User’s Quota
/scripts/finddev Search For Trojans in /dev
/scripts/findtrojans Locate Trojan Horses
Suggest Usage
/scripts/findtrojans > /var/log/trojans
/scripts/fixtrojans /var/log/trojans
/scripts/fixcartwithsuexec Make Interchange work with suexec
/scripts/fixinterchange Fix Most Problems with Interchange
/scripts/fixtrojans Run on a trojans horse file created by findtrojans to remove them
/scripts/fixwebalizer Run this if a user’s stats stop working
/scripts/fixvaliases Fix a broken valias file
/scripts/hdparamify Turn on DMA and 32bit IDE hard drive access (once per boot)
/scripts/initquotas Re-scan quotas. Usually fixes Disk space display problems
/scripts/initsuexec Turn on SUEXEC (probably a bad idea)
/scripts/installzendopt Fetch + Install Zend Optimizer
/scripts/ipusage Display Ipusage Report
/scripts/killacct Terminate an Account
/scripts/killbadrpms Delete “Security Problem Infested RPMS”
/scripts/mailperm Fix Various Mail Permission Problems
/scripts/mailtroubleshoot Attempt to Troubleshoot a Mail Problem
/scripts/mysqlpasswd Change a Mysql Password
/scripts/quicksecure Kill Potential Security Problem Services
/scripts/rebuildippool Rebuild Ip Address Pool
/scripts/remdefssl Delete Nasty SSL entry in apache default httpd.conf
/scripts/restartsrv Restart a Service (valid services: httpd,proftpd,exim,sshd,cppop,bind,mysql)
/scripts/rpmup Syncup Security Updates from RedHat/Mandrake
/scripts/runlogsnow Force a webalizer/analog update.
/scripts/secureit Remove non-important suid binaries
/scripts/setupfp4 Install Frontpage 4+ on an account.
/scripts/simpleps Return a Simple process list. Useful for finding where cgi scripts are running from.
/scripts/suspendacct Suspend an account
/scripts/sysup Syncup Cpanel RPM Updates
/scripts/unblockip Unblock an IP
/scripts/unsuspendacct UnSuspend an account
/scripts/upcp Update Cpanel
/scripts/updatenow Update /scripts
/scripts/wwwacct Create a New Account
/scripts/runweblogs account username for awstats to run manually
Sometimes such behavior of apache/httpd (taking more and more memory until it dies or crashes the server) can be caused by corrupted MySQL database. Try to do the following:
1) Kill the mysql server
/etc/rc.d/init.d/mysql stop
2) Repair all SQL databases:
myisamchk -r /var/lib/mysql/*/*.MYI
3) Start mysql again:
/etc/rc.d/init.d/mysql start
Cpanel scripts or addon software installations
If /scripts/updatenow doen’t work and says it should be updated using /scripts/upcp, then you just run the command /scripts/updatenow.orig and then run the command /scripts/updatenow for updating the scripts.
Cpanel scripts or addon software installations