Postfix is a free and open-source mail transfer agent (MTA) that routes and delivers electronic mail. PostfixAdmin is a web-based management tool created for Postfix. It is a PHP based application that handles Postfix Style Virtual Domains and Users that are stored in a database.
I have this PostFixAdmin install that leads to a blank page after login. A peek at the web server error log identified the problem:
Got error 'PHP message: Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'superadmin' in...
I fixed it. Then I encountered another blank page. Another peek at the web server:
Got error 'PHP message: Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_expiry' in...
It appears that during an upgrade from an older version, the database portion of the upgrade got botched somehow. So the fix was to get into the SQL console and manually run the following updates:
ALTER TABLE admin ADD COLUMN superadmin bool after password;
ALTER TABLE mailbox ADD COLUMN password_expiry TIMESTAMP DEFAULT now() not null;
ALTER TABLE domain ADD COLUMN password_expiry int DEFAULT 0;
And that was it. Simple but might help someone.
Just learned that Ken Block of Gymkhana fame passed away due to a snow mobile accident last January 2. I first encountered him when I watched Gymkhana 3 at a DC Shoes in Eastwood a long time ago. I stopped watching after Gymkhana 4 but he and his driving panache definitely left a lasting impression.
One of the good things that came out of this pandemic is an increased awareness of mental health. One of the few things I picked up on during this time is the concept of gaslighting.
Gaslighting is when one person unintentionally or intentionally misleads another, creating a false narrative and making them question the validity of their own thoughts, perception of reality, or memories and typically leads to confusion, loss of confidence and self-esteem, even uncertainty of one’s emotional or mental stability.
No two people remember an event in exactly the same way. Everyone may have different memories of the same event. Gaslighting can happen when you challenge, question, or discredit another’s memories based solely on your perspective, on your say so.
This can happen between parents and kids. The parent has a view of what happened, the kid has a different story. The parent would insist that their version is the way it happened. And because of the parent/authority relationship, the kid ends up believing it even if it really wasn’t so. Unfortunately, this is very damaging to the child’s mental health.
To avoid unintentionally gaslighting, you should not insist on your perspective of an event if there is no empirical evidence or record of how it transpired. Rather, respect each others’ perspectives, agree to disagree, or at least give it the benefit of the doubt. Even if, or especially if, you’re talking to a child.
Earlier my wife had an impulse to visit her mom. Which prompted me to share about a friend recently losing her mom. It was also my way of supporting and encouraging her to visit. Life is short. My wife then asked our youngest if she wanted to come along. She was reluctant so, to encourage her, I told her about my grandfather who passed away when I was in Grade 2, same as she is now.
His name was Lolo Mike. He was one of the most interesting people I know. He was a guerrilla who fought against the Japanese in World War 2. He told us how he had a grenade after the war that he had to bury because my dad was asking what the cacao-like thing is on the shelf. He was a photographer and had a studio. He was musically inclined, he played the violin and tried to teach my brother and I the ukulele and guitar. He was also a craftsman, he tried to teach us how to craft nets. He taught us chess and I still play chess. He read us books and that was one of the reasons why I love reading. But above these, he had a lot of knowledge and wisdom that he imparted to us grandkids.
As I ended my story, I hoped I was able to impress on our daughter the joy of grandparents and valuing the precious time to be with them. As for me, it was a reminder that remembering them, they are with us.