febry's questions

I already create new host on zabbix 5.0 LTS For monitoring SQL Server (2012). I using default template from zabbix (Template DB MSSQL by ODBC).

this macros I set on host

{$MSSQL.DSN} => devdb
{$MSSQL.INSTANCE} => DBDEV115\DBDEV115
{$MSSQL.PASSWORD} => passworduserdb
{$MSSQL.PORT} => 4019
{$MSSQL.USER} => zabbix

after that I see on each items i got error message like this

Failed: cannot extract value from json by path "$[?(@.object_name=='DBDEV115\DBDEV115:Databases' && @.counter_name=='Transactions/sec' && @.instance_name=='dbColaFlakes')].cntr_value.first()": unsupported construct in jsonpath starting with: "'DBDEV115\DBDEV115:Databases' && @.counter_name=='Transactions/sec' && @.instance_name=='dbColaFlakes')].cntr_value.first()"

this error impact from instance name ? or zabbix doesn't support ?

because i got instance name from query like this

select @@servername

I am using keepalived for make HA current maxscale and using virtual IP on keepalived. If I change virtual IP on keepalived I must restart OS on VM or restart keepalived service only?

I am still confused about that.

currently i have one domain controller with zentyal (Community Edition). And i have 2 node already connected to domain.

So i setup Windows Failover Cluster, but i always got failed validate with error message access denied. Earlier i already create use with administrator level domain controller and this user already join to administrator group on every each node.

but still i got error access denied on validate step when i setup windows failover cluster.

this is impact or limitation from zentyal or need more configuration on zentyal ?

i have 2 node will be setup windows failover cluster. every node already connect to Active Directory. when i validate on windows failover cluster, still failed on List Disk

error message like this

i have one task scheduler with 2 action.

<?xml version="1.0" encoding="UTF-16"?>
<Task version="1.2" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">
  <RegistrationInfo>
    <Date>2020-07-21T08:40:20.4842672</Date>
    <Author>WIN-9DQ9EVI3R22\Administrator</Author>
    <URI>\RESTORE</URI>
  </RegistrationInfo>
  <Triggers>
    <CalendarTrigger>
      <Repetition>
        <Interval>PT5M</Interval>
        <StopAtDurationEnd>false</StopAtDurationEnd>
      </Repetition>
      <StartBoundary>2020-07-21T00:00:00</StartBoundary>
      <Enabled>true</Enabled>
      <ScheduleByDay>
        <DaysInterval>1</DaysInterval>
      </ScheduleByDay>
    </CalendarTrigger>
  </Triggers>
  <Principals>
    <Principal id="Author">
      <UserId>S-1-5-21-316211975-241055689-3246940587-500</UserId>
      <LogonType>Password</LogonType>
      <RunLevel>LeastPrivilege</RunLevel>
    </Principal>
  </Principals>
  <Settings>
    <MultipleInstancesPolicy>IgnoreNew</MultipleInstancesPolicy>
    <DisallowStartIfOnBatteries>true</DisallowStartIfOnBatteries>
    <StopIfGoingOnBatteries>true</StopIfGoingOnBatteries>
    <AllowHardTerminate>true</AllowHardTerminate>
    <StartWhenAvailable>false</StartWhenAvailable>
    <RunOnlyIfNetworkAvailable>false</RunOnlyIfNetworkAvailable>
    <IdleSettings>
      <StopOnIdleEnd>true</StopOnIdleEnd>
      <RestartOnIdle>false</RestartOnIdle>
    </IdleSettings>
    <AllowStartOnDemand>true</AllowStartOnDemand>
    <Enabled>true</Enabled>
    <Hidden>false</Hidden>
    <RunOnlyIfIdle>false</RunOnlyIfIdle>
    <WakeToRun>false</WakeToRun>
    <ExecutionTimeLimit>PT72H</ExecutionTimeLimit>
    <Priority>7</Priority>
  </Settings>
  <Actions Context="Author">
    <Exec>
      <Command>"D:\Batch File\LS_RESTORE_221.bat"</Command>
    </Exec>
    <Exec>
      <Command>"D:\Batch File\LS_RESTORE_MAINDB.bat"</Command>
    </Exec>
  </Actions>
</Task>

my issue if i change or update action or trigger task scheduler not running in same day. but tommorrow in same trigger task schduler running normal.

example at 21 Jul 2020 i change action file on task scheduler. but i see task scheduler can't running. i see 22 Jul 2020 task scheduler running normal.

so whats wrong on my task scheduler