wakatime / ssms-wakatime Goto Github PK

Starting SSMS Express 2014 results in the following error message being displayed:

---------------------------
Microsoft SQL Server Management Studio
---------------------------
The Add-in 'WakaTime' failed to load or caused an exception.
Would you like to remove this Add-in?
If you choose yes, the file it was loaded from, 'C:\ProgramData\Application Data\Microsoft\MSEnvShared\Addins\WakaTime.Addin', will be renamed.

Error Message: <Unknown Error>
Error number: 80131515
---------------------------
Yes   No   
---------------------------

Is this just a case of the latest release not being supported? I've got other addins loading without issue so it doesn't seem to be a direct issue with SSMS, I think.

ActivityLog.zip

With release 2, SSMS 2017:

1. Downloaded
2. Followed instructions here: https://github.com/gandarez/ssms-wakatime
   (particularly copying WakaTime folder to C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions ), including running the batch file.
3. Was not asked for API key, not clear where to input.

Microsoft SQL Server Management Studio 14.0.17289.0
Microsoft Analysis Services Client Tools 14.0.1016.283
Microsoft Data Access Components (MDAC) 10.0.17134.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.17134.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.17134

The only way I've found to work around this is to put the key in the field you access from vs code by pressing f1. Save that. (if you enter it from anywhere else in vs code extension settings it won't save and says it's invalid.) then reopen SSMS and the key is saved as it should be. I believe you can do this by adding the key to VS2022 extension as well and then opening SSMS. Nice to have a work around, but it would be even better if it just allowed the correct amount of characters to be input in the SSMS field and other vs code fields directly

Hi!

I installed the plugin on SSMS 18.8, it works, but
it attribute the time to "Unknown Project" and file name is something like "~vsA005.sql"
how can I set project name?
I tried adding a ".wakatime-project" file containing the name of the project in the same directory where are stored primary and log database file but it still not works.

Thanks

hi, I followed the instructions but absolutely nothing is happening when I open SSMS. I changed the wakatime.cfg debug flag to true but nothing is logged about SSMS.

I ran the AddPackage.bat then copied the WakaTime folder to: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions

please help, this is my SSMS about:

Microsoft SQL Server Management Studio 14.0.17277.0
Microsoft Analysis Services Client Tools 14.0.1016.262
Microsoft Data Access Components (MDAC) 10.0.18362.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.18362.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.18363

thanks,

Hello,
I followed the instructions and did everything I found here in the Problems section, but it still doesn't report anything.
If anyone can help I would be very gratefulл
This is my SSMS about:

SQL Server Management Studio 15.0.18390.0
SQL Server Management Objects (SMO) 16.100.46521.71
Microsoft Analysis Services Client Tools 15.0.19714.0
Microsoft Data Access Components (MDAC) 10.0.19041.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19043

SSMS 18 version: 2019.150.18390.0 (Microsoft Visual Studio 2017 version: 15.0.28307.421)

CreateInstance failed for package [WakaTimePackage]Source: 'mscorlib' Description: Could not load file or assembly 'file:///c:\program files (x86)\microsoft sql server management studio 18\common7\ide\extensions\wakatime.v18\WakaTime.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)
System.IO.FileLoadException: Could not load file or assembly 'file:///c:\program files (x86)\microsoft sql server management studio 18\common7\ide\extensions\wakatime.v18\WakaTime.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)
File name: 'file:///c:\program files (x86)\microsoft sql server management studio 18\common7\ide\extensions\wakatime.v18\WakaTime.dll' ---> System.NotSupportedException: An attempt was made to load an assembly from a network location which would have caused the assembly to be sandboxed in previous versions of the .NET Framework. This release of the .NET Framework does not enable CAS policy by default, so this load may be dangerous. If this load is not intended to sandbox the assembly, please enable the loadFromRemoteSources switch. See http://go.microsoft.com/fwlink/?LinkId=155569 for more information.
 at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
 at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
 at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
 at System.Reflection.RuntimeAssembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, Boolean suppressSecurityChecks, StackCrawlMark& stackMark)
 at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)
 at System.Activator.CreateInstanceFromInternal(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)
 at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName)

