RE: [qmailadmin] MySQL Usage
On Sun, 2004-10-24 at 09:57 -0700, Admin wrote: > Jeremy, > > I have someone else that manages my server. I did not 'just convert'. I > have been using qmailadmin for a few years now and have the near latest > version. I have perhaps a thousand email accounts running right now > under the non-mysql method. I wouldn't do anything to disrupt that in > advance of knowing exactly how to link the two. understood, and there's no reason to do so. > Is there any instruction material anywhere showing for instance what the > names of the tables / fields must be? Where in qmail or vpop the > information about connecting to the database is kept? Is there a way to > test that things are working before one switches over. In other words, > is there an SQL / NON-SQL config setting that I could toggle where I > could revert if something wasn't working. what I always do, is recompile vpopmail with mysql support (but do not do a 'make install'), run vconvert from the source directory, test all of the tools from the source directory, and then move the binaries into place. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail GnuPG Key ID: 481BF7E2 ++ scriptkitchen.com/kitchen.asc signature.asc Description: This is a digitally signed message part
RE: [qmailadmin] MySQL Usage
Jeremy, I have someone else that manages my server. I did not 'just convert'. I have been using qmailadmin for a few years now and have the near latest version. I have perhaps a thousand email accounts running right now under the non-mysql method. I wouldn't do anything to disrupt that in advance of knowing exactly how to link the two. Is there any instruction material anywhere showing for instance what the names of the tables / fields must be? Where in qmail or vpop the information about connecting to the database is kept? Is there a way to test that things are working before one switches over. In other words, is there an SQL / NON-SQL config setting that I could toggle where I could revert if something wasn't working. Your thoughts? Jay -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Sunday, October 24, 2004 12:46 AM To: [EMAIL PROTECTED] Subject: RE: [qmailadmin] MySQL Usage On Sun, October 24, 2004 2:00 am, Admin said: > Jeremy, > > > Well, I'd like users and their passwords to be stored in a db table so > I could manage them with my own client front end. That's the main > thing I'm shooting for right now. There may be other possibilities but > right now that's my desire. that's how vpopmail's mysql functionality works. qmailadmin can manage this without any changes (just recompile qmailadmin if you've just converted) -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
RE: [qmailadmin] MySQL Usage
On Sun, October 24, 2004 2:00 am, Admin said: > Jeremy, > > > Well, I'd like users and their passwords to be stored in a db table so I > could manage them with my own client front end. That's the main thing I'm > shooting for right now. There may be other possibilities but right now > that's my desire. that's how vpopmail's mysql functionality works. qmailadmin can manage this without any changes (just recompile qmailadmin if you've just converted) -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
RE: [qmailadmin] MySQL Usage
Jeremy, Well, I'd like users and their passwords to be stored in a db table so I could manage them with my own client front end. That's the main thing I'm shooting for right now. There may be other possibilities but right now that's my desire. Your thoughts? Jay -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Saturday, October 23, 2004 11:08 PM To: [EMAIL PROTECTED] Subject: Re: [qmailadmin] MySQL Usage On Sat, October 23, 2004 8:44 pm, Jay said: > Hello, > > > I just saw an email indicating that qmailadmin can somehow integrate > with mysql? Is there any instruction material available that shows > how they may work in concert together? qmailadmin links in the vpopmail library for managing the vpopmail users database. This makes it (mostly) transparent for qmailadmin/vpopmail to be able to switch between backend types such as cdb, mysql, pgsql, oracle, etc. Work is being done to make vpopmail more abstract and to make qmailadmin make better use of this abstraction (currently it does too much work itself) however qmailadmin can interoperate with vpopmail/mysql very easily. Is there a specific function you wanted qmailadmin to perform while interacting with mysql? -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
Re: [qmailadmin] MySQL Usage
On Sat, October 23, 2004 8:44 pm, Jay said: > Hello, > > > I just saw an email indicating that qmailadmin can somehow integrate > with mysql? Is there any instruction material available that shows how > they may work in concert together? qmailadmin links in the vpopmail library for managing the vpopmail users database. This makes it (mostly) transparent for qmailadmin/vpopmail to be able to switch between backend types such as cdb, mysql, pgsql, oracle, etc. Work is being done to make vpopmail more abstract and to make qmailadmin make better use of this abstraction (currently it does too much work itself) however qmailadmin can interoperate with vpopmail/mysql very easily. Is there a specific function you wanted qmailadmin to perform while interacting with mysql? -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail