ejabberd - Comments for "Setup mod_vcard_odbc for mysql"

Should be fixed in ejabberd-2.0.0-rc1

mfoss — Tue, 12 Feb 2008 10:45:20 +0000

chobbs wrote:

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: Relational databases can be used for modules when using non relational authentication. It should be fixed in ejabberd-2.0.0-rc1

What version of ejabberd?

mfoss — Tue, 12 Feb 2008 10:44:52 +0000

Anonymous wrote:

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

mfoss — Tue, 12 Feb 2008 10:40:17 +0000

chobbs wrote:

Also found the port is hardcoded inside src/odbc/ejabberd_odbc.erl with MYSQL_PORT.

This improvement is tracked in Ability to specify MySQL or Postgres port in the config file, and is included since ejabberd 2.0.0-beta1.

Still around

Anonymous — Mon, 07 Jan 2008 21:12:03 +0000

chobbs wrote:

sander wrote:

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?

Thanks for the tip.

chobbs — Sat, 16 Dec 2006 15:27:14 +0000

sander wrote:

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

Bugzilla

sander — Sat, 16 Dec 2006 09:19:08 +0000

chobbs wrote:

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

Looked through the code and

chobbs — Sat, 16 Dec 2006 01:38:57 +0000

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