Erlang Mailing Lists
Author Message

<  Ejabberd mailing list  ~  Hardcoded database queries for odbc authentication
Guest
Posted: Thu Feb 01, 2007 12:09 pm Reply with quote
Guest
Hi all,

I'm trialling ejabberd on a project and a problem has arisen
concerning the hardcoded db schema for postgresql.

Basically ejabberd seems to expect a table (or view) called users in
the public schema. Unfortunately I already have a requirement on a
users table and I cannot alter the tabel to fit ejabberd's needs.

Looking in src/odbc, it looks like the pg.sql schema file would be
easy to change to meet my needs, but I'd also have to change all the
queries in odbc_queries.erl, and I have little to no erlang experience
beyond some basic tutorials.

Is there a non-hardcoded version of ejabberd in the works (svn) that
reads the odbc queries from a config file instead of having them
compiled in?

Thanks,
Kev
_______________________________________________
ejabberd mailing list
ejabberd@jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Post recived from mailinglist
Back to top
Guest
Posted: Fri Feb 02, 2007 7:54 am Reply with quote
Guest
Hello,
Le 1 f
Back to top
Guest
Posted: Fri Feb 02, 2007 9:33 am Reply with quote
Guest
Op vrijdag 2 februari 2007 08:54, schreef Mickaël Rémond:
> Hello,
>
> Le 1 févr. 07 à 13:08, Kevin Jackson a écrit :
> > Hi all,
> >
> > I'm trialling ejabberd on a project and a problem has arisen
> > concerning the hardcoded db schema for postgresql.
> >
> > Basically ejabberd seems to expect a table (or view) called users in
> > the public schema. Unfortunately I already have a requirement on a
> > users table and I cannot alter the tabel to fit ejabberd's needs.
>
> There is no version with configurable database table names.
> This is a common situation for application to have their own schema.
> If you have specific need, our suggestion is indeed to modify the code.

I even believe there is a feature in PostgreSQL to handle hardcoded schema's.

--
Mvg, Sander Devrieze.
_______________________________________________
ejabberd mailing list
ejabberd@jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Post recived from mailinglist
Back to top
Guest
Posted: Fri Feb 02, 2007 2:51 pm Reply with quote
Guest
Hi,

On Feb 2, 2007, at 7:54 AM, Micka
Back to top
Guest
Posted: Fri Feb 02, 2007 5:04 pm Reply with quote
Guest
Micka
Back to top
Guest
Posted: Fri Feb 02, 2007 5:15 pm Reply with quote
Guest
Op vrijdag 2 februari 2007 18:04, schreef Jaco Kroon:
<snip>
> I've also found it handy to hack together a "view" in another
> "database". So for mysql you create a database called "ejabberd" or
> something and then use create view foo select ???,??? from
> actualdb.table where ... etc. Probably not the most efficient solution
> in general, and views can't be updated most of the time, but it might
> work for your needs.

http://lists.jabber.ru/pipermail/ejabberd/2006-September/002117.html

--
Mvg, Sander Devrieze.
_______________________________________________
ejabberd mailing list
ejabberd@jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Post recived from mailinglist
Back to top

Display posts from previous:  

All times are GMT
View next topic
View previous topic
Page 1 of 1
Erlang Forum - Trap Exit Forum Index  ~  Ejabberd mailing list
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
Hosted by Erlang Solutions    |    Powered by phpBB and NoseBleed v1.14