(imported topic written by murtasma91)
I keep getting this error message when I attempt to add a database to our WebReports server
Unknown Error: Could not connect. Database ‘test’ has been disabled.
I enabled logging on the BigFix Web Report server here is the relevant chunk of information from the log file. As you can see it appears like the ODBC call is sucessfull you can see the language and database context change however further down you see the unknown connection error.
On the WebReport server I can test this System DSN connection just fine without issue.
hu, 16 Jul 2009 11:02:22 -0400 – 924 – — printing parameters:
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – AddDB=test
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – AdminToken=-2942301192312852396
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – DBDSN=localbesreportingserver
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – DBUsername=bfit-cppmsql
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – DSN=1
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – Trusted=0
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – page=AddToDB2
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – webReportsURL=https://some-site.com:8443/webreports
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – — done.
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – select S.ExpirationTime from SESSION S, USERS U where S.Username = ‘bfit-cppmadmin’ and U.Username = S.Username and S.SessionToken = ‘I+AgdW54+pc9sHTrcuL+6FhW2gU’
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – Login verified…
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – select IsAdmin from USERS where Username = ‘bfit-cppmadmin’
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – SELECT UserSetting, SettingValue FROM USER_DEFAULT_MISC WHERE Username = ‘bfit-cppmadmin’
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – User retrieved…
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – Directed to page: AddToDB2
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – Successful ODBC call returned:
Microsoft
ODBC SQL Server Driver
SQL Server
Changed database context to ‘master’. (01000:5701)
Microsoft
ODBC SQL Server Driver
SQL Server
Changed language setting to us_english. (01000:5703)
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – Successful ODBC call returned:
Microsoft
ODBC SQL Server Driver
SQL Server
Changed database context to ‘master’. (01000:5701)
Microsoft
ODBC SQL Server Driver
SQL Server
Changed language setting to us_english. (01000:5703)
Thu, 16 Jul 2009 11:02:22 -0400 – 924 – MEMORY USAGE: 56.656/3999.637/39.645/2047.715; peak 56.656/2048.000/39.801/2047.715
commit/free/reserve/maxFreeBlock, in MB
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – MEMORY USAGE: 56.645/3999.637/39.656/2047.715; peak 56.656/2048.000/39.801/2047.715
commit/free/reserve/maxFreeBlock, in MB
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – configuration set up…
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – MEMORY USAGE: 56.645/3999.637/39.656/2047.715; peak 56.656/2048.000/39.801/2047.715
commit/free/reserve/maxFreeBlock, in MB
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – set cookies…
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – — printing parameters:
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – DBName=test
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – Error=connecterror
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – ErrorDetail=Unknown Error: Could not connect.
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – page=Settings
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – — done.
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – select S.ExpirationTime from SESSION S, USERS U where S.Username = ‘bfit-cppmadmin’ and U.Username = S.Username and S.SessionToken = ‘I+AgdW54+pc9sHTrcuL+6FhW2gU’
Thu, 16 Jul 2009 11:02:23 -0400 – 5096 – Login verified…