Plesk 12.x / Linux :: Prompt For Password When User Clicks On Database In Account
Dec 4, 2014
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.
I've been trying to set the Rsync works without prompt for user's password via merging keys, but after sending the rsa key and trying to merge keys I got the error
# ssh USER@IP mergekeys bash: mergekeys: command not found
In Plesk (V. 12.0.18) there is no possibility to create mail accounts for subdomains via web interface. The KB article [URL] ..... describes this problem. The article suggests two possible ways.
I don´t want to use option 1 (create subdomain as additional domain) because a subdomain as domain wastes a domain in the license model.
Instead of that I tried the second way (command line interface). I can execute the first command without problems. When I try to execute the second command, I get the following error: "An error occured during mailname creation: Unable to set password: Domain of type subdomain selected".
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.
When I change an email address on a user's account I get this error?
Code:
Internal error: mailmng-mailname failed: Unable to open dir /var/qmail/mailnames/mydomain.com/stevebrown/@attachments: No such file or directory System error 2: No such file or directory
Message mailmng-mailname failed: Unable to open dir /var/qmail/mailnames/bullochrec.com/stevebrown/@attachments: No such file or directory System error 2: No such file or directory File Agent.php Line 243 Type PleskUtilException
From admin account there is no problem to create databases.I`ve run bootstrap.sh repair successfully but still not working.Plesk 12.0.18 #55 Ubuntu Linux 10.04
today i changed the password for the admin panel for a customer (username eg. mylogin). 10 minutes later he called me and said that he cannot get into his emailaccount anymore. Checked the password and saw that the emailpassword for his emailaddress (eg. mylogin@mydomain.com) is now the same from the admin panel login. So i changed the emailpassword and checked the admin panel login - it now has the emailpassword. What a mess.. I'm running Plesk Panel 11.5.30 MU47.
We are planning to move the mail accounts and domains from plesk to other control panel. Is there any way to view the password of the accounts (domain and emails) of plesk. So we can create the same accounts on new server with same password.
I have a problem with one of my user accounts (let's call it testuser) in Plesk. System is Windows Server 2012 R2 with Plesk 12.In the Control Panel, the customer and subscription for testuser are removed, so there should not be any data left for the domain/user.
However, when I want to create a new subscription with the username testuser, Plesk gives the error "User account already exists". I tried to manually remove the domain and took the following steps:
Code: C:Program Files (x86)ParallelsPleskbin>customer --remove testuser An error occurred during removal of customer account: testuser does not exist
C:Program Files (x86)ParallelsPleskbin>webuser --remove testuser The web user with the name 'testuser' does not exist
C:Program Files (x86)ParallelsPleskbin>ftpsubaccount --remove testuser -do main testdomain.tld Unable to remove FTP account: Unable to find service node for web service on dom ain with id=0
C:Program Files (x86)ParallelsPleskbin>database --remove testuser An error occurred during database removal: database does not exist
As described in this topic, I logged in to the MySQL server and tried to remove the user:
Code:
C:Program Files (x86)ParallelsPleskMySQLbin>mysql -P8306 -uadmin -p[admin-pass] psa mysql> g SELECT id FROM `sys_users` WHERE login=`testuser` ERROR 1054 (42S22): Unknown column 'testuser' in 'where clause' mysql> g DELETE FROM `sys_users` WHERE login=`testuser` ERROR 1054 (42S22): Unknown column 'testuser' in 'where clause'
Also, the inetpub/vhosts directory for the user is correctly removed and therefore doesn't exist. Are there any other steps I can take to remove the user manually and so be able to recreate the user?
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.
from some time, the plesk password is no more stored in chrome.I mean that even I delete all passwords/history etc chrome don't ask to save password...so something changed in the login page I suppose.from same time every time I connect to any plesk panel. Chrome say that it's not safe and I have to click "advanced" to continue, even it's a new installation make some minute before.
I get an error when i try to access my webmail(horde) over the i-net i get error Unable to get webmail password every time. The error appeared when i upgraded from 11.09 to 11.5. I also followed this tutorial but it didn't worked too. --> [URL] ....
i have installed phpMyAdmin becouse I don't like the limitation of db management of Plesk, but I can't find the root password to access in it. I read that Plesk rename "root" user in "admin", but I can't find the password. Where is it?
