Unable to start the tabmon service

[Tabuser]

Hi,

I just installed the Tabmon successfully with the service account that has admin privileges. But when I try to start the Tabmon service from the services.msc, I am getting the below error. Can someone help me on this?

[danjrahm]

Hello,

To look into this I will need the TabMon.log file. This can be found in the Logs folder of the TabMon directory. (Default directory: C:\Program Files (x86)\TabMon\Logs)

Once I have these I should be able to see why we are receiving the error.

[Tabuser]

Please see the below notes from the logs.

2015-11-05 00:56:46,896 [5] INFO TabMon.TabMonAgent - Initializing TabMon.. 2015-11-05 00:56:46,896 [5] FATAL TabMon.TabMonAgent - Invalid TabMon options specified! Aborting.. 2015-11-05 00:56:46,896 [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)

[danjrahm]

From that snippet it looks like this issue could be caused by a few things.

1. The TabMon config is incorrectly configured.
2. Postgres is not properly initialized.

For me to determine the exact cause, I will need the following.

1. The full TabMon log file. (You can drag and drop it into the comment box here)
2. The DBCreation log file. (This can be found in the temp directory)
3. TabMon config file. (This can be found in the Config folder of the Tabmon directory)

Let me know if there are any questions.

[Tabuser]

here is the tabmon log file.

2015-11-05 15:56:24,334 [5] INFO TabMon.Config.TabMonConfigReader - Loading TabMon user configuration.. 2015-11-05 15:56:24,381 [5] DEBUG TabMon.Config.TabMonConfigReader - Loading database configuration.. 2015-11-05 15:56:24,381 [5] INFO TabMon.Config.TabMonConfigReader - Connecting to results database.. 2015-11-05 15:56:24,647 [5] FATAL TabMon.Config.TabMonConfigReader - Could not initialize writer: FATAL: 28P01: password authentication failed for user "tabmon" 2015-11-05 15:56:24,647 [5] DEBUG TabMon.Helpers.HostnameHelper - Successfully resolved 'localhost' to ''. 2015-11-05 15:56:24,663 [5] FATAL TabMon.Config.TabMonConfigReader - Invalid options in configuration: [Host='Primary', Writer='null', PollInterval='30', TableName='countersamples'] 2015-11-05 15:56:24,663 [5] INFO TabMon.TabMonAgent - Initializing TabMon.. 2015-11-05 15:56:24,663 [5] FATAL TabMon.TabMonAgent - Invalid TabMon options specified! Aborting.. 2015-11-05 15:56:24,663 [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) 2015-11-05 15:57:20,554 [5] INFO TabMon.Config.TabMonConfigReader - Loading TabMon user configuration.. 2015-11-05 15:57:20,601 [5] DEBUG TabMon.Config.TabMonConfigReader - Loading database configuration.. 2015-11-05 15:57:20,601 [5] INFO TabMon.Config.TabMonConfigReader - Connecting to results database.. 2015-11-05 15:57:20,851 [5] FATAL TabMon.Config.TabMonConfigReader - Could not initialize writer: FATAL: 28P01: password authentication failed for user "tabmon" 2015-11-05 15:57:20,867 [5] DEBUG TabMon.Helpers.HostnameHelper - Successfully resolved 'localhost' to ''. 2015-11-05 15:57:20,867 [5] FATAL TabMon.Config.TabMonConfigReader - Invalid options in configuration: [Host='Primary', Writer='null', PollInterval='30', TableName='countersamples'] 2015-11-05 15:57:20,867 [5] INFO TabMon.TabMonAgent - Initializing TabMon.. 2015-11-05 15:57:20,867 [5] FATAL TabMon.TabMonAgent - Invalid TabMon options specified! Aborting.. 2015-11-05 15:57:20,867 [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)

[Tabuser]

sorry I am not able to attach the files as I dont have write permissions. Here is the tabmon config file

<?xml version="1.0"?>

Tabuser commented 8 years ago

Can I get the exact location for the temp directory where can I get the db creation log?

danjrahm commented 8 years ago

The temp directory should be here: C:\Temp

It looks like github is messing up the XML, to workaround this you can email me the files at drahm@tableau.com. If possible please email me all of the files I previously requested.

Tabuser commented 8 years ago

Hi Dan,

I sent you the requested files through my company id. Please check it

ddubrul commented 8 years ago

I am also receiving the error "error 5 access is denied" when attempting to start the tabmon service.

I checked the tabmon.log and it says:

