- wlug - University of Waikato Mail Lists

SQLite 3.14 Does CSV
by Lawrence D'Oliveiro 09 Aug '16

09 Aug '16

The latest release of SQLite now lets you load a CSV file as a “virtual” database table, and do the usual sorts of queries on it <http://phoronix.com/scan.php?page=news_item&px=SQLite-3.14-Released>. More details about the new extension here <http://www.sqlite.org/csv.html>.

1 0

Linux Abandoning DocBook For Its Documentation?
by Lawrence D'Oliveiro 08 Aug '16

08 Aug '16

Just came across this <http://www.theregister.co.uk/2016/08/08/linux_48_rc1_lands_with_surface_3_s…>: Torvalds has also pointed out that while progress on v 4.8 is “fairly normal … the patch itself looks somewhat unusual: over 20% of the patch is documentation updates, due to conversion of the drm and media documentation from docbook to the Sphinx doc format. There are other doc updates, but that's the big bulk of it.” DocBook is an open-source implementation of SGML, which is a pretty heavyweight, official-international-standard, 1980s, big-company way of writing documentation. Sphinx, on the other hand, is commonly used for Python documentation, including on python.org itself <https://docs.python.org/3/index.html>. If you were putting together the documentation set for a passenger liner or a chemical factory, you’ll probably use SGML (in fact, there is very likely a legal requirement to do so). But for the rest of us, more lightweight markup systems like Sphinx/ReST and Markdown are much more convenient.

1 0

The Murky (Under)World Of Pay-Per-Install
by Lawrence D'Oliveiro 07 Aug '16

07 Aug '16

A research group has released a paper <http://www.theregister.co.uk/2016/08/05/payperinstall_study/> studying those “free” software installs that bring along a host of uninvited guests with them. While not actually illegal (yet), they resort to sneaky tactics, like lying low for a few weeks before taking over your browser search bar or injecting ads, to try to obscure their origin. They even actively defeat blocking attempts, by jumping between domain names as often as in a matter of hours.

1 0

Old server hardware
by Daniel Lawson 04 Aug '16

04 Aug '16

Hi all Endace is getting rid of a lot of old server hardware. Some of it is still in reasonable condition, and I can make it available to WLUG members if they are interested. It's all offered as-is, on a first-come-first-serve basis, and if you say you want it you have to take it away ( we are sending it to an e-waste recycler very soon) There's two types of system, multiple units of each: 1U, non-redundant PSU (SMC 6015X-TB system), Supermicro X7DBX-i motherboard, dual Xeon X5440 (quad-core, 2.5GHz), 16 or 32 GB (depending on unit) DDR2 667MHz FB DIMMs, IPMI controller, dual gige LAN, 3x SATA disk in hotswap drive bays 3U, 2+1 redundant PSU (Chenbro Chassis), Supermicro X7DBE Motherboard, dual Xeon X5540 (quad-core, 2.5GHz), 16 or 32 GB (dependint on unit) DDR2 667MHz FB DIMMs, IPMI controller, dual gige LAN, 2x 3Ware 9650SE-8LPML RAID controllers, 16 x SATA disk in hotswap drive bays In both cases, any disks inside them will need to be scrubbed. If anyone is interested, based on a firm commitment to pick up, please let me know by Friday 5pm. Email to daniel.lawson(a)endace.com or daniel(a)meta.net.nz please Thanks

3 3

FTC Stops Requiring Regular Password Changes
by Lawrence D'Oliveiro 04 Aug '16

04 Aug '16

Lorrie Cranor, new chief technologist at the US Federal Trade Commission, has managed to persuade them to drop their policy of requiring regular password changes <http://arstechnica.com/security/2016/08/frequent-password-changes-are-the-e…>: Frequent password changes do little to improve security and very possibly make security worse by encouraging the use of passwords that are more susceptible to cracking.

1 0

Beware Of User-Interface Experts
by Lawrence D'Oliveiro 04 Aug '16

04 Aug '16

The nice thing about GUIs is that there are so many to choose from. And everybody has an opinion about them. Particularly UI experts, who are always ready to point to things that any particular GUI does wrong. Even the platform developers themselves are prone to keep redesigning things from time to time. And then not even following their own rules. There was a famous map of the New York subway, released in 1972 <http://www.nytimes.com/2012/08/06/arts/design/the-subway-map-that-rattled-n…>, that represented the network in such a stylized fashion that the city’s residents got mightily confused. Was it the people’s fault? Was the designer’s brilliance simply misunderstood? Sometimes I think UI designers themselves lose track of how users actually do things outside their labs...

2 2

Project Hosting Service Fosshub Compromised, Embedding Malware Inside Hosted Files
by Peter Reutemann 04 Aug '16

04 Aug '16

