Thu Jun 16 2022 18:17:29 EDT from IGnatius T Foobar Subject: Re: Database error back

When I set this Citadel server up a few years ago I used a set of
migrate commands that dumped the database as XML and then imported
the XML,

does anyone know how I can find those commands?

I also recall that because of the size of the database, and the
slowness of the servers I had to set a timeout parameter otherwise
the actions failed,

The program is called "ctdlmigrate" and you run it on the *receiving* system.

And I have good news: this program was substantially re-engineered last year and it is far more performant and reliable than it used to be. We removed the troublesome SSH transport and replaced it with a direct Citadel-to-Citadel connection.

Here's a documentation page showing the instructions, including a pretty screenshot!
[ https://www.citadel.org/how_do_i_move_citadel_to_another_host.html

]

Thanks for this, however I have an older version of the server running (929), and the documents suggest that the sending and receiving servers should be the same version.  Also on a different note I have some Thunderbird users who have accessed the Citade server as a IMAP server, they ran compact which seemed to delete messages on the citadel server, have these messages really been deleted or are they still i the database somewhere, and can they be recovered?
Rgds

Kim

Hello all!

I got Citadel working with my IPA server for LDAP auth. Now for email.

It appears Citadel did not install any email services. 

 netstat -lnp

Active Internet connections (only servers)

Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    

tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1054/sshd           

tcp6       0      0 :::80                   :::*                    LISTEN      64724/webcit        

tcp6       0      0 :::22                   :::*                    LISTEN      1054/sshd           

tcp6       0      0 :::443                  :::*                    LISTEN      64746/webcit        

tcp6       0      0 :::5222                 :::*                    LISTEN      65029/citserver     

raw6       0      0 :::58                   :::*                    7           1039/NetworkManager 

raw6       0      0 :::58                   :::*                    7           1039/NetworkManager 

Active UNIX domain sockets (only servers)

Proto RefCnt Flags       Type       State         I-Node   PID/Program name     Path

unix  2      [ ACC ]     STREAM     LISTENING     61547    6367/sssd_nss        /var/lib/sss/pipes/nss

unix  2      [ ACC ]     STREAM     LISTENING     25936    991/irqbalance       @irqbalance991.sock

unix  2      [ ACC ]     SEQPACKET  LISTENING     15668    1/systemd            /run/udev/control

unix  2      [ ACC ]     STREAM     LISTENING     15680    1/systemd            /run/lvm/lvmpolld.socket

unix  2      [ ACC ]     SEQPACKET  LISTENING     15689    1/systemd            /run/systemd/coredump

unix  2      [ ACC ]     STREAM     LISTENING     41304    6228/systemd         /run/user/0/systemd/private

unix  2      [ ACC ]     STREAM     LISTENING     41312    6228/systemd         /run/user/0/bus

unix  2      [ ACC ]     STREAM     LISTENING     64148    6364/sssd            /var/lib/sss/pipes/private/sbus-monitor

unix  2      [ ACC ]     STREAM     LISTENING     64747    6366/sssd_be         /var/lib/sss/pipes/private/sbus-dp_implicit_files.6366

unix  2      [ ACC ]     STREAM     LISTENING     13717    1/systemd            /run/systemd/journal/stdout

unix  2      [ ACC ]     STREAM     LISTENING     15286    1/systemd            /run/systemd/private

unix  2      [ ACC ]     STREAM     LISTENING     278834   65029/citserver      citadel.socket

unix  2      [ ACC ]     STREAM     LISTENING     278835   65029/citserver      citadel-admin.socket

unix  2      [ ACC ]     STREAM     LISTENING     278846   65029/citserver      lmtp.socket

unix  2      [ ACC ]     STREAM     LISTENING     278847   65029/citserver      lmtp-unfiltered.socket

unix  2      [ ACC ]     STREAM     LISTENING     41693    1/systemd            /var/run/.heim_org.h5l.kcm-socket

