I got OTRS going just before a long holiday weekend. I'd logged in as
[EMAIL PROTECTED] with a password of "root", just as the docs say.
I edited a copy of my Config.pm file to use LDAP and had no problems with
the new functionality.
When I returned to work this morning, the session had expired and I was no
longer able to log in.
I perused the maillist archives and I reset the admin password using
perl's crypt command, pasting it into the password field of the OTRS
service account.
Then I swapped out my modified LDAP-enabled Config.pm file for a virgin
Config.pm and I was able to log in as [EMAIL PROTECTED]
QUESTION 1: If authentication is set to LDAP, can I still authenticate to
the local database for the system account?
Now I'm experiencing another problem: I cannot make a MySQL database
connection from the login web page. This is strange because I didn't
modify the OTRS entry in to MySQL users table or any of the scripts.
The original 'otrs' user password in MySQL was:
*600ADED1E606A22C05804C307665D5782097D3B2
I reset the 'otrs' database password:
1. Used bin/CryptPassword.pl with a password of 'otrs'
2. Pasted the result, '09b8d8c8, into the otrs password field in MySQL
3. Setup entry in Config.pm to: $Self->{DatabasePw} = 'otrs';
I have noticed that the password that I generated is very short compared
to the default password and I still cannot connect to the database.
Running bin/CheckDB.pl results in this:
DBI connect('database=otrs;host=localhost;','otrs',...) failed:
Access denied for user 'otrs'@'localhost' (using password: YES)
at /opt/otrs/Kernel/System/DB.pm line 191
ERROR: OTRS-CheckDB-10 Perl: 5.8.5 OS: linux Time: Mon Nov 28
17:20:33 2005
Message: Access denied for user 'otrs'@'localhost' (using password: YES)
Traceback (551):
Module: Kernel::System::DB::new (v1.47) Line: 168
Module: /opt/otrs/bin/CheckDB.pl (v1.12) Line: 47
No database connect!
The error displayed when attempting to connect with the OTRS web page is
more verbose:
ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time: Mon Nov 28 17:35:03 2005
Message: Access denied for user 'otrs'@'localhost' (using password: YES)
Traceback (469):
Module: Kernel::System::DB::new (v1.47) Line: 168
Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 150
Module:
ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
(v) Line: 48
Module: (eval) (v1.80) Line: 202
Module: ModPerl::RegistryCooker::run (v1.80) Line: 202
Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 168
Module: ModPerl::Registry::handler (v1.99) Line: 30
QUESTION 2: Does this still look like a simple authentication error or is
there a clue here of another problem?
TIA,
--Richard
Austin, Texas
_______________________________________________
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
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
