[rt-devel] RE: [rt-users] User creation with encoding errors

[Senoner Samuel]

 I resolved this problem, it hasn't anything to do with the request tracker and his dependent packages, also nothing with LDAP.
It was a debian problem in converting the input data to utf8.

Strange.

Samuel


-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com] 
Sent: Friday,05 September,2003 22:23
To: Senoner Samuel




On Fri, Sep 05, 2003 at 10:12:55PM +0200, Senoner Samuel wrote:
> I don't really want to update to a RC, also because I use debian apt to install my packages.....
> But if you can tell me wich patches to update to my 3.0.4.......

Sorry, no.


> One other thing I saw, is that when I change details or something else on the server with the problem, the characters are displayes correctly.
> In this case, if I look into the database with my terminal, in the system with the problem I see ?? and in the other one, I see something like <0A><C5>.
> I can't remember exactly because now I'am at home, and it's 10 PM here.

RT stores everything in unicode, which is why they won't display correctly on your iso-8859-1 terminal.

>  
> It is very strange because both systems should be identical.
>  
> Thanks for any ideas.
>  
> Samuel
> 
> 	-----Original Message----- 
> 	From: Jesse Vincent [mailto:jesse at bestpractical.com] 
> 	Sent: Fri 9/5/2003 9:52 PM 
> 	To: Senoner Samuel 
> 	Cc: 
> 	Subject: Re: [rt-users] User creation with encoding errors
> 	
> 	
> 
> 
> 
> 
> 	On Fri, Sep 05, 2003 at 07:53:34PM +0200, Senoner Samuel wrote:
> 	> 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:
> 	
> 	Can you tell me if it's still an issue with 3.0.5rc1?
> 	
> 	
> 	> 
> 	> 
> 	> [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
> 	
> 	--
> 	http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.
> 	
> 

--
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.