NetXMS Forum

Many thanks, I wil retry whit this version of postgresql . 

Luciano.

I add journalctl after boot... 

logs_1day.txt

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...

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.

wich is the correct command to delete only 2 row? 

thanks

ok, I see 3 lines... Have I to delete 2?

only one  :(.

I'm using postgres, and netxms 4.4.5.

thanks.

thanks so much.

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

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 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.

[pre]But wasn't there the possibility of migrating the configuration without touching the old server?

[/pre]

[pre]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.

[/pre]

Luciano.

I 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?

[pre]thank you.

[/pre]

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?

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

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.