Connecting common points on a map

I work with a private preschool – 12th-grade school. The school has several campuses. And each campus has several hundred families. We have two separate spreadsheets. One spreadsheet has all of the parents’ home addresses and the other spreadsheet has all of the parents’ work addresses. We’re using a mapping software called eSpatial (but it’s limited). We can upload the spreadsheets (datasets) and map both batches of addresses.

The problem is that this doesn’t really tell us very much. Ultimately, we need a way to link home and work addresses together, visually, as being the same person.

For example, let’s say one point on a map is a parent’s home address at 123 Main St. and another point on the map is the same parent’s work address at 321 Sycamore Rd. We need a way to visually know that the two points below to the same person so we can see who, and how far, each parent travels to work. Ideally, if there was a line that connected the two points that would be great. That would make it easy to see how far away the parent works. Or it would also work to hover over one point and the corresponding home or work point would highlight.

Currently, the two spreadsheets do not have a common column that links the two together (I guess a “key”). Although I can create a spreadsheet that has a student ID column which would be the key between the two.

Any thoughts on how to put something like this together? Hopefully, this makes sense.

security – MFA on Linux server stops database GUI’s from connecting

I have a VPS which has Ubuntu 20.04 installed, I have configured SSH Key pairs for remote access and google_authenticator.so.

When trying to connect to the hosted mysql database through workbench, It fails due to having no support for the extra security layer (Google_authenticator).

As a workaround I created another user, and allowed this user to connect without the need to input a code, this in theory should allow workbench to connect through SSH, However the server still checks for the MFA, before passing it through, which in-turn causes workbench to fail, due to that extra security step.

Is there any alternative GUI platforms for mysql databases that support MFA for remoting in to a server, that is preferably not paid?

Or primarily would anyone know of a workaround for this, without the need of removing the extra security layer?

appletv – Remote not connecting to Apple TV 4 (2015) model after a factory reset

Ever since I did a factory reset my remote and Apple TV are not working well together. I’m in the screen where you have to press any button to continue. This doesn’t work because it seems like my remote is not connected. No hard feelings, I’ll try to connect it. I have to press the MENU and volume UP button for about 5 seconds.

When I do this, the Apple TV does recognise me trying to pair the remote, as it says that I need to bring the remote closer to the Apple TV to continue the pairing. When I do this however it seems like the pairing is not being done and it seems to freeze. At the very top a message appears where it asks me to press the MENU and volume UP button together again.

It doesn’t matter what I try but unfortunately it does not pair and it does not let me past the setup screen. Is it possible to do this setup without my remote, for example using my Macbook Pro?

macos – USB 3.0 hub connecting over USB 2.0; How to correct?

Issue:

I have a couple USB-C 3.0 hubs, and a 2016/2017 MacBook Pro 13″ (Fn-Key). The first hub, everything connected over USB 2.0, so I assumed it was just a shitty hub, so I bought one from Anker that is verifiably 3.0…

And all my devices connect over USB 2.0. Specifically, the device registers as both a USB 2.0 hub connect to the USB 3.0 controller, and as a USB 3.0 hub connected to the USB 3.1 controller. However, devices always default to the USB 2.0 device… โ€” This is confirmed by System Information.

USB 3.0 BusUSB 3.1 Bus

I tested the same hub on a Windows PC with a USB-C port and it connected as a USB SuperSpeed (3.0) hub over the USB 3.1 controller…

So why is my MacBook connecting it as a legacy 2.0 device?

It’s clearly not. The devices connected are USB 3 devices that do not require external power. The hub is a USB 3.0 SuperSpeed hub. But my MacBook keeps prioritizing USB 2.0 for whatever reason…

Is there a way to disable the 3.0 controller and/or the 2.0 hub device?

Update: One of the USB 3 devices randomly started connecting over USB 3.0 instead of USB 2.0, but another still connects over USB 2.0. Sometimes the flash drive (the one that started connecting right) still connects over USB 2.0 however. It seems… random?

air travel – Is it ever useful to allow access to phone data when connecting one’s phone to an airplane USB plug?

Occasionally useful, mostly irrelevant.

Some in-flight entertainment systems have USB ports that let you connect your own device and then play your own movies from said device on the IFE screen. Allowing access to your files would thus be necessary to be able to browse them through the IFE system.

More often, there is no such feature and the USB port is purely meant to be used as a charger. For reasons like supporting proper current negotiation (necessary for various fast charging protocols), the USB port might not be completely dumb (having just the power lines like a wall wart charger) but actually be a valid USB device with working data lines.

Any time you connect your phone to a real USB device, it pops up the dialog asking you whether you want to actually present the file access protocols to the device or to just play dead. The device does not need to “ask to access data” first, the phone asks you before it even offers the data access features to the device.

Connecting Sharepoint lists via lookup/utilizing the lookup item in Sharepoint Online

I’m making a leave request where the user picks which department he/she is in and also their manager to send the request to. I don’t want the user to manually type anyone’s email address. I want a drop down column of ‘Department’ and a dropdown column of ‘Managers’. See the photo. I already made these dropdown columns, and they are taking information from the same list. Thing is, I want so that whichever Department they pick, it only shows the managers of THAT department. For example, in the photo they selected ‘Engineering’. In the column Manager it is showing all 4 managers but I only want the manager of the Department to be seen. Reza is the manager of Engineering so I only want his name shown, no one elses. If you need any more info let me know. I am new to this and do not know much of the jargon, or if I am missing a key detail in order to recieve help. Thanks.

