RE: [Dbmail] optimisations under 1.2.8b / mysql

2004-07-06 Thread Simon Gray
> What are the hardware specifications of you dbmail server ? > How many users do you have ? > How many email do you process each day ? We're using dbmail as the backend storage for our service and haven't as yet place in to production. Hardware just an old twin intel pII. Would like to go towar

RE: Re[2]: [Dbmail] Platform Recomendations

2004-07-06 Thread Simon Gray
> > We run all of the above (apart from procmail, why would you need it? ... > > I am hoping to do filtering to folders somehow with it. I didn't mention > I'll probably run amavis-new with clam-av and spamassassin. So if > nothing else I will want to filter on the X-spam headers. Interesting, we

[Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Tomek Jarzynka
Hi, I thought DBmail is SQL-based, and so, that the userlist is stored entirely in the database. To my dismay, I could not add a working e-mail address to the base using solely SQL queries. Do I really have to use the dbmail-adduser command? Or have I done something wrong? What is the correct comm

SV: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Mikael Syska
Hi. > -Oprindelig meddelelse- > Fra: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] På vegne af Tomek Jarzynka > Sendt: 6. juli 2004 12:07 > Til: dbmail@dbmail.org > Emne: [Dbmail] How to manage users with SQL queries? > > Hi, > > I thought DBmail is SQL-based, and so, that the userlist

Re: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Ilja Booij
Tomek Jarzynka wrote: Hi, I thought DBmail is SQL-based, and so, that the userlist is stored entirely in the database. To my dismay, I could not add a working e-mail address to the base using solely SQL queries. Do I really have to use the dbmail-adduser command? Or have I done something wrong?

Re: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Tomek Jarzynka
On Tuesday 06 of July 2004 13:02, Ilja Booij wrote: > There are man-pages. What's wrong with them? The names of them being... ? -- tomasz k. jarzynka / 601 706 601 / tomee(a-t)kadu(d-o-t)net "My software never has bugs. It just develops random features."

Re: SV: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Tomek Jarzynka
On Tuesday 06 of July 2004 12:16, Mikael Syska wrote: > Read the INSTALL guide in the tar.gz file, its all described there how to > add users with thte dbmail-adduser. The trouble is I don't want to use dbmail-adduser, but direct queries. But I'll have a look at the file, maybe there's an explanat

Re: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Ilja Booij
Tomek Jarzynka wrote: On Tuesday 06 of July 2004 13:02, Ilja Booij wrote: There are man-pages. What's wrong with them? The names of them being... ? man dbmail-adduser man dbmail-maintenance man dbmail-smtp man dbmail-imapd man dbmail-pop3d Ilja -- Ilja Booij IC&S B.V. Stadhou

RE: SV: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Simon Gray
> The trouble is I don't want to use dbmail-adduser, but > direct queries. But I'll have a look at the file, maybe there's > an explanation there. We just used the dbmail-src/mysql/dbmysql.c file and striped the queries out works fine, it's all quite straight forward. Simon

Re: SV: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Tomek Jarzynka
On Tuesday 06 of July 2004 13:47, Simon Gray wrote: > > The trouble is I don't want to use dbmail-adduser, but > > direct queries. But I'll have a look at the file, maybe there's > > an explanation there. > We just used the dbmail-src/mysql/dbmysql.c file and striped the queries > out works fine, i

Re: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Leonel Nunez
On Tue, 2004-07-06 at 04:07, Tomek Jarzynka wrote: > Hi, > > I thought DBmail is SQL-based, and so, that the userlist is > stored entirely in the database. To my dismay, I could not > add a working e-mail address to the base using solely SQL > queries. Do I really have to use the dbmail-adduser co

[Dbmail] Postfix <> amavis <> procmail <> dbmail (email to either inbox or junk based on spamassassin results)

2004-07-06 Thread Simon Gray
> Interesting, we run a similar setup with spamassassin and uvscan/clam-av > but currently only append ***SPAM*** to the subject forwarding email to > a separate dbmail folder if spam would be handy - I'll have a bash at > getting that working. (Although I've not done much with procmail) Right thi

Re: [Dbmail] DBMail Kills Squirrels!

2004-07-06 Thread Robert Andersson
James XMS wrote: > I then deleted the messages he wanted removed from his mailbox, but now > when he goes back into squirrelmail he gets the following error: > > ERROR : Could not complete request. > Unknown response from IMAP server: 1. > > And all of the messages are coming up mwith 'No Subject'

RE: [Dbmail] Postfix <> amavis <> procmail <> dbmail (email to eitherinbox or junk based on spamassassin results)

2004-07-06 Thread Simon Gray
Ignore previous email, it doesn't work :/ > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Simon Gray > Sent: 06 July 2004 14:36 > To: 'DBMail mailinglist' > Subject: [Dbmail] Postfix <> amavis <> procmail <> dbmail (email to > eitherinbox or junk bas

Re: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Tomek Jarzynka
On Tuesday 06 of July 2004 14:35, Leonel Nunez wrote: > What I did is > > Add user to the users table > add alias to the aliases table > add a mailbox to the mailboxes table INSERT INTO users VALUES (1,'[EMAIL PROTECTED]@__','',0,0,0,'md5','1979-11-03 22:05:58',NULL); INSERT INTO users VALUES (

RE: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Simon Gray
> And it just doesn't work. The user gets no mail from sendmail. > > By the way, sendmail sends out a whole lot of logs, among others: > Jul 6 17:11:03 daimonion dbmail/lmtpd[2515]: dbmysql.c,db_query: > executing > query [SELECT deliver_to FROM aliases WHERE lower(alias) = > lower('@arista.ath.c

Re: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Leonel Nunez
On Tue, 2004-07-06 at 09:16, Tomek Jarzynka wrote: > On Tuesday 06 of July 2004 14:35, Leonel Nunez wrote: > > What I did is > > > > Add user to the users table > > add alias to the aliases table > > add a mailbox to the mailboxes table > > INSERT INTO users VALUES > (1,'[EMAIL PROTECTED]@__',''

Re: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Tomek Jarzynka
On Tuesday 06 of July 2004 17:34, Simon Gray wrote: > If you add a user with dbmail-adduser what results do you get? Proper. Can't trace any differences in the users, aliases and mailboxes tables either. Other than the last login stuff etc. which should be insignificant. -- tomasz k. jarzynka / 6

RE: [Dbmail] optimisations under 1.2.8b / mysql

2004-07-06 Thread Jacques Beaudoin
I have 1800 users receiving over 7000 emails each day Im running dbmail 1.2.8b My server is a dell dual xeon hypertreading 2.0 gigaherts I have 4 gigs of ram I have 4,40 gigs drives configure as raid 5 for linux mandrake 10.0 I have 4,40 gigs drives configure as raid 5 for the dbmail mysql dat

RE: [Dbmail] postfix gives User unknown in virtual alias table

2004-07-06 Thread Scott Johnson
Hi Jeff, In the end I found the problem. I tied to set-up postfix like this was a standard install. But that was my downfall. I had added the domain to the "virtual" file and to the postfix config file. That in it's self is bad. But is caused postfix to look for an alias of this virtual domain. On

Re: [Dbmail] How to manage users with SQL queries?

2004-07-06 Thread Jacques Beaudoin
My choice for administrating dbmail is using all the dbmail utilities that i run via webmin custum menu. I let dbmail-adduser do the work and execute it via webmin custom menus. My technician in charge of adding and deleting users never seas dbmail-addusers Bien à vous Jacques Beaudoin Agent d'a