[sork] RE: Vpasswd+vpopmail+mysql many-domains enabled problem

[phasma]

Quoting Eric Rostetter <eric.rostetter at physics.utexas.edu>:

-> 
-> > Database: vpopmail
-> > +--------------------+
-> > |       Tables       |
-> > +--------------------+
-> > | try1_org		   |
-> > | dir_control        |
-> > | lastauth           |
-> > | try2_org   	   |
-> > | try3_com		   |
-> > | relay              |
-> > | try4_net	         |
-> > | valias             |
-> > | vlog               |
-> > | try5_org           |
-> > +--------------------+
-> 
-> Okay, so your tables are try1_org, try2_org, try3_com, 
-> try4_net, and try5_org?
-> If so, I assume those tables correspond to the domains 
-> try1.org, try2.org, try3.com, try4.net, and try5.org?
-> 

right

-> > As we can see, a table is created for each domain, and in 
-> that table 
-> > we have "pw_name" "pw_passwd" and "pw_clear_passwd".
-> 
-> If the above mapping is correct, then you need to map *.* to 
-> *_*.  But first you need to get *.* to start.  If your 
-> configuration is such that you login with a FQDN, then you 
-> can use Auth::getAuth() to get user@*.*, and then from that 
-> get *.* and convert it to *_*.  This assumes there will be 
-> nothing else in the domain (e.g. not mail.*.* or www.*.* or similar).
-> 

Uhmmm, in my imp servers.php conf i have:

$servers['imap'] = array(
    'name' => 'IMAP Server',
    'server' => 'localhost',
    'hordeauth' => 'full',
    'protocol' => 'imap/notls',
    'port' => 143,
    'folders' => 'INBOX.',
    'namespace' => '',
    'maildomain' => '',
    'smtphost' => 'localhost',
    'realm' => '',
    'preferred' => '',
    'dotfiles' => true,
    'hierarchies' => array()

With "'hordeauth' => 'full'", we pass user at domain.com or
user at whatever.domain.com to imap auth, so in our case, could we use
"hordeauth" to get fully user, strip "username@", and convert "." of domain
in "_" ? As result we'll have the domain_com or whatever_domain_com, that is
the correct name of the table to use in passwd module "'table' => ''". Could
be a general way to do that ? I'm wrong?

-> If each domain has its own web address, then you can get the 
-> address from the server name.  This is fairly easy to do.
-> 

Yes, every domain has own webmail.domain.com address... And all have as
document_root $HTTP_ROOT/horde/imp and Alias $HTTP_ROOT/horde, where
$HTTP_ROOT is static.


-> If neither is set, but you have a realm set in imp, then we 
-> can probably grab the realm from imp.  But if you don't know 
-> how to setup passwd, you probably didn't know how to setup 
-> imp this way, so this is *probably* not the case.
-> 

No, i haven't set a realm

-> So, basically we need to know how they login so we can try 
-> to determine where to get the realm info from.  Once we have 
-> the realm info, we can convert it to the right format and 
-> use it for the table name.
-> 

Hoping my reply is usefull, regards

p