RE: [vchkpw] what appears to be mysql errors inside.... and other questions
-Original Message- From: Dave Goodrich [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 4:25 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] what appears to be mysql errors inside and other questions Grimes, David wrote: > Hello all, > > New user/abuser here... > > 1. Last night, due to a problem with a corporate mail server, my mail > server got flooded with ~20k emails. It tried like heck to chew through them > but the poor little machine just wasn't havin' it. My setup is a gentoo box > running vpopmail, qmail, qmail-scanner, spamassassin, -prot, and courier-et > al. with the latest packages as of yesterday. I have two questions 1. > Outside of better hardware what are some things I should do to the software > config to better equip it for things? Switches, etc... What do you have now for hardware? [DG] Athlon 1700 512 60gig ide drive What version of SA are you running? [DG] SA is 2.6.3 What extra rules are your running in SA? [DG] I used the out of the box rule set. Since reading your message I've removed the RBL and razor checks/usage. How many messages do you normally handle a day? [DG] this machine sees ~25k messages a day I have found that when getting blasted to the extent that it becomes a hardware issue, turning off SA until you can get the queue cleared helps quite a bit. [DG] I eventually did that but for about 4-5 hours my load avg was 400-500 I've got the screen shots to prove it ;) Eventually I blackholed my mx record which allowed my box to catch up on already delievered mail and then removed qmail scanner and let everything through un processed. If you are doing Razor lookups in SA, stop. I've not found Razor to make a difference in spam caught compared to to the network and system resources it consumes. If you are doing RBL lookups in SA, stop. RBL lookups are considerably faster with qmail and saves you having to process a message that you later would dump when it gets to SA anyway. Example; I move 40k to 50k inbound messages a day, 65k+ of those I dropped at the smtp level via qmail. If I had used RBL lookups in SA I would have over doubled my SA load. > Number two, this > message appeared quite often last night. What exactly is it telling me? It has been my experience, someone/anyone correct me if I am wrong, but you A) need to upgrade to 5.4.6 as there were changes to the SQL code or B) your MySQL connection was timing out. It seemed to me that those errors went away here when I gave MySQL more resources. Of course, YMMV, and I could be just a nut ;^) DAve [DG] thanks for the input! David > > I realize this email is vague and poorly worded so any comments, questions, > and suggestions to further the discussion would be greatly appreciated. > > > > Thanks > > DG > > > > @4000415240cb09be3594 delivery 3013: success: > vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmys > ql:_sql_error[3]:_No_Database_Selected/could_not_create_limits_table_CREATE_ > TABLE_limits_(_domain_CHAR(64)_PRIMARY_KEY,___maxpopaccounts___I > NT(10)_NOT_NULL_DEFAULT_-1,___maxaliases___INT(10)_NOT_NULL_ > DEFAULT_-1,___maxforwards__INT(10)_NOT_NULL_DEFAULT_-1,_ > __maxautorespondersINT(10)_NOT_NULL_DEFAULT_-1,___maxmailinglist > s__INT(10)_NOT_NULL_DEFAULT_-1,___diskquotaINT(1 > 2)_NOT_NULL_DEFAULT_0,___maxmsgcount__INT(12)_NOT_NULL_DEFAU > LT_0,___defaultquota_INT(12)_NOT_NULL_DEFAULT_0,___defau > ltmaxmsgcount___INT(12)_NOT_NULL_DEFAULT_0,___disable_pop___ > ___TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_imap_TINYINT(1)_ > NOT_NULL_DEFAULT_0,___disable_dialup___TINYINT(1)_NOT_NULL_DEFAU > LT_0,___disable_passwordchanging_TINYINT(1)_NOT_NULL_DEFAULT_0,___di > sable_webmail__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_relay___ > _TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_smtp_TINYI > NT(1)_NOT_NULL_DEFAULT_0,___perm_account_TINYINT(2)_NOT_NULL > _DEFAULT_0,___perm_alias___TINYINT(2)_NOT_NULL_DEFAULT_0,___ > perm_forward_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_autor > esponder___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_maillist___ > _TINYINT(4)_NOT_NULL_DEFAULT_0,___perm_quota___TINYINT(2)_NO > T_NULL_DEFAULT_0,___perm_defaultquotaTINYINT(2)_NOT_NULL_DEFAULT > _0_)/vmysql:_sql_error[p]:_No_Database_Selected/user_does_not_exist,_but_wil > l_deliver_to_/var/vpopmail/domains/thegrimesfamily.net/test//did_0+0+1/ > > -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
RE: [vchkpw] what appears to be mysql errors inside.... and other questions
Yes mysql IS running and permissions are correct. It’s a fully functional setup and chugs along just fine otherwise… DG From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 3:59 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] what appears to be mysql errors inside and other questions do u have mysql running? did u give the right permissions? Bye, Remo - Original Message - From: Grimes, David To: [EMAIL PROTECTED] Sent: Thursday, September 23, 2004 2:46 PM Subject: [vchkpw] what appears to be mysql errors inside and other questions Hello all, New user/abuser here… 1. Last night, due to a problem with a corporate mail server, my mail server got flooded with ~20k emails. It tried like heck to chew through them but the poor little machine just wasn’t havin’ it. My setup is a gentoo box running vpopmail, qmail, qmail-scanner, spamassassin, -prot, and courier-et al. with the latest packages as of yesterday. I have two questions 1. Outside of better hardware what are some things I should do to the software config to better equip it for things? Switches, etc… Number two, this message appeared quite often last night. What exactly is it telling me? I realize this email is vague and poorly worded so any comments, questions, and suggestions to further the discussion would be greatly appreciated. Thanks DG @4000415240cb09be3594 delivery 3013: success: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmysql:_sql_error[3]:_No_Database_Selected/could_not_create_limits_table_CREATE_TABLE_limits_(_domain_CHAR(64)_PRIMARY_KEY,___maxpopaccounts___INT(10)_NOT_NULL_DEFAULT_-1,___maxaliases___INT(10)_NOT_NULL_DEFAULT_-1,___maxforwards__INT(10)_NOT_NULL_DEFAULT_-1,___maxautorespondersINT(10)_NOT_NULL_DEFAULT_-1,___maxmailinglists__INT(10)_NOT_NULL_DEFAULT_-1,___diskquotaINT(12)_NOT_NULL_DEFAULT_0,___maxmsgcount__INT(12)_NOT_NULL_DEFAULT_0,___defaultquota_INT(12)_NOT_NULL_DEFAULT_0,___defaultmaxmsgcount___INT(12)_NOT_NULL_DEFAULT_0,___disable_pop__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_imap_TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_dialup___TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_passwordchanging_TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_webmail__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_relayTINYINT(1)_NOT_NULL_DEFAULT_0,___disable_smtp_TINYINT(1)_NOT_NULL_DEFAULT_0,___perm_account_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_alias___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_forward_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_autoresponder___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_maillistTINYINT(4)_NOT_NULL_DEFAULT_0,___perm_quota___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_defaultquotaTINYINT(2)_NOT_NULL_DEFAULT_0_)/vmysql:_sql_error[p]:_No_Database_Selected/user_does_not_exist,_but_will_deliver_to_/var/vpopmail/domains/thegrimesfamily.net/test//did_0+0+1/
RE: [vchkpw] what appears to be mysql errors inside.... and other questions
Apologies that error is from /var/log/qmail/qmail-send/current From: Grimes, David [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 3:47 PM To: [EMAIL PROTECTED] Subject: [vchkpw] what appears to be mysql errors inside and other questions Hello all, New user/abuser here… 1. Last night, due to a problem with a corporate mail server, my mail server got flooded with ~20k emails. It tried like heck to chew through them but the poor little machine just wasn’t havin’ it. My setup is a gentoo box running vpopmail, qmail, qmail-scanner, spamassassin, -prot, and courier-et al. with the latest packages as of yesterday. I have two questions 1. Outside of better hardware what are some things I should do to the software config to better equip it for things? Switches, etc… Number two, this message appeared quite often last night. What exactly is it telling me? I realize this email is vague and poorly worded so any comments, questions, and suggestions to further the discussion would be greatly appreciated. Thanks DG @4000415240cb09be3594 delivery 3013: success: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmysql:_sql_error[3]:_No_Database_Selected/could_not_create_limits_table_CREATE_TABLE_limits_(_domain_CHAR(64)_PRIMARY_KEY,___maxpopaccounts___INT(10)_NOT_NULL_DEFAULT_-1,___maxaliases___INT(10)_NOT_NULL_DEFAULT_-1,___maxforwards__INT(10)_NOT_NULL_DEFAULT_-1,___maxautorespondersINT(10)_NOT_NULL_DEFAULT_-1,___maxmailinglists__INT(10)_NOT_NULL_DEFAULT_-1,___diskquotaINT(12)_NOT_NULL_DEFAULT_0,___maxmsgcount__INT(12)_NOT_NULL_DEFAULT_0,___defaultquota_INT(12)_NOT_NULL_DEFAULT_0,___defaultmaxmsgcount___INT(12)_NOT_NULL_DEFAULT_0,___disable_pop__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_imap_TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_dialup___TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_passwordchanging_TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_webmail__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_relayTINYINT(1)_NOT_NULL_DEFAULT_0,___disable_smtp_TINYINT(1)_NOT_NULL_DEFAULT_0,___perm_account_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_alias___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_forward_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_autoresponder___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_maillistTINYINT(4)_NOT_NULL_DEFAULT_0,___perm_quota___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_defaultquotaTINYINT(2)_NOT_NULL_DEFAULT_0_)/vmysql:_sql_error[p]:_No_Database_Selected/user_does_not_exist,_but_will_deliver_to_/var/vpopmail/domains/thegrimesfamily.net/test//did_0+0+1/
[vchkpw] what appears to be mysql errors inside.... and other questions
Hello all, New user/abuser here… 1. Last night, due to a problem with a corporate mail server, my mail server got flooded with ~20k emails. It tried like heck to chew through them but the poor little machine just wasn’t havin’ it. My setup is a gentoo box running vpopmail, qmail, qmail-scanner, spamassassin, -prot, and courier-et al. with the latest packages as of yesterday. I have two questions 1. Outside of better hardware what are some things I should do to the software config to better equip it for things? Switches, etc… Number two, this message appeared quite often last night. What exactly is it telling me? I realize this email is vague and poorly worded so any comments, questions, and suggestions to further the discussion would be greatly appreciated. Thanks DG @4000415240cb09be3594 delivery 3013: success: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmysql:_sql_error[3]:_No_Database_Selected/could_not_create_limits_table_CREATE_TABLE_limits_(_domain_CHAR(64)_PRIMARY_KEY,___maxpopaccounts___INT(10)_NOT_NULL_DEFAULT_-1,___maxaliases___INT(10)_NOT_NULL_DEFAULT_-1,___maxforwards__INT(10)_NOT_NULL_DEFAULT_-1,___maxautorespondersINT(10)_NOT_NULL_DEFAULT_-1,___maxmailinglists__INT(10)_NOT_NULL_DEFAULT_-1,___diskquotaINT(12)_NOT_NULL_DEFAULT_0,___maxmsgcount__INT(12)_NOT_NULL_DEFAULT_0,___defaultquota_INT(12)_NOT_NULL_DEFAULT_0,___defaultmaxmsgcount___INT(12)_NOT_NULL_DEFAULT_0,___disable_pop__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_imap_TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_dialup___TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_passwordchanging_TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_webmail__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_relayTINYINT(1)_NOT_NULL_DEFAULT_0,___disable_smtp_TINYINT(1)_NOT_NULL_DEFAULT_0,___perm_account_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_alias___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_forward_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_autoresponder___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_maillistTINYINT(4)_NOT_NULL_DEFAULT_0,___perm_quota___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_defaultquotaTINYINT(2)_NOT_NULL_DEFAULT_0_)/vmysql:_sql_error[p]:_No_Database_Selected/user_does_not_exist,_but_will_deliver_to_/var/vpopmail/domains/thegrimesfamily.net/test//did_0+0+1/
