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

2009-04-03 Thread Jonathan Feally
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

[Dbmail-dev] Are we alive or am I dead?

2009-03-24 Thread Jonathan Feally
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-dev mailing list Dbmail-dev@dbmail.org

[Dbmail] Are we alive or am I dead?

2009-03-24 Thread Jonathan Feally
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

Re: [Dbmail-dev] MySQL 5.1x

2009-03-11 Thread Jonathan Feally
I have some performance issues on 5.1 when it comes to sorting and using the indexes. Also had some queries just getting stuck processing. Stick with 5.0.x for production use for a while. I think 5.1.x and 6.x will start working better in the next couple releases, but won't try it again until

Re: [Dbmail-dev] heavy query with select inbox (git)

2009-02-27 Thread Jonathan Feally
I've found that with thunderbird, the select on the mailbox is not as much of an issue as the list/lsub of all the mailboxes that Thunderbird does on startup. My inbox usually hovers around 500 messages, but with 150-200 mailboxes, the list/lsub build a part of the cache out for those boxes

Re: [Dbmail-dev] heavy query with select inbox (git)

2009-02-27 Thread Jonathan Feally
I've found that with thunderbird, the select on the mailbox is not as much of an issue as the list/lsub of all the mailboxes that Thunderbird does on startup. My inbox usually hovers around 500 messages, but with 150-200 mailboxes, the list/lsub build a part of the cache out for those boxes

[Dbmail-dev] Git on FreeBSD broken

2009-02-25 Thread Jonathan Feally
Paul/Others, Starting with the first wip: buffered reads commit, FreeBSD IMAP TLS is broken. Thunderbird throws an error: Error establishing an encrypted connection to server. Error Code: -12217 The certificate is being transmitted just fine, but after accepting the cert, it blows up with that

Re: [Dbmail] sieve error on 2.2.10

2009-01-18 Thread Jonathan Feally
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

Re: [Dbmail] Installation issues

2009-01-14 Thread Jonathan Feally
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 =

Re: [Dbmail-dev] Bandwidth

2008-12-31 Thread Jonathan Feally
I'm guessing you are speaking about limiting the connection throughput to the clients? As it sits now, the daemons write out huge chunks of data all at once towards the client socket. I don't see how we can limit the speed of data written to the client with out some major reworking to keep it

Re: [Dbmail] git head no sieve?

2008-12-15 Thread Jonathan Feally
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

Re: [Dbmail] git head no sieve?

2008-12-15 Thread Jonathan Feally
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

Re: [Dbmail] git head no sieve?

2008-12-15 Thread Jonathan Feally
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

Re: [Dbmail-dev] opening tmpfile failed: Too many open files

2008-12-13 Thread Jonathan Feally
How many concurrent connections do you have when this happens? Perhaps you are having a DOS attack? -Jon Jorge Bastos wrote: Paul, continuing this problem, it still happens. -- Dec 13 15:22:59 lira dbmail/imap4d[21103]: [0x87aa260] Error:[message] _set_content_from_stream(+783): opening

Re: [Dbmail-dev] build dbmail-2.3 from scratch

2008-12-03 Thread Jonathan Feally
Try: autoreconf -i ./configure [g]make [g]make install You may need to add CFLAGS, LDFLAGS, and/or --with-sieve to your configure line depending on your system My FreeBSD system uses ./configure CFLAGS=-I/usr/local/include LDFLAGS=-L/usr/local/lib --with-sieve -Jon Uwe Kiewel wrote: I'm

Re: [Dbmail] Message filtering.

2008-12-02 Thread Jonathan Feally
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

2008-11-30 Thread Jonathan Feally
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,

[Dbmail-dev] 2.3.4 Internal date problem

2008-11-28 Thread Jonathan Feally
Is anyone experiencing an issue with the internal date being returned wrong for messages on IMAP? I am running FreeBSD, MySQL 5.1 delivered via postfix LMTP. Date on db row is corrected for TZ from -0800 (local machine time and zone) to +, but when recalled it is taken as is and the -0800

