[JDEV] How to add JIT Transport using xdb_sql for backend

[Ju-Shan Cheng]

I change my configuration about xdb_sql and jit again.
But it still doesn't work. ><

The error picture is shown as:
http://tw.img.photo.yahoo.com/raiccy/ab21/p245.jpg

The XML denug messgae:
<iq type='result' id='JCOM_16' to='laida at lnx1.abc.com.tw/laida_701' from='icq.lnx1.abc.com.tw'>
  <query xmlns='jabber:iq:register'>
    <password/>
    <key>86f18a655d3c633b89d0cd0b9c51fc090e76ba05</key>
    <instructions>Please enter your ICQ UIN and password.
     Username : your UIN.
     Password : your icq password.
 </instructions>
 <registered/>
    <x type='form' xmlns='jabber:x:data'>
      <title>Registration to ICQ by JIT</title>
      <instructions>Please enter your ICQ UIN and password.
        Username : your UIN.
        Password : your icq password.
      </instructions>
   <field type='text-single' var='username' label='UIN'>
     <value/>
   </field>
   <field type='text-private' var='password' label='Password'>
     <value/>
   </field>
   <field type='hidden' var='key'>
     <value>86f18a655d3c633b89d0cd0b9c51fc090e76ba05</value>
   </field>
   <field type='hidden' var='registered'>     ==> I didn't find this when I use xdb_file. Maybe it is something wrong here.
     <value/>
      </field>
    </x>
  </query>
</iq>

The main change in jabber.xml is list below.
I add two xdb block in jabber.xml.
  <xdb id="xdb_jab">
    <host>lnx1.abc.com.tw</host>
    <ns>jabber:iq:roster</ns>
    <ns>jabber:x:offline</ns>
    <ns>jabber:iq:filter</ns>
    <ns>jabber:iq:last</ns>
    <ns>jabber:iq:auth</ns>
    <ns>jabber:iq:auth:0k</ns>
    <ns>jabber:iq:register</ns>
    <ns>vcard-temp</ns>
    <load>
      <xdb_sql>./xdb_sql/xdb_sql.so</xdb_sql>
    </load>
    <jabberd:include>./xdb_sql/xdb_sql.xml</jabberd:include>
  </xdb>
  <xdb id="xdb_icq">
    <host>icq.lnx1.abc.com.tw</host>
    <ns>jabber:iq:roster</ns>
    <ns>jabber:x:offline</ns>
    <ns>jabber:iq:filter</ns>
    <ns>jabber:iq:last</ns>
    <ns>jabber:iq:auth</ns>
    <ns>jabber:iq:auth:0k</ns>
    <ns>jabber:iq:register</ns>
    <ns>vcard-temp</ns>
    <load>
      <xdb_sql>./xdb_sql/xdb_sql.so</xdb_sql>
    </load>
    <jabberd:include>./xdb_sql/xdb_sql.xml</jabberd:include>
  </xdb>
  
In my xdb_sql.xml:
    <connection>
      <host>lnx1.abc.com.tw</host>
      <host>icq.lnx1.abc.com.tw</host>
      <port>3306</port>
      <db>jabber</db>
      <user>jabber</user>
      <pass>secret</pass>
    </connection>

I don't know what wrong is in my configuration.
Any pointer will be helpful.