enter image description here

enter image description here

Why does bitcoin core appear to freeze while connecting to peers on startup?

When I startup bitcoin-qt (version 0.20.1.0) on linux, at the bottom of the app is the mesage “Connecting to peers… 4 years and 10 weeks behind”. It appears that things are just frozen, no progress and the increase per hour says “calculating…”. Estimated time left until synced is “Unknown…”.

In the .bitcoin/debug.log file, it just keeps spitting out a lot of the following.

2021-03-10T20:26:47Z Disconnecting and discouraging peer 88.99.213.166:8333!
2021-03-10T20:26:47Z New outbound peer connected: version: 70016, blocks=674050, peer=61 (full-relay)
2021-03-10T20:26:47Z New outbound peer connected: version: 70015, blocks=674050, peer=62 (full-relay)
2021-03-10T20:26:48Z ERROR: AcceptBlockHeader: block 0000000000000000032864f2cd9a15916fdd8c4e2b49a4a9c1403152bdaa6259 is marked invalid
2021-03-10T20:26:48Z Disconnecting and discouraging peer 213.156.1.101:8333!
2021-03-10T20:26:48Z ERROR: AcceptBlockHeader: block 0000000000000000032864f2cd9a15916fdd8c4e2b49a4a9c1403152bdaa6259 is marked invalid
2021-03-10T20:26:48Z Disconnecting and discouraging peer 35.245.173.118:8333!
2021-03-10T20:26:49Z New outbound peer connected: version: 70015, blocks=674046, peer=63 (full-relay)
2021-03-10T20:26:49Z ERROR: AcceptBlockHeader: block 0000000000000000032864f2cd9a15916fdd8c4e2b49a4a9c1403152bdaa6259 is marked invalid
2021-03-10T20:26:49Z Disconnecting and discouraging peer 34.69.253.72:8333!
2021-03-10T20:26:49Z New outbound peer connected: version: 70015, blocks=674050, peer=64 (full-relay)
2021-03-10T20:26:51Z New outbound peer connected: version: 70015, blocks=674050, peer=65 (full-relay)
2021-03-10T20:26:51Z ERROR: AcceptBlockHeader: block 0000000000000000032864f2cd9a15916fdd8c4e2b49a4a9c1403152bdaa6259 is marked invalid
2021-03-10T20:26:51Z Disconnecting and discouraging peer 37.187.117.39:8333!
2021-03-10T20:26:51Z New outbound peer connected: version: 70015, blocks=674050, peer=66 (full-relay)
2021-03-10T20:26:52Z New outbound peer connected: version: 70015, blocks=674050, peer=67 (full-relay)
2021-03-10T20:26:53Z ERROR: AcceptBlockHeader: block 0000000000000000032864f2cd9a15916fdd8c4e2b49a4a9c1403152bdaa6259 is marked invalid
2021-03-10T20:26:53Z Disconnecting and discouraging peer 47.96.111.238:8333!
2021-03-10T20:26:54Z ERROR: AcceptBlockHeader: block 0000000000000000032864f2cd9a15916fdd8c4e2b49a4a9c1403152bdaa6259 is marked invalid
2021-03-10T20:26:54Z Disconnecting and discouraging peer 75.148.91.168:8333!
2021-03-10T20:26:58Z New outbound peer connected: version: 70015, blocks=674050, peer=68 (full-relay)
2021-03-10T20:26:59Z New outbound peer connected: version: 70015, blocks=674050, peer=69 (full-relay)

Also, I do run a VPN, but even a few days ago things were working ok.

Thoughts?

Can I avoid connecting to a CDN if I block JavaScript?

I use a browser extension where I can selectively block JavaScript in a granular way. I often encounter the cloudflare.com or the https://cdnjs.cloudflare.com scripts on websites. I’m also aware that Cloudflare can act as a CDN to reduce latency, among other things. Does that mean that if I block the cloudflare scripts my browser will connect directly to the web host and not to the CDN if the website is sitting entirely behind a CDN?

Edit: clarity

Kioptrix level 1 SMB problem connecting

I’m new to the OSCP certification, and in lab 1, I need to solve Kioptrix level 1. In the OSCP webinar, I follow the same step as my instructor; everything seam to works just fine except the last step, which is connecting to Kioptrix throw SMB. but I am unable to connect, this is what I got:

โ”Œโ”€โ”€(root๐Ÿ’€kali)-(/etc/samba)
โ””โ”€# smbclient -L //192.168.47.135                                                                              
protocol negotiation failed: NT_STATUS_IO_TIMEOUT

On Reddit, someone had the same issue, and someone else sed to go to /etc/samba/smb.conf and under (globals) I should add client min protocol = CORE and client max protocol = SMB3 but after saving smb.conf I got:

โ”Œโ”€โ”€(root๐Ÿ’€kali)-(/etc/samba)
โ””โ”€# smbclient -L //192.168.47.135
WARNING: Ignoring invalid value 'CORE' for parameter 'client min protocol'
smbclient: Can't load /etc/samba/smb.conf - run testparm to debug it
protocol negotiation failed: NT_STATUS_IO_TIMEOUT

How could I solve the problem connecting to SMB?