Many thanks, I wil retry whit this version of postgresql .
Luciano.
Luciano.
- Welcome to NetXMS Support Forum.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages1
#1
General Support / Re: after installationon fedora 40 very low to login
July 30, 2024, 10:42:19 PM #2
General Support / Re: after installationon fedora 40 very low to login
July 28, 2024, 08:38:33 PM
I add journalctl after boot...
#3
General Support / after installationon fedora 40 very low to login
July 28, 2024, 10:08:30 AM
Hi to all!
I installed netxms server 5.0.6 on fedora40, but I detect login problems, very slow after 2 min, and if I look at the logs, I notice that the service netxms has several errors in queries towards the postgres database. I tried both with postgres-14 and 15 and it behaves the same way. for fedora 40 I see that only 5.0.6 is available... I'll start by saying that the db check is always correct with nxdbmgr.
thanks to help me...
I installed netxms server 5.0.6 on fedora40, but I detect login problems, very slow after 2 min, and if I look at the logs, I notice that the service netxms has several errors in queries towards the postgres database. I tried both with postgres-14 and 15 and it behaves the same way. for fedora 40 I see that only 5.0.6 is available... I'll start by saying that the db check is always correct with nxdbmgr.
thanks to help me...
#4
General Support / Re: error on export db
December 31, 2023, 06:25:24 PM
many thanks, but I found more row duplicate 
... then I adopted the query below...
delete from config a using config b where a=b and a.ctid < b.ctid;
it works well... also for all duplicate on db.
I resolved.
... then I adopted the query below...delete from config a using config b where a=b and a.ctid < b.ctid;
it works well... also for all duplicate on db.
I resolved.
#5
General Support / Re: error on export db
December 29, 2023, 05:19:10 PM
wich is the correct command to delete only 2 row?
thanks
thanks
#6
General Support / Re: error on export db
December 29, 2023, 05:09:52 PM
ok, I see 3 lines... Have I to delete 2?
. #8
General Support / Re: error on export db
December 29, 2023, 03:19:21 PM
I'm using postgres, and netxms 4.4.5.
thanks.
thanks.
#10
General Support / error on export db
December 29, 2023, 01:21:45 AM
Hi to all.,
I receive this error when exporting the db, do you know a way to resolve it? .
ERROR: SQLite query failed: UNIQUE constraint failed: config.var_name
Query: INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,is_public,description,units) VALUES ('DBConnectionPool.MaxLifetime','14400','14400','1','1','I','N','Maximum lifetime (in seconds) for a database connection.','seconds')
Database export failed.
Thank you
I receive this error when exporting the db, do you know a way to resolve it? .
ERROR: SQLite query failed: UNIQUE constraint failed: config.var_name
Query: INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,is_public,description,units) VALUES ('DBConnectionPool.MaxLifetime','14400','14400','1','1','I','N','Maximum lifetime (in seconds) for a database connection.','seconds')
Database export failed.
Thank you
#11
General Support / update netxms on fedora 38
November 22, 2023, 11:28:03 PM
hi,
I tried to update the system with dnf update, which would also have updated netxms to 4.4.3, but it crashed due to the wrong gpg key. How can I solve it?
and once updated, do I have to check the java version? and more? does the port remain 8080?
Thank you
I tried to update the system with dnf update, which would also have updated netxms to 4.4.3, but it crashed due to the wrong gpg key. How can I solve it?
and once updated, do I have to check the java version? and more? does the port remain 8080?
Thank you
#12
General Support / Re: migrate netxms core server and db to another server
November 06, 2023, 04:17:11 PMI could try, but they are real-time machines,
and if the update failed, I would have big problems.
This was why I had planned the backup, with the creation of a new machine, to test in the office.
But wasn't there the possibility of migrating the configuration without touching the old server?
The old servers are physical, and for this very reason their virtual activation was planned.
But since I wasn't able to migrate the db I got stuck.
Luciano.
#13
General Support / Re: migrate netxms core server and db to another server
November 06, 2023, 03:29:44 PMI saw that the old versions I have are not in the list of installable releases.
so how can I do it? manual installation? Could I have the correct steps for a manual installation on Debian?
with importable and exportable backup? like the 3.9.280? or the old release 3.9.280 is iportable on the old 3.9.420?thank you.
#14
General Support / Re: migrate netxms core server and db to another server
November 06, 2023, 01:38:40 PM
Hi, Thank yoy for the answer.
All my installation is in postgres db. Then you say that the nxdbmr, will newer be able to import the backup to a newer server with postgres? so, if I had some advice, when creating the new server, with the old release, shouldn't I initialize the db? is there perhaps the possibility of switching from a version of netxms on windows, and then re-entering the db in postgres on the new server? but the backup is in sqlite, and therefore it wouldn't work? Right?
in the row :
apt install netxms-base=4.3.4-1 netxms-dbdrv-sqlite3=4.3.4-1 netxms-agent=4.3.4-1
is missing :
Luciano
All my installation is in postgres db. Then you say that the nxdbmr, will newer be able to import the backup to a newer server with postgres? so, if I had some advice, when creating the new server, with the old release, shouldn't I initialize the db? is there perhaps the possibility of switching from a version of netxms on windows, and then re-entering the db in postgres on the new server? but the backup is in sqlite, and therefore it wouldn't work? Right?
can we migrate a sqlite db to postgres or vice versa, or, do you have a tool that migrates the backup of one version
to another? Thank you.
in the row :
apt install netxms-base=4.3.4-1 netxms-dbdrv-sqlite3=4.3.4-1 netxms-agent=4.3.4-1
is missing :
netxms-dbdrv-pgsql
How should I insert it correctly?
Do you perhaps recommend always using another database, to better manage backups?
Luciano
#15
General Support / migrate netxms core server and db to another server
November 05, 2023, 11:47:41 AM
Hi, I know there are several posts with this question, but still, following various procedures I was unable to migrate the db from an old netxms to another, unfortunately I'm inexperienced.
I tried to run the command to export the db from the old one:
nxdbmgr -s export file_name, but then I can't reimport it to the new one, as it obviously has the latest release, and the nxdbmgr -s command fails.
using debian and fedora, the repositories, always install the latest version available and don't let me choose what to install, I have several active devices all with old releases, which I can't update, but which I have to migrate. Thanks for the answers you give me.
I tried to run the command to export the db from the old one:
nxdbmgr -s export file_name, but then I can't reimport it to the new one, as it obviously has the latest release, and the nxdbmgr -s command fails.
using debian and fedora, the repositories, always install the latest version available and don't let me choose what to install, I have several active devices all with old releases, which I can't update, but which I have to migrate. Thanks for the answers you give me.
Pages1