openEMR installation

Summary:
Installation went very smoothly. A couple things here and there (creating/editing php.ini) were not done, but it appears I’m functioning. This will only be for a handful of test records, and will not be an actual live/real system. Looking forward to going through the manual.

Procedure for installing openEMR

Desired Outcome: Install openEMR on my website, so I can have a good sense of EHR/EMR systems, including making changes to interface (eg forms)

Download the software to local HDD folder
Note: In my case, I chose Linux

Extracted the Tarball – double-clicking the file to expand

Created a subdomain on my web-site

Create a folder (webspace)

Linked the webspace to the subdomain

Uploaded the expanded software to the folder on website – using FileZilla
Note: Took forever — nearly 400MB upload

Ran the setup for installation – see what happens
Note: Was as simple as just going to the new website
Note: Looks like the auto-check for folder security passed

Database
Note: I selected that I already had created a database
Note: Changed Serverhost from the default of “localhost” to what IONOS wants
Note: Changed Database Name from default of “openemr” to what IONOS wants
Note: Changed Login name from default of “openemr” to the Username as defined by IONOS
Note: Entered password that I had created before
Note: Skipped two factor auth for now

Install results so far, so good:
Connecting to MySQL Server… OK.
Creating Main tables… OK
Creating Language Translation (utf8) tables… OK
Creating CVX Immunization Codes tables… OK
Writing SQL configuration… OK.
Setting version indicators… OK
Writing global configuration defaults… OK
Adding Initial User… OK

Installing and Configuring Access Controls (php-GACL)…
Note: Came back all OK

PHP Configuration recommendations
We recommend making the following changes to your PHP installation, which can normally be done by editing the php.ini configuration file:

https://www.ionos.com/help/hosting/using-php-for-web-projects/changing-php-settings-in-a-phpini-file/#c64991

https://www.open-emr.org/wiki/index.php/FAQ#What_are_the_correct_PHP_settings_.28can_be_found_in_the_php.ini_file.29.3F

Your php.ini file can be found at /etc/php7.4/php.ini
To ensure proper functioning of OpenEMR you must make sure that PHP settings include:
Setting Required value Current value
short_open_tag Off On
display_errors Off Off
register_globals Off Off
max_input_vars at least 3000 5000
max_execution_time at least 60 0
max_input_time -1 -1
post_max_size at least 30M 64M
memory_limit at least 256M -1
mysqli.allow_local_infile On Off
In order to take full advantage of the patient documents capability you must make sure that settings in php.ini file include “file_uploads = On”, that “upload_max_filesize” is appropriate for your use and that “upload_tmp_dir” is set to a correct value that will work on your system.

Configuring Apache WebServer
Note: Because of confidential patient files, there is a bunch of lines that I have to somehow enter at bottom of my Apache configuration file — wherever that is

Resolved – Error logging in to Microsoft Outlook for Mac

Got some weird message about redirect to Autodiscover-s.outlook.com – https://support.microsoft.com/en-us/help/3206915/how-to-suppress-the-office-365-autodiscover-redirect-warning-in-outloo

Then, when I tried to change password it wasn’t emailing to my backup email address.

Maybe it’s because I’m cancelling Office 365 Family for Office 365 Business Standard

This is annoying, because it won’t log in.

Able to log in to Outlook via the web portal no problem. Able to send email to outlook account AND reply — so that means the password is fine.

Q: Why is there an issue with the local Mac App of Outlook not wanting to log in. I did follow the instructions within the link above about going into terminal and flagging something as “true”

Opened local Mac version of Outlook. Closed the prompt for login password. Went into Preferences, Account. I see the default account email address correct. The authentication method is Username and password. Username is correct. Entered what I know the password to be. This is really annoying because there is no “Save” or “OK” Button.

Was able, from iPhone, to send an email to gmail and reply back — OK

Q: Why, within local Mac App for Outlook is it wanting a password?

Found this info to check re: keychain passwords — https://www.sysinfotools.com/blog/fix-outlook-mac-keeps-asking-for-credentials/

I followed all the steps within keychain access — no difference

Updated Firefox and restarted Mac

Message: OneDrive wants to use your confidential information stored in “adalcache” in your keychain. Wants me to login to the keychain password. Entered passwword and said “Always”. Notice the OneDrive icon at the topic appeared to now be OK.

Some message about Dropbox accessibility – unrelated to Outlook issues, but did that because it was nagging from before.

Yammer was running — odd because I don’t remember loading it before. Maybe it’s on an auto-connect. Quit Yammer for now.

