Re: [vchkpw] migrating
Actually, I am currently working on the same thing (moving an entire IMail 6 on Win2K Pro to vpopmail on FreeBSD) and came up with an interesting way to migrate people over. We're using IMail's internal user database, and this may or may not work if you're using an external database or the NT one. (I've only dealt with IMail at two different places, and both used the internal IMail database.) As always, YMMV. I found a neat little utility that can be run from the command line on Win2000 to export the usernames and passwords of all IMail users on all domains. Each domain goes into its own text file. It's supposed to export in several formats (CSV, or having columns for each thing starting at a fixed place, etc.) Never could make CSV work, but I was able to use fixed-width fields. I then conjured up a shell script into which you can cat(1) the text file (just remove the first line with the field names, and the last one with the _alias user.) This script would extract (using a hack of commands) the usernames and passwords, then call vadduser to add their accounts (including username, password, and GECOS fields.) Only problems I have had with this method: Users who have their mail forwarded are created on the new server, but their mail isn't forwarded. For me, this isn't a problem, since I can scroll through there and spot-check them, then manually (through qmailadmin) set up those who need it. No biggie. Also, aliases aren't converted, so you have to do those by hand. (We don't have many aliases either.) Lists are also a manual thing, but we have very few of those. If you have alot of aliases/lists/forwarded accounts, this could be a major pain. There might be a better way that I missed, but this one works fine for my purposes and beats typing it all out by hand for sure! :) If anyone's interested in this please E-Mail me directly and let me know. (I'm not at work right now, and I'd have to be there to find the exact names of the software I used.) I can send you the link to the software and a copy of the script, etc. Call it a dirty hack, but it works. However, YMMV. Jeremy Unless the network is lying to me again, Vladimir Kabanov said: > export to LDIF and then parse that file > > - Original Message - > From: "made" <[EMAIL PROTECTED]> > To: "vchkpw" <[EMAIL PROTECTED]> > Sent: Wednesday, March 19, 2003 12:59 AM > Subject: [vchkpw] migrating > > > > did anyone knows how to migrating database account from Imail mail server > > to vchkpw database(mysql) > > -- > > made <[EMAIL PROTECTED]> > > > > > > -- > -- > > Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah > masing-masing Rp 250.000 tunai > > - > --- > > > > > > -- Jeremy Gault <[EMAIL PROTECTED]> Network Administrator / MIS, WinWorld Corporation (v) 423-473-8084 // (f) 423-472-9465
Re: [vchkpw] migrating
export to LDIF and then parse that file - Original Message - From: "made" <[EMAIL PROTECTED]> To: "vchkpw" <[EMAIL PROTECTED]> Sent: Wednesday, March 19, 2003 12:59 AM Subject: [vchkpw] migrating > did anyone knows how to migrating database account from Imail mail server > to vchkpw database(mysql) > -- > made <[EMAIL PROTECTED]> > > > -- -- > Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp 250.000 tunai > - --- > >
[vchkpw] migrating
did anyone knows how to migrating database account from Imail mail server to vchkpw database(mysql) -- made <[EMAIL PROTECTED]> Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp 250.000 tunai
Re: [vchkpw] MySQL 4
Hallo Steve! have no any problems, but only... improved perfomance in mysql 4 :) - Original Message - From: "Steve Fulton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 19, 2003 9:09 AM Subject: [vchkpw] MySQL 4 > Hi all, > > Quick, obvious question: Now that the Powers That Be(tm) have declared > MySQL 4.xx production ready, has anyone run into any difficulties with it > and Vpopmail? > > -- Steve > > >
[vchkpw] MySQL 4
Hi all, Quick, obvious question: Now that the Powers That Be(tm) have declared MySQL 4.xx production ready, has anyone run into any difficulties with it and Vpopmail? -- Steve
Re: [vchkpw] Strange problems with adding a new domain
On Tuesday, March 18, 2003, at 01:17 PM, hondaman wrote: I know when I set up qmail the first time a long time ago, I used vipmap to map the ip to the domain. Could I do that again, with a new ip for the new domain? If you have multiple IP addresses for that machine, then you should be able to use vipmap to map different domains to each IP. My server only has one IP, so I haven't had an opportunity to use vipmap. -- Tom Collins [EMAIL PROTECTED]
RE: [vchkpw] Spamassassin Integration Problem
You need to add the spam option into the alias file too otherwise it will not work, this has been posted before :) Have a good one. REMO -Original Message- From: jeffkoch [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 10:40 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Spamassassin Integration Problem We have spamassassin partly working with the qmail/vpopmail setup. But are having a problem getting it setup so that it processes all of the email that comes into the domain. We have the following line in .qmail-default : | preline /usr/bin/spamc | /home/vpopmail/bin/vdelivermail '' /home/vpopmail/domains/edeint.com/pop99922 within this domain directory we have directories for the users: ede/ jbk/ pop99922/ postmaster/ we also have .qmail files for the following aliases. There .qmail files were created by qmailadmin .qmail-chinesco (contains &[EMAIL PROTECTED]) .qmail-daniel (contains /home/vpopmail/domains/edeint.com/pop99922/Maildir/ ) .qmail-jeff (contains &[EMAIL PROTECTED] ) The problem we have is that spamassassin commands in .qmail-default are only analyzing emails that are addressed to one of the real pop accounts - it is not analyzing emails addressed to an alias for either a local or remote email account. For example it does not work on mail addressed to [EMAIL PROTECTED] even though that mail is then put into the local pop99922 email account. Does anyone have a suggestion on how we can get spamassassin to work on all mail at the domain level? Are we using it wrong or are we using qmailadmin incorrectly. Thanks Jeff -- --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003
RE: [vchkpw] Strange problems with adding a new domain
I know when I set up qmail the first time a long time ago, I used vipmap to map the ip to the domain. Could I do that again, with a new ip for the new domain? -Original Message- From: Tom Collins [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:15 PM To: vpopmail list Subject: Re: [vchkpw] Strange problems with adding a new domain On Tuesday, March 18, 2003, at 11:17 AM, hondaman wrote: > I was using simply hondaman as the username. I just switched to > [EMAIL PROTECTED] and I was able to retrieve my mail. However, a > couple questions still remain: > > Why, when it was just "hondaman" as username for the domain > fast-us.org, > was I getting a duplicate email for every incoming email sent to my > original account, hardcs.com? "hondaman" is either an actual account on the machine (in /etc/passwd), or your POP/IMAP server is setup to use a particular virtual domain as the default for logins that don't specify a domain. When using vpopmail to do virtual domains, you need to include the domain name in the username you use to pick up mail from the server. That's the only way the POP/IMAP server can know what domain the user belongs to. -- Tom Collins [EMAIL PROTECTED]
Re: [vchkpw] Strange problems with adding a new domain
On Tuesday, March 18, 2003, at 11:17 AM, hondaman wrote: I was using simply hondaman as the username. I just switched to [EMAIL PROTECTED] and I was able to retrieve my mail. However, a couple questions still remain: Why, when it was just "hondaman" as username for the domain fast-us.org, was I getting a duplicate email for every incoming email sent to my original account, hardcs.com? "hondaman" is either an actual account on the machine (in /etc/passwd), or your POP/IMAP server is setup to use a particular virtual domain as the default for logins that don't specify a domain. When using vpopmail to do virtual domains, you need to include the domain name in the username you use to pick up mail from the server. That's the only way the POP/IMAP server can know what domain the user belongs to. -- Tom Collins [EMAIL PROTECTED]
RE: [vchkpw] Strange problems with adding a new domain
I was using simply hondaman as the username. I just switched to [EMAIL PROTECTED] and I was able to retrieve my mail. However, a couple questions still remain: Why, when it was just "hondaman" as username for the domain fast-us.org, was I getting a duplicate email for every incoming email sent to my original account, hardcs.com? Why was the username "hondaman" able to send email in the first place if that wasn't a valid login? -Original Message- From: Tom Collins [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:56 AM To: vpopmail list Subject: Re: [vchkpw] Strange problems with adding a new domain Are you using "[EMAIL PROTECTED]" (or "hondaman%fast-us.org") as the POP/IMAP username (and not just "hondaman")? On Tuesday, March 18, 2003, at 10:13 AM, hondaman wrote: > I was using my email client to check to see if mail had arrived. > > In ~vpopmail/domains/fast-us.org/hondaman/Maildir/new appears to be > all the test emails I have sent, but cannot retrieve. > > Yes, I am using qmail-pop3d, and vchkpw > > Hondaman -- Tom Collins [EMAIL PROTECTED]
Re: [vchkpw] Strange problems with adding a new domain
Are you using "[EMAIL PROTECTED]" (or "hondaman%fast-us.org") as the POP/IMAP username (and not just "hondaman")? On Tuesday, March 18, 2003, at 10:13 AM, hondaman wrote: I was using my email client to check to see if mail had arrived. In ~vpopmail/domains/fast-us.org/hondaman/Maildir/new appears to be all the test emails I have sent, but cannot retrieve. Yes, I am using qmail-pop3d, and vchkpw Hondaman -- Tom Collins [EMAIL PROTECTED]
Re: [vchkpw] Spamassassin Integration Problem
Hi Jeff, > The problem we have is that spamassassin commands in .qmail-default are > only analyzing emails that are addressed to one of the real pop accounts - > it is not analyzing emails addressed to an alias for either a local or > remote email account. These aliases are handled by qmail-local _before_ vpopmail pops in. qmail-local checks for .qmail- for a given address, and only if it doesn't find it, it calls .qmail-default which is then executing your filter and delivering mails to POP accounts. I'd suggest to use qmail-scanner to filter all mails on a per-server basis. Actually, it's not filtering, only marking for further inspection. I then have the following in my .qmail files: |condredirect [EMAIL PROTECTED] 822field X-Spam-Flag > /dev/null &[EMAIL PROTECTED] Jonas
Re: [vchkpw] deleting non-existent domain
On Tue, Mar 18, 2003 at 08:19:24PM +0530, Payal Rathod wrote: > What is the problem? There is no directory or file by name > /home/vpopmail/domains/example.net > Maybe it was created previously when I was learning configuring > vpopmail. > How to delete it now? Look in your /var/qmail/users/assign file. You may need to remove the entry there and recompile the cdb file. Also remember to remove it from rcpthosts and virtualdomains. Cory -- Cory Wright Stand Blue Technology http://www.standblue.net/
[vchkpw] deleting non-existent domain
Hi, I tried to add domain example.net in my vpopmail *test* system. But I get, # ./vadddomain example.net payal Error: Domain already exists But then, # ./vdeldomain example.net Error: Domain does not exist But vdominfo gives, # ./vdominfo | grep example.net domain: example.net dir:/home/vpopmail/domains/example.net What is the problem? There is no directory or file by name /home/vpopmail/domains/example.net Maybe it was created previously when I was learning configuring vpopmail. How to delete it now? Thanks a lot and bye. Regards, -Payal -- "Visit GNU/Linux Success Stories" www.geocities.com/rpayal99 Guest-Book Section Updated.
Re: [vchkpw] Strange problems with adding a new domain
On Mon, Mar 17, 2003 at 09:43:45PM -0600, hondaman wrote: > I can reproduce the problem every time I send an email. It doesn't > work. Every time. So the email is sending properly. Why am I not able > to retrieve the email from that account? Why, when I check both > accounts, do I get a copy of every email from each account? [cut] > > msg 79202: bytes 1404 from <[EMAIL PROTECTED]> qp 15120 uid 506 > > @40003e7672e00a02dbcc starting delivery 7940: msg 79202 to local > > [EMAIL PROTECTED] > > @40003e7672e00a02f33c status: local 1/10 remote 0/20 > > @40003e7672e00bbbda54 delivery 7940: success: did_0+0+1/ > > @40003e7672e00bbe89d4 status: local 0/10 remote 0/20 > > @40003e7672e00bbf54f4 end msg 79202 That is a OK delivery.. how exactly are you checking if the mail has arrived? is it qmail-pop3d, and vchkpw? what's in ~vpopmail/domains/fast-us.org/hondaman/Maildir/new ? -- Kiril Todorov < -+- > +359 2 9712013 Bulgaria Online < -+- > http://home.online.bg /* waiting... dreaming... wishing... */
Re: [vchkpw] qmail-smtpd-auth against vpopmail mysql userdb
Hi Peter, The error message is quite clear, albeit I must confess: not it's origin. Are you, by any chance, running the qmail-smtpd process under control of "softlimit" or do you have "ulimit"s applied??? You're absolutely right, the softlimit is set to 2'000'000 membytes. I've just adapted the recomendation from "life with qmail" without reading the notes! shame on me! ;) Now it works great, hint appreciated! Best regads Sam
[vchkpw] Vpopmail/qmail/multiple servers
I have a mail server currently handling smtp/pop3 with storage across NFS and auth through mysql. (qmail 1.03, vpopmail 5.2) I working to add another server (qmail 1.03, vpopmail 5.3.16) as a load share for smtp/pop3. When I add the second server to the mix, using vuserinfo I can query the database and get back results for email boxes and virtual domains without a problem. When I try to add an email box to an existing domain that vuserinfo just told me was there, I get : Error: Domain does not exist For example : == [EMAIL PROTECTED] bin]# ./vadddomain testing3431.com [EMAIL PROTECTED] bin]# ./vdominfo testing3431.com domain: testing3431.com uid:89 gid:89 dir:/usr/local/vpopmail/domains/0/testing3431.com users: 1 === [EMAIL PROTECTED] bin]# ./vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$tEwdi$gxDfuY8/NerlUWDmfmlpS. clear passwd: uid:0 gid:0 all services available dir: /usr/local/vpopmail/domains/0/testing3431.com/postmaster quota: 1000S,2000C usage: 0% account created: Mon Mar 17 17:06:53 2003 last auth: Never logged in [EMAIL PROTECTED] bin]# ls -la /usr/local/vpopmail/domains/0/testing3431.com/postmaster total 3 drwx-- 3 vpopmail vchkpw 512 Mar 17 17:07 . drwx-- 3 vpopmail vchkpw 512 Mar 17 17:07 .. drwx-- 5 vpopmail vchkpw 512 Mar 17 17:07 Maildir [EMAIL PROTECTED] bin]# ./vdominfo testing3431.com domain testing3431.com does not exist [EMAIL PROTECTED] bin]# ./vadduser [EMAIL PROTECTED] what Error: Domain does not exist [EMAIL PROTECTED] bin]# If I create the domain on the new server and do the query/email add from the current server, I also get the same errors. I'm guessing there is something I'm missing on letting the multiple servers share emailbox info or something between themselves. Anyone able to give me a pointer or maybe even a hint of what I've overlooked? thanks your time. David Brinks -- Power-Net Internet Services -- Network Manager [EMAIL PROTECTED] Local Office : 402 N. Mission, Mt.Pleasant, MI 48858 Phone : 989.772.1121 Fax : 989.772.8008
Re: [vchkpw] qmail-smtpd-auth against vpopmail mysql userdb
Hi Samuel, On Tue, 18 Mar 2003 10:37:25 +0100 Samuel Hug <[EMAIL PROTECTED]> wrote: >> http://qmail.org/top.html#checkpassword >> >> Check out the hints by Mark Delany right at the top of the section. > I've tried this, works great! And also the logfile shows up with the > corresponding message: > Mar 18 10:49:06 zeus vpopmail[666]: vchkpw: login success [EMAIL PROTECTED]: Good news. Your authentication "works in general". > Next thing i've done is testing the smtp server via the command line, > and this shows me an error which i can't retrace: [...] > Out of memory (Needed 8164 bytes) > vmysql: sql error[3]: MySQL client run out of memory454 oops, problem > with child and I can't auth (#4.3.0) > > The system itself has enough free memory, and i also wonder why there > are no such problems when i try to login manually as mentioned above. When you try to "log in manually" you don't actually log in somewhere you only test the password checker. The error message is quite clear, albeit I must confess: not it's origin. Are you, by any chance, running the qmail-smtpd process under control of "softlimit" or do you have "ulimit"s applied??? Something 's limiting the memory available to smtpd-process, and of course this limitation is applied to the sub process "vchkpw" too. vchpw tries to connect to the database and execute a query. This query fails. 'sql error[3]' can be cound in 'vmysql.c' in vpopmai sources and it's "thrown" when the query failed. so make sure there's not only enough free memory available, but also 'tcpserver', 'qmail-smtpd' and 'vchkpw' have access to it. If in doubt post your _complete_ qmail-smtpd startup script and the output of 'ulimit -a' -- Peter
Re: [vchkpw] *.domain
sure you can but who will do a simple hack in vpopmail code ?? for my server it's sufficient with all the feature under vpopmail because we only had 2 mail server On 18 Mar 2003 07:00:47 - [EMAIL PROTECTED] wrote: > > Hi !! > > > Subject: Re: [vchkpw] *.domain > > > > Hi Raboo, > > > > > how do you like add in vpopmail? > > > *.domain??? > > > > > > if i want to get the mail for all the subdomains of a domain > > > > There is no such option in vpopmail. > > > > Jonas > > ...but you can set it up manually creating a wildcarded > host in ../control/virtualdomains > > please, check http://qmail.dcs.net/man/man9/qmail-send.html > > If you're planning to use this as default for all Your domains > then You need a simple hack in vpopmail code. > > =d0Mi= > > > > -- thx onOs Divisi Pusat dan Pengawasan Jaringan UPPTI - Universitas Brawijaya Gedung Rektorat Lama Lt. 2 Jl. Veteran Malang 65145 Malang, Jawa Timur mobile phone : (+62) 08563529463 office phone : (+62) 0341 575878
Re: [vchkpw] qmail-smtpd-auth against vpopmail mysql userdb
Hi there, Well i've tried to use vchkpw as the pw checking backend for qmail-smtpd-auth. But at the moment it's not possible to gain access to send mail trough the smtp server. The server is invoked via tcpsever, and runs under the correct user: /usr/local/bin/tcpserver -v -R -l mail.moritzi.ch -x /etc/tcp.smtp.cdb -c 20 -u 7797 -g 2109 0 smtp /var/qmail/bin/qmail-smtpd mail.moritzi.ch /export/opt/vpopmail/bin/vchkpw /bin/true Tho logs doesn't show up with any useful informations. So what exactly do they say? Did you compile vpopmail with verbose error logging? Yes it is compiled with the verbose error logging flag, but not a single line shows up when i'm trying to auth via mua. Is there any possibility to check an useracount with vchkpw via the shell, just to be shure that it does what it should do? http://qmail.org/top.html#checkpassword Check out the hints by Mark Delany right at the top of the section. I've tried this, works great! And also the logfile shows up with the corresponding message: Mar 18 10:49:06 zeus vpopmail[666]: vchkpw: login success [EMAIL PROTECTED]: Are there any other suggestions? Not at the moment, until we see exact error messages from the logs. Which client are you using? Which SMTP AUTH technique are you using - PLAIN, LOGIN or CRAM-MD5? I've tried with mozilla 1.3 and Outlook Express 6, so AUTH technique should be LOGIN i think. Next thing i've done is testing the smtp server via the command line, and this shows me an error which i can't retrace: Connected to localhost. Escape character is '^]'. 220 mail.moritzi.ch ESMTP ehlo sam.baden.moritzi.ch 250-mail.moritzi.ch 250-AUTH LOGIN CRAM-MD5 PLAIN 250-AUTH=LOGIN CRAM-MD5 PLAIN 250-PIPELINING 250 8BITMIME auth login 334 VXNlcm5hbWU6 dGVzdEBzMnBpZC5jaA== 334 UGFzc3dvcmQ6 ZmFrZXB3Oyk= Out of memory (Needed 8164 bytes) vmysql: sql error[3]: MySQL client run out of memory454 oops, problem with child and I can't auth (#4.3.0) The system itself has enough free memory, and i also wonder why there are no such problems when i try to login manually as mentioned above. Any ideas? regards sam
