Hey Brian; 1) This is used for the storage of the accounts, moderators, etc. Not the postings.
2) Should be a mysql user that has access to the database/table that you created for this list. 3) Yes, you do use ezmlm-mktab. This will make the appropriate tables that qmailadmin can use. I use the mysql option for my larger listserv's (2-10K lists) because I can interface directly with the table to manage the userlist and it's much faster than the flatfile option that's normally used by ezmlm. I do need to warn you of a bug in the current version of qmailadmin. If you have a listserv with more than 500 users, the "show subscribers" page won't do anything. This is a bug in the sorting function that was added a couple releases ago. I've got a patched mailinglist.c from Bill Shupp (Thanks again bill!) that takes out the sort routine yet allows everything to continue working (It just won't sort the list...*shrug*...no big deal for me right now) If you have any more questions, feel free to drop me a line. I'm quite impressed with ezmlm now that I'm starting to delve into it. Much nicer than majordomo *shudder* Regards, Tren. -----Original Message----- From: Brian Ipsen [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 20, 2001 12:48 PM To: [EMAIL PROTECTED] Subject: Ezmlm SQL settings ? Hi! Just started qmailadmin 0.88 up on a system running qmail & vpopmail with MySQL support, and went to create a new mailing-list... In the bottom it's possible to add some SQL information - but I have some questions regarding this: 1. What is the information used for ?? Storing postings or something else ?? 2. The user-id/password - should root be used, or could any e.g. ezmlm account be used (if the account has rights to the specified database, that is) ? 3. A table name should be entered. Will I have to create the table myself in the specified database, or will the system create the table itself. (probably needs to be created with ezmlm-mktab - but is the tablename entered the same as used with ezmlm-mktab) ? Regards, /Brian
