Re: [qmailtoaster] vpopmail schema

2011-03-06 Thread Fred Richards
Thanks Pak and Eric. My schema looks perfect, and I've figured out my issue. When you try and authenticate, and use just plain user instead of u...@domain.com vpopmail looks for a vpopmail.users table. Because everything is organized by domain (which makes perfect sense for virtual users and

Re: [qmailtoaster] vpopmail schema

2011-03-06 Thread Pak Ogah
On 06-Mar-11 23:34, Fred Richards wrote: Thanks Pak and Eric. My schema looks perfect, and I've figured out my issue. When you try and authenticate, and use just plain user instead of u...@domain.com vpopmail looks for a vpopmail.users table. Because everything is organized by domain (which

Re: [qmailtoaster] vpopmail schema

2011-03-06 Thread Maxwell Smart
I tried it according to the wiki instruction and it broke my fail2ban. I think the formatting needs to be a bit clearer. The vpopmail-fail file should look like this. (For idiots like me that leave the definition directive out, doh!) [Definition] failregex = vchkpw-smtp: password fail

Re: [qmailtoaster] vpopmail schema

2011-03-03 Thread Eric Broch
On 3/3/2011 4:37 PM, Fred Richards wrote: Hi qmailtoaster-ers! First of all, let me thank you for such a great project. I'm finding myself needing to single-handedly migrate an older (very custom) qmail install complete with virtual users in a flat file, to something newer. I went ahead

Re: [qmailtoaster] vpopmail schema

2011-03-03 Thread Fred Richards
Yup, did that, and if you look at the script, it sets a root password, creates the database, and assigns privileges... but doesn't make any tables or a schema for the vpopmail database. On 03/03/2011 07:12 PM, Eric Broch wrote: Don't forget to edit the file first and set your mysql

Re: [qmailtoaster] vpopmail schema

2011-03-03 Thread Eric Broch
On 3/3/2011 7:55 PM, Fred Richards wrote: Yup, did that, and if you look at the script, it sets a root password, creates the database, and assigns privileges... but doesn't make any tables or a schema for the vpopmail database. On 03/03/2011 07:12 PM, Eric Broch wrote: Don't forget to

Re: [qmailtoaster] vpopmail schema

2011-03-03 Thread Pak Ogah
Halo Fred, when we install vpopmail-toaster from installation script, it created the database and tables automatically. and the vpopmail has support to use mysql (database) not flatfile incase you miss the database creation, here mine: ps: I am using mysql 5 and export it using heidisql 6 #