Jamf released version 9.98 of its Casper Suite/JSS Jamf Pro management suite. The eagle-eyed amongst us may have noticed a change to the system requirements deep within the documentation: Prior to version 9.98, MySQL 5.7 was not recommended. You’ll likely have MySQL 5.5 or 5.6 installed. I’m running 5.6 and successfully upgraded my Jamf Pro Server to 9.98 in our development/test environment. In the interests of future proofing as well as satisfying my little OCD monster, I decided to migrate to MySQL 5.7 as well. I’m deliberately avoiding the word ‘upgrade’ because it’s more like an uninstall and re-install, with a few steps in between. What follows is how I did it in a Windows Server setting. Surprisingly, Jamf don’t provide much in terms of documentation for this specific activity, but the move to MySQL 5.7 will be something admins will have to consider as Jamf Pro evolves on its way up to version 10. Let’s set the stage. I’m assuming that we’ve got a single server environment (not clustered) and that we’re running Windows Server 2012R2. I’m also assuming that we’re running MySQL Server 5.6 and the Java JDK 8. We’ve just upgraded our JSS to version 9.98 and the humongous database migration/changes it made were successful and everything is working. Best music apps for mac. That’s good but we want new shiny MySQL Server 5.7 goodness bestowed upon our green and pleasant land. Finally, I’m assuming that your MySQL Server data folder is in the default location (C: ProgramData). This video covers the configuration process for changing MySQL or MariaDB data directory into new location. MariaDB is an alternative for MySQL that is mostly used in websites like Mozilla. I've never installed MySQL on Mac before but you can try to find the file my.cnf and check what's the default data dir and change it if necessary. Eset antivirus for mac. Data directory. You do have your MySQL database user (default name is jamfsoftware) password to hand, don’t you? You’ll need it later Before you begin There may be other ways to do this – here’s what I did. I’d love to hear from you if you’ve got any comments/suggestions – drop a comment at the bottom of the post! Stop Tomcat’s service first. We don’t want the database being changed whilst we’re working. Click Start, Administrative Tools, then launch the Services application. This is where we can control all the services running on our server. You’ll probably find yourself coming back here quite often Right-click the “Apache Tomcat 8.0 Tomcat8” service and choose Stop. Wait a moment. Now, let’s back up our JSS database. Jamf provide a little Java utility for this (I think it uses mysqldump) – if you installed your JSS to the default location, it’s in: C: Program Files JSS bin JSSDatabaseUtil.jar You need to run it with local administrator privileges. Read reviews, compare customer ratings, see screenshots, and learn more about VPN Unlimited - WiFi Proxy. Download VPN Unlimited - WiFi Proxy for macOS 10.11 or later and enjoy it on your Mac. Benefit from a simple yet powerful VPN app that works smoothly with your Mac. Go private instantly Seize the power of a single click – hit Quick Connect and get connected to the best server right away. Vpn proxy for mac free download - Betternet Free VPN Proxy App, Free VPN Proxy by Star VPN, Hola Free VPN Proxy, and many more programs. Free VPN And Free Proxy Free OPENVPN And Free Proxy For Windows, Mac, Android, iOS And Linux. Vpn proxy master. Vpn proxy for mac free download - Vpn One Click Mac, X VPN, WWD FTP Proxy for Mac, and many more programs. I found the only way to do this was to open a Command Prompt as administrator – hit the Start menu and search for ‘cmd’, then right-click and select “Run as administrator”: Next, issue the following command (assuming that you installed the JSS to the default location): java -jar 'C: Program Files JSS bin JSSDatabaseUtil.jar' Handy hint: to make things quicker for next time, stick that command in a text file and save it as “JSS Database Utility.bat” on your Desktop. Now you only need to right-click that file and select “Run as administrator”. In the Database Utility, click Save Backup Now and choose where you want to save it. This may take a little while depending on the size of your database Uninstall MySQL Server 5.6 Next, let’s take a copy of our current MySQL settings file, just in case we need to reference it later (folks often alter things here for their specific environment). The default location for it is here: C: ProgramData MySQL MySQL Server 5.6 my.ini Now, download the MySQL Server installer from – don’t worry about it being 32 bit. That’s just the installer, not MySQL Server! We’ll use the installer to remove MySQL 5.6 and then install MySQL 5.7. Run the installer – you should see a dialog like this: If you’re not running the most up-to-date version of 5.6, you’ll be thrown straight into an upgrade installer for it. Click Cancel to get to the main installer window above. If you are running the most up-to-date version, you won’t see the yellow circle/arrow icon either. Depending on your setup, you may have other items listed – I tend to have Workbench as it’s really useful for monitoring database activity and troubleshooting. Click the Remove button. Tick the “MySQL Server 5.6.xx” entry and click Execute, then confirm that you really are sure. You’ll be asked if you want to remove the MySQL Data folder for MySQL Server 5.6.
0 Comments
Leave a Reply. |