[Dbmail] Database + Webmail

Hi I'm considering installing DBmail, because I really like the idea about using a database instead of flat files. In this way you have the possibility to use the same data for several applications. First I would like to know what database you think is the best? I read that Mysql is the fastest o

[Dbmail] auth login problem

Hello all I have problem with auth login. In telnet session i see: ehlo localhost 250-mydomain.ru Hello localhost.ru [127.0.0.1] 250-SIZE 5242880 250-PIPELINING 250-AUTH PLAIN LOGIN CRAM-MD5 250 HELP auth login 334 VXNlcm5hbWU6 YWRtaW4AemVsZ18yLnJ1 334 UGFzc3dvcmQ6 MzIyOTZEZ345ubnk= 435 Unabl

[Dbmail] exim+dbmail

Hello!!! I use exim and MySQL. If need, i send my exim.conf file! Senks! Dgonny > On Mon, Oct 13, 2003 at 08:01:02PM +0400, [EMAIL PROTECTED] wrote: > > I have problem with auth login. > > In telnet session i see: > > > > ehlo localhost > > 250-mydomain

Re: [Dbmail] exim+dbmail

auth login!! after change in maillog file i see: Oct 14 10:30:13 mydomain exim[39465]: 2003-10-14 10:30:13 SMTP protocol error in "auth login" H=localhost.ru (localhost) [127.0.0.1] login authentication mechanism not supported question: how you create dbmail base??? Senks! Dgonny.

[Dbmail] auth_login problem!

Hello all! I use Exim 4.24+Dbmail1.1+Mysql+Drweb! If my client use auth_plain - system work properly (all ok!) But if use auth_login - in maillog file i see: Oct 15 18:13:43 myserver exim[46663]: [1\2] 2003-10-15 18:13:43 auth_login authenticator failed for (programmer) [212.5.102.96]: 435 Unable

[Dbmail] migration from qmail+vpopmail to exim+dbmail

Hello! I plan to migration from qmail+vpopmail to exim+mysql+drweb. All my user accaunts is stored in vpasswd file. How copy my vpopmail accaunts to dbmail if it possible. best regards Dgonny

[Dbmail] messageblks trable

Hello all! I use exim+dbmail+mysql. All messages recive and send properly.It's ok! BUT! in table messages and messageblks i see all messages wich i send and recive.it's ok or not? and how automaticli delete message from tables? P.s. sorry for my english!I'm like a dog :) Dgonny

[Dbmail] DBMA V2.0 Administration GUI FOR DbMail v2.0CVS & Backward Compat

*DBMA V2.0 Administration GUI FOR DbMail v2.0CVS & Backward Compat* DBMA V2.0 (DbMailAdministrator GUI) is now consistant with pre-2.0/RC8 CVS and backward compatable with dbmail V1.2.8/9 and 2.0RC9 using SQL only. We are getting good use out of it and hope others will as well. DBMA configura

[Dbmail] DbMail Administrator (DBMA V2.0.2) is RC8 Compatible -- need steer on PSQL Encrypt

Hello to All: Congratulations to the dev group on the release of 20RC8. Nice job and many thanks for all your hard work! It is certainly a fine release candidate. Happy bug hunting. I have been running it (from CVS) on both PostgreSQL and MySQL for about two weeks plus with the pre-rollback m

[Dbmail] DbMail Administrator (DBMA V2.0.2) is RC8 Compatible -- need steer on PSQL Encrypt

Thank you all, for your views and advice. As Mathew points out, PostgreSQL encryption features on a par with MySQL 4 don't occur until version PgSQL 7.4. Although PostgreSQL is now at version 7.4.5 and the new product is rich in features, research suggests that PgSQL users in large scale are c

[Dbmail] New user, questions, scalability, etc.

I have been working on a little PERL project that takes from a list of 550,000 email addresses and generates an SQL statement foreach to create an entry into a DbMail MySQL database. This will be my new test database. Too bad numerous things arose in August and I have had to put dev resources

[Dbmail] DBMA v2.0.5 Will now also access all mail in the database.

Hello All. It might help testers to know that DBMA (DbMail Administrator) V2.0.5 will access all mail in the database from the user account window. Typing the user_idnr, name or email address in the main menu's search box brings up the user account in which, among other things, is displayed a

[Dbmail] Re: [Dbmail-dev] current cvs head doesn't compiles under freebsd 5.2.1 - FreeBSD users Note that issue is FIXED

