New install version 24.01 ( fresh install)error on reboot
Arturo J Garcia Jmz
systemctl status sipxconfig.service
● sipxconfig.service - sipxconfig
Loaded: loaded (/usr/lib/systemd/system/sipxconfig.service;
disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2024-12-23 23:09:44
CST; 3min 19s ago
Docs: http://sipxcom.org
Main PID: 5382 (code=exited, status=1/FAILURE)
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: Total time: 0 seconds
Dec 23 23:09:44 host.domain.xxrunuser[7062]: pam_unix(runuser:session): session
closed for user sipx
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: ERROR:
relation "version_history" does not exist
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: LINE 1: select max(vh.version)
from version_history vh;
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: ^
Dec 23 23:09:44 host.domain.xxsystemd[1]: sipxconfig.service: main process
exited, code=exited, status=1/FAILURE
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: Error: could not
get the database version. Exiting now.
Dec 23 23:09:44 host.domain.xxsystemd[1]: Failed to start sipxconfig.
Dec 23 23:09:44 host.domain.xxsystemd[1]: Unit sipxconfig.service entered
failed state.
Dec 23 23:09:44 host.domain.xxsystemd[1]: sipxconfig.service failed.
-----------------------------------------------------------
sipxconfig.service - sipxconfig
Loaded: loaded (/usr/lib/systemd/system/sipxconfig.service;
disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2024-12-23 23:09:44
CST; 3min 19s ago
Docs: http://sipxcom.org
Main PID: 5382 (code=exited, status=1/FAILURE)
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: Total time: 0 seconds
Dec 23 23:09:44 host.domain.xxrunuser[7062]: pam_unix(runuser:session): session
closed for user sipx
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: ERROR: relation
"version_history" does not exist
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: LINE 1: select max(vh.version)
from version_history vh;
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: ^
Dec 23 23:09:44 host.domain.xxsystemd[1]: sipxconfig.service: main process
exited, code=exited, status=1/FAILURE
Dec 23 23:09:44 host.domain.xxsipxconfig[5382]: Error: could not get the
database version. Exiting now.
Dec 23 23:09:44 host.domain.xxsystemd[1]: Failed to start sipxconfig.
Dec 23 23:09:44 host.domain.xxsystemd[1]: Unit sipxconfig.service entered
failed state.
Dec 23 23:09:44 host.domain.xxsystemd[1]: sipxconfig.service failed.
[root@ippbx-net50 ~]# ^C
[root@ippbx-net50 ~]# systemctl list-units --type service --state
running,failed
UNIT
LOAD ACTIVE SUB DESCRIPTION
auditd.service loaded active
running Security Auditing Service
crond.service loaded active
running Command Scheduler
dbus.service loaded
active running D-Bus System Message Bus
elasticsearch.service loaded active running Elasticsearch
fail2ban.service loaded active running
Fail2Ban Service
ge...@tty1.service loaded active running
Getty on tty1
gssproxy.service loaded active running
GSSAPI Proxy Daemon
httpd.service loaded active
running The Apache HTTP Server
irqbalance.service loaded active running
irqbalance daemon
lvm2-lvmetad.service loaded active running LVM2
metadata daemon
mongod.service loaded active
running High-performance, schema-free document-oriented database
named.service loaded active
running Berkeley Internet Name Domain (DNS)
NetworkManager.service loaded active running Network
Manager
nfs-idmapd.service loaded active running
NFSv4 ID-name mapping service
nfs-mountd.service loaded active running NFS
Mount Daemon
ntpd.service loaded
active running Network Time Service
polkit.service loaded active
running Authorization Manager
postgresql.service loaded active running
PostgreSQL database server
redis.service loaded active
running Redis persistent key-value database
rpc-statd.service loaded active running NFS
status monitor for NFSv2/3 locking.
rpcbind.service loaded active running
RPC bind service
rsyslog.service loaded active running
System Logging Service
sendmail.service loaded active running
Sendmail Mail Transport Agent
● sipxconfig.service loaded failed failed
sipxconfig
sipxlogwatcher.service loaded active running SYSV: Simple
Event Correlator script to filter log file entries
sm-client.service loaded active running
Sendmail Mail Transport Client
snmpd.service loaded active
running Simple Network Management Protocol (SNMP) Daemon.
snmptrapd.service loaded active running
Simple Network Management Protocol (SNMP) Trap Daemon.
sshd.service loaded
active running OpenSSH server daemon
systemd-journald.service loaded active running Journal Service
systemd-logind.service loaded active running Login Service
systemd-timedated.service loaded active running Time & Date Service
systemd-udevd.service loaded active running udev Kernel
Device Manager
tftp.service loaded
active running Tftp Server
tuned.service loaded active
running Dynamic System Tuning Daemon
vgauthd.service loaded active runnin
OnRelay Support
To check, could you please do the following from a terminal:
To start PSQL:
psql -U postgres sipxconfig
From the PSQL prompt:
select * from version_history;
If there is a final entry version 14 there, please delete is as follows (version 14 was added in error in on of our early updates, subsequently removed):
delete from version_history where version='14';
If you have more severe DB errors we would need to see some logs to tell why your installation could be corrupted.