Re: [Dbmail] SQLException: innodb_log_file_size headache

#x27;. 2016-03-21 01:38:50 75322 [Note] Event Scheduler: Loaded 0 events 2016-03-21 01:38:50 75322 [Note] /usr/local/libexec/mysqld: ready for connections. On 3/21/2016 3:39 AM, Reindl Harald wrote: Am 21.03.2016 um 10:07 schrieb Jonathan Feally: After taking a look in lmtp logs I fo

[Dbmail] SQLException: innodb_log_file_size headache

FYI, After performing a number of upgrades on my FreeBSD ports based install on an older release of FreeBSD 9.1-STABLE, I started getting corrupt messages. Since it was seemingly random on message with attachments, and I had upgraded postfix, mailscanner, dbmail, and mysql all the the same tim

Re: [Dbmail] {Spam?} Re: dbmail and multimaster mysql replication

I tested MySQL proxy last year, and the delay inserted because of the proxying was huge. DBMail has a lot of queries just to do simple things (a lot of IMAP compliance) and it just slows it way down. I think logging into a mailbox with a user will very little email in the INBOX went from 0.5 se

Re: [Dbmail] Version

. > > If you have an elegant solution please share. > > > Jonathan Feally wrote: > >> Paul, >> This problem still exists on FreeBSD - just did a fresh git and compile. >> The version 0.9.9 is the version of mhash on the system as it is setting >> the PAC

Re: [Dbmail] Version

Paul, This problem still exists on FreeBSD - just did a fresh git and compile. The version 0.9.9 is the version of mhash on the system as it is setting the PACKAGE_VERSION defines/declares before we try to set them again to our version. Perhaps we can just create our own DBMAIL_VERSION to be us

Re: [Dbmail] DBMail 2.2.12 released

Aleksander Kamenik wrote: > Bret Baptist wrote: > >> Also looks like the "internaldate as UTC" is causing issues with Mac Mail >> and >> older Outlook clients. They are subtracting the time zone offset from the >> received time. >> > > I can confirm this. After upgrade to 2.2.12 MS Outl

Re: [Dbmail] DBMail 2.2.12 internal date offset wrong

Jonathan Feally wrote: > The correct operation would be to have the UTC timestamp stored in the > database. When read from the database, it is not adjusted other than to > add + for a timestamp to the reformatted time. The patches > http://git.dbmail.eu/cgit/cgit.cgi/paul/dbma

Re: [Dbmail] DBMail 2.2.12 released

Paul J Stevens wrote: > >> It looks like it is happening for post 2.2.12 inserted email. Perhaps only >> with IMAP clients, but I was not able to confirm before I rolled back to >> 2.2.11. >> > > Jon, > > Any ideas here? > > Oh thanks for passing the ball to me. What timezone is the ser

Re: [Dbmail] DBMAIL error on SELECT

Michael Monnerie wrote: > On Donnerstag 17 September 2009 Paul J Stevens wrote: > >> No way around that without full text indexing. >> > > Any chance to have FTI support? PostgreSQL 8.3 has that built-in AFAIK, > so it could be interesting. Dbmail could support it if the DB supports > it,

Re: [Dbmail] IMAP quick resync?

George Vieira wrote: > Yeah I got dbmail configured for multiple servers hosting the same domain (or > others) but need an option to move users to another server hence the question > came up during this post. > DBMail Hyrda - (2.5.x) is planning on a split front-end, multi-back-end setup to a

Re: [Dbmail] MySQL tweaks?

Simon Gray wrote: > Michael Monnerie wrote: > >> Note: >> Everybody who care about their data, you should leave this setting on >> it's default "1": >> innodb_flush_log_at_trx_commit=1 >> >> > Also, this will only affect writes - rather than reads. > > If you have minimal writes and

Re: [Dbmail] MySQL tweaks?

