Re: [vchkpw] vpopmail 5.3.18 with --enable-vlimits
Quoting Brian Kolaci <[EMAIL PROTECTED]>: > > Ahh, good catch. I increased limits table structure to about twice > its original size, (more items added) and since my table already existed, > I didn't encounter the buffer overflow. > > Since the original create failed, you'll need to delete and > add the domain again to get the row added to the table. > > I guess another limit we can add would be Rick's request > for a monthly bandwidth limitation per domain (or user?). I was thinking user.. In my own environment, I use Isoqlog to watch domains, but users aren't 'summed' up by month. I figured (note, I haven't actually looked at the code ;) maildirsize.* could be copied to bandwidthsize.*, trimmed (we don't need directories), and a date added. I only mentioned it first, because I saw the 'naughty' word in vdelivermail.c, and I figured I'd 'air' my quota thoughts :) Not that I'm a prude or anything, most of my first applications' variable names consisted of f**kthis,f**that... Yes, those were real var names :) Good thing those were small programs. I stopped doing that after one of the 'real' programmers (I'm a network guy), told me he used a 'choice phrase' for a 'This should never happen' message, and a client managed to create that error.. whoops. Sorry.. very babbly today.. must go socialize with adults :) Rick > Brian > > > solved. > > > > increasing vmysql.c: SQL_BUF_SIZE to 2000 fixed it. > > > > however i do get > > delivery 6: success: > > vnysql:_can't_find_limits_for_domain_'test.com'/did_0+0+1/ > > > > > > (with a type in it too.. vnysql => vmysql) > > > > shouldn't it add some defaults when calling vadddomain ? > > > > -- > > Best Regards, > > Justin > > > > >
Re: [vchkpw] vpopmail 5.3.18 with --enable-vlimits
Ahh, good catch. I increased limits table structure to about twice its original size, (more items added) and since my table already existed, I didn't encounter the buffer overflow. Since the original create failed, you'll need to delete and add the domain again to get the row added to the table. I guess another limit we can add would be Rick's request for a monthly bandwidth limitation per domain (or user?). Brian > solved. > > increasing vmysql.c: SQL_BUF_SIZE to 2000 fixed it. > > however i do get > delivery 6: success: > vnysql:_can't_find_limits_for_domain_'test.com'/did_0+0+1/ > > > (with a type in it too.. vnysql => vmysql) > > shouldn't it add some defaults when calling vadddomain ? > > -- > Best Regards, > Justin >
Re: [vchkpw] vpopmail 5.3.18 with --enable-vlimits
solved. increasing vmysql.c: SQL_BUF_SIZE to 2000 fixed it. however i do get delivery 6: success: vnysql:_can't_find_limits_for_domain_'test.com'/did_0+0+1/ (with a type in it too.. vnysql => vmysql) shouldn't it add some defaults when calling vadddomain ? -- Best Regards, Justin
[vchkpw] vpopmail 5.3.18 with --enable-vlimits
hi.. just built 5.3.18 and i have a problem with vlimits. it was a fresh install, i dropped any existing tables from the vpopmail mysql database. built with: ./configure --enable-roaming-users=y --enable-md5-passwords=y --enable-mysql-logging=y --enable-users-big-dir=n --enable-mysql=y --enable-qmail-ext=y --enable-clear-passwd=y --enable-file-sync=y --enable-valias=y --enable-mysql-limits=y --enable-vpopgroup=vpopmail adding domains works fine. when i try to send a mail locally # /var/qmail/bin/qmail-inject -froot [EMAIL PROTECTED] qmail tells me: 2003-02-22 14:42:43.729012500 delivery 2: success: 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,___disabl/vmysql:_sql_error[j]:_Table_'vpopmail.limits'_doesn't_exist/did_0+0+1/ it could create all the other tables, however furthermore: after i created the table myself, it still shows the same error message. the sql query the qmail-send log is showing is obviosly truncated. i checked with the source and there it seems complete. -- Best Regads, Justin
