1 Reply Latest reply on Oct 14, 2016 12:27 PM by DiogoSM

    CHANGING USERS JID - HISTORY OF PREVIOUS DISCUSSIONS DBACCESS

    DiogoSM

      Hello Dear, How are you?

       

      Hope so ...

       

      I'm getting an environment where it is with the following scenario:

       

      Windows 2008 Enterprise R2 x64

      PostgreSQL 9.1

      Openfire 4.0.3

      Customer does not use LDAP

       

      Domain Name:

      DomainClient.local

       

      Current Name Server:

      SRVMSG01

       

      And what's happening is that it came migrated from other 3 servers, always in need of new facilities.

      The names of the other servers were:

      Year 2011 - SRVCadilac

      2014 - SRV Zeus

      2015 - SVRClient

      Currently - SRVMSG01

       

      NOTE: (A T.I. is a nut that client, as amended multiple servers, with no default ... lol).

       

       

      Thus what happens is as follows:

       

      In seeking a conversation in previous periods by entering only the names of users, it is only the conversations that are since the last migration forward.

      In order to find the above have to type in the User field the user_name @ nomedoantigoservidor, for example:

       

      User: John

      To char the latest conversations, just type the name joao User and hit search, but it does not list john conversations the 2011, 2014, 2016.

      To be able to find I need to type:

      2011:

      joe @ SRVCadilac

       

      2014:

      joe @ SRVZeus

       

      2015:

      joe @ SRVClient

       

      My questions are:

       

      1 - Considering the possible BUG, or new form of authentication Spark 2.8.0 to 4.0.3 openfire, I can leave the domain name in the spark with the server name, for not having certificate problems?

       

      2 - How do I change all former members who for example @SRVCadilac by SRVMSG01 to regularize the conversation history through DBAccess the OpenFire plugin?

       

      Tks

        • Re:  CHANGING USERS JID - HISTORY OF PREVIOUS DISCUSSIONS DBACCESS
          DiogoSM

          Guys, I just wanted to know how I can change the JID of users who are in the old conversations, anyone out there know how this can be done?

          Type a command that can be executed by the plugin dbaccess where replace the database all JIDs who are on the bench that have @SRVCadilac or @SRVZeus or @SRVCliente by @ SRVMSG01

          My knowledge is very basic in the database, is that no kind soul has knowledge of how to do this?

          TKS