Ok - but your sliderule is bent too. 139KB/message looks more correct. I must have had too many 1024's in there to the first time. Ken D'Ambrosio wrote: > Thanks for all the pointers! Though I'm afraid your sliderule* dropped a > decimal: 1*10^11 / 7.5*10^5 = 13., or 13K/message. I'm ru

Re: [Dbmail] MySQL tweaks?

Ken D'Ambrosio wrote: >> How much data are you searching through? (how big is your dbmail db?) >> > > Roughly 100 GB; it's got 750K messages or so. > You need to clean and optimize your tables. With a quick calc, that would put you at about 140MB/message. Are you on 2.2.x or 2.3.x? You sh

Re: [Dbmail] IMAP quick resync?

Shane, Briefly looking at the two RFC's, i think we could do this, but it will take some work. This would have to go into the 2.3.x branch. What client are you using that is supposed to support CONDSTORE and QRESYNC? Paul, I think we can add a modseq bigint to the messages table. This value wou

Re: [Dbmail] DBMAIL error on SELECT

What database server and version are you using? This seems like an older database not able to handle that query. -Jon David Young wrote: > Hi, I recently upgraded my dbmail to 2.2.11 and decided to create a > new email account/mailbox to make sure everything is working > correctly. I sent mys

Re: [Dbmail] recipient redirect

sendmail_destination_recipient_limit = 1 This could be the wrong option, but I'm not sure of the right one if it is needed at all. Jonathan Feally wrote: > You can try to make your distribution lists using an external forward, > and set postfix to send the message to each recipient

Re: [Dbmail] recipient redirect

You can try to make your distribution lists using an external forward, and set postfix to send the message to each recipient instead of trying to group them into a single message. This would effectively make the message be received by dbmail-lmtpd and then resend the messages back to postfix fo

Re: [Dbmail] recipient redirect

