Posts made by Pete.S

@JaredBusch said in Dropping a black box on a client network:

A Dell R230 on Xbyte shows $599 to start.

"To start"...in that case it's without CPU, memory or disk. So it's a server that does not start.

Get a new one instead from Dell. Dell R240, 8GB ECC RAM, Dual-core G4900 CPU, 1TB disk. $709 ready to go on dell.com

G4900 is latest gen CPU, more than you need. To step up to 4 cores it's $176 to get a Xeon E-series CPU in the same machine.

Supermicro is never going to be a cheap as Dell or HP low end models so there's no point even looking at it.

PS. Also you get 1 year basic HW warranty on site in that price but you could extend to 3 year for $100 or whatever the customer wants.

If you put cpanel on a server - not saying you should - but don't you get a complete mail setup with dovecot, postfix, spamassasin and the whole shebang? And then set it to relay smtp through mailgun.

Isn't that what all those website and email providers do? Or are they each running custom configs?

@scottalanmiller Try with another separator instead of dash, just to make check if it's the dash or something else. Maybe just remove it altogether.

@scottalanmiller Isn't it simply a case of Facebook stripping everything after the dash so "MySite - Stuff About My Site" turns into "MySite". It's common to use dash to separate page and subpage title so it makes sense for them to strip everything after the dash.

@scottalanmiller said in Building a Mail Server:

MailGun

Is that the same type of service as Sendgrid? Do you send all outgoing mail through it?

@wrx7m said in Connecting to 1 Site With Separate Logins/Several IPs:

Aside from security, another concern is that that list seems to be pretty dynamic with which servers are available. Managing 4 shortcuts for everyone with hardcoded links would be a nightmare to update.

You mean "pretty dynamic" being the same as "totally freakin unreliable", with unknown uptime, unknown bandwidth, used by spammers and who-knows-what?

That's why I said VPN service, like nordvpn. Which in this scenario is exactly the same thing as a proxy.

Or set up your own proxy servers somewhere in the cloud.

@Dashrender said in Connecting to 1 Site With Separate Logins/Several IPs:

@wrx7m said in Connecting to 1 Site With Separate Logins/Several IPs:

@Dashrender said in Connecting to 1 Site With Separate Logins/Several IPs:

@wrx7m said in Connecting to 1 Site With Separate Logins/Several IPs:

@JaredBusch

@JaredBusch said in Connecting to 1 Site With Separate Logins/Several IPs:

about 10 seconds on google gave me this.....

1. Setup 4 proxy servers to route traffic via the needed IP addresses.
2. Launch chrome in porn mode specifying the proxy and user folder.

# Proxy 1
%pathtochrome%\chrome.exe --incognito --proxy-server="http://proxy01.domain.local:3128" --user-data-dir="%LOCALAPPDATA%\Google\ChromeProxy01\User Data
# Proxy 2
%pathtochrome%\chrome.exe --incognito --proxy-server="http://proxy02.domain.local:3128" --user-data-dir="%LOCALAPPDATA%\Google\ChromeProxy02\User Data
# Proxy 3
%pathtochrome%\chrome.exe --incognito --proxy-server="http://proxy03.domain.local:3128" --user-data-dir="%LOCALAPPDATA%\Google\ChromeProxy03\User Data
# Proxy 4
%pathtochrome%\chrome.exe --incognito --proxy-server="http://proxy04.domain.local:3128" --user-data-dir="%LOCALAPPDATA%\Google\ChromeProxy04\User Data

This might work, but I would have to set up the proxies, externally, for contractors.

use open proxies on the internet, unless you want to/need to manage them yourself.

Something like this? https://www.proxynova.com/proxy-server-list/

Bingo.

Open proxies? WTF...is this a practical joke?

Sorry, I should have explained more clearly what I'm try to accomplish.

I want to screen to blank, which is what causes the screen to go into power saving mode. Not just setting it to a black color.

Blanking is tech speak for when the graphics adapter would turn of either one or both of the horizontal and vertical sync signals and thereby communicate to the display that the screen is not in use and it can go into one of it's power saving modes.

Lock windows computer =>> screen goes into power save mode right away.
Computer don't go into sleep until it does so by it's normal settings.

This is a Windows question - is it possible to set the screen to blank (aka sleep) when you lock windows (win-L or other way)?

@scottalanmiller @DustinB3403
So if you make a backup to something like Backblaze. Would that be considered an offline backup?

@DustinB3403 But isn't then a tape library the only practical offline backup solution? And if you had the credentials to that, you could erase the tapes anyway.

Maybe it was a disgruntled former (or current) employee.

Anyway, what do you guys mean with offline backups?
Do you mean backups that are stored somewhere not connected to the net, like backup tapes in safe?

For instance, in DBMS world "offline backup" is something completely different.

A lot of people I know, including myself, use desks where you can stand or sit. I can't stand standing all day and I'd say most people with desks that can do both, spend the larger part of the day sitting.

I don't see what the problem here is. Just order a vpn account somewhere, nordvpn for instance, and let the users use those. Then they will all have different IP addresses and it's not going to be their own. I think most vpn account supports more than one device.

Or if you want to do this from your LAN, you'll just order the vpn account and set up 4 openvpn links in your firewall and set up some rules on which ones to route through based on the LAN IP or whatever.

@JaredBusch said in Convert Asterisk dial plan for use in FreePBX:

@Pete-S said in Convert Asterisk dial plan for use in FreePBX:

@JaredBusch said in Convert Asterisk dial plan for use in FreePBX:

• The id field is an auto-increment.
  • This leans me to overriding that during the mass import. Opinions appreciated.

Just omit the id field completely when you insert rows and it will handle itself.

Except I have to know it to use it in the ivr_entries. Yes it could be requeried, but why? I can simply specify it as I parse down the dialplan.
Turning of identity insert is a trivial and common task when importing/migrating like this.

The purpose of turning it off is only when you want to make sure you have the same id. Maybe the id is referring to a filename or something like that and you are importing into empty tables. Otherwise it is bad practice.

Good practice is to use SELECT LAST_INSERT_ID(); after insert (if you need the number) and let mysql handle the autoincrement. Then you can be certain you are not trying to insert the same id as has already been used.

@scottalanmiller said in Print to CSV:

@Pete-S said in Print to CSV:

@scottalanmiller said in Print to CSV:

@CCWTech said in Print to CSV:

From what I can tell the program we are using has a built in integration for Excel but you have to have Excel and not something like Libre Office.

Likely using the Excel automation API that is unique.

Not impossible but not likely. Especially not if it's software that runs on a server of some kind.

"Integration" in order of complexity (I probably forgot some):

• Files that Excel can open (csv files, html tables etc)

Yeah, but keep in mind it's opening Excel in order to make the CSV, so it's not CSV that it is passing to Excel. And it isn't just opening Excel, but operating it, too. So it needs something to automate the tasks.

Yeah, it's the excel com objects. But normally you would run those hidden without actually invoking the gui.

@scottalanmiller said in Print to CSV:

@Dashrender said in Print to CSV:

@scottalanmiller said in Print to CSV:

@Dashrender said in Print to CSV:

@scottalanmiller said in Print to CSV:

@CCWTech said in Print to CSV:

From what I can tell the program we are using has a built in integration for Excel but you have to have Excel and not something like Libre Office.

Likely using the Excel automation API that is unique.

I spaced this one.

I was thinking the application could be lame and trying to call the excel.exe executable directly. That could be solved with a link to LibreOffice executable - assuming the LibreOffice executable accepts the same arguments.

In theory, yes. But I think it is using an API to make it output to CSV. Otherwise, we'd just expect it to open the file and sit there.

I assume then that using the API is easier than the application simply outputing to CSV on it's own?

I doubt it.

It's harder, but it all depends. I've done software projects with MS Office automation (aka com objects). It's not the smartest way to do things but sometimes the only way (very seldom for Excel though).

@scottalanmiller said in Print to CSV:

@CCWTech said in Print to CSV:

From what I can tell the program we are using has a built in integration for Excel but you have to have Excel and not something like Libre Office.

Likely using the Excel automation API that is unique.

Not impossible but not likely. Especially not if it's software that runs on a server of some kind.

"Integration" in order of complexity (I probably forgot some):

• Files that Excel can open (csv files, html tables etc)
• Simple Excel files, xls or xlsx
• Excel files containing macros
• Excel files with database links, web queries and/or programming
• Excel add-ins (extends Excels functionality)
• Excel automation (Excel is remotely controlled by another application)

