Unable to authenticate with Active Directory

koti · Post by **koti** » 13 May 2013, 10:37

Hi,

Installed version 3.2.5 using Windows installer and able to log in root@localhost. After adding ldap information to config.pm file unable to log in using both ad user names and root@localhost. The error message is Login failed! Your username or password was entered incorrectly.

Thank you,
Koti

Following is the config.pm

Code: Select all

# --
# Kernel/Config.pm - Config file for OTRS kernel
# Copyright (C) 2001-2013 xxx, http://otrs.org/
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
#  Note:
#
#  -->> Most OTRS configuration should be done via the OTRS web interface
#       and the SysConfig. Only for some configuration, such as database
#       credentials and customer data source changes, you should edit this
#       file. For changes do customer data sources you can copy the definitions
#       from Kernel/Config/Defaults.pm and paste them in this file.
#       Config.pm will not be overwritten when updating OTRS.
# --

package Kernel::Config;

use strict;
use warnings;
use utf8;

sub Load {
    my $Self = shift;

    # ---------------------------------------------------- #
    # database settings                                    #
    # ---------------------------------------------------- #

    # The database host
    $Self->{'DatabaseHost'} = "localhost";

    # The database name
    $Self->{'Database'} = "otrs";

    # The database user
    $Self->{'DatabaseUser'} = "otrs";

    # The password of database user. You also can use bin/otrs.CryptPassword.pl
    # for crypted passwords
    $Self->{'DatabasePw'} = 'idaK!*_U27z20e33';

    # The database DSN for MySQL ==> more: "perldoc DBD::mysql"
    $Self->{'DatabaseDSN'} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost}";

    # The database DSN for PostgreSQL ==> more: "perldoc DBD::Pg"
    # if you want to use a local socket connection
#    $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};";
    # if you want to use a TCP/IP connection
#    $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};";
    # if you have PostgresSQL 8.1 or earlier, activate the legacy driver with this line:
#    $Self->{DatabasePostgresqlBefore82} = 1;

    # The database DSN for Microsoft SQL Server - only supported if OTRS is
    # installed on Windows as well
#    $Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Database=$Self->{Database};Server=$Self->{DatabaseHost},1433";

    # The database DSN for Oracle ==> more: "perldoc DBD::oracle"
#    $ENV{ORACLE_HOME} = '/u01/app/oracle/product/10.2.0/client_1';
#    $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
#    $ENV{NLS_LANG} = "american_america.utf8";

