First, my apologies for this long winded e-mail.
I know this looks like it should be very straight forward but I am having
some doubts here. See if you can help:
My system:
Kernel 2.2.16-22smp on a 2-processor i686
qmail-1.03-102memphis.i386.rpm
ezmlm-idx-mysql-0.53.400-8.i386.rpm
vpopmail-4.9.9
qmailadmin-0.43
When creating a new mailing list, I want to use the SQL option since I
compiled mySQL with ezmlm, vpopmail and qmailadmin.
So I need to enter the appropriate info for these parameters:
-----------------------------
Enable SQL support
Host Port
User Password
Database Table
-----------------------------
But no matter what I entered, I always end up getting these in the error
log.
This is from /var/log/mysqld.log
010316 13:24:04 Aborted connection 535 to db: 'vpopmail' user: 'vpopmail'
host: `localhost' (Got an error reading communication packets)
010316 13:24:08 Aborted connection 536 to db: 'vpopmail' user: 'vpopmail'
host: `localhost' (Got an error reading communication packets)
010316 13:24:16 Aborted connection 537 to db: 'vpopmail' user: 'vpopmail'
host: `localhost' (Got an error reading communication packets)
010316 13:24:20 Aborted connection 538 to db: 'vpopmail' user: 'vpopmail'
host: `localhost' (Got an error reading communication packets)
010316 13:24:24 Aborted connection 539 to db: 'vpopmail' user: 'vpopmail'
host: `localhost' (Got an error reading communication packets)
I used the following info (in vmysql.h) before making vpopmail:
#define MYSQL_SERVER "localhost"
#define MYSQL_USER "vpopmail"
#define MYSQL_PASSWD "password"
I tried entering the exact info in the above html form but I do not see
anything regarding ezmlm in the vpopmail db.
My questions are :
1) what do I entered in here ?
User Password
Database Table
-----------------------------
2) and will I need to first create these for does ezmlm create these for me
?
3) And if successful, do all the subscribers end up in this db ? What else
?
4) Right now I am seeing a whole bunch of files related to a list I had just
created in
/usr/local/vpopmail/domains/test.com/test-list/ including subscribers. I
guess then it is not using SQL.
So if it cannot use SQL because of the above problem, it reverts to using
normal method ?
Thank you.
Lu
