Re: [rt-users] Searching with no case sensitivity?
Good morning, Is there an easy way to turn off case sensitivity for the search feature in RT 3.8.x? I am using MySql as the database and tried a few suggestions I found by googling the problem but none of them work. I'm pretty sure it's just a matter of the collation setting for your database. Would you mind giving me some additional pointers, I'm having the same trouble with a Postgres Database and I am no Postgres Expert. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT mysql / LDAP Auth
-Original Message- From: Mike Peachey [mailto:mike.peac...@jennic.com] Sent: 14 May 2010 10:33 To: Julian Grunnell; rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT mysql / LDAP Auth Julian Grunnell wrote: Right, thanks - that makes sense now. I misunderstood the use of this and thought you had to define ALL the authentication methods you wanted to use. So I have removed the MySQL section completely from the config and tried again with different results. Using my LDAP credentials I still get Your username or password is incorrect BUT RT has created me as a user, the Let this user be granted rights box is unchecked and I'm NOT a member of any Groups. The logs created when this was done are: 1. It found you and loaded your information from LDAP just as it should. 2. ExternalAuth cannot currently add you to any internal RT groups based on LDAP information, this must be done in the RT administration panels. 3. If you want LDAP users to be automatically assigned Let this user be granted rights then you may do so with this config setting: Set($AutoCreate, {Privileged = 1}); Otherwise it will need setting manually along with group membership. The only thing that is now failing for you is authentication and the reason is now obvious: Your config ### # Does authentication depend on group membership? What group name? 'group' = 'GROUP_NAME', # What is the attribute for the group object that determines membership? 'group_attr' = 'GROUP_ATTR', ### Your log ### [Fri May 14 08:22:42 2010] [critical]: Search for (GROUP_ATTR=CN=Julian Grunnell,OU=Technical,OU=Users,OU=Leeds,OU=Webfusion,OU=Hosting,OU=Corp , DC=internal,DC=hosteurope,DC=com) failed: LDAP_INVALID_DN_SYNTAX 34 ### You have told ExternalAuth that all ldap users must be in an ldap group named GROUP_NAME and that in order to confirm that the users are a member of that group, the members should be in the GROUP_ATTR attribute of that group. If you simply comment out group and group_attr it should work fine. If in future you wish to restrict access by group, ensure the group name is specified in full ldap dn form. -- [] Thanks Mike - appreciate your help with this, made the changes you suggest and it works a treat now. Now to look at the script that can convert to ldap style logins. Julian. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] FW: Custom Fields available in SeflService?
Hello, I would like for users to be able to select an urgency custom field when they log in to self service and create a new ticket. I have successfully created the custom field and it is viewable/editable by staff, however I cannot get it to appear in self service when users are creating a new ticket. Oddly, the custom field IS visible to self service users after a ticket has been created. What am I missing? Much appreciated, Paul RT 3.8.7 OS OEL 5.4 64bit Apache 2.2.3 mysql 5.0.77 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] To NotifyActor or not to NotifyActor ...
I really like this method... I have the ticket creation notifications going to a shared mailbox for all the users to see. but I cannot seem to find a sample scrip on the wiki to assign ownership of a ticket based on the email address that the reply came from. I mean I know I can set the owner of the ticket by using: Ahh, it must have been from the book then: Description: On Correspond Open Ticket Condition: On Correspond Action: Open Tickets Template: Blank #Use Transaction if you want notification Stage: TransactionCreate That should do it. -- Cambridge Energy Alliance: Save money. Save the planet. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] FW: Custom Fields available in SeflService?
What am I missing? Have you given unprivileged users the rights to edit this field? -- Cambridge Energy Alliance: Save money. Save the planet. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Ticket UI
I was wondering if there was a way to insert a saved search into a ticket. ie I want to have a better view of the linked tickets with the ability to see the age and status. I am Setting this up because our users are used to it on quick base. You can make links with the wiki CustomField type, but it's a little more work than cut and paste. You could create your own custom field that just stores the name of the saved search, and have its display be a link which passes the value out to simple search to be processed by RTx::S3Invoker -- Cambridge Energy Alliance: Save money. Save the planet. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Trying to install mod_perl
I read the link that you sent me and that helps me get the result that I got. I have pasted the configuration in the link that you sent me and created a private link http://pastebin.com/8n6vemSK -Original Message- From: Rob MacGregor rob.macgre...@gmail.com To: RT-Users RT-Users@lists.bestpractical.com Sent: Mon, May 17, 2010 5:47 pm Subject: Re: [rt-users] Trying to install mod_perl I don't need to get multiple copies of all of your emails - please end them to the list and the list alone. On Mon, May 17, 2010 at 22:28, borngunn...@aol.com wrote: I have checked and made necessary corrections. Now, all I am getting is this: It Works! What am I missing in this case? Appropriate configuration of Apache ;) Did you read the URL I previously directed you to? It's apparent that ou haven't made the appropriate RT changes to your Apache install. Can you upload a copy of your Apache configuration file (such as at ttp://pastebin.com/) and provide a link to where it can be found? -- Please keep list traffic on the list. Rob MacGregor Whoever fights monsters should see to it that in the process he doesn't become a monster. Friedrich Nietzsche Discover RT's hidden secrets with RT Essentials from O'Reilly Media. uy a copy at http://rtbook.bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Parsing headers to decide which Queue to assign ticket!
Does your Exchange server allow extensions? If so, rt-mailgate --extension queue will automagically put mail for rt+qu...@example.net into the corresponding queue. You'd then just need two addresses, one for correspondence and one for comments, if you want to allow comment by email; which isn't necessary since privileged users have the full-featured web interface. -- Cambridge Energy Alliance: Save money. Save the planet. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Email.pm - No recipients found. Not sending
Hi, I just moved an instance of RT from another server/domain to a local server and I am having problems getting Replies and outgoing mail out of RT. incoming mail is working fine per the logs and ticket creation in RT, however notifications and responses are not outgoing. See the log snippets from the web server log files when a response is initiated. [Tue May 18 16:51:28 2010] [info]: rt-3.8.2-1265-1274201488-1190.631-...@alliance Medical Center No recipients found. Not sending. (/opt/rt3/bin/../lib/RT/Interface/Email.pm:338) [Tue May 18 16:51:28 2010] [info]: rt-3.8.2-1265-1274201488-1312.631-...@alliance Medical Center #631/9529 - Scrip 7 On Correspond Notify Other Recipients (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:301) [Tue May 18 16:51:28 2010] [info]: rt-3.8.2-1265-1274201488-1312.631-...@alliance Medical Center No recipients found. Not sending. (/opt/rt3/bin/../lib/RT/Interface/Email.pm:338) [Tue May 18 16:51:28 2010] [info]: rt-3.8.2-1265-1274201488-428.631-...@alliance Medical Center #631/9529 - Scrip 6 On Correspond Notify Requestors and Ccs (/opt/rt3/bin/../lib/RT/Action/SendEmail.pm:301) Any clues would be appreciated. Thanks, -- Mark Street, D.C., RHCE Chief Technology Officer Alliance Medical Center (707) 433-5494 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] To NotifyActor or not to NotifyActor ...
Ahh, it must have been from the book then: Description: On Correspond Open Ticket Condition: On Correspond Action: Open Tickets Template: Blank #Use Transaction if you want notification Stage: TransactionCreate That should do it. I am even more confused than ever now. That scrip is there by default, but checking the logs after I reply to a 'ticket creation' email, that scrip isnt invoked at all. When a requestor sends an email to create a ticket the first scrip that runs is: Description: On Create Notify ALL Users Condition: On Create Action: Notify Other Recipients Template: Global Template: Notify Users Stage: TransactionCreate The template is just a simple message to a shared mailbox: To: csqu...@domain.com Subject: New Ticket: {$Ticket-Subject} A New Ticket has been created in the Client Support Queue. If you would like to take ownership of this ticket, reply to this email with the word take in the body. ... so if a user replies to that email, I want to set that user as the owner and send the {$Ticket-Transactions-First-Content} out to that user, so they can begin working on it. The only piece that I cannot seem to figure out is how to have the On Correspond scrip look at the email address, and match that to a user in RT so that I can assign them as the owner of this ticket. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Trying to install mod_perl
Hi, have you tried to rename or remove /root/.cpan/build/mod_perl-1.31-OqZLsX than try reinstall. raymond Running make for G/GO/GOZER/mod_perl-1.31.tar.gz Has already been unwrapped into directory /root/.cpan/build/mod_perl-1.31-OqZLsX On Mon, 17 May 2010, borngunn...@aol.com wrote: After I uncomment the PerlRequire in my httpd.conf file, apche2 restart successfully, but then I receive the following message from my web browser: You're almost there! You haven't yet configured your webserver to run RT. You appear to have installed RT's web interface correctly, but haven't yet configured your web server to run the RT server which powers the web interface. The next step is to edit your webserver's configuration file to instruct it to use RT's mod_perl, FastCGI or SpeedyCGI handler. If you need commercial support, please contact us at sa...@bestpractical.com. What Am I doing wrong in this case? -Original Message- From: Rob MacGregor rob.macgre...@gmail.com To: RT-Users RT-Users@lists.bestpractical.com Sent: Mon, May 17, 2010 4:14 pm Subject: Re: [rt-users] Trying to install mod_perl On Mon, May 17, 2010 at 20:31, borngunn...@aol.com wrote: After couple of apache2 fail, I am trying to install mod_perl in cpan and I got the following error messages: cpan[1] install mod_perl CPAN: Storable loaded ok (v2.18) Going to read '/root/.cpan/Metadata' Database was generated on Mon, 17 May 2010 14:28:57 GMT CPAN: YAML loaded ok (v0.71) Going to read 125 yaml files from /root/.cpan/build/ CPAN: Time::HiRes loaded ok (v1.9711) DONE Restored the state of none (in 2.8972 secs) Running install for module 'mod_perl' Running make for G/GO/GOZER/mod_perl-1.31.tar.gz Has already been unwrapped into directory /root/.cpan/build/mod_perl-1.31-OqZLsX '/usr/bin/perl Makefile.PL INSTALLDIRS=site' returned status 2, won't make Running make test Make had some problems, won't test Running make install Make had some problems, won't install That suggests you already have installed mod_perl. Did you also onfigure it in Apache? See the mod_perl documentation at http://perl.apache.org/, in articular http://perl.apache.org/docs/2.0/user/config/config.html#Enabling_mod_perl Please help me resolve this issue. What do I need to do and where is apache2 source directory located? That really depends on how you installed Apache. Note that Apache has it's own mailing lists - ttp://httpd.apache.org/userslist.html. -- Regards, Raymond Wong Personal motto: P.E.A.C.E Enjoy the present Assert your goals Champion peace Entrust others Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Trying to install mod_perl
This is the error that I got after I did the following : #rm -rf /root/.cpan/build/mod_perl-1.31-OqZLsX #cpan CPAN install mod_perl CPAN: File::Temp loaded ok (v0.22) '/usr/bin/perl Makefile.PL INSTALLDIRS=site' returned status 2, won't make Running make test Make had some problems, won't test Running make install Make had some problems, won't install -Original Message- From: raymond raym...@pilotsupplies.com To: borngunners borngunn...@aol.com Cc: rob.macgregor rob.macgre...@gmail.com; RT-Users RT-Users@lists.bestpractical.com Sent: Tue, May 18, 2010 1:32 pm Subject: Re: [rt-users] Trying to install mod_perl Hi, have you tried to rename or remove root/.cpan/build/mod_perl-1.31-OqZLsX than try reinstall. raymond Running make for G/GO/GOZER/mod_perl-1.31.tar.gz Has already been unwrapped into directory /root/.cpan/build/mod_perl-1.31-OqZLsX n Mon, 17 May 2010, borngunn...@aol.com wrote: After I uncomment the PerlRequire in my httpd.conf file, apche2 restart uccessfully, but then I receive the following message from my web browser: You're almost there! You haven't yet configured your webserver to run RT. You appear to have nstalled RT's web interface correctly, but haven't yet configured your web erver to run the RT server which powers the web interface. The next step is o edit your webserver's configuration file to instruct it to use RT's mod_perl, astCGI or SpeedyCGI handler. If you need commercial support, please contact us t sa...@bestpractical.com. What Am I doing wrong in this case? -Original Message- From: Rob MacGregor rob.macgre...@gmail.com To: RT-Users RT-Users@lists.bestpractical.com Sent: Mon, May 17, 2010 4:14 pm Subject: Re: [rt-users] Trying to install mod_perl On Mon, May 17, 2010 at 20:31, borngunn...@aol.com wrote: After couple of apache2 fail, I am trying to install mod_perl in cpan and I got the following error messages: cpan[1] install mod_perl CPAN: Storable loaded ok (v2.18) Going to read '/root/.cpan/Metadata' Database was generated on Mon, 17 May 2010 14:28:57 GMT CPAN: YAML loaded ok (v0.71) Going to read 125 yaml files from /root/.cpan/build/ CPAN: Time::HiRes loaded ok (v1.9711) DONE Restored the state of none (in 2.8972 secs) Running install for module 'mod_perl' Running make for G/GO/GOZER/mod_perl-1.31.tar.gz Has already been unwrapped into directory /root/.cpan/build/mod_perl-1.31-OqZLsX '/usr/bin/perl Makefile.PL INSTALLDIRS=site' returned status 2, won't make Running make test Make had some problems, won't test Running make install Make had some problems, won't install That suggests you already have installed mod_perl. Did you also onfigure it in Apache? See the mod_perl documentation at http://perl.apache.org/, in articular http://perl.apache.org/docs/2.0/user/config/config.html#Enabling_mod_perl Please help me resolve this issue. What do I need to do and where is apache2 source directory located? That really depends on how you installed Apache. Note that Apache has it's own mailing lists - ttp://httpd.apache.org/userslist.html. -- Regards, Raymond Wong ersonal motto: P.E.A.C.E njoy the present ssert your goals hampion peace ntrust others Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Trying to install mod_perl
I have remove it and successfully reinstall it without the messages that showed up. Apache still keeps failing with the following error message after I look into my log: [Tue May 18 14:47:36 2010] [error] Can't load Perl file: /opt/rt3/bin/webmux.pl for server UHC Helpdesk:0, exiting... This is my configuration file: VirtualHost helpdesk.uhc.umd.edu:80 ServerName UHC Helpdesk ServerAdmin helpd...@health.umd.edu ErrorLog /var/log/apache2/helpdesk-error.log # config for your main content DocumentRoot /opt/rt3/share/html/ AddDefaultCharset UTF-8 PerlRequire /opt/rt3/bin/webmux.pl Directory /opt/rt3/share/html/ Order Allow,Deny Allow from all SetHandler perl-script PerlResponseHandler RT::Mason /Directory Location / /Location /VirtualHost -Original Message- From: raymond raym...@pilotsupplies.com To: borngunners borngunn...@aol.com Cc: rob.macgregor rob.macgre...@gmail.com; RT-Users RT-Users@lists.bestpractical.com Sent: Tue, May 18, 2010 1:32 pm Subject: Re: [rt-users] Trying to install mod_perl Hi, have you tried to rename or remove root/.cpan/build/mod_perl-1.31-OqZLsX than try reinstall. raymond Running make for G/GO/GOZER/mod_perl-1.31.tar.gz Has already been unwrapped into directory /root/.cpan/build/mod_perl-1.31-OqZLsX n Mon, 17 May 2010, borngunn...@aol.com wrote: After I uncomment the PerlRequire in my httpd.conf file, apche2 restart uccessfully, but then I receive the following message from my web browser: You're almost there! You haven't yet configured your webserver to run RT. You appear to have nstalled RT's web interface correctly, but haven't yet configured your web erver to run the RT server which powers the web interface. The next step is o edit your webserver's configuration file to instruct it to use RT's mod_perl, astCGI or SpeedyCGI handler. If you need commercial support, please contact us t sa...@bestpractical.com. What Am I doing wrong in this case? -Original Message- From: Rob MacGregor rob.macgre...@gmail.com To: RT-Users RT-Users@lists.bestpractical.com Sent: Mon, May 17, 2010 4:14 pm Subject: Re: [rt-users] Trying to install mod_perl On Mon, May 17, 2010 at 20:31, borngunn...@aol.com wrote: After couple of apache2 fail, I am trying to install mod_perl in cpan and I got the following error messages: cpan[1] install mod_perl CPAN: Storable loaded ok (v2.18) Going to read '/root/.cpan/Metadata' Database was generated on Mon, 17 May 2010 14:28:57 GMT CPAN: YAML loaded ok (v0.71) Going to read 125 yaml files from /root/.cpan/build/ CPAN: Time::HiRes loaded ok (v1.9711) DONE Restored the state of none (in 2.8972 secs) Running install for module 'mod_perl' Running make for G/GO/GOZER/mod_perl-1.31.tar.gz Has already been unwrapped into directory /root/.cpan/build/mod_perl-1.31-OqZLsX '/usr/bin/perl Makefile.PL INSTALLDIRS=site' returned status 2, won't make Running make test Make had some problems, won't test Running make install Make had some problems, won't install That suggests you already have installed mod_perl. Did you also onfigure it in Apache? See the mod_perl documentation at http://perl.apache.org/, in articular http://perl.apache.org/docs/2.0/user/config/config.html#Enabling_mod_perl Please help me resolve this issue. What do I need to do and where is apache2 source directory located? That really depends on how you installed Apache. Note that Apache has it's own mailing lists - ttp://httpd.apache.org/userslist.html. -- Regards, Raymond Wong ersonal motto: P.E.A.C.E njoy the present ssert your goals hampion peace ntrust others Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Category no longer shows in ticket
To List, Upon further testing, I've discovered that the Category of a Custom Field only disappears from the Update Ticket screen when that Category is linked to another CF. When I remove the link, the Category shows up again. Is this normal? What is the reasoning for this? Kenn LBNL On Thu, Apr 1, 2010 at 12:13 PM, Kenneth Crocker kfcroc...@lbl.gov wrote: To list, When we were in 3.6.4, the category for a Custom Field would show in the Modify Ticket screen. This allowed a user to select the *category* from a drop-down tab and thereby shorten the list of available values to choose from for that CF. Now in 3.8.7, that *category* list/drop-down no longer shows. I *did* link the *category* to another CF and all those values are valid for the * category*. It just doesn't show up at all when in the Modify Ticket' screen. This is not what my users are used to, as we started using the * category* field in the first place because they didn't want to scroll thru a bunch of values that didn't apply to their respective groups (the * category* itself). Is anyone else getting this? Thanks in advance. Kenn LBNL Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] No To: Field being generated.
On Fri, May 14, 2010 at 6:24 PM, Ruslan Zakirov r...@bestpractical.com wrote: Hello, I believe you should become more familiar with NotifyActor option. I apologize but I am still confused. From what I read http://wiki.bestpractical.com/view/EmailInterface, I thought NotifyActor was just there to select whether the person who replied to the ticket gets a copy of this reply or not. Here is my test email, which I sent from my gmail account, after being passed through RT: Subject: [domain support #1186] A Test From: Mauricio Tavares raubvo...@gmail.com Date: Wed, 12 May 2010 15:28:42 -0400 Return-Path: raubvo...@gmail.com Delivered-To: mauri...@domain.com Reply-To: supp...@domain.com In-Reply-To: aanlktiksne66layxlkcih3g6i0a2wdbcimpgwyaag...@mail.gmail.com References: rt-ticket-1...@domain.com aanlktiksne66layxlkcih3g6i0a2wdbcimpgwyaag...@mail.gmail.com Message-ID: rt-3.6.7-23269-1273692522-49.1186-...@domain.com Precedence: bulk X-RT-Loop-Prevention: domain support RT-Ticket: domain support #1186 Managed-by: RT 3.6.7 (http://www.bestpractical.com/rt/) RT-Originator: supp...@domain.com MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=utf-8 X-RT-Original-Encoding: utf-8 The System is Down Now, mauri...@domain.com is a member of the support group, so it should receive this email. But, as you can see from above, there is no To: field. On Sat, May 15, 2010 at 1:34 AM, Mauricio Tavares raubvo...@gmail.com wrote: On Tue, May 11, 2010 at 3:21 PM, Ruslan Zakirov r...@bestpractical.com wrote: Mauricio, Without logs and additional info we can not help you. Sorry for that. I sent a test email, -- Best regards, Ruslan. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] No To: Field being generated.
On Tue, 18 May 2010 16:58:18 -0400, Mauricio Tavares raubvo...@gmail.com said: Now, mauri...@domain.com is a member of the support group, so it should receive this email. But, as you can see from above, there is no To: field. If mauri...@domain.com is set up as an AdminCC watcher on the queue, then I believe they will be bcc'ed in an email separate from what is sent to Requestors, so the email they get will not have a To: field set. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Trying to install mod_perl
On Tue, May 18, 2010 at 19:55, borngunn...@aol.com wrote: I have remove it and successfully reinstall it without the messages that showed up. Apache still keeps failing with the following error message after I look into my log: [Tue May 18 14:47:36 2010] [error] Can't load Perl file: /opt/rt3/bin/webmux.pl for server UHC Helpdesk:0, exiting... Does that file exist? Can the user you're running Apache as access it? -- Please keep list traffic on the list. Rob MacGregor Whoever fights monsters should see to it that in the process he doesn't become a monster. Friedrich Nietzsche Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Migration from MySQL to PostgreSQL - Pg datatypes for blobs?
On Mon, May 17, 2010 at 02:10:43PM +0200, Emmanuel Lacour wrote: Maybe there is a better way as of recent postgres? FYI: fwd -- Zito ---BeginMessage--- * Václav Ovsík: Is it possible that binding of binary data-type (bytea) without data-type specification would behave like in MySQL in some future versions of DBD::Pg? Binding binary values works correctly without type specification in DBD::mysql. PostgreSQL's on-the-wire protocol has issues which make this very difficult to implement, unfortunately. ---End Message--- Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] 1; in the RT_SiteConfig.pm file
Hi, folks. Below is an excerpt (located at the end of my RT_SiteConfig.pm file): My 'easy' question is: what this 1; does at the final? What is its utility? I don't remember if I had put it there or RT came with it by default. # this has no effect for the SQLite case, the first Set() wins # end /etc/request-tracker3.6/RT_SiteConfig.d/51-dbconfig-common # end /etc/request-tracker3.6/RT_SiteConfig.d/50-debconf 1; Thanks in advance. Att, -- Wagner Pereira PoP-SP/RNP - Ponto de Presença da RNP em São Paulo CCE/USP - Centro de Computação Eletrônica da Universidade de São Paulo http://www.pop-sp.rnp.br Tel. (11) 3091-8901 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 1; in the RT_SiteConfig.pm file
Wagner Pereira wrote: Hi, folks. Below is an excerpt (located at the end of my RT_SiteConfig.pm file): My 'easy' question is: what this 1; does at the final? What is its utility? I don't remember if I had put it there or RT came with it by default. # this has no effect for the SQLite case, the first Set() wins # end /etc/request-tracker3.6/RT_SiteConfig.d/51-dbconfig-common # end /etc/request-tracker3.6/RT_SiteConfig.d/50-debconf 1; All good Perl modules have this as the exit code/value at the end. \\||/ Rod -- Thanks in advance. Att, Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Searching with no case sensitivity?
Is there an easy way to turn off case sensitivity for the search feature in RT 3.8.x? I am using MySql as the database Terrible, awful hack of DBIx::SearchBuilder.pm (/usr/share/perl5/DBIx/SearchBuilder.pm) to transform the case sensitive BLOB column to a case-INsensitive during WHERE clause comparison: line 991 + $subclause =~ s/Attachments_[0-9]\.Content/CONVERT\($ Using latin1\)/; If you use SearchBuilder for anything other than RT with MySQL, this hack will break your stuff. But it will fix the RT searches to be case insensitive. You will find tHisORThat when you search for thisorthat Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Trying to install mod_perl
Does that file exist? Can the user you're running Apache as access it? I checked the file and it was in there and I am running apache as root and root seems to own the file. -Original Message- From: Rob MacGregor rob.macgre...@gmail.com To: RT-Users RT-Users@lists.bestpractical.com Sent: Tue, May 18, 2010 5:39 pm Subject: Re: [rt-users] Trying to install mod_perl On Tue, May 18, 2010 at 19:55, borngunn...@aol.com wrote: I have remove it and successfully reinstall it without the messages that showed up. Apache still keeps failing with the following error message after I look into my log: [Tue May 18 14:47:36 2010] [error] Can't load Perl file: /opt/rt3/bin/webmux.pl for server UHC Helpdesk:0, exiting... Does that file exist? Can the user you're running Apache as access it? -- Please keep list traffic on the list. Rob MacGregor Whoever fights monsters should see to it that in the process he doesn't become a monster. Friedrich Nietzsche Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 1; in the RT_SiteConfig.pm file
Wagner Pereira wrote: My 'easy' question is: what this 1; does at the final? What is its utility? I don't remember if I had put it there or RT came with it by default. 1; All good Perl modules have this as the exit code/value at the end. More specifically, if I may quote from Wikipedia... # A Perl module must end with a true value or else it is considered not to # have loaded. By convention this value is usually 1 though it can be # any true value. A module can end with false to indicate failure but # this is rarely used and it would instead die() (exit with an error). John Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com