At the office we needed a list of Postcodes of suburbs affected by the second lockdown of Melbourne, Victoria.
Below is the list. While I believe that this is accurate, assume it’s released under the MIT license. It could have gaps. (Technically it’s licensed under the ‘Creative Commons Attribution 4.0 International (CC BY 4.0)’ license)
UPDATE 16/7/2020 – As pointed out by Michael the list below is missing 3135 & 3136. I’ve included them in the list below.
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Background: I was asked to compile a list of postcodes in lockdown in Melbourne, I started by first going through the list of Local Government Area, I got to the second one and decided that their had to be a better way. Thank goodness for the DATA VIC site.
Failed to build pyinstaller Skipping wheel build for altgraph, due to binaries being disabled for it. Skipping wheel build for pefile, due to binaries being disabled for it. ERROR: Could not build wheels for pyinstaller which use PEP 517 and cannot be installed directly
It turns out that Windows Defender (the built in AV in Windows 10) was blocking runw.exe
The real error was a few lines above:
error: could not open 'PyInstaller\bootloader\Windows-32bit\runw.exe': Invalid argument
A quick unblock from Windows Defender and it worked.
Recently I added some headsets (Jabra PRO 9450) to a range of LG LIP-8012D and LG LIP-8024D phones.
The electronic hook switch plugs into the back of the handset, with the coloured strip (usually indicating pin 1) facing up. It’s best to remove the power, add the accessory, then plug it back in, otherwise, the phone won’t recognize the accessory. A second cable for audio is required from the headset port on the back of the phone to the base use of the headset. (only control signals are sent down the electronic hook switch cable)
The handset requires programming to be told to use the handset and not the speakerphone. Trans PGM > 6 > 1. Select 0 for headset then Hold/Save.
The handset requires programming to be told to ring in the headset: Trans PGM > 6 > 2 Select 2 for headset or 3 for both, then Hold/Save
Sometimes you need to move VPS’s, and you don’t want downtime with the SSL certs.
Well it turns out that you can easily run Let’s Encrypt in standalone mode and use DNS verification to do a once-off cert prior to moving the VPS. – Read the Certbot docs.
But once the migration has taken place, you may also want to return to the validation method that you had been using previously. Two options exist, either a) modify the config files by hand (strongly advised against) or to return to the certbot and get it to update the config itself.
For example here is how I generally get a SSL cert on a particular box:
To Connect with MSSQL or SQL Server via Zato 3:
#sudo su - zato
$/opt/zato/current/bin/pip install pymssql
(More info: http://pymssql.org/en/stable/intro.html)
Add the following lines at the end: [mssql+pymssql]
???I don’t know if this is required or not, but I still do it.
Deploy to other servers in the cluster: $cp /opt/zato/env/qs-1/server1/config/repo/sql.conf /opt/zato/env/qs-1/server2/config/repo/
Restart your cluster and MSSQL should appear as an option under SQL Outgoing connections.
Recently I had a bunch of trouble with some SIP trunks (read about it at: LG IPECS SIP Trunk Issue) and needed to edit the Least Cost Routing (or Least Call Cost Routing).
The system is pretty basic, landline calls go out of one CO group, calls to mobiles go to another CO group.
There are a couple of tables that control how LCR works: LCR LDT (PGM 221) and LCR DMT (PGM 222).
LCR LDT – Leading Digit Table – PGM 221
This is where the ‘patterns’ are setup, so that the phone system knows what to do with the call, based on the starting digit(s).
Check out this screenshot for a full view:
These are setup under Index 1,
Then in subindex 0-6 are setup for landlines, 7 is setup for the mobile calls.
For each of the Subindex 0-6, it looks at DMT 01
For the Subindex 07 (Mobile calls), it looks at DMT 02
LCR DMT – Digit Modification Table – PGM 222
[To be honest, I have no idea what is actually happening here, except for the reference to the CO/IP Group].
Index 1 routes via CO/IP Group 1
Index 2 routes via CO/IP Group 2
– Index 2 also has an Alternative DMT Index (3) – This is used when all the lines in CO/IP Group 2 are busy
– Routes via CO/IP Group 1.