Re: [vchkpw] Mysql table

2007-09-21 Thread Tom Collins
On Sep 20, 2007, at 12:56 PM, Rick Widmer wrote: If I remember right, speed was the reason for separate tables, but testing showed it was not faster. I think the single table works better because all your mail users are accessing the same table, and its indexes so they stay loaded all the

Re: [vchkpw] Mysql table

2007-09-20 Thread mlist
John Simpson wrote: On 2007-09-19, at 1532, mlist wrote: Please try creating a domain with a long name, up around 80-90 characters long. ... I did as you said and I recieved errors. Here is the command I used and the errors returned. ... vmysql: error creating table

Re: [vchkpw] Mysql table

2007-09-20 Thread Rick Widmer
mlist wrote: John Simpson wrote: and since mysql has a limit of 64 bytes for a table name, you have a... maybe not a bug, but a design flaw. the name a(63 times).com IS a valid domain name, but a(63 times)_com is NOT a valid table name. Definitely a design flaw, even before the

Re: [vchkpw] Mysql table

2007-09-20 Thread mlist
Rick Widmer wrote: mlist wrote: John Simpson wrote: and since mysql has a limit of 64 bytes for a table name, you have a... maybe not a bug, but a design flaw. the name a(63 times).com IS a valid domain name, but a(63 times)_com is NOT a valid table name. Definitely a design

Re: [vchkpw] Mysql table

2007-09-20 Thread Ken Jones
Rick Widmer wrote: mlist wrote: John Simpson wrote: and since mysql has a limit of 64 bytes for a table name, you have a... maybe not a bug, but a design flaw. the name a(63 times).com IS a valid domain name, but a(63 times)_com is NOT a valid table name. Definitely a design

Re: [vchkpw] Mysql table

2007-09-19 Thread mlist
Please try creating a domain with a long name, up around 80-90 characters long. Then try to add a user, delete that user then delete that domain. If it all works, you are in good shape and I'll change the note in INSTALL to say you don't have to do anything special if you are using

Re: [vchkpw] Mysql table

2007-09-19 Thread Joshua Megerman
qmail-newu: fatal: bad format in users/assign Before pursuing anything else, check this out - qmail-newu (part of qmail, and simply called by vpopmail) is telling you that your /var/qmail/users/assign file is incorrect/corrupted, and that it can't create the users.cdb file from it. Vpopmail

Re: [vchkpw] Mysql table

2007-09-19 Thread mlist
mlist wrote: Please try creating a domain with a long name, up around 80-90 characters long. Then try to add a user, delete that user then delete that domain. If it all works, you are in good shape and I'll change the note in INSTALL to say you don't have to do anything special if you are

Re: [vchkpw] Mysql table

2007-09-19 Thread John Simpson
On 2007-09-19, at 1532, mlist wrote: Please try creating a domain with a long name, up around 80-90 characters long. ... I did as you said and I recieved errors. Here is the command I used and the errors returned. ... vmysql: error creating table

Re: [vchkpw] Mysql table

2007-09-18 Thread Rick Widmer
mlist wrote: Hello, I'm upgrading vpopmail to version 5.4.21. The documentation states that I need to alter some tables. ALTER TABLE `dir_control` CHANGE `pw_domain` `pw_domain` CHAR(96) NOT NULL; ALTER TABLE `ip_alias_map` CHANGE pw_domain pw_domain CHAR(96) NOT NULL; ... I read on a