Announce update for mailfilters

[osterhase]

Hi there!

I'm still struggeling to implement the possibility for my roundcube users to edit their spamfilters via the webinterface using the according roundcube-plugin. My newest plan:

The filterrules are written into a file (roundcube.sieve) - the syntax of this file is fully understood by ispconfig due to the fact that it is a regular sieve syntax.

I managed to convince the roundcube-plugin to insert the content of the file into dbispconfig.mail_user.custom_mailfilter. But obviously it is not respected by the server.sh as an update and so it is not written into file and takes no effect.

Here is my question: How can I convince ispconfig 3.0.3.3 do run an update for mail_filter_edit?

In a bigger frame: Is that generally possible?

I would - as always - appreciate any suggestions.

[till]

I managed to convince the roundcube-plugin to insert the content of the file into dbispconfig.mail_user.custom_mailfilter. But obviously it is not respected by the server.sh as an update and so it is not written into file and takes no effect.

If you want to update a field in the ispconfig database, use the datalogUpdate function of the ispconfig mysql library or the remoting API. If you do the updates without these functions, then all changes will be ignored.

[osterhase]

Thanks for your fast reply. Just to unterstand the concept:

API: Is basically meant to create an interface between (in this case) roundcube and ISPConfig. A php-script is wirtten that logs into ISPConfig as a remote-user which is equipped with certain rights (f.e. mail-user-edit) and makes certain changes defined in the scirpt.

...so I think I'll try to go with the API-solution.

I had a look at the examples and I think that the soap-mail-user-update.php file is my one. Due to the fact, that I only want to update one field in the db-table I wanted to ask if this is possible via API.

Currently all fields in the array inserted:

$params = array(	'server_id' => 1,
				'email' => 'test23@domain.ltd',
				'password' => 'testen',
				'quota' => '10',
				'maildir' => '/var/vmail/domain.ltd/test23',
				'homedir' => '/var/vmail',
				'uid' => '5000',
				'gid' => '5000',
				'postfix' => 'y',
				'disableimap' => 'n',
				'disablepop3' => 'n');

If this is not possible and the entire record is written completly new using the mail_user_update function it would be the best way to query the current entries from the db, save them as variables and then send them back to the params array, like:

$params = array(	'server_id' => 1,
				'email' => $email,
				'password' => $pass,
(...)

Am I correct here or completly of the track?

References:
http://www.howtoforge.com/how-to-cre...or-ispconfig-3

And: /tmp/ispconfig3_install/remoting_client/examples/soap-mailuser-update.php

A punch into any direction is appreciated (whereas "give up" does not count).

[till]

You can not update a single field. A update call has to contain all fields. So the easiest way is to use the mail user get function to retrive the current mailuser, the function returns an array of all fields of that mailuser, then change the value that you intended to cahnge and pass the whole array back as $params to the mail user update function.

[osterhase]

Sorry to bother again... do you mean the function that is defined in remoting.inc.php? I got up that bit of the code that calls the function but don't know how to get the array returned or printed. I would appreciate your help.

Ah - by the way - am I right that the primary_id is the mail_user_id? (or how is the mailuser defined?)

<?php

$username = 'xxx';
$password = 'xxx';

$soap_location = 'http://localhost:8005/remote/index.php';
$soap_uri = 'http://localhost:8005/remote/';


$client = new SoapClient(null, array('location' => $soap_location,
                                     'uri'      => $soap_uri));

try {
	if($session_id = $client->login($username,$password)) {
		echo 'Login sucessful. Session-ID:'.$session_id.'<br />';
	}

	$primary_id = 108;
	$domain__id = $client->mail_user_get($session_id, $primary_id);

		if($client->logout($session_id)) {
		echo 'Logout succesful.<br />';
	}

	
} catch (SoapFault $e) {
	die('SOAP Blad: '.$e->getMessage());
}

?>

[till]

Yes, thats the function. You just have to pass the mailuser_id to the function and it will return the mailuser record-