unix  2      [ ACC ]     STREAM     LISTENING     16355    1/systemd            /run/dbus/system_bus_socket

And the settings in site settings dont appear to point to a server or service on the local system. 

Do I need to install Dovecot/Postfix to complete the email solution?

Someone smarter than me about the inner workings will reply soon i'm sure, but no you dont need to install a mail service as email is integrated. 

That is what I figured based on what I read but the ports are not open....

Sat Jun 18 2022 04:39:31 PM EDT from IGnatius T Foobar

If citserver failed to bind ports it will tell you in its log. I see that you have citserver answering on port 5222, which is the only port >=1024 that it uses. This suggests to me that you did not start citserver as root and therefore it could not bind to any of the low numbered ports.

Awesome! It was SELinux doing its thing. I set it to permissive and everything works great. Whatever bug I was hitting before with LDAP is now gone too! Thanks for the awesome alternative to corporate email!

Sun Jun 19 2022 09:11:19 AM EDT from IGnatius T Foobar

Awesome! It was SELinux doing its thing. I set it to permissive and
everything works great. Whatever bug I was hitting before with LDAP
is now gone too! Thanks for the awesome alternative to corporate

Ooooh, that's great! I've never seen any use for SELinux other than making stuff not work correctly :)

This might also be good advice for the other person above these messages who had trouble on RHEL. I don't know, maybe it'll work there too.

I am very excited to finally not use my customer-facing product (Virtualmin) for email.

Perchance is there a good calendar app or syncer that would  sync up to Citadel? I expected Google Calendar to do this but it wont run with authentication which I find VERY odd.

I have a working Citadel server, but now that I have a few users set up we've found that if anyone deletes messages they end up in a kind of global trash folder so that anyone on the system can read them!  Thankfully I've just started using this particular Citadel server and it's only for family members but still, this can't be right surely?  How can I fix this so that everyone has their own private trash folders?

Since compiling on the actual Pi took forever the previous time, I´d like to crosscompile using my x64 (Ubuntu 22.04LTS) machine. Is this a viable option? I assume simply running the script would just compile and set-up Citadel on my x64 machine instead of compiling targeting the Pi, right?

Tue Jun 21 2022 08:58:44 EDT from IGnatius T Foobar Subject: Re: Trash folders

up we've found that if anyone deletes messages they end up in a kind
of global trash folder so that anyone on the system can read them! 

