Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 - issue

Discussion in 'HOWTO-Related Questions' started by c0mrade, Jul 6, 2008.

  1. lieb12

    lieb12 New Member

    horde login fine bit imp problem with exim centos mysql horde

    Good day!

    Great how to thanks!

    So sorry to bother you again with this problem but I have tried everything from the localhost.localdomain and r flag to cookie settings and all with no luck.

    I also cant login to imp but horde is fine. IMP auth is set to full.

    Below are some log files.

    horde log
    Jan 28 11:44:43 HORDE [error] [imp] FAILED LOGIN 10.3.4.219 to 127.0.0.1:143[imap/notls] as admin@domain [on line 258 of "/usr/share/horde/imp/lib/Auth/imp.php"]

    secure log
    Jan 28 11:01:18 success dovecot-auth: pam_succeed_if(dovecot:auth): error retrieving information about user admin
    Jan 28 11:01:20 success dovecot-auth: pam_unix(dovecot:auth): check pass; user unknown
    Jan 28 11:01:20 success dovecot-auth: pam_unix(dovecot:auth): authentication failure; logname= uid=0 euid=0 tty=dovecot ruser= rhost=::

    maillog
    Jan 28 09:53:38 success dovecot: imap-login: Aborted login: user=<admin@domain>, method=PLAIN, rip=::ffff:127.0.0.1, lip=::ffff:127.0.0.1, secured.
     
  2. topdog

    topdog New Member HowtoForge Supporter

    The problem is you are using dovecot not cyrus-imapd. The howto uses cyrus-imapd not dovecot.
     
  3. ask2me007

    ask2me007 New Member

    Mail server setup with Exim,mysql,cyrus-imapd,horde

    Dear Topdog

    Thanks for your great effort in creating a howto for the mailserver setup.I have installed the mail server as per your how to.Even though I managed to login to horde, i cant sent mail through imp.When I click the sent button, it shows a error message

    "There was an error sending your message: Failed to connect to localhost:25 [SMTP: Invalid response code received from server (code: 451, response: Temporary local problem - please try later)]"

    When i checked the horde log, it showed the following error.

    "Apr 13 21:13:12 HORDE [error] [imp] Failed to connect to localhost:25 [SMTP: Invalid response code received from server (code: 451, response: Temporary local problem - please try later)] [on line 1059 of "/usr/share/horde/imp/compose.php"]
    Apr 13 21:13:12 HORDE [debug] [horde] SQL Query by SessionHandler_mysql::read(): query = "SELECT session_data FROM horde_sessionhandler WHERE session_id = 'rooich0eqtsntihoj3q83e03j0' AND session_lastmodified > 1240067952 FOR UPDATE" [on line 105 of "/usr/share/horde/lib/Horde/SessionHandler/mysql.php"]"
    I am struck up with the installation.
    My configuration file is


    nf['debug_level'] = E_ALL;
    $conf['debug_level'] = debug;
    $conf['max_exec_time'] = 0;
    $conf['compress_pages'] = true;
    $conf['umask'] = 077;
    $conf['use_ssl'] = 2;
    $conf['server']['name'] = $_SERVER['SERVER_NAME'];
    $conf['server']['port'] = $_SERVER['SERVER_PORT'];
    $conf['session']['name'] = 'Horde';
    $conf['session']['use_only_cookies'] = true;
    $conf['session']['cache_limiter'] = 'nocache';
    $conf['session']['timeout'] = 0;
    $conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
    $conf['cookie']['path'] = '/';
    $conf['sql']['username'] = 'horde';
    $conf['sql']['password'] = 'hordepassword';
    $conf['sql']['socket'] = '/var/lib/mysql/mysql.sock';
    $conf['sql']['protocol'] = 'unix';
    $conf['sql']['database'] = 'horde';
    $conf['sql']['charset'] = 'iso-8859-1';
    $conf['sql']['phptype'] = 'mysqli';
    $conf['auth']['admins'] = array('Administrator', 'ask@ksfe.com');
    $conf['auth']['checkip'] = true;
    $conf['auth']['checkbrowser'] = true;
    $conf['auth']['alternate_login'] = false;
    $conf['auth']['redirect_on_logout'] = false;
    $conf['auth']['params']['driverconfig'] = 'horde';
    $conf['auth']['params']['table'] = 'horde_users';
    $conf['auth']['params']['username_field'] = 'user_uid';
    $conf['auth']['params']['password_field'] = 'user_pass';
    $conf['auth']['params']['encryption'] = 'md5-hex';
    $conf['auth']['params']['show_encryption'] = false;
    $conf['auth']['driver'] = 'sql';
    $conf['signup']['allow'] = false;
    //$conf['log']['priority'] = PEAR_LOG_NOTICE;
    $conf['log']['priority'] = LOG_DEBUG;
    $conf['log']['ident'] = 'HORDE';
    $conf['log']['params'] = array();
    $conf['log']['name'] = '/tmp/horde.log';
    $conf['log']['params']['append'] = true;
    $conf['log']['type'] = 'file';
    $conf['log']['enabled'] = true;
    $conf['log_accesskeys'] = false;
    $conf['prefs']['params']['driverconfig'] = 'horde';
    $conf['prefs']['driver'] = 'sql';
    $conf['datatree']['params']['driverconfig'] = 'horde';
    $conf['datatree']['driver'] = 'sql';
    $conf['group']['driver'] = 'datatree';
    $conf['cache']['default_lifetime'] = 1800;
    $conf['cache']['params']['dir'] = Horde::getTempDir();
    $conf['cache']['params']['gc'] = 86400;
    $conf['cache']['driver'] = 'file';
    $conf['token']['driver'] = 'none';
    $conf['mailer']['params']['auth'] = '0';
    $conf['mailer']['type'] = 'smtp';
    $conf['vfs']['params']['driverconfig'] = 'horde';
    $conf['vfs']['type'] = 'sql';
    $conf['sessionhandler']['params']['persistent'] = false;
    $conf['sessionhandler']['params']['rowlocking'] = true;
    $conf['sessionhandler']['params']['socket'] = '/var/lib/mysql/mysql.sock';
    $conf['sessionhandler']['params']['protocol'] = 'unix';
    $conf['sessionhandler']['params']['hostspec'] = 'localhost';
    $conf['sessionhandler']['params']['username'] = 'horde';
    $conf['sessionhandler']['params']['password'] = 'hordepassword';
    $conf['sessionhandler']['params']['database'] = 'horde';
    $conf['sessionhandler']['type'] = 'mysql';
    $conf['problems']['email'] = 'webmaster@ksfe.com';
    $conf['problems']['maildomain'] = 'ksfe.com';
    $conf['problems']['tickets'] = false;
    $conf['menu']['apps'] = array();
    $conf['menu']['always'] = true;
    $conf['menu']['links']['help'] = 'authenticated';
    $conf['menu']['links']['help_about'] = true;
    $conf['menu']['links']['options'] = 'authenticated';
    $conf['menu']['links']['problem'] = 'never';
    $conf['menu']['links']['login'] = 'all';
    $conf['menu']['links']['logout'] = 'authenticated';
    $conf['hooks']['permsdenied'] = false;
    $conf['hooks']['username'] = false;
    $conf['hooks']['preauthenticate'] = false;
    $conf['hooks']['postauthenticate'] = false;
    $conf['hooks']['authldap'] = false;
    $conf['portal']['fixed_blocks'] = array();
    $conf['accounts']['driver'] = 'null';
    $conf['imsp']['enabled'] = false;
    $conf['kolab']['enabled'] = false;

    Pls help me to settle this problem.

    Thanks in advance
     
  4. topdog

    topdog New Member HowtoForge Supporter

    The problem is not a horde problem it is an smtp problem you need to check /var/log/exim/main.log and see what the error is.

    I suspect that your clamav is not running that is why you are getting that message.
     
  5. ask2me007

    ask2me007 New Member

    Thanks Mr.Topdog
    When i checked the exim log i found the error message

    2009-04-17 18:39:23 malware acl condition: clamd: ClamAV returned /var/spool/exim/scan/1LwcCZ-0001x2-Ne: lstat() failed: Permission denied. ERROR
    2009-04-22 18:39:23 H=localhost.localdomain (localhost) [127.0.0.1] F=<ask@example.com> temporarily rejected after DATA
    -MsgID: 1Lwcin-0003kU-6k:
    2009-04-22 19:13:14 malware acl condition: clamd: ClamAV returned /var/spool/exim/scan/1Lwcin-0003kU-6k: lstat() failed: Permission denied. ERROR
    2009-04-22 19:13:14 H=localhost.localdomain (pop.example.com) [127.0.0.1] F=<ask@example.com> temporarily rejected after DATA
    -MsgID: 1LwdBa-0003vv-1D:
    2009-04-22 19:42:26 malware acl condition: clamd: ClamAV returned /var/spool/exim/scan/1LwdBa-0003vv-1D: lstat() failed: Permission denied. ERROR
    2009-04-22 19:42:26 H=localhost.localdomain (localhost) [127.0.0.1] F=<admn@example.com> temporarily rejected after DATA
    0 messages delivered immediately to 0 total recipients

    When I tested smtp it was ready to accept connection.But it makes problem at the time of sending data.I suspect that ther is some dns problem .The problem has already seen in my previous installation.When i send mail using horde, it only shows the username and never shows the domain name at the end of the From email address and the Recepients address.
    I know this is not at all a horde problem or the howto.If you dot mind, your help is always welcome.
    Thank you
     
  6. topdog

    topdog New Member HowtoForge Supporter

    That seems like a permissions problem with selinux try disabling it and see if clamav works, you can then create a custom policy using audit2allow.
     

Share This Page