Tech Talk & Other Thoughts

Some nerd talk by Brian and other random thoughts

I had been using Raspberry Pints ported over to my windows server for a while. Getting it installed was a hack job and the database calls never worked right. After upgrading my database and PHP, my Raspberry Pints install stopped working and a reinstall didn’t work either (I was hoping that my upgrades eliminated the need for my hacks, but no luck). Raspberry Pints hasn’t been updated in a few years so rather than figuring out how to do another hack install, I started searching for other options. I came across Kegerface which looked nice and rather than using database is just reads simple csv file.  This worked out of the box, but I kind of liked the Raspberry Pints display better.   This inspired me to mix the simplicity of Kegerface with the display of Raspberry Pints. I started with the raspberry pints code base. Then I cut out the database calls and added in a file read scheme. With a few more tweaks the first working version is online. There is more to do. The code is still messy with old code commented out and random test lines also commented out. Also, I’d like to change up the style.css a bit, but I’m also happy with what is working now.  I’ve named it Simple Pints and posted to github.com to share just in case there is someone else who might find it useful.  Here is my running version

 

Tags: , , ,

I ran into issues with the latest phpmyadmin. seems like there is a real bug in 4.9.2 that won’t let cookies work at the moment. I tried a lower version, but had different problems. I’ve been providing some feedback through Issue #15634. In the meantime, I’ve turned to Adminer. It’s a single small php file and worked first time. Given the hours I’ve spent with phpmyadmin and the limited need I have to edit the SQL database, Adminer is my new goto tool

Tags:

After the PHP Upgrade I noticed that PHPmyAdmin wasn’t working. After messing around with this a bit I decided to go ahead and upgrade MySQL to 8.0. Things have changed a lot since I did 5.5, but after getting the new installer things went ok. I failed the first time at importing the old database into the new one so bad that I ruin the root login. After an uninstall and clean install I successfully migrated the data with the migration tool. WordPress wasn’t working. After a little digging it looks like the users from the old database didn’t really migrate. So after setting up the WordPress User account again things worked no problem. With that complete, PHPmyAdmin still doesn’t work. Also, Raspberry Pints doesn’t work with the new SHA2 encryption. To help here I reconfigured MySQL for backward compatibility to 5.X. That almost worked, but now I need to go redo all the hacks that I made to get raspberry pints to work the first time.

Tags: , ,

I successfully upgraded PHP and still have my wordpress site working!  I hadn’t touched a PHP upgrade since I setup my server a while ago.  I thought this was going to be a disaster, but it wasn’t too bad.  I discovered my spam blocker ad was no longer supported which created errors the first night I tried to jump to PHP 7.X.  To figure this out, I deactivated all plugins and changed to a basic theme.  Then I upgraded to PHP 7.X and individually turned on each plugin and restored the theme. When I hit the spam blocker plugin it was clear this was the problem from the first night.  Next up trying to upgrade Apache….

Tags:

I discovered that many excel save problems I’ve been having are a result of the “new” Google Backup Sync program. In Windows MS Office when a file is open it creates a ~filename temp/lock file. With BackupSync running, it would backup/copy this file and somehow it wouldn’t release the file. Then when saving in Excel the save would fail.

So I decided to only turn Backupsync at night and then turn off 2 hours later. That should be enough time to copy everything from the previous day and if not it should eventually catch up.

To turn it on I setup a TaskManager task to simple trigger at 3am and start the program.

To turn it off is a bit more complicated. In the end I created a .bat file based on this post. Which resulted in the code below. From there I have another TaskManager task to run the .bat file at 5am

tasklist /fi “imagename eq googledrivesync.exe” | find “:” > nul

if errorlevel 1 taskkill /f /im “googledrivesync.exe”

I replaced the main board and now it just resets, flashes, and repeats. Any suggestions?

https://youtu.be/5kmxlttkc-s

The following deals were at Costco.  Not sure what the problem is/was, but Costco didn’t get me signed up for it.  Then after 6+ hours of chat with sprint and an hour phone call they finally honored the deal (I think).  Though I’m not sure Sprint ever really found this plan and just gave me what I told them

I also bought a new phone that is supposed to have the following deal. I suspect this is a mess and I’ll have to fight to get the deal too. Fortunately, I have plenty of saved IM conversations with Spring saying they will honor the deal.

Tags: ,

For a while I was making my own certs, just to see that I could and to understand how to setup and force https.  However, since my certs were not signed every browsers said my site wasn’t secure (rightly so).  So after a few times of my certs expiring I turned off forcing https and all redirects related to it.

With Chrome now making https more mandatory I looked into getting real SSL certs.  I found ZeroSSL.com could do the trick.  I followed the new user directions and have a few trips I was able to get real certs.  However, I read that these certs expire every 90 days.  Now I’m not the best at remembering to do updates like this so I set out to figure out how to refresh my certs automatically.  

Perhaps I’ll get into the details later, but my final messy solution is a php script that will create an html output will run the refresh command.  It translates the refresh command output to a less descriptive output (i.e. it hides all the folder paths and files used).  If the refresh command generates keys the command is setup to place the keys in my webservers SSL folder. From there I use a windows batch file to call the php file and to log the output to a html file.  The batch file also transfers the lastest html log file to a known folder that I can see from my website (the reason I don’t capture the full refresh command output into the html log file).  Finally, I have Windows Scheduled task setup to run the batch file every night.

 

