You may also get asked for a username/password and when you put in the cPanel account information you get the Fatal error.
From the looks of it the cPanel accounts user has lost connection to the MySQL or be it that it does not know what the username/password is for the account to access MySQL. There is a simple fix.
Log into WHM
SQL Services
Change MySQL DB Owner Password
Select the User from the drop down list
Either put in the cPanel User’s password or Generate a new one
Change Password.
Done.
Log back in as the cPanel User and you should have access via phpMyAdmin again.
Comments and feed back welcome
Saturday, December 11, 2010
Thursday, December 9, 2010
Request exceeded the limit of 10 internal redirects due to probable configuration error. Use ‘LimitInternalRecursion’ to increase the limit if necessa
Fix for infinite loops
An error message related to this isRequest exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.or you may seeRequest exceeded the limit,probable configuration error,Use 'LogLevel debug' to get a backtrace, orUse 'LimitInternalRecursion' to increase the limit if necessary
RewriteCond %{ENV:REDIRECT_STATUS} 200
RewriteRule .* - [L]
An error message related to this isRequest exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.or you may seeRequest exceeded the limit,probable configuration error,Use 'LogLevel debug' to get a backtrace, orUse 'LimitInternalRecursion' to increase the limit if necessary
RewriteCond %{ENV:REDIRECT_STATUS} 200
RewriteRule .* - [L]
Wednesday, December 1, 2010
Plesk failed to start due to drwebd service
service psa stopall
service psa start
OR
Running plesk without drweb.
In /etc/init.d/psa
comment out the line,
service_after_psa="drwebd"
then service psa stopall
service psa start
it should start without drweb
service psa start
OR
Running plesk without drweb.
In /etc/init.d/psa
comment out the line,
service_after_psa="drwebd"
then service psa stopall
service psa start
it should start without drweb
Monday, November 22, 2010
How to increase MaxClients in Apach2
You can add the following to your httpd.conf file
==
ServerLimit 1500
MaxClients 1500
==
Usually ServerLimit value will be absent and the default value is 256.
Thank you
==
ServerLimit 1500
MaxClients 1500
==
Usually ServerLimit value will be absent and the default value is 256.
Thank you
Monday, October 4, 2010
MySQL time zone different from system time zone
In some situations, the system time zone will be different than the one in MySQL, even though MySQL is set to use the system time zone. This normally means that a user has changed the system time zone, but they haven't started MySQL to cause it to change as well.
$ date
Sun Jul 1 11:32:56 UTC 2007
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | CDT |
| time_zone | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)
If you find yourself in this situation, just restart MySQL and the situation should be fixed:
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | UTC |
| time_zone | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)
$ date
Sun Jul 1 11:32:56 UTC 2007
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | CDT |
| time_zone | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)
If you find yourself in this situation, just restart MySQL and the situation should be fixed:
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | UTC |
| time_zone | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)
Thursday, September 30, 2010
Installing zend optimizer 3.3 in cpanel
Run this command
/scripts/installzendopt 3.3.0
[~]# /scripts/installzendopt 3.3.0
Installing Zendopt
Determining PHP version
Installing Zend Optimizer binary
Activating Zend Optimizer in /usr/local/lib/php.ini
Zend Optimizer activated
[~]# php -v
PHP 5.2.13 (cli) (built: Jul 14 2010 18:00:25)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
with the ionCube PHP Loader v3.3.20, Copyright (c) 2002-2010, by ionCube Ltd., and
with Zend Optimizer v3.3.9, Copyright (c) 1998-2009, by Zend Technologies
/scripts/installzendopt 3.3.0
[~]# /scripts/installzendopt 3.3.0
Installing Zendopt
Determining PHP version
Installing Zend Optimizer binary
Activating Zend Optimizer in /usr/local/lib/php.ini
Zend Optimizer activated
[~]# php -v
PHP 5.2.13 (cli) (built: Jul 14 2010 18:00:25)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
with the ionCube PHP Loader v3.3.20, Copyright (c) 2002-2010, by ionCube Ltd., and
with Zend Optimizer v3.3.9, Copyright (c) 1998-2009, by Zend Technologies
Tuesday, September 7, 2010
Changing cPanel servers main IP or full IP address pool
Changing main shared server IP.
/etc/sysconfig/network-scripts/ifcfg-eth0
/etc/sysconfig/network
/etc/hosts
Then add the cpanel license to the new IP.
Update cPanel configurations.
replace $oldip $newip -- /var/cpanel/mainip
replace $oldip $newip -- /var/cpanel/userdata/*/*
replace $oldip $newip -- /var/named/*.db
replace $oldip $newip -- /etc/*
service named restart
/scripts/rebuildhttpconf
If you are adding new block IP's
1) Add the IP through the cpanel.
2) /etc/init.d/ipaliases restart
/etc/sysconfig/network-scripts/ifcfg-eth0
/etc/sysconfig/network
/etc/hosts
Then add the cpanel license to the new IP.
Update cPanel configurations.
replace $oldip $newip -- /var/cpanel/mainip
replace $oldip $newip -- /var/cpanel/userdata/*/*
replace $oldip $newip -- /var/named/*.db
replace $oldip $newip -- /etc/*
service named restart
/scripts/rebuildhttpconf
If you are adding new block IP's
1) Add the IP through the cpanel.
2) /etc/init.d/ipaliases restart
Subscribe to:
Posts (Atom)