@jaredbusch said in MariaDB - Remote connections from specific IP:

@fuznutz04 said in MariaDB - Remote connections from specific IP:

@scottalanmiller Well that worked, but it looks like I can connect from any IP, not just the one I specified. Digging further.....

You don't want that first rule. That opened it to everything. You only want the second.

Bingo. Thanks!

nj3PBpF.png

This is missing a few: Protected access for admin over all files & PC's, Visuals (graphs) , Easy to use interface.

Here is what I have so far for important features outside of the standard. Do you guys see anything that is more important than another?

Anything I'm missing completely?

This list is not complied by priority, however it needs to be ( my Boss asked me to make a list) so any / all input would be greatly appreciated.

@dashrender It is SA

@dave247 said in Questions about licensing issues after converting physical SQL server to virtual:

Hi. New here..

I have a Poweredge R320 running Server 2012 R2 Standard which is running Microsoft SQL Server 2008 R2 (64bit). This server has always been a bit slow with often very high disk I/O. Performance has gotten worse over time and I believe it's due to the fact that it's disks are in a RAID 5, and the SQL DB has gotten larger over the years/had more use, etc.

Anyway, I wish to virtualize this system because our storage controller is RAID 10 with much better IOPs. We have 3x ESXi hosts, each with dual sockets and better processors than the R320 server as well, but I'm really only looking to improve disk I/O. This server is running a single Xeon E5-2440 0 (6 cores) btw.

I want to convert this system from physical to virtual (using vCenter Converter) and verify that there are no issues before we pay more money for licensing, assuming we have to pay to change # of CPU and cores. If there is an issue, I can just revert and we won't be out $. I am just unclear on if SQL Server 2008 actually knows when there's a hardware change and if it will stop functioning or something, or if the system will continue on without any issues.

Thanks. Also, hi Scott.

When you use the converter, it creates a VM with the same hardware specs.
So the VM will have the same number of sockets and cores as the physical box. There is no licensing issue there.
You will have to reactivate Windows, but again, not a licensing issue, just an activation.
Prior to running the converter, run a backup and shut down the SQL services so that no database files are open just to be safe.
I have done it live with no issues, but the butt cheeks were clinched.

I was thinking about deploying applocker as I migrate toe Windows 10 Ent. Is anyone using whiteltisting, successfully? What about 3rd party application?

Another thing I was thinking about was using a plugin I've used in the past (Pretty Link) to just do it on my own website backend.

https://wordpress.org/plugins/pretty-link/

It's a bit more work than something like bit.ly, but probably better in the long run.

@dashrender Yes, you can. But you just need to have the domain added as main in Exchange and you will be all set.

@ramblingbiped said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@stacksofplates said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@scottalanmiller said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@travisdh1 said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@jaredbusch said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@wirestyle22 said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@jaredbusch said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@travisdh1 said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@scottalanmiller said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@wirestyle22 said in Fedora 26 No Space Left on Device with Plenty of Space Available:

@scottalanmiller I could've sworn there was a post here related to a reboot solving it

Someone mentioned rebooting to try to solve it. But it did not (had already done that.) It was real files causing the issue, nothing orphaned. Literally, we were making 30K files an hour or so.

Tiny files to, right?

That is not relevant except for that fact that large files would have filled drive space and likely been noticed.

How is that not relevant? more files = more inodes being used

Size of the files is not relevant.

It actually makes sense that @scottalanmiller said it was mostly directories. Files of any size will almost always run out of drive space before inodes run out in 99.9999% of situations. This is the first time I've actually heard of this happening, ever.

Only not relevant for those who actually know about inodes already. The only reason I even know about them is they got mentioned in SGI's IRIX Sysadmin courses.

The one major exception is marker files. "touch thishappened" as a file automatically and never clean up and you are using inodes without using any space. That's who you can easily learn about inode depletion. But who does that?

People writing bad scripts that use lock files and forget to remove them.

That wouldn't create enough to do this though.

If you start using configuration management tools to manage infrastructure with code you get the chance to see some of these one-off oddities in the wild a little more frequently than you'd expect. Like having Java developers not use Java's log facilities to manage log rotation, and then having a generic log rotation configuration completely bork things by delete application logs that are still being accessed by the Java application.

I got to see this issue a few dozen times a few months ago before another of our Engineers disassociated the Java applications from our generic log rotation recipe.

Rebooting was the quick fix for us prior to fixing the actual problem.

