Plesk 11.x / Linux :: Constant Unable To Connect To Database While Upgrading / Repairing
Aug 11, 2014
I had Plesk 10 installed on my openSUSE system (was a low version, maybe 11 or less) and then decided to upgrade to 11.5. So I did distribution upgrades to openSUSE 12.3 and everything went smoothly, except for some services like mysql and php. So I used Plesk autoinstaller to fix the php error and edited an outdated line in mysql configuration and both services ran smoothly!
Then I downloaded Plesk autoinstaller and ran the autoinstaller, but was surprised by this error message:
===> Checking for previous installation ... found.
ERR (3) [panel]: Error during product key mode determination, details: Unable to connect to database: ; trace: #0 /usr/local/psa/admin/plib/functions.php(2821): isPpaKeyRequired()
#1 /usr/local/psa/admin/plib/common_func.php3(11): require_once('/usr/local/psa/...')
#2 /usr/local/psa/admin/plib/api-common/cu.php(5): require_once('/usr/local/psa/...')
#3 /usr/local/psa/admin/sbin/httpdmng(8): include_once('/usr/local/psa/...')
#4 (main)
Unable to connect to database:
- My MySQL version is: 5.5.33 openSUSE package
- I did run mysql_upgrade with my admin username and password (password from: /etc/psa/.psa.shadow) and it worked successfully and fixed all of the errors, I did so after running the auto installer first, but then ran the installer again and the problem was still there
- I can access my web page, but it still doesn't connect to MySQL either.
I believe this is a problem with MySQL, but how can I make sure or detect what exactly the problem is
View 3 Replies
ADVERTISEMENT
Nov 9, 2013
when I try to access to my plesk I obtain:
ERROR: PleskFatalException: Unable to connect to database: Access denied for user 'admin'@'localhost' to database 'psa' (auth.php:142).
If I restart with ssh /etc/init.d/psa start and I check plesk_11.5.30_reset_instance_data.log
I note: ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'.
View 10 Replies
View Related
Jul 18, 2014
After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.
The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !
Though, remote connections are allowed from any host in the settings.
View 3 Replies
View Related
Aug 16, 2014
I recently upgraded to 12.0.18 and I am using Roundcube 1.0 from the panel. I read that the "Unable to connect to sieve serve" problem would be solved in version 12.It seems not. What to do?
View 12 Replies
View Related
May 30, 2015
I have the problem that I can't connect to my mailserver tru the mail client (Webmail works fine, I receive mails and can send mails)
But if i try to connect over mailclient I get this error in errorlog:
couriertls: connect: error:1408A0C1:SSL routines:SSL3_GET_CLIENT_HELLO:no shared cipher
What can I do to get connection over mailclient?
View 2 Replies
View Related
Sep 21, 2014
Since we had Update to 12.x we have problem to connect to any ftp Server
We have this Problem on two diffrend Plesnikserver.
Both are running under Ubuntu 12.04 ....
View 1 Replies
View Related
Mar 30, 2015
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException
Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
View 2 Replies
View Related
Jan 23, 2015
Up until a week ago we had some troubles with package dependencies on our dedicated server running on Ubuntu 14.04.1. Plesk was totally out of reach, displaying 502 Bad Gateway pages and some other weird error on login_up.php3.
I fixed the dependencies by removing a lot of packages (including Plesk) and finally managed to reinstall Plesk using the autoinstaller, then repaired it using "/usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh" (IIRC this whole bootstrapper folder was not present before reinstallation).
Now, after restoring our data from a backup pretty much everything works except for the subdomains. They all redirect to the primary domain's vhost (307 Redirect) for some reason.
"/var/log/apache2/access.log" shows the following after issuing a HTTP request to any subdomain:
Code:
<ip> - - [23/Jan/2015:23:15:31 +0100] "GET / HTTP/1.1" 307 244 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:35.0) Gecko/20100101 Firefox/35.0"
<ip> - - [23/Jan/2015:23:15:31 +0100] "GET / HTTP/1.1" 200 13397 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:35.0) Gecko/20100101 Firefox/35.0"
I have tried enabling and disabling nginx, it did not work. Then I just kept it disabled because it makes our forum think that everyone has the server's IP (because of the reverse proxy thing I assume).
Oh, and I should say: using HTTPS anywhere just gets me a 502 Bad Gateway error.
View 7 Replies
View Related
Jun 22, 2015
Connection to the database server failed: Unknown column 'plugin' in 'mysql.user'
View 1 Replies
View Related
Oct 12, 2007
for months my server has been running fine, since about a week ago the server crashed and was up and down
the fault was found to be faulty ram which has been replaced.
now I have had every tom, dick & harry take a look at the server to get it stable again but im still having issues.
The server seems to run fine but crashes when I try and repair or backup my database.
the database is large like 30gig but the server used to do this fine before but it wont now, it get so far then hangs.
Server:
Dual Core Xeon
4GB Ram
2x 250GB HDD
Raid 1
View 6 Replies
View Related
Aug 6, 2012
Lately whenever i try to connect to my Plesk Panel, I get Firefox's "Unable to connect" error and with Internet Explorer I get "Cannot display web page". I disabled all addons, still couldn't connect. Checked my Firewall, still nothing. I pinged the IP and got 51ms. My site is still up. And I just dont know what's wrong.
View 2 Replies
View Related
Jul 17, 2012
I've upgraded to 11, but when I try and apply updates, I'm getting
WARNING: Unable to connect to local default MySQL server. Read carefully article [URL] ..... for details.
I've followed the directions in the KB mentioned, but haven't had any luck yet.
View 8 Replies
View Related
Jul 20, 2015
Not sure why, but for some reason lately our Plesk installation randomly sends us notification emails about alarm level changes which go from Green to yellow, yellow to red, then goes back to normal over time. No changes were made on the server for these constant changes and emails to occur. We have a customer who also has the same issue.. Both focus primarily on nginx with little to no usage of apache.
View 2 Replies
View Related
Jul 21, 2012
This problem has been reported before Plesk Panel 11. What's the current solution for this problem? I've got this problem since I upgraded to Plesk Panel 11.09.
I'm getting spammed with emails like:
Server health parameter "Services > Apache memory usage" changed its status from "green" to "yellow". Click to expand...
View 19 Replies
View Related
Dec 19, 2013
I have installed Plesk 11.x windows version. I use that for 1 month but now I want to login to panel by http://mysite.com:8880 get error:
The system cannot find the file specified. (Error code 2) at Unable to connect to pipe .pipeP_85da9518-b79d-49a6-a154-e5055dc53d7c
View 2 Replies
View Related
Nov 24, 2014
I got this error when i try to active an account in Plesk.
Error: DNSZone::Table::select() failed: no such row in the table
And when o try to solve issue by the following steps,
1) Login to mysql psa database using the plesk administrator password,
cd %plesk_dir%Mysqlin
mysql -h 127.0.0.1 -uadmin -p -P 8306 psa
I got : Unknown psa Database...I'm ensure that database is founded on the server under C:Program Files(86x)MysqlData
View 11 Replies
View Related
Feb 28, 2014
when i try to make backup of mssql 2012 on plesk 11.5 i have the following error:Error: dbbackup failed: Unable to backup database 'DBANME'. Unable to open connection: A specified logon session does not exist. It may already have been terminated.i already configured temp/network directory,
View 6 Replies
View Related
Mar 8, 2015
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
View 1 Replies
View Related
Jul 22, 2015
Unable to restore database '17'
Not valid backup:
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.).
VERIFY DATABASE is terminating abnormally.
(Error code 22)
---------------------- Debug Info -------------------------------
View 1 Replies
View Related
Feb 25, 2008
Anyone know of a good tutorial for upgrading php on a linux plesk 8.3.0?
View 4 Replies
View Related
Sep 1, 2014
My Plesk installation (on Debian Wheezy) has PHP5.4.4 and I need to upgrade it to 5.4.9 or above.
How can I do this (It's a self managed Plesk server)?
View 3 Replies
View Related
Oct 12, 2014
OS: CentOS 6.4 (Final)
After upgrading components as suggested by "Tools&Settings->Plesk->Updates and Upgrades" item, components remained the previous version (PHP 5.3.3 and MySQL 5.1.73) as stated by phpinfo() result and by "Tools&Settings->Server Management->Server Components" list, though "Update Components" is no more permitted as if there is nothing more to update.
I need both PHP and MySQL servers updated in order to run Joomla 3.3.6.
View 5 Replies
View Related
Aug 3, 2013
Yesterday we upgraded V.11 to V.11.5.30. And now we are not able to restore our backups anymore from our main server on our failover server by CLI (we have automated this with cronjobs and need the CLI backup/restore). We have a failover sulotion with two servers and restore the backups of our main server on our failover server!
If we try to create the map file on our failover server, we get the error:
The dump specification '/home/backups/plesk_partnerserver/dumps/backup_info_1308030132.xml' should be inside of dump directory '/home/backups/plesk/dumps'.
/home/backups/plesk_partnerserver/dumps is the path on our failoverserver where we store the backups of our main server and /home/backups/plesk/dumps ist the regular dump path of the failover server.
And if we try to restore the file without creating a map file on our failover server with /usr/local/psa/bin/pleskrestore --restore backup_info_1308030132.xml -level server: Unable to resolve all conflicts
What happend? Now after upgrading to 11.5 our backup- and failover-solutions are in big trouble!
Our OS is Debian Squeeze
PP is 11.5.30
View 6 Replies
View Related
Aug 13, 2014
Yesterday I've upgraded the server to Plesk 12.0.18. After the upgrade, a WHMCS install has stopped working.
The only error logs where I found errors is the proxy_error_log. It contains this kind of lines (for the 502 error):
2014/08/13 08:13:45 [error] 2918#0: *400 upstream prematurely closed connection while reading response header from upstream, client: XX.XX.XX.XX, server: XXXXXXX.COM, request: "GET /knowledgebase.php HTTP/1.1", upstream: "http://XX.XX.XX.XX:7080/knowledgebase.php", host: "xxxxxxxxx.com"
View 9 Replies
View Related
Aug 28, 2014
I need to upgrade mysql from 5.1.73 to 5.7 but I have applications like lms, cms, and websites that runs with that version with no problems, my question is: Some of you had problems upgrading mysql, because i kwon plesk runs over mysql y i don't want to mess up with plesk.
View 1 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
Apr 2, 2015
We have a plesk server running on a Ubuntu 14.04.2 LTS machine. We check the state of the mailqueue with nagios, executing the "mailq" command. After the AutoInstaller upgraded our installation from 12.0.18 update 38 to 39, we noticed, that the nagios check failed.
After investigating a little bit, it seems that we found the problem:
When I enter "mailq" in the shell, the command is executed and gives me an proper output. But when I try to execute the command with its full path "/usr/bin/mailq" nothing happens, and I have to cancel with [ctrl]+[c]. The which-command delivers exactly the same path as written above...
View 4 Replies
View Related
