Skip to main content
Jamf Nation, hosted by Jamf, is a knowledgeable community of Apple-focused admins and Jamf users. Join us in person at the ninth annual Jamf Nation User Conference (JNUC) this November for three days of learning, laughter and IT love.

Installing Java and MySQL for Jamf Pro 10.13.0 or Earlier

Overview

Before you can install Jamf Pro, Java and MySQL must be installed and running on your server. This article explains how to install and configure Java and MySQL on supported Mac, Linux, and Windows operating systems.

Note: If installing or upgrading to Jamf Pro 10.6.0 or later, you must make a one-time change to the default MySQL settings to avoid performance issues. See the "Configure MySQL" section of the Creating the Jamf Pro Database Knowledge Base article for instructions.

For more information about MySQL 8.0, see the Configuring MySQL 8.0 for Jamf Pro Knowledge Base article.

Versions Affected

Jamf Pro 10.13.0 or earlier

Requirements

The required versions of Java and MySQL for each supported platform are listed on the Jamf Pro System Requirements page of the Jamf Pro Administrator's Guide.

Note: The latest versions of MySQL may not be compatible with older operating systems. For information on MySQL supported platforms and versions, see the following webpage:
https://www.mysql.com/support/supportedplatforms/database.html

Procedures

Important: As of April 16, 2019, commercial license and support for the Oracle JDK requires a Java SE Subscription. If you don’t have a subscription, you can install a variant of OpenJDK instead as detailed below.

macOS 10.7 or later

To install and configure Amazon Corretto OpenJDK:

  1. Download the Amazon Corretto 8 installer for MacOS: https://docs.aws.amazon.com/corretto/latest/corretto-8-ug/macos-install.html
  2. Run the installer and follow the instructions.
  3. Open Terminal.
  4. Set the JAVA_HOME path by executing the following command:
    $ export PATH=$JAVA_HOME/bin:$PATH

To install and configure Java SE Development Kit (JDK) 1.8 Update 161 or later:

  1. Download the Java SE Development Kit (JDK) 1.8 for macOS. You can download the latest JDK from: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  2. Launch the JDK installer and follow the onscreen instructions to install the software. Use the default settings to configure the installation.

To install and configure Java SE Development Kit (JDK) 1.8 Update 151–152:

  1. Download the Java SE Development Kit (JDK) 1.8 for macOS. You can download the latest JDK from: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  2. Launch the JDK installer and follow the onscreen instructions to install the software. Use the default settings to configure the installation.
  3. Navigate to /Library/Java/JavaVirtualMachines/jdk<version>.jdk/Contents/Home/jre/lib/security
  4. Open the java.security file with a plain text editor of your choice.
  5. Enable unlimited strength encryption by locating the crypto.policy=unlimited line and uncomment it by removing the hash (#) at the beginning of the line. If the line does not exist, add it to the end of the file.
  6. Save the file.

To install and configure Java SE Development Kit (JDK) 1.8 Update 144 and earlier:

  1. Download the Java SE Development Kit (JDK) 1.8 for macOS. You can download the latest JDK from: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  2. Launch the JDK installer and follow the onscreen instructions to install the software. Use the default settings to configure the installation.
  3. Download the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files 1.8. You can download the latest JCE from: http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html
  4. Copy the following files from the extracted folder to /Library/Java/JavaVirtualMachines/jdk<version>.jdk/Contents/Home/jre/lib/security/:
    • local_policy.jar
    • US_export_policy.jar
  5. Accept the prompt to replace the existing files.

To install MySQL Community Server:

  1. Download the DMG archive of MySQL Community Server, available at: https://dev.mysql.com/downloads/mysql/
  2. Mount the DMG and run the MySQL Community Server installer.
  3. (MySQL 8.0 only) When prompted, select Use Legacy Password Encryption.
  4. Open System Preferences and click MySQL.
  5. Click the Start MySQL Server button.

Red Hat Enterprise Linux 6.x or 7.x

To install and configure Amazon Corretto OpenJDK:

  1. Install wget by executing the following command:
    yum install wget
  2. Download the Amazon Corretto 8 Installer for RPM-based Linux by executing the following command:
    wget "https://d3pxv6yz143wms.cloudfront.net/8.212.04.2/java-1.8.0-amazon-corretto-devel-1.8.0_212.b04-2.x86_64.rpm"
  3. Install Amazon Corretto 8 by executing the following command:
    sudo yum localinstall java-1.8.0-amazon-corretto-devel-1.8.0_212.b04-2.x86_64.rpm
  4. Change the default java provider by executing the following command:
    sudo alternatives --config java
  5. Set the JAVA_HOME path by executing the following command:
    export PATH=$JAVA_HOME/bin:$PATH

To install and configure OpenJDK 8:

  1. Install Red Hat OpenJDK by executing the following command:
    sudo yum install java-1.8.0-openjdk
  2. Change the default java provider by executing the following command:
    sudo alternatives --config java
  3. Set the JAVA_HOME path by executing the following commands:
    export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk
    export PATH=$JAVA_HOME/bin:$PATH

To install MySQL Community Server:

  1. Download the MySQL yum repository available at: https://dev.mysql.com/downloads/repo/yum/ Note: MySQL 8.0 is provided by default. If you need MySQL 5.7, follow the instructions on the download page.
  2. Add the MySQL Yum repository and install MySQL by following the instructions under step 1 in Oracle's documentation: https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
  3. Enable MySQL to start at boot by executing:
    sudo /sbin/chkconfig --levels 345 mysqld on
  4. Start MySQL by executing:
    sudo systemctl start mysqld
  5. Stop the MySQL server.
  6. Open the my.cnf file.
  7. Add the following entry:
    [mysqld]
    default-authentication-plugin=mysql_native_password
  8. Restart the MySQL server.

Note: The built-in repositories from Red Hat Enterprise Linux will install MySQL 5.1, which is not compatible with Jamf Pro.

Ubuntu 18.04 or 16.04 LTS Server

To install and configure Amazon Corretto OpenJDK:

  1. Download the Amazon Corretto 8 Installer for Debian-based Linux by executing the following command:
    wget "https://d3pxv6yz143wms.cloudfront.net/8.212.04.2/java-1.8.0-amazon-corretto-jdk_8.212.04-2_amd64.deb"
  2. Install Amazon Corretto 8 by executing the following command:
    sudo apt update && sudo apt install java-common
    sudo dpkg --install java-1.8.0-amazon-corretto-jdk_8.212.04-2_amd64.deb
  3. Execute the following command to set the JAVA_HOME path:
    export PATH=$JAVA_HOME/bin:$PATH

To install and configure OpenJDK 8:

  1. Install the OpenJDK by executing the following commands:
    sudo apt update
    sudo apt install openjdk-8-jdk
  2. Set the JAVA_HOME path by executing the following commands:
    export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
    export PATH=$PATH:$JAVA_HOME/bin

To install MySQL Community Server:

  1. Download the latest MySQL APT repository available at: https://dev.mysql.com/downloads/repo/apt/ For example, execute the following command:
    wget –c https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb
  2. Install the APT repository by executing the following command:
    sudo dpkg –i mysql-apt-config_0.8.12-1_all.deb
  3. During installation, select the MySQL version you want to install.
  4. Refresh the repositories by executing the following command:
    sudo apt update
  5. Install MySQL by executing the following command:
    sudo apt install mysql-server
  6. When prompted, set a password for the MySQL "root" user.
  7. (MySQL 8.x only) When prompted to select an authentication plugin, select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility).

