On my Mazda 2 (2011 Black model) The door open light is staying on and will not lock

On my Mazda 2 (Black model 2011) The door open light on the dash is on despite all 5 doors being properly shut and will not lock on the remote or the key because it thinks a door is still open.
Could this be a problem with one or all door shut sensors.
Has anyone experienced this and or can recommend a solution.

Google Sheets. Cursor staying in cell

By comparison between Excel where when you press keys Ctrl+Enter, the cursor doesn’t move from the current cell, in Google Sheets there’s no such option. Well I think there’s not such option. Can you help me to at least confirm that there’s no option to keep the cursor to stay still in the current cell using keyboard’s keys?
Thank you.

Question: Is it worth staying, or should I just take the L and leave?

Hi Everyone. I’m 28, my boyfriend is 26. We’ve been together for 2.5 years. Over all, our relationship has been good. Latently, it’s been a little tough for me. You see, we live together. I’m ready for marriage, he isn’t. I ask him why not, he says that we have some things we need to work on in the relationship, and that he’s just not ready. It’s no secret that we love each other and we both want to be with each other, but I need a commitment. We live together, and that’s why I’m pushing marriage, and he’s not bugging. I don’t have time to wait on him. I don’t want to waste more years on him not knowing for sure if he is going to marry me or not. I also want another child ( I have one child; not my boyfriend’s child), he’s not ready for a child now. I can’t waste the rest of my child bearing years waiting on him. Should I stay, or should I go?

Re-entry period after staying for 6 months in canada

Good day!

i would like to ask something. my mother-in-law came and stayed in Canada for 6 months then she went back to Philippines last May 2018. My question is. can my mother-in-law come back in Canada eventhough it’s not yet 6 months since she went back to Philippines? is it must be 6 months cooling period before coming to Canada or maybe less?

Thank you in advance!

Best regards,

Oni

Question: What are some good tips for staying awake in lectures?

I have a particular class that I keep falling asleep in. Its later in the day, and I make sure to drink cups of coffee before it, and to avoid meals before the class. Despite this, halfway through the class I always fall asleep- this is worsened because I sit in the front row.
Are there any other tips that can help me stay awake?

Configuring external SMTP server on Azure VM – messages staying in queue

I have an external SMTP provider: auth.smtp.1and1.co.uk

I am trying to send SQL Server Reporting Services emails via this on an Windows 2012 Azure VM.

It is configured sufficiently correctly for emails to be generated, but I’ve not configured something or mis-configured something as the emails then stay in the queue.

Setup details

Configured SMTP Virtual Server

General: IP Address: Fixed value
Access: Access Control: Authentication: ticked Anonymous access
Access: Connection Control: All except the list below (which is empty)
Access: relay restrictions: Only the list below (which contains 127.0.0.1), ticked 'allow all..' option
Delivery: Outbound Security...:Basic Authentication with username and password completed, ticked TLS encryption
Delivery: Outbound connections...:TCP port=587
Delivery: Advanced: FQDN=ServerName, smarthost=auth.smtp.1and1.co.uk

I then set the following SSRS rsreportserver.config values:

100.92.192.3
2
 c:inetpubmailrootpickup 
tickets@sqlrelay.co.uk

Tried so far

  1. turning the smtp service off and on again (just in case)

  2. run SMTPDiag with no errors (also no emails)

  3. tried turning off the firewall for the ports (and more generally to see if it made a difference)

  4. tried generation from powershell which resulted with message in queue

  5. added 25 and 587 as endpoint

  6. perused the event log and found some warnings that appear to be about the recipient

    Message delivery to the remote domain ‘gmail.com’ failed for the following reason: Unable to bind to the destination server in DNS.
    Message delivery to the host ‘212.227.15.179’ failed while delivering to the remote domain ‘gmail.com’ for the following reason: The remote server did not respond to a connection attempt.

  7. tried pinging but this appears to be blocked on azure

  8. tried more powershell sending on different domains variants (localhost, boxname, internal ip used in smtp properties, 127.0.0.1) – none resulting in success

  9. tried adding a remote domain – no change

Could anyone recommend what step 10 should be in fixing this issue please?