Initial Configuration Problems
I'm running SuSE 8.1. I installed OTRS when I installed SuSE, but I never configured it. I recently installed beta 8 from rpm using YaST. I use Apache to host other web sites, so to avoid changing the Apache user from wwwrun I ran the SetPermissions script. I also configured the otrs user account in MySQL and initialized the databases by hand. When I go to do the first login as root, I get a 500 Server Error. The Apache log file shows: Jan 5 22:00:54 2003] index.pl: DBI->connect(database=OpenTRS;host=localhost;:OpenTRS) failed: Access denied for user: 'otrs@localhost' (Using password: YES) at /opt/OpenTRS//Kernel/System/DB.pm line 61 [Sun Jan 5 22:00:54 2003] index.pl: (in cleanup) Can't call method "disconnect" on an undefined value at /opt/OpenTRS//Kernel/System/DB.pm line 78, <TEMPLATEIN> line 131. [Sun Jan 5 22:00:57 2003] [error] [client 127.0.0.1] File does not exist: /srv/www/htdocs/favicon.ico [Sun Jan 5 22:01:10 2003] index.pl: Subroutine GenericModules redefined at /opt/OpenTRS/bin/cgi-bin/index.pl line 228, <TEMPLATEIN> line 131. [Sun Jan 5 22:01:10 2003] index.pl: DBI->connect(database=OpenTRS;host=localhost;:OpenTRS) failed: Access denied for user: 'otrs@localhost' (Using password: YES) at /opt/OpenTRS//Kernel/System/DB.pm line 61 [Sun Jan 5 22:01:10 2003] index.pl: (in cleanup) Can't call method "disconnect" on an undefined value at /opt/OpenTRS//Kernel/System/DB.pm line 78, <TEMPLATEIN> line 262. [Sun Jan 5 22:01:20 2003] index.pl: Subroutine GenericModules redefined at /opt/OpenTRS/bin/cgi-bin/index.pl line 228, <TEMPLATEIN> line 262. [Sun Jan 5 22:01:20 2003] index.pl: DBI->connect(database=OpenTRS;host=localhost;:OpenTRS) failed: Access denied for user: 'otrs@localhost' (Using password: YES) at /opt/OpenTRS//Kernel/System/DB.pm line 61 [Sun Jan 5 22:01:20 2003] null: (in cleanup) Can't call method "disconnect" on an undefined value at /opt/OpenTRS//Kernel/System/DB.pm line 78, <TEMPLATEIN> line 262. [Sun Jan 5 22:01:20 2003] [error] PerlRun: `Can't call method "prepare" on an undefined value at /opt/OpenTRS//Kernel/System/DB.pm line 139, <TEMPLATEIN> line 262. (in cleanup) Can't call method "disconnect" on an undefined value at /opt/OpenTRS//Kernel/System/DB.pm line 78, <TEMPLATEIN> line 262. ' Any help in pinpointing this problem would be appreciated. I'm not a programmer (though I can compile and install apps from sources OK), so this level of debugging is a challenge! TIA, Mark -- ___________________________________________________________________ A Message From... L. Mark Stone http://www.lmstone.com
I'm trying to add new language on current cvs version. I added jp.pm to Kernel/Language. I also added new language $Self->{DefaultUsedLanguages}->{jp} = 'Japanese' to Config.pm. After that, I can find new language on the agent login page. But, there is no new language record in mysql language table. The admin interface (AdminArea ->> Language) was disappeared. How to add new language to language list at agent preference page? Best, Murahashi
Hi Shozo, On Mon, Jan 06, 2003 at 07:20:54PM +0900, murahashi wrote:
I'm trying to add new language on current cvs version.
I added jp.pm to Kernel/Language. I also added new language $Self->{DefaultUsedLanguages}->{jp} = 'Japanese' to Config.pm. After that, I can find new language on the agent login page.
But, there is no new language record in mysql language table. The admin interface (AdminArea ->> Language) was disappeared.
The Kernel/Config.pm replaced the database table (the language table is not longer used).
How to add new language to language list at agent preference page?
If you have your new language on the agent login page, you also should have the language on the agent preference page! PS0: If you send me your jp.pm I can add it to the OTRS 1.0 release! :)) PS1: Which charset do you use? UTF-8?
Best, Murahashi
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.
HI Martin,
On Mon, Jan 06, 2003 at 07:20:54PM +0900, murahashi wrote:
I'm trying to add new language on current cvs version.
I added jp.pm to Kernel/Language. I also added new language $Self->{DefaultUsedLanguages}->{jp} = 'Japanese' to Config.pm. After that, I can find new language on the agent login page.
But, there is no new language record in mysql language table. The admin interface (AdminArea ->> Language) was disappeared.
The Kernel/Config.pm replaced the database table (the language table is not longer used).
How to add new language to language list at agent preference page?
If you have your new language on the agent login page, you also should have the language on the agent preference page!
Sorry for my unclear quiestion. I have new language on the agent login page, but I could not find new language on the agent preference page. This is my problem.
PS0: If you send me your jp.pm I can add it to the OTRS 1.0 release! :))
PS1: Which charset do you use? UTF-8?
At this time, euc_JP only
Best, Murahashi
Martin
Shozo
Hi Shozo, On Tue, Jan 07, 2003 at 09:35:42AM +0900, murahashi wrote:
I added jp.pm to Kernel/Language. I also added new language $Self->{DefaultUsedLanguages}->{jp} = 'Japanese' to Config.pm. After that, I can find new language on the agent login page. [...]
How to add new language to language list at agent preference page?
If you have your new language on the agent login page, you also should have the language on the agent preference page!
Sorry for my unclear quiestion. I have new language on the agent login page, but I could not find new language on the agent preference page. This is my problem.
Really! Try to add [...] $Self->{DefaultUsedLanguages}->{bb} = 'Bavarian'; [...] to your Kernel/Config.pm. Is this language shown in your preference page?
Shozo
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Perfection is our goal, excellence will be tolerated. -- J. Yahl
HI, I'm sorry. It's my error! I Copied from Defaults.pm and added jp=>'Japanese' in Config.pm like this. I modified it to $Self->{DefaultUsedLanguages}->{jp} = 'Japanese' . Worked! Thank you Martin. $Self->{DefaultUsedLanguages} = { # bb => 'Bavarian', en => 'English', de => 'Deutsch', nl => 'Nederlands', fr => 'Fran?is', bg => 'Bulgarian', fi => 'Suomi', jp => 'Japanese', # es => 'Espaniol', # cs => 'Czech',
On Tue, Jan 07, 2003 at 09:35:42AM +0900, murahashi wrote:
I added jp.pm to Kernel/Language. I also added new language $Self->{DefaultUsedLanguages}->{jp} = 'Japanese' to Config.pm. After that, I can find new language on the agent login page. [...]
How to add new language to language list at agent preference page?
If you have your new language on the agent login page, you also should have the language on the agent preference page!
Sorry for my unclear quiestion. I have new language on the agent login page, but I could not find new language on the agent preference page. This is my problem.
Really! Try to add
[...] $Self->{DefaultUsedLanguages}->{bb} = 'Bavarian'; [...]
to your Kernel/Config.pm. Is this language shown in your preference page?
Shozo
Martin
Hi Mark, On Sun, Jan 05, 2003 at 10:13:27PM -0500, L. Mark Stone wrote:
I'm running SuSE 8.1. I installed OTRS when I installed SuSE, but I never configured it.
I recently installed beta 8 from rpm using YaST. I use Apache to host other web sites, so to avoid changing the Apache user from wwwrun I ran the SetPermissions script. I also configured the otrs user account in MySQL and initialized the databases by hand.
When I go to do the first login as root, I get a 500 Server Error. The Apache log file shows:
Jan 5 22:00:54 2003] index.pl: DBI->connect(database=OpenTRS;host=localhost;:OpenTRS) failed: Access denied for user: 'otrs@localhost' (Using password: YES) at
Your database setup is wrong. This means your user otrs@localhost can't connect to the OpenTRS database. Check the mysql password for otrs@localhost in Kernel/Config.pm (e. g. set it new in mysql). Try also '/opt/OpenTRS/bin/CheckDB.pl' for database checks. PS: About your Apache user, you will find improvements in OTRS 1.0 to use OTRS with any Apache user without problems.
[...] Any help in pinpointing this problem would be appreciated. I'm not a programmer (though I can compile and install apps from sources OK), so this level of debugging is a challenge!
That's should not be the problem! :)
TIA, Mark [...] A Message From... L. Mark Stone http://www.lmstone.com
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson
Martin, Thanks for your prompt reply. I destroyed and recreated the otrs user account in mysql (using phpMyAdmin) and all is now well. Who knows? Now I'm off to do the root configuration, etc. etc. Thanks again, and looking forward to 1.0! Best regards, Mark -- ___________________________________________________________________ A Message From... L. Mark Stone http://www.lmstone.com
participants (3)
-
L. Mark Stone -
Martin Edenhofer -
murahashi