[rt-users] User creation with encoding errors

[Senoner Samuel]

I have two similar (almost identical) systems.
 
both Debian
both rt 3.0.4
both postgres 7.3.3
both searchbuilder 0.86
 
I have on both my LDAP User Lookup
This works on user creationn. If I have a User with an ä oder à somewhere, on one server I get following error:
 
 
[Fri Sep  5 17:04:21 2003] [warning]: DBD::Pg::st execute failed: ERROR:  Invali
d UNICODE character sequence found (0xe4e000) at /usr/share/perl5/DBIx/SearchBui
lder/Handle.pm line 410.
 (/usr/share/perl5/RT.pm:235)
[Fri Sep  5 17:04:21 2003] [warning]: RT::Handle=HASH(0x948cdc0) couldn't execut
e the query 'INSERT INTO Users (City, RealName, EmailAddress, Creator, Gecos, Pa
ssword, Country, LastUpdatedBy, Zip, WorkPhone, Created, id, Organization, Name,
 LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/shar
e/perl5/DBIx/SearchBuilder/Handle.pm line 417.
 (/usr/share/perl5/RT.pm:235)
[Fri Sep  5 17:04:21 2003] [error]: Could not create a new user -  (/usr/share/p
erl5/RT/User_Overlay.pm:277)
[Fri Sep  5 17:04:21 2003] [warning]: DBD::Pg::st execute failed: ERROR:  curren
t transaction is aborted, queries ignored until end of transaction block at /usr
/share/perl5/DBIx/SearchBuilder/Handle.pm line 410.

Where can I find the difference in the encoding?
Or whould it be the best solution to convert my input by LDAP somewhere?
But I just import my data with LDAP and pass UserInfo to User Create.
But the strange thing is that the two servers are almost identic.
 
Do someone has an idea?
 
Jesse, I saw that somewhere a user wrote it also to the mailing list, you said to him to write directly to you.
 
I wanted to start using RT on Monday, but I suddently fount that everywhere in my Active Directory there are this strange characters, so I have this big problem.
 
Thank you
 
Samuel Senoner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030905/37102bc3/attachment.htm>