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:
We have been looking at utilizing something like nocmonkey or similar to make OS reinstalls easier on our servers. My real need is to be able to do this remotely if and when I can't have someone onsite do this to help speed up turning up a server where a client has cancelled, and we are reinstalling CentOS to turn up to new client.
I'm almost certain there is no quick and easy way to do a OS reinstall remotely without utilizing something like NOCmonkey, correct?
I do have KVM/IP so I was curious if there is a way remotely to do this that is possible because of the KVM/IP?
I just started using plesk for my blogs and websites, so testing and finding my way around i notice every site i add instead of having its own folder just like in cpanel(shared hosting) the sites are been added under the primary domain.
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've got a situation in which I need to have a set of mail accounts that share a domain name with a domain that's already in use as a domain alias and because the domain is already in use, I'm unable to create a new account using that domain. I tried explicitly adding "www" to the domain alias so I could keep the www.domain.com address as an alias and reserve the "domain.com" name for use as a separate account, but Plesk won't allow for that.
How to address this? The idea I'm currently considering is to delete the domain alias and then create the new account and manually set the DOCUMENT ROOT of the new account to refer to the other domain's document root. I'm sure this could create some difficulty in Plesk so I'm looking for input before trying it. I'm actually not even sure exactly where I would be able to redefine the document root with Plesk allowing the change and not overwriting it later.
If all else fails, I can setup a new account on a different and unrelated Plesk server, but I'd prefer not to do that.
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;
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.
keep a local and remote backup of certain subscriptions or at least have a full server backup on FTP.
I have a livedrive.com reseller account which allows be to quite cheaply add 512GB of remote storage accessible through SFTP, FTP and WebDAV. I created this partition and added it as a server-level FTP repository in Plesk 12 (latest build). During testing I added a firewall exception for traffic on the FTP IP-address and figured that I had to put the FTP repository in passive mode to properly connect.
After setting this up I ran a configuration only backup to test if everything was working properly. The backup was created properly and can be accessed through the FTP as well: success!
My second test was running a full server backup through the manager. The ±40GB file was created properly (I could see my disk usage increase and decrease through new relic monitoring) and supposedly transferred to the FTP repository according to Plesk.
When I look at the FTP or the Plesk Backup Manager both indicate that the full server backup is 0kb in size.
After this issue I figured: I really don't care about a full server backup, I mostly care about a specific set of subscriptions that have new content on a daily basis and need to be backed up properly as well. Those subscriptions are already on a daily or weekly backup scheme that places backups on the local repository.
What I would eventually like to do is create daily or weekly backups on the local repository and create weekly or monthly backups on the FTP repository for those specific subscriptions, but unfortunately you cannot (by default) setup Plesk to automatically backup to local and remote based on different or even the same intervals.
And this is the more important question: How to be able to create/setup a backup automation that keeps local and remote backups for the same or different intervals? Either through the Plesk interface, a plugin or a script?
Running Plesk 12 on CentOS 6.6
Just tried running the same server wide backup, but this time as a multivolume backup. This resulted in the following error:
I tried adding an apache service node to PPA Admin Node.
I referred to the specs at [URL] ....
Specifications of the Apache server node are:
RHEL 6.4 64bit RAM 3GB CPU 2.5GHz Free Space 18GB Ports Opened: 80, 443: HTTP, HTTPS 8352-8999: Communication between a service node and PPA panels 22: Communication through SSH 20, 21: FTP connections
But when I tried adding it as a service node, PPA says The Linux platform installed on the remote host 'xx.xx.xx.xx' is not supported. Please, check the list of supported platforms.
After upgrade 11.5 to 12, my panel works fine but nos subscription in the panel.Websites are working well...Is it possible to reconstruct the psa database (no backup :-( ) ?Some backups of psa database are done before the upgrade?
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.