2015-11-09 10:46:58,608 [5] INFO TabMon.Config.TabMonConfigReader - Loading TabMon user configuration.. 2015-11-09 10:46:58,686 [5] DEBUG TabMon.Config.TabMonConfigReader - Loading database configuration.. 2015-11-09 10:46:58,686 [5] INFO TabMon.Config.TabMonConfigReader - Connecting to results database.. 2015-11-09 10:46:58,920 [5] FATAL TabMon.Config.TabMonConfigReader - Could not initialize writer: FATAL: 28P01: password authentication failed for user "tabmon" 2015-11-09 10:46:58,920 [5] DEBUG TabMon.Helpers.HostnameHelper - Successfully resolved 'localhost' to 'AMTROWTABWRKD01'. 2015-11-09 10:46:58,935 [5] FATAL TabMon.Config.TabMonConfigReader - Invalid options in configuration: [Host='Primary\AMTROWTABWRKD01', Writer='null', PollInterval='30', TableName='countersamples'] 2015-11-09 10:46:58,935 [5] INFO TabMon.TabMonAgent - Initializing TabMon.. 2015-11-09 10:46:58,935 [5] FATAL TabMon.TabMonAgent - Invalid TabMon options specified! Aborting.. 2015-11-09 10:46:58,935 [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)

I see where it says "password authentication failed for user tabmon". I am using the default value for the tabmon password during the initial setup. Should I be using something else?

Tabuser commented 8 years ago

When I installed for the first time, I changed the password. As it was failing I uninstalled tabmon and the postgre and reinstalled with the default passoword as mentioned in the config file. Also, forgot to tell, I am running my tableau server on windows 2012. Does it have anything to do with it?

danjrahm commented 8 years ago

Did you by chance uninstall the TabMon-Postgres service?

Tabuser commented 8 years ago

No I did not.

danjrahm commented 8 years ago

That makes sense. So, the reason TabMon won't start is that the original database is up and running. The tabmon user on that database is still using the custom password that was used to install TabMon the first time.

There are 2 ways that I can think of that will resolve/workaround this.

1. Uninstall TabMon and TabMon-Postgres and reinstall the software.
2. Access the TabMon postgres installation using the tabmonsuperuser and delete/re-create the tabmon user.

If there are any questions about these options let me know.

Tabuser commented 8 years ago

Uninstalling of the software will uninstall the services as well right? Hence I did not worry about it. Also, I made sure I deleted the folders as per the user guide. Anyways, will try and update you. Thank you

danjrahm commented 8 years ago

So currently the uninstaller does not uninstall the postgres service. This is because we wanted to avoid accidental deletions of the data in postgres. We do however list the uninstall steps in our setup guide.

If there are any questions about uninstalling the service please let me know.

danjrahm commented 8 years ago

I'm just checking in to see how the reinstall went.

It also occurred to me that there may be another instance of Postgres running on the host. Can you get me a netstat? The command is below:

netstat -anb > C:\netstat.txt

danjrahm commented 8 years ago

Hello, just checking in to see it this is resolved.

rarandall commented 8 years ago

I was having this exact issue... Error 5: Access is Denied and the same log file output. Turns out I already had PostgreSQL installed in a different directory.

Uninstalling postgres and reinstalling Tabmon fixed the issues and everything is now working.

Hope this helps... rr

jmangue commented 8 years ago

Thanks for chiming in to help, rarandall!

Closing this issue out due to inactivity, please reopen it if you still need further assistance.

Tabuser commented 8 years ago

Hey Justin,

Sorry, Was busy with some other stuff and holidays. The issue is still open. I am not able to delete the tabmon postgre to reinstall it. I do need some assistance on this.

Thanks

On Sat, Jan 9, 2016 at 4:43 PM, Justin Mangue notifications@github.com wrote:

Thanks for chiming in to help, rarandall!

Closing this issue out due to inactivity, please reopen it if you still need further assistance.

— Reply to this email directly or view it on GitHub https://github.com/tableau/TabMon/issues/9#issuecomment-170284951.

jmangue commented 8 years ago

No problem, I know how it goes :) Hope you had happy holidays.

There's some guidance on how to delete the TabMon Postgres instance on page 9 of the User Guide which I'll paste here:

Open up a console window as administrator and enter these commands: sc stop TabMon-Postgres sc delete TabMon-Postgres ... then delete the folder where you told TabMon to install Postgres (default is C:\Postgres)

At that point, you should be able to reinstall TabMon. Sorry for the hassle on this; as Dan said, we leave Postgres in place during uninstall to prevent the customer from accidentally losing their data.

Tabuser commented 8 years ago

Ok. Thanks. I will try and let you know.

On Sat, Jan 9, 2016 at 5:14 PM, Justin Mangue notifications@github.com wrote:

No problem, I know how it goes :) Hope you had happy holidays.

