<div>Hi Kevin,</div>
<div> </div>
<div>I'm not a Perl wiz at all, and I'm just grasping at straws trying to troubleshoot why it isn't working.</div>
<div> </div>
<div>Here is the core of the log before the lines I posted...</div>
<div> </div>
<div>[Mon Jul 26 19:52:54 2010] [debug]: Reloading RT::User to work around a bug in RT-3.8.0 and RT-3.8.1 (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth:14)<br>[Mon Jul 26 19:52:54 2010] [debug]: Attempting to use external auth service: NOSMLDAP (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:64)<br>
[Mon Jul 26 19:52:54 2010] [debug]: SSO Failed and no user to test with. Nexting (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:92)<br>[Mon Jul 26 19:52:54 2010] [debug]: Autohandler called ExternalAuth. Response: (0, No User) (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth:26)<br>
[Mon Jul 26 19:52:58 2010] [debug]: Reloading RT::User to work around a bug in RT-3.8.0 and RT-3.8.1 (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth:14)<br>[Mon Jul 26 19:52:58 2010] [debug]: Attempting to use external auth service: NOSMLDAP (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:64)<br>
[Mon Jul 26 19:52:58 2010] [debug]: Calling UserExists with $username (testuser) and $service (NOSMLDAP) (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:105)<br>[Mon Jul 26 19:52:58 2010] [debug]: UserExists params:<br>
username: testuser , service: NOSMLDAP (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:274)<br>[Mon Jul 26 19:52:58 2010] [debug]: LDAP Search === Base: dc=nosm,dc=local == Filter: (&(&(objectCategory=User)(ObjectClass=Person))(sAMAccountName=testuser)) == Attrs: cn,mail,sAMAccountName,sAMAccountName (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:304)<br>
[Mon Jul 26 19:52:58 2010] [debug]: RT::Authen::ExternalAuth::CanonicalizeUserInfo called by RT::User /opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/User_Vendor.pm 20 with: Disabled: 0, EmailAddress: , Gecos: testuser, Name: testuser, Priviledged: 1, Privileged: 0 (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:450)<br>
[Mon Jul 26 19:52:58 2010] [debug]: Attempting to get user info using this external service: NOSMLDAP (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:458)<br>[Mon Jul 26 19:52:58 2010] [debug]: Attempting to use this canonicalization key: Name (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:472)<br>
[Mon Jul 26 19:52:58 2010] [debug]: LDAP Search === Base: dc=nosm,dc=local == Filter: (&(&(objectCategory=User)(ObjectClass=Person))(sAMAccountName=testuser)) == Attrs: cn,mail,sAMAccountName,sAMAccountName (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:195)<br>
[Mon Jul 26 19:52:58 2010] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Disabled: 0, EmailAddress: <a href="mailto:test.user@normed.ca">test.user@normed.ca</a>, ExternalAuthId: testuser, Gecos: testuser, Name: testuser, Priviledged: 1, Privileged: 0, RealName: Test User (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)<br>
[Mon Jul 26 19:52:58 2010] [warning]: DBD::mysql::st execute failed: Unknown column 'Priviledged' in 'field list' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509, <DATA> line 273. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)<br>
[Mon Jul 26 19:52:58 2010] [warning]: RT::Handle=HASH(0x2b88760b6e00) couldn't execute the query 'INSERT INTO Users (Priviledged, RealName, EmailAddress, Creator, Gecos, LastUpdatedBy, Password, Created, id, Name, LastUpdated, ExternalAuthId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522<br>
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x2b88760b6e00)', 'INSERT INTO Users (Priviledged, RealName, EmailAddress, Creat...', 1, 'Test User', <a href="mailto:'test.user@normed.ca'">'test.user@normed.ca'</a>, 1, 'testuser', 1, '*NO-PASSWORD*', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357<br>
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x2b88760b6e00)', 'Users', 'Priviledged', 1, 'RealName', 'Test User', 'EmailAddress', <a href="mailto:'test.user@normed.ca'">'test.user@normed.ca'</a>, 'Creator', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/<a href="http://mysql.pm">mysql.pm</a> line 36<br>
DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x2b88760b6e00)', 'Users', 'Priviledged', 1, 'RealName', 'Test User', 'EmailAddress', <a href="mailto:'test.user@normed.ca'">'test.user@normed.ca'</a>, 'Creator', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1293<br>
DBIx::SearchBuilder::Record::Create('RT::User=HASH(0x2b8876d75580)', 'Priviledged', 1, 'RealName', 'Test User', 'Creator', 1, 'EmailAddress', <a href="mailto:'test.user@normed.ca'">'test.user@normed.ca'</a>, ...) called at /opt/rt3/bin/../lib/RT/Record.pm line 289<br>
RT::Record::Create('RT::User=HASH(0x2b8876d75580)', 'id', 40, 'Priviledged', 1, 'RealName', 'Test User', 'EmailAddress', <a href="mailto:'test.user@normed.ca'">'test.user@normed.ca'</a>, ...) called at /opt/rt3/bin/../lib/RT/User_Overlay.pm line 195<br>
RT::User::Create('RT::User=HASH(0x2b8876d75580)', 'Priviledged', 1, 'Name', 'testuser', 'Gecos', 'testuser') called at /opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm line 124<br>
RT::Authen::ExternalAuth::DoAuth('HASH(0x2b88754ecc70)', 'testuser', '<<password>>') called at /opt/rt3/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth line 25<br>
HTML::Mason::Commands::__ANON__('pass', '<<password>>', 'user', 'testuser') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135<br> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x2b8875502fc0)', 'pass', '<<password>>', 'user', 'testuser') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1297<br>
eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292<br> HTML::Mason::Request::comp('undef', 'undef', 'pass', '<<password>>', 'user', 'testuser') called at /opt/rt3/bin/../lib/RT/Interface/Web/Request.pm line 180<br>
RT::Interface::Web::Request::callback('RT::Interface::Web::Request=HASH(0x2b8879903140)', 'pass', '<<password>>', 'user', 'testuser', 'CallbackName', 'Auth', 'CallbackPage', '/autohandler', ...) called at /opt/rt3/bin/../lib/RT/Interface/Web.pm line 202<br>
RT::Interface::Web::HandleRequest('HASH(0x2b88755d3130)') called at /opt/rt3/share/html/autohandler line 53<br> HTML::Mason::Commands::__ANON__('pass', '<<password>>', 'user', 'testuser') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135<br>
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x2b88754e9dd0)', 'pass', '<<password>>', 'user', 'testuser') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1297<br>
eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292<br> HTML::Mason::Request::comp('undef', 'undef', 'undef', 'pass', '<<password>>', 'user', 'testuser') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481<br>
eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481<br> eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 433<br> HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b8879903140)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168<br>
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2b8879903140)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825<br> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b8875f5ae80)', 'Apache2::RequestRec=SCALAR(0x2b887622f770)') called at /opt/rt3/bin/<a href="http://webmux.pl">webmux.pl</a> line 78<br>
eval {...} called at /opt/rt3/bin/<a href="http://webmux.pl">webmux.pl</a> line 78<br> RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b887622f770)') called at -e line 0<br> eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)<br>
[Mon Jul 26 19:52:58 2010] [error]: Could not create a new user - Priviledged-1-RealName-Test <a href="mailto:User-EmailAddress-test.user@normed.ca-Gecos-testuser-Password-*NO-PASSWORD*-Name-testuser-ExternalAuthId-testuser">User-EmailAddress-test.user@normed.ca-Gecos-testuser-Password-*NO-PASSWORD*-Name-testuser-ExternalAuthId-testuser</a> (/opt/rt3/bin/../lib/RT/User_Overlay.pm:201)<br>
[Mon Jul 26 19:52:58 2010] [error]: Couldn't create user testuser: Could not create user (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:129)</div>
<div> </div>
<div> </div>
<div> </div>
<div>Again, I am no perl wiz, and I'm just making guesses as to whats wrong based on these logs... RTFM might work with 3.8.8, I just can't get mine to work.</div>
<div> </div>
<div>Sorry if I mislead in my wording.</div>
<div> </div>
<div>Mike.<br></div>
<div class="gmail_quote">On Mon, Jul 26, 2010 at 4:12 PM, Kevin Falcone <span dir="ltr"><<a href="mailto:falcone@bestpractical.com">falcone@bestpractical.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im">On Mon, Jul 26, 2010 at 04:09:01PM -0400, Mike Johnson wrote:<br>> Something is preventing the user from being created... based on the INSERT language I see, it<br>> looks like RTFM doesn't work with 3.8.8??? I dunno, it's trying to use a field called<br>
> Priviledged in the User table... which doesn't exist?<br><br></div>Please provide the actual failing code you're seeing.<br>Privileged is a user attribute stored in a different table.<br>Why do you believe that RTFM is causing conflicts with this?<br>
<font color="#888888"><br>-kevin<br></font><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>Buy a copy at <a href="http://rtbook.bestpractical.com/" target="_blank">http://rtbook.bestpractical.com</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Mike Johnson<br>Datatel Programmer/Analyst<br>Northern Ontario School of Medicine<br>955 Oliver Road<br>Thunder Bay, ON P7B 5E1<br>Phone: (807) 766-7331<br>Email: <a href="mailto:mike.johnson@nosm.ca">mike.johnson@nosm.ca</a><br>