[vchkpw] Vpopmail 5.4.5 released
http://vpopmail.sf.net Release Notes: There are significant changes in here for MySQL and Postgres backends. If you had problems with Postgres and roaming users, you should definitely upgrade. If you've had errors stating "couldn't create table/database because it already exists" with MySQL, you should definitely upgrade. ChangeLog: fernando (at) telemacro (dot) com (dot) br - Patch for vpgsql.c fixes bug with Postgres and roaming users (POP before SMTP). [895501] Françoi Wautier - Fix method used to open database in vauth_open_update of vmysql.c. [967994, 946983] Pit Palme - Show 'delete' as valid option to vdelivermail in docs. [951245] rstml - Hide error message during POP3 auth with Postgres. [915485] Tom Collins - Fix `vuserinfo -l` output, based on Bill Shupp's patch (moved code to a single function call). [961742]
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
At 01:41 PM 6/25/2004, Ken Jones wrote: On Friday 25 June 2004 02:40 pm, Paul Theodoropoulos wrote: > At 12:33 PM 6/25/2004, Ken Jones wrote: > >What you can do is keep the original data, then update and add a domain. > >If it doesn't work, put the old data back. It only is used when adding > > domains not users. > > thanks. so my speculation that the 'dom_89' user is sort of a > 'master' field for such things is correct? Yep! It controls just the domain directory layout. dom_89 is short for "domain_directory_layout_user_id_89" since 89 was reserved for vpopmail by one of the *nix distributions . excellent! i tried it, it works - many thanks. now all i have to do is figure out how to get the two existing domains i had to create for customers that are still under the '5' subdir to be under '1'. i can't find any way to do it besides deleting and re-creating the domains, which isn't exactly elegant... Paul Theodoropoulos http://www.anastrophe.com
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
On Friday 25 June 2004 03:41 pm, Ken Jones wrote: > On Friday 25 June 2004 02:40 pm, Paul Theodoropoulos wrote: > > At 12:33 PM 6/25/2004, Ken Jones wrote: > > >What you can do is keep the original data, then update and add a domain. > > >If it doesn't work, put the old data back. It only is used when adding > > > domains not users. > > > > thanks. so my speculation that the 'dom_89' user is sort of a > > 'master' field for such things is correct? > > Yep! It controls just the domain directory layout. > dom_89 is short for "domain_directory_layout_user_id_89" > since 89 was reserved for vpopmail by one of the *nix distributions . I believe it was freebsd. Gentoo Linux comes with a vpopmail user by default, of 89: kitchen ~ # id vpopmail uid=89(vpopmail) gid=89(vpopmail) groups=89(vpopmail) -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
On Friday 25 June 2004 02:40 pm, Paul Theodoropoulos wrote: > At 12:33 PM 6/25/2004, Ken Jones wrote: > >What you can do is keep the original data, then update and add a domain. > >If it doesn't work, put the old data back. It only is used when adding > > domains not users. > > thanks. so my speculation that the 'dom_89' user is sort of a > 'master' field for such things is correct? Yep! It controls just the domain directory layout. dom_89 is short for "domain_directory_layout_user_id_89" since 89 was reserved for vpopmail by one of the *nix distributions . > > i'll give this a try. and i'll be using phpMyadmin - thanks to the guys for > the various suggestions for running it. (i'm doing two layers of security - > first a .htaccess allowing only my home machine, and, when i'm not using > phpmyadmin - which is most of the time - i just chmod the phpmyadmin > directory. that's about as secure as you can get, i'd say!) > > > > > > >there is no domain dom_89, which suggests to me this may be the > > > > > > 'master control' for what overflow subdirectory is to be used - > > > > > > it's the only record that has '5' for the value 'the_dir', and > > > > > > '89' is the vpopmail uid/gid. > > > > > > > > > > > >however, i'm reluctant to make changes to the record, for fear of, > > > > > > well, duh - completely destroying my setup with one bad > > > > > > keystroke. > > > > > > > > > > > >so, if anyone can confirm my speculations, and suggest how to fix > > > > > > it (that's right, i've never inserted data manually into a > > > > > > table!), i'd appreciate the help. > > > > > > > > > > Paul Theodoropoulos > > > > > http://www.anastrophe.com > > > > > > Paul Theodoropoulos > > > http://www.anastrophe.com > > Paul Theodoropoulos > http://www.anastrophe.com
Re: [vchkpw] Migration from MySQL to CDB Files
On Jun 25, 2004, at 12:26 PM, Rick Macdougall wrote: How are you running both qscanq and qmail-spamc ? I modified qmail-spamc.c to run qmail-queue-real instead of qmail-queue. It's also modified to not run spamc if RELAYCLIENT is set -- this way, mail sent by my users is not scanned. I renamed /var/qmail/bin/qmail-queue to qmail-queue-real. I built qscanq, but I don't think I installed it. I have QMAILQUEUE set in my qmail-smtpd/run script: export QMAILQUEUE='/package/mail/qscanq/command/qscanq' So, qmail-smtpd runs qscanq (since QMAILQUEUE is set), qscanq runs /var/qmail/bin/qmail-queue (which is actually my qmail-spamc) which in turn runs spamc and the real qmail-queue. You can download my modified qmail-spamc.c here: http://tomlogic.com/qmail/qmail-spamc.c -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
At 12:33 PM 6/25/2004, Ken Jones wrote: What you can do is keep the original data, then update and add a domain. If it doesn't work, put the old data back. It only is used when adding domains not users. thanks. so my speculation that the 'dom_89' user is sort of a 'master' field for such things is correct? i'll give this a try. and i'll be using phpMyadmin - thanks to the guys for the various suggestions for running it. (i'm doing two layers of security - first a .htaccess allowing only my home machine, and, when i'm not using phpmyadmin - which is most of the time - i just chmod the phpmyadmin directory. that's about as secure as you can get, i'd say!) > > > >there is no domain dom_89, which suggests to me this may be the > > > > 'master control' for what overflow subdirectory is to be used - it's > > > > the only record that has '5' for the value 'the_dir', and '89' is the > > > > vpopmail uid/gid. > > > > > > > >however, i'm reluctant to make changes to the record, for fear of, > > > > well, duh - completely destroying my setup with one bad keystroke. > > > > > > > >so, if anyone can confirm my speculations, and suggest how to fix it > > > >(that's right, i've never inserted data manually into a table!), i'd > > > >appreciate the help. > > > > > > Paul Theodoropoulos > > > http://www.anastrophe.com > > Paul Theodoropoulos > http://www.anastrophe.com Paul Theodoropoulos http://www.anastrophe.com
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
On Friday 25 June 2004 12:07 pm, Paul Theodoropoulos wrote: > indeed, but i can't take that risk without knowing the specific details for > sure. this is a production system with thousands of customers. > > would Bill Shupp possibly know? I wrote the code. Bill might know. What you can do is keep the original data, then update and add a domain. If it doesn't work, put the old data back. It only is used when adding domains not users. Also, if you have a different machine for testing, add domains until it starts adding to the /0/ directory, and use those settings. Ken > > At 10:00 AM 6/25/2004, Ken Jones wrote: > >It might be as simple as changing the two "5" entries to "0" > >which from your listing below looks like the level_index0 and the_dir > > columns > > > >Ken Jones > > > >On Friday 25 June 2004 11:23 am, Paul Theodoropoulos wrote: > > > sooo - nobody knows where the directory 'incrementer' lives? Tom? i > > > have no fix? i'm stuck with going from > > > > > > /u1/domains/0/abc.com to > > > /u1/domains/5/def.com > > > > > > ?? no way to get the system to resume creating new domains under the > > > more logical /u1/domains/1/def.com? > > > > > > i mean, yeah - i can live with it. it's not affecting actual > > > functionality. > > > > > > At 12:16 PM 6/23/2004, Paul Theodoropoulos wrote: > > > >well, now it's incremented up to '5'. eesh. what i've found in > > > > perusing the mysql backend db, is the following: > > > > > > > >mysql> select * from dir_control where domain = 'dom_89'; > > > >++---+---+---+--+- > > > > > > > > -+--+++++ > > > >- > > > > ---++--+--+--+--- > > > >- -+ > > > > > > > >| domain | cur_users | level_cur | level_max | level_start0 | > > > >| level_start1 level_start2 | level_end0 | level_end1 | level_end2 | > > > >| level_mod0 | > > > > > > > >level_mod1 | level_mod2 | level_index0 | level_index1 | level_index2 | > > > >the_dir | > > > >++---+---+---+--+- > > > > > > > > -+--+++++ > > > >- > > > > ---++--+--+--+--- > > > >- -+ > > > > > > > >| dom_89 | 201 | 0 | 3 |0 | > > > >| 0 0 | 61 | 61 | 61 | 0 2 | > > > >| 4 |5 |0 |0 | > > > > > > > >5 | > > > >++---+---+---+--+- > > > > > > > > -+--+++++ > > > >- > > > > ---++--+--+--+--- > > > >- -+ 1 row in set (0.00 sec) > > > > > > > > > > > >there is no domain dom_89, which suggests to me this may be the > > > > 'master control' for what overflow subdirectory is to be used - it's > > > > the only record that has '5' for the value 'the_dir', and '89' is the > > > > vpopmail uid/gid. > > > > > > > >however, i'm reluctant to make changes to the record, for fear of, > > > > well, duh - completely destroying my setup with one bad keystroke. > > > > > > > >so, if anyone can confirm my speculations, and suggest how to fix it > > > >(that's right, i've never inserted data manually into a table!), i'd > > > >appreciate the help. > > > > > > Paul Theodoropoulos > > > http://www.anastrophe.com > > Paul Theodoropoulos > http://www.anastrophe.com
Re: [vchkpw] smtp-auth on separate server queries vpopmail -mysql
Ron Culler wrote: I'm and having difficulty setting up a separate qmail server as a smtp-auth server. (* Its being done to provide inbound virus scanning prior to the message being delivered to the local mailbox) I have successfully setup Qmail and can get smtp-auth to work with checkpassword and the local shadow users. I installed vpopmail enabling roaming users, and mysql-auth. I then set the vpopmail.mysql file to use the DB on my main vpopmail server. I can see it connect but it returns an incorrect password response for the user and then sends the email. My question is can vpopmail provide this type of functionality? If not has anyone seen something that can? I want to be able to have smtp-auth query the vpopmail user DB. Thanks Ron Culler this works great. the only think to do is to mirror the /var/qmail/users dir to the auth server. then your users can auth against your mainserver regards mandy
Re: [vchkpw] OT: Using rblsmtpd and postmaster still receiving mail from all (even blacklisted) hosts
Jeremy Kitchen wrote: On Friday 25 June 2004 08:19 am, Jasper Metselaar wrote: I use rblsmtpd to block mail from hosts that are listed on some blacklists, but I would like to keep my postmaster address(es) ([EMAIL PROTECTED]) receiving mail from all other hosts, even if they are listed on blacklists. Is there a way to achieve this? I give them a hint to use my Website to contact me. Therfor you have to patch rblsmtp for using own retrun messages. regards mandy
Re: [vchkpw] Migration from MySQL to CDB Files
Tom Collins wrote: On Jun 25, 2004, at 11:54 AM, Jorge Valdes wrote: I would replace qmail-scanner 1.21 with qmail-spamc (for SpamAssassin processing) and qscanq (for ClamAV virus filtering). You would eliminate the Perl overhead of Qmail-Scanner and block incoming viruses at the qmail-smtpd level (cuts down on bounce message generation). I have been extremely happy with the results. Hi, How are you running both qscanq and qmail-spamc ? Regards, Rick
Re: [vchkpw] Migration from MySQL to CDB Files
On Jun 25, 2004, at 11:54 AM, Jorge Valdes wrote: I am running qmail-scanner 1.21, spamassassin 2.63(spamd), clamav 0.70, File::Scan 1.15, also I have patched tcpserver to deny connections if the load average is greater than 12 or more than 5 connections from the same IP address. This alleviated the problem temporarily. I would replace qmail-scanner 1.21 with qmail-spamc (for SpamAssassin processing) and qscanq (for ClamAV virus filtering). You would eliminate the Perl overhead of Qmail-Scanner and block incoming viruses at the qmail-smtpd level (cuts down on bounce message generation). I have been extremely happy with the results. My knowledge of process accounting is limited, otherwise I'd try to recommend something that could report on how much processor time and swapping was caused by different programs. If you don't have a lot of account adds/deletes/password-changes, then I'd think that going to CDB would be a good solution. You'll cut down on the memory overhead of MySQL connections, and looking up users in the CDB file should have a lower overhead. What's the maximum number of users you have in a domain? -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] Migration from MySQL to CDB Files
At 10:57 AM 25/06/2004, Greg Kopp wrote: I doubt this is a MySQL problem. We are using MySQL in several environments, including vpopmail. My guess is I don't have as many users as you, since I set my pop3 concurency at 30 with no problems. Are you running qmail-scanner or spamassassin? These added quite a bit of load to my mail server (dual 2.8 Xeons, 2GB RAM) but it still averages at around 0.3 for the 5min average. It will spike if Razor is slow to respond or one of our customers does a blast e-mail to thier client base. You can try and put MySQL on a seperate server and just have vpopmail connect to the external database and see if that solves any load problems. BTW, What versions are you running? I cannot add more RAM to the server.. :( I am running qmail-scanner 1.21, spamassassin 2.63(spamd), clamav 0.70, File::Scan 1.15, also I have patched tcpserver to deny connections if the load average is greater than 12 or more than 5 connections from the same IP address. This alleviated the problem temporarily. I have gathered the following average daily stats: 438 IMAP connections0 Rejects due to load/maxip 28708 POP3 connections 308 Rejects due to load/maxip 7355 SMTP connections 128 Rejects due to load/maxip Bloquing: 10 Emails due to policy reasons 2923 Emails due to Virus 595 Emails due to Spam > 15.0 pts. 39.4% spam/ham ratio Each instance of mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686) uses PID USER PR NI VIRT RES SHR S %CPU %MEM TIME COMMAND 1055 mysql 9 0 14500 9376 1152 S 0.0 1.8 4:28 mysqld So when there are several concurrent POP3 connections, another instance of mysql is spawned to query the DB. I think this is whats bringing the server to its knees... In any case, has anyone done a MySQL to CDB migration? -- Jorge Valdes IT Manager Intercom El Salvador [EMAIL PROTECTED] Tel. 503-278-5068 Tel. 503-265-7070 Fax. 503-265-7025
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
indeed, but i can't take that risk without knowing the specific details for sure. this is a production system with thousands of customers. would Bill Shupp possibly know? At 10:00 AM 6/25/2004, Ken Jones wrote: It might be as simple as changing the two "5" entries to "0" which from your listing below looks like the level_index0 and the_dir columns Ken Jones On Friday 25 June 2004 11:23 am, Paul Theodoropoulos wrote: > sooo - nobody knows where the directory 'incrementer' lives? Tom? i have no > fix? i'm stuck with going from > > /u1/domains/0/abc.com to > /u1/domains/5/def.com > > ?? no way to get the system to resume creating new domains under the more > logical /u1/domains/1/def.com? > > i mean, yeah - i can live with it. it's not affecting actual functionality. > > At 12:16 PM 6/23/2004, Paul Theodoropoulos wrote: > >well, now it's incremented up to '5'. eesh. what i've found in perusing > >the mysql backend db, is the following: > > > >mysql> select * from dir_control where domain = 'dom_89'; > >++---+---+---+--+- > >-+--+++++- > >---++--+--+--+ > >-+ > > > >| domain | cur_users | level_cur | level_max | level_start0 | level_start1 > >| level_start2 | level_end0 | level_end1 | level_end2 | level_mod0 | > > > >level_mod1 | level_mod2 | level_index0 | level_index1 | level_index2 | > >the_dir | > >++---+---+---+--+- > >-+--+++++- > >---++--+--+--+ > >-+ > > > >| dom_89 | 201 | 0 | 3 |0 |0 > >|0 | 61 | 61 | 61 | 0 > >| 2 | 4 |5 |0 |0 | > > > >5 | > >++---+---+---+--+- > >-+--+++++- > >---++--+--+--+ > >-+ 1 row in set (0.00 sec) > > > > > >there is no domain dom_89, which suggests to me this may be the 'master > >control' for what overflow subdirectory is to be used - it's the only > >record that has '5' for the value 'the_dir', and '89' is the vpopmail > > uid/gid. > > > >however, i'm reluctant to make changes to the record, for fear of, well, > >duh - completely destroying my setup with one bad keystroke. > > > >so, if anyone can confirm my speculations, and suggest how to fix it > >(that's right, i've never inserted data manually into a table!), i'd > >appreciate the help. > > Paul Theodoropoulos > http://www.anastrophe.com Paul Theodoropoulos http://www.anastrophe.com
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
It might be as simple as changing the two "5" entries to "0" which from your listing below looks like the level_index0 and the_dir columns Ken Jones On Friday 25 June 2004 11:23 am, Paul Theodoropoulos wrote: > sooo - nobody knows where the directory 'incrementer' lives? Tom? i have no > fix? i'm stuck with going from > > /u1/domains/0/abc.com to > /u1/domains/5/def.com > > ?? no way to get the system to resume creating new domains under the more > logical /u1/domains/1/def.com? > > i mean, yeah - i can live with it. it's not affecting actual functionality. > > At 12:16 PM 6/23/2004, Paul Theodoropoulos wrote: > >well, now it's incremented up to '5'. eesh. what i've found in perusing > >the mysql backend db, is the following: > > > >mysql> select * from dir_control where domain = 'dom_89'; > >++---+---+---+--+- > >-+--+++++- > >---++--+--+--+ > >-+ > > > >| domain | cur_users | level_cur | level_max | level_start0 | level_start1 > >| level_start2 | level_end0 | level_end1 | level_end2 | level_mod0 | > > > >level_mod1 | level_mod2 | level_index0 | level_index1 | level_index2 | > >the_dir | > >++---+---+---+--+- > >-+--+++++- > >---++--+--+--+ > >-+ > > > >| dom_89 | 201 | 0 | 3 |0 |0 > >|0 | 61 | 61 | 61 | 0 > >| 2 | 4 |5 |0 |0 | > > > >5 | > >++---+---+---+--+- > >-+--+++++- > >---++--+--+--+ > >-+ 1 row in set (0.00 sec) > > > > > >there is no domain dom_89, which suggests to me this may be the 'master > >control' for what overflow subdirectory is to be used - it's the only > >record that has '5' for the value 'the_dir', and '89' is the vpopmail > > uid/gid. > > > >however, i'm reluctant to make changes to the record, for fear of, well, > >duh - completely destroying my setup with one bad keystroke. > > > >so, if anyone can confirm my speculations, and suggest how to fix it > >(that's right, i've never inserted data manually into a table!), i'd > >appreciate the help. > > Paul Theodoropoulos > http://www.anastrophe.com
Re: [vchkpw] Migration from MySQL to CDB Files
I doubt this is a MySQL problem. We are using MySQL in several environments, including vpopmail. My guess is I don't have as many users as you, since I set my pop3 concurency at 30 with no problems. Are you running qmail-scanner or spamassassin? These added quite a bit of load to my mail server (dual 2.8 Xeons, 2GB RAM) but it still averages at around 0.3 for the 5min average. It will spike if Razor is slow to respond or one of our customers does a blast e-mail to thier client base. You can try and put MySQL on a seperate server and just have vpopmail connect to the external database and see if that solves any load problems. BTW, What versions are you running? On Fri, 25 Jun 2004 09:53:35 -0600, Jorge Valdes <[EMAIL PROTECTED]> wrote: > > Hi, > > I have been having problems with resouce utilization with one of my qmail > servers, which basically boils down to reaching the concurrencylimit of > tcpserver for my pop3 connections (60) and this brings the server to its > knees. The only recourse I have left is to reboot, since even console is > not responsive. > > I have checked my logs, and basically, for each pop3 connection, an > instance of mysql is generated to check password for a virtual domain user, > this generates swapping. The load average shoots up to 300 and I have seen > this go as high as 500. > > The server is running Linux RedHat 7.3 and has 512MB RAM and 1GB SWAP, for > about 4000 users in 70 virtual domains. It also runs Apache for qmailadmin. > Since there are not that many users per domain, less than 100 average, will > CDB Files be a better solution to this problem? > > Currently running vpopmail 5.3.19 and qmailadmin 1.0.15 > > > -- > Jorge Valdes > IT Manager > Intercom El Salvador > [EMAIL PROTECTED] > >
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
On Jun 25, 2004, at 9:23 AM, Paul Theodoropoulos wrote: sooo - nobody knows where the directory 'incrementer' lives? Tom? i have no fix? i'm stuck with going from /u1/domains/0/abc.com to /u1/domains/5/def.com ?? no way to get the system to resume creating new domains under the more logical /u1/domains/1/def.com? i mean, yeah - i can live with it. it's not affecting actual functionality. That's one area of code that I haven't looked at. I really don't know how vpopmail decides where to put new domains. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] ack, major problem! numbered subdir incremented too high
sooo - nobody knows where the directory 'incrementer' lives? Tom? i have no fix? i'm stuck with going from /u1/domains/0/abc.com to /u1/domains/5/def.com ?? no way to get the system to resume creating new domains under the more logical /u1/domains/1/def.com? i mean, yeah - i can live with it. it's not affecting actual functionality. At 12:16 PM 6/23/2004, Paul Theodoropoulos wrote: well, now it's incremented up to '5'. eesh. what i've found in perusing the mysql backend db, is the following: mysql> select * from dir_control where domain = 'dom_89'; ++---+---+---+--+--+--+++++++--+--+--+-+ | domain | cur_users | level_cur | level_max | level_start0 | level_start1 | level_start2 | level_end0 | level_end1 | level_end2 | level_mod0 | level_mod1 | level_mod2 | level_index0 | level_index1 | level_index2 | the_dir | ++---+---+---+--+--+--+++++++--+--+--+-+ | dom_89 | 201 | 0 | 3 |0 |0 |0 | 61 | 61 | 61 | 0 | 2 | 4 |5 |0 |0 | 5 | ++---+---+---+--+--+--+++++++--+--+--+-+ 1 row in set (0.00 sec) there is no domain dom_89, which suggests to me this may be the 'master control' for what overflow subdirectory is to be used - it's the only record that has '5' for the value 'the_dir', and '89' is the vpopmail uid/gid. however, i'm reluctant to make changes to the record, for fear of, well, duh - completely destroying my setup with one bad keystroke. so, if anyone can confirm my speculations, and suggest how to fix it (that's right, i've never inserted data manually into a table!), i'd appreciate the help. Paul Theodoropoulos http://www.anastrophe.com
Re: [vchkpw] Migration from MySQL to CDB Files
On Jun 25, 2004, at 8:53 AM, Jorge Valdes wrote: I have been having problems with resouce utilization with one of my qmail servers, which basically boils down to reaching the concurrencylimit of tcpserver for my pop3 connections (60) and this brings the server to its knees. The only recourse I have left is to reboot, since even console is not responsive. What happens if you set concurrencylimit to 30? Are people checking their email too often? Is the problem that the POP3 users take a long time to download their email (on dialup)? I have checked my logs, and basically, for each pop3 connection, an instance of mysql is generated to check password for a virtual domain user, this generates swapping. The load average shoots up to 300 and I have seen this go as high as 500. Are you sure there isn't something else happening on the machine that pushes the load up? The server is running Linux RedHat 7.3 and has 512MB RAM and 1GB SWAP, for about 4000 users in 70 virtual domains. It also runs Apache for qmailadmin. Since there are not that many users per domain, less than 100 average, will CDB Files be a better solution to this problem? Can this machine work with more memory? You could add another 512M or even 1G of RAM and alleviate the problem. I'm sorry, but I don't know whether switching to CDB will help with your problem. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
[vchkpw] Migration from MySQL to CDB Files
Hi, I have been having problems with resouce utilization with one of my qmail servers, which basically boils down to reaching the concurrencylimit of tcpserver for my pop3 connections (60) and this brings the server to its knees. The only recourse I have left is to reboot, since even console is not responsive. I have checked my logs, and basically, for each pop3 connection, an instance of mysql is generated to check password for a virtual domain user, this generates swapping. The load average shoots up to 300 and I have seen this go as high as 500. The server is running Linux RedHat 7.3 and has 512MB RAM and 1GB SWAP, for about 4000 users in 70 virtual domains. It also runs Apache for qmailadmin. Since there are not that many users per domain, less than 100 average, will CDB Files be a better solution to this problem? Currently running vpopmail 5.3.19 and qmailadmin 1.0.15 -- Jorge Valdes IT Manager Intercom El Salvador [EMAIL PROTECTED]
Re: [vchkpw] qmail & mysql
On Friday 25 June 2004 09:10 am, Nick Harring wrote: > I must agree with Jeremy, with one small caveat. Absolutely do not > attempt this with the MySQL 3.23.x branch. When replication breaks (in > my 6 server setup it breaks about once a month on one server, so not bad > at all), the ability to execute "load data from master; start slave;" is > very, very worth while. I've never gotten that to work anyways. I bounce the master server a few times, clear out some binlogs and then tar up the mysql directory and copy it over ... *shrug* :) -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
Re: [vchkpw] OT: Using rblsmtpd and postmaster still receiving mail from all (even blacklisted) hosts
On Friday 25 June 2004 08:19 am, Jasper Metselaar wrote: > I use rblsmtpd to block mail from hosts that are listed on some > blacklists, but I would like to keep my postmaster address(es) > ([EMAIL PROTECTED]) receiving mail from all other hosts, even if > they are listed on blacklists. Is there a way to achieve this? not without modification to rblsmtpd. but otherwise, yes, totally possible. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
Re: [vchkpw] OT: Using rblsmtpd and postmaster still receiving mail from all (even blacklisted) hosts
One would hope that they would be smart enough to possibly use a different mail server or service at that point, like yahoo, hotmail, or soon for most, gmail. Greg On Fri, 25 Jun 2004 16:18:31 +0200 (CEST), Jasper Metselaar <[EMAIL PROTECTED]> wrote: > > > >> Hi, > >> > >> I know this is not a vpopmail question, but I looked everywhere (I > >> also tried the qmail mailing list, but haven't received a reply > >> there. :-() to find an answer to this question and hopefully you > >> can help me with this (or at least guide me in the right > >> direction). > >> Okay, here is my question: > >> > >> I use rblsmtpd to block mail from hosts that are listed on some > >> blacklists, but I would like to keep my postmaster address(es) > >> ([EMAIL PROTECTED]) receiving mail from all other hosts, even > >> if they are listed on blacklists. Is there a way to achieve this? > > > > Hi, > > > > Since rblsmtpd works before the smtpd connection even occurs, it is > > not possible to allow email through to a specific account. > > > > Regards, > > > > Rick > > Thanks Rick, I was afraid for that. :-( > I was looking for a way to allow people to be able to reach me when > they are blocked, so I can explain why they are blocked and help them > to solve it if needed. To bad that rblsmtpd has no option to skip > checking when mail is addressed to a specific address > - Jasper > >
Re: [vchkpw] OT: Using rblsmtpd and postmaster still receiving mail from all (even blacklisted) hosts
>> Hi, >> >> I know this is not a vpopmail question, but I looked everywhere (I >> also tried the qmail mailing list, but haven't received a reply >> there. :-() to find an answer to this question and hopefully you >> can help me with this (or at least guide me in the right >> direction). >> Okay, here is my question: >> >> I use rblsmtpd to block mail from hosts that are listed on some >> blacklists, but I would like to keep my postmaster address(es) >> ([EMAIL PROTECTED]) receiving mail from all other hosts, even >> if they are listed on blacklists. Is there a way to achieve this? > > Hi, > > Since rblsmtpd works before the smtpd connection even occurs, it is > not possible to allow email through to a specific account. > > Regards, > > Rick Thanks Rick, I was afraid for that. :-( I was looking for a way to allow people to be able to reach me when they are blocked, so I can explain why they are blocked and help them to solve it if needed. To bad that rblsmtpd has no option to skip checking when mail is addressed to a specific address - Jasper
Re: [vchkpw] qmail & mysql
Title: Re: [vchkpw] qmail & mysql On Thu, 2004-06-24 at 17:22, Jeremy Kitchen wrote: > On Thursday 24 June 2004 05:08 pm, [EMAIL PROTECTED] wrote: > > We run eight qmail servers with one main server that stores the > client data > > and acts as the main mysql server. We have a backup server to the > main > > server that replicates the mysql DBs. The six additional qmail > servers > > connect to these servers as the mysql server. The primary mysql > server > > performs all queries that make changes to the DBs and the backup > server > > executes all select queries. I am wondering if we are better off > > replicating the mysql DBs to each qmail server (six of them) and > performing > > the sql select queries locally rather than over the network. > > it's a little more headache to administer the mysql stuff, but > definitely a > better setup. I've done this with several customers and it works > fine. > > -Jeremy > > -- > Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet > Technologies, Inc. > [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 > int'l > kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail > I must agree with Jeremy, with one small caveat. Absolutely do not attempt this with the MySQL 3.23.x branch. When replication breaks (in my 6 server setup it breaks about once a month on one server, so not bad at all), the ability to execute "load data from master; start slave;" is very, very worth while. Overall though the architecture you're suggesting, and Jeremy and I have both setup, is absolutely the best for a setup like yours. Hope that helps, Nick Harring
Re: [vchkpw] OT: Using rblsmtpd and postmaster still receiving mail from all (even blacklisted) hosts
Jasper Metselaar wrote: Hi, I know this is not a vpopmail question, but I looked everywhere (I also tried the qmail mailing list, but haven't received a reply there. :-() to find an answer to this question and hopefully you can help me with this (or at least guide me in the right direction). Okay, here is my question: I use rblsmtpd to block mail from hosts that are listed on some blacklists, but I would like to keep my postmaster address(es) ([EMAIL PROTECTED]) receiving mail from all other hosts, even if they are listed on blacklists. Is there a way to achieve this? Hi, Since rblsmtpd works before the smtpd connection even occurs, it is not possible to allow email through to a specific account. Regards, Rick
[vchkpw] OT: Using rblsmtpd and postmaster still receiving mail from all (even blacklisted) hosts
Hi, I know this is not a vpopmail question, but I looked everywhere (I also tried the qmail mailing list, but haven't received a reply there. :-() to find an answer to this question and hopefully you can help me with this (or at least guide me in the right direction). Okay, here is my question: I use rblsmtpd to block mail from hosts that are listed on some blacklists, but I would like to keep my postmaster address(es) ([EMAIL PROTECTED]) receiving mail from all other hosts, even if they are listed on blacklists. Is there a way to achieve this? Thanks in advance! Kind regards, Jasper
Re: [vchkpw] Authentication
Hello Anuradha, On Fri, 25 Jun 2004 03:21:28 -0700 UTC, Anuradha Kalyan wrote: AK> where do u think the authorization is not happening. What program are you using to authenticate? If you're using vpopmail, you should use vchkpw. Check your run script for your pop3 daemon. -- Regards, Charles.
Re: [vchkpw] Authentication
thanks charles, but i am still not able to sort the problem. i tried [EMAIL PROTECTED] the virtual domain created is erivaind.com. where do u think the authorization is not happening. thanks, Anuradha -- Original Message -- From: "Charles M. Gerungan" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 25 Jun 2004 12:15:08 +0200 Hello Anuradha, On Fri, 25 Jun 2004 02:56:51 -0700 UTC, Anuradha Kalyan wrote: AK> i added users throught the qmailadmin web interface. So they're virtual. AK> user dharini Try: USER [EMAIL PROTECTED] -- Regards, Charles.
Re: [vchkpw] Authentication
Hello Anuradha, On Fri, 25 Jun 2004 02:56:51 -0700 UTC, Anuradha Kalyan wrote: AK> i added users throught the qmailadmin web interface. So they're virtual. AK> user dharini Try: USER [EMAIL PROTECTED] -- Regards, Charles.
[vchkpw] Authentication
hello everyone, i am a newbie to linux and to qmail . i installed qmail+ vpopmail+qmailadmin + ezmlm i added users throught the qmailadmin web interface. but there is a problem with the authentication. could anyopne help. i could use telnet but authentication is a problem. this is what happens [EMAIL PROTECTED] host root] telnet 192.168.1.9 110 Trying 192.168.1.9 Connected to 192.168.1.9 Escape character is '^]'. +ok <[EMAIL PROTECTED]> user dharini +ok pass dharu -ERR authorization failed Connection closed by foreign host. let me know how to sort this out. thanks , Anu