Windows 2012 or later

Note: Before installing Jamf Pro on Windows, it is recommended that you verify that the JAVA_HOME and JRE_HOME environment variables are pointed at the correct locations. For more information, see Configuring the JAVA_HOME and JRE_HOME Environment Variables on a Windows Server.

To install and configure Amazon Corretto OpenJDK:

  1. Download Amazon Corretto: https://docs.aws.amazon.com/corretto/latest/corretto-8-ug/windows-7-install.html
  2. Run the installer and follow the instructions.
  3. Copy and paste the following script into your preferred text editor, and then save it as a .bat file:
    reg add "HKLM\Software\JavaSoft\Java Development Kit" /v CurrentVersion /t REG_SZ /d "1.8" /f 
    reg add "HKLM\Software\JavaSoft\Java Runtime Environment" /v CurrentVersion /t REG_SZ /d "1.8" /f 
    reg add "HKLM\SOFTWARE\WOW6432Node\Apache Software Foundation\Procrun 2.0\Tomcat8\Parameters\Java" /v Jvm /t REG_SZ /d "C:\Program Files\Amazon Corretto\jre8\bin\server\jvm.dll" /f
    Note: The path to OpenJDK listed in the commands must match your downloaded OpenJDK version. If necessary, change the path to the OpenJDK installation in the above command.
  4. Run the .bat script to edit the Java registry entries. Note: The script must be run as an administrator.

To install and configure Red Hat OpenJDK:

  1. Log in to your Red Hat account or register a new account.
  2. Download the OpenJDK 8 from Red Hat: https://developers.redhat.com/products/openjdk/download/
  3. Copy the downloaded folder to the following location: C:\Program Files\
  4. Copy and paste the following script into your preferred text editor, and then save it as a .bat file:
    reg add "HKLM\Software\JavaSoft\Java Development Kit\1.8" /v JavaHome /t REG_SZ /d "C:\Program Files\java-1.8.0-openjdk-1.8.0.191-1.b12.redhat.windows.x86_64" /f
    reg add "HKLM\Software\JavaSoft\Java Development Kit" /v CurrentVersion /t REG_SZ /d "1.8" /f
    reg add "HKLM\Software\JavaSoft\Java Runtime Environment\1.8" /v JavaHome /t REG_SZ /d "C:\Program Files\java-1.8.0-openjdk-1.8.0.191-1.b12.redhat.windows.x86_64\jre" /f
    reg add "HKLM\Software\JavaSoft\Java Runtime Environment" /v CurrentVersion /t REG_SZ /d "1.8" /f
    reg add "HKLM\Software\JavaSoft\Java Runtime Environment\1.8" /v RuntimeLib /t REG_SZ /d "C:\Program Files\java-1.8.0-openjdk-1.8.0.191-1.b12.redhat.windows.x86_64\jre\bin\server\jvm.dll" /f
    reg add "HKLM\SOFTWARE\WOW6432Node\Apache Software Foundation\Procrun 2.0\Tomcat8\Parameters\Java" /v Jvm /t REG_SZ /d "C:\Program Files\java-1.8.0-openjdk-1.8.0.191-1.b12.redhat.windows.x86_64\jre\bin\server\jvm.dll" /f
    Note: The path to OpenJDK listed in the commands must match your downloaded OpenJDK version. If necessary, change the path to the OpenJDK installation in the above command.
  5. Run the .bat script to edit the Java registry entries. Note: The script must be run as an administrator.
  6. Configure the JAVA_Home and JRE_Home environment variables for Red Hat. For more information see the Configuring the JAVA_HOME and JRE_HOME Environment Variables on a Windows Server Knowledge Base article.
  7. Add the path to the OpenJDK bin directory in System Properties. a. On the Windows server, open the Control Panel, and then navigate to the "Advanced System Settings" section. b. In the System Properties menu, click Environment Variables. c. Select "Path", and then click New. d. Add the following path: C:\Program Files\java-1.8.0-openjdk-1.8.0.191-1.b12.redhat.windows.x86_64\bin e. Click OK.

