/usr/local/cpanel/base/3rdparty/roundcube/skins/default/images/roundcube_logo.png
Craftysyntax3.2.0 error
[SELECT `session_data` FROM `livehelp_sessions` WHERE `session_id` = ‘c2991aff8b77cff7fbee9675cdb8408ee’ AND `expires` > 4536021092] ( 1146 : Table ‘testusr_newtable.livehelp_sessions’ doesn’t exist )
SOLUTION :
Login to the specified database >>
CREATE TABLE `livehelp_sessions` ( `session_id` varchar(100) NOT NULL default ”, `session_data` text NOT NULL, `expires` int(11) NOT NULL default ‘0’, PRIMARY KEY (`session_id`) ) ENGINE=MyISAM;
WordPress Permalink shows blankpage
Solution :
Open wp-admin/includes/misc.php and change the line in RED as indicated below
function got_mod_rewrite() {
//$got_rewrite = apache_mod_loaded('mod_rewrite', true); //old line with false negative;
$got_rewrite = true;//force the response to true as we know mod_rewite is installed;
return apply_filters('got_rewrite', $got_rewrite); }
Find the wordpress theme from database
select * from wp_options where `option_name` = ‘siteurl';
select * from wp_options where `option_name` = ‘home';
SELECT * FROM `wp_options` WHERE `option_name` = ‘current_theme';
UPDATE `user_wrdp1`.`wp_users` SET `user_pass` = MD5( ‘12345678’ ) WHERE `wp_users`.`ID` =1;
UPDATE `wp_users` SET `user_pass` = MD5( ‘12345678’ ) WHERE `wp_users`.`ID` =1;
Restarting network overwrites /etc/resolv.conf
Solution :
Open the below file and add NM_CONTROLLED=no to the bottom
vi /etc/sysconfig/network-scripts/ifcfg-eth0
NM_CONTROLLED=no
How to get joomla database login details
How to get joomla database login details from configuration.php
Database name :
grep mosConfig_db configuration.php
grep mosConfig_user configuration.php
grep mosConfig_password configuration.php
Fatal error: Call to undefined method mosMenu::mosDBTable()
This mostly happens after updating php to 5.3.X
You need to edit file named : database.php which will be under includes folder and add
EG : /home/username/public_html/includes/database.php
===========================================================================
/** @var mosDatabase Database connector */
var $_db = null;
// ADD THIS FUNCTION….
function mosDBTable($table=”, $keyname=’id’, $db=”) {
$this->mosDBAbstractRow ($table, $keyname, $db);
}
===========================================================================
If it still shows a warning in some lines like : /home/username/public_html/includes/Cache/Lite/Function.php
Edit the error line mentioned and add that as below :
line 100:
$result = call_user_func_array($target, $arguments);
to
$result = call_user_func_array($target, &$arguments);
Troubleshoot spamming in qmail server
How to get the mail statistics :
[root@ qmail]# /var/qmail/bin/qmail-qstat
messages in queue: 23024
messages in queue but not yet preprocessed: 0
[root@ qmail]#
The postgresql server is currently offline cpanel
Reset the postgress sql password from WHM.
Script to email load average when it goes above a particular threshold
load=`uptime | awk ‘{print $(NF-2)}’ | cut -d. -f1`
if [ $load -gt 4 ]
then
echo `uptime` | mail -s “server load is $load” [email protected]
fi
YUM command
yum update
yum-complete-transaction
[ yum-complete-transaction –cleanup ]
yum check-updates