System.NotSupportedException: An attempt was made to load an assembly from a network location which would have caused the assembly to be sandboxed in previous versions of the .NET Framework. This release of the .NET Framework does not enable CAS policy by default, so this load may be dangerous. If this load is not intended to sandbox the assembly, please enable the loadFromRemoteSources switch. See http://go.microsoft.com/fwlink/?LinkId=155569 for more information.

I've followed the directions for installing wakatime in SSMS but I'm not getting the item in the Tools tab nor am I see any errors:

Not sure what to do at this point.

I have follow these steps to be able to configurate:

1. Download the latest release https://github.com/gandarez/ssms-wakatime/releases/latest
2. Unzip the content.
3. Run AddPackage.bat to add WakaTime extension into registry white list.
4. Open SSMS and select option No
   
5. Close SSMS
6. Follow this step #23 (comment)

To fix this go to the wakatime.dll, right click properties and click unblock then okay and it’ll work on restart.

In the menu choose "Tools" > "Wakatime"

7. Start SSMS and right here the WakaTime extension should appear so you can add your API Key
8. It also appears in the Tools window

9. Now it is working

This is a combination of the issues relating to SSMS version 2016 and later whereby the reference to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0_Config\AutomationOptions\LookInFolders and C:\Users\AppData\Roaming\Microsoft\MSEnvShared\Addins is not pertinent.

In short the question is how do we get Wakatime to work in these environments for SSMS. The work around I am employing at present is to create database projects in Visual Studio to do my SQL work. However this does not compare to running SQL queries in SSMS

I have used this plugin for two days.
I used to think that it couldn't record data; today, I use debug mode to see its commands; I also saw the recorded file information on the dashboard; but in the editor this column does not show ssms, I also see the command Written in visual studio, so I think there is a problem with the command sent by this plugin.

and I think this is the problem

Hi!

I installed the plugin on SSMS 18.8, it works, but
it attribute the time to "Unknown Project" and file name is something like "~vsA005.sql"
how can I set project name?
I tried adding a ".wakatime-project" file containing the name of the project in the same directory where are stored primary and log database file but it still not works.

Thanks

HKCU registry part seems different of other versions.

I checked on AddPackage.bat and there is no handling of this case.
Is SSMS v19.x a handled version?

[WakaTime Debug 03:22:12 PM] ["\python27\pythonw", "C:\Users\xxxx\AppData\Roaming\WakaTime\wakatime-master\wakatime\cli.py", "--key", "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXX1c51", "--entity", "C:\Users\xxxx\AppData\Local\Temp~vsA096.sql", "--time", "1644351732.178587", "--plugin", "ssms/2019.0150 ssms-wakatime/2.0.1"]
[WakaTime Debug 03:22:12 PM] \python27\pythonw: can't open file 'C:\Users\xxxx\AppData\Roaming\WakaTime\wakatime-master\wakatime\cli.py': [Errno 2] No such file or directory

I went to C:\Users\xxxx\AppData\Roaming\ and noticed a folder named legacy-python-cli-master. I made a copy of this named wakatime-master and then the plugin started working again. Im guessing the repository names changed or something? not too sure but im suspicious of https://github.com/gandarez/ssms-wakatime/blob/master/WakaTime/Constants.cs#L16 and https://github.com/gandarez/ssms-wakatime/blob/8010b6ee0c85f343ac1d6b5bf5b5c5e3385ffcd9/WakaTime/Dependencies.cs#L43. Just tried downloading https://github.com/wakatime/wakatime/archive/master.zip myself and i got a file called legacy-python-cli-master.zip

Hi everyone,

I tried following the instructions on the help page and replaced "11_config" with "13_config" but not luck. Has anyone else had any luck getting that to work?

I start SSMS but i never get asked to enter an API key.

Newest extension release for SSMS 2017 installs fine but does not log at all

Currently testing SQL Server Management Studio 19 Preview 3, current v18 does not play nicely with v19.

I have the plugin installed and working fine within VS2017 and Notepad++. I have a .wakatime.cfg file which contains my API key.

I'd like to get it working within SSMS too so I followed the instructions as detailed here: https://wakatime.com/sql-server-management-studio

However SSMS doesn't prompt me for my API key, nor is there a Wakatime menu option either at the top level nor within Tools, nor is my time in SSMS being recorded. I'm not receiving any errors and I've tried running as Admin but that doesn't appear to make a difference either.