To install and configure Java SE Development Kit (JDK) 1.8 Update 161 or later:

  1. Download the Java SE Development Kit (JDK) 1.8 for Windows x64. You can download the latest JDK from: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  2. Launch the JDK Installer and follow the onscreen instructions to install the software. Use the default settings to configure the installation.

To install and configure Java SE Development Kit (JDK) 1.8 Update 151–152:

  1. Download the Java SE Development Kit (JDK) 1.8 for Windows x64. You can download the latest JDK from: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  2. Launch the JDK Installer and follow the onscreen instructions to install the software. Use the default settings to configure the installation.
  3. Navigate to C:\Program Files\Java\jre<version>\lib\security\
  4. Open the java.security file with a plain text editor of your choice.
  5. Enable unlimited strength encryption by locating the crypto.policy=unlimited line and uncomment it by removing the hash (#) at the beginning of the line. If the line does not exist, add it to the end of the file.
  6. Save the file.

To install and configure Java SE Development Kit (JDK) 1.8 Update 144 and earlier:

  1. Download the Java SE Development Kit (JDK) 1.8 for Windows x64. You can download the latest JDK from: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  2. Launch the JDK Installer and follow the onscreen instructions to install the software. Use the default settings to configure the installation.
  3. Download the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files 1.8. You can download the latest JCE from: http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html
  4. Copy the following files from the extracted folder to C:\Program Files\Java\jre<version>\lib\security\:
    • local_policy.jar
    • US_export_policy.jar
  5. Accept the prompt to replace the existing files.

To install MySQL Community Server:

Follow these steps to perform a basic installation of MySQL Community Server on Windows. Your organization may require different configuration settings for security or other reasons. Consult your IT department for more information about how MySQL should be configured.

Note: These steps may vary slightly between MySQL versions.

  1. Download one of the following:
  2. Launch the Visual Studio C++ Redistributable installer. Perform the basic install.
  3. Download MySQL Community Server 64-bit MSI installer for Microsoft Windows, available at: https://dev.mysql.com/downloads/mysql/
  4. Launch the MySQL Installer.
  5. Select the Server Only setup type, and click Next.
  6. Start the installation by clicking Execute, and click Next when the installation is complete.
  7. Click Next to begin the configuration.
  8. Select the Standalone MySQL Server option, and click Next.
  9. Select Server Computer, and click Next.
  10. (MySQL 8.0 only) Select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility), and click Next.
  11. Provide the MySQL Root Password, enter it again for confirmation, and click Next.
  12. Ensure Configure MySQL Server as a Windows Service, Start the MySQL Server at System Startup and Standard System Account are selected, and click Next.
  13. (MySQL 5.x only) Leave Enable X Protocol / MySQL as a Document Store disabled, and click Next.
  14. Click Execute to apply the configuration and then click Finish when the configuration is complete.
  15. Click Next and then click Finish to complete the installation and exit the installer.

Additional Information

For instructions on installing Java and MySQL for Jamf Pro 10.14.0 or later, see the Installing Java and MySQL for Jamf Pro 10.14.0 or Later Knowledge Base article.

Like Comment
Order by:
SOLVED Posted: by ben
Like
SOLVED Posted: by jarednichols

I just installed the Java JDK 1.6 Update 31 freshly on my Windows 2008 R2 server and the path to put the JCE files is ```
c:\program files\java\jre6\lib\security
```

Minor difference, but it may need changing in the documentation

Like
SOLVED Posted: by erin.miska

Hi Jared,

Thanks for catching that. I changed the path accordingly.

-Erin

Like
SOLVED Posted: by justinrummel

This needs to be updated for 8.6. the Windows .msi installer now comes with Tomcat.

Like
SOLVED Posted: by erin.miska

Hi Justin,

Which Windows installer are you referring to? Tomcat is installed when you run any of the JSS Installers.

-Erin

Like
SOLVED Posted: by petewann

Is there an option that doesn't install X11 and all of the associated cruft when installing on Linux? I'm installing on a headless server and don't need or want a GUI, etc.

Like
SOLVED Posted: by H3144-IT

This was really helpful...

May I ask \-

who needs Java 1.6 ?! Mac OS X or CasperSuite \- and when are they starting to use 1.7 (Java 7), since no further Support & Updates will be available for 1.6 from April 2013...

&

when does Casper switch to MariaDB \- the later seems to be the new Buzzword:

Google just announced that they are switching from MySQL to MariaDB
http://www.theregister.co.uk/2013/09/12/google_mariadb_mysql_migration/

Like
SOLVED Posted: by donmontalvo

We are building a POC environment on Mac minis running 10.9, for future migration of existing JSS. It would help to know up front what the requirements are, since "N or later" seems to be fuzzy and we'd like to avoid any issues by going with JAMF's recommendation.

  1. What is JAMF's recommendation on MySQL version? This article seems to recommend "5.5 or later" but the link takes you to Oracle's default site which shows 5.6. I remember there were some issues with 5.6, so is JAMF's recommendation to go with 5.5? Or go with 5.6 and deal with the issues?

  2. Oracle is no longer supporting Java 1.6 but this article states support for 1.6 or later, the link takes you to 1.7. What is JAMF's recommendation on the Java version?