Ran Outlook for Mac. Prompted for password. This time it accepted it. Sent a test from gmail to my Outlook account. Received and replied — all good. Now it appears that the Outlook app for Mac can log-in and send/receive mail.

Summary: Maybe it was just about restarting the Mac and also updating the Keychain re: OneDrive.

Quit Outlook for Mac and back in again — OK.

Checked Preferences, Accounts within Outlook Mac and now I see the Default account with a green blip — that’s good, as it was yellow before.

Microsoft Teams – Naming members and guests

Scenario
-Created a Team, named after a client’s name. If I work with many individuals, I would think that naming a team after the client’s name would be OK.
-Sent an invite to the client by entering their email address
-Client responds to email, creates a MS-Teams account

Issue
-Within the team, I select “Manage Team”
-I see myself in there – Firstname and Lastname and my email address
-But… the new member has – first part of email address for the name and then their email address
-Because their “Name” is the first part of email address, I somehow have to remember this when doing searches
-When going into Chat, I could only do a search of the first part of email address, because that’s technically their name
-So…..
-Q: How do I rename the user’s name after the fact?

Forum Posting
https://techcommunity.microsoft.com/t5/microsoft-teams/bd-p/MicrosoftTeams

Microsoft Teams – Upgrading from Family to Business

Current Environment
-Mac osMojave
-Office 2016 Suite of applications (Word, Excel, Outlook) on several machines
-Microsoft 365 Family (formerly 365 Home) – which I’ve had for several years now ($99.99/yr)
-Hosting of www.paulgarth.name through IONOS

Objective
-Have Outlook mail (50GB) hosted by Microsoft, so I’m not limited by local IONOS database
-Integrate Microsoft Teams for working with clients (chat, web-conference, etc)
-Have Teams interactions with each individual client – 1:1 ratio
-Publish my calendar for bookings
-Have files uploaded/downloaded to OneDrive (MP3 audios, articles, client paperwork)
-Have access to OWA for Outlook 2019 via browser
-Continued ability to have local applications (Word, Excel, etc) installed on Mac/Windows

Microsoft Teams – Free Version
-Using same email address domain I currently have with 365 Family, I created a free Teams account.
-Q: What limitation is there for free version re: number of teams?
-A: Is it 300?
-Q: When I added a member/guest,their username is their email address, which complicates lookups for chat. Can their username be renamed, or is this only with the pay version?

Microsoft Teams – pay version through Microsoft 365 Business Basic
Q: Is there a difference in the number of people total of 300?

Outlook – version and via web-browser
-Currently using Outlook 2016 for Mac locally installed
Note: I’m accessing a mail database on IONOS via IMAP
-Would like to maintain osMojave, so as to avoid any drama with upgrade to osCatalina
-Have used gmail for years via web-browser, and will continue to use
-Ideally, I have the latest version of Outlook (2019) via web-browser
-My understanding is that I would go to this URL if IONOS was hosting – https://exchange2019.ionos.com/owa/auth/logon.aspx?replaceCurrent=1&url=https%3a%2f%2fexchange2019.ionos.com%2fowa
-Q: Is Teams integrated within the web app of Outlook 2019?

Microsoft Bookings
-This feature starts with Microsoft 365 Standard and is an interface for customers to schedule and manage appointments.

Which version of Microsoft 365 to migrate to?
-Microsoft 365 Business Basic is out because it doesn’t include local applications
-Microsoft 365 Business Standard has web and mobile version; 50GB for email with your own domain name; publish calendar, share available meeting times, schedule meetings; store and share files with 1TB of OneDrive, share files with external contacts – guest links, secure down the access; host online meetings, chat with team member, integrate with MS-Teams; maximum number of users = 300.
-Microsoft 365 Business Premium appears overkill for my needs; some additional advanced security features.

Which vendor would be preferred? (Microsoft, IONOS, CDW)?
-The paulgarth.name domain is currently managed by IONOS, but I don’t use the MS-Exchange feature yet, which I believe is the purpose of Microsoft 365 Business
-Q: Is there an advantage to change to the Business plan thru IONOS?
A: You get support from IONOS – but it’s relatively limited IMO

Number to contact IONOS re: Microsoft 365 Business Standard
(866) 289-5039 (8AM to 5PM) – Eastern

Pricing comparisons of Microsoft 365 Business Standard
OK Note: I currently have Microsoft 365 Family for $99.99/yr
-Microsoft: $12.50/month; try free for a month; that works out to a recurrent $150/year (12 * $12.50)
-IONOS: 3 months free, then $14/month; for first year that’s $126 and then a recurring $168. Even though there is an additional $18 difference with IONOS, it’s maybe advantageous to consolidate with them, considering they manage my domain names.

