search

tableau / TabMon

A Tableau Server performance monitoring service
https://tableau.github.io/TabMon/
MIT License
109 stars 50 forks source link

Could not initialize writer: FATAL: 28P01: password authentication failed for user "tabmon" #210

Closed Tabuser closed 5 years ago

Tabuser commented 5 years ago

Hi, I am unable to start the tabmon sevices as I am getting "Access denied". When I check the logs, I see the error msg as "Could not initialize writer: FATAL: 28P01: password authentication failed for user "tabmon"". I tried reinstalling Tabmon multiple times with the postgres and without postgres(separate installation) but no luck. I am using the default password for TabMon db as mentioned in the tabmon.config file. Ironically, it does not allow me via pgadmin as well. I am attaching the logs and tabmon.config file as well. I have installed 1.3V to monitor the 2018.2.5 Tableau server.Any help is appreciated.

2019-01-10 10:39:43,966 [5] INFO TabMon.Config.TabMonConfigReader - Loading TabMon user configuration.. 2019-01-10 10:39:44,013 [5] DEBUG TabMon.Config.TabMonConfigReader - Loading database configuration.. 2019-01-10 10:39:44,013 [5] INFO TabMon.Config.TabMonConfigReader - Connecting to results database.. 2019-01-10 10:39:44,201 [5] FATAL TabMon.Config.TabMonConfigReader - Could not initialize writer: FATAL: 28P01: password authentication failed for user "tabmon" 2019-01-10 10:39:44,217 [5] FATAL TabMon.Config.TabMonConfigReader - Invalid options in configuration: [Hosts='Primary\xx.xx.xx.x \,Primary\xx.xx.xx.x \,Primary\xx.xx.xx.x \', Writer='null', PollInterval='5', TableName='countersamples'] 2019-01-10 10:39:44,217 [5] INFO TabMon.TabMonAgent - Initializing TabMon.. 2019-01-10 10:39:44,217 [5] FATAL TabMon.TabMonAgent - Invalid TabMon options specified! Aborting.. 2019-01-10 10:39:44,217 [5] FATAL Topshelf.Runtime.Windows.WindowsServiceHost - The service did not start successfully Topshelf.TopshelfException: The service did not start successfully (returned false). at Topshelf.Runtime.Windows.WindowsServiceHost.OnStart(String[] args) 2019-01-10 10:39:44,217 [1] ERROR Topshelf.HostFactory - The service terminated abnormally System.NullReferenceException: Object reference not set to an instance of an object. at TabMon.TabMonAgent.Dispose(Boolean disposing) at TabMonService.TabMonServiceBootstrapper.Dispose(Boolean disposing) at TabMonService.TabMonServiceBootstrapper.Dispose() at Topshelf.Builders.ControlServiceBuilder1.ControlServiceHandle.Dispose() at Topshelf.Runtime.Windows.WindowsServiceHost.Dispose(Boolean disposing) at System.ComponentModel.Component.Dispose() at System.ServiceProcess.ServiceBase.Run(ServiceBase[] services) at System.ServiceProcess.ServiceBase.Run(ServiceBase service) at Topshelf.Runtime.Windows.WindowsServiceHost.Run() at Topshelf.HostFactory.Run(Action1 configureCallback)

Thanks

Tabuser commented 5 years ago

tabmon.config.txt

Tabuser commented 5 years ago

The issue has been resolved.Had to uninstall another version of postgres as its was conflicting with the tabmon postgres. I later got another issue " failed to initialize counter sample using counters from configuration file: The given key was not present in the dictionary" which was resolved after adding all the processes in all the hosts.

Tabuser commented 5 years ago

Now I am able to view the report, but looks like there are few fields (invocation_count for example) that are not compatible with 2018.2.5 because of which the dashboards (vizql Bootstrap Activity,Concurrent users,cache hit/miss analysis) does not show any data.

danjrahm commented 5 years ago

Hello @Tabuser,

The issue with incomplete data showing in the workbook should be resolved by downloading and using the workbook in issue #204.

The cause of the issue is that the counters were renamed in Tableau Server 2018.2.

If there are any other issues let me know. -Dan