#    $Self->{DatabaseDSN} = "DBI:Oracle:sid=OTRS;host=$Self->{DatabaseHost};port=1522;";

    # ---------------------------------------------------- #
    # fs root directory
    # ---------------------------------------------------- #
    $Self->{Home} = 'E:/PROGRA~1/OTRS/OTRS';

    # ---------------------------------------------------- #
    # insert your own config settings "here"               #
    # config settings taken from Kernel/Config/Defaults.pm #
    # ---------------------------------------------------- #
    # $Self->{SessionUseCookie} = 0;
    # $Self->{CheckMXRecord} = 0;

    # ---------------------------------------------------- #

    # ---------------------------------------------------- #
    # data inserted by installer                           #
    # ---------------------------------------------------- #

    $Self->{'LogModule'}          = 'Kernel::System::Log::File';
    $Self->{'LogModule::LogFile'} = 'E:/PROGRA~1/OTRS/OTRS/var/log/otrs.log';
    # $DIBI$
  # This is an example configuration for using an MS AD backend
    $Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP';
    $Self->{'AuthModule::LDAP::Host'} = 'dc.xyz.net.au';
    $Self->{'AuthModule::LDAP::BaseDN'} = 'dc=xyz,dc=net,dc=au';
    $Self->{'AuthModule::LDAP::UID'} = 'sAMAccountName';
 
    # Check if the user is allowed to auth in a posixGroup
    # (e. g. user needs to be in a group OTRS_Agents to use otrs)
    $Self->{'AuthModule::LDAP::GroupDN'} = 'CN=otrs_agents,CN=Users,DC=xyz,DC=net,DC=au';
    $Self->{'AuthModule::LDAP::AccessAttr'} = 'memberuid';
    $Self->{'AuthModule::LDAP::UserAttr'} = 'DN';
 
    # Bind credentials to log into AD
    $Self->{'AuthModule::LDAP::SearchUserDN'} = 'CN=OTRS,OU=users,DC=xyz,DC=net,DC=au';
    $Self->{'AuthModule::LDAP::SearchUserPw'} = 'xyz';
 
    # in case you want to add always one filter to each ldap query, use
    # this option. e. g. AlwaysFilter => '(mail=*)' or AlwaysFilter => '(objectclass=user)'
    $Self->{'AuthModule::LDAP::AlwaysFilter'} = '';
 
    # in case you want to add a suffix to each login name,  then
    # you can use this option. e. g. user just want to use user but
    # in your ldap directory exists user@domain.
    #$Self->{'AuthModule::LDAP::UserSuffix'} = '';
 
    # Net::LDAP new params (if needed - for more info see perldoc Net::LDAP)
    $Self->{'AuthModule::LDAP::Params'} = {
        port => 389,
        timeout => 120,
        async => 0,
        version => 3,
    };
 
   # Now sync data with OTRS DB
    $Self->{'AuthSyncModule'} = 'Kernel::System::Auth::Sync::LDAP';
    $Self->{'AuthSyncModule::LDAP::Host'} = 'dc.xyz.net.au';
    $Self->{'AuthSyncModule::LDAP::BaseDN'} = 'dc=xyz,dc=net,dc=au';
    $Self->{'AuthSyncModule::LDAP::UID'} = 'sAMAccountName';
    $Self->{'AuthSyncModule::LDAP::SearchUserDN'} = 'CN=OTRS,OU=users,DC=xyz,DC=net,DC=au';
    $Self->{'AuthSyncModule::LDAP::SearchUserPw'} = 'xyz';
 
    $Self->{'AuthSyncModule::LDAP::UserSyncMap'} = {
        # DB -> LDAP
        UserFirstname => 'givenName',
        UserLastname  => 'sn',
        UserEmail     => 'mail',
    };
 
    # AuthSyncModule::LDAP::UserSyncInitialGroups
    # (sync following group with rw permission after initial create of first agent
    # login)
    $Self->{'AuthSyncModule::LDAP::UserSyncInitialGroups'} = [
        'users',
    ];



    # ---------------------------------------------------- #
    # ---------------------------------------------------- #
    #                                                      #
    # end of your own config options!!!                    #
    #                                                      #
    # ---------------------------------------------------- #
    # ---------------------------------------------------- #
}

# ---------------------------------------------------- #
# needed system stuff (don't edit this)                #
# ---------------------------------------------------- #
use strict;
use warnings;

use vars qw(@ISA);

use Kernel::Config::Defaults;
push (@ISA, 'Kernel::Config::Defaults');

# -----------------------------------------------------#

1;

KlausNehrer · Post by **KlausNehrer** » 13 May 2013, 10:42

deactivate ad auth, create a admin user in otrs with same name in your ad. activate ad auth.
check your logs.

koti · Post by **koti** » 13 May 2013, 13:17

thank you for the reply, is there any script to test ldap authentication, another thing I forgot to mention was under var directory log files do not have any errors related to bad password or ad authentication.

Post by **crythias** » 13 May 2013, 14:14

koti wrote:var directory log files do not have any errors related to bad password or ad authentication.

This seems unreasonable. If the logs aren't in a file called otrs.log for Windows, the logs might be in Event Viewer.

koti · Post by **koti** » 14 May 2013, 07:23

Hi Kalusnehrer,

I did as per your advice and it did not work. Also the log file is not logging the errors or in system log.

regards,
koti

Post by **crythias** » 14 May 2013, 14:03

koti wrote:it did not work

What happened? Did the computer blow up?

I can't solve "it did not work".

Login failed! Your username or password was entered incorrectly.

This means what it says. Your backend didn't like your login/password. Alternatively, it's unable to parse group membership.

