[Dbmail] CVS compile problems on RH8

same deal with gcc296 and 3.2. Its almost like there's a file missing somewhere. Here is what I get: ock.c gcc296 -g -O2 -o dbmail-smtp -lmysqlclient list.o debug.o dbmd5.o md5.o mime.o main.o pipe.o bounce.o forward.o memblock.o mysql/libmysqldbmail.a main.o: In function `main': /root/dbmail

Re: [Dbmail] CVS compile problems on RH8

he config.c was there. I didn't have the right path to my mysql.h file. I was tired the other night when I did this. I've got to learn to do this stuff in the mornings when I have concentration. :-) Thanks for your help. Curtis Ryan Butler said: > On Wed, 2003-02-05 at 19:52, C

Re: [Dbmail] Performance Issues

MySQL will try its level best to move the indexes into RAM and will keep as much of them there as possible. It will try to move the tables there as well, if it can. If your database is over 64 MB, you're in trouble. I don't know how many users you have or how big your mail spool is, but if you'

RE: [Dbmail] dbmail setup

** [smtp] Error 1 > > > > > > Can anybody provide help here ? > > I'm using Debian 3.0r1 btw! > > > > > > > > Kind Regards, > > > > Markus > > > > > > ___ > > Dbmail mailing list > > Dbmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > -- End Original Message -- > > > -- > Jesse Norell > [EMAIL PROTECTED] > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: Re: [Dbmail] dbmail setup

h as large ? > > > > Kind Regards, > > Markus > > _______ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: [Dbmail] smtp-auth, pop before smtp / qmail + dbmail + postgresql

