After update to 1.8 got DSN problems

[Padawan.AVT]

Hi everyone!

After upgrading to 1.8 some of my database checks fails with the error as below:

  2455:20091229:131659.754 Failed to connect to DSN '' : Error: failed connection [[unixODBC][Driver Manager]Can't initiate unicode conversion] (0)
  2455:20091229:131659.754 Item [europe.intranet.com:db.odbc.select[ MyApp Database Sessions count]] error: failed connection [[unixODBC][Dri
ver Manager]Can't initiate unicode conversion] (0)

As you see, there is missing DSN name.

Prior to update, on 1.6 all worked fine. Zabbix + unixODBC for Oracle were configured in this way:

http://www.zabbix.com/forum/showpost.php?p=49044&postcount=4

Any clues?

[rizwank]

Some, but not all?

[Padawan.AVT]

Yes. I'm sorry for the late reply - I just added a few lines to zabbix sources so I could monitor when parameters are passed or not.

Strange things happen: sometimes these parameters are passed and sometimes not:

 26701:20091231:151055.131 Item [server1.com:db.odbc.select[Empty count]] error: failed connection [[unixODBC][Driver Manager]Can't initiate unicode conversion] (0)
 26698:20091231:151055.375 The following DSN parameters were passed to odbc_DBconnect procedure: DSN '' User '' Pass ''
 26699:20091231:151055.536 The following DSN parameters were passed to odbc_DBconnect procedure: DSN '' User '' Pass ''
 26698:20091231:151055.601 Failed to connect to DSN '' : Error: failed connection [[unixODBC][Driver Manager]Can't initiate unicode conversion] (0)
 26698:20091231:151055.601 Item [server2.com:db.odbc.select[App2 Controller status]] error: failed connection [[unixODBC][Driver Manager]Can't initiate unicode conversion] (0)
 26699:20091231:151055.632 Failed to connect to DSN '' : Error: failed connection [[unixODBC][Driver Manager]Can't initiate unicode conversion] (0)
 26699:20091231:151055.632 Item [server2.com:db.odbc.select[App3 Controller status]] error: failed connection [[unixODBC][Driver Manager]Can't initiate unicode conversion] (0)
 26699:20091231:151056.930 The following DSN parameters were passed to odbc_DBconnect procedure: DSN 'APP1' User 'admin' Pass 'password'
 26718:20091231:151100.786 Parameter [25809][server2.com:db.odbc.select[App Delay]] became supported by agent
 26700:20091231:151104.134 The following DSN parameters were passed to odbc_DBconnect procedure: DSN 'APP2' User 'admin' Pass 'password'
 26699:20091231:151104.679 The following DSN parameters were passed to odbc_DBconnect procedure: DSN '' User '' Pass ''
 26699:20091231:151104.750 Failed to connect to DSN '' : Error: failed connection [[unixODBC][Driver Manager]Can't initiate unicode conversion] (0)
 26699:20091231:151104.750 Item [server2.com:db.odbc.select[App2 Controller delay]] error: failed connection [[unixODBC][Driver Manager]Can't initiate unicode conversion] (0)

"The following DSN parameters were passed to odbc_DBconnect procedure: DSN '' User '' Pass '' " - this does my piece of code - it shows if any parameters were passed at all
I set it to be the first command in odbc_DBconnect procedure.