Are you checking /index.pl or customer.pl?
Your log file is: E:/PROGRA~1/OTRS/OTRS/var/log/otrs.log
you're looking for membership in a group: otrs_agents
you are looking for memberuid as a group attribute. Try "member"

koti · Post by **koti** » 16 May 2013, 09:54

Hi,

I have tried with both member and memberuid.

I have enabled auditing on Active Directory server and can only see the searchuser authenticating but there is no trace of log in details of agent who is a member of the otrs_agents trying to validate against AD.
Is there any way I can create .pl file and pass the required parameters for AD and other things to see what response I get from AD.

Thank you for the help.

Following is the otrs.log file

Code: Select all

[Mon May 13 16:52:11 2013][Error][Kernel::System::DB::new][224] Access denied for user 'otrs'@'localhost' (using password: YES)
[Mon May 13 16:57:33 2013][Notice][Kernel::System::User::SetPassword] User: 'root@localhost' changed password successfully!
[Mon May 13 17:20:05 2013][Notice][main::_Start] Scheduler Service is starting...!
[Mon May 13 17:20:06 2013][Notice][main::_Start] Scheduler Service start! PID 2244
[Mon May 13 17:31:13 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Mon May 13 17:31:14 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Mon May 13 17:31:15 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Mon May 13 17:31:16 2013][Notice][main::_Start] Scheduler Service is starting...!
[Mon May 13 17:31:17 2013][Notice][main::_Start] Scheduler Service start! PID 2580
[Mon May 13 17:31:31 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Mon May 13 17:31:32 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Mon May 13 17:31:33 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Mon May 13 17:31:34 2013][Notice][main::_Start] Scheduler Service is starting...!
[Mon May 13 17:31:35 2013][Notice][main::_Start] Scheduler Service start! PID 268
[Mon May 13 17:31:44 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Mon May 13 17:31:45 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/268)!
[Mon May 13 17:31:46 2013][Notice][main::_Start] Scheduler Service is starting...!
[Mon May 13 17:31:47 2013][Notice][main::_Start] Scheduler Service start! PID 268
[Mon May 13 17:31:47 2013][Error][main::_AutoStop][685] Process could not be found in the process table!
Scheduler is stopping...!

[Mon May 13 17:31:47 2013][Notice][main::_Stop] Scheduler Service stop! PID 268
[Mon May 13 17:36:36 2013][Notice][main::_Start] Scheduler Service is starting...!
[Mon May 13 17:36:37 2013][Notice][main::_Start] Scheduler Service start! PID 1196
[Mon May 13 17:51:40 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Mon May 13 17:51:41 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Mon May 13 17:51:41 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Mon May 13 17:51:42 2013][Notice][main::_Start] Scheduler Service is starting...!
[Mon May 13 17:51:43 2013][Notice][main::_Start] Scheduler Service start! PID 1760
[Tue May 14 11:32:44 2013][Error][Kernel::System::User::UserAdd][349] Need UserFirstname!
[Tue May 14 11:35:13 2013][Error][Kernel::System::User::UserAdd][349] Need UserFirstname!
[Tue May 14 11:35:31 2013][Error][Kernel::System::User::UserAdd][349] Need UserLastname!
[Tue May 14 11:36:00 2013][Notice][Kernel::System::User::UserAdd] User: 'otrssearch' ID: '2' created successfully (1)!
[Tue May 14 11:36:00 2013][Notice][Kernel::System::User::SetPassword] User: 'otrssearch' changed password successfully!
[Tue May 14 11:37:49 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 11:37:51 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 11:37:51 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 11:37:52 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 11:37:53 2013][Notice][main::_Start] Scheduler Service start! PID 2912
[Tue May 14 11:38:14 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Tue May 14 11:38:17 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 11:38:17 2013][Notice][main::_Stop] Scheduler Service stop! PID 2912
[Tue May 14 11:38:18 2013][Notice][main::_Start] Scheduler Service start! PID 2856
[Tue May 14 11:39:03 2013][Error][Kernel::System::User::UserAdd][374] Duplicate entry 'otrssearch' for key 'users_login', SQL: 'INSERT INTO users (title, first_name, last_name,  login, pw,  valid_id, create_time, create_by, change_time, change_by) VALUES  (?, ?, ?, ?, ?, ?, 
        '2013-05-14 11:39:03'
    , ?, 
        '2013-05-14 11:39:03'
    , ?)'