Thanks,
Don

Like
SOLVED Posted: by tomt

Don, did you ever get any official response to your questions? Particularly the one about which MySQL version is recommended for JAMF?

Like
SOLVED Posted: by donmontalvo

@tomt There was some discussion, for our situation we needed to keep the MySQL verision the same on the POC environment as on the live environment. Still a little fuzzy, maybe open a ticket with JAMF to get a formal response for whatever your situation is?

Like
SOLVED Posted: by tomt

Ticket opened, I'll post any response I get.

Like
SOLVED Posted: by tomt

@donmontalvo Just received a response from support. They said that there is no officially recommended version of MySQL for v9 of the JSS. They said that anything 5.5 and up will work great and referred me to the Admin Guide for system requirements.

Like
SOLVED Posted: by donmontalvo

Is JDK a requirement? Or is JRE all that is needed for JSS running on OS X Server?

Scroll up this page for requirements, seems a little vague for OS X Server.

Don

Like
SOLVED Posted: by scottb

@erin.miska][/url: Just checking this as well for Win 2008 R2 as we had issues on the last try.
Vague is an understatement. I'd like to know what version of Java and MySQL to have on the Wintel server as we have to request those installs be done by the Enterprise support teams.
The plan is to go to 8.72 to 9.32. Thanks!

Like
SOLVED Posted: by dderusha

We are on a Win 2008 R2 server and here is what we needed.
(downloading 3 items)

-MySQL 5.5.39 winx64 Community
http://dev.mysql.com/downloads/mysql/5.5.html#downloads

-Java 7u67
-Java JCE 1.7 (1.7 is for Java 7) there are two files in the JCE that need to replace files Java 7u67 installed. located
Program Files \- Java \- jre7 \- lib \- security

Yes there are new versions available but these are the ones that support said work best.

Like
SOLVED Posted: by justinrummel

Please remove references to JDK 1.6 as an option as 1.6 cannot do TLSv1.1. At a minimum JDK 7 should be used to prevent POODLE attacks, PLUS we need references for JDK 8 as "After April 2015, Oracle will no longer post updates of Java SE 7 to its public download sites".

https://java.com/en/download/faq/java_7.xml

\- Justin

Like
SOLVED Posted: by scottmorabito

I noticed this documentation for the Mac changed from "Java 1.6 or later" to specify using JDK, yet the most recent JSS Installation and Configuration guide (9.61) specifies "Java 1.6 or Java 1.7". Can anyone explain the discrepancy?

Like
SOLVED Posted: by donmontalvo

Please update this article with steps for setting up Launch Daemon (vs StartupItems) for MySQL.

We know this is a MySQL problem, but need to guide JAMF users, please see:

http://bugs.mysql.com/bug.php?id=59855

Like
SOLVED Posted: by jake.snyder

@justinrummel Did you get a response about Java 8 yet? April is coming up quickly.

Like
SOLVED Posted: by justinrummel

@jake.snyder as far as I know Java 8 is still not approved.

Like
SOLVED Posted: by bentoms

@justinrummel][/url & @jake.snyder][/url, FWIW I just moved & upgraded my JSS.

We're on 9.63 & the host has Java 8. All seems fine.

Like
SOLVED Posted: by were.wulff

@jake.snyder

Our development and QA teams are aware of the upcoming EOL of Java 7, and are working on thoroughly testing out Java 8 with the JSS. @jake responded to the Support for Java 8 Feature Request with the following:

We are aware of Oracle ending public updates for Java 7 in April 2015. We will have official support for Java 8 before this time to ensure all environments can be patched and running the latest and most secure version of Java.

Java 8 is still not officially supported at the time of this posting, however, so if you do decide to implement it prior to us having it fully supported, please be aware that it’s possible that you may run into some undesirable behavior.

We do have some customers who have upgraded and are not seeing issues (such as @bentoms right above me), however, support has also had cases in which Java 8 was causing problems or instability in the JSS and we ended up needing to downgrade back to Java 7 to resolve the stability issues.

It would be something, until we have Java 8 listed as fully supported, that we'd recommend stick to a dev environment or at least be tested out in a dev environment before making the decision whether or not to move to Java 8 in production, just to be on the safe side.

We do know that there are some issues with Java 8 in regards to Casper Focus (D-008008), so if you’re using Focus in your environment, it would not be a good idea to implement Java 8 just yet as it will likely prevent Focus from working properly.
D-008008 will more than likely be taken care of once we have fully implemented support for Java 8.

If you have additional questions or concerns regarding Java 8 compatibility, please get in touch with your Technical Account Manager either by giving the a call, by sending an e-mail to support@jamfsoftware.com, or by using the My Support section of JAMF Nation.

Thanks!
Amanda Wulff
JAMF Software Support

Like
SOLVED Posted: by uurazzle

Any updated status on JSS and Java 8 support? Is it officially supported if not any timeframe on when it will be reviewed to be officially supported?

Like
SOLVED Posted: by uurazzle

FYI:

Answering my own question, but...

You are correct. With 9.7 there are still a few defects associated to 8. However we are supposed to be releasing 9.71 very very shortly to be supported with Java 8. Possibly this week.
Like
SOLVED Posted: by uurazzle

FYI:

Here are detailed instructions for install Java/MySQL on OS X Yosemite.

Installing Java & MySQL for JSS on OS X Server

Like
SOLVED Posted: by kitzy

Under the OS X instructions

To install MySQL Community Server: Download the DMG archive or MySQL Community Server, available at: http://www.mysql.com/downloads/ Mount the DMG and install the MySQL package and the MySQL Startup Item package. Add MySQL to System Preferences by double-clicking the MySQL.prefPane file. Open System Preferences and click MySQL. Click the Start MySQL Server button.

This appears to be inaccurate. The latest MySQL installer for Mac now has everything bundled into a single pkg. The current process looks like this:

Download the DMG archive or MySQL Community Server, available at:
http://www.mysql.com/downloads/
Mount the DMG and install the MySQL package
Open System Preferences and click MySQL.
Click the Start MySQL Server button.

Like
SOLVED Posted: by uurazzle

Thanks for the feedback, I will review it and update the documentation.

Like
SOLVED Posted: by donmontalvo

Building a JSS 9.8 test box today, using MySQL 5.6.20.

Nice, MySQL finally drops StartupItems and installs proper Launch Daemon.

However, the port seems to have changed in MySQL 5.6.20, to 3307 rather than 3306.

Using vi (*) to change the port in the Launch Daemon from 3307 to 3306, and of course unloading/loading it seems to have done the trick.

$ cat /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
    <key>Label</key>             <string>com.oracle.oss.mysql.mysqld</string>
    <key>ProcessType</key>       <string>Interactive</string>
    <key>Disabled</key>          <false/>
    <key>RunAtLoad</key>         <true/>
    <key>KeepAlive</key>         <true/>
    <key>SessionCreate</key>     <true/>
    <key>LaunchOnlyOnce</key>    <false/>
    <key>UserName</key>          <string>_mysql</string>
    <key>GroupName</key>         <string>_mysql</string>
    <key>ExitTimeOut</key>       <integer>600</integer>
    <key>Program</key>           <string>/usr/local/mysql/bin/mysqld</string>
    <key>ProgramArguments</key>
        <array>
            <string>/usr/local/mysql/bin/mysqld</string>
            <string>--user=_mysql</string>
            <string>--basedir=/usr/local/mysql</string>
            <string>--datadir=/usr/local/mysql/data</string>
            <string>--plugin-dir=/usr/local/mysql/lib/plugin</string>
            <string>--log-error=/usr/local/mysql/data/mysqld.local.err</string>
            <string>--pid-file=/usr/local/mysql/data/mysqld.local.pid</string>
            <string>--port=3307</string>
        </array>
    <key>WorkingDirectory</key>  <string>/usr/local/mysql</string>
</dict>
</plist>
$

(*) ducking!!!

Don

Like
SOLVED Posted: by calumhunter

Vi the one true command line text editor ;)

