My accesses are still going to mnesia despite the fact that I have ejabberd 2 with the following ejabberd.cfg line:
{odbc_server, {pgsql, "localhost", "ejabberd", "ejabberd", "********"}}.
with PostgresSQL 8.3 installed with a database named "ejabberd" under user "ejabberd" initialized with pg.sql. Its as though that line wasn't even there but when I change the database name to something else, I do get an error in the ejabberd.log file.
I'm using:
{loglevel, 5}.
and I get no database connect errors when I start up:
=INFO REPORT==== 2008-02-28 09:25:12 ===
I(<0.321.0>:mod_pubsub:152) : pubsub init "ec2-67-202-54-1.compute-1.amazonaws.com" [{access_createnode,
pubsub_createnode},
{plugins,
["default",
"pep"]}]
=INFO REPORT==== 2008-02-28 09:25:12 ===
I(<0.321.0>:mod_pubsub:207) : ** tree plugin is nodetree_default
=INFO REPORT==== 2008-02-28 09:25:12 ===
I(<0.321.0>:mod_pubsub:211) : ** init default plugin
=INFO REPORT==== 2008-02-28 09:25:12 ===
I(<0.321.0>:mod_pubsub:211) : ** init pep plugin
You told ejabberd how he can
You told ejabberd how he can connect to a SQL database.
But you didn't request ejabberd to use it, right? ejabberd allows to use an SQL database for authentication, or for some modules (like mod_roster_odbc...). You need to tell him what exactly you want to store in that external database.
Everything else will be stored in Mnesia.