[Dbmail] RE: debian update - Problems with owner_idnr being set to zero causes Foriegn Key problems

2004-02-23 Thread Brian Winkers
It seems that dbmail -smtp is failing to set the owner_idnr correctly. (logs below) The first query: [SELECT user_idnr FROM users WHERE userid='[EMAIL PROTECTED]'] should get the correct userid, since I do when logged into mysql as dbmail user. mysql> SELECT user_idnr FROM users WHER

[Dbmail] RE: debian update - Problems with owner_idnr being set to zero causes Foriegn Key problems

2004-02-23 Thread Brian Winkers
It seems that dbmail -smtp is failing to set the owner_idnr correctly. (logs below) The first query: [SELECT user_idnr FROM users WHERE userid='[EMAIL PROTECTED]'] should get the correct userid, since I do when logged into mysql as dbmail user. mysql> SELECT user_idnr FROM users WHERE

Re: [Dbmail] RE: debian update - Problems with owner_idnr being set to zero causes Foriegn Key problems

2004-02-23 Thread Brian Winkers
You're correct in that I have no dbmail-delivery-user (0). Do I just add this manually? I'm assuming I only need the record in the users table. Does the data in any of the other fields matter? Thanks, Brian Winkers Roel Rozendaal - IC&S wrote: Hi Brian, What version a

Re: [Dbmail] RE: debian update - Problems with owner_idnr being set to zero causes Foriegn Key problems

2004-02-23 Thread Brian Winkers
I tried the below and it did get things working. It doesn't appear any of the other data matters. You just need an entry in the users table with a user_idnr=0. Thanks for your help. Brian Winkers wrote: You're correct in that I have no dbmail-delivery-user (0). Do I just add thi

Re: [Dbmail] basics please

2004-02-24 Thread Brian Winkers
Mysql table to provide transport info (based on "most" Postfix Mysql howtos) Then the "domain" field would be: yourdomain.com The transport field would be: dbmail: Forgetting to add the colon, ":", after the transport mechanism will cause failure. Brian Winkers [

Re: [Dbmail] basics please

2004-02-24 Thread Brian Winkers
tion this because it was counter intuitive for me to have what I considered my POP and IMAP server managing aliases. Brian Winkers [EMAIL PROTECTED] http://www.ultri.com Jan-Kees Fels wrote: Hello, Can someone tell me where I can find some basics regarding the setup of postfix and dbmail

[Dbmail] RE: debian update - Problems with IMAP, POP working

2004-02-24 Thread Brian Winkers
OIN acl ON acl.mailbox_id = mbx.mailbox_idnr JOIN subscription sub ON sub.user_id = '3' AND sub.mailbox_id = mbx.mailbox_idnr WHERE mbx.owner_idnr = '3' OR (acl.user_id = '3' AND acl.lookup_flag = '1') GROUP BY mbx.name, mbx.mailbox_idnr, mbx.owner_idnr 887 Query SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM mailboxes mbx LEFT JOIN acl ON mbx.mailbox_idnr = acl.mailbox_id WHERE (acl.user_id = '3' AND acl.lookup_flag = '1') OR mbx.owner_idnr = '3' 887 Query SELECT owner_idnr FROM mailboxes WHERE mailbox_idnr = '2' 887 Query SELECT name FROM mailboxes WHERE mailbox_idnr = '2' 892 Connect [EMAIL PROTECTED] on dbmail Brian Winkers [EMAIL PROTECTED] http://www.ultri.com

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

2004-02-25 Thread Brian Winkers
The following were left out of the dbmail.conf (fill in whatever for the ?'s) [POP] MINSPARECHILDREN = ? MAXSPARECHILDREN = ? [IMAP] MINSPARECHILDREN = ? MAXSPARECHILDREN = ? MAXCHILDREN = ? I also had to change the dbmail database users table to have a user called: [EMAIL PROTECTED]@__

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

2004-02-25 Thread Brian Winkers
in CVS. I'm preparing new packages... As soon as dbmail's CVS server comes back online I'll update and upload. Brian Winkers wrote: The following were left out of the dbmail.conf (fill in whatever for the ?'s) [POP] MINSPARECHILDREN = ? MAXSPARECHILDREN = ? [IMAP] MIN

Re: [Dbmail] RE: debian update - Problems with IMAP, POP working

2004-02-25 Thread Brian Winkers
I was the experimental Debian package from debian.nfgd.net. The newest package fixed it. Brian Winkers Ilja Booij wrote: which version of dbmail are you using? Ilja Brian Winkers wrote: It bombs out after the query below. The query runs just fine. Any suggestions? The problem appears to

Re: [Dbmail] Dbmail quota in version 2.0

2004-03-07 Thread Brian Winkers
intrinsic part of mail services. I would think a third party app would almost always provide more options. Brian Winkers [EMAIL PROTECTED] http://www.ultri.com Jacques Beaudoin wrote: Want im trying to say is that i would like to have the option not to impose any quota restriction for my users rec

Re: [Dbmail] GECOS field? (was Is there a nead for a users description table)

2004-05-15 Thread Brian Winkers
al_id would also go in users so the two tables would be related. Just a thought. Brian Winkers Ultri Jacques Beaudoin wrote: From a preceding quote " The Important Bit: " " DBMail currently has absolutely no mechanism to record the name of a " " user. While the I

Re: [Dbmail] Exim 4 Delivery + DBMail

2004-07-26 Thread Brian Winkers
educe the bandwidth used and the CPU cycles used on your end. Especially if your virus and spam scanning the messages. This can make a HUGE difference if the percentage of spam mails intended for non-existant users is high. Brian Winkers Ultri Hereward Cooper wrote: Hey guys, I'm in the pr

Re: [Dbmail] Mail forwarding question

2004-08-06 Thread Brian Winkers
[EMAIL PROTECTED] wrote: Hello. I would like to know if it's possible to setup dbmail so it can delivery mail to a user account as well as forward mail that comes into that user account to an external email address. I am using postfix with MailScanner ( Spam Assassin and ClamAV ) and dbmai

Re: [Dbmail] Mail forwarding question

2004-08-06 Thread Brian Winkers
ount? Can I set up the alias to point back to itself? I.E. an alias for [EMAIL PROTECTED] goes to "[EMAIL PROTECTED],[EMAIL PROTECTED]"? Thanks. Brian Winkers <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/06/2004 09:17 AM Please respond to DBMail mailinglist

Re: [Dbmail] Postfix

2004-11-26 Thread Brian Winkers
There are numerous valid ways to config Postfix for use with Dbmail. It might be easier for you to post your Postfix conf file and someone should eb able to spot whats wrong. Brian Armando Meeuwenoord wrote: Can anyone post here a working postfix configuration. becaus i have everything try

Re: [Dbmail] Postfix

2004-11-26 Thread Brian Winkers
richt- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Brian Winkers Verzonden: vrijdag 26 november 2004 19:50 Aan: [EMAIL PROTECTED]; DBMail mailinglist Onderwerp: Re: [Dbmail] Postfix There are numerous valid ways to config Postfix for use with Dbmail. It might be easier for you to post