The only other extension I have installed is SSMS Tools.

Here's the info from my SSMS about screen:

Microsoft SQL Server Management Studio: 14.0.17289.0
Microsoft Analysis Services Client Tools: 14.0.1016.283
Microsoft Data Access Components (MDAC): 10.0.17134.1
Microsoft MSXML: 3.0 5.0 6.0
Microsoft Internet Explorer: 9.11.17134.0
Microsoft .NET Framework: 4.0.30319.42000
Operating System: 6.3.17134

https://wakatime.com/help/plugins/sql-server

I followed the steps in the URL above, but I see no sign of WakaTime in SSMS. I was expecting it to prompt for my WakaTime API.

I follow this step to install it
and when I start my ssms,I get this error

and this is my ActivityLog.xml
ActivityLog.zip
this is my ssms about page

and I use another extension:SQLPrompt,I don't know whether it cause this error

How can I link it to track alongside my visual studio project?

Is there any wakatime plugin for SSMS 19?

Hi

Please include WakaTime.AddIn in the release since it is needed, I had to use a few minutes to find out that the file is in the code.

Posted original issue a year ago at the now closed issue: #1 Original attempted install was version 1.0.3

Help!? Re the post referenced above, I did get past that step, but could never get past the "install python" prompt. Gave up. lived with the "install python" popup every time I open SSMS since then. Now I'm circling back and seeing new install steps. Seems much quicker, easier, etc. I was hoping that following these instructions for v 2.0.1 for SSMS 2014 would "override/overwrite" problems with my previous install attempt, sadly it didn't. ... can anyone provide instructions on what I need to back out to make the new install work? I've got wakatime.cfg & .db & .log in my C:\Users folder. Do I keep these? What about the WakaTime.Addin and WakaTime.dll files in C:\users\xxxxxx\AppData\Roaming\Microsoft\MSEnvShared\Addins\ ?? Any others? I really want this tool to work, any advice greatly appreciated.

I have SSMS 10.50.1600.1 (sql server 2008 R2) and my registry layout is completely different from the suggested install.

I don't have HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio...
Instead mine's HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server

The 11.0_Config makes me think this is designed for a higher version than I have.

Where should the WakaTime.Addin file go if none of the folders listed in the HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0_Config\AutomationOptions\LookInFolders registry key exist?

Create a new folder to match the registry or add an existing directory to that registry key?

We have a problem when sql server adapter install process "HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0_Config\AutomationOptions\LookInFolders" has our error message we have Active Directory Is it problem for this?

Possible duplicate issue; WakaTime isn't asking for an API key on startup. I've followed the latest instructions for installation and have run the .bat and tried SSMS as admin.

Console shows the following during startup so it appears the extension is being loaded; I just have no idea where you're meant to put the API key?

[WakaTime Info 03:47:09 PM] Initializing WakaTime v2.0.1
[WakaTime Info 03:47:10 PM] Current wakatime-cli version is 13.0.2
[WakaTime Info 03:47:10 PM] Checking for updates to wakatime-cli...
[WakaTime Info 03:47:10 PM] wakatime-cli is up to date.
[WakaTime Info 03:47:10 PM] Finished initializing WakaTime v2.0.1

I'm using the following version:
SQL Server Management Studio 15.0.18206.0
Microsoft Analysis Services Client Tools 15.0.1567.0
Microsoft Data Access Components (MDAC) 10.0.18362.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.18362.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.18362

Hi!
I'm sure I've done the installing procedure in the correct way but in logs I have this:

2018-09-14 19:35:52.3064|INFO|WakaTime.Logger|Initializing WakaTime v1.0.3 2018-09-14 19:35:53.0935|ERROR|WakaTime.Logger|Error initializing Wakatime: System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. at System.Net.WebClient.DownloadFile(Uri address, String fileName) at System.Net.WebClient.DownloadFile(String address, String fileName) at WakaTime.Downloader.DownloadCli(String url, String dir) at WakaTime.WakaTime.OnConnection(Object application, ext_ConnectMode connectMode, Object addInInst, Array& custom)

using ssms 2014

can suggest the reason

when are we getting support for SSMS 2017 ?
has anyone managed a work around? please confirm steps. Thank you