There's some guidance on how to delete the TabMon Postgres instance on page 9 of the User Guide which I'll paste here:

Open up a console window as administrator and enter these commands: sc stop TabMon-Postgres sc delete TabMon-Postgres ... then delete the folder where you told TabMon to install Postgres (default is C:\Postgres)

At that point, you should be able to reinstall TabMon. Sorry for the hassle on this; as Dan said, we leave Postgres in place during uninstall to prevent the customer from accidentally losing their data.

— Reply to this email directly or view it on GitHub https://github.com/tableau/TabMon/issues/9#issuecomment-170287071.

Tabuser commented 8 years ago

Hi,

It was installed successfully. Thank you. I have a question, Do we need to install the Windows Framework Manager 3.0 on Windows server 2012r2 as well. I'm able to see the articles which says 3.0 is compatible only till windowss 2008. Is that true?

Thanks

jmangue commented 8 years ago

Hi,

Glad to hear you got it installed successfully!

If you already have TabMon installed and working correctly, you don't need to worry about Windows Management Framework -- we only require that during installation, in order to run some database initialization commands in Powershell. It looks like Windows 2012R2 actually includes Powershell, so you're all set.

Mind if I close this out?

jmangue commented 8 years ago

Closing out, reopen if you need additional help on this issue.

Tabuser commented 8 years ago

OK. Thanks Justin. You can close the issue. Thanks for the amazing support you guys are giving. On Jan 17, 2016 5:18 PM, "Justin Mangue" notifications@github.com wrote:

Hi,

Glad to hear you got it installed successfully!

If you already have TabMon installed and working correctly, you don't need to worry about Windows Management Framework -- we only require that during installation, in order to run some database initialization commands in Powershell. It looks like Windows 2012R2 actually includes Powershell, so you're all set.

Mind if I close this out?

— Reply to this email directly or view it on GitHub https://github.com/tableau/TabMon/issues/9#issuecomment-172390444.

Shobananpa commented 8 years ago

Hi Team, Could you please explain this step

2. Access the TabMon postgres installation using the tabmonsuperuser and delete/re-create the tabmon user. Thanks, Shoba

• © Githubissues.
• Githubissues is a development platform for aggregating issues.

[Tabuser]

Can I get the exact location for the temp directory where can I get the db creation log?

[danjrahm]

The temp directory should be here: C:\Temp

It looks like github is messing up the XML, to workaround this you can email me the files at drahm@tableau.com. If possible please email me all of the files I previously requested.

[Tabuser]

Hi Dan,

I sent you the requested files through my company id. Please check it

[ddubrul]

I am also receiving the error "error 5 access is denied" when attempting to start the tabmon service.

I checked the tabmon.log and it says:

2015-11-09 10:46:58,608 [5] INFO TabMon.Config.TabMonConfigReader - Loading TabMon user configuration.. 2015-11-09 10:46:58,686 [5] DEBUG TabMon.Config.TabMonConfigReader - Loading database configuration.. 2015-11-09 10:46:58,686 [5] INFO TabMon.Config.TabMonConfigReader - Connecting to results database.. 2015-11-09 10:46:58,920 [5] FATAL TabMon.Config.TabMonConfigReader - Could not initialize writer: FATAL: 28P01: password authentication failed for user "tabmon" 2015-11-09 10:46:58,920 [5] DEBUG TabMon.Helpers.HostnameHelper - Successfully resolved 'localhost' to 'AMTROWTABWRKD01'. 2015-11-09 10:46:58,935 [5] FATAL TabMon.Config.TabMonConfigReader - Invalid options in configuration: [Host='Primary\AMTROWTABWRKD01', Writer='null', PollInterval='30', TableName='countersamples'] 2015-11-09 10:46:58,935 [5] INFO TabMon.TabMonAgent - Initializing TabMon.. 2015-11-09 10:46:58,935 [5] FATAL TabMon.TabMonAgent - Invalid TabMon options specified! Aborting.. 2015-11-09 10:46:58,935 [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)

I see where it says "password authentication failed for user tabmon". I am using the default value for the tabmon password during the initial setup. Should I be using something else?

[Tabuser]

When I installed for the first time, I changed the password. As it was failing I uninstalled tabmon and the postgre and reinstalled with the default passoword as mentioned in the config file. Also, forgot to tell, I am running my tableau server on windows 2012. Does it have anything to do with it?

[danjrahm]

Did you by chance uninstall the TabMon-Postgres service?

[Tabuser]

No I did not.

[danjrahm]

That makes sense. So, the reason TabMon won't start is that the original database is up and running. The tabmon user on that database is still using the custom password that was used to install TabMon the first time.

There are 2 ways that I can think of that will resolve/workaround this.

