Re: [rt-users] [RT4] Mailgate couldn't find sender's address and load a valid user
14.01.12 23:43, Ruslan Zakirov пишет:
Hi,
Tested with RT 4.0.4 and all modules up to date from the CPAN. Works
without any issues. If user has rights to create tickets then ticket
created and non ASCII symbols are decrypted.
Все читабельно, в интерфейсе вижу Александр Кубаткин в заголовках письма.
Additional information required to diagnose this further.
After rollover to
bsdpan-Email-Address-1.892
from
bsdpan-Email-Address-1.894
issue was resolved,
Thank you for your help.
Question: when RT will be work with latest {bsdpan|p5}-Email-Address ?
Periodic ports updates can break RT again ...
On Sat, Jan 14, 2012 at 14:25, Alexander Kubatkin wrote:
Hello,
08.01.12 23:54, Ruslan Zakirov пишет:
Hi,
From address is wrong in testmail or new users don't have permissions
to create tickets.
I'm not sure in this, try to check with test message which in "From:" record
contain value like this:
From: =?UTF-8?B?
encoded name is in a russian, such "From:" give us
not ok - Could not load a valid user
if this record changed to
From: "test"
or
From: test
there is no problem and ticket created.
So this is problem in RT, I hope this would be fixed ASAP.
On Mon, Jan 2, 2012 at 14:56, Ronan MOUCHOUXwrote:
Hello,
I'm trying to configure RT4 so that it will be possible to create ticket
from email. The mail server and RT are running on the same server.
I'm running on RHEL5, so I've copy /opt/rt4/bin/rt-mailgate to
/etc/smrsh/rt-mailgate
I've update the /etc/aliases file with this line :
rtest:"|/etc/smrsh/rt-mailgate --queue General --action correspond --url
http:/x.x.x.x:8080"
rtest is the username of an existing RT user. In the WEB interface, I've
granted the group 'Everyone' for the 'General' queue (Create a ticket and
Reply to ).
In addition in RT_SiteConfig.pm I've added this line : Set($WebExternalAuto,
1);
But when I try to send a mail through the command " /etc/smrsh/rt-mailgate
--queue General --action correspond --url http://x.x.x.x:8080 --debug<
/root/testmsg"
i get this error from the mailgate debug :
/etc/smrsh/rt-mailgate: temp file is '/tmp/EwqftI9qgS/E83e2Ts_i_'
/etc/smrsh/rt-mailgate: connecting to
http://203.0.57.51:8080/REST/1.0/NoAuth/mail-gateway
not ok - Could not load a valid user
and this in the logs provided by "/opt/rt4/sbin/rt-server" :
[Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $From in
pattern match (m//) at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 151.
(/opt/rt4/sbin/../lib/RT/Interface/Email.pm:151)
[Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $From in
pattern match (m//) at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 151.
(/opt/rt4/sbin/../lib/RT/Interface/Email.pm:151)
[Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $From in
string eq at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 151.
(/opt/rt4/sbin/../lib/RT/Interface/Email.pm:151)
[Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $line in
pattern match (m//) at /usr/local/share/perl5/Mail/Header.pm line 174.
(/usr/local/share/perl5/Mail/Header.pm:174)
[Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $line in
substitution (s///) at /usr/local/share/perl5/Mail/Header.pm line 176.
(/usr/local/share/perl5/Mail/Header.pm:176)
[Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $line in
substitution (s///) at /usr/local/share/perl5/Mail/Header.pm line 176.
(/usr/local/share/perl5/Mail/Header.pm:176)
[Mon Jan 2 10:50:14 2012] [error]: Couldn't find sender's address
(/opt/rt4/sbin/../lib/RT/Interface/Email/Auth/MailFrom.pm:71)
[Mon Jan 2 10:50:14 2012] [error]: Could not record email: Could not load a
valid user (/opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway:75)
I've probably missed something during the configuration. Does anyone have a
clue?
Thanking you in advance,
Best regards,
Ronan
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5&6, 2012
--
Александр Кубаткин
Руководитель отдела ИТ
Бэйрэль Телеком ISP
http://www.beirel.ru/?p=contacts
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5& 6, 2012
--
Александр Кубаткин
Руководитель отдела ИТ
Бэйрэль Телеком ISP
http://www.beirel.ru/?p=contacts
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
Re: [rt-users] [RT4] Mailgate couldn't find sender's address and load a valid user
Hello, 08.01.12 23:54, Ruslan Zakirov пишет: > Hi, > > From address is wrong in testmail or new users don't have permissions > to create tickets. > I'm not sure in this, try to check with test message which in "From:" record contain value like this: From: =?UTF-8?B?0JDQu9C10LrRgdCw0L3QtNGAINCa0YPQsdCw0YLQutC40L0=?= encoded name is in a russian, such "From:" give us not ok - Could not load a valid user if this record changed to From: "test" or From: test there is no problem and ticket created. So this is problem in RT, I hope this would be fixed ASAP. > On Mon, Jan 2, 2012 at 14:56, Ronan MOUCHOUX wrote: >> Hello, >> >> I'm trying to configure RT4 so that it will be possible to create ticket >> from email. The mail server and RT are running on the same server. >> I'm running on RHEL5, so I've copy /opt/rt4/bin/rt-mailgate to >> /etc/smrsh/rt-mailgate >> >> I've update the /etc/aliases file with this line : >> rtest:"|/etc/smrsh/rt-mailgate --queue General --action correspond --url >> http:/x.x.x.x:8080" >> >> rtest is the username of an existing RT user. In the WEB interface, I've >> granted the group 'Everyone' for the 'General' queue (Create a ticket and >> Reply to ). >> In addition in RT_SiteConfig.pm I've added this line : Set($WebExternalAuto, >> 1); >> >> But when I try to send a mail through the command " /etc/smrsh/rt-mailgate >> --queue General --action correspond --url http://x.x.x.x:8080 --debug< >> /root/testmsg" >> i get this error from the mailgate debug : >> /etc/smrsh/rt-mailgate: temp file is '/tmp/EwqftI9qgS/E83e2Ts_i_' >> /etc/smrsh/rt-mailgate: connecting to >> http://203.0.57.51:8080/REST/1.0/NoAuth/mail-gateway >> not ok - Could not load a valid user >> >> and this in the logs provided by "/opt/rt4/sbin/rt-server" : >> [Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $From in >> pattern match (m//) at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 151. >> (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:151) >> [Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $From in >> pattern match (m//) at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 151. >> (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:151) >> [Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $From in >> string eq at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 151. >> (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:151) >> [Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $line in >> pattern match (m//) at /usr/local/share/perl5/Mail/Header.pm line 174. >> (/usr/local/share/perl5/Mail/Header.pm:174) >> [Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $line in >> substitution (s///) at /usr/local/share/perl5/Mail/Header.pm line 176. >> (/usr/local/share/perl5/Mail/Header.pm:176) >> [Mon Jan 2 10:50:14 2012] [warning]: Use of uninitialized value $line in >> substitution (s///) at /usr/local/share/perl5/Mail/Header.pm line 176. >> (/usr/local/share/perl5/Mail/Header.pm:176) >> [Mon Jan 2 10:50:14 2012] [error]: Couldn't find sender's address >> (/opt/rt4/sbin/../lib/RT/Interface/Email/Auth/MailFrom.pm:71) >> [Mon Jan 2 10:50:14 2012] [error]: Could not record email: Could not load a >> valid user (/opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway:75) >> >> >> I've probably missed something during the configuration. Does anyone have a >> clue? >> >> Thanking you in advance, >> Best regards, >> Ronan >> >> >> RT Training Sessions (http://bestpractical.com/services/training.html) >> * Boston — March 5& 6, 2012 > > > -- Александр Кубаткин Руководитель отдела ИТ Бэйрэль Телеком ISP http://www.beirel.ru/?p=contacts RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] problem with upgrade rt 3.6.7->3.8.1rc4
> On Aug 15, 2008, at 8:02 AM, Alexander Kubatkin wrote:
> > Hello.
> >
> > My RT-3.6.7 working fine under FreeBSD 7-STABLE x86_64 with:
> > 1. Apache 2.2.8
> > 2. mod_perl2-2.0.3_3,3
> > 3. MySQL 5.0.51-log
> > 4. all p5 and other packages from lastest FreeBSD ports
> > current database 2 years old and have size ~500MB and attachments
> > have 112888 elements
>
> Alexander, can you tell us if anything shows up in the mysql error
> logs? Also, what version of DBD::mysql do you have installed?
any idea in wich way to move?
i also try to clean install (3.8.1 release) in differnet db on same host and i
got following:
-
# make initialize-database
/usr/bin/perl sbin/rt-setup-database --action init --dba root
--prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to
your mysql instance on localhost as root
Please specify that user's database password below. If the user has no database
password, just press return.
Password:
Working with:
Type: mysql
Host: localhost
Name: rt3_2
User: rt_user
DBA: root
Now creating a mysql database rt3_2 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs
Granting access to rt_user@'localhost' on rt3_2.
Done.
Now inserting RT core system objects
[Tue Aug 19 01:39:41 2008] [warning]: DBD::mysql::st execute failed: MySQL
server has gone away
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Tue Aug 19 01:39:41 2008] [warning]: RT::Handle=HASH(0x297fae8) couldn't
execute the query 'INSERT INTO GroupMembers (GroupId, MemberId)
VALUES (?, ?)' at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x297fae8)', 'INSERT
INTO GroupMembers (GroupId, MemberId) VALUES (?, ?)', 2, 1) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 353
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x297fae8)',
'GroupMembers', 'GroupId', 2, 'MemberId', 1) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm line
36
DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x297fae8)',
'GroupMembers', 'GroupId', 2, 'MemberId', 1) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1293
DBIx::SearchBuilder::Record::Create('RT::GroupMember=HASH(0x306e568)',
'GroupId', 2, 'MemberId', 1) called at /usr/local/rt3/lib/RT/Record.pm line 289
RT::Record::Create('RT::GroupMember=HASH(0x306e568)', 'GroupId', 2,
'MemberId', 1) called at /usr/local/rt3/lib/RT/GroupMember_Overlay.pm line 251
RT::GroupMember::_StashUser('RT::GroupMember=HASH(0x306e568)', 'Group',
'RT::Principal=HASH(0x30478b8)', 'Member', 'RT::Principal=HASH(0x2f5ff78)')
called at /usr/local/rt3/lib/RT/Group_Overlay.pm line 524
RT::Group::_CreateACLEquivalenceGroup('RT::Group=HASH(0x3004fa8)',
'RT::Principal=HASH(0x2f5ff78)') called at
/usr/local/rt3/lib/RT/User_Overlay.pm
line 397
RT::User::_BootstrapCreate('RT::User=HASH(0x2f601d8)', 'Name', 'RT_System',
'RealName', 'The RT System itself', 'Comments', 'Do not delete or modify
this user. It is integral to RT\'s in...', 'Creator', 1, ...) called at
/usr/local/rt3/lib/RT/Handle.pm line 556
RT::Handle::InsertInitialData('RT::Handle=HASH(0x297fae8)') called at
sbin/rt-setup-database line 240
main::action_coredata('prompt-for-dba-password', 1, 'action', 'init', 'dba',
'root') called at sbin/rt-setup-database line 166
(/usr/local/lib/perl5/5.8.8/Carp.pm:272)
[Tue Aug 19 01:39:41 2008] [crit]: Couldn't add the user to his own acl
equivalence group: (/usr/local/rt3/lib/RT/Group_Overlay.pm:528)
[Tue Aug 19 01:39:42 2008] [warning]: DBD::mysql::st execute failed: MySQL
server has gone away
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Tue Aug 19 01:39:42 2008] [warning]: RT::Handle=HASH(0x297fae8) couldn't
execute the query 'DELETE FROM Groups WHERE id=? '
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x297fae8)', 'DELETE
FROM Groups WHERE id=? ', 2) called
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1326
DBIx::SearchBuilder::Record::__Delete('RT::Group=HASH(0x3004fa8)') calle
Re: [rt-users] problem with upgrade rt 3.6.7->3.8.1rc4
В сообщении от Пятница 15 августа 2008 вы написали: > On Aug 15, 2008, at 8:02 AM, Alexander Kubatkin wrote: > > Hello. > > > > My RT-3.6.7 working fine under FreeBSD 7-STABLE x86_64 with: > > 1. Apache 2.2.8 > > 2. mod_perl2-2.0.3_3,3 > > 3. MySQL 5.0.51-log > > 4. all p5 and other packages from lastest FreeBSD ports > > current database 2 years old and have size ~500MB and attachments > > have 112888 elements > > Alexander, can you tell us if anything shows up in the mysql error > logs? no special errors, only regular not critical errors such us: 080814 16:48:05 mysqld started 080814 16:48:06 InnoDB: Started; log sequence number 0 2672904431 080814 16:48:06 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.51a-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.51a 080814 17:07:40 [Warning] Aborted connection 6 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 17:24:19 [Warning] Aborted connection 18 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 17:24:20 [Warning] Aborted connection 3 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 17:24:21 [Warning] Aborted connection 19 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 17:24:22 [Warning] Aborted connection 15 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 17:49:56 [Warning] Aborted connection 2 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 18:07:08 [Warning] Aborted connection 1 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 18:12:33 [Warning] Aborted connection 83 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 18:12:34 [Warning] Aborted connection 23 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 18:12:35 [Warning] Aborted connection 21 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 18:12:36 [Warning] Aborted connection 20 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 18:19:33 [Warning] Aborted connection 86 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 19:00:46 [Warning] Aborted connection 84 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:06:08 [Warning] Aborted connection 82 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:06:25 [Warning] Aborted connection 90 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:14:26 [Warning] Aborted connection 85 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:16:40 [Warning] Aborted connection 71 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:16:40 [Warning] Aborted connection 22 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:16:40 [Warning] Aborted connection 87 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:18:29 [Warning] Aborted connection 250 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:18:29 [Warning] Aborted connection 249 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:18:29 [Warning] Aborted connection 247 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:18:29 [Warning] Aborted connection 248 to db: 'rt3' user: 'rt_user' host: 'localhost' (Got an error reading communication packets) 080814 22:21:15 [Warning] Aborted connection 251 to db: 'rt3' user: 'rt_user' host: 'localhost'
[rt-users] problem with upgrade rt 3.6.7->3.8.1rc4
Hello. My RT-3.6.7 working fine under FreeBSD 7-STABLE x86_64 with: 1. Apache 2.2.8 2. mod_perl2-2.0.3_3,3 3. MySQL 5.0.51-log 4. all p5 and other packages from lastest FreeBSD ports current database 2 years old and have size ~500MB and attachments have 112888 elements but i can't upgrade to 3.8.x, below a result from trying to upgrade to 3.8.1rc4: /usr/local/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade In order to create or update your RT database, this script needs to connect to your mysql instance on 127.0.0.1 as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: 127.0.0.1 Name: rt3 User: rt_user DBA:root Enter RT version you're upgrading from: 3.6.7 Going to apply following upgrades: * 3.7.1 * 3.7.3 * 3.7.10 * 3.7.15 * 3.7.19 * 3.7.81 * 3.7.82 * 3.7.85 * 3.7.86 * 3.7.87 * 3.8.0 * 3.8.1 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: HI THERE IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP Proceed [y/N]:y Processing 3.7.1 [Thu Aug 14 17:33:29 2008] [warning]: DBD::mysql::db selectrow_array failed: MySQL server has gone away at /usr/local/rt3/sbin/../lib/RT/Handle.pm line 257, line 4. (/usr/local/rt3/sbin/../lib/RT/Handle.pm:257) [Thu Aug 14 17:33:29 2008] [crit]: DBD::mysql::db selectrow_array failed: MySQL server has gone away at /usr/local/rt3/sbin/../lib/RT/Handle.pm line 257, line 4. (/usr/local/rt3/sbin/../lib/RT.pm:377) DBD::mysql::db selectrow_array failed: MySQL server has gone away at /usr/local/rt3/sbin/../lib/RT/Handle.pm line 257, line 4. -- Need some help to upgrade. Thanks -- Alexander Kubatkin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
