RE: Webmail client + custom user table

Hello,

> Now I'm curious if anyone (i've seen the rockclimbing.com people) has
> successfully integrated dbmail with their userdb. I have a simple
> requirement, no aliases, just one domain and all user accounts are
> username@domain. I have postfix working with mysql. Now what I would
love
> is to adapt dbmail's schema to use my username field as the alias by
> appending the domain. I have looked through the code and hope to
give it a
> shot, but wondering if anyone can give some advice. This is with
> dbmail-2.0rc2 and it's currently working with default schema with innodb
> tables on mysql.

  You specifically ask about the using your table for aliases - under
postgres you could do that fairly easily by making dbmail's "aliases"
table a custom view.  I don't know if recent mysql's support that or
not, but might be an option.  Also, that won't work for your users
table .. you'd currently have to hack dbmail source to change that.
That is a todo list feature, though.


> Has anyone tried to combine their user authentication system with one of
> the dbmail webmail clients? This seems like an ideal single sign-on
> solution but I read recently here that the dbwebmail PHP package is not
> adapted for version 2.

  This is going to use the users table, not aliases .. again, you'd
have to hack the application to look at your table (though it's
probably not terribly difficult if you know a little sql and php).


> It seems wasteful to use IMAP in a setup where webmail is the only mail
> access method required, otherwise i would try to make squirremail agree
> with my authentication scheme and somehow re-authenticate over imap.
> 
> any thoughts on this kind of setup?

  That's how all IMAP clients work - you give your login/password to
squirrelmail and it authenticates to the server using them.




--
Jesse Norell

administrator@xxxxxxx is not my email address;
change "administrator" to my first name.
--