And with that I should have SSL certs always up to date….at least that’s the theory.

Tags: , ,

Just experienced my first corrupt database error. All repair attempts failed. Fortunately, I have the WP-DBManager plugin running with periodic full backups. With a previous backup I was able to use the import function in phpMyAdmin to recover my WordPress site back to my last post.

Tags: , ,

I’ve been trying to sort out why my Plex media server hangs occasionally or takes a while to load content. One of my suspicions was the access time to the hard drive with the media. It was an external hard drive on a shared USB bus. I just recently moved it off of that to a dedicated USB 3.0 input and ran the CrystalDiskMark program recommended by several sites including this one.

WD Speed Test

———————————————————————–
CrystalDiskMark 5.2.2 Shizuku Edition x64 (C) 2007-2017 hiyohiyo
Crystal Dew World : http://crystalmark.info/
———————————————————————–
* MB/s = 1,000,000 bytes/s [SATA/600 = 600,000,000 bytes/s]
* KB = 1000 bytes, KiB = 1024 bytes

Sequential Read (Q= 32,T= 1) : 139.284 MB/s
Sequential Write (Q= 32,T= 1) : 124.293 MB/s
Random Read 4KiB (Q= 32,T= 1) : 0.530 MB/s [ 129.4 IOPS]
Random Write 4KiB (Q= 32,T= 1) : 1.327 MB/s [ 324.0 IOPS]
Sequential Read (T= 1) : 134.639 MB/s
Sequential Write (T= 1) : 118.700 MB/s
Random Read 4KiB (Q= 1,T= 1) : 0.354 MB/s [ 86.4 IOPS]
Random Write 4KiB (Q= 1,T= 1) : 1.303 MB/s [ 318.1 IOPS]

Test : 1024 MiB [G: 29.9% (836.9/2794.5 GiB)] (x5) [Interval=5 sec]
Date : 2017/10/08 21:29:44
OS : Windows 7 Home Premium SP1 [6.1 Build 7601] (x64)

The sequential Read and Writes look pretty good, but the randoms are horrible.  I know sequential is the most important in my case, but still thats bad.

To compare I ran the speed test on a Seagate Drive still on the USB bus and on my C drive which is a RAID 0 2 drive system.

Seagate Speed Test

———————————————————————–
CrystalDiskMark 5.2.2 Shizuku Edition x64 (C) 2007-2017 hiyohiyo
Crystal Dew World : http://crystalmark.info/
———————————————————————–
* MB/s = 1,000,000 bytes/s [SATA/600 = 600,000,000 bytes/s]
* KB = 1000 bytes, KiB = 1024 bytes

Sequential Read (Q= 32,T= 1) : 0.838 MB/s
Sequential Write (Q= 32,T= 1) : 0.812 MB/s
Random Read 4KiB (Q= 32,T= 1) : 0.275 MB/s [ 67.1 IOPS]
Random Write 4KiB (Q= 32,T= 1) : 0.387 MB/s [ 94.5 IOPS]
Sequential Read (T= 1) : 0.838 MB/s
Sequential Write (T= 1) : 0.629 MB/s
Random Read 4KiB (Q= 1,T= 1) : 0.211 MB/s [ 51.5 IOPS]
Random Write 4KiB (Q= 1,T= 1) : 0.382 MB/s [ 93.3 IOPS]

Test : 1024 MiB [F: 29.2% (816.9/2794.5 GiB)] (x5) [Interval=5 sec]
Date : 2017/10/08 21:58:01
OS : Windows 7 Home Premium SP1 [6.1 Build 7601] (x64)

C Drive Speed Test

———————————————————————–
CrystalDiskMark 5.2.2 Shizuku Edition (C) 2007-2017 hiyohiyo
Crystal Dew World : http://crystalmark.info/
———————————————————————–
* MB/s = 1,000,000 bytes/s [SATA/600 = 600,000,000 bytes/s]
* KB = 1000 bytes, KiB = 1024 bytes

Sequential Read (Q= 32,T= 1) : 87.041 MB/s
Sequential Write (Q= 32,T= 1) : 61.630 MB/s
Random Read 4KiB (Q= 32,T= 1) : 1.862 MB/s [ 454.6 IOPS]
Random Write 4KiB (Q= 32,T= 1) : 2.187 MB/s [ 533.9 IOPS]
Sequential Read (T= 1) : 60.815 MB/s
Sequential Write (T= 1) : 61.664 MB/s
Random Read 4KiB (Q= 1,T= 1) : 0.856 MB/s [ 209.0 IOPS]
Random Write 4KiB (Q= 1,T= 1) : 2.107 MB/s [ 514.4 IOPS]

Test : 1024 MiB [C: 66.0% (393.4/596.1 GiB)] (x5) [Interval=5 sec]
Date : 2017/10/10 21:30:17
OS : Windows 7 Home Premium SP1 [6.1 Build 7601] (x64)

 

Both of these drives are showing a really poor performance which makes me start to wonder if there is something wrong with Windows 7 and/or the hard drive drivers.   Any suggestions where to go from here?

Tags: , , , ,

« Older entries