RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8
Tom, I believe I figured out what was causing the problem. In the virtual domains file there was a hidden ^M at the end of the domain. When I removed the ^M, everything worked just fine. Thanks for responding. Keith -Original Message- From: Tom Walsh [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 1:02 PM To: Lapidus, Keith; [EMAIL PROTECTED] Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 Keith, In an effort to troubleshoot this particular problem... Would it be possible for you to alter the assign file to also include an entry for kelnet.net_ but point to the same information as the other entry in the assign file? Then see if it works... (this would test the rest of the vpopmail installation as it sits.) I am pretty sure it will because of the stray _ in there. I have to wonder where that is coming from. Seems like it might be a bug with the gcc compiler or the glibc itself... as I have heard there are some issues with that gcc compiler... I am not really sure... As I understand the process qmail-smtpd receives the mail and then hands it over to vckpw which mangles the user information into the EXT compatiable format [EMAIL PROTECTED] (which vdelievermail uses when the variables come from qmail-local/qmail-command). It might be possible that vckpw is suspect in RH8.0 when compiled with that version of gcc... I read that you tried the compiled binaries on RH8.0 but I think you are talking about qmail not vpopmail (which is where the issue probably resides). Good luck on getting it sorted... I could dig through the code, but I am having my own issues that I am trying to dig through the code to find right now... (post forth coming shortly). Let me know what you find out. I am always curious when something odd like this pops up. Tom Walsh Network Administrator http://www.ala.net/ ::-Original Message- ::From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] ::Sent: Monday, December 30, 2002 12:21 PM ::To: Tom Walsh; [EMAIL PROTECTED] ::Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 :: :: ::Tom, :: ::Thanks for the info although I believe that everything is configured ::correctly. I did notice something interesting though. When I send mail ::to the 8.0 server and watch the log file for the starting delivery ::messages I see this: :: ::@40003e108cb13a39e81c new msg 196739 ::@40003e108cb13a39ff8c info msg 196739: bytes 57171 from ::[EMAIL PROTECTED] qp 13176 uid 502 ::@40003e108cb13ac7439c starting delivery 1: msg 196739 to local ::[EMAIL PROTECTED] ::@40003e108cb13ac75b0c status: local 1/10 remote 0/20 ::@40003e108cb13b17b944 delivery 1: failure: ::Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ ::@40003e108cb13b17d884 status: local 0/10 remote 0/20 :: ::Notice where it says starting delivery 1: msg 196739 to local ::[EMAIL PROTECTED] there is a _ attached to kelnet.net_. This ::would explain why qmail is not talking to vpopmail. I am not sure why ::this is happening because when I do the same thing on the 7.3 box, the ::extra _ is not there and the correct virtual domain is found as shown ::below: :: ::@40003e1089a12edf07f4 new msg 58686 ::@40003e1089a12edf234c info msg 58686: bytes 57192 from ::[EMAIL PROTECTED] qp 3843 uid 502 ::@40003e1089a1342ae96c starting delivery 21: msg 58686 to local ::[EMAIL PROTECTED] ::@40003e1089a1342b04c4 status: local 1/10 remote 0/20 ::@40003e1089a137502ddc delivery 21: success: did_0+0+1/ ::@40003e1089a137504d1c status: local 0/10 remote 0/20 ::@40003e1089a1375054ec end msg 58686 :: ::For grins, I recompiled qmail on the 7.3 box and installed the compiled ::binaries on the 8.0 box but still have this problem. My thoughts were ::that the 7.3 box is using gcc 2.96 and the 8.0 box is using gcc 3.2. :: ::Any thoughts or should I possibly defer to the qmail board or maybe ::downgrade to 7.3 from 8.0 redhat? :: ::-Original Message- ::From: Tom Walsh [mailto:[EMAIL PROTECTED]] ::Sent: Monday, December 30, 2002 11:09 AM ::To: Lapidus, Keith; [EMAIL PROTECTED] ::Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 :: :: ::Keith, :: ::I have seen this problem one time in the past when I was setting up a ::Free BSD machine. :: ::I don't recall the specific details as to why it was doing this, just ::that is was. :: ::I think the problem is related to the configuration of qmail and ::specifically the assign file. Make sure that your assign file references ::the correct domain name and storage path... :: ::The storage path for the domian is highly important as it is where qmail ::looks for the .qmail-default that vdelivermail ends up running from... :: ::Hope that helps. :: ::Tom Walsh ::Network Administrator ::http://www.ala.net/ :: :: -Original Message- From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 10:22 AM To: Tom Walsh; [EMAIL PROTECTED] Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8
[vchkpw] qmail + vpopmail + mysql + Redhat 8
Title: qmail + vpopmail + mysql + Redhat 8 I have two servers; one with Redhat 8 installed and one with redhat 7.3 installed. They both have mysql and qmail installed and configured identically. The redhat 7.3 server can send and receive email just fine using vpopmail 5.2.1. When I configure the Redhat 8 server to be the primary mailserver with vpopmail, always gives me the following error: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ I've tried the newer version of vpopmail but have not gotten it to work. Has anyone else gotten qmail and vpopmail to work with Redhat 8?
FW: [vchkpw] qmail + vpopmail + mysql + Redhat 8
Title: Message Actually, vpopmail on the 8.0 box and is NFS exported to the 7.3 box. As for the user accounts, the mysql server is running on the 7.3 as a primary and is replicated on the 8.0 server. In fact, I currently have vpopmail setup to read from the 8.0 box mysql server and write to the 7.3 box mysql server. That works just fine. -Original Message-From: Matt Darcy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 4:53 PMTo: Lapidus, Keith; [EMAIL PROTECTED]Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 -Original Message-From: Lapidus, Keith [mailto:[EMAIL PROTECTED]]Sent: 30 December 2002 06:50To: [EMAIL PROTECTED]Subject: [vchkpw] qmail + vpopmail + mysql + Redhat 8 I have two servers; one with Redhat 8 installed and one with redhat 7.3 installed. They both have mysql and qmail installed and configured identically. The redhat 7.3 server can send and receive email just fine using vpopmail 5.2.1. When I configure the Redhat 8 server to be the primary mailserver with vpopmail, always gives me the following error: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ I've tried the newer version of vpopmail but have not gotten it to work. Has anyone else gotten qmail and vpopmail to work with Redhat 8? [Matt Darcy]Looks like your user accounts are on the7.3 server and database. export the vpopmail database and import it on the 8.0 box and copythe domains from $VPOPMAILHOME/domains on the 7.3 machine to the 8.0 $VPOPMAILHOME/domains Just a thought
RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8
I understand where you are coming from, and I have installed and reinstalled vpopmail many times on the 8.0 machine, and have tried local commands to make sure vpopmail works and it does. For some reason, qmail is not using vpopmail. Do you think this is actually a qmail problem? -Original Message- From: Tom Walsh [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 9:59 AM To: Lapidus, Keith; [EMAIL PROTECTED] Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 From the error message, you can determine that vpopmail is not being run on that particular mailbox. failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ Note the lack of vpopmail in that line... A typical vpopmail bounce (meaning that it got to the vdeliver application but when the look up went to the DB it didn't find it) will read: Sorry,_no_mailbox_here_by_that_name._vpopmail_(#5.1.1) Check your vpopmail install on the RH 8.0 machine. Tom Walsh Network Administrator http://www.ala.net/ -Original Message- From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 9:45 AM To: [EMAIL PROTECTED] Subject: FW: [vchkpw] qmail + vpopmail + mysql + Redhat 8 Actually, vpopmail on the 8.0 box and is NFS exported to the 7.3 box. As for the user accounts, the mysql server is running on the 7.3 as a primary and is replicated on the 8.0 server. In fact, I currently have vpopmail setup to read from the 8.0 box mysql server and write to the 7.3 box mysql server. That works just fine. -Original Message- From: Matt Darcy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 4:53 PM To: Lapidus, Keith; [EMAIL PROTECTED] Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 -Original Message- From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] Sent: 30 December 2002 06:50 To: [EMAIL PROTECTED] Subject: [vchkpw] qmail + vpopmail + mysql + Redhat 8 I have two servers; one with Redhat 8 installed and one with redhat 7.3 installed. They both have mysql and qmail installed and configured identically. The redhat 7.3 server can send and receive email just fine using vpopmail 5.2.1. When I configure the Redhat 8 server to be the primary mailserver with vpopmail, always gives me the following error: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ I've tried the newer version of vpopmail but have not gotten it to work. Has anyone else gotten qmail and vpopmail to work with Redhat 8? [Matt Darcy] Looks like your user accounts are on the 7.3 server and database. export the vpopmail database and import it on the 8.0 box and copy the domains from $VPOPMAILHOME/domains on the 7.3 machine to the 8.0 $VPOPMAILHOME/domains Just a thought
RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8
With the exception of rcpthosts, both the 7.3 and 8.0 boxes qmail are configured and installed from the same source. Below are the requested file contents: /var/qmail/control/virtualdomains kelnet.net:kelnet.net /var/qmail/control/rcpthosts localhost ns1.kelnet.net q.kelnet.net smtp1.kelnet.net kelnet.net .kelnet.net /var/qmail/users/assign +kelnet.net-:kelnet.net:89:89:/var/vpopmail/domains/kelnet.net:-:: . -Original Message- From: Clayton Weise [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 10:37 AM To: vchkpw Subject: Re: [vchkpw] qmail + vpopmail + mysql + Redhat 8 What do your qmail control files look like? /var/qmail/control/virtualdomains /var/qmail/control/rcpthosts /var/qmail/users/assign I'm assuming they're correct, otherwise we'd probably get an error about that domain not being in qmail's allowed list of rcpthosts. But it can't hurt to check. I'd be most interested in /var/qmail/users/assign. On Monday, December 30, 2002, at 08:22 AM, Lapidus, Keith wrote: I understand where you are coming from, and I have installed and reinstalled vpopmail many times on the 8.0 machine, and have tried local commands to make sure vpopmail works and it does. For some reason, qmail is not using vpopmail. Do you think this is actually a qmail problem? -Original Message- From: Tom Walsh [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 9:59 AM To: Lapidus, Keith; [EMAIL PROTECTED] Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 From the error message, you can determine that vpopmail is not being run on that particular mailbox. failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ Note the lack of vpopmail in that line... A typical vpopmail bounce (meaning that it got to the vdeliver application but when the look up went to the DB it didn't find it) will read: Sorry,_no_mailbox_here_by_that_name._vpopmail_(#5.1.1) Check your vpopmail install on the RH 8.0 machine. Tom Walsh Network Administrator http://www.ala.net/ -Original Message- From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 9:45 AM To: [EMAIL PROTECTED] Subject: FW: [vchkpw] qmail + vpopmail + mysql + Redhat 8 Actually, vpopmail on the 8.0 box and is NFS exported to the 7.3 box. As for the user accounts, the mysql server is running on the 7.3 as a primary and is replicated on the 8.0 server. In fact, I currently have vpopmail setup to read from the 8.0 box mysql server and write to the 7.3 box mysql server. That works just fine. -Original Message- From: Matt Darcy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 4:53 PM To: Lapidus, Keith; [EMAIL PROTECTED] Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 -Original Message- From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] Sent: 30 December 2002 06:50 To: [EMAIL PROTECTED] Subject: [vchkpw] qmail + vpopmail + mysql + Redhat 8 I have two servers; one with Redhat 8 installed and one with redhat 7.3 installed. They both have mysql and qmail installed and configured identically. The redhat 7.3 server can send and receive email just fine using vpopmail 5.2.1. When I configure the Redhat 8 server to be the primary mailserver with vpopmail, always gives me the following error: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ I've tried the newer version of vpopmail but have not gotten it to work. Has anyone else gotten qmail and vpopmail to work with Redhat 8? [Matt Darcy] Looks like your user accounts are on the 7.3 server and database. export the vpopmail database and import it on the 8.0 box and copy the domains from $VPOPMAILHOME/domains on the 7.3 machine to the 8.0 $VPOPMAILHOME/domains Just a thought
RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8
Tom, Thanks for the info although I believe that everything is configured correctly. I did notice something interesting though. When I send mail to the 8.0 server and watch the log file for the starting delivery messages I see this: @40003e108cb13a39e81c new msg 196739 @40003e108cb13a39ff8c info msg 196739: bytes 57171 from [EMAIL PROTECTED] qp 13176 uid 502 @40003e108cb13ac7439c starting delivery 1: msg 196739 to local [EMAIL PROTECTED] @40003e108cb13ac75b0c status: local 1/10 remote 0/20 @40003e108cb13b17b944 delivery 1: failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ @40003e108cb13b17d884 status: local 0/10 remote 0/20 Notice where it says starting delivery 1: msg 196739 to local [EMAIL PROTECTED] there is a _ attached to kelnet.net_. This would explain why qmail is not talking to vpopmail. I am not sure why this is happening because when I do the same thing on the 7.3 box, the extra _ is not there and the correct virtual domain is found as shown below: @40003e1089a12edf07f4 new msg 58686 @40003e1089a12edf234c info msg 58686: bytes 57192 from [EMAIL PROTECTED] qp 3843 uid 502 @40003e1089a1342ae96c starting delivery 21: msg 58686 to local [EMAIL PROTECTED] @40003e1089a1342b04c4 status: local 1/10 remote 0/20 @40003e1089a137502ddc delivery 21: success: did_0+0+1/ @40003e1089a137504d1c status: local 0/10 remote 0/20 @40003e1089a1375054ec end msg 58686 For grins, I recompiled qmail on the 7.3 box and installed the compiled binaries on the 8.0 box but still have this problem. My thoughts were that the 7.3 box is using gcc 2.96 and the 8.0 box is using gcc 3.2. Any thoughts or should I possibly defer to the qmail board or maybe downgrade to 7.3 from 8.0 redhat? -Original Message- From: Tom Walsh [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 11:09 AM To: Lapidus, Keith; [EMAIL PROTECTED] Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 Keith, I have seen this problem one time in the past when I was setting up a Free BSD machine. I don't recall the specific details as to why it was doing this, just that is was. I think the problem is related to the configuration of qmail and specifically the assign file. Make sure that your assign file references the correct domain name and storage path... The storage path for the domian is highly important as it is where qmail looks for the .qmail-default that vdelivermail ends up running from... Hope that helps. Tom Walsh Network Administrator http://www.ala.net/ ::-Original Message- ::From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] ::Sent: Monday, December 30, 2002 10:22 AM ::To: Tom Walsh; [EMAIL PROTECTED] ::Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 :: :: ::I understand where you are coming from, and I have installed and ::reinstalled vpopmail many times on the 8.0 machine, and have tried local ::commands to make sure vpopmail works and it does. For some reason, ::qmail is not using vpopmail. Do you think this is actually a qmail ::problem? :: ::-Original Message- ::From: Tom Walsh [mailto:[EMAIL PROTECTED]] ::Sent: Monday, December 30, 2002 9:59 AM ::To: Lapidus, Keith; [EMAIL PROTECTED] ::Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 :: :: ::From the error message, you can determine that vpopmail is not being run ::on that particular mailbox. :: ::failure: Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ :: ::Note the lack of vpopmail in that line... A typical vpopmail bounce ::(meaning that it got to the vdeliver application but when the look up ::went to the DB it didn't find it) will read: :: ::Sorry,_no_mailbox_here_by_that_name._vpopmail_(#5.1.1) :: ::Check your vpopmail install on the RH 8.0 machine. :: ::Tom Walsh ::Network Administrator ::http://www.ala.net/ :: :: ::-Original Message- ::From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] ::Sent: Monday, December 30, 2002 9:45 AM ::To: [EMAIL PROTECTED] ::Subject: FW: [vchkpw] qmail + vpopmail + mysql + Redhat 8 :: :: :: :: ::Actually, vpopmail on the 8.0 box and is NFS exported to the 7.3 box. ::As for the user accounts, the mysql server is running on the 7.3 as a ::primary and is replicated on the 8.0 server. In fact, I currently have ::vpopmail setup to read from the 8.0 box mysql server and write to the ::7.3 box mysql server. That works just fine. -Original Message- ::From: Matt Darcy [mailto:[EMAIL PROTECTED]] ::Sent: Monday, December 30, 2002 4:53 PM ::To: Lapidus, Keith; [EMAIL PROTECTED] ::Subject: RE: [vchkpw] qmail + vpopmail + mysql + Redhat 8 :: :: :: ::-Original Message- ::From: Lapidus, Keith [mailto:[EMAIL PROTECTED]] ::Sent: 30 December 2002 06:50 ::To: [EMAIL PROTECTED] ::Subject: [vchkpw] qmail + vpopmail + mysql + Redhat 8 :: :: ::I have two servers; one with Redhat 8 installed and one with redhat 7.3 ::installed. They both have mysql and qmail installed and configured ::identically. The redhat 7.3 server can send
RE: [vchkpw] vpop and mysql problems (migration from linux to solaris)
Just curious if you compiled with the --enable-clear-passwd=n and it actually worked. My experience in solaris is that you can use that option but it will set a clear password all the time. I actually had to modify the configure script to get it to not create the clear passwd column. -Original Message- From: nicholas [mailto:nicholas;no-spam.co.uk] Sent: Wednesday, November 13, 2002 6:13 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] vpop and mysql problems (migration from linux to solaris) Nice one! Perfect, it worked. Thanks for the help. Now back to work :) I'll stay on the list and see if i can be of any help in the future nicholas It'd probably be better to just recompile vpopmail without clear passwords. -Clayton -Original Message- From: Marco [mailto:marco;ellusion-networks.com] Sent: Wednesday, November 13, 2002 12:56 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpop and mysql problems (migration from linux to solaris) don't mind me, i was just babbling some thoughts earlier without merit. I tested my theory by deleting the clear text password in mysql and i can still authenticate. Anyways, I'm sure it can't hurt to recompiling vpopmail with --enable-clear-passwd=n. For some reason it seems to be trying to access that pw_clear_passwd table which doesnt exist. I really don't know why it is trying to access it. a quick hack might be to create the pw_clear_passwd field, just to satisfy it being there and see if its even gets populated. - Original Message - From: nicholas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 3:58 PM Subject: Re: [vchkpw] vpop and mysql problems (migration from linux to solaris) Thanks for your answer Do you mean --enable-clear-passwd=n here? Im sure i didnt compile it with yes to clear passwords, and trawling through the database they look pretty encypted to me nicholas I've wondered about the clear passwords. Whether or not i compile vpopmail with --enable-clear-passwd=y it still stores a clear text password. I was wondering if it does this regardless. It seems that its trying to pull the password from the pw_clear_password field and not the encrypted one. My thoughts are maybe vchkpw doesn't even match against the encrypted password, but only matches against the clear text password. Any thoughts? - Original Message - From: nicholas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 3:39 PM Subject: [vchkpw] vpop and mysql problems (migration from linux to solaris) hello all Having a little problem here, and thought i would seek help. I have a working vpopmail 5.3.7 on linux with mysql 3.23.32 and qmail, and I want to move the environment over to a solaris box. The solaris box is Solaris 8 with vpopmail 5.3.7 and mysql 3.23.42 and qmail. I compile and install vpopmail with nice options on the solaris box, tar up the relevant /home/vpopmail/domains etc temp user and other stuff (no bin or libs of course) and also copy them across to the solaris machine Then on the Linux box I do a mysqldump --opt vpopmail vpopmail.sql and populate the mysql database on the solaris box with vpopmail.sql I connect to the new sql server and check, the data seems there. but when I telnet to 110 to my new solaris server to see if it all works i get this user [EMAIL PROTECTED] ok pass vmysql: sql error[3]: Unknown column 'pw_clear_passwd' in 'field list' -ERR authorization failed Connection closed by foreign host Now, Im not too up on the tables and fields the vpopmail populates in a mysql database but surely for the same version of vpopmail on different OSes, i should have no problem Can anyone enlighten me on this error, my SQL needs improving. Many thanks nicholas
RE: [vchkpw] Upgrading an old vpopmail install
Just to get my two cents in about the --enable-clear-passwd=n option. This does not work. I actually had to modify the configure script in order to turn this off. -Original Message- From: Bill Shupp [mailto:hostmaster;shupp.org] Sent: Monday, November 04, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Upgrading an old vpopmail install On Monday, November 4, 2002, at 09:58 AM, Darek wrote: Hey guys, I want to go from vpopmail-4.9.8 to probably 5.2.1, or maybe the unstable branch. This is a live system and I am a bit weary about everything working without as much as 5 minutes of downtime. The only difference that I could see between a new version and the old is the placement of tcp.smtp(.cdb) files. But that is pretty trivial. Everything else was the same. Are there any serious differences that qmail, qmailadmin, courier-imap, etc would care about? I know that there's been a lot of development going on, but from a functional and practical point of view, would qmail use vpopmail in the same exact way? There are a couple of issues: 1. 5.0+ defaults to clear passwords being on, which alters the number of fields in the vqpasswd structure (vpasswd file, table definitions, etc). There were some problems with backwards compatibility early on, but 5.2.1 should be fine. If you want to be extra cautious, use --enable-clear-passwd=n. 2. Courier-imap will need to be upgraded. Or, you can grab the latest preauchvchkpw.c and recompile your existing version. Regards, Bill