[rt-users] Unknown encoding 'GB18030' at RT4.0.4
Sir, Emails which encode with 'GB18030' can not receive by RT-4.0.4. Mail log as: Dec 29 08:51:08 server postfix/local[26843]: A58FF51008F: to=, relay=local, delay=239881, delays=239880/0.95/0/0.35, dsn=4.3.0, status=deferred (temporary failure. Command output: RT server error. The RT server which handled your email did not behave as expected. It said: Unknown encoding 'GB18030' at /opt/rt4/sbin/../lib/RT/I18N.pm line 323 Stack: [/usr/local/lib/perl5/5.10.1/Carp.pm:44] [/usr/local/lib/perl5/5.10.1/i686-linux-thread-multi/Encode.pm:189] [/opt/rt4/sbin/../lib/RT/I18N.pm:323] [/opt/rt4/sbin/../lib/RT/I18N.pm:542] [/opt/rt4/sbin/../lib/RT/I18N.pm:214] [/opt/rt4/sbin/../lib/RT/EmailParser.pm:282] [/opt/rt4/sbin/../lib/RT/Interface/Email.pm:1400] [/opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway:61] ) I tried to install Encode::HanExtra, but still have the same error message. Refer: http://www.gossamer-threads.com/lists/rt/commit/106389 -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] cannot get result of search Chinese character - centos 5.4
Sir, Looks like can search Chinese character when use Perl 5.10 instead of Perl 5.8.8 on CentOS 5. -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] cannot get result of search Chinese character - centos 5.4
Kevin, Thanks for your reply. Same database, from Debian box is okay, but CentOS 5.4 is not. Here it sql file: INSERT INTO `Tickets` (`id`, `EffectiveId`, `Queue`, `Type`, `IssueStatement`, `Resolution`, `Owner`, `Subject`, `InitialPriority`, `FinalPriority`, `Priority`, `TimeEstimated`, `TimeWorked`, `Status`, `TimeLeft`, `Told`, `Starts`, `Started`, `Due`, `Resolved`, `LastUpdatedBy`, `LastUpdated`, `Creator`, `Created`, `Disabled`) VALUES (1, 1, 1, 'ticket', 0, 0, 6, '中文测试 - test - 123abc', 0, 0, 0, 0, 0, 'new', 0, NULL, '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 12, '2011-12-20 14:02:47', 12, '2011-12-20 14:02:47', 0), (2, 2, 1, 'ticket', 0, 0, 6, '中文测试2', 0, 0, 0, 0, 0, 'new', 0, NULL, '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 12, '2011-12-20 15:51:25', 12, '2011-12-20 15:51:24', 0); Here it is from rt.log(Debian): [debug]: SQL(0.167067s): SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Subject LIKE '%中%') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ORDER BY main.id ASC LIMIT 50; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1064) Here it is from rt.log(CentOS): [debug]: SQL(0.000729s): SELECT count(main.id) FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Subject LIKE '%涓?') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1064) Thanks, -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] cannot get result of search Chinese character - centos 5.4
kevin, a. search from RT as "http://domain/Search/Simple.html?q=中文";, RT got: Found 0 tickets b. search database using SQL as "SELECT * FROM `rt4`.`Tickets` WHERE ( `Subject` LIKE '%中文%' )", database got: Showing rows 0 - 0 (1 total, Query took 0.0003 sec) Does it mean that we can search Chinese character from sql query, but can not from RT web page? -- LiuJia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] cannot get result of search Chinese character - centos 5.4
Sir, Installed RT4.0.4 on CentOS 5.4 box, make new database from RT or restore mysql file, everything looks well. But cannot get result of search Chinese character. For example, if ticket subject is "Best Practical 公司", then we can search "Best" or "Practical" to list this ticket, but "公司" get no result. I tried to install old version of FCGI(from 0.74 to 0.68), but still the same issue. refer: Centos 5.4 + FCGI + Unicode in messages = Failure - http://www.gossamer-threads.com/lists/rt/users/92359 Do you have advise? Thanks, -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] why my rt4 loop create new ticket or reply ticket from the same email
Christonph, Thanks for you reply. But I do not know how to test, tried to test rt-mailgate, get blow information. # echo tr-lai |/opt/rt4/bin/rt-mailgate --queue sales --action correspond --url https://domain/rt --debug /opt/rt4/bin/rt-mailgate: temp file is '/tmp/SjjXGauJZ7/SzAAaaBYHJ' /opt/rt4/bin/rt-mailgate: connecting to https://domain/rt/REST/1.0/NoAuth/mail-gateway An Error Occurred = 500 read failed: /opt/rt4/bin/rt-mailgate: undefined server error -- LiuJia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] why my rt4 loop create new ticket or reply ticket from the same email
Sir, Upgraded from 3.8 to rt4 at debian6 + postfix, but my new rt4 create new tickets from loop emails. For example, if people email "hello" to rt4, then rt4 will created ticket #2, and after some minute, rt4 will create ticket#5 or other new tickets with the same email content. More emails are being sent out from rt, and most of them are the same content. I tried to check RT configure, postfix configure and apache configure files. Still can not find solution. Do you have advise? Thank you. -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] how to check if can receive email from special domain
Sir, Our RT can not receive email from special domain(for example, t...@test.com), it is okay before. a. We can sent email to t...@test.com via RT web UI(create ticket for him) b. But RT can not receive email from t...@test.com or he can not update ticket c. If we use m...@gmail.com sent email to t...@test.com, m...@gmail.com can get reply email from t...@test.com If our RT blocked emails from t...@test.com? Thank you. -- LiuJia
Re: [rt-users] How to get requestor Custom Fields data on Template
Emmanuel, Thanks, it works. -- LiuJia On Sun, Sep 12, 2010 at 4:43 AM, Emmanuel Lacour wrote: > On Sat, Sep 11, 2010 at 05:07:21PM +0800, nectar wrote: >> Sir >> >> We can use {$Ticket->FirstCustomFieldValue('name')} to get custom >> fileds which apply ticket, and use >> {$Ticket->CreatorObj->FirstCustomFieldValue('InstantMessaging')} to >> get custom fileds which belong creator, but sometimes, we created new >> ticket for clients(for example, create a abuse ticket for client). How >> to get requestor Custom Fields data? RequestorObj is not working. >> > > if you're working with only one requestor per ticket, you can user this: > > $Ticket->Requestors->UserMembersObj->First->FirstCustomFieldValue('InstantMessaging') > > > RT Training in Washington DC, USA on Oct 25 & 26 2010 > Last one this year -- Learn how to get the most out of RT! > RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
[rt-users] How to get requestor Custom Fields data on Template
Sir We can use {$Ticket->FirstCustomFieldValue('name')} to get custom fileds which apply ticket, and use {$Ticket->CreatorObj->FirstCustomFieldValue('InstantMessaging')} to get custom fileds which belong creator, but sometimes, we created new ticket for clients(for example, create a abuse ticket for client). How to get requestor Custom Fields data? RequestorObj is not working. Thanks, -- LiuJia RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!