Plesk 11.x / Linux :: Error Adding Remote Database Server
May 9, 2014
PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Plesk 11.5, 11.5.30 Update #44, last updated at April 30, 2014 03:25 AM, Centos 6.5 (Final), Linux 64bit
When I try to add an extra MySQL server, running on a different server, I always get an error that the user has no admin access. But the user I created does have admin access to the database.
The remote database is a MySQL 5.5 on a Linux Ubuntu 12.04 LTS server
STEPS TO REPRODUCE
Tools & Settings -> Database Servers -> Add Databases server
Error: Test connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'%' to database 'd536cedf97037e'
A working database connection.
ANY ADDITIONAL INFORMATION
These queries are logged by MySQL:
I'm trying to add multiple PHP version (current version installed: 5.5.13), using the official documentation. I always get 500 Internal Server Error after switching to the new version, with the following error_log content:
Code: [Sat Jun 07 00:49:35 2014] [warn] [client XXX.XXX.XXX.XXX] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server [Sat Jun 07 00:49:35 2014] [error] [client XXX.XXX.XXX.XXX] Premature end of script headers: index.php Here you can view phpinfo() obtained running php54-cgi index.php from the command line. Same script doesn't work as FastCGI.
I'm trying to add PHP 5.4.29. Here is how I compiled it:
I seem to have an error with backing up to my personal FTP repository. I have only just noticed the issue, but i believe it originated when I upgraded Plesk Panel 11 to Plesk Panel 12. I am currently running version 12.0.18 on Cent OS 6.5.
Note whether i check the "Use passive mode" option makes no difference to my problem.Below is what I get from the panel.log under /usr/local/psa/admin/logs
why but autoupdate fails. It doesn't give a reason why it cant backup.
For line of log :
START pp11.5.30-bootstrapper-11.5.30-cos5.build115131216.11 installing AT Thu Mar 27 07:43:37 CET 2014
Last lines of log :
===> Upgrading database
Trying to start service mysqld... mysqld (pid 24610) is running... done Trying to establish test connection... connected done Trying to find psa database... version is 011005030 Version is OK, no need to create psa database. Trying to backup MySQL database... ERROR while trying to backup MySQL database Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
Trying to start psa...
**** Product prep-install for BASE failed.
***** problem report ***** ERROR while trying to backup MySQL database Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jun 17 04:04:48 CEST 2014
I have Plesk installed on the master nameserver ns1.example.com, the dns slave manager extension installed, a working slave ns2.example.com and Plesk installed with working WHMCS autocreation of customers and subscriptions on a shared hosting server web1.example.com. I feel there's probably something obvious that I'm missing, but I can't figure out how to autocreate DNS records on ns1.example.com for customers on web1.example.com when new accounts are created.
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
I'm migrating all of my websites form one server to a new one. And everything is working as planned with the plesk migration manager. But with my last website i'm having some problems and getting this error:
Short Error: Adding webspace manually
Code: Error: System user update is failed: Unable to create system user: Unable to execute usermng: column login is not unique (Error code 1) Full Error Log - Migration
Code: Warning: server "server" Unable to dump server settings. Server element will be empty[Object reference not set to an instance of an object.] Warning: domain "teamswear.be"
I've also tried to add the webspace manually but getting the same error.
i would like to change the access control for datebase users via CL: command: /usr/local/psa/bin/database --update-dbuser web1_presta -server localhost:3306 reply: The database user was successfully updated. examination: mysql> select host, user from mysql.user;
According to de Plesk Administrator Guide and according to the kb article: [URL] ...., Plesk Panel is suitable to enable multiple php versions After I performed the steps mentioned in the kb article, all seemed fine until somehow php-cgi and php-fcgi broke down after
Code: # service httpd restart
After this event, all websites hosted on this particular the server only work running php as an apache module.
I am running Pleks Panel 12.0.18 #7 on top of CenOs 6.5 on this particular server, which means php version 5.3.3 is installed by default. PHP 5.3.3 also is was the php version for the "custom: false" php handlers (id's: cgi, fastcgi, module). Somehow all php handlers look like this:
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm ...done. done -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started. ===> Cumulative upgrade of APS controller database has been completed. ===> Cumulative Plesk database upgrade (revertable stage) has been started. ===> Preparing Plesk database upgrade (revertable stage). ===> Cumulative upgrade of Plesk database (revertable stage) has been completed. Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
When adding a subscription with a certain plan, I get this error"Error: The plan was not applied: Custom changes in PHP settings" almost instantly after I initiated the creation of the new subscription. Another service plan doesn't have the issue, and though I tried finding the reason why one works while the other doesn't I simply wasn't able to. The service plan in question is used for over 40 others without a problem just when I select it for a new subscription, I get the mentioned error message.I am using Plesk 12 on Linux, all latest updates installed.
i registered some new domains and wanted to add them via Plesk. Before i did that i got the stanard Plesk default page saying that i have to add the domains via plesk as usual.
When i did that the domain switched to a white page and is not able to load .html pages, i can load a phpinfo.php or install wordpress etc. but when i try to load a simple .html file with css or something, i only get a whitepage..
i dont know why this is happening, other domains from december are working fine, new ones wont. the error.logs are empty and even after a whole server restart it wont work.I´m using Ubuntu 14.04 LTS Server 64bit + Plesk 12.0.18