'At least some applications on Fosshub, a free project hosting service appear to have been compromised, according to several reports. (Update: Fosshub has acknowledged the hack.) The software portal, furthermore, is serving malware payloads, reports add. Catalin Cimpanu of Softpedia says that a hacking group which goes by the name of PeggleCrew is responsible for the hack. "In short, a network service with no authentication was exposed to the internet," the hacker told Softpedia in an email. "We were able to grab data from this network service to obtain source code and passwords that led us further into the infrastructure of FOSSHub and eventually gain control of their production machines, backup and mirror locations, and FTP credentials for the caching service they use, as well as the Google Apps-hosted email." The hacker group told the publication that they have compromised the entire website, "including the administrator's email. He also revealed he didn't dump the site's database but claimed that "passwords weren't salted." A user on Reddit, who has since received lots of upvotes, adds: Some popular apps that have links to FossHub that may be infected include: Audacity, WinDirStat, qBittorrent, MKVToolNix, Spybot Search&Destroy, Calibre, SMPlayer, HWiNFO, MyPhoneExplorer, and IrfanView. Another application which has reportedly been compromised is Classic Shell. It is ostensibly overwriting the MBR on users' computers. Many users are upset with the timing of hack, noting that plenty of people were looking for Classic Shell amid the release of Windows 10 Anniversary Update. Update: 08/03 17:30 GMT by M :In a blog post, Audacity said that Fosshub was serving a hacked copy of its audio editing software for three hours. It adds that "no Audacity Team infrastructure was compromised." Fosshub team writes: Last night we had a security incident caused by a group of hackers that allowed them to log-in to FossHub developer *through* an user that was compromised. Shortly after, we noticed two users that were compromised. They simply logged-in using their passwords and this allowed them to escalate. [...] Several hours later, we noticed the attackers were able to gain access through an FTP account and we decided to shut down the main server immediately to prevent any further infection/damage. FossHub.com is down on purpose until we are able to identify the way hackers were able to escalate. Fosshub insists that the hacked copy of Classic Shell was only downloaded 300 times. In the meantime, if you know someone who may have downloaded the compromised copy of Classic Shell, here's what they need to do next.' -- source: https://tech.slashdot.org/story/16/08/03/1635240 Cheers, Peter -- Peter Reutemann Dept. of Computer Science University of Waikato, NZ +64 (7) 858-5174 http://www.cms.waikato.ac.nz/~fracpete/ http://www.data-mining.co.nz/

2 1

Windows 10 Anniversary Update Borks Dual-Boot Partitions
by Peter Reutemann 04 Aug '16

04 Aug '16

'Windows 10 Anniversary Update may affect and even delete other partitions on the same disk, OMGUbuntu is reporting, citing several complaints by users. "Broken boot loaders on an update are one thing but losing data, even entire partitions?" asks the author. Microsoft-centric news blog WindowsReport is corroborating on the report, adding that in some cases, the new OS was not able to detect some partitions. It says (edited): Many users are reporting that some of their partitions disappeared after installing the Anniversary Update. Usually, it's the smallest partition that disappears, although we couldn't say for sure whether the partition is deleted or if Windows simply doesn't detect it. Some users are saying that the partition is not allocated, while others can detect it once they install third-party partition management applications. We have reached out to Microsoft for clarification, and will update the post when we hear back from them.' -- source: https://linux.slashdot.org/story/16/08/03/1614223 Cheers, Peter -- Peter Reutemann Dept. of Computer Science University of Waikato, NZ +64 (7) 858-5174 http://www.cms.waikato.ac.nz/~fracpete/ http://www.data-mining.co.nz/

1 0

LibreOffice 5.2 Officially Released
by Peter Reutemann 04 Aug '16

04 Aug '16

'LibreOffice 5.2 is finally here, after it has been in development for the past four months, during which the development team behind one of the best free office suites have managed to implement dozens of new features and improvements to most of the application's components. Key features include more UI refinements to make it flexible for anyone, standards-based document classification, forecasting functions in Calc, the spreadsheet editor, as well as lots of Writer and Impress enhancements. A series of videos are provided to see what landed in the LibreOffice 5.2 office suite, which is now available for download for GNU/Linux, Mac OS X, and Microsoft Windows operating systems.' -- source: https://news.slashdot.org/story/16/08/03/2022226 Cheers, Peter -- Peter Reutemann Dept. of Computer Science University of Waikato, NZ +64 (7) 858-5174 http://www.cms.waikato.ac.nz/~fracpete/ http://www.data-mining.co.nz/

1 0

Security Vulnerabilities In Wireless Keyboards
by Lawrence D'Oliveiro 03 Aug '16

03 Aug '16

You’d think they’d be encrypted, but apparently most of them are not <https://www.schneier.com/blog/archives/2016/08/security_vulner_7.html>.

1 0