[Casper] Searchable FAQ or Discussion?

[Nick Amundsen]

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


On 8/29/08 3:41 PM, "Ron Prue" <ron.prue at mynoahs.com> wrote:

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 <http://www.mynoahs.com/>


[cid:3302872453_2619559]

On Aug 29, 2008, at 2:24 PM, Thomas Larkin wrote:

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.

Ron Prue <ron.prue at mynoahs.com> 08/29/08 2:58 PM >>>
I am new to Casper and seem to be having difficulty with some of the
most basic and mundane operations (ie, JSS installation on Leopard
Server, Web admin authentication problems).  I am trying to be as self
sufficient as possible while I am learning so I was wondering if there
is another resource that is searchable that I can glean some
information from.  Googling the errors does nothing and the Casper
site does not seem to point anywhere other than this list and a
Jumpstart session.

Any direction would be much appreciated.


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





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.jamfsoftware.com/pipermail/casper/attachments/20080829/0f4ccfd0/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 11936 bytes
Desc: image.png
Url : http://list.jamfsoftware.com/pipermail/casper/attachments/20080829/0f4ccfd0/attachment-0001.png