Re: Dbfunctions patch - big changes.
had time to patch my version and use it. What would be really helpful is if you could write up some (uggg) documentation. A nice blurb about each of the new API functions, along with info on the new command line programs, finished off with a section on overall design. That would really help me use it and understand what you did ;] this ALREADY is in the distribution. check out the readme file. The only other thing would be how should we retrofit the non mysql modules. Maybe the best thing would be to leave the current cdb functionality in place and update the new API/command line programs to support the current .qmail file mechanism. What I'm looking to do is make the underlying implementation be transparent to the users of command line programs and to users of the API. We can just create "vaddalias, vaddforward and vaddcomand" commands and let them handle that stuff internaly so end users wont see anything. Kris
Re: e-mail
I know but I don't want to send the all contex of the email, just let know there is a new message for that address. - Original Message - From: "Ken Jones" [EMAIL PROTECTED] To: "celano e5net" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 9:31 AM Subject: Re: e-mail celano e5net wrote: Hi all I'm using qmail,vpopmail,sqwebmail etc.. is there a way, to advise me that I have received an e-mail for the account [EMAIL PROTECTED], into my other [EMAIL PROTECTED]? Thank you "advise you" hmm.. Perhaps send you a copy of the email. Ken Jones
Re: Best Practises for vpopmail scaling
Paul Tan wrote:I have qmail/vpopmail/etc running on a Sun 2.8 Server. and would like to scale it to 2 servers. I understand that most cost effective solution would to go for NFS. Are there any tips and tricks i should look out for when implementing vpopmail Maildirs via NFS? Am i supposed to share out ~/vpopmail/domains dir on the NFS server?? Or are there other ways of implementing it? Ken wrote: I've seen some NFS file locking problems with the vpasswd.cdb files.We put in alot of time trying to track it down, and I think we fixed it. But I'm not sure since we couldn't track down exactly what was happening. It was hard to reproduce since it was some kind of timing issue. MySQL removes the need to lock the vpasswd files. The only other files that need locking are the open-smtp file if youhave roaming-users enabled. I recommend CODA over NFS because it has support for disconnected operation, read/write server replication, secure authenticationa dn encryption, persistent client caches and write back caching. A quicked but less functional method would be using something like rsync or RDist. I would definitely use SQL over cdb. I have been through 1 awful setup that required mysql and roaming options, and i recommend against it. I wonder how does the "default-domain" or "large-sites" options affect performance is such setup/environment. I also just started looking at GFS and am thinking about a 3-system RAID/Fiber storage pool and 2 GFS clients for a test bed. This is quite interesting because I also just recently started playing with reiserfs and qmail queue fs. Performs faster than on ext2 on high load servers. fsck is also much faster than e2fsck. GFS not only supports Jounalling, but also recovery from client failures. One thing really pisses me off. GFS and Reiserfs are both only supported by linux. Sothat means no BSD. Linux 2.4.2 looks good and I run it on many Qmail/Vpop boxenwith QoS and CBQ to load balance compiled in. I am thinking also about LVS which looks very interesting (and cheaper than many other alternatives). Needless to mention, maildir is a must for this to work right. Let me know of any thoughts. Tim
Large site questions
I've installed vpopmail/sqwebmail/courier-imap/qmailadmin on a small system ( 200 users spread over ~40 domains) and it works like a champ and I love it. I'm working on a project for a large client, and I've got them willing to look at a qmail/vpopmail/sqwebmail/courier-imap/qmailadmin solution instead of outsourcing their e-mail, so I've got a couple of questions. They currently have ~1,000,000 (yes, 1 million) mail boxes and growing spread over ~30 domains. The biggest single domain has ~400,000 users/mailboxes. As new users get added, I have a feeling that the rebuilding the cdb file for authentication is just not going to be practical. Is MySQL with the --enable-large-site=y the best choice? Is anybody running qmail/vpopmail with ~400,000+ users/mailboxes? If you are, would you e-mail me privately with your platform (OS and hardware), and any loadbalancing you may be doing? TIA, Dave Weiner
Re: vpopmail with mySQL
Not only must the user exist in the database, they must also have a directory. Adding user directories yourself is bad. vpopmail has a directory structure it sticks it, and mucking with that can cause problems. So to everyone who tries to do vpopmail's job for it, do it at your own risk. Daniel Hardaker wrote: Ive been studying the code for vpopmail and cant answer my question from it...so I hope someone can shed some light on it for me. When addint a POP user to a domain, whyis it not enough to simply add their details into the relevant sql table? Ive tried to add a row into a domain table with the password, pw_dir and everythiong else, but when i telnet in as the user, or even vuserinfo user authorization fails and the user does not exist. What am i missing? Thanks PS anyone who has some statistics for how qmail/vpopmail handles large volumes of mail, especially with mysql id really like to see them to use in a college project im working on, graphs would be great too! --- www.iv2.co.uk -- [EMAIL PROTECTED] Inter7 Internet Technologies, Inc. www.inter7.com - 847-492-0470 New prices! http://www.inter7.com/prices.html
Re: Large site questions
Dave Weiner wrote: I've installed vpopmail/sqwebmail/courier-imap/qmailadmin on a small system ( 200 users spread over ~40 domains) and it works like a champ and I love it. I'm working on a project for a large client, and I've got them willing to look at a qmail/vpopmail/sqwebmail/courier-imap/qmailadmin solution instead of outsourcing their e-mail, so I've got a couple of questions. They currently have ~1,000,000 (yes, 1 million) mail boxes and growing spread over ~30 domains. The biggest single domain has ~400,000 users/mailboxes. As new users get added, I have a feeling that the rebuilding the cdb file for authentication is just not going to be practical. Is MySQL with the --enable-large-site=y the best choice? Is anybody running qmail/vpopmail with ~400,000+ users/mailboxes? If you are, would you e-mail me privately with your platform (OS and hardware), and any loadbalancing you may be doing? TIA, Dave Weiner I would definitly go for mysql over cdb format. What the large site option does is create a table per domain instead of one table with all domains in it. This has two trade offs 1. with large site = yes you will save the space for the domain name. For example: with a domain name = 20 characters and 400,000 users you will save 8Mega Bytes of storage space. Which is significant. 2. The draw back of large site = yes is that mysql uses a file descriptor per table. I think mysql normal keeps up to a maxium of 20 open tables. So if you have 20+ active domains, mysql will be opening and closing database table files, which will slow down performance. Ken Jones
Re: vpopmail with mySQL
Daniel Hardaker wrote: Ive been studying the code for vpopmail and cant answer my question from it...so I hope someone can shed some light on it for me. When addint a POP user to a domain, whyis it not enough to simply add their details into the relevant sql table? Ive tried to add a row into a domain table with the password, pw_dir and everythiong else, but when i telnet in as the user, or even vuserinfo user authorization fails and the user does not exist. What am i missing? You'll have to post your SQL insert string, the contents of the table, and the contents of the domain directory. And anything else that is involved ;] Ken Jones Thanks PS anyone who has some statistics for how qmail/vpopmail handles large volumes of mail, especially with mysql id really like to see them to use in a college project im working on, graphs would be great too! --- www.iv2.co.uk
Re: Auto create users maildir with vpopmail, mysql and sqwebmail
just asking again...haven;t asked in about 3 months i think does sqwebmail compile yet with freebsd with vpopmail .23.x mysql still have 50 people waiting. On Wed, 7 Mar 2001, Ken Jones wrote: Date: Wed, 07 Mar 2001 12:13:42 -0600 From: Ken Jones [EMAIL PROTECTED] To: Einar Bordewich [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Auto create users maildir with vpopmail, mysql and sqwebmail Einar Bordewich wrote: With the mysql support for vpopmail, you only need to insert the user info into the vpopmail table, setting pw_dir to NULL. When mail arrives, or the user login through pop, the users maildir is created, and the pw_dir is updated with the new maildir info of the virtual user. When login from sqwebmail, this will not initialize the creation of the users maildir, resulting in a "Premature end of script headers", and following error for the browser. The same happens when login via IMAP. Of course sending a mail to the user, creates the maildir and gives a successful login with sqwebmail/courier-imap for the user. Any solution to this? vpopmail-4.9.8 sqwebmail-1.2.5 courier-imap-1.2 mysql-3.22.32 I've just inserted 19757 users into the mysql table, and I could of course generate a welcome mail for all of these users/accounts. On the other hand, why bother to create the maildirs if only 10% of these accounts acctually will be used. They will not be allowed to pop in, but I could generate a welcom mail based on activation from a web page that the user had to visit before using sqwebmail. You might want to check out the functionality of sqwebmail-1.2.5. I tried installing it yesterday and found that everything worked fine untill I tried to read an email message, then I saw some strange error message about the user being over quota, that's sqwebmail's quota. sqwebmail-1.2.3 works fine and it's availble from the source forge ftp directory of sqwebmail. I've updated the vpopmail-4.9.9 to redo how user dirs are created. So if you download the new version and use that, you'll have luck. Then i've updated the sqwebmail authlib/preauthvchkpw.c code to use this new code. Here is my code sample from that file: vget_assign(s,NULL,0,uid, gid); pw=vauth_getpw(usercopy, s); if ( pw!=NULL ) { if (pw-pw_dir == NULL || strlen(pw-pw_dir) == 0 ) { make_user_dir(usercopy, s, uid, gid); pw=vauth_getpw(usercopy, s); } vlogauth(pw, s, service); } free(usercopy); vclose(); You'll notice it does the check for a null or zero length directory and calls make_user_dir to make it. It also calls the new vlogauth function to updated the lastlog table so you'll know if they authenticated with sqwebmail. By default this code is disabled. if you want it to log that you'll need to add --enable-auth-log=y Ken
Multiple catch all accounts?
I know you can put the catch all email account in the .qmail-default file. But can you put multiple catch all accounts? Should I do this via a forward? Like set the catch all account to be like zzz@domainname and then set zzz as a forward to the other accounts? --- Brad Dameron[EMAIL PROTECTED] Network Account Executive 877-663-4349 TSCNet Online Services www.tscnet.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.231 / Virus Database: 112 - Release Date: 2/12/2001
Re: Multiple catch all accounts?
on 3/7/01 4:48 PM, Brad Dameron at [EMAIL PROTECTED] wrote: I know you can put the catch all email account in the .qmail-default file. But can you put multiple catch all accounts? Should I do this via a forward? Like set the catch all account to be like zzz@domainname and then set zzz as a forward to the other accounts? Sure. -Bill
RE: Multiple catch all accounts?
Lol. Thanks Bill. Your always so helpful. Haha. I was more hoping for a easy .qmail-default mod. But the otherway works. G --- Brad Dameron[EMAIL PROTECTED] Network Account Executive 877-663-4349 TSCNet Online Services www.tscnet.com -Original Message- From: Bill Shupp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 2:48 PM To: [EMAIL PROTECTED] Subject: Re: Multiple catch all accounts? on 3/7/01 4:48 PM, Brad Dameron at [EMAIL PROTECTED] wrote: I know you can put the catch all email account in the .qmail-default file. But can you put multiple catch all accounts? Should I do this via a forward? Like set the catch all account to be like zzz@domainname and then set zzz as a forward to the other accounts? Sure. -Bill --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.231 / Virus Database: 112 - Release Date: 2/12/2001
Re: Multiple catch all accounts?
I know you can put the catch all email account in the .qmail-default file. But can you put multiple catch all accounts? Should I do this via a forward? Like set the catch all account to be like zzz@domainname and then set zzz as a forward to the other accounts? Maybe i misunderstand you... if you wanted to have multiple catch all accounts, just put each address in the .qmail-default file address1 address2 etc etc Sorry if ive misunderstood your problem :)
Need services
I need to find homes for 2 domains. 1 church, 1 commercial. Services desired: http: 5MB disk space smtp: vpopmail (obviously) with qmailadm interface for management pop: sqwebmail Both domains are very small. Customers are familure with qmailadmin and sqwebmail. Looking at less than 12 accounts per domain. web traffic is well under 2 MB per month per domain. I will continue to serve them for tech issues, just dropping the server for now. Email me prices off list please. - Jaysen O'Dell Oatka Data Solutions Technical Support -- [EMAIL PROTECTED]
Re: Auto create users maildir with vpopmail, mysql and sqwebmail
It always compiled for me. Ken Dan Phoenix wrote: just asking again...haven;t asked in about 3 months i think does sqwebmail compile yet with freebsd with vpopmail .23.x mysql still have 50 people waiting. On Wed, 7 Mar 2001, Ken Jones wrote: Date: Wed, 07 Mar 2001 12:13:42 -0600 From: Ken Jones [EMAIL PROTECTED] To: Einar Bordewich [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Auto create users maildir with vpopmail, mysql and sqwebmail Einar Bordewich wrote: With the mysql support for vpopmail, you only need to insert the user info into the vpopmail table, setting pw_dir to NULL. When mail arrives, or the user login through pop, the users maildir is created, and the pw_dir is updated with the new maildir info of the virtual user. When login from sqwebmail, this will not initialize the creation of the users maildir, resulting in a "Premature end of script headers", and following error for the browser. The same happens when login via IMAP. Of course sending a mail to the user, creates the maildir and gives a successful login with sqwebmail/courier-imap for the user. Any solution to this? vpopmail-4.9.8 sqwebmail-1.2.5 courier-imap-1.2 mysql-3.22.32 I've just inserted 19757 users into the mysql table, and I could of course generate a welcome mail for all of these users/accounts. On the other hand, why bother to create the maildirs if only 10% of these accounts acctually will be used. They will not be allowed to pop in, but I could generate a welcom mail based on activation from a web page that the user had to visit before using sqwebmail. You might want to check out the functionality of sqwebmail-1.2.5. I tried installing it yesterday and found that everything worked fine untill I tried to read an email message, then I saw some strange error message about the user being over quota, that's sqwebmail's quota. sqwebmail-1.2.3 works fine and it's availble from the source forge ftp directory of sqwebmail. I've updated the vpopmail-4.9.9 to redo how user dirs are created. So if you download the new version and use that, you'll have luck. Then i've updated the sqwebmail authlib/preauthvchkpw.c code to use this new code. Here is my code sample from that file: vget_assign(s,NULL,0,uid, gid); pw=vauth_getpw(usercopy, s); if ( pw!=NULL ) { if (pw-pw_dir == NULL || strlen(pw-pw_dir) == 0 ) { make_user_dir(usercopy, s, uid, gid); pw=vauth_getpw(usercopy, s); } vlogauth(pw, s, service); } free(usercopy); vclose(); You'll notice it does the check for a null or zero length directory and calls make_user_dir to make it. It also calls the new vlogauth function to updated the lastlog table so you'll know if they authenticated with sqwebmail. By default this code is disabled. if you want it to log that you'll need to add --enable-auth-log=y Ken
Re: Auto create users maildir with vpopmail, mysql and sqwebmail
Ok thx i will check later this week. Last timne i need to add all this -lmysqlclient crap and stuffhopefully it has been added and fixed by now! On Wed, 7 Mar 2001, Ken Jones wrote: Date: Wed, 07 Mar 2001 17:40:30 -0600 From: Ken Jones [EMAIL PROTECTED] To: Dan Phoenix [EMAIL PROTECTED] Cc: Einar Bordewich [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Auto create users maildir with vpopmail, mysql and sqwebmail It always compiled for me. Ken Dan Phoenix wrote: just asking again...haven;t asked in about 3 months i think does sqwebmail compile yet with freebsd with vpopmail .23.x mysql still have 50 people waiting. On Wed, 7 Mar 2001, Ken Jones wrote: Date: Wed, 07 Mar 2001 12:13:42 -0600 From: Ken Jones [EMAIL PROTECTED] To: Einar Bordewich [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Auto create users maildir with vpopmail, mysql and sqwebmail Einar Bordewich wrote: With the mysql support for vpopmail, you only need to insert the user info into the vpopmail table, setting pw_dir to NULL. When mail arrives, or the user login through pop, the users maildir is created, and the pw_dir is updated with the new maildir info of the virtual user. When login from sqwebmail, this will not initialize the creation of the users maildir, resulting in a "Premature end of script headers", and following error for the browser. The same happens when login via IMAP. Of course sending a mail to the user, creates the maildir and gives a successful login with sqwebmail/courier-imap for the user. Any solution to this? vpopmail-4.9.8 sqwebmail-1.2.5 courier-imap-1.2 mysql-3.22.32 I've just inserted 19757 users into the mysql table, and I could of course generate a welcome mail for all of these users/accounts. On the other hand, why bother to create the maildirs if only 10% of these accounts acctually will be used. They will not be allowed to pop in, but I could generate a welcom mail based on activation from a web page that the user had to visit before using sqwebmail. You might want to check out the functionality of sqwebmail-1.2.5. I tried installing it yesterday and found that everything worked fine untill I tried to read an email message, then I saw some strange error message about the user being over quota, that's sqwebmail's quota. sqwebmail-1.2.3 works fine and it's availble from the source forge ftp directory of sqwebmail. I've updated the vpopmail-4.9.9 to redo how user dirs are created. So if you download the new version and use that, you'll have luck. Then i've updated the sqwebmail authlib/preauthvchkpw.c code to use this new code. Here is my code sample from that file: vget_assign(s,NULL,0,uid, gid); pw=vauth_getpw(usercopy, s); if ( pw!=NULL ) { if (pw-pw_dir == NULL || strlen(pw-pw_dir) == 0 ) { make_user_dir(usercopy, s, uid, gid); pw=vauth_getpw(usercopy, s); } vlogauth(pw, s, service); } free(usercopy); vclose(); You'll notice it does the check for a null or zero length directory and calls make_user_dir to make it. It also calls the new vlogauth function to updated the lastlog table so you'll know if they authenticated with sqwebmail. By default this code is disabled. if you want it to log that you'll need to add --enable-auth-log=y Ken
Re: sqwebmail-addressbook GONE again ...
lol at least it works...version i got the addressbook is backwards. -- Dan +--+ | BRAVENET WEB SERVICES | | [EMAIL PROTECTED]| | make installworld| | ln -s /var/qmail/bin/sendmail /usr/sbin/sendmail | | ln -s /var/qmail/bin/newaliases /usr/sbin/newaliases | +__+ On Thu, 8 Mar 2001, Francis P. Ling wrote: Date: Thu, 08 Mar 2001 00:33:11 GMT From: Francis P. Ling [EMAIL PROTECTED] To: sqwebmail-list [EMAIL PROTECTED], vpopmail-list [EMAIL PROTECTED] Subject: sqwebmail-addressbook GONE again ... This is becoming very annoying. For the third time since upgrading vpopmail (from 4.9.4 to 4.9.8) and sqwebmail (1.0.2 to 1.2.5), my users complained of their addressbook being wiped out. Sure enough, the whole sqwebmail-addressbook is gone from their Maildir. Can anyone shed any light on this? Any has anyone with the similar version of the programs experience this? Nope, the quota is 10MB and the said users does not even utilize half of their quota ... Anyone know a cure, pls help as this is becoming a disease to my org. ++ | Francis P. Ling [EMAIL PROTECTED] | | Network Administrator +6084-66 | | Pan Sarawak Co Sdn Bhd www.pansar.com.my | ++ --- Any opinions, explicit or implied, are solely those of the author and do not necessarily represent those of PANSAR ---
New Email Notify
Hi all, I wonder if anyone has tried using some sort of notifier to notify you that your mailbox has new email? Currently, I'm using courier-imap on the server side and Vandyke IMAP Notify on the client side. The problem is that the password is sent in cleartext, so I'm thinking of enabling the SSL mode of the courier-imap. Unfortunately, I've not found any IMAP notifier client that support SSL. Netscape, of course does have a notifier but it doesn't seems to notify me of any new email, although new mail does arrive. ++ | Francis P. Ling [EMAIL PROTECTED] | | Network Administrator +6084-66 | | Pan Sarawak Co Sdn Bhd www.pansar.com.my | ++ --- Any opinions, explicit or implied, are solely those of the author and do not necessarily represent those of PANSAR ---
sqwebmail-addressbook GONE again ...
This is becoming very annoying. For the third time since upgrading vpopmail (from 4.9.4 to 4.9.8) and sqwebmail (1.0.2 to 1.2.5), my users complained of their addressbook being wiped out. Sure enough, the whole sqwebmail-addressbook is gone from their Maildir. Can anyone shed any light on this? Any has anyone with the similar version of the programs experience this? Nope, the quota is 10MB and the said users does not even utilize half of their quota ... Anyone know a cure, pls help as this is becoming a disease to my org. ++ | Francis P. Ling [EMAIL PROTECTED] | | Network Administrator +6084-66 | | Pan Sarawak Co Sdn Bhd www.pansar.com.my | ++ --- Any opinions, explicit or implied, are solely those of the author and do not necessarily represent those of PANSAR ---
More Postmaster Logins
Hello BY Default, Qmailadmin only permits one postmaster to be logged in to particular domain...id another tries to login previous one is kicked out. Any Idea how to increase the postmaster login to atleast 5 Thanks Sumith