> > On the other hand, i try to create in my postgresql, how indicate in > > manual, a table caled pbsp, and i put "yes" in the /etc/dbmail.conf, > > hoping that dbmail-pop3d or dbmail-imap add to this table "IP" for the > > last consult of user's, but nothing.. > > > > Anyboy work dbmail + qmail + postgresl, or some light about this??? > > > > thank's for all... > > > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: [Dbmail] ;-(

ears you are missing the > development libraries or they aren't in your linker's path > > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: [Dbmail] autoconf update [PATCH]

ql auth > >system with them. Maybe one of those would be better suited to what > >yoour goal is. (Its what I ran previous to switching to dbmail) > > > > > > > > ___ > Dbmail mailing list > Dbmail@db

Re: [Dbmail] autoconf update [PATCH]

other RDBMS at the backend will have much better scaleability over the Exchange server. Curtis On Tue, 18 Mar 2003, Blake wrote: > Oh man, I think I'm going to be sick! > > Curtis Maurand wrote: > > >Sounds like an Exchange Server. :-) > > >

Re: [Dbmail] exchange and dbmail

_ > > Dbmail mailing list > > Dbmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > ___________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: [Dbmail] exchange and dbmail

__ > > STOP MORE SPAM with the new MSN 8 and get 2 months FREE* > > http://join.msn.com/?page=features/junkmail > > > > ___ > > Dbmail mailing list > > Dbmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

RE: [Dbmail] DBmail v1.1 takes 90% CPU - SOLUTION

Those are old numbers using MySQL 3.23.39. PCWorld did a test recently against a lot of products including Oracle 9i. The only database that came close Oracle's performance (and they were testing an alpha version of mysql) was MySQL. Curtis Jan Pavlík said: > No flame, and read :)) > > http://w

Re: [Dbmail] DBmail v1.1 takes 90% CPU - SOLUTION

best see for yourself. > http://www.google.com/search?q=postgres+vs+mysql&btnG=Google+Search > > > > > cheers > > > > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: [Dbmail] Message to multiple users

Better yet, simply store a pointers to the message blocks if there are multiple copies of a message on the server. This is one of the drawbacks of MS Exchange Server. It stores muliple copies of everything rather than pointers to the blocks and attachments. Worse the end user can't delete their

Re: [Dbmail] Shared folders

That will be half the battle of providing exchange functionality, too since an exchange server is really nothing more than a big imap server. calendar events are messages in the standard format that ical uses which is an ietf format the mail headers look like X.500 stuff. the address book looks li

Re: [Dbmail] Query on Database Stability in DB Mail

Let us not forget that the really highend email systems such as Openwave Email Kx uses Oracle (AT&T Broadband, RoadRunner, Bell Canada and a host of other very large systems use the Openwave product), Microsofts highend smtp product uses MSSQL server, Novell's highend system (which outperforms m

Re: [Dbmail] Query on Database Stability in DB Mail

of features (of which > Sendmail has too many in my opinion). There are still a few gotchas with > DBMail, but I've logged all of mine in the bug tracking database and > hope to learn a bit more about DBMail's structure with a view to fixing > them. > > Regardless, o

Re: [Dbmail] Query on Database Stability in DB Mail

to that upon request from the copyright holders. Curtis On Wednesday 23 April 2003 14:27, Joby Walker wrote: > Curtis Maurand wrote: > > Novell can't distribute PostgreSQL as part of the Netware distribution. > > That would be a violation of the BSD license. However, they&#x

Re: [Dbmail] Query on Database Stability in DB Mail

ur modifications, while with a > BSD license you can keep those proprietary. > > > > BTW, MySQL is dual licensed. It is available via GPL and for a price > under a private license. > > jbw > > Curtis Maurand wrote: > > from the postgresql website: >

Re: [Dbmail] schema dump

It would seem to me that you'll want that field to be binary as well. Usually when I store passwords, they're stored as small blobs. Curtis Jesse Norell said: > > Hello, > >> CREATE TABLE users ( >> user_idnr bigint(21) NOT NULL auto_increment, >> userid varchar(100) NOT NULL default '', >>

Re: [Dbmail] SMTP server for dbmail

this is interesting, but you might talk to some other folks that already have projects out there. The first ones that comes to mind would be zmailer or exim. zmailer is smtp only and supposed to be very fast. I'm not sure you should be trying to reinvent the wheel. However, any smtp implementa

Re: [Dbmail] PHP interface to dbmail

rting sendmail/postfix. It all depends on how much I can figure > > >>>> > > >>>> > > >>>out. :) > > >>> > > >>> > > >>>>Hopefully, some of you will be interested. If you have any code you > > >>>> > > >>>> > > >>>would > > >>> > > >>> > > >>>>like to contribute to the project or any requests for features, I would > > >>>> > > >>>> > > >>>be > > >>> > > >>> > > >>>>happy to hear from you. > > >>>> > > >>>>Thanks! > > >>>> > > >>>>- Ken > > >>>> > > >>>>__ > > >>>>Do you Yahoo!? > > >>>>The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com > > >>>>___ > > >>>>Dbmail mailing list > > >>>>Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>>> > > >>>>___ > > >>>>Dbmail mailing list > > >>>>Dbmail@dbmail.org > > >>>>https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>>> > > >>>> > > >>>> > > >>>> > > >>>> > > >>>___ > > >>>Dbmail mailing list > > >>>Dbmail@dbmail.org > > >>>https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>> > > >>> > > >>___ > > >>Dbmail mailing list > > >>Dbmail@dbmail.org > > >>https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >> > > >> > > >> > > > > > > > > > > > > > > > > > > ___ > > Dbmail mailing list > > Dbmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

RE: [Dbmail] PHP interface to dbmail

> Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: [Dbmail] messages not getting stored in the dbmail database

I'm not a postfix expert. Is there a "howto" or a set of sample configs out there to help one set up postfix with dbmail and spamassassin/razor and anti-virus? There's absolutely nothing on the website. Curtis On Tuesday 10 June 2003 20:16, Kenneth Oncinian wrote: > On Wednesday 11 June 2003

Re: [Dbmail] messages not getting stored in the dbmail database

Thank you muchly. I'll check it out. I was just getting a test machine together. Curtis On Wed, 11 Jun 2003, lou wrote: > In some email I received from Curtis Maurand <[EMAIL PROTECTED]> on Wed, 11 > Jun 2003 > 08:20:25 -0400, wrote: > > > > > I'm

RE: [Dbmail] diff between 1.x and 2.x and other questions

You have a syntax error in your SQL statement below, it should read "SELECT max(people.version) AS Lastversion, addr.name FROM people, addr REGHT JOIN addr ON people.ID = addr.ID GROUP BY "add.name;" You have to call out both tables in your SQL statement. Then it might work. Curtis Chris Cart

Re: [Dbmail] Many pop3 daemons ?

to enlighten me here ? > > Regards > - > Marc Hultquist > ComputerKit Systems (Pty) Ltd > Network Administrator > http://www.cks.co.za > (E-Mail) [EMAIL PROTECTED] > (Cell) +27 (0)82 5495467 > Personal Site: http://www.aftermatch.net -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

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

07:19 trinity postfix/pipe[21459]: > 70C76AB5B5: to=<[EMAIL PROTECTED]>, relay=dbmail, > delay=1, status=sent (echopc.com) > > > What am I doing wrong? The user exists and dbmail > seems to find the userid on the first SQL query, but > then fails at the end. Any help would be greatly > appreciate it. > > Thanks, > David > > > __ > Do you Yahoo!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re[2]: [Dbmail] Postfix with IMAP

compiled Postfix with SQL support. > That's easily enough done for MySQL, but you need to hunt down the > latest patches to use PostGres. > > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: [Dbmail] Webmail client + custom user table

__ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

Re: [Dbmail] basics please

really would like to use dbmail as a mailserver. I already have experience > running other mailservers and mysql experience. > > > > Everywhere where I read about postfix I read how great it is but nowhere it > seems to explain in human readable form how to set it up. >

Re: SV: [Dbmail] basics please

gt; > I really would like to use dbmail as a mailserver. I already have experience > running other mailservers and mysql experience. > > > > Everywhere where I read about postfix I read how great it is but nowhere it > seems to explain in human readable form how

RE: [Dbmail] CAP domain results in "no such user" mail bounce

an/listinfo/dbmail > > _______ > > Dbmail mailing list > > Dbmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

RE: [Dbmail] CAP domain results in "no such user" mail bounce

___ > >>Do you Yahoo!? > >>Yahoo! Mail SpamGuard - Read only the mail you want. > >>http://antispam.yahoo.com/tools > >>___ > >>Dbmail mailing list > >>Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbm

Re: [Dbmail] CAP domain results in "no such user" mail bounce

ange Server (I only use it as an example, I'm not endorsing it.) doesn't care on the username side. Curtis On Wed, 3 Mar 2004, Ilja Booij wrote: > I've changed it to be case-insensitive in the case of name (username, > alias). As far as I see, there's no disagreement be

RE: [Dbmail] CAP domain results in "no such user" mail bounce

t > > >>> > > >>> > > >>> > > >>> > > >>>>>> will bounced the mail with "so such user". Has this comparison > > >>>>>> always > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>>> been case sensitive? For example, if [EMAIL PROTECTED] is in the > > >>>>>> aliases > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>>> table and then I get a mail address to [EMAIL PROTECTED], > > dbmail rejects > > >>> > > >>> > > >>> > > >>> > > >>>>>> it. Actually it will reject anything not spelled exactly as > > >>>>>> "example.com". This is the error message generated. > > >>>>>> > > >>>>>> dbmail/smtp[31935]: bounce.c,bounce: sending 'no such user' bounce > > >>>>>> for > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>>> destination [EMAIL PROTECTED] > > >>>>>> > > >>>>>> Is this a postfix problem, PostgreSQL problem, or a dbmail problem? > > >>>>>> > > >>>>>> __ > > >>>>>> Do you Yahoo!? > > >>>>>> Yahoo! Mail SpamGuard - Read only the mail you want. > > >>>>>> http://antispam.yahoo.com/tools > > >>>>>> ___ > > >>>>>> Dbmail mailing list > > >>>>>> Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>>>>> ___ > > >>>>>> Dbmail mailing list > > >>>>>> Dbmail@dbmail.org > > >>>>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>>>> > > >>>>> > > >>>>> > > >>>>> ___ > > >>>>> Dbmail mailing list > > >>>>> Dbmail@dbmail.org > > >>>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>>>> > > >>>>> > > >>>>> ___ > > >>>>> Dbmail mailing list > > >>>>> Dbmail@dbmail.org > > >>>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>>> > > >>>> > > >>>> > > >>>> ___ > > >>>> Dbmail mailing list > > >>>> Dbmail@dbmail.org > > >>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>>> > > >>>> > > >>>> ___ > > >>>> Dbmail mailing list > > >>>> Dbmail@dbmail.org > > >>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>> > > >>> > > >>> > > >>> ___ > > >>> Dbmail mailing list > > >>> Dbmail@dbmail.org > > >>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >>> > > >>> > > >>> ___ > > >>> Dbmail mailing list > > >>> Dbmail@dbmail.org > > >>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >> > > >> > > >> ___ > > >> Dbmail mailing list > > >> Dbmail@dbmail.org > > >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > ___ > > > Dbmail mailing list > > > Dbmail@dbmail.org > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > ___ > > Dbmail mailing list > > Dbmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > ___ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com

RE: [Dbmail] CAP domain results in "no such user" mail bounce

tally irrelevent to the discussion. Making MySQL treat domain > names as case-sensitive doesn't help when domain names are case-insensitive. > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf > > Of Curtis Maurand > > Sent:

RE: [Dbmail] CAP domain results in "no such user" mail bounce

never espoused those solutions since they have > the same problems as yours does regarding the points I'm trying to address. > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf > > Of Curtis Maurand > > Sent: Thu

Re: [Dbmail] Is there a nead for a users description table

I put all of this in the front-end management system. The dbmail tables are part of that as are the powerdns tables and virtual webserver information. Curtis -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Thu, 13 May 2004, Feargal Reilly wrote: On Thu, 13 May 2004

Re: [Dbmail] Deleting mails

I've taken to running it twice. Works well. Curtis -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Sat, 22 May 2004, Robert Andersson wrote: Leonel Nunez wrote: I've sent one message all flags are 0 status is 2 after I check the mail and get it from the

Re: [Dbmail] Server wide addresses

dbmail-adduser a postmaster D5 password 0 0 [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED], ad infinitim That's about the only way that I can see to do it. Curtis -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Tue, 15 Jun 2004, Robert Andersson wrote:

Re: [Dbmail] Platform Recomendations

I've been running on gentoo with a 2.6 kernel. It rocks. Curtis -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Sun, 20 Jun 2004 [EMAIL PROTECTED] wrote: Is there a preferred version of Linux to run dbmail on? My first choice was Red Hat until they went commercia

Re: [Dbmail] how important is postfix + postgresql?

thing like: dbmail-adduser a [EMAIL PROTECTED] secret 0 0 [EMAIL PROTECTED] [EMAIL PROTECTED] Will things work properly with that kind of setup. That setup allows me to unique logins for each domain hosted on the server. Thanks in advance, Curtis -- Curtis Maurand mailto:[EMAIL PROTE

Re: [Dbmail] how important is postfix + postgresql?

But I was looking to check against the dbmail interface. I have the login names as their email addresses, will the local recipient maps be broken, then? Curtis -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Fri, 16 Jul 2004, Leander Koornneef wrote: Hi, On 15-jul

Re: [Dbmail] how important is postfix + postgresql?

] by entering users in such a way, will it break the recipient maps feature in postfix? Curtis Leander Koornneef, IC&S wrote: I'm not sure what you mean and/or what you want to do exactly. Could you elaborate? regards, Leander On 19-jul-04, at 21:53, Curtis Maurand wrote:

[Dbmail] query problems

Hello, I have a domain on a server thats authoritative for it. I have the following records mysql> select * from domains where name = 'standre.org'; ++-++++-+-+ | id | name| master | last_check | type | notified_seri

[Dbmail] sorry wrong list

Hi, Sorry. I posted my last message to the wrong list. Its been a very long weekend. dbmail is working fine on the same box. amavisd-new keeps crashing, but hey. Curtis

Re: [Dbmail] mass add of users to dbmail with postgresql

Export your mail table as some sort of delimited file. I would suggest tab delimited. Write a perl script that opens the file, splits the line into the various elements and then executes dbmail-user for each user. Example: #!/usr/bin/perl open (INFILE, ") { ($username,$password,$email_

[Dbmail] md5-hash vs md5-digest

I'm in the process of writing a script that converts Linux passwd/shadow file into dbmail-users. The passwords are encrypted, but I don't know the difference between md5-hash-raw and md5-digest-raw. does anyone here know? Curtis

[Dbmail] importing usernames and passwords

Hello, I'm trying to import system accounts from one machine to another. Passwords that were encrypted using the LInux crypt function import fine by inserting them directly into the database and setting the password encryption to crypt . However, passwords that were encrypted using md5-hash

Re: [Dbmail] importing usernames and passwords

with the transfer, DbMail will read it as md5 digest and look for the random seed to decrypt. In short, if your truly mean md5 hash, a one-way hash algorithm defined by RFC1321, then md5sum is what should be in the database as encrypt type. Mike - Original Message - From: "Curt

Re: [Dbmail] md5-hash vs md5-digest

Thank you, you were correct. It was a digest. Curtis Paul J Stevens wrote: IIRC, the digest version of md5 uses a salt string very much like crypt does. So if your hash looks like $$xxx$ you're dealing with a digest. Curtis Maurand wrote: I'm in the process of

Re: [Dbmail] Still having "user unknown messages"

Postfix is giving you the errors because there are no local usernames or addresses on the system. After all, they're part of a database. To that end, you need to tell dbmail where to find them. I use the following and it works well. In /etc/postfix/main.cf use the following: local_recipie

Re: [Dbmail] Dbmail 2 and postfix

in your main.cf local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf the contents of sql-recipients.cf look like: # For the local transport map. user=dbmail password= hosts= dbname=dbmail table=dbmail_aliases select_field=alias where_field=alias # end sql-recipients.cf Matt Salerno wro

Re: [Dbmail] Dbmail 2 and postfix

I'm using it with 2.1.5, but I started this whole thing with 2.0.n Curtis Matthew T. O'Connor wrote: > Curtis Maurand wrote: > >> in your main.cf >> >> local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf >> >> the contents of sql-recipients

Re: [Dbmail] DbMail in a ISP Cluster

I would hope that you can get better performance than that. I ran an ISP that handled over 6,000 messages per day which is nothing for a moderate ISP. figure at least 10 messages per day (including spam) per user. If you've got 3500 users that's 35,000 messages. (35,000 / 24 = 1458.33 per hour

Re: [Dbmail] Question about Virtual Domains

Yes, it does work. I do it now. dbmail has a field for client id. each user has an alias, but all of my users have a user name of their email address and an alias that is also their email address, you can set up multiple email addresses for each customer. I'm using postfix/dbmail/amavisd-ne

Re: [Dbmail] Question about Virtual Domains

| Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/ -----Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:36 PM To: DBMail mailinglist Subject: Re: [Dbmail] Question about Virtual Domains Yes, it does work. I do i

Re: usermaps (was Re: [Dbmail] Question about Virtual Domains)

massassin settings and linking it to the users table. Amavisd-new has provisions for writing a custom query to get the information from a preferences table. Curtis Maurand Maine Line Systems Biddeford, ME Paul J Stevens wrote: On a different note: I've ported Jesse Norell's userma

Re: [Dbmail] Help to install dbmail

I get the same thing. Gentoo 2005.0. glibc-2.3.4.20041102 is what I have installed. Curtis Shahrizal Muhamad Kasim wrote: Hi, I received the following error when try to install dbmail. I'm at no. 3 of the INSTALL file documentation. I managed to run the 'configure --with-mysql' but error

Re: [Dbmail] Help to install dbmail

that's a new requirement. I didn't notice that in the docs, but then again I may have missed it. I never needed glib before. You might note that in the "what's new," section. Curtis Paul J Stevens wrote: Curtis Maurand wrote: I get the same thin

Re: [Dbmail] Help to install dbmail

and make. Curtis Curtis Paul J Stevens wrote: Curtis Maurand wrote: I get the same thing. Gentoo 2005.0. glibc-2.3.4.20041102 is what I have installed. glibc is not glib. For 2.1 you need glib-2.4 or better (glib-2.2 may actually suffice), as well as gmime-2.1.14 or better.

Re: [Dbmail] DBMail with Postfix is driving me nuts!

Then all you need to do is handle it in the alias table. You're talking about a management issue. under aliases user_idnr alias 1[EMAIL PROTECTED] 1[EMAIL PROTECTED] 1[EMAIL PROTECTED] Curtis Danil V. Gerun wrote: > >>

[Dbmail] smtp authentication

Hi, Is it possible to configure postfix to use dbmail's database for smtp authentication? I'm having a problem with evolution trying to do pop before smtp since I'm using IMAP. While I have imap configured and imap before smtp, evolution doesn't understand it and i get an error that states I'm

Re: [Dbmail] smtp authentication

the select statement which allows >you to use any table you like. > >-- >David A. Niblett | email: [EMAIL PROTECTED] >Network Administrator | Phone: (352) 334-3400 >Gainesville Regional Utilities | Web: http://www.gru.net/ > > > >-Original Messa

Re: [Dbmail] How to compile php with dbmail-imapd support

there is one outside dependency. You'll need the c-client (University of Washington) library to compile php against. * *ftp://ftp.cac.washington.edu/mail/imap.tar.Z * *ftp://ftp.cac.washington.edu/mail/imap-utils.tar.Z Curtis Micah wrote: db

Re: [Dbmail] import md5

there are different password types. I had this discussion once and I found that using simply: dbmail-users -a test -p md5 -P /etc/passwd ... works. I also have a perl script that will rip through a passwd and shadow file. I won't cover multiple domains. Only one domain at a time. Curti

Re: [Dbmail] Questions

The user_idnr is an auto-increment number. The database assigns that integer automatically. Then you use that number to create the rest of what you need. I had a perl script at one point to do this which would give you the queries that you needed. Most of them are pretty well documented though

Re: [Dbmail] Questions

e information than you wanted? Curtis zamri wrote: > On 1/28/06, Curtis Maurand <[EMAIL PROTECTED]> wrote: >> >> >> The user_idnr is an auto-increment number. The database assigns that >> integer automatically. Then you use that number to create the rest of >&

Re: [Dbmail] Which util switch does the OPTIMIZE?

If your not careful and you don't run mysqloptimize -o -u -p against the innodb database on a regular basis, your database will grow to an unwieldy size. However, the database will be locked while you do this. At one point, I ran out of disk space. I ended up having to dump all of the databas

Re: [Dbmail] Which util switch does the OPTIMIZE?

urtis Ming-Wei Shih wrote: I had the same problem, since then I switched to postgresql with the compression on the text table, it's actually speedier than mysql+innodb Ming-Wei Curtis Maurand wrote: If your not careful and you don't run mysqloptimize -o -u -p against the innodb da

[Dbmail] Moving from one database to another

. I had meant for the machine its currently on (Celeron 1GHz) to be a testing and development platform. Its become a workhorse and is just not up to it. Thanks in advance, Curtis Maurand

Re: [Dbmail] Moving from one database to another

6243 BE Geulle The Netherlands Tel. +31.43.3655190 Op 5-jun-2006, om 4:40 heeft Curtis Maurand het volgende geschreven: Hello, I need to migrate all users and messages from one dbmail database to another. Is there a graceful way of doing this? I have a machine that needs to be deco

Re: [Dbmail] Moving from one database to another

Time to get busy on a script, methinks. I'll se what I can do. This should be able to be done via perl and walking through the tables. lastinsertid() is my friend. I'll see what I can come up with. Curtis Paul J Stevens wrote: Curtis Maurand wrote: imap-copy has the

Re: [Dbmail] Webmail

I've used openwebmail, squirellmail and roundcube. I like roundcube. I started using a very early version. Now I need to upgrade it. I have multiple installations pointing to the same set of databases. The newer version doesn't like the older database. I need to migrate it to the newer one.

RE: [Dbmail] Multiple domains

I'm using 2.0. usernames are [EMAIL PROTECTED] aliases line up to [EMAIL PROTECTED] then any additional aliases. It works like a charm. that's for one share ip address. That patch that's being talked about is pretty slick and is for using multiple ip addresses. Curtis --

Re: [Dbmail] roundcube

I have it working. I'm not sure which version. Curtis -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Tue, 22 Aug 2006, Jorge Bastos wrote: Hi, does anyone have roundcube webmail working with dbmail? i downloaded the stable version on the website, "0.1beta

RE: [Dbmail] Postfix / Dbmailallow user to send emails outside mynetwork

I've setup the pop before smtp and it works pretty nicely. I'd be interested in solution 3 and 3a -- the port 587 thing. I have sasl with mysql support and, of course, postfix with mysql support. Curtis Niblett, David A wrote: > There are basically 3 ways to accomplish what you want, only > 2

RE: [Dbmail] Web Client for Multip Domins/Websites

-- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Tue, 19 Sep 2006, Niblett, David A wrote: We use the old trusty SquirrelMail with the Nutsmail skins and the vlogin plugin for our 3 domains. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator

[Dbmail] database optimization

Hello, I ran dbmail-util -a on the database today. All ran OK. After that I ran mysqloptimize against the database and lo and behold, the innodb file was larger by 1 GB than it was before I started. Anyone have any idea what's going on?

Re: [Dbmail] database optimization

Comment: InnoDB free: 6620160 kB innodb_data_file_path = ibdata1:10M:autoextend Curtis Leander Koornneef wrote: > > On 15-nov-2006, at 22:16, Curtis Maurand wrote: > >> Hello, >> I ran dbmail-util -a on the database today. All ran OK. After >> that I >&

Re: [Dbmail] database optimization

Thank you. I was more concerned with performance than i was with database size. Disks are cheap. The larger a file is, the longer it takes to query. Curtis Leander Koornneef wrote: > > On 15-nov-2006, at 23:53, Curtis Maurand wrote: > >> Leander Koornneef wrote: >>> &

Re: [Dbmail] Re: User administration of DBMail

I'm interested. Bernard Johnson wrote: > http://permalink.gmane.org/gmane.mail.imap.dbmail/6652 > > I only made modifications that work with MySQL though. > > Atet Sugiharto wrote: > >> I have 3 domain in my DBMail and every domain have it's own administrator >> person. I would like each person

Re: [Dbmail] Mailman integration in dbmail HOWTO

I just went to this link because I'm having trouble making mailman and dbmail work and the link is broken. The script on the wiki does not work. So if anyone could point me to a working example, that would be cool. Curtis Vital Gold wrote: Hi, I am new to dbmail and I missed a HOWTO for

Re: [Dbmail] Mailman integration in dbmail HOWTO

To Paul and Aaron, Thank you, that worked. I had to go find the postfix-to-mailman.py script (separate download). Now it works pretty well, but is there a way to handle virtual domains this way? It would seem to me that its a mailman config that I'm missing, now. the mailman documentation

Re: [Dbmail] MySQL Mirgration Scripts

I don't know if anyone else is having this trouble, but mysqldump for me does not dump the database in the correct order in order to load the tables back in. Usually I get failures for dependency issues (tables depending on other tables that haven't been created, yet.). I've found that I've

Re: [Dbmail] MySQL Mirgration Scripts

ns of mysqldump add this to the top of the dump file: SET FOREIGN_KEY_CHECKS = 0; and then at the end of the file: SET FOREIGN_KEY_CHECKS = 1; On Thu, 2007-03-29 at 10:02 -0500, Curtis Maurand wrote: I don't know if anyone else is having this trouble, but mysqldump for me does no

Re: [Dbmail] Configurations for performance

Josh wrote: That's what I'm thinking might be the best method. Just need to find some documentation on doing this for both MySQL and Postgres. One thing to be careful of is that if the slave is lagging behind the master and we have a failure, there will be some database changes missing, which

Re: [Dbmail] user info

Aleksander wrote: zamri wrote: I think to have more fields or tables for user information like name, address or anything would be nice. Then dbmail-users can be used to get the info from username with dbmail-users -l. What do u all think? If I'd want that, I would probably use LDAP. Althou

Re: [Dbmail] Configurations for performance

Can it? Point me to some docs and/or sample configs. If this can be made to work, then we really would have a single namespace horizontally scalable setup that we could recommend. look at the transport maps in postfix. In my configuration its transport_maps = hash:/etc/postfix/transports

Re: [Dbmail] DBmail webmail app

Aaron Stone wrote: On Wed, Jun 6, 2007, Tom Allison <[EMAIL PROTECTED]> said: On Jun 6, 2007, at 6:39 PM, Aaron Stone wrote: On Wed, Jun 6, 2007, Tom Allison <[EMAIL PROTECTED]> said: Jake Anderson wrote: If you have 4 accounts then you won't even notice it.

[Dbmail] dbmail-util problem

Ok, maybe I'm doing something wrong, but the help message isn't helping if I am. When I run dbmail-util against the database I get the following. Please note that I cannot purge the messages that have the "DELETE" status set. I need this to work as I'm preparing to upgrade to a more recent v

[Dbmail] [SOLVED] dmail-util

I solved it. kind of wierd having to run -dby in one run rather than -dy in one run and -py in the next. but dbmail-util -dpy worked. Curtis ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] problems

On a fairly small server where dbmail-util gets run on a nightly basis. mysql> SELECT count(id) FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages); +---+ | count(id) | +---+ | 30365 | +---+ 1 row in set (2.14 sec) mysql> SELECT cou

