Plesk Automation :: Set User And Privileges From Mysql

Jul 3, 2014

I'd want to create a user and set custom privileges using the standard mysql-client, ie. create user and grant privileges, but I know that sometimes Plesk overwrites my config files for other services.

View 2 Replies


Backup Mysql User Privileges

Aug 26, 2007

how do i backup mysql user privileges?

this will only backup the databases:
mysqldump --opt -u root -p --all-databases > data.sql

i would like to backup mysql user privileges too.

View 1 Replies View Related

Plesk 12.x / Linux :: MySQL Routines And Triggers No Privileges

Feb 16, 2015

I need a MySQL user that has the privileges to add routines and triggers. The default users that are created by Plesk do not have these rights. How would I be able to add these rights to a specific user, or all users, that doesn't care.

I already logged in over SSH as a root user:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

Then I tried to update the rights of the users:

mysql >UPDATE db SET Create_view_priv = 'Y', Show_view_priv = 'Y', Create_routine_priv = 'Y', Alter_routine_priv = 'Y';
Query OK, 0 rows affected (0.00 sec)

This didn't work. So I wanted to add super privileges by doing this:

mysql> GRANT SUPER ON *.* TO 'user'@'%' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)

But also not of any effect. What's left to do?

View 4 Replies View Related

Serverbeach, User Privileges

Oct 19, 2007

I have a server from ServerBeach Linux Powerline 2600. CentOS5.

It even has webmin on it.

But this is what I'm trying to do, trying to add a user so the user can use apache/php/mysql/cron and cannot look into other directories like /etc

SB is taking sometime, so I thought to post here as well.

I know it's a linux admin thing, but I'd like to get some quick help as well..

View 12 Replies View Related

Plesk Automation :: Login As User From Admin / Actual Login As User Are Different

Jan 3, 2014

when I find the subscription from the admin side of PPA, if I select "Login as user" I've noticed that it is different from actually logging in as the user - for example - "add domain alias" is missing when I login as a customer - but not as an admin... I need my customers to add their own aliases and manage them - how do I add that feature to the client login side?

View 9 Replies View Related

Plesk Automation :: Change Of Permissions For User

Jul 2, 2014

I believe the product we are using is Parallels Operations Automation.

We have a customer that we want to be able to give the right to unlock user accounts. The only way to do this seems to be to enable "Billing" as one of the privileges. Unfortunately this gives them more access than we really want to. Is there some trick we can use to give this user only these rights?

View 2 Replies View Related

Plesk Automation :: Change Subscriptions User / Customer

Mar 20, 2014

I have a Customer with 22 subscriptions associated. Can I assign some of these subscriptions to another customer?

View 2 Replies View Related

Plesk Automation :: Disable Changing System User Name (FTP / SSH) For Customers?

May 26, 2015

Is it possible to disable the option to change the system user (FTP/SSH) for customers. I can disable this for the control panel user but not the system user (FTP/SSH). Is there any option to do this that I didn't see?

View 2 Replies View Related

Plesk Automation :: How To Disable Changing Of System User Settings

Aug 28, 2014

How do we disable the "change system user settings" option when a user creates a new webspace? I don't want customers to pick their own system username/passwords.

View 2 Replies View Related

Plesk Automation :: Error SMTP 550 - User Unknown In Virtual Mailbox Table

Nov 7, 2014

I have a problem with my Parallels Plesk Panel (v 11.5.30) in CentOS 6.4.

When I try to send an email by RoundCube to an other email address with the same domain (that is hosted in my server) i get this error:

Error SMTP (550): ... "" (5.1.1 <>: Recipient address rejected: User unknown in virtual mailbox table)

View 2 Replies View Related

[Cpanel::Mysql]: Not Updating Privileges

Apr 11, 2008

On a cPanel server, running RHEL 4 I got the following error (from cpanel logs) while associating an user with a DB from the cPanel admin:

Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/ line 268
Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa4a8768)') called at /usr/local/cpanel/bin/mysqladmin line 88
Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/ line 268

