NetXMS Support Forum

I suspect this issue is related to Solaris on SPARC - at least I was unable to reproduce it on Solaris x86, and I don't have any SPARC machine at my disposal. Does anybody uses NetXMS server on Solaris SPARC? Or maybe somebody could provide me shell access to some Solaris SPARC machine with dev environment?

Best regards,
Victor

I've put missing file back. But it's very outdated - current release is 0.2.31. We need new maintainer for FreeBSD port.

Best regards,
Victor

Hi!

You should turn off automatic layout (uncheck Map -> Enable automatic layout).

Best regards,
Victor

A kakie oshibki ostalis' v loge?

Poprobujte zamenit' src/server/dbdrv/pgsql/pgsql.cpp na prilozennij.
A v kakoj kodirovke sdelana baza? Esli zamena pgsql.cpp ne pomozet i kodirovka bazi ne UTF8, poprobujte sozdat' bazu s UTF8 kodirovkoj.

Vrode razobralsja. Poprobujte novij variant netobj.cpp.

Poprobujte zapustit' server s kljucom -D 9 (togda budet pisat'sja mnogo debug informacii, vkljuchaja i sql zaprosi) i prislat' log servera pered vipolneniem etogo sql zaprosa (vkljuchaja i sam zapros).
I kakaja versija PostgreSQL i operacionki?

Ochen' stranno - vrode kak ispravlena uze eta oshibka. Sravnite pozalujsta fail src/server/core/netobj.cpp s prilozennim. Esli oni ne sovpadajut, zamenite na prilozennij i peresoberite server.

Sdelaju vecherom patch i vilozu. Spasibo

Viktor

Do you have any other program running which may communicate with UPS - agent form UPS vendor, Windows UPS service, etc.?

Best regards,
Victor

Very strange. Could you please run netxmsd under gdb, like this:


debian:~# gdb /opt/netxms/bin/netxmsd
GNU gdb 6.8-debian
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "i486-linux-gnu"...
(gdb) run -D 5


and when it crashes, enter gdb command bt and post it's output?

Thank you for patience!

Best regards,
Victor

Hi!

Did you grant all privileges on netxms database to user 'netxms'?
Try to drop and re-create database. After that, run netxmsd in debug mode and post it's output.

Best regards,
Victor

Да, если пропали настройки, сделанные давно - это конечно к порядку остановки сервисов отношения не имеет. А что в логах сервера? Добавьте в netxmsd.conf строчку

LogFailedSQLQueries = yes

возможно какие-то SQL запросы не проходят.

Добрый день!

Если я правильно понимаю этот скрипт, при остановке сначала останавливается база данных, а уже потом netxmsd. Соответственно при выходе сервер может не записать какие-то данные из памяти, поскольку база уже остановлена. Правильная последовательность - дать SIGTERM процессу netxmsd, дождаться его завершения (в зависимости от ситуации это может занять какое-то время - до 30 секунд на больших базах), и только после этого останавливать базу.

Best regards,
Victor

Hi!

If you are connecting to localhost, you should grabt access to database in this way:

GRANT ALL ON netxms.* TO netxms@localhost IDENTIFIED BY 'PaSsWd';

Because MySQL threats localhost connections differently. (MySQL page where this behavior is explained: http://dev.mysql.com/doc/refman/5.1/en/adding-users.html).

Best regards,
Victor