Ken tried to help me on this but he is not familiar with using mysql with ezmlm. Let me ask you all this: Have any of you successfully used ezmlm+mysql via qmailadmin ? If you have please read my orignal post below and help me answer those questions. I need to know in order to keep trying or give up. One curious note: I do not see ezmlm-mktab inside mailinglist.c which indicates to me that the table you enter in the form must have been already created ? Thanks. > -----Original Message----- > From: Lu [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 16, 2001 11:43 AM > To: [EMAIL PROTECTED] > Subject: SQL portion of Add Mailing List in qmailadmin > > > 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