In fact, from cPanel interface all privileges are added OK, but the MySQL itself is not connecting at all due to this error.

I already tried:

/scripts/mysqlup --force
/scripts/upcp --force
/usr/bin/mysql_fix_privilege_tables -u root --password=PASSWORD

View 2 Replies View Related

Plesk Automation :: Prefix For MySQL / FTP And Email Accounts

Mar 14, 2014

I've configured PPA management, web server and a mysql database server. Now I want that if a customer add a mysql, ftp or mail account, that the names begins with a prefix that I've defined.

View 4 Replies View Related

Plesk Automation :: All MySQL Databases Exposed At Reseller Level

May 22, 2014

I have 2 Nodes. Both of them are configured like this:

Node1: Roles: MySQL, Apache,. Postfix; Attributes: Apache, Postfix, Webhost; restricted=>Reseller1
Node2: Roles: MySQL, Apache,. Postfix; Attributes: Apache, Postfix, Webhost; restricted=>Reseller2

I log in as Reseller1 (clean login; not by switching from PPA Admin to Reseller1), create a Webspace and a Database. At that point I am able to see and create Databases on every Node, even on Reseller1 (Node1), which is set to restricted. I guess this behaviour is not intended, isn't it?

View 2 Replies View Related

Plesk Automation :: Update MySQL Version Database Node

Jun 6, 2015

Is it possible to update the MySQL version on the db nodes from 5.1 to 5.5 or is it supported?

View 3 Replies View Related

Plesk Automation :: Local Server Visible When Adding New MySQL Database

Mar 27, 2014

Somehow when customers add a new MySQL database they can select a Local MySQL server. It turns out this is the MySQL instance running on the CP server, can I somehow hide this server from the list?

View 1 Replies View Related

Plesk Automation :: MySQL Server Not Starting Anymore - Failed To Restart Service

Jun 5, 2014

What could I fix by trying to start mysql server, recieve following errors:

plesk interface:

Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start

from the console:

sudo service mysql start
start: Job failed to start

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:

[Code] ...

View 4 Replies View Related

Plesk 12.x / Linux :: Can't Change MySQL User Password

Mar 31, 2015

I try to change a mysql user password, but I get an error message:

Fehler: attribute name is invalid: status
Search for related Knowledge Base articles

I'm running12.0.18 Update Nr. 39

View 1 Replies View Related

Plesk 12.x / Windows :: Psaadm And Psacln Privileges

Feb 3, 2015

I'm trying to set permission for text file which is exists in Program Files (x86)MyFile directory. File should be accessible by psaadm and not accessible for psacln accounts. I've set permissions for psaadm Full Control Allow and for psacln Full Control Deny.

In my PHP script I'm checking file using is_readable function and no matter which user trying to read this file function always returns true (admin or customer account). I tried to find solution in Web but without success so I'd like to ask you about it.

Additionally, I've tried to create Plesk DiskSecurity XML with privileges settings. After Apply this settings privileges are correctly set for my file, but customers still can read this file.

Is there any other way to deny access to this file for customers and resellers?

View 2 Replies View Related

Plesk Automation :: Error While Installing Automation During (Getting SELinux) Step

Jul 5, 2013

I am trying to install Automation, and I keep getting an error after the "Getting SELinux" step, here is a log of the process so far:

[INFO]: Checking current user privileges...
[INFO]: Checking critical environment requirements...
[INFO]: Determining OS parameters...
[INFO]: Detected OS: CentOS-5-x86_64
[INFO]: Getting SELinux state...
[ERROR]: Unexpected error: ''

[Code] ....

I have tried running the installation on a different server and the same issue came up...

View 19 Replies View Related

Plesk Automation :: Failure To Install Automation On Centos 6.5

Apr 4, 2015

I am installing plesk automation on centos 6.5 using this command on a fresh system

./ppa_installer --password some_password --admin_email some_email

