Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Minor Minor
    • Resolution: Won't Fix
    • Affects Version/s: ejabberd 1.1.4, ejabberd 2.0.0
    • Fix Version/s: master
    • Labels:
      None

      Description

      I have compiled ejabberd source successfully. It is running with internal database.

      but I was trying to connect to mssql server using odbc, in order to do that I did the following:

      in ejabberd.cfg file:
      I commented the following line:

      %

      {auth_method, internal}

      .

      and uncommented the following:

      % For authentification via ODBC use the following:

      {auth_method, odbc}

      .

      {odbc_server, "DSN=ejabberd;UID=sa;PWD=sa"}

      .

      and I executed the mssql script.

      then I started the server and created the "admin" user.

      when I am trying to connect to ejabberd server with admin user, it's showing the following error:

      =ERROR REPORT==== 2007-11-14 18:06:50 ===
      E(<0.255.0>:gen_iq_handler:101) : {{case_clause,
      {error,
      "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'vcard'. SQLSTATE IS: 42S22"}},
      [

      {mod_vcard_odbc,process_sm_iq,3}

      ,

      {gen_iq_handler,process_iq,6}

      ,

      {gen_iq_handler,handle_info,2}

      ,

      {gen_server,handle_msg,6}

      ,

      {proc_lib,init_p,5}

      ]}

      I found one thing:
      when the user tries to connect the server, it's searching for "vcard" column in "vcard" table, but it doesn't exist in mssql.sql file.

      can any one please help me on what's going wrong.

      thanks in advance,
      Kamesh J.

        Activity

        Hide
        Badlop
        added a comment -

        The vcard table should be created by the sql script.

        EJAB-535: New MSSQL 2005 script
        You can find the old and new scripts in the SVN:
        http://svn.process-one.net/ejabberd/trunk/src/odbc/

        However, it seems mod_vcard_odbc only supports MSSQL partially:
        EJAB-748: VCARD module support for MSSQL

        Show
        Badlop
        added a comment - The vcard table should be created by the sql script. EJAB-535 : New MSSQL 2005 script You can find the old and new scripts in the SVN: http://svn.process-one.net/ejabberd/trunk/src/odbc/ However, it seems mod_vcard_odbc only supports MSSQL partially: EJAB-748 : VCARD module support for MSSQL
        Hide
        Christophe Romain
        added a comment -

        MSSQL is not supported and just provided "as this", we'll not working on this issue.

        Show
        Christophe Romain
        added a comment - MSSQL is not supported and just provided "as this", we'll not working on this issue.

          People

          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Days since last comment:
              1 year, 13 weeks, 5 days ago

              Issue deployment