Subject: Re: systemd / compile from source / Berkeley DB
That's awesome to hear. Please let me know if there is anything I can do to help. I'm not a coder, but I was previously a Unix/Linux Systems Administrator. Also, I would be happy to support financially if it is needed. I run a package mirror for the Devuan project. Happy to help out here to as I can.
Subject: Re: Citadel Server stopped working - created huge amount of db logs
Eventually resolved the issue by restoring last known good backup. It was 47k tranlog files so I felt even if I had a way of applying them manually this would take ages. I am just wondering whether this was a technical glitch or some kind of attack. Would be good to hear if anyone else experienced this in the past and might have gotten to the bottom of it.
Patrick
Tue Aug 08 2023 02:49:39 EDT from p.agsten Subject: Citadel Server stopped working - created huge amount of db logsHello All,
this morning I realized my Linux server was playing up. When checking I found the file system was full. Cause was that citadel last night started to created some hundreds of GBytes worth of db translaction log files (log.XXX). Restarting Citadel did not help, it is not updating the actual db files (cdb.XX) Given the huge amount of data now I also do not have sufficient maneauvring space on the machine to add a backup in parallel. Deleting the tranlogs also does not seem a good idea. Of course I doubt that I would have recieved that amount of mails over night anyway so looks like some sort of internal problem.
Any idea what could have caused this? The mail log does not show errors as far as I can see, just normal mail processing.
Is there a way to manually apply the tranlogs before starting citadel in the hope this solves the issue?
Any ideas are very welcome.
Patrick
The documentation says the Citadel installation will take a while. Should it take a long time when it reaches the point where it says "Restarting Citadel server to apply changes"? If so, I can continue to be patient. Otherwise, do you have any tips as to what I should do if it has truly frozen at this stage? I'm not sure where to go to find logs to show what has transpired so far.
Can you please help me know how to troubleshoot my problem?
I have used the curl https://easyinstall.citadel.org/install | bash command to install the citadel server.
I have used the default settings except the administrator name and password.
I get the following and it stops. I can't find where the logs are kept to review the logs to see why it stops. Can anyone help me?
Restarting Citadel server to apply changes
[************************************************************************....]
I have tried this three times and it stops here every time.
Thank you for any help you can offer.
Ugh!
So a couple days ago Citadel failed to auto-reload the cert files, so I decided to try "doas service citserver restart" but that ended up with an "Unexpectedly terminated" message in the Aides room (also does Citadel not maintain its pid file?).
Now the database is all goobered up! All mew messages don't show up in my mail clients and in WebCit they're just ERROR: #
wtf happened? db_recover and database_cleanup.sh aren't doing shit to correct this. kinda missing some important messages here!
Apparently after using database_verify.sh, firing up citserver again just re-corrupts it? dafuq?
Can we just move to MariaDB instead of whatever this is?
Okay but it also isn't building on FreeBSD. I'll post a FreeBSD VM guide so you can set up a VM and do local testerings.
Sun Aug 27 2023 14:11:09 EDT from IGnatius T FoobarFollow along in the development room and you'll see that I am working as fast as possible to set us up for backends other than Berkeley DB. In other news, the most recent commit fixes the problem some people have been having with the Berkeley DB backend, so we have two ways to win. Believe me, I am as frustrated as you are, and Citadel is my pride and joy so it WILL be addressed.
As of right now, Uncensored is now running on what will hopefully become the next release version of Citadel.
I'm getting MUCH more reliable database performance, and we're working on fixing the FreeBSD compatibility issues.
Just a quick update: the database continues to be far more reliable than in the previous version, and y'all are going to love it. However, it exposed a bug in the full text indexer, which we are working out now.
The next version will drop soon, and you're gonna love it!
Full text search is a nice-to-has, disable it for release and RELEASE.
Also make sure it builds/workses on FreeBSD.
Tue Aug 29 2023 22:54:15 EDT from IGnatius T Foobar
Just a quick update: the database continues to be far more reliable than in the previous version, and y'all are going to love it. However, it exposed a bug in the full text indexer, which we are working out now.
The next version will drop soon, and you're gonna love it!
Full text search is a nice-to-has, disable it for release and
RELEASE.
You know I can't do that. It will break some important workflow at some site that depends on it. I cannot in good conscience release software that is incomplete or has known defects.
The good news is that the indexer isn't locking up anymore when combined with the new and more robust database layer. There is just some cleanup work to do. And yes, I am testing it on FreeBSD.
Search works in so few places these days that it would be an even bigger shame not to have it work in Citadel.
Anyway, it's finished so we don't have to worry about it. The code is more simple, too, eliminating the index cache because modern systems are going to mmap the relevant parts of the database anyway.
All that's left to do is tune it up on FreeBSD, because Kitty asked nicely and needs this soon.
BSD! BSD! BSD! BSD! BSD!
Thu Aug 31 2023 00:27:24 EDT from IGnatius T Foobar
All that's left to do is tune it up on FreeBSD, because Kitty asked nicely and needs this soon.
What about 9Front?
( just kidding )
Thu Aug 31 2023 12:27:24 AM EDT from IGnatius T FoobarCitadel also uses its search index to do things like email address autocompletion.
Anyway, it's finished so we don't have to worry about it. The code is more simple, too, eliminating the index cache because modern systems are going to mmap the relevant parts of the database anyway.
All that's left to do is tune it up on FreeBSD, because Kitty asked nicely and needs this soon.
What about 9Front?
You do the work :)
I like the 9front web site though. I especially like how their "code of conduct" is Asimov's three laws of robotics. It's *almost* as awesome as Citadel's CoC.