also lol at MySQL launchd, I'm guessing it was a typo that made it through.

Like
SOLVED Posted: by Laurent.Pertois

Sed is your friend too ;-)

$ sudo launchctl unload /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

$ sudo sed -i .bck 's/3307/3306/' /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

$ sudo launchctl load /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

Now, the question is to know if they really made a typo and, if yes, how long it will take them to correct it. Because, looking at how long it took them to drop the Startup Item method, it could take years. And then, if they reinstall the incorrect launchd every time, you may end up with a correction to do every time you upgrade.

But on the other hand, if you stay with port 3307 and they correct the launchd item, you'll have to change the port used by the JSS.

Like
SOLVED Posted: by donmontalvo

^^^ what he sed.

Like
SOLVED Posted: by MikeF

Just installed using 5.6.27 and it looks like they fixed the port. I did not have to change it

Like
SOLVED Posted: by cwaldrip

Just installed 5.7.9 and they're now auto-generating a random root password.

To change the root password to blank you can log into mysql with the random password and change it with this command.

SET PASSWORD = PASSWORD('');

That's with no space between the single-quote marks.

Like
SOLVED Posted: by jonathan.spiva

The key is finding that random password, for RHEL/Cent check out this page - https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/

sudo grep 'temporary password' /var/log/mysqld.log
Like
SOLVED Posted: by sujihap

Hi All,

Need some ideas , we are building our MAC environment , during this process , whenwe tried to install Java and MySQL , during the recommendations as shown by Jamf (http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html) , when we install Java 1.8 update 66 , and when we try to copy and paste the .jar files we are not able to find the referred Java folder under libraries . /Library/Java/JavaVirtualMachines/jdk<version>.jdk/Contents/Home/jre/lib/security/

Please let us know where are we missing the steps , Any help and suggestions are highly appreciated .

Suggested Link : http://www.jamfsoftware.com/resources/manually-installing-the-jamf-software-server/

Regards ,

Suji

Like
SOLVED Posted: by kenglish

Just a note: Depending on the version of Ubuntu you are running, you may have to run

sudo apt-get install software-properties-common python-software-properties
sudo apt-get install python-software-properties

Before the add-apt-repository command will function.

Like
SOLVED Posted: by kitzy
sudo apt-get install openjdk-8-jdk

Running this on Ubuntu 14.04 will install a Java version that breaks communication with Amazon S3. Is there any updated documentation on appropriate installation instructions for Ubuntu?

Like
SOLVED Posted: by asseeger

Oooh boy – hands on with my first installation on virtualized CentOS installation.
Took me all day long to figure out the fact that mysql server 5.7 is creating a random password when being installed through yum...
RTFM, I shall say...

Having that said, because of the fact that my CentOS already had MariaDB installed I'd like to vote up for MariaDB!!! ;-)

Like
SOLVED Posted: by were.wulff

@asseeger

If you're running this JSS in a production environment, instead of testing, I'd highly recommend not using MySQL 5.7 if you still are as we do not yet officially support it.

