Synology L2TP VPN not working

This is an issue that a friend ran into. It seem like it was hard to find the correction information so posting here just to get it out there more.

Synology Diskstation 6.2 L2TP VPN Server

Windows clients could not connection but Mac could.

The fix, shown here on Synology site its to create the registry DWORD

Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PolicyAgent\AssumeUDPEncapsulationContextOnSendRule

Set the value to 2

Reboot and should work.

https://www.synology.com/en-us/knowledgebase/DSM/tutorial/Network/How_do_I_connect_to_Synology_VPN_Server_via_Windows_PC

 207 total views,  1 views today

Migrating Dormant Exchange accounts

Here is a simple script you get information for evaluating your exchange accounts.

This script will return a csv of all the emails, display names, and LastLogonTime on your databases.

Get-Mailbox -ResultSize Unlimited |
Select-Object DisplayName,
SamAccountName,
PrimarySmtpAddress,
@{label=”LastLogonTime”;expression={(Get-MailboxStatistics $_).LastLogonTime}},IssueWarningQuota, ProhibitSendQuota | Export-Csv “c:\filelocation.csv” -NoTypeInformation

 115 total views

Ready Set GO!

An unexpected upside of all the chaos right now is the fact that project migrations are happening way faster than originally planned.

Projects that were on hold till summer, are getting done in a week’s time.

An example, I just migrated a ton of users to Office 365, and OneDrive.

 254 total views,  1 views today

Working remote

So it seems that everyone is going remote with the US spread of COVID-19.

So I have been working to migrate users from on Prem to OneDrive.

The share point migration tool is definitely nice for this from a GUI perspective but I think the power shell side is a bit more robust.

It was super frustrated everyone I had one error the whole CSV would not run. Where as with power shell I can make it skip, alert and move on.

With respect to Education and remote classrooms, all the big companies are doing what they can to help out.

Check out this link for more info that might prove useful.

https://www.instructure.com/canvas/blog/canvas-partners-and-distance-learning

 269 total views,  1 views today

List Server – Exchange

Everyone wants to make the most of what you have right?

For years we used an old version of GNU Mailman as a moderated listed server. In an effort to consolidate resources I got it in my head I wanted to do a moderated list in our Exchange server.

The moderated part wasn’t that hard, thats already built in.

Exchange ECP -> Recipients -> Groups -> “Group Name” -> Message Approval

What took some getting creative was the syncing of users. The users were passed using an SQL query, and imported into the list on a semester basis.

Im sure there are a bunch of different ways this could of been approached. Here is out I tackled the problem.

https://github.com/ke5awf/exchangelistusermanagement

I set the following script to run nightly and rebuild the groups.

#10/10/2018
#Script for Syncing Emails from SQL to Distro list in Exchange
#Only Exchange Admin's should attempt to run this script

$SYNCNAME = "All Mailing Lists"
#Name of Sync

#The following sets up the connection to Exchange, it will ask you for Exchange Admin Credentials to start the remote session
$Username = "DOMAIN\USER"
$Password = 'PASSWORD' | ConvertTo-SecureString -AsPlainText -Force
Import-PSSession $Session -DisableNameChecking
$UserCredential = New-Object System.Management.Automation.PSCredential -ArgumentList $Username,$Password
#Or you can have it prompt you for the credentials by using the following line instead. 
#The following sets up the connection to Exchange, it will ask you for Exchange Admin Credentials to start the remote session
#$UserCredential = Get-Credential

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri http://EXCHANGE_FQDN/PowerShell/ -Authentication Kerberos -Credential $UserCredential
Import-PSSession $Session -DisableNameChecking

#Declare group list that the Users will be put into. 
#There is an assumption that this group exists already in exchange, if it does not you must create it first!!
$group1="DISTRO1"



#Get List of emails from SQL that need to be in this sync, plus any extras that need manually added.
#DISTRO1
$emaillist1 = (Invoke-SQLcmd -server 'SQL_SERVER' -database 'DATABASE' -Query "select email from database.dbo.maillist where listname = 'DISTRO1' order by lastname, firstname")



#Remove users from list that are currently in the list. This is being done with the update-distibutiongroupmember command.
Update-DistributionGroupMember -Identity $group1 -Members user@domain.com -Confirm:$false




#Get results of SQL and aux list and add email to specified group. 
$emaillist1 | ForEach {Add-DistributionGroupMember -Identity $group1 -Member $_.email}
Add-DistributionGroupMember -Identity $group1 -Member "specialadd@domain.com"


#required to exit SQLServer
cd c:


#Save results to \\FILESERVER\DESTINATION and email a copy to the admin
Get-DistributionGroupmember -identity $group1 | select DisplayName,PrimarySMTPAddress | Export-CSV "C:\MailLists\Export\$group1 $(get-date -f yyyy-MM-dd).log"
Send-MailMessage -SMTPServer SMTP_SERVER -To "emailadmin@domain.com" -From "EMAILSYNC@domain.com" -Subject "Distro List SYNC Complete $SYNCNAME" -Body "Sync results can be found in \\FILESERVER\DESTINATION" -Attachment "C:\MailLists\Export\$group1 $(get-date -f yyyy-MM-dd).log"

exit

This has worked for me very well. I would like to improve the code down the road, but for now it works great. I run the script from a server as a scheduled task nightly and everyone is synced up.

 309 total views,  1 views today

Canceling Vacation

Tickets ✅

Travel Plans ✅

Passport ✅

International Driving Permit ✅

COVID-19 …. ❌

Just like that our Italy trip was cancelled. After watching the state departments comments on COVID-19 and the reaction in Italy, we decided it was best to cancel our trip. Luckily we got Travel insurance and will get to use those funds for a future trip.

https://travel.state.gov/content/travel/en/traveladvisories/traveladvisories/italy-travel-advisory.html
https://www.livescience.com/coronavirus-updates.html

 211 total views