Re: R: [Dbmail] Table dbmail_messages is full

___ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______ > DBmail mailing list > DBmail@dbmail.org > https://mailm

Re: [Dbmail] Deleting an account

In the 2.0 series, dbma did not delete the mails correctly. I sent a couple of queries out to the list a 2 or 3 weeks ago that will delete mail in the 2.0 series not connected to anyone. I'm working on a conversion for my system to 2.2. It hasn't happened, yet. Curtis zamri wrote: On

Re: [Dbmail] POP_BEFORE_SMTP

Its in the docs, but here is my setup. in main.cf mynetworks = 66.152.196.64/27,127.0.0.0/8,mysql:/etc/postfix/my_net.cf smtpd_client_restrictions = permit_mynetworks, reject /etc/postfix/mynet.cf user= password= dbname= hosts = table = dbmail_pbsp select_field = since where_field = ipnum

Re: [Dbmail] POP_BEFORE_SMTP

;> Charles >> ___ >> DBmail mailing list >> DBmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > ___ > DBmail mailing list > DBmail@dbmail.

Re: [Dbmail] POP_BEFORE_SMTP

e. > but right now, the packages that i have installed on my server are broken > for *sql usage and i'm using sasldb mode until that is fixed. > IF you want i can give my configurations > - Original Message - > From: Curtis Maurand > To: DBMail mailinglist &g

Re: [Dbmail] POP_BEFORE_SMTP

Ok, lets see the configs. Curtis Michael Monnerie wrote: > On Donnerstag, 30. August 2007 Curtis Maurand wrote: >> I'd love to see working instructions for smtp auth. I'd rather use >> that and change my 40 or 50 users over to that. > > I use a very simp

  1   2   >