I got OTRS going just before a long holiday weekend. I'd logged in as root@localhost 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 root@localhost. 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
Richard Petty wrote: <snip>
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';
Not sure what the CryptPassword.pl script is for, but that is not how you change a password in mysql. At least not how I have always done it. You can change the password using the command line mysql client like this: Log in to mysql: mysql -u root -p Enter the root password when prompted. Now issue the commands: mysql> SET PASSWORD FOR 'otrs'@'localhost' = PASSWORD('otrs'); You can also edit the password field directly like you said you did above. In that case, you still use the mysql PASSWORD() function to set the password. After manually editing the password field like that, you should issue a 'flush privileges' command to mysql. S/ Matt M.
participants (2)
-
Matt M. -
Richard Petty