hm... Mist, ist nur ein Passwort Wechsler...
ich kann dir nur meine Änderungen auflisten, die ich bei horde-vacation gemacht habe (ich fuinde horde-webmail besser als squirrel):
die conf.php (Ausschnitt):
Code:
$conf['vacation']['default_subject'] = _("On vacation message");
$conf['vacation']['default_message'] = _("I'm on vacation and will not be reading my mail for a while.\nYour mail will be dealt with when I return.");
$conf['vacation']['subject'] = false;
$conf['vacation']['from'] = false;
$conf['server']['params']['default']['query_set'] = 'UPDATE `ispcp`.`mail_users` SET `mail_auto_respond_text` = \M, `mail_auto_respond` = 1, `status` = \'change\' WHERE mail_add
$conf['server']['params']['default']['query_unset'] = 'UPDATE `ispcp`.`mail_users` SET `mail_auto_respond` = 0, `status` = \'change\' WHERE mail_addr = \U AND `mail_pass` = \P';
$conf['server']['params']['default']['query_get'] = "SELECT IF(`mail_auto_respond`=1,'Y', 'N') AS `vacation`, `mail_auto_respond_text` AS `message`, '' AS `subject` FROM `ispcp`
$conf['server']['params']['default']['driverconfig'] = 'horde';
$conf['server']['params']['default']['hordeauth'] = false;
$conf['server']['params']['encryption'] = 'plain';
$conf['server']['params']['show_encryption'] = false;
$conf['server']['driver'] = 'ispcp';
und die Datei lib/Driver/ispcp.php als "diff-u" von customsql.php:
Code:
--- customsql.php 2009-01-29 17:02:55.000000000 +0100
+++ ispcp.php 2010-01-28 17:33:17.000000000 +0100
@@ -13,7 +13,7 @@
* @since Vacation 3.1
* @package Vacation
*/
-class Vacation_Driver_customsql extends Vacation_Driver {
+class Vacation_Driver_ispcp extends Vacation_Driver {
/**
* SQL connection object.
@@ -35,7 +35,7 @@
* @param string $user A user name.
* @param array $params Configuration parameters for the backend.
*/
- function Vacation_Driver_customsql($user, $params = array())
+ function Vacation_Driver_ispcp($user, $params = array())
{
$params = Horde::getDriverConfig('server', 'sql');
parent::Vacation_Driver($user, $params);
@@ -65,6 +65,9 @@
// Build username.
$myuser = $this->_buildUsername();
+ # ispcp
+ $password = $this->encrypt_db_password($password);
+
// Encrypt password.
$crypted_password = $this->_encryptPassword($password, $this->_getCurrentPassword($myuser));
@@ -91,6 +94,8 @@
if ($result !== DB_OK) {
return PEAR::raiseError(_("An unknown error occured while enabling the vacation notice."));
}
+ # ispCP Update...
+ $this->send_request();
}
/**
@@ -113,6 +118,9 @@
// Build username.
$myuser = $this->_buildUsername();
+ # ispcp
+ $password = $this->encrypt_db_password($password);
+
// Encrypt password.
$crypted_password = $this->_encryptPassword($password, $this->_getCurrentPassword($myuser));
@@ -135,6 +143,9 @@
if ($result !== DB_OK) {
return PEAR::raiseError(_("An unknown error occured while enabling the vacation notice."));
}
+
+ # ispCP Update...
+ $this->send_request();
}
/**
@@ -166,6 +177,9 @@
// Build username.
$myuser = $this->_buildUsername();
+ # ispcp
+ $password = $this->encrypt_db_password($password);
+
// Encrypt password.
$crypted_password = $this->_encryptPassword($password, $this->_getCurrentPassword($myuser));
@@ -205,7 +219,7 @@
if (empty($this->_params[$this->_realm]['query_password'])) {
return '';
}
-
+
// Build the SQL query.
$query = str_replace('\U',
$this->_db->quote($this->_buildUsername()),
@@ -230,7 +244,12 @@
{
if ($this->_realm === 'default' ||
$this->_realm === '') {
- return $this->_user;
+
+ $userid = Auth::getAuth();
+// $userid = Auth::getBareAuth();
+
+// return $this->_user;
+ return $userid;
} else {
return $this->_user . '@' . $this->_realm;
}
@@ -308,4 +327,120 @@
$this->_connected = true;
}
+# ispcp Funktionen
+function read_line(&$socket) {
+ $ch = '';
+ $line = '';
+ do {
+ $ch = socket_read($socket,1);
+ $line = $line . $ch;
+ } while($ch != "\r" && $ch != "\n");
+ return $line;
+}
+
+function send_request() {
+
+# global $Version;
+ $Version = 'ispCP-Horde-Passwd';
+
+ $code = 999;
+
+ @$socket = socket_create (AF_INET, SOCK_STREAM, 0);
+ if ($socket < 0) {
+ $errno = "socket_create() failed.\n";
+ return $errno;
+ }
+
+ @$result = socket_connect ($socket, '127.0.0.1', 9876);
+ if ($result == FALSE) {
+ $errno = "socket_connect() failed.\n";
+ return $errno;
+ }
+
+ /* read one line with welcome string */
+ $out = $this->read_line($socket);
+
+ list($code) = explode(' ', $out);
+ if ($code == 999) {
+ return $out;
+ }
+
+ /* send hello query */
+ $query = "helo $Version\r\n";
+ socket_write ($socket, $query, strlen ($query));
+
+ /* read one line with helo answer */
+ $out = $this->read_line($socket);
+
+ list($code) = explode(' ', $out);
+ if ($code == 999) {
+ return $out;
+ }
+
+ /* send reg check query */
+ $query = "execute query\r\n";
+ socket_write ($socket, $query, strlen ($query));
+ /* read one line key replay */
+ $execute_reply = $this->read_line($socket);
+
+ list($code) = explode(' ', $execute_reply);
+ if ($code == 999) {
+ return $out;
+ }
+
+ /* send quit query */
+ $quit_query = "bye\r\n";
+ socket_write ($socket, $quit_query, strlen ($quit_query));
+ /* read quit answer */
+ $quit_reply = $this->read_line($socket);
+
+ list($code) = explode(' ', $quit_reply);
+ if ($code == 999) {
+ return $out;
+ }
+
+ list($answer) = explode(' ', $execute_reply);
+
+ socket_close ($socket);
+
+ return $answer;
+}
+
+function encrypt_db_password($db_pass) {
+ require '/var/www/ispcp/gui/include/ispcp-db-keys.php';
+# global $ispcp_db_pass_key, $ispcp_db_pass_iv;
+
+ if (extension_loaded('mcrypt') || @dl('mcrypt.' . PHP_SHLIB_SUFFIX)) {
+ $td = @mcrypt_module_open(MCRYPT_BLOWFISH, '', 'cbc', '');
+ // Create key
+ $key = $ispcp_db_pass_key;
+ // Create the IV and determine the keysize length
+ $iv = $ispcp_db_pass_iv;
+
+ // compatibility with used perl pads
+ $block_size = @mcrypt_enc_get_block_size($td);
+ $strlen = strlen($db_pass);
+
+ $pads = $block_size-$strlen % $block_size;
+
+ $db_pass .= str_repeat(' ', $pads);
+
+ // Initialize encryption
+ @mcrypt_generic_init($td, $key, $iv);
+ // Encrypt string
+ $encrypted = @mcrypt_generic ($td, $db_pass);
+ @mcrypt_generic_deinit($td);
+ @mcrypt_module_close($td);
+
+ $text = @base64_encode("$encrypted");
+
+ // Show encrypted string
+ return trim($text);
+ } else {
+ //system_message("ERROR: The php-extension 'mcrypt' not loaded!");
+ die("ERROR: The php-extension 'mcrypt' not loaded!");
+ }
+}
+
+
}
Vielleicht siehst du damit, was ca nötig ist...
Natürlich muss der sql-User diese Tabellen ändern können (der sql-user von horde... - das habe ich mal geschrieben im Forum...)
Edit: das könnte so aussehen:
INSERT INTO `tables_priv` (`Host`, `Db`, `User`, `Table_name`, `Grantor`, `Timestamp`, `Table_priv`, `Column_priv`) VALUES
('localhost', 'ispcp', 'horde-webmail', 'mail_users', 'root', '2009-06-20 23:16:31', 'Select', 'Select,Update');
INSERT INTO `columns_priv` (`Host`, `Db`, `User`, `Table_name`, `Column_name`, `Timestamp`, `Column_priv`) VALUES
('localhost', 'ispcp', 'horde-webmail', 'mail_users', 'mail_auto_respond_text', '2009-06-20 23:17:18', 'Update'),
('localhost', 'ispcp', 'horde-webmail', 'mail_users', 'mail_auto_respond', '2009-06-20 23:17:18', 'Update'),
('localhost', 'ispcp', 'horde-webmail', 'mail_users', 'status', '2009-06-20 23:17:18', 'Update'),
('localhost', 'ispcp', 'horde-webmail', 'mail_users', 'mail_pass', '2009-06-20 23:17:18', 'Update');
oder so...
Gruss Joxi
Search
Member List
Calendar
Help
/
Webmail mit Abwesenheitsfunktion