In the latest version of the Casper Suite Administrator's Guide, it's specified that MySQL 5.5 and MySQL 5.6 are the two supported versions, and that MySQL 5.6 is recommended. This KB also specifies either MySQL 5.5 or 5.6, with 5.6 being the recommended version.

Once we do fully support MySQL 5.7, our documentation and KB articles will be updated to reflect that.

While we do have some customers who are using MySQL 5.7 without difficulty, we have also had a number who have seen odd behaviors, including the JSS hanging or dropping the connection, and those issues are resolved once we remove MySQL 5.7 and replace it with MySQL 5.6.

Now, as for your mention of MariaDB, it just so happens that we actually have an open Feature Request for that; if you haven't already voted it up/commented there, I'd encourage you to go ahead and do so.

Thanks!
Amanda Wulff
JAMF Software Support

Like
SOLVED Posted: by donmontalvo

We had problems importing our database backup, and were trying to set the max_allowed_packet=1024M value. JSSDatabaseUtility.exe writes these settings by default to C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini. But it didn't seem to do the trick, imports continued to fail.

So we called MikeS (our Buddy) and as always he had a quick answer. :)

JSSDatabaseUtility.exe writes custom settings to C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini, but (in our case) MySQL is actually writing to C:\ProgramData\MySQL\MySQL Server 5.6/my.ini.

The path might differ for you. To find your actual path, run > services.msc > select MySQL56 > right-click > Properties > General > Path to executable.

We manually set max_allowed_packet=1024M in C:\ProgramData\MySQL\MySQL Server 5.6/my.ini and import completed perfectly.

Ran out of time, but hope to circle back to update this post with info on how to set JSSDatabaseUtillity.exe to write to the correct file. Unless someone knows and wants to chime in. :)

HTH,
Don

Like
SOLVED Posted: by etippett

We had a similar issue as @donmontalvo where with JSS 9.81 and MySQL 5.6 the Change MySQL Settings option in the JSS Database Utility were greyed out and database imports failed. Interestingly in our case the DB Util wanted to write to C:\Program Files\MySQL\MySQL Server 5.6\my.ini (not my-default.ini as Don saw), but MySQL was writing to C:\ProgramData\MySQL\MySQL Server 5.6\my.ini.

Since we didn't know how to change the path that the DB Util was writing to, we elected to change the path MySQL was referencing by modifying the MySQL service in Windows to look at the file the JSS DB Util was writing to. Based on the information here we ran the following command:

sc config MySQL56 binPath= "\"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe\" --defaults-file=\"C:\Program Files\MySQL\MySQL Server 5.6\my.ini\" MySQL56"

After a restart of MySQL, the MySQL Settings were no longer greyed out in the JSS DB Util and changes made with the Util were properly reflected in the running instance of MySQL.

-Eric

Like
SOLVED Posted: by arekdreyer

I notice that there's a section in "Windows 2008". Is there a reason it's not "Windows 2008 or later"? Compare to the section: "OS X v10.7 or later". Thanks -Arek

Like
SOLVED Posted: by arekdreyer

The MSI Installer for Windows is labeled as "32 bit", even though it is 32/64 bit. Step 2 is currently "Launch the MySQL Installer and follow the onscreen instructions to perform a "Typical" install," which does not exist. The installer choices are Developer Default, Server Only, Client Only, Full, and Custom.

This is for http://dev.mysql.com/downloads/mysql/5.6.html#downloads for Windows

Like
SOLVED Posted: by scottb

@amanda.wulff - can we assume that this doc is the current recommendation(s) still? We have to do some updates to a Windows JSS and I'd like to be sure that the info on top is the latest.

Thanks much!

Like
SOLVED Posted: by scottb

@amanda.wulff @arekdreyer - what install do we use for the Windows MySQL??? We are in this now and don't know which one to use. Please someone provide some feedback?

Like
SOLVED Posted: by donmontalvo

We just built a JSS on Windows Server 2012 and went with latest Java 1.8x and MySQL 5.6.x (avoided 5.7).

Like
SOLVED Posted: by were.wulff

@scottb

It's recommended to use either 5.5 or 5.6 (preferred), as specified in the Casper Suite Administrator's Guide & this KB article.
When that recommendation changes, we will update the Administrator's Guide & the KB article to reflect the change.

Amanda Wulff
JAMF Support

Like
SOLVED Posted: by scottb

We got some great assistance from Mike L. at JAMF. Everything turned out swell. Must say though that since nobody had done this on Windows before, it was nail biting and sooner things could be added to the doc above. We ended up nuking and paving both java and MySQL community server components. Created news database and imported the latest backup. All is working well and we all learned a great deal.

Like
SOLVED Posted: by luisgiraldo

Since default MySQL command for Ubuntu installs a non-supported version of MySQL, please consider updating the command in this KB article to:

sudo apt-get install mysql-server-5.6
Like
SOLVED Posted: by walts.9

I'm currently trying to install the MySQL community server to set up a test JSS on a vm running Microsoft Server 2012 r2 and have a few questions. 1. The 32bit version is the only version available at http://www.mysql.com/downloads/, will using it cause problems? The vm it will be on has a 64bit os.

  1. This is version 5.7.17 of mysql community server and there is no option for a typical install, the options are: Developer default, Server only, Client only, Full and Custom. Am I missing something or is the the wrong version of mysql community server? None of the options outline in the above instructions seem to make sense.
Like
SOLVED Posted: by arekdreyer

Update: As of March 22, 2017, Jamf 9.98 works with MySQL 5.7, and MySQL 5.7 is recommended.

To the best of my knowledge as of January 23, 2017, version 5.7 is not supported

I would not install it.

