I am having trouble getting ejabberd to use mod_vcard_odbc through mysql. There are a few problems that I am hitting in trying to get it configured. Main problem is that it seems to require using ODBC for the auth_method in order to make a connection to mysql. I need to use external auth and just use mysql for the vcard information. How do I get this setup so that it will only use mysql for that portion? Also, if anybody knows how to tell ejabberd to use mysql on a different port other than the standard 3306 that would be great too. Thanks.
- Chris
Looked through the code and
Looked through the code and sure enough you have to use ODBC for the auth_method in order to enable ODBC for anything at all. It is the only module that starts up the ODBC supervisor. Ended up copying the start_child code to the mod_vcard_odbc module's Start function. It makes the connection and seems to work okay.
Also found the port is hardcoded inside src/odbc/ejabberd_odbc.erl with MYSQL_PORT.
Hopefully this info will help somebody else in need of activating only part of the functionality. It would be great if the config somehow actived the database connection when it saw the odbc_server entry instead of depending on the auth_method to do that step.
- Chris
Bugzilla
It would be great if the config somehow actived the database connection when it saw the odbc_server entry instead of depending on the auth_method to do that step.
Maybe you can add an entry to the bug and wishes tracker?
--
sander
Thanks for the tip.
Maybe you can add an entry to the bug and wishes tracker?
--
sander
Ah ... didn't even realize there was a link to that on here. Still hobbling around. :) Thanks.
- Chris
Still around
Maybe you can add an entry to the bug and wishes tracker?
--
sander
Ah ... didn't even realize there was a link to that on here. Still hobbling around. :) Thanks.
- Chris
It is 2008 now and I am still experiencing this on Ubuntu 7.10
Whenever I upgrade I have to patch this stuff again.
Is it just me or has this issue simply not found its way into process-one's jira, yet?
What version of ejabberd?
It is 2008 now and I am still experiencing this on Ubuntu 7.10
Whenever I upgrade I have to patch this stuff again.
The important is which version of ejabberd you are trying. 1.1.4 is known to have this problem. It should be fixed since 2.0.0-beta1. Did you try with the recent ejabberd 2.0.0-rc1, and you still suffer the problem?
Configurable database port
Also found the port is hardcoded inside src/odbc/ejabberd_odbc.erl with MYSQL_PORT.
This improvement is tracked in , and is included since ejabberd 2.0.0-beta1.
Should be fixed in ejabberd-2.0.0-rc1
I am having trouble getting ejabberd to use mod_vcard_odbc through mysql. There are a few problems that I am hitting in trying to get it configured. Main problem is that it seems to require using ODBC for the auth_method in order to make a connection to mysql.
This problem is tracked here: . It should be fixed in ejabberd-2.0.0-rc1