[sork] Horde Mysql Virtual user and VACATION

kyros benoit.gobe at efa.gr
Thu Oct 18 09:06:42 UTC 2007


Hello everybody !  

   I work with :
      - Ubuntu 7.04
      - Postfix  2.3.8-2, 
      - Maildrop 2.0.2,
      - courier-imap 4.1, 
      - SpamAssassin and Amavis
      - MySQL 5, 
      - Apache 2 with ssl.
      - horde-webmail-1.0.1,
      - postfixadmin 2.2 ,

   Horde Webmail is working correctly, ( I suppose ) I manage everything,
send and receive Emails,  create and move directory. My DB is ok. All my
user have a login like : john.doe at delos.school.com

  About SORK, specialy VACATION :

   In  DB, I create 3 columns in the Mailbox table ( users table ) :
vacation ( y or n ) ENUM , vacation_msg ( autoresponding messages) 
LONGTEXT, vacation_sub ( autoresponding subject ) VARCHAR 120.

   I modified the conf.php like that :

$conf['vacation']['path'] = '/usr/bin/vacation';  source :  apt-get install
vacation
$conf['vacation']['default'] = 'Subject: ' . _("On vacation message") . "\n"
. _("I'm on vacation and will not be reading my mail for a while.") . "\n" .
_("Your mail will be dealt with when I return.") . "\n";;
$conf['vacation']['subject'] = true;
$conf['vacation']['from'] = false;
$conf['server']['params']['default']['persistent'] = false;
$conf['server']['params']['default']['username'] = 'userdb';
$conf['server']['params']['default']['password'] = 'password';
$conf['server']['params']['default']['hostspec'] = 'localhost';
$conf['server']['params']['default']['port'] = 3306;
$conf['server']['params']['default']['protocol'] = 'tcp';
$conf['server']['params']['default']['database'] = 'postfix';
$conf['server']['params']['default']['charset'] = 'iso-8859-1';
$conf['server']['params']['default']['phptype'] = 'mysql';
$conf['server']['params']['default']['table'] = 'mailbox';
$conf['server']['params']['default']['user_col'] = 'username';
$conf['server']['params']['default']['pass_col'] = 'password';
$conf['server']['params']['default']['message'] = 'vacation_msg';
$conf['server']['params']['default']['subject'] = 'vacation_sub';
$conf['server']['params']['default']['vacation'] = 'vacation';
$conf['server']['params']['default']['driverconfig'] = 'custom';
$conf['server']['params']['default']['hordeauth'] = 'full';
$conf['server']['params']['encryption'] = 'crypt-md5';
$conf['server']['params']['show_encryption'] = false;
$conf['server']['driver'] = 'sql';
$conf['aliases']['show'] = true;
$conf['aliases']['driver'] = 'none';


   When I activate the autoresponding message into the WebInterface , it
write that Its ok, but when I verify the DB, nothing is changing.

   If I modify $conf['server']['params']['default']['hordeauth'] = 'full';
to "NO" , there is a new occurence created in the MAILBOX table, like :
john.doe ( without @delos.school.com) with the right subject and MSG.

   So, now, I am lost because I dont know what is wrong. I read a lot of
POSTs in forums, try some but nothing ...

   I have some specifics questions to try to help me :

    - 1st : I install package ( apt-get install vacation) to have a
software, it's the good software ?

    - 2nd : In some forum, I read that I should modify the master.cf of my
postfix configuration, it's right ?

    - 3rd  : should I activate some thing else into the horde configuration
to work ?

  Best regards !

              B. Gobé

   



-----
:working::super::handshake::drunk:B-)
-- 
View this message in context: http://www.nabble.com/Horde-Mysql-Virtual-user-and-VACATION-tf4632518.html#a13228499
Sent from the Horde - Sork mailing list archive at Nabble.com.



More information about the sork mailing list