>Does someone have a FreeBSD machine that they can provide accounts on? >I could set one up at home, but it would be on a DSL line with a slow >uplink rate. >Aaron >-- > M. J. [Mike] O'Brien <[EMAIL PROTECTED]> said: > what do you need? > It sounds like Ilj

[Dbmail] DBMA (DbMail Administrator) V2.1 Adds RESTRICTGroupID-Mode For End-To-End Secure External Client Access

Hello All: DBMA Version 2.1.0 (09-26-04) enables an Administrator to 'hard-code' DBMA to restrict administrative access to a single DbMail "Group" (client_idnr). Why? This is ideal for Help Desk or Level One Support situations where you want personnel to perform mail-user management on a sp

[Dbmail] Anyone interested in SPF for their Postfix/DbMail Setup?

FYI: Anyone interested in enabling SPF (plus MS CALLER-ID if desired) for their Postfix MTA / DbMail system? This is not intended as a recommendation but if you have considered implementing the new SPF I have been running the Postfix SMTP policy daemon with Postfix/DbMail with good result. S

Re: [Dbmail] Anyone interested in SPF for their Postfix/DbMail Setup?

Hi Doug: If you visit http://spf.pobox.com/wizard.html you will be able to test your DNS SPF records, if that is what you seek. There is no co-relationship between Spamassassin and an SPF daemon that I know about. SPF is a sender policy framework wherein mail claiming to originate from a server

Re: [Dbmail] DBMail 2.0 final

ages); Replace select with delete to actually delete the stragglers. This is only for postgres (no idea if mysql supports this). Weren't there going to be a cleanup tool to get rid of old messages no longer linked from any mailbox? I did some housekeeping, and still have 300.000+ mess

[Dbmail] DbMailAdministrator (DBMA V2.1.2) Rats out Rogues

Hello List: If you have (rogue) orphaned messages DBMA will 'rat them out' and serve them up to the next crontab 'dbmail-util -d' firing squad. DBMA finds and marks orphaned messages for deletion. Get DbMail Administratior - DBMA V2.1.2 at http://library.mobrien.com/dbmailadministrator/ untar

Re: [Dbmail] DBMA shows duplicate forwards

Nate Zabaldo wrote: When I set up a forward via DBMA and then click "List All Forwards" it shows duplicate entries. Has anyone seen this before? E.g.: Forwards in alpha sort Forwarded to [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL

Re: [Dbmail] dbmail administrator strange user password encryption type

April Lorenzen wrote: When I create a new user in the dbmail administrator with password type "plain", the password type in the database table comes out as "on" (no quotes). ? I have been manually fixing it in the table, or just using dbmail-users to create users. But now I have custome

Re: [Dbmail] dbMail with MySQL Replication...

Angus On Wed, 19 Jan 2005 07:40:06 -0800, Steven Lynn <[EMAIL PROTECTED]> wrote: I have actually been using this for some time now. I used it, originally, on two routers and point all of my Windows boxes at the shared ip. That way I could mess with one, if it failed, the second box would

Re: [Dbmail] Upgrading DBMAIL from 1.2.8 to 2.0.3 - questions

use procmail to deliver to the Mailboxes and i use virtual tables with postfix configuration at the moment /etc/postfic/virtual #DOMAIN.DE domain.de VIRTUAL [EMAIL PROTECTED] user1 @domain.de user1,user2 /etc/postfix/main.cf mailbox_transport = procmail mailbox_command = /usr/bin/procmail

[Dbmail] DbmailAdministrator (DBMA) Rel V. 2.1.6

Hello List: Just a quick note to say hello and note that that DbmailAdministrator (DBMA) V. 2.1.6 ** is available for download with the following upgrades/changes. This is a fairly significant new release responding to some feature requests and DbMail developments: - SR. Admin can delete ent

Re: [Dbmail] FBSD getopt issue

Hi Paul: Thanks for your response. I have shown the offending lines in unistd.h of two versions of FBSD. FBSD 5.3 Line 374-376 re:getopt Offending line is 376 374 | #ifndef _GETOPT_DECLARED 375 | #define _GETOPT_DECLARED 376 | int getopt(

Re: [Dbmail] OT: Automatic removal of email from trash folder.

That's a very conscientious thread, folks. Pertaining to Canada these are snippets of policy directives I work under... .../ Deleting mail from a trash bin on a periodic basis is good practice if that is what the Mail Address Owners in your group know will happen to mail stored in 'trash folder

[Dbmail] quotum would exceed

After checking RFC 2087 - IMAP4 QUOTA extension and RFC-3502 - IMAP4, it would seem you are witnessing the correct response from dbmail. The over-quota condition needs to be addressed by either increasing the quota or deleting some mail. The amount of mail transferred into another folder wil

[Dbmail] newbie question

That's a pretty good setup for dbmail. If you don't need IMAP, you wouldn't need to run the IMAP daemon. But the dbmail IMAP is extremely good so you might like to have it for yourself / admin. :o) *Use postfix for the MTA. http://www.postfix.org/download.html (Post fix has some great configs

[Dbmail] DbMail Administrator (DBMA) V2.2 has ACL Management

New Release Hello All: As well as a thorough upgrade of all feature sets, DBMA V2.2 integrates Access Control List and Shared folder Management enabling for Administrators and mail users the full advantage of DbMail's excellent implementation of the IMAP4 ACL extension. DBMA will teach you abo

Re: [Dbmail] Where is the docs?

The wiki on dbmail.org should help a bit including setup procedures to some popular MTAs. http://www.dbmail.org/ If this is for a production system, ignore 2.1 for now as it's the development/prview branch. Stick with 2.0.4. The entity relationship diagram in the wiki is probably the best vi

Re: [Dbmail] Database connection log flooding

set loglevel to 5 in /etc/dbmail.conf under imapd section and see what is triggering it.. perhaps you have a bot trying to test some random password/user combo every second or so...if no one is connecting and dbmail is still triggering the db connects, get detailed logs and submit a bug report

[Dbmail] Auth from a radius database

First off I'd like to say, from just looking at dbmail I'm very excited. I haven't ever seen a solution to store mail in a database...the possibilities are limitless... I'm part of an isp that is currently trying to decide on a new mail system. Someone in the ISP recommended DBmail upon review I fo

Re: [Dbmail] DBMail and Postfix : Recipient FAIL (in reply to RCPT TO command))