That's definitely not the normal behavior. Did someone create a global room called "Trash"? I'd be willing to believe that this could override the normal behavior with some clients (and if we find out this is the case, let us know and we'll code around it).

Yes, that appears to be what happened (though obviously not deliberately, could it have somehow been created by an IMAP client?)  Either way, I deleted the "Trash" and "Trashcan" from the "Main Floor" and it seems OK now.

Hello Volks sorry need help.

I am getting segmentation fault after updating debian stretch to buster:

Thx in advance

Log file:

Jun 27 22:56:08 my kernel: [ 1054.584447] show_signal_msg: 78 callbacks suppressed

Jun 27 22:56:08 my kernel: [ 1054.584456] citserver[3867]: segfault at 10000014c ip 00007ff0323a6198 sp 00007ffeaef906f0 error 4 in libdb-5.3.so[7ff0322d4000+142000]

Jun 27 22:56:08 my kernel: [ 1054.584483] Code: a5 4d 85 e4 74 bc 4c 39 f0 74 a0 31 c0 48 8d 35 96 31 08 00 48 89 ef e8 46 e6 f2 ff b8 16 00 00 00 eb a1 0f 1f 80 00 00 00 00 <41> 8b 94 24 4c 01 00 00 e9 d4 fe ff ff 0f 1f 00 f6 83 ac 05 00 00

Jun 27 22:56:08 my kernel: [ 1054.643175] citserver[3868]: segfault at 10000014c ip 00007ff0323a6198 sp 00007ffeaef906f0 error 4 in libdb-5.3.so[7ff0322d4000+142000]

Jun 27 22:56:08 my kernel: [ 1054.643207] Code: a5 4d 85 e4 74 bc 4c 39 f0 74 a0 31 c0 48 8d 35 96 31 08 00 48 89 ef e8 46 e6 f2 ff b8 16 00 00 00 eb a1 0f 1f 80 00 00 00 00 <41> 8b 94 24 4c 01 00 00 e9 d4 fe ff ff 0f 1f 00 f6 83 ac 05 00 00

Jun 27 22:56:08 my kernel: [ 1054.702374] citserver[3869]: segfault at 10000014c ip 00007ff0323a6198 sp 00007ffeaef906f0 error 4 in libdb-5.3.so[7ff0322d4000+142000]

Jun 27 22:56:08 my kernel: [ 1054.702406] Code: a5 4d 85 e4 74 bc 4c 39 f0 74 a0 31 c0 48 8d 35 96 31 08 00 48 89 ef e8 46 e6 f2 ff b8 16 00 00 00 eb a1 0f 1f 80 00 00 00 00 <41> 8b 94 24 4c 01 00 00 e9 d4 fe ff ff 0f 1f 00 f6 83 ac 05 00 00

Jun 27 22:56:08 my kernel: [ 1054.761006] citserver[3870]: segfault at 10000014c ip 00007ff0323a6198 sp 00007ffeaef906f0 error 4 in libdb-5.3.so[7ff0322d4000+142000]

 

Jun 27 22:56:08 my kernel: [ 1054.761036] Code: a5 4d 85 e4 74 bc 4c 39 f0 74 a0 31 c0 48 8d 35 96 31 08 00 48 89 ef e8 46 e6 f2 ff b8 16 00 00 00 eb a1 0f 1f 80 00 00 00 00 <41> 8b 94 24 4c 01 00 00 e9 d4 fe ff ff 0f 1f 00 f6 83 ac 05 00 00

 

Manual start

root@mygate:~# citserver -x 9

citserver[32092]:  

citserver[32092]:  

citserver[32092]: *** Citadel server engine ***

citserver[32092]: Version 917 (build b47178f) ***

citserver[32092]: Copyright (C) 1987-2018 by the Citadel development team.

citserver[32092]:  

citserver[32092]: This program is open source software: you can redistribute it and/or

citserver[32092]: modify it under the terms of the GNU General Public License, version 3.

citserver[32092]:  

citserver[32092]: This program is distributed in the hope that it will be useful,

citserver[32092]: but WITHOUT ANY WARRANTY; without even the implied warranty of

citserver[32092]: MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

citserver[32092]: GNU General Public License for more details.

citserver[32092]:  

citserver[32092]: libcitadel(unnumbered)

citserver[32092]: main: creating lockfile

citserver[32092]: extensions: registered server command STLS (Start SSL/TLS session)

citserver[32092]: extensions: registered server command GTLS (Get SSL/TLS session status)

citserver[32092]: extensions: registered a new session function (type 0 Priority 30010)

citserver[32092]: master_startup() started

citserver[32092]: Checking directory access

citserver[32092]: Opening databases

citserver[32092]: db: open_databases() starting

citserver[32092]: db: Compiled libdb: Berkeley DB 5.3.28: (September  9, 2013)

citserver[32092]: db:   Linked libdb: Berkeley DB 5.3.28: (September  9, 2013)

citserver[32092]: db:    Linked zlib: 1.2.11

citserver[32092]: db: Setting up DB environment

citserver[32092]: db: dbenv->open(dbenv, /var/lib/citadel/data/, 75043, 0)

citserver[32092]: db: BDB2526 Finding last valid log LSN: file: 424695 offset 2551866

citserver[32092]: db: BDB1518 Recovery complete at Mon Jun 27 23:25:09 2022

citserver[32092]: db: BDB1519 Maximum transaction ID 0 recovery checkpoint [424695][2550648]

citserver[32092]: db: mounting databases

 

citserver[32092]: Initializing configuration system