headers
Kevin Jackson | 1 Feb 2007 13:08
Picon
Gravatar

Hardcoded database queries for odbc authentication

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
Permalink | Reply | 5 comments |
headers
Peter Saint-Andre | 1 Feb 2007 19:17

cert patch

Has the patch for correct presentation of the certificate chain been 
tested? Does it work? Is it stable? Will it be rolled into 1.1.3? I'd 
like to make sure the jabber.org server is doing the right thing. :-)

Peter
Attachment (smime.p7s): application/x-pkcs7-signature, 7358 bytes
_______________________________________________
ejabberd mailing list
ejabberd <at> jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Permalink | Reply | 1 comment |
headers
Jaco Kroon | 1 Feb 2007 19:34
Picon

Re: cert patch

Peter Saint-Andre wrote:
> Has the patch for correct presentation of the certificate chain been
> tested? Does it work? Is it stable? Will it be rolled into 1.1.3? I'd
> like to make sure the jabber.org server is doing the right thing. :-)
> 
> Peter

tlug.up.ac.za is running that patch and it's working correctly, so my
vote goes to roll it in.

Jaco
Permalink | Reply | 0 comments |
headers
C00I90WN | 1 Feb 2007 19:13

MySQL problem?

I can't retrieve the roster users from the MySQL db, here is the error:

=CRASH REPORT==== 1-Feb-2007::17:04:27 ===
crasher:
pid: <0.209.0>
registered_name: []
error_info: {undef,[{mysql_conn,start,
["localhost",
3306,
"lsjabber",
"PASSWORD",
"litestep_jabber",
#Fun<ejabberd_odbc.1.125926014>]},
{ejabberd_odbc,mysql_connect,4},
{gen_server,init_it,6},
{proc_lib,init_p,5}]}
initial_call: {gen,init_it,
[gen_server,
<0.208.0>,
<0.208.0>,
ejabberd_odbc,
["litestep.com"],
[]]}
ancestors: ['ejabberd_odbc_sup_litestep.com',ejabberd_sup,<0.37.0>]
messages: []
links: [<0.208.0>]
dictionary: []
trap_exit: false
status: running
heap_size: 233
stack_size: 21
reductions: 125
neighbours:
 
=SUPERVISOR REPORT==== 1-Feb-2007::17:04:27 ===
Supervisor: {local,
'ejabberd_odbc_sup_litestep.com'}
Context: start_error
Reason: {undef,[{mysql_conn,start,
["localhost",
3306,
"lsjabber",
"PASSWORD",
"litestep_jabber",
#Fun<ejabberd_odbc.1.125926014>]},
{ejabberd_odbc,mysql_connect,4},
{gen_server,init_it,6},
{proc_lib,init_p,5}]}
Offender: [{pid,undefined},
{name,1},
{mfa,{ejabberd_odbc,start_link,["litestep.com"]}},
{restart_type,transient},
{shutdown,brutal_kill},
{child_type,worker}]
_______________________________________________
ejabberd mailing list
ejabberd <at> jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Permalink | Reply | 3 comments |
headers
Mickaël Rémond | 2 Feb 2007 08:51
Favicon
Gravatar

Re: Re: New ejabberd Windows installer

Hello,

Le 29 janv. 07 à 21:57, Alexander Gnauck a écrit :

Hi Mickaël,

ya this installer is very cool and easy.

Thank you :)

I tried to get ejabberd working with a mySQL database on windows but had no luck. Is mySQL supported on windows?
I followed this tutorial:

Yes, it is supported and it should work.

Cheers,

-- 
Mickaël Rémond

 

_______________________________________________
ejabberd mailing list
ejabberd <at> jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Permalink | Reply | 2 comments |
headers
Mickaël Rémond | 2 Feb 2007 08:52
Favicon
Gravatar

Re: Re: New ejabberd Windows installer

Hello,

Thank you for your feedback.
We will work on improving the enabled feature set as you suggest.

Thank you !

Le 30 janv. 07 à 19:24, Konstantin Khomoutov a écrit :

On Fri, Jan 26, 2007 at 11:44:18PM +0100, Micka?l R?mond wrote:

ejabberd Windows installer has been updated:
[...]
Your feedback is welcome :)
Installs and works smoothly on WinXP SP2.

But I would suggest several tweaks of the packaged config file:
* Fix paths to the server certs -- now they coniain two
  backslashes in each path I have seen, and those backslashes
  render their paths unreadable for ejabberd (since they create
  escape symbols in that paths).
* Enable STARTTLS on 5222 and SSL on 5223 per default.
* Enable zlib on 5222 per default.

The latter two propositions are to make just installed ejabberd
as much feature-rich as possible thus allowing for quick testing
of its features.

Also, I don't know whether it's at all possible, but not leaving
the service in the "running" state if ejabberd failed to start
would give a clear hint to the administrator, which is now
must resort to peeking to the end of the log file or run
netstat to look if the XMPP ports are being listened on.

_______________________________________________
ejabberd mailing list

-- 
Mickaël Rémond

 

_______________________________________________
ejabberd mailing list
ejabberd <at> jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Permalink | Reply | 0 comments |
headers
Mickaël Rémond | 2 Feb 2007 08:54
Favicon
Gravatar

Re: Hardcoded database queries for odbc authentication

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.

Best regards,

-- 
Mickaël Rémond

 

_______________________________________________
ejabberd mailing list
ejabberd <at> jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Permalink | Reply | 4 comments |
headers
Mickaël Rémond | 2 Feb 2007 08:57
Favicon
Gravatar

Re: MySQL problem?

Hello,

Le 1 févr. 07 à 19:13, C00I90WN a écrit :

I can't retrieve the roster users from the MySQL db, here is the error: error_info: {undef,[{mysql_conn,start,

It means that you do not have installed the MySQL module, available here:


-- 
Mickaël Rémond

 

_______________________________________________
ejabberd mailing list
ejabberd <at> jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Permalink | Reply | 2 comments |
headers
Sander Devrieze | 2 Feb 2007 10:33
Picon

Re: Hardcoded database queries for odbc authentication

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.
Permalink | Reply | 0 comments |
headers
Alexander Gnauck | 2 Feb 2007 13:12
Picon
Gravatar

Re: New ejabberd Windows installer

Mickaël Rémond wrote:
> Yes, it is supported and it should work.

it's working now, no idea what was wrong, sometimes restarts help on 
windows ;-)

Alex
Permalink | Reply | 1 comment |

Gmane