Hi Kevin, I'm not a Perl wiz at all, and I'm just grasping at straws trying to troubleshoot why it isn't working.
Here is the core of the log before the lines I posted... [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) [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) [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) [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) [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) [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) [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) [Mon Jul 26 19:52:58 2010] [debug]: UserExists params: username: testuser , service: NOSMLDAP (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:274) [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) [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) [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) [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) [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) [Mon Jul 26 19:52:58 2010] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Disabled: 0, EmailAddress: test.u...@normed.ca, 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) [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) [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 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x2b88760b6e00)', 'INSERT INTO Users (Priviledged, RealName, EmailAddress, Creat...', 1, 'Test User', 'test.u...@normed.ca', 1, 'testuser', 1, '*NO-PASSWORD*', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357 DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x2b88760b6e00)', 'Users', 'Priviledged', 1, 'RealName', 'Test User', 'EmailAddress', 'test.u...@normed.ca', 'Creator', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm line 36 DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x2b88760b6e00)', 'Users', 'Priviledged', 1, 'RealName', 'Test User', 'EmailAddress', 'test.u...@normed.ca', 'Creator', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1293 DBIx::SearchBuilder::Record::Create('RT::User=HASH(0x2b8876d75580)', 'Priviledged', 1, 'RealName', 'Test User', 'Creator', 1, 'EmailAddress', 'test.u...@normed.ca', ...) called at /opt/rt3/bin/../lib/RT/Record.pm line 289 RT::Record::Create('RT::User=HASH(0x2b8876d75580)', 'id', 40, 'Priviledged', 1, 'RealName', 'Test User', 'EmailAddress', 'test.u...@normed.ca', ...) called at /opt/rt3/bin/../lib/RT/User_Overlay.pm line 195 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 RT::Authen::ExternalAuth::DoAuth('HASH(0x2b88754ecc70)', 'testuser', '<<password>>') called at /opt/rt3/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth line 25 HTML::Mason::Commands::__ANON__('pass', '<<password>>', 'user', 'testuser') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135 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 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp('undef', 'undef', 'pass', '<<password>>', 'user', 'testuser') called at /opt/rt3/bin/../lib/RT/Interface/Web/Request.pm line 180 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 RT::Interface::Web::HandleRequest('HASH(0x2b88755d3130)') called at /opt/rt3/share/html/autohandler line 53 HTML::Mason::Commands::__ANON__('pass', '<<password>>', 'user', 'testuser') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135 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 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292 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 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 433 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 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 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b8875f5ae80)', 'Apache2::RequestRec=SCALAR(0x2b887622f770)') called at /opt/rt3/bin/ webmux.pl line 78 eval {...} called at /opt/rt3/bin/webmux.pl line 78 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b887622f770)') called at -e line 0 eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Mon Jul 26 19:52:58 2010] [error]: Could not create a new user - Priviledged-1-RealName-Test user-emailaddress-test.u...@normed.ca-gecos-testuser-password-*no-password*-name-testuser-externalauthid-testuser(/opt/rt3/bin/../lib/RT/User_Overlay.pm:201) [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) 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. Sorry if I mislead in my wording. Mike. On Mon, Jul 26, 2010 at 4:12 PM, Kevin Falcone <falc...@bestpractical.com>wrote: > On Mon, Jul 26, 2010 at 04:09:01PM -0400, Mike Johnson wrote: > > Something is preventing the user from being created... based on the > INSERT language I see, it > > looks like RTFM doesn't work with 3.8.8??? I dunno, it's trying to use > a field called > > Priviledged in the User table... which doesn't exist? > > Please provide the actual failing code you're seeing. > Privileged is a user attribute stored in a different table. > Why do you believe that RTFM is causing conflicts with this? > > -kevin > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Mike Johnson Datatel Programmer/Analyst Northern Ontario School of Medicine 955 Oliver Road Thunder Bay, ON P7B 5E1 Phone: (807) 766-7331 Email: mike.john...@nosm.ca
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com