and get the following error.

[LOGTEE]: Error Downloading Packages:
[LOGTEE]: libuuid-2.17.2-12.18.el6.i686: failure: Packages/libuuid-2.17.2-12.18.el6.i686.rpm from base: [Errno 256] No more mirrors to try.

Looks like some lib is not found in the mirrors.

View 1 Replies View Related

Plesk Automation :: Automation Installer Breaks Yum In CentOS 6.6

Jan 29, 2015

On a clean install of CentOS 6.6 (Final) I did the following:

1. updated the /etc/hosts file to point my ip to the hostname

2. Open the ports in the iptables file.

3. ran the ppa_installer per the instructions on [URL] ....

The ppa_installer log says installed Successfully. However the following occurs:

1. Cannot browse to the url:8443, or any of the other variations (8080, 8880, https/http)

2. Yum installer is now broken (I replicated this twice). Yum will not run at all with the following error:

There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: /usr/lib64/ file too short

Please install a package which provides this module, or verify that the module is installed correctly.It's possible that the above module doesn't match the

current version of Python, which is:
2.6.6 (r266:84292, Jan 22 2014, 09:42:36)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)]

I am now going to try Cent OS 6.4.. will report back.

View 8 Replies View Related

Plesk 11.x / Windows :: Supplied Account Does Not Possess Administrative Privileges

Sep 1, 2013

I recently upgraded the Plesk to 11.5.30. Now I am not able to create new MySQL databases. I am getting below error.

Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'localhost' (using password: YES)

MySQL admin details are correct in plesk database, also the admin has full privileges. I am manually able to create databases, users from mysql prompt. It's just the plesk interface that's giving error.

C:Program Files (x86)ParallelsPleskMySQLbin>mysql -u admin -p*************** mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 68
Server version: 5.1.68-community MySQL Community Server (GPL)

[Code] .....

View 4 Replies View Related

Connect To MySQL DB Only On Certain User

Apr 20, 2009

I am using cPanel 11 (stable release) on a CentOS 5 server and would like to make it so that a certain database can only be connected to from the cPanel user that it is under (ie. user1_db can only be connected to from the user "user1" on the same server).

View 9 Replies View Related

How To Find Which Mysql User Is Using All Cpu

Nov 13, 2008

31015 100 15 0 151m 35m 5156 S 28 0.4 379:34.10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql

This is my top process, I have quad core server and because of this server load is over 10

I am using cPanel, is it possible to trace which user is using all this cpu?

View 6 Replies View Related

Wich User Have More Mysql Process?

May 25, 2009

How can see wich user have more mysql process?

View 2 Replies View Related

Allow User To Remote Mysql Connection

Aug 15, 2008

how to allow user to remote mysql connection from his localhost ( in linux server with WHM )

my user wants to connect to the mysql from his localhost

View 7 Replies View Related

MySQL Forgetting User Permissions

Jul 5, 2007

Does anyone know what could be the cause of this issue? I located a few others over at that have this problem, but no solution has been found.


I am running a VPS server with the following:

WHM 10.8.0 cPanel 10.9.1-S14304
RedHat 9 i686 - WHM X v3.1.0
phpMyAdmin -
MySQL client version: 4.1.10
mysql version: 5.0.27-standard

I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE".

Here's a look at the database permissions from phpMyAdmin.

User Host Password Global privileges Grant
hello localhost Yes ALL PRIVILEGES Yes
hello_ % No ALL PRIVILEGES Yes
hello_ localhost No ALL PRIVILEGES Yes

The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.

View 3 Replies View Related

Mysql/user Is Marked As Crashed

Jan 30, 2007

I am trying to start mysql but i am getting the following error

MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]

I checked my hostname.err file in /var/lib/mysql and this is the error message it shows.

070130 17:59:41 mysqld started
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 mysqld ended

how I would repair that to get mysql to start again?

View 7 Replies View Related

Copyrights 2005-15, All rights reserved