Re: [vchkpw] Problems migrating to mysql
On Aug 17, 2004, at 10:08 PM, Tom Collins wrote: I'm going to add code to properly update dir_control for MySQL->CDB as well. I'll check the changes into CVS and they will be in the next release. Maybe not that easy. It looks like I might have to copy the functions to read/write dir_control for CDB into vconvert. Then I can do a straight conversion (read the old format, write the new format). -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] Problems migrating to mysql
On Aug 5, 2004, at 5:13 AM, Mark Richardson wrote: The problem is this: After converting vdominfo says that there are "0" users in the domain, the users are in fact in the database but it appears that the field "cur_users" in the dir_control table isn't updated by vconvert. Can you (or someone else) test this patch and report back? It should increment the count just like vadduser does. I did a quick test with a 5-user domain and it worked. It should also help with getting the other fields of dir_control set right (so a domain with 1000's of users hashes properly). I'm going to add code to properly update dir_control for MySQL->CDB as well. I'll check the changes into CVS and they will be in the next release. diff -u -r1.2.2.1 vconvert.c --- vconvert.c 10 Mar 2004 15:18:50 - 1.2.2.1 +++ vconvert.c 18 Aug 2004 05:01:38 - @@ -188,6 +188,8 @@ int i, colon_count, dir_count; int bFoundDomain = 0; char assign_file[MAX_BUFF]; + uid_t uid; + gid_t gid; snprintf(assign_file, sizeof(assign_file), "%s/users/assign", QMAILDIR); if ( (assign_fs=fopen(assign_file, "r"))==NULL ) { @@ -227,9 +229,13 @@ fclose(assign_fs); vauth_deldomain(domain); +vdel_dir_control(domain); vauth_adddomain(domain); -vget_assign(domain, Dir, sizeof(Dir), NULL, NULL ); +vget_assign(domain, Dir, sizeof(Dir), &uid, &gid ); +#ifdef USERS_BIG_DIR +open_big_dir (domain, uid, gid); +#endif snprintf(tmpbuf, sizeof(tmpbuf), "%s/vpasswd", Dir); fs = fopen(tmpbuf,"r"); if ( fs == NULL ) return(-1); @@ -241,8 +247,14 @@ continue; } vauth_setpw(pw, domain); +#ifdef USERS_BIG_DIR + next_big_dir (uid, gid); /* increment user count */ +#endif } fclose(fs); +#ifdef USERS_BIG_DIR +close_big_dir (domain, uid, gid); +#endif #endif /* USE_SQL */ return(0); } -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
[vchkpw] RBL blocking both SMTP AUTH and POP before SMTP users from sending
still debugging a few users here. vpopmail/vchkpw with mysql install (Matt Simerson's qmail toaster, aged about 9 months) that has had vmysql manually patched for pop before smtp removal of RBL checks, and has had tcpserver patched(old error, subsequenty fixed in newer patches toaster releases) to allow SMTP AUTH users. Both POP before SMTP and SMTP AUTH work fine on the server for a vast majority of the users. We do have a few holdouts though that are troubling me as I am not sure how or why. The purpose of installing the SMTP AUTH was to hopefully force the whole RELAYCLIENT="",RBLSMTPD=""\n entry and ensure that if there were issues with POP before SMTP timeouts or something else that would ensure they could relay and bypass the RBL. We are still having some problem users that can't seem to bypass the RBL check and are subsequently blocked by the dynablock list(justifiably so if they aren't bypassing it). Is there a set of events that would cause the rblsmtpd variable not to be set to blank on either POP before SMTP or SMTP AUTH? Server is not under heavy load or anything... mysql is located on the same box, and it is the same handful of users who can't get around this for the most point. Can't help but think that vchkpw isn't passing the RBLSMTPD="" to qmail for some reason. Look forward to any ideas or suggestions. Dave
[vchkpw] [OT] RBL dialups.services.net
Sorry for the OT, but I really don't know where to ask. Does anyone here know the website for the RBL dialups.services.net? I start using it sometime ago and it is really a great RBL, but sometimes some sysops calls me asking why they got listed, and I can't even say where they should look at. Best regards, Eduardo M. Bragatto.
Re: [vchkpw] ldap or mysql
If you use MySQL I would highly recommend doing a clean install of all your domains and user information. Setup a new server and migrate using scripts to reload all domain/user info. An in place conversion has proven problematic for us with getting acurate dir_control information into MySQL. It seems starting with empty tables and loading all domain and user information via vadddomain and vadduser works just fine though. DAve Fernando Costa de Almeida wrote: Is LDAP support of Vpopmail mature enough for a large production server? Has anyone used it succesfully in such a case? From README.ldap : Using vpopmail with LDAP is not very common. The LDAP modules are functional, but because it not as popular as using CDB or MySQL auth systems, you should be wary of implementing the LDAP system on a production server. I'm using Vpopmail+LDAP for about 2 years, with no problems. But, for older versions of Vpopmail, I had to do some nasty things in order to make it compile correctly. From README.mysql : Using vpopmail with MySQL is becoming increasingly popular. The code is well tested and can be considered to be just as stable as the default CDB authentication system. Michael. And you will have much more flexibility. I did choose LDAP because of this performance, but if I had to make the choice again, I would choose mysql instead.
RE: [vchkpw] ldap or mysql
> > > > > Is LDAP support of Vpopmail mature enough for a large > production server? > > Has anyone used it succesfully in such a case? > > From README.ldap : > > Using vpopmail with LDAP is not very common. > The LDAP modules are functional, but because it not as > popular as using > CDB or MySQL auth systems, you should be wary of > implementing the LDAP > system on a production server. I'm using Vpopmail+LDAP for about 2 years, with no problems. But, for older versions of Vpopmail, I had to do some nasty things in order to make it compile correctly. > > From README.mysql : > > Using vpopmail with MySQL is becoming increasingly popular. > The code is well tested and can be considered to be just > as stable as the default CDB authentication system. > > Michael. > And you will have much more flexibility. I did choose LDAP because of this performance, but if I had to make the choice again, I would choose mysql instead.