Re: [vchkpw] what appears to be mysql errors inside.... and other questions

2004-09-24 Thread Dave Goodrich
Grimes, David wrote:
-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:

config to better equip it for things? Switches, etc... 
What do you have now for hardware?
[DG] Athlon 1700 512 60gig ide drive 
Should be plenty with a stock qmail-vpopmail-mysql-SA. Not sure how much 
qmail-scanner requires as far as resources. Perl can get hungry. I've 
processed twice as much on a Sparc 20 with dual 125mhz and 512 ram. I 
didn't run qmail-scanner and a AV solution though..


The fellow who could convert one of the many perl qmailqueue 
replacements to C, would likely be carried about town on the shoulders 
of a grateful crowd.


What version of SA are you running?
[DG] SA is 2.6.3
They should have the problems sorted out with SA 3.0.0 now, seems most 
of the traffic I have seen is people not thoroughly reading the docs 
before upgrading. The upgrade will also give you SURBL, which will help 
more than anything else I have tried.

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.
Did you add your RBLs into qmail-smtpd? (adding rblsmtpd to your run file)
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.
Painfull I know, but sometimes it is the only way ;^)
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
Your welcome.
DAve

I realize this email is vague and poorly worded so any comments,
questions,
and suggestions to further the discussion would be greatly appreciated.

--
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

2004-09-24 Thread Grimes, David


-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

2004-09-23 Thread Dave Goodrich
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?
What version of SA are you running?
What extra rules are your running in SA?
How many messages do you normally handle 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.

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
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

2004-09-23 Thread Rick Macdougall

Hello all,
New user/abuser here…
@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/
Hi,
vpopmail (or one of it's components) could not connect to the MySQL 
database for what ever reason.  It then thought it was missing the 
vpopmail database and tried to create it.  It's a known bug and version 
5.4.6 alleviates some of the problem (not all though).

Best to look at your MySQL setup to make sure that you have enough 
allowed connections and enough mem etc assigned to mysql in your my.cnf 
file.

Regards,
Rick



RE: [vchkpw] what appears to be mysql errors inside.... and other questions

2004-09-23 Thread Grimes, David








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

2004-09-23 Thread Remo Mattei



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

2004-09-23 Thread Grimes, David








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/