DB Cleanup befor converting to supported version



  • Hi
    We have a community version which has a user count of 37 but only has 18 real users. How can we clean out the no-name users and the orphaned stores? Thanks

    User list for Default(37):
            Username        Fullname                Homeserver
            ---------------------------------------------------------
            SYSTEM          SYSTEM                  Kopano
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
            executive       Cheryl Prestipino
            compsos         IT Staff
            admin           Local Admin
            administration  Alison Liddy
            tumra           Wilfred Peter
            operations      Gavin Bassini
            leader2         Chris Witana
            rindoparr       Marina Plains
            leader1         Anneleise Baird
            safety          Stephen Doctor
            seniorranger    Senior Ranger
            engagement      Mikayla Down
            culture         Elaine Liddy
            ranger          Ranger Team
            cairnsadmin     YAC Cairns Office
            faxes           Lamalama Faxes
            landandsea      David Miralles
            board           Yintjingga Board
    
    Stores without users:
    Store GUID                              Guessed username        Last login      Store size      Store type
    --------------------------------------------------------------------------------------------------------------
    042d3c1ce944445d8de95d1aed0133be        operations              2y ago          609.59 MB       private
    0d0c90047c5b4837a5d339883219f267        <unknown>               <unknown>       0.00 MB         private
    0d6120ef909d4a36b343f67da5fa4bc9        management              <unknown>       0.00 MB         private
    1656364b0e154436a79fdc7bff4db9c3        compsos                 2y ago          0.01 MB         private
    64e2dcff7f884faea8d166afc45e3e40        ceolap$                 <unknown>       0.00 MB         private
    64f4724e3fa047cab4a0c5390aca4d6d        rindoparr               2y ago          0.00 MB         private
    7e6ed7694a7f49c1a520ede51eeac904        executive               2y ago          8374.12 MB      private
    8122b5b6214449a6a0d851bfcfd48089        administration          2y ago          8945.11 MB      private
    99ee2606ca534175a1a8ada66299641d        leader2                 2y ago          51.82 MB        private
    a3a5039b4852460c8e5d3274145fe77d        safety                  3y ago          1.89 MB         private
    b314806cf8d94e70b55c4a8964014c66        <unknown>               2y ago          4816.15 MB      private
    b379d42001854ae3b1c848e14f43770f        ranger                  2y ago          6.86 MB         private
    b8a2ef92988441b6999474f1354c3f65        culture                 <unknown>       122.32 MB       private
    c377405f583443c6bfa44350b74917dd        leader1                 2y ago          270.77 MB       private
    de104e9e62874c69a25ec498c9e6b671        <unknown>               2y ago          265.43 MB       private
    df413faf940a4304834e9c50ca689de9        engagement              2y ago          712.56 MB       private
    e4b1823d177342b3940a1e8d1f8f70d9        seniorranger            2y ago          100.71 MB       private
    f5220880337c410c973276169c1989ea        <unknown>               2y ago          0.00 MB         private
    fe6a45f180674d5d85f29ebd3e7dfba2        admin                   2y ago          0.00 MB         private
    
    
    
    root@mailx:~# kopano-storeadm -M
    {
            "display_name" : "Inbox - Yintjingga Board",
            "display_name_w" : true,
            "mtime" : 1456887142,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000A4000000636D4A6248697259514B7569426D6D7257444D304B673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - David Miralles",
            "display_name_w" : true,
            "mtime" : 1506470804,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000A30000007577486D4E46725A536865357748347451694F4F4F413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Lamalama Faxes",
            "display_name_w" : true,
            "mtime" : 1456969864,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000A20000003130476B76322B6B533675666C66366E5131646E37513D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - YAC Cairns Office",
            "display_name_w" : true,
            "mtime" : 1543818765,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000A1000000546E38724E464249517A6D7156736F76317031784F773D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Ranger Team",
            "display_name_w" : true,
            "mtime" : 1480644100,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000009F0000006A51772B552B615854447930706F34776863507758513D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Elaine Liddy",
            "display_name_w" : true,
            "mtime" : 1554436057,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000009E0000007030385A547169555335794A334942773277527966673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Mikayla Down",
            "display_name_w" : true,
            "mtime" : 1555901938,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000009D0000005A4C704F657A74445341657675764C414F476F7074413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Senior Ranger",
            "display_name_w" : true,
            "mtime" : 1419296318,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000009C000000393158374C576B57543575486A455336566D746A79413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Wilfred Peter",
            "display_name_w" : true,
            "mtime" : 1555477335,
            "owner" : "00000000AC21A95040D3EE48B319FBA753304425010000000600000095000000727A323447417836544432514D54436F4730557479773D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Stephen Doctor",
            "display_name_w" : true,
            "mtime" : 1419298260,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000009B000000774E467874704544526575534F68502F444F53634D413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Cheryl Prestipino",
            "display_name_w" : true,
            "mtime" : 1555900802,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000910000007753566944384E46516B4F34446E4546724C676833773D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Anneleise Baird",
            "display_name_w" : true,
            "mtime" : 1552365615,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000009A000000326B67466E32766753414F30344F3675466D4E514F673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Marina Plains",
            "display_name_w" : true,
            "mtime" : 1435037640,
            "owner" : "00000000AC21A95040D3EE48B319FBA753304425010000000600000099000000543276337766574B53704343556A426F73577A3162413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Chris Witana",
            "display_name_w" : true,
            "mtime" : 1555901785,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000980000004845627461353637524E2B554E617255672F723141673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Gavin Bassini",
            "display_name_w" : true,
            "mtime" : 1555484633,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000970000006B6F526477744C535266656A694C366A556B71666D413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Alison Liddy",
            "display_name_w" : true,
            "mtime" : 1555901506,
            "owner" : "00000000AC21A95040D3EE48B319FBA753304425010000000600000094000000555241786449554352334B642B75325446695A726B413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - Local Admin",
            "display_name_w" : true,
            "mtime" : 1555894692,
            "owner" : "00000000AC21A95040D3EE48B319FBA753304425010000000600000093000000326F5A2F59495371547A71743441754B436C344C30413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - IT Staff",
            "display_name_w" : true,
            "mtime" : 1503279159,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000009200000049756854584C6659546F4B69393973394E55685155413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1419055504,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000008F0000004E5441324F413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1417762640,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000008A0000004E5441324E513D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1407371644,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000870000004E5441324D773D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1385688904,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000620000004E5441304D413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1418281634,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000005F0000004E54417A4E773D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1418004109,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000005E0000004E54417A4E673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1418791719,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000005B0000004E54417A4D773D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1365655062,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000005D0000004E54417A4E513D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1419214991,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000005C0000004E54417A4E413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1342043405,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000008000000190000004E5441794E513D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1342041603,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000180000004E5441794D673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1407382450,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000610000004E54417A4F513D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1361428757,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000000D0000004E5441784E413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1402915693,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000005A0000004E54417A4D673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1396836065,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442501000000060000000B0000004E5441784D673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1419043091,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000600000004E54417A4F413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1418890257,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000630000004E5441304D673D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Public Folders",
            "display_name_w" : true,
            "mtime" : 1341010501,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442500000000080000000100000000000000",
            "type" : "public"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1407374716,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000040000004E5441774D413D3D00000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - ",
            "display_name_w" : true,
            "mtime" : 1419205524,
            "owner" : "00000000AC21A95040D3EE48B319FBA7533044250100000006000000550000004D54417800000000",
            "type" : "private"
    }
    {
            "display_name" : "Inbox - SYSTEM",
            "display_name_w" : true,
            "owner" : "00000000AC21A95040D3EE48B319FBA75330442500000000060000000200000000000000",
            "type" : "private"
    }
    
    User counts:
                            Allowed         Used    Available
            --------------------------------------------------------
            Active          no limit        35      -
            Non-active      no limit        1       -
              Users                         1
              Rooms                         0
              Equipment                     0
            Total                           36
    
    Insert Code Here
    

  • Kopano

    Hi @compsos,

    those empty lines in the user listing look strange. Since you seem to have a subscription I would recommend to get in direct contact with our support so that they can have a direct look at the database.



  • Hi Felix
    No subscription for this client yet. That is actually the point. That we are trying to get a real user list for the license.
    There is a script (db-find-missingattachments.pl) to check on the links to attachments that no longer “connected” and it returns 5078 files. Could it be that these stores have links to the external file storage? Total file store 305357.
    Any ideas on how we can “clean up”?
    If we try to remove the stores we get

     kopano-storeadm -R 1656364b0e154436a79fdc7bff4db9c3
    [error  ] RemoveStore: collision (80040604)```

  • Kopano

    @compsos said in DB Cleanup befor converting to supported version:

    That we are trying to get a real user list for the license.

    at this point in time the server is not limiting the amount of users that can be created and since you know how many people you have at your company that interact with email this number should be “good enough”.

    but if you are at the moment trying to convince the customer to go for a subscription then the situation can work in your favor: “hey $customer, I have here a problem that I cannot solve myself, shall I get in contact with the Kopano support for your?”. I am sure that in anticipation of a subscription bought something can be worked out that works for all involved parties.

    If you still decide against contacting our support then I would at first look at the empty lines in the user listing. As explained in our trainings these users map to entries in the “users” table in the database. Look in there if you can find something that connects to these empty lines. Only once you have the user list cleaned up I would start thinking about cleaning up stores or attachments.

    And as always: “Remember to make a backup!”



  • Thanks Felix
    I will apply for license based on the users and see where we can get from there. Thanks



  • @compsos Felix Is there an email that I can send to support to sort this? Just in the partner portal but nothing obvious.


  • Kopano

    @compsos I think my colleges prefer when tickets are opened through https://portal.kopano.com/sdtickets. Since you currently do not have a subscription to map this ticket to you could also send a mail to info at kopano dot com and ask them to forward the mail.


Log in to reply