search

ikzelf / zbxdb

Zabbix database monitoring, the easy and extendable way
GNU General Public License v3.0
94 stars 45 forks source link

TypeError: int() argument must be a string, a bytes-like object or a number, not 'list' #18

Closed MichaelJochen closed 5 years ago

MichaelJochen commented 5 years ago

hi Ronald,when monitoring the sqlserver database with zbxdb, I encountered the following error: " 2019-07-14 18:04:01.972193 user CISTATS CISTATS sid,serial 0,0 instance DHEC-VM-74 as normal cancel:False

INFO:main:using checks from ['etc/zbxdb_checks/mssql/primary.11.cfg']

INFO:main:checks loading etc/zbxdb_checks/mssql/primary.11.cfg

CRITICAL:main:file etc/zbxdb_checks/mssql/primary.11.cfg has parsing errors ->(13)

CRITICAL:main:problem Traceback (most recent call last): File "/home/zbxdb/zbxdb/bin/zbxdb.py", line 794, in main() File "/home/zbxdb/zbxdb/bin/zbxdb.py", line 539, in main sec_mins = int(_checks.get(section, "minutes")) TypeError: int() argument must be a string, a bytes-like object or a number, not 'list' " How can I analyze and resolve this issue? Thank you, I look forward to your reply.

ikzelf commented 5 years ago

Hi,

I have no machine at hand now ... I could have made an error in primary.11.cfg, it should have section names containing a minutes parameter that should tell the frequency in minutes after which the queries in the given section should be repeated and the list of queries.

Can you compare with the other primary cfg files? I think it should be easy to spot.

Sorry for the inconvenience

Groeten, Ronald Rood

Op 14 jul. 2019 om 12:06 heeft MichaelJochen notifications@github.com het volgende geschreven:

hi Ronald,when monitoring the sqlserver database with zbxdb, I encountered the following error: " 2019-07-14 18:04:01.972193 user CISTATS CISTATS sid,serial 0,0 instance DHEC-VM-74 as normal cancel:False

INFO:main:using checks from ['etc/zbxdb_checks/mssql/primary.11.cfg']

INFO:main:checks loading etc/zbxdb_checks/mssql/primary.11.cfg

CRITICAL:main:file etc/zbxdb_checks/mssql/primary.11.cfg has parsing errors ->(13)

CRITICAL:main:problem Traceback (most recent call last): File "/home/zbxdb/zbxdb/bin/zbxdb.py", line 794, in main() File "/home/zbxdb/zbxdb/bin/zbxdb.py", line 539, in main sec_mins = int(_checks.get(section, "minutes")) TypeError: int() argument must be a string, a bytes-like object or a number, not 'list' " How can I analyze and resolve this issue? Thank you, I look forward to your reply.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

MichaelJochen commented 5 years ago

ok,and what is the name of the section?

MichaelJochen commented 5 years ago

well,i found it,at line 139 of mssql's primary.11.cfg " [checks_60m] minutes: 60 instname: SELECT 'zbxdb[connect,instance_name]', @@servername " Remove ”[checks_60m] Minutes: 60" After that, there is no problem.

ikzelf commented 5 years ago

Thanks, I will see that I can fix that tomorrow, if time allows ....

Groeten, Ronald Rood

Op 14 jul. 2019 om 12:58 heeft MichaelJochen notifications@github.com het volgende geschreven:

well,i found it,at line 139 of mssql's primary.11.cfg " [checks_60m] minutes: 60 instname: SELECT 'zbxdb[connect,instance_name]', @@ServerName " Remove ”[checks_60m] Minutes: 60" After that, there is no problem.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

MichaelJochen commented 5 years ago

Another question, which templates are made for mssql? Which one do I use to configure the web page?

ikzelf commented 5 years ago

I use the same for all. Most items I created for oracle and where possible I try to reuse them for others. Like backups, storage, databases etc.

Groeten, Ronald Rood

Op 14 jul. 2019 om 14:06 heeft MichaelJochen notifications@github.com het volgende geschreven:

Another question, which templates are made for mssql? Which one do I use to configure the web page?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.