[JDEV] XDB / ODBC

[raditha dissanayake]

there is a function called xdbodbc_query in xdb_sql_odbc.c
If you add a debug messeage to echo out the query that is be query that 
is being executed you will be able to pin point the error.

be warned that some of the transports are not 100% with xdb_sql but 
basic authentication works ok.


Michel Oosterbeek wrote:

> 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
> 
> 
> 
> _______________________________________________
> jdev mailing list
> jdev at jabber.org
> http://mailman.jabber.org/listinfo/jdev
> 



-- 
Raditha Dissanayake
raditha at mediasolv.com
http://www.mediasolv.com/?rd