[rt-users] UNSUBSCRIBE
UNSUBSCRIBE Luciano Silva luci...@cpd.ufrgs.br mailto:luci...@cpd.ufrgs.br Divisão de Suporte a Software DRS - CPD - UFRGS Fone (51)3308-5050
[rt-users] Help with local custom login x javascript
Hello, An early time ago, I made motifications on ExternalAUTH LDAP to be possible autenticate using numeric uids users. For example, the numeric uid 001236456 can authenticate from a LDAP server. In the RT side it has a real id user with A00123456. The mofication makes a concat a word in front uid and its ok for RT and LDAP. Now I'm trying remove the need of the user put all numeric numbers on login. This a local motification, or callback. I have many users in format 00123456, and would be nice for them put only 123456 without the zeros. We adjusted a javascript function for that. I made a copy of Elements/Login for local customizations. In Login elemnt i modified this around line 105(RT 4.0.2.): div class=button-row span class=inputinput type=submit onSubmit=formatUIDnumber(this.user,8); class=button value=|/lLogin/ / /span /div My javascript function(inside Login), that checks if the numeric matchs 8 length. If not, put more 0 to complete: function formatUIDnumber(UID,sizeOK){ if IsNumeric(UID.value){ newUID = UID.value; zeros = ''; var i = newUID.length; if(newUID.length==sizeOK) return; else { for(i; isizeOK; i++){ zeros = zeros + 0; } newUID = zeros + newUID; } UID.value = newUID; return; } }; But I'm not getting that, the javascript function is not called when submit is called, is there another way to call the javascript function formatUIDnumber before it sends $user and $pass? Can you give some direction, the right way, please?
[rt-users] Login page + Javascript function
A time ago, I made motifications on ExternalAUTH LDAP to be posible autenticate numeric users. For example, the numeric uid 123645678 can authenticate from a LDAP server. In the RT side it has a real id user with A12345678. The mofication concat a word in front uid and its ok for RT and LDAP. Now I'm trying remove the need of the user put all numeric numbers on login. This a local motification, or callback. I have many users in format 1234, and would be nice for them put only 1234 without the zeros. We have a javascript function for that. I made a copy of Elements/Login for local customizations. In Login i modified this around line 105(RT 4.0.2.): div class=button-row span class=inputinput type=submit onSubmit=formatUIDnumber(this.user,8); class=button value=|/lLogin/ / /span /div My javascript function(inside Login), that checks if the numeric matchs 8 length. If not, put more 0 to complete: function formatUIDnumber(UID,sizeOK){ if IsNumeric(UID.value){ newUID = UID.value; zeros = ''; var i = newUID.length; if(newUID.length==sizeOK) return; else { for(i; isizeOK; i++){ zeros = zeros + 0; } newUID = zeros + newUID; } UID.value = newUID; return; } }; My intention is check if it has 8 numbers, if not put zeros ahead. Not getting that, the javascript function is not called when submit is called, is there another way to do that? Can you give some direction, the right way? Att. Luciano
[rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4
Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. Dale, SPHINX: I'm thing theirs is a problem with perl module DBIx::SearchBuilder, mine is 1.61, but can't connect to localhost port 3312. I tested searchd daemon and is working OK. Dale, what version of DBIx::SearchBuilder are you using? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de gekkoman Enviada em: quinta-feira, 5 de janeiro de 2012 19:02 Para: Poulter, Dale; rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Greetings, FYI I got sphinx running on 4.04 by following instructions before Christmas and everything looked ok.but then I started discovering non functioning aspects of RT post the change eg changing user group memberships stopped working for example. The database was intact with no corruptions. This is obviously not ideal. I had debugged it to the point of finding some RT generated SQL no longer running properly on the database. Since I actually prefer psql over mysql I ended up migrated to psql using exactly the same dataset, engaged fulltext indexing and the problems all went away. Tarek Sounds like it cannot connect to the sphinx server. Can you confirm that sphinx is running (ps -eaf |grep searchd ) and that it is running on the port specified in the attachmentsindex create statement (mysql show create table AttachmentsIndex; )? I believe the default port is 9312 but the documents at http://blog.bestpractical.com/2011/06/full-text-searching.html indicate that the port is 3312. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Luciano Ernesto da Silva Sent: Thursday, January 05, 2012 5:24 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RES: Sphinx fulltext index v4.0.4 Hello, I installed everything as described here by Dale/ documentation from docs/full_text_indexing.podc , documentarion by sphinxsearch but i got this error: RT: DBD::mysql::st execute failed: Unable to connect to foreign data source: failed to resolve searchd host (name=localhost) at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) Jan 5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id ) JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id = Attachments_2.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '23' AND ( AttachmentsIndex_3.query = 'ESEF;limit=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 The Mysql server is running on localhost and the firewall is off(Devel server) and SELINUX is disabled. DBIx::SearchBuilder is up to date. Any ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Luciano Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49 Para: Poulter, Dale Cc: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks for you help! Luciano -Original Message- From: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Sent: Thu 12/29/2011 4:42 PM To: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Here is the process I used. From Mysql-5.5.17 source Move the sphinx source directory msqlse (I used sphinx-2.0.2-beta) to storage/sphinx in the source tree cmake \ -DWITH_UNIXODBC=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_SPHINX_STORAGE_ENGINE=1 \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_SSL=yes Once mysql is compiled and installed you just need to install the plugin mysql INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; mysqls elect * from mysql.plugin; This should indicated that the sphinx plugin is installed. -Original Message- From: Luciano Ernesto da Silva
[rt-users] RES:RE: Re: RES: Sphinx fulltext index v4.0.4
Did yoy run rt-fulltext-indexer with the default options, like sphinx://localhost:3312 ? Luciano -Mensagem original- De: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Enviada em: quinta-feira, 12 de janeiro de 2012 13:02 Para: Luciano Ernesto da Silva; gekkoman; rt-users@lists.bestpractical.com Assunto: [*SPAM*] RE: Re: [rt-users] RES: Sphinx fulltext index v4.0.4 We are using v.1.6.1 -Original Message- From: Luciano Ernesto da Silva [mailto:luci...@cpd.ufrgs.br] Sent: Thursday, January 12, 2012 8:47 AM To: gekkoman; Poulter, Dale; rt-users@lists.bestpractical.com Subject: RES: Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. Dale, SPHINX: I'm thing theirs is a problem with perl module DBIx::SearchBuilder, mine is 1.61, but can't connect to localhost port 3312. I tested searchd daemon and is working OK. Dale, what version of DBIx::SearchBuilder are you using? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de gekkoman Enviada em: quinta-feira, 5 de janeiro de 2012 19:02 Para: Poulter, Dale; rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] RES: Sphinx fulltext index v4.0.4 Greetings, FYI I got sphinx running on 4.04 by following instructions before Christmas and everything looked ok.but then I started discovering non functioning aspects of RT post the change eg changing user group memberships stopped working for example. The database was intact with no corruptions. This is obviously not ideal. I had debugged it to the point of finding some RT generated SQL no longer running properly on the database. Since I actually prefer psql over mysql I ended up migrated to psql using exactly the same dataset, engaged fulltext indexing and the problems all went away. Tarek Sounds like it cannot connect to the sphinx server. Can you confirm that sphinx is running (ps -eaf |grep searchd ) and that it is running on the port specified in the attachmentsindex create statement (mysql show create table AttachmentsIndex; )? I believe the default port is 9312 but the documents at http://blog.bestpractical.com/2011/06/full-text-searching.html indicate that the port is 3312. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Luciano Ernesto da Silva Sent: Thursday, January 05, 2012 5:24 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RES: Sphinx fulltext index v4.0.4 Hello, I installed everything as described here by Dale/ documentation from docs/full_text_indexing.podc , documentarion by sphinxsearch but i got this error: RT: DBD::mysql::st execute failed: Unable to connect to foreign data source: failed to resolve searchd host (name=localhost) at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) Jan 5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id ) JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id = Attachments_2.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '23' AND ( AttachmentsIndex_3.query = 'ESEF;limit=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 The Mysql server is running on localhost and the firewall is off(Devel server) and SELINUX is disabled. DBIx::SearchBuilder is up to date. Any ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Luciano Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49 Para: Poulter, Dale Cc: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks for you help! Luciano -Original Message- From: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Sent: Thu 12/29/2011 4:42 PM To: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Here
[rt-users] RES: RES: Re: RES: Sphinx fulltext index v4.0.4
When you migrate to PostgreSQL, what version of RT were you using? RT 4? Any special option on script? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Jeff Blaine Enviada em: quinta-feira, 12 de janeiro de 2012 15:06 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 On 1/12/2012 9:46 AM, Luciano Ernesto da Silva wrote: Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. We had the same problem. This worked perfectly for us in the end, though we went to PostgreSQL 8.4.9 as provided by RHEL 6.x http://wiki-archive.bestpractical.com/view/rt-mysql2pg RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] RES: RES: RES: Re: RES: Sphinx fulltext index v4.0.4
Thanks for your help. I'll try the script. Luciano -Mensagem original- De: Jeff Blaine [mailto:jbla...@kickflop.net] Enviada em: quinta-feira, 12 de janeiro de 2012 16:12 Para: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Assunto: Re: RES: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 On 1/12/2012 12:54 PM, Luciano Ernesto da Silva wrote: When you migrate to PostgreSQL, what version of RT were you using? RT 4? Any special option on script? We dumped our RT 3.4.4 database from MySQL 4.1 (this is the last time we touched the old data) We stood up a new host. It had MySQL 5.1.x We loaded the MySQL 4.1 dump into the new MySQL 5.1.x instance We followed docs/UPGRADING.mysql We updated the password salt stuff (docs/UPGRADING.*) Then... We stood up PostgreSQL 8.4.9 on the same server We reconfigured RT for 'Pg', then primed the DB + tables + acls make install sbin/rt-setup-database --action drop # ignore any errors sbin/rt-setup-database --action create sbin/rt-setup-database --action schema sbin/rt-setup-database --action acl Then we migrated the data from MySQL 5.1 (running) to PostgreSQL 8.4.9 (running) with: http://wiki-archive.bestpractical.com/view/rt-mysql2pg There's no magic to the script's options. It has --help -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Jeff Blaine Enviada em: quinta-feira, 12 de janeiro de 2012 15:06 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 On 1/12/2012 9:46 AM, Luciano Ernesto da Silva wrote: Tarek, I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don't get converted to utf8 and I get the strange character with letter I with acute, like í looking to  (there's a space after Â, hidden or not). I don't know fix that, do you know any way to do that? I even used sed command, but it don't remove the space or whatever this is. We had the same problem. This worked perfectly for us in the end, though we went to PostgreSQL 8.4.9 as provided by RHEL 6.x http://wiki-archive.bestpractical.com/view/rt-mysql2pg RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] RES: Sphinx fulltext index v4.0.4
Hello, I installed everything as described here by Dale/ documentation from docs/full_text_indexing.podc , documentarion by sphinxsearch but i got this error: RT: DBD::mysql::st execute failed: Unable to connect to foreign data source: failed to resolve searchd host (name=localhost) at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) Jan 5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id ) JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id = Attachments_2.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '23' AND ( AttachmentsIndex_3.query = 'ESEF;limit=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 The Mysql server is running on localhost and the firewall is off(Devel server) and SELINUX is disabled. DBIx::SearchBuilder is up to date. Any ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Luciano Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49 Para: Poulter, Dale Cc: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks for you help! Luciano -Original Message- From: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Sent: Thu 12/29/2011 4:42 PM To: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Here is the process I used. From Mysql-5.5.17 source Move the sphinx source directory msqlse (I used sphinx-2.0.2-beta) to storage/sphinx in the source tree cmake \ -DWITH_UNIXODBC=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_SPHINX_STORAGE_ENGINE=1 \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_SSL=yes Once mysql is compiled and installed you just need to install the plugin mysql INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; mysqls elect * from mysql.plugin; This should indicated that the sphinx plugin is installed. -Original Message- From: Luciano Ernesto da Silva [mailto:luci...@cpd.ufrgs.br] Sent: Thursday, December 29, 2011 12:27 PM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Hello Dale, Can you point me how did you compiled sphinxSE with MySQL? I tryed compile MySQL 5.1.41 with sphinx, but not worked for me in Ubuntu 10.04, following instructions from Sphinx site. Thanks Luciano -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Poulter, Dale Sent: Thu 12/29/2011 1:15 PM To: Ruslan Zakirov Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks. I was just about to send out a note. It appears the v4 was installed on top of the v3.8.5 instance which caused many issues. I did a clean install and everything is working as of a few minutes ago. Thanks again for all of your help! -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Thursday, December 29, 2011 9:14 AM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Hi, Looks like your RT 4 instance is installed incorrectly. Log says that RT loads libraries from RT 3.8 instance and this shouldn't happen. On Thu, Dec 29, 2011 at 17:26, Poulter, Dale dale.poul...@vanderbilt.edu wrote: Here is the output from the debug log. The mysql log did not have any errors. [Thu Dec 29 13:01:54 2011] [error]: Found more than one occurrence of the /Callbacks/AssetTracker/autohandler/Default callback. This may cause only one of the callbacks to run. Look for the duplicate Callback in your /apps/rt385/local/html /apps/rt385/local/plugins/RT-Authen-ExternalAuth/html /apps/rt385/local/plugins/RT-Extension-MergeUsers/html /apps/rt385/local/plugins/RT-Extension-MergeUsersHistory/html /apps/rt385/local/plugins/RT-Extension-MandatorySubject/html /apps/rt385/local/plugins/RT-Extension-SummaryByUser/html /apps/rt385/local/plugins/RT-Extension-MobileUI/html /apps/rt385/share/html (/apps/rt385/sbin/../lib/RT/Interface/Web/Request.pm:133) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222) [Thu Dec 29
Re: [rt-users] Sphinx fulltext index v4.0.4
Thanks for you help! Luciano -Original Message- From: Poulter, Dale [mailto:dale.poul...@vanderbilt.edu] Sent: Thu 12/29/2011 4:42 PM To: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Here is the process I used. From Mysql-5.5.17 source Move the sphinx source directory msqlse (I used sphinx-2.0.2-beta) to storage/sphinx in the source tree cmake \ -DWITH_UNIXODBC=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_SPHINX_STORAGE_ENGINE=1 \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_SSL=yes Once mysql is compiled and installed you just need to install the plugin mysql INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; mysqls elect * from mysql.plugin; This should indicated that the sphinx plugin is installed. -Original Message- From: Luciano Ernesto da Silva [mailto:luci...@cpd.ufrgs.br] Sent: Thursday, December 29, 2011 12:27 PM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Sphinx fulltext index v4.0.4 Hello Dale, Can you point me how did you compiled sphinxSE with MySQL? I tryed compile MySQL 5.1.41 with sphinx, but not worked for me in Ubuntu 10.04, following instructions from Sphinx site. Thanks Luciano -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Poulter, Dale Sent: Thu 12/29/2011 1:15 PM To: Ruslan Zakirov Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks. I was just about to send out a note. It appears the v4 was installed on top of the v3.8.5 instance which caused many issues. I did a clean install and everything is working as of a few minutes ago. Thanks again for all of your help! -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Thursday, December 29, 2011 9:14 AM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Hi, Looks like your RT 4 instance is installed incorrectly. Log says that RT loads libraries from RT 3.8 instance and this shouldn't happen. On Thu, Dec 29, 2011 at 17:26, Poulter, Dale dale.poul...@vanderbilt.edu wrote: Here is the output from the debug log. The mysql log did not have any errors. [Thu Dec 29 13:01:54 2011] [error]: Found more than one occurrence of the /Callbacks/AssetTracker/autohandler/Default callback. This may cause only one of the callbacks to run. Look for the duplicate Callback in your /apps/rt385/local/html /apps/rt385/local/plugins/RT-Authen-ExternalAuth/html /apps/rt385/local/plugins/RT-Extension-MergeUsers/html /apps/rt385/local/plugins/RT-Extension-MergeUsersHistory/html /apps/rt385/local/plugins/RT-Extension-MandatorySubject/html /apps/rt385/local/plugins/RT-Extension-SummaryByUser/html /apps/rt385/local/plugins/RT-Extension-MobileUI/html /apps/rt385/share/html (/apps/rt385/sbin/../lib/RT/Interface/Web/Request.pm:133) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsGroup redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 76. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:76) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsUser redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 96. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:96) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine Object redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 116. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:116) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine GrantRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 153. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:153) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine RevokeRight redefined at /apps/rt385/sbin/../lib/RT
Re: [rt-users] Sphinx fulltext index v4.0.4
Hello Dale, Can you point me how did you compiled sphinxSE with MySQL? I tryed compile MySQL 5.1.41 with sphinx, but not worked for me in Ubuntu 10.04, following instructions from Sphinx site. Thanks Luciano -Original Message- From: rt-users-boun...@lists.bestpractical.com on behalf of Poulter, Dale Sent: Thu 12/29/2011 1:15 PM To: Ruslan Zakirov Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Thanks. I was just about to send out a note. It appears the v4 was installed on top of the v3.8.5 instance which caused many issues. I did a clean install and everything is working as of a few minutes ago. Thanks again for all of your help! -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Thursday, December 29, 2011 9:14 AM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 Hi, Looks like your RT 4 instance is installed incorrectly. Log says that RT loads libraries from RT 3.8 instance and this shouldn't happen. On Thu, Dec 29, 2011 at 17:26, Poulter, Dale dale.poul...@vanderbilt.edu wrote: Here is the output from the debug log. The mysql log did not have any errors. [Thu Dec 29 13:01:54 2011] [error]: Found more than one occurrence of the /Callbacks/AssetTracker/autohandler/Default callback. This may cause only one of the callbacks to run. Look for the duplicate Callback in your /apps/rt385/local/html /apps/rt385/local/plugins/RT-Authen-ExternalAuth/html /apps/rt385/local/plugins/RT-Extension-MergeUsers/html /apps/rt385/local/plugins/RT-Extension-MergeUsersHistory/html /apps/rt385/local/plugins/RT-Extension-MandatorySubject/html /apps/rt385/local/plugins/RT-Extension-SummaryByUser/html /apps/rt385/local/plugins/RT-Extension-MobileUI/html /apps/rt385/share/html (/apps/rt385/sbin/../lib/RT/Interface/Web/Request.pm:133) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222) [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, falling back to deprecated defaults (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsGroup redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 76. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:76) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsUser redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 96. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:96) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine Object redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 116. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:116) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine GrantRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 153. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:153) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine RevokeRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 190. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:190) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine HasRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 282. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:282) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 372. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:372) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasGroupRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 390. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:390) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasRoleRight redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 444. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:444) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine InvalidateACLCache redefined at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 526. (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:526) [Thu Dec 29 13:03:55 2011] [warning]: Subroutine
[rt-users] Select Especif Comments from an Ticket to an Article RT 4.0.2
Hello, When I try extract an article, I have this message on ticket: Use the dropdown menus to select which ticket updates you want to extract into a new article. You can insert ticket content into any freeform, text or wiki field. But the dropdown Field is empty. Should have an yes and no for specific comments that I want extract to an article? Luciano RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] RES: Select Especif Comments from an Ticket to an Article RT 4.0.2
Thank You for you help! Luciano De: pleh.i...@gmail.com [mailto:pleh.i...@gmail.com] Em nome de Bart Enviada em: segunda-feira, 28 de novembro de 2011 12:24 Para: Luciano Ernesto da Silva Cc: RT-Users@lists.bestpractical.com Assunto: Re: [rt-users] Select Especif Comments from an Ticket to an Article RT 4.0.2 You'll have to create at least one CF specifically for Articles (text area type) and apply it to the articles. After that you should be able to select that CF when creating an article. We use two CF's, one for the question and another for the answer. (very basic) -- Bart Op 28 november 2011 13:28 schreef Luciano Ernesto da Silva luci...@cpd.ufrgs.br het volgende: Hello, When I try extract an article, I have this message on ticket: Use the dropdown menus to select which ticket updates you want to extract into a new article. You can insert ticket content into any freeform, text or wiki field. But the dropdown Field is empty. Should have an yes and no for specific comments that I want extract to an article? Luciano RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain - November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] rt-mailgate error wht ExternalAuth On User Creation by Email
Hello, Some users send an email to email address of the queue to open tickets, but we are getting this error on user creation, since we are using ExternalAuth (RT4.0.2 + ExternalAuth 0.09): Sat Oct 29 12:37:42 2011] [crit]: User creation failed in mailgateway: Name in use (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:244) Trace begun at /opt/rt4/sbin/../lib/RT.pm line 249 Log::Dispatch::log('Log::Dispatch=HASH(0x7f4acf1969b0)', 'level', 'crit', 'message', 'User creation failed in mailgateway: Name in use') called at /opt/rt4/sbin/../lib/RT/Inter face/Email.pm line 244 RT::Interface::Email::MailError('To', 'john...@mydomain.com', 'Subject', 'User could not be created', 'Explanation', 'User creation failed in mailgateway: Name in use', 'MIMEObj', 'MIME::Entity=HASH(0x7f4aced00a98)', 'LogLevel', 'crit') called at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 999 I had set RT_SiteConfig.pm with Set($AutoCreateNonExternalUsers, 1); Set($AutoCreate, {Privileged = 1}); On interface is granted rights to Everyone: Comment on tickets Create tickets Reply to tickets My attributes on LDAP are these: 'attr_match_list' = ['Name', 'EmailAddress'], 'attr_map' = {'Name' = 'uid', 'EmailAddress' = 'mail', 'RealName' = 'cn', 'ExternalAuthId' = 'uid'} Actually I checked the list of users, I don't have any user with same name of the requestor. Should I use Set($AutoCreate, {UnPrivileged = 1}); or something like that? Tks Luciano Silva RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] RES: Re: rt-mailgate error wht ExternalAuth On User Creation by Email
Kevin, I found just one unprivileged user with the following: Username: czar...@yahoo.com.br Email: czar...@yahoo.com.br RealName: Vanessa Somelastname The real name is the same of the requestor that got the error: Vanessa Somelastname. The only diference is the email address. My guess: ExternalAuth or other subroutine is denying creation of users with the same RealName. My LDAP attributes: 'attr_match_list' = ['Name', 'EmailAddress'], 'attr_map' = {'Name' = 'uid', 'EmailAddress' = 'mail', 'RealName' = 'cn', 'ExternalAuthId' = 'uid'} Any Ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: segunda-feira, 31 de outubro de 2011 11:43 Para: rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] rt-mailgate error wht ExternalAuth On User Creation by Email On Mon, Oct 31, 2011 at 09:49:51AM -0200, Luciano Ernesto da Silva wrote: Actually I checked the list of users, I don't have any user with same name of the requestor. Search for the user, don't just read the list of users. The list is only Privileged users. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] RES: RES: Re: rt-mailgate error wht ExternalAuth On UserCreation by Email
Is there a way to modify this behavior Or allow the system create the users with the same RealName? My problem is that I have many users unprivileged(SPAM), something about 100.000 users. Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Izz Abdullah Enviada em: segunda-feira, 31 de outubro de 2011 12:28 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Re: rt-mailgate error wht ExternalAuth On UserCreation by Email Your attribute map list will restrict creation if any of the conditions are met, if I understand correctly. So since someone exists with that name, it sees the user as already existing. The attribute match list is for searching on either name or email, in your case, for authentication / creation / update, etc. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Luciano Ernesto da Silva Sent: Monday, October 31, 2011 9:24 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RES: Re: rt-mailgate error wht ExternalAuth On UserCreation by Email Kevin, I found just one unprivileged user with the following: Username: czar...@yahoo.com.br Email: czar...@yahoo.com.br RealName: Vanessa Somelastname The real name is the same of the requestor that got the error: Vanessa Somelastname. The only diference is the email address. My guess: ExternalAuth or other subroutine is denying creation of users with the same RealName. My LDAP attributes: 'attr_match_list' = ['Name', 'EmailAddress'], 'attr_map' = {'Name' = 'uid', 'EmailAddress' = 'mail', 'RealName' = 'cn', 'ExternalAuthId' = 'uid'} Any Ideas? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: segunda-feira, 31 de outubro de 2011 11:43 Para: rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] rt-mailgate error wht ExternalAuth On User Creation by Email On Mon, Oct 31, 2011 at 09:49:51AM -0200, Luciano Ernesto da Silva wrote: Actually I checked the list of users, I don't have any user with same name of the requestor. Search for the user, don't just read the list of users. The list is only Privileged users. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] RES: Re: RES: Re: rt-mailgate error wht ExternalAuth On User Creation by Email
Hello Kevin, What do you mean conflicting Name/EmailAddress match ? Is attr_map mandatory? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: segunda-feira, 31 de outubro de 2011 15:19 Para: rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] RES: Re: rt-mailgate error wht ExternalAuth On User Creation by Email On Mon, Oct 31, 2011 at 12:24:02PM -0200, Luciano Ernesto da Silva wrote: I found just one unprivileged user with the following: Username: czar...@yahoo.com.br Email: czar...@yahoo.com.br RealName: Vanessa Somelastname The real name is the same of the requestor that got the error: Vanessa Somelastname. The only diference is the email address. My guess: ExternalAuth or other subroutine is denying creation of users with the same RealName. Your attr_match_list says you're uniquing on Name and EmailAddress, not on RealName. If you'd configured attr_match_list to use RealName, then this would explain your problem. What's usually happening is that you have a conflicting Name/EmailAddress match happening in RT (based on your config). My LDAP attributes: 'attr_match_list' = ['Name', 'EmailAddress'], 'attr_map' = {'Name' = 'uid', 'EmailAddress' = 'mail', 'RealName' = 'cn', 'ExternalAuthId' = 'uid'} -kevin -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: segunda-feira, 31 de outubro de 2011 11:43 Para: rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] rt-mailgate error wht ExternalAuth On User Creation by Email On Mon, Oct 31, 2011 at 09:49:51AM -0200, Luciano Ernesto da Silva wrote: Actually I checked the list of users, I don't have any user with same name of the requestor. Search for the user, don't just read the list of users. The list is only Privileged users. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] RT 4.0.2 SSL Email Verification Failed
Hello, I was testing RT with a self-signed certificate(SSL), I send a email to queue, but in /var/log/mail I got this: (temporary failure. Command output: An Error Occurred = 500 Can't connect to rt4.dev.ufrgs.br:443 (certificate verify failed) ) No errors in other log files, like syslog or rt.log. The queues were not receiving mails. I installed all PERL dependencies to SSL, as described here http://www.gossamer-threads.com/lists/rt/users/71129 : Pod::Usage, HTML::TreeBuilder, Getopt::Long, HTML::FormatText, LWP::UserAgent And Crypt::SSLeay, LWP::Protocol::https As described here http://blogs.perl.org/users/brian_d_foy/2011/07/now-you-need-lwpprotocol https.html I made and applied a patch against file Rt-mailgate, around line 151: -my $ua = LWP::UserAgent-new(); +my $ua = LWP::UserAgent-new(ssl_opts = { verify_hostname = 0 }); Patch link here: http://pastebin.com/DQCH3R8L Now perl don't check the certificate, and the queues receive all messages. My question: Is this the correct approach for that? Luciano Silva RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Barcelona, Spain November 28 29, 2011
[rt-users] RES: RT 4.0.2 SSL Email Verification Failed
Thomas, I made a motification for LWP User Agent in line 151(rt-mailgate), and seems to work ok. 151 my $ua = LWP::UserAgent-new(ssl_opts = {SSL_ca_file = '/etc/ssl/certs/mycert.crt'}); 152 # my $ua = LWP::UserAgent-new(); Ok? Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Thomas Sibley Enviada em: segunda-feira, 17 de outubro de 2011 13:55 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RT 4.0.2 SSL Email Verification Failed On 10/17/2011 11:51 AM, Luciano Ernesto da Silva wrote: I was testing RT with a self-signed certificate(SSL), I send a email to queue, but in /var/log/mail I got this: (temporary failure. Command output: An Error Occurred = 500 Can't connect to rt4.myurl.com :443 (certificate verify failed) ) [snip] As described here http://blogs.perl.org/users/brian_d_foy/2011/07/now-you-need-lwpprotoc olhttps.html I made and applied a patch against file Rt-mailgate, around line 151: - my $ua = LWP::UserAgent-new(); + my $ua = LWP::UserAgent-new(ssl_opts = { verify_hostname = 0 }); Patch link here: http://pastebin.com/DQCH3R8L Now perl don’t check the certificate, and the queues receive all messages. *My question: Is this the correct approach for that*? No, this is wrong from a security standpoint, although it works since you're ignoring the cert data. You'll be vulnerable to a MITM attack. You should instead take the advice of the second half of brian's blog post and tell LWP::UserAgent about your root CA or install the root CA into your operating system's list of trusted CAs (which means you don't have to patch rt-mailgate). Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Barcelona, Spain November 28 29, 2011
[rt-users] RES: Strange error message dashboard notification
Hello, Is this a bug from rt 4.0.2 ? Can I revert this to the old way like rt 3.8.9(simple text)? Luciano De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Luciano Ernesto da Silva Enviada em: terça-feira, 11 de outubro de 2011 15:42 Para: RT-Users@lists.bestpractical.com Assunto: [*SPAM*] [rt-users] Strange error message dashboard notification Hello Kevin, I did an upgrade from 3.8.9 to 4.0.2 Ubuntu server. Now the notifications are coming with a strange problem in html/Javascript header of messages received in any email client(Evolution, Exchange 2003, 2007 and 2010): if (window.top !== window.self) { document.write = ; window.top.location = window.self.location; setTimeout(function(){ document.body.innerHTML = ; }, 1); window.self.onload = function(){ document.body.innerHTML = ; }; } jQuery(document).ready(function(){ jQuery(#quick-personal).append(' '); jQuery(#li-preferences).detach().appendTo(#prefs-menu); jQuery(#li-tools-config).detach().appendTo(#app-nav); jQuery(#li-search-simple).detach().insertBefore(#li-search); jQuery(#li-tools-approval).detach().appendTo(#app-nav); jQuery(#li-page-bookmark).detach().appendTo(#li-page-actionsul); jQuery(#li-page-actionsul).attr(id,page-action-menu).detach().insertAfter(#topactions); jQuery.fn.supersubs.defaults = { maxWidth: 30, extraWidth: 2 }; jQuery(#page-menu.toplevel).addClass(sf-menu sf-js-enabled).supersubs().superfish({ dropShadows: false, speed: 'fast' }).supposition(); jQuery(#app-nav.toplevel).addClass(sf-menu sf-vertical sf-js-enabled).supersubs().superfish({ speed: 'fast' }).supposition(); jQuery(#prefs-menu).addClass(sf-menu sf-js-enabled).supersubs().superfish().supposition({ speed: 'fast' }); }); Dashboard Spam queue Is there a way to fix that? Tks Luciano RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Barcelona, Spain November 28 29, 2011
[rt-users] Strange error message dashboard notification
Hello Kevin, I did an upgrade from 3.8.9 to 4.0.2 Ubuntu server. Now the notifications are coming with a strange problem in html/Javascript header of messages received in any email client(Evolution, Exchange 2003, 2007 and 2010): if (window.top !== window.self) { document.write = ; window.top.location = window.self.location; setTimeout(function(){ document.body.innerHTML = ; }, 1); window.self.onload = function(){ document.body.innerHTML = ; }; } jQuery(document).ready(function(){ jQuery(#quick-personal).append(' '); jQuery(#li-preferences).detach().appendTo(#prefs-menu); jQuery(#li-tools-config).detach().appendTo(#app-nav); jQuery(#li-search-simple).detach().insertBefore(#li-search); jQuery(#li-tools-approval).detach().appendTo(#app-nav); jQuery(#li-page-bookmark).detach().appendTo(#li-page-actionsul); jQuery(#li-page-actionsul).attr(id,page-action-menu).detach().ins ertAfter(#topactions); jQuery.fn.supersubs.defaults = { maxWidth: 30, extraWidth: 2 }; jQuery(#page-menu.toplevel).addClass(sf-menu sf-js-enabled).supersubs().superfish({ dropShadows: false, speed: 'fast' }).supposition(); jQuery(#app-nav.toplevel).addClass(sf-menu sf-vertical sf-js-enabled).supersubs().superfish({ speed: 'fast' }).supposition(); jQuery(#prefs-menu).addClass(sf-menu sf-js-enabled).supersubs().superfish().supposition({ speed: 'fast' }); }); Dashboard Spam queue Is there a way to fix that? Tks Luciano RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Barcelona, Spain November 28 29, 2011
[rt-users] RT 4.0.2. Dashboard Notifications Header Error
Hello, I did na upgrade from 3.8.9 to 4.0.2 Ubuntu server. Now the notifications are coming with a strange problem in html/Javascript header of messages received in any email client(Evolution, Exchange 2003, 2007 and 2010): if (window.top !== window.self) { document.write = ; window.top.location = window.self.location; setTimeout(function(){ document.body.innerHTML = ; }, 1); window.self.onload = function(){ document.body.innerHTML = ; }; } jQuery(document).ready(function(){ jQuery(#quick-personal).append(' '); jQuery(#li-preferences).detach().appendTo(#prefs-menu); jQuery(#li-tools-config).detach().appendTo(#app-nav); jQuery(#li-search-simple).detach().insertBefore(#li-search); jQuery(#li-tools-approval).detach().appendTo(#app-nav); jQuery(#li-page-bookmark).detach().appendTo(#li-page-actionsul); jQuery(#li-page-actionsul).attr(id,page-action-menu).detach().ins ertAfter(#topactions); jQuery.fn.supersubs.defaults = { maxWidth: 30, extraWidth: 2 }; jQuery(#page-menu.toplevel).addClass(sf-menu sf-js-enabled).supersubs().superfish({ dropShadows: false, speed: 'fast' }).supposition(); jQuery(#app-nav.toplevel).addClass(sf-menu sf-vertical sf-js-enabled).supersubs().superfish({ speed: 'fast' }).supposition(); jQuery(#prefs-menu).addClass(sf-menu sf-js-enabled).supersubs().superfish().supposition({ speed: 'fast' }); }); Dashboard Spam queue Is there a way to fix that? Luciano Luci RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Barcelona, Spain November 28 29, 2011
[rt-users] RES: Re: RES: Re: RES: Re: RT External Auth and uid problem
Hello, I worked in a solution, modifying the file ExternalAuth.pm in /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ and seems to work fine. In this case, only work with local auth and LDAP with UID. It prefix the uid number with letter a, and remove it where is necessary. Here's the mofifications if someone need it in future: http://pastebin.com/4qZ5vbsM If you want, I can post in the wikia page too. Tks Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: quarta-feira, 24 de agosto de 2011 14:52 Para: rt-users@lists.bestpractical.com Assunto: [*SPAM*] Re: [rt-users] RES: Re: RES: Re: RT External Auth and uid problem On Wed, Aug 24, 2011 at 02:22:35PM -0300, Luciano Ernesto da Silva wrote: I will try prefix the numeric username with a character. I don't know where start. Can you tell me what functions are involved in user creation? As I said earlier In the past, people have prefixed numeric usernames with a character, but since I've never had to do that, I do not know the best way to do it. -kevin I think I would have to map the authentication, including a character a internally before the number and a on creation. Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: quarta-feira, 24 de agosto de 2011 13:42 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Re: RT External Auth and uid problem On Wed, Aug 24, 2011 at 12:26:26PM -0300, Luciano Ernesto da Silva wrote: Kevin, Ok, I understand, I will not touch the extension. But is there a way to overlay creation of privileged users and allow 'Name' with numeric field? We have many services that use LDAP and users just use the RT does not support numeric usernames. Changing that would require significant code churn. -kevin uid(numeric) and password. Would be more friendly keep the same method. The last option would use Name = 'mail' in 'attr_map', but I don't think this a good solution. -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: quarta-feira, 24 de agosto de 2011 11:13 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RT External Auth and uid problem On Wed, Aug 24, 2011 at 10:54:22AM -0300, Luciano Ernesto da Silva wrote: 'attr_match_list' = [ 'Name', 'EmailAddress', 'RealName'], # The mapping of RT attributes on to LDAP attributes 'attr_map' = { 'Name' = 'uid', 'EmailAddress' = 'mail', 'RealName' = 'cn', 'ExternalAuthId' = 'uid' } In the extension ExternalAuth I changed all the strings Name for NickName and seems work, but I still cant't create users. Do you meant you literally replaced all occurrences of Name with NickName in the extension? That will never work. If you have a non-numeric field, just fix attr_map so that Name = 'non_numeric_ldap_field' Also, you almost certainly don't want attr_match_list to consider RealName to be unique. That would mean that you can't have two users in RT with the name Kevin Falcone since the extension will try to resolve them to the same AD user. -kevin I thought a solution creating a local/lib overlay for create a user with NickName to use as uid number, and keep RealName for cn, and EmailAdddress for mail. What function in lib is used to create the users? Can you give me some tips? Thanks for your help, Luciano Silva [1]luci...@cpd.ufrgs.br References Visible links 1. mailto:luci...@cpd.ufrgs.br RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA ? September 26 27, 2011 * San Francisco, CA, USA ? October 18 19, 2011 * Washington DC, USA ? October 31 November 1, 2011 * Melbourne VIC, Australia ? November 28 29, 2011 * Barcelona, Spain ? November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 27, 2011 * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Melbourne VIC, Australia November 28 29, 2011 * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 27, 2011 * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011
[rt-users] RT External Auth and uid problem
Hello, I installed External Auth, Works ok, but I have a problem with my users. There's +5.000 users in LDAP that I need allow use of RT, but now I realized that RT does not allow create users with numbers in field Name. So, all my users have numbers in uid attribute in LDAP. I don't have a field with Jdoe as uid , but uid=00112245, and cn= John Doe, mail=john...@example.com . ##RELEVANT PARTS OF MY CONFIG### Set($AutoCreateNonExternalUsers, 1); Set($AutoCreate, {Privileged = 1}); MAP TO ATTRIBUTES# 'attr_match_list' = [ 'Name', 'EmailAddress', 'RealName'], # The mapping of RT attributes on to LDAP attributes 'attr_map' = { 'Name' = 'uid', 'EmailAddress' = 'mail', 'RealName' = 'cn', 'ExternalAuthId' = 'uid' } In the extension ExternalAuth I changed all the strings Name for NickName and seems work, but I still cant't create users. I thought a solution creating a local/lib overlay for create a user with NickName to use as uid number, and keep RealName for cn, and EmailAdddress for mail. What function in lib is used to create the users? Can you give me some tips? Thanks for your help, Luciano Silva luci...@cpd.ufrgs.br RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 27, 2011 * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Melbourne VIC, Australia November 28 29, 2011 * Barcelona, Spain November 28 29, 2011
[rt-users] RES: Re: RT External Auth and uid problem
Kevin, Ok, I understand, I will not touch the extension. But is there a way to overlay creation of privileged users and allow 'Name' with numeric field? We have many services that use LDAP and users just use the uid(numeric) and password. Would be more friendly keep the same method. The last option would use Name = 'mail' in 'attr_map', but I don't think this a good solution. Thanks, Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: quarta-feira, 24 de agosto de 2011 11:13 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RT External Auth and uid problem On Wed, Aug 24, 2011 at 10:54:22AM -0300, Luciano Ernesto da Silva wrote: 'attr_match_list' = [ 'Name', 'EmailAddress', 'RealName'], # The mapping of RT attributes on to LDAP attributes 'attr_map' = { 'Name' = 'uid', 'EmailAddress' = 'mail', 'RealName' = 'cn', 'ExternalAuthId' = 'uid' } In the extension ExternalAuth I changed all the strings Name for NickName and seems work, but I still cant't create users. Do you meant you literally replaced all occurrences of Name with NickName in the extension? That will never work. If you have a non-numeric field, just fix attr_map so that Name = 'non_numeric_ldap_field' Also, you almost certainly don't want attr_match_list to consider RealName to be unique. That would mean that you can't have two users in RT with the name Kevin Falcone since the extension will try to resolve them to the same AD user. -kevin I thought a solution creating a local/lib overlay for create a user with NickName to use as uid number, and keep RealName for cn, and EmailAdddress for mail. What function in lib is used to create the users? Can you give me some tips? Thanks for your help, Luciano Silva [1]luci...@cpd.ufrgs.br References Visible links 1. mailto:luci...@cpd.ufrgs.br RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA ? September 26 27, 2011 * San Francisco, CA, USA ? October 18 19, 2011 * Washington DC, USA ? October 31 November 1, 2011 * Melbourne VIC, Australia ? November 28 29, 2011 * Barcelona, Spain ? November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 27, 2011 * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Melbourne VIC, Australia November 28 29, 2011 * Barcelona, Spain November 28 29, 2011
[rt-users] RES: Re: RES: Re: RT External Auth and uid problem
Kevin, I will try prefix the numeric username with a character. I don't know where start. Can you tell me what functions are involved in user creation? I think I would have to map the authentication, including a character a internally before the number and a on creation. Luciano -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: quarta-feira, 24 de agosto de 2011 13:42 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Re: RT External Auth and uid problem On Wed, Aug 24, 2011 at 12:26:26PM -0300, Luciano Ernesto da Silva wrote: Kevin, Ok, I understand, I will not touch the extension. But is there a way to overlay creation of privileged users and allow 'Name' with numeric field? We have many services that use LDAP and users just use the RT does not support numeric usernames. Changing that would require significant code churn. In the past, people have prefixed numeric usernames with a character, but since I've never had to do that, I do not know the best way to do it. -kevin uid(numeric) and password. Would be more friendly keep the same method. The last option would use Name = 'mail' in 'attr_map', but I don't think this a good solution. -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Kevin Falcone Enviada em: quarta-feira, 24 de agosto de 2011 11:13 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RT External Auth and uid problem On Wed, Aug 24, 2011 at 10:54:22AM -0300, Luciano Ernesto da Silva wrote: 'attr_match_list' = [ 'Name', 'EmailAddress', 'RealName'], # The mapping of RT attributes on to LDAP attributes 'attr_map' = { 'Name' = 'uid', 'EmailAddress' = 'mail', 'RealName' = 'cn', 'ExternalAuthId' = 'uid' } In the extension ExternalAuth I changed all the strings Name for NickName and seems work, but I still cant't create users. Do you meant you literally replaced all occurrences of Name with NickName in the extension? That will never work. If you have a non-numeric field, just fix attr_map so that Name = 'non_numeric_ldap_field' Also, you almost certainly don't want attr_match_list to consider RealName to be unique. That would mean that you can't have two users in RT with the name Kevin Falcone since the extension will try to resolve them to the same AD user. -kevin I thought a solution creating a local/lib overlay for create a user with NickName to use as uid number, and keep RealName for cn, and EmailAdddress for mail. What function in lib is used to create the users? Can you give me some tips? Thanks for your help, Luciano Silva [1]luci...@cpd.ufrgs.br References Visible links 1. mailto:luci...@cpd.ufrgs.br RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA ? September 26 27, 2011 * San Francisco, CA, USA ? October 18 19, 2011 * Washington DC, USA ? October 31 November 1, 2011 * Melbourne VIC, Australia ? November 28 29, 2011 * Barcelona, Spain ? November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 27, 2011 * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Melbourne VIC, Australia November 28 29, 2011 * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 27, 2011 * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Melbourne VIC, Australia November 28 29, 2011 * Barcelona, Spain November 28 29, 2011