Re: [Dbmail] Mailing list

atack wrote: Is it possible to create mailinglists with postfix mysql dbmail ? Sort of... Or aliases that forward to external email addresses ? It is. Check the dbmail-adduser manpage and look at the x and f options. This does work kind of, but dbmail-adduser is a rather simplistic interf

Re: [Dbmail] Debian packages?

I'm working on them. I'm not quite there yet. I'm building debs for woody/stable and sid/unstable for mysql and pgsql, based on cvs with added patches from the list, i.e. fixed autoconf support, autocreate mailbox support, and the mb2db tool. I'm no official debian maintainer yet, though. Tim

Re: [Dbmail] Debian packages?

ebian package, so please be gentle. I've made a first stab at debconf. Database connections parameters are now managed through debconf. Feedback and encouragement most welcome. enjoy. Paul J Stevens wrote: I'm working on them. I'm not quite there yet. I'm building d

Re: [Dbmail] Debian packages?

because the default dbmail.conf sez: NCHILDREN=50 Can you confirm it works when you tune that one down. Worked for me. btw, I've only tested the pgsql build so far - -ben "Unix is user friendly, Its just picky about its friends." On Wed, 22 Jan 2003, Paul J Stevens wrote:

Re: [Dbmail] Debian packages?

Ben Kochie wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ok.. works fine now.. too many children. I'll have to look at mysql's config to see where it limits server connections. maybe i need more fd's A couple more things that you might want to change: dbmail-imapd/pop3d/smtp should p

Re: [Dbmail] Is there any way to hide the password?

Ben Kochie wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 the dbmail.conf does not have to be world readable.. it needs to be user and/or group readable by the dbmail daemon If however you want to grant lusers access to dbmail-smtp via procmail you would have to run dbmail-smtp suid dbm

[Dbmail] debian packages status update

Hi all, Debian packages for dbmail are ready for consumption. I've done a cleanup of the archive because I made a mistake in the version numbering in the early woody packages. You might have to remove and re-install to make sure you get the latest debs if you've installed a woody version befor

Re: [Dbmail] Need help in using dbmail-smtp

Robert Tom Jr. wrote: I am a newbie using dbmail. I am using qmail with dbmail. I got qmail working and I installed dbmail by following the instructions on the dbmail install file. I tried using dbmail-smtp -d [EMAIL PROTECTED] to see if the message would be stored in the mysql dbmail database

Re: [Dbmail] [Fwd: DBMAIL: delivery failure]

Shon, Is there an alias for the mentioned address in the aliases table ? Or a catch-all alias for @netel.bg shon wrote: i keep getting lots of the message below...however, my posts are getting through. thanks, shon Original Message Subject: DBMAIL: delivery failure From

Re: [Dbmail] starting dbmail-imapd and dbmail-popd?