/dbmail-users -l Opening connection to database... Opening connection to authentication... Ok. Connected Existing users: [anyone] [john] [test] [EMAIL PROTECTED]@__] $ echo hello | mail -s Hello [EMAIL PROTECTED] # tail -f /var/log/mail/all Aug 10 09:44:46 ebr-app postfix/pickup[27857]: 100EA3C6E

Re: [Dbmail] imapsync - maybe dbmail that curses the errors

# imapsync --debug --host1 dom1.dk --user1 [EMAIL PROTECTED] --password1 pass --host2 127.0.0.1 --user2 [EMAIL PROTECTED] --password2 pass get options: [1] $RCSfile: imapsync,v $ $Revision: 1.121 $ $Date: 2005/02/01 04:03:30 $ Mail::IMAPClient version used here is 2.2.9 auth md5 : 1 From imap server

[Dbmail] Aliases not working 2.1.2

I just installed dbmail2-mysql from the web site and I cannot get aliases to work. 2005-08-23 01:54:15 H=(p02m141.mxlogic.net) [66.179.26.141] F=<[EMAIL PROTECTED]> rejected RCPT <[EMAIL PROTECTED]>: Unrouteable address I'm using exim4 and here's my call to dbmail-

Re: [Dbmail] Aliases not working 2.1.2

E \ alias='${quote_mysql:[EMAIL PROTECTED]' OR \ alias='${quote_mysql:@$domain}'}{yes}{no}} Again, in my setup all users have an alias which points to their box... each user uses his or her email address to log in as the username. Example: Userid: [

Re: [Dbmail] IDN support?

I do not believe the current dbmail db scheme fully supports UTF-8 natively which is what is needed for IDN. For mysql, upon connection, you must set the character set/name to UTF-8. Otherwise, sending in the [EMAIL PROTECTED] login for verification is comparing to non-utf-8 charset. The

[Dbmail] update wiki for full postfix 2.2 + dbmail integration

For those looking for detailed and complete install instruction of Postfix 2.2 + dbmail + mysql + sasl2 (smtp authentcation), I have rewritten the previous wiki article with full doc on the integration procedure. Major changes to article: 1) SASL2 how to: Cyrus SASL2 mysql compile is a pain i

Re: [Dbmail] mysql_real_query failed: Can't open file: 'dbmail_messageblks.MYI' (errno: 144)

2 mx1 dbmail/smtp[2721]: main(): exit code is [75]. Nov 10 16:55:52 mx1 dbmail/smtp[2722]: dbmysql.c,db_query: mysql_real_query failed: Can't open file: 'dbmail_messageblks.MYI' (errno: 144) Nov 10 16:55:52 mx1 postfix/pipe[2719]: A91C82620177: to=<[EMAIL PROTECTED] <mailto:[EM

[Dbmail] SMTP Service

