Всем привет.
Имеем УКМ4 версия 104. Столкнулись с проблемой следующего характера: СГО дочерний сервер видит, но подключиться не может, дочерний сервер так же, видит СГО но при этом дает странные логи на подключение удалённого подключения, которые постоянно повторяются.
[spoiler = "Логи дочернего сервера"]
Момент tid Событие Задача Сообщение
19.11.2022 13:08:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:08:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:08:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:08:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:08:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:08:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:08:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:08:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:07:55 0x00000df8 INFO diag finished command 244
19.11.2022 13:07:55 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:07:55 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:07:55 0x00000df8 INFO diag incoming command 244
19.11.2022 13:07:55 0x00000df8 INFO diag finished command 244
19.11.2022 13:07:55 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:07:55 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:07:55 0x00000df8 INFO diag incoming command 244
19.11.2022 13:07:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:07:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:07:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:07:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:07:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:07:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:07:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:07:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:06:55 0x00000df8 INFO diag finished command 244
19.11.2022 13:06:55 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:06:55 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:06:55 0x00000df8 INFO diag incoming command 244
19.11.2022 13:06:55 0x00000df8 INFO diag finished command 244
19.11.2022 13:06:55 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:06:55 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:06:55 0x00000df8 INFO diag incoming command 244
19.11.2022 13:06:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:06:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:06:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:06:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:06:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:06:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:06:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:06:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:05:55 0x00000df8 INFO diag finished command 244
19.11.2022 13:05:55 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:05:55 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:05:55 0x00000df8 INFO diag incoming command 244
19.11.2022 13:05:55 0x00000df8 INFO diag finished command 244
19.11.2022 13:05:55 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:05:55 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:05:55 0x00000df8 INFO diag incoming command 244
19.11.2022 13:05:47 0x00000df8 INFO diag finished command 266
19.11.2022 13:05:47 0x00000df8 INFO diag incoming command 266
19.11.2022 13:05:30 0x00000df8 INFO diag finished command 266
19.11.2022 13:05:30 0x00000df8 INFO diag incoming command 266
19.11.2022 13:05:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:05:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:05:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:05:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:05:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:05:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:05:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:05:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:04:55 0x00000df8 INFO diag finished command 244
19.11.2022 13:04:55 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:04:55 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:04:55 0x00000df8 INFO diag incoming command 244
19.11.2022 13:04:54 0x00000df8 INFO diag finished command 244
19.11.2022 13:04:54 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:04:54 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:04:54 0x00000df8 INFO diag incoming command 244
19.11.2022 13:04:25 0x00000df8 INFO diag finished command 244
19.11.2022 13:04:25 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:04:25 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:04:25 0x00000df8 INFO diag incoming command 244
19.11.2022 13:04:24 0x00000df8 INFO diag finished command 244
19.11.2022 13:04:24 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:04:24 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:04:24 0x00000df8 INFO diag incoming command 244
19.11.2022 13:03:55 0x00000df8 INFO diag finished command 244
19.11.2022 13:03:55 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:03:55 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
19.11.2022 13:03:55 0x00000df8 INFO diag incoming command 244
19.11.2022 13:03:54 0x00000df8 INFO diag finished command 244
19.11.2022 13:03:54 0x00000df8 INFO NtlpTrnManager Answer for 192.168.36.1 host remotehost, db = ukmserver, port = 0, user = ukm00000003d89r4
19.11.2022 13:03:54 0x00000df8 INFO NtlpTrnManager Remote username ukm00000003d89r4, for host 192.168.36.1
[/spoiler]
Лог СГО где он не может подключиться:
00:00:08.491: 0x0000145c: INFO: NtlpTrnManager: Receive host:192.168.36.1, db:ukmserver, port: 0, user: ukm00000000w0z54
00:00:08.513: 0x0000145c: WARNING: replication#replication#экспорт на сервер SCASH36: Ошибка при подключении БД. Параметры подключения: host=192.168.36.1, user=ukm00000000w0z54, db=ukmserver, port=0: Error(1045) Access denied for user 'ukm00000000w0z54'@'192.168.36.136' (using password: YES): SQL . Перезапуск через 30 сек.
00:00:11.655: 0x00000720: INFO: NtlpTrnManager: Receive host:192.168.36.1, db:ukmserver, port: 0, user: ukm00000000w0z54
00:00:11.676: 0x00000720: WARNING: replication#replication#импорт с сервера SCASH36: Ошибка при подключении БД. Параметры подключения: host=192.168.36.1, user=ukm00000000w0z54, db=ukmserver, port=0: Error(1045) Access denied for user 'ukm00000000w0z54'@'192.168.36.136' (using password: YES): SQL . Перезапуск через 30 сек.
При этом сервера друг друга видят в плане сети, в веб интерфейса могу зайти как СГО на дочерний, так и с дочернего на СГО.
Куда копать? Проблемы маршрутизации? или глюк УКМ?