Re: [vchkpw] reporting on my vpopmail system
Hello. (echo, echo!) is anyone out there? Rick Root wrote: Does anyone have a script or application or something that will view my vpopmail directory structure and give me a report? I would like to know. accounts in each domain # of messages per account amount of disk space per account amount of disk space per domain Thanks. - Rick
Re: [vchkpw] reporting on my vpopmail system
Rick Root wrote: Hello. (echo, echo!) is anyone out there? Rick Root wrote: Does anyone have a script or application or something that will view my vpopmail directory structure and give me a report? I would like to know. accounts in each domain # of messages per account amount of disk space per account amount of disk space per domain Hi, We are here, I just guess no one has a script that does that. Regards, Rick
[vchkpw] clearopensmtp problem
Hi all, I'm having a problem witch clearopensmtp, i dont' know if it's strictly vpopmail related, but that's the file giving me the problem I have the following crontab line 15 * * * * /usr/local/vpopmail/bin/clearopensmtp but I get a mail from crontab saying: /bin/sh: /usr/local/vpopmail/bin/clearopensmtp: No such file or directory I'm sure the path to the file is right # ll /usr/local/vpopmail/bin/clearopensmtp -rwx--x--x1 vpopmail vchkpw 52316 Oct 21 17:04 /usr/local/vpopmail/bin/clearopensmtp what about it ? Tnx in advance Edoardo Serra
Re: [vchkpw] reporting on my vpopmail system
Rick Root wrote: Hello. (echo, echo!) is anyone out there? Rick Root wrote: Does anyone have a script or application or something that will view my vpopmail directory structure and give me a report? I would like to know. accounts in each domain # of messages per account amount of disk space per account amount of disk space per domain Thanks. - Rick Here's a start to what you might want. Your criteria is open to interpretation. I didn't bother prettying it up, and you can add any code you might want. #!/bin/bash VIRTUALROOT='/home/vpopmail/domains' cd ${VIRTUALROOT} find . -type d -maxdepth 1 | sed 's#^\./##' | while read domain; do if [ -e ${VIRTUALROOT}/${domain}/vpasswd ]; then echo echo Domain - ${domain} - occupies $(du -hs ${domain}) cd ${VIRTUALROOT}/${domain} find . -type d -maxdepth 1 | sed 's#^\./##' | while read user; do if [ -d ${VIRTUALROOT}/${domain}/${user}/Maildir ]; then echo ${user} echoMaildir/new contains $(ls -1 ${user}/Maildir/new|wc -l) messages. echoAccount occupies $(du -hs ${user}) fi done cd - fi done -- Bill Gradwohl [EMAIL PROTECTED] http://www.ycc.com SPAMstomper Protected email
[vchkpw] MySql load causes bounced mail
Hello all, I've searched and wasn't able to come up with an answer to this question. Though I did see a reference to it in the Bug Lists ( http://tinyurl.com/59gos ). We're hitting a wall with our MySql install and our traffic is filling up all available MySql connections. We are currently working to tune our MySql install. Until that happens, I was wondering if there was a reason that vpopmail bounces all mail with a 5xx response when it can't connect to MySql. I know that I can increase my max_connections in MySql...it just seems as if vpopmail should respond with a 4xx response so that valid mail isn't bounced. I will admit that I am using an old version of vpopmail (5.2). If this has been fixed I'll work towards an upgrade. Thanks in advance, -jw-
Re: [vchkpw] reporting on my vpopmail system
im using mysql accounts and i dont have a vpasswd, so i changed line 6 to: if [ -e ${VIRTUALROOT}/${domain}/.qmail-default ]; then (all my domains have a .qmail-default) cream Bill Gradwohl wrote: Here's a start to what you might want. Your criteria is open to interpretation. I didn't bother prettying it up, and you can add any code you might want. #!/bin/bash VIRTUALROOT='/home/vpopmail/domains' cd ${VIRTUALROOT} find . -type d -maxdepth 1 | sed 's#^\./##' | while read domain; do if [ -e ${VIRTUALROOT}/${domain}/vpasswd ]; then echo echo Domain - ${domain} - occupies $(du -hs ${domain}) cd ${VIRTUALROOT}/${domain} find . -type d -maxdepth 1 | sed 's#^\./##' | while read user; do if [ -d ${VIRTUALROOT}/${domain}/${user}/Maildir ]; then echo ${user} echoMaildir/new contains $(ls -1 ${user}/Maildir/new|wc -l) messages. echoAccount occupies $(du -hs ${user}) fi done cd - fi done
Re: [vchkpw] reporting on my vpopmail system
Bill Gradwohl schrieb: Rick Root wrote: Hello. (echo, echo!) is anyone out there? Rick Root wrote: Does anyone have a script or application or something that will view my vpopmail directory structure and give me a report? I would like to know. accounts in each domain # of messages per account amount of disk space per account amount of disk space per domain Thanks. - Rick Here's a start to what you might want. Your criteria is open to interpretation. I didn't bother prettying it up, and you can add any code you might want. #!/bin/bash VIRTUALROOT='/home/vpopmail/domains' cd ${VIRTUALROOT} find . -type d -maxdepth 1 | sed 's#^\./##' | while read domain; do if [ -e ${VIRTUALROOT}/${domain}/vpasswd ]; then echo echo Domain - ${domain} - occupies $(du -hs ${domain}) cd ${VIRTUALROOT}/${domain} find . -type d -maxdepth 1 | sed 's#^\./##' | while read user; do if [ -d ${VIRTUALROOT}/${domain}/${user}/Maildir ]; then echo ${user} echoMaildir/new contains $(ls -1 ${user}/Maildir/new|wc -l) messages. echoAccount occupies $(du -hs ${user}) fi done cd - fi done thank you very much bill! werner
Re: [vchkpw] MySql load causes bounced mail
On Oct 21, 2004, at 11:17 AM, Jason Wilkinson wrote: We're hitting a wall with our MySql install and our traffic is filling up all available MySql connections. I think I see one possible problem. vdelivermail calls _exit() when running a command in a .qmail file (exit codes 99, 100 and 111). It should really be calling vexit() to give the MySQL lib a chance to close its connections. We could also consider just using atexit() to register functions that will be automatically called at exit, then we don't have to worry about calling vexit instead (which calls vclose). I took a quick look at vchkpw, and it appears to close its database connections, but I can't be sure. Is it possible to have MySQL report which processes/programs opened connections but failed to close them? I know that I can increase my max_connections in MySql...it just seems as if vpopmail should respond with a 4xx response so that valid mail isn't bounced. I know that Tonio has worked on a new chkuser patch that, along with some extra code in vpopmail, will respond with 4xx. Is there a chance that the old chkusr patch had an execution path that resulted in it not closing its connection to MySQL? -- 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] Mailing list creating with qmailadmin
On Oct 20, 2004, at 4:12 PM, Alexandre Vieira wrote: I think this isn't the right ML to post this but i'm having some trouble with qmailadmin. Everythign work OK but when I try to create a mailing list and click ADD it just goes to the initial qmailadmin domain page and displays in the top No mailing lists to display and doesn't create any mailing list. Anyone experienced this problem? It sounds like ezmlm wasn't installed correctly, or you configured QmailAdmin incorrectly during installation. If the call to ezmlm-make fails, you'll see that sort of error. Take a look at your web server's error log to see if QmailAdmin is reporting any errors. -- 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] chkuser 2.0
On Oct 19, 2004, at 8:14 PM, Charles Sprickman wrote: The one thing that kind of grabbed people's interest was the flood of connection dropped messages that mysql will log if I enable the log warnings option. On other mysql installations I can leave this on and I just see the occasional error. If I point vpopmail at a db with the logging enabled, it just scrolls errors like mad. Is there any way to find out what program was responsible for creating the connection that was dropped? Can you add additional logging to find out what queries are made on the dropped connections before they get dropped? If there's a pattern, we might be able to track down the offending program and fix it. -- 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] chkuser 2.0
Tom Collins wrote: On Oct 19, 2004, at 8:14 PM, Charles Sprickman wrote: The one thing that kind of grabbed people's interest was the flood of connection dropped messages that mysql will log if I enable the log warnings option. On other mysql installations I can leave this on and I just see the occasional error. If I point vpopmail at a db with the logging enabled, it just scrolls errors like mad. Is there any way to find out what program was responsible for creating the connection that was dropped? Can you add additional logging to find out what queries are made on the dropped connections before they get dropped? If there's a pattern, we might be able to track down the offending program and fix it. I have plenty of logging, the querys are in one log, and the errors are in other. The query log is not timestamped consistantly, IE not every record. Makes determining a cause tough. I can see only what DB was accessed and by what user, pass, IP. I've been trying to get better logging, the mysql list, and forums have not responded. I'm hitting a dead end as far as getting more information. DAve -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] Mailing list creating with qmailadmin
Is there a way to display the archives on the web like you regularly see with mailman? I couldn't find any option in qmailadmin to enable this and I'm pretty new to ezmlm myself. On Thu, 21 Oct 2004 12:10:28 -0700, Tom Collins [EMAIL PROTECTED] wrote: On Oct 20, 2004, at 4:12 PM, Alexandre Vieira wrote: I think this isn't the right ML to post this but i'm having some trouble with qmailadmin. Everythign work OK but when I try to create a mailing list and click ADD it just goes to the initial qmailadmin domain page and displays in the top No mailing lists to display and doesn't create any mailing list. Anyone experienced this problem? It sounds like ezmlm wasn't installed correctly, or you configured QmailAdmin incorrectly during installation. If the call to ezmlm-make fails, you'll see that sort of error. Take a look at your web server's error log to see if QmailAdmin is reporting any errors. -- 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/ -- Computers are like air conditioners. Both stop working, if you open windows. -- Adam Heath
Re: [vchkpw] chkuser 2.0
Hi Folks, I've been experimenting some problems about MySQL connections too. Aparently connections with MySQL wasn't closed (or something like that) and the server's load started to grow up. At the begining, I thought that the problem was in MySQL's configuration (timeouts, etc); but it wasn't. I improved the MySQL connections when I recompiled MySQL as static and then recompile vpopmail; it spend more server's memory I know, but the connection close faster. When my POP3 server reach approximately 100 connections/second, the problem come back, but not so hard as before static compiled. Perhaps, the complete solution for high load servers using vpopmail and MySQL will be SQLRelay (for connection pooling). It's my two cents. Telles Dave Goodrich wrote: Tom Collins wrote: On Oct 19, 2004, at 8:14 PM, Charles Sprickman wrote: The one thing that kind of grabbed people's interest was the flood of connection dropped messages that mysql will log if I enable the log warnings option. On other mysql installations I can leave this on and I just see the occasional error. If I point vpopmail at a db with the logging enabled, it just scrolls errors like mad. Is there any way to find out what program was responsible for creating the connection that was dropped? Can you add additional logging to find out what queries are made on the dropped connections before they get dropped? If there's a pattern, we might be able to track down the offending program and fix it. I have plenty of logging, the querys are in one log, and the errors are in other. The query log is not timestamped consistantly, IE not every record. Makes determining a cause tough. I can see only what DB was accessed and by what user, pass, IP. I've been trying to get better logging, the mysql list, and forums have not responded. I'm hitting a dead end as far as getting more information. DAve
Re: [vchkpw] MySql load causes bounced mail
At 21/10/2004 21/10/2004 -0700, you wrote: We could also consider just using atexit() to register functions that will be automatically called at exit, then we don't have to worry about calling vexit instead (which calls vclose). Wow! In another thread I just suggested to use atexit() in vpopmail. I know that Tonio has worked on a new chkuser patch that, along with some extra code in vpopmail, will respond with 4xx. Is there a chance that the old chkusr patch had an execution path that resulted in it not closing its connection to MySQL? Yes, both for new and for old patch. chkuser cannot close any connection, as it's called only for each sender or rcpt, and cannot know when it has finished his job. But, as we are speaking of atexit(), I'll give the good example ( :-) ) and in next 2.0.7 version I'll use it to call vclose(). Thanks, Tonino -- 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/ [EMAIL PROTECTED]Interazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED]
Re: [vchkpw] MySql load causes bounced mail
On Oct 21, 2004, at 3:09 PM, Tom Collins wrote: vdelivermail calls _exit() when running a command in a .qmail file (exit codes 99, 100 and 111). It should really be calling vexit() to give the MySQL lib a chance to close its connections. According to my book here, calling _exit() does not run any atexit() registered functions. This is also the only reason it is async safe, and thus also safe to use when you are in a signal handler. Whereas exit() does call the atexit() registered functions, and thus is not async safe. X-Istence
Re: [vchkpw] MySql load causes bounced mail
At 21/10/2004 21/10/2004 +0100, you wrote: But, as we are speaking of atexit(), I'll give the good example ( :-) ) and in next 2.0.7 version I'll use it to call vclose(). As another thread is saying, qmail-smtpd also is using _exit(), so atexit() is useless. I'll put another solution to work. Probably I'll change the flush() functions. Tonino -- 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/ [EMAIL PROTECTED]Interazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED] [EMAIL PROTECTED]Interazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED]
[vchkpw] vpopmail4.9.10 to vpopmail 5.4.3
Hi,all I have a problem.I want to update vpopmail4.9.10 to vpopmail 5.4.3,but I find the password's encrypt type is not same.How can I convert password's field to vpopmail 5.4.3? thanks 2004-10-22 [EMAIL PROTECTED]