NOTE: This URL is about “Switch from Microsoft 365 for home to a business subscription
https://support.microsoft.com/en-us/office/switch-from-microsoft-365-for-home-to-a-business-subscription-9322ffb8-a35d-4407-8ebe-ed6ea0859b9f

Procedure:
OK -Migrating the Microsoft 365 Family Account (paul@paulgarth.name) to IONOS – 365 Business Standard
NOTE: I may actually not be migrating from 365 Family, as I’m not hosting email thru Microsoft now
-On Outlook for Mac (locally installed), export everything (email, calendar, tasks, contacts) to an .OLM extension file — locally saved on Mac
-Within IONOS Portal, create a subdomain – backup.paulgarth.name
-Within IONOS Portal, Email, there are several email addresses:
–audio@paulgarth.name — click on email address link; change domain to backup.paulgarth.name
–info@paulgarth.name — click on email address link; change domain to backup.paulgarth.name
–lists@paulgarth.name — click on email address link; change domain to backup.paulgarth.name
–onsite-hypno@paulgarth.name — click on email address link; change domain to backup.paulgarth.name
–paul@paulgarth.name — click on email address link; change domain to backup.paulgarth.name
–proxyxxxxprivate-registration.com – mrpaulgarth@gmail.com — left as is
–skype-hypno@paulgarth.name — click on email address link; change domain to backup.paulgarth.name

OK -Called back into IONOS to see what next steps are. They created the new account
–Issues with trying to resolve the actual configuration
–Resolved by logging out of IONOS portal and logging back in again
–Configured for my email address and new password
–Now I can get into the portal for 365 Business Standard

OK -Downloading Office 365 – version 10.38 (latest) – 1.5GB total size
–Note: Unpacking will take 8.58GB or space – I have enough space… barely…
–Apps appear to install and run OK, except for Outlook – still pointing to IMAP
–Outlook via Web not receiving email – maybe the mx record needs updating
A: Now resolved. Mail going thru. Removed old IMAP account

-Issues to resolve via Microsoft directly)
Q: Teams app is still showing free – how to either merge or remove the free version? You have to upgrade to a new Microsoft 365 subscription. Merging Teams free into an existing Microsoft 365 paid subscription is not supported.
Q: How many teams in MS-Team can I have?
Q: In MS-Teams, if you invite based on email address, can you rename their username later?
Q: Do I have a Team for each client I have?
Q: How do I remove the old free MS-Teams account?
A: https://support.microsoft.com/en-us/office/delete-your-teams-free-organization-2c28cfcf-3fbf-497c-938f-8815a8f6a6b9
A: https://docs.microsoft.com/en-us/microsoftteams/guest-access-checklist

https://support.microsoft.com/en-us/office/switch-from-microsoft-365-for-home-to-a-business-subscription-9322ffb8-a35d-4407-8ebe-ed6ea0859b9f
Switch from MS-365 for Home to a Business Subscription

PG Forum request — Renaming members and guests in MS-Teams
https://techcommunity.microsoft.com/t5/microsoft-teams/renaming-members-and-guests/m-p/1479176

Todo:
-Review Microsoft 365 Family to copy over anything in OneDrive to the new OneDrive
-Contact Microsoft to cancel the 365 Family Account, as I now have 365 Business Standard

NOTE: Place in a different post when resolved:

-Q: Do I have a free SSL that I can use for paulgarth.name? Something about attacks.
-A: Yes. It’s included.
-Q: Is there a recurring cost for SSL?
-A: No. It’s included.

Migrating Domino baremetal to ActiveGrid (E2E)

Desired Outcome
-Create an end-to-end detailed flow of processes and configurations for Domino Migration
-This is the copy-style method, where the same Domino OS version is migrated to new hardware

ActiveGrid Configuration (OS, Drives, Drive Space, RAM, IP Address)
-ActiveGrid currently certified to Microsoft Server 2012 R2
-Disk capacity total I requested = 800GB
-Drive C = 150GB (Windows OS)
-Drive D = 350GB (Domino Apps, Installers, manual Backups)
-Drive D = 300GB (Domino Data)

Web-Browser application for connecting to ActiveGrid
-Use Safari on the Mac to make the connection
-Note: I was getting “Server Disconnected Code: 1015; Connect Timout” with Firefox

