Re: ldap and qmail
I want to do email routing where qmail on the mail hub looks up the ldap database for mail host information so that it can route mail to the mail servers. That way I do not have to add user accounts on solaris. All user info for email routing is centrally administered on the LDAP server. By the way, the QLDAPINSTALL document mentions that I need Netscape LDAP sdk (libldapss130). What is this for and where do I download it?? Thanks for any help, Kristina At 02:20 99/12/22 -0500, you wrote: > Kristina writes: > > So far the only documentation I have found on the qmail-ldap patch is > > at http://www.nrg4u.com/qmail/QLDAPINSTALL. > > Yeah, they're assuming that you want everything they want: ldap user > lookups, clustering, and gratuitious anti-spam patches. > > > Are there any other documents around? > > No, but it's really not too hard to hack something up. Exactly what > you need depends on exactly what your ldap is exporting. > > -- > -russ nelson <[EMAIL PROTECTED]> http://russnelson.com > Crynwr sells support for free software | PGPok | Government schools are so > 521 Pleasant Valley Rd. | +1 315 268 1925 voice | bad that any rank amateur > Potsdam, NY 13676-3213 | +1 315 268 9201 FAX | can outdo them. Homescho ol! >
Re: Permissions problem
Todd A. Jacobs writes: > On Wed, 22 Dec 1999, Russell Nelson wrote: > > > Read the source of instcheck. It'll point you to hier.c Or else just > > run install ("make setup") again. > > Any chance that re-running the installation could clobber something? No, although you'll probably want to stop qmail before you do the install. -- -russ nelson <[EMAIL PROTECTED]> http://russnelson.com Crynwr sells support for free software | PGPok | Government schools are so 521 Pleasant Valley Rd. | +1 315 268 1925 voice | bad that any rank amateur Potsdam, NY 13676-3213 | +1 315 268 9201 FAX | can outdo them. Homeschool!
Re: ldap and qmail
Kristina writes: > So far the only documentation I have found on the qmail-ldap patch is > at http://www.nrg4u.com/qmail/QLDAPINSTALL. Yeah, they're assuming that you want everything they want: ldap user lookups, clustering, and gratuitious anti-spam patches. > Are there any other documents around? No, but it's really not too hard to hack something up. Exactly what you need depends on exactly what your ldap is exporting. -- -russ nelson <[EMAIL PROTECTED]> http://russnelson.com Crynwr sells support for free software | PGPok | Government schools are so 521 Pleasant Valley Rd. | +1 315 268 1925 voice | bad that any rank amateur Potsdam, NY 13676-3213 | +1 315 268 9201 FAX | can outdo them. Homeschool!
ldap and qmail
So far the only documentation I have found on the qmail-ldap patch is at http://www.nrg4u.com/qmail/QLDAPINSTALL. Are there any other documents around? Your response much appreciated, Kristina
Re: Permissions problem
Did you added the correct user/group for qmail? See the INSTALL.ids and install the respective group and user for the system. Good Luck, Sei Heng "Todd A. Jacobs" wrote: > Running 'make check' returns the following: > > instcheck: warning: /var/qmail/alias has wrong permissions > instcheck: warning: .../bin/sendmail has wrong group > instcheck: warning: .../bin/sendmail has wrong permissions > > How can I find out what the "right" permissions are? > > -- > Todd A. Jacobs > Network Systems Engineer
Re: 3 quickies!
On Wed, 22 Dec 1999, Marc-Adrian Napoli wrote: > 1. anyone have any suggestions as to what to use for anti-spam > measures? there seems to be a number of options. http://cr.yp.to/rblsmtpd.html -- Todd A. Jacobs Network Systems Engineer
Re: Permissions problem
On Wed, 22 Dec 1999, Russell Nelson wrote: > Read the source of instcheck. It'll point you to hier.c Or else just > run install ("make setup") again. Any chance that re-running the installation could clobber something? -- Todd A. Jacobs Network Systems Engineer
3 quickies!
hi all! 1. anyone have any suggestions as to what to use for anti-spam measures? there seems to be a number of options. 2. anyone have any ideas on putting restrictions on the size of incoming/outgoing mails to certain mailboxes? 3. anyone on the list have details on the up and coming ezmlm-idx 0.40? :-] Regards, Marc-Adrian Napoli Connect Infobahn Australia +61 2 92811750
qmail routing
Hi, How do I get a host running qmail-smtpd to route (forward) all incoming mail to another smtp host? Thanks in advance. --Leonid
Re: Converting PMMail files to Maildir or mbox format
On Tue, Dec 21, 1999 at 09:09:11AM -0500, Subba Rao wrote: > > I am in the process of moving my mail from a OS/2 box. The mail client > here is PMMail. Each email is stored in a seperate file, like in Maildir. > I have moved these files to linux, but cannot read them using Mutt to > convert them to Maildir named files. The PMMail files are named in 7.3 format, > which is like ABCXYZ1.MSG They are just the message, but in dos/CRLF format. There are several ways to convert them. The easiest if to ftp from the OS/2 box to the unix box into the ~Maildir/new/ folder using "ascii" mode. You can then see them with e.g. Mutt. FWIW - PMMail98 for win32 is ok but of course it doesn't run on unix ;-) --Fred
Re: Permissions problem
Todd A. Jacobs writes: > Running 'make check' returns the following: > > instcheck: warning: /var/qmail/alias has wrong permissions > instcheck: warning: .../bin/sendmail has wrong group > instcheck: warning: .../bin/sendmail has wrong permissions > > How can I find out what the "right" permissions are? Read the source of instcheck. It'll point you to hier.c Or else just run install ("make setup") again. -- -russ nelson <[EMAIL PROTECTED]> http://russnelson.com Crynwr sells support for free software | PGPok | Government schools are so 521 Pleasant Valley Rd. | +1 315 268 1925 voice | bad that any rank amateur Potsdam, NY 13676-3213 | +1 315 268 9201 FAX | can outdo them. Homeschool!
Permissions problem
Running 'make check' returns the following: instcheck: warning: /var/qmail/alias has wrong permissions instcheck: warning: .../bin/sendmail has wrong group instcheck: warning: .../bin/sendmail has wrong permissions How can I find out what the "right" permissions are? -- Todd A. Jacobs Network Systems Engineer
Re: Forwarding
On Wed, 22 Dec 1999, Carsten Witt wrote: > How can I forward a mail to another adress. Must I compile another > modul. Or can I put this in /var/qmail/aliases/ ? echo forwardee > ~alias/.qmail-forwarding:address -- Todd A. Jacobs Network Systems Engineer
Re: qmail scanner
On Tue, Dec 21, 1999 at 05:45:43PM -0500, [EMAIL PROTECTED] wrote: > has anyone come to a final howto on getting any of the virus scanning > programs to integrate in qmail? > > I did see one about amavis(?) working but there were no details as to ftp > sites for binaries. > Hi, Take a look at my website: http://www.unixzone.com/virus/ Chris
Re: Forwarding
Carsten, It depends a great deal on your setup. I'll describe the answer for a generic setup now: A) favorite.net is in /var/qmail/control/locals B) there is no UNIX user "martin.buber" C) you want to forward "[EMAIL PROTECTED]" to [EMAIL PROTECTED] You create a the following file: ~alias/.qmail-martin:buber == &[EMAIL PROTECTED] - - - - OK, notice that any "." in a username becomes a ":" in a filename. This disambiguates filesystem "."s from email address "."s, since "." has a special meaning in a filesystem context. Now, you can use an ampersand, or nothing as the first character of the line. If you have a more specific question, please ask. Also check out the Life with Qmail page. It's excellent documentation. (Und wenn Sie sich lieber auf Deutsch fragen wollen, fragen Sie bitte.) -Martin -- Martin A. Brown --- Wonderfrog Enterprises --- [EMAIL PROTECTED] On Wed, 22 Dec 1999, Carsten Witt wrote: -->Hi anybody, --> -->How can I forward a mail to another adress. Must I compile another modul. Or -->can I put this in /var/qmail/aliases/ ? --> -->Thanks to anybody --> --> -->CU --> Carsten --> --> -->
real date stamp in log prob
Hi, First i'd like to thank all those people out there for their help in fixing up my 3 problems in an excelent time.. Now my problem is that i want to get maillog to log with human readable times.. I know that i have to use the tai64nlocal command but where exactly and how.. here is one of my logging scripts.. cat /var/qmail/supervise/qmail-send/log/run #!/bin/sh exec /usr/local/bin/setuidgid qmaill /usr/local/bin/multilog t /var/log/qmail/qmail.send
Forwarding
Hi anybody, How can I forward a mail to another adress. Must I compile another modul. Or can I put this in /var/qmail/aliases/ ? Thanks to anybody CU Carsten
qmail scanner
has anyone come to a final howto on getting any of the virus scanning programs to integrate in qmail? I did see one about amavis(?) working but there were no details as to ftp sites for binaries. Thanks. Paul Farber Farber Technology [EMAIL PROTECTED] Ph 570-628-5303 Fax 570-628-5545
Re: Qmail site down..
Philip Gabbert writes: > > Okay.. Qmail's site is down ;( Yes, I finally tracked the problem down to a dead CPU fan. You get the oddest symptoms when your machine has a brain fever. -- -russ nelson <[EMAIL PROTECTED]> http://russnelson.com Crynwr sells support for free software | PGPok | Government schools are so 521 Pleasant Valley Rd. | +1 315 268 1925 voice | bad that any rank amateur Potsdam, NY 13676-3213 | +1 315 268 9201 FAX | can outdo them. Homeschool!
Re: sending mail
"Stephan Weaver" <[EMAIL PROTECTED]> wrote: >when i send a email locally it sends. >thats from syslog reports. >but when i type mail i dont receive mail locally Where are you having your mail delivered? $HOME/Mailbox? $HOME/Maildir/? /var/spool/mail? Have you made sure that "mail" is looking in the right place? -Dave
Re: Thnx.. One other thing - Grabbing ENV Values?
On Tue, Dec 21, 1999 at 11:47:49AM -0700, Philip Gabbert wrote: > > Thank you very much Martin and Dave.. > Turns out that I need $EXT2 for forwarding, and the name of my alias > files was incorrect as well, should have been .qmail-gpsmac-default for > just .qmail-gpsmac (I presume, I just used the -default) > > One other thing. I want to create a quick perl script to print out all > the arguments and enviroment valiables that are appearent when > qmail-send sends the email. This would help me better understand qmail. > > I've created a test email account: [EMAIL PROTECTED], but when I send my > email to there, it gets lost, and nothing comes out of my script. Here's > my .qmail-test file: > > |preline /home/guice/tmp/test.pl > > test.pl contains: > #!/usr/bin/perl > > open (FLE, ">file.text"); > foreach $key (keys %ENV ) > { print FLE "$key\t$ENV{$key}\n"; } > foreach (@ARGV) > { print FLE $_ . "\n"; } > close (FLE); > exit (0); > > Nothing gets sent to file.text... Any ideas? Or does anybody already > have a script that will do this for me that I can install. I just want > something simple, just enough so I can see everything avaliable when > qmail-send is invoked. > > Thnx again.. > > Philip > > BTW: tmp is set to 777 and test.pl is set to 755. Note: The dir doesn't need to be world or group writable as the script is run as the user owning the dir. The script is effectively run in the users home directory; thus ">file.text" will create a file in the users home directory. I myself has used this script a few times to do something similar, but at the same time include the incoming message and return the lot to the sender: (note that the message body return is xml-parsable as well. ~test/.qmail: --cut here | /home/guice/tmp/env_echo.pl --cut here- env_echo.pl: cut here -- #!/usr/bin/perl # env_echo.pl [EMAIL PROTECTED] 1999-02-18 use strict; my $inmail; while () { $inmail .= ; } my $sender = $ENV{SENDER}; my $modsender = $sender; #$modsender =~ s/\@/\=/; my $from = "env\@example.com"; open MAIL,"| /var/qmail/bin/qmail-inject"; print MAIL "From: $from\nTo: $sender\n". "Subject: mail environment\n". "\n"; print MAIL "
Re: problem qmail / checkpassword
On Tue, Dec 21, 1999 at 08:40:06PM +0100, bert hubert wrote: > On Tue, Dec 21, 1999 at 08:36:07PM +0100, bert hubert wrote: > > > You probably have shadow passwords. These cannot be read by any user but > > root. This means that checkpassword needs to be 'set user id root', suid > > root for short. Try this: > > > > chown root:root /bin/checkpassword > > chmod +s /bin/checkpassword > > DO NOT DO THIS. Sorry. Braino on my part. checkpassword needs to be invoked > by root, it should not be suid. And, as ahu and I discussed on irc, a suid checkpassword is just a /bin/su with a difficult interface and no logging :) Greetz, Peter. -- Peter van Dijk - student/sysadmin/ircoper/womanizer/pretending coder | | 'C makes it easy to shoot yourself in the foot; | C++ makes it harder, but when you do it blows your whole leg off.' | Bjarne Stroustrup, Inventor of C++
Re: problem qmail / checkpassword
On Tue, Dec 21, 1999 at 08:36:07PM +0100, bert hubert wrote: > You probably have shadow passwords. These cannot be read by any user but > root. This means that checkpassword needs to be 'set user id root', suid > root for short. Try this: > > chown root:root /bin/checkpassword > chmod +s /bin/checkpassword DO NOT DO THIS. Sorry. Braino on my part. checkpassword needs to be invoked by root, it should not be suid. Regards, bert hubert. -- +---+ | http://www.rent-a-nerd.nl | nerd for hire | | +---+ | - U N I X - | | Inspice et cautus eris - D11T'95
Re: problem qmail / checkpassword
On Tue, Dec 21, 1999 at 08:27:05PM +0100, Michael Neubert wrote: > I'm an newbie to qmail (and also linux) and hope to find help. You've come to the right place. > michael:~ # /var/qmail/bin/qmail-popup host /bin/checkpassword pwd > +OK <548.945710015@host> > user linux > +OK > pass 12345 > /home/linux > michael:~ # > > I have already checked the rights of /var/qmail... and > /bin/checkpassword. All looks like described in the qmail > INSTALL...-files. You probably have shadow passwords. These cannot be read by any user but root. This means that checkpassword needs to be 'set user id root', suid root for short. Try this: chown root:root /bin/checkpassword chmod +s /bin/checkpassword Regards, bert hubert. -- +---+ | http://www.rent-a-nerd.nl | nerd for hire | | +---+ | - U N I X - | | Inspice et cautus eris - D11T'95
problem qmail / checkpassword
I'm an newbie to qmail (and also linux) and hope to find help. After setting up qmail on SuSE-Linux 6.1 I found a problem with my pop3-server. When contacting the pop3-server the messages "authorization failed" appears. I start the pop3-server in /etc/inetd.conf with this line: pop3 stream tcp nowait root /var/qmail/bin/qmail-popup qmail-popup michael.neubert.de /bin/checkpassword /var/qmail/bin/qmail-pop3d /home/$USER/.mailspool/ After a few tests, I found the following: run 1. test as user michael@michael:~ > /var/qmail/bin/qmail-popup host /bin/checkpassword pwd +OK <569.945710144@host> user linux +OK pass 12345 -ERR authorization failed michael@michael:~ > run 2. test as root michael:~ # /var/qmail/bin/qmail-popup host /bin/checkpassword pwd +OK <548.945710015@host> user linux +OK pass 12345 /home/linux michael:~ # I have already checked the rights of /var/qmail... and /bin/checkpassword. All looks like described in the qmail INSTALL...-files. Thanks in advance for any idea! Michael
Re: trouble opening remote
On Tue, Dec 21, 1999 at 01:09:44PM -0600, Ronny Haryanto wrote: > I keep getting hundreds of these in my logs (with different numbers): > > 945803383.619689 warning: trouble opening remote/5/1569; will try again later > 945803383.619908 warning: trouble opening remote/0/3036; will try again later > 945803383.619921 warning: trouble opening remote/8/1986; will try again later Do you perhaps have multiple qmail instances running? Try strace or truss to see what qmail is doing. Regards, bert hubert. -- +---+ | http://www.rent-a-nerd.nl | nerd for hire | | +---+ | - U N I X - | | Inspice et cautus eris - D11T'95
Re: Tidbit..
Philip Gabbert writes: > > I was looking over the Qmail homepage and I found that you can "usually". The key word missing here is "usually". > create a rcpthosts file with the following shell command: Yeah, I could do this: sed -e 's/^[^@]*@//' -e 's/:.*//' rcpthosts But that makes it harder to understand the relationship between virtualdomains, locals, and rcpthosts, which is the real reason why I wrote that shell script. -- -russ nelson <[EMAIL PROTECTED]> http://russnelson.com Crynwr sells support for free software | PGPok | Government schools are so 521 Pleasant Valley Rd. | +1 315 268 1925 voice | bad that any rank amateur Potsdam, NY 13676-3213 | +1 315 268 9201 FAX | can outdo them. Homeschool!
trouble opening remote
Hi, I keep getting hundreds of these in my logs (with different numbers): 945803383.619689 warning: trouble opening remote/5/1569; will try again later 945803383.619908 warning: trouble opening remote/0/3036; will try again later 945803383.619921 warning: trouble opening remote/8/1986; will try again later 945803383.619933 warning: trouble opening remote/12/4175; will try again later 945803383.619945 warning: trouble opening remote/20/3815; will try again later 945803383.619957 warning: trouble opening remote/16/1396; will try again later 945803383.619970 warning: trouble opening remote/5/2811; will try again later All other deliveries run fine though. What could be the problem? -- Ronny Haryanto
Thnx.. One other thing - Grabbing ENV Values?
Thank you very much Martin and Dave.. Turns out that I need $EXT2 for forwarding, and the name of my alias files was incorrect as well, should have been .qmail-gpsmac-default for just .qmail-gpsmac (I presume, I just used the -default) One other thing. I want to create a quick perl script to print out all the arguments and enviroment valiables that are appearent when qmail-send sends the email. This would help me better understand qmail. I've created a test email account: [EMAIL PROTECTED], but when I send my email to there, it gets lost, and nothing comes out of my script. Here's my .qmail-test file: |preline /home/guice/tmp/test.pl test.pl contains: #!/usr/bin/perl open (FLE, ">file.text"); foreach $key (keys %ENV ) { print FLE "$key\t$ENV{$key}\n"; } foreach (@ARGV) { print FLE $_ . "\n"; } close (FLE); exit (0); Nothing gets sent to file.text... Any ideas? Or does anybody already have a script that will do this for me that I can install. I just want something simple, just enough so I can see everything avaliable when qmail-send is invoked. Thnx again.. Philip BTW: tmp is set to 777 and test.pl is set to 755. Dave Sill wrote: > > [EMAIL PROTECTED] wrote: > > >and in ~alias/.qmail-alias-gpsmac > >&{$USER}@gpsmac.net > > > >Is this correct? > > Close. Try: > > |forward "$USER"@gpsmac.net > > >I was going to try and search the archive and locate it in there, but > >I'm unable to get to the qmail site and thus unable to locate the link > >to the qmail list archive. > > Bookmark LWQ for future reference. It's got pointers to the list > archives. > > -Dave
Re: tcpserver logging
Marek Narkiewicz <[EMAIL PROTECTED]> wrote: >>> > tcpserver -v -u 7770 -g 2108 0 smtp /var/qmail/bin/qmail-smtpd \ >>> > 2>&1 | /var/qmail/bin/splogger smtpd 3 & > >Does qmail-smtpd send its logging information to stderr qmail-smtpd doesn do any logging, but tcpserver does. >or am i missing something here? I don't know. What are you getting at? -Dave
Re: tcpserver logging
On Tue, 21 Dec 1999 11:24:23 -0500, Keith Warno wrote: >- Original Message - >From: "Dave Sill" <[EMAIL PROTECTED]> >> "Keith Warno" <[EMAIL PROTECTED]> wrote: >> >> > tcpserver -v -u 7770 -g 2108 0 smtp /var/qmail/bin/qmail-smtpd \ >> > 2>&1 | /var/qmail/bin/splogger smtpd 3 & >> > >> >Um ok, the uid and gid are diff on my box :> So's the qmail path but >other >> >than that it's a cut/paste and msgs are getting blurted out to the >terminal. >> >> Odds are good that you're using a shell that doesn't use the "2>&1" >> syntax to redirect stderr to stdout. Does qmail-smtpd send its logging information to stderr or am i missing something here?
Re: tcpserver logging
"Keith Warno" <[EMAIL PROTECTED]> writes: All seems well tho I can't seem to figure out why things are getting logged to my terminal rather than to a log file somewhere. [...] tcpserver -v -u 7770 -g 2108 0 smtp /var/qmail/bin/qmail-smtpd \ 2>&1 | /var/qmail/bin/splogger smtpd 3 & [...] To be honest I have no idea what facility 3 is (second arg to splogger); at any sane hour of the day I probably would You're close. Read /usr/include/syslog.h (or maybe it's /../sys/syslog.h for you). 3 is "daemon" for me. I use splogger without specifying any facility to get my tcpserver logs placed in my mail log.
Re: tcpserver logging
- Original Message - From: "Dave Sill" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 21, 1999 12:24 PM Subject: Re: tcpserver logging > "Keith Warno" <[EMAIL PROTECTED]> wrote: > >From: "Dave Sill" <[EMAIL PROTECTED]> > >> "Keith Warno" <[EMAIL PROTECTED]> wrote: > >> > >> > tcpserver -v -u 7770 -g 2108 0 smtp /var/qmail/bin/qmail-smtpd \ > >> > 2>&1 | /var/qmail/bin/splogger smtpd 3 & > >> > > >> >Um ok, the uid and gid are diff on my box :> So's the qmail path but > >other > >> >than that it's a cut/paste and msgs are getting blurted out to the > >terminal. > >> > >> Odds are good that you're using a shell that doesn't use the "2>&1" > >> syntax to redirect stderr to stdout. > >> > >> -Dave > > > >If it were that easy I would have spotted it, even at 230am :) > > > >The shell is bash. > > OK, pardon me. So what to the messages you see look like? Is anything > going to syslog? What does: > > echo foo | /var/qmail/bin/splogger smtpd 3 > > do? Facility 3 is (usually?) daemon. Check /usr/include/sys/syslog.h. > Leave it off, and splogger will default to 2 (mail), which is probably > what you want. > > -Dave It turned out to be a minor goof in the rc script. I spelled a variable wrong. These things happen during the wee hours of the AM :) Sorry about that; thanks for your help. kw
Re: Qmail site down..
Philip, I like Dave's reply better. :-) -Martin -- Martin A. Brown --- Wonderfrog Enterprises --- [EMAIL PROTECTED] On Tue, 21 Dec 1999, Martin A. Brown wrote: -->Philip, --> -->I suspect that you want to use $EXT, not $USER (which in this case would -->expand to be "alias". And I think you really want to use forward: --> -->| forward ${EXT}@gpsmac.net --> -->-Martin --> -->
Re: Qmail site down..
Philip, I suspect that you want to use $EXT, not $USER (which in this case would expand to be "alias". And I think you really want to use forward: | forward ${EXT}@gpsmac.net -Martin -- Martin A. Brown --- Wonderfrog Enterprises --- [EMAIL PROTECTED] On Tue, 21 Dec 1999, Philip Gabbert wrote: --> -->Okay.. Qmail's site is down ;( -->or at least traceroute is unable to trace to the site. --> -->So I'll ask here, just a quickie, I want to forward all email coming to -->my domain gpsmac.com to another domain, changing the domain name to one -->that recognized by the recipient. -->I have: -->gpsmac.com:alias-gpsmac --> -->and in ~alias/.qmail-alias-gpsmac -->&{$USER}@gpsmac.net --> -->Is this correct? -->I was going to try and search the archive and locate it in there, but -->I'm unable to get to the qmail site and thus unable to locate the link -->to the qmail list archive. --> -->Just a quickie.. --> -->Thnx.. --> -->Philip -->
Re: tcpserver logging
"Keith Warno" <[EMAIL PROTECTED]> wrote: >From: "Dave Sill" <[EMAIL PROTECTED]> >> "Keith Warno" <[EMAIL PROTECTED]> wrote: >> >> > tcpserver -v -u 7770 -g 2108 0 smtp /var/qmail/bin/qmail-smtpd \ >> > 2>&1 | /var/qmail/bin/splogger smtpd 3 & >> > >> >Um ok, the uid and gid are diff on my box :> So's the qmail path but >other >> >than that it's a cut/paste and msgs are getting blurted out to the >terminal. >> >> Odds are good that you're using a shell that doesn't use the "2>&1" >> syntax to redirect stderr to stdout. >> >> -Dave > >If it were that easy I would have spotted it, even at 230am :) > >The shell is bash. OK, pardon me. So what to the messages you see look like? Is anything going to syslog? What does: echo foo | /var/qmail/bin/splogger smtpd 3 do? Facility 3 is (usually?) daemon. Check /usr/include/sys/syslog.h. Leave it off, and splogger will default to 2 (mail), which is probably what you want. -Dave
Re: Qmail site down..
[EMAIL PROTECTED] wrote: >and in ~alias/.qmail-alias-gpsmac >&{$USER}@gpsmac.net > >Is this correct? Close. Try: |forward "$USER"@gpsmac.net >I was going to try and search the archive and locate it in there, but >I'm unable to get to the qmail site and thus unable to locate the link >to the qmail list archive. Bookmark LWQ for future reference. It's got pointers to the list archives. -Dave
Re: Qmail is killing my mySQL server!
On Tue, Dec 21, 1999 at 05:01:22PM +0800, Michael Boman wrote: > The problem isnt either the database server, it's fine tuned to the maximum. The > problem is that SMTP/POP3 is causing ALLOT of traffic to the database server. > > It wouldn't matter if we put Oracle or MS Sql instead, 'cause the traffic will still > be there. What I am looking for is a way to slow down the queries, limit them some >how, > to the database server. What do you mean by ALOT of traffic? We've changed POP3 auth to a MySQL database (homegrown scripts etc.) and had problems during prime times that the mysql server wasn't responding fast enough thus up to 120 checkpassword scripts were "in the queue" on the POP3 server waiting for connections and some of them dying due to timeouts. I set up a test environment and noticed that the mysql server was only able to handle 3-4 requests a second. Inspecting the tables I found out that we had defined an INDEX false. This had the effect that the INDEX was unusable for the authent requests. Fixing this and stress testing in the testing environment got us more than 400 successful requests per second. We have about 15K userbase and now it runs smoothly without problems. Maybe this helps. \Maex -- SpaceNet GmbH | http://www.Space.Net/ | Stress is when you wake Research & Development| mailto:[EMAIL PROTECTED] | up screaming and you Joseph-Dollinger-Bogen 14 | Tel: +49 (89) 32356-0| realize you haven't D-80807 Muenchen | Fax: +49 (89) 32356-299 | fallen asleep yet.
Qmail site down..
Okay.. Qmail's site is down ;( or at least traceroute is unable to trace to the site. So I'll ask here, just a quickie, I want to forward all email coming to my domain gpsmac.com to another domain, changing the domain name to one that recognized by the recipient. I have: gpsmac.com:alias-gpsmac and in ~alias/.qmail-alias-gpsmac &{$USER}@gpsmac.net Is this correct? I was going to try and search the archive and locate it in there, but I'm unable to get to the qmail site and thus unable to locate the link to the qmail list archive. Just a quickie.. Thnx.. Philip
Re: tcpserver logging
- Original Message - From: "Dave Sill" <[EMAIL PROTECTED]> > "Keith Warno" <[EMAIL PROTECTED]> wrote: > > > tcpserver -v -u 7770 -g 2108 0 smtp /var/qmail/bin/qmail-smtpd \ > > 2>&1 | /var/qmail/bin/splogger smtpd 3 & > > > >Um ok, the uid and gid are diff on my box :> So's the qmail path but other > >than that it's a cut/paste and msgs are getting blurted out to the terminal. > > Odds are good that you're using a shell that doesn't use the "2>&1" > syntax to redirect stderr to stdout. > > -Dave If it were that easy I would have spotted it, even at 230am :) The shell is bash.
Re: Segmentation fault in qmail log
Please don't CC me on replies to the list. "David C. Maple" <[EMAIL PROTECTED]> wrote: >That's a problem I can't find any core files on the system. Which MDA(s) is the .qmail file in question running? -Dave
Re: Qmail is killing my mySQL server!
Definitely need persistant connections. We use M$ SQL 7 for our authentication via RADIATOR which is an sql based radius server. It uses persistant connections (via perl::DBI) and we have no problems with 10k+ users. jpd At 09:18 AM 12/21/99 -0500, you wrote: >Sound like you need to look into mod_perl, mod_dbi so you can have >persistant >database connections for your server. > >Mike > > > >- Original Message - >From: Eric Peters <[EMAIL PROTECTED]> >To: Michael Boman <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Tuesday, December 21, 1999 3:23 AM >Subject: Re: Qmail is killing my mySQL server! > > >> makes you think about that doesn't it >> >> you probably want to consult the mysql mailing list for perf tuning >> >> Eric >> >> On Tue, 21 Dec 1999, Michael Boman wrote: >> > On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote: >> > > its probably rather simple - your probably using the decaprecated >mysql_connect >> > > in the CGI possibly - rather than the mysql_real_connect api - >> > > >> > > well to be simpler than that make sure your majority of the >connections are >> > > connecting through teh mysql named pipe (the socket) rather than >tcp/ip >> > > connections >> > > >> > > Eric >> > > >> > >> > Err.. It's on three different computers: Webserver, Mailserver, mySQL >server. >> > >> > /Mike >> > >> > > On Mon, 20 Dec 1999, Michael Boman wrote: >> > > > I am running following setup: >> > > > >> > > > qmail 1.03 + mysql patch >> > > > tcpserver etc. >> > > > >> > > > Right now qmail is killing the mySQL database server with requests. >I've >> > > > seen ppl here on the list with 30k-50k users and I wonder how you >manage >> > > > to keep the mySQL server alive. >> > > > >> > > > We have about 10k clients. On our homepage there is a CGI program >that >> > > > checks your email the moment you login. >> > > > >> > > > Problems so far: >> > > > >> > > > The maximum connections to the mySQL server exceeds the limit, >causing >> > > > downtime on our mail- and web server as it depends on the same >mySQL >> > > > server. >> > > > >> > > > So, is there any way to keep the mySQL connections down while >keeping >> > > > a high uptime of web- and mail server? Anyone written a >proxy/wrapper >> > > > for mySQL to limit the number of connections to the real mySQL >server? >> > > > >> > > > Future setup: qmail + vpopmail with even higher number of users. >> > > > >> > > > Please advice >> > > > >> > > > Michael Boman >> > > > >> > > > PS >> > > > Having a separate mySQL servers for mail and web is not a option, as >> > > > it would give our CGI programs more to do and by that making >> > > > the web-server load too high... Plus it would be another server >> > > > to manage. >> > > > DS >> > > > >> > > > >> > > > -- >> > > > W I Z O F F I C E . C O M - Your Online Wizard >> > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 >> > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 >> > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com >> > > -- >> > > >> > > -- >> > > Eric Peters >> > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 >> > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] >> > > -- >> > >> > -- >> > W I Z O F F I C E . C O M - Your Online Wizard >> > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 >> > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 >> > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com >> -- >> >> -- >> Eric Peters >> I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 >> [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] >> -- >> > > >
Re: Segmentation fault in qmail log
That's a problem I can't find any core files on the system. Dave -- [EMAIL PROTECTED] David C. Maple V.P. Information Systems Advanced Communications Group 'The bigger it bloats, the harder it falls.' -- "The 48 Laws of Power" (R. Greene, J Elffers) On Tue, 21 Dec 1999, Dave Sill wrote: > "David C. Maple" <[EMAIL PROTECTED]> wrote: > > >Dec 21 09:41:31 zimba qmail: 945787291.119817 starting delivery 530: msg > >78810 to local [EMAIL PROTECTED] > >Dec 21 09:41:31 zimba qmail: 945787291.121236 status: local 1/10 remote > >0/20 > >Dec 21 09:41:31 zimba qmail: 945787291.259721 delivery 530: deferral: > >Segmentation_fault_-_core_dumped/ > > > >Does anyone have any idea what could be causing this? > > Looks like the message delivery agent (MDA) is dumping core. Find a > core dump and do "file core". That will tell you which program is > broken, and, if you're handy with a debugger, where and how. > > -Dave >
Re: Two questions: Return-Path rewriting and AUTH packets
On Mon, 20 Dec 1999, Mike van der Velden wrote: [snip] > Second, the firewall people have started to complain that ever since the > switch-over to qmail, they are seeing a lot of "auth" packets to and > from the qmail server to various remote sites. They want to know what > is going on. What sort of extra packets does qmail send out? Are some > of these "auth" communications initiated by outside systems? If you don't want tcpserver to do ident queries (you are using tcpserver, aren't you?), add the "-R" option. > If I've missed something in the FAQs or docs, I apologize. Please point > me in the right direction. > > Mike van der Velden > -- "Life is much too important to be taken seriously." Thomas Erskine<[EMAIL PROTECTED]>(613) 998-2836
Re: Segmentation fault in qmail log
"David C. Maple" <[EMAIL PROTECTED]> wrote: >Dec 21 09:41:31 zimba qmail: 945787291.119817 starting delivery 530: msg >78810 to local [EMAIL PROTECTED] >Dec 21 09:41:31 zimba qmail: 945787291.121236 status: local 1/10 remote >0/20 >Dec 21 09:41:31 zimba qmail: 945787291.259721 delivery 530: deferral: >Segmentation_fault_-_core_dumped/ > >Does anyone have any idea what could be causing this? Looks like the message delivery agent (MDA) is dumping core. Find a core dump and do "file core". That will tell you which program is broken, and, if you're handy with a debugger, where and how. -Dave
Re: Converting PMMail files to Maildir or mbox format
Subba Rao <[EMAIL PROTECTED]> wrote: > > $ file *.MSG > > I get the following output > > FKBOL40.MSG: RFC 822 mail text > FKOE9A0.MSG: RFC 822 mail text > FKQ6D20.MSG: RFC 822 mail text > FKU7OB0.MSG: RFC 822 mail text > FKVW7B0.MSG: ASCII text > FKXO320.MSG: RFC 822 mail text > FKXO370.MSG: RFC 822 mail text > > How do you convert these files into mbox or Maildir format? I want to be able > to read these messages using Mutt MUA. Well, if you're using qmail as your MTA, something like the following should be a quick 'n' dirty way to do it. Just set the two addresses in the script below to both be your local email address: #!/bin/bash for file in "$@" do qmail-inject -f [EMAIL PROTECTED] [EMAIL PROTECTED] <"$file" done Charles -- Charles Cazabon <[EMAIL PROTECTED]> Any opinions expressed are just that -- my opinions.
Segmentation fault in qmail log
In my maillog I get: Dec 21 09:41:31 zimba qmail: 945787291.119817 starting delivery 530: msg 78810 to local [EMAIL PROTECTED] Dec 21 09:41:31 zimba qmail: 945787291.121236 status: local 1/10 remote 0/20 Dec 21 09:41:31 zimba qmail: 945787291.259721 delivery 530: deferral: Segmentation_fault_-_core_dumped/ Dec 21 09:41:31 zimba qmail: 945787291.260009 status: local 0/10 remote 0/20 Dec 21 09:41:41 zimba qmail: 945787301.269991 starting delivery 531: msg 78808 to local [EMAIL PROTECTED] Dec 21 09:41:41 zimba qmail: 945787301.271411 status: local 1/10 remote 0/20 Dec 21 09:41:41 zimba qmail: 945787301.429934 delivery 531: deferral: Segmentation_fault_-_core_dumped/ Dec 21 09:41:41 zimba qmail: 945787301.431421 status: local 0/10 remote 0/20 Does anyone have any idea what could be causing this? Other messages are going through with no difficulty, but every couple of messages is this Seg-fault. I'm running qmail on FreeBSD 3.2. -- [EMAIL PROTECTED] David C. Maple V.P. Information Systems Advanced Communications Group 'The bigger it bloats, the harder it falls.' -- "The 48 Laws of Power" (R. Greene, J Elffers)
Re: Qmail is killing my mySQL server!
Sound like you need to look into mod_perl, mod_dbi so you can have persistant database connections for your server. Mike - Original Message - From: Eric Peters <[EMAIL PROTECTED]> To: Michael Boman <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, December 21, 1999 3:23 AM Subject: Re: Qmail is killing my mySQL server! > makes you think about that doesn't it > > you probably want to consult the mysql mailing list for perf tuning > > Eric > > On Tue, 21 Dec 1999, Michael Boman wrote: > > On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote: > > > its probably rather simple - your probably using the decaprecated mysql_connect > > > in the CGI possibly - rather than the mysql_real_connect api - > > > > > > well to be simpler than that make sure your majority of the connections are > > > connecting through teh mysql named pipe (the socket) rather than tcp/ip > > > connections > > > > > > Eric > > > > > > > Err.. It's on three different computers: Webserver, Mailserver, mySQL server. > > > > /Mike > > > > > On Mon, 20 Dec 1999, Michael Boman wrote: > > > > I am running following setup: > > > > > > > > qmail 1.03 + mysql patch > > > > tcpserver etc. > > > > > > > > Right now qmail is killing the mySQL database server with requests. I've > > > > seen ppl here on the list with 30k-50k users and I wonder how you manage > > > > to keep the mySQL server alive. > > > > > > > > We have about 10k clients. On our homepage there is a CGI program that > > > > checks your email the moment you login. > > > > > > > > Problems so far: > > > > > > > > The maximum connections to the mySQL server exceeds the limit, causing > > > > downtime on our mail- and web server as it depends on the same mySQL > > > > server. > > > > > > > > So, is there any way to keep the mySQL connections down while keeping > > > > a high uptime of web- and mail server? Anyone written a proxy/wrapper > > > > for mySQL to limit the number of connections to the real mySQL server? > > > > > > > > Future setup: qmail + vpopmail with even higher number of users. > > > > > > > > Please advice > > > > > > > > Michael Boman > > > > > > > > PS > > > > Having a separate mySQL servers for mail and web is not a option, as > > > > it would give our CGI programs more to do and by that making > > > > the web-server load too high... Plus it would be another server > > > > to manage. > > > > DS > > > > > > > > > > > > -- > > > > W I Z O F F I C E . C O M - Your Online Wizard > > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > > > -- > > > > > > -- > > > Eric Peters > > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > > > -- > > > > -- > > W I Z O F F I C E . C O M - Your Online Wizard > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > -- > > -- > Eric Peters > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > -- >
Converting PMMail files to Maildir or mbox format
I am in the process of moving my mail from a OS/2 box. The mail client here is PMMail. Each email is stored in a seperate file, like in Maildir. I have moved these files to linux, but cannot read them using Mutt to convert them to Maildir named files. The PMMail files are named in 7.3 format, which is like ABCXYZ1.MSG When I issue the command, $ file *.MSG I get the following output FKBOL40.MSG: RFC 822 mail text FKOE9A0.MSG: RFC 822 mail text FKQ6D20.MSG: RFC 822 mail text FKU7OB0.MSG: RFC 822 mail text FKVW7B0.MSG: ASCII text FKXO320.MSG: RFC 822 mail text FKXO370.MSG: RFC 822 mail text How do you convert these files into mbox or Maildir format? I want to be able to read these messages using Mutt MUA. Thank you in advance. Subba Rao [EMAIL PROTECTED] http://pws.prserv.net/truemax/ => Time is relative. Here is a new way to look at time. <= http://www.smcinnovations.com
Re: Problems running qmail
Cameron Arnott <[EMAIL PROTECTED]> wrote: >Sorry but this is a long message but it'll tell you everything about >how i have qmail setup Thanks. It's rare for someone to include all the necessary information in their initial problem report. :-) >[root@top supervise]# vdir -R >.: >total 3 >drwxrwxr-x 4 root root 1024 Dec 19 01:43 qmail-pop3d >drwxrwxr-x 4 root root 1024 Dec 19 01:43 qmail-send >drwxrwxr-x 4 root root 1024 Dec 19 01:43 qmail-smtpd > >qmail-pop3d: >total 3 >drwxrwxr-t 2 root root 1024 Dec 19 00:22 log >-rwxr-xr-x 1 root root 158 Dec 19 07:56 run >drwx-- 2 root root 1024 Dec 21 10:42 supervise As you know by now, the top-level subdirs should have the sticky bit set to enable the log subservice. You have the sticky bit set on the log subdirectly. Close, but no cigar. >[root@top qmail-pop3d]#cat run >exec /usr/local/bin/tcpserver 0 pop-3 /var/qmail/bin/qmail-popup >mail.kat.net.au \ >/bin/checkpassword /var/qmail/bin/qmail-pop3d Maildir 2>&1 & Remove the "&" from the end of the line. -Dave
Re: multilog not logging.. problem fixed
Cameron Arnott <[EMAIL PROTECTED]> wrote: >hi all just thought i'd let you know that i've found out why multilog >wasn't logging under supervise mode.. > >the dir >/var/qmail/supervise/ has to chowned to be sticky.. then the >multilog scriptt in /var/qmail/supervise//run will be run.. Not exactly. The directory has to be *chmod*'d to be sticky in order for svscan to start a supervise for the "log" subservice. >It's documented on >http://cr.yp.to/daemontools/svscan.html LWQ does include the necessary chmod commands: chmod +t /var/qmail/supervise/qmail-send chmod +t /var/qmail/supervise/qmail-smtpd -Dave
Re: tcpserver logging
"Keith Warno" <[EMAIL PROTECTED]> wrote: > tcpserver -v -u 7770 -g 2108 0 smtp /var/qmail/bin/qmail-smtpd \ > 2>&1 | /var/qmail/bin/splogger smtpd 3 & > >Um ok, the uid and gid are diff on my box :> So's the qmail path but other >than that it's a cut/paste and msgs are getting blurted out to the terminal. Odds are good that you're using a shell that doesn't use the "2>&1" syntax to redirect stderr to stdout. -Dave
Re: strange..
"Marc-Adrian Napoli" <[EMAIL PROTECTED]> wrote: >Anyone know how i could chase this up? Have you considered looking at the logs? -Dave
Re: anybody using smtp-auth with qmail ? (NOT smtp after pop)
Hello Olivier, I found your message in my qmail mailing list archive. Is the smtpd patch now working for you? I installed it, but it works only with the standard checkpassword. It doesn't work with checkvpw. To Bruce: checkvpw also does not work with smtp-auth perl scripts from Mrs. Brisby. So checkvpw have to be different from checkpassword. Smoerk On Fri, 12 Nov 1999 09:38:39 +0100, Olivier M. wrote: >Netscape & Outlook allow to setup a login/passwd pair for >smtp outgoing mails : I saw a kind of patch on http://www.nimh.org, but >I can't understand how it work : it doesn't call any "checkpasswd" program. > >Is anybody using this (or other smtp-auth) patch ? If possible with vmailmgrd.
RE: Compiling qmail on Solaris
>> Dec 17 16:10:17 host1 qmail: 945414617.771422 alert: unable >> to opendir mess/0, sleeping... > > The permissions of /var/qmail/queue/mess are :drwxr-x--- All right - I've just poked through the code to look at what causes that error, and I'm stumped ;>. At a wild guess, make sure that /var/qmail/bin/qmail-queue and /var/qmail/queue/mess/* are owned by the same user and group (qmaild:qmail, I think) and that qmail-queue is setuid. Anybody else have more light than I do? -- gowen -- Greg Owen -- [EMAIL PROTECTED]
qmail Digest 21 Dec 1999 11:00:01 -0000 Issue 856
qmail Digest 21 Dec 1999 11:00:01 - Issue 856 Topics (messages 34600 through 34655): Re: qmail appending mail machines name to recipients 34600 by: Alissa Rogers 34603 by: Dave Sill Re: Sendmail vs Qmail? 34601 by: Russell Nelson 34602 by: Timothy L. Mayo 34606 by: Dave Sill 34616 by: Sam 34620 by: vogelke.c17mis.region2.wpafb.af.mil Leaning more about Linux skills... 34604 by: Marvel Carvalho 34611 by: Derek Smith Re: How to control message ? 34605 by: Dave Sill Re: Why empty 34607 by: Greg Owen sending mail 34608 by: Stephan Weaver Continuing Virtual Domain Troubles... 34609 by: J Torres Re: systemload 34610 by: Roland Pelzer Re: Learning more about Linux skills. 34612 by: Peter Cavender 34622 by: Stephan Weaver Virtual Domain Problems 34613 by: J Torres 34614 by: Jonathan McDowell 34615 by: Chris Johnson 34634 by: J Torres Re: Here are your coupons 34617 by: Florian G. Pflug Re: Compiling qmail on Solaris 34618 by: Kristina 34635 by: Magnus Bodin charactor limitations in .qmail-blah? 34619 by: deeann mikula Re: Limit POP3 and SMTP service ! 34621 by: Ruben van der Leij Two questions: Return-Path rewriting and AUTH packets 34623 by: Mike van der Velden 34624 by: Adam McKenna 34631 by: Sam 34649 by: Jim Breton 34652 by: bert hubert 34653 by: Jim Breton Windows Mailing list 34625 by: qmail.col7.metta.lk 34626 by: Troy Frericks 34627 by: Derek Callaway 34628 by: Jim Breton 34629 by: Peter Cavender 34647 by: qmail.col7.metta.lk Problems running qmail 34630 by: Cameron Arnott 34633 by: Jim Gilliver 34636 by: Cameron Arnott 34637 by: Martin A. Brown 34644 by: Cameron Arnott Tidbit.. 34632 by: Philip Gabbert 34640 by: petervd.vuurwerk.nl Qmail is killing my mySQL server! 34638 by: Michael Boman 34641 by: Eric Peters 34642 by: Michael Boman 34643 by: Eric Peters 34646 by: Michael Boman 34648 by: Eric Peters 34650 by: Michael Boman 34655 by: Li Hong tcpserver logging 34639 by: Keith Warno multilog not logging.. problem fixed 34645 by: Cameron Arnott Save 50-80% on International Calls and Win $500 in Free phone calls! 34651 by: usayhello.earthlink.net strange.. 34654 by: Marc-Adrian Napoli Administrivia: To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To subscribe to the digest, e-mail: [EMAIL PROTECTED] To bug my human owner, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- At 05:05 PM 12/17/99 -0500, clifford thurber wrote: >Hello, >I made a post earlier to this list open a PERL program I have written which >basic opens one file handle ot a CSV file containing usernames and email >adresses parses them and then sends users mail by writing to a file handle >opened to qmail. Here is the snippet of code that achieves this: >Dec 16 14:39:23 ketel-1 qmail: 945373163.430257 starting delivery 20110: >msg 721 >291 to local [EMAIL PROTECTED]@snapper.raremedium.com We have the same problem here. Except that we use the same perl script for multiple domains, so the From: line changes. The only ones that seem to get the local domain tacked on are domains of 3 letters. This holds true for .co.uk domains as well (ie xxx.co.uk.) If anyone can come up with a reason, I'd love to hear it. Cheers, Alissa Rogers Systems Administrator Vardus Ltd. clifford thurber <[EMAIL PROTECTED]> wrote: >Dec 16 14:39:23 ketel-1 qmail: 945373163.430257 starting delivery 20110: >msg 721 >291 to local [EMAIL PROTECTED]@snapper.raremedium.com > >and then later on the logfile I will see the failure message with : > > Dec 16 14:43:21 ketel-1 qmail: 945373163.430257 delivery 20110: >failure: Sorry,_ >no_mailbox_here_by_that_name._(#5.1.1)/ What does qmail-showctl say? -Dave Sam writes: > Well, that's still 90% better than what Qmail does. And, with mailing > lists being managed in one place, that goes up to 100%. There is no > concept of a "workgroup" versus "enterprise" server. Think "university politics", and translate "workgroup" into "department". > Eliminate-dups is a solution in search of a problem. Duplicates due to > SMTP window failures are mostly theoretical than anything else. Nope. See RFC1047 ("Duplicate messages and SMTP.") Also see the quoted message from this very list over a year ago, and my response to it. > I'm not comfortable with the notion that the way to eliminate duplicates > with 100% certainty is, first, to generate a whole bunch of them, and then > to eliminate them on t
Re: Qmail is killing my mySQL server!
It's a common problem in the typical internet world,using Linux+Apache+Perl+mySQL+qmail I suggest you read perl.apache.org(assume ya using perl:-) there is a powerful module of Apache,mod_perl which using perl as a function module of Apache then use persist connection to mySql,say,thousands db queries using a single connection to mySQL server. the same way used before is FASTCGI but mod_perl is much more better. - Original Message - From: Michael Boman <[EMAIL PROTECTED]> To: Eric Peters <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, December 21, 1999 5:21 PM Subject: Re: Qmail is killing my mySQL server! > On Tue, Dec 21, 1999 at 01:10:06AM -0800, Eric Peters wrote: > > ever consider gigaethernet? : ) > > > > its possible to come up with a schema for persistant connections via the perl > > scripts/ named pipes and etc al as well so you don't have to create a new > > tcp/ip connection for each request/query etc but woudl rather use a connection > > that is already open - which would probably reduce alot of the load > > > > Eric > > Okey. Has anyone done a such application or know someone who has done it? > Please advice. > > And you guys who is having tons of users, what are you running? > > Best regards > > Michael Boman > > > > > On Tue, 21 Dec 1999, Michael Boman wrote: > > > On Tue, Dec 21, 1999 at 12:23:18AM -0800, Eric Peters wrote: > > > > makes you think about that doesn't it > > > > > > > > you probably want to consult the mysql mailing list for perf tuning > > > > > > > > Eric > > > > > > The problem isnt either the database server, it's fine tuned to the maximum. The > > > problem is that SMTP/POP3 is causing ALLOT of traffic to the database server. > > > > > > It wouldn't matter if we put Oracle or MS Sql instead, 'cause the traffic will >still > > > be there. What I am looking for is a way to slow down the queries, limit them >some how, > > > to the database server. > > > > > > > On Tue, 21 Dec 1999, Michael Boman wrote: > > > > > On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote: > > > > > > its probably rather simple - your probably using the decaprecated >mysql_connect > > > > > > in the CGI possibly - rather than the mysql_real_connect api - > > > > > > The CGI is written in Perl and uses the DBI modules. Each CGI script is running >as > > > a daemon. Nothing special about them that could cause this load, as the only >thing > > > is does is to do a POP3 connect to check if you have mail... > > > > > > > > > well to be simpler than that make sure your majority of the connections are > > > > > > connecting through teh mysql named pipe (the socket) rather than tcp/ip > > > > > > connections > > > > > > > > > > > > Eric > > > > > > > > > > > > > > > > Err.. It's on three different computers: Webserver, Mailserver, mySQL server. > > > > > > > > > > /Mike > > > > > > > > > > > On Mon, 20 Dec 1999, Michael Boman wrote: > > > > > > > I am running following setup: > > > > > > > > > > > > > > qmail 1.03 + mysql patch > > > > > > > tcpserver etc. > > > > > > > > > > > > > > Right now qmail is killing the mySQL database server with requests. I've > > > > > > > seen ppl here on the list with 30k-50k users and I wonder how you manage > > > > > > > to keep the mySQL server alive. > > > > > > > > > > > > > > We have about 10k clients. On our homepage there is a CGI program that > > > > > > > checks your email the moment you login. > > > > > > > > > > > > > > Problems so far: > > > > > > > > > > > > > > The maximum connections to the mySQL server exceeds the limit, causing > > > > > > > downtime on our mail- and web server as it depends on the same mySQL > > > > > > > server. > > > > > > > > > > > > > > So, is there any way to keep the mySQL connections down while keeping > > > > > > > a high uptime of web- and mail server? Anyone written a proxy/wrapper > > > > > > > for mySQL to limit the number of connections to the real mySQL server? > > > > > > > > > > > > > > Future setup: qmail + vpopmail with even higher number of users. > > > > > > > > > > > > > > Please advice > > > > > > > > > > > > > > Michael Boman > > > > > > > > > > > > > > PS > > > > > > > Having a separate mySQL servers for mail and web is not a option, as > > > > > > > it would give our CGI programs more to do and by that making > > > > > > > the web-server load too high... Plus it would be another server > > > > > > > to manage. > > > > > > > DS > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > W I Z O F F I C E . C O M - Your Online Wizard > > > > > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > > > > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > > > > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > > > > > > -- > > > > > > > > > > > > -- > > > > > > Eric Peters > > > > > > I Do: http://www.tekmetri
strange..
hi there.. we usually have a local queue that sits at about 10 and a remote queue that sits at 100 or so. This afternoon i realised that we were running out of space on our /mail partition. At the same time, I realised that i wasn't receiving any mail. I killed all qmail processes and started again... Then, strangely, our local/remote queue shot right up! We had 1500 in the local queue and 1000 in the remote queue.. At that point they started to settle down and now it is getting back to normal. Any ideas of what may have caused this? I checked both queues and all the messages in them seemed to be to various addresses, neither queue contained hundreds of the same mails. Anyone know how i could chase this up? Regards, Marc-Adrian Napoli Connect Infobahn Australia +61 2 92811750
Re: Two questions: Return-Path rewriting and AUTH packets
Yup... I'd already sent him a pvt msg detailing how to do that with tcpserver :) On Tue, 21 Dec 1999, bert hubert wrote: > And this can easily be turned off.
Re: Two questions: Return-Path rewriting and AUTH packets
On Tue, Dec 21, 1999 at 03:57:17AM -0500, Jim Breton wrote: > More specifically, it is probably tcpserver (or whatever superserver he's > running) that is causing the ident requests. And this can easily be turned off. Regards, bert hubert -- +---+ | http://www.rent-a-nerd.nl | nerd for hire | | +---+ | - U N I X - | | Inspice et cautus eris - D11T'95
Save 50-80% on International Calls and Win $500 in Free phone calls!
Save up to 80% on your INTERNATIONAL long distance phone bill. Join our easy-to-use callback service today for FREE. There are no monthly minimums, surcharges or set-up fees, just low flat rates 24 hours, everyday. Visit our website: http://home.earthlink.net/~usayhello/ and win $500 in FREE phone calls. HELLO MIDDLE EAST http://home.earthlink.net/~usayhello/ Email: [EMAIL PROTECTED] Sample our LOW rate chart below. To determine the rates add cost of country you are calling FROM to cost of country you are calling TO. Complete rate list available on our website. Prices are per minute in USD. Algeria 0.31 Australia0.08 Austria 0.12 Azerbaijan 0.42 Bahamas 0.18 Bahrain 0.41 Bangladesh 0.60 Bangladesh Dhaka0.49 Belgium 0.08 Brazil 0.28 Canada 0.06 Chile0.15 China0.32 Columbia 0.25 Cyprus 0.28 Czechoslovakia 0.28 Denmark 0.08 Djibouti 0.69 Dominican Rep. 0.17 Egypt0.59 Ethiopia 0.95 Finland 0.11 France 0.07 Georgia 0.46 Germany 0.06 Greece 0.25 Hong Kong 0.07 Hungary 0.23 India0.69 India New Delhi 0.66 India-Bomba 0.54 India-Madras 0.62 India-Bangalore 0.54 Indonesia0.35 Iran 0.58 Iraq 0.68 Ireland 0.09 Israel 0.13 Italy0.11 Japan0.09 Japan-Tokyo 0.08 Jordan 0.43 Kazakhstan 0.49 Kenya0.60 Kuwait 0.54 Kyrgyzstan 0.57 Lebanon 0.38 Liberia 0.43 Libya0.32 Malaysia 0.22 Malta0.17 Mauritania 0.66 Mexico 0.15 Morocco 0.42 Nepal0.83 Netherlands 0.07 New Zealand 0.09 Nigeria 0.69 Norway 0.11 Oman 0.47 Pakistan 0.58 Pakistan\Karachi 0.56 Philippines 0.26 Poland 0.25 Qatar0.46 Romania 0.37 Russia 0.31 Russia-Moscow0.12 Russia-St.Petersberg 0.22 Saudi Arabia0.62 Singapore Rep. 0.15 Somalia 0.68 South Africa0.34 South Korea 0.12 Spain0.11 Sri Lanka 0.74 Sudan0.43 Sweden 0.05 Switzerland 0.09 Syria0.51 Taiwan 0.14 Tajikistan 0.46 Tanzania 0.42 Thailand 0.35 Thailand bangkok 0.29 Tunisia 0.42 Turkey 0.31 Turkmenistan 0.54 Ukraine 0.29 United Arab Emirates0.30 United Kingdom 0.05 USA 0.05 Yemen0.63 HELLO MIDDLE EAST Hello Corp Hello Building 434 Sunrise Highway West Islip N.Y. 11795 Tel: 516-321-1204 Fax: 516-321-1758 Email: [EMAIL PROTECTED] http://home.earthlink.net/~usayhello/
Re: Qmail is killing my mySQL server!
On Tue, Dec 21, 1999 at 01:10:06AM -0800, Eric Peters wrote: > ever consider gigaethernet? : ) > > its possible to come up with a schema for persistant connections via the perl > scripts/ named pipes and etc al as well so you don't have to create a new > tcp/ip connection for each request/query etc but woudl rather use a connection > that is already open - which would probably reduce alot of the load > > Eric Okey. Has anyone done a such application or know someone who has done it? Please advice. And you guys who is having tons of users, what are you running? Best regards Michael Boman > > On Tue, 21 Dec 1999, Michael Boman wrote: > > On Tue, Dec 21, 1999 at 12:23:18AM -0800, Eric Peters wrote: > > > makes you think about that doesn't it > > > > > > you probably want to consult the mysql mailing list for perf tuning > > > > > > Eric > > > > The problem isnt either the database server, it's fine tuned to the maximum. The > > problem is that SMTP/POP3 is causing ALLOT of traffic to the database server. > > > > It wouldn't matter if we put Oracle or MS Sql instead, 'cause the traffic will >still > > be there. What I am looking for is a way to slow down the queries, limit them some >how, > > to the database server. > > > > > On Tue, 21 Dec 1999, Michael Boman wrote: > > > > On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote: > > > > > its probably rather simple - your probably using the decaprecated >mysql_connect > > > > > in the CGI possibly - rather than the mysql_real_connect api - > > > > The CGI is written in Perl and uses the DBI modules. Each CGI script is running as > > a daemon. Nothing special about them that could cause this load, as the only thing > > is does is to do a POP3 connect to check if you have mail... > > > > > > > well to be simpler than that make sure your majority of the connections are > > > > > connecting through teh mysql named pipe (the socket) rather than tcp/ip > > > > > connections > > > > > > > > > > Eric > > > > > > > > > > > > > Err.. It's on three different computers: Webserver, Mailserver, mySQL server. > > > > > > > > /Mike > > > > > > > > > On Mon, 20 Dec 1999, Michael Boman wrote: > > > > > > I am running following setup: > > > > > > > > > > > > qmail 1.03 + mysql patch > > > > > > tcpserver etc. > > > > > > > > > > > > Right now qmail is killing the mySQL database server with requests. I've > > > > > > seen ppl here on the list with 30k-50k users and I wonder how you manage > > > > > > to keep the mySQL server alive. > > > > > > > > > > > > We have about 10k clients. On our homepage there is a CGI program that > > > > > > checks your email the moment you login. > > > > > > > > > > > > Problems so far: > > > > > > > > > > > > The maximum connections to the mySQL server exceeds the limit, causing > > > > > > downtime on our mail- and web server as it depends on the same mySQL > > > > > > server. > > > > > > > > > > > > So, is there any way to keep the mySQL connections down while keeping > > > > > > a high uptime of web- and mail server? Anyone written a proxy/wrapper > > > > > > for mySQL to limit the number of connections to the real mySQL server? > > > > > > > > > > > > Future setup: qmail + vpopmail with even higher number of users. > > > > > > > > > > > > Please advice > > > > > > > > > > > > Michael Boman > > > > > > > > > > > > PS > > > > > > Having a separate mySQL servers for mail and web is not a option, as > > > > > > it would give our CGI programs more to do and by that making > > > > > > the web-server load too high... Plus it would be another server > > > > > > to manage. > > > > > > DS > > > > > > > > > > > > > > > > > > -- > > > > > > W I Z O F F I C E . C O M - Your Online Wizard > > > > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > > > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > > > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > > > > > -- > > > > > > > > > > -- > > > > > Eric Peters > > > > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > > > > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > > > > > -- > > > > > > > > -- > > > > W I Z O F F I C E . C O M - Your Online Wizard > > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > > > -- > > > > > > -- > > > Eric Peters > > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > > > -- > > > > -- > > W I Z O F F I C E . C O M - Your Online Wizard > > 16 Tannery Lane, Cr
Re: Tidbit..
On Mon, Dec 20, 1999 at 09:59:18PM -0700, Philip Gabbert wrote: > > I was looking over the Qmail homepage and I found that you can create a > rcpthosts file with the following shell command: > > sed 's/:.*//' rcpthosts > > by Russ Nelson. This is pretty kewl, incase you all didn't know, but one > thing was wrong. > One: I'm ordered and sorted my virtualdomains file in a matter I like. > Two: It picked up my address: [EMAIL PROTECTED] - Not needed in rcpthosts. > > So, I did a little change to it: > >sed 's/^[^@]*@//' | cat - locals >rcpthosts > (line wrapped due to email max line length) > > This will filter out everything in front of and including the @. The only > bug I see in this one liner is that if you have multiple [EMAIL PROTECTED] > addresses, it will place multiple myhost.com lines. > It's a bug I won't mind hearing how to fix, but it won't affect how qmail > runs. Without having tested your line: replacing the second line with ' | cat - locals | sort -u > rcpthosts' should do the job. Greetz, Peter. -- Peter van Dijk - student/sysadmin/ircoper/womanizer/pretending coder | | 'C makes it easy to shoot yourself in the foot; | C++ makes it harder, but when you do it blows your whole leg off.' | Bjarne Stroustrup, Inventor of C++
tcpserver logging
Hi all. 0230 am, and I decide to move our mx server's qmail smtpd invocation from inetd to tcpserver. Wise choice eh? Seems to be performance jump thus far (judging from the few msgs I have sent thru it). All seems well tho I can't seem to figure out why things are getting logged to my terminal rather than to a log file somewhere. >From the qmail FAQ (5.1): By default, tcpserver allows at most 40 simultaneous qmail-smtpd processes. To raise this limit to 400, use tcpserver -c 400. To keep track of who's connecting and for how long, run (on two lines) tcpserver -v -u 7770 -g 2108 0 smtp /var/qmail/bin/qmail-smtpd \ 2>&1 | /var/qmail/bin/splogger smtpd 3 & Um ok, the uid and gid are diff on my box :> So's the qmail path but other than that it's a cut/paste and msgs are getting blurted out to the terminal. I suspect that it's simply really late, my brain is no longer functioning, and there's something funky with my /etc/syslog.conf; any thoughts wopuld be appreciated. To be honest I have no idea what facility 3 is (second arg to splogger); at any sane hour of the day I probably would PS -- it's a SuSE 6.2 box but not necessarily stock :> qmail v1.03 tcpserver and company, v0.84 Thanks /* ** Keith Warno ** Make Us An Offer, Inc. ** Real-Time Online Haggling ** http://www.makeusanoffer.com/ */
Re: Qmail is killing my mySQL server!
makes you think about that doesn't it you probably want to consult the mysql mailing list for perf tuning Eric On Tue, 21 Dec 1999, Michael Boman wrote: > On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote: > > its probably rather simple - your probably using the decaprecated mysql_connect > > in the CGI possibly - rather than the mysql_real_connect api - > > > > well to be simpler than that make sure your majority of the connections are > > connecting through teh mysql named pipe (the socket) rather than tcp/ip > > connections > > > > Eric > > > > Err.. It's on three different computers: Webserver, Mailserver, mySQL server. > > /Mike > > > On Mon, 20 Dec 1999, Michael Boman wrote: > > > I am running following setup: > > > > > > qmail 1.03 + mysql patch > > > tcpserver etc. > > > > > > Right now qmail is killing the mySQL database server with requests. I've > > > seen ppl here on the list with 30k-50k users and I wonder how you manage > > > to keep the mySQL server alive. > > > > > > We have about 10k clients. On our homepage there is a CGI program that > > > checks your email the moment you login. > > > > > > Problems so far: > > > > > > The maximum connections to the mySQL server exceeds the limit, causing > > > downtime on our mail- and web server as it depends on the same mySQL > > > server. > > > > > > So, is there any way to keep the mySQL connections down while keeping > > > a high uptime of web- and mail server? Anyone written a proxy/wrapper > > > for mySQL to limit the number of connections to the real mySQL server? > > > > > > Future setup: qmail + vpopmail with even higher number of users. > > > > > > Please advice > > > > > > Michael Boman > > > > > > PS > > > Having a separate mySQL servers for mail and web is not a option, as > > > it would give our CGI programs more to do and by that making > > > the web-server load too high... Plus it would be another server > > > to manage. > > > DS > > > > > > > > > -- > > > W I Z O F F I C E . C O M - Your Online Wizard > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > > -- > > > > -- > > Eric Peters > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > > -- > > -- > W I Z O F F I C E . C O M - Your Online Wizard > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com -- -- Eric Peters I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] --
Re: Qmail is killing my mySQL server!
On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote: > its probably rather simple - your probably using the decaprecated mysql_connect > in the CGI possibly - rather than the mysql_real_connect api - > > well to be simpler than that make sure your majority of the connections are > connecting through teh mysql named pipe (the socket) rather than tcp/ip > connections > > Eric > Err.. It's on three different computers: Webserver, Mailserver, mySQL server. /Mike > On Mon, 20 Dec 1999, Michael Boman wrote: > > I am running following setup: > > > > qmail 1.03 + mysql patch > > tcpserver etc. > > > > Right now qmail is killing the mySQL database server with requests. I've > > seen ppl here on the list with 30k-50k users and I wonder how you manage > > to keep the mySQL server alive. > > > > We have about 10k clients. On our homepage there is a CGI program that > > checks your email the moment you login. > > > > Problems so far: > > > > The maximum connections to the mySQL server exceeds the limit, causing > > downtime on our mail- and web server as it depends on the same mySQL > > server. > > > > So, is there any way to keep the mySQL connections down while keeping > > a high uptime of web- and mail server? Anyone written a proxy/wrapper > > for mySQL to limit the number of connections to the real mySQL server? > > > > Future setup: qmail + vpopmail with even higher number of users. > > > > Please advice > > > > Michael Boman > > > > PS > > Having a separate mySQL servers for mail and web is not a option, as > > it would give our CGI programs more to do and by that making > > the web-server load too high... Plus it would be another server > > to manage. > > DS > > > > > > -- > > W I Z O F F I C E . C O M - Your Online Wizard > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > -- > > -- > Eric Peters > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > -- -- W I Z O F F I C E . C O M - Your Online Wizard 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 email : [EMAIL PROTECTED]URL : http://www.wizoffice.com
Re: Two questions: Return-Path rewriting and AUTH packets
On Tue, 21 Dec 1999, Sam wrote: > The "return path" is specified solely by MUA, so this is entirely a Pegasus > Mail configuration issue. It is possible that other mail servers take it > upon themselves to rewrite the return address, but they should not really > do that, and it's none of their jobs. Whoa, are you sure about that? I don't think this is correct. Seems to me that the smtp daemon writes the header. Maybe there are some cases where the client supplies one... but I don't think you can flat out say it's not the MTA. Here's a snippet from the qmail-local man page: The message's envelope sender is sender. qmail-local records sender in a new Return-Path header field. Now I know that's not the MTA but rather the MDA. But that does go to show that it's not solely the client that can be responsible for the Return-Path line. Also, I know this for a fact: when I use the qmail "sendmail" binary to send mail from pine, it writes my local user account's name into the Return-Path header. I had to set pine to deliver via smtp to the local qmail-smtpd in order to force it to accept the client-supplied "From" address as the Return-Path. > Additionally, refusing to accept mail for this reason is rather dumb, Agreed. ;) > Qmail sends an ident (or auth) packets in response to any incoming More specifically, it is probably tcpserver (or whatever superserver he's running) that is causing the ident requests.
Re: Qmail is killing my mySQL server!
ever consider gigaethernet? : ) its possible to come up with a schema for persistant connections via the perl scripts/ named pipes and etc al as well so you don't have to create a new tcp/ip connection for each request/query etc but woudl rather use a connection that is already open - which would probably reduce alot of the load Eric On Tue, 21 Dec 1999, Michael Boman wrote: > On Tue, Dec 21, 1999 at 12:23:18AM -0800, Eric Peters wrote: > > makes you think about that doesn't it > > > > you probably want to consult the mysql mailing list for perf tuning > > > > Eric > > The problem isnt either the database server, it's fine tuned to the maximum. The > problem is that SMTP/POP3 is causing ALLOT of traffic to the database server. > > It wouldn't matter if we put Oracle or MS Sql instead, 'cause the traffic will still > be there. What I am looking for is a way to slow down the queries, limit them some >how, > to the database server. > > > On Tue, 21 Dec 1999, Michael Boman wrote: > > > On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote: > > > > its probably rather simple - your probably using the decaprecated mysql_connect > > > > in the CGI possibly - rather than the mysql_real_connect api - > > The CGI is written in Perl and uses the DBI modules. Each CGI script is running as > a daemon. Nothing special about them that could cause this load, as the only thing > is does is to do a POP3 connect to check if you have mail... > > > > > well to be simpler than that make sure your majority of the connections are > > > > connecting through teh mysql named pipe (the socket) rather than tcp/ip > > > > connections > > > > > > > > Eric > > > > > > > > > > Err.. It's on three different computers: Webserver, Mailserver, mySQL server. > > > > > > /Mike > > > > > > > On Mon, 20 Dec 1999, Michael Boman wrote: > > > > > I am running following setup: > > > > > > > > > > qmail 1.03 + mysql patch > > > > > tcpserver etc. > > > > > > > > > > Right now qmail is killing the mySQL database server with requests. I've > > > > > seen ppl here on the list with 30k-50k users and I wonder how you manage > > > > > to keep the mySQL server alive. > > > > > > > > > > We have about 10k clients. On our homepage there is a CGI program that > > > > > checks your email the moment you login. > > > > > > > > > > Problems so far: > > > > > > > > > > The maximum connections to the mySQL server exceeds the limit, causing > > > > > downtime on our mail- and web server as it depends on the same mySQL > > > > > server. > > > > > > > > > > So, is there any way to keep the mySQL connections down while keeping > > > > > a high uptime of web- and mail server? Anyone written a proxy/wrapper > > > > > for mySQL to limit the number of connections to the real mySQL server? > > > > > > > > > > Future setup: qmail + vpopmail with even higher number of users. > > > > > > > > > > Please advice > > > > > > > > > > Michael Boman > > > > > > > > > > PS > > > > > Having a separate mySQL servers for mail and web is not a option, as > > > > > it would give our CGI programs more to do and by that making > > > > > the web-server load too high... Plus it would be another server > > > > > to manage. > > > > > DS > > > > > > > > > > > > > > > -- > > > > > W I Z O F F I C E . C O M - Your Online Wizard > > > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > > > > -- > > > > > > > > -- > > > > Eric Peters > > > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > > > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > > > > -- > > > > > > -- > > > W I Z O F F I C E . C O M - Your Online Wizard > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > > -- > > > > -- > > Eric Peters > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > > -- > > -- > W I Z O F F I C E . C O M - Your Online Wizard > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com -- -- Eric Peters I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] --
Re: Windows Mailing list
On Mon, Dec 20, 1999 at 08:03:29PM -0600, Troy Frericks wrote: Hi Troy, > Totally inappropriate question, you knew it, and still posted? What a > waste of band width. Please take my apology. > Did you try yahoo, altavista, hotbot, aj, webcrawler, or a host of other > web search engines? I searched on the web for 6 hours and got nothing of any use. I have had very much help from the Linux platform and perhaps this might help me also. (sorry for the flames it caused) > Did you know that microsoft has special licensing which makes these > products "cheap" to hardware vendors as an incentive to included them with > the hardware sale? Buy a new pentinum, and they will "throw in" > windows/office (includes word). Yes I am aware of that, and perhaps someone running Linux on a PC might sell his license to me. > BTW, why the hurry to run out and buy just licenses? I am a Buddhist monk, and my daily duty is to encourage persons not to "kill" "steal" etc. so how can I run unlicensed software (double morals, isn't it) I run a number of "free mail servers" in Sri Lanka, all of them have Linux and qmail, but we also need Windows as most persons are only used to Windows. Sri Lanka is not a very rich country and we cannot afford very much, that is how I am thinking of buying some second hand licensed software. People are upgrading to other systems. Many persons on Linux machines would have licenses, and would perhaps sell them to me. Perhaps others could put me onto some place where I could get it without having to pay for New Software. Please drop me a line if you can help. All I need is a Original CD and the License documents No books etc. Again my apology for this on this list. Best regards Jacob > # > > At 05:56 PM 12/20/99 , [EMAIL PROTECTED] wrote: > >Hi all, > > > >I am sorry to present a Non qmail on this list. > >I need a few Windows Mailing lists. > > > >Purpose: I need to find out where to buy > >some cheap licenses for Windows/Word/Office etc. > > > >Thank you for tolerating this on this list > >Jacob -- Random Dhammapada Verse 173 Whosoever, by a good deed, covers the evil done, such a one illuminates this world like the moon freed from clouds.
Re: Qmail is killing my mySQL server!
On Tue, Dec 21, 1999 at 12:23:18AM -0800, Eric Peters wrote: > makes you think about that doesn't it > > you probably want to consult the mysql mailing list for perf tuning > > Eric The problem isnt either the database server, it's fine tuned to the maximum. The problem is that SMTP/POP3 is causing ALLOT of traffic to the database server. It wouldn't matter if we put Oracle or MS Sql instead, 'cause the traffic will still be there. What I am looking for is a way to slow down the queries, limit them some how, to the database server. > On Tue, 21 Dec 1999, Michael Boman wrote: > > On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote: > > > its probably rather simple - your probably using the decaprecated mysql_connect > > > in the CGI possibly - rather than the mysql_real_connect api - The CGI is written in Perl and uses the DBI modules. Each CGI script is running as a daemon. Nothing special about them that could cause this load, as the only thing is does is to do a POP3 connect to check if you have mail... > > > well to be simpler than that make sure your majority of the connections are > > > connecting through teh mysql named pipe (the socket) rather than tcp/ip > > > connections > > > > > > Eric > > > > > > > Err.. It's on three different computers: Webserver, Mailserver, mySQL server. > > > > /Mike > > > > > On Mon, 20 Dec 1999, Michael Boman wrote: > > > > I am running following setup: > > > > > > > > qmail 1.03 + mysql patch > > > > tcpserver etc. > > > > > > > > Right now qmail is killing the mySQL database server with requests. I've > > > > seen ppl here on the list with 30k-50k users and I wonder how you manage > > > > to keep the mySQL server alive. > > > > > > > > We have about 10k clients. On our homepage there is a CGI program that > > > > checks your email the moment you login. > > > > > > > > Problems so far: > > > > > > > > The maximum connections to the mySQL server exceeds the limit, causing > > > > downtime on our mail- and web server as it depends on the same mySQL > > > > server. > > > > > > > > So, is there any way to keep the mySQL connections down while keeping > > > > a high uptime of web- and mail server? Anyone written a proxy/wrapper > > > > for mySQL to limit the number of connections to the real mySQL server? > > > > > > > > Future setup: qmail + vpopmail with even higher number of users. > > > > > > > > Please advice > > > > > > > > Michael Boman > > > > > > > > PS > > > > Having a separate mySQL servers for mail and web is not a option, as > > > > it would give our CGI programs more to do and by that making > > > > the web-server load too high... Plus it would be another server > > > > to manage. > > > > DS > > > > > > > > > > > > -- > > > > W I Z O F F I C E . C O M - Your Online Wizard > > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > > > -- > > > > > > -- > > > Eric Peters > > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > > > -- > > > > -- > > W I Z O F F I C E . C O M - Your Online Wizard > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 > > email : [EMAIL PROTECTED]URL : http://www.wizoffice.com > -- > > -- > Eric Peters > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745 > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED] > -- -- W I Z O F F I C E . C O M - Your Online Wizard 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778 Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228 email : [EMAIL PROTECTED]URL : http://www.wizoffice.com
multilog not logging.. problem fixed
hi all just thought i'd let you know that i've found out why multilog wasn't logging under supervise mode.. the dir /var/qmail/supervise/ has to chowned to be sticky.. then the multilog scriptt in /var/qmail/supervise//run will be run.. It's documented on http://cr.yp.to/daemontools/svscan.html whew.. 2 probs down 1 to go.. stopping the supervised pop3d from running twice
Re: Problems running qmail
Doh.. (utter embarasement) thanks for pointout my spelling mistakes.. thats fixed up the realying.. (i feel so stupid.. been looking at these darn files for days and never picked them up.. i've also fixedup the spelling in the multilog for loging the send however it still puts the log info to the console not the logdir's listes below.. and the qmail-pop3d is still starting up twice.. it is working thougn.. just the second starting of it just keeps restarting because its already running.. when i do a /etc/rc.d/init.d/qmail stop the first evoking still running . i kill that task and nothing is then running and then i start up qmail again and the same thing.. it runs the pop3 deamon twice.. [root@top qmail]# vdir total 2 drwxrwxr-x 2 qmaill nofiles 1024 Dec 19 04:50 qmail.pop3d drwxrwxr-x 2 qmaill nofiles 1024 Dec 19 01:55 qmail.smtpd [root@top qmail]# "Martin A. Brown" wrote: > Cameron, > > If this is actually a from your xterm, it looks like you have a > problem in your tcp.smtp file. > > Look at the environment variable. > REALYCLIENT="" > I think you mean > RELAYCLIENT="" > > Try that for a solution to problem number 1. > > For problem 3, it appears (I didn't look closely at what was going on in > your scripts), that you have a spelling error in miultilog. > > Come back to the list if you still have troubles, > > -Martin > > -- > Martin A. Brown --- Wonderfrog Enterprises --- [EMAIL PROTECTED] > > On Tue, 21 Dec 1999, Cameron Arnott wrote: > > -->Hi, Here I go again.. > -->I know i had it working before but can't remember how.. > -->As far as i know i have everything set up ok. and the same as before > --> > -->First i'll state my problems then my setup > --> > --> > -->Problem1 : user on 10.0.0.21 can send mail to @kat.net.au > -->but not to @ > --> > --> however i can from the server.. (if i couldn't you > -->wouldn't be reading this message) > --> > -->Problem 2 : a prob with the pop3d starting 2 copies.. help with this > -->would also be appreciated > -->Sorry but this is a long message but it'll tell you everything about > -->how i have qmail setup > -->I read and used LWQ as the base and tried to follow it as much as i > -->could > --> > -->Problem 3: qmail and tcpserver not logging to the logfiles its going to > -->the console instead > --> > --> > -->Any help would be appreciated.. oh BTW merry christmas everyone and best > -->seasons greetings > --> > -->My setup > -->(tried to follow LWQ as close as i could.. using the mandrake linix6.0 > -->dist. with sendmail,procmaail and postfix uninstalled) > --> > -->here are my setup files etc... > --> > -->my /var/qmail/control files > --> > -->[root@top control]# vdir > -->total 5 > -->-rw-r--r-- 1 root root 11 Dec 15 21:54 defaultdomain > -->-rw-r--r-- 1 root root 11 Dec 21 10:23 locals > -->-rw-r--r-- 1 root root 11 Dec 19 03:18 me > -->-rw-r--r-- 1 root root7 Dec 15 21:54 plusdomain > -->-rw-r--r-- 1 root root 11 Dec 21 10:22 rcpthosts > -->[root@top control]# cat defaultdomain > -->kat.net.au > -->[root@top control]# cat locals > -->kat.net.au > -->[root@top control]# cat me > -->kat.net.au > -->[root@top control]# cat plusdomain > -->net.au > -->[root@top control]# cat rcpthosts > -->kat.net.au > -->[root@top control]# > --> > -->my /etc/tcp.smtp file > --> > -->[root@top qmail]# cd /etc > -->[root@top /etc]# cat tcp.smpt > -->cat: tcp.smpt: No such file or directory > -->[root@top /etc]# cat tcp.smtp > -->127.0.0.1:allow,RELAYCLIENT="" > -->10.0.0.1:allow,REALYCLIENT="" > -->10.0.0.21:allow,REALYCLIENT="" > -->10.0.0.22:allow,REALYCLIENT="" > -->10.0.0.23:allow,REALYCLIENT="" > -->10.0.0.31:allow,REALYCLIENT="" > -->203.87.57.227:allow,RELAYCLIENT="" > -->[root@top /etc]# > --> > -->my /etc/rc.d/init.d/qmail file > --> > -->#! /bin/sh > --> > -->PATH=/var/qmail/bin:/usr/local/bin:/usr/bin:/bin > -->export PATH > --> > -->case "$1" in > -->start) > -->echo -n "Starting qmail: svscan" > -->cd /var/qmail/supervise > -->env - PATH="$PATH" svscan & > -->echo $! > /var/run/svscan.pid > -->echo "." > -->;; > -->stop) > -->echo -n "Stopping qmail: svscan" > -->kill `cat /var/run/svscan.pid` > -->echo -n " qmail" > -->svc -dx /var/qmail/supervise/* > -->echo -n " logging" > -->svc -dx /var/qmail/supervise/*/log > -->echo "." > -->;; > -->stat) > -->cd /var/qmail/supervise > -->svstat * */log > -->;; > -->doqueue|alrm) > -->echo "Sending ALRM signal to qmail-send." > -->svc -a /var/qmail/supervise/qmail-send > -->;; > -->queue) > -->qmail-qstat > -->qmail-qread > -->;; > -->reload|hup) > -->echo "Sending HUP signal to qmail-send." > -->svc -h /var/qmail/supervise/qmail-send > -->;; >