This may sound like a bit of a dump, newbie question... I've found the script, but how do I go about running it?
Greg -----Original Message----- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Terrill Yuhas Sent: Thursday, 5 March 2009 10:29 a.m. To: User questions and discussions about OTRS. Subject: Re: [otrs] Issues with otrs 2.3.4 and Customer LDAP Auth As you'd found out with your testing, OTRS only uses LDAP for authentication and doesn't automatically create a user account in the OTRS db. We use the script that's included in the package and (for us at least) is in /opt/otrs/scripts/tools called sync-ldap2db.pl. There are some LDAP connection variables in there you need to set but it should be ready-to-go aside from that. To keep things in sync, you'll have to periodically run the script. Terrill Jeremy Adams wrote: > Hi and greetings for the The Great State of Texas, > > Much like many of the users here, I too am new to otrs. I have successfully setup otrs 2.3.4 on openSuSE 10.3. I have successfully setup Agents via DB back end and have not issues with Agents. My issues come when I setup Customer Authentication using LDAP. All changes have been made in SysConfig. No edits have been done to Config.pl - at least edits that worked. Again Config.pm is standard. > > Currently users who exist in LDAP receive the following when attempting authentication through customer.pl: > > Panic! No UserData!!! > > But the System Log states that "CustomerUser:[username} (CN=[username]...) authentication ok... > > I have tried using scrips from the list and from Defaults.pm but still receive the same error. > > With all that said, I have created a Customer user in the DB with ONLY First Name, Last Name, and Email address. This user authenticates and loads the ticket page. So I guess there is some issue migrating user data into the DB. How is this done? Below i have attached the WHOLE of the Config.pm file. but keep in mind that this issue persists with or with out the additions to Config.pm > > Below is the output of the otrs.checkModules script and the contents of Config.pm > > cvcticketsys:/ # ./opt/otrs/bin/otrs.checkModules > o CGI............................ok (v3.15) > o Date::Pcalc....................ok (v1.2) > o Date::Format...................ok (v2.22) > o DBI............................ok (v1.58) > o DBD::mysql.....................ok (v4.005) > o Digest::MD5....................ok (v2.36) > o Crypt::PasswdMD5...............ok (v1.3) > o LWP::UserAgent.................ok (v2.036) > o IO::Scalar.....................ok (v2.110) > o IO::Wrap.......................ok (v2.110) > o MIME::Base64...................ok (v3.07) > o Mail::Internet.................ok (v2.04) > o MIME::Tools....................ok (v5.427) > o Net::DNS.......................ok (v0.65) > o Net::POP3......................ok (v2.28) > o Net::POP3::SSLWrapper.......ok (v0.02) > o Net::IMAP::Simple..............ok (v1.17) > o Net::IMAP::Simple::SSL......ok (v1.3) > o Net::SMTP......................ok (v2.29) > o Authen::SASL................ok (v2.11) > o Net::LDAP......................ok (v0.39) > o GD.............................ok (v2.35) > o GD::Text....................ok (v0.85) > o GD::Graph...................ok (v1.44) > o GD::Graph::lines............ok (v1.15) > o GD::Text::Align.............ok (v1) > o PDF::API2......................not installed! (not required / for PDF required!) > o Compress::Zlib..............ok (v2.005) > o XML::Parser....................ok (v2.34) > > Config.pm contents > > $Self->{'DatabaseHost'} = 'localhost'; > # Database > # (The database name.) > $Self->{'Database'} = 'otrs'; > # DatabaseUser > # (The database user.) > $Self->{'DatabaseUser'} = 'otrs'; > # DatabasePw > # (The password of database user. You also can use bin/CryptPassword.pl > # for crypted passwords.) > $Self->{'DatabasePw'} = 'xxxx'; > # DatabaseDSN > # (The database DSN for MySQL ==> more: "man DBD::mysql") > $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; > > # (The database DSN for PostgreSQL ==> more: "man DBD::Pg") > # if you want to use a local socket connection > # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; > # if you want to use a tcpip connection > # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};"; > > # ---------------------------------------------------- # > # fs root directory > # ---------------------------------------------------- # > $Self->{Home} = '/opt/otrs'; > > # ---------------------------------------------------- # > # insert your own config settings "here" # > # config settings taken from Kernel/Config/Defaults.pm # > # ---------------------------------------------------- # > # $Self->{SessionUseCookie} = 0; > $Self->{'CheckMXRecord'} = 1; > # customer uniq id > CustomerKey => 'uid', > # customer # > CustomerID => 'mail', > CustomerUserListFields => ['cn', 'mail'], > CustomerUserSearchFields => ['uid', 'cn', 'mail'], > CustomerUserSearchPrefix => '', > CustomerUserSearchSuffix => '*', > CustomerUserSearchListLimit => 250, > CustomerUserPostMasterSearchFields => ['mail'], > CustomerUserNameFields => ['givenname', 'sn'], > # show now own tickets in customer panel, CompanyTickets > CustomerUserExcludePrimaryCustomerID => 0, > # add a ldap filter for valid users (expert setting) > # CustomerUserValidFilter => '(!(description=gesperrt))', > # # admin can't change customer preferences > AdminSetPreferences => 0, > #added as a test from another script > # $Self->{UserSyncLDAPMap} = { > # # DB -> LDAP > # UserFirstname => 'givenname', > #3 UserLastname => 'sn', > # UserEmail => 'mail', > # }; > #$Self->{DatabaseUserTable} = 'users'; > # $Self->{DatabaseUserTableUserID} = 'id'; > # $Self->{DatabaseUserTableUserPW} = 'pw'; > # $Self->{DatabaseUserTableUser} = 'login'; > > # } > #end test add > Map => [ > # note: Login, Email and CustomerID needed! > # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly > # [ 'UserSalutation', 'Title', 'title', 1, 0, 'var', '', 0 ], > [ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var', '', 0 ], > [ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var', '', 0 ], > [ 'UserLogin', 'Username', 'name', 1, 1, 'var', '', 0 ], > [ 'UserEmail', 'Email', 'mail', 1, 1, 'var', '', 0 ], > [ 'UserCustomerID', 'CustomerID', 'mail', 0, 1, 'var', '', 0 ], > [ 'UserCustomerIDs', 'CustomerIDs', 'second_customer_ids', 1, 0, 'var', '', 0 ], > [ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var', '', 0 ], > [ 'UserAddress', 'Address', 'postaladdress', 1, 0, 'var', '', 0 ], > [ 'UserComment', 'Comment', 'description', 1, 0, 'var', '', 0 ], > ], > }; > # ---------------------------------------------------- # > > # ---------------------------------------------------- # > # data inserted by installer # > # ---------------------------------------------------- # > # $DIBI$ > $Self->{'SystemID'} = 10; > $Self->{'SecureMode'} = 1; > $Self->{'Organization'} = 'Cedar Valley College'; > $Self->{'LogModule::LogFile'} = '/tmp/otrs.log'; > $Self->{'LogModule'} = 'Kernel::System::Log::SysLog'; > $Self->{'FQDN'} = 'cvcticketsys.cvc.educ.dcccd.edu'; > $Self->{'DefaultLanguage'} = 'en'; > $Self->{'AdminEmail'} = 'jeremyad...@dcccd.edu'; > $Self->{'DefaultCharset'} = 'utf-8'; > > # ---------------------------------------------------- # > # ---------------------------------------------------- # > # # > # End of your own config options!!! # > # # > # ---------------------------------------------------- # > # ---------------------------------------------------- # > > > # ---------------------------------------------------- # > # needed system stuff (don't edit this) # > # ---------------------------------------------------- # > #} > use strict; > use warnings; > > use vars qw(@ISA $VERSION); > use Kernel::Config::Defaults; > push (@ISA, 'Kernel::Config::Defaults'); > > use vars qw(@ISA $VERSION); > $VERSION = qw($Revision: 1.20 $)[1]; > > # -----------------------------------------------------# > > 1; > > > > Thanks for any and all assistance, > > > > > > > Jeremy Adams > PC Support Specialist I > Cedar Valley College > 972.860.8086 > > > > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ > > --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/