API: Mysql Update problem

[Matt43]

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?

[Matt43]

Just an update.

I see in database.tform.php:

'database_password' => array (
'datatype' => 'VARCHAR',
'formtype' => 'PASSWORD',
'encryption' => 'MYSQL',
'default' => '',
'value' => '',
'width' => '30',
'maxlength' => '255'
),

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

if($field['formtype'] == 'PASSWORD') {
if($field['encryption'] == 'CRYPT') {
$record[$key] = $app->auth->crypt_password(stripslashes($record[$key]));
} else {
$record[$key] = md5($record[$key]);
}
$sql_update .= "`$key` = '".$record[$key]."', ";
}

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

[till]

There is nothing missing in the current ISPConfig version and the database update function works fine. If there is something missing in your files, then you should update your server to ISPConfig 3.0.4.3.

Beside that, if you use the database update function, the password field has to be empty in case that that password has not been changed.

[Matt43]

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):

if($field['formtype'] == 'PASSWORD') {
if($field['encryption'] == 'CRYPT') {
$record[$key] = $app->auth->crypt_password(stripslashes($record[$key]));
$sql_update .= "`$key` = '".$record[$key]."', ";
} else if($field['encryption'] == 'MYSQL') {
$record[$key] = md5($record[$key]);
$sql_update .= "`$key` = PASSWORD('".$app->db->quote($record[$key])."'), ";
} else {
$record[$key] = md5($record[$key]);
$sql_update .= "`$key` = '".$record[$key]."', ";
}
}

[till]

Yes, your right. I did not see your post. I just looked at the insert branch which has all functions and not the update branch. I will fix that in svn stable.

[Matt43]

Glad i could help