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;
+-----------+------------------+
| 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 |
+-----------+------------------+
View 2 Replies
ADVERTISEMENT
Jul 11, 2014
After a successful upgrade from 11.5.30 to 12.0.8 the Backup Manager cannot be accessed anymore. The system replies with:
Internal error: Failed to parse response. Reason: Failed to read data from stream Process output:
MessageFailed to parse response. Reason: Failed to read data from stream Process output:
File PMMConnector.php
Line708
TypePleskPMMResponseException
Apparently the backups are not saved anymore either.
View 3 Replies
View Related
Sep 20, 2014
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.
View 3 Replies
View Related
Jun 29, 2012
after upgrading to plesk 11 i get this error (Image attached)
so basicaly i cant do nothing..
View 3 Replies
View Related
Nov 9, 2013
when I try to access to my plesk I obtain:
ERROR: PleskFatalException: Unable to connect to database: Access denied for user 'admin'@'localhost' to database 'psa' (auth.php:142).
If I restart with ssh /etc/init.d/psa start and I check plesk_11.5.30_reset_instance_data.log
I note: ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'.
View 10 Replies
View Related
Oct 30, 2013
* 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">
[Code] ....
View 13 Replies
View Related
May 18, 2015
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?
View 8 Replies
View Related
May 26, 2014
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.
View 7 Replies
View Related
Jun 4, 2014
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.
View 3 Replies
View Related
Aug 21, 2014
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.
View 1 Replies
View Related
Aug 4, 2014
Since one of my scripts was not working fine I came up with enabling
" Home>Subscriptions>tld>Websites & Domains>Web Hosting Access = > Access to the server over SSH : forbidden to /bin/sh "
Is it safe or not?
View 2 Replies
View Related
Apr 13, 2015
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.
View 2 Replies
View Related
Mar 10, 2013
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?
View 7 Replies
View Related
Jul 21, 2015
if I can install plesk panel with a dedicated database server... and how.
View 3 Replies
View Related
Oct 22, 2014
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?
View 8 Replies
View Related
May 18, 2015
When I try to SSH to server with hosting username it disconnects and says in secure.log:
May 18 14:33:40 mail sshd[22764]: error: ssh_selinux_setup_pty: security_compute_relabel: Invalid argument
I run Plesk 12, sepolicy is Permissive.
View 1 Replies
View Related
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
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.
View 2 Replies
View Related
Nov 24, 2014
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?
View 1 Replies
View Related
Aug 18, 2014
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).
View 2 Replies
View Related
Oct 24, 2014
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?
On our other servers we use rotatelogs for this.
View 3 Replies
View Related
Nov 20, 2014
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.
View 5 Replies
View Related
Sep 29, 2014
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
View 3 Replies
View Related
Jul 14, 2015
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.
View 18 Replies
View Related
Dec 5, 2014
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
View 2 Replies
View Related
Jan 13, 2015
I cannot find the DNS Setting in Websites&Domain TheWebsite/Show More
I tried changing:
Tools&Settings
Plesk
Custom View setting (DNS template settings checked)
Also:
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?
Centos 6.6
Plesk 12.0.18 Update #30
View 5 Replies
View Related
May 7, 2015
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...
View 1 Replies
View Related
Sep 15, 2014
Ubuntu 12.04
Upgraded Plesk from 11.5 to 12.0.18 from panel.
I have installed PHP 5.3.29 (make from sources)
All smooth, added handler:
Code:
/usr/local/psa/bin/php_handler --add -displayname 5.3.29 -path /usr/local/php5329/bin/php-cgi -phpini /usr/local/php5329/etc/php.ini -type fastcgi -id php5329
App work ok after change to new php with hosting settings(change php handler Fast Cgi)
But php info shows that: Loaded Configuration File is /etc/php5/cgi/php.ini
This is not good as I checked should be for certain vhost cutsom php ini which is generated by PHP settings.
For example I changed in Plesk memory_limit to 333MB applied changes panel show successully, but still there is 128MB default value in phpinfo().
Am I missing sth ? Is there additional task needed expect adding handler? Or is there a known bug?
ps. after change handler back to 5.3.10, (default installation) there also custom PHP settings file seems not to be processed.
I did not tested earlier maybe upgrade Plesk to v12 broked sth? What should I check?
I have tried to delete (and let psa recreate) php.ini from vhost/system/mydomain.com/ but also did not worked...
View 15 Replies
View Related
Dec 12, 2014
I want to know what settings to make in the Dns of my Server so always to show the www. in the browser, before the domain name.
For example, in the url to be www.mydomain.com and not mydomain.com
View 1 Replies
View Related
Oct 9, 2014
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...
View 1 Replies
View Related