Plesk 12.x / Linux :: MySQL Remote - Adding External Resource?
Jun 15, 2015
I am looking to add a mysql external source to my plesk. So far no difficulty.
My question is if I remove the mysql server where the currently plesk. I have to say to the panel get the information (psa, roudcube, horde) on the remote mysql to invez mysql local server?
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
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
PROBLEM DESCRIPTION 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
ACTUAL RESULT 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'
EXPECTED RESULT A working database connection.
ANY ADDITIONAL INFORMATION These queries are logged by MySQL:
If I just ignore this message, go to a subscription and create a database, then the database gets created just fine. It's just Plesk that thinks that something went wrong.
I recently migrated a load of domains from a pleks 8.? install to a plesk 12 one. As part of the migration a new reseller was created but all the resellers domains got "lost". They were all there and working but not appearing in the interface.
I did some googleing and fixed this problem and can now see all the domains and when I look at the reseller plesk tells me it has 0 own customers, 0 own plans and 0 own subscriptions. However, if I look at the resources tab it tells me that 7 domains out of unlimited are being used.I just wondered where plesk get's that info from and if it is safe to delete that reseller without risking the domains getting deleted too.
Is there any way to do resource throttling by subscription?What I would like to do is limit the CPU resources to all of the subscriptions equally, as some subscriptions are eating away the CPU all the time.
Version Parallels Plesk v12.0.18_build1200140606.15 os_Debian 7.0 OS Debian 7.7
I have a dedicated server and I am about to get a few high traffic sites that will be Joomla based and MySQL served. What I am thinking a about is to create another MySQL instance, leave the current websites on the "old" instance and get the new ones onto a separate instance.
I am on PPP 11.0.9 on windows and the current mysql version is 5.1.56 on port 3306 (I can get other ports for other instances).
What I did was the following:
In the Database Servers page, I hit "Add Database Server"
In the next page I add the following: MySQL (from the dropdown) localhost 3307 (leave blank the default check box)
I then add the Administrator's username and passwords and hit OK.
The next page, reports an error message (in between asterisks below): ************************ Error: Test connection to the database server has failed because of network problems:
No connection could be made because the target machine actively refused it. ************************ The primary (eg. current) mysql instance is working fine, it's just I cannot add a second server...
to repair the databases. Worked, but give me the error
"Table 'aps_resource' doesn't exist"
One more time, i recover this table from the newest backup existing. But now, give the error " Can not find registry resource for Application ID" for one domain - I have 3 domains, 2 are working, one not.
-----Original Message----- From: Provider Co. [mailto:<email>] Sent: <date> To: <customer name> Subject: Notification: Resource limits exceeded by reseller account.
The <account name> account is approaching or already exceeded the limits:However, no exceeded or close to exceeded resources were found.This is in the KB, but no date is on it. Has this been fixed?URL...
Somehow when customers add a new MySQL database they can select a Local MySQL server. It turns out this is the MySQL instance running on the CP server, can I somehow hide this server from the list?
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:
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
The sql server I have my users use is on a different server from which plesk is installed. Plesk should include the size of the user's databases from the external server as well otherwise the user can have a database as large as he wants. It's no longer restricted by the plans limits.
I want to add a subdomain foo.bar.com to a master domain bar.com in the subscription bar.com. Normally this works but if I set the hosting type of the master domain to forward, I cannot add subdomains anymore. If I have already added a subdomain, I cannot change the hosting type of the master domain. Also it is not possible to add a second domain to the subscription anymore.
I am currently unable to access the Plesk control panel except from the web server itself. When I try any of the following options, all work on the server itself but externally all I get is the default Tomcat page.
I don't know if the problem is on the server itself or something within our firewall - we use Microsoft Forefront TMG. The port 8443 is open, and the Tomcat page is being served. All websites working fine, both internally and externally. The server itself is in a DMZ on the network.
The server is running Centos 7 with Plesk 12.
I just noticed that when adding a new domain, I am warned that the domain resolves to another IP address - the external one. Currently, the IP address set up in Plesk is the internal (192.168...) address. Could it be that I need to change this to the external?
I have followed the instructions here to send Plesk notifications through External SMTP (overuse, new domain creation, etc): URL....Here is the error I see in the panel.log: ERR [panel] Unable to send mail.
Is there another log that I'm missing with a more detailed error? Sending through an external SMTP works fine on sites hosted on the same server (Wordpress, Joomla).
I can receive email from all accounts and all domains.
The problem is that when sending an email to an external email (gmail., hotmail, outlook.com .... etc) this is sent to mail queue and do not leave that place.
When I set up spamassassin to store spam in the spam folder of my mailbox, it doesn't add any X-Sapm headers nor tags the subject. All I found so far was an old thread where a plesk employee stated that it will be fixed in 'a' future version.
Seems everythings is working normal when ignoring following error message, but everytime I add or change mail settings for a domain, I am getting this error:
Internal error.
ERROR: Uncaught exception 'Zend_Log_Exception' with message '"/var/log/plesk/panel.log" cannot be opened with mode "a"' in /usr/local/psa/admin/externals/Zend/Log/Writer/Stream.php:81 Stack trace: #0 /usr/local/psa/admin/plib/Plesk/Log.php(69): Zend_Log_Writer_Stream->__construct
I'm using a 1blu.de vServer. On my VPS is Plesk 11.5 with centOS 6 installed. I created my Webspace [URL] .... and removed the Mail Services and activated the MSMTP plugin because I'm using the webserver from the hoster 1blu.de.
I activated the Firewall with the "allow any connection" rule.
In Plesk Tools & Settings > External SMTP Server I filled in the server informations smtp.1blu.de password & username. I checked all three boxes -> SMTP needs auth, allow user scripts ...
I installed Wordpress 3.9.2 with a Theme that uses PHP Mail function. The contact form is not sending any messages out. So I tried other php mail scripts but it doesn't work.