TCC

TCC – Taleo Connect Client Content Migrated

Hi and thanks for dropping by! I’m excited to announce that I’ve migrated the TCC content that was hosted here to the ThinkTalent.US website! With the loss of the TCC SIG, there’s a vacuum related to TCC information and community and I trust ThinkTalent to be the curator of this arcane knowledge moving forward. Looking for the best of the pack Oracle Taleo support? Drop ThinkTalent a line and they’ll be sure to get you pointed in the right direction!

Windows 11

Windows 11 – Restore Context Menu

I got a new laptop and it’s got Windows 11 on it and the right-click (context) menu is a bit goofy and needs to be reset to the old way. Luckily Microsoft seems to understand there would be issues with this new methodology and published a fix to set it back and even remove that if so desired.

Windows 11

Windows 11 missing New > Text File from Context Menu

This was a fun one, right-click > new > text file is one of my goto needs to create files that have zero content. You then name them whatever you need and change the extension and off you go. That was missing in the initial Windows 11. Oddly enough the fix is to set the default .txt back to Notepad, it then works, then reset it to Notepad++. Found this here and it works like a charm.

Uncategorized

NextCould – Locked Admin Account

Somehow managed to lock myself out of the next cloud admin account. If you have proper access it can be reset with the following:

sudo -u www-data php /var/www/nextcloud/occ user:resetpassword admin
Open Source

Lychee > Piwigo – Transfer

So I had been using Piwigo for a while but when I tried to upgrade PHP it blew up the instance. So I started looking around for something else that would support PHP 8+ and drifted into the docker/podman world, and the first container I got working in production happened to be Lychee which is a neat little photo management software but, there is some major lack on Lychee, no user management, no size selection when viewing, no method of putting in a photo description. Then Piwigo version 14 drops and it fixes a lot of the issues that Lychee has and adds some pretty cool functionality so now I’m trying to migrate back to Piwigo, here is the script I’m using to pull out the info for transfer.

--SELECT * FROM photos WHERE album_id = 'qVnjGzkaw25SvFRPek3TpULO'

SELECT 
'move ".\' || replace(sv.short_path, '/', '\') || '" ".\breakout\' || replace(a.title, '/', '-') || '\' || p.title || '.jpg"' as oFileName
FROM size_variants sv
JOIN photos p on (sv.photo_id = p.id)
JOIN base_albums a on (p.album_id = a.id)
WHERE sv.short_path like 'original%'
AND p.album_id != 'qVnjGzkaw25SvFRPek3TpULO'

SELECT 'mkdir "' || replace(a.title, '/', '-') || '"' FROM base_albums

SELECT * 
FROM size_variants sv
JOIN photos p on (sv.photo_id = p.id)
JOIN base_albums a on (p.album_id = a.id)
WHERE sv.short_path like 'original%'

Administration

Domains Transferred

So domain registration is just part of life. It’s right up there with death and taxes, well that may be a little exaggerated for standard folk but let’s face it, your domain is an identity. I’m asberry.org the same way I’m Aron Asberry. I have to get my license renewed every so often and it’s the same way with the domains.

In the dark ages companies like GoDaddy preyed upon both novice and experts alike. $2.99 domain registrations opened the door for up-sales and charges up the wazoo. Then Google brought it’s ‘do no evil’ to domain registration with simple yearly pricing, the centralized, intuitive dashboard, and auto privacy as well as included SSH and all was good.

That is until it wasn’t, large companies like Google can’t not be evil forever, just not in their nature. So they sold off the domain registrar bushiness with 10 million domains to Squarespace and clouds began to form and it got dark. SqSp will honor the $12 for a year so the first renewal is at the old price, but then what? I don’t trust SqSp any further than I can throw them.

A ray of hope showed up on my Facebook feel when WordPress.com says they’ll transfer and renew for a year at no charge if you sign up with them. Well why not, I already have an account with WordPress.com and they hook you up with a free year, why not?

So I transferred 7 domains leaving my .us domain behind because it’s not supported. The process was fairly simple and I’m still checking out the DNS and validating that everything is working but so far so good. Not super happy about the interface, not nearly as clean as Google but it does what you need to. There seem to be a lot more add ons like email address and such but nothing too annoying. So far I’m happy but domain registration isn’t a sprint, it’s a marathon and we’ll find out if WordPress is in it for the long run. Here’s hoping!!!

Batch

Windows CLI – Setting code page with CHCP

For those times when you are needing to set the command prompt export to UTF-8, it can be done on a temporary basis with ‘chcp 65001’ in the CLI. I’ve been working on achieving parity between the filename in a CSV and on the file system and because the file is rendered in UTF-8, the output of any CLI data needs to be the same so there’s actually a reason that you would want to do this.

Linux

RHEL – Drive Fix (COMPLETE)

Super excited to say this one would appear to be in the books. I stopped the services and backed up the partition. I didn’t bother trying to shrink it, just blew it away and recreated the home partition and as I write this, xfsrestore is chugging along restoring files. I have already grown the root from 75 GB to 2.1 TB. This seems to have fixed all the issues the web server was exhibiting. Funny how having enough space helps with that.

So just to be clear, the restore takes (in my particular case) 5 times as long as the backup. I don’t think I realized that was the case otherwise I would have probably just picked up a SATA single that I could have internalized instead of the USB 2.0 external drive.

When I rebooted after it was done, I didn’t get to see what happened but I believe it error-checked the drive and rebooted again. My heart skipped a few beats but by that point, I was watching the console and everything was coming up properly.

Initial tests indicate everything is back to the way it was. Email is dropping back into the home/vmail structure. We have oodles of room on the root and home. Life is good today.

Linux

RHEL – Drive Fix

This post is a collection of data related to fixing an issue with the distribution of space coming from a Dell

Services that need to be stopped:

  • postfix.service – Postfix is delivering the mail to home/vmail
  • dovecot.service – Dovecot looks to the home/vmail

Commands that will be run:

XFSDUMP – backs up the /home filesystem to external USB drive:
xfsdump -l 0 -f /mnt/linuxBackup/home.xfsdump /home

xfsrestore -f /mnt/linuxBackup/home.xfsdump /home

Important links

Linux

RHEL – Gee Ar Umble…

So when I reformatted the server to Red Hat Enterprise Linux, it was basically a fresh start as I got rid of the SAS drives in favor of SATA, there’s a rant someplace on my tech blog about it. Long story short I accepted all the defaults and got on with the business of getting everything that had been set up on Fedora ported over to RHEL. One thing I noticed was mount point / had 75GB while /home had 12TB. Odd but surely there would be a way to shrink home and add it to the root, I’ll contend with it later.

So now it’s later because I have round about 6GB left on the root and now we find XFS filesystems don’t have shrink capabilities… Nice!!! It appears that it wasn’t thought of because hey, storage is cheap, buy and attach new drives and expand the LVM2 VG.

Batch Python

Jupyter Notebook starting directory

We love Jupyter notebooks for data manipulation but it’s default starting directory is a bit of a pain on Windows. But you can override this behavior and specify the directory for it to start up with the following command, do make note of the backward slashes, not sure what that is all about but find and replace in normal mode in NPP and you’re golden.

jupyter notebook --notebook-dir="Z:/onedrive_tt/Archive/client/TCC_Touchpoints-Decommissioning/data/outbound"