Is it possible to use a remote database server on two or more Plesk installations without issue?
Plesk A (192.168.1.1):
Local MySQL (default)
Remote A MySQL (192.168.1.5)
Plesk B (192.168.1.2):
Local MySQL (default)
Remote A MySQL (192.168.1.5)
... etc etc. Is that possible? It'll allow me to create databases on the remote server from both/all the Plesk servers without conflict?
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:
140509 16:54:51 28 Connectadmin@10.1.0.162 as anonymous on
28 QuerySELECT VERSION()
28 Querycreate database `BUG115166_1374110215536CEC3816DD2` /*!40101 default charset=utf8 */
28 Querycreate database `bug115166_1374110215536cec3816dd2` /*!40101 default charset=utf8 */
28 Queryinsert into mysql.user (Host, User, Password) values ('%', 'bug115166_17546', password('BUG115166_1374110215536CEC3816DD2'))
28 QueryFLUSH PRIVILEGES
[Code] .....
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've been looking around on how to do a remote mail server for cPanel.
I am talking about two separate dedicated servers. I want this first server to serve as the mail server of my second dedicated server.
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.
example; maindomain.com/seconddomain.com
I want it to be
maindomain.com
seconddomain.com
thirddomain.com
etc ...
change the webmail from Plesk over
/usr/local/psa/admin/conf/templates/custom/domainWebmail.php
thats working without a problem if i change the Webmail Subdomain from one to another.
But i want to change the webmail from
webmail.domain.tld
to
domain.tld/webmail
The following change in domainWebmail.php does not work:
ServerAlias "<?php echo $VAR->domain->asciiName ?>/webmail"
<?php foreach ($VAR->domain->mailAliases AS $alias): ?>
ServerAlias "<?php echo $alias->asciiName ?>/webmail"
<?php endforeach; ?>
After a fresh install of Plesk 11.5 am unable to FTP the server.
The FTP client shows that successful but no file in the remote server and its lock I saw only / I cannot stroll the client on remote server
Site builders work ok, Wordpress and built software update and publish...
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.
View 2 Replies View RelatedI'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.
if I can install plesk panel with a dedicated database server... and how.
View 3 Replies View Relatedi 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;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | web1_presta |
| localhost | web1_oxid |
| localhost | web1_presta |
| localhost | web1_shopware |
| localhost | web1_wp |
+-----------+------------------+
Only when using the GUI:
home -> Subscriptions -> Website & Domains -> Databases -> Users -> web1_wp -> Access control
-> from Allow remote connections from any host
-> to Allow local connections only
is also the user adjusted:
mysql> select host, user from mysql.user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| localhost | web1_oxid |
| localhost | web1_presta |
| localhost | web1_shopware |
| localhost | web1_wp |
+-----------+------------------+
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).
View 13 Replies View RelatedWhen I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
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.
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
All my Backups to a remote FTP fails with Error Code: 1
View 4 Replies View RelatedSince moving to version 12 on the remote FTP backup is not working.
This makes the tar of 50K ~
We have chosen "Setting and content domain" ...
Since upgrading to 12 (Linux) all backups to remote storage now cause timeout in curl. Is it possible to change the timeout anywhere?
To be more precise, when testing FTP settings receive this error:
Transport error: unable to list directory: Curl error: Timeout was reached
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
Update:
Just tried running the same server wide backup, but this time as a multivolume backup. This resulted in the following error:
ERROR: () Can't upload file 'backup_info_1505301327.xml' to ftp. Error code: 1
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 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?
View 2 Replies View RelatedJust updated to V12 and noticed you can't copy a database from one domain to another as easy as before. So doing any testing is much harder. Is this correct or am I missing something...
View 5 Replies View RelatedI've created a database through SSH and give it a user so no problem.
But when i came back in Plesk Panel i don't see this database connected to the domain i want.
So how can i do to "indicate" my server this database must be going with this domain ?
The SpamAssassin bayes database has become ineffective on one of our servers and we want to wipe it and start fresh - how to do this on Plesk 11.5.30?
View 1 Replies View RelatedWe 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.
View 4 Replies View Related
