Re: [vchkpw] Add domain error with MySQL
On Mon, 2004-04-05 at 12:15, Thiago M. Campos wrote: Hi, I followed this http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm howto to configure qmail + vpopmail + mysql but i get the following error when i try to add a domain: Failure while attempting to remove_line() the locals file Error. Failed to add domain to assign file Not sure if I missed the resolution to this, or if you've fixed it, but I just encountered the same problem on a fresh install, and the solution was touch /var/qmail/control/locals. (google vadduser failure while attempting to remove_line() found it, from this list in January ;^) You'll also have to remove the domain's info from /var/qmail/users manually, or get a new error when you try to vadddomain the next time - it actually /does/ add the domain to the assign file, /then/ it fails. j When i started MySQL for the first time i get an error with Inoodb, the i disabled it using skip-innodb in my.cnf I don't know if my error is related with innodb. Can you give any help? Thanks Thiago -- Not all those who wander are lost. - JRR Tolkien
Re: [vchkpw] Re: SMTP-Auth question
(Apologies for the delayed reply - I've been on the road) On Thu, 2004-04-01 at 13:52, Peter Palmreuther wrote: Even if RELAYCLIENT is set, (the Auth patched) qmail-smtpd *WILL* ask for Authentication. No. It'll /OFFER/ SMTP-ATUH, for those that want to set up their mail client to always use SMTP-AUTH instead of relying on a formerly done POP3. You absolutely don't have to make ANY use of this offer. If your IP is set to RELAYCLIENT= by a former POP3 (or whatever) connection, or even is set statically to be allowed to relay, the MUA can simply go I read this: ,- [ mid:[EMAIL PROTECTED] ] | Is there any way to set up SMTP-Auth, while still allowing pop-b4-smtp? | So far when I've rebuilt the system with SMTP-Auth patching, it will | ONLY accept SMTP-Auth to allow relaying... :( `- as follows: - I want both method, SMTP-Auth and POP3-b4-SMTP, for allowing a client to relay. - I don't want the system to /require/ SMTP-Auth when POP3-b4-SMTP already set RELAYCLIENT= But maybe I got it wrong ... Joel? No, you got it right. When I'd tested after rebuilding with SMTP-Auth, I was unable to send mail through without authentication. It could, however, have been caused by my MUA (Evolution 1.4) and my own local configuration, rather than the server - I'll be looking into that tomorrow. Thanks. j -- Not all those who wander are lost. - JRR Tolkien
RE: [vchkpw] MySQL questions, vchkpw tcpserver
On Tue, 2004-03-30 at 13:20, Shane Chrisp wrote: PS: I just confirmed the format is as I said before. Add the IP address like 192.168.0 with a NULL timestamp. Shane Well, I've tried this, but it always disappears from the DB eventually, I presume (unchecked) when clearopensmtp runs. I've had success, however, using a ludicrously high timestamp (99). j -- Not all those who wander are lost. - JRR Tolkien
[vchkpw] MySQL questions, vchkpw tcpserver
I've got a couple of issues. I'm in the process of migrating a cluster of qmail servers to MySQL backend for authentication, and have a question: I'm set up to use vpopmail:relay table to track pops, and I've applied the tcpserver patch to also use vpopmail:relay to store info on 'always-allowed' relaying from our own IPs. My questions: 1 - Previously, with .cdb arrangement, we used the form 192.168.0. to permit relaying from any machine in that /24 network. How do I specify the same using vpopmail:relay?? When I've tried using the same form, it appears not to work. Do I need to insert each IP individually? (that'd be ugly, with a /21 public network and roughly the same size in combined private networks, but if that's the way then that's the way...) 2 - Allowing 'permanent' relaying - Do I just use a ridiculously high timestamp? 3 - How did I end up with entries like this in vpopmail:relay??? | 216.26.255.33 | 1080657350 | | 216.26.255.65.41.4 | 108036425024 | I've got (currently) two qmail/vpopmail nodes in the cluster running on the MySQL backend, and a third still on cdb (until we're assured of the stability of the new setup). Because of this split, I've written a small perl program that periodically synchronizes the two - it reads in open-smtp, reads in all entries from the relay table, removes the earlier of any duplicates, then inserts/updates entries in the db and writes a new open-smtp. j -- Not all those who wander are lost. - JRR Tolkien
[vchkpw] SMTP-Auth question
Is there any way to set up SMTP-Auth, while still allowing pop-b4-smtp? So far when I've rebuilt the system with SMTP-Auth patching, it will ONLY accept SMTP-Auth to allow relaying... :( We have several thousand clients set up on pop-b4-smtp, and forcing a mass migration to smtp-auth is out of the question, yet I /really/ want to get proper smtp-auth working, so new clients are already there, and current clients are migrated as we are able to do so. We're set up with qmail/vpopmail on mysql backend, in an IPVS cluster arrangement of three mailnodes, a director, and a DB/fileserver backend. Worst-case I guess I can assign a second public IP and a separate DNS entry, and force SMTP-Auth clients to use the second FQDN, routing that to a single node that supports SMTP-Auth, but then I lose the benefit of clustering. :( Any insights are appreciated. j -- Not all those who wander are lost. - JRR Tolkien
