error: failed retrieving file 'mingw32.db' from repo.msys2.org : SSL certificate problem: self signed certificate in certificate chain

one way to fix it is to replace ca-bundle.crt with the self-signed certificate.

This works for us going through netsweeper.

error: failed retrieving file 'mingw32.db' from repo.msys2.org : SSL certificate problem: self signed certificate in certificate chain

one way to fix it is to replace ca-bundle.crt with the self-signed certificate.

This works for us running through netsweeper.

req: a sims report with the columns classcode, admission number, admission number in the office field of 365 accounts, class code in the team name of the format #:classcode#

#get useraccounts, drop in file
get-msoluser -all | where-object {$_.office} | Select-Object Userprincipalname,office | export-csv -path msoluser.csv -NoTypeInformation

#add useraccounts to lookup table
write-output "Adding pupils to lookup"
$xpupils = @{}
import-csv msoluser.csv | foreach {
   $xpupils.add($_.office,$_.userprincipalname)
   }

#fetch teams
write-output "Fetching teams"
$xteams = get-team | Select-Object groupid,displayname

#process teams
write-output "processing teams"
foreach ($xteam in $xteams)  
{

   $xgroupid = $xteam.groupid
   $xname = $xteam.displayname

   $xListofCodes = [regex]::match($xname,'#.*)#').Groups[1].Value

   if ($xListofCodes.length -gt 3){


       $xCodeArray = $xListofCodes -split ","
       Write-Output $xteam.groupid
       foreach ($xcode in $xCodeArray) {
               Write-Output $xcode
               #Write-Output $xcode    
               #make an array of admission numbers that are assigned to this code
               $xclassarray = @()    
               import-csv studentclasses.csv | foreach {
                   #check row classcode matches $xcode
                   if ($_.class -eq $xcode) {
                           #add to array
                           $xclassarray += $xpupils[$_.adno]
                           }

                   
                   



                    }
           #printarray
           foreach ($ad in $xclassarray) {
           
           
                   Write-Output $ad
                   
                   #add to team. 

                   Add-TeamUser -GroupID $xgroupid -user $ad
                   
                   }
           
           
           }
       
       
       
       }


}

I reproduce the list to help anyone else looking for the right command

Connect to Office365

Connect-MsolService  

connect to exchange online

$UserCredential = Get-Credential

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri [url]https://outlook.office365.com/powershell-liveid/[/url] -Credential $UserCredential -Authentication Basic -AllowRedirection

Import-PSSession $Session -DisableNameChecking

**if you need to enable running scripts
set-executionpolicy remotesigned

Export staff emails from office365

get-msoluser -all | where-object {$_.userprincipalname -like "*@domain*"} | select-object userprincipalname | export-csv -path "d:\staffemails.csv"

Computers in AD and their last logon date

get-adcomputer -filter * -properties Name,LastLogonDate | sort LastLogonDate | FT Name,LastLogonDate -autosize | out-file "d:\allcomputers.txt"

Printers (not sure what this for)

get-wmiobject -class win32_printer -computername printserver -Filter "name='sci-colour'"

Add staff to security group

get-msoluser -all | where-object {$_.userprincipalname -like "*@domain*"} | export-csv -path "d:\staffemails.csv" 

$securitygroup = get-msolgroup | where-object {$_.displayname -eq "Encrypted_mail_users"}

import-csv d:\staffemails.csv | Foreach {add-msolgroupmember -groupobjectid $securitygroup.objectid -groupmembertype "User" -groupmemberobjectid $_.objectid}

add staff to mail enabled group using exchange online

make csv with msol.

$UserCredential = Get-Credential

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri [url]https://outlook.office365.com/powershell-liveid/[/url] -Credential $UserCredential -Authentication Basic -AllowRedirection

Import-PSSession $Session -DisableNameChecking

import-csv "d:\staffemails.csv" | foreach {add-distributiongroupmember -identity "groupname" -member $_.userprincipalname}

Remove a user or many users

#userprincipalname is usually their email address. CSV needs userprincipalname as column name

import-csv d:\tobedeleted.csv | foreach {remove-msoluser -userprincipalname $_.userprincipalname -force}

Assign license to many users

Set usage location first

import-csv d:\2019emails.csv | foreach {set-msoluser -userprincipalname $_.userprincipalname -usagelocation GB}

