Authentication via ODBC possible?

[pcatiprodotnet]

Greetings,
Is it possible to authenticate users via ODBC? If not, does Zimbra have a JDBC or PostgreSQL.org driver?
Thank you,
-pc

[schemers]

Not currently. At this point we only support internal or an external LDAP connection. I'm planning on providing more extensive support for other mechanisms in the near feature though, including a way for someone to write their own.

People adventurous enough to play with source can look at authAccount in LdapProvisioning.java in ZimbraServer.

roland

[pcatiprodotnet]

I never used "LDAP", is there an easy way to export username/password list from MS Access to be accessable by Zimbra? And perhaps even batch it to export every 10mins or so?

[schemers]

If you have the cleartext password, then you could use the zmprov program to create accounts and/or set the password if it changes.

to create accounts:

/opt/zimbra/bin/zmprov ca account@your.domain thepassword [other attrs]

to set the password on an existing account:

/opt/zimbra/bin/zmprov sp account@your.domain thepassword

roland