Oh wow. Everything I have is managed with Ansible ( I can't even log in to servers), however all of the devs use Oracle APEX on separate systems so they don't really touch anything on my stuff. I'm sure I'd have it much worse if I had to manage their stuff.

Seems unlikely, but hey, Microsoft keeps making chat bots that bash Microsoft. So, very possible.

@dashrender said in Shrinking many domains to few or one:

@wirestyle22 said in Shrinking many domains to few or one:

@coliver said in Shrinking many domains to few or one:

@wirestyle22 said in Shrinking many domains to few or one:

@coliver Next cloud is such a sore subject for me. Why they won't do it:

They won't spend the maximum of $15 a year on a domain for us to use for it. so I said we can just create an a-record for nc.domain.com and port forward to our Next Cloud instance. I can even do the SSL certification for free. Management says no. Why? Because the guy who runs the website doesn't know how to do that. I'll do it. No, you can't. Why? Because you can't.

It's actually infuriating

That's fine you've presented it to them and they've declined. So move on.

Yeah it's just annoying that they don't want to save themselves money. The city has so many dropboxes they are paying for right now and then ask us to come up with a solution that saves them a ton of money, but they refuse.

/rant

So the next time they are whining about drop box costs, tell them, we have a solution ready to bang out, it only costs $x and will take me 2 hours to get up and running - etc.

It's sitting on one of my hyper-v hosts, 100% ready. Only thing I need is the port forwarding and a-record. It would take 2 mins.

Maybe this earlier discussion will help.
https://www.mangolassi.it/topic/13392/import-xenserver-export-into-scale-cluster

@dustinb3403 said in OS cloud images, anyone?:

@marcinozga said in OS cloud images, anyone?:

I had a look at UNMS and the installer is just pulling Docker image. That's a lot of moving parts and getting Docker to run in LXD is a challenge already, just too many variables. There's a feature request to have standard .deb installer.

I thought @JaredBusch posted a guide to installing UNMS in a Debian 9.1 VM on the forums just the other day. . .

Edit: Yeah he did, here is the guide.

Installing Docker in VM is quite different than installing it in LXD container. Think of it as installing Docker inside Docker.

So these instructions, with Fedora 26 Minimal instead of 25, and NextCloud 12 instead of 11. Everything will likely work the same other than that.

https://mangolassi.it/topic/13573/install-nextcloud-11-03-on-fedora-25-minimal

@dashrender From what I've seen, yeah.

I am still searching as well. On Deepin right now.

0_1502063240412_DeepinScreenshot_VirtualBox_20170806194538.png

If the drafters are so valuable perhaps hiring a min wage person to sort things will pay for itself?

If you don't have 12 trays today, then the number of trays is clearly not enough. Lol

@bigbear said in Provisioning URL for FreePBX:

So the server ip http://x.x.x.x:1443 if manually entered into the phone as provisioning URL (with no auth info) would provision the phone so long as the provisioning files are there?

Yes. Here is my phone's GUI view.

0_1502058122029_d31ae28e-0e7f-4336-b472-063ef237a336-image.png

Here are the contents of the /tftpboot directory.

There are a bunch of default files and folders, I just ignore them and drop my firmware .rom files and the .cfg files right in there.

[fpbx ~]# cd /tftpboot/ [fpbx tftpboot]# ls -la total 69588 drwxr-xr-x. 7 asterisk asterisk 4096 Jul 17 20:37 . dr-xr-xr-x. 24 root root 4096 Jun 28 20:34 .. -rw-r--r-- 1 asterisk asterisk 2396 Jul 17 15:51 00156565f9bc.cfg -rw-r--r-- 1 asterisk asterisk 4300 Jul 17 15:43 00156565fb3c.cfg -rw-r--r-- 1 asterisk asterisk 4688 Oct 17 2016 0015657e26ed.cfg -rw-r--r-- 1 asterisk asterisk 2721 Jul 17 21:10 001565bdeef3.cfg -rw-r--r-- 1 asterisk asterisk 464 Jun 7 10:04 aastra.cfg -rw-r--r--. 1 asterisk asterisk 449 Jun 7 10:04 cfg0300.xml -rw-r--r-- 1 asterisk asterisk 449 Jun 7 10:04 cfg0400.xml -rw-r--r-- 1 asterisk asterisk 449 Jun 7 10:04 cfg0405.xml -rw-r--r--. 1 asterisk asterisk 449 Jun 7 10:04 cfg0500.xml -rw-r--r--. 1 asterisk asterisk 449 Jun 7 10:04 cfg0700.xml -rw-r--r-- 1 asterisk asterisk 449 Jun 7 10:04 cfg0705.xml drwxr-xr-x 3 asterisk asterisk 4096 Mar 21 16:20 digium drwxr-xr-x. 2 asterisk asterisk 4096 Jun 7 10:04 firmwaredownloads drwxr-xr-x. 4 asterisk asterisk 4096 Sep 26 2016 images -rw-r--r--. 1 asterisk asterisk 191699 Sep 26 2016 legacy_sip.cfg -rw-r--r--. 1 asterisk asterisk 362 Sep 26 2016 phonebook.xml drwxr-xr-x 4 asterisk asterisk 4096 Sep 26 2016 ringtones drwxr-xr-x 3 asterisk asterisk 4096 Jun 7 10:04 sangoma -rw-r--r-- 1 asterisk asterisk 7393488 Jul 17 15:20 T42-29.81.0.110.rom -rw-r--r-- 1 asterisk asterisk 7286992 Nov 24 2016 T42-29.81.0.20.rom -rw-r--r-- 1 asterisk asterisk 7385296 Mar 13 06:39 T42-29.81.0.70.rom -rw-r--r-- 1 asterisk asterisk 23144608 Mar 13 06:58 T46-28.81.0.70.rom -rw-r--r-- 1 asterisk asterisk 25715632 Jul 17 15:20 T4XS-66.81.0.110.rom -rw-r--r-- 1 asterisk asterisk 9949 Jul 17 15:58 y000000000028.cfg -rw-r--r-- 1 asterisk asterisk 10143 Jul 17 15:57 y000000000029.cfg -rw-r--r-- 1 asterisk asterisk 10144 Jul 17 20:17 y000000000067.cfg

@dashrender Oh yeah, that is the most annoying part. We have SSDs and still it takes 2 minutes to get the OS backup 😕

@scottalanmiller said in HPE SmartArray P420 Memory Overwritten Error:

@dashrender said in HPE SmartArray P420 Memory Overwritten Error:

From Scott's post it seemed to say the data written to the drives that allows rebuilding the array when the RAID is replaced is what is missing. If that data is gone, aren't you hosed? Unless it is backed up somewhere?

It's not the disks that are bad, it's the controller itself. It's ROM is messed up.

With luck the flashed controller will pull the array data back in.