import-csv d:\2019emails.csv | foreach {set-msoluserlicense -userprincipalname $_.userprincipalname -addlicenses <tenantID>:STANDARDWOFFPACK_IW_STUDENT}

(it has an invalid error if the license is already assigned)

Add office field(admission number) from AD to many users

the column headings in the csv can be referenced with $_.

import-csv pupils.csv | foreach {set-msoluser -userprincipalname $_.emailaddress -office $_.officecolumn}

Account SKU IDs for students

get-msolaccountsku

AccountSkuId ActiveUnits WarningUnits ConsumedUnits

------------ ----------- ------------ -------------

<tenantID>:STANDARDWOFFPACK_STUDENT 3000 0 893

<tenantID>:STANDARDWOFFPACK_IW_STUDENT 1000000 0 661 (this one includes office apps)

<tenantID>:STANDARDWOFFPACK_IW_FACULTY staff with office365 apps

Get a list of users' UPNs

get-msoluser -all | where-object {$_.userprincipalname -like "*domain*"} | select-object userprincipalname,displayname | export-csv -path "d:\allemail.csv"

get last useractivity time

 import-csv "D:\allemail.csv" | foreach {$UPN = $_.UserPrincipalName; get-mailboxstatistics -identity $UPN | select @{n='UserPrincipalName';e={$UPN}},displayname,lastuseractiontime}

Need to do "Get a list of users' UPNs" above to get the UPNs

Remove groups using exchange online

export groups from admin groups list

import csv groups.csv | foreach {remove-unifiedgroup -identity $_.groupemail -confirm:$False}

Set the name of ADusers the same as sims "preferred name"

import-csv .\update.csv | foreach {set-aduser -identity $_.UserName -givenname $_.Forename -surname $_.Surname -displayname $_.Fullname}

set-aduser $_.Username -passthru | rename-adobject -newname $_.Fullname

Change the name of office365 accounts to match sims "preferred name"

set-msoluser -UserPrincipalName [email]pupil@domain.sch.uk[/email] -FirstName "Fred" -Lastname "Bloggs" -DisplayName "Fred Bloggs"

Import-Csv .\update.csv | foreach {set-msoluser -UserPrincipalName $_.EMail -FirstName $_.Forename -Lastname $_.Surname -DisplayName $_.Fullname}

It's taken me 3 hours to figure out that the scheduled task command

powershell -ExecutionPolicy Bypass -file .....

No longer works as intended. Although it allows the powershell script and by extension ninite pro to run, something is getting blocked.

If I run the ninite command on the command line it works fine. If I run the powershell command on the command line, the script runs ninite runs but then it's unable to find the applications.

Edit: I've worked out that powershell doesn't like the brackets in the line

Set-Variable APPS -option constant -value 'Chrome Flash "Flash (PPAPI)" "7-Zip" Irfanview "Notepad++" Audacity "Visual Studio Code" Blender Krita GIMP "Reader DC" "Paint.net" "Google Earth" Inkscape "Flash (IE)"'

I haven't worked out how to fix it yet.

Edit2: Made enquiries and the string is correct. Apparently it all goes wrong when powershell inserts the string in the execute command....

EDIT3: It works if you don't have a separate apps variable. I guess I can manage without that. I was planning to rewrite the script to deliver different apps to different devices. It's going to be a less efficient script.

In the previous non virtualized system we had 5 main servers, a san, and a bunch of other servers doing various jobs. If one of the 5 main servers went down we'd have to attach the volume on the san to one of the other servers and maybe remap a bunch of user areas. Any other server that broke would only affect its singular function. In the 7 year life of those 5 servers we never had a major outage.

In the new system we have 3 host servers running vmware off SD card and a 12TB san hosting all the data. On Thursday night one of the host servers crashed which put a 3rd of the VMs offline. Luckily it was mostly not any important ones.

After rebooting and a day of our support company trying to fix the situation we have 1 print server restored from backup, 6 other servers wiped out and a call in to vmware because VMX files have locks which refuse to delete making the vms unrecoverable!

I really hope Vmware know what to do as otherwise we just lost 1/3 of the VMs...

Imaging server + all the images

Proxy server for computer maintenance

Antivirus sophos server

Remote desktop server

Lucid Server (learning support program)

Dev server (all the install files, ISOs, login logs etc)

