Re: [vchkpw] Check Space Usage
- Original Message -
From: "Justin R. Miller" <[EMAIL PROTECTED]>
To: "vpopmail list" <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 5:43 PM
Subject: Re: [vchkpw] Check Space Usage
> Is there an efficient way to do this if you _don't_ use quotas, ideally
> something other than 'du'?
You can open a pipe to 'ls' since the mail sizes are in the name. Quite
easy, though it's up for debate if this is more efficient than du.
This also doesn't take into account other files in the Maildir that aren't
actually messages, but depending on your point of view, these files
shouldn't be included in the user quota anyways.
Snippet of ls pipe (haven't converted to native opendir and readdir yet,
which is probably a bit faster since it saves a process being launched):
open (IN, "ls $homeDir/Maildir/$dir |");
while ($line = ){
chomp $line;
($garbage,$size) = split(',', $line);
($garbage,$size) = split('=', $line);
# $filename = "$homeDir/Maildir/$dir" . $line;
$MailBoxSize += $size;
}
Even better would be native opendir() and readdir(), since it saves a
process being launched. At this point, savings are likely to be minimal,
even with thousands of mailboxes.
Depending on how you do backups and what your needs are for calculating used
space, you might be better analyzing last night's backups instead of live
data. We copy the main data store every night to a seperate disk as part of
our backup, so running analysis on this disk would be quite a bit faster
than on the live store. If you don't need "live" quota management, this
might be acceptable.
--Doug
[vchkpw] devel: vqadmin-2.3.4 availble
Package: vqadmin Version: 2.3.4 (devel) Home: http://www.inter7.com/vqadmin/ Devel Home: http://www.inter7.com/devel/ ChangeLog: http://www.inter7.com/vqadmin/ChangeLog The latest development version of vqadmin is now available at http://www.inter7.com/devel/vqadmin-2.3.4.tar.gz ChangeLog from 2.3.2 (devel) follows: 2.3.4 "Chris Stump" 09/27/02 - Added eFilter enable/disable capabilities - Made vqadmin default to English if an unsupported language is set in user's browser 09/15/02 - Modified Makefile.am to set permission on /images/vqadmin instead of /vqadmin 09/04/02 - match the html dir configure.in directive with vpopmail's. - match new variable (old: wwwroot, new: htmldir) in Makefile.am - simplify (one statement instead of two) chmod/chown of htmldir/images/vqadmin dir - update html templates to use href=/images/vqadmin/vqadmin.css instead of href=../../html/images/vqadmin/vqadmin.css - change style sheet file name from vpop.css to vqadmin.css 2.3.3 08/08/02<[EMAIL PROTECTED]> - Various trivial overflow fixes 08/07/02"Chris Stump" - Qmail control file viewing/modification functionality - Modified configure.in and Makefile.am to correctly place vpop.css "Jeff Keys" - Added vpop.css and improved HTML templates 07/30/02"Maciej Gruszczynski" - New Polish translation 07/29/02"Robert Jonker" - New Dutch translation
Re: [vchkpw] possibly dumb question
There are a couple possibilities. At least vadduser and qmailadmin are working. you have to be carefull installing vqadmin because it runs set uid root. It has to run as root to work on the standard qmail installation. It also needs to be able to send a sig HUP to qmail-send to tell it to re-read it's control files. The standard out of the box setups on redhat and most of the other linux distros let vqadmin run as setuid root. I highly recommend using SSL for qmailadmin and vqadmin. it's easy to do now days as some linux distros support a self generated SSL certificate that the user can click thru to login. you can always buy a real cert and install it. The easiest fix would be if vqadmin wasn't re-built. To give me some feed back on our development work, it would be handy if your future reports were on the latest devel version. I'll make sure we upload the latest version on Friday afternoon USCentral Time. We've added initial support for system admin management of qmail's control files. Also added style sheet support and java script form doohickies. Personally I don't like how style sheet pages display on my Linux browsers. On Wednesday 09 October 2002 04:30 pm, Malachi de AElfweald wrote: > I was able to add them from /vadduser or qmailadmin and it worked ok. > Could it be a problem with vqadmin? > > Malachi > > 10/9/2002 2:14:27 PM, "Michael Bowe" <[EMAIL PROTECTED]> wrote: > >Are you adding new domains/users via vqadmin, or from the command line? > > > >If you are doing it via vqadmin, then try adding from the command line and > >see if that works. > > > >Remember that when you install a new version of vpopmail, you also need to > >recompile any add-on programs that are using the vpopmail libraries eg > >qmailadmin, courier-imap (and also vqadmin although I dont use vqadmin > >myself so couldnt say for sure) > > > >Michael. > > > >- Original Message - > > From: "Paul Theodoropoulos" <[EMAIL PROTECTED]> > > >To: <[EMAIL PROTECTED]> > >Sent: Thursday, October 10, 2002 4:48 AM > >Subject: Re: [vchkpw] possibly dumb question > > > >> yep. i shoudl have said 'i've compiled and installed' - sorry. > >> > >> i'm actually wondering though if this may be something cached by > >> vqadmin, rather than a vpopmail issue > >> > >> At 11:44 AM 10/9/2002, Roberto P.Martins Jr wrote: > >> >Possibly a dump answer, but did you: > >> > > >> ># make install-strip > >> > > >> >?? > >> > > >> >Roberto > >> > > >> >On Wed, 2002-10-09 at 15:38, Paul Theodoropoulos wrote: > >> > > some month back, i made a boo-boo in compiling vpopmail, which left > >> > > me > >> > > >> > with > >> > > >> > > a default quota line that was fubar, e.g. from a random vpasswd > > > >entry: > > > > > > > >tom:x:1:0:tom:/m/domains/example.com/tom:1S,1000C--enable-clea > >r- passwd=y:12345 > > > >> > > as you can see, the quota line has the enable-clear-passwd config > > > >switch > > > >> > > appended to it. it never caused any problems that i could see, but > >> > > it > >> > > >> > is fubar. > >> > > >> > > well, i've compiled newer versions of vpopmail at least twice since > > > >then, > > > >> > > yet whenever i create a new domain and populate it with accounts, it > > > >still > > > >> > > comes up with that fubar quota - even though i've checked, > >> > > rechecked, > > > >and > > > >> > > triple checked my compile-time configs, and it's not being compiled > > > >with > > > >> > > the bad default. > >> > > > >> > > any clues? > >> > > > >> > > > >> > > Paul Theodoropoulos > >> > > http://www.anastrophe.com > >> > > http://folding.stanford.edu > >> > > The Happy-go-lucky Misanthrope > >> > > >> >-- > >> >"Let the source be with you" - Tux > >> > >> Paul Theodoropoulos > >> http://www.anastrophe.com > >> http://folding.stanford.edu > >> The Happy-go-lucky Misanthrope
Re: [vchkpw] Check Space Usage
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Said Matt Simerson on Wed, Oct 09, 2002 at 03:30:55PM -0400: > Otherwise, Doug's heading down the right path. Write yourself a script > that loops for each domain, and then each user within the domain, and > go through and start counting up the bits. You'll likely have issues > with depending on the maildirquota file so make sure that if that file > doesn't exist, you fall back to a more expensive but accurate method > like "du". Is there an efficient way to do this if you _don't_ use quotas, ideally something other than 'du'? - -- [!] Justin R. Miller <[EMAIL PROTECTED]> Encrypted email preferred (key 0xC9C40C31) -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (FreeBSD) iD8DBQE9pM0594d6K8nEDDERAiZtAJwJCG/Msbh2sBhOURk14/rFhV9S9wCeLzKK 9UlVmADxqekIwcH1xtG7RAo= =qPLj -END PGP SIGNATURE-
Re: [vchkpw] possibly dumb question
I was able to add them from /vadduser or qmailadmin and it worked ok. Could it be a problem with vqadmin? Malachi 10/9/2002 2:14:27 PM, "Michael Bowe" <[EMAIL PROTECTED]> wrote: >Are you adding new domains/users via vqadmin, or from the command line? > >If you are doing it via vqadmin, then try adding from the command line and >see if that works. > >Remember that when you install a new version of vpopmail, you also need to >recompile any add-on programs that are using the vpopmail libraries eg >qmailadmin, courier-imap (and also vqadmin although I dont use vqadmin >myself so couldnt say for sure) > >Michael. > >- Original Message - >From: "Paul Theodoropoulos" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, October 10, 2002 4:48 AM >Subject: Re: [vchkpw] possibly dumb question > > >> >> yep. i shoudl have said 'i've compiled and installed' - sorry. >> >> i'm actually wondering though if this may be something cached by vqadmin, >> rather than a vpopmail issue >> >> At 11:44 AM 10/9/2002, Roberto P.Martins Jr wrote: >> >Possibly a dump answer, but did you: >> > >> ># make install-strip >> > >> >?? >> > >> >Roberto >> > >> >On Wed, 2002-10-09 at 15:38, Paul Theodoropoulos wrote: >> > > >> > > some month back, i made a boo-boo in compiling vpopmail, which left me >> > with >> > > a default quota line that was fubar, e.g. from a random vpasswd >entry: >> > > >> > > >> > >tom:x:1:0:tom:/m/domains/example.com/tom:1S,1000C--enable-clear- >passwd=y:12345 >> > > >> > > as you can see, the quota line has the enable-clear-passwd config >switch >> > > appended to it. it never caused any problems that i could see, but it >> > is fubar. >> > > >> > > well, i've compiled newer versions of vpopmail at least twice since >then, >> > > yet whenever i create a new domain and populate it with accounts, it >still >> > > comes up with that fubar quota - even though i've checked, rechecked, >and >> > > triple checked my compile-time configs, and it's not being compiled >with >> > > the bad default. >> > > >> > > any clues? >> > > >> > > >> > > Paul Theodoropoulos >> > > http://www.anastrophe.com >> > > http://folding.stanford.edu >> > > The Happy-go-lucky Misanthrope >> > > >> > > >> > > >> >-- >> >"Let the source be with you" - Tux >> >> Paul Theodoropoulos >> http://www.anastrophe.com >> http://folding.stanford.edu >> The Happy-go-lucky Misanthrope >> >> >> > > >
Re: [vchkpw] Vpopmail locking problem on NFS filesystem
I agree with Andrea. Also, there is a configure option to not use locking. ./configure --help | grep lock to get the exact line. Ken Jones On Wednesday 09 October 2002 11:32 am, Andrea Cerrito wrote: > -BEGIN PGP SIGNED MESSAGE- > > I think that for a NFS solution the SQL backend is a must-have. > Regards, > > Andrea Cerrito > IT Manager > > +39. 0744. 5441. 1 > +39. 348. 4912. 581 > > www.centromultimediale.tv > www.centromultimediale.it > www.etad.it > > == /history > Due giovani e uno meno giovane si trovano proiettati a causa di una > serie di fatalita' in un mondo parallelo dove non esistono le leggi > del business ma solo follia e dolore. > > > -Original Message- > > From: Steve Fulton [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, October 09, 2002 5:44 PM > > To: [EMAIL PROTECTED] > > Subject: Re: [vchkpw] Vpopmail locking problem on NFS filesystem > > > > > > At 10:42 09/10/2002 +0200, you wrote > > > > Which directories did you mount as NFS? Are you using CDB files > > or an SQL > > backend for authentication? > > > > -- Steve > > > > >Hi, > > > > > >I'm trying to share maildir directories with NFS from a backend > > >file server to distribute load on a couple frontend pop/smtp > > >boxes. > > > > In my first > > > > >tests, everything works ok at the moment with vpopmail, > > >qmail-pop3d and courier-imapd managing remotely exported > > >mailboxes, but I get a nfs-related locking error when trying to > > >add/edit user accounts, > > > > changinng > > > > >passwords, quotas, etc. > > > > > >vpopmail tools complaint with non-NFS related error messages, but > > >when running them thru strace, I find a timeout while trying to > > >lock > > > > vusers cdb > > > > >files. NFS client boxes are linux, server is a netapp.com filer, > > > > nfs mount > > > > >options are the defaults (got error when trying to switch to > > >tcp-based nfs), and lockd service is enabled. > > > > > >I know this is not directly related to vpopmail, but what nfs > > > > settings are > > > > >appropiate for this purpose? > > > > > >Thnx > > -BEGIN PGP SIGNATURE- > Version: PGP 7.0.4 > > iQEVAwUBPaRaD/o9HK4+yTI3AQEaFQf+NuI4OOkPOt44PSPZVtLuqE9TjvfqgNk/ > ouqXhhbUCiTzJmR/YIp0XQUpaVS9QXFtUKSl7bj1FlrV1G9Gn35D7FHPxrho8L3i > 2GnxFS6OOchkHKIzE8bn6tMkZQIwAFnUSRXRi6yZYnjhnYlaRj03XsBZsGhu82g4 > 7DT1t/MnQarKAq+McGrqrXFG6om4c/gu/qo49oWpJt1kRWDsIPab8XWMhxs0oDa7 > 9Jr9mnmVBPyXPkdjZMY5ANpCvttHsrKvJnUuOcXL/y2OTD/OYyK0hfM0FzNpV6HA > 9YaA5oYKYF1R/DXiygDE3kur/mt9dao/IvuyhKd13JcyhDgJiHGaQA== > =YoAH > -END PGP SIGNATURE-
Re: [vchkpw] possibly dumb question
I think that was it - recompiling the add-on utils. i downloaded vqadmin 2.3.3 (which isn't mentioned anywhere on the inter7 site - when you go to download the current development release, it refers to 2.3.2), and now it seems to be working okay. thanks. At 02:14 PM 10/9/2002, Michael Bowe wrote: >Are you adding new domains/users via vqadmin, or from the command line? > >If you are doing it via vqadmin, then try adding from the command line and >see if that works. > >Remember that when you install a new version of vpopmail, you also need to >recompile any add-on programs that are using the vpopmail libraries eg >qmailadmin, courier-imap (and also vqadmin although I dont use vqadmin >myself so couldnt say for sure) Paul Theodoropoulos http://www.anastrophe.com http://folding.stanford.edu The Happy-go-lucky Misanthrope
Re: [vchkpw] possibly dumb question
On Wednesday 09 October 2002 02:03 pm, Werner Schalk wrote: > Hello, > > I do have exactly the same problem > because after I installed vpopmail completly > new it still has this damn quota. The compiled quota is only applied to newly created users. The quota value for any current user is already stored in the authentication files/database/whatever. If you want to modify a current users quota use something like vsetuserquota command Ken Jones
Re: [vchkpw] possibly dumb question
Are you adding new domains/users via vqadmin, or from the command line? If you are doing it via vqadmin, then try adding from the command line and see if that works. Remember that when you install a new version of vpopmail, you also need to recompile any add-on programs that are using the vpopmail libraries eg qmailadmin, courier-imap (and also vqadmin although I dont use vqadmin myself so couldnt say for sure) Michael. - Original Message - From: "Paul Theodoropoulos" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 4:48 AM Subject: Re: [vchkpw] possibly dumb question > > yep. i shoudl have said 'i've compiled and installed' - sorry. > > i'm actually wondering though if this may be something cached by vqadmin, > rather than a vpopmail issue > > At 11:44 AM 10/9/2002, Roberto P.Martins Jr wrote: > >Possibly a dump answer, but did you: > > > ># make install-strip > > > >?? > > > >Roberto > > > >On Wed, 2002-10-09 at 15:38, Paul Theodoropoulos wrote: > > > > > > some month back, i made a boo-boo in compiling vpopmail, which left me > > with > > > a default quota line that was fubar, e.g. from a random vpasswd entry: > > > > > > > > tom:x:1:0:tom:/m/domains/example.com/tom:1S,1000C--enable-clear- passwd=y:12345 > > > > > > as you can see, the quota line has the enable-clear-passwd config switch > > > appended to it. it never caused any problems that i could see, but it > > is fubar. > > > > > > well, i've compiled newer versions of vpopmail at least twice since then, > > > yet whenever i create a new domain and populate it with accounts, it still > > > comes up with that fubar quota - even though i've checked, rechecked, and > > > triple checked my compile-time configs, and it's not being compiled with > > > the bad default. > > > > > > any clues? > > > > > > > > > Paul Theodoropoulos > > > http://www.anastrophe.com > > > http://folding.stanford.edu > > > The Happy-go-lucky Misanthrope > > > > > > > > > > >-- > >"Let the source be with you" - Tux > > Paul Theodoropoulos > http://www.anastrophe.com > http://folding.stanford.edu > The Happy-go-lucky Misanthrope > > >
Re: [vchkpw] Check Space Usage
This is a valid argument for having each domain created/owned by an unprivileged system user. When you do that, you have handy tools like repquota to help you manage your disk space usage. When used in conjunction with a perl script, I can format and report the disk space for 10,000 domains in about 6 seconds. I've further taken that report and for all domains that are within 90% of their quota, check the disk usage for each user within the domain and report the disk space hogs. That report takes a couple minutes to run but is invaluable. Otherwise, Doug's heading down the right path. Write yourself a script that loops for each domain, and then each user within the domain, and go through and start counting up the bits. You'll likely have issues with depending on the maildirquota file so make sure that if that file doesn't exist, you fall back to a more expensive but accurate method like "du". Matt On Wednesday, October 9, 2002, at 08:27 AM, Doug Clements wrote: > Michael Funk wrote: >> Is there a way to use vuserinfo to produce a report of user space >> utilization, per user, for all users in the domain? >> Most of the scripting stuff I have tried takes HOURS with 50,000 >> users. > > vuserinfo doesn't store that data.. you pretty much just have to > either count up the mails, or look in the maildirquota file if you use > those kinds of quotas. I think parsing the quota file would be a bit > easier, but the perl script I use to look for abusive customers also > takes quite a while with a large amount of uses. > > I've spent a bit of time optimizing my script, so if you want to post > it, I'll take a look and see if it can sped up. > > --Doug > >
Re: [vchkpw] Check Space Usage
Michael Funk wrote: > Is there a way to use vuserinfo to produce a report of user space > utilization, per user, for all users in the domain? > > Most of the scripting stuff I have tried takes HOURS with 50,000 users. vuserinfo doesn't store that data.. you pretty much just have to either count up the mails, or look in the maildirquota file if you use those kinds of quotas. I think parsing the quota file would be a bit easier, but the perl script I use to look for abusive customers also takes quite a while with a large amount of uses. I've spent a bit of time optimizing my script, so if you want to post it, I'll take a look and see if it can sped up. --Doug
RE: [vchkpw] possibly dumb question
Hello, I do have exactly the same problem because after I installed vpopmail completly new it still has this damn quota. Any hints? Bye and thanks, Werner.
Re: [vchkpw] Problems with sqwebmail
All users fail, or just the new one? Malachi 10/9/2002 9:31:55 AM, <[EMAIL PROTECTED]> wrote: > > >Hello, > >I am hve installed Qmail with vpopmail (mysql-support) and sqwebmail. > >When i added a new user the authetifikation with sqwebmail failed > >I have added a cronjob "killall -HUP >/usr/local/share/sqwebmail/libexec/authlib/authdaemond.ldap" that runs >ever one minute > >It works, but that is only a temporary assistance > >me can someone give a tip which can I do? > >Thanks Chris > > >
[vchkpw] Check Space Usage
Is there a way to use vuserinfo to produce a report of user space utilization, per user, for all users in the domain? Most of the scripting stuff I have tried takes HOURS with 50,000 users.
Re: [vchkpw] possibly dumb question
yep. i shoudl have said 'i've compiled and installed' - sorry. i'm actually wondering though if this may be something cached by vqadmin, rather than a vpopmail issue At 11:44 AM 10/9/2002, Roberto P.Martins Jr wrote: >Possibly a dump answer, but did you: > ># make install-strip > >?? > >Roberto > >On Wed, 2002-10-09 at 15:38, Paul Theodoropoulos wrote: > > > > some month back, i made a boo-boo in compiling vpopmail, which left me > with > > a default quota line that was fubar, e.g. from a random vpasswd entry: > > > > > >tom:x:1:0:tom:/m/domains/example.com/tom:1S,1000C--enable-clear-passwd=y:12345 > > > > as you can see, the quota line has the enable-clear-passwd config switch > > appended to it. it never caused any problems that i could see, but it > is fubar. > > > > well, i've compiled newer versions of vpopmail at least twice since then, > > yet whenever i create a new domain and populate it with accounts, it still > > comes up with that fubar quota - even though i've checked, rechecked, and > > triple checked my compile-time configs, and it's not being compiled with > > the bad default. > > > > any clues? > > > > > > Paul Theodoropoulos > > http://www.anastrophe.com > > http://folding.stanford.edu > > The Happy-go-lucky Misanthrope > > > > > > >-- >"Let the source be with you" - Tux Paul Theodoropoulos http://www.anastrophe.com http://folding.stanford.edu The Happy-go-lucky Misanthrope
Re: [vchkpw] possibly dumb question
Possibly a dump answer, but did you: # make install-strip ?? Roberto On Wed, 2002-10-09 at 15:38, Paul Theodoropoulos wrote: > > some month back, i made a boo-boo in compiling vpopmail, which left me with > a default quota line that was fubar, e.g. from a random vpasswd entry: > > >tom:x:1:0:tom:/m/domains/example.com/tom:1S,1000C--enable-clear-passwd=y:12345 > > as you can see, the quota line has the enable-clear-passwd config switch > appended to it. it never caused any problems that i could see, but it is fubar. > > well, i've compiled newer versions of vpopmail at least twice since then, > yet whenever i create a new domain and populate it with accounts, it still > comes up with that fubar quota - even though i've checked, rechecked, and > triple checked my compile-time configs, and it's not being compiled with > the bad default. > > any clues? > > > Paul Theodoropoulos > http://www.anastrophe.com > http://folding.stanford.edu > The Happy-go-lucky Misanthrope > > > -- "Let the source be with you" - Tux
[vchkpw] possibly dumb question
some month back, i made a boo-boo in compiling vpopmail, which left me with a default quota line that was fubar, e.g. from a random vpasswd entry: tom:x:1:0:tom:/m/domains/example.com/tom:1S,1000C--enable-clear-passwd=y:12345 as you can see, the quota line has the enable-clear-passwd config switch appended to it. it never caused any problems that i could see, but it is fubar. well, i've compiled newer versions of vpopmail at least twice since then, yet whenever i create a new domain and populate it with accounts, it still comes up with that fubar quota - even though i've checked, rechecked, and triple checked my compile-time configs, and it's not being compiled with the bad default. any clues? Paul Theodoropoulos http://www.anastrophe.com http://folding.stanford.edu The Happy-go-lucky Misanthrope
Re: [vchkpw] vpopmail vpasswd file difference(s) between 4.9.10 and 5.3.8 (convert from cdb to mysql)
Just in case anyone else runs into this, I wrote a little Perl script
that parses out /var/qmail/users/assign to fetch a list of domains that
are active on the mail server. Then, for each domain it goes out and
fetches the vpasswd file and feeds its contents into a SQL database. It
works quite nicely.
Matt
#!/usr/bin/perl
use strict;
use DBI;
my $host = 'localhost';
my $user = 'vpopmail';
my $password = 'secret';
my $db = 'vpopmail';
my $domainfile="/var/qmail/users/assign";
my @connect = ("dbi:mysql:database=$db:host=$host", $user, $password);
my $dbh = DBI->connect(@connect);
warn "@connect" unless $dbh;
my @domainlist = get_domainlist( $domainfile );
foreach my $file ( @domainlist ) {
#print "$file->{'dom'} \t $file->{'dir'} \n";
add_users( $file->{'dir'}, $file->{'dom'} );
};
$dbh->disconnect;
print "All done.\n\n";
##
## Subdomains
##
sub get_domainlist {
my @domainlist;
print "Reading in the file $_[0]...";
open ( DOMAINLIST, $_[0] ) || die "couldn't open $_[0]: $!\n";
my @lines = ;
close (DOMAINLIST) || die "couldn't close $_[0]: $!\n";
print "done.\n\n";
print "Extracting the list of domains...";
my $row = "0";
foreach my $line ( @lines ) {
my @fields = split(":", $line);
my %domain = (
dir => "$fields[4]/vpasswd",
dom => "$fields[1]"
);
$domainlist[$row] = \%domain;
$row++;
};
print "done.\n\n.";
return @domainlist;
}
sub add_users {
if ( -e $_[0] ) {
open ( USERLIST, $_[0] ) || warn "couldn't open $_[0]: $!\n";
my @users = ;
close (USERLIST);
foreach my $user (@users) {
chomp $user;
my @f = split(":", $user);
print "$user\n";
my $query = "INSERT INTO vpopmail SET pw_name=\"$f[0]\",
pw_domain=\"$_[1]\", pw_passwd=\"$f[1]\", pw_uid=\"$f[2]\",
pw_gid=\"$f[3]\", pw_gecos=\"$f[4]\", pw_dir=\"$f[5]\",
pw_shell=\"$f[6]\"";
my $sth = $dbh->prepare($query);
$sth->execute;
my $x = $DBI::errstr;
if ($x) { print "Error running $query\n"; };
$sth->finish;
};
};
}
On Tuesday, September 24, 2002, at 04:03 PM, Matt Simerson wrote:
> I'm rebuilding a dinosaur mail server that I built a couple years ago.
> It's running vpopmail 4.9.10 using cdb authentication. I'm upgrading
> to 5.3.8 with MySQL authentication.
>
> I've build out the new 5.3.8 system and cluster of machines. It's all
> up, running and happy. I've NFS mounted all the home directories from
> the old cluster onto the new system so that I have ready access to the
> vpasswd and vpasswd.cdb files. They are mounted onto the local
> filesystem so that the paths in /var/qmail/users/assign are correct.
>
> I run vconvert -c -m test.domain.com and it exits quietly indicating
> success:
>
> mail8# ~vpopmail/bin/vconvert -c -m -v -d test.simerson.net
> version: 5.3.8
> converting test.simerson.net done
>
> However, when I check the MySQL server, there's no entries in the
> vpopmail table that correspond to that domain. :-(
>
> I've tested this one step further. I've manually added a valid user
> ([EMAIL PROTECTED]) into the new mail system by manually adding
> it into the MySQL table. It works fine, authenticates, etc. That
> basically makes it work with my new mail system and the old one at the
> same time. Cool. Anyway, if I run vconvert again, it'll actually
> delete that entry from the vpopmail table. Is that supposed to > happen?
>
> Everything on the new system works just fine except the vconvert
> function. Can anyone verify that vconvert actually does work? Can you
> sanitize a copy of a newer vpasswd file and send it my way so I can
> compare it to my ancient system to see if the format is still the > same?
>
> Matt
>
RE: [vchkpw] Vpopmail locking problem on NFS filesystem
-BEGIN PGP SIGNED MESSAGE- I think that for a NFS solution the SQL backend is a must-have. Regards, Andrea Cerrito IT Manager +39. 0744. 5441. 1 +39. 348. 4912. 581 www.centromultimediale.tv www.centromultimediale.it www.etad.it == /history Due giovani e uno meno giovane si trovano proiettati a causa di una serie di fatalita' in un mondo parallelo dove non esistono le leggi del business ma solo follia e dolore. > -Original Message- > From: Steve Fulton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 09, 2002 5:44 PM > To: [EMAIL PROTECTED] > Subject: Re: [vchkpw] Vpopmail locking problem on NFS filesystem > > > At 10:42 09/10/2002 +0200, you wrote > > Which directories did you mount as NFS? Are you using CDB files > or an SQL > backend for authentication? > > -- Steve > > >Hi, > > > >I'm trying to share maildir directories with NFS from a backend > >file server to distribute load on a couple frontend pop/smtp > >boxes. > In my first > >tests, everything works ok at the moment with vpopmail, > >qmail-pop3d and courier-imapd managing remotely exported > >mailboxes, but I get a nfs-related locking error when trying to > >add/edit user accounts, > changinng > >passwords, quotas, etc. > > > >vpopmail tools complaint with non-NFS related error messages, but > >when running them thru strace, I find a timeout while trying to > >lock > vusers cdb > >files. NFS client boxes are linux, server is a netapp.com filer, > nfs mount > >options are the defaults (got error when trying to switch to > >tcp-based nfs), and lockd service is enabled. > > > >I know this is not directly related to vpopmail, but what nfs > settings are > >appropiate for this purpose? > > > >Thnx > > -BEGIN PGP SIGNATURE- Version: PGP 7.0.4 iQEVAwUBPaRaD/o9HK4+yTI3AQEaFQf+NuI4OOkPOt44PSPZVtLuqE9TjvfqgNk/ ouqXhhbUCiTzJmR/YIp0XQUpaVS9QXFtUKSl7bj1FlrV1G9Gn35D7FHPxrho8L3i 2GnxFS6OOchkHKIzE8bn6tMkZQIwAFnUSRXRi6yZYnjhnYlaRj03XsBZsGhu82g4 7DT1t/MnQarKAq+McGrqrXFG6om4c/gu/qo49oWpJt1kRWDsIPab8XWMhxs0oDa7 9Jr9mnmVBPyXPkdjZMY5ANpCvttHsrKvJnUuOcXL/y2OTD/OYyK0hfM0FzNpV6HA 9YaA5oYKYF1R/DXiygDE3kur/mt9dao/IvuyhKd13JcyhDgJiHGaQA== =YoAH -END PGP SIGNATURE-
[vchkpw] Problems with sqwebmail
Hello, I am hve installed Qmail with vpopmail (mysql-support) and sqwebmail. When i added a new user the authetifikation with sqwebmail failed I have added a cronjob "killall -HUP /usr/local/share/sqwebmail/libexec/authlib/authdaemond.ldap" that runs ever one minute It works, but that is only a temporary assistance me can someone give a tip which can I do? Thanks Chris
Re: [vchkpw] Vpopmail locking problem on NFS filesystem
At 10:42 09/10/2002 +0200, you wrote Which directories did you mount as NFS? Are you using CDB files or an SQL backend for authentication? -- Steve >Hi, > >I'm trying to share maildir directories with NFS from a backend file >server to distribute load on a couple frontend pop/smtp boxes. In my first >tests, everything works ok at the moment with vpopmail, qmail-pop3d and >courier-imapd managing remotely exported mailboxes, but I get a >nfs-related locking error when trying to add/edit user accounts, changinng >passwords, quotas, etc. > >vpopmail tools complaint with non-NFS related error messages, but when >running them thru strace, I find a timeout while trying to lock vusers cdb >files. NFS client boxes are linux, server is a netapp.com filer, nfs mount >options are the defaults (got error when trying to switch to tcp-based >nfs), and lockd service is enabled. > >I know this is not directly related to vpopmail, but what nfs settings are >appropiate for this purpose? > >Thnx >
[vchkpw] vpopmail and fetchmail
How do I set up fetchmail to deliver mail to a virtual user? /S
Re: [vchkpw] Vpopmail locking problem on NFS filesystem
Gonzalo, may you please turn off notification when you post to a list? Thanks, Tonino At 09/10/02 09/10/02 +0200, Gonzalo G. Agulló wrote: >Hi, > >I'm trying to share maildir directories with NFS from a backend file >server to distribute load on a couple frontend pop/smtp boxes. In my first >tests, everything works ok at the moment with vpopmail, qmail-pop3d and >courier-imapd managing remotely exported mailboxes, but I get a >nfs-related locking error when trying to add/edit user accounts, changinng >passwords, quotas, etc. > >vpopmail tools complaint with non-NFS related error messages, but when >running them thru strace, I find a timeout while trying to lock vusers cdb >files. NFS client boxes are linux, server is a netapp.com filer, nfs mount >options are the defaults (got error when trying to switch to tcp-based >nfs), and lockd service is enabled. > >I know this is not directly related to vpopmail, but what nfs settings are >appropiate for this purpose? > >Thnx Inter@zioniInterazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED]
[vchkpw] Vpopmail locking problem on NFS filesystem
Hi, I'm trying to share maildir directories with NFS from a backend file server to distribute load on a couple frontend pop/smtp boxes. In my first tests, everything works ok at the moment with vpopmail, qmail-pop3d and courier-imapd managing remotely exported mailboxes, but I get a nfs-related locking error when trying to add/edit user accounts, changinng passwords, quotas, etc. vpopmail tools complaint with non-NFS related error messages, but when running them thru strace, I find a timeout while trying to lock vusers cdb files. NFS client boxes are linux, server is a netapp.com filer, nfs mount options are the defaults (got error when trying to switch to tcp-based nfs), and lockd service is enabled. I know this is not directly related to vpopmail, but what nfs settings are appropiate for this purpose? Thnx
