Cmd_db

[Marckus_e]

Hi!

Do i need to use the domain value when sending data or is it enough to use only the rest?

name, username and password that is.

Best regards
Marcus

[l0rdphi1]

CMD_API_DB doens't need a domain. The other info is good enough.

[Marckus_e]

Thanks for the quick answer!

/Marcus

[Marckus_e]

I am trying to create a db with my user

and i get

The request you've made cannot be executed because it does not exist in your authority level

Code

$sock = new HTTPSocket;

$sock->connect('ssl://ipnumber',2222);
$sock->set_login($dauser,$dapwd);

$sock->set_method('POST');

$sock->query('/CMD_API_DB',
array('action' => 'create',
'name' => $slices[2],
'user' => $dauser,
'passwd' => $dapwd,
'passwd2' => $dapwd2
));
$result = $sock->fetch_body();

[l0rdphi1]

Actually, yes, that's a problem. Maybe we can get John to fix this for the next version - Users should be able to manipulate themselves using any applicable APIs.

This is what I'm using in iTron: $socket->set_login("{admin}|{user}","{admin_passwd}");

[Marckus_e]

So i need to login as admin | user and adminpassword?

Best regards
Marcus

[l0rdphi1]

Yes, say we have an admin named super (whose password is cheese) and a user named frank.

We'd use: super|frank:cheese

[Marckus_e]

$sock->set_login('admin|user,'adminpwd');

That is correct right?

Still getting error.

Best regards
Marcus

[l0rdphi1]

Yeah, I meant super|frank:cheese as:

$obj->set_login("super|frank","cheese");

[DirectAdmin Support]

Hello,

There is no CMD_API_DB ... only CMD_API_DATABASES

John

[Marckus_e]

CMD_API_DATABASES does what?

/Marcus

[DirectAdmin Support]

http://www.directadmin.com/api.html#user_apis

CMD_API_DATABASES is listed starting the 5th one down.. and there are 3 of them. They used for listing databases, creating databases, and deleting databases.

John

[Marckus_e]

Thank you for the quick support!

Just what i was looking after and missed, sorry!

/Marcus

[l0rdphi1]

Shoot; yes, it should be CMD_API_DATABASES. Looked right over that :)

[Marckus_e]

Problems,

i have changed to CMD_API_DATABASES, have the correct login ('admin|user','adminpwd') and all the values that are needed and still get The request you've made cannot be executed because it does not exist in your authority level

$sock = new HTTPSocket;

$sock->connect('ssl://ipnumber',2222);
$sock->set_login('admin|user','adminpwd');

$sock->set_method('POST');
$sock->query('/CMD_API_DATABASES',

array('action' => 'create',
'name' => $slices[2],
'user' => $dauser,
'passwd' => $dapwd,
'passwd2' => $dapwd ));

$result = $sock->fetch_body();
echo $result;

Also tried the username, usrpwd but no difference.

Best regards
Marcus

[Marckus_e]

Any ideas?

I have tried all kinds of different logins and changes but doesn't work so far.

Best regards
Marcus

[DirectAdmin Support]

Hello,

Is the / added automatically... try removing the / before the /CMD_API_DATABASES.

John

[Marckus_e]

It doesn't create the DB then, if i echo the result i get

Error: document not found

i removed the / before CMD_API_DATABASES

Best regards
Marcus

[DirectAdmin Support]

What happens when you run the command from your browser:

http://domain.com:2222/CMD_API_DATABASES

You should get a list of databases. Also which version of DA are you running? It's only available in 1.21.2.

John

[Marckus_e]

Thanks, Runnign 1.21.0 .. Will tell the admin to update that tomorrow!

Sorry for the problems i have been dragging up here..

THanks for the fast help!

Best regards
Marcus

[DirectAdmin Support]

If the backup system has fewer bugs, then I can force out 1.21.3 when it comes out.

John