Categories
SysAdmin

Moodle Automated Backup Problems

I am back to troubleshooting, yet again, the problem of Moodle backups taking forever and a day. An actual day, for very small courses.

A second problem occurring with the automated backups is that the old backups are not being purged so the file system is filling up with them rather than purging/pruning them. I am solving the problem at present by a weekly manual clean up.

I could simply pour over the forums for an answer, which has not produced results. I could look at tables/records in the actual database for anomalies and that strikes me as time consuming. Or I could wait until the semester break in two weeks and backup and export each class and all the information and create a brand new instance of Moodle and restore the classes into that and see if that leaves the cruft and problems behind.

I am going with that alternative in the interests of cleaning up any other problems I am not yet aware of that affect other areas including performance.

Will post my results.

Categories
SysAdmin

Tiny Tiny RSS: Building my own RSS Reader

ttrssI finally setup my TinyTinyRSS server following the guidelines on LifeHacker outlined in this article.  The original plan, when Google Reader shut down, was to have my own RSS server and not be beholden to someone disappearing.

Next on the list is to find a bookmarking tool that wouldn’t go away.

While I have the basic system setup and am going for coffee now I have a few things to still look at:

The feature set – read more about them here, the Android app, the Chrome extension, and more third-party supported apps.

I haven’t set it up for auto update.  I am running the PHP update script in a terminal window for now.  I think I may simply use the client to update itself by setting it as a pinned tab, it would update every 30 minutes then.

Open up your config.php file in a text editor, and scroll down “SIMPLE_UPDATE_MODE” and change its flag from “false” to “true.” This will make TTRSS update your feeds for you every 30 minutes (by default, you can change this in the Preferences) as long as you’re logged in. Set it as a pinned tab, and you’ll never have a problem.

And I have the final sheet of items I may look at someday, depending on whether I actually switch in the next 7 days from Feedly to it.

Additional Reading
Categories
Linux

Installing WiFi with Fedora 24 on HP ProBook 6570b

fedoraI have a HP ProBook 6570b as my work machine and while installing Cinnamon and Fedora 24 I found myself challenged to get WiFi working with the Broadcom WiFi adapter.

How did I solve it?  Well, there were two likely methods that really are the same method, installing the WiFi drivers from the HP Support Site, however, they require a few additional dependencies, notably gcc and the kernel-devel packages.  And the instructions weren’t provided.  Just as I was determining what it was missing I happened across this command:

wget http://git.io/vuLC7 -v -O fedora23_broadcom_wl_install.sh && sh ./fedora23_broadcom_wl_install.sh;

The details of which are located here on a site which some browsers may not like as the site isn’t configured correctly.  Still, the script is available and easily understood from the documentation.

The best part is I now have WiFi and it wasn’t so bad after all.

Categories
Linux

Upgrading to Fedora 24

Fedora 24 is official. I decided to jump in on my production server as I had just risked everything taking care of the Ants.  Seriously, my Cisco, Server, and Printer/Scanner were infested in their temporary location.  They have never been so clean.

I was going to go straight to FedUp like I had in the past; however, according to the documentation page:

FedUp (FEDora UPgrader) was the official tool for upgrading between Fedora releases, until the introduction of the DNF system upgrade plugin. FedUp is now obsolete and should not be used in any circumstances.

And I imagine I had been using it one or two updates too many, being slow to convert to DNF.  Installing the DNF upgrade plugin, which appears to be default is the recommended and supported way to upgrade from Fedora 23 to Fedora 24.

I have also seen that you should be able to update to Fedora 24 Workstation using the Software app, although I haven’t tested it and my system is “headless”.

Assuming you have backed up your system Smile, perhaps using deja-dup. Update your machine and install the DNF plugin

$ sudo dnf upgrade --refresh

 

$ sudo dnf install dnf-plugin-system-upgrade

Part 1 – download upgrades to prepare for the upgrade

$ sudo dnf system-upgrade download --releasever=24

This command will begin downloading all of the upgrades for your machine locally to prepare for the upgrade. You may wish

If you have issues when upgrading because of packages without updates, broken dependencies, or retired packages, add the --allowerasing flag when typing the above command. This will allow DNF to remove packages that may be blocking your system upgrade.

Upgrading to Fedora 24: Starting upgrade

Part 2 – Reboot and upgrade

$ sudo dnf system-upgrade reboot

Your system will restart after this. In past releases, the fedup tool would create a new option on the kernel selection / boot screen. With the new dnf-plugin-system-upgrade package, your system reboots into the current kernel installed for Fedora 23; this is normal. Shortly after the kernel selection screen, your system begins the upgrade process.

Now might be a good time for a coffee break! Once it finishes, your system will restart and you’ll be able to log in to your newly upgraded Fedora 24 Workstation.

I flew through without any issues, but if there are issues, check out the  DNF system upgrade wiki page as well as Fedora Magazine’s Upgrading Fedora 23 to Fedora 24 article.  I followed their directions for the most part and have put the salient ones in here so I can remember as I upgrade all my workstations.

Categories
SysAdmin

How to convert an entire MySQL database character set and collation to UTF-8?

I found myself in need of upgrading a number of older wordpress sites to change from the old latin1_swedish_ci to UTF-8, both the character set and collation.  I utilized a command line SQL prompt to accomplish this.  Modify the appropriate parameters “test” for your database, and “yourpasswordhere” with your password, ymmv, and have fun.

I am using Fedora 21 and MariaDB 10.0.15

(echo ‘ALTER DATABASE `'”test”‘` CHARACTER SET utf8 COLLATE utf8_general_ci;’; mysql -u root –password=”yourpasswordhere” “test” -e “SHOW TABLES” –batch –skip-column-names | xargs -I{} echo ‘ALTER TABLE `'{}’` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;’ ) | mysql -u root –password=”yourpasswordhere” “test”

I don’t believe I needed to login twice; however, I was rewriting this from some notes and it worked, so I left it.  Feel free to send me the shorter code.  I always appreciate it.