Re: [qmailtoaster] Re: Check data in vpopmail/dir_control table
Eric Shubert e...@shubes.net ha scritto: On 08/03/2012 02:52 PM, ales...@skye.it wrote: Eric Shubert e...@shubes.net ha scritto: On 08/03/2012 02:54 AM, Alessio Cecchi wrote: Hi, after a migration, based on mysqldump and rsync, I think I've corrupted the dir_control table in vpopmail database (I'm using mysql). The row total in my dir_control are 1220 but the total number of domain hosted in the email server are about 1300. How can I rebuild or check the table dir_control? Thank Good question. I think it'd be handy to have a script for that. I've noticed some weirdness/cruft in that table as well. Please ask on the vpopmail list (vch...@inter7.com). if nothing comes of that, perhaps we can write something. Thanks for your reply. I have alreadyasked on vpopmail list but nobody answered :-( Ooops. Sorry, I missed that post. I guess we're on our own with this. I wonder if this is a symptom of a buggy vqadmin. Have you used vqadmin to update anything? I'm not using vqadmin, only vadddomain. Are you noticing any specific problem with this? No, no problem was found. This implies that you have domains being hosted that aren't listed in the dir_control table. Is that correct? Yes could be, currently the only certain thing is that domains in rcpthosts+morercpthosts are more that domain in dir_control table and so the dom_89 row is corrupted. Let's see if we can get this fixed up. I wouldn't be surprised if there are people with disparities there too who haven't migrated. :( Thanks. -- Alessio Cecchi is: @ ILS - http://www.linux.it/~alessice/ on LinkedIn - http://www.linkedin.com/in/alessice Assistenza Sistemi GNU/Linux - http://www.cecchi.biz/ @ PLUG - ex-Presidente, adesso senatore a vita, http://www.prato.linux.it - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
[qmailtoaster] Re: Check data in vpopmail/dir_control table
On 08/04/2012 02:42 AM, Alessio Cecchi wrote: Yes could be, currently the only certain thing is that domains in rcpthosts+morercpthosts are more that domain in dir_control table and so the dom_89 row is corrupted. So rather than me having to look it up, will you (or someone) post a CLI command we can run to check this value? I'd like to see what various people find. The next question then is what impact does that field have? Once we have some idea of how wide spread the disparity is, we can as Matt on the vpopmail list about how that field is used. If he's not responsive, we'll need to take a look at the vpopmail code. Just off the top of my head, I'm wondering if it's used to determine whether or not to use rcpthosts and/or more_rcpthosts files to add domains. If that's the case, it probably doesn't have much if any impact. (Use the Source, Luke.) ;) -- -Eric 'shubes' - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
[qmailtoaster] qmailtoaster-plus-0.3.2-1.4.19 release
There is a new qmailtoaster-plus package available. You should apply this update before doing your next qtp-newmodel (to be sure the required database changes are made for the upcoming vpopmail-5.4.33 release). See the doc/release-notes.txt file for details of modifications. # yum update qmailtoaster-plus is all there is to it. -- -Eric 'shubes' - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Re: Check data in vpopmail/dir_control table
|-- Eric Shubert, le 04/08/2012 14:27, a dit : On 08/04/2012 02:42 AM, Alessio Cecchi wrote: Yes could be, currently the only certain thing is that domains in rcpthosts+morercpthosts are more that domain in dir_control table and so the dom_89 row is corrupted. run /home/vpopmail/bin/vdominfo should add to dir_control missing domains dom_89 should be equal to (and so total rows -1) /home/vpopmail/bin/vdominfo |grep domain: | grep -v alias | wc -l if not, fix it manually So rather than me having to look it up, will you (or someone) post a CLI command we can run to check this value? I'd like to see what various people find. /home/vpopmail/bin/vdominfo |grep domain: | grep -v alias | wc -l cat /var/qmail/users/assign | grep -o ':.*:' | sort | uniq | wc -l must be equal /home/vpopmail/bin/vdominfo |grep domain: | wc -l cat /var/qmail/control/rcpthosts /var/qmail/control/morercpthosts | wc -l cat /var/qmail/control/virtualdomains | wc -l sed '$d' /var/qmail/users/assign | wc -l must be equal The next question then is what impact does that field have? Once we have some idea of how wide spread the disparity is, we can as Matt on the vpopmail list about how that field is used. If he's not responsive, we'll need to take a look at the vpopmail code. Just off the top of my head, I'm wondering if it's used to determine whether or not to use rcpthosts and/or more_rcpthosts files to add domains. If that's the case, it probably doesn't have much if any impact. no, vpopmail does count rcpthosts domains each time vadddomain is invoked (rcpthosts 50 morercpthosts) xaf - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com