Author:
erics, Posted on Thursday, March 17th, 2022 at 9:55:22am
When I sent email from my desktop Mac cron jobs, it went out with the full hostname as the domain, i.e.: root@demo.wyzaerd.com, when all I wanted was a simple root@wyzaerd.com for ease of deliverability and domain maint.
Edit the mail configuration file main.cf:
Add/edit the myorigin value of $mydomain:
Categories: How-To's, Technology Tags: Change, Domain, Email, Hostname, MacOS, mail, main.cf, Masquerade, mydomain, myorigin, PostFix | 
No comments
Author:
erics, Posted on Wednesday, March 16th, 2022 at 2:39:07pm
Had an old server, needed to get root.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
service mysql stop ~OR~ service mysqld stop cd /etc/init.d; ./mysql<tab> start --skip-grant-tables mysql> update mysql.user set Password=PASSWORD('secret') where user='root'; mysql> flush privileges; mysql> ^D service mysql stop service mysql start ~OR~ service mysqld stop service mysqld start |
For MySQL 5.7:
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
For some other v5.7 nodes, I had admin access via a different user’s login, so all I needed was this:
|
|
ALTER USER 'root'@'localhost' IDENTIFIED BY 'secret'; ALTER USER 'root'@'%' IDENTIFIED BY 'secret'; |
Categories: How-To's, Technology Tags: 5.5, Flush, Grant, init.d, Lost, mysql, MySQL 5.5, Password, privileges, recover, Recovery, Reset, root, service, Skip, skip-grant-tables, Tables, User | No comments
Author:
erics, Posted on Wednesday, March 16th, 2022 at 12:19:54pm
Situation: Newbie mistake, used copy-and-paste to create a script that used variables with the incorrect variable name, then ran chown -R / OUCH
Resolution: Since I had aa clone host nearby, I decided to export the remote root fs via NFS, mount it on the fouled nnode, and use find magic to repair.
Here are the steps:
Bad host is nodeB, and good host is nodeG ;-}
Step 1. On nodeG, prepare NFS:
|
|
sudo -i service nfs start rpcinfo -p vi /etc/exports / *(ro,sync,no_root_squash) exportfs -a exportfs |
Step 2. On nodeB, mount the resource from nodeG and use it to set the ownership locally on nodeB via find -exec chown:
|
|
sudo -i mkdir -p /volumes/nodeG/ mount nodeG:/ /volumes/nodeG/ mount find / -mount -exec chown -v --reference='/volumes/nodeG{}' '{}' \; |
Categories: How-To's, Technology Tags: chown, exportfs, Find, howto, mount, nfs, rpcinfo, service, sudo, tips | No comments
Author:
erics, Posted on Wednesday, February 23rd, 2022 at 2:56:59pm
Try a newer browser before anything else!
I was using an older version of Safari on Mac and got this:
|
|
If you're seeing this Grafana has failed to load its application files 1. This could be caused by your reverse proxy settings. 2. If you host grafana under subpath make sure your grafana.ini root_url setting includes subpath. If not using a reverse proxy make sure to set serve_from_sub_path to true. 3. If you have a local dev build make sure you build frontend using: yarn start, yarn start:hot, or yarn build 4. Sometimes restarting grafana-server can help 5. Check if you are using a non-supported browser. For more information, refer to the list of supported browsers. |
I switched to the latest version of FireFox and was fine.
Categories: How-To's, Technology Tags: Browser, Error, Failed, Failed to Load, Firefox, Grafana, howto, Safari, tips | No comments
Author:
erics, Posted on Saturday, February 19th, 2022 at 9:58:30am
I went to perform a yum update
|
|
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package. Check that the correct key URLs are configured for this repository. Failing package is: mysql-community-server-5.7.37-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql |
SOLUTION: Import the needed new key and manually edit the config files before retrying the yum update.
|
|
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 |
I had to edit two files: mysql-community-source.repo and mysql-community.repo
For 5.7 – add -2022 to the key name: i.e.:
ORIGINAL:
|
|
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql |
MODIFY ONE LINE IN EACH FILE FOR 5.7:
|
|
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022 |
Then re-run yum update.
Categories: How-To's, Technology Tags: GPG, GPG Key, key, mysql, Yum, yum update | 2 comments
Author:
erics, Posted on Wednesday, January 26th, 2022 at 1:53:30pm
If you are asked “Are you sure you want to continue connecting (yes/no)?” when trying to connect via SSH, then the remote host’s identification key has not yet been stored in your ~/.ssh/known_hosts file.
This then requires you to type the full string “yes” in order to proceed because the default value for ssh is StrictHostKeyChecking=ask.
To bypass this behavior (not recommended), you may add the -o StrictHostKeyChecking=no option to the command-line, for example:
BEFORE
|
|
myHost$ ssh demohost The authenticity of host 'demohost (10.2.2.11)' can't be established. ECDSA key fingerprint is SHA256:6KdaBv7v4+aIh1yCegIMjSFQzIqZm+LlK3Livs34OOA. Are you sure you want to continue connecting (yes/no)? <strong>yes</strong> Warning: Permanently added 'demohost' (ECDSA) to the list of known hosts. |
AFTER
|
|
myHost$ ssh -o StrictHostKeyChecking=no demohost Warning: Permanently added 'demohost' (ECDSA) to the list of known hosts. |
Categories: How-To's, Technology Tags: ask, Check, Checking, Host, howto, interactive, key, known_hosts, prompt, ssh, Strict, StrictHostKeyChecking, tips | No comments
Author:
erics, Posted on Monday, January 17th, 2022 at 3:08:39am
This is the third post in a short series about Tungsten Clustering topologies. In this post we will highlight the key differences between Composite Active/Passive, Composite Active/Active (CAA), and the newly available Dynamic Active/Active topology. In short, DAA blends the simplicity of CAP with the automated continuous operations of CAA.
Categories: Uncategorized Tags: | Comments Off on De-Mystifying Tungsten Cluster Topologies, Part 3: CAP vs. CAA vs. DAA
Author:
erics, Posted on Thursday, January 6th, 2022 at 4:04:58pm
In this short post we will highlight the key differences between Multi-Site Active/Active (MSAA) and Composite Active/Active (CAA) topologies. The core principle behind an active/active topology is that you have more than one writable cluster. So why do we have more than one type of Active/Active topology?
Categories: Uncategorized Tags: | Comments Off on De-Mystifying Tungsten Cluster Topologies, Part 2: CAA vs. MSAA
Author:
erics, Posted on Tuesday, December 28th, 2021 at 4:14:03am
As system administrators, we are called upon to be responsible for a vast quantity of discrete subsystems, each with its own set of operating rules. When starting and stopping any subsystem, it is the best practice to do so gracefully whenever possible to ensure data integrity. In this blog post, we detail the best practices for stopping and starting a Tungsten Cluster.
Categories: Uncategorized Tags: | Comments Off on How To Gracefully Stop and Start Tungsten Clusters
Author:
erics, Posted on Friday, December 10th, 2021 at 12:41:09pm
I use the httpful library from https://phphttpclient.com
The website has not defined the Httpful\Response keys anyplace easy to find, so I have documented them here:
|
|
body raw_body headers raw_headers request code content_type parent_type charset meta_data is_mime_vendor_specific is_mime_personal |
Categories: How-To's, Technology Tags: Body, Code, httpful, Httpful Response, Httpful\Response, Object, php, Response | No comments
