Re: [vchkpw] Cdb and mysql auth modules at a time?

2004-04-29 Thread Cesare D'Amico
On Thursday 29 April 2004 02:39, Rick Widmer wrote:
 Good luck.  Two servers, or a virtual server where each qmail+vpopmail
 image appeared as a separate machine would be the only ways I would want
 to keep them separate.  If you find a reasonable way, please let us know.

An idea could be to run two separate binaries each bound on a different 
network interface, but I think that it's not a real solution. Perhaps I could 
investigate using an UML virtual server, but I think that the simplest path 
is converting everything to mysql (and in the long run it's also probably the 
best approach, since it allows more web-based services to be implemented).

Thanks for all your advices, I'll try to find some time to have a look at the 
(really interesting) pmailadmin framework. Does it work with cdb files yet? 
(I was told that the latest versions of PHP's dba extension support also cdb 
files, but I didn't check). If you support the cdb backend, how did you solve 
the user/group privileges problems for writing to cdb files?

Thanks again
 ce
-- 
Computer science is no more about computers than astronomy is about 
telescopes.
   -- E. W. Dijkstra



Re: [vchkpw] Cdb and mysql auth modules at a time?

2004-04-29 Thread Rick Widmer


Cesare D'Amico wrote:

Thanks for all your advices, I'll try to find some time to have a look at the 
(really interesting) pmailadmin framework. Does it work with cdb files yet? 
Right now there are things that only work with cdb files.  At least with 
the extension option.  Once I get all the features working I will 
convert my test system to MySQL and do what ever it takes to get it 
running again.  At the very least I will have to add ordered alias names 
to the mysql back end.  It should be easier there than in cdb.  Just add 
a few ORDERED BY clauses in the right places.


(I was told that the latest versions of PHP's dba extension support also cdb 
files, but I didn't check). 
Yes PHP's dba supports cdb, and is currently required by pMailAdmin. 
The new get_domain_entries code in vpopmail may eliminate it.


If you support the cdb backend, how did you solve 
the user/group privileges problems for writing to cdb files?


There are two ways I have found. The easy way is to run Ken's daemon and 
let it handle all the permissions.  The other way is harder, and messy, 
but much faster.  You have to run Apache as vpopmail:vchkpw.  At least 
one copy for accessing vpopmail.  I wouldn't want to do this on a server 
that hosted web sites. I have a separate machine for email and no one 
else can write web pages on it.

I am trying to keep the documentation on the pMailAdmin site up to date, 
so it is worth a look.

Rick



[vchkpw] Cdb and mysql auth modules at a time?

2004-04-28 Thread Cesare D'Amico
Hi all, I've googled for this, but I came to nothing.

Is it possible to configure vpopmail to use more than one auth module at 
a time? In particular, I need it to search into cdb files for some 
domains, and use a mysql backend for another one.

That's because I was asked to consolidate two mail servers on a single 
machine. The problem is that one server uses cdb files, the other one 
has a php application manipulating the vpopmail database, which uses 
the mysql backend. I need to migrate this web application too, so I 
must keep that domain sticked to mysql. If possible, I'd rather not 
convert all the other domains to mysql.

The older documentation in README.mysql says that if you want to 
convert cdb domains to mysql you should use vconvert; so I think that 
at least cdb and mysql can be used at the same time. Is it right or 
wrong?
And how can I do that, if it's possible? I tried to ./configure vpopmail 
with both --enable-auth-module=cdb AND --enable-auth-module=mysql, but 
only the latter is shown in the configuration summary at the end of 
the ./configure step. Instead, only cdb is shown if I change their 
order (that actually makes sense :)

By the way, I've tried that with vpopmail 5.4.0.

Thanks for your help and your great software ;)

Ciao
 ce
-- 
Cesare D'Amico - boss (@t) cesaredamico (dot) com
http://cesaredamico.com  ~  http://phpday.it  ~  http://verona.linux.it/
Key on pgp.mit.edu, ID 92802693.



Re: [vchkpw] Cdb and mysql auth modules at a time?

2004-04-28 Thread X-Istence
Cesare D'Amico wrote:
snip

Ciao
 ce


Not possible. At this time.

X-Istence


Re: [vchkpw] Cdb and mysql auth modules at a time?

2004-04-28 Thread Cesare D'Amico
Alle 01:37, giovedì 29 aprile 2004, X-Istence ha scritto:
 Not possible. At this time.

D'oh!

I think I'll have to do something on the web app then. Or perhaps try to 
use two sets of vpopmail binaries, which isn't a really appealing 
possibility.

Thanks for the quick reply :)

Ciao
 ce
-- 
Cesare D'Amico - boss (@t) cesaredamico (dot) com
http://cesaredamico.com  ~  http://phpday.it  ~  http://verona.linux.it/
Key on pgp.mit.edu, ID 92802693.
Questa è la mia vita, se ho bisogno te lo dico, sono io che guido, io 
che vado fuori strada, sempre io che pago... non è mai successo che 
pagassero per me... [Questa è la mia vita - Ligabue]



Re: [vchkpw] Cdb and mysql auth modules at a time?

2004-04-28 Thread Rick Widmer


Cesare D'Amico wrote:
Hi all, I've googled for this, but I came to nothing.

Is it possible to configure vpopmail to use more than one auth module at 
a time? 
That is not going to be possible because the choice of authentication 
back-end is made by setting a symlink (vauth.c) at compile time.  As you 
found out, the last ./configure option wins.


That's because I was asked to consolidate two mail servers on a single 
machine. The problem is that one server uses cdb files, the other one 
has a php application manipulating the vpopmail database, which uses 
the mysql backend. I need to migrate this web application too, so I 
must keep that domain sticked to mysql. If possible, I'd rather not 
convert all the other domains to mysql.
Migrating everything to MySQL is probably going to be your best bet.  If 
the cdb group is already using qmailadmin they won't notice the 
difference.  Vpopmail is pretty good at abstracting the back end, and it 
is getting better, so they won't notice if they are using the commands 
in ~vpopmail/bin either.

Managing vpopmail from PHP is in the process of getting easier.  Ken 
Jones just wrote a daemon, and I am working on a PHP extension and a 
pair of classes that abstract them so a program can use either just by 
changing one include statement.

It is all very much under construction, and I don't suggest you try it 
unless you are willing to debug and possibly even write some code for 
the project.  You can see what is happening here:

   http://pmailadmin.sourceforge.net


The older documentation in README.mysql says that if you want to 
convert cdb domains to mysql you should use vconvert; so I think that 
at least cdb and mysql can be used at the same time. Is it right or 
wrong?
I haven't figured out how vconvert does it yet.  I will have to one of 
these days, but not soon.  I still run a straight cdb shop.

My guess is that vconvert actually does cdb within itself, and provides 
one SQL back end, the one you selected at compile time.  Even though the 
program --help seems to imply that you can vconvert from mysql to pgsql 
I don't think it is possible.  I would love it if someone who knows 
would explain it...


I think I'll have to do something on the web app then. Or perhaps try to 
use two sets of vpopmail binaries, which isn't a really appealing 
possibility.
Good luck.  Two servers, or a virtual server where each qmail+vpopmail 
image appeared as a separate machine would be the only ways I would want 
to keep them separate.  If you find a reasonable way, please let us know.

Rick