ejabberd - Comments for "Native PostgreSQL support"

postgre document

wysxs — Tue, 10 Jan 2006 22:32:56 +0000

Waiting for postgre document. thanks a lot

ODBC Docs

Trivial — Tue, 03 Jan 2006 09:14:10 +0000

How far are you? Is it possible to post what you have done so far?

Yes. I have started writing

mremond — Wed, 21 Dec 2005 17:50:47 +0000

Yes. I have started writing an ODBC document. Not yet ready however, but I will publish it soon.

--
Mickaël Rémond

Jungerl build chain is not

mremond — Wed, 21 Dec 2005 17:47:29 +0000

Jungerl build chain is not intended to be issued at the library level but for the whole Jungerl compilation.

You could simply type erlc *.erl in the jungerl pgsql library.

--
Mickaël Rémond

Failed to compile PGSQL library

Trivial — Wed, 21 Dec 2005 09:03:51 +0000

Retrieved the PGSQL code from the sourceforge CVS server and tried to compile it.
---------------------------------------------------
[186] root@lilo:~/tmp/jungerl/lib/pgsql# make
(cd src;make)
"Makefile", line 1: Could not find ../../../support/include.mk
make: fatal errors encountered -- cannot continue
*** Error code 1

Stop in /root/tmp/jungerl/lib/pgsql.
---------------------------------------------------
Looks like the include.mk file is missing. There is a include.mk.in file. I renamed the file to include.mk, but it still wouldn't compile.

---------------------------------------------------
[211] root@lilo:~/tmp/jungerl/lib/pgsql# make
(cd src;make)
"../../../support/include.mk", line 25: Need an operator
"../../../support/include.mk", line 27: Need an operator
"../../../support/include.mk", line 29: Need an operator
"../../../support/include.mk", line 31: Need an operator
make: fatal errors encountered -- cannot continue
*** Error code 1

Stop in /root/tmp/jungerl/lib/pgsql.
---------------------------------------------------

What am I missing? It would be much appreciated if someone could please nudge me in the right direction.

Re: Preliminary instructions

sander — Thu, 15 Dec 2005 19:40:45 +0000

badlop wrote:

I'll ask if this is the correct method. Maybe somebody is able to write a nice tutorial.

Mickaël said he has very detailed documentation for ODBC and PostgreSQL.

Preliminary instructions

mfoss — Thu, 15 Dec 2005 19:28:47 +0000

It seems the documentation does not cover this yet, and the example config does not include any example.

Preliminary instructions to use PostgreSQL native support:

Install the library: PGSQL
Create the database
Import the file ejabberd/src/pg.sql to the new database

Configure ejabberd to use this method. On ejabberd.cfg

{auth_method, odbc}.
{odbc_server, {pgsql, Server, Database, Username, Password}}.

Example values:

{odbc_server, {pgsql, "localhost", "erlang_example", "cos", ""}}.

Start ejabberd on interactive mode (removing Erlang options such as -detached) and call manually the functions exported by the module ejd2odbc to generate SQL formatted dump files.

Note that even if the configuration seems to use ODBC, ejabberd uses in fact the pgsql library, with no ODBC involved.

I'll ask if this is the correct method. Maybe somebody is able to write a nice tutorial.