- Jamf Nation Community
- Products
- Jamf Pro
- Re: Remote Database JSS
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Remote Database JSS
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-19-2013 02:38 PM
I looked around in the web app on both V8 and V9 and can't find a place to point to a remote database instead of using the local one. Does anyone know how to update this? Or can this only be done during install?
8 REPLIES 8
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-19-2013 02:51 PM
Shawn, do you mean a second instance of the JSS? How remote is this?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-19-2013 06:15 PM
Depends on your OS most likely but on my Ubuntu server the information is here:
/usr/local/jss/tomcat/webapps/ROOT/WEB-INF/xml/DataBase.xml
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-19-2013 10:22 PM
It's also an option when installing the JSS.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-20-2013 05:44 AM
But use caution if deploying version 9 of the JSS along with JDS as all files are first copied into the database, then copied to the JDS instances. I found this out the hard way when I was on our corporate MySQL server located in a different datacenter and I used Casper Admin to load one of our large monolithic images (20g). It was taking forever, and I got a call from the SQL admins asking why my db had grown to over 10g (specifically the downloadable_file_chunk_data table). I have since reverted to a single machine hosting both the JSS and MySQL to keep the speeds up and the phone calls from upset SQL admins down ;-)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-20-2013 07:41 AM
dmw3 - I mean that the JSS app will be on my Mac Server and the Database will be in the datacenter on one of the prod servers.
Thank you guys! I will run with this and see what happens. I haven't upgraded yet to JAMF 9 but will eventually!
Shawn
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-21-2013 01:33 PM
Wait. What? @simbimbo are you saying that if you choose to run JDS, the packages end up in the MySQL database, at least temporarily? But .. why? That makes no sense, especially if we're talking about multi GB sized files.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-21-2013 01:33 PM
Wait. What? @simbimbo are you saying that if you choose to run JDS, the packages end up in the MySQL database, at least temporarily? But .. why? That makes no sense, especially if we're talking about multi GB sized files.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 11-21-2013 01:55 PM
@hkim, yes.
The original upload will upload the file to the JSS and insert it into the mySQL database, temporarily. After it is uploaded, it will replicate out to the root JDS and then will be removed from the mySQL database. Any child JDS's will then distribute packages depending on the JDS parent/child relationships.
As for "why". I have a lot of ideas about why this likely makes the most sense, but I haven't heard anything concrete.
