March 2020 - Roundtable

How does on get the date function to work in Libre Office spreadsheet?
by eh＠eduardhiebert.com 07 May '23

07 May '23

Hi, I've formatted the cells as date mm/dd/yy and entered the values as is. Also tried by preceeding with equal sign in case deemed to be a formula but neither works. I assume a difference between two days yields the difference in days, correct? Or are the formula different than plain math? Eduard the Osborne guy at last meeting

4 6

Gmail spam filtering super-aggressive lately
by Hartmut W Sager 02 Apr '20

02 Apr '20

I've had a lot of trouble in the last few months with Gmail's spam filtering having become super-aggressive, but tonight we have a live case worthy of analysis. In the thread "Opinions on Fedora Server" initiated by Alberto Abrao <alberto(a)abrao.net>, *both* of Alberto's postings went to my Gmail spam, while Trevor Cordes's posting came through fine. A detail on my use of Gmail: I use it as infrastructure for my own e-mail addresses @marityme.net. Incoming e-mails to @marityme.net are forwarded into my Gmail address from somewhere else, and outgoing e-mails from @ marityme.net are sent from Gmail where I set up these addresses as valid "from" addresses. Yeah, I suspect the trouble is somewhere in Gmail's new expectations re TXT SPF, DKIM, DomainKeys, and such. Hartmut W Sager - Tel +1-204-339-8331

5 24

Main firewall / router for public facing subnet
by Alberto Abrao 01 Apr '20

01 Apr '20

Hi folks, hope everybody is safe and sound. This may be a basic question for most of you, but at any rate, I would rather ask here as I like the way MUUG members approach things. I have a Shaw connection with a few Static IPs. As of now the modem is bridged, and each machine grabs its own IP and goes to town, be it a static for servers or a dynamic for my local network router. On each of these, I set up firewall and whatever else is needed. I have the feeling that's redundant. That, and having a main router in front of them would help me set up things such as QoS and a central firewall. I am used to doing this for simple NAT duties, but this time I would have a router managing public facing IP addresses. Any tips on what should I look for to get started? Thanks! -- Alberto Abrao 204-202-1778 204-558-6886 www.abrao.net

5 11

win server licence
by Dan Keizer 30 Mar '20

30 Mar '20

well, first off this is not for me (honest!) .. a guy I know is looking to run a windows server licence for some specific software vertical he is looking at ... (i asked - they dont have a linux port) the company (no idea who it is) claims the software works best on server licence as it utilizes the hardware better ... he's looking at trying to save money on the licence, so does anyone have 2016 or 2008 server licences on dead machines that can be repurposed? wondering if the likes of MER may as well.... thanks. Dan.

5 8

Opinions on Fedora Server
by Alberto Abrao 25 Mar '20

25 Mar '20

Does anyone have experience with Fedora Server on a (semi) production setting? If yes, care to share your opinions? Thank you! Kind regards, Alberto Abrao 204-202-1778 204-558-6886

3 4

MUUG Meeting, April 14, 2020: CANCELLED
by Gilbert E. Detillieux 18 Mar '20

18 Mar '20

The Manitoba UNIX User Group (MUUG) will not be holding its next monthly meeting on Tuesday, April 14th: April 14, 2020: CANCELLED In light of the current concerns over COVID-19 and the risk of infection, and in keeping with a directive from the University of Winnipeg (which states "All discretionary events on campus currently scheduled until May 1, 2020 will be postponed."*), the MUUG board has decided to cancel the April 14th meeting. The board will be looking into ways we can provide a remote, virtual meeting for subsequent months, if the current public health circumstances continue. (Stay tuned for updates on future meetings.) * https://news-centre.uwinnipeg.ca/all-posts/uwinnipeg-update-on-covid-19-sit… For more information about MUUG, and its monthly meetings, check out their web server: https://muug.ca/ -- Manitoba UNIX User Group E-mail: <gedetil(a)muug.ca> c/o Gilbert E. Detillieux Web: http://muug.ca/ University of Manitoba Phone: (204)474-8161 Winnipeg MB CANADA R3T 2N2 Fax: (204)474-7609

