1 have to create a new user, for example "webmaster" with ftp access, plesk access and database access.
My problem is: after i make all, this user can see all database for this domain. Can i show him only 1 database (him database)? If yes, how i can do?
After upgrading to plesk 12 over the weekend. None of my mail users can authenticate.I'm receiving quite a few error messages such as this for my ipmap users
authpsa[3822]: No such user 'bstewart@mwfbooks.com' in mail authorization database
courier-imapd: LOGIN FAILED, user=bstewart@mwfbooks.com, ip=[::ffff:69.176.116.106]
I've tried running mchk --with-spam command. But it hangs at the mail_auth_dump for several hours. Checking the cpu on that command and it is sitting idle.I've tried running the mail_auth_dump.worker manually and no better luck. Still nothing on the screen just hangs as if it's asleep.
Connection to the database server failed: Unknown column 'plugin' in 'mysql.user'
View 1 Replies View Relatedwhen 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'.
We use CentOS Linux 7.0.1406 (Core) with Plesk Version 12.0.18 Update #27.
We have the following problem:
When a user clicks on a database in his account and tries to login with phpmyadmin, Plesk prompts for a Password of that specific user. The message is (in german):
Code:
The site https://........:8443 responded with:
Enter the password to log in as the database user xxxxxx
When i enter the correct password a new phpmyadmin window opens and the user can use his database. A few days ago you didnt have to enter a password at all. When you were logged into Plesk as a user, you could just click "Databases -> Webadmin" and phpmyadmin opened up without Plesk asking for a password.
The question for the password is NOT coming from phpmyadmin. Its from Plesk itself. After i enter the correct password plesk hands the request over to PMA.
For debugging i created a new database for a user and i could enter its database without any problem. No password was required. But the existing old databases now all require a password. So obviously Plesk is not aware of these passwords anymore. I guess they are/were stored somewhere.
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
I'd like to give my username on my server permission to access g++ to compile custom C++ programs. I know I can just su - and compile as root, but I really don't like that.
What do I need to do to allow ONLY my username permission to do that?
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 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 have a domain which has a website built in Web Presence Builder. That allows people to go to http://domain.com. When they do that, for Google analytics purposes (I do not want Google Analytics to show 2 pages of http://domain.com and http://www.domain.com), I want to ensure that any request puts www. in it automatically.
View 3 Replies View RelatedWe are running Plesk 12.0.18 with MySQL (Server Version: 5.5.33-MariaDB - openSUSE package) on OpenSuSE 13.1
MySQL is running in strict mode and its fine for the most of our customers. But some are trying to run Contenido, thats a CMS, which could work with this mode and we have to disable mysql strict mode.
So my question is: Is it possible to disable mysql strict mode just for choosen customers?
How to install PHP (v.5.3+) compatible with Plesk v.12.08 with support for sockets and pthreads, mysql and etc. for Centos 6.5 (I have some configuring options).
Should I build it or there are another options provided by Plesk panel?
I need only one PHP (not multiple releases) but fine working if possible.
I want to create a webpage where users can make a SRV record. I thought this is possible with the Plesk API but i dont have any expierance with the API. How to create it?
View 3 Replies View RelatedI try to backup server and become error
Code:
# plesk bin pleskbackup server
UNIVERSAL->import is deprecated and will be removed in a future perl at (eval 13) line 3.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run.pm line 1060.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/IO.pm line 78.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/Timer.pm line 161.
Runtime error: Could not run make dump with pmmcli[Illegal seek]
Code:
# /usr/local/psa/admin/sbin/pmmcli
Traceback (most recent call last):
File "/usr/local/psa/admin/sbin/pmmcli", line 5, in <module>
import pmmcli
File "/usr/local/psa/admin/share/pmmcli/pmmcli.py", line 21, in <module>
import pmmcli_session
File "/usr/local/psa/admin/share/pmmcli/pmmcli_session.py", line 15, in <module>
import pmm_migration_handler
File "/usr/local/psa/admin/share/pmmcli/pmm_migration_handler.py", line 16, in <module>
import migration_handler
ImportError: Bad magic number in /usr/local/psa/admin/share/migration-handler/migration_handler.pyc
OS: Centos 6.5
Plesk 12.0.18 Update #23
Rouncube 1.0.0
I have had Roundcube installed and I went and changed the mail server from Courier to Dovecot. Is the installation of Dovecot supposed to make the 'Filters' tab appear in RoundCube or is there more that is supposed to be done?I tried reinstalling Dovecot & Roundcube and the settings still do not appear.
I have a issue when i try to start the DNS bing server over my vps with Centos 7 and plesk 12 its shows me this error
Error: Unable to make action: Unable to manage service by dnsmng: Empty error message from utility. ('--start', 'dns')
what is SSH command - to make a new database with database name as ( ra_ra ) with database user as ( ra_ra ) and database password as 'ra'
View 4 Replies View RelatedI have manually removed a user from the Ubuntu OS. The user isn't present in the Plesk-UI too.On my Vhosts SuexecUserGroup is still set to this non existent user. So the apache can't restart...
Apache message:
bad user name xxx
Action 'configtest' failed.
Are there corresponding UI-fields in Plesk or can I edit any Plesk-Db-Table to fix this?How is SuexecUserGroup set by Plesk?
Is it possible to make Joomla connect to an external mysql database server?
Meaning, the database for Joomla won't be local, but on another server.
Will it work by just entering the mysql hostname, user and password in Joomla's config?
What issues might arose by doing this?
I've been messing about a lot recently and I've had to rebuild my VPS template a lot in the past month. For some reason, Plesk is finding user data from a bunch of previous instances, so I've got to a point now where it's saying users exist when they can't be found in the panel interface.
I don't know how my VPS provider's infrastructure works but I'd presume that when I rebuild the server it's a total new instance and no data should carry over.
Is the the user data stored locally, and how would I go about clearing out the obsolete data?
Is it possible to set the subscription shell option of an subscription via xml api? I see it is possible via cmd "/usr/local/psa/bin/subscription -u {subscription} -shell /usr/local/psa/bin/chrootsh" But how is it possible via xml api?
View 1 Replies View RelatedI need to create a SSH account for an subscription. This account is not allowed to access other domains. How do i do that?
I know how to create an SSH account with remote access.
I use Plesk 11.5.30 on my vServer. I created a new domain with a new web user and /bin/bash (chroot) setting. I can't login with a SFTP connection to this domain only normal FTP connection works. With existing users I don't have this problem.
View 1 Replies View RelatedWe have a website under httpdocs/. We can change/delete files with a ftp user : "ftpold". All is ok. We must create another ftp access for another company which can access only to httpdocs directory (not to logs/, error_docs/...).
So we have create a ftp access in Plesk. But with this ftp connexion, we can not update/delete files ou update rights.
So we decide to change rights on the files/directories under httpdocs with the new ftp access :
httpdocs# chown -R ftpnewsacln *
The is no errors but the files:directories are always with the old ftp user :
httpdocs# ls -l
ftpold psacln ... libs/
ftpold pscln ... index.php
Why ? How can i create another ftp access ?
I have a virtual server linux with Strato. When I have upgrade from 11.5 to 12.0.18 in spanish I have seen that I can´t add a new domain in power user. The user has ilimited domains and I have less that 10 domains. I see the buttom of "add domain" as in 11.5 and appears all the fields to complete, but there is not buttom to accept o decline. There is no problem with alias or subdomain. I have reinstall 11.5 and dissapeared the problem, but when I upgrade again to 12.0 this buttom doesn´t appear.
View 1 Replies View RelatedI'm running a brand new installed VPS with CentOS 6.6 and Plesk 12.0.18. I created a subscription and by default a FTP user is created. However, I cannot login with these credentials. I also created a new user but the same problem presists. I'm 100% sure that the username and password is correct.
Filezilla gives me and 530 Login incorrect. But if I look at the /var/log/secure file, I see this odd message (FTP username = test):
Jan 30 16:01:45 transip proftpd: PAM unable to dlopen(/lib64/security/pam_stack.so): /lib64/security/pam_stack.so: cannot open shared object file: No such file or directory
Jan 30 16:01:45 transip proftpd: PAM adding faulty module: /lib64/security/pam_stack.so
Jan 30 16:01:45 transip proftpd: pam_listfile(proftpd:auth): Couldn't open /etc/ftpusers
Jan 30 16:01:45 transip proftpd[18085]: 127.0.0.1 (x.x.x.x[x.x.x.x]) - USER test (Login failed): No such user found
No such user found, although it is created with Plesk.
How can I create an FTP user read-only in plesk 11.5?
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)