[ejabberd] virtual hosts and ODBC

Safford, Brian brian.safford at eds.com
Wed Mar 7 23:36:38 MSK 2007


I'm trying to setup 2 virtual hosts using MySQL via ODBC.

Is there any magic to doing this?  My /etc/odbc.ini file:

[ejabberd]
Driver          = MySQL
DATABASE        = ejabberd
PWD             = XXXXXXXX
SERVER          = ahbkdb1-2.mail.eds.com
PORT            = 18000
UID             = mailadm

[imrsvcs]
Driver          = MySQL
DATABASE        = ej_imrsvcs
PWD             = XXXXXXXX
SERVER          = ahbkdb1-2.mail.eds.com
PORT            = 18000
UID             = mailadm

My virtual host config :

{host_config, "eim.mail.eds.com",
  [ {odbc_server, "DSN=ejabberd"},
    {auth_method, ldap},
    {ldap_servers, ["ahbkdb1-2.mail.eds.com"]},
    {ldap_port, 17000},
    {ldap_uids, [{"jabberid", "%u"}]},
    {ldap_filter, "(objectClass=inetOrgPerson)"},
    {ldap_base, "ou=eim.mail.eds.com,o=jabber,c=us"},
    {ldap_rootdn, "cn=Manager,o=jabber,c=us"},
    {ldap_password, "XXXXXXXX"},
    {language, "en"},
...


{host_config, "eim.imrsvcs.com",
  [
    {odbc_server, "DSN=imrsvcs"},
    {auth_method, ldap},
    {ldap_servers, ["ahbkdb1-2.mail.eds.com"]},
    {ldap_port, 17000},
    {ldap_uids, [{"jabberid", "%u"}]},
    {ldap_filter, "(objectClass=inetOrgPerson)"},
    {ldap_base, "ou=eim.imrsvcs.com,o=jabber,c=us"},
    {ldap_rootdn, "cn=Manager,o=jabber,c=us"},
    {ldap_password, "XXXXXXX"},
    {language, "en"},
...

The 'imrsvcs' database never gets a connection from the server.

Thoughts?

Regards,

Brian Safford
Senior Consultant
EDS - Managed Messaging Services
1075 W. Entrance Drive
Auburn Hills, MI  48326
+1 248-853-3544



More information about the ejabberd mailing list