Re: [Dbmail-dev] 2.3.4 Internal date problem

2008-11-28 Thread Jonathan Feally
this issue with the 2.2.x series with the same pda phone, same database settings, same host settings. Only thing changed was the dbmail. -Jon Paul J Stevens wrote: Jonathan Feally wrote: Is anyone experiencing an issue with the internal date being returned wrong for messages on IMAP? I am

Re: [Dbmail-dev] 2.3.4 Internal date problem

2008-11-28 Thread Jonathan Feally
v1.0.0 Sender: [EMAIL PROTECTED] Errors-to: [EMAIL PROTECTED] X-original-sender: [EMAIL PROTECTED] Precedence: bulk X-list: dovecot X-UID: 3 Status: O Jonathan Feally wrote: Ok - so what I am seeing is with message insertion via lmtpd care of postfx. Sample e-mail is delivered at 2008-12-01 00:00

Re: [Dbmail-dev] mhash support for SQL auth?

2008-11-18 Thread Jonathan Feally
I've tested this patch on FreeBSD and adjusted the length of the pw variable 200-130. This also requires an adjustment to the dbmail_users.passwd column to accept the longer hash result. All seems well and working. Tested both pop3 and imapd Paul, I've commited this to my ready branch and

Re: [Dbmail] DBMail 2.3.4 released

2008-11-17 Thread Jonathan Feally
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

Re: [Dbmail] Re: which tables

2008-10-31 Thread Jonathan Feally
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

2008-10-27 Thread Jonathan Feally
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

RE: [Dbmail-dev] last SVN

2008-10-05 Thread Jonathan Feally
Jorge, please do let us know how it is working, along with the selective logging options now available. See the new dist/dbmail.conf on those new options and my last email to -dev. -Jon -Original Message- From: Jorge Bastos [EMAIL PROTECTED] Sent: Sunday, October 05, 2008 8:55 AM To:

RE: [Dbmail-dev] last SVN

2008-10-05 Thread Jonathan Feally
production server, if it's working OK -Original Message- From: [EMAIL PROTECTED] [mailto:dbmail-dev- [EMAIL PROTECTED] On Behalf Of Jonathan Feally Sent: domingo, 5 de Outubro de 2008 21:14 To: DBMAIL Developers Mailinglist Subject: RE: [Dbmail-dev] last SVN Jorge, please do let us

[Dbmail-dev] Trunk Logging Progress - Selective Logging - Session Tracking

2008-10-02 Thread Jonathan Feally
Paul and myself have been working on the logging of dbmail. Selective Logging: We have moved in favor of a selective logging level system that better mirrors syslog. Differences: Old: 6 Levels 0-5, each level including Syslog logging only logged to levels alert or notice depending on

[Dbmail-dev] IMAP append seq fault 11 problem with 2.3.x on FreeBSD 7.0-STABLE i386

2008-08-19 Thread Jonathan Feally
I was having an issue coping messages from another account into 2.3.x where large messages caused a seg fault 11. I was able to narrow it down to the creation of the buff char variable in dbmail-imapsession.c being initialized as the size of the message from the append {size} information.

Re: [Dbmail-dev] IMAP append seq fault 11 problem with 2.3.x on FreeBSD 7.0-STABLE i386