Firewall configuration on ActiveGrid
-Note: Possible to add my @Home IP address within ActiveGrid Firewall – for SSH’ing
-The well-known port for Domino is 1352
–Note: Added 0.0.0.0/0 for ANY to 1352
–Note: Added 0.0.0.0/0 for ANY to 80
–Note: Added 0.0.0.0/0 for ANY to 443
-All ports to/from ActiveGrid will be direct (with no flip-flopping)

Firewall configuration on Windows Server
-XXX –

LogMeIn Agent Installation
-Installed Agent – manually typed the URL for installer
-Connected from home via Firefox – fast!

LogMeIn for copying data from baremetal server to ActiveGrid
-Logged in from ActiveGrid to baremetal servers (from the LogMeIn Control Panel)
-Note: This is the preferred method – using the local LogMeIn Control Panel on ActiveGrid
-Note: Change time out on both baremetal and ActiveGrid Servers
–LogMein Control Panel; Options; Preferences; Advanced; Network, Idle Time Allowed
–Change to 0:03:00:00 – 3 hours (Note: Default was 1 hour)

-For making the connection between the two servers (for file copying)
–LogMein Control Panel; Connect to: (log-in to other server)
–See both servers within the File Directory
–Note: Appeared faster when initiating everything from ActiveGrid server

Windows Updates and Restart
-Routine Windows Update process and server restart

Copying over Installers
-Domino
-Fixpacks
-Java JVM (Just in case)
-McAfee Mail Security (will come back to actual installation/configuration later)

HOSTS file changes because ActiveGrid not using NAT

Current IP configuration of baremetal (LAX) is:
–Server: 10.60.60.2
–Gateway: 10.60.60.1
–Subnet: 255.255.255.0
–DNS: 8.8.8.8 and 4.2.2.2
–Note: For the system with IBM Traveler, I can request a second NIC for the “DMZ”

Copying over data for IBM Domino with baremetal server down
-Note: Approximately 1GB/minute file transfer (via LogMeIn)
-set config server_restricted=4 (within console)
-drop all (repeat until sh users shows no active users)
-tell router show q (check the router queue); repeat until no mail pending
-tell router quit
-tell adminp process new
-sh tasks (and check that adminp is idle)
-Quit Domino Server
-Change Domino Server Services to change from Automatic to Manual

-Copy over D: (baremetal) to D: (ActiveGrid) using LogMeIn
–Note: Only took about 4 minutes
-Copy over E: (baremetal) to D: (ActiveGrid) using LogMeIn
–Note: Took about 3 hours

Info on how I ensured Test Server didn’t talk outside
-Remove replicator task from servertasks= within notes.ini
-Remove router task from servertasks= within notes.ini
-Block port 1352 outbound within Windows Server Firewall
-Create alias in etc/hosts file and point it to test server IP

Changing FQDN pointer to new IP Address
Changing MXPurify pointer to new IP Address (including the port)
-Ensure the new IP address correct for server I’m migrating
-Ensure I’m using the default port this time (no flip-flopping now)

Review notes.ini within D:\Lotus\Domino
-For now, remove McAfeeAddinMgrX64 (McAfee Endpoint Security for Domino)
if needing DIOPP anymore
-Left all the ServerTasksAtX – as is
-Left all SAVMailXX – as is (I think this maybe from the old Symantec)
-Left ExistingServerName=DA-OJAI/DAC (This is odd, but leaving as is)
-TCPIP_ControllerTcpipAddress=10.60.60.2:2050
–Note: Changed this to the new static IP address
-Domain=ICA (This is odd, but from the past I remember having to leave as is for now)
-Sametime Stuff (Left as is for now)
-SAVJava=c:\Program Files\java\jre7\bin (Legacy, but left as is for now)

Run installer for Domino including Fixpack and Interim Fixpack
-Setup (During test, saw it saying, “Prepare Java JVM for Virtual Machine”
-Left “Install Partitioned Domino Server” checkbox blank
-D:\Lotus\Domino
-E:\Lotus\Domino\Data
-Domino Enterprise Server (pre-selected)
-Note: Installation took about 4 minutes

Fixpack 6 for Domino 8.5.3
-Ran the installer
-Confirmed directories
-Note: Takes about 4 to 5 minutes

Domino IF 15 for 8.5.3. FP 6
-Ran the installer
-Now going to 8.5.3.FP6 HF2880
-Note: About 1 to 2 minutes

JAVA JVM UPDATE

Notes.INI review – one more time
-OK

Quick system checks before first run
-XXX

Console check with Server down?
-XXX

First run of Domino Server on ActiveGrid

Console Check on Active Server

Trace Checks from Notes client to server on ActiveGrid