today we notice that all subscriptions on Plesk when we access phpmyadmin has access to all databases,it was a Plesk update that can be done this ?
I don't remember to update anything during this days to this happen.
Plesk: 12.0.18
phpMyAdmin: 4.2.5
When I try to access phpMyAdmin directly from the link: [URL] ....
I get the following error:
Welcome to phpMyAdmin
You probably did not create a configuration file. You might want to use the setup script to create one.
Error
MySQL said: Documentation
Cannot connect: invalid settings.
Retry to connectClick to expand...
One of my users is unable to connect to his database using phpMyAdmin. The query is:
LOAD DATA INFILE '/tmp/phpYXZFfZ' INTO TABLE `count` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY '
And mysql reports:
#1045 - Access denied for user '<USERNAME>'@'%' (using password: YES)
The funny part is that I can connect without any problems from a shell like this:
mysql -u <USERNAME> -p<PASSWORD> -D <DATABASE_NAME>.
This server has been recently migrated from plesk9 to plesk11.5, running on a centos6 OS.
My reseller have got one plan, where option "Gestion de l'accès au serveur via SSH" (Manage SSH access to server) is on "Peut autoriser l'accès uniquement à un environnement chrooté" (Can autorize access only in chrooted environment).
This plan contains only one subscription in which I would like to permit users to use sftp. If I go in the subscription, and then I click on "Customize subscription", I can see option "Gestion de l'accès au serveur via SSH" (Manage SSH access to server) is on "Peut autoriser l'accès uniquement à un environnement chrooté" (Can autorize access only in chrooted environment)...
=> So same than in the plan.
After that, when I click on subscription => WebSites and Domain => One domain => FTP Access and I choose a ftp user, I don't have any option to allow ssh access to the user.
I'm using Plesk Panel 12 on Debian GNU/Linux 7.6 server. I created a ftp user in a subdomain (sub.domain.tld) of my domain (domain.tld).
In Tools and settings = Policy security, I allowed sftp and ftp connections. When I try to connect I get this message :
Code:
sftp my_user@domain.tld
Connection closed
In the password file I got :
Code:
my_user:x:10000:1003::/var/www/vhosts/domain.tld/sub.mydomain.tld/httpdocs:/bin/false
Is there any way to give a reseller or customer access to the php custom settings box labeled "Additional configuration directives" on the website & domains -> php settings button that an admin can see and alter? We have attempted to give resellers the "Common PHP settings management" and "Setup of potentially insecure web scripting options that override provider's policy" options, but it still does not show up to a reseller.
View 1 Replies View RelatedI have taken over management of a bunch of a dedicated servers and have a question.
What are the commands on Linux (RedHat, RHL) for giving a User access rights to a directory(ies) only.
So that this user can FTP and Telnet to the server but will be able to:
1- only upload files to these directory(ies)
2- only delete files/dirs from these directory(ies)
3- only execute programs residing in these directory(ies)
I seem to be having a strange problem with Plesk 12, after adding about 23 domains, i cant seem to add any more domains.
While adding the domain, it just keeps syncing, and then when i click on the subscriptions i see the domain has been added, but i cannot customise it.
I want to be able to copy 1000's of files from one subscription to another or rather from one domain to another on the server without having to FTP them each time. Is there a way which this can be done directly in Plesk and avoid the need to ftp the same 1000's of files into each subscription ? FTPing on my connection is really slow and takes 2-3 for each subscription / domain, whereas if I could just FTP to the server once and then copy&paste the files between subscriptions then this would save me a huge amount of time...
View 2 Replies View RelatedAfter upgrading (i know, i should not do this) from Squeeze to Wheezy i have got a problem with subscriptions.Plesk seems to work, but whein i want do manage a domain/hosting. i just see 502 Bad Gateway nginxClick to expand...
View 7 Replies View RelatedI imported backups in Plesk 12 from Plesk 9.5.4.
I can access 4 out of 5 domains in my subscritions, but one domain dosn't appear in the list.
The 4 working domains are "Default Domain", the one i can't access is "unlimited".
In the list of packages i can click on the number of subscriptions and see the domains, but if click on the 1 unlimited subscription nothing gets listed / no elements found.
The domains is online, but i can't access it with plesk.
Quote:
A software developer has uncovered a bug in most versions of Linux that could allow untrusted users to gain complete control over the open-source operating system.
The null pointer dereference flaw was only fixed in the upcoming 2.6.32 release candidate of the Linux kernel, making virtually all production versions in use at the moment vulnerable. While attacks can be prevented by implementing a common feature known as mmap_min_addr, the RHEL distribution, short for Red Hat Enterprise Linux, doesn't properly implement that protection, Brad Spengler, who discovered the bug in mid October, told The Register.
Read the complete article at The Register. New kernels are available for Redhat and CentOS (obviously), and likely others who may be affected.
Can't add new subscriptions or domains/ subdomain after upgrade. Upgraded to 12.0.18 today and can no longer add domains or subdomains. When I try create a new subscription I get the following error:
New configuration files for the Apache web server were not created due to the errors in configuration templates:
Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error =
Template_Exception: No data. file: /usr/local/psa/admin/plib/Template/Processor.php line: 28 code: 0 Previous error: Template_Variable_Exception: No data. file: /usr/local/psa/admin/plib/Template/Variable/AbstractCachedData.php line: 67 code: 0.
Detailed error descriptions were sent to you by email. Please resolve the issues and click here to generate broken configuration files once again or here to generate all configuration files.
Trying to generate all configuration files OR generate broken configuration files doesnt work. Still get the same error.
When I try can create a subdomain I get the error:
.............
Error: proftpd-config failed: mktemp: failed to create file via template `/etc/proftpd.d/50-plesk.conf.XXXXXX': No such file or directory
Can not create temporary file
...........
This solution [URL] ..... doesnt work that just says 'ls: cannot access /etc/proftpd.d/: No such file or directory'
I tried yum update proftpd to see if that would do anything but get this...
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* atomic: mir01.syntis.net
193 packages excluded due to repository priority protections
Setting up Update Process
No Match for argument: proftpd
No package proftpd available.
No Packages marked for Update
In plesk, ProFTPD ftpserver is showing as installed.
I have migrated User from Confixx 3.3.9 to Plesk and now it works fine.
In the Subscriptions i have disable the Feature Backup for the Costumers, but it dosent take an effect.
So i Turn it on and off again. But there was also no effect.
Any time I attempt to create a customer, subscription, domain, anything I get the error "The password should be between 5 and 20 characters in length.". The password is exactly like that. On some pages it gives an error to the username I chose and the error just explains what a username is (??)....
The only actual error I've seen is one from creating an account via the command line. It was a PHP error relating to a function having issues with the encoding or something. (I think this is only relating to sending feedback though?)
Error occurred while sending feedback. HTTP code returned: 502 PHP Notice: iconv(): Wrong charset, conversion from `ISO-8859-1' to `UTF-8//TRANSLIT' is not allowed; File: /usr/local/psa/admin/plib/api-common/cu.php, Line: 599
Error occurred while sending feedback. HTTP code returned: 502 PHP Notice: iconv(): Wrong charset, conversion from `ISO-8859-1' to `UTF-8' is not allowed; File: /usr/local/psa/admin/plib/api-common/cu.php, Line: 597..I've tried OpenSuSE 12.3 with Plesk 11.5 and 12 and I'm now on OpenSuSE 13.1 with the latest Plesk 12.
I've been happily copy databases between subscriptions in Plesk 11.5xx for years but having updated to 12 the feature no longer works.
In the copy database screen when the 'local MySQL server' option is selected in the drop down the 'Copy to existing database' radio button is disabled.
My service provider tells me this is a feature change.
If you would disable a subscription and reloaded that domain name. You would be redirected to a default subscription. How can i change this default landing page?
View 2 Replies View RelatedAfter a migration I did this weekend I mis a couple of the migrated domains in the subscription list. The domains are working great, but I cannot find them in Plesk.
I got this errors in the migration manager:
Info:
The password was generated for user 'Domain Administrator (domain.com)'. New password is 'GA66QgQ'
Warning:
Execution of /opt/psa/admin/plib/api-cli/user.php --create domain.com -owner admin -guid cfa43606-e8b0-444c-a005-660984840498 -cname Domain Administrator (domain.com) -passwd '' -status disabled -domain-admin true -email '' -external-email true -role Domain Administrator (domain.com) -country NL -legacy-user false -subscription-name domain.com -ignore-nonexistent-options failed with return code 1.
Stderr is
Error during user creation: Owner with id 1 has not subscription with id 69
Warning: domain "domain.com"
Execution of /opt/psa/admin/bin/backup_restore_helper --restore-legacy-dlu domain.com -dlu-info /opt/psa/PMM/tmp/deployer_legacy_dluIrjcWa -ignore-nonexistent-options failed with return code 1.
Stderr is
Unable to create Account object: Account: unable to select: no such row in the tableClick to expand...
I got a new Server with Plesk 12.0.8 (old one has 11.5.30). Now I have to migrate all Subscriptions of the old System into the new one.
I tested it with one item and all time I get this warning:
Warning:SSL certificate "default certificate" Execution of /opt/psa/admin/plib/api-cli/certificate.php --create default certificate -cert-file /opt/psa/PMM/tmp/pmm-cert-GzVcei -key-file /opt/psa/PMM/tmp/pmm-privkey-PgXbaU -print-signature -admin -ignore-nonexistent-options failed with return code 1. Stderr is Unable to create certificate "default certificate": Unable to set the private key: Probably, the private key format is invalid.
I have a Plesk 12.0.18 on Centos Server. All subscriptions works fine, but one subscription have a domain with this problem.
When i change the domain prefix to "www.mydomain.com" or to "mydomain.com", this still stuck to "Waiting...".
When this happens, the rest of the server still works fine, but will not let me make any changes to the rest of subscriptions.
I try to edit the apache vhosts, but this looks fine.
I have a 'Service Plan' which has 270 subscriptions associated with it. When I navigate to 'Service Plans' page, underneath my plan it reads "Unable to sync subscriptions with the service plan" along with a yellow exclamation mark.
If I go into the plan there is another message near the "Update & Sync" button stating that syncing will take time and therefore be run in the background. When I click the "Update & Sync" button nothing appears to happen. If I then click on the plan again, as if to edit the settings I get the following "Warning: Subscriptions are currently syncing with the service plan. Please wait until the sync process is finished." and it prevents me from accessing the plan settings.
If I wait a while, I can eventually get into the plan settings again, which should mean that the Update & Sync has completed. However the "Unable to sync subscriptions with the service plan" warning is still present under my custom plan on the 'Service Plans' page and if I navigate to a subscription to check if it has been updated it hasn't.
If I change the subscription plan to another plan and then change it back to my original plan again, then the changes are reflected. But this is obviously a workaround.
Why doesn't the "Update & Sync" button do as it should?
Why is my plan "Unable to sync subscriptions with the service plan"?
Getting this error on the customer, domain and subscriptions pages on Plesk 11.5 update 5.
Running CentOS 5.9
Recently I've tested the usage of domain keys on my plesk 12 server. The feature works without problems. I'm wondering however if it's possible to activate the domain keys by a service plan or subscription model. If not, for all my domains (65) I've to activate them manually and for each domain iIll create in the future I have to activate it too.
View 6 Replies View RelatedI have following Warning when creating a new Domain inside a Subscriptions:
I found this Article: [URL] .....
But in my case this does not solve the Problem.
1> All permissions are right.
2> When I type command '/usr/local/psa/bin/repair --restore-vhosts-permissions' i get the answer 'Directory permissions were successfully updated.'
3> The Order of Webuser and FTPUser (as described in the article) could also not be the problem, because in my case there is only one user (There is only Webuser and no FTP-User.)
4> When typing '/usr/local/psa/bin/repair --update-vhosts-structure' I get the following error 6 times each:
Code:
[2015-04-15 21:03:30] ERR [util_exec] proc_close() failed
Error: update-vhosts-structure failed: mkdir: cannot create directory `./webroot.kk-bits.com/logs': File exists
ERROR: Cannot relink logs. Target directory '/var/www/vhosts/webroot.kk-bits.com/logs' is in invalid state.
Unable to update the structure of the home directory: an unexpected error has occurred.
update-vhosts-structure failed: mkdir: cannot create directory `./webroot.kk-bits.com/logs': File exists
ERROR: Cannot relink logs. Target directory '/var/www/vhosts/webroot.kk-bits.com/logs' is in invalid state.
To get the error 6 times seems to mean, that i have this problem with 6 Domain.
my server has just compromised and someone can retrieve all databases on server with my root sql password.
i changed the root sql password to avoid attacking again and want to ask a question...do i have to change all user's databases password too?
many users have wordpress, forum and other php scripts with config file contains current database password.If i change their pass their sites will stop working.
How to do this without bothering users?
It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.%
Would allowing access to localhost will help and how can I do that for all users?
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.
View 7 Replies View RelatedI have done many tests and always fails.= Plesk 9.5 to Plesk 12 =
I perform a migration with several domains from Plesk 9.5 and Plesk 12, it runs well. Then I remove all the migrated domains in Plesk 12 server. Then I perform a new migration with the same domains from the same server with Plesk 9.5 to the same server with Plesk 12 and it fails.The reason is that Plesk 12 doesn't remove the databases attached to the subscriptions. The new migration tries to deploy the databases and it can't because the same databases with the same users are deployed already.
I tried to remove the databases with `plesk bin database` and it was not enough. Maybe the same error will show when you migrate from Plesk 11.5/12 to Plesk 12.