Hi All
I am having an issue with new users first time logging into the VCL landing
page successfully but when the user us tries to create a new reservation the
error that is emailed to the admin is 'Error with VCL Pages (301)' and the user
sees 'You don't have access to any environments and, therefore, cannot make any
reservations.' There is nothing unique with the user compared to another user
in the same LDAP group.
The error email is shown below. If the same user tries to log in again another
error email is sent which will be attached below as well.
First error log email :
Duplicate entry 'cn=Business
Administration,ou=Major,o=poets.whittier.edu,o=c-3' for key 2
INSERT INTO usergroup (name, affiliationid, custom, courseroll) VALUES
('cn=Business Administration,ou=Major,o=poets.whittier.edu,o=cp', 3, 0, 0)
ERROR(301): Failed to execute query 2 in updateGroup Mode was submitLogin
Backtrace:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:submitLogin() (line#:90)
Call#:2 => authentication.php:ldapLogin() (line#:340)
Call#:3 => authentication.php:updateLDAPUser() (line#:434)
Call#:4 => ldapauth.php:updatewcldapGroups() (line#:266)
Call#:5 => ldapauth.php:getUserGroupID() (line#:447)
Call#:6 => utils.php:doQuery() (line#:8232)
Backtrace with Arguments:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:submitLogin() (line#:90)
Arguments(none):
-----------------------
Call#:2 => authentication.php:ldapLogin() (line#:340)
Arguments(3)
Argument#: 1 => Whittier Username
Argument#: 2 => ncurtice
Argument#: 3 => #(password hidden)
-----------------------
Call#:3 => authentication.php:updateLDAPUser() (line#:434)
Arguments(2)
Argument#: 1 => Whittier Username
Argument#: 2 => ncurtice
-----------------------
Call#:4 => ldapauth.php:updatewcldapGroups() (line#:266)
Arguments(1)
Argument#: 1 => Array
(
[unityid] => ncurtice
[affiliationid] => 3
[affiliation] => wcldap
[firstname] => Nicholas
[lastname] => Curtice
[preferredname] =>
[email] => [email protected]<mailto:[email protected]>
[IMtype] => none
[IMid] =>
[uid] =>
[id] => 42
[width] => 1024
[height] => 768
[bpp] => 16
[audiomode] => local
[mapdrives] => 1
[mapprinters] => 1
[mapserial] => 0
[showallgroups] => 0
[lastupdated] => 2014-04-04 14:29:47
)
-----------------------
Call#:5 => ldapauth.php:getUserGroupID() (line#:447)
Arguments(2)
Argument#: 1 => cn=Business Administration,ou=Major,o=poets.whittier.edu,o=cp
Argument#: 2 => 3
-----------------------
Call#:6 => utils.php:doQuery() (line#:8232)
Arguments(2)
Argument#: 1 => INSERT INTO usergroup (name, affiliationid, custom, courseroll)
VALUES ('cn=Business Administration,ou=Major,o=poets.whittier.edu,o=cp', 3, 0,
0)
Argument#: 2 => 301
-----------------------
Second email if user attempts to login again:
Duplicate entry 'cn=Business
Administration,ou=Major,o=poets.whittier.edu,o=c-3' for key 2
INSERT INTO usergroup (name, affiliationid, custom, courseroll) VALUES
('cn=Business Administration,ou=Major,o=poets.whittier.edu,o=cp', 3, 0, 0)
ERROR(301): Failed to execute query 2 in updateGroup Mode was main
Backtrace:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:initGlobals() (line#:58)
Call#:2 => utils.php:getUserInfo() (line#:209)
Call#:3 => utils.php:updateUserData() (line#:3424)
Call#:4 => utils.php:updateLDAPUser() (line#:3604)
Call#:5 => ldapauth.php:updatewcldapGroups() (line#:266)
Call#:6 => ldapauth.php:getUserGroupID() (line#:447)
Call#:7 => utils.php:doQuery() (line#:8232)
Backtrace with Arguments:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:initGlobals() (line#:58)
Arguments(none):
-----------------------
Call#:2 => utils.php:getUserInfo() (line#:209)
Arguments(1)
Argument#: 1 => ncurtice@wcldap
-----------------------
Call#:3 => utils.php:updateUserData() (line#:3424)
Arguments(3)
Argument#: 1 => ncurtice
Argument#: 2 => loginid
Argument#: 3 => 3
-----------------------
Call#:4 => utils.php:updateLDAPUser() (line#:3604)
Arguments(2)
Argument#: 1 => Whittier Username
Argument#: 2 => ncurtice
-----------------------
Call#:5 => ldapauth.php:updatewcldapGroups() (line#:266)
Arguments(1)
Argument#: 1 => Array
(
[IMtype] => none
[IMid] =>
[affiliationid] => 3
[affiliation] => wcldap
[shibonly] => 0
[emailnotices] => 1
[preferredname] =>
[uid] =>
[id] => 42
[width] => 1024
[height] => 768
[bpp] => 16
[audiomode] => local
[mapdrives] => 1
[mapprinters] => 1
[mapserial] => 0
[showallgroups] => 0
[unityid] => ncurtice
[firstname] => Nicholas
[lastname] => Curtice
[email] => [email protected]<mailto:[email protected]>
[lastupdated] => 2014-04-07 08:55:46
)
-----------------------
Call#:6 => ldapauth.php:getUserGroupID() (line#:447)
Arguments(2)
Argument#: 1 => cn=Business Administration,ou=Major,o=poets.whittier.edu,o=cp
Argument#: 2 => 3
-----------------------
Call#:7 => utils.php:doQuery() (line#:8232)
Arguments(2)
Argument#: 1 => INSERT INTO usergroup (name, affiliationid, custom, courseroll)
VALUES ('cn=Business Administration,ou=Major,o=poets.whittier.edu,o=cp', 3, 0,
0)
Argument#: 2 => 301
-----------------------
-
Richard Lo
Systems Manager
IT Services
Whittier College
13406 E. Philadephia Street
Whittier, CA 90601
phone. 562-907-4881
[email protected]<mailto:[email protected]>