[EMAIL PROTECTED] wrote: thanx for you great answers, ill give that a try. im not using the debian package because is was not in debian when i installed it.. and i dont know how to install it with your package.. :( (i'm still a newbie ) i downloaded it, but saw the same faults in the install

Re: [Dbmail] dbmail 1.1 - autoconf issues

Ryan Butler wrote: Here is another patch so that autoconf finds postgresql headers on debian machines. Shouldn't files like Makefile.in and configure and all the other files that are generated by automake and autoconf be removed from cvs? Just an idea, since I know this is common practice in

Re: [Dbmail] Compile OK but not working

Nataniel Klug wrote: I can't use imap becouse my webmail is all for POP3 (and it is already translated by me to Portuguese). dbmail supports pop3 just fine. : I recall reading about some bugs in dbmail-pop3d on the list, but I don't : use it myself so I can't say what. Try dbmail-imapd, yo

Re: [Dbmail] Virus Scanning Emails?

Tim Uckun wrote: At 05:26 PM 2/15/2003 +1000, you wrote: Hi I have looked through the archives of this mailling list and searched the net for virus scanners that work with dbmail/postfix. I have found several that claim to work with postfix but reading the INSTALL or README files has always l

Re: [Dbmail] avoiding spam-mail with dbmail

Kuschel Sebastian wrote: Hi everybody, I did install dbmail currently, and it works fine, but how can I prevent my server from being used as a spam-mail source (the server is in a public server-farm). Furthermore I cannot limit the acceptable IP-range, 'cos users from around the world have t

Re: AW: [Dbmail] avoiding spam-mail with dbmail

Kuschel Sebastian wrote: Thanks for your advices. But how can I set up the application, so that it's using your mentioned pop-before-smtp and sasl. Is there any specific adjustment I've to set? (or dbmail related documentation, where I can dig into the problems) I'm planning to use dbmail 1.0

Re: [Dbmail] Problem with dbmail-adduser

Nico De Beer wrote: Hi can I get dbmail-adduser to work It keeps saying it can't connect to the dbase but the user i set in the config file is god in the mysqlserver yuk :-) i can add the thing manualy but would want to write some advanced scripts for this and using dbmail would be nice p

Re: [Dbmail] dbmail setup

You might add deb http://debian.nfgd.net/debian/ woody/ to your sources.list and install dbmail-mysql. You'll find a late cvs pre 1.1 version there for now. 1.1 will follow rsn. But then, why are you installing mysql-max instead of simply doing apt-get install mysql-server ? Markus Welsch wr

Re: [Dbmail] pop before smtp ; postfix and mysql => problem

Can you also connect to the mysql server using the explicit -h localhost switch. Without it you might by connecting over a tcp socket in stead of a unix socket, like postfix is trying to do. So: mysql -h localhost -u postfix -p'pass123' dbmail should emulate a postfix connection. Also check /etc

Re: [Dbmail] Upgrading from RC3 to 1.1

I've been preparing an mysql upgrade batch to upgrade a client from i think rc2 or rc3. I'm not sure. The source on the system is cvs and was last updated december (rc4), but the active build dates to jan 21 2002 and I haven't been around here that long. The basic principle applies of course, an

Re: [Dbmail] dbmail-pop performance with attachments ; hardware suggestions required

All dbmail debian packages at debian.nfgd.net are 1.1 The only difference from stock 1.1. is the auto_create_mailbox patch that circulated on the list awhile back, and a different path to dbmail.conf to conform to debian standards (/etc/dbmail/dbmail.conf) The auto_create_mailbox could probably

Re: [Dbmail] Maximun size of a DB

debians mysql-server package does come with innodb enabled. You just have to edit /etc/mysql/my.cnf to activate it. Jeff Brenton wrote: NK> Can you tell me how I install or even just verify if InnoDB is NK> instaled in my machine? Where can I found documentation and some NK> other information a

Re: [Dbmail] dbmail-pop performance with attachments ; hardware suggestions required

Eelco van Beek - IC&S wrote: ok. When are debian packages added to the main distribution? Unless I find a debian maintainer willing be my mentor or sponsor this package it'll be awhile yet. -- Paul Stevens

Re: [Dbmail] Procmail

Matthew, Though I use postfix instead of sm, I run a similar setup as yours. Yes, you can tell dbmail-smtp to deliver messages to a specific folder. The -m switch does the trick. A typical dynamic procmail filter for mailinglists would be: :0 * ^List-Id: \/.* { LISTNAME=`echo $MATCH|sed 's/<

[Dbmail] dbmailctl: another console tool.

ger [EMAIL PROTECTED] The Netherlandshttp://www.nfg.nl #!/bin/sh # dbmailctl # # Simple dialog based wrapper for the dbmail-adduser usermanagement # utility for dbmail (www.dbmail.org) # # Licence: GPL (www.gnu.org) # Author: Paul J Stevens <[EMAIL PROTECTED]

Re: [Dbmail] Problem? Large message forwarded to multiple recipient

This is not a dbmail issue perse. You're simple getting what you're asking for :-) i.e. trouble. First off, I'm assuming your spamc version supports the -s switch, and is therefore defaulting to maxsize 256k, so messages larger than that are not evaluated for spam probability. Next I would ad

Re: [Dbmail] Problem? Large message forwarded to multiple recipient

This is not a dbmail issue perse. You're simple getting what you're asking for :-) i.e. trouble. First off, I'm assuming your spamc version supports the -s switch, and is therefore defaulting to maxsize 256k, so messages larger than that are not evaluated for spam probability. Next I would ad

Re: [Dbmail] autoconf update [PATCH]

Blake wrote: I'm going to try something, and please don't everyone hate me for suggesting it. I'm thinking about using dbmail without the messageblk table, and storing the messages in files on the file system. It seems like a good idea to me, please tell me why it is a bad idea. Your idea is

Re: [Dbmail] Sendmail, procmail, dbmail (default RedHat 7.2 setup)

Hi Scott, I'm stuck with a couple of SM installations as well :-( I haven't done dbmail/sendmail and hope never to do so, but I do have a pretty good idea of how to go about it. You have basically two main routes for messages to take into dbmail: - mailertable-based, and procmail. Since the

Re: [Dbmail] Memory Leak in dbmail-imapd?

Has any progress been made re this issue. I'm seeing significant leaks in pop3d as well running from stock 1.1. After less than a day on a server serving < 10 clients: PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 9129 dbmail 9 0 39964 39M 792 S 0.0 7.7

Re: [Dbmail] postfix+dbmail+spamassassin+antivirus

Joby Walker wrote: Yes I am using amavisd-new with SpamAssassin, Razor, and OpenAntivirus's Scannerdaemon. Isn't the scannerdaemon project dead and burried ? Their site shows a latest signature update october 2002. just curious. http://www.ijs.si/software/amavisd/ jbw lou wrote: H

Re: [Dbmail] LDAP

Aaron, Do those pathes still apply to cvs-current ? I'll make a stab at integrating those patches into the debian packages I maintain if they do, releasing dbmail-ldap as a separate package. I for myself could definitely do with ldap authentication. It's a key part of why I'm not rolling out

Re: [Dbmail] dbmail debian apt-get update does not end.

Hi there, There appears to be some weirdness in how start-stop-daemon works i'm not quite grokking yet. [EMAIL PROTECTED] wrote: Hi, No hurry, but just to know, after a apt-get update , apt-get install dbmail dbmail-mysql the dbmail server does nog end its starting proces. after a CRT

Re: [Dbmail] need help with dbmail error

Running mysql with isam or myisam tables ? Your mysql tables are corrupted. Read the man page for (my)isamchk and fix your tables. Kenneth Oncinian wrote: Hi, dbmail is working fine for months, suddenly this error occured after a reboot of the box.

[Dbmail] HOWTO: vacation autoreplies with dbmail

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, Just presenting a brief writeup of my morning exercise with dbmail: How to provide functionality such as offered by the famous 'vacation' program when using dbmail. When you use dbmail as your default destination for a domain it is quite

Re: [Dbmail] dbmail-smtp does not insert

darookee wrote: Hi everybody! I tried this now for a few times... I Installed dbmail the first time and everything worked perfectly... Because i'm using gentoo I tried to make an ebuild. So i deleted everything from my system ( including the database tables etc... ) and installed it with my o

Re: [Dbmail] dbmail-smtp does not insert

Something else occurred to me: Where exactly do these mysql-logs come from? darookee wrote: 030803 0:59:32 222 Connect [EMAIL PROTECTED] as anonymous on This doesn't look like a connection from dbmail-smtp to me. You're connection here to no database at all. Is this a some mysql c

Re: [Dbmail] heyas again..

Try searching the recent archives of the list. Auto-reply as build into dbmail appears to be broken. A patch to fix this was posted last week. Also, last week I've posted a HOWTO for setting up autoreplies with dbmail using procmail. Daniel Bryant wrote: :) still trying to get the auto_

Re: [Dbmail] heyas again..

ok for the patch tho.. Thanks again, Dan. - Original Message - From: "Paul J Stevens" <[EMAIL PROTECTED]> To: Sent: Sunday, August 10, 2003 7:32 PM Subject: Re: [Dbmail] heyas again.. Try searching the recent archives of the list. Auto-reply as build into dbmail appea

Re: [Dbmail] dbmail and mysql replication

Matt Dickinson wrote: Hi, I've currently got 2 servers running a "conventional" postfix/uw-imapd solution, and I've been looking to replace this with a more reliable system in the event of a machine failing. Having come across dbmail today, I'm impressed so far :-) But just a quick question..

Re: [Dbmail] dbmail and mysql replication

Matt Dickinson wrote: Paul J Stevens wrote: Sure. Why not. Run a heartbeat-cluster with IP fallover for a mysql cluster. Use as many different machines as you like, or the same two machines for that matter, as pop/imap/smtp frontends, all pointing to the mysql master for their storage

Re: [Dbmail] Deleting emails and debian packages

[EMAIL PROTECTED] wrote: Hi, It looks like my emails stay in the mysql database ( 570+ atm) how can i flag all email of all domains / users to be deleted.. i want to start with a clean database atm.. howabout delete from messages; delete from messageblks; and, the debian package has

Re: [Dbmail] dbmail and mysql replication

Ilja wrote: On Thursday, Aug 21, 2003, at 16:44 Europe/Amsterdam, Paul J Stevens wrote: Matt Dickinson wrote: Those schema are seriously bogus. They contain many duplicate indexes and fail to include some essential ones. Also, the auto_notification and auto_reply features are broken

Re: [Dbmail] problem with To address

When you suspect a problem with dbmail: - upgrade your dbmail installation. It's ancient ! - bump the DEBUG switches in dbmail.conf to 5 - post the relevant syslog lines so we can see what's happening - post the fetchmail stanza so we can see what you're trying to do When upgrading from pre-1.0

RE: [Dbmail] custom mailbox creation [Fwd: [Dbmail] New db_insert_message with auto-mailbox creation]

I like this patch. -- Paul Stevens mailto:[EMAIL PROTECTED] NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] The Netherlandshttp://www.nf

Re: [Dbmail] moving messages using imap not working

Michael Kefeder wrote: KMail tells me that deletion of the message failed and Mulberry crashes a few seconds after it tried to move the message. The syslog does not tell me anything useful (does not even mention the attempt to move a message) - any hints about how i can track that issue down to

Re: [Dbmail] forward a COPY of mail

Preisinger Áron wrote: Hi I use postfix+dbmail. I'm trying forward a COPY of mails that receives to [EMAIL PROTECTED](dbmail) to [EMAIL PROTECTED](in an other domain on an other server), so [EMAIL PROTECTED] AND [EMAIL PROTECTED] has the email, but I can't do it. Has anybody any idea how ca

[Dbmail] important update of debian packages

Hi all, I'm close to having dbmail uploaded for inclusion into the main debian archives. If things go smoothly we might even make it into the upcoming sarge release. Debian policy forced me to use the latest released tarball, i.e. dbmail-1.1. I've patched this version to match the current CVS

Re: [Dbmail] important update of debian packages

[EMAIL PROTECTED] wrote: Debconf support was improved and now supports dutch and italian locales. I'm still seeing problems with restarting the daemons on busy systems. Wel, the bug for restarting dbmail happens also on a not busy system. Busy as in serving clients. I've never noticed r

Re: [Dbmail] LDAP

Actually its not there. Jesse Norell wrote: Hello, You can download it from the SourceForge project page: http://sourceforge.net/tracker/index.php?func=detail&aid=777879&group_id=85894&atid=577644 Original Message From: Honghai Gu To: Subject: [Dbmail] LDAP Sent: Wed, 13 Aug 200

Re: [Dbmail] exim+dbmail

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My advice would be to: useradd dbmail groupadd dbmail chown dbmail:dbmail /etc/dbmail/dbmail.conf chown dbmail:dbmail /usr/sbin/dbmail-smtp chmod 0600 /etc/dbmail/dbmail.conf chmod 4755 /usr/sbin/dbmail-smtp also, make sure you run dbmail-imapd and/

Re: [Dbmail] Hi

Eric Estabrooks wrote: Jesse Norell wrote: Hello, From: Jason Jorgensen I have alittle problem with dbmail getting in to some sort of locked or strange state. In a mail client if I switch rapidly from different imap folders the daemon stops responding to all clients. I have to restar

Re: [Dbmail] help on autoreply and aoutonotify ?

Some time ago Roel explained: the auto-reply option requires an extra table (auto_replies); setting the option to YES causes the dbmail-smtp program to send an automatic (predefined in the auto_replies table) reply-message to be send. In the same stroke there is a AUTO_NOTIFY option causing a me

Re: [Dbmail] info on auto_reply

general advise: Set debuglevel to 5 under the SMTP stanza. And send us some logs if that doesn't tell you more. Nunno Luca wrote: Excuse me for previous mail. I found auto_reply in sql directory on CVS. With my users ID and a body message in auto_reply tables, i’ve this error row in m

Re: [Dbmail] 100% cpu usage with dbmail-pop3d

Jamie Becker wrote: (as i said, i'm thinking about taking the existing python imap server code in twisted matrix and writing a new dbmail-server engine around it with pluggable backend message stores. the performance might not be as high (python vs straight c) but the long term maintenance wou

Re: [Dbmail] solicit feature interest

Jesse, I'm interested. Does the patch apply cleanly to current CVS-head? Does it support both mysql and postgresql? If so, could you please send me the patch, or upload it to sf.net. I'll see if I can extend the current debian packages with this added capability. fwiw, I have no problems wi

Re: [Dbmail] Request....Rules for imcomming mail

This is a FAQ. You can handle filtering of email through procmail filters. Drawbacks: your users need shell accounts, mailboxes have to exist beforehand, and there are as of yet no commandline tools to create mailboxes. There have been floating around some patches for auto_creation of mailboxe

Re: [Dbmail] feature solicitation

I disagree. Think about a setup where more than one frontend connect to a single backend. Storage of configs in the database was how things were done pre-1.0. Bad idea. I want to be able to tune front-end specifics on the front end: listen at different addresses, run at different debug levels,

Re: [Dbmail] Wow 1.2 is nice but found a few things.

Brett (Mare) Henley wrote: Hello everyone, I heard about DBmail on Freshmeat Monday and decided to try it out. It seems to have promise. But I found a few things that I hope will help make using it a bit better. 1. the build.sh has 3 errors in it. lines 65. 68 I believe there needs to be a s

Re: [Dbmail] Wow 1.2 is nice but found a few things.

Ilja Booij wrote: The tables are fixed in CVS. For people using the DBMail 1.2 release: I've put Paul's SQL-script on http://www.dbmail.org so you can download it, and run it against your PostgreSQL DBMail database. This update script can also be found in the sql/postgresql/ directory in the s

Re: [Dbmail] Webmin Management of Dbmail?

ple dialog based wrapper for the dbmail-adduser usermanagement # utility for dbmail (www.dbmail.org) # # Licence: GPL (www.gnu.org) # Author: Paul J Stevens <[EMAIL PROTECTED]> # # (c) 2003, NFG Net Facilities Group BV, Utrecht NL. # # $Id: dbmailctl,v 1.2 2003/03/18 13:40:52 paul Exp $ L

Re: [Dbmail] auto_replies (again)

Butch Evans wrote: So, is this thread gonna die without an answer, too? Do I sense a certain level of frustration here ? Has anyone gotten Postfix+DBmail (using 1.2 now) working with auto_replies? Do you read any C? From what I understand when reading pipe.c it looks like your trapmail.

Re: [Dbmail] Mac OS X Installation

Lars Hedquist wrote: mysql -u root -p < sql/mysql/create_tables.mysql" ... I did EXACTLY this, but I guess it means that you need to do: % mysql -u root -p mysql> CREATE DATABASE DBMAIL; Query OK, 1 row affected (0.11 sec) .. But then what do I do to CREATE TABLE? create_tables.mysql does

Re: [Dbmail] dbmail-1.2 +MySQL-4.1 barfs

From reading the mysql site re 4.1 changes vis-a-vis 4.0: DEFAULT values no longer can be specified for AUTO_INCREMENT columns. (In 4.0, a DEFAULT value is silently ignored; in 4.1, an error occurs). (ref http://www.mysql.com/doc/en/Upgrading-from-4.0.html) So my guess: just change all DEFA

Re: [Dbmail] dos attack

You're right. Dbmail simply spawns NCHILDREN, accepts MAXCONNECTS subsequent connects per child, and then exits and respawns that child. Afaik MAXCHILDREN is not used at all. So if you're looking for intelligent pre-forking of children, or even simply linear scaling of children to accept inc

Re: [Dbmail] dos attack

I will look into this. Ilja Booij wrote: Hi All, On Sunday, Oct 19, 2003, at 17:53 Europe/Amsterdam, Paul J Stevens wrote: You're right. Dbmail simply spawns NCHILDREN, accepts MAXCONNECTS subsequent connects per child, and then exits and respawns that child. Afaik MAXCHILDREN is not

Re: [Dbmail] updating my dbmail

Upgrading from 1.1 to 1.2 should not cause any trouble at all. There are no compatibility issues what so ever. Just bugfixes and speedups. Generally: 1) download, configure, make, make install 2) restart dbmail dbmail wrote: Hey guys. I installed dbmail a few months ago (version 1.1) a

[Dbmail] auto_reply works just fine.

It work for me. I'm using [SMTP] SENDMAIL=/usr/sbin/sendmail cat >> testmail << EOF From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: test test EOF echo "insert into auto_replies (user_idnr,reply_body) values (23,'some\nsilly\mtest\n')" | mysql dbmail cat testmail | dbmail-smtp -u tes

Re: [Dbmail] auto_reply works just fine.

AIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens Sent: 23. oktober 2003 10:31 To: dbmail@dbmail.org Subject: [Dbmail] auto_reply works just fine. It work for me. I'm using [SMTP] SENDMAIL=/usr/sbin/sendmail cat >> testmail << EOF From: [EMAIL PROTECTED] To:

Re: [Dbmail] piping in the aliases table

Daniel Bryant wrote: Hi. As i mentioned a few hours ago, im planning on writing a php script to handle auto-responders. I plan on doing this by using the aliases table to pipe to a php script, which will in turn query a database and check how many times an autoresponse has been sent to

Re: [Dbmail] memory problem on RedHat 9 and dbmail 1.1

I for one would vote against having those patches be accepted into CVS, and I imagine Ilja wont commit them as they are. Don't get me wrong though; inetd functionality is a valuable attribute, but I don't think they should be acquired by forking existing files. Personally, since I'm workin

Re: [Dbmail] using dbmail as a mail archive

Giorgio70165 wrote: It could be simpler to use and externa tool as preprocessing that strip attachments, and insert something like nfs,http,smb url of location in the saved mail but don't know how to do that. Any suggestion? And by then, unless very careful you'd be dropping dbmail's keyfeatu

Re: [Dbmail] message sending

I use 'dbmail-smtp -m some/other/mailbox -u someuser' This is not documented in the manpage. A longstanding ommision. Alexander Prohorenko wrote: Guys! Are there any tool to mannualy put a message file (say, Unix mailbox, or just a piped message) to some SPECIFIC folder in the dbimapd IMAP? T

Re: [Dbmail] Latest dbmail-2 from CVS doesn't like to work with MySQL

No. You have to specify two new parameters in dbmail.conf sqlport=3306 sqlsocket=/var/run/mysqld/mysqld.sock If you specify host=localhost, sqlsocket IS required since mysql_real_connect will connect to the unix socket instead of a tcp socket. Otherwise, if host=someotherhost sqlport is requir

Re: SV: [Dbmail] Easiest way to transfer mails from postgresql 1.x to mysql 2.x or 1.x does not matter.......

What are the exact aliases that make the script barf? Try: cursor_2.execute("""INSERT INTO auto_notifications (auto_notify_idnr, user_idnr, notify_address) VALUES ('%s', '%s', '%s')""", record) instead around line 113. Notice the single quotes ar

Re: [Dbmail] compiling 2.0 RC1 error with tm in misc.c

Bruno Bauer wrote: I am happy about 2.0 but since it is not yet in debian I have to compile myself. And it won't be in debian until 2.0-final is released and I or someone else writes a clean script to convert the dbmail-1 db into a dbmail-2 db in place (i.e. without using a second db)

Re: [Dbmail] compiling 2.0 RC1 error with tm in misc.c

Christian G. Warden wrote: On Sat, Jan 31, 2004 at 07:11:38PM +0100, Paul J Stevens wrote: Bruno Bauer wrote: I am happy about 2.0 but since it is not yet in debian I have to compile myself. And it won't be in debian until 2.0-final is released and I or someone

Re: [Dbmail] compiling 2.0 RC1 error with tm in misc.c

Christian G. Warden wrote: On Sat, Jan 31, 2004 at 07:11:38PM +0100, Paul J Stevens wrote: Bruno Bauer wrote: I am happy about 2.0 but since it is not yet in debian I have to compile myself. And it won't be in debian until 2.0-final is released and I or someone

Re: SV: SV: [Dbmail] Easiest way to transfer mails from postgresql 1.x to mysql 2.x or 1.x does not matter.......

tions.py", line 33, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1136, "Column count doesn't match value count at row 1") fw# -----Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne af Paul J Stevens Sendt: 31

Re: SV: SV: SV: [Dbmail] Easiest way to transfer mails from postgresql 1.x to mysql 2.x or 1.x does not matter.......

have another (better ;) ) look at migration scripts this week. Ilja Paul J Stevens wrote: Again, try putting single-quotes around all the %s. Mikael Syska wrote: Hi Poul, The alias is "[EMAIL PROTECTED]" Nope did not help to solve the problem. I have now tried

Re: SV: SV: SV: [Dbmail] Easiest way to transfer mails from postgresql 1.x to mysql 2.x or 1.x does not matter.......

Yes, I'm using Christian's script as a base. Ilja Booij wrote: Hi, Paul J Stevens wrote: Perhaps you should then first migrate from pgsql to mysql, before moving from 1.2 to 2.0: I once used: pg_dump --file=/var/tmp/dbmail-dump.pgdata --format=p --data-only --inserts --no-

[Dbmail] debian update

I've just finished uploading the updated experimental packages for dbmail-2.0 They are CVS snapshots, not rc1 They contain migration scripts for mysql and postgresql. Pure SQL. More tests are required for these. I'll add them here as well. There are still some rough edges to these packages:

Re: [Dbmail] debian update

to messages toggle_messages_constraint ON (1 row) That good enough for you? -Feargal. On Tue, 03 Feb 2004 17:33:27 +0100 Ilja Booij <[EMAIL PROTECTED]> wrote: Hi, I was trying the PostgreSQL script, but it failed on some foreign key checks. I'd lik

Re: [Dbmail] Manual

Doesn't man dbmail-adduser work for you ? Marko Djordjevic [EMAIL PROTECTED] wrote: Hi Folks, Does it exist any Manual for DBMAIL ? Add Users, delete Useres, change password etc… thx [EMAIL PROTECTED] send your message Marko Djordjevic Head of Vis

Unique keys (was Re: [Dbmail] Does DBmail support spam-, virus-filter, SPF, tar pitting and sorting into folders?)

Indeed. Just remove the uniqueness. Also, while looking into this: Roel: why do all the innodb tables contain additional unique indexes on all tables's primary keyfields: PRIMARY KEY (alias_idnr), ... UNIQUE alias_idnr_2 (alias_idnr) seems like pretty redundant to me. John Hansen

Re: Unique keys (was Re: [Dbmail] Does DBmail support spam-, virus-filter, SPF, tar pitting and sorting into folders?)

upport spam-, virus-filter, SPF, tar pitting and sorting into folders?) it sure is redundant, should have been removed a long time ago :$ Op 8-feb-04 om 8:56 heeft Paul J Stevens het volgende geschreven: Indeed. Just remove the uniqueness. Also, while looking into this: Roel: why do all the inn

Re: Unique keys (was Re: [Dbmail] Does DBmail support spam-, virus-filter, SPF, tar pitting and sorting into folders?)

Ilja, The uniqueness on the alias table should of course also be removed from the migration sql-code for postgres. Paul J Stevens wrote: Indeed. Just remove the uniqueness. Also, while looking into this: Roel: why do all the innodb tables contain additional unique indexes on all tables&#

Re: [Dbmail] dbmail + exim, router problem?

I just recently received a exim/dbmail-mysql howto from another debian developer. Might be helpful. It's in linux-doc format. Perhaps you could share your thought on this one, since I don't use exim myself, but would like to include exim and other mta related setup docs with the debian packag

Re: [Dbmail] injecting emails in chinese

I'm guessing this is more a backend issue rather than a dbmail issue. Just a quick googling reveils that mysql-4.1 should have proper unicode support but alas, only for the myisam and heap tables. Not for innodb. So if unicode support is required, you should probably switch to postgresql. J

Re: [Dbmail] dbmail unable to find recipient dbmail + postfix

Your installation is incomplete. Part of the create_tables... sql files is the statement: INSERT INTO users (userid, passwd, encryption_type) VALUES ('[EMAIL PROTECTED]@__', '', 'md5'); Apparently this systemuser is missing. David wrote: Hi, I'm new to DBmail and am having some diffic

Re: [Dbmail] How to get /var/mail/username to dbmail?

cat /var/mail/username|formail -s dbmail-smtp -u mydbmailusername should do the trick. Of course you need to have procmail installed to get formail. And of course this only works for mbox type mailboxes. Maildir and mbx type mailboxes require somewhat different approaches. Matthias Guenther

Re: [Dbmail] Postfix with IMAP

David, You should fix your smtpd_recipient_restrictions parameter. The fine manual reads: # reject_unauth_destination: reject mail unless it is sent # - to destinations matching $inet_interfaces, $mydestination, # or $virtual_maps. # - to destinations matching $relay_domai

Re: [Dbmail] Debian dbmail 2.0-0_20040224-1 - problems

For MINSPARECHILDREN and MAXSPARECHILDREN something like 2 and 5 should be fine, depending on your load. For MAXCHILDREN try 40 or more if your sql server allows that many connections. These new config settings are part of the preforking code that are targetted at the 2.1 release. They may or may

Re: [Dbmail] 2.0 Stability

Dont use rc2 if you have mozilla/thunderbird clients. We have a grave bug in the server code preventing dbmail2 from interacting nicely with mozilla's imap clientcore. Release-critical stuff imo. Check the devel list to stay updated. Rod K wrote: We'll be throwing together a new server soon

Re: [Dbmail] db connection - mysql

This is mysql-api dependant. Referring to 'mysql_real_connect' for the mysql C-api docs: `mysql_real_connect()' attempts to establish a connection to a MySQL database engine running on `host'. `mysql_real_connect()' must complete successfully before you can execute any of the other API functions

Re: [Dbmail] db connection - mysql

If host is localhost there is no real choice. Sockets will be used. The quote from 'info mysql' is had in mind in the earlier post: * The value of `host' may be either a hostname or an IP address. If `host' is `NULL' or the string `"localhost"', a connection to the local host is as

Re: [Dbmail] Backing up dbmail mysql innodb with mysqldump

I use mysqldump --opt dbmail, but I guess it's a matter of taste. However, remember to execute: SET FOREIGN_KEY_CHECKS=0; SET SQL_LOG_OFF=1; SET SQL_LOG_UPDATE=0; before you start loading such a backup file. Esp if it's big. So if dbmail.preload.mysql contains the previous statements, mysql

Re: [Dbmail] Postfix 2.0 + DBMail + SMTP AUTH

Chris Nolan wrote: Hi all! I'm looking to migrate the dodgy setup from hell to DBMail. Here's the problem: * The current setup is: Postfix 1.x + UW-IMAP (ugh...) + SASL + PWCheck I want to move this across to: Postfix 2.x + DBMail Migrating existing mail isn't a problem, but migrating ex

Re: [Dbmail] Debian and dbmail 1.2.3

backport to woody of dbmail-1.2.3 has just been uploaded to debian.nfgd.net Louis van Belle wrote: Is there a change the 1.2.3 dbmail version Wil be packaged for debian woody (stable) ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.f

Re: [Dbmail] Postfix 2.0 + DBMail + SMTP AUTH

Chris Nolan wrote: And SMTP AUTH with users in dbmail only, will work if you use pam-mysql. Of course if 2.0 will do ldap that will work even better performance wise. Admittedly, I want to get as far away from SASL as I can. I've used Cyrus stuff before and although it's quite good, th

Re: [Dbmail] Dbmail quota in version 2.0

What's the difference of users storing their mail in inbox rather than some other folder ? Jacques Beaudoin wrote: Could a parameter in the dbmail.conf file be set in dbmail 2.0 so quota would only apply to users folders excluding the inbox. Then i could let all my users receive all the ma

  1   2   3   4   5   6   7   8   9   10   >