May I send MsgBox message for all users who has the same .xlsm file open from sharepoint?

We are using .xlsm files stored on sharepoint which need to be updated regularly. I would like to inform all users about macro starts/ends running who has the file open. Would be great to simply add a MsgBox to the VBA code but as I tested it is visible only for that user who starts the macro. Is there any solution to inform other users?

Many Thanks, marci

Use common VirtualBox setup between users

I want to solve the following use case: my wife and me (= two separate linux users) want to use THE SAME VirtualBox Windows10 virtual machine. So my idea is to have all VirtualBox settings under the user “vmuser” and start VirtualBox always in the vmuser environment.

Then in the folder /home/vmuser all the VirtualBox settings are set up.

On every user desktop I added a desktop file “VirtualBox.desktop” with the content:

 [Desktop Entry]  Comment=  Exec=mate-terminal -- /bin/su vmuser -w QT_QPA_PLATFORM_THEME,DISPLAY,XDG_RUNTIME_DIR -c /usr/local/bin/startVirtualBox.sh  GenericName=Go virtual  Icon=virtualbox  MimeType=  Name=VirtualBox  Path=  StartupNotify=true  Terminal=true  TerminalOptions=  Type=Application  X-DBUS-ServiceName=  X-DBUS-StartupType=  X-KDE-SubstituteUID=false  X-KDE-Username=` 

Clicking on this icon then launches the file /usr/local/bin/startVirtualBox.sh. The “-w” is for not replacing existing environment variables. I use “mate-terminal” because it is starting faster on my machine compared to “gome-terminal” but your mileage may vary.

For some to me yet unknown reason (I think the issue is the /bin/sh at the beginning but it does not work without) I need to define the environment variables this way:

 #!/bin/sh  QT_X11_NO_MITSHM=1   DISPLAY=$  DISPLAY  XAUTHORITY=$  XAUTHORITY  XDG_RUNTIME_DIR=$  XDG_RUNTIME_DIR  export QT_X11_NO_MITSHM  export DISPLAY   export XAUTHORITY   export XDG_RUNTIME_DIR    /usr/bin/VirtualBox 

This solution works as expected despite some error messages during the start of VirtualBox in the extra console window:

Qt WARNING: QStandardPaths: wrong ownership on runtime directory /run/user/1000, 1000 instead of 1002 Qt WARNING: Qt: Session management error: None of the authentication protocols specified are supported 

The user runtime directory is under control of the user who clicks the desktop icon (id=1000) and the VirtualBox process starts under the vmuser (user id = 1002). Ok.

But does anybody know how to get rid of this?

Authenticating Users In Django With SSH Keys

I would like to users of my REST API written in Django to be able to authenticate using SSH keys.

What I am doing is I have created an API to allow me to release software to my website via the command line. I want to authenticate using my ssh key when accessing that API.

So I have in my user interface that I can add public ssh keys associated with my user account.

Now how do I validate the keys in order to authenticate? What is it that I have to do?

I have my API client that will make a post call to:

https://examlple.com/api/release/

How can validate keys!? I have found a couple of python libraries but they are incomplete or unclear. Any step in the right direction would be helpfl.

Automatically sleep when all users (ssh or GUI) are logged out?

I’ve got an Ubuntu 19.04 desktop that I sometimes use as a physical workstation, and sometimes log into using ssh or NoMachine.

In order to save power, I’m wondering if there’s a way to make the computer automatically log off whenever there are no users, physical or remote, logged in.

I’ve tried setting “Suspend after 1 hour” in the power settings, but this seems to log off even if there are ssh users logged in.

Is there a way to enable this behaviour in Ubuntu?

Storing user’s private files on S3 and securing access using signed URLs – good idea?

I will be storing private user’s files on S3. The files will be PDFs, possibly containing private financial information.

I’m considering letting users directly access the files on S3, without proxying all the traffic through my app server. How should I do that?

So far I’m considering:

  • Signed URLs – what are the risks of the URL being “stolen”? I guess HTTPS is a must, what else?
  • Signed Cookies – is it any better than signed URLs?

Is this the correct way of doing it, or should I use a completely different approach (maybe not S3)?

Storing user’s private files on S3 and securing access using signed URLs – good idea?

I will be storing private user’s files on S3. The files will be PDFs, possibly containing private financial information.

I’m considering letting users directly access the files on S3, without proxying all the traffic through my app server. How should I do that?

So far I’m considering:

  • Signed URLs – what are the risks of the URL being “stolen”? I guess HTTPS is a must, what else?
  • Signed Cookies – is it any better than signed URLs?

Is this the correct way of doing it, or should I use a completely different approach (maybe not S3)?

Share document to multiple users using REST api in SharePoint 2013

I am using SharePoint 2013 rest api. I want to share SharePoint document among multiple users Here is my rest endpoint

https://XXXXXX.sharepoint.com/sites/XXXX-Test-SharePoint/_api/web/Lists(%27%7BB17B74B2-6EB4-4D3E-9DD6-4CCD0202C30D%7D%27)/GetItemById(90)/ShareObject 

and passing POST data to endpoint as below

{"peoplePickerInput":[{"Key":"i:0#.f|membership|john.miller@XXXXX.com","Description":"john.miller@XXXXX.com","DisplayText":"John Miller ","EntityType":"User","ProviderDisplayName":"Tenant","ProviderName":"Tenant","IsResolved":true,"EntityData":{"IsAltSecIdPresent":false,"Title":"Partner","Email":"john.miller@XXXXX.com","MobilePhone":0,"ObjectId":"c8dd8ac6-fb06-4d59-94e0-6e525b98146d","Department":"Professional Services Americas"},"MultipleMatches":[]},{"Key":"i:0#.f|membership|david.miller@XXXXX.com","Description":"david.miller@XXXXX.com","DisplayText":"david Miller ","EntityType":"User","ProviderDisplayName":"Tenant","ProviderName":"Tenant","IsResolved":true,"EntityData":{"IsAltSecIdPresent":false,"Title":"Partner","Email":"david.miller@XXXXX.com","MobilePhone":0,"ObjectId":"c8dd8ac6-fb06-4d59-94e0-6e525b98146d","Department":"Professional Services Americas"},"MultipleMatches":[]}],"propagateAcl":true,"roleValue":"role:1073741827","sendEmail":true,"useSimplifiedRoles":true,"emailSubject":"Sharing Test","emailBody":"Shared you folder..","includeAnonymousLinkInEmail":false} 

After executing above url, i am getting below response

{"odata.error":{"code":"-1, Microsoft.Data.OData.ODataException","message":{"lang":"en-US","value":"A node of type 'StartArray' was read from the JSON reader when trying to read a value of a property; however, a 'PrimitiveValue' or 'StartObject' node was expected."}}} 

share CUDA with multiple users

very easy question from a beginner. I am one of some users of a GPU server. There is CUDA 7.5 already installed and I want to install CUDA 9.0 and cuDNN 7.0 I am not sure weather the other users are running some application on CUDA 7.5, can I go ahead upgrading or I am risking the other users not to be able to run their project anymore? Thanks!