mailzu-users Mailing List for MailZu
Brought to you by:
trilexcom
Menu
▾
▴
mailzu-users — General end-user discussion list
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(28) |
Aug
(41) |
Sep
(57) |
Oct
(30) |
Nov
(52) |
Dec
(24) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
(23) |
Feb
(42) |
Mar
(27) |
Apr
(15) |
May
(5) |
Jun
(23) |
Jul
(39) |
Aug
(9) |
Sep
(10) |
Oct
(9) |
Nov
(21) |
Dec
(24) |
| 2007 |
Jan
(13) |
Feb
(48) |
Mar
(58) |
Apr
(37) |
May
(37) |
Jun
(84) |
Jul
(56) |
Aug
(32) |
Sep
(20) |
Oct
(10) |
Nov
(37) |
Dec
(29) |
| 2008 |
Jan
(60) |
Feb
(34) |
Mar
(10) |
Apr
(27) |
May
(11) |
Jun
(17) |
Jul
(26) |
Aug
(16) |
Sep
(2) |
Oct
(7) |
Nov
(4) |
Dec
(10) |
| 2009 |
Jan
(7) |
Feb
(3) |
Mar
(12) |
Apr
(8) |
May
(8) |
Jun
(25) |
Jul
(15) |
Aug
(2) |
Sep
(1) |
Oct
|
Nov
(16) |
Dec
(7) |
| 2010 |
Jan
(10) |
Feb
(1) |
Mar
(4) |
Apr
(6) |
May
(3) |
Jun
|
Jul
|
Aug
|
Sep
(10) |
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
(3) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Dave D. <da...@ci...> - 2014-05-08 04:35:44
|
Is anyone going to be putting out patches for mailzu to bring it up to date for the new version of amavisd-new ? Is mailzu being maintained at this point ? Will there be a correct, up to date tarball ? -- Dave |
|
From: Gary V <mr8...@gm...> - 2012-03-17 20:05:58
|
> On Sat, Mar 17, 2012 at 8:48 AM, Gary V wrote:
>> On Thu, Mar 1, 2012 at 12:49 AM, Anirudha Patil wrote:
>>>
>>> Hello,
>>>
>>> I'm testing the Mailzu (MailZu v0.8RC3) with amavis-new 2.6.4, but unable to login with Mysql authentication selected.
>>>
>>> Getting the below mentioned error
>>>
>>> There was an error executing your query:
>>> DB Error: syntax error
>>> Back
>>>
>>> I created a new user - mail in the default (mysql) database and granted all privileges to it
>>>
>>> mysql> use mysql;
>>> Reading table information for completion of table and column names
>>> You can turn off this feature to get a quicker startup with -A
>>>
>>> Database changed
>>> mysql> select * from user;
>>>
>>> ....
>>> | localhost | mail | 428567f408994404 | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 |
>>>
>>> I'm able to access the database with sample test php script and gets the message "Connected sucessfully" which mean i'm able to get into mysql from php.
>>>
>>> ==========
>>> <?php
>>> $link = mysql_connect('localhost', 'mail', 'secret');
>>> if (!$link) {
>>> die('Could not connect: ' . mysql_error());
>>> }
>>> echo 'Connected successfully';
>>> mysql_close($link);
>>> ?>
>>> ==========
>>>
>>> Also attached is the config.php file.
>>>
>>>
>>> With Regards
>>> Anirudha Patil
>>> mobile no: 9221306620
>>> email-id: ani...@ho...
>>
>>
>> Try:
>> $conf['auth']['dbHostSpec'] = 'localhost:3306';
>> instead of:
>> $conf['auth']['dbHostSpec'] = 'localhost';
>>
>>
>> You might try something like this example (I have not exactly tested however):
>>
>> CREATE DATABASE mailzu;
>> USE mailzu;
>>
>> CREATE TABLE mailzu_users (
>> User varchar(255) NOT NULL UNIQUE,
>> Password varchar(255) DEFAULT NULL
>> );
>>
>> GRANT SELECT ON mailzu.* TO mailzu@localhost IDENTIFIED BY 'secret';
>>
>> use mailzu;
>> INSERT INTO mailzu_users VALUES ( 'us...@ex...', MD5('Passw0rd') );
>>
>> // Available authentication methods
>> /* Options are:
>> ldap -> Standard LDAP server, e.g. OpenLDAP
>> ad -> MS Active Directory
>> sql -> PHP PEAR compatible database
>> exchange -> MS Exchange 5.5
>> imap -> IMAP protocol
>> */
>> $conf['auth']['serverType'] = 'sql';
>>
>>
>> /*** Database Authentication Settings ***/
>> // Database type to be used by PEAR
>> /* Options are:
>> mysql -> MySQL
>> pgsql -> PostgreSQL
>> ibase -> InterBase
>> msql -> Mini SQL
>> mssql -> Microsoft SQL Server
>> oci8 -> Oracle 7/8/8i
>> odbc -> ODBC (Open Database Connectivity)
>> sybase -> SyBase
>> ifx -> Informix
>> fbsql -> FrontBase
>> */
>> $conf['auth']['dbType'] = 'mysql';
>>
>> // Database host specification (hostname[:port]) [localhost]
>> $conf['auth']['dbHostSpec'] = 'localhost:3306';
>>
>> // Database user who can access the auth database
>> $conf['auth']['dbUser'] = 'mailzu';
>>
>> // Password for above user to auth database
>> $conf['auth']['dbPass'] = 'secret';
>>
>> // Name for auth database
>> $conf['auth']['dbName'] = 'mailzu';
>>
>> // Name for auth table that contains usernames and passwords
>> $conf['auth']['dbTable'] = 'mailzu_users';
>>
>> // Name of the Username field of the SQL table
>> $conf['auth']['dbTableUsername'] = 'User';
>>
>> // Name of the password field of the SQL table
>> $conf['auth']['dbTablePassword'] = 'Password';
>>
>> --
>
> Also see a patch that needs to be applied if you are using the SQL
> schema that amavisd-new 2.7.0 uses:
>
> http://sourceforge.net/tracker/?func=detail&aid=3365667&group_id=137277&atid=738236
>
Actually, I think you need an email address field, so the table
creation might be::
CREATE TABLE mailzu_users (
User varchar(255) NOT NULL UNIQUE,
password varchar(255) DEFAULT NULL,
emailaddress varchar(255) DEFAULT NULL
);
and to add a user:
INSERT INTO mailzu_users VALUES ( 'ga...@ex...',
MD5('Passw0rd'), 'ga...@ex...' );
and in config.php:
// Name of the 'mail address' field of the SQL table
$conf['auth']['dbTableMail'] = 'emailaddress';
--
Gary V
|
|
From: Gary V <mr8...@gm...> - 2012-03-17 14:53:22
|
On Sat, Mar 17, 2012 at 8:48 AM, Gary V wrote:
> On Thu, Mar 1, 2012 at 12:49 AM, Anirudha Patil wrote:
>>
>> Hello,
>>
>> I'm testing the Mailzu (MailZu v0.8RC3) with amavis-new 2.6.4, but unable to login with Mysql authentication selected.
>>
>> Getting the below mentioned error
>>
>> There was an error executing your query:
>> DB Error: syntax error
>> Back
>>
>> I created a new user - mail in the default (mysql) database and granted all privileges to it
>>
>> mysql> use mysql;
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>>
>> Database changed
>> mysql> select * from user;
>>
>> ....
>> | localhost | mail | 428567f408994404 | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 |
>>
>> I'm able to access the database with sample test php script and gets the message "Connected sucessfully" which mean i'm able to get into mysql from php.
>>
>> ==========
>> <?php
>> $link = mysql_connect('localhost', 'mail', 'secret');
>> if (!$link) {
>> die('Could not connect: ' . mysql_error());
>> }
>> echo 'Connected successfully';
>> mysql_close($link);
>> ?>
>> ==========
>>
>> Also attached is the config.php file.
>>
>>
>> With Regards
>> Anirudha Patil
>> mobile no: 9221306620
>> email-id: ani...@ho...
>
>
> Try:
> $conf['auth']['dbHostSpec'] = 'localhost:3306';
> instead of:
> $conf['auth']['dbHostSpec'] = 'localhost';
>
>
> You might try something like this example (I have not exactly tested however):
>
> CREATE DATABASE mailzu;
> USE mailzu;
>
> CREATE TABLE mailzu_users (
> User varchar(255) NOT NULL UNIQUE,
> Password varchar(255) DEFAULT NULL
> );
>
> GRANT SELECT ON mailzu.* TO mailzu@localhost IDENTIFIED BY 'secret';
>
> use mailzu;
> INSERT INTO mailzu_users VALUES ( 'us...@ex...', MD5('Passw0rd') );
>
> // Available authentication methods
> /* Options are:
> ldap -> Standard LDAP server, e.g. OpenLDAP
> ad -> MS Active Directory
> sql -> PHP PEAR compatible database
> exchange -> MS Exchange 5.5
> imap -> IMAP protocol
> */
> $conf['auth']['serverType'] = 'sql';
>
>
> /*** Database Authentication Settings ***/
> // Database type to be used by PEAR
> /* Options are:
> mysql -> MySQL
> pgsql -> PostgreSQL
> ibase -> InterBase
> msql -> Mini SQL
> mssql -> Microsoft SQL Server
> oci8 -> Oracle 7/8/8i
> odbc -> ODBC (Open Database Connectivity)
> sybase -> SyBase
> ifx -> Informix
> fbsql -> FrontBase
> */
> $conf['auth']['dbType'] = 'mysql';
>
> // Database host specification (hostname[:port]) [localhost]
> $conf['auth']['dbHostSpec'] = 'localhost:3306';
>
> // Database user who can access the auth database
> $conf['auth']['dbUser'] = 'mailzu';
>
> // Password for above user to auth database
> $conf['auth']['dbPass'] = 'secret';
>
> // Name for auth database
> $conf['auth']['dbName'] = 'mailzu';
>
> // Name for auth table that contains usernames and passwords
> $conf['auth']['dbTable'] = 'mailzu_users';
>
> // Name of the Username field of the SQL table
> $conf['auth']['dbTableUsername'] = 'User';
>
> // Name of the password field of the SQL table
> $conf['auth']['dbTablePassword'] = 'Password';
>
> --
Also see a patch that needs to be applied if you are using the SQL
schema that amavisd-new 2.7.0 uses:
http://sourceforge.net/tracker/?func=detail&aid=3365667&group_id=137277&atid=738236
--
Gary V
|
|
From: Gary V <mr8...@gm...> - 2012-03-17 14:48:12
|
On Thu, Mar 1, 2012 at 12:49 AM, Anirudha Patil wrote:
>
> Hello,
>
> I'm testing the Mailzu (MailZu v0.8RC3) with amavis-new 2.6.4, but unable to login with Mysql authentication selected.
>
> Getting the below mentioned error
>
> There was an error executing your query:
> DB Error: syntax error
> Back
>
> I created a new user - mail in the default (mysql) database and granted all privileges to it
>
> mysql> use mysql;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql> select * from user;
>
> ....
> | localhost | mail | 428567f408994404 | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 |
>
> I'm able to access the database with sample test php script and gets the message "Connected sucessfully" which mean i'm able to get into mysql from php.
>
> ==========
> <?php
> $link = mysql_connect('localhost', 'mail', 'secret');
> if (!$link) {
> die('Could not connect: ' . mysql_error());
> }
> echo 'Connected successfully';
> mysql_close($link);
> ?>
> ==========
>
> Also attached is the config.php file.
>
>
> With Regards
> Anirudha Patil
> mobile no: 9221306620
> email-id: ani...@ho...
Try:
$conf['auth']['dbHostSpec'] = 'localhost:3306';
instead of:
$conf['auth']['dbHostSpec'] = 'localhost';
You might try something like this example (I have not exactly tested however):
CREATE DATABASE mailzu;
USE mailzu;
CREATE TABLE mailzu_users (
User varchar(255) NOT NULL UNIQUE,
Password varchar(255) DEFAULT NULL
);
GRANT SELECT ON mailzu.* TO mailzu@localhost IDENTIFIED BY 'secret';
use mailzu;
INSERT INTO mailzu_users VALUES ( 'us...@ex...', MD5('Passw0rd') );
// Available authentication methods
/* Options are:
ldap -> Standard LDAP server, e.g. OpenLDAP
ad -> MS Active Directory
sql -> PHP PEAR compatible database
exchange -> MS Exchange 5.5
imap -> IMAP protocol
*/
$conf['auth']['serverType'] = 'sql';
/*** Database Authentication Settings ***/
// Database type to be used by PEAR
/* Options are:
mysql -> MySQL
pgsql -> PostgreSQL
ibase -> InterBase
msql -> Mini SQL
mssql -> Microsoft SQL Server
oci8 -> Oracle 7/8/8i
odbc -> ODBC (Open Database Connectivity)
sybase -> SyBase
ifx -> Informix
fbsql -> FrontBase
*/
$conf['auth']['dbType'] = 'mysql';
// Database host specification (hostname[:port]) [localhost]
$conf['auth']['dbHostSpec'] = 'localhost:3306';
// Database user who can access the auth database
$conf['auth']['dbUser'] = 'mailzu';
// Password for above user to auth database
$conf['auth']['dbPass'] = 'secret';
// Name for auth database
$conf['auth']['dbName'] = 'mailzu';
// Name for auth table that contains usernames and passwords
$conf['auth']['dbTable'] = 'mailzu_users';
// Name of the Username field of the SQL table
$conf['auth']['dbTableUsername'] = 'User';
// Name of the password field of the SQL table
$conf['auth']['dbTablePassword'] = 'Password';
--
Gary V
|
|
From: Brian E. <grk...@sc...> - 2011-01-24 14:44:36
|
On 1/23/2011 9:17 AM, Benny Pedersen wrote: > bug related to <? inline html ?> > > <?php ?> is now required in 5.3 No, you just need "short_open_tag = On" However, this will probably get removed in the next version of PHP. Can someone with commit access change this permanently? All future code should be written as if "short_open_tag = Off" is set. |
|
From: Benny P. <me...@ju...> - 2011-01-23 14:17:47
|
bug related to <? inline html ?> <?php ?> is now required in 5.3 but i dont know enoug to fix it, only report it |
|
From: Benny P. <me...@ju...> - 2011-01-14 16:46:07
|
2 years of developments of mailzu and not a single complain on maillist :) more serious, is anyone running mailzu on php 5.3 ? |
|
From: Matt H. <dom...@sl...> - 2010-09-28 15:22:14
|
On 9/28/2010 10:32 AM, Mark Martinec wrote: > On Monday 27 September 2010 19:51:34 Matt Hayes wrote: >> On 9/27/2010 12:55 PM, Brian Evans wrote: >>> On 9/27/2010 12:40 PM, Matt Hayes wrote: >>>> This is what I get when I run the large query: >>>> >>>> ERROR 1052 (23000): Column 'content' in field list is ambiguous >>> >>> This error is the real problem. >>> >>> The query in question uses the msgs and msgrcpt tables. >>> Only the msgs table should have a content field. > > This is no longer true with amavisd-new-2.7.0 . > >> I reread what you said and started looking at my tables. >> msgs and msgrcpt both had content fields. >> I just went through the queries in the DBEngine queries and set it from >> content to msgs.content and all is well. > > > the 2.7.0-pre* release notes: > > - when using SQL for logging/penpals: two fields need to be added > to the table msgrcpt: msgrcpt.content and msgrcpt.rseqnum. > > Semantics of msgrcpt.content is similar to msgs.content, but reflects > individual recipient's settings (e.g. when a message is both banned and > spam, a recipient with banning tests disabled will see a message as spam, > while other recipient of the same message will consider it banned). > The added field may also simplify queries by third party applications. > > The field msgrcpt.rseqnum uniquely identifies recipients of each message, > typically by assigning them sequential numbers starting with 1. The only > purpose of this field is to make it possible to define a primary key for > the table msgrcpt, which may be needed for some clustering/partitioning > purposes. Amavisd itself does not need a primary key on this table. > > The following SQL directives can be used to add the two new fields: > ALTER TABLE msgrcpt ADD content char(1) DEFAULT ' '; > ALTER TABLE msgrcpt ADD rseqnum integer DEFAULT 0; > > If a primary key on table msgrcpt is needed for some reason, > try something like the following: > *MySQL: > UPDATE msgrcpt SET rseqnum=1+floor(999999999*rand()) WHERE rseqnum=0; > ALTER TABLE msgrcpt ADD PRIMARY KEY (partition_tag,mail_id,rseqnum); > *PostgreSQL: > UPDATE msgrcpt SET rseqnum=1+floor(999999999*random()) WHERE rseqnum=0; > CREATE UNIQUE INDEX msgrcpt_idx_primary > ON msgrcpt (partition_tag,mail_id,rseqnum); > > If keeping a customized copy of %sql_clause in a configuration file, > the entry 'ins_rcp' will need to be adjusted accordingly. > > - SQL fields msgs.content and msgrcpt.content used to encode a content > type CC_SPAMMY as 's', and CC_MTA as 't'. With default case-insensitive > queries on a data type char it was not possible to distinguish > between lowercase 's' (= CC_SPAMMY) and uppercase 'S' (= CC_SPAM), so > the CC_SPAMMY is now encoded as 'Y', and CC_MTA as 'T' (just in case). > Please adjust your management tools if necessary. > > already did all that. It would lead me to believe the queries in SQL for MailZu-ng need to be updated to reflect the changes in amavisd-new 2.7 and greater. all working for now. -Matt |
|
From: Mark M. <Mar...@ij...> - 2010-09-28 14:32:48
|
On Monday 27 September 2010 19:51:34 Matt Hayes wrote:
> On 9/27/2010 12:55 PM, Brian Evans wrote:
> > On 9/27/2010 12:40 PM, Matt Hayes wrote:
> >> This is what I get when I run the large query:
> >>
> >> ERROR 1052 (23000): Column 'content' in field list is ambiguous
> >
> > This error is the real problem.
> >
> > The query in question uses the msgs and msgrcpt tables.
> > Only the msgs table should have a content field.
This is no longer true with amavisd-new-2.7.0 .
> I reread what you said and started looking at my tables.
> msgs and msgrcpt both had content fields.
> I just went through the queries in the DBEngine queries and set it from
> content to msgs.content and all is well.
the 2.7.0-pre* release notes:
- when using SQL for logging/penpals: two fields need to be added
to the table msgrcpt: msgrcpt.content and msgrcpt.rseqnum.
Semantics of msgrcpt.content is similar to msgs.content, but reflects
individual recipient's settings (e.g. when a message is both banned and
spam, a recipient with banning tests disabled will see a message as spam,
while other recipient of the same message will consider it banned).
The added field may also simplify queries by third party applications.
The field msgrcpt.rseqnum uniquely identifies recipients of each message,
typically by assigning them sequential numbers starting with 1. The only
purpose of this field is to make it possible to define a primary key for
the table msgrcpt, which may be needed for some clustering/partitioning
purposes. Amavisd itself does not need a primary key on this table.
The following SQL directives can be used to add the two new fields:
ALTER TABLE msgrcpt ADD content char(1) DEFAULT ' ';
ALTER TABLE msgrcpt ADD rseqnum integer DEFAULT 0;
If a primary key on table msgrcpt is needed for some reason,
try something like the following:
*MySQL:
UPDATE msgrcpt SET rseqnum=1+floor(999999999*rand()) WHERE rseqnum=0;
ALTER TABLE msgrcpt ADD PRIMARY KEY (partition_tag,mail_id,rseqnum);
*PostgreSQL:
UPDATE msgrcpt SET rseqnum=1+floor(999999999*random()) WHERE rseqnum=0;
CREATE UNIQUE INDEX msgrcpt_idx_primary
ON msgrcpt (partition_tag,mail_id,rseqnum);
If keeping a customized copy of %sql_clause in a configuration file,
the entry 'ins_rcp' will need to be adjusted accordingly.
- SQL fields msgs.content and msgrcpt.content used to encode a content
type CC_SPAMMY as 's', and CC_MTA as 't'. With default case-insensitive
queries on a data type char it was not possible to distinguish
between lowercase 's' (= CC_SPAMMY) and uppercase 'S' (= CC_SPAM), so
the CC_SPAMMY is now encoded as 'Y', and CC_MTA as 'T' (just in case).
Please adjust your management tools if necessary.
Mark
|
|
From: Matt H. <dom...@sl...> - 2010-09-27 18:04:54
|
On 9/27/2010 2:02 PM, Benny Pedersen wrote: > On man 27 sep 2010 19:51:34 CEST, Matt Hayes wrote >> I reread what you said and started looking at my tables. >> >> msgs and msgrcpt both had content fields. >> >> I just went through the queries in the DBEngine queries and set it from >> content to msgs.content and all is well. >> >> Thanks for the insight. > > diff -urp mailzu-ng-from-git mailzu-ng-local >mailzu.patch > > send the patch file to http://trac.husku.net/mailzu-ng/wiki > > thanks for starting developments :) > Hehe, wouldn't say I'm quite 'developing' anything. I have found a few other things that needed to be changed to work properly. Some of which is found in the SF.net forums for the project, but had to dig for 'em. -Matt |
|
From: Benny P. <me...@ju...> - 2010-09-27 18:03:04
|
On man 27 sep 2010 19:51:34 CEST, Matt Hayes wrote > I reread what you said and started looking at my tables. > > msgs and msgrcpt both had content fields. > > I just went through the queries in the DBEngine queries and set it from > content to msgs.content and all is well. > > Thanks for the insight. diff -urp mailzu-ng-from-git mailzu-ng-local >mailzu.patch send the patch file to http://trac.husku.net/mailzu-ng/wiki thanks for starting developments :) -- xpoint |
|
From: Matt H. <dom...@sl...> - 2010-09-27 17:57:40
|
On 9/27/2010 12:55 PM, Brian Evans wrote: > On 9/27/2010 12:40 PM, Matt Hayes wrote: >> This is what I get when I run the large query: >> >> ERROR 1052 (23000): Column 'content' in field list is ambiguous >> > > This error is the real problem. > > The query in question uses the msgs and msgrcpt tables. > Only the msgs table should have a content field. > I reread what you said and started looking at my tables. msgs and msgrcpt both had content fields. I just went through the queries in the DBEngine queries and set it from content to msgs.content and all is well. Thanks for the insight. -Matt |
|
From: Matt H. <dom...@sl...> - 2010-09-27 17:13:52
|
Hrm, odd.. tried to replace my crap tables with this code and it errors out.. complaining about some syntax error near the KEY definitions. -Matt On 9/27/2010 12:55 PM, Brian Evans wrote: > On 9/27/2010 12:40 PM, Matt Hayes wrote: >> This is what I get when I run the large query: >> >> ERROR 1052 (23000): Column 'content' in field list is ambiguous >> > > This error is the real problem. > > The query in question uses the msgs and msgrcpt tables. > Only the msgs table should have a content field. > > They should look like this (note, my tables may be optimized more than > yours, aka keys): > > CREATE TABLE `msgrcpt` ( > `mail_id` VARCHAR(12) NOT NULL, > `rid` INT(10) UNSIGNED NOT NULL, > `ds` CHAR(1) NOT NULL, > `rs` CHAR(1) NOT NULL, > `bl` CHAR(1) DEFAULT '', > `wl` CHAR(1) DEFAULT '', > `bspam_level` FLOAT DEFAULT NULL, > `smtp_resp` VARCHAR(255) DEFAULT '', > `partition_tag` INT(11) DEFAULT '0', > KEY `msgrcpt_idx_mail_id` (`mail_id`), > KEY `msgrcpt_idx_rid` (`rid`), > ) > > CREATE TABLE `msgs` ( > `mail_id` VARCHAR(12) NOT NULL, > `secret_id` VARCHAR(12) DEFAULT '', > `am_id` VARCHAR(20) NOT NULL, > `time_num` INT(10) UNSIGNED NOT NULL, > `time_iso` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE > CURRENT_TIMESTAMP, > `sid` INT(10) UNSIGNED NOT NULL, > `policy` VARCHAR(255) DEFAULT '', > `client_addr` VARCHAR(255) DEFAULT '', > `size` INT(10) UNSIGNED NOT NULL, > `content` CHAR(1) DEFAULT NULL, > `quar_type` CHAR(1) DEFAULT NULL, > `quar_loc` VARCHAR(255) DEFAULT '', > `dsn_sent` CHAR(1) DEFAULT NULL, > `spam_level` FLOAT DEFAULT NULL, > `message_id` VARCHAR(255) DEFAULT '', > `from_addr` VARCHAR(255) DEFAULT '', > `subject` VARCHAR(255) DEFAULT '', > `host` VARCHAR(255) NOT NULL, > `partition_tag` INT(11) DEFAULT '0', > PRIMARY KEY (`mail_id`), > KEY `msgs_idx_sid` (`sid`), > KEY `msgs_idx_mess_id` (`message_id`), > KEY `msgs_idx_time_num` (`time_num`), > KEY `msgs_idx_content` (`content`), > ) >> Still looking through this, but any input is appreciated. >> >> -Matt >> >> On 9/27/2010 12:17 PM, Brian Evans wrote: >>> On 9/27/2010 10:07 AM, Matt Hayes wrote: >>>> Getting that unknown error and starting to frustrate me a bit. >>>> >>>> It does this for the Site Qurantine Summary and for the Domain >>>> Quarantine Summary. >>>> >>>> I can't seem to sort out WHERE the actual error is and hoping someone >>>> here has seen it and able to correct it. >>> Can you run the query that you quoted in the mysql command client or gui? >>> >>> You will probably get a better answer. > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Mailzu-users mailing list > Mai...@li... > https://lists.sourceforge.net/lists/listinfo/mailzu-users |
|
From: Brian E. <grk...@sc...> - 2010-09-27 16:55:56
|
On 9/27/2010 12:40 PM, Matt Hayes wrote: > This is what I get when I run the large query: > > ERROR 1052 (23000): Column 'content' in field list is ambiguous > This error is the real problem. The query in question uses the msgs and msgrcpt tables. Only the msgs table should have a content field. They should look like this (note, my tables may be optimized more than yours, aka keys): CREATE TABLE `msgrcpt` ( `mail_id` VARCHAR(12) NOT NULL, `rid` INT(10) UNSIGNED NOT NULL, `ds` CHAR(1) NOT NULL, `rs` CHAR(1) NOT NULL, `bl` CHAR(1) DEFAULT '', `wl` CHAR(1) DEFAULT '', `bspam_level` FLOAT DEFAULT NULL, `smtp_resp` VARCHAR(255) DEFAULT '', `partition_tag` INT(11) DEFAULT '0', KEY `msgrcpt_idx_mail_id` (`mail_id`), KEY `msgrcpt_idx_rid` (`rid`), ) CREATE TABLE `msgs` ( `mail_id` VARCHAR(12) NOT NULL, `secret_id` VARCHAR(12) DEFAULT '', `am_id` VARCHAR(20) NOT NULL, `time_num` INT(10) UNSIGNED NOT NULL, `time_iso` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sid` INT(10) UNSIGNED NOT NULL, `policy` VARCHAR(255) DEFAULT '', `client_addr` VARCHAR(255) DEFAULT '', `size` INT(10) UNSIGNED NOT NULL, `content` CHAR(1) DEFAULT NULL, `quar_type` CHAR(1) DEFAULT NULL, `quar_loc` VARCHAR(255) DEFAULT '', `dsn_sent` CHAR(1) DEFAULT NULL, `spam_level` FLOAT DEFAULT NULL, `message_id` VARCHAR(255) DEFAULT '', `from_addr` VARCHAR(255) DEFAULT '', `subject` VARCHAR(255) DEFAULT '', `host` VARCHAR(255) NOT NULL, `partition_tag` INT(11) DEFAULT '0', PRIMARY KEY (`mail_id`), KEY `msgs_idx_sid` (`sid`), KEY `msgs_idx_mess_id` (`message_id`), KEY `msgs_idx_time_num` (`time_num`), KEY `msgs_idx_content` (`content`), ) > Still looking through this, but any input is appreciated. > > -Matt > > On 9/27/2010 12:17 PM, Brian Evans wrote: >> On 9/27/2010 10:07 AM, Matt Hayes wrote: >>> Getting that unknown error and starting to frustrate me a bit. >>> >>> It does this for the Site Qurantine Summary and for the Domain >>> Quarantine Summary. >>> >>> I can't seem to sort out WHERE the actual error is and hoping someone >>> here has seen it and able to correct it. >> Can you run the query that you quoted in the mysql command client or gui? >> >> You will probably get a better answer. |
|
From: Matt H. <dom...@sl...> - 2010-09-27 16:40:54
|
This is what I get when I run the large query: ERROR 1052 (23000): Column 'content' in field list is ambiguous Still looking through this, but any input is appreciated. -Matt On 9/27/2010 12:17 PM, Brian Evans wrote: > On 9/27/2010 10:07 AM, Matt Hayes wrote: >> Getting that unknown error and starting to frustrate me a bit. >> >> It does this for the Site Qurantine Summary and for the Domain >> Quarantine Summary. >> >> I can't seem to sort out WHERE the actual error is and hoping someone >> here has seen it and able to correct it. > > Can you run the query that you quoted in the mysql command client or gui? > > You will probably get a better answer. > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Mailzu-users mailing list > Mai...@li... > https://lists.sourceforge.net/lists/listinfo/mailzu-users |
|
From: Brian E. <grk...@sc...> - 2010-09-27 16:36:08
|
On 9/27/2010 10:07 AM, Matt Hayes wrote: > Getting that unknown error and starting to frustrate me a bit. > > It does this for the Site Qurantine Summary and for the Domain > Quarantine Summary. > > I can't seem to sort out WHERE the actual error is and hoping someone > here has seen it and able to correct it. Can you run the query that you quoted in the mysql command client or gui? You will probably get a better answer. |
|
From: Matt H. <dom...@sl...> - 2010-09-27 15:47:39
|
Getting that unknown error and starting to frustrate me a bit.
It does this for the Site Qurantine Summary and for the Domain
Quarantine Summary.
I can't seem to sort out WHERE the actual error is and hoping someone
here has seen it and able to correct it.
Here's what I get from the mailzu.log:
[Mon, 27 Sep 2010 13:54:30] 65.124.104.200 matt DB Error:
unknown error
[Mon, 27 Sep 2010 13:54:30] 65.124.104.200 matt There was an
error executing your query SELECT date,
MAX(stattable.spam) AS spam,
MAX(stattable.banned) AS banned,
MAX(stattable.viruses) AS viruses,
MAX(stattable.badheaders) AS badheaders,
MAX(stattable.pending) AS pending
FROM (
SELECT CAST(time_iso AS DATE) AS date,
COUNT(content) AS spam,
0 AS banned,
0 AS viruses,
0 AS badheaders,
0 AS pending
FROM msgs INNER JOIN msgrcpt ON
msgs.mail_id=msgrcpt.mail_id
WHERE content='S' AND NOT
(msgs.quar_type = '')
AND msgrcpt.rs IN ('','v')
GROUP BY CAST(time_iso AS DATE)
UNION
SELECT CAST(time_iso AS DATE) AS date,
0 AS spam,
COUNT(content) AS banned,
0 AS viruses,
0 AS badheaders,
0 AS pending
FROM msgs INNER JOIN msgrcpt ON
msgs.mail_id=msgrcpt.mail_id
WHERE content='B' AND NOT
(msgs.quar_type = '')
AND msgrcpt.rs IN ('','v')
GROUP BY CAST(time_iso AS DATE)
UNION
SELECT CAST(time_iso AS DATE) AS date,
0 AS spam,
0 AS banned,
COUNT(content) AS viruses,
0 AS badheaders,
0 AS pending
FROM msgs INNER JOIN msgrcpt ON
msgs.mail_id=msgrcpt.mail_id
WHERE content='V' AND NOT
(msgs.quar_type = '')
AND msgrcpt.rs IN ('','v')
GROUP BY CAST(time_iso AS DATE)
UNION
SELECT CAST(time_iso AS DATE) AS date,
0 AS spam,
0 AS banned,
0 AS viruses,
COUNT(content) AS badheaders,
0 AS pending
FROM msgs INNER JOIN msgrcpt ON
msgs.mail_id=msgrcpt.mail_id
WHERE content='H' AND NOT
(msgs.quar_type = '')
AND msgrcpt.rs IN ('','v')
GROUP BY CAST(time_iso AS DATE)
UNION
SELECT CAST(time_iso AS DATE) AS date,
0 AS spam,
0 AS banned,
0 AS viruses,
0 AS badheaders,
COUNT(content) AS pending
FROM msgs JOIN msgrcpt ON
msgs.mail_id=msgrcpt.mail_id
WHERE msgrcpt.rs='p' AND NOT
(msgs.quar_type = '')
GROUP BY CAST(time_iso AS DATE)
) AS stattable
GROUP BY date
ORDER BY date
|
|
From: Gary V <mr8...@gm...> - 2010-05-05 01:56:22
|
On 5/4/10, Alrik Bronsema wrote: > Hi, > > I doubt that using a dedicated machine to release the emails to will solve > your problem. Maybe the problem is in the releasing proces. Not delivering > the released email. And that will still take place on the machine that > quarantines the spam/virus email. > > Regards, > Alrik > > > On Tue, May 4, 2010 at 12:44 PM, Alex Forrest <ale...@me...> > wrote: > > > > > > Hello, > > > > I’ve been having some issues with high CPU usage on a few Amavisd-new > servers which as a result has meant that releasing mail from Quarantine is a > little flaky. When CPU usage is low then there’s no issue but when it’s > high then it’s hit and miss whether the mail will be released on any given > attempt. > > > > I’ve upped the timeout window from 5 second to 10 seconds which has help > slightly but not as much as I’d hoped. I was wondering if there is any way > to specify a separate Amavisd-new host to release mail to. > > > > Currently the servers will release mail to the host that originally > received the mail but I would like to build a new host and release mail to > that one as CPU will never be too high but can’t see where I might specify > this in the config files. Is this possible? > > > > Thanks, > > > > Alex I will assume you are using Postfix. If you make $max_servers one more than max proc for the amavis transport in master.cf then there will be an instance of amavisd-new available for use by mailzu. For example: in amavisd-conf: $max_servers = 6; in master.cf: smtp-amavis unix - - n - 5 smtp -- Gary V |
|
From: Alrik B. <al...@gm...> - 2010-05-04 14:19:02
|
Hi, I doubt that using a dedicated machine to release the emails to will solve your problem. Maybe the problem is in the releasing proces. Not delivering the released email. And that will still take place on the machine that quarantines the spam/virus email. Regards, Alrik On Tue, May 4, 2010 at 12:44 PM, Alex Forrest <ale...@me...>wrote: > Hello, > > > > I’ve been having some issues with high CPU usage on a few Amavisd-new > servers which as a result has meant that releasing mail from Quarantine is a > little flaky. When CPU usage is low then there’s no issue but when it’s > high then it’s hit and miss whether the mail will be released on any given > attempt. > > > > I’ve upped the timeout window from 5 second to 10 seconds which has help > slightly but not as much as I’d hoped. I was wondering if there is any way > to specify a separate Amavisd-new host to release mail to. > > > > Currently the servers will release mail to the host that originally > received the mail but I would like to build a new host and release mail to > that one as CPU will never be too high but can’t see where I might specify > this in the config files. Is this possible? > > > > Thanks, > > > > Alex > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Mailzu-users mailing list > Mai...@li... > https://lists.sourceforge.net/lists/listinfo/mailzu-users > > |
|
From: Alex F. <ale...@me...> - 2010-05-04 11:05:05
|
Hello, I've been having some issues with high CPU usage on a few Amavisd-new servers which as a result has meant that releasing mail from Quarantine is a little flaky. When CPU usage is low then there's no issue but when it's high then it's hit and miss whether the mail will be released on any given attempt. I've upped the timeout window from 5 second to 10 seconds which has help slightly but not as much as I'd hoped. I was wondering if there is any way to specify a separate Amavisd-new host to release mail to. Currently the servers will release mail to the host that originally received the mail but I would like to build a new host and release mail to that one as CPU will never be too high but can't see where I might specify this in the config files. Is this possible? Thanks, Alex |
|
From: Allan J. W. <aw...@ya...> - 2010-04-29 05:14:49
|
The 'quarantine' table is full ? What file system are you storing your database files to ? Take a look at http://dev.mysql.com/doc/refman/4.1/en/full-table.html Allan Jul Woer Denmark ----- Original Message ---- From: troxlinux <xse...@gm...> To: mai...@li... Sent: Thu, April 29, 2010 12:36:37 AM Subject: [Mailzu-users] amavis corrupt db with mailzu Hi list, I want to comment something very strange, configure a new server with amavisd-new 2.6.4 and mysql with mailzu, all well for a couple of days, then I see that some messages didn't come out and the server sent error in the chart msg of amavisd-new Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) SEND via SQL (DBI:mysql:database=amavisd_db;host=127.0.0.1;port=3306): <ja...@se...> -> <cg...@mi...>,<sp...@mi...>, mail_id 50035po2-Vo4 Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) _WARN: [32470] Amavis::IO::SQL::close error: Error closing, flush: sql inserting text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 250, <GEN14> line 144717. at (eval 112) line 113, <GEN14> line 144717. at (eval 112) line 88, <GEN14> line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286, <GEN14> line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) mail_via_sql: rollback done Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!!)TROUBLE in check_mail: quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286, <GEN14> line 144717. at (eval 112) line 387, <GEN14> line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!)PRESERVING EVIDENCE in /var/spool/amavis/tmp/amavis-20100428T105045-32470 Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) TIMING [total 347 ms] - SMTP greeting: 1 (0%)0, SMTP LHLO: 0 (0%)0, SMTP pre-MAIL: 0 (0%)1, lookup_sql: 2 (0%)1, lookup_sql: 1 (0%)1, SMTP pre-DATA-flush: 1 (0%)1, SMTP DATA: 86 (25%)26, check_init: 0 (0%)26, digest_hdr: 1 (0%)27, digest_body_dkim: 9 (3%)29, sql-enter: 113 (33%)62, mime_decode: 61 (18%)79, get-file-type3: 10 (3%)82, parts_decode: 0 (0%)82, check_header: 1 (0%)83, AV-scan-1: 9 (3%)85, spam-wb-list: 2 (1%)86, update_cache: 1 (0%)86, decide_mail_destiny: 1 (0%)86, notif-quar: 2 (0%)87, write-header: 2 (1%)88, fwd-sql: 38 (11%)99, SMTP pre-response: 1 (0%)99, SMTP response: 3 (1%)100, rundown: 1 (0%)100 Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A: to=<cg...@mi...>, relay=127.0.0.1[127.0.0.1]:10024, delay=529, delays=529/0.01/0/0.34, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286, <GEN14> line 144717. at (eval 112) line 387, <GEN14> line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> lin 451 4.5.0 e 144717. (in reply to end of DATA command)) Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A: to=<sp...@mi...>, relay=127.0.0.1[127.0.0.1]:10024, delay=529, delays=529/0.01/0/0.48, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286, <GEN14> line 144717. at (eval 112) line 387, <GEN14> line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> lin 451 4.5.0 e 144717. (in reply to end of DATA command)) Apr 28 12:21:53 lentesnic postfix/smtpd[1770]: connect from ppp-203-225.21-151.libero.it[151.21.225.203] I check mysql, postfix, amavisd-new and all these services are running well , somebody in the list that wants to shake hands me with this problem, for my this problem is ignored regardss -- rickygm http://gnuforever.homelinux.com ------------------------------------------------------------------------------ _______________________________________________ Mailzu-users mailing list Mai...@li... https://lists.sourceforge.net/lists/listinfo/mailzu-users |
|
From: troxlinux <xse...@gm...> - 2010-04-28 22:37:04
|
Hi list, I want to comment something very strange, configure a new server with amavisd-new 2.6.4 and mysql with mailzu, all well for a couple of days, then I see that some messages didn't come out and the server sent error in the chart msg of amavisd-new Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) SEND via SQL (DBI:mysql:database=amavisd_db;host=127.0.0.1;port=3306): <ja...@se...> -> <cg...@mi...>,<sp...@mi...>, mail_id 50035po2-Vo4 Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) _WARN: [32470] Amavis::IO::SQL::close error: Error closing, flush: sql inserting text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 250, <GEN14> line 144717. at (eval 112) line 113, <GEN14> line 144717. at (eval 112) line 88, <GEN14> line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286, <GEN14> line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) mail_via_sql: rollback done Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!!)TROUBLE in check_mail: quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286, <GEN14> line 144717. at (eval 112) line 387, <GEN14> line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> line 144717. Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!)PRESERVING EVIDENCE in /var/spool/amavis/tmp/amavis-20100428T105045-32470 Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) TIMING [total 347 ms] - SMTP greeting: 1 (0%)0, SMTP LHLO: 0 (0%)0, SMTP pre-MAIL: 0 (0%)1, lookup_sql: 2 (0%)1, lookup_sql: 1 (0%)1, SMTP pre-DATA-flush: 1 (0%)1, SMTP DATA: 86 (25%)26, check_init: 0 (0%)26, digest_hdr: 1 (0%)27, digest_body_dkim: 9 (3%)29, sql-enter: 113 (33%)62, mime_decode: 61 (18%)79, get-file-type3: 10 (3%)82, parts_decode: 0 (0%)82, check_header: 1 (0%)83, AV-scan-1: 9 (3%)85, spam-wb-list: 2 (1%)86, update_cache: 1 (0%)86, decide_mail_destiny: 1 (0%)86, notif-quar: 2 (0%)87, write-header: 2 (1%)88, fwd-sql: 38 (11%)99, SMTP pre-response: 1 (0%)99, SMTP response: 3 (1%)100, rundown: 1 (0%)100 Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A: to=<cg...@mi...>, relay=127.0.0.1[127.0.0.1]:10024, delay=529, delays=529/0.01/0/0.34, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286, <GEN14> line 144717. at (eval 112) line 387, <GEN14> line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> lin 451 4.5.0 e 144717. (in reply to end of DATA command)) Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A: to=<sp...@mi...>, relay=127.0.0.1[127.0.0.1]:10024, delay=529, delays=529/0.01/0/0.48, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL failed: print: sql inserting mail text failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine' is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286, <GEN14> line 144717. at (eval 112) line 387, <GEN14> line 144717., id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> lin 451 4.5.0 e 144717. (in reply to end of DATA command)) Apr 28 12:21:53 lentesnic postfix/smtpd[1770]: connect from ppp-203-225.21-151.libero.it[151.21.225.203] I check mysql, postfix, amavisd-new and all these services are running well , somebody in the list that wants to shake hands me with this problem, for my this problem is ignored regardss -- rickygm http://gnuforever.homelinux.com |
|
From: Benny P. <me...@ju...> - 2010-04-02 17:17:24
|
On fre 02 apr 2010 03:59:36 CEST, Kerem ERSOY wrote > Thank you for your e-mail. But I don't think it will solve my > problem. Because I need to keep the original recipient. In fact I > was expecting a quick hack in the code rather than this kind of > solution. so make each recipient a mailbox ?, same problem comes when there is forward to non local mailbox then mailzu cant auth either, hack could be that imap auth being extended to more then one imap server, or one could install mailzu on diff weburls one pr imap server, and then have nearly equal config for them with the only diff another imap server again alias have no auth -- xpoint |
|
From: Kerem E. <ke...@si...> - 2010-04-02 01:59:47
|
Hi, Thank you for your e-mail. But I don't think it will solve my problem. Because I need to keep the original recipient. In fact I was expecting a quick hack in the code rather than this kind of solution. Cheers, Kerem ERSOY -----Original Message----- > From: Benny Pedersen [mailto:me...@ju...] > Sent: 01 Nisan 2010 Perşembe 22:37 > To: mai...@li... > Subject: Re: [Mailzu-users] IMAP Multiple Domain Problem > > On tor 01 apr 2010 12:09:07 CEST, Kerem ERSOY wrote > >> Hi, >> >> We are using MailZu for some time. The problem is that we are using >> IMAP authentication and we have several domains. So the users have >> only a single mailbox such as "user" but we accept for several >> domains such as "mydomain.com", "anotherdomain.com". So both: >> us...@my... and us...@an... are valid addresses. >> We're logging on to domain using IMAP authentication. But IMAP >> supports only the us...@my... addresses so that the user >> cannot see the mails arrived for us...@an.... How can I >> modify the code so that the algorithm will match only the username >> part "user" only but not whole domain "us...@my..."? > > do alias rewrite before calling amavisd, this solves it atleast for > me, and there is no auth on alias anyway > > this should be a faq > > http://www.google.dk/search?q=amavisd-new+alias+rewrite+postfix&ie=utf-8&oe=utf-8&aq=t&rls=com.ubuntu:da-DK:unofficial&client=firefox-a > > > -- > xpoint > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Mailzu-users mailing list > Mai...@li... > https://lists.sourceforge.net/lists/listinfo/mailzu-users __________ Information from ESET Smart Security, version of virus signature database 4969 (20100323) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4969 (20100323) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4969 (20100323) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
From: Benny P. <me...@ju...> - 2010-04-01 19:37:26
|
On tor 01 apr 2010 12:09:07 CEST, Kerem ERSOY wrote > Hi, > > We are using MailZu for some time. The problem is that we are using > IMAP authentication and we have several domains. So the users have > only a single mailbox such as "user" but we accept for several > domains such as "mydomain.com", "anotherdomain.com". So both: > us...@my... and us...@an... are valid addresses. > We're logging on to domain using IMAP authentication. But IMAP > supports only the us...@my... addresses so that the user > cannot see the mails arrived for us...@an.... How can I > modify the code so that the algorithm will match only the username > part "user" only but not whole domain "us...@my..."? do alias rewrite before calling amavisd, this solves it atleast for me, and there is no auth on alias anyway this should be a faq http://www.google.dk/search?q=amavisd-new+alias+rewrite+postfix&ie=utf-8&oe=utf-8&aq=t&rls=com.ubuntu:da-DK:unofficial&client=firefox-a -- xpoint |
3 messages has been excluded from this view by a project administrator.
