API: Mysql Update problem

Hi there,

I have problem with API command: sites_database_update I got this error:

Wrong Version

Please, can you help me what is wrong? My code is:

Code:

$params = array(
                'server_id' => $server_id,
                'type' => 'mysql',
                'database_name' => $database_name,
                'database_user' => $database_name,
                'database_password' => $database_password,
                'database_charset' => $database_charset,
                'remote_access' => 'y',
                'remote_ips' => '%',
                'active' => 'y',
);

 try {
  $first = $client->client_get_id($session_id,$ADM_User->ispid);
  $update = $client->sites_database_update($session_id, $first, $database_id, $params);
  return $res;     
 } catch (SoapFault $e) {
 	return $e->getMessage();
 }

 

I found the primary problem but... I have secondary problem...

When a create a new database in api, the password has format like:

*59046E90AC274ECDD88C8983B47A0156BD2CD7BA

But when I edit a mysql from api (sites_database_update) the password is like:

78d1fe0f0064cf6654940c87d99d4456

And problem is, when I edit the password, I cannot login to database, which edit. In mysql log is that the password was changed, but I cannot login. I think, problem is in password hashing? Or..? Is this bug or its my problem?

Thanks very mich

 

any ideas please? I cant continue in my work

 

So I dont think its my script problem... When I change the password, I send it to sites_database_update as plain text. In dbispconfig is password change in hash format, but its not the same format like had password when I add database. It looks like different hashing in sites_database_add and sites_database_update.

I hope you know what I mean

Here is output from params sent to sites_database_update:

Code:

Array ( [server_id] => 2 [type] => mysql [database_name] => d6ccc [database_user] => d6ccc [database_password] => noveheslo123 [database_charset] => utf8 [remote_access] => y [remote_ips] => % [active] => y )

 

I upgraded all from svn and now I get this error in editing:

SOAP Error: Call to undefined method db::affectedRows()

WTF? Im little bit nervous from this After every upgrade is something wrong One problem solving, another I find

Please help me when may be problem... Same function - sites_database_update.

EDIT: NOT only in this function, this error I got on every functions (

 

Im sorry, I run update_from_svn.sh script in /usr/local/ispconfig/server/scripts and I dont check what contains. I try to svn official branch.

Thank you and sorry for my stupidity...

 

Everything works fine. Thanks.

The last problem still away... When I update mysql password from api, in ispconfig database has changed, but has different hash format like newly created mysql database. Because this, I cannot login in to mysql with changed password.... I really dont know where is the problem... API result is 1 affected row, looks all is fine, but password is changed in different hash or.. I dont know....I dont know where look up for errors, or how debug...

 

I'm also having this same MySQL Database Update Password Problem via API.

This is what i've noticed.

Updating password from ISPConfig to "test" works fine:
web_database database_password field value is updated to:
*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29

Updating password via API sites_database_update to "test" does not work:
web_database database_password field value is updated to:
098f6bcd4621d373cade4e832627b4f6

Looks like the encryption/hash used is different.
During API sites_database_add, the password is added properly.

Any help/assistance here?

 

Just an update.

I see in database.tform.php:

However, there is no "encryption" type of "MYSQL" here in remoting_lib.inc.php:

First time i've looked at the actual coding of ISPConfig so i may be wrong but i assume the lib file is missing an elseif encryption == "MYSQL"? Please advise

 

Thanks for your reply.

Did you see my last post right before your reply?

should this not be instead the following (SIMILAR to the code to INSERT):

 

Glad i could help