1 0

Hacking Shaw email
by Rob Dyck 17 Mar '20

17 Mar '20

I have an odd question. The girlfriend's ex-mother-inlaw got herself in trouble with Shaw. She claims Shaw is holding her email and contacts hostage. We suspect she just hasn't paid her bill and got cut off. She asked my girlfriend to ask me how to get her email. Anyway to do that? Other than paying her bill? Rob Dyck

3 2

Question about physical hosting
by Grigory Shamov 12 Mar '20

12 Mar '20

Hi All, A theoretical question: is it still possible to host a physical server in Winnipeg somewhere? What would be the range of the hosting price per 1U, if there are no large traffic needs to it? Googling brought me https://www.datacentermap.com/canada/winnipeg/fiber-back-up-canada.html which lists a price from 2015, $190/U. Is it a right range or things became much cheaper since? I am interested in the order of magnitude of the prices. Thank you very much in advance! -- Grigory Shamov WestGrid Site Lead / HPC Specialist University of Manitoba E2-588 EITC Building, (204) 474-9625

4 3

MUUG Meeting, Tonight (Mar 10), 7:30pm -- FreeSWITCH Asterisk Clone
by Gilbert E. Detillieux 10 Mar '20

10 Mar '20

An update on tonight's meeting, which will take place as scheduled: Health Concerns In light of the current concerns over COVID-19 and the risk of infection, we ask that if you are currently experiencing any of the symptoms* (fever, cough, difficulty breathing, etc.), please stay home. All those attending should follow recommended guidelines** for hand hygiene and coughing/sneezing etiquette. * https://www.canada.ca/en/public-health/services/diseases/2019-novel-coronav… ** https://www.canada.ca/en/public-health/services/diseases/2019-novel-coronav… The Manitoba UNIX User Group (MUUG) will be holding its next monthly meeting on Tuesday, March 10. The meeting topic for this month is as follows: FreeSWITCH Asterisk Clone Troy Denton will present FreeSWITCH, "a Software-Defined Telecom Stack enabling the digital transformation from proprietary telecom switches to a versatile software implementation that runs on any commodity hardware. From a Raspberry PI to a multi-core server, FreeSWITCH can unlock the telecommunications potential of any device. Combined with our hosted cloud platform, SignalWire, FreeSWITCH can interconnect with the outside world and scale to any size." The group holds its meetings at 7:30pm on the second Tuesday of every month from September to June. (There are no meetings in July and August.) Meetings are open to the general public; you don't have to be a MUUG member to attend. ******************************************************************* Please note our meeting location for this month: *Room 1M28* Manitoba Hall, University of Winnipeg, entrance on Ellice Ave. between Spence and Balmoral St. Parking is available on the surrounding streets and in the lots on nearby streets. Look for signage once you're at the building, or ask a security guard. ******************************************************************* For more information about MUUG, and its monthly meetings, check out their web server: https://muug.ca/ Help us promote this month's meeting, by putting this poster up on your workplace bulletin board or other suitable public message board: https://muug.ca/meetings/MUUGmeeting.pdf -- Manitoba UNIX User Group E-mail: <gedetil(a)muug.ca> c/o Gilbert E. Detillieux Web: http://muug.ca/ University of Manitoba Phone: (204)474-8161 Winnipeg MB CANADA R3T 2N2 Fax: (204)474-7609

2 1

UDP bad checksum flood
by Scott Toderash 03 Mar '20

03 Mar '20

[10192947.300008] UDP: bad checksum. From 1.2.3.4:10398 to 3.4.5.6:5060 ulen 237 I started getting some of this yesterday on one host. I think that there is a way to use regex and fail2ban to block flood attacks like this. Does anyone have the recipe? It comes in on various ports. This example is port 5060 but the host does not have anything listening there.

2 2