I'm shocked that something this bad could happen. Now the NAS is going to have to back up all the VMS just in case VMware kills them all, make sure the DCs are never on the same host, have a duplicate print server on a different host and consider having some functions running outside of the virtual system altogether.

MSOL

Exchange online.

You can add members to a security group using MSOL but you have to use EOL for distribution groups or mail-enabled security groups.

At this juncture I only know how to get user data using msol.

(we use -like @ domain because pupils have a different subdomain)

#connect MSOL
connect-msolservice

get-msoluser -all | where-object {$_.userprincipalname -like  "domain"} | export-csv -path "d:\staffemails.csv" 

#connect EOL
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri [url]https://outlook.office365.com/powershell-liveid/[/url] -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session -DisableNameChecking

import-csv "d:\staffemails.csv" | foreach {add-distributiongroupmember -identity "groupname" -member $_.userprincipalname}

Also worth a look is a Brazillian cryptonight coin called Niobio, although I haven't managed to find a remote daemon link for it as the wallet itself had a problem downloading the blockchain. But you can sell it on Tradeogre.

If you'd have sold stellite coins last week you would have made double what you could now.

Graft has forked to monero7 and the difficulty is way down at the moment so that's worth mining and selling for a few days.

Since a bunch of cryptonight currencies forked to counteract asic mining, the asic owners are on the prowl for currencies that haven't forked yet. Currently they're on Electroneum whose hash rate has spiked to 750MH.

An attacker on the intensecoin network caused 8 days worth of blocks in a few hours. They're going to roll the block chain back when they're ready to hard fork.

https://intensecoin.com/2018/04/16/imminent-hard-fork-and-network-attack/

is Turtlecoin dying as buy orders dry up? Apparently that's what's been happening on tradeogre and tradesatoshi. But if you believe cryptunit - Trtl is 4th worth $1.6 for 1000kh. Since Turtle runs cryptonight-light that's easily obtainable on as low as a GTX1060. Probably cryptunit.com doesn't bear in mind whether you can actually sell it or not. Turtle is so low in value it can't get cheaper. There's plenty of developers hard at work developing stuff but no sign of industrial interest. So I'm not sure where it's going to go. Don't go mad mining it.

Finally ultranote was last on cryptunit.com and has shot up to the middle of the table and it's price on tradeogre is up nearly 40%. 40% of nearly nothing is still nearly nothing. But it's worth 40 times turtle but you only get 150 XUN per block whereas turtle give ~29000 coins per block.

The difficulty has doubled in the last 2 days but the network hashrate is under 2MH - so i'm not sure what's happening with that.

We want to rent some of your computing power to do "work", you'll get a percentage of the value of the "work". Due to the market the value of the "work" changes but you'll always get more than you would spend in electricity. All you have to do is install our client on your computers. We'll send you a monthly report of how much "work" your computers performed, the cost of the electricity and how much we'll pay you for the work. It's the same as having solar panels - how much electricity you make and sell back to the electric co depends on sunny days. - In our case how much you make depends on how much your computers are turned on/logged in

Any companies like that around?

delete them because Narconon is a subsidiary of the church of Scientology and you don't want to get involved with those charlatans.

info: https://tonyortega.org/2016/10/09/exclusive-recent-deaths-of-scientology-rehab-staffers-points-to-ongoing-problem/

[ATTACH=CONFIG]47290[/ATTACH]

Occasionally I get mail addressed to somethingsomethingelse@gmail.com

i.e. no dot

As it happens, gmail accounts with dots in also have an alias of no dot. So somethingsomethingelse@gmail.com is a legit alias of my email.

So the strange thing is the mail i get to the alias is someone else's mail.

My email is def not compromised and I have 2 factor authentication.

The mails I get are typically signup mails where the signup mail is for verification and not required to log in so I request a password change on the account and then go through the account delete process.

Recently I've seen a dubious looking twitter account which had the language set to thai and a pornhub signup!

I get spotify promo emails in thai too.

It's hard to imagine someone has a similar prefix to mine and types it in wrong.

I still plan what I would buy if I were to do it.

My Budget is usually around £800 but I got some extra in lieu from a long service award. My ideal pc has decent quality components, best performance, quiet as possible.

Also I'm "attached" to certain brands. It pains me that it's hard to get hold of HIS graphics cards at the moment.

This is what I propose for July: (£902)

[ATTACH=CONFIG]44430[/ATTACH]

