Hello.
After installation of components I have some problems:
- i want to initialization DB:
nxdbmgr init /usr/lib/postgresql/9.5/bin/initdb
but result:
SQL query failed (42601 ERROR: syntax error at or near "
LINE 1:ELF
^):
ELF
Database initialization failed
In the logfile:
*I* Platform subagent "/usr/lib/x86_64-linux-gnu/netxms/linux.nsm" successfully loaded
*I* Database driver "pgsql.ddr" loaded and initialized successfully
*E* SQL query failed (Query = "SELECT var_value FROM metadata WHERE var_name='SchemaVersion'"): 42P01 ERROR: relation "metadata" does not exist
LINE 1: SELECT var_value FROM metadata WHERE var_name='SchemaVersion...
^
*E* SQL query failed (Query = "SELECT var_value FROM config WHERE var_name='DBFormatVersion'"): 42P01 ERROR: relation "config" does not exist
LINE 1: SELECT var_value FROM config WHERE var_name='DBFormatVersion...
^
* Unable to get database schema version
What I can change to fix it?
- if I login with admin/netxms in web management console, i always have "Connection refused".
- and one problem yet:
root@nxms:~# service netxmsd status
● netxmsd.service - NetXMS Server
Loaded: loaded (/lib/systemd/system/netxmsd.service; disabled; vendor preset: enabled)
Active: failed (Result: exit-code) since MSK; 30min ago
Process: 3172 ExecStart=/usr/bin/netxmsd -d (code=exited, status=0/SUCCESS)
Main PID: 3176 (code=exited, status=3)
nxms systemd[1]: Starting NetXMS Server...
nxms systemd[1]: netxmsd.service: PID file /var/run/netxmsd.pid not readable (yet?) after start: No s
nxms systemd[1]: Started NetXMS Server.
nxms systemd[1]: netxmsd.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED
nxms systemd[1]: netxmsd.service: Unit entered failed state.
nxms systemd[1]: netxmsd.service: Failed with result 'exit-code'.
I use:
- Ubuntu server 16.04
- PostgreSQL 9.5.13
- tomcat8
--
Thanks for help
After installation of components I have some problems:
- i want to initialization DB:
nxdbmgr init /usr/lib/postgresql/9.5/bin/initdb
but result:
SQL query failed (42601 ERROR: syntax error at or near "
LINE 1:ELF
^):
ELF
Database initialization failed
In the logfile:
*I* Platform subagent "/usr/lib/x86_64-linux-gnu/netxms/linux.nsm" successfully loaded
*I* Database driver "pgsql.ddr" loaded and initialized successfully
*E* SQL query failed (Query = "SELECT var_value FROM metadata WHERE var_name='SchemaVersion'"): 42P01 ERROR: relation "metadata" does not exist
LINE 1: SELECT var_value FROM metadata WHERE var_name='SchemaVersion...
^
*E* SQL query failed (Query = "SELECT var_value FROM config WHERE var_name='DBFormatVersion'"): 42P01 ERROR: relation "config" does not exist
LINE 1: SELECT var_value FROM config WHERE var_name='DBFormatVersion...
^
* Unable to get database schema version
What I can change to fix it?
- if I login with admin/netxms in web management console, i always have "Connection refused".
- and one problem yet:
root@nxms:~# service netxmsd status
● netxmsd.service - NetXMS Server
Loaded: loaded (/lib/systemd/system/netxmsd.service; disabled; vendor preset: enabled)
Active: failed (Result: exit-code) since MSK; 30min ago
Process: 3172 ExecStart=/usr/bin/netxmsd -d (code=exited, status=0/SUCCESS)
Main PID: 3176 (code=exited, status=3)
nxms systemd[1]: Starting NetXMS Server...
nxms systemd[1]: netxmsd.service: PID file /var/run/netxmsd.pid not readable (yet?) after start: No s
nxms systemd[1]: Started NetXMS Server.
nxms systemd[1]: netxmsd.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED
nxms systemd[1]: netxmsd.service: Unit entered failed state.
nxms systemd[1]: netxmsd.service: Failed with result 'exit-code'.
I use:
- Ubuntu server 16.04
- PostgreSQL 9.5.13
- tomcat8
--
Thanks for help