[rt-users] RT user login not possible after Ubuntu 11.04 uprade
Hi all, Yesterday, I upgraded my very old uUbuntu server and with that, mysql and apache2 were updated too, configuration files are still the same. I had some problems with some file names and locations and Perl modules, I fixed them all, now I can see RT login page, but I can't login to that with my rt user (already exists in rtdb) alex001. even not with root. I checked things like rtuser can access mysql and still has all privileges, rtdb is readable to anyone, mysql log says nothing about this problem, apache log just says login for alex001 failed and I have no idea where else I can check or what might cause this problem. Please tell me if you can think of anything, I mean what does RT do for user login, what might have been changed, what permissions it will need and anything else you might think of... PS: I am not even sure rt is querying mysql, how can I make sure?? Thank you all Alex
Re: [rt-users] Upgrade: RTFM Article, Content CustomField not displaying
Hi Kevin, -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt- users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: 20 August 2013 13:29 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrade: RTFM Article, Content CustomField not displaying On Fri, Aug 16, 2013 at 09:26:41AM +, Anthony Gladdish wrote: Test system ( RT 3.8.17 + RTFM 2.4.5 ): For both menus: Menu: RTFM - Configuration - Custom Fields Menu: Configuration - RTFM - Custom Fields Lists record #32 from the CustomFields table. Applied column is empty. Lists record #31 from the CustomFields table. Applied column is empty. Clicking on each CustomField, Applies to is RTFM Articles. Are you quoting us the Applies To dropdown or the results of clicking on the Applies To link, which is where you apply Custom Fields to appropriate RT objects? Test system: for each CustomField, the Applies to drop down box has RTFM Articles selected. Production system: Tickets is selected instead and does not display an RTFM Articles option. Assigning this Tickets option in my test system appears to have no effect. Test system: for each CustomField, clicking on the Applies to link shows a list of unselected objects - RT and my queues. Selecting these and submitting, does not display the CF in the Article's page. I think it should be referencing CF records from FM_CustomFields table instead? FM_CustomFields has not been a relevant RTFM table since before the 2.4.0 release. All RTFM CF data is stored in RT's core Custom Field tables. Good to know. Hope this sheds more light, Anthony
Re: [rt-users] RT user login not possible after Ubuntu 11.04 uprade
I just found out that RT time is not sync. I got it from RT log file, it is 2 hours late, I am not sure why, my server time is correct (by command date) people say it might be because of mod_perl, can it be possibly the reason I can't login to RT? On Wed, Aug 21, 2013 at 9:39 AM, Alex Decalli alexdecall...@gmail.comwrote: Hi all, Yesterday, I upgraded my very old uUbuntu server and with that, mysql and apache2 were updated too, configuration files are still the same. I had some problems with some file names and locations and Perl modules, I fixed them all, now I can see RT login page, but I can't login to that with my rt user (already exists in rtdb) alex001. even not with root. I checked things like rtuser can access mysql and still has all privileges, rtdb is readable to anyone, mysql log says nothing about this problem, apache log just says login for alex001 failed and I have no idea where else I can check or what might cause this problem. Please tell me if you can think of anything, I mean what does RT do for user login, what might have been changed, what permissions it will need and anything else you might think of... PS: I am not even sure rt is querying mysql, how can I make sure?? Thank you all Alex
Re: [rt-users] (RT::Authen::ExternalAuth) email exists problem authenticating trough AD
Hi Nathan, After many searchs with your help and our AD Administrator we found that the account was not authorized. I was given another one and now, command line binds and authenticate well but no chance with RT. Here is the command line ldapsearch -LLL -H ldap://myserver.mydomain.local -x -D 'mydomain\ldapuser' -W -b ou=FR,dc=mydomain,dc=local uid=mysuer and the output. dn: CN=Firstname Lastname,OU=z - y - x,OU=city,OU=Users Clients,OU=mydomain,OU=FR,DC=mydomain,DC=local v objectClass: top objectClass: person objectClass: organizationalPerson objectClass: user cn: Firstname Lastname sn: Lastname c: FR l: city title: myTitle postalCode: Zipcode physicalDeliveryOfficeName: z - y - x telephoneNumber: myTelephonenumber givenName: FirstName distinguishedName: CN=Firstname Lastname,OU=z - y - x,OU=city,OU=Users Clients,OU=mydomain,OU=FR, DC=mydomain,DC=local instanceType: 4 whenCreated: 20100701014148.0Z whenChanged: 20130821001737.0Z displayName: Firstname Lastname uSNCreated: 73679 memberOf: CN=LL.microsoftproject,OU=SDG Groups,DC=mydomain,DC=local memberOf: CN=LL.Crystal.Reports.XI,OU=SDG Groups,DC=mydomain,DC=local memberOf: CN=LL.IE8,OU=SDG Groups,DC=mydomain,DC=local memberOf: CN=LL.itop,OU=Groups,OU=mydomain,OU=FR,DC=mydomain,DC=local memberOf: CN=LL.msvisio2003,OU=SDG Groups,DC=mydomain,DC=local memberOf: CN=LL.ClickToCall,OU=SDG Groups,DC=mydomain,DC=local memberOf: CN=mydomain.LL.dsi,OU=Groups,OU=mydomain,OU=FR,DC=mydomain,DC=local uSNChanged: 10019507 co: FRANCE department: z - y - x streetAddress: myaddress name: Firstname Lastname objectGUID:: l8cI/GO3KEOyA0E8neccKA== userAccountControl: 544 badPwdCount: 0 codePage: 0 countryCode: 250 badPasswordTime: 130215493735596806 lastLogoff: 0 lastLogon: 130214762950697235 pwdLastSet: 130214610102266437 primaryGroupID: 513 objectSid:: AQUAAAUVEQz3vwuoUpdtKTGZJPEAAA== accountExpires: 1302513840 logonCount: 197 sAMAccountName: mysuer sAMAccountType: 805306368 userPrincipalName: mymail lockoutTime: 0 objectCategory: CN=Person,CN=Schema,CN=Configuration,DC=mydomain,DC=local dSCorePropagationData: 20130524093118.0Z dSCorePropagationData: 20130523093743.0Z dSCorePropagationData: 1601010101.0Z lastLogonTimestamp: 130214610103032919 uid: mysuer mail: mymail I'm quite confused with the RT configuration file and it's option, even looking at the documentation I'm a litte bit lost, maybe the problem is there. Here is the RT_Config extract # External Authentication Configuration Set($ExternalAuthPriority, [ 'My_LDAP']); Set($ExternalInfoPriority, [ 'My_LDAP']); Set($ExternalSettings, { # AN EXAMPLE LDAP SERVICE 'My_LDAP' = { 'type' = 'ldap', 'server'= 'myserver.mydomain.local', 'user' = 'ldapaccount', 'pass' = 'ldapaccountpassword', 'base' = 'ou=FR,dc=mydomain,dc=local', 'filter'= '((ObjectCategory=User)(ObjectClass=Person))', 'd_filter' = '(userAccountControl:1.2.840.113556.1.4.803:=2)', 'group' = 'OU=Users Clients,OU=MYDOMAIN,OU=FR,DC=mydomain,DC=local', 'group_attr'= 'member', 'tls' = 0, 'ssl_version' = 3, 'net_ldap_args' = [version = 3 ], 'group_scope' = 'base', 'group_attr_value' = '*', 'attr_match_list' = ['Name'], 'attr_map' = { 'Name' = 'sAMAccountName', 'EmailAddress' = 'mail', 'Organization' = 'physicalDeliveryOfficeName', 'RealName' = 'cn', 'ExternalAuthId' = 'sAMAccountName', 'Gecos' = 'sAMAccountName', 'WorkPhone' = 'telephoneNumber', 'Address1' = 'streetAddress', 'City' = 'l', 'State' = 'st', 'Zip' = 'postalCode', 'Country' = 'co' }, }, } ); Any other Idea ? -- Regards Maximilien
Re: [rt-users] Ticket search include relationships ticket status.
Just up. Thanks -- View this message in context: http://requesttracker.8502.n7.nabble.com/Ticket-search-include-relationships-ticket-status-tp54665p55062.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] RT user login not possible after Ubuntu 11.04 uprade
Ok, found the problem but really didn't know how to fix, so have to reset password... UPDATE Users SET Password=ENCRYPT('password','SA') WHERE Name='root'; It is the password encryption method, it is changed. Any comments? On Wed, Aug 21, 2013 at 11:34 AM, Alex Decalli alexdecall...@gmail.comwrote: I just found out that RT time is not sync. I got it from RT log file, it is 2 hours late, I am not sure why, my server time is correct (by command date) people say it might be because of mod_perl, can it be possibly the reason I can't login to RT? On Wed, Aug 21, 2013 at 9:39 AM, Alex Decalli alexdecall...@gmail.comwrote: Hi all, Yesterday, I upgraded my very old uUbuntu server and with that, mysql and apache2 were updated too, configuration files are still the same. I had some problems with some file names and locations and Perl modules, I fixed them all, now I can see RT login page, but I can't login to that with my rt user (already exists in rtdb) alex001. even not with root. I checked things like rtuser can access mysql and still has all privileges, rtdb is readable to anyone, mysql log says nothing about this problem, apache log just says login for alex001 failed and I have no idea where else I can check or what might cause this problem. Please tell me if you can think of anything, I mean what does RT do for user login, what might have been changed, what permissions it will need and anything else you might think of... PS: I am not even sure rt is querying mysql, how can I make sure?? Thank you all Alex
[rt-users] Too many Undefined subroutine in rt.log
Hi. I have recently upgraded Ubuntu 11.04 and packages (not RT,RT is still 3.8.10) since then, I cannot load any page after I login, it is just the left menu and this message comes after any link I click on: An internal RT error has occurred. Your administrator can find more details in RT's log files. I am checking the log file and it is full of undefined subroutins: [Wed Aug 21 11:46:14 2013] [error]: Undefined subroutine HTML::Mason::Commands::ScrubHTML called at /usr/share/request-tracker3.8/html/Elements/ScrubHTML line 49, GEN17 line 1510. (/usr/share/request-tracker3.8/lib/RT/Interface/Web/Handler.pm:278) [Wed Aug 21 11:46:16 2013] [error]: Undefined subroutine HTML::Mason::Commands::ScrubHTML called at /usr/share/request-tracker3.8/html/Elements/ScrubHTML line 49, GEN19 line 1511. (/usr/share/request-tracker3.8/lib/RT/Interface/Web/Handler.pm:278) [Wed Aug 21 11:46:18 2013] [error]: Undefined subroutine HTML::Mason::Commands::ScrubHTML called at /usr/share/request-tracker3.8/html/Elements/ScrubHTML line 49, GEN21 line 1511. (/usr/share/request-tracker3.8/lib/RT/Interface/Web/Handler.pm:278) [Wed Aug 21 11:46:25 2013] [error]: Undefined subroutine HTML::Mason::Commands::ScrubHTML called at /usr/share/request-tracker3.8/html/Elements/ScrubHTML line 49, GEN23 line 1511. (/usr/share/request-tracker3.8/lib/RT/Interface/Web/Handler.pm:278) [Wed Aug 21 12:26:48 2013] [error]: Undefined subroutine RT::Interface::Web::EscapeJS called at /usr/local/share/perl/5.12.4/HTML/Mason/Interp.pm line 1020. (/usr/share/request-tracker3.8/lib/RT/Interface/Web/Handler.pm:278) What possibly causes this? Any perl modules I need? I already have these installed, tell me if I need more: Apache::DBI DateTime::Format::Mail Digest::MD5 HTML::Mason MLDBM Perl Test::Deep Test::NoWarnings Test::Tester Thanks Alex
[rt-users] Ticket reply issues
I am having problems with certain individuals not being able to properly reply to a ticket once it is created. In this instance when I ticket is open an admin of the queue responds and a new ticket is created. The admin simply clicks reply and the subject contains the correct information between the brackets in the subject line.I have included the headers below. Any ideas? I assume the reere of @example.com probably isn't correct. MIME-Version: 1.0 In-Reply-To: CABoYp6PTqQuWqz_2-mywBMS-LDPtK1tCeTUaZbj=_xxx-hc...@mail.x.com X-Mailer: MIME-tools 5.427 (Entity 5.427) Content-Disposition: inline References: rt-ticket-...@example.com rt-ticket-...@example.com 0cf0d76b-6dbf-4330-b1cc-865aed983...@psu.edu rt-3.8.10-6284-1376575355-1034.384-...@example.com CABoYp6OOtgwSzRb1-FKPN4oSCL=f96qnycnepff0of6xext...@mail..com caboyp6ortryeinkmgfnx59gc9bv_v7ke6dt6un6xwnt5fsi...@mail..com rt-3.8.10-13494-1376927913-1078.388-...@example.com CABoYp6PTqQuWqz_2-mywBMS-LDPtK1tCeTUaZbj=_jw7-hc...@mail..com Content-Type: text/html; charset=UTF-8 Message-ID: rt-3.8.10-16643-1376928170-559.391-...@example.com Content-Transfer-Encoding: binary X-RT-Original-Encoding: utf-8 RT-Send-CC: Content-Length: 3586
Re: [rt-users] Ticket reply issues
On Wed, Aug 21, 2013 at 12:39:45PM -0400, Mark Campbell wrote: I am having problems with certain individuals not being able to properly reply to a ticket once it is created. In this instance when I ticket is open an admin of the queue responds and a new ticket is created. The admin simply clicks reply and the subject contains the correct information between the brackets in the subject line.I have included the headers below. Any ideas? I assume the reere of @example.com probably isn't correct. I don't see a Subject in your headers, but your headers also refer to two separate tickets (384 and 388) so clearly you have a few things going on. You should also have them reply and watch debug logs from RT. -kevin MIME-Version: 1.0 In-Reply-To: CABoYp6PTqQuWqz_2-mywBMS-LDPtK1tCeTUaZbj=_xxx-hc...@mail.x.com X-Mailer: MIME-tools 5.427 (Entity 5.427) Content-Disposition: inline References: rt-ticket-...@example.com rt-ticket-...@example.com 0cf0d76b-6dbf-4330-b1cc-865aed983...@psu.edu rt-3.8.10-6284-1376575355-1034.384-...@example.com CABoYp6OOtgwSzRb1-FKPN4oSCL=f96qnycnepff0of6xext...@mail..com caboyp6ortryeinkmgfnx59gc9bv_v7ke6dt6un6xwnt5fsi...@mail..com rt-3.8.10-13494-1376927913-1078.388-...@example.com CABoYp6PTqQuWqz_2-mywBMS-LDPtK1tCeTUaZbj=_jw7-hc...@mail..com Content-Type: text/html; charset=UTF-8 Message-ID: rt-3.8.10-16643-1376928170-559.391-...@example.com Content-Transfer-Encoding: binary X-RT-Original-Encoding: utf-8 RT-Send-CC: Content-Length: 3586 pgpG0nIV2hKk9.pgp Description: PGP signature
Re: [rt-users] Upgrade: RTFM Article, Content CustomField not displaying
On Wed, Aug 21, 2013 at 08:54:17AM +, Anthony Gladdish wrote: Production system: Tickets is selected instead and does not display an RTFM Articles option. Assigning this Tickets option in my test system appears to have no effect. I'm a little confused how RTFM works on production if you don't see RTFM Articles as a Custom Field option. I assume it worked when you set up the system, but then someone broke something later (Since you mention the FM_CustomFields table I know you upgraded from a very old RTFM at some point). You can go look in the Database at the LookupType field to confirm. Assigning it to Tickets in test would just break. Test system: for each CustomField, clicking on the Applies to link shows a list of unselected objects - RT and my queues. Selecting these and submitting, does not display the CF in the Article's page. It shouldn't show Queues, it'll show classes. Change it back to RTFM Articles, then click on Applies to and then assign it to the relevant Classes. -kevin pgpiEBCeOKE1F.pgp Description: PGP signature
Re: [rt-users] upgrade-database push to the mysql replica ?
On Tue, Aug 20, 2013 at 11:59 AM, Asif Iqbal vad...@gmail.com wrote: On Mon, Aug 19, 2013 at 11:37 PM, Asif Iqbal vad...@gmail.com wrote: Hi All, If I run make upgrade-database on mysql master, will it push the change to mysql slave ? I could not find any answer in the mailing list, unless I missed it. Thanks I did a test make updgrade-database while running 'show processlist' on slave and it looks the slave rt4 gets the upgrade-database too. Please let me know if someone thinks otherwise. It does seem that ``make upgrade-database'' pushes the change to slave as well. Just needed to double check with all before migrating about 8 million transactions this weekend from old environment (sparc/solaris/rt3.8.2/mysql 5.0.55) to new environment ( 2 supermicro/linux/rt 4.0.17/mysql 5.5.32/ master/master active/passive) -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
[rt-users] problem sharing session between RT and custom code
I have written an application that runs alongside an RT4 instance, and makes use of RT's Logger, db handle and session. In moving from mysql to Oracle, I've run into a problem that after lodign a page from my app, the next request, whether to my app, or RT, hangs trying to get an exclusive lock on the session lock file that it had used without a problem on the previous request (and requests, if I start out clicking around in RT). I've determined that it is exclusive lock call by using strace. I've also learned that while clicking through RT, and the first click into my app, the session lock file is file descriptor 11, but the request after hitting my app uses 13, but doesn't close 11, so it looks like my app is not untie-the session, but I'm relying on RT to tie/until the session - or so I think. I'm sure that there's something that I've missed. Something that RT does that I've orverlooked, or some assumption I've made that is invalid. Can anybody tell me (why my autohandler might be causing RT to use a different fd despite using the same session id, and why it might not be correctly relinquishing the lock or the tied hash? Or nudge me in the right direction? Thanks, Len. -- lenja...@jaffesystems.com 614-404-4214@lenjaffe Software Engineer, Founder Volunteerable http://www.volunteerable..com/, Host of Columbus Code Jam http://www.meetup.com/techlifecolumbus/ www.lenjaffe.com http://www.theycomewithcheese.com Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent Calendars: Perlish and otherwise.
[rt-users] Technician on vacation status
Hi all - Running RT 4.0.16. Was talking with a co-worker today about this. I was wondering if there is anything that can be put in place (easily) for when a person is out of the office for a long time. For instance , if a person is out on vacation for two weeks and not everybody is aware, maybe RT shouldn't allow tickets to be given to this person? Not sure if this is possible...or even a good idea. Just a thought. Max