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/...')
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
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.
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?
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:
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.
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.
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.
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,
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.
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 -------------------------------
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.
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!
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.
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...