- main - earth.li

Libre Office Calc
by Phil Thane 01 Apr '22

01 Apr '22

Database nerds look away now. I have two loads of data in .ods or .cvs. Basically two versions of a membership list, one with >500 rows, the other >700. I want a list of approx 200 who are on the big list but not the smaller. 'Compare' in LO just gives me a list of thousands of cells that are different, that's no help. Can anyone help? Lots on t'internet about merging and tracking changes but nothing about my case I can find. -- Phil Thane www.pthane.co.uk Tweet @pthane 01767 449759 07582 750607

7 9

Re: Libre Office Calc
by cl＠isbd.net 29 Mar '22

29 Mar '22

On Tue, Mar 29, 2022 at 03:15:20PM +0100, Phil Thane wrote: > On 29/03/2022 14:42, Chris Green wrote: > > Can you export them (via CVS) to two tables in a database, it would > > then be trivial to get the answer you want. > > You're absolutely right of course but then I'd have to spend hundreds of > hours learning how to use a database. About 30 years ago I used Access. > Later the LO equivalent 'Base' but that was probably nearly 20 years ago. > Since then not needed anything. Not worth the time for a one off. Thanks > anyway. > It's a trivial bit of SQL to do what you want once the two sets of data are inthe database. No need to learn a lot, just use the command line sqlite3, nothing as complex as Access or anything like that. In this case, IMHO, a GUI just adds complication. -- Chris Green

1 0

OT: DNS propagation delays
by Mark Rogers 16 Mar '22

16 Mar '22

I figured someone here might be able to explain this to me better than the ISP (or tell me they're wrong). A lot of domain registrars provide DNS hosting, but often only after the domain has transferred, and only after the DNS is set to use their servers. This means there is a delay between (a) switching to the new DNS and (b) adding the host records to it, resulting in potential downtime for anything that relies on the DNS. My question: If the time between (a) and (b) can be reduced to almost zero (such as by making both changes in a single hit via an API), I assumed that there'd (almost certainly) never be an incorrect DNS response given and therefore no propagation delays should apply. However the company in question told me that there would still be a propagation delay but disappeared from the chat when I asked where. Am I missing something, and if so what? -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0344 251 1450 Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

5 11

Manually creating "thunmbnails"
by Mark Rogers 16 Mar '22

16 Mar '22

I have 100+ images. From each I need to create what might best be described as a thumbnail, but manually rather than automated. I need to manually choose which part of the image is used. What I need "automated" is ensuring the correct aspect ratio. GIMP allows me to set the aspect ratio for the selection, which works well. But from there I still need to "crop to selection", "export as", enter a filename, and set export properties. Which makes it quite cumbersome when I have so many to work through. Any suggestions for a better tool, or way to automate the rest of the process in GIMP? My ideal workflow would be: - Open image "xxx.png" (or "xxx.jpg" etc) (with no additional prompts for how to perform the import) - Manually select the area I want to use as the thumbnail - Hit a key to save just that selection as (eg) "xxx.thumb.png", or "xxx.png" to a "thumbs" directory. As few additional steps as possible so that the focus is on the selection of area, not the process. Note that It's likely I'll want the output format to be png regardless of input format (or maybe jpeg, not yet decided - but it'll be a global choice not determined by the input format. That said I can post-process using imagemagick "convert" if I have to. Thoughts? -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0344 251 1450 Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

2 2

Zentyal as a domain controller.
by B D 14 Mar '22

14 Mar '22

Hi all, Just wanted to ask if anyone here is using Zentyal. I have a number of vlans on cisco L3 switches, two independent domains and fortinet firewall to make all more complicated. I'm having problems with gateways and multipaths in Zentyal. I'm guessing this will be better suited for Zentyal forum, but maybe some of you had/have experience with Zentyal. Cheers! Bart

1 0

Thunderbird 91 will not open pdf's in preview
by Bev Nicolson 08 Mar '22

08 Mar '22

That's it really. I wasn't sure about the change for a time but I'd quite like it to revert now. But even though I've made sure the settings ask it to, it will not open pdf's in preview any more but in Firefox. Has anyone found a solution yet? Googling has got me nowhere. Bev (Linux Mint 19.)

1 0

Part time sysadmin or business infrastructure consultant
by Jenny Hopkins 07 Mar '22

07 Mar '22

Morning, As some of you know, I've maintained a mainly internal business set-up for a local client, including the maintenance of currently two debian servers (one hosted at bytemark), 2 ubuntu desktops, wifi access points, data backups, and just generally helping the client get what he needs from his desktop. I'm now a very hand-on granny of two, and find I just don't have the time nor inclination to do the job, however I'm unwilling to leave the client in the lurch. I wondered if anyone on-list knows of anyone who would take over this set-up, which could consist of either five minutes a week, or several hours if something goes wrong? Failing this my techy brother tells me that they way the IT is run is very last century, and that nobody runs their own mail server internally any more or upgrades from the command line etc etc. Does anyone know of a consultant who might advise on how to get the company IT zooming into 2022? Many thanks, Jenny

1 0

ntpclient
by Mark Rogers 03 Mar '22

03 Mar '22

I think this might be more about my expectation than anything else but I am struggling to get ntpclient to work (on an openwrt-based box). It is configured to update every 600s but my clock is drifting by about 2s/day so there's clearly no corrections taking place every 10 minutes, and if left for a week it just continues to accumulate so I don't think it's doing anything at all. But I don't really know what to expect. I'm measuring the drift using ntpclient -c 1 -h 0.openwrt.pool.ntp.org .. so I know it has access to the NTP servers if it chooses to use them, Any suggestions? When I google I find details on setting things like freq for far greater accuracy than I care about (a second or two out is fine by me as long as it isn't accumulating). I'd rather not move away from ntpclient as that's what's baked into the openwrt firmware I'm using and I'm trying to avoid making unnecessary changes, but I just can't get this to work. (I'm sure ntpclient -s in crontab would fix it but surely that isn't supposed to be necessary?) -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0344 251 1450 Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

3 6

OpenVPN with IPv6 only clients
by Mark Rogers 17 Feb '22

17 Feb '22

Just playing with ideas really but I would like to try setting up a VPN, accessed over IPv4, but where everything within it is IPv6. There's a few reasons, but they're mostly that I don't know enough IPv6 so it would force me to get to grips with it when working within the VPN. (My objective is to host a VPN to which devices (typically things like Raspberry Pi's) and "users" connect, with users having access to the devices but devices not having access to each other or anything else. No doubt this might change in future to require that some devices can access specific other services but they'd always be tied down.) Does this sound plausible? As an OpenVPN novice, is this something I should park until I know OpenVPN better? -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0344 251 1450 Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

3 4

Nextcloud Pi
by Phil Thane 17 Feb '22

17 Feb '22

Hi Folks, I think I might have asked a variation of this about this time last year but I'm better informed now with a better question! When I'm away on my canal/river boat I like to run a tracker so friends and family can see where I am. I have Phonetack on my phone and on my Nextcloud server and it works OK. What I'd like to do is embed the Phonetrack map page from the server in my Wordpress blog but that throws an error: /To protect your security, 192.168.178.20 will not allow Firefox to display the page if another site has embedded it. To see this page, you need to open it in a new window./ Opening in a new window was last year's work around but a bit clunky for my non-techie friends and family. So I looked into a bit more and there is loads of advice online about editing Nextcloud lib files, ie: /www/nextcloud/lib/public/AppFramework/Http/ContentSecurityPolicy.php/ Unfortunately my Nextcloud server doesn't anything like that as far as I can see. It doesn't even have /lib/public/ Maybe because it's actually NextcloudPi which comes preconfigured as an SD card image for the Pi. I could create the file and insert the recommended lines but would it even be read if the rest of the OS isn't expecting it? And will I bugger up something else? Any other suggestions? (But please not 'start again with a fresh install of standard Nextcloud' The Pi 'just works'.) -- Phil Thane www.pthane.co.uk Tweet @pthane 01767 449759 07582 750607

2 1