2008-08-19 Thread Jonathan Feally
to test and let you know. -Original Message- From: [EMAIL PROTECTED] [mailto:dbmail-dev- [EMAIL PROTECTED] On Behalf Of Jonathan Feally Sent: terça-feira, 19 de Agosto de 2008 19:31 To: DBMAIL Developers Mailinglist Subject: [Dbmail-dev] IMAP append seq fault 11 problem with 2.3.x

Re: [Dbmail] Change Default Folder Names

2008-08-19 Thread Jonathan Feally
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

Re: [Dbmail] feature for dbmail-util

2008-08-13 Thread Jonathan Feally
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

Re: [Dbmail] Db growing size

2008-08-12 Thread Jonathan Feally
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

Re: [Dbmail] Db growing size

2008-08-12 Thread Jonathan Feally
, 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 cleanup

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

2008-05-16 Thread Jonathan Feally
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

2008-05-14 Thread Jonathan Feally
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.

Re: [Dbmail] Re: DBMail 2.3.0 released

2008-01-07 Thread Jonathan Feally
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

Re: [Dbmail] Re: DBMail 2.3.0 released

2007-12-31 Thread Jonathan Feally
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

[Dbmail] Feature request for 2.4.0

2007-12-29 Thread Jonathan Feally
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

Re: [Dbmail] POP/IMAP logging via syslog

2007-08-07 Thread Jonathan Feally
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

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

2007-07-28 Thread Jonathan Feally
; // This tool works only in the database. LDAP modification is not done. Changing quotas and group id's may not do anything at all. // Set the next line to true to allow you to continue past the login screen. $skip_ldap_auth_warn=false; Jonathan Feally wrote: Greeting All, I am pleased to announce

RE: [Dbmail] DBMail usage poll

2007-07-27 Thread Jonathan Feally
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!

2007-07-24 Thread Jonathan Feally
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 http://www.netvulture.com/nvcapps.php - I have also added a link on the Wiki so you can easily find it again

Re: [Dbmail-dev] ./configure

2007-07-23 Thread Jonathan Feally
I don't think so. I compiled just last night with all 3 drivers, ldap and sieve and it seems to be ok. -Jon Keith Hopkins wrote: Hello, Is there any issues with the resulting dbmail binary if it built with more then one database type specified? (assuming all libraries are available to

Re: [Dbmail] users and alias forwards together

2007-07-18 Thread Jonathan Feally
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

Re: [Dbmail] Bug #579

2007-07-04 Thread Jonathan Feally
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 dbmail@dbmail.org Sent: Wednesday, July 04, 2007 8:14 AM Subject: Re: [Dbmail] Bug #579 Jonathan Feally wrote

Re: [Dbmail] Bug #579

2007-07-04 Thread Jonathan Feally
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 dbmail@dbmail.org Sent: Wednesday, July 04, 2007 11:46 PM Subject: Re: [Dbmail] Bug #579 Well

Re: [Dbmail] Bug #579

2007-07-03 Thread Jonathan Feally
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

[Dbmail-dev] FreeBSD 6.x Stable + glib = 2.12.11+ DBMAIL 2_2_branch + IDLE patch

2007-07-02 Thread Jonathan Feally
The attached patch fixes an issue I was having with my system. Apparently the g_strncasecmp call was broken with glib 2.12.9. The call seemed to think that an empty buffer still matched DONE. That caused all my connection to go into a bogus state. Upgrading to glib 2.12.12 (current version

Re: [Dbmail] DBmail webmail app

2007-06-06 Thread Jonathan Feally
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

[Dbmail-dev] Re: [Dbmail] single instance mime storage

2007-06-04 Thread Jonathan Feally
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

Re: [Dbmail] single instance mime storage

2007-06-04 Thread Jonathan Feally
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

Re: [Dbmail] DBmail webmail app

2007-06-03 Thread Jonathan Feally
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)

2006-11-17 Thread Jonathan Feally
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

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

2006-11-15 Thread Jonathan Feally
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

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

2006-11-15 Thread Jonathan Feally
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

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

2006-11-15 Thread Jonathan Feally
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 looks great! Thanks

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

2006-11-15 Thread Jonathan Feally
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.0 rc2

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

2006-11-14 Thread Jonathan Feally
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.. [EMAIL

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

2006-11-12 Thread Jonathan Feally
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 mysql db

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

2006-11-12 Thread Jonathan Feally
in 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

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

2006-11-11 Thread Jonathan Feally
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

2006-02-14 Thread Jonathan Feally
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: [Dbmail] Feature Request: trigger in dbmail

2006-02-02 Thread Jonathan Feally
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

Re: [Dbmail] Feature Request: trigger in dbmail

2006-02-02 Thread Jonathan Feally
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: snip As far as getting what your want done, I would suggest using a script driven via cron every half hour or so

<    1   2