Since you're starting from https://www.mysql.com/downloads/,

  1. Click Community (GPL) Downloads (near the bottom of the page),
  2. Click "Looking for previous GA versions?"
  3. Click MySQL Community Server 5.6 »
  4. Click Download next to the "Windows (x86, 64-bit), ZIP Archive" item.

Or you could just click the link for the Windows installer for 5.6

Like
SOLVED Posted: by arekdreyer

If you're running Windows, and you want to install MySQL on a drive different than the C: drive, here's a trick. You can either: A) Use File Explorer to create a folder C:\Program Files\MySQL\MySQL Server 5.6. OR B) Run the installer and complete the installation, which installs on C:, then uninstall the program but leave the files.

Then when you run the installer (or run the installer again), you'll see the option to change the location. Weird.

Like
SOLVED Posted: by mpenrod

To install MySQL 5.7.19 on 2012r2 I had to download the x86 VS 13 Redist from: https://support.microsoft.com/en-us/help/3179560/update-for-visual-c-2013-and-visual-c-redistributable-package before the MySQL installer would complete.

Like
SOLVED Posted: by jneljeff

@mpenrod The MySQL installer told me to install the 64bit version... then failed until I installed the 32 bit version.

Like
SOLVED Posted: by AndreasWatzinger

When executing sudo add-apt-repository ppa:openjdk-r/ppa ubuntu server prompts "apt-repository: command not found". Any ideas?

Like
SOLVED Posted: by kneitzel

@AndreasWatzinger Which Distribution are you using exactly?

The application add-apt-repository must be installed first. (Often this is done by default already but if it isn't installed then you have to install it manually first.)

So on Ubuntu (12.04 and 14.04 if I am correct) the following command might help:

apt-get install software-properties-common

I hope this helped. If not: please give us more details and then we might help you, too. You could also show the output of the following command in such a case please:

dpkg -S add-apt-repository

Edit: The command to install the package must be executed as root of course, so issue the commands either directly as root or add a "sudo" before the command e.g. "sudo apt-get install ....." or "sudo dpkg -S ...."

Like
SOLVED Posted: by AndreasWatzinger

Thanks for the quck reply kneitzel. This command didn't have any effect:

apt-get install software-properties-common

This command shows the following output:

dpkg -S add-apt-repository

software-properties-common: /usr/bin/add-apt-repository
software-properties-common: /usr/share/man/man1/add-apt-repository.1.gz

Like
SOLVED Posted: by kneitzel

Can you show the output of the command

sudo apt-get install software-properties-common

so that we see what "does not have any effect" means. I see multiple possibilities e.g. it was installed already or the package is not available (might be the case if you have your own repository with only selected packages) or ....

The output of the dpkg command shows, that the package name was correct. add-apt-repository is inside of software-properties-common.

With kind regards,
Konrad

Like
SOLVED Posted: by AndreasWatzinger

Is there a way to copy paste text from the virtual machine (vm ware fusion 10). My mouse disappears when hovering over the virtual machine.

Like
SOLVED Posted: by spalmer

This documentation needs to be updated for JDK 8 Update 151 as the location to the copy the local_policy.jar and US_export_policy.jar files to has changed to:

/Library/Java/JavaVirtualMachines/jdk<version>.jdk/Contents/Home/jre/lib/security/policy/limited

There is also an "unlimited" folder located at

/Library/Java/JavaVirtualMachines/jdk<version>.jdk/Contents/Home/jre/lib/security/policy/unlimited/

so I first tried copying the unlimited local_policy.jar and US_export_policy.jar files to that folder, but the JSS didn't seem to understand that location as it came up with a startup error stating something to the effect of the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files were not installed.

Once I replaced the files in the "limited" folder and rebooted Tomcat the JSS seemed to start up correctly without any errors.

FYI, this was on a macOS server so I can't attest to whether or not this has changed when installing on Windows servers.

Like
SOLVED Posted: by tony.schaps

@spalmer THANKS so much for posting this. These instructions NEED TO BE UPDATED for Mac. I just wasted a bunch of time because I dared to RTFM and follow instructions. At the top, this (now way too long) page currently says: ...

4. Copy the local_policy.jar and US_export_policy.jar files from the extracted folder to the following location: /Library/Java/JavaVirtualMachines/jdk<version>.jdk/Contents/Home/jre/lib/security/ 5. Accept the prompt to replace the existing files.

...
The files aren't at that path anymore, so step 5 doesn't happen, and it doesn't work. The files are now in a sub-folder as @spalmer pointed out.

Please update this to save the wasted time of others who dare to follow instructions ;) Thanks!

Like
SOLVED Posted: by tony.schaps

Hey, as long as I'm at it, there are some inaccuracies in the MySQL instructions for Mac, too:

...Download the DMG archive or MySQL Community Server...

It should be "... of MySQL Community Server." That may seem like a minor error, but to someone who hasn't done this before, the word "or" could make them look for two different download options... enter confusion.

