[vchkpw] -help
Re: [vchkpw] SQL data
Thanx Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 "The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse." - Original Message - From: "Scott Helms" <[EMAIL PROTECTED]> To: "Rudi Ahlers" <[EMAIL PROTECTED]> Cc: "VpopMail" <[EMAIL PROTECTED]> Sent: Wednesday, July 30, 2003 4:26 PM Subject: Re: [vchkpw] SQL data Rudi, Here is the base way of doing it without any data. mysqldump -d DATABASENAME > backup-file.sql You can read this back into MySQL with: mysql DATABASENAME < backup-file.sql Check here for more options for mysqldump: http://www.mysql.com/doc/en/mysqldump.html Scott Helms On Mon, 2001-07-30 at 09:20, Rudi Ahlers wrote: > I know this is not entirely an SQL mailing list, but how do I dump only my > database table layout? I don't want a dump of all the data > > > Kind Regards > Rudi Ahlers > Océ Software Support > +27 (11) 661-9000 > > "The basic difference between an ordinary man and a warrior is that a > warrior takes everything as a challenge while an ordinary man takes > everything either as a blessing or a curse." >
[vchkpw] SQL data
I know this is not entirely an SQL mailing list, but how do I dump only my database table layout? I don't want a dump of all the data Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 "The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse."
Re: [vchkpw] tcpserver: fatal: unable to bind: address already used
Have you checked your /etc/inetd for anything starting with SMTP? Hash it out, and restart inetd. That will probably solve the "tcpserver: fatal: unable to bind: address already used", if you have an SMTP server running from there. Else, kill sendmail / postfix / exim if it apprears in "ps ax" Regarding your second question, depending on the platform used, you can "cp /var/qmail/bin/maildir /var/qmail/rc && /var/qmail/rc start" Goto /var/qmaill/docs/ and checkout the README.* files, to see which file from /var/qmail/bin you want to use. - Original Message - From: "Javier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 11:42 AM Subject: [vchkpw] tcpserver: fatal: unable to bind: address already used Hi I've installed qmail following "Lfe with qmail" and vpopmail with the scripts that allow roaming users to use our smtp server without opening the machine up to everyone on the internet. Now I've the subject error. I guess it's produced because qmail supervise is running from the original "Life with qmail" configuration. How could avoid supervise to start or how could I use FAQ scripts with supervise to avoid to receive subject error in /var/qmail/log/smtpd/current and pop3d/current ? Thanks in advance !
[vchkpw] routing of outgoing messages
Hi again I hope someone can shed some light on this topic. I have an ISDN dailup connection, with a FBDS + qmail + vpopmail + mysql box on my LAN. When I send emails to local users, all is fine. But, when I send email to www.webmail.co.za, I get the following message: Knocky qmail: 1059263981.990167 delivery 7: deferral: Connected_to_196.35.40.11_but_greeting_failed./Remote_ho st_said:_553_Your_IP_address_196.22.188.100_is_blackholed_by_dnsbl.njabl.org ._/ My internal LAN is on the 192.168.0.0 IP range, and I send email to my server (192.168.0.250), which then directly sends it out on the net. Is there a way to deliver local mail locally, and all other mail to my upstream ISP? As per the FAQ, I have to add my upstream mail server address, and then disable local delivery (hash it out in /etc/inetd), but then it doesn't run at all. Any ideas? Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 "The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse."
Re: [vchkpw] Big server
urity bug or sucks up all available CPU on the server? I generally shy away from this scenario. - At one site, I implemented a batch processing system. Mail would be "delivered" by vdelivermail program into a user's mail spool on the central storage server. The user would not be able to run any filters on inbound mail. By "delivered", I mean that the message would exist in ~user/Maildir/tmp/MESSAGE#. I would have vdelivermail stop before moving the message into the "new" subdirectory and instead append the message delivery information to a file that got rolled every minute. After a periodic delay of at least one minute, another program on the storage server would look at the list of new messages and serially process them through user-controlled filers (a jailed perl script). The customers are given some knobs for tuning (spam score threshold, sender address, recipient address, content search) and the filtering program would apply them to each batched message for final delivery. In final delivery, the message is moved into "~user/Maildir/new" or "~user/Maildir/junk" or some user-specified CourierIMAP folder. The MySql database contains a list of user preferences for their mail filtering with this program. The message is optionally tagged by the filter with "spam" in case a POP user wants to use that subject tag for filtering in their outlook mail client. The web mail and POP and IMAP servers are simply scalable via NFS: - Platform: up to 1GHz, 1GB RAM, single-disk PCs ($200) or more PCs similar to the inbound relays. - User vpopmail directories are seen via an NFS mount of the central mail storage server. - Install user-based web services (eg: pop3d, imapd, apache, sqwebmail), and SSL wrappers. Note: The nubmer of simultaneous sessions depends most upon available RAM. More sessions -> more RAM. - This server could also be the outbound SMTP server for users. One could take the POP logs and use them for POP-before-SMTP authentication, or the qmail-smtpd service could be configured for SMTP-auth with queries against the cenral MySQL server on the mail storage server. With multiple servers, SMTP-auth works better, but it is possible to create a summary of POP traffic on all servers to build a central POP-before-SMTP database. Scaling: - The database and storage server must be reliable. This server is not linearly scalable, but if properly designed, one can process a significant amount of storage before needing to upgrade. To scale this out to multiple servers, one needs a way of hashing/routing inbound mail to the correct storage server - think of how "vdominfo -d" or "vuserinfo -d" or /var/qmail/users/access are used by vdelivermail/qmail and how one might be able to use symlinks to point users into different NFS mounts. Adding a user or domain becomes more complicated if one can't use a single directory tree for their mail storage. - The mail filtering servers must have good CPU, but don't need to be reliable. They are linearly scalable. - The client access processors don't need to be reliable if you have some method for failover (IP address takeover, LVS) or load balancing (Alteon, Foundry, BigIP, etc). They are linearly scalable. Outbound smtp works better with a local "dnscache" DNS resolver (http://cr.yp.to/djbdns) than a local nameserver on the network. This is an example that can service 2+ users well. One could decide to scale the single database/storage server with some sort of server redundancy, or create clusters of cheaper storage/database servers paired with relay/access servers. One would need a method, though, of managing accounts across multiple clusters. Scaling to 100 users or more would involve commercial storage systems (eg: Celerra or NetApp), load balancers (eg: Alteon), hashing users or domains into multiple clusters of access servers and storage/database managers, and custom scripting to manage the creation and removal of domains and users. One might also start looking at the cost/benefit of commercial software packages when dealing with large user bases. "Life With Qmail" is your friend: http://LifewithQmail.org . "Qmail-Scanner" is a good beginning Virus/Spam integration tool for Qmail - http://qmail-scanner.sourceforge.net/ . Hi Can you pleas explain to me how you got the whole procmail thing to work? I have qmail+ Maildir, and vpopmail setup, yet I cannot redirect mail comming in for any other user except the default user who downloads the pop3 ETRN email. Please help? Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 "The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse."
[vchkpw] Accepting mail for localhost, when using virtual domains
Hi again This whole Virtual Domain thing is rather new to me, so I hope you have patience with me. My default local domain is set to tradeleads.co.za, but the machine my virtual domain runs on is knocky.tradeleads.co.za. How do I accept local emails? i.e, email sent to root / local system users? Email generated from crontab / at / logs / etc?--Kind RegardsRudi AhlersTradeleads IT Director 27 (80( 926 1689
Re: Re: [vchkpw] maildrop account on Virtual Domains
Hi Thanx for the suggestion, but this doesn't seem to work in my case, since I have Maildir mailbox'es. The question I have with fetchmail is, I have a multidrop pop account, which I download via fetchmail. This account can take @domain, and this is where the problem lies. I want to be able to filter say @domain, and forward that to the user Pete. And this is where I got stuck--Kind RegardsRudi AhlersTradeleads IT Director 27 (80( 926 1689--- Original Message From: "Peter Palmreuther" <[EMAIL PROTECTED]>To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>CC: Subject: Re: [vchkpw] maildrop account on Virtual DomainsDate: 23/07/03 01:07Hi Rudi,On Wed, 23 Jul 2003 12:47:59 Rudi wrote:> Hi>> Can someone please tell me howto do this? If I have a domain, with one main> account, and 10 mailboxes, how do I tell it that everything except for the> 10 mailboxes must goto the main account?Change '~vpopmail/domains//.qmail-default' with a text editorfrom "|/path/to/vdelivermail '' bounce-no-mailbox" to"|/path/to/vdelivermail '' /Full/path/to/a/vpopmail/user/directory",e.g."|/home/vpopmail/bin/vdelivermail ''/home/vpopmail/domains/example.com/mainuser"> And then, how would this setup work if I had fetchmail running as well Fetchmail injects to MTA and MTA decides how to deliver.Above setup tells MTA (qmail) and MDA (vpopmail) what to do, what shouldfetchmail have to know about this catch-all?P.S.: For future mails to this list you really should disable "Reply-To".1.) It's superfluous. It contains the same address as "From" andtherefore is absolutely useless.2.) It makes it impossible to easily reply to the list for those MUAscapable of List-Reply by evaluating 'List-Post' header.'Reply-To' takes, for obvious reasons, precedence over'List-Post'.Thank you.--Ciao,Pit
[vchkpw] maildrop config
Does anyone know if maildrop can be used to filter mail for all virtual users on a domain? I have a dialup account, which I download @domain for, but now I want to filter it, so that @domain will point to [EMAIL PROTECTED], and @domain will point to [EMAIL PROTECTED] Can this be done? -- Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 "The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse."
[vchkpw] Fw: redirecting email using fetchmail
Hi I have an account with my upstream ISP, which accepts any mail in the form of [EMAIL PROTECTED] (i.e. [EMAIL PROTECTED] / [EMAIL PROTECTED] / [EMAIL PROTECTED] - all will work), I download the mail using fetchmail, and I've setup vpopmail, and qmail+mysql on my LAN. On my LAN, I can setup virtual domains and virtual users for the domains. What I would like to know is, how can I forward email downloaded via fetchmail, that was sent to [EMAIL PROTECTED] to [EMAIL PROTECTED], yet, [EMAIL PROTECTED] must goto [EMAIL PROTECTED], and [EMAIL PROTECTED] to [EMAIL PROTECTED] ? I looked at procmail, but this doesn't seem to work since I have Maildir format mailboxes, and all the users are virtual users, they don't really exist in /etc/passwd Any help / pointers are appreciated Kind Regards Rudi Ahlers "The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse."
[vchkpw] redirecting email using fetchmail
Hi I have an account with my upstream ISP, which accepts any mail in the form of [EMAIL PROTECTED] (i.e. [EMAIL PROTECTED] / [EMAIL PROTECTED] / [EMAIL PROTECTED] - all will work), I download the mail using fetchmail, and I've setup vpopmail, and qmail+mysql on my LAN. On my LAN, I can setup virtual domains and virtual users for the domains. What I would like to know is, how can I forward email downloaded via fetchmail, that was sent to [EMAIL PROTECTED] to [EMAIL PROTECTED], yet, [EMAIL PROTECTED] must goto [EMAIL PROTECTED], and [EMAIL PROTECTED] to [EMAIL PROTECTED] ? I looked at procmail, but this doesn't seem to work since I have Maildir format mailboxes, and all the users are virtual users, they don't really exist in /etc/passwd Any help / pointers are appreciated Kind Regards Rudi Ahlers "The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse."