Topics created by scottalanmiller

@brandon220 said in Show Active Users in NextCloud: Mine is on 18.0.5 via the stable channel and shows there is an update to 18.0.6 I ended up with two systems that will not upgrade path 17 all the rest of them are upgraded 18 on the stable channel

@JaredBusch said in Odd Reboot Command in DNF-Automatic Discovered: @scottalanmiller said in Odd Reboot Command in DNF-Automatic Discovered: ExecStartPost The file dates are the same across multiple systems. June 2 and March 31, and that text is not found Yeah. We have never seen it before.

I did some experimenting... but it's not always the case, it depends on what you are doing. But doing this with simple counting results: And for fun lol....

@Pete-S said in How to Connect Power Disable SATA Drive to Dell Inspiron 5676: @pmoncho said in How to Connect Power Disable SATA Drive to Dell Inspiron 5676: @JaredBusch said in How to Connect Power Disable SATA Drive to Dell Inspiron 5676: @scottalanmiller said in How to Connect Power Disable SATA Drive to Dell Inspiron 5676: @pmoncho said in How to Connect Power Disable SATA Drive to Dell Inspiron 5676: @scottalanmiller said in How to Connect Power Disable SATA Drive to Dell Inspiron 5676: @Pete-S said in How to Connect Power Disable SATA Drive to Dell Inspiron 5676: @scottalanmiller said in How to Connect Power Disable SATA Drive to Dell Inspiron 5676: Confirmed, snipping the orange wire (I needed help as I can't see orange) did the job, drive showed up immediately. Congrats! I wasn't sure you'd be up for the task. A lot of people are afraid to make permanent changes to their equipment. You can't believe how much pushback I got from @Dominica and @pchiodo about snipping a simple cable on a $2 SATA extension part! For me, it was a no brainer once knowing what it was. But they were up for spending hundreds of dollars to avoid snipping that wire. And it isn't even hard wired to the power supply or anything it's literally just a SATA extension piece! lol Like $2 tops if you don't shop around. I would have been with @Dominica and @pchiodo on this. Electric scares me. I would think snipping the wire would cause a spark while I wasn't home and come home to a few burning cinders. That was mentioned as a concern. lol FFS people need to just STFU if they don’t know how electricity works. That was exactly my point and why I wouldn't have done it. As for STFU about well, that is where we differ. Those concerns could be alleviated with an explanation of why it would not be an issue. For electrons to flow you need a circuit. If you cut the wire you don't have a circuit anymore and because of that you don't have any electricity flowing. Since there is no electricity, there can't be any sparks. If you just cut the wire but don't remove it, then one end can come in contact with the chassis and then you have a circuit and electricity flowing. Modern switched power supplies (as in your computer) have short-circuit protection. So nothing would happen except that 3.3V will go down to 0V. So if there is anything in your computer that need 3.3V power from the power supply, it will not get it. If you had something else producing 3.3V (for instance a battery) and you'd short-circuit that, then it can get cause a fire. Just because it's only 3.3V doesn't mean anything. And sparks is not a problem unless you're in an explosive environment. The problem is that a short-circuit cause increased current running in the wire. That current will turn into heat. That heat causes things to melt and catch fire. And that's how you burn down a house. Also nice to know is that any electrical circuit inside a computer is low voltage, 12V or below. It can't kill you no matter what you do. It's the same voltage as you have in an ordinary car battery. The only way to get into trouble with a computer is by disassembling the power supply. There you have lethal voltage. Thank you for the explanation. Very helpful.

@Obsolesce said in Apple Mac Going to ARM RISC: @scottalanmiller said in Apple Mac Going to ARM RISC: RISC-V is seen as the future with more modern and more open design than ARM and zero security risks like ARM has. ARM is so risky, I'd never risk (pun intended) developing something new with it, only something old. Oh yeah, forgot about that! Still very low end devices, but moving up fast. I'm really excited to see the first SBCs and desktops built off of it.

@scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?: Trust me, we tried to go Linux. But it just didn't work out.

@scottalanmiller said in Recovering SQL Server 2005 Databases: We got a 2008 R2 that we tracked down. And they were able to get backup files rather than the original database files only, so looking like it will be much easier. Good news, much less pain than having to deal with mounting on 2005 and then backup/restore to current.

the dd command is so useful

@scottalanmiller said in Engineering vs Administration - That's what makes Windows and FreeNAS so risky: @stacksofplates said in Engineering vs Administration - That's what makes Windows and FreeNAS so risky: @scottalanmiller said in Engineering vs Administration - That's what makes Windows and FreeNAS so risky: @stacksofplates said in Engineering vs Administration - That's what makes Windows and FreeNAS so risky: @scottalanmiller said in Engineering vs Administration - That's what makes Windows and FreeNAS so risky: @IRJ said in Engineering vs Administration - That's what makes Windows and FreeNAS so risky: @scottalanmiller said in Engineering vs Administration - That's what makes Windows and FreeNAS so risky: @IRJ said in Engineering vs Administration - That's what makes Windows and FreeNAS so risky: Admin roles are also dying with immutable infrastructure and HA. Designing a system that is immutable and highly available isn't expensive or time consuming on the cloud anymore. But someone is still designing the initial system and someone (maybe the same person) is managing it. Yeah so you don't have an admin here as you admit. You have an engineer designing the system and replacing the system if there is issues. It's all design and no maintenance. Maintenance is automated during build. Not in the real world. That's a nice theory, but applies to effectively no one anywhere. In the real world, engineering almost always is a trivial effort that involves almost no time, skill or planning, and all the effort goes into years of administration that deals with that haphazard system. That's completely false. Engineering is almost always a trivial effort...... It's completely true and I've given example after example. In the real world, engineering is generally done without planning or resources and it works enough for people to accept it. Then all the effort is hoisted onto administration. You can argue, but you can't deny that this is what 95%+ of the market does. No you gave an example of FreeNAS and have completely ignored things like SRE where design upfront including architecture, engineering, coffee design, IaC, etc are all roles for the engineer. Immutability is vital and SREs are embedded in specific teams and only supporting that application. Yes, but the difference is my example represents nearly the entire market. I didn't say that there weren't exceptions. But that's what they are. Outside of F500 maybe but outside of F500 you don't normally have systems engineers and systems admins.

Also a bit hesitant to say I really know it but have experience. Mostly managing Android devices.

@dbeato said in Access Changed Files on VSS Copy on Write Disk Image: @scottalanmiller said in Access Changed Files on VSS Copy on Write Disk Image: @black3dynamite said in Access Changed Files on VSS Copy on Write Disk Image: Mount the disk image on Windows Server instance, from the mounted disk drive, go to Properties and then Previous Versions? That's what I thought. But it just seemed too easy, lol. Lol, anything that appears with Microsoft as easy should work but emphasis on "should" Emphasis with "assume" too. lol

I followed this instruction: https://serverfault.com/questions/843212/existing-kvm-vm-to-proxmox-ve

To do that.... Edit... sudo vi /etc/libvirt/qemu.conf And set... user = "root" group = "root" And then... sudo systemctl restart libvirtd

@JasGot said in VitalPBX / Asterisk Limit Calls Then Go To Voicemail: @scottalanmiller said in VitalPBX / Asterisk Limit Calls Then Go To Voicemail: We can't limit in Skyetel, or the calls won't make it to the voicemail. My first thought would be to route calls (when their are 4 current calls) to a specific DiD that goes right to VM. Are you working with Skyetel with custom programming or are you limited to their web portal options? Not sure what we'd have them do to fix the issue.

While awaiting another episode, feel free to follow on Instagram, too... https://www.instagram.com/takeflightwithscott/

@Dashrender said in Microsoft Licensing Verification Program: Is this a SAM Audit?: @scottalanmiller said in Microsoft Licensing Verification Program: Is this a SAM Audit?: Just got a customer with this Microsoft Licensing Verification Program / MLVP audit request. It sure looks like a SAM Audit. It comes from one of those "not really Microsoft" v- email addresses that are third party scammers traditionally paying MS for an email address. They never say that the audit is a SAM or voluntary, but the terms that they use and the email address don't match anything legit and look just like the scams that MS has been in on for years. Anyone seen this new terminology yet? Is this the new name now that MS customers have caught on to the SAM scam and now need a new name so that it isn't so obvious? Interesting - I don't recall seeing the word voluntary on any SAM letter I ever got. I used to see them, but looks like it's not required in the form.

@Seb1982 said in Ubuntu 20.04 Desktop Lag: My Dell XPS 13 lags after upgrading to 20.04. All graphics are fine, but the system simply does not respond quickly enough. Sometimes all is fine, but often the pointer is about half a second behind, so is typing. And, I assume, it was snappy under the previous version? Since the initial issues, mine has stayed responsive.

If you install using the above method, it never tells you the random password assigned to your management interface. But no fear, there is a tool that sets that for you and is super, duper easy. cd /usr/local/lsws/admin/misc sh admpass.sh It is interactive. And voila.

Zabbix has the ability to monitor HAProxy as well. https://www.zabbix.com/integrations/haproxy

Date/Time issue?

@scottalanmiller said in Mattermost Behind Nginx and Cloudflare Script Load Error: @Pete-S said in Mattermost Behind Nginx and Cloudflare Script Load Error: @scottalanmiller said in Mattermost Behind Nginx and Cloudflare Script Load Error: @black3dynamite said in Mattermost Behind Nginx and Cloudflare Script Load Error: s your setup is Cloudflare proxy -> Nginx proxy -> apache (mattermost)? CF Proxy > Nginx Proxy > Mattermost (MM is its own server) And yes, if I disable the CF Proxy, it works. Why the double reverse proxies? That's the standard. You are always expected to have your node.js servers behind a reverse proxy. And CloudFlare is the CDN cache in front. This is the universal standard for all web servers. Plenty of times to avoid it, of course, but this is the baseline system design. In this case, MM is a raw node server so has none of the protections or handling of a system like Nginx. Nginx also provides the ability to have multiple sites behind one IP address. MM doesn't do that on its own, nor does CloudFlare. No different than how MangoLassi is on NodeBB, also a node platform, behind Nginx, behind CloudFlare. CF can't do the details port and IP handling, Nginx can't do the globally distributed cache. Thanks for the clarification Scott. I (wrongly) thought that Cloudflare was a full featured proxy and could do the same job as haproxy, nginx etc.

The virtualization... do we only count hypervisors, or do we count the VMs? Or only the VMs? My desktop has full VMs that are used as if they are completely separate machines. How do we count them? How do we count VDI, Terminal Servers, Thin Clients, etc?

I've seen that a lot. When I import Drupal databases, I learnt to use its Backup and Migrate module instead, it works flawlessly. Downside is you need to do clean Drupal installation first, but that basically is just creating blank database and putting brick on enter key.

@Dashrender said in Compare Azure to Windows On Prem for Normal Business Workloads: @Pete-S said in Compare Azure to Windows On Prem for Normal Business Workloads: @scottalanmiller said in Compare Azure to Windows On Prem for Normal Business Workloads: @Dashrender said in Compare Azure to Windows On Prem for Normal Business Workloads: Hosting Costs 1U Colocation America, /24 IP Range Monthly cost: ~$250/month Yearly cost: 12 x 250 = $3000 5 year cost: 5 x $3000 = $15K Last I looked, 1U was more like $225 with that many IPs. And I think typically you'd get fewer for a lot less cost and/or go IPv6. /24 is two IPs per VM. No need to pay for that. Yes, the basic 1U was $100 with two power outlets and then you get four usable IPv4s. A smaller server, say 16c EPYC, 128GB RAM, 2x500GB SSD, would be about $3500 and something even smaller, like a 8c Xeon @ 3.7Ghz, 64GB RAM, 2x500GB SSD around $2K. So you could scale down everything substantially if you wanted. But if all you are doing is running a few very small workloads then a couple of $5 Vultr VM would be cheaper. another factor is - are you running windows VMs, likely always cheaper to have your own hardware, but yeah, the amount of workloads definitely plays a factor here. That's true, Windows workloads make cloud computing harder to justify. Not much, but a little.

@Pete-S said in How to Rename a Column in SQLite Database: There used to be a lot of databases like SQLite. Often called database engines. dBase was probably one of the first. Later Microsoft Jet engine (aka Microsoft Access) became popular when Visual Basic ruled the world. Basically it's a one user database. You can have more than one user but it's done by multiple users accessing the same database file. Or by having an application on top that accessing the file and shares it out. That thing can be called a "database management system" or any application, really. All databases use database engines. MySQL, for example, isn't a database. It's a database management system. It uses one or more database engines to talk to the files on disk. MyISAM and InnoDB are two database engine options for the MySQL platform. At the end of the day, all databases work like SQlite. You can easily build your own database management system that uses SQlite as the engine and it could work just like MySQL or Oracle or SQL Server. Those are all single users to a file, under the hood. They just have the "multi-access" management built into an extra layer, instead of letting an application handle it. But for most things, you only access a database from a single app anyway, so that extra layer is often unnecessary as it is redundant. Just adds overhead.