Plesk 12.x / Linux :: CLI Database Server Settings - Access Control
Jun 10, 2015
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;
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 been a solid cPanel / WHM user for the past 2 years, we have now since downsized our hosting requirements and also wanted to cut our panel costs and so we moved to PLESK 12 Web Edition.The server is on a trial license and has been working fine with no problems for the past 2 weeks. Today all of a sudden none of the websites are accessible, although I can ping all IP's on server and login via SSH.I cannot access any websites or hosting control panel, I have disabled IP tables as this was the cause of a problem last time.
Why this happened was there an update at around 5AM this morning which could have caused this?I have restarted the server, I can successfully ping / resolve address from SSH.
* Go to "Web Server Settings" add text to "Additional directives for HTTP" and press button "Ok". * Go to "Document root" folder of your domain and now you have a new folder "/cgi-bin/test" with file "test.cgi":
Code: #!/usr/bin/perl print <<HTML; Content-type: text/html <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
I set multiple mail servers (eg media-26.com) in the black list of server-wide mail settings but i still get spams from these mail servers..does it work properly?
Since 12.0.18, when I go to Tools & Settings > Mail Server, I get this error message on the page:
"Error: The limits on outgoing mail will not work for the subscriptions that have IP addresses from the white list. To make the limits work, remove IP addresses from the mail server's white list".
However, the whitelist page just contains 127.0.0.0/8 and ::1/128, and all my subscriptions have an external IP address which is clearly not in the whitelist.
I have just moved away from Kloxo Hosting, and I am a bit confused as to how I go about setting Client domains to use the (Already Registered) Nameserver Records I have created on the server.
You see, when I create a customer, the template adds the domain with it's own nameservers, ex: (ns.customerdomain.com -> 0.0.0.0) I don't want this to be the case.
What I would like to achieve, is for all my client's to have their NS records pointing at the NS records I already have registered on the server.
The reason for this is, when I submit the registration document to my local registrar, I have to specify the nameserver address for the domain, however, I only have 2 IP's on the server. I cannot glue every customer's domain FQDN to an IP.
I have server with the Plesk control panel on Linux server and want to install ffmpeg but not sure about the steps to install it. Any script or easy steps to install ffmpeg on my server.
I cannot SSH or login into Plesk Admin panel. Once I tried SSH, it says 'connection refused'. Once I tried login into admin panel, it says 'Error: Access for administrator from address 'xxx.xxx.xxx.xxx' is restricted in accordance with IP Access restriction policy currently applied.
Tried restarting the plesk server too. Nothing seems working.
I enter one of my IPs or the hostname belonging to this IP, followed by the Plesk port, and I get redirected to the "main" hostname of the server, which was set in Plesk. But at this moment that hostname is used by another server (my old server) and so I'm redirected to the other server and cannot access Plesk on the new server.
I don't know why Plesk reacts like this, because it did not on the old server. Here the problem more detailed:
I'm just configuring my new server with Plesk 11. My old server uses Plesk 10. On my old server / in Plesk 10 I have the following scenario:
- I have several IPs (10) - Each IP is used for a different domain - Each IP has it's domain as the reverse entry (configured outside of the server/Plesk) - Each IP is set to "Dedicated" in Plesk - I set Plesk to listen only on one of these IPs (and different port) - Several domains are created in Plesk, but not a domain for my Plesk IP - The server's name is one of the domains (required for mails not being recognized as spam) - The hostname of the Plesk IP is one assigned by my provider (something like x-x-x-x.xyzservers.com) - Entering the IP of Plesk redirects to the "Plesk hostname" => Plesk can be accessed by using x-x-x-x.xyzservers.com:myport
And under Plesk 11 (here comes the problem):
- Still several IPs (but less: 4) - One IP should be used for Plesk, one for domain X, one for domain Y and the last one for the other domains - Reverse entries are x-x-x-x.xyzservers.com for Plesk IP, domain X/Y for two other IPs and the main domain for the last IP - Plesk IP and the two single domain IPs are configured as dedicated, the last one as shared - At this point I did not configure any domains in Plesk - Server's name is the same as my old server (the main domain) => Entering any IP with the Plesk port redirects to the servers hostname, e.g. my main domain, which is still on the old server. => Result: I cannot access Plesk!
Of course I could just change the hostname of the server via SSH (just have to find out how to do this), but why does Plesk react in another way now? Or is the problem that I cannot change Plesk to listen on only one IP?
I host a number of large sites (20GB+) on my VPS server running Centos6 and Plesk Panel 12. Due to the large sites I don't want to keep multiple backups on the actual server because it would take too much disk space. When I create a backup to the server's repository all is good, but when I click the green arrow to download the backup it takes a long time and then it fails with a timeout error. On some smaller sites it takes a while but eventually downloads the tar.
So my question: Is it possible to access the Server Repository via FTP? How and where would I set this up? Presumably it would be a better way to download these large archive files?
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 have a rented VPS with 2TB of disk space and a plesk license in order to host the sites that i develop and my sites, and found myself with around 1.8TB of free space, plesk samba management and plesk vpn management but with few missing pieces for my idea. My idea was to setup vpn tunneling between my laptop and desktop to plesk server and access samba share from the server like they were in my LAN.In the firewall I have opened only the classic mail and web ports (obviously plesk access too).
I want to save the access logs of our websites on an external server. If I do this now with the default setup, the gets overwritten every day. The desired file name format whould be: websitedomain-tld-access-2014-10-24.log
How can I tell Plesk to do this and how can I make sure the statistics keep working?
When 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.
situation: - compiled and installed php 5.5 and 5.6 - both versions work fine and are registered in plesk - base configuration for php is set for each version in a custom.ini
issue: - plesk php-settings are not applied: not matter what I change in Plesk php-settings, the values from my custom.ini file are used
What did I do wrong? How do I re-enable plesk php-settings?
Addendum: The php-settings apply esspecially to post_max_size and execution_time
I am trying to change the default php settings under domain (upload_max_filesize & post_max_size) but nothing happens. I am running PHP 5.5 in FastCGI. I also changed it to Centos default PHP (5.4.16) but nothing happens again. It only works when PHP runs as Apache module. The problem is on FastCGI Application.
My server: Centos 7, Plesk 12 Check the screenshot for installed components.
so my website is working perfectly fine for a few months now, and im looking to use Roundcube instead of Google Apps.What are the DNS settings i need to change to for my domain registrar?Currently i have the following records, and it can only send email, and not receive.
A Records @ IP Address A Records webmail IP Address
Tools&Settings Plesk Appearance Interface Management -Power user View (with & without) Use Custom View-Service Provider View (with & without) Open hosting operations in Server Administration Panel However when I go to
Websites&Domain TheWebsite/Show More, the DNS settings are still missing.
Is there any other setting I can try to show the dns settings?
I manage 1 server with 5 domains. I use the panel as power user (unique user)
I want to assign a new IP to a domain. In the hosting setting there is no IP to choose and in the IP tab if I click on the IP there is no domains to choose becouse all the domains are assigned to the primary IP...
I'd like to set IP in the hosting setting of the domain...