1. Uninstall TabMon and TabMon-Postgres and reinstall the software.
2. Access the TabMon postgres installation using the tabmonsuperuser and delete/re-create the tabmon user.

If there are any questions about these options let me know.

[Tabuser]

Uninstalling of the software will uninstall the services as well right? Hence I did not worry about it. Also, I made sure I deleted the folders as per the user guide. Anyways, will try and update you. Thank you

[danjrahm]

So currently the uninstaller does not uninstall the postgres service. This is because we wanted to avoid accidental deletions of the data in postgres. We do however list the uninstall steps in our setup guide.

If there are any questions about uninstalling the service please let me know.

[danjrahm]

I'm just checking in to see how the reinstall went.

It also occurred to me that there may be another instance of Postgres running on the host. Can you get me a netstat? The command is below:

netstat -anb > C:\netstat.txt

[danjrahm]

Hello, just checking in to see it this is resolved.

[rarandall]

I was having this exact issue... Error 5: Access is Denied and the same log file output. Turns out I already had PostgreSQL installed in a different directory.

Uninstalling postgres and reinstalling Tabmon fixed the issues and everything is now working.

Hope this helps... rr

[jmangue]

Thanks for chiming in to help, rarandall!

Closing this issue out due to inactivity, please reopen it if you still need further assistance.

[Tabuser]

Hey Justin,

Sorry, Was busy with some other stuff and holidays. The issue is still open. I am not able to delete the tabmon postgre to reinstall it. I do need some assistance on this.

Thanks

On Sat, Jan 9, 2016 at 4:43 PM, Justin Mangue notifications@github.com wrote:

Thanks for chiming in to help, rarandall!

Closing this issue out due to inactivity, please reopen it if you still need further assistance.

— Reply to this email directly or view it on GitHub https://github.com/tableau/TabMon/issues/9#issuecomment-170284951.

[jmangue]

No problem, I know how it goes :) Hope you had happy holidays.

There's some guidance on how to delete the TabMon Postgres instance on page 9 of the User Guide which I'll paste here:

Open up a console window as administrator and enter these commands: sc stop TabMon-Postgres sc delete TabMon-Postgres ... then delete the folder where you told TabMon to install Postgres (default is C:\Postgres)

At that point, you should be able to reinstall TabMon. Sorry for the hassle on this; as Dan said, we leave Postgres in place during uninstall to prevent the customer from accidentally losing their data.

[Tabuser]

Ok. Thanks. I will try and let you know.

On Sat, Jan 9, 2016 at 5:14 PM, Justin Mangue notifications@github.com wrote:

No problem, I know how it goes :) Hope you had happy holidays.

There's some guidance on how to delete the TabMon Postgres instance on page 9 of the User Guide which I'll paste here:

Open up a console window as administrator and enter these commands: sc stop TabMon-Postgres sc delete TabMon-Postgres ... then delete the folder where you told TabMon to install Postgres (default is C:\Postgres)

At that point, you should be able to reinstall TabMon. Sorry for the hassle on this; as Dan said, we leave Postgres in place during uninstall to prevent the customer from accidentally losing their data.

— Reply to this email directly or view it on GitHub https://github.com/tableau/TabMon/issues/9#issuecomment-170287071.

[Tabuser]

Hi,

It was installed successfully. Thank you. I have a question, Do we need to install the Windows Framework Manager 3.0 on Windows server 2012r2 as well. I'm able to see the articles which says 3.0 is compatible only till windowss 2008. Is that true?

Thanks

[jmangue]

Hi,

Glad to hear you got it installed successfully!

If you already have TabMon installed and working correctly, you don't need to worry about Windows Management Framework -- we only require that during installation, in order to run some database initialization commands in Powershell. It looks like Windows 2012R2 actually includes Powershell, so you're all set.

Mind if I close this out?

[jmangue]

Closing out, reopen if you need additional help on this issue.

[Tabuser]

OK. Thanks Justin. You can close the issue. Thanks for the amazing support you guys are giving. On Jan 17, 2016 5:18 PM, "Justin Mangue" notifications@github.com wrote:

Hi,

Glad to hear you got it installed successfully!

If you already have TabMon installed and working correctly, you don't need to worry about Windows Management Framework -- we only require that during installation, in order to run some database initialization commands in Powershell. It looks like Windows 2012R2 actually includes Powershell, so you're all set.

Mind if I close this out?

— Reply to this email directly or view it on GitHub https://github.com/tableau/TabMon/issues/9#issuecomment-172390444.

[Shobananpa]

Hi Team, Could you please explain this step

2. Access the TabMon postgres installation using the tabmonsuperuser and delete/re-create the tabmon user. Thanks, Shoba