@tim_g said in Windows Server Backup and Oracle:

@dbeato said in Windows Server Backup and Oracle:

@tim_g said in Windows Server Backup and Oracle:

@dave_c said in Windows Server Backup and Oracle:

In NOARCHIVELOG mode the database must be shut down before you can back it up. I recommend you to change the database mode to ARCHIVELOG so you can perform an online backup.

There are many documents and blog posts about it, but this may help you:
https://www.veritas.com/support/en_US/article.000011425

Awesome, that looks promising.

I'm not responsible for the Oracle side of things, so I will pass this on to those in charge of that as a recommended change.

I just deal with the Windows Server / VM & hypervisor back-end of it.

But what Backup system/software are you using?

It's in the title :winking_face:

And also not really relevant. Because all backups would fail with that error unless the DB was stopped.

well done!

@dbeato said in Windows Licensing and VPS:

@scottalanmiller said in Windows Licensing and VPS:

@dbeato said in Windows Licensing and VPS:

@scottalanmiller said in Windows Licensing and VPS:

@dbeato said in Windows Licensing and VPS:

@scottalanmiller said in Windows Licensing and VPS:

@aaronstuder seems to do what? Amazon is NOT claiming to do Datacenter licensing, it is SPLA. And if you look at how tiny those instances are, they are definitely charging the normal Windows amount for them. So nothing like any of the ones that we've been questioning. It is, in fact, these Amazon numbers that make us realize how far off the other vendors are that are not charging plausible rates for Windows.

But Amazon has Datacenter on the systems through EC2 as far as I hosted Windows Servers there.

Are you sure that they are DC not SPLA?

It is SPLA https://aws.amazon.com/windows/faq/

Right, that's the key difference. Amazon uses SPLA, like Vultr does, and clearly covers the cost of it. These others, say Datacenter instead of SPLA, and don't cover the costs.

It's the combination of claiming a different license and being absurdly cheap, too cheap to pay for SPLA, that is the tip off.

What I should have clarified was that the Servers are running on Datacenter Edition regardless if they have SPLA or not using EC2.

Ah, I see. Yes, DCE vs DCL.

@matteo-nunziati said in server barebones: asrock, gigabyte, tyan, intel, chenbro. Opinions?:

@scottalanmiller I know. I always prefer postgres when available. but there is a chicken-egg problem: small companies buy software from small devel companies which - for whatever reason I don't know- develop only in .NET with MS SQL.
there is a claer trend here in Italy. Therefore you have to bump the specs for the oversized framework.

Same experience. 99% ERP for SMB are made with MS SQL. Usually they are pretty crap. Some stuff from walter kluwers is getting better, though.

@dbeato said in Active Directory account - automatic disable:

I remember this only:
https://blogs.technet.microsoft.com/makeiteasy/2012/11/23/auto-mail-expiring-domain-accounts/

http://mikefrobbins.com/2013/12/12/setting-an-active-directory-user-account-to-expire-at-a-specific-time-of-day-with-powershell/

Bummer, I had looked in both of those places.

Had to reboot, now i am getting the error. Never realized how much I have been leaning on ML for knowledge. Bring back internetz pleeze!!

@mike-davis said in Unifi Time Schedule:

Ah, maybe the best approach would be to have two SSIDs. One on a schedule and one on all the time. Then only allow devices you want to connect to the all on SSID.

This is what I have done in the past for myself and my friends/family. I setup a SSID for parents and then sometimes a SSID for each child. That way the parent can turn off the internet for one child and not bother the other children. Of course I always think that the punishment imposed by the children on other children for everyone losing internet because of the actions for one is a great way to get them to behave.

@360col said in schedule time per client not possible:

Opps this was meant as a reply to the Unifi Schedule thread. No idea why it became a separate topic 😞

Can someone fix up this or close this thread. Thanks.

Probably because you tried posting it as below:
0_1517838266493_2018-02-05_0843.png

@mattbagan said in Looking for stock of the EdgeRouter 4:

@JaredBusch ubnt has them in their store now https://store.ubnt.com/collections/routing-switching/products/edgerouter-4

I ended up purchasing from DoubleRadius.

@dbeato said in Outlook vs. Gmail - mail & calendar exporting:

@bbigford said in Outlook vs. Gmail - mail & calendar exporting:

@bbigford said in Outlook vs. Gmail - mail & calendar exporting:

Is the built in migration intended to get calendars and contacts? I would think it'd get everything since they are all technically just folders, but I've yet to have it work 100% for me so was not sure.

Fun fact after researching... it is indeed intended to grab contacts-calendars-mail, but will not grab local distribution groups if you've created them in the local Outlook client. I think they are technically stored in a separate file, but for whatever reason it is not included in the migration.

The file you need to do it manually per user. See below:
https://support.office.com/en-us/article/migrate-email-and-contacts-to-office-365-a3e3bddb-582e-4133-8670-e61b9f58627e?ui=en-US&rs=en-US&ad=US
Or use Migrationwiz