I've had dbmail installed and running great since 1.2.x. I'm now using 2.0.7on Debian Sarge with exim4 as the MTA. My question is simple. DBmail's install for pop3 and imap are so easy and the configuration to make local domains + mailboxes all virtual (mysql driven) is so complicated are there pl

Re: [Dbmail] SMTP Service

e main things I find difficult to set up are the SMTP Authentication and mailbox forwarding functions with SMTP Authentication being the most difficult. On 11/11/05, Paul J Stevens <[EMAIL PROTECTED]> wrote: > > > > [EMAIL PROTECTED] wrote: > > I've had dbmail insta

Re: [Dbmail] Max_data_length for dbmail_messageblks reached

Importing that much data is slow. Just copy the files for backup then alter. Check to see if the number of rows match. Simon wrote: Hi... On 11/15/05, Dominic Amann <[EMAIL PROTECTED]> wrote: ALTER TABLE tbl_name MAX_ROWS=10 AVG_ROW_LENGTH=nnn; But before i do this, i

Re: [Dbmail] Max_data_length for dbmail_messageblks reached (Solved)

You have fixed a short term problem but forgot about long term consequences. Email system is a delete/insert/update/select heavy system, if you have lots of users. Going with innodb you get concurrent reads + writes. I can do most of the dbmail-util cleanup functions without having to lock ta

Re: [Dbmail] Mysql and the dbmail 2.x

Highly recommend upgrading mysql as well. There have been literally gazillion bug fixes since the 4.1 alpha version. Butch Evans wrote: Current configuration: dbmail 1.2.x (I think 1.2.9) mysql 4.1.0-alpha Postfix MTA Running MyISAM tables currently. The users table has several custom column

[Dbmail] Character set problem

Hello! I have a little problem with character set. I compiled and installed mysql-server-4.1.18 from ports on freeBSD 6.0 with default character set cp1251. Then I compiled and installed dbmail-2.0.7. (also from ports). Thurther configuration process was done with the docs (database created wit

[Dbmail] sendmail mysql store + relay

I'm trying to store mail alerts from a monoitoring system and then send the recieved messages on to the mail server that will send the mail out the the internet. Here are my issues: 1) I want to store all mail, regardless of To address or From address, in the database. 2) I want all mes

[Dbmail] Removing old spam messages (with SQL?)

Hi everybody, I've set up the dbmail system and it really works great but I still got a question. Currently I have postfix/amavisd/spam-assassin etc running and all parts do their job. Spam e-mails are marked with the subject "***SPAM*** xyz" and automatically sorted into a folder "Inbox.SPA

[Dbmail] Script to fix the relational integrity - MySQL.

Ok, it took a while, but I finally came up with this MySQL script to fix the IR of the whole database. It's running now, and hopefully it should fix my problems. I'm posting it here so that if anybody else need it.. Obviously I make no guarantees of any kind. ALTER TABLE dbmail_mailboxes DROP

[Dbmail] I got it

I got it. It's a mysql bug (at least so it seems to me): changing the COLLATION of a table with foreign keys looses the ON UPDATE and ON DELETE. I'm fixing my database now, I'll make a couple more investigation later and report it to mysql ab. This is also what broke the database in the first

[Dbmail] The whole thing crashed down [Was: Errors]

I'm still Andrea Brancatelli from another address as the whole dbmail crashed right now. Now I am in troubles. After trying to fix up something yesterday the whole message base started to dismant so today i decided to rename the dbmail database to something else, and to recreate it new. After

Re: [Dbmail] Really offtopic question :P

Jorge Bastos wrote: Guys, don't kill me, but if want to only do it after answer me :P Beside MSOutlook, does anyone know another email client with MAPI support? Jorge ___ DBm

[Dbmail] Manual

Hi Folks, Does it exist any Manual for DBMAIL ? Add Users, delete Useres, change password etc. thx <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] send your message Marko Djordjevic Head of Vision & Solutions Liechtensteinstr. 32-43 A-1090 Wien Mobile: +43/6991/262

[Dbmail] Adduser

; [EMAIL PROTECTED] Action: failed Status: 4.0.0 Diagnostic-Code: X-Postfix; temporary failure I am a complete newbie to this system I hope someone can help me. thx <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] send your message Marko Djordjevic Head of Vision &

[Dbmail] Austria/Vienna

Hi, Is on this list someone from Austria/Vienna who can provide me with a payed hands-on training ? cheers <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] send your message Marko Djordjevic Head of Vision & Solutions Liechtensteinstr. 32-43 A-1090 Wien Mobile: +43/69