MysqlFE::userdbprivs() syntax

[lvt]

Can you please tell me the complete syntax of this function ? I tried with an user having several privileges but the API only returns one.

Here is the XML result :

<cpanelresult>
<apiversion>2</apiversion>
<data>
<ALTER>1</ALTER>
</data>
<func>userdbprivs</func>
<module>MysqlFE</module>
</cpanelresult>

How to use this function to show a full list of privileges ?

My API call is the following

PHP Code:

<cpanelaction><module>MysqlFE</module><func>userdbprivs</func><apiversion>2</apiversion><args><user>{$info['user']}</user><db>{$info['db']}</db></args></cpanelaction> 


Thanks.

[cPanelDavidG]

Originally Posted by lvt

Can you please tell me the complete syntax of this function ? I tried with an user having several privileges but the API only returns one.

Here is the XML result :



How to use this function to show a full list of privileges ?

My API call is the following

PHP Code:

<cpanelaction><module>MysqlFE</module><func>userdbprivs</func><apiversion>2</apiversion><args><user>{$info['user']}</user><db>{$info['db']}</db></args></cpanelaction> 


Thanks.

Your function call is returning all privileges for me. Are you seeing this user as having all privileges via the cPanel interface?

[lvt]

Originally Posted by cPanelDavidG

Your function call is returning all privileges for me. Are you seeing this user as having all privileges via the cPanel interface?

You're right, this function works fine, thanks to your suggestion I use the cPanel interface to check and I see that the API function "adduserdb" doesn't work at all. Some days ago I posted an entry about this problem here :

http://forums.cpanel.net/developer-c...tml#post531025

I think it worked but it was just an inlusion, it only works with "ALL" option, any other input will fails.

[lvt]

Let's do some tests

#1

PHP Code:

<cpanelaction><module>Mysql</module><func>adduserdb</func><apiversion>1</apiversion><args>{$info['db']}</args><args>{$info['user']}</args><args>ALL</args></cpanelaction> 


OK I have ALL checked, no problem here.

#2

PHP Code:

<cpanelaction><module>Mysql</module><func>adduserdb</func><apiversion>1</apiversion><args>{$info['db']}</args><args>{$info['user']}</args><args>INSERT DELETE</args></cpanelaction> 


This query failed !

#3

PHP Code:

<cpanelaction><module>Mysql</module><func>adduserdb</func><apiversion>1</apiversion><args>{$info['db']}</args><args>{$info['user']}</args><args>INSERTDELETE</args></cpanelaction> 


For this #3 (no space between values) I only have the "DELETE" value checked.

So how can I do to use this API properly ? Because it's important to not to give all privileges to anyone as it poses some security risk. Most of users will only need "INSERT SELECT UPDATE DELETE".

[cPanelDavidG]

https://SERVER:2083/xml-api/cpanel?user=cPanelUser&xmlin=<cpanelaction> <module>Mysql</module><func>adduserdb</func><apiversion>1</apiversion><args>cpanel_DB</args><args>cpanel_USER</args><args>INSERT DELETE</args></cpanelaction>

Works for me.

Acceptable values are as follows:

ALL SELECT CREATE INSERT ALTER UPDATE DROP DELETE LOCK INDEX REFERENCES CREATETEMPORARYTABLES

The X3 interface places spaces between these values and uses these values in the above order.

[lvt]

Originally Posted by cPanelDavidG

https://SERVER:2083/xml-api/cpanel?user=cPanelUser&xmlin=<cpanelaction> <module>Mysql</module><func>adduserdb</func><apiversion>1</apiversion><args>cpanel_DB</args><args>cpanel_USER</args><args>INSERT DELETE</args></cpanelaction>

Works for me.

Acceptable values are as follows:

ALL SELECT CREATE INSERT ALTER UPDATE DROP DELETE LOCK INDEX REFERENCES CREATETEMPORARYTABLES

The X3 interface places spaces between these values and uses these values in the above order.

Can you please test with the following cPanel version ?

11.24.4-RELEASE

[cPanelDavidG]

I'll provision a server with the latest RELEASE tonight, should be able to test on it when I'm back in the office tomorrow .

[lvt]

Originally Posted by cPanelDavidG

I'll provision a server with the latest RELEASE tonight, should be able to test on it when I'm back in the office tomorrow .

Thanks David

[cPanelDavidG]

Originally Posted by lvt

Thanks David

It's still working for me on:

cPanel 11.24.4-R36167 - WHM 11.24.2 - X 3.9
CENTOS 4.7 i686 standard

[lvt]

Originally Posted by cPanelDavidG

It's still working for me on:

cPanel 11.24.4-R36167 - WHM 11.24.2 - X 3.9
CENTOS 4.7 i686 standard

With your prompt support I have solved the problem, in fact, cPanel's APIs don't accept spaces between argument values so we need to replace all spaces by "%20" (as urlencode() usually does).

Thanks again.