Plesk 12.x / Linux :: Unable To Create New Database User
Jun 22, 2015Connection to the database server failed: Unknown column 'plugin' in 'mysql.user'
View 1 RepliesConnection to the database server failed: Unknown column 'plugin' in 'mysql.user'
View 1 Replieswhen 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'.
How can I remove all previous web users, even after an uninstall, I am having trouble finishing a new installation, during the wizard because users already exist.
View 15 Replies View RelatedWhen i go to tools & setings -> notifications, i have this message:
Error: Unable to create notification: Unable to create Note object: Note: unable to select: no such row in the table.
A customer wanted me to install the Google Apps MX records. However, it seems that they are not being created in Route53, at all.
Also if I delete the existing MX reccord the change does not reflect to Route53. Try to replicate?
Fact is that you've put this module in the catalog and would get in touch with you guys to tweak it to perfection as I think it can be a real USP for small hosters like me as this utilises the power of Amazons giant network yet you only have one server to take care of for all your regular hosting.
I saw that Plesk 11 doesn't create IMAP folder like sent items, deleted items or draft, junk etc. Is possible to fix this problem?
View 15 Replies View RelatedHow can I create an FTP user read-only in plesk 11.5?
View 1 Replies View RelatedWe are having an issue when users are trying to add attachments via horde the error:
unable to create VFS directory /.horde/imp
appears. How this can be resolved?
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".
I get the following error :
Fehler: Unable to create notification: Unable to create Note object: Note: unable to select: no such row in the table
and
Fehler: Benachrichtigung kann nicht aktualisiert werden: Unable to create Note object: Note: unable to select: no such row in the table
In tools&settings -> Email Notifications
I run plesk 12.00.18#7 and i have upgrade from 11.5.30 ....
I just migrated a bunch of domains from plesk 11.5. Everything appears to be working well however when examining the maillog, I am seeing some strange errors... In this example, the message was delivered and had the spamassassin stuff in the header.
spamd: handle_user unable to find user: 'jason@xxxxxxp.com'
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.
I had Plesk 10 installed on my openSUSE system (was a low version, maybe 11 or less) and then decided to upgrade to 11.5. So I did distribution upgrades to openSUSE 12.3 and everything went smoothly, except for some services like mysql and php. So I used Plesk autoinstaller to fix the php error and edited an outdated line in mysql configuration and both services ran smoothly!
Then I downloaded Plesk autoinstaller and ran the autoinstaller, but was surprised by this error message:
===> Checking for previous installation ... found.
ERR (3) [panel]: Error during product key mode determination, details: Unable to connect to database: ; trace: #0 /usr/local/psa/admin/plib/functions.php(2821): isPpaKeyRequired()
#1 /usr/local/psa/admin/plib/common_func.php3(11): require_once('/usr/local/psa/...')
#2 /usr/local/psa/admin/plib/api-common/cu.php(5): require_once('/usr/local/psa/...')
#3 /usr/local/psa/admin/sbin/httpdmng(8): include_once('/usr/local/psa/...')
#4 (main)
Unable to connect to database:
- My MySQL version is: 5.5.33 openSUSE package
- I did run mysql_upgrade with my admin username and password (password from: /etc/psa/.psa.shadow) and it worked successfully and fixed all of the errors, I did so after running the auto installer first, but then ran the installer again and the problem was still there
- I can access my web page, but it still doesn't connect to MySQL either.
I believe this is a problem with MySQL, but how can I make sure or detect what exactly the problem is
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...
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.
Having an issue creating a brand in PPA 11.5. After configuring the brand, all tasks complete okay. After opening up the website, i receive the following error:
Bad Gateway: Web server received an invalid response while acting as a gateway or proxy server.
Web Server at branded.name.com
I have tested this on
PPA version
11.5 Update #02
and
PPA version
11.5 Update #03
Still not working. In both cases I re-created the brand.
My Plesk backup doesn't work properly. I constantly get the error "dump file has wrong format".I followed the steps in "How to verify an invalid Plesk backup file" [URL] .... and found the following:
Code:
C:UsersAdministrator>c:xmllintxmllint.exe --noout --schema "%plesk_dir%PMM
plesk.xsd" "D:Program Files (x86)ParallelsPleskBackupmanual_info_1411131008
_formatted.xml"
file:///D:/Program%20Files%20(x86)/Parallels/Plesk/Backup/manual_info_1411131008
_formatted.xml:2769:
[code]...
No matter what I do (updating settings, saving, etc.), the error keeps coming back. Seems like a database inconsistency. How can I access the Plesk DB through PhpMyAdmin to check the notifications table? When I go to Settings > Database servers > Local MySQL server > Webadmin, I only see my customers' databases.
im getting an error when im trying to create a subscription on a windows node via PPA management node, the task error is:
Method name: registerIpPlesk on SCREFleskWebIIS:0
Last execution output: This IP address XXX.XXX.XXX.XXX is already registered in Panel on the network interface Local Area Connection
the IP XXX.XXX.XXX.XXX is the correct service node IIS ip address..
In plesk 11 with os windows 2012 when i try to create any new subscription i get following error:
Error: Unable to update domain data: Execute websrvmng --add-domain "--domain-name=testDomain123.com" failed with error code 1:
what should i do? this problem happen suddenly without any changes by us.
I have parallel plesk 11.5 on my VPS hosting. Recently I upgraded the PHP version to 5.4 via Updates and Upgrades feature. Now, I am not able to change anything for any domain/website, it always shows me following error:
"Error: Unable to create or update the subscription: The PHP handler "fastcgi-5.4" is not registered. It was probably deleted from the server. Register a handler with the same properties and try again."
I tried creating a handler with same name in IIS but it didn't work. When I checked in "Server Components" the max PHP version is "PHP 5.3.28" but I see PHP 5.4 installed in C:ParallelsPleskAdditionalPleskPHP54 folder on the server.
When logged into the admin panel, I can manage all other domain except for one. When I try to manage this particular domain (which is our own domain rather than a client domain), it takes a while before returning page not found. In the logs, it's getting a high volume of the following error message:
Error: Unable to create or update the subscription: The PHP handler "fastcgi-5.3" is not registered. It was probably deleted from the server. Register a handler with the same properties and try again.
I've tried attacking the issue through IIS. PHP appears to be configured correctly in IIS. I've looked at permissions. The website itself runs fine, I just can't manage the domain.
Another issue, which may be related, is when trying to access the PHP Manager in IIS for the PleskControlManager site, it gets an error stating that it can't find the php.ini file. I don't know if this is normal, or related.
I have a server setup and running shared hosting perfectly. I duplicated one of the plans and just set it to DEDICATED IP. This is for users that will be requiring SSL.
I then went into my panel settings and added in all the additional ip's. It even says in the panel listing "6 dedicated ip's available".
Yet, when I try to re-run the task for provisioning it constantly fails with the message:
Unable to create hosting. Ip address does not exist in client's pool ....
when i try to make backup of mssql 2012 on plesk 11.5 i have the following error:Error: dbbackup failed: Unable to backup database 'DBANME'. Unable to open connection: A specified logon session does not exist. It may already have been terminated.i already configured temp/network directory,
View 6 Replies View RelatedI installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
View 1 Replies View RelatedUnable to restore database '17'
Not valid backup:
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.).
VERIFY DATABASE is terminating abnormally.
(Error code 22)
---------------------- Debug Info -------------------------------
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
12.0.18 update #39
Server 2012r2
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX'
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER