Re: [otrs] Login not creating a DB entry for a new LDAP agent

[Alvaro Cordero]

Hello,

That means that the user cannot be sync to the database, you need to verify
the user mapping in sysconfig, to match the fields from ldap into OTRS.

Regards


2016-01-28 9:59 GMT-06:00 Cosme Faria Corrêa :

> Hi,
>
> my interface message is that:
> Panic, user authenticated but no user data can be found in OTRS DB!!
> Perhaps the user is invalid.
>
> My log says:
> [Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserLookup][922]
> No UserID found for 'johndoe'!
> [Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserLookup][922]
> No UserID found for 'johndoe'!
> [Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserAdd][348] Need
> UserEmail!
> [Thu Jan 28 10:45:40
> 2016][Error][Kernel::System::Auth::Sync::LDAP::Sync][281] Can't create user
> 'johndoe' (uid=johndoe,ou=People,dc=aaa,dc=bb) in RDBMS!
> [Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserLookup][922]
> No UserID found for 'johndoe'!
>
> The point is, Why? Why it can't?
> [Thu Jan 28 10:45:40
> 2016][Error][Kernel::System::Auth::Sync::LDAP::Sync][281] Can't create user
> 'johndoe' (uid=johndoe,ou=People,dc=uff,dc=br) in RDBMS!
>
> --
> Cosme Corrêa
> +55 21 4042-6606
> CanalSAC
> O Nosso Negócio é Relacionamento
>
> -
> 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




-- 

*Alvaro Cordero RetanaConsultor de Tecnologias*
*Tel: 22585757 ext 123*
*Email:* alv...@gridshield.net
-
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

[otrs] Login not creating a DB entry for a new LDAP agent

[Cosme Faria Corrêa]

Hi,

my interface message is that:
Panic, user authenticated but no user data can be found in OTRS DB!! 
Perhaps the user is invalid.


My log says:
[Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserLookup][922] 
No UserID found for 'johndoe'!
[Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserLookup][922] 
No UserID found for 'johndoe'!
[Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserAdd][348] 
Need UserEmail!
[Thu Jan 28 10:45:40 
2016][Error][Kernel::System::Auth::Sync::LDAP::Sync][281] Can't create 
user 'johndoe' (uid=johndoe,ou=People,dc=aaa,dc=bb) in RDBMS!
[Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserLookup][922] 
No UserID found for 'johndoe'!


The point is, Why? Why it can't?
[Thu Jan 28 10:45:40 
2016][Error][Kernel::System::Auth::Sync::LDAP::Sync][281] Can't create 
user 'johndoe' (uid=johndoe,ou=People,dc=uff,dc=br) in RDBMS!


--
Cosme Corrêa
+55 21 4042-6606
CanalSAC
O Nosso Negócio é Relacionamento

-
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

Re: [otrs] Login not creating a DB entry for a new LDAP agent

[Cosme Faria Corrêa]

Hi Alvaro,

thanks for your help.

I am not sure if I undesrtand.

I walked arround sysconfig, without success.

CustomerInformationCenter   


1   Framework
Frontend::Admin 


4   Framework
Frontend::Admin::AdminCustomerCompany   


1   Framework
Frontend::Admin::AdminCustomerUser  


1   Framework
Frontend::Admin::AdminSelectBox 


1   Framework
Frontend::Admin::ModuleRegistration 


28  Framework
Frontend::Agent 


29  Framework
Frontend::Agent::Auth::TwoFactor


4   Framework
Frontend::Agent::Dashboard  


11  Framework
Frontend::Agent::LinkObject 


1   Framework
Frontend::Agent::ModuleMetaHead 


1   Framework
Frontend::Agent::ModuleNotify   


7   Framework
Frontend::Agent::ModuleRegistration 


15  Framework
Frontend::Agent::NavBarModule   


2   Framework
Frontend::Agent::Preferences


13  Framework
Frontend::Agent::SearchRouter   


1   Framework
Frontend::Agent::Stats  


10  Framework
Frontend::Customer  


28  Framework
Frontend::Customer::Auth


26  Framework
Frontend::Customer::Auth::TwoFactor 


4   Framework
Frontend::Customer::ModuleMetaHead  



I have:

 * Frontend::Customer::Auth

I do not have:

 * Frontend::Agent::Auth

Why?


I am using LDAP with memberof.
My idea is:

 * Do not use root@localhost in normal operation.
 * LDAP Auth is suppressing DB Auth.

I have no problems If i create, manually, an account and log AFTER.

This is a part of my Config.pm

...
# OpenLDAP
# authenticate agents against ldap
$Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP';
$Self->{'AuthModule::LDAP::Host'} = '127.0.0.1';
$Self->{'AuthModule::LDAP::BaseDN'} = 'dc=aaa,dc=bb';
$Self->{'AuthModule::LDAP::UID'} = 'uid';

# Check if the user is allowed to auth in a posixGroup
# (e. g. user needs to be in a group clerks to use otrs)
$Self->{'AuthModule::LDAP::GroupDN'} = 
'cn=clerks,ou=Group,dc=aaa,dc=bb';

#$Self->{'AuthModule::LDAP::AccessAttr'} = 'memberUid';
$Self->{'AuthModule::LDAP::AccessAttr'} = 'member';
$Self->{'AuthModule::LDAP::UserAttr'} = 'DN';

# defines AuthSyncBackend (AuthSyncModule) for AuthModule
# if this key exists and is empty, there won't be a sync.
# example values: AuthSyncBackend, AuthSyncBackend2
$Self->{'AuthModule::UseSyncBackend'} = 'AuthSyncBackend';

# sync agents from ldap to mysql
$Self->{'AuthSyncModule'} = 'Kernel::System::Auth::Sync::LDAP';
$Self->{'AuthSyncModule::LDAP::Host'} = '127.0.0.1';
#$Self->{'AuthSyncModule::LDAP::BaseDN'} = 'ou=People,dc=aaa,dc=bb';
$Self->{'AuthSyncModule::LDAP::BaseDN'} = 'dc=aaa,dc=bb';
$Self->{'AuthSyncModule::LDAP::UID'} = 'uid';

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = {
# DB -> LDAP
UserFirstname => 'givenName',
UserLastname  => 'sn',
UserEmail => 'mail',
UserMobile=> 'mobile',
#UserComment=> 'description',
};

# AuthSyncModule::LDAP::UserSyncInitialGroups
# (sync following group with rw permission after initial create of 
first agent

# login)
$Self->{'AuthSyncModule::LDAP::UserSyncInitialGroups'} = [
'users',
];

# Attributes needed for group syncs
# (attribute name for group value key)
#$Self->{'AuthSyncModule::LDAP::AccessAttr'} = 'memberUid';
$Self->{'AuthSyncModule::LDAP::AccessAttr'} = 'member';
# (attribute for type of group content UID/DN for full ldap name)
#$Self->{'AuthSyncModule::LDAP::UserAttr'} = 'UID';
$Self->{'AuthSyncModule::LDAP::UserAttr'} = 'DN';

# AuthSyncModule::LDAP::UserSyncGroupsDefinition
# (If "LDAP" was selected for AuthModule and you want to sync LDAP
# groups to otrs groups, define the following.)
$Self->{'AuthSyncModule::LDAP::UserSyncGroupsDefinition'} = {
## ldap group
'cn=netadmins,ou=Group,dc=aaa,dc=bb' => {
## otrs group
'admin' => {
## permission
rw => 1,
ro => 1,
},
},
'cn=users,ou=Group,dc=aaa,dc=bb' => {
'users' => {
rw => 1,
ro => 1,
},
}
};
...


Could you help me?
I will appreciate any kind of directions or examples.

TIA

On 28/01/16 11:15, Alvaro Cordero wrote:

Hello,

That means that the user cannot be sync to the database, you need to 
verify the user mapping in sysconfig, to match the fields from ldap 
into OTRS.


Regards


2016-01-28 9:59 GMT-06:00 Cosme Faria Corrêa 

Re: [otrs] Login not creating a DB entry for a new LDAP agent

[DHilsbos]

Cosme;

The UserEmail attribute is required
This log line:
[Thu Jan 28 10:45:40 2016][Error][Kernel::System::User::UserAdd][348] Need 
UserEmail!

Indicates that there isn't an email address for the agent it is trying to 
insert.
Have you verified the "mail " is a proper attribute of your LDAP server, and 
that it is populated for the agent you're trying to have login?

Can you tell us what your LDAP server is (Microsoft Active Directory, OpenLDAP, 
Apache Directory, etc.)?

Thank you,

Dominic L. Hilsbos, MBA, EIT, CSDA

Director - Information Technology

[Perform Air International, Inc.]

dhils...@performair.com<mailto:dhils...@performair.com>

www.PerformAir.com<http://www.performair.com>



From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Cosme 
Faria Corrêa
Sent: Thursday, January 28, 2016 11:08 AM
To: otrs@otrs.org
Subject: Re: [otrs] Login not creating a DB entry for a new LDAP agent

Hi Alvaro,

thanks for your help.

I am not sure if I undesrtand.

I walked arround sysconfig, without success.
CustomerInformationCenter


1

Framework

Frontend::Admin


4

Framework

Frontend::Admin::AdminCustomerCompany


1

Framework

Frontend::Admin::AdminCustomerUser


1

Framework

Frontend::Admin::AdminSelectBox


1

Framework

Frontend::Admin::ModuleRegistration


28

Framework

Frontend::Agent


29

Framework

Frontend::Agent::Auth::TwoFactor


4

Framework

Frontend::Agent::Dashboard


11

Framework

Frontend::Agent::LinkObject


1

Framework

Frontend::Agent::ModuleMetaHead


1

Framework

Frontend::Agent::ModuleNotify


7

Framework

Frontend::Agent::ModuleRegistration


15

Framework

Frontend::Agent::NavBarModule


2

Framework

Frontend::Agent::Preferences


13

Framework

Frontend::Agent::SearchRouter


1

Framework

Frontend::Agent::Stats


10

Framework

Frontend::Customer


28

Framework

Frontend::Customer::Auth


26

Framework

Frontend::Customer::Auth::TwoFactor


4

Framework

Frontend::Customer::ModuleMetaHead


I have:

  *   Frontend::Customer::Auth
I do not have:

  *   Frontend::Agent::Auth
Why?


I am using LDAP with memberof.
My idea is:

  *   Do not use root@localhost in normal operation.
  *   LDAP Auth is suppressing DB Auth.
I have no problems If i create, manually, an account and log AFTER.

This is a part of my Config.pm

...
# OpenLDAP
# authenticate agents against ldap
$Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP';
$Self->{'AuthModule::LDAP::Host'} = '127.0.0.1';
$Self->{'AuthModule::LDAP::BaseDN'} = 'dc=aaa,dc=bb';
$Self->{'AuthModule::LDAP::UID'} = 'uid';

# Check if the user is allowed to auth in a posixGroup
# (e. g. user needs to be in a group clerks to use otrs)
$Self->{'AuthModule::LDAP::GroupDN'} = 'cn=clerks,ou=Group,dc=aaa,dc=bb';
#$Self->{'AuthModule::LDAP::AccessAttr'} = 'memberUid';
$Self->{'AuthModule::LDAP::AccessAttr'} = 'member';
$Self->{'AuthModule::LDAP::UserAttr'} = 'DN';

# defines AuthSyncBackend (AuthSyncModule) for AuthModule
# if this key exists and is empty, there won't be a sync.
# example values: AuthSyncBackend, AuthSyncBackend2
$Self->{'AuthModule::UseSyncBackend'} = 'AuthSyncBackend';

# sync agents from ldap to mysql
$Self->{'AuthSyncModule'} = 'Kernel::System::Auth::Sync::LDAP';
$Self->{'AuthSyncModule::LDAP::Host'} = '127.0.0.1';
#$Self->{'AuthSyncModule::LDAP::BaseDN'} = 'ou=People,dc=aaa,dc=bb';
$Self->{'AuthSyncModule::LDAP::BaseDN'} = 'dc=aaa,dc=bb';
$Self->{'AuthSyncModule::LDAP::UID'} = 'uid';

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = {
# DB -> LDAP
UserFirstname => 'givenName',
UserLastname  => 'sn',
UserEmail => 'mail',
UserMobile=> 'mobile',
#UserComment=> 'description',
};

# AuthSyncModule::LDAP::UserSyncInitialGroups
# (sync following group with rw permission after initial create of first 
agent
# login)
$Self->{'AuthSyncModule::LDAP::UserSyncInitialGroups'} = [
'users',
];

# Attributes needed for group syncs
# (attribute name for group value key)
#$Self->{'AuthSyncModule::LDAP::AccessAttr'} = 'memberUid';
$Self->{'AuthSyncModule::LDAP::AccessAttr'} = 'member';
# (attribute for type of group content UID/DN for full ldap name)
#$Self->{'AuthSyncModule::LDAP::UserAttr'} = 'UID';
$Self->{'AuthSyncModule::LDAP::UserAttr'} = 'DN';

# AuthSyncModule::LDAP::UserSyncGroupsDefinition
# (If "LDAP" was selected for AuthModule and you want to sync LDAP
# groups to otrs groups, define the following.)
$Self->{'AuthSyncModule::LDAP::UserSyncGroupsDefinition'} = {
## ldap group
'cn=netadmins,ou=Group,dc=aaa,dc=bb' => {
## otrs group
'admin' => {
## permission
rw => 1,
ro => 1,
},
 

[otrs] login using ldap

[Neil Simpson]

Hello,

Using otrs 3.0.9.  I remember a time in version 2.4 where i could login to
otrs WITHOUT having an account already configured in otrs, just a valid
ldap account. You'd then log-out, admin would setup your groups + queues,
you'd log back in and be done.

in 3.0.9 i need to first create the user account before a valid LDAP user
can login to otrs. i didn't make any big changes to my config.pm file.

anyone had a similar experience or know an option to fix the issue.

thanks in advance,

Neil
-
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

Re: [otrs] login using ldap

[Thomas Mueller]

Am Tue, 28 Feb 2012 15:06:50 +0100 schrieb Neil Simpson:

 Hello,
 
 Using otrs 3.0.9.  I remember a time in version 2.4 where i could login
 to otrs WITHOUT having an account already configured in otrs, just a
 valid ldap account. You'd then log-out, admin would setup your groups +
 queues,
 you'd log back in and be done.
 
 in 3.0.9 i need to first create the user account before a valid LDAP
 user can login to otrs. i didn't make any big changes to my config.pm
 file.
 
 anyone had a similar experience or know an option to fix the issue.
 

maybe: http://bugs.otrs.org/show_bug.cgi?id=8227

- Thomas


-
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

Re: [otrs] login using ldap

[Neil Simpson]

thanks thomas, i actually figured out in the meantime that my issue was
with the difference between new and old way of syncing, but the
defaults.pmi didn't know about, check it tomorrow when im in office
again.

On Tue, Feb 28, 2012 at 5:59 PM, Thomas Mueller tho...@chaschperli.chwrote:

 Am Tue, 28 Feb 2012 15:06:50 +0100 schrieb Neil Simpson:

  Hello,
 
  Using otrs 3.0.9.  I remember a time in version 2.4 where i could login
  to otrs WITHOUT having an account already configured in otrs, just a
  valid ldap account. You'd then log-out, admin would setup your groups +
  queues,
  you'd log back in and be done.
 
  in 3.0.9 i need to first create the user account before a valid LDAP
  user can login to otrs. i didn't make any big changes to my config.pm
  file.
 
  anyone had a similar experience or know an option to fix the issue.
 

 maybe: http://bugs.otrs.org/show_bug.cgi?id=8227

 - Thomas


 -
 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

-
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

[otrs] login error

[Ekram]

Hi,

I am unable to login using root@localhost/root
getting the following error. Please help.

Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
[Error][Kernel::System::Valid::ValidIDsGet][Line:215]: ERROR:  permission
denied for relation valid, SQL: 'SELECT id FROM valid WHERE name = ?'
Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
[Error][Kernel::System::Auth::DB::Auth][Line:95]: ERROR:  syntax error at or
near )#012LINE 1: SELECT pw, id  FROM  users  WHERE  valid_id IN (  ) AND
log...#012  ^, SQL:
'SELECT pw, id  FROM  users  WHERE  valid_id IN (  ) AND  login =
'root@localhost''
Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
[Notice][Kernel::System::Auth::DB::Auth] User: root@localhost doesn't exist
or is invalid!!! (REMOTE_ADDR: 10.251.10.12)
Oct 19 10:42:48 newotrs OTRS-CGI-10[31370]:
[Error][Kernel::System::User::UserLookup][Line:736]: ERROR:  permission
denied for relation users, SQL: 'SELECT id FROM users  WHERE LOWER(login) =
?'


Also getting the following error whey run database check.

DBD::Pg::st execute failed: ERROR:  permission denied for relation valid at
/opt/otrs/Kernel/System/DB.pm line 553.
ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.10.1 OS: linux Time: Wed Oct 19
10:47:37 2011

 Message: ERROR:  permission denied for relation valid, SQL: 'SELECT * FROM
valid'

 Traceback (32444):
   Module: /opt/otrs/bin/otrs.CheckDB.pl (v1.4) Line: 71

DBD::Pg::st fetchrow_array failed: no statement executing at
/opt/otrs/Kernel/System/DB.pm line 616.


/Ekram
-
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

Re: [otrs] login error

[Ekram]

manage to get using

GRANT SELECT ON valid TO otrs;


Trying to connect to database
DSN: DBI:Pg:dbname=otrs;
DatabaseUser: otrs

It looks Ok!

but its unable to login giving the

Oct 19 11:06:41 newotrs OTRS-CGI-10[30806]:
[Notice][Kernel::System::Auth::DB::Auth] User: root@localhost doesn't exist
or is invalid!!! (REMOTE_ADDR: 10.251.10.12)
Oct 19 11:06:41 newotrs OTRS-CGI-10[30806]:
[Error][Kernel::System::User::UserLookup][Line:736]: ERROR:  permission
denied for relation users, SQL: 'SELECT id FROM users  WHERE LOWER(login) =
?

):

On Wed, Oct 19, 2011 at 2:48 PM, Ekram chutygo...@gmail.com wrote:

 Hi,

 I am unable to login using root@localhost/root
 getting the following error. Please help.

 Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
 [Error][Kernel::System::Valid::ValidIDsGet][Line:215]: ERROR:  permission
 denied for relation valid, SQL: 'SELECT id FROM valid WHERE name = ?'
 Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
 [Error][Kernel::System::Auth::DB::Auth][Line:95]: ERROR:  syntax error at or
 near )#012LINE 1: SELECT pw, id  FROM  users  WHERE  valid_id IN (  ) AND
 log...#012  ^, SQL:
 'SELECT pw, id  FROM  users  WHERE  valid_id IN (  ) AND  login =
 'root@localhost''
 Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
 [Notice][Kernel::System::Auth::DB::Auth] User: root@localhost doesn't
 exist or is invalid!!! (REMOTE_ADDR: 10.251.10.12)
 Oct 19 10:42:48 newotrs OTRS-CGI-10[31370]:
 [Error][Kernel::System::User::UserLookup][Line:736]: ERROR:  permission
 denied for relation users, SQL: 'SELECT id FROM users  WHERE LOWER(login) =
 ?'


 Also getting the following error whey run database check.

 DBD::Pg::st execute failed: ERROR:  permission denied for relation valid at
 /opt/otrs/Kernel/System/DB.pm line 553.
 ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.10.1 OS: linux Time: Wed Oct 19
 10:47:37 2011

  Message: ERROR:  permission denied for relation valid, SQL: 'SELECT * FROM
 valid'

  Traceback (32444):
Module: /opt/otrs/bin/otrs.CheckDB.pl (v1.4) Line: 71

 DBD::Pg::st fetchrow_array failed: no statement executing at
 /opt/otrs/Kernel/System/DB.pm line 616.


 /Ekram

-
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

Re: [otrs] login error

[Michiel Beijen]

Hi Ekram,

This makes the 'otrs' user only able to select on the 'valid' table in
your PostgreSQL but it must have ownership of the 'otrs' database.

Most probably, the command you're looking for is:

ALTER DATABASE otrs OWNER TO otrs;

Michiel Beijen
Senior Consultant

OTRS BV
Schipholweg 103
2316 XC Leiden
The Netherlands

T: +31 71 8200 255
F: +31 71 8200 254
I: http://www.otrs.com

Making OTRS even better! Exclusive Feature Add-Ons improve usability
of OTRS and extend its functionality: http://j.mp/ndQvZj

On Wed, Oct 19, 2011 at 11:09, Ekram chutygo...@gmail.com wrote:
 manage to get using

 GRANT SELECT ON valid TO otrs;

 Trying to connect to database
 DSN: DBI:Pg:dbname=otrs;
 DatabaseUser: otrs

 It looks Ok!

 but its unable to login giving the

 Oct 19 11:06:41 newotrs OTRS-CGI-10[30806]:
 [Notice][Kernel::System::Auth::DB::Auth] User: root@localhost doesn't exist
 or is invalid!!! (REMOTE_ADDR: 10.251.10.12)
 Oct 19 11:06:41 newotrs OTRS-CGI-10[30806]:
 [Error][Kernel::System::User::UserLookup][Line:736]: ERROR:  permission
 denied for relation users, SQL: 'SELECT id FROM users  WHERE LOWER(login) =
 ?

 ):

 On Wed, Oct 19, 2011 at 2:48 PM, Ekram chutygo...@gmail.com wrote:

 Hi,

 I am unable to login using root@localhost/root
 getting the following error. Please help.

 Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
 [Error][Kernel::System::Valid::ValidIDsGet][Line:215]: ERROR:  permission
 denied for relation valid, SQL: 'SELECT id FROM valid WHERE name = ?'
 Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
 [Error][Kernel::System::Auth::DB::Auth][Line:95]: ERROR:  syntax error at or
 near )#012LINE 1: SELECT pw, id  FROM  users  WHERE  valid_id IN (  ) AND
 log...#012  ^, SQL:
 'SELECT pw, id  FROM  users  WHERE  valid_id IN (  ) AND  login =
 'root@localhost''
 Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]:
 [Notice][Kernel::System::Auth::DB::Auth] User: root@localhost doesn't exist
 or is invalid!!! (REMOTE_ADDR: 10.251.10.12)
 Oct 19 10:42:48 newotrs OTRS-CGI-10[31370]:
 [Error][Kernel::System::User::UserLookup][Line:736]: ERROR:  permission
 denied for relation users, SQL: 'SELECT id FROM users  WHERE LOWER(login) =
 ?'


 Also getting the following error whey run database check.

 DBD::Pg::st execute failed: ERROR:  permission denied for relation valid
 at /opt/otrs/Kernel/System/DB.pm line 553.
 ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.10.1 OS: linux Time: Wed Oct 19
 10:47:37 2011

  Message: ERROR:  permission denied for relation valid, SQL: 'SELECT *
 FROM valid'

  Traceback (32444):
    Module: /opt/otrs/bin/otrs.CheckDB.pl (v1.4) Line: 71

 DBD::Pg::st fetchrow_array failed: no statement executing at
 /opt/otrs/Kernel/System/DB.pm line 616.


 /Ekram


 -
 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

-
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

[otrs] login error with software error

[Colin Chen]

Hi there
I'v installed otrs 2.4 from source under debian, below is my environment:
Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny4 with Suhosin-Patch mod_perl/2.0.4
Perl/v5.10.0 Server at debian.teccolin.info

I followed the Install and README.webserver to finished the installation,
and passed the sytax test. It looks just fine when I get the first page (
http://myhost/otrs/index.pl), but when I use r...@localhost:root to login
the system, I got below error message:
*
Software error:
junk '
Connection: close
' after XML element
For help, please send mail to the webmaster (webmas...@localhost), giving
this error message and the time and date of the error.
**

Another error message when I visit http://myhost/otrs;  as below:
**
Not Found
The requested URL /otrs/ was not found on this server.
Additionally, a 500 Internal Server Error error was encountered while trying
to use an ErrorDocument to handle the request.
Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny4 with Suhosin-Patch mod_perl/2.0.4
Perl/v5.10.0 Server at debian.teccolin.info Port 80
**

I try to check my apache log, below is the error message:
**
 Message: C-Parser:
junk after document element at line 54, column 0, byte 1405 at
/usr/lib/perl5/XML/Parser.pm line 187
!

 Traceback (25174):
   Module: Kernel::System::XML::XMLParse (v1.83) Line: 1295
   Module: Kernel::System::XML::XMLParse2XMLHash (v1.83) Line: 687
   Module: Kernel::Output::HTML::DashboardProductNotify::Run (v1.11) Line:
86
   Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390
   Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
   Module:
ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
(unknown version) Line: 48
   Module: (eval) (v1.88) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Fri Dec 11 11:30:55 2009

 Message: XML::Parser produced errors. I use XML::Parser::Lite as fallback!

 Traceback (25174):
   Module: Kernel::System::XML::XMLParse (v1.83) Line: 1296
   Module: Kernel::System::XML::XMLParse2XMLHash (v1.83) Line: 687
   Module: Kernel::Output::HTML::DashboardProductNotify::Run (v1.11) Line:
86
   Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390
   Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
   Module:
ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
(unknown version) Line: 48
   Module: (eval) (v1.88) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

[Fri Dec 11 11:30:55 2009] [error] [Fri Dec 11 11:30:55 2009] -e: junk
'\r\n[Fri Dec 11 11:30:55 2009] -e: Connection: close\r\n[Fri Dec 11
11:30:55 2009] -e: \r\n[Fri Dec 11 11:30:55 2009] -e: ' after XML element\n
**

Pleaes may you help or give any points of directions.

Thanks and Best Regards
Colin
-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] login error with software error

[Leonardo Certuche]

Hello,

This info might help you a bit:
http://doc.otrs.org/2.4/en/html/x531.html#installation-of-perl-modules

Leonardo Certuche


On Thu, Dec 10, 2009 at 10:35 PM, Colin Chen silencer...@gmail.com wrote:

 Hi there
 I'v installed otrs 2.4 from source under debian, below is my environment:
 Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny4 with Suhosin-Patch mod_perl/2.0.4
 Perl/v5.10.0 Server at debian.teccolin.info

 I followed the Install and README.webserver to finished the installation,
 and passed the sytax test. It looks just fine when I get the first page (
 http://myhost/otrs/index.pl), but when I use r...@localhost:root to
 login the system, I got below error message:
 *
 Software error:
 junk '
 Connection: close
 ' after XML element
 For help, please send mail to the webmaster (webmas...@localhost), giving
 this error message and the time and date of the error.
 **

 Another error message when I visit http://myhost/otrs;  as below:
 **
 Not Found
 The requested URL /otrs/ was not found on this server.
 Additionally, a 500 Internal Server Error error was encountered while
 trying to use an ErrorDocument to handle the request.
 Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny4 with Suhosin-Patch mod_perl/2.0.4
 Perl/v5.10.0 Server at debian.teccolin.info Port 80
 **

 I try to check my apache log, below is the error message:
 **
  Message: C-Parser:
 junk after document element at line 54, column 0, byte 1405 at
 /usr/lib/perl5/XML/Parser.pm line 187
 !

  Traceback (25174):
Module: Kernel::System::XML::XMLParse (v1.83) Line: 1295
Module: Kernel::System::XML::XMLParse2XMLHash (v1.83) Line: 687
Module: Kernel::Output::HTML::DashboardProductNotify::Run (v1.11) Line:
 86
Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390
Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
Module:
 ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
 (unknown version) Line: 48
Module: (eval) (v1.88) Line: 204
Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

 ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Fri Dec 11 11:30:55 2009

  Message: XML::Parser produced errors. I use XML::Parser::Lite as fallback!

  Traceback (25174):
Module: Kernel::System::XML::XMLParse (v1.83) Line: 1296
Module: Kernel::System::XML::XMLParse2XMLHash (v1.83) Line: 687
Module: Kernel::Output::HTML::DashboardProductNotify::Run (v1.11) Line:
 86
Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390
Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
Module:
 ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
 (unknown version) Line: 48
Module: (eval) (v1.88) Line: 204
Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

 [Fri Dec 11 11:30:55 2009] [error] [Fri Dec 11 11:30:55 2009] -e: junk
 '\r\n[Fri Dec 11 11:30:55 2009] -e: Connection: close\r\n[Fri Dec 11
 11:30:55 2009] -e: \r\n[Fri Dec 11 11:30:55 2009] -e: ' after XML element\n
 **

 Pleaes may you help or give any points of directions.

 Thanks and Best Regards
 Colin

 -
 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

 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
 http://www.otrs.com/en/support/enterprise-subscription/

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] login error with software error

[Colin Chen]

Hi Leonardo
All required Perl modules have been installed in my system, and I do
followed that document to install otrs and the database. I can get the first
page at http://myhost/otrs/index.pl;, but I can't login.

Below is my %otrshome%/bin/otrs.check result:
o CGIok (v3.48)
   o Date::Pcalcok (v1.2)
   o Date::Format...ok (v2.22)
   o DBIok (v1.609)
   o DBD::mysql.ok (v4.007)
   o Digest::MD5ok (v2.39)
   o Crypt::PasswdMD5...ok (v1.3)
   o LWP::UserAgent.ok (v5.834)
   o Encode::HanExtra...ok (v0.23)
   o IO::Scalar.ok (v2.110)
   o IO::Wrap...ok (v2.110)
   o MIME::Base64...ok (v3.07_01)
   o Mail::Internet.ok (v2.04)
   o MIME::Toolsok (v5.427)
   o Net::DNS...ok (v0.65)
   o Net::POP3..ok (v2.29)
   o Mail::POP3Client...ok (v2.18 )
  o IO::Socket::SSL.ok (v1.31)
   o Net::IMAP::Simple..ok (v1.17)
  o Net::IMAP::Simple::SSL..ok (v1.3)
   o Net::SMTP..ok (v2.31)
  o Authen::SASLok (v2.12)
  o Net::SMTP::SSL..ok (v1.01)
   o Net::LDAP..ok (v0.39)
   o GD.ok (v2.44)
  o GD::Textok (v0.86)
  o GD::Graph...ok (v1.44)
  o GD::Graph::linesok (v1.15)
  o GD::Text::Align.ok (v1.18)
   o PDF::API2..ok (v0.73)
  o Compress::Zlib..ok (v2.012)
   o SOAP::Lite.ok (v0.710.10)
   o XML::Parserok (v2.36)
Regards
Colin

On Fri, Dec 11, 2009 at 12:45 PM, Leonardo Certuche 
leonardo.certu...@itcon-ltda.com wrote:

 Hello,

 This info might help you a bit:
 http://doc.otrs.org/2.4/en/html/x531.html#installation-of-perl-modules

 Leonardo Certuche


 On Thu, Dec 10, 2009 at 10:35 PM, Colin Chen silencer...@gmail.comwrote:

 Hi there
 I'v installed otrs 2.4 from source under debian, below is my environment:
 Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny4 with Suhosin-Patch
 mod_perl/2.0.4 Perl/v5.10.0 Server at debian.teccolin.info

 I followed the Install and README.webserver to finished the installation,
 and passed the sytax test. It looks just fine when I get the first page (
 http://myhost/otrs/index.pl), but when I use r...@localhost:root to
 login the system, I got below error message:
 *
 Software error:
 junk '
 Connection: close
 ' after XML element
 For help, please send mail to the webmaster (webmas...@localhost), giving
 this error message and the time and date of the error.
 **

 Another error message when I visit http://myhost/otrs;  as below:
 **
 Not Found
 The requested URL /otrs/ was not found on this server.
 Additionally, a 500 Internal Server Error error was encountered while
 trying to use an ErrorDocument to handle the request.
 Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny4 with Suhosin-Patch mod_perl/2.0.4
 Perl/v5.10.0 Server at debian.teccolin.info Port 80
 **

 I try to check my apache log, below is the error message:
 **
  Message: C-Parser:
 junk after document element at line 54, column 0, byte 1405 at
 /usr/lib/perl5/XML/Parser.pm line 187
 !

  Traceback (25174):
Module: Kernel::System::XML::XMLParse (v1.83) Line: 1295
Module: Kernel::System::XML::XMLParse2XMLHash (v1.83) Line: 687
Module: Kernel::Output::HTML::DashboardProductNotify::Run (v1.11) Line:
 86
Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390
Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
Module:
 ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
 (unknown version) Line: 48
Module: (eval) (v1.88) Line: 204
Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

 ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Fri Dec 11 11:30:55 2009

  Message: XML::Parser produced errors. I use XML::Parser::Lite as
 fallback!

  Traceback (25174):
Module: Kernel::System::XML::XMLParse (v1.83) Line: 1296
Module: Kernel::System::XML::XMLParse2XMLHash (v1.83) Line: 687
Module: Kernel::Output::HTML::DashboardProductNotify::Run (v1.11) Line:
 86
Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390
Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
Module:
 ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
 (unknown version) Line: 48
Module: (eval) (v1.88) 

[otrs] Login Issue

[James Wilson]

Hi all,

I've just upgraded our OTRS install from 2.3 to 2.4.5. I'm using the
otrs4win installer.

I followed the upgrade guide at
http://faq.otrs.org/otrs/public.pl?Action=PublicFAQItemID=351 and
everything seemed fine up until I try to login to the upgraded system which
doesn't seem to be working. If I enter incorrect login details then the
system responds with the appropriate message. If I enter correct details the
system just hangs. If I look in the OTRS log file then I see the following
line: [Fri Dec  4 17:31:57 2009][Notice][Kernel::System::Auth::DB::Auth]
User: jwilson authentication ok (REMOTE_ADDR: 10.11.17.145)..

In the Apache error log there are a couple of errors but nothing helpful for
me:

 Use of uninitialized value $_ in -d at
C:/OTRS/StrawberryPerl/perl/lib/CGI.pm line 4083., referer:
http://otrs/otrs/index.pl;
Premature end of script headers: index.pl

Both of these lines appear several times.

I've done the data import steps in the upgrade guide and I can see my users
in the users table in the DB and the login does seem to be successful, it's
just trying to load the next page that's causing the problem.

The only thing I can think of is that the system is redirecting to the wrong
page after login. This might be off the mark but we used to access the old
2.3 system through http://otrs but the new system is only accessible through
http://otrs/otrs/. OTRS is the server name.

Any suggestions to get this working again would be most gratefully received!

James
-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] Login Account cannot be accessed

[Michiel Beijen]

Hi Brad,

What kind of timeout error do you get?
Is there something in the Apache error log or the OTRS error log?
Are you using authentication against LDAP or AD?

Kind regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl


On Thu, Jul 9, 2009 at 16:54, Brad Gayler bgay...@tdpcorp.com wrote:

  I cannot get my agent account to login. Am using OTRS 2.3.4 with MySQL on
 windows 2003 server

 All others are able to logon, but I get a timeout error when I try.

 Is there something locking it up?

 Can anyone help with this?



 bgay...@tdpcorp.com

 -
 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

 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
 http://www.otrs.com/en/support/enterprise-subscription/

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] Login Account cannot be accessed

[Brad Gayler]

I am getting an error because internet explorer times out saying ‘Internet 
Explorer cannot display the webpage.

The account shows up in Users, I can reset the password under ‘Lost Password?’, 
and I am still receiving e-mail notifications.

There is nothing in the Apache log file and there is no OTRS log file. (this 
may be another issue)

I am NOT using authentication against LDAP or AD at this time.

We are new to OTRS – been running for 4 weeks now.

 

From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Michiel 
Beijen
Sent: Thursday, July 09, 2009 9:50 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Login Account cannot be accessed

 

Hi Brad,

What kind of timeout error do you get? 
Is there something in the Apache error log or the OTRS error log?
Are you using authentication against LDAP or AD?

Kind regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl



On Thu, Jul 9, 2009 at 16:54, Brad Gayler bgay...@tdpcorp.com wrote:

I cannot get my agent account to login. Am using OTRS 2.3.4 with MySQL on 
windows 2003 server

All others are able to logon, but I get a timeout error when I try.

Is there something locking it up?

Can anyone help with this?

 

bgay...@tdpcorp.com


-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

 

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] Login Account cannot be accessed

[Leonardo Certuche]

Do you have any proxy setting on your browser?
Have you tried from another machine?
Does the OTRS server reply pings from your machine?

Greetings,

Leonardo Certuche


On Thu, Jul 9, 2009 at 11:21 AM, Brad Gayler bgay...@tdpcorp.com wrote:

  I am getting an error because internet explorer times out saying
 ‘Internet Explorer cannot display the webpage.

 The account shows up in Users, I can reset the password under ‘Lost
 Password?’, and I am still receiving e-mail notifications.

 There is nothing in the Apache log file and there is no OTRS log file.
 (this may be another issue)

 I am NOT using authentication against LDAP or AD at this time.

 We are new to OTRS – been running for 4 weeks now.



 *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf Of
 *Michiel Beijen
 *Sent:* Thursday, July 09, 2009 9:50 AM
 *To:* User questions and discussions about OTRS.
 *Subject:* Re: [otrs] Login Account cannot be accessed



 Hi Brad,

 What kind of timeout error do you get?
 Is there something in the Apache error log or the OTRS error log?
 Are you using authentication against LDAP or AD?

 Kind regards,
 --
 Michiel Beijen
 Software Consultant
 +31 6 - 457 42 418
 Bee Free IT + http://beefreeit.nl

  On Thu, Jul 9, 2009 at 16:54, Brad Gayler bgay...@tdpcorp.com wrote:

 I cannot get my agent account to login. Am using OTRS 2.3.4 with MySQL on
 windows 2003 server

 All others are able to logon, but I get a timeout error when I try.

 Is there something locking it up?

 Can anyone help with this?



 bgay...@tdpcorp.com


 -
 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

 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
 http://www.otrs.com/en/support/enterprise-subscription/



 -
 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

 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
 http://www.otrs.com/en/support/enterprise-subscription/

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] Login Account cannot be accessed

[Brad Gayler]

Proxy setting is on Auto Detect

I have tried from 2 other machines and get same results. I can logon as
root and as any other agent from my laptop and my desktop.

Which file contains the user account information? Is there something
there that I can check?

 

From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of
Leonardo Certuche
Sent: Thursday, July 09, 2009 11:27 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Login Account cannot be accessed

 

Do you have any proxy setting on your browser?
Have you tried from another machine?
Does the OTRS server reply pings from your machine?

Greetings,

Leonardo Certuche



On Thu, Jul 9, 2009 at 11:21 AM, Brad Gayler bgay...@tdpcorp.com
wrote:

I am getting an error because internet explorer times out saying
'Internet Explorer cannot display the webpage.

The account shows up in Users, I can reset the password under 'Lost
Password?', and I am still receiving e-mail notifications.

There is nothing in the Apache log file and there is no OTRS log file.
(this may be another issue)

I am NOT using authentication against LDAP or AD at this time.

We are new to OTRS - been running for 4 weeks now.

 

From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of
Michiel Beijen
Sent: Thursday, July 09, 2009 9:50 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Login Account cannot be accessed

 

Hi Brad,

What kind of timeout error do you get? 
Is there something in the Apache error log or the OTRS error log?
Are you using authentication against LDAP or AD?

Kind regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl

On Thu, Jul 9, 2009 at 16:54, Brad Gayler bgay...@tdpcorp.com wrote:

I cannot get my agent account to login. Am using OTRS 2.3.4 with MySQL
on windows 2003 server

All others are able to logon, but I get a timeout error when I try.

Is there something locking it up?

Can anyone help with this?

 

bgay...@tdpcorp.com


-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

 


-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

 

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] Login Account cannot be accessed

[Leonardo Certuche]

Hi Brad,

The user account information is on the database under the users table. I
once forgot the root password so I went there and replaced the pw entry with
the same one of a known user and I was able to enter as root using the same
password of the known user but you said you can change your password so
that's not the case.

Since you're able to enter as root, go to /otrs/index.pl?Action=AdminUser
and look for your user to make sure is set to valid. If you can access as
other user from your machine then there's no connectivity problem, it should
be user related.

Every time a user logs in, an entry in the log shows up. As root visit
/otrs/index.pl?Action=AdminLog using one browser and then with a different
browser try to log in as your user, an entry like the following should be
seen in the log:

User: your.username authentication ok (REMOTE_ADDR: your.own.ip.adrress).

Let us know how it goes.

Greetings,

Leonardo Certuche
On Thu, Jul 9, 2009 at 12:43 PM, Brad Gayler bgay...@tdpcorp.com wrote:

  Proxy setting is on Auto Detect

 I have tried from 2 other machines and get same results. I can logon as
 root and as any other agent from my laptop and my desktop.

 Which file contains the user account information? Is there something there
 that I can check?



 *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf Of
 *Leonardo Certuche
 *Sent:* Thursday, July 09, 2009 11:27 AM

 *To:* User questions and discussions about OTRS.
 *Subject:* Re: [otrs] Login Account cannot be accessed



 Do you have any proxy setting on your browser?
 Have you tried from another machine?
 Does the OTRS server reply pings from your machine?

 Greetings,

 Leonardo Certuche

  On Thu, Jul 9, 2009 at 11:21 AM, Brad Gayler bgay...@tdpcorp.com wrote:

 I am getting an error because internet explorer times out saying ‘Internet
 Explorer cannot display the webpage.

 The account shows up in Users, I can reset the password under ‘Lost
 Password?’, and I am still receiving e-mail notifications.

 There is nothing in the Apache log file and there is no OTRS log file.
 (this may be another issue)

 I am NOT using authentication against LDAP or AD at this time.

 We are new to OTRS – been running for 4 weeks now.



 *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf Of
 *Michiel Beijen
 *Sent:* Thursday, July 09, 2009 9:50 AM
 *To:* User questions and discussions about OTRS.
 *Subject:* Re: [otrs] Login Account cannot be accessed



 Hi Brad,

 What kind of timeout error do you get?
 Is there something in the Apache error log or the OTRS error log?
 Are you using authentication against LDAP or AD?

 Kind regards,
 --
 Michiel Beijen
 Software Consultant
 +31 6 - 457 42 418
 Bee Free IT + http://beefreeit.nl

 On Thu, Jul 9, 2009 at 16:54, Brad Gayler bgay...@tdpcorp.com wrote:

 I cannot get my agent account to login. Am using OTRS 2.3.4 with MySQL on
 windows 2003 server

 All others are able to logon, but I get a timeout error when I try.

 Is there something locking it up?

 Can anyone help with this?



 bgay...@tdpcorp.com


 -
 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

 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
 http://www.otrs.com/en/support/enterprise-subscription/




 -
 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

 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
 http://www.otrs.com/en/support/enterprise-subscription/



 -
 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

 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
 http://www.otrs.com/en/support/enterprise-subscription/

-
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

[otrs] Fwd: OTRS Login Problem

[Sivakumar ☺]

Hi All,

 I need your help very badly. Please help he  solve my problem..

It seems my configuratiopn ok for Integrating OTRS with OPenLDAp

But i got the following error,

Aug  6 20:04:24 tek OTRS-CGI-10[30120]:
[Error][Kernel::System::Auth::LDAP::Auth][Line:248]: Search failed!
base='cn=Manager,ou=People,ou=posixGroups,dc=tek,dc=virtual,dc=vps-host,dc=net',
filter='(memberUid=test2)', Success

Aug  6 20:06:12 tek OTRS-CGI-10[1552]:
[Error][Kernel::System::CustomerAuth::LDAP::Auth][Line:238]: Search failed!
base='cn=Manager,ou=People,ou=posixGroups,dc=tek,dc=virtual,dc=vps-host,dc=net',
filter='(memberUid=vis)', Success


please find my Config.pm file in attached,

Expecting your reply..

Siva
___
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 or consulting for your OTRS system?
= http://www.otrs.com/

[otrs] Login from outside

[Alexandru Palade]

Hi,

I managed to make otrs use the same customer database as my e-commerce
site does. I was wondering what would be the best way to make the user
logged in otrs once it logs in the e-commerce site.

I'm mentioning that i use sites like xyz.co.uk, xyz.de for localization
and the otrs is located at support.xyz.com (might be some troubles with
cookies).


Thanks in advance,
Alexandru Palade.

begin:vcard
fn:Alexandru Palade
n:Palade;Alexandru
org:ThinkUP Design;Development
email;internet:[EMAIL PROTECTED]
title:Senior Programmer
tel;fax:(+40)234.519.117
tel;cell:(+40)744.792.007
url:http://www.thinkupdesign.ro
version:2.1
end:vcard

___
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 or consulting for your OTRS system?
= http://www.otrs.com/

[otrs] Login Error (Can't use an undefined value as an ARRAY reference at ../..//Kernel/System/Config.pm line 195.)

[Simon Bierbaum]

Hi List,

I'm seeing this after logging into OTRS 2.1.7 for the first time  
after installation using the default credentials:


 Can't use an undefined value as an ARRAY reference at ../..// 
Kernel/System/Config.pm line 195.


I installed from source onto a shared linux-based webhosting account  
w/ ssh access and Apache 1.3. The perl module check comes up fine,  
index.pl can successfully display the login screen. I had to use the  
manual process for database setup as well since I don't have admin  
rights. Looking at the screenshots, it appears that installer.pl  
additionally sets some non-database config values (System FQDN, ...),  
is there any critial setting I might have missed? perl -cw Kernel/ 
Config.pm comes back with an OK, here's what I set:


$Self-{'DefaultLanguage'} = 'de';
$Self-{LogModule} = 'Kernel::System::Log::File';
$Self-{'LogModule::LogFile'} = '/path/to/otrs-2.1.7/log/ 
otrs.log';	# anonymized

$Self-{FQDN} = 'otrs.mydomain.net'; # anonymized
$Self-{ScriptAlias} = 'cgi-bin/';
$Self-{AdminEmail} = '[EMAIL PROTECTED]';
$Self-{'Frontend::ImagePath'} = '/images/Standard/';
$Self-{'SystemID'} = 10;
$Self-{'SecureMode'} = 1;
$Self-{'Organization'} = 'TestOrg';
$Self-{'DefaultCharset'} = 'iso-8859-1';

Any pointers?

Thanks, Simon
___
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 or consulting for your OTRS system?
= http://www.otrs.com/

[otrs] skip otrs login

[Sofia Peixoto]

Hi,

what I want to do is integrate your otrs system in my company's
website. It already has a login form to access restricted areas and I
wanted to integrate the otrs customer interface in one of those areas,
but I don't want the customers to have the need to do a second login.
Is it possible to jump directly to the customer area? And is there a
way to integrate the current interface in my website template? What
file(s) should I edit?

I'm still new to otrs and would apreceate any help.
Thanks


--
Sofia



___
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 orr consulting for your OTRS system?
= http://www.otrs.com/

RE: [otrs] skip otrs login

[Nathan Campbell]

http://doc.otrs.org/2.1/en/html/x1456.html#configuration-agent-auth-back
end-htbasic

 

Is this what you are looking for? I have never used it before, perhaps
someone could correct me if wrong.

 

Nathan Campbell


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Sofia Peixoto
Sent: Thursday, December 07, 2006 6:33 AM
To: otrs@otrs.org
Subject: [otrs] skip otrs login

 

Hi,

what I want to do is integrate your otrs system in my company's website.
It already has a login form to access restricted areas and I wanted to
integrate the otrs customer interface in one of those areas, but I don't
want the customers to have the need to do a second login. Is it possible
to jump directly to the customer area? And is there a way to integrate
the current interface in my website template? What file(s) should I
edit?

I'm still new to otrs and would apreceate any help.
Thanks


--
Sofia

___
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 orr consulting for your OTRS system?
= http://www.otrs.com/

RE: [otrs] skip otrs login

[Charles Sprickman]

On Thu, 7 Dec 2006, Nathan Campbell wrote:


http://doc.otrs.org/2.1/en/html/x1456.html#configuration-agent-auth-back
end-htbasic

Is this what you are looking for? I have never used it before, perhaps
someone could correct me if wrong.


I'm using that for agent logins and it works great.  Caveat:  You still 
need to individually setup each user or it won't work.  Kind of a pain - 
it would be nice if the account were auto-created based on some template 
when the agent first logs in.


On a related note, does anyone know if the customer httpauth has the same 
limitation?


Thanks,

Charles




Nathan Campbell


 _

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Sofia Peixoto
Sent: Thursday, December 07, 2006 6:33 AM
To: otrs@otrs.org
Subject: [otrs] skip otrs login



Hi,

what I want to do is integrate your otrs system in my company's website.
It already has a login form to access restricted areas and I wanted to
integrate the otrs customer interface in one of those areas, but I don't
want the customers to have the need to do a second login. Is it possible
to jump directly to the customer area? And is there a way to integrate
the current interface in my website template? What file(s) should I
edit?

I'm still new to otrs and would apreceate any help.
Thanks


--
Sofia



___
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 orr consulting for your OTRS system?
= http://www.otrs.com/

Re: [otrs] skip otrs login

[Alexander Scholler]

Hi Charles,

Charles Sprickman schrieb:

On Thu, 7 Dec 2006, Nathan Campbell wrote:


http://doc.otrs.org/2.1/en/html/x1456.html#configuration-agent-auth-back
end-htbasic

Is this what you are looking for? I have never used it before, perhaps
someone could correct me if wrong.


I'm using that for agent logins and it works great.  Caveat:  You still 
need to individually setup each user or it won't work.  Kind of a pain - 
it would be nice if the account were auto-created based on some template 
when the agent first logs in.


See
# UserSyncLDAPMap
# (map if agent should create/synced from LDAP to DB after login)
#$Self-{UserSyncLDAPMap} = {
## DB - LDAP
#Firstname = 'givenName',
#Lastname = 'sn',
#Email = 'mail',
#};
# UserSyncLDAPGroups
# (If LDAP was selected for AuthModule, you can specify inital
# user groups for first login.)
#$Self-{UserSyncLDAPGroups} = [
#'users',
#];



On a related note, does anyone know if the customer httpauth has the 
same limitation?


Thanks,

Charles


Bye, Alex
___
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 orr consulting for your OTRS system?
= http://www.otrs.com/

[otrs] Login Language Problem

[Carlos A. Cardona Gomez]

Hello



I am using ORTS in spanish, but i still get the red-color-english-sentence
Sent

new password to: [EMAIL PROTECTED] when
i request for a new

password in the login page. 



I tried to translate this sentence in the

/otrs/Kernel/Language/es.pl file but i didn't
find such sentence. 



I also tried to find it in Kernel/Config/Defaults.pm
to copy into Kernel/Config.pm but I only found the subject and the body

of the email OTRS sends with the new password,  not
the message that appears over the username fieldtext in the login page.



¿Can anyone tell me how can i translate it?



Thanks











Carlos Andrés Cardona

Analista de Informática

Centro de Tecnologías de Información y Comunicación



Universidad Pontificia Bolivariana

Circular 1 No 70-01 Bloque 9

Medellín COLOMBIA

Tel:+57 4 415 9006

Fax: +57 4 230 6164

[EMAIL PROTECTED]

-- www.upb.edu.co
--

UPB 70 años de Transformación Social y Humana








___
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 orr consulting for your OTRS system?
= http://www.otrs.com/

[otrs-de] OTRS Login Frage

[Christopher R. Parr]

Hallo!

Ich habe OTRS 1.3.2 auf sarge stable installiert. Wie kann ich den
Sprachauswahldialog vom Login screen ausblenden?

Danke.
___
OTRS Mailingliste: otrs-de - Webpage: http://otrs.org/
Archiv: http://lists.otrs.org/pipermail/otrs-de/
Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/
Support oder Consulting fuer Ihr OTRS System?
= http://www.otrs.com/

[otrs] login

[Mamakwa M. Sefiri]

Is it possible to make the system recognize the Customer and
Agent login details whenever they login, only if they have login before on the
system.



Thanks

Mamakwa










___
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/

[otrs] login

[Mamakwa M. Sefiri]

I am not sure what I did but after activating the CustomerGroupSupport
I can not login on the LOG S CALL login window



Please advise



thanks






___
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/

[otrs] OTRS login: redirection limit for this URL exceeded

[Graham Leggett]

Hi all,

Another problem I am having with my OTRS install: Having dumped the 
database and started again, and am having a further problem with login.


After entering your login details, the message Redirection limit for 
this URL exceeded. Unable to load the requested page. This may be caused 
by cookies that are blocked. is displayed by the browser (Mozilla).


A look in the access log shows this line repeated over and over:

196.31.24.162 - - [25/Mar/2006:09:07:23 -0600] GET 
/otrs/index.pl?Session=10ec825a265cbeacb4730c1ed8af65b286 HTTP/1.1 302 
107 https://yyy/otrs/index.pl; Mozilla/5.0 (X11; U; Linux i686; en-US; 
rv:1.7.12) Gecko/20060130 Red Hat/1.7.12-1.4.2


All lines have differing session ids.

I have checked the browser cookie settings, and these are set to the 
default setting (allow cookies based on privacy settings). Changing the 
cookie setting to allow all makes no difference.


Has anybody seen this behaviour before?

Regards,
Graham
--


smime.p7s
Description: S/MIME Cryptographic Signature
___
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/

Re: [otrs] OTRS login: redirection limit for this URL exceeded

[Graham Leggett]

Graham Leggett wrote:


A look in the access log shows this line repeated over and over:

196.31.24.162 - - [25/Mar/2006:09:07:23 -0600] GET 
/otrs/index.pl?Session=10ec825a265cbeacb4730c1ed8af65b286 HTTP/1.1 302 
107 https://yyy/otrs/index.pl; Mozilla/5.0 (X11; U; Linux i686; en-US; 
rv:1.7.12) Gecko/20060130 Red Hat/1.7.12-1.4.2


Some Google searching located 
http://lists.otrs.org/pipermail/otrs/2005-July/008334.html which 
described the need to use Apache::compat to stop weird things happening.


The next problem I face is that mod_perl v2.0.2 has for some reason 
renamed most of the Apache perl modules from Apache to Apache2.


I tried to fix some of the problems by creating symlinks from 
Apache2::compat to Apache::compat (and others), but this hasn't seemed 
to worked.


Is there any hope of getting OTRS to work with mod_perl 2.0.2? My system 
is running httpd v2.2.0, and downgrading is not practical.


In the mean time I have disabled mod_perl entirely, and now OTRS works 
without errors.


Regards,
Graham
--


smime.p7s
Description: S/MIME Cryptographic Signature
___
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/

[otrs] Login Error message login failed!

[Jesse]

I recently installed otrs and followed the suse howto but when I login
I get this error:

"Login failed! Your username or password was entered
incorrectly."

I'm not sure how to add a user to get this to
work, but I've tried the root user and the otrs user and get this
message on both accounts.

thanks
marshall



___
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/

Re: [otrs] Login Error message login failed!

[Robert Kehl]

On Sunday, May 30, 2004 10:35 PM
Jesse [EMAIL PROTECTED] wrote:
 I recently installed otrs and followed the suse howto but when I
 login I get this error:

 Login failed! Your username or password was entered incorrectly.

 I'm not sure how to add a user to get this to work, but I've tried
 the root user and the otrs user and get this message on both
 accounts.

Try [EMAIL PROTECTED] with the password root. If that doesn't help, see:
http://doc.otrs.org/1.2/en/html/problems-with-mysql.html#PROBLEMS-LOST-MYSQL-ROOT-PW

hth,

Robert Kehl

--
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
 http://www.otrs.de/ :: Tel. +49 (0)6172 4832388

___
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/

Re: [otrs] Login not possible: crypt() on BSD systems

[Robert Kehl]

On Tuesday, April 20, 2004 1:42 PM
Jan Herbst [EMAIL PROTECTED] wrote:
 Crypt() is the problem. But how to solve the problem? Maybe this is
 useful for debugging. I still found no solution for my problem.

Does the problem still persist?

Robert Kehl

--
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
 http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
___
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/

[otrs] Login not possible: crypt() on BSD systems

[Jan Herbst]

Hallo!

I have installed OTRS 1.2.3 from the sources. No Problems:

[EMAIL PROTECTED]:/# perl -cw /usr/local/otrs/bin/cgi-bin/index.pl
/usr/local/otrs/bin/cgi-bin/index.pl syntax OK
[EMAIL PROTECTED]:/# perl -cw /usr/local/otrs/bin/PostMaster.pl
/usr/local/otrs/bin/PostMaster.pl syntax OK

But after inserting the initial SQL data, i can't login with the login
combination ([EMAIL PROTECTED], root) given in the documentation.

I found the following errors in /var/log/messages:

Apr 20 09:31:18 heli OTRS-CGI-10[2539]:
[Notice][Kernel::System::Auth::DB::Auth] The crypt() of your mod_perl(2) is
not working correctly! Update mod_perl!
Apr 20 09:31:18 heli OTRS-CGI-10[2539]:
[Notice][Kernel::System::Auth::DB::Auth] User: [EMAIL PROTECTED] with wrong
Pw!!! (REMOTE_ADDR: 192.168.100.10)

I'm not using mod_perl. I assume, the problem is the crypt() function. A
test does not return the encrypted password as given in the documentation.

[EMAIL PROTECTED]:/# perl -e 'print crypt(root, [EMAIL PROTECTED]) . \n'
$2a$04$root..QHSCVtcO1oNz6sch8SNzSuYTbSVQtwK

How could i configure OTRS tu work with this version of crypt()?

I found out, that there is a test for bug inside RedHat8, where the the
encrypted password is compared with a given one. I changed

(crypt('root', '[EMAIL PROTECTED]') eq 'roK20XGbWEsSM')) 

to

(crypt('root', '[EMAIL PROTECTED]') eq 'QHSCVtcO1oNz6sch8SNzSuYTbSVQtwK'))

inside Kernel/System/User.pm, Kernel/System/CustomerAuth/DB.pm,
Kernel/System/CustomerUser/DB.pm and Kernel/System/Auth/DB.pm. I changed the
password for [EMAIL PROTECTED] inside the database to. But it didn't work. I
got the same error message as mentioned above.

Could anyone help me please?


With kind regards

Jan

-- 
NEU : GMX Internet.FreeDSL
Ab sofort DSL-Tarif ohne Grundgebühr: http://www.gmx.net/dsl

___
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/

Re: [otrs] Login not possible: crypt() on BSD systems

[Jan Herbst]

Hello,

 [EMAIL PROTECTED]:/# perl -cw /usr/local/otrs/bin/cgi-bin/index.pl
 /usr/local/otrs/bin/cgi-bin/index.pl syntax OK
 [EMAIL PROTECTED]:/# perl -cw /usr/local/otrs/bin/PostMaster.pl
 /usr/local/otrs/bin/PostMaster.pl syntax OK

I forget to write, this is perl 5.8.2. FreeBSD 5.2.1 is running as operating
system on the server.


With kind regards

Jan

-- 
Sie haben neue Mails! - Die GMX Toolbar informiert Sie beim Surfen!
Jetzt aktivieren unter http://www.gmx.net/info

___
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/

Re: [otrs] Login not possible: crypt() on BSD systems

[Jan Herbst]

Hello!

 I found the following errors in /var/log/messages:
 
 Apr 20 09:31:18 heli OTRS-CGI-10[2539]:
 [Notice][Kernel::System::Auth::DB::Auth] The crypt() of your mod_perl(2)
 is not working correctly! Update mod_perl!
 Apr 20 09:31:18 heli OTRS-CGI-10[2539]:
 [Notice][Kernel::System::Auth::DB::Auth] User: [EMAIL PROTECTED] with wrong
 Pw!!! (REMOTE_ADDR: 192.168.100.10)

I set Debug to 1 and get the following messages now:

Apr 20 13:33:15 heli OTRS-CGI-10[94139]:
[Notice][Kernel::System::Auth::DB::Auth] The crypt() of your mod_perl(2) is
not working correctly! Update mod_perl!
Apr 20 13:33:15 heli OTRS-CGI-10[94139]:
[Notice][Kernel::System::Auth::DB::Auth] User: '[EMAIL PROTECTED]' tried to
login with Pw: 'root'
(1/$2a$04$Q.NaNm9VdHtKYWEXxWfp4t9wLK1rhJuo6/QHSCVtcO1oNz6sch8SNzSuYT
bSVQtwK/QH/192.168.175.119)
Apr 20 13:33:15 heli OTRS-CGI-10[94139]:
[Notice][Kernel::System::Auth::DB::Auth] User: [EMAIL PROTECTED] with wrong
Pw!!! (REMOTE_ADDR: 192.168.100.10)

Crypt() is the problem. But how to solve the problem? Maybe this is useful
for debugging. I still found no solution for my problem.


With kind regards

Jan

-- 
Sie haben neue Mails! - Die GMX Toolbar informiert Sie beim Surfen!
Jetzt aktivieren unter http://www.gmx.net/info

___
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/

[otrs] Login - How can I remove the (request new password) option from t he OTRS Admin Login page?

[Stig Graasbøl Rasmussen]

Title: Message



Hi,

Is there a way I can 
remove / disable the (request new password) option from the Admin Login 
page?

The thing is that I 
am interested in administrating the passwords in a central way and therefore I 
don't want users or agents to request new passwords 
themselves.
And another thing is that I have not got my 
sendmail to work yet and I won't risk that sombody requests a new password send 
by a mail that never reach its destination.

Thanks
Stig




___
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/

Re: [otrs] Login - How can I remove the (request new password) optionfrom t he OTRS Admin Login page?

[Robert Kehl]

On Wednesday, March 24, 2004 12:36 PM
Stig Graasbøl Rasmussen [EMAIL PROTECTED] wrote:
 Is there a way I can remove / disable the (request new password)
 option from the Admin Login page?

Set this in Kernel/Config.pm:

# LostPassword
# (use lost password feature)
$Self-{LostPassword} = 1;

hth,

Robert Kehl

--
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
 http://www.otrs.de/ :: Tel. +49 (0)6172 4832388

___
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/

[otrs] Login - How can I remove the (request new password) option from the OTRS Admin Login page?

[Stig Graasbøl Rasmussen]

Title: Message



Thanks 
Robert,

I added the line you 
suggested into my /Kernel/Config.pm but I still get the (request new password 
option) on my login pages... Do I have to restart OTRS or apache to make the 
changes take effect?

/Stig

-
On Wednesday, March 24, 2004 12:46 
PMRobert Kehl robert.kehl at 
otrs.de wrote: 
$Self-{LostPassword} = 1;Ups - for sure you want a 
 $Self-{LostPassword} = 0;in your 
situation. *g*Regards,Robert Kehl
___
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/

Re: [otrs] Login - How can I remove the (request new password) optionfrom the OTRS Admin Login page?

[Robert Kehl]

On Wednesday, March 24, 2004 1:48 PM
Stig Graasbøl Rasmussen [EMAIL PROTECTED] wrote:
 I added the line you suggested into my /Kernel/Config.pm but I still
 get the (request new password option) on my login pages... Do I have
 to restart OTRS or apache to make the changes take effect?

At last, yes.

hth,

Robert Kehl

--
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
 http://www.otrs.de/ :: Tel. +49 (0)6172 4832388

___
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/

Re: [otrs] Login page - font weirdness on Win XP/IE6

[Erik Mathis]

Increase the Font size in IE. I had a similar problem using 
FireBird(FireFox now) on my Knoppix HDD install. FireBird worked 
flawlessly when I was using windows.



Michael Rojas wrote:
Greetings,

I've been an OTRS user for several months now.  I don't think my problem
is OTRS-specific, but I am curios to know if anyone else has experienced
this...  I have a VAIO laptop running Windows XP Home, with IE 6.  I
recently went to the M$ windows update site to install M$'s patches.  I
don't know if that has anything to do with it, but lately, when I access
my OTRS log in page I no longer get the 'circle' symbols that appeared
when I typed in my password, and my fonts are slightly distorted on the
log in page, and the rest of my pages.  Whenever I log in to OTRS from
any other computer, everything remains the same.  This annoyance only
appears on my laptop, so I'm almost certain that it has to do with a M$
patch or something related.  I haven't been able to replicate the
problem to determine it's cause.  This doesn't necessarily impair my
OTRS set up, but it makes it slightly difficult to read trouble tickets
due to the distortion of the fonts.  I've only see this behavior on my
OTRS, and on the OTRS.ORG site.  There must be an issue with an M$ patch
that changes either my OS, IE6, or both that affects how I view my OTRS
or OTRS.ORG... Maybe something to do with how web-based content is
formatted, or fonts?
Any help from any one else who has experienced this would be greatly
appreciated...
Thanks!

Michael







Michael Rojas,
Systems Administrator
South Texas Internet
956.504.5252
http://www.ies.net
Some dream of success... Others work hard at it. 

---
[South Texas Internet scanned this E-mail for viruses using Declude Virus]
___
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/
--
Erik Mathis
AIU Dunwoody Network Administrator
___
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/