Only the two first are likely to be more or less openoffice compatible.

@IRJ said in Print to CSV:

@Pete-S said in Print to CSV:

@CCWTech said in Print to CSV:

From what I can tell the program we are using has a built in integration for Excel but you have to have Excel and not something like Libre Office.

Depends on what "integration" is.

It might spit everything out in a single cell or split every word or something. There's almost no chance it will split the file as desired

Again, it depends on what "integration" is. There are many ways to integrate something. It can be a common file format, it can be macros, it can be database queries etc etc.

@CCWTech said in Print to CSV:

From what I can tell the program we are using has a built in integration for Excel but you have to have Excel and not something like Libre Office.

Depends on what "integration" is.

csv are text files that will look something like this:

Year,Make,Model,Description,Price
1997,"Ford","E350","ac, abs, moon",3000.00
1999,"Chevy","Extended Edition","",4900.00
1999,"Chevy","Venture Extended Edition, Very Large","",5000.00
1996,"Jeep","Grand Cherokee","MUST SELL! air, moon roof, loaded",4799.00

@JaredBusch said in Convert Asterisk dial plan for use in FreePBX:

• The id field is an auto-increment.
  • This leans me to overriding that during the mass import. Opinions appreciated.

Just omit the id field completely when you insert rows and it will handle itself.

Trying to get back into a switch after locking myself out with some erroneous vlan config. Hooked up to the console port now.

I'll just want to confirm that I will go with one pool for production and one pool for development and benchmarking.

Citrix recommendation for Xenserver is to have production & development hosts in separate pools and it makes sense just from avoiding avoiding human mistakes as well.

Also all the hosts in the pool share the same network config so it also makes sense to have development in it's own pool in case one want to test something out.

Ideally, I'd have one set of switches for each pool as well, but I'll have to settle for different vlans for now - for budgetary reasons.

@DustinB3403 said in How to Install Desktop Environment to a Fedora Server:

@Pete-S I was the person to mention creating a desktop environment on the system to use as the management domain, and run virt-manager there. And I've repeated it numerous times, across several topics.

As for using virsh, that is an option too.

Sorry, I didn't follow the other previous thread(s).

@DustinB3403 said in How to Install Desktop Environment to a Fedora Server:

While this is an option, this isn't what he is wanting to learn to use. His goal is to setup KVM and learn it, and how to administer KVM.

While I would generally agree XCP-ng is a great option for a lot of people it's not doing @hobbit666 anything to learn the same things he's already done.

The simple solution here would be for @hobbit666 to create a Fedora Workstation VM on his KVM hypervisor (through cockpit or the CLI) and use Virt-Viewer to access this VM.

From this VM, use Virt-Manager to manage the Hypervisor.

If one wants to learn it makes sense to install a lightweight desktop environment on the server, like xfce, and run virt-manager there, just like SAM mentioned. The "cost" in memory/cpu/storage of doing that is minimal. For sure less than installing another VM. And if he decides later that he doesn't need it, he can just uninstall it.

For learning, it makes sense to try all management options. He should try administering with virsh too.

@hobbit666 Not what you asked for but if you are running predominantly Windows in your environment, I'd use xcp-ng on the server and run xcp-ng center from whatever windows computer you have.

As a tool, it's a lot more refined and capable than virt-manager. But only for windows.

@black3dynamite said in Pros and cons running local repository (for packages like deb, rpm etc)?:

@Pete-S said in Pros and cons running local repository (for packages like deb, rpm etc)?:

Cons would be storage space - amd64 repository for debian stable is around 60 GB.

According to the information in this link, which is updated daily, amd64 is 330 GB.
https://www.debian.org/mirror/size

It's because that includes everything like testing, unstable, experimental and what not. Also source code. So it's a couple of different versions of the OS.

The amd64 stable main contrib non-free are 60.1 GB today - as of right now...

@scottalanmiller said in KVM USB Wake Issues:

Assuming you mean the old KVM (keyboard switch) not KVM the virtualization, that's not something I've used since 2003 or so, and even then it was on legacy 1990s gear. Always used built in OOB management since right around 2001.

So that's the story on how you became a java expert

I've never seen that problem and I've used plenty of KVMs.

Does it work the way it should without the KVM switch in between? Then I think your KVMs are probably sh*te.