[rt-users] how to check if can receive email from special domain

2011-01-09 Thread nectar
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


[rt-users] why my rt4 loop create new ticket or reply ticket from the same email

2011-12-17 Thread nectar
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


Re: [rt-users] why my rt4 loop create new ticket or reply ticket from the same email

2011-12-19 Thread nectar
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] cannot get result of search Chinese character - centos 5.4

2011-12-19 Thread nectar
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] cannot get result of search Chinese character - centos 5.4

2011-12-19 Thread nectar
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

Re: [rt-users] cannot get result of search Chinese character - centos 5.4

2011-12-23 Thread nectar
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

2011-12-28 Thread nectar
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


[rt-users] Unknown encoding 'GB18030' at RT4.0.4

2011-12-28 Thread nectar
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


[rt-users] How to get requestor Custom Fields data on Template

2010-09-11 Thread nectar
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!


Re: [rt-users] How to get requestor Custom Fields data on Template

2010-09-12 Thread nectar
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!