[Tue May 14 11:39:03 2013][Error][Kernel::System::Group::GroupMemberAdd][396] Need UID!
[Tue May 14 11:42:41 2013][Notice][Kernel::System::User::SetPassword] User: 'root@localhost' changed password successfully!
[Tue May 14 11:43:10 2013][Notice][Kernel::System::User::SetPassword] User: 'otrssearch' changed password successfully!
[Tue May 14 12:10:03 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 12:10:04 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 12:14:18 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:14:19 2013][Notice][main::_Start] Scheduler Service start! PID 1484
[Tue May 14 12:20:02 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 12:20:04 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 12:21:08 2013][Error][Kernel::System::DB::new][224] Access denied for user 'otrs'@'localhost' (using password: YES)
[Tue May 14 12:21:44 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:21:45 2013][Notice][main::_Start] Scheduler Service start! PID 828
[Tue May 14 12:22:28 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 12:22:30 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 12:22:30 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 12:22:31 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:22:32 2013][Notice][main::_Start] Scheduler Service start! PID 840
[Tue May 14 12:32:46 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 12:32:48 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 12:32:49 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 12:32:50 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:32:51 2013][Notice][main::_Start] Scheduler Service start! PID 556
[Tue May 14 12:33:02 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Tue May 14 12:33:03 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/556)!
[Tue May 14 12:33:04 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:33:05 2013][Notice][main::_Start] Scheduler Service start! PID 556
[Tue May 14 12:33:05 2013][Error][main::_AutoStop][685] Process could not be found in the process table!
Scheduler is stopping...!

[Tue May 14 12:33:05 2013][Notice][main::_Stop] Scheduler Service stop! PID 556
[Tue May 14 12:36:23 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:36:24 2013][Notice][main::_Start] Scheduler Service start! PID 1656
[Tue May 14 12:38:42 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/1656)!
[Tue May 14 12:38:43 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:38:44 2013][Notice][main::_Start] Scheduler Service start! PID 1656
[Tue May 14 12:50:07 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 12:50:08 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 12:50:09 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 12:50:10 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:50:11 2013][Notice][main::_Start] Scheduler Service start! PID 2108
[Tue May 14 12:50:39 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Tue May 14 12:50:41 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:50:42 2013][Notice][main::_Stop] Scheduler Service stop! PID 2108
[Tue May 14 12:50:42 2013][Notice][main::_Start] Scheduler Service start! PID 1776
[Tue May 14 12:51:34 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/1776)!
[Tue May 14 12:51:35 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 12:51:36 2013][Notice][main::_Start] Scheduler Service start! PID 1776
[Tue May 14 13:02:09 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/1776)!
[Tue May 14 13:02:10 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 13:02:11 2013][Notice][main::_Start] Scheduler Service start! PID 1776
[Tue May 14 13:20:56 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 13:20:57 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 13:20:58 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 13:20:59 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 13:21:00 2013][Notice][main::_Start] Scheduler Service start! PID 348
[Tue May 14 13:28:29 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 13:28:30 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 13:28:31 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 13:28:32 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 13:28:33 2013][Notice][main::_Start] Scheduler Service start! PID 876
[Tue May 14 13:28:44 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 13:28:45 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 13:28:46 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 13:28:47 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 13:28:48 2013][Notice][main::_Start] Scheduler Service start! PID 1760
[Tue May 14 15:31:47 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 15:31:48 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 15:31:49 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 15:31:50 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 15:31:51 2013][Notice][main::_Start] Scheduler Service start! PID 2176
[Tue May 14 15:32:06 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Tue May 14 15:32:07 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/2176)!
[Tue May 14 15:32:08 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 15:32:09 2013][Notice][main::_Start] Scheduler Service start! PID 2176
[Tue May 14 15:32:09 2013][Error][main::_AutoStop][685] Process could not be found in the process table!
Scheduler is stopping...!