I still plan what I would buy if I were to do it.

My Budget is usually around £800 but I got some extra in lieu from a long service award. My ideal pc has decent quality components, best performance, quiet as possible.

Also I'm "attached" to certain brands. It pains me that it's hard to get hold of HIS graphics cards at the moment.

This is what I propose for July :

the main error seems to be related to ExcelMUI.MSI.

Of course the 64bit version of either works just fine...

Spent 5 hours writing the perfect script for changing the control assessment passwords.

It

chooses a random word out of 1600

changes the passwords using dsmod

writes them to files on the staff drive

emails them to relevant teachers using blat.

It took 5 hours because I don't code in vbscript often so practically every line had errors. Only 34 lines... Also originally I was going to have the vbs get the word and then feed it into a batch file to do the rest but later i realised I could do the whole lot in vbs using object.run.

2 hours later, today.....I can not make it work in a scheduled task and it doesn't tell me why it doesn't work.

I've tried using cscript in the scheduled task and a batch file that works from the command line.

Update

I found out how to get a log file from a scheduled batch file from here: Functional Fun: Debugging Windows batch files when used as scheduled tasks

Turns the out the problem all along that I hadn't noticed is where it initialises the text files it refers to them by drive letter which doesn't exist in the environment the scheduled task runs in.

Here is the script:

Const ForReading = 1, ForWriting = 2


Set objFSO = CreateObject("Scripting.FileSystemObject") 
Set objTextFile = objFSO.OpenTextFile("wordlist.csv", ForReading) 


thefile=objtextfile.readall
myArray = Split(theFile,vbcrlf)
objtextfile.close



function getword()
Dim max,min
max=1162
min=1
Randomize
getnumber=Int((max-min+1)*Rnd+min)
getword=myarray(getnumber)
wscript.echo(getword)
end function


Dim objShell
Set objShell = WScript.CreateObject("WScript.Shell")
Set f = objFSO.OpenTextFile("\\server\staffdrive\controlassessi.txt", ForWriting, True)
Set g = objFSO.OpenTextFile("\\server\staffdrive\controlassess.txt", ForWriting, True)

'controlassessi password change
tempword=getword() 
f.writeline(tempword)
objShell.Run  ("c:\windows\system32\dsmod.exe user " & Chr(34) & "cn=controlled assessmenti,ou=pupils,dc=domain" & Chr(34) & " -pwd " & tempword), false
objShell.Run ("blat - -body " & chr(34) & "new controlassessi password is " & tempword & chr(34) &  " -to browolf@domain -server server -f academic\administrator -subject " & chr(34) & "new controlassessi password" & chr(34)),false


'controlassess no internet password change
tempword=getword()
g.writeline(tempword)
objShell.Run  ("c:\windows\system32\dsmod user " & Chr(34) & "cn=controlled assessments,ou=internetban,ou=pupils,dc=domain" & Chr(34) & " -pwd " & tempword),false
objShell.run ("blat - -body " & chr(34) & "new controlassess password is " & tempword & chr(34) & " -to browolf@domain -server server -f academic\administrator -subject " & chr(34) & "new controlassess password" & chr(34)), false


f.close
g.close

The good thing about Dropshipping is that it takes little to no money getting stated, and later when you need to start paying for things, your profits cover it.

My partner has done it for 18 months and is now making £700-£900 a month profit.

I know a UK Amazon dropshipper who has 2000 items and makes £40k a year and has outsourced most of the work to the Philippines!

I can show you an ebay seller who is dropshipping, has 5000 items, sells ~50 a day and is probably making £300-500 a day!

There's tonnes of videos about it on you tube including a company called DS Domination. DSD is an American company that teaches Dropshipping and has a lucrative affiliate scheme.

What you can learn is useful, the basics and their facebook group is worth reading but don't fall for the idea of needing to upgrade, joining infinii or using their built in tracking. Just pay for a month or 2 then leave.

If you're interested PM me and I'll point you in the right direction.

It stalls on boot with CPU Fan error. Wait 30-60 seconds, reboot, and it works. Today it started happening again.

I know that the cpu fan is powered on an auxiliary fan power point and not the labelled cpu fan point. It didn't seem to be a problem when I first built the computer (probably because it wasn't between Nov and May at the time)

It has been suggested that it's a temperature thing with the board and ambient room temperature.

