
Hi I'm having real problems trying to install OTRS I have a ubuntu server - I followed the instructions for a Debian install (www.writely.com/View.aspx?docid=drm3kmx_0cbr3x9) and so installed otrs2 mysql-server apache2 and a whole bunch of other stuff that was in the package manager's 'recommends' category. Then I went to http://MYSERVER/otrs/installer.pl and plugged in the defaults which all seemed to work. Except after the last page says it's installed and directs you to http://MYSERVER/otrs/index.pl However I get ********** ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri May 23 15:28:03 2008 Message: Access denied for user 'otrs'@'localhost' (using password: NO) Traceback (1688): Module: Kernel::System::DB::new (v1.57) Line: 172 Module: Kernel::System::Web::InterfaceAgent::Run (v1.17.2.1) Line: 145 Module: ModPerl::ROOT::ModPerl::Registry::usr_share_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 47 Module: (eval) (v1.81) Line: 203 Module: ModPerl::RegistryCooker::run (v1.81) Line: 203 Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 169 Module: ModPerl::Registry::handler (v1.99) Line: 30 *********** I've tried going into mysql and manually dropping the otrs database and recreating it either manually in mysql or by using the "dpkg-reconfigure otrs2" command. I get a variation on the above error where it says using password: YES Aaarrgh I've tried everyhting I can think of - I've even stripped the passwords from the mysql root and otrs users and still get the same error. Where am I going wrong? D -- Douglas Walker Systems Administrator Jones Coulter Young Architects 321 Murray St, Perth WA, 6000

Douglas Walker wrote:
I'm having real problems trying to install OTRS
I have a ubuntu server - I followed the instructions for a Debian install (www.writely.com/View.aspx?docid=drm3kmx_0cbr3x9) and so installed
otrs2 mysql-server apache2
and a whole bunch of other stuff that was in the package manager's 'recommends' category.
Then I went to http://MYSERVER/otrs/installer.pl
and plugged in the defaults which all seemed to work. Except after the last page says it's installed and directs you to http://MYSERVER/otrs/index.pl
However I get
********** ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri May 23 15:28:03 2008
Message: Access denied for user 'otrs'@'localhost' (using password: NO)
Traceback (1688): Module: Kernel::System::DB::new (v1.57) Line: 172 Module: Kernel::System::Web::InterfaceAgent::Run (v1.17.2.1) Line: 145 Module: ModPerl ::ROOT ::ModPerl ::Registry::usr_share_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 47 Module: (eval) (v1.81) Line: 203 Module: ModPerl::RegistryCooker::run (v1.81) Line: 203 Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 169 Module: ModPerl::Registry::handler (v1.99) Line: 30
***********
I've tried going into mysql and manually dropping the otrs database and recreating it either manually in mysql or by using the "dpkg-reconfigure otrs2" command.
I get a variation on the above error where it says using password: YES
Aaarrgh
I've tried everyhting I can think of - I've even stripped the passwords from the mysql root and otrs users and still get the same error.
Where am I going wrong?
The database name, username and password in your Config.pm need to match the database name, username and password of the database that was installed. Nils Breunese.

Nils Breunese (Lemonbit) wrote:
Douglas Walker wrote:
I'm having real problems trying to install OTRS
<snip> Then I went to http://MYSERVER/otrs/installer.pl
and plugged in the defaults which all seemed to work. Except after the last page says it's installed and directs you to http://MYSERVER/otrs/index.pl
However I get
********** ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Fri May 23 15:28:03 2008
Message: Access denied for user 'otrs'@'localhost' (using password: NO) <snip> I've tried everyhting I can think of - I've even stripped the passwords from the mysql root and otrs users and still get the same error.
Where am I going wrong?
The database name, username and password in your Config.pm need to match the database name, username and password of the database that was installed.
Nils Breunese.
Ok, thanks for the quick answer - however still can't get it to work. I editied /etc/otrs/Kernel/Config.pm so that the line $Self->{DatabasePw} = $dbpass; \\ read $Self->{DatabasePw} = $dbpass || 'PASSWORD'; And instead of my previous error of Error: Access denied for user 'otrs'@'localhost' (using password: YES) I get a log-in screen - but when I log in as otrs (or root) it says either the username or pass is wrong. -- Douglas Walker Systems Administrator Jones Coulter Young Architects 321 Murray St, Perth WA, 6000

Douglas Walker wrote:
Ok, thanks for the quick answer - however still can't get it to work.
I editied /etc/otrs/Kernel/Config.pm so that the line
$Self->{DatabasePw} = $dbpass; \\
read
$Self->{DatabasePw} = $dbpass || 'PASSWORD';
And instead of my previous error of Error: Access denied for user 'otrs'@'localhost' (using password: YES)
I get a log-in screen - but when I log in as otrs (or root) it says either the username or pass is wrong.
See 'First login' in the documentation: http://doc.otrs.org/2.2/en/html/x677.html The default OTRS admin username is 'root@localhost', the default password is 'root'. Nils Breunese.
participants (2)
-
Douglas Walker
-
Nils Breunese (Lemonbit)