Ok, I will chime in now with your answer, In your databases create the view to merge users with their aliases: CREATE ALGORITHM=UNDEFINED definer=`ro...@`localhost` SQL SECURITY DEFINER VIEW `dbmail_postfix_map` AS select `dbmail_users`.`userid` AS `user`,`dbmail_users`.`passwd` AS `passwd` from

Re: [Dbmail] stunnel replacement

Michael Monnerie wrote: Why not just download source and compile it? Packages are nice, but I never restrict myself to just the available packages. If it isn't available as a package for a production box, then test in dev real quick, then get it compiled in production and move on. Of course 2.

Re: [Dbmail] Calculate mailbox size?

OK - 2nd try forgot the WHERE msg.status < 2 If you don't include the msg.status < 2, then you will be counting all messages, whether deleted or not. status=2 deleted (expunge done), status=3 deleted waiting for purge run to actually be deleted. Well, If you are looking for the used space o

Re: [Dbmail] Calculate mailbox size?

Well, If you are looking for the used space of the user in general, then dbmail_users.curmail_size is the column you want. SELECT curmail_size FROM dbmail_users WHERE userid="theuser"; But I think you want to get a per mailbox (folder) look, so: SELECT users.userid user, mbx.name mailbox, COUNT

Re: [Dbmail] 2.3.6 delivery failed with malformed subject

Piotr Wadas wrote: > Error:[message] _header_value_get_id(+1577): SQLException: ERROR: value too > long for type > character varying(255) > > >

Re: [Dbmail] 2.3.6 delivery failed with malformed subject

You are using dbmail-deliver with sendmail? Try setting your syslog to level 511 and running again. I don't like the syslog logging as it cuts off messages, but it should give us more than stdout/stderr that is lost with sendmail piping to dbmail-deliver. -Jon -- Scanned for viruses and dange

Re: [Dbmail] Error dbmodule

You will need to be more verbose about your problems when requesting help. We are not mind readers. If you are trying to run 2.2.x, then you need to compile --with-mysql or --with-pysql If you are trying to run 2.3.x, then your libzdb needs to be compiled with the correct database support. Wit

Re: [Dbmail] Error

Edson F. Cunha wrote: > > > Jul 28 14:13:42 x.x.xxx.xx lt-dbmail-pop3d[23598]: > Error:[server] server.c,server_run(+278): unable to drop privileges > Jul 28 14:17:09 x.x.xxx.xx lt-dbmail-pop3d[23674]: > Error:[misc] misc.c,drop_privileges(+76): could not find group nogroup Looks

Re: [Dbmail] dbmail looses mail address in From: header

Michael Monnerie wrote: > Is this a know bug? > > When I receive mail from this guy, in Zarafa/Outlook it stores the > header like this: > From: =?windows-1252?Q?M._Oostergo?= > Is this when you retrieve the message from a non-dbmail pop3/imap server? > But when received over dbmail, the mail

Re: [Dbmail] client groups, group quotas, ldap etc.

Piotr Wadas wrote: > Hello, > I've read this (quite old) > > http://www.nabble.com/Group-quotas-td7814443.html#a7814443 > > What's the current status of this ? client_idnr column is still present, > and there's field_cid in ldap configuration in dbmail.conf > > Can I ask some up-to-date explanatio

Re: [Dbmail] Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder

Michael Monnerie wrote: > > select * from dbmail_messages where physmessage_id IN (select > physmessage_id from dbmail_subjectfield where subjectfield like > 'Annoying%DELETE THIS MESSAGE%'); > > Instead of "select *" simply write "DELETE" and those messages are gone. > > mfg zmi > I'm glad y

Re: [Dbmail] auto replies / vacation messages

Casper Langemeijer wrote: > Hi All, > > What is the correct way to implement out of office replies for dbmail > 2.2? I see people on this list using sieve (vacation), but I've used > an entry in dbmail_auto_replies, and I think (but am not sure) that > I've seen that one work before. > auto-rep

Re: [Dbmail] URGENT: Accidentally delete mail user with dbmail-users -d

Perhaps we should have a status column on dbmail_users like we have on messages. 0 = disabled 1 = enabled 2 = deleted 3 = purge ok Then on the dbmail-util run it will moved deleted to purge - then really delete the purge like we do with messages. -Jon -- Scanned for viruses and dangerous c

Re: [Dbmail] MySQL 5.1 dependancy?

Dan, I'm not sure who put that in the UPGRADING doc, but 5.0.x will work fine. I have not tested 5.1.x for performance fixes in a while. 5.1.x could be ok now, but if you can run 5.0.83 then do that for best bets. I have not tried 5.4.x, so I can't comment on that other than its pretty new. The

Re: [Dbmail] DBMail 2.3.6 released ( works fine )

Something is missing in the constraints or dbmail-util clean up. With 0 messages, then headernames/headervalues should be 0 as well. I'm glad to see that headers is 0 as it should be. These should clean up the extra rows. Please note that these will take a while on a database with a lot of head

Re: [Dbmail] Repeated Folder Names

There is a sql migration from 2.2 to 2.3 that needs to be done in addition to dbmail-util runs. This could take longer than you expect to do. I'm not sure what the response difference is between 2.2 and 2.3 that needs to be corrected. Perhaps I'll test it later to see what I get. -Jon Gordan B

Re: [Dbmail] DBMail 2.3.6 released

Jake Anderson wrote: > Any chance of debs of this? > It makes upgrading much easier ;-> > > Oh and is there anything to migrate headers over to the new storage as > well? Debs would be Paul's dept. Part of upgrading to 2.3.6 removes the old header caching tables and creates new ones. dbmail-util

Re: [Dbmail] [Dbmail-dev] DBMail 2.3.6 released

Paul J Stevens wrote: > New features in this release: > There is also a new option -M on dbmail-util to migrate 2.2 messageblks stored messages to the 2.3 single-instance storage. Messages are moved 1 per run of dbmail-util. You can change the 1 limit with a -m # argument. -Jon --

Re: [Dbmail] Unable to have dbmail work on Fedora 11

Jean Naimard wrote: > $ dbmail-users -l * > Jun 26 17:34:45 domus dbmail-users[11177]: Error:[sql] > dbmysql.c,db_connect(+172): mysql_real_connect failed: Access denied for > user 'dbmail'@'x' to database '/var/lib/dbmail/dbmail.db' > Failed. Could not connect to database (check log) > Comma

Re: [Dbmail] emptying database

Piotr Wadas wrote: > The count(*) result is zero, anyway rows are still available in mentioned > tables, as listed :/ > Well then it sounds like the tables just need to be shrunk/optimized in postgres. I'm not sure what the syntax is to do that as I'm a mysql guy. -Jon -- Scanned for viruse

Re: [Dbmail] emptying database

Piotr Wadas wrote: > dbmail_physmessage| 994 > dbmail_fromfield | 994 > These match - that is good - should be one from header for each message > dbmail_envelope | 1057 > A couple extra maybe?? Not too far off. > dbmail_tofield| 5011 > This

Re: [Dbmail] emptying database

What tables still have a lot of rows? select count(*) from dbmail_xxx; For a single user, you should probably have <10 rows in all of the tables. Let me know what tables still have more than that. -Jon Piotr Wadas wrote: > >>> Garbage collection on dbmail_mimeparts is still missing. >>>

Re: [Dbmail] emptying database

Jorge Bastos wrote: > I think there's something incomplete on that function 'cause when I used the > git version when that was added, messages were not being completely removed. > It might be that we are missing the partlists cleanup. If the parts aren't being deleted, then that db_icheck_mimep

Re: [Dbmail] emptying database

Paul J Stevens wrote: > delete from dmail_mimeparts > where id not in (select part_id from dbmail_partlists) > > though this is of course a very slow query Hmm. I thought we have put in that cleanup in the dbmail-util for trunk (2.3.x) already?? dm_db.c:db_icheck_mimeparts(t/f) -Jon -- Scanned

Re: [Dbmail] dbmail performance test

appreciated. > > Thanks in advance, > > Andreja > > -Ursprüngliche Nachricht- > Von: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] Im Auftrag > von Andreja Babic > Gesendet: Donnerstag, 28. Mai 2009 09:37 > An: DBMail mailinglist > Betreff: R

Re: [Dbmail] dbmail performance test

It would be very nice if you were to compare the new 2.3.x from git vs. 2.2.x. I suspect that the size of the database will be much less than your 2.2 install and would like to see what performance difference there really is. If you were to run this test, please copy all the messages into a fre

Re: [Dbmail] LDAP Schema

s. > > How do I add dbmailUsers objectClass to existing users to I can > authenticate dbmail off the same user account? > > Thanks. > > Gordan > > Jonathan Feally wrote: > >> See - >> http://git.dbmail.eu/cgit/cgit.cgi/paul/dbmail/tree/dbmail.schema?h=dbm

Re: [Dbmail] LDAP Schema

See - http://git.dbmail.eu/cgit/cgit.cgi/paul/dbmail/tree/dbmail.schema?h=dbmail_2_2 We no longer use svn. I'm not sure as to how correct this schema is, but it should be better than what that old svn version shows. -Jon Gordan Bobic wrote: > Hi, > > Can anyone confirm if this is the most up t

Re: [Dbmail] Odd Behavior Under Mutt

Kevin Monceaux wrote: > I tried to build 2.3.5 and hit bug 757. The version of libzdb in > ArchLinux's package repository is version 2.4. > libzdb 2.3 and 2.4 support will be in 2.3.6. I think I'm holding up the 2.3.6 branch with my latest ideas. I'll get to work on giving Paul the final pa

Re: [Dbmail] Odd Behavior Under Mutt

Kevin, Since you are just trying it out, give the 2.3 branch a test. When 2.3.6 comes out, I would say you would be relatively safe to move to the new 2.3.x storage infrastructure. A few more changes are going to be in the database schema in 2.3.6. Possible a couple more that I'm working on tha

Re: [Dbmail] #noattach mode

Not to burst anyone's bubble, but we are talking about having dbmail intelligently rewrite messages for clients on demand. This could pose a big problem with the fact that all messages in a mailbox would have to be rewritten before a simple list command could be fulfilled as the size of the me

Re: [Dbmail] /tmp full

A simple way to determine who is at fault is to set tmpdir=/usr/mysql.tmp in my.cnf. cd /usr mkdir mysql.tmp chown mysql:mysql mysql.tmp vi /usr/local/etc/my.cnf insert or change tmpdir=/usr/mysql.tmp (this does not effect the /tmp/mysql.sock) /usr/local/etc/rc.d/mysql-server restart restar

Re: [Dbmail] OT: DBMail Administrator (DBMA) Performance Fix

Wallace Tan wrote: > And what's the best admin interface for DBMail? > > Not to toot my own horn, but I did up a php based administration tool for managing your mailboxes and aliases along with added functionality to partition your users into manageable groups. See http://www.netvulture.com/

[Dbmail] Are we alive or am I dead?

Testing the lists. I haven't gotten anything since 3/19. -Jon -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/ma

Re: [Dbmail] Resources on the project

Anyone can help contribute to the project Testing is always needed. Having people to checkout out that commits are doing what they are supposed to do along with not causing new issues helps keep the active commiters on track and being able to fix new bugs introduced faster. Database optimiza

Re: [Dbmail] sieve error on 2.2.10

This error would be coming from the fact that your script is trying to use notify. As far as I can tell, dbmail is currently not supporting the use of notify, despite setting sieve_notify=yes. There is processing of notify, but not supported nor maintained as far as I can tell given: excerpt fr

Re: [Dbmail] Installation issues

in your dbmail.conf change pid_directory = /var/run/dbmail* *then create the /var/run/dbmail directory owned by nobody:nogroup. Launching the daemon will then work properly. -Jon Cody Stewart wrote: Thanks. That fixed that issue. Now I am having an issue with starting the imapd. version = db

Re: [Dbmail] adding database rows and customize insert querys

I think we could defiantly store the individual parts encrypted in dbmail_mimeparts and still have the hash on the un-encrypted data. But the key to encrypt and decrypt would need to be stored/obtained somewhere for imapd and pop3d to know how to read and write those blobs. The header caching t

Re: [Dbmail] git head no sieve?

Confirmed. Working again. -Jon Uwe Kiewel wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Uwe Kiewel schrieb: Paul J Stevens schrieb: Uwe Kiewel wrote: Paul J Stevens schrieb: I haven't touched the sieve layer at all. Just return values from sql calls setting t

Re: [Dbmail] git head no sieve?

Testing now. Will report back shortly. -Jon Paul J Stevens wrote: Uwe Kiewel wrote: Paul J Stevens schrieb: I haven't touched the sieve layer at all. Just return values from sql calls setting the is_active field. Uwe Kiewel wrote: Paul J Stevens wrote: fixed n

Re: [Dbmail] git head no sieve?

Same problem for me. Haven't looked into it myself yet, but my Inbox is getting full of mailling list items. -Jon Uwe Kiewel wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul J Stevens schrieb: I haven't touched the sieve layer at all. Just return values from sql calls setting the

Re: [Dbmail] Message filtering.

You would need to setup sieve scripts for your mailboxes. See http://www.dbmail.org/dokuwiki/doku.php?id=sieve for how to write a script. This script will then do things with messages as they are delivered to dbmail via the dbmail-deliver (pipe method) or dbmail-lmtpd (LMTP delivery). Messages

Re: [Dbmail] About virtual domain routing

DBMail currently runs on only one database. Thus all email for your 3 domains would be in one database on one server. The number of front-end servers (dbmail-imapd) can be as many as you like - all accessing the MySQL/PostGres db over the network. Now you could run 3 databases, 3 front-ends, ea

Re: [Dbmail] DBMail 2.3.4 released

Have a look at http://git.dbmail.eu/?p=paul/dbmail;a=tree;f=sql;h=db840570d289ebbe1d77101724ec35a37ae03cf7;hb=master From there click on your database platform, then click on history next to the create_tables file. 2.3.2 came out on 2008-02-09, so any commits past date you should click on th

Re: [Dbmail] imapd error

It looks like you have either a db schema issue, or database server problem. Please do a show create table dbmail_messages; You should have a recent_flag field. If you are missing that field (unlikely) do a alter table dbmail_messages add column `recent_flag` tinyint(1) NOT NULL DEFAULT '0'; Y

Re: [Dbmail] Re: which tables

I thought I suggested that??? If you want all the messages in the old db, then the auto_increment will be much faster and more reliable. If you are wanting to filter out some messages such as only transfer mail that is <1 year old, then imapsync would be a better choice for that. If you already

Re: [Dbmail] Which tables

One option to migrate to a new server and still retain the old messages, but with a delay, is to start your new database with an auto_increment number for the dbmail_messages table that is greater than the max(message_idnr) on your existing dbmail_messages table. Then you can import a dump (us

Re: [Dbmail] Change Default Folder Names

As far as I know, only INBOX is created. The other folders are created by the client when logging in with IMAP. INBOX will always be INBOX. You will have to experiment with other language releases of the email client on a fresh user account to see if there is any difference. -Jon Wilfredo Pac

Re: [Dbmail] feature for dbmail-util

I was looking at the code for trunk/2.3.x and it looks like the vacuum switch is calling a function to do nothing. From the descriptions of what the -c flag should do, i think this is the function that used to do this and should be populated with the optimization of the tables code. Or make a n

Re: [Dbmail] Db growing size

n vacation, and he deserves!) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Feally Sent: terça-feira, 12 de Agosto de 2008 21:39 To: DBMail mailinglist Subject: Re: [Dbmail] Db growing size I looked at the code for dbmail-util and the clea

Re: [Dbmail] Db growing size

I looked at the code for dbmail-util and the cleanup of the partlists and mimeparts tables are not there. Thus your mimeparts will never be cleared out of parts that are no longer in ues. Run the normal dbmail-util -dy; dbmail-util -py; dbmail-util -cy to clean out any messages pending db dele

Re: [Dbmail] DBMAIL grinds to a craw in production

Also make sure that your MySQL is not 5.1.23 from packages or ports. I had an issue with the sorting of large result sets losing rows. I had the issue on both i386 and amd64. DBMail did all kinds a weird things such as messages not showing up at all when headers were downloaded. I'm glad that

Re: [Dbmail] DBMAIL grinds to a craw in production

Do Not use Mysql 5.1.23-rc on FreeBSD from ports/packages!!! Use 5.1.22. I ran into an issue where order by's were causing data from the result sets to be dropped. This was causing a lot of issues with dbmail imapd clients. There was a bug open on an issue with this with MySQL team. Essentially

Re: [Dbmail] Re: DBMail 2.3.0 released

I think that we should also add a column that specifies what hashing method(s) the hash value is on the row of the part. This would allow 2 things. 1) Re-Calculation of the hash value for a change in hashing methods could be interrupted and resumed later, and 2) Message insertion can still o

Re: [Dbmail] Re: DBMail 2.3.0 released

While there has been quite a bit of discussion already on this topic, and I know the purpose of this was to avoid collisions, has there been any thought in a configuration option to skip the blob comparison and assume they are the same? Perhaps a size threshold that has to be exceeded to skip t

[Dbmail] Feature request for 2.4.0

Hello All, While I know the Dev Team has plenty on their plate already, I would like to propose 2 new features to be included in the release of 2.4.0 (whenever that comes out). Feature 1: Database stored configuration leaving only the vital database connection information in dbmail.conf CRE

Re: [Dbmail] POP/IMAP logging via syslog

You can change the logged in /logging out messages in pop.c, dbmail-imapsession.c and imapcommands.c from a TRACE_MESSAGE to a TRACE_WARNING so you can use a TRACE_LEVEL=2. This will probably solve your problem. But you would need to change these everytime you compile a new version. I do see th

Re: [Dbmail] New DBMail Admin web tool released!

; // The encryption type to be used on passwords. Valid types are plaintext, crypt, md5-hash, md5-digest, or md5-base64 $encryption_type="md5-hash"; // $encryption_type=""; // This is what will show on the interface. Set to whatever you want to call your seperation of users.

RE: [Dbmail] DBMail usage poll

Sorry about that. The field is meant to capture the number of logins, not the count of all folders. Some people refer to a login as a mailbox. I'll change the text to be more specific. Thank you for participating in the poll. -Jon -Original Message- From: Aleksander <[EMAIL PROTECTED]>

[Dbmail] New DBMail Admin web tool released!

Greeting All, I am pleased to announce the release of my own DBMail Admin tool for DBMail 2.2.x. Yes - Its Free! You can download it at my site http://www.netvulture.com/nvcapps.php - I have also added a link on the Wiki so you can easily find it again

Re: [Dbmail] users and alias forwards together

Yes, that is how it works. Not quite as one would expect, but it can be worked around. Dbmail will checkthe aliases first. If one or more aliases exist for [EMAIL PROTECTED], then the mail is sent to those destinations, either a local mailbox, or sent to another email server. If no aliases are

Re: [Dbmail] Bug #579

ed by IMAP server. Query: SEARCH CHARSET ISO-8859-1 ALL BODY {2} aa Paul, Do you help me debuging this with gdb? - Original Message ----- From: "Jonathan Feally" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Wednesday, July 04, 2007 11:46 PM Subject: Re:

Re: [Dbmail] Bug #579

like i said in the previous email, after i received the error, i pushed the logout button on squirrelmail. - Original Message - From: "Paul J Stevens" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Wednesday, July 04, 2007 8:14 AM Subject: Re: [Dbmail] B

Re: [Dbmail] Bug #579

What OS, kernel, glib, and db versions are you running? I tested the search command by hand using the literal method and did not have any problems at all. Also - your log file doesn't seem to indicate anything about the child process crashing out, but rather that the main parent process was tol

Re: [Dbmail] DBmail webmail app

I don't think DBMAIL should try to impose any limits on an individual piece of mail size. Administrator's should limit the size of messages from the SMTP side, an wrist slap users putting messages in the system that are huge. Also keep in mind that most users are not going to have a 100 Mbit/se

Re: [Dbmail] single instance mime storage

Just to be clear - are you taking the headers of the mime part and keeping them seperate of the body of said part? My original post to keep them seperate was to allow for the attached file be renamed but not create duplicates, and also some mail clients may create the headers of the mime part s

Re: [Dbmail] DBmail webmail app

Consider the following tables: CREATE TABLE `dbmail_messageblks` ( `messageblk_idnr` bigint(21) NOT NULL auto_increment, `physmessage_id` bigint(21) NOT NULL default '0', `messagepart_order` int NOT NULL, `messagepart_idnr` bigint(21) NOT NULL, `mime_header` tinyint(1) NOT NULL DEFAULT '0',

Re: [Dbmail] FreeBSD 6.x - 2.2.0 rc2 - mysql 5.0.21 - libsieve 2.2.1 - goes BOOM! (temp workaround found)

How does it not work? Doesn't compile? Doesn't run? Doesn't run right? Did you make sure you installed the deps? Why not use 6-STABLE? I am having no issues with 6-STABLE with dbmail. This box actually runs dbmail inside a jail and has the database accessed via IP to another jail along with 8 o

Re: [Dbmail] Patch for LSUB/LIST "" "%/%" commands.

Thanks. I did test it some more and it seemed to work for everything I could throw at it. -Jon Paul J Stevens wrote: Jonathan, I've verified the validity of your patch and have merged it in my tree. Thanks a lot. regards, Jonathan Feally wrote: While playing around with 2.2.

Re: [Dbmail] delivery methods - POSTFIX SMTP AUTH / VALIDATION HOW TO

k place. -Jon Tom Allison wrote: Jonathan Feally wrote: I use postfix with smtp auth and receipient validation against dbmail with sasl. All user passwords must be in format crypt!! Can't do md5-digest eh? Good to know before I get too far along. Your write up

Re: [Dbmail] delivery methods - POSTFIX SMTP AUTH / VALIDATION HOW TO

I use postfix with smtp auth and receipient validation against dbmail with sasl. All user passwords must be in format crypt!! 1. Recieve mail for only those that have a userid or alias 2. SMTP AUTH with either his userid ([EMAIL PROTECTED]) or any of his aliases ([EMAIL PROTECTED]) 3. User can

[Dbmail] Patch for LSUB/LIST "" "%/%" commands.

While playing around with 2.2.0 rc2 - this is broken in 2.1.x as well - i found out that my netscape mail 7.2 will not show the folders as being able to be subscribed to. So - how to duplicate Create a folder structure that is 3 levels deep like Lists/DBMAIL/Boring with no other folders in DBM

Re: [Dbmail] FreeBSD 6.x - 2.2.0 rc2 - mysql 5.0.21 - libsieve 2.2.1 - goes BOOM! (temp workaround found)

I was able to compile and run dbmail-imapd just fine with the fix. -Jon Paul J Stevens wrote: Oleg, try the attached patch. UEMURA (fka. MAENAKA) Tetsuya wrote: Posted on Mon, 13 Nov 2006 11:37:56 +0300 by author Oleg Albegov <[EMAIL PROTECTED]> I think, i have the latest.. [EMAI

Re: [Dbmail] FreeBSD 6.x - 2.2.0 rc2 - mysql 5.0.21 - libsieve 2.2.1 - goes BOOM! (temp workaround found)

select_and_accept or i guess you could run dbmail-imap through inetd with the -n option. -Jon Jonathan Feally wrote: I have narrowed it down to the select_and_accept function in serverchild.c I can get the daemon to work just fine when I comment out the setting and the unsetting of the

Re: [Dbmail] FreeBSD 6.x - 2.2.0 rc2 - mysql 5.0.21 - libsieve 2.2.1 - goes BOOM! (temp workaround found)

ng a child getting stuck on an accept block when someone connects and then disconnects the tcp connection before a child has accpeted the conn. So this is to prevent DOS for the most part. -Jon Jonathan Feally wrote: Hello, I have a FreeBSD box that is already running dbmail 2.1.x against a

[Dbmail] FreeBSD 6.x - 2.2.0 rc2 - mysql 5.0.21 - libsieve 2.2.1 - goes BOOM!

Hello, I have a FreeBSD box that is already running dbmail 2.1.x against a mysql db - client and server is 5.0.21. I am trying to get it up to 2.2.0 rc2 with libSieve - and I can compile it just fine. The daemon starts. And all looks good in the logs. When I try to connect to the imap server

[Dbmail] Bug Cleanup

Hello, Being a new user of dbmail, but a longtime user of many other opensource projects, I have tried to get a handle on current issues and progress of DBMAIL's development. However, the bug system appears to be mostly ignored in terms of bug status and response to bugs in general. Feature re

Re: [Dbmail] Feature Request: trigger in dbmail

in it. I guess each dbmail daemon could have a tuneable as to whether it is going to update this field and on what events. -Jon Magnus Sundberg wrote: Aleksander wrote: Jonathan Feally wrote: As far as getting what your want done, I would suggest using a script driven via cron every half ho

Re: [Dbmail] Feature Request: trigger in dbmail

Triggers do sound interesting, however i'd rather see the effort put into server-side filters for sorting purposes then special execution of other applications. As far as getting what your want done, I would suggest using a script driven via cron every half hour or so. I have SpamAssassin's sa-l