Searchable FAQ or Discussion?

I found their Knowledgebase online to be helpful, could use more content though. . . .
http://jamfsoftware.com/kb
-Nathaniel

I just deployed 6 new Casper servers, 1 JSS and 5 new distribution points. I built them as stand alone from scratch and it was pretty painless. The documentation in the Casper Suite DMG file is pretty decent as well. This mailing list has a bunch of good resources too. Don't feel bad about asking any questions either. Half of the time I post questions to the mailing list I figure the answer out myself in a few hours and then sometimes post it. Or someone will email me the answer I was looking for.

That is what it is for. So, just ask away your questions.

Thanks for the link Nathaniel and the welcome Thomas.

The error I am seeing specifically after installing 6.014 (the latest Tomcat update) is this:

Error looking up jss_settings: java.sql.SQLException: Column 'smtp_is_secure' not found.

That is placed above the login window in my web admin using FIrefox, Safari and Opera (so it doesn't appear to be a browser specific error). When I go to my Server Admin utility and select the MySQL tab, it shows no errors in the log or any settings that can be changed regarding smtp security.

Sorry if this is an issue that is simple and common knowledge, but I really am a new server admin with little experience with Leopard Server.

Ron Prue
Technical Services
Noah Corporation
w.435.214.2927
f.435.645.3936
http://www.mynoahs.com

Is it part of an open directory or stand alone? How did you set up 10.5 server? Basic, advanced, or whatever option you used.

I am running the most up to date JSS and have 10.5 but my server is stand alone and not part of the Directory, and it works great.

Hi Ron,

I have an Xserve installed as an advanced server, since it does more than one thing. Bound to Active Directory.

You had to do a separate install of TomCat, or an upgrade? The JSS Setup Utility pretty much has taken care of everything, and in terms of the install portion I've not seen a problem in a long time, and I've reloaded it a few times moving things around and what not. It appears part of the setup script may have no completed properly for the database.

I would go back into the JSS Setup Util first, click Uninstall JSS, check Drop Database, click uninstall, and then try install the database again. Or you could check all those options, wipe out the JSS, and start over. Have you tried this already?

Otherwise, is this a machine you can start over on, and see if the same thing happens?

The support folks can be very helpful as well, unfortunately it's a holiday weekend.

Craig Ernst
Systems Management & Configuration
----------------------------------
University of Wisconsin-Eau Claire
Learning & Technology Services
105 Garfield Ave
Eau Claire, WI 54701
Phone: (715) 836-3639
Fax: (715) 836-6001
----------------------------------
ernstcs at uwec.edu

On 8/29/08 4:09 PM, "Thomas Larkin" <tlarki at kckps.org> wrote:

Is it part of an open directory or stand alone? How did you set up 10.5 server? Basic, advanced, or whatever option you used.

I am running the most up to date JSS and have 10.5 but my server is stand alone and not part of the Directory, and it works great.

Ron,

I'm going to drop in here since I believe the error message is suggesting that there is a column in the jss_settings table from your jamfsoftware database is missing.

I would start by making a backup of your current database structure with the JSS Setup Utility. There was an upgrade script that should have run as part of the upgrade process from 5.13 to 6.0 that would have added this column into the jss_settings table for you, but the script can also be run through the JSS Setup Utility by clicking the "Export Components" button, then "Database Upgrade 5.13-->6.0".

This will export a script that can then be run through the JSS Setup Utility by clicking "Database" in the "Servers & Services" pane, then clicking the "Troubleshooting" tab at the bottom of the setup utility, then clicking "Run a Script." There may be some errors returned as a result of running the script if the upgrade process partially upgraded the database, but it shouldn't be destructive.

If this process does not resolve the issue, feel free to contact JAMF Support at 612-216-1296 or submit an email to support at jamfsoftware.com.

Hope this helps!

Nick Amundsen
Product Specialist
.............................................................
JAMF Software
1011 Washington Ave S. #350
Minneapolis, MN 55415
.............................................................
US Support (612) 216-1296
UK Support (020) 3002 3907
support at jamfsoftware.com
.............................................................
http://www.jamfsoftware.com

That worked beautifully. I can now login to the Web Admin. Thanks for the help everyone.

Ron Prue
Technical Services
Noah Corporation
w.435.214.2927
f.435.645.3936
http://www.mynoahs.com

Yeah, that Nick guy is da bomb (I wanted to say something that rhymes with HIT, but figured it was not appropriate). The responses you got, Ron, are normal. Usually quick. Don't normally see a JAMF person respond on here, but I get it...let the community help each other out and grow. =)

And for those that celebrate it, have a great Labor Day Weekend.
And for those in education and classes start next week Tuesday, I hope you aren't working all weekend.
And for those using digest mode I trimmed my post. =P

Craig E