[Tue May 14 15:32:09 2013][Notice][main::_Stop] Scheduler Service stop! PID 2176
[Tue May 14 17:12:42 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 17:12:43 2013][Notice][main::_Start] Scheduler Service start! PID 2420
[Tue May 14 17:19:32 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 17:19:34 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 17:20:51 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 17:20:52 2013][Notice][main::_Start] Scheduler Service start! PID 1352
[Tue May 14 17:22:07 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Tue May 14 17:22:08 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Tue May 14 17:22:09 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Tue May 14 17:22:10 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 17:22:11 2013][Notice][main::_Start] Scheduler Service start! PID 2320
[Tue May 14 17:22:21 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Tue May 14 17:22:24 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 17:22:24 2013][Notice][main::_Stop] Scheduler Service stop! PID 2320
[Tue May 14 17:22:25 2013][Notice][main::_Start] Scheduler Service start! PID 2360
[Tue May 14 17:24:21 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/2360)!
[Tue May 14 17:24:22 2013][Notice][main::_Start] Scheduler Service is starting...!
[Tue May 14 17:24:23 2013][Notice][main::_Start] Scheduler Service start! PID 2360
[Wed May 15 10:43:38 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Wed May 15 10:43:39 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Wed May 15 10:43:40 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Wed May 15 10:43:41 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 10:43:42 2013][Notice][main::_Start] Scheduler Service start! PID 2540
[Wed May 15 10:47:51 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/2540)!
[Wed May 15 10:47:53 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 10:47:54 2013][Notice][main::_Start] Scheduler Service start! PID 2540
[Wed May 15 11:51:00 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Wed May 15 11:51:01 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Wed May 15 11:51:02 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Wed May 15 11:51:03 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 11:51:04 2013][Notice][main::_Start] Scheduler Service start! PID 1604
[Wed May 15 11:51:37 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Wed May 15 11:51:38 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/1604)!
[Wed May 15 11:51:39 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 11:51:40 2013][Notice][main::_Start] Scheduler Service start! PID 1604
[Wed May 15 11:51:40 2013][Error][main::_AutoStop][685] Process could not be found in the process table!
Scheduler is stopping...!