available at: [http://www.mysql.com/downloads/](link URL)

Why not send us directly right to the right page: [https://dev.mysql.com/downloads/mysql/ ](link URL) and save some time hunting and clicking?

Mount the DMG and install the MySQL package and the MySQL Startup Item package.

There is no "MySQL Startup Item package" to be found.

Add MySQL to System Preferences by double-clicking the MySQL.prefPane file.

This step is no longer necessary, it's installed in System Preferences by the installer.

Why this really irks me is that I just noticed most of it was reported over two years ago in the comments above: See––> "Posted: 9/3/15 at 2:10 PM by kitzy"

and someone from Jamf said they'd review and fix it.

That, my friends, is not the attention to detail I expect for this kind of money shelled out.

Like
SOLVED Posted: by spalmer

@tony.schaps I would encourage you to open a case with Jamf Support. I did that immediately after posting my info and they said they would test the new Java version and look into updating the instructions. But the more support cases for it the more attention it should get (hopefully).

Like
SOLVED Posted: by tony.schaps

@spalmer Thanks for the response, but I have spent enough time on this, and opening a case means more time spent. (I'm trying to be generous, I am actually thinking more "wasted" than spent).

A big benefit to software development firms of having documentation/knowledge base online is that it can be more easily maintained. But it follows that the expectation of the customer is then that the online documentation is accurate, at least more accurate than a PDF which had been created weeks or months before.

When I happened to see that this inaccurate information was reported in the comments of the article over two years ago, and you added that you opened a case and reported this a week ago, I will restate-- this is not the attention to detail I expect. How many cases must have been opened in the past two years by people who ran into the JCE policy problem and couldn't make their install work, and even that didn't spur someone on to fix it.

Again, I appreciate your response, but I'm not going to go through the whole explanation with a support agent when it would take literally five minutes for anyone at Jamf to verify our reports and escalate a case to update the knowledge base.

Thanks much--

Like
SOLVED Posted: by aaron.eccles

How many people need to waste time on this and request that you update the documentation before you actually do it?

Like
SOLVED Posted: by cj.krueger

@aaron.eccles Hey Aaron! I updated this article in January to reflect the previous concerns, but didn't make a comment at the time letting everyone know. Sorry about that! Are there any further issues with the article that we could address? Happy to start work on an update if so!

Like
SOLVED Posted: by spalmer

@cj.krueger Thanks for updating the article. After running through an update for Java 1.8.0_171 I found a few more things that might be useful information in the article.

It might be nice for those of us long time admins, who have it permanently etched into their memory to always install the JCE files, to have a brief statement of why the JCE files are no longer needed. For example, under the requirements section for Mac and Windows:

- Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files 1.8 (JDK Update 144 and earlier only). JDK 1.8.0_151 and later include the Unlimited Strength JCE files by default and JDK 1.8.0_171 and later enable the Unlimited Strength JCE files by default.

This article assumes you are installing Java and MySQL for the first time on a new JSS so, even though I have gone through this procedure several times before, I still always refer back to these instructions to update Java on our existing JSS. After performing an update to the latest version of Java it would be nice to have a reminder at the end of the instructions to restart Tomcat and verify the JCE files are correctly installed. Maybe add the following lines as the last few steps to each of the Java install sections:

7. If you are updating Java on an existing JSS you will need to restart Tomcat. See https://www.jamf.com/jamf-nation/articles/117/starting-and-stopping-tomcat. If the JCE files are not correctly installed the JSS will generate the error "Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files were not installed" (may not be correct wording) at startup (and fail to start? - I can't remember for sure). 8. After restarting Tomcat verify the JSS is using the most recently installed version of Java, by logging into your JSS as a Full JSS admin and going to Settings>Jamf Pro Information>Jamf Pro Summary and click Create. Verify the Java Version line shows the version you just installed.

You should also include instructions for removing older versions of the JDK because according to https://www.java.com/en/download/faq/remove_olderversions.xml leaving older versions of Java installed is a security risk. This only references removing older versions on Windows, but it seems like this would be a best practice for any of the supported operating systems that can run the JSS. Unfortunately, the article only gives instructions for removing them on Windows so Jamf would need to provide instructions for the other platforms.

9. After verifying everything is working with the new version of Java, the previous versions can be uninstalled. See the section titled Uninstalling Previous Java Versions After Upgrading.
Like
SOLVED Posted: by ryan.ball

According to this document (at time of writing) the recommended Linux OS is Ubuntu 18.04. The directions above do not show updated directions for installing the openjdk-8-jdk package in Ubuntu 18.04. It does not appear that the specified repository contains that package any longer. This is how I did it:

# Add the following line to /etc/apt/sources.list
deb http://security.ubuntu.com/ubuntu bionic-security main universe

then

# Run these commands to install openjdk-8-jdk
sudo apt-get update
sudo apt-get install openjdk-8-jdk
Like
SOLVED Posted: by ron.heck

This article has been updated to include instructions for Ubuntu 18.04 LTS Server.

Like
SOLVED Posted: by Dalmatian

MySQL 5.7 supports to currently JAMF PRO, the latest MySQL 8 DOSE NOT support JAMF PRO so far

Like
SOLVED Posted: by ron.heck

This article has been updated to include information about MySQL 8.0. In addition, the Requirements section now provides a link to the "Jamf Pro System Requirements" section of the Jamf Pro Administrator's Guide.

Like
SOLVED Posted: by john.roemhild

This article has been updated to include instructions for installing OpenJDK 8 on each operating system.

Like
SOLVED Posted: by mwilkerson

Why is this article not linked in this guide? I've been struggling through Ubuntu setup and installation for 2 days and I came across it via a comment in another thread/article.

Like
SOLVED Posted: by john.roemhild

This article has been updated to improve visibility of the link to the Configuring MySQL 8.0 for Jamf Pro Knowledge Base article.

Like
SOLVED Posted: by john.roemhild

This article has been updated with minor improvements to the Ubuntu and Red Hat Enterprise Linux instructions for installing OpenJDK 8.

Like
SOLVED Posted: by john.roemhild

The title of this article has been changed to “Installing Java and MySQL for Jamf Pro 10.13.0 or Earlier”, because Jamf Pro 10.14.0 or later requires Java 11. For more information, see the following Knowledge Base articles:

Like