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

[gsp]

Got this trying to send to you from Outlook with SMTP authorization:

2008-12-03 16:19:50 no host name found for IP address 192.168.10.199
2008-12-03 16:20:01 1L7sZy-000326-Nm <= "george@marishotels.eu"@mailsrv H=(sync4j) [192.168.10.199] P=esmtpa A=login:george@marishotels.eu S=5549 id=007c01c95551$ad097580$c70aa8c0@maris.local
2008-12-03 16:20:04 1L7sZy-000326-Nm == andrew@topdog.za.net R=dnslookup T=remote_smtp defer (-44): SMTP error from remote mail server after RCPT TO:<andrew@topdog.za.net>: host mail.topdog.za.net [209.20.66.9]: 450 4.1.8 <george@marishotels.eu@mailsrv>: Sender address rejected: Domain not found

Again this stupid login... when authenticates... (thunderbird did the same!!!)... why uses all this for user?... Without authentication works fine now...

[gsp]

Tried to upgrade to latest versions of Horde, imp, etc..

Everything seems fine but in the upgrade doc of Horde says it needs MDB2_Schema so it can run a script for updating database...

After some tries of installing it, and running the php script i get a Fatal Error: MDB2 Error: not found

I am spending hours now to find what is all this about and i cannot... any suggestions? Below is the script i am trying to run:

PHP Code:

#!/usr/bin/env php
<?php
/**
 * Fix MDB2 sequence names. Thie script changes the MDB2 sequence names from the
 * default of 'sequence' to 'id' to be consistent with all horde apps, and to
 * allow automated upgrade scripts to use MDB2_Schema in the future.
 *
 * $Horde: horde/scripts/upgrades/2008-08-29_fix_mdb2_sequences.php,v 1.1.2.5 2008/09/04 19:25:22 mrubinsk Exp $
 *
 * @author Michael J. Rubinsky <mrubinsk@horde.org>
 * @since Horde 3.2.2
 */
@define('AUTH_HANDLER', true);
@define('HORDE_BASE', dirname(__FILE__) . '/../..');

/* These are the table => key names that need to be updated */
$to_upgrade = array('ansel_shares' => 'share_id',
                    'ansel_images' => 'image_id',
                    'ansel_tags' => 'tag_id',
                    'ansel_faces' => 'face_id',
                    'genie_shares' => 'share_id',
                    'ingo_shares' => 'share_id',
                    'klutz_comics' => 'comicpic_id',
                    'kronolith_shares' => 'share_id',
                    'mnemo_shares' => 'share_id',
                    'nag_shares' => 'share_id',
                    'turba_shares' => 'share_id',
                    'whups_shares' => 'share_id');

/* Set up the CLI environment */
require_once HORDE_BASE . '/lib/core.php';
require_once 'Horde/CLI.php';
if (!Horde_CLI::runningFromCli()) {
    exit("Must be run from the command line\n");
}
$cli = &Horde_CLI::singleton();
$cli->init();

/* Grab what we need to steal the DB config */
require_once HORDE_BASE . '/config/conf.php';
require_once 'MDB2/Schema.php';
require_once 'MDB2.php';
$config = $GLOBALS['conf']['sql'];
unset($config['charset']);
$schema = MDB2_Schema::factory($config, array('seqcol_name' => 'id'));
if (is_a($schema, 'PEAR_Error')) {
    $cli->fatal($schema->getMessage());
}
$db = &MDB2::factory($config);
if (is_a($db, 'PEAR_Error')) {
    $cli->fatal($db->getMessage());
}

$db->loadModule('Manager');
$tables = $db->manager->listTables();
if (is_a($tables, 'PEAR_Error')) {
    $cli->fatal($tables->getMessage());
}

/* Update any of the tables that we have */
foreach ($to_upgrade as $table => $field) {
    if (array_search($table, $tables) !== false) {
        $results = $schema->createSequence(
            $table, array('on' => array('table' => $table, 'field' => $field)), true);

        if (is_a($results, 'PEAR_Error')) {
            $cli->fatal(sprintf(_("Unable to modify the sequence for %s: %s"), $table, $results->getMessage()));
        }
        $cli->message(sprintf(_("Modified sequence for %s"), $table), 'cli.success');
    }
}

$cli->message(_("Done"), 'cli.success');

UPDATE---> Ok this one solved with Pear Driver mysqli install...

[topdog]

Originally Posted by gsp

Got this trying to send to you from Outlook with SMTP authorization:

2008-12-03 16:19:50 no host name found for IP address 192.168.10.199
2008-12-03 16:20:01 1L7sZy-000326-Nm <= "george@marishotels.eu"@mailsrv H=(sync4j) [192.168.10.199] P=esmtpa A=login:george@marishotels.eu S=5549 id=007c01c95551$ad097580$c70aa8c0@maris.local
2008-12-03 16:20:04 1L7sZy-000326-Nm == andrew@topdog.za.net R=dnslookup T=remote_smtp defer (-44): SMTP error from remote mail server after RCPT TO:<andrew@topdog.za.net>: host mail.topdog.za.net [209.20.66.9]: 450 4.1.8 <george@marishotels.eu@mailsrv>: Sender address rejected: Domain not found

Again this stupid login... when authenticates... (thunderbird did the same!!!)... why uses all this for user?... Without authentication works fine now...

Make this change and all will work properly

 accept  authenticated = *
          control       = submission/sender_retain

[gsp]

What this setting will do? I would like to have my users authenticate when trying to send because i am planning to use SMTP and from outside, so i don't want to be a spammer...

Thanks..

P.S. After many hours of trying to update the system, got back to versions of "how to" but unfortunately i miss the sync function with outlook as Funambol plugin don't work with Horde 3.1.x installations...

[topdog]

That will let you do smtp authentication with out the address being modified, ie you will be able to send mail via smtp authentication with the correct address appearing instead of the login@server

[gsp]

OK, i'll try this and let you know.. Now i have my system up&running with 124 mail accounts and seems fine... Now it only needs fine-tunning... For spam, for attachment sizes and syncing with outlook (difficult part, horde needs updating!!)

Thank you

[gsp]

It seems to work. Now only two minor problems remain... SMTP authentication takes sooo long to complete even in the LAN network...

Finally the receiver sees this message in From section:

From: "user@mydomain.com"@mail.mydomain.com on behalf of NAME [user@mydomain.com]<"user@mydomain.com"@mail.mydomain.com>


All this!! Is there any way to get only the real sender to be there? And of course i mean only when using POP3 clients with SMTP authentication..

Cheers

[topdog]

Originally Posted by gsp

It seems to work. Now only two minor problems remain... SMTP authentication takes sooo long to complete even in the LAN network...

Finally the receiver sees this message in From section:

From: "user@mydomain.com"@mail.mydomain.com on behalf of NAME [user@mydomain.com]<"user@mydomain.com"@mail.mydomain.com>


All this!! Is there any way to get only the real sender to be there? And of course i mean only when using POP3 clients with SMTP authentication..

Cheers

I am suspecting that u did the wrong thing, you must have just added that in you are supposed to modify the existing configuration and just add sender_retain

[gsp]

No, in my config exists only this :

accept  authenticated = *
          control       = submission/sender_retain

Not added again, found this section and just added a "/sender_retain" in the end. Isn't this that you mean? Or i should remove the "submission" and leave only "sender_retain"?

[topdog]

Thats correct if you did that then the email will be correct and there should be no slowness at all. Did u restart exim ?