MigWiz for the win here.

@gjacobse said in Remmina VNC: Unknown Authentication scheme:

@stacksofplates said in Remmina VNC: Unknown Authentication scheme:

@gjacobse said in Remmina VNC: Unknown Authentication scheme:

@stacksofplates said in Remmina VNC: Unknown Authentication scheme:

I just wanted to chime in and say sorry you have to use VNC.

Well,.. I don't have to use VNC. But VNC is native to the rPi distro installed. I could install something like x2goserver, but even that has given me some trouble.

I’d just use X11 forwarding.

I believe this is the first time I have heard of x11 forwarding - so while I google it,.. I have no ideas about it.

I assume you have been working a lot with Windows for this not to happen 😉

@scottalanmiller said in Botnet Security Alert on Sonicwall:

@tim_g said in Botnet Security Alert on Sonicwall:

@scottalanmiller said in Botnet Security Alert on Sonicwall:

@tim_g said in Botnet Security Alert on Sonicwall:

@scottalanmiller said in Botnet Security Alert on Sonicwall:

@jaredbusch said in Botnet Security Alert on Sonicwall:

@scottalanmiller said in Botnet Security Alert on Sonicwall:

@jaredbusch said in Botnet Security Alert on Sonicwall:

@scottalanmiller said in Botnet Security Alert on Sonicwall:

@tim_g said in Botnet Security Alert on Sonicwall:

Latest news is saying a half million sized botnet is mining line to, and one of the targets are Linux SQL servers.

What's a Linux SQL server? Anything running a relational database? How do they target them?

I assumed that one meant Linux servers running MS SQL.

I had thought of that, but that seemed so unlikely.

Not really. I mean you know how good Windows people patch right?

That's true. But it seems like a worthless target. How many of these can there be yet?

Probably nothing outside of labs / testing.

Why would you run MS SQL on Linux when an MS SQL license includes an OS license?
Why would you run MS SQL on Linux when there are better options to run on Linux?

MS SQL licenses include an OS license?

Maybe not. I thought about it again and I think I got that mixed with System Center including an MS SQL license.

Ah, okay. I was really confused there. I've always priced it out with Server + SQL Server licenses and CALs. Was hoping I hadn't been adding all that in extra all this time 🙂

You were not doing it wrong.

@jaredbusch said in UptimeRobot.com:

@dbeato does.

Yes, I use it a lot for my connection monitoring.

@danp his installation is pre-service creation.

IMO time to rebuild and get current.

@mike-davis said in How MSPs provide their services:

@scottalanmiller said in How MSPs provide their services:

That's a lot of investment for a system like that. If you have hundreds of customers, it can make sense. But it takes a lot of customers to recoup the lost time into that system. It can work out well for a traditional MSP, but depends on large scale standardization to justify the investment.

I don't know about hundreds of customers. The number of end points might be more relevant. For me at about 10 MSP customers I can justify the investment. When you look at the time it takes to set up something like a zabbix server and maintaining a WSUS server vs not having to that helps make it worth it. Missed revenue because you didn't have a system in place to capture every minute hurts.

It would be a blend, I'm sure. A single customer with a million end points wouldn't make sense because you'd use more traditional tools in a single customer scenario. And a hundred with only one end point each wouldn't do it either. So some combination of enough end points for volume and enough customers for complexity put together.

@mike-davis said in Spam filtering software:

@tech1 Sometimes it helps to take a step back and evaluate what you're really trying to do instead of look for a product for what is already in place. Liquid mail claims to filter, but clearly it's not working. o365 and gmail do a great job, so why not consider them? It would probably be better to filter it before it hits the client.

And for a single user.... the cost of looking at another option is too much. Office 365 is $4/mo... that's $48/year. That's hosting, storage, support, everything. And that's a top end, luxury level service. It only gets cheaper from there.

Prerequisites for client

sudo apt-get install python3 python3-pip sudo pip3 install paho-mqtt

Python script:

#!/usr/bin/python3 #Imports import time import os import paho.mqtt.client as mqtt import paho.mqtt.publish as publish #Variable setups broker = "IP Address MQTT Broker" state_topic = "pi/cputemp" #Topic to publish commands too delay = 1 #Time delay #Fuction to return temp def measure_temp(): temp = os.popen("vcgencmd measure_temp").readline() return (temp.replace("temp=","")) #MQTT connection setup client = mqtt.Client() client.username_pw_set("username", "password") #Login for broker client.connect(broker) client.loop_start() #While loop for posting to MQTT while True: print(measure_temp()) time.sleep(1) cpu_temp = measure_temp() client.publish("pi/cputemp", str(cpu_temp)) time.sleep(delay)

@matteo-nunziati said in ERP for small manufacturer w/web integration:

While I cant say about the mrp module quality odoo can be an option as well as openbravo.

But who will support them?

That can't be a challenge. Those are well known, especially odoo, get anyone you want to support them.