Plesk 12.x / Linux :: Updating Database Name Of WordPress Installation Through Phpmyadmin Panel
Jan 21, 2015
I found out a easy way to update the Database name of a WP installation through phpmyadmin panel, However I can't seem to update or refresh the Parallels WP Settings with correct information. Is this a bug?
This is how to reproduce:
From phpMyAdmin select the database you want to select, in the tabs there's one called Operations, Go to the rename section.
Update the user privileges to the new Database name and remove the old privileges (save)
Then manually update the wp-config file which contains the 'Database name' (save)
Then goto Parallels Plesk > Websites & Domains> WordPress Installations > Change Settings
Here you should notice the Change Settings for the WordPress Installation still contains the old Database name.
In the Wordpress Toolkit several WP installs appear with exclamation mark and title: "A Wordpress installation was previously detected at this path, but it is not operating properly".
I have installed the Wordpress application. The wordpress url is "server.com/wordpress", but I want to change it to something like "server.com/myblog".
In Plesk, the installation path cannot be changed (at least, it is not under "Change Settings").
Changing the Wordpress installation itself is not that difficult (renaming the folder in httpdocs and changing the siteurl and home parameter in the database), however, in Plesk still the old installation path is shown, and the Plesk interface to Wordpress obviously does not work any more.
How can I change the Wordpress installation path in Plesk?
Version Parallels Plesk v12.0.18_build1200140606.15 os_Ubuntu 12.04 OS Ubuntu 12.04.5 LTS
My wordpress installation in plesk some times give me:
[Sun Apr 12 14:26:08 2015] [warn] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server [Sun Apr 12 14:26:08 2015] [error] Premature end of script headers: index.php
On server are many Wordpress installations after scan all these were added however about 90% have this tool-tip message "A WordPress installation was previously detected at this path, but it is not operating properly now." How to correct and manage these installations
I have a clean installation of Parallels Plesk on my server, and I installed wordpress on two of my domains. I'm scanning for installations through Plesk Admin, and it shows two installations with empty name and the toolkit is not functional at all. Check the attached screenshot.
We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.
I recently had to uninstall WordPress from a blog of mine. The whole thing was down for a while and then I reinstalled WordPress but I'm trying to get the new install to recognize the prior install's database. I have done a lot of poking around and haven't been able to find the answer. I have also contacted the hosting service's customer support and they did respond with a quick answer but it was also a little too vague (or I might just not be understanding it right... but I think I am; I think it was good information they sent but probably just not enough good information).
I'm getting the following alert in my Plesk 11.5 panel :
1) Failed to update Panel. To solve this problem, you can send the update log to Parallels support. View the update logs (Oct 27, 2014). View the update logs (Oct 28, 2014). Copy the logs to your computer before you close this message. To close this message, click here.
2) Installation or upgrade failed. For more information, log in as root to the server over SSH and view the file /tmp/plesk_11.5.30_installation.log. To remove this notice, remove the file /var/lock/parallels-panel-upgrade-failure.flag from the server. Repair the failed upgrade or installation. ---------------------------- here the final part of the update log: ---- ===> Cumulative APS controller database (apsc) upgrade has been started. ===> Upgrade of APS controller database has been completed. ===> Cumulative Plesk database upgrade (revertable stage) has been started.
I'm on a VPS with Ubuntu 14.04 and Plesk 12 Web Admin Edition. I can't import a large (20 MB zipped) database dump to phpmyadmin because there is a 2MB file size limit. I suppose I have to change the server-wide PHP configuration (if I change the PHP settings for the domain nothing happens). Is there a way to change the global PHP settings via the Plesk panel?
Windows setup: Plesk Panel 11.5 - Server 2012r2 - IIS 8.5 - PHP 5.3/5.4/5.5 - mySQL/MSSQL. Server runs behind firewall (NAT). Setup with local DNS pointing all A records towards public IP.
Situation: Installed Wordpress through Plesk applications. (mysql). URL....Installs themes in WP console. Everything ok. Installs theme from file, site gets an 500 error. Sometimes installation of theme goes fine, but once activated or previewed it shows 500 error.
Error: Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.
We have change IP from NS server in Plesk.Why can we force refresh named.conf (for all domains) ? Informations stay with old IP.We can force one domain when we change an information in the DNS and we validate. But Hown can we change all domains?
Example: Old > NS server1.com (x.x.x.1) New > NS server1.com (x.x.x.2)
My server admin already upgraded my OpenSSL to version 1.0.1m 19 Mar 2015 and he also upgraded Nginx to 1.6. I'm also running CentOS v5.11 and Plesk v11.5.
However, he tells me that he still can't get TLS 1.2 to work because he noticed that my server uses a different version of Nginx (sw-nginx), which he believes is part of Plesk. How we can get TLS 1.2 working on the Plesk copy of Nginx (sw-nginx)?
I am running OS Ubuntu 14.04.1 LTS Plesk version 12.0.18 Update #34, last updated at Feb 10, 2015 01:52 AM
I have created a few websites using plesk and i have the dns acting as the primary . This server acts as a primary nameserver for the DNS zone mywebsite.co.uk
When i add a txt record the dns is updated but it never resolves so my DKIM and SPF records are never found. I have checked my syntax for the records and all are fine. My domains are hosted by stratoservers. Is it there fault or mine. Should i change providers so i have more access to the domains dns or should plesk be doing that for me...
I have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ". In the %plesk_dir%adminlogs under the php-error.log i have this error:
# ll /opt/psa/var/modules/firewall/active.flag ls: cannot access /opt/psa/var/modules/firewall/active.flag: No such file or directory
# /etc/init.d/psa-firewall start psa-firewall: service is disabled
You then have to manually "touch" the active.flag to be able to start the firewall again. A workaround is to remove the line:
Code: sed -i 's:rm -f /opt/psa/var/modules/firewall/active.flag::' /opt/psa/var/modules/firewall/firewall-emergency.sh'
I really hope that Parallels fixes this asap, as normally you won't notice that the firewall is not active when every works fine (nothing is blocked) and Plesk still shows all the rules.
My license is updated every month, however it is not automatic, i have to go to Tools & settings > license management and click on "Retrieve Keys" every month.
Iguess there should a cron job that should do this for me every month in Centos.
After Plesk Panel upgrade to 12.x I found a warning showing at Home>Tools & Settings> Database Servers
Warning: Unable to determine the TCP port number used by Microsoft SQL server '.SQLEXPRESS': TCP/IP protocol is not enabled in the server network configuration or the server is configured to use dynamic TCP ports.
To allow your customers to automatically configure firewall for remote database access, manually configure the SQL server to listen on a specific fixed TCP port.Click to expand...
How to update out of date components included in VPS? For instance...
rkhunter is at v1.3.4 whereas the current version is 1.4.2. Why both about updating? Well, in part to reduce the number of false-positive warnings and in part to gain more current protection.
A yum update isn't possible as 1.4.x has moved on quite significantly from 1.3.x and while downloading and installing rkhunter isn't terrible difficult, trying to get it to update the 1.3.4 version included with VPS seems somewhat more difficult...
SpamAssassin is at v3.3.1-3 whereas 3.4.0 is the current release version and 3.3.2 is no longer supported, meaning 3.3.1 is definately way out of support. Why bother? Better spam detection and blocking
When VPS will update to something nearer current versions of both of these components?
I'd like to upgrade my server from Ubuntu 12.04 to Ubuntu 14.04. The idea is to migrate my actual server (S1) to another one (S2). Then, format and install ubuntu 14.04 with Plesk on S1, and finally migrate the data from S2 to S1. Is it a good solution? Is it possible to do this using only one server? I don't know if I can do it making a backup, install Ubuntu 14.04 and then, restore the data into the server.
However, I have a problem with the migration agent. When I go the migration page, the migration agent tries to update itself and it keep at 0% forever (I attach an screenshot).
The IP addresses assigned to our servers have changed so it's time to update the default SPF information contained in the DNS records for ALL of the domains hosted on our servers:
However, when we update the resource record in the DNS template and then "Apply the changes to all zones...",
Panel will apply changes from the template to all DNS zones including the customized ones. Note that user-modified records always remain intact. For example, if the template contains a new record that was already added by a customer, Panel will keep the customer's record.Click to expand...