Spacewalk:jabberd/c2s[XXXX]: sqlite (authreg): no such table: authreg (Doc ID 2654593.1)

Last updated on JULY 17, 2023

Applies to:

Symptoms

On the Spacewalk Server, the port who communicates with the clients is filtered so the port is blocked.

# nmap -sT -p 5222 localhost

Starting Nmap 6.40 ( http://nmap.org ) at 2020-03-30 14:46 MST
Nmap scan report for localhost (127.0.0.1)
Host is up (0.00019s latency).
Other addresses for localhost (not scanned): 127.0.0.1
Not shown: 198 closed ports
PORT STATE SERVICE
5222/tcp filtered xmpp-client

From the Client to the Spacewalk Server nc is not working.

<Client IP> nc -zv <Spacewalk IP> 5222
Ncat: Version 7.50 ( https://nmap.org/ncat )
Ncat: Connection refused.

 The status of OSA in the Spacewalk GUI is unknown.

 From the Spacewalk Client, the osad service is not working.

[root@ tmp]# /usr/sbin/osad -N -v -v -v -v

2020-03-19 11:59:12 osad._setup_config: Updating configuration
2020-03-19 11:59:12 jabber_lib.setup_connection: Connecting to FQDN
2020-03-19 11:59:12 jabber_lib._get_jabber_client:
2020-03-19 11:59:12 jabber_lib._get_jabber_client: Connecting to FQDN
2020-03-19 11:59:12 jabber_lib.__init__:
2020-03-19 11:59:12 jabber_lib.__init__:
2020-03-19 11:59:12 jabber_lib.check_cert: Loading cert <X509Name object ''>
2020-03-19 11:59:12 jabber_lib.connect:
2020-03-19 12:01:20 rhn_log.log_error: Error connecting to jabber server: Unable to connect to the host and port specified. See https://access.redhat.com/solutions/327903 for more information.
Error connecting to jabber server: Unable to connect to the host and port specified. See https://access.redhat.com/solutions/327903 for more information.
2020-03-19 12:01:20 jabber_lib.print_message: socket error
2020-03-19 12:01:20 jabber_lib.print_message: Could not connect to jabber server FQDN
2020-03-19 12:01:20 rhn_log.log_error: Traceback (most recent call last):
File "/usr/share/rhn/osad/jabber_lib.py", line 266, in setup_connection
c = self._get_jabber_client(js)
File "/usr/share/rhn/osad/jabber_lib.py", line 338, in _get_jabber_client
c.connect()
File "/usr/share/rhn/osad/jabber_lib.py", line 612, in connect
raise socket.error(e)
error: Unable to connect to the host and port specified

Jabber database is corrupted.

# ll /var/lib/jabberd/db/*
-rw-r--r-- 1 jabber jabber 0 Jan 6 11:30 /var/lib/jabberd/db/sqlite.db

Messages.log

Mar 16 12:46:12 jabberd/c2s[8469]: sqlite (authreg): no such table: authreg
Mar 16 12:46:12 jabberd/c2s[8469]: sqlite (authreg): no such table: authreg
Mar 16 12:46:12 jabberd/c2s[8469]: sqlite (authreg): no such table: authreg
Mar 16 12:46:12 jabberd/c2s[8469]: sqlite (authreg): no such table: authreg
Mar 16 12:46:12 jabberd/c2s[8469]: sqlite (authreg): no such table: authreg

Changes

One of the reasons Jabberd DB (SQLite) can get corrupted is because /var/satellite is 100% full.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.