[Wed May 15 11:51:40 2013][Notice][main::_Stop] Scheduler Service stop! PID 1604
[Wed May 15 13:07:21 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 13:07:22 2013][Notice][main::_Start] Scheduler Service start! PID 2264
[Wed May 15 13:09:46 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Wed May 15 13:09:46 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID otrs.Scheduler, because it's already running (OTRS/2264)!
[Wed May 15 13:09:47 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 13:09:48 2013][Notice][main::_Start] Scheduler Service start! PID 2264
[Wed May 15 13:09:48 2013][Error][main::_AutoStop][685] Process could not be found in the process table!
Scheduler is stopping...!

[Wed May 15 13:09:49 2013][Notice][main::_Stop] Scheduler Service stop! PID 2264
[Wed May 15 13:40:01 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 13:40:02 2013][Notice][main::_Start] Scheduler Service start! PID 2148
[Wed May 15 14:08:45 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Wed May 15 14:08:46 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Wed May 15 14:08:48 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Wed May 15 14:08:49 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 14:08:50 2013][Notice][main::_Start] Scheduler Service start! PID 1272
[Wed May 15 14:09:33 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Wed May 15 14:09:36 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 14:09:37 2013][Notice][main::_Stop] Scheduler Service stop! PID 1272
[Wed May 15 14:09:37 2013][Notice][main::_Start] Scheduler Service start! PID 2160
[Wed May 15 14:47:28 2013][Notice][main::_Start] Scheduler Service is stopping...!
[Wed May 15 14:47:31 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 14:47:32 2013][Notice][main::_Stop] Scheduler Service stop! PID 2160
[Wed May 15 14:47:32 2013][Notice][main::_Start] Scheduler Service start! PID 2540
[Wed May 15 14:53:28 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Wed May 15 14:53:29 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Wed May 15 14:53:30 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Wed May 15 14:53:31 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 14:53:32 2013][Notice][main::_Start] Scheduler Service start! PID 320
[Wed May 15 15:25:57 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Wed May 15 15:25:58 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Wed May 15 15:25:59 2013][Error][Kernel::System::DB::new][224] Access denied for user 'otrs'@'localhost' (using password: NO)
[Wed May 15 15:26:14 2013][Error][Kernel::System::DB::new][224] Access denied for user 'otrs'@'localhost' (using password: NO)
[Wed May 15 15:26:56 2013][Error][Kernel::System::DB::new][224] Access denied for user 'otrs'@'localhost' (using password: YES)
[Wed May 15 15:27:20 2013][Notice][main::_Start] Scheduler Service is starting...!
[Wed May 15 15:27:21 2013][Notice][main::_Start] Scheduler Service start! PID 1868
[Thu May 16 11:50:43 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Thu May 16 11:50:45 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Thu May 16 11:50:46 2013][Error][main::_AutoRestart][666] Could not start-up new Scheduler instance.
[Thu May 16 11:50:47 2013][Notice][main::_Start] Scheduler Service is starting...!
[Thu May 16 11:50:48 2013][Notice][main::_Start] Scheduler Service start! PID 2732
[Thu May 16 11:51:36 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! 
Scheduler is restarting...!

[Thu May 16 11:51:37 2013][Notice][main::_AutoRestart] Scheduler service is stopping due a restart.
[Thu May 16 11:51:38 2013][Notice][main::_Start] Scheduler Service is starting...!
[Thu May 16 11:51:39 2013][Notice][main::_Start] Scheduler Service start! PID 2992

SchedulerERR-1368595639

Code: Select all

DBI connect('database=otrs;host=localhost','otrs',...) failed: Access denied for user 'otrs'@'localhost' (using password: NO) at E:/PROGRA~1/OTRS/OTRS/Kernel/System/DB.pm line 253.
ERROR: OTRS-otrs.Scheduler-43 Perl: 5.16.3 OS: MSWin32 Time: Wed May 15 15:25:59 2013

 Message: Access denied for user 'otrs'@'localhost' (using password: NO)

 Traceback (2988): 
   Module: Kernel::System::DB::new (OTRS 3.2.5) Line: 224
   Module: main::_CommonObjects (unknown version) Line: 607
   Module: E:\PROGRA~1\OTRS\OTRS\bin\otrs.Scheduler4win.pl (unknown version) Line: 179

Got no DBObject! at E:/PROGRA~1/OTRS/OTRS/Kernel/System/PID.pm line 78.

Post by **crythias** » 16 May 2013, 12:57

Well, you're right. But the scheduler service needs to be fixed, too. For some reason it doesn't see a password entry for your database in Config.pm

But
[Tue May 14 11:32:44 2013][Error][Kernel::System::User::UserAdd][349] Need UserFirstname!
[Tue May 14 11:35:13 2013][Error][Kernel::System::User::UserAdd][349] Need UserFirstname!
[Tue May 14 11:35:31 2013][Error][Kernel::System::User::UserAdd][349] Need UserLastname!
[Tue May 14 11:36:00 2013][Notice][Kernel::System::User::UserAdd] User: 'otrssearch' ID: '2' created successfully (1)!
[Tue May 14 11:36:00 2013][Notice][Kernel::System::User::SetPassword] User: 'otrssearch' changed password successfully!
[Tue May 14 11:37:49 2013][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! <--
Scheduler is restarting...!

otrssearch apparently logged in successfully.

koti · Post by **koti** » 16 May 2013, 13:51

The otrsserach user I have created locally in OTRS and in AD I have given admin rights.
Can the scheduler service run if the db password is wrong, I have tested the user name and password against otrs db on MySQL and it is working.

Thankyou

koti · Post by **koti** » 16 May 2013, 13:53

Also any suggestions on how to fix the scheduler service.

Post by **crythias** » 16 May 2013, 13:58

Create a new topic. Your original topic is closed.

Znuny Open Source Ticketsystem

Unable to authenticate with Active Directory

Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory

Re: Unable to authenticate with Active Directory