Language:
switch to room list switch to menu My folders
Go to page: 1 [2] 3 4 5 6 ... Last
[#] Tue Jun 14 2022 12:58:36 EDT from KimValentine

Subject: Database Error

[Reply] [ReplyQuoted] [Headers] [Print]

Sorry if this is a duplcate.

I got this message:

Ive got a database error message
//


citserver[1288]:
citserver[1288]:
citserver[1288]: *** Citadel server engine ***
citserver[1288]: Version 929 (build f59e2e677) ***
citserver[1288]: Copyright (C) 1987-2020 by the Citadel development team.
citserver[1288]:
citserver[1288]: This program is open source software: you can redistribute it and/or
citserver[1288]: modify it under the terms of the GNU General Public License, version 3.
citserver[1288]:
citserver[1288]: This program is distributed in the hope that it will be useful,
citserver[1288]: but WITHOUT ANY WARRANTY; without even the implied warranty of
citserver[1288]: MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
citserver[1288]: GNU General Public License for more details.
citserver[1288]:
citserver[1288]: libcitadel(unnumbered)
citserver[1288]: Checking directory access
citserver[1288]: Opening databases
citserver[1288]: db: mounting databases
citserver[1288]: Initializing configuration system
citserver[1288]: Creating base rooms (if necessary)
citserver[1288]: Seeding the pseudo-random number generator...
citserver[1288]: control: sanity checking the recorded highest message and room numbers
citserver[1288]: db: cdb_fetch(4): BDB0075 DB_PAGE_NOTFOUND: Requested page not found

Message from syslogd@citadel at Jun 14 17:53:47 ...
 citserver[1288]: db: cdb_fetch(4): BDB0075 DB_PAGE_NOTFOUND: Requested page not found

Broadcast message from systemd-journald@citadel (Tue 2022-06-14 17:53:47 BST):

citserver[1288]: db: cdb_fetch(4): BDB0075 DB_PAGE_NOTFOUND: Requested page not found

I tried
cd /usr/local/citadel/data; /usr/local/ctdlsupport/bin/db_recover -c

and got :
db_recover: BDB1520 Recovery function for LSN 597 28 failed on forward pass
db_recover: BDB0061 PANIC: No such file or directory
db_recover: BDB1544 process-private: unable to find environment
db_recover: DB_ENV->open: BDB0087 DB_RUNRECOVERY: Fatal error, run database recovery


Then tried .\database_cleanup.sh and got this:


Citadel Database Cleanup
---------------------------

This script exports, deletes, and re-imports your database.  If you have
any data corruption issues, this program may be able to clean them up for you.

Please note that this program does a Berkeley DB dump/load, not a Citadel
export.  The export files are not generated by the Citadel export module.

WARNING #1:
  MAKE A BACKUP OF YOUR DATA BEFORE ATTEMPTING THIS.  There is no guarantee
  that this will work (in case of disk full, power failure, program crash)!

WARNING #2:
  citserver must NOT be running while you do this.

WARNING #3:
  Please try "cd /usr/local/citadel/data; /usr/local/ctdlsupport/bin/db_recover -c" first. Run citserver afterwards to
  revalidate whether its fixed or not, No news might be good news. Use this
  tool only if that one fails to fix your problem.

WARNING #4:
  You must have an amount of free space on your disk that is at least twice
  the size of your database, see the following output:
  (for substantially better performance you should specify a location that is
   on another disk than /usr/local/citadel/data)

Filesystem      Size  Used Avail Use% Mounted on
udev            961M     0  961M   0% /dev
tmpfs           196M   19M  178M  10% /run
/dev/sda1        96G   26G   66G  29% /
tmpfs           976M     0  976M   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           976M     0  976M   0% /sys/fs/cgroup
tmpfs           196M   16K  196M   1% /run/user/116
tmpfs           196M     0  196M   0% /run/user/1000

you will need 5.0G       of free space.

Do you want to continue? Y

DO NOT INTERRUPT THIS PROCESS.

Dumping cdb.00
Dumping cdb.01
Dumping cdb.02
Dumping cdb.03
Dumping cdb.04
Exiting

citserver then started OK, but the cloent usernames and passwords were not recognised,
Any ideas on how I can startt and recover the data?
regards
Kim



[#] Tue Jun 14 2022 13:50:51 EDT from IGnatius T Foobar

Subject: Re: Database Error

[Reply] [ReplyQuoted] [Headers] [Print]

database_cleanup.sh looks like it exited prematurely. It should dump far more than five databases, and it should then load them all back in.

[#] Tue Jun 14 2022 18:44:52 EDT from KimValentine

Subject: Re: Database Error

[Reply] [ReplyQuoted] [Headers] [Print]

I ran the db_baclup and db_restore commands manually and citserver has now started successfully.
Thanks for pointing out the failure.

Rgds

Kim



[#] Tue Jun 14 2022 19:19:26 EDT from IGnatius T Foobar

Subject: Re: Database Error

[Reply] [ReplyQuoted] [Headers] [Print]

Excellent! Happy to hear that it worked, and we'll take a peek to see if there's a reason the script stopped early.

[#] Wed Jun 15 2022 10:21:26 EDT from jldavila

Subject: Re: Easy Install Error

[Reply] [ReplyQuoted] [Headers] [Print]

On Red Hat Enterprise.



[#] Wed Jun 15 2022 20:28:21 EDT from IGnatius T Foobar

Subject: Re: Easy Install Error

[Reply] [ReplyQuoted] [Headers] [Print]


Ok, I don't have access to that operating system since it costs a lot of money, but we can try a few things.

First, see if you can start Citadel Server from the command line:

cd /usr/local/citadel
./citserver -x9

If it looks like it's running, try running setup from another terminal. If it crashes, please post the last screenful of output.

[#] Thu Jun 16 2022 10:51:41 EDT from jldavila

Subject: Re: Easy Install Error

[Reply] [ReplyQuoted] [Headers] [Print]

First of all, thanks for your response. I had not seen it till after trying to install again and got back the same error indicated in previous message. So I followed your instructions and this is what I got back. I also checked the status of citadel service which indicated that it failed to start as you can see.

 



[#] Thu Jun 16 2022 13:07:25 EDT from KimValentine

Subject: Database error back

[Reply] [ReplyQuoted] [Headers] [Print]

hi guys

when I  putty into my server I get these broadcast messages

Message from syslogd@citadel at Jun 16 18:00:58 ...
 citserver[4312]: db: cdb_store(8): BDB0075 DB_PAGE_NOTFOUND: Requested page not found

Broadcast message from systemd-journald@citadel (Thu 2022-06-16 18:00:58 BST):

citserver[4312]: db: cdb_store(8): BDB0075 DB_PAGE_NOTFOUND: Requested page not found

THis is clearly not good!

so the dump and restore of the database didnt seem to have fixed my issue, and I know if I stop citserver it wont start up properly

any Ideas on how I should progress?

Regards

Kim

 



[#] Thu Jun 16 2022 13:49:04 EDT from KimValentine

Subject: Re: Database error back

[Reply] [ReplyQuoted] [Headers] [Print]

Some further thoughts,

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,

but of course I dodnt write anything down so I cant remember what I did!

Rgds

Kim



[#] Thu Jun 16 2022 18:17:29 EDT from IGnatius T Foobar

Subject: Re: Database error back

[Reply] [ReplyQuoted] [Headers] [Print]

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 ]

[#] Fri Jun 17 2022 03:20:38 EDT from KimValentine

Subject: Re: Database error back

[Reply] [ReplyQuoted] [Headers] [Print]

 

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

 



[#] Sat Jun 18 2022 06:22:14 EDT from sciens

[Reply] [ReplyQuoted] [Headers] [Print]

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?



[#] Sat Jun 18 2022 07:02:48 EDT from Nurb432

[Reply] [ReplyQuoted] [Headers] [Print]

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. 



[#] Sat Jun 18 2022 07:07:53 EDT from sciens

[Reply] [ReplyQuoted] [Headers] [Print]

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



[#] Sat Jun 18 2022 16:39:31 EDT from IGnatius T Foobar

[Reply] [ReplyQuoted] [Headers] [Print]

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.

[#] Sat Jun 18 2022 18:02:17 EDT from IGnatius T Foobar

Subject: Re: Easy Install Error

[Reply] [ReplyQuoted] [Headers] [Print]

First of all, thanks for your response. I had not seen it till after
trying to install again and got back the same error indicated in
previous message. So I followed your instructions and this is what I
got back. I also checked the status of citadel service which
indicated that it failed to start as you can see.

Hmm. I am unable to reproduce this error. If you are running a Citadel built from source code (that includes Easy Install), perhaps you might consider running the Docker version? It's pre-built and runs wherever containers can run, and can't be foiled by the little differences between Linux distributions.

[#] Sun Jun 19 2022 01:05:46 EDT from sciens

[Reply] [ReplyQuoted] [Headers] [Print]

 

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 08:43:36 EDT from Robin of Sweden

Subject: can I use my own logo and branding?

[Reply] [ReplyQuoted] [Headers] [Print]

Hello!

can I use my own logo and branding?

//Robin BE Sjöberg



[#] Sun Jun 19 2022 09:11:19 EDT from IGnatius T Foobar

[Reply] [ReplyQuoted] [Headers] [Print]

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.

[#] Sun Jun 19 2022 09:13:03 EDT from IGnatius T Foobar

Subject: Re: can I use my own logo and branding?

[Reply] [ReplyQuoted] [Headers] [Print]

can I use my own logo and branding?

You can set the site logo in Citadel and it'll display in the corner and remain there. If you want more than that, go through /usr/local/webcit/static/ and replace whatever you want. Maybe keep a tarball of the files you modified so you can drop them back in whenever you upgrade.

Go to page: 1 [2] 3 4 5 6 ... Last