Grommunio 2025.1.2 Webmail is extremly slow

gbailey · 2025-04-24T11:54:18+00:00

Hy, i have Grommunio Appliance installed, and since 1 Month, or with 30 Clients, the Webclient is very slow. The Appliance run on Proxmox as KVM with 30GB R...

crpb

gbailey @crpb i would like to open the exchange.sqlite but with the SQLITEBrowser it says it is encrypted.

never heard of any encryption with them.
i often enough use such things to make me a local copy and use sqlitebrowser aswell

ssh root@grom-test-4.test.local sqlite3 -readonly /var/lib/gromox/user/clownflare.de/cb/exmdb/exchange.sqlite3 .dump |sqlite3 moo.db

crpb

gbailey But, it is this refresh from Server Side possible?

you can use grommunio-admin user devices .. for that

e.g. https://community.grommunio.com/d/444-scripting-snippets-notepad/42 which uses the "remove" command but a "resync" is also possible. The help provided by grommunio-admin user devices --help lists all possible commands.

EDIT: or did you mean this search and read/unread "workflow" than no idea 🙈

gbailey

Oh, i see on the gromox-http service, there is a scheme update running.

[2025-05-15 23:31:50.302341]: dbop_sqlite: /var/lib/gromox/domain/homestylingkilga.at: current schema EB-17; upgrading to EB-18.
[2025-05-15 23:31:50.302782]: dbop_sqlite: upgrading /var/lib/gromox/domain/homestylingkilga.at to schema EB-18
[2025-05-15 23:31:50.303620]: dbop_sqlite: Completed upgrade of /var/lib/gromox/domain/homestylingkilga.at in 0.00s.

@crpb ja, i mean the read/unread 😃

WalterH

gbailey If the system is only now updating to EV-18, your system was not patched to the latest version when you carried out the ICS repair. The ICS repair cannot find anything, the additions for the ICS repair have only been in grommunio for a few days.

gbailey

the support has answered, (yeah on this time).

to see more, i must increase the log level on http service in the file /etc/gromox/http.cfg with http_log_level=6, and restart the http service (gromox-http).

after that we hope, to find the problem.

@WalterH if i install parallel a new gromox server from the grommunio Appliance, and i move the exchange.sqlite and the mysql data.
that's possible?
Or is better to copy all the user store content?!

i think i have seen a good manual for that in the forum?! 🤔

rg bailey

crpb

gbailey Or is better to copy all the user store content?!

You basically need the whole folder /var/lib/gromox/user/domain.tld/username (or with ../[0-9]+/[0-9]+/ on older installation), so basically the result of gromox-mbop -u "username" echo-maildir in any case.

The mysql database isn't necessary if you use ldap. In that case you can just create all users with a grommunio-admin ldap downsync.. and then i would just stop the gromox services and delete the folders before moving them in or use rsync with --delete --chmod ug=rwX --usermap=*:gromox --groupmap=*:gromox (or change the permissions after you moved it there)

gbailey i think i have seen a good manual for that in the forum?! 🤔

there isn't really good one but andy put together most things some time ago
https://community.grommunio.com/d/1531-migrieren-eines-grommunio-servers-auf-neuen-server/4

my workflow is basically the same as back when i did my first recovery tests
https://community.grommunio.com/d/307-mailbox-backup/5

EDIT: oh and before i forget to mention it. If it's just for tests than it won't matter but you should migrate the configurations for the x500_org_name= or at least those lines from /etc/gromox/*.cfg

WalterH

crpb or sqlite

do you have a SQLite query to list the search folders?

crpb

WalterH do you have a SQLite query to list the search folders?

Yeah, they will also show up with the simple temp.folderlist

-- FOLDER LOOKUP VIEW VIA FOLDERS INCLUDING PARENT
-- DROP VIEW IF EXISTS temp.folderlist;
CREATE VIEW IF NOT EXISTS temp.folderlist
AS SELECT distinct(p.folder_id),
          p.parent_id,
          f1.propval AS foldername
     FROM folders p
     JOIN folder_properties f1
       ON f1.folder_id = p.folder_id
      AND f1.proptag = 805371935
    ORDER BY p.folder_id
;
SELECT  * FROM temp.folderlist WHERE lower(foldername) LIKE '%search%' ;

crpb

Wobei du auch direkt auf folders.search_flags > 0 nen query machen kannst so wie ich das hier gerade sehe und vergleiche

gbailey

@WalterH thank's for the hint.
after that, the repair script takes 3 Minutes an repair 60k messages. 👍️

@crpb ich dachte auf sqlite darf immer nur 1 Process zugreifen, aber anscheind kann man im Betrieb echt die DB abfragen.
So langsam verstehe ich, warum Sie beim Fork auf sqlite gesetzt haben. 😃

crpb

gbailey @crpb ich dachte auf sqlite darf immer nur 1 Process zugreifen, aber anscheind kann man im Betrieb echt die DB abfragen.

Ich lasse alle diese sachen außerdem immer mit sqlite3 -readonly laufen um ganz sicher zu sein. Also den selector.

Aber ja, dadurch das sqlite3 wal benutzt können da auch mehrere lesen und auch welche schreiben.

WalterH

gbailey after that, the repair script takes 3 Minutes an repair 60k messages.

Is the speed issue now solved?

gbailey

WalterH: After a week, the server is running smoothly again.

So the problem is solved.

Thanks everyone for your help.

« Previous Page