[JDEV] XDB / ODBC

[Michel Oosterbeek]

Hi,

Still having problems here. Right now I'm using:
- Red Hat 7.2
- Jabber 1.4.1
- xdb_sql
- db2 (I connect through ODBC)

All settings seem to be correct (jabber.xml and xdb_sql.xml), all info is
inserted correctly (hostname, user, pw - checked and double checked), but
the connection seems to fail somehow. I have included some debug-info below.
I've kept everything 'basic' (no changes), and the odbc-connection has also
been tested and proved working with other c-programs, so that can't be it.

Any idea what this could be?

Thanks,

Michel.


-= Debug Output =-

Thu Feb 21 13:07:25 2002  xdb.c:41 xdb_results checking xdb packet <xdb
type='result' to='xdb' from='config at -internal' ns='jabberd:xdb_sql:config'
id='0'><xdb_sql xmlns='jabberd:xdb_sql:config'>
    <backend>odbc</backend>
    <connection>
      <host>dbpc</host>
      <db>testdb</db>
      <user>testuser</user>
      <pass>testpw</pass>
    </connection>
    <queries>
      <querydef name='auth-get'>
        <text>
          SELECT password FROM users WHERE username =
&apos;$$username$$&apos;
        </text>
        <bindvar name='user'>$$username$$</bindvar>
        <bindcol name='password' offset='0'/>
      </querydef>
      <querydef name='auth-set'>
        <text>
          UPDATE users SET password = &apos;$$p$$&apos; WHERE username =
&apos;$$username$$&apos;
        </text>
        <bindvar name='user'>$$username$$</bindvar>
        <bindvar name='password'>$$p$$</bindvar>
      </querydef>
    <querydef name
Thu Feb 21 13:07:25 2002  log.c:105 <log type='alert'
from='-internal'>[xdbsql_config_init] cannot connect database :
</log>
Thu Feb 21 13:07:25 2002  log.c:105 <log type='alert'
from='-internal'>[xdb_sql] configuration failed</log>
Thu Feb 21 13:07:25 2002  deliver.c:277 Registering c2s with instance c2s
Thu Feb 21 13:07:25 2002  client.c:440 pthsock_client loading
Thu Feb 21 13:07:25 2002  deliver.c:235 @-internal processing <xdb
type='get' to='config at -internal' from='c2s' ns='jabber:config:pth-csock'
id='0'/>
Thu Feb 21 13:07:25 2002  deliver.c:649 delivering to instance 'c2s'

................

Thu Feb 21 13:07:25 2002  mio.c:1115 io_select to listen on 5269 [(null)]
Thu Feb 21 13:07:25 2002  dnsrv.c:132 DNSRV CHILD: starting
Thu Feb 21 13:07:25 2002  mio.c:1139 io_select starting to listen on 5269
[(null)]Thu Feb 21 13:07:25 2002  dnsrv.c:147 DNSRV CHILD: Read from buffer:
<stream>

Thu Feb 21 13:07:25 2002  deliver.c:460 DELIVER 3:-internal <log
type='alert' from='-internal'>[xdbsql_config_init] cannot connect database :
</log>
Thu Feb 21 13:07:25 2002  deliver.c:649 delivering to instance 'elogger'
20020221T12:07:25: [alert] (-internal): [xdbsql_config_init] cannot connect
database :

Thu Feb 21 13:07:25 2002  deliver.c:460 DELIVER 3:-internal <log
type='alert' from='-internal'>[xdb_sql] configuration failed</log>
Thu Feb 21 13:07:25 2002  deliver.c:649 delivering to instance 'elogger'
20020221T12:07:25: [alert] (-internal): [xdb_sql] configuration failed
Thu Feb 21 13:07:25 2002  mio.c:624 socket 9 has restore karma -100 -=> 50