In any event I'm reluctant to mess with the insides of the computer and it's not a big problem.

Still, must be a contender for the weirdest computer error ever :-)

But it doesn't.

It finds the ITSupport group in "search people". I subscribed even though I'm a member.

Still nothing in groups section under mailbox :-(

this is a disaster as I told the deputy head that outlook 2016 would solve all our groups problems. The main one being people want to stay in OWA where the groups are, and not use outlook 2013.

It's not going to go down well if I have to tell them they need to remake all their groups in outlook 2016...

For the time being I'll just keep quiet about office 2016. Maybe it'll magically start working at a later date.

This talk is based on a book of the same name. Apparently he's on TV a lot, political debates and the like.

It's about the stories of the people who have been massively publicly shamed online.

Jon Ronson has a lot of stories... and a wonderful way of describing them and events that have occurred to him or people he met. Funnily enough I've never read his books but I like listening to him talk about stuff.

If you like that; definitely check out this playlist of recordings from a radio show called "Jon Ronson on..... Stories on a variety of subjects.

There's one about the time, every night when he went out to call his cat (Monty) in, he hears someone, an unknown neighbour, mimicking his voice!

If you like Zero 7 or perhaps björk, I think you'd like this too.

The singer, a peruvian woman has an incredible voice that it's hard to believe isn't being post-produced in some way. This video from a russian radio station illustrates its live quality (they didn't believe it either)

this is the produced version is at

It's called Profit Accumulator, which is a sytem for doing "Matched betting". From what I can see, matched betting has been around for years, but not as simple as this.

It takes a while to get your head around how it works.

Makes money from bookies's free bets. Converts about ~75% of the free bet into money in your pocket.

Using tools on the Profit Accumulator website, you place an initial bet with minimal losses. then use freebie bet with a massive advantage.

The advantage comes because half the bet is free and you bet for and against. It depends on close odds. The site lists the best for vs against odds. Betting against is effectively acting as the bookie vs some other punter's bet.

Say you have a £20 free bet and you see England to win at odds of 18 (sounds about right!) and loose(not win) at 17.5

Use the tools on the site to figure you need to bet 19.48 against. The calculation takes into account stake not returned and the against bet comission.

If england win, overall you gain £18.58

If endland loose/draw (not win), overall you gain £18.51

Really the only traumatic bits are the liability of the against bet and knowing if you make a mistake...

Because you're the bookie you might have to pay out for someone elses win.... but the amount you pay out is always less than what you win on the other end.

You need a bit of money to start with. The best bit is you can join for free and get instructions on 2 free bets that you're guaranteed to make money on. I made about £30.

there's some videos on the Profit Accumulator website which probably explain it better than i can.

With a premium account you also get added to a very busy facebook group which constantly has new bet opportunities and much discussion about existing ones.

I need a machine to install FreeRadius on. Using debian on a hyper-V virtual machine on win 2008r2. It installed Really fast

So what's a mystery is after switching the sources from DVD to the internet ones in sources.list, only 3 mentions of radius can be found. Unlike the 63! in the wheezy repository site.

I've done apt-get update and even apt-get upgrade (which did upgrade files from the internet) but still can't find freeradius.

Anyone know why I can't apt-get install freeradius ?

Set up 2 dhcp boxes on the guest wireless to replace proxies. Proxies no longer needed, only dhcp to hand out county addresses.

First one works fine. Its a debian base install with only isc-dhcp-server, dnstools, ntfs-3g, dhcpstatus & ssh. It's super quick on a dual core HP workstation!

the second one is a failover handing out the 2nd half of our allocated range. I was writing the documentation whilst I did that one. Sort of a record of how to set another up if something happened to me.

for some reason I can't fathom, dns lookups have stopped working on the 2nd one. I can ping the router, the 1st server, but not the upstream dns, which also i means I can't install ssh as now the repository won't resolve.

It was working before as I managed to install everything upto and including ntfs-3g from the internet and dhcpstatus copied off usb. Configured dhcpd.conf, interfaces and dhcpstatus. Been scratching my head for an hour at least.

wait i just had an idea.

{thoughts about default gateways and routes}

Oh my god I put gatway in the interfaces file

I looked at that like 3 times and didn't notice....

It's a miracle more things haven't "gone wrong", the number of times having to unjam printers, replace cables and the such in classrooms whilst I been doing this!