Default data connections to the Qlik Repository Service API (QRS API) were added in Qlik Sense 3.0.
These data connections are used by the included monitoring applications (Operations and License monitors) and have been renamed and updated in Qlik Sense June 2017.
Continue reading “Changes to default QRS API data connections in Qlik Sense from June 2017”
Domo is a cloud visualisation tool that offers a wealth of connectors (400+ according to their website) and a simple learning curve.
I thought I’d have a go connecting to the same google analytics account as I did with Qlik Cloud a while ago. This will be using the Domo free tier, which you can use to share up to 50 cards at the time of writing.
Continue reading “Loading Google Analytics data on Domo”
I have an installation of the 3arcade script that’s still in the wild, and decided it was time to update it to work with PHP 5.6 (at least).
These changes fix:
– a row 0 error in play.php linked to deprecated functions
– deprecation of the ereg_replace function through use of intval
– deprecation of the mysql_connect function (and future deprecation of mysql* functions) through use of PDO
– consistency of database connection and query errors with a variable in the config file
Changes live at https://github.com/withdave/3arcade
CentOS7 (and some of the other RHEL flavours) currently don’t include PHP 5.6+ in the core repos, and yet the versions of PHP bundled are at EOL or close to it.
A number of guides suggest using the webstatic or remi repos – but this is not recommended as they contain packages with names that conflict with packages in core repos.
One of the better options is to use the IUS repo (Inline with Upstream Stable project), which means you can quickly and easily update.
Continue reading “Upgrading PHP to 5.6.x or later on CentOS7 via Yum and the IUS repo”
After installing LAMP on new servers (similar to as described here for CentOS), I’ve recently had two errors after the creation of MySQL users.
These user accounts required additional steps after creation – flushing permissions, and re-running the MySQL secure installation.
Continue reading “After creating a new user in MariaDB / MySQL, flush permissions and MYSQL_SECURE_INSTALLATION”
Simple Event Attendance has been updated to 1.5.0.
Update to fulfill some of the requests posted at https://withdave.com/2017/05/seatt-feature-request-may-2017-update/, as well as some other fixes:
- Updates to structure of comments in source files to improve readability
- Addition of list format to make displaying multiple events easier
- Change to remaining time display in the admin panel (from hours to a formatted time)
- Removed use of extract function from add_shortcode (seatt-list and seatt-form) as per best practice
- Added ability to use shortcode to control public visibility of comments
- Updated screenshots for plugin
Plugin is live on wordpress.org.
I’ve been exploring how to generate videos on the fly through use of packages like ffmpeg (I installed this the other day), and recently tried out ClipBucket (a free video site script).
ClipBucket is a little rough around the edges, but has a load of great features, has a relatively active community, and large parts of the code are on GitHub.
Continue reading “DateTime with no DateTimeZone set in PHP.ini with ffmpeg and ClipBucket”
This is a quick guide to installing the following in CentOS 7:
CentOS 7 requires a tweak to the process I’d used for CentOS 6. The links below are generally suitable for EL7.
Continue reading “Installing ffmpeg, flvtool2, mp4box and ImageMagick on CentOS7”
Note to self: do not update Intel Rapid Storage Technology drivers on a HP Proliant ML10v2, unless I really, really need to.
I’ve become complacent when throwing drivers at devices and this is a reminder how easy it is to break things. I recently added a TPM to one of my servers and one of the fixed drives is classified as removable by Windows, which means I can’t use the TPM with it. There’s at least two ways to fix this, either install Intel RST drivers and configure it through the console, or change some registry keys to force them to fixed drives.
Continue reading “INACCESSIBLE_BOOT_DEVICE, courtesy of Intel Rapid Storage Technology drivers (188.8.131.521)”