Re: [rt-users] cannot get result of search Chinese character - centos 5.4
Kevin, Thanks for your reply. Same database, from Debian box is okay, but CentOS 5.4 is not. Here it sql file: INSERT INTO `Tickets` (`id`, `EffectiveId`, `Queue`, `Type`, `IssueStatement`, `Resolution`, `Owner`, `Subject`, `InitialPriority`, `FinalPriority`, `Priority`, `TimeEstimated`, `TimeWorked`, `Status`, `TimeLeft`, `Told`, `Starts`, `Started`, `Due`, `Resolved`, `LastUpdatedBy`, `LastUpdated`, `Creator`, `Created`, `Disabled`) VALUES (1, 1, 1, 'ticket', 0, 0, 6, '中文测试 - test - 123abc', 0, 0, 0, 0, 0, 'new', 0, NULL, '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 12, '2011-12-20 14:02:47', 12, '2011-12-20 14:02:47', 0), (2, 2, 1, 'ticket', 0, 0, 6, '中文测试2', 0, 0, 0, 0, 0, 'new', 0, NULL, '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 12, '2011-12-20 15:51:25', 12, '2011-12-20 15:51:24', 0); Here it is from rt.log(Debian): [debug]: SQL(0.167067s): SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Subject LIKE '%中%') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ORDER BY main.id ASC LIMIT 50; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1064) Here it is from rt.log(CentOS): [debug]: SQL(0.000729s): SELECT count(main.id) FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Subject LIKE '%涓?') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1064) Thanks, -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Sphinx fulltext index v4.0.4
On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poul...@vanderbilt.edu wrote: However, Request Tracker does not seem to be searching the index. If we search for any term that is only in the contents of the ticket and not the header we do not get any hits. We do get hits for terms in the ticket header though. If I search sphinx directly for a term everything works correctly. It seems as if RT is not searching Sphinx. Have I missed a step in the setup process? Any assistance will be appreciated. Thanks. How do you search? It's still required to use fulltext:x in simple search and Content in the query builder. -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Creating custom fields with non-root account?
Hello, we have recently added a new queue to our RT system: this queue is supposed to be used by one (external) group of colleagues only and they should be able to make any changes to it they desire. In our configuration, only the root user can create custom fields and, if possible, it should not be necessary for our external colleagues to have the root password to edit their custom fields. Is it possible to give particular users of one RT group root rights (or extended rights for editing custom fields, at least) - but only for one queue? Many thanks in advance. Best regards, Stefan -- Dr. Stefan Vollmar, Dipl.-Phys. Head of IT group Max-Planck-Institut für neurologische Forschung Gleuelerstr. 50, 50931 Köln, Germany Tel.: +49-221-4726-213 FAX +49-221-4726-298 Tel.: +49-221-478-5713 Mobile: 0160-93874279 Email: voll...@nf.mpg.de http://www.nf.mpg.de smime.p7s Description: S/MIME cryptographic signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Sphinx fulltext index v4.0.4
On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poul...@vanderbilt.edu wrote: I actually tried with and without the fulltext without any success. It's hard to say what went wrong. Just for clarification, you've created required tables with a script, configured RT's config, configured sphinx, setup indexer that puts data into sphinx index. Right? To diagnose this start with RT's debug log. Enable logging of SQL statements in RT. Use command line sphinx client to make sure data is in the index. At this moment we don't have any info to help you. Sent from iphone On Dec 23, 2011, at 3:09 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poul...@vanderbilt.edu wrote: However, Request Tracker does not seem to be searching the index. If we search for any term that is only in the contents of the ticket and not the header we do not get any hits. We do get hits for terms in the ticket header though. If I search sphinx directly for a term everything works correctly. It seems as if RT is not searching Sphinx. Have I missed a step in the setup process? Any assistance will be appreciated. Thanks. How do you search? It's still required to use fulltext:x in simple search and Content in the query builder. -- Best regards, Ruslan. -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Sphinx fulltext index v4.0.4
Correct. The index and table seems to have been created. One strange item is that the attatchmentindex table in MySQL is empty. Thanks for your help. Sent from iphone On Dec 23, 2011, at 8:29 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poul...@vanderbilt.edu wrote: I actually tried with and without the fulltext without any success. It's hard to say what went wrong. Just for clarification, you've created required tables with a script, configured RT's config, configured sphinx, setup indexer that puts data into sphinx index. Right? To diagnose this start with RT's debug log. Enable logging of SQL statements in RT. Use command line sphinx client to make sure data is in the index. At this moment we don't have any info to help you. Sent from iphone On Dec 23, 2011, at 3:09 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poul...@vanderbilt.edu wrote: However, Request Tracker does not seem to be searching the index. If we search for any term that is only in the contents of the ticket and not the header we do not get any hits. We do get hits for terms in the ticket header though. If I search sphinx directly for a term everything works correctly. It seems as if RT is not searching Sphinx. Have I missed a step in the setup process? Any assistance will be appreciated. Thanks. How do you search? It's still required to use fulltext:x in simple search and Content in the query builder. -- Best regards, Ruslan. -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Sphinx fulltext index v4.0.4
On Fri, Dec 23, 2011 at 18:47, Poulter, Dale dale.poul...@vanderbilt.edu wrote: Correct. The index and table seems to have been created. One strange item is that the attatchmentindex table in MySQL is empty. Thanks for your help. It's sort of empty as it's dynamic. It's a special table that connects mysql to sphinx. Run 'show create table AttachmentsIndex' and send us output. Sent from iphone On Dec 23, 2011, at 8:29 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poul...@vanderbilt.edu wrote: I actually tried with and without the fulltext without any success. It's hard to say what went wrong. Just for clarification, you've created required tables with a script, configured RT's config, configured sphinx, setup indexer that puts data into sphinx index. Right? To diagnose this start with RT's debug log. Enable logging of SQL statements in RT. Use command line sphinx client to make sure data is in the index. At this moment we don't have any info to help you. Sent from iphone On Dec 23, 2011, at 3:09 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poul...@vanderbilt.edu wrote: However, Request Tracker does not seem to be searching the index. If we search for any term that is only in the contents of the ticket and not the header we do not get any hits. We do get hits for terms in the ticket header though. If I search sphinx directly for a term everything works correctly. It seems as if RT is not searching Sphinx. Have I missed a step in the setup process? Any assistance will be appreciated. Thanks. How do you search? It's still required to use fulltext:x in simple search and Content in the query builder. -- Best regards, Ruslan. -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] 3.4.2 to 4.x
I recently went through upgrading/migrating to a new server and setting up an upgrade from a 3.4.5 to 4.0.2. Let me know if you want the steps that I went through to get it working... Kevin On Thu, Dec 22, 2011 at 4:55 PM, Thomas Sibley t...@bestpractical.comwrote: On 12/22/2011 03:45 PM, Jeff Blaine wrote: Before I waste a bunch of time, is there any chance this is likely to work? 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') 2. Stand up new server with RT 4.x and modern MySQL 3. Import old data Not with just those steps, but yes, of course you can upgrade from 3.4.2 to 4.0.4. Carefully read and follow the instructions in the UPGRADING.mysql, UPGRADING-3.4, UPGRADING-3.6, UPGRADING-3.8, and UPGRADING-4.0 documentation. You have a large upgrade ahead of you, but it's well documented and fairly straightforward. http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html is a gentle introduction, but it does not try to cover all of the individual steps you'll need to take, just the general process. Thomas 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
Re: [rt-users] Option to store attachments on the filesystem
On 12/22/2011 12:43 PM, Joe Harris wrote: I am looking into this type of functionality as well. We were thinking of an NSF share in a web directory to drop the attachment with a way to drop a link within the ticket. So the attachments may not even exist on the RT server, but there will be links in the ticket to a web server that houses the attachment. It'd be nice if this was the case, but the big problem with having the web server directly serve your attachments is that suddenly you lose _all_ access control that RT normally provides around attachments. Even if attachments are stored on disk, they must be _served_ by RT, not the web server directly. Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Option to store attachments on the filesystem
Please keep replies on the list. For the record, I'm not claiming that core RT shouldn't support attachments on disk in the future. I'm just trying to give you the relevant info for right now. On 12/22/2011 08:58 PM, Geoff Mayes wrote: I searched but struck out. Could you provide some links? Why isn' it public? Any way I can take a look at it? :) The extension was originally the result of customer work, and it hasn't been made public. Will it be made public? We don't know yet. For the time being, you'll need to contact sa...@bestpractical.com if you're interested in it. The mailing list threads I found just now with a search: http://www.gossamer-threads.com/lists/rt/users/92667 http://www.gossamer-threads.com/lists/rt/users/100964 Is it that non-trivial? The Bugzilla in-house Attachments.pm module we used to use was 200 lines of Perl and that handled the main 8TB attachments datastore as well as the archives 30TB datastore, sorting out discrepancies between the two. And larger organizations will have the resources and expertise to do these kinds of things easily, so if RT really is for organizations of all sizes, then how does it cater to the non-trivial users in this matter? Larger organizations take a variety of steps to help ensure RT performs well. Yes, occasionally that includes putting attachments on disk, but it also includes good database tuning and many other tweaks before that. The fact is that a 15 or 20GB database is simply not large at all; 15-20GB fits on a single USB flash drive. I just don't see how keeping attachments in the database is *optimal* for backing up and restoring the database when the database gets beyond 10-20GB, especially when an organization hasn't paid Oracle $5,000 so they can run hotcopy on their InnoDB databases. As Ken from rice.edu said earlier, there are smarter backup solutions than dumping/restoring the entire DB every single time. He named a couple. As for Oracle's $5k tool, you can get similar results with Percona's completely free, open-source hot backup/copy tool for InnoDB called XtraBackup: http://www.percona.com/software/percona-xtrabackup/ How big are their databases and attachment tables? How do they do backups and restores? What are their disaster recovery plans? These are customers that we can't provide that information on. There was at least one thread in 2010 or 2011 on the mailing list asking people to contribute stats about the sizes of their RT instance. Some notably large ones came up. Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Sphinx fulltext index v4.0.4
Hi, Looks good. Move on to SQL log and debug log. On Fri, Dec 23, 2011 at 21:13, Poulter, Dale dale.poul...@vanderbilt.edu wrote: Here is the output. Thanks. mysql show create table AttachmentsIndex; +--+---+ | Table | Create Table | +--+---+ | AttachmentsIndex | CREATE TABLE `AttachmentsIndex` ( `id` int(10) unsigned NOT NULL, `weight` int(11) NOT NULL, `query` varchar(3072) NOT NULL, KEY `query` (`query`(1024)) ) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:9312/rt' | +--+---+ 1 row in set (0.00 sec) -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Friday, December 23, 2011 8:56 AM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 On Fri, Dec 23, 2011 at 18:47, Poulter, Dale dale.poul...@vanderbilt.edu wrote: Correct. The index and table seems to have been created. One strange item is that the attatchmentindex table in MySQL is empty. Thanks for your help. It's sort of empty as it's dynamic. It's a special table that connects mysql to sphinx. Run 'show create table AttachmentsIndex' and send us output. Sent from iphone On Dec 23, 2011, at 8:29 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poul...@vanderbilt.edu wrote: I actually tried with and without the fulltext without any success. It's hard to say what went wrong. Just for clarification, you've created required tables with a script, configured RT's config, configured sphinx, setup indexer that puts data into sphinx index. Right? To diagnose this start with RT's debug log. Enable logging of SQL statements in RT. Use command line sphinx client to make sure data is in the index. At this moment we don't have any info to help you. Sent from iphone On Dec 23, 2011, at 3:09 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poul...@vanderbilt.edu wrote: However, Request Tracker does not seem to be searching the index. If we search for any term that is only in the contents of the ticket and not the header we do not get any hits. We do get hits for terms in the ticket header though. If I search sphinx directly for a term everything works correctly. It seems as if RT is not searching Sphinx. Have I missed a step in the setup process? Any assistance will be appreciated. Thanks. How do you search? It's still required to use fulltext:x in simple search and Content in the query builder. -- Best regards, Ruslan. -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- Best regards, Ruslan. -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Sphinx fulltext index v4.0.4
Here is the output. Thanks. mysql show create table AttachmentsIndex; +--+---+ | Table| Create Table | +--+---+ | AttachmentsIndex | CREATE TABLE `AttachmentsIndex` ( `id` int(10) unsigned NOT NULL, `weight` int(11) NOT NULL, `query` varchar(3072) NOT NULL, KEY `query` (`query`(1024)) ) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:9312/rt' | +--+---+ 1 row in set (0.00 sec) -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Friday, December 23, 2011 8:56 AM To: Poulter, Dale Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 On Fri, Dec 23, 2011 at 18:47, Poulter, Dale dale.poul...@vanderbilt.edu wrote: Correct. The index and table seems to have been created. One strange item is that the attatchmentindex table in MySQL is empty. Thanks for your help. It's sort of empty as it's dynamic. It's a special table that connects mysql to sphinx. Run 'show create table AttachmentsIndex' and send us output. Sent from iphone On Dec 23, 2011, at 8:29 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poul...@vanderbilt.edu wrote: I actually tried with and without the fulltext without any success. It's hard to say what went wrong. Just for clarification, you've created required tables with a script, configured RT's config, configured sphinx, setup indexer that puts data into sphinx index. Right? To diagnose this start with RT's debug log. Enable logging of SQL statements in RT. Use command line sphinx client to make sure data is in the index. At this moment we don't have any info to help you. Sent from iphone On Dec 23, 2011, at 3:09 AM, Ruslan Zakirov r...@bestpractical.com wrote: On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poul...@vanderbilt.edu wrote: However, Request Tracker does not seem to be searching the index. If we search for any term that is only in the contents of the ticket and not the header we do not get any hits. We do get hits for terms in the ticket header though. If I search sphinx directly for a term everything works correctly. It seems as if RT is not searching Sphinx. Have I missed a step in the setup process? Any assistance will be appreciated. Thanks. How do you search? It's still required to use fulltext:x in simple search and Content in the query builder. -- Best regards, Ruslan. -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012 -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] 3.4.2 to 4.x
I've read and re-read docs/UPGRADING*. Things are going quite smoothly so far, as this is a pretty stock old install of 3.4.2 heading to 4.0.4 on a totally different box. Question: Importing the old MySQL 'rt3' database as 'rt4' How? Edit the dump file? Thanks for any further help! On 12/22/2011 4:55 PM, Thomas Sibley wrote: On 12/22/2011 03:45 PM, Jeff Blaine wrote: Before I waste a bunch of time, is there any chance this is likely to work? 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') 2. Stand up new server with RT 4.x and modern MySQL 3. Import old data Not with just those steps, but yes, of course you can upgrade from 3.4.2 to 4.0.4. Carefully read and follow the instructions in the UPGRADING.mysql, UPGRADING-3.4, UPGRADING-3.6, UPGRADING-3.8, and UPGRADING-4.0 documentation. You have a large upgrade ahead of you, but it's well documented and fairly straightforward. http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html is a gentle introduction, but it does not try to cover all of the individual steps you'll need to take, just the general process. Thomas 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
Re: [rt-users] 3.4.2 to 4.x
Just (within MySql): create database rt4; Then, from the command line, using the dump from your current mysql server, mysql -u username -p rt4 name_of_sql_dump.sql -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Friday, December 23, 2011 2:00 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x I've read and re-read docs/UPGRADING*. Things are going quite smoothly so far, as this is a pretty stock old install of 3.4.2 heading to 4.0.4 on a totally different box. Question: Importing the old MySQL 'rt3' database as 'rt4' How? Edit the dump file? Thanks for any further help! On 12/22/2011 4:55 PM, Thomas Sibley wrote: On 12/22/2011 03:45 PM, Jeff Blaine wrote: Before I waste a bunch of time, is there any chance this is likely to work? 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') 2. Stand up new server with RT 4.x and modern MySQL 3. Import old data Not with just those steps, but yes, of course you can upgrade from 3.4.2 to 4.0.4. Carefully read and follow the instructions in the UPGRADING.mysql, UPGRADING-3.4, UPGRADING-3.6, UPGRADING-3.8, and UPGRADING-4.0 documentation. You have a large upgrade ahead of you, but it's well documented and fairly straightforward. http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html is a gentle introduction, but it does not try to cover all of the individual steps you'll need to take, just the general process. Thomas 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 Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] 3.4.2 to 4.x
On 12/23/2011 3:03 PM, Izz Abdullah wrote: Just (within MySql): create database rt4; Then, from the command line, using the dump from your current mysql server, mysql -uusername -p rt4 name_of_sql_dump.sql Thanks. That will override the 'CREATE DATABASE' in the rt3 dump file? -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Friday, December 23, 2011 2:00 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x I've read and re-read docs/UPGRADING*. Things are going quite smoothly so far, as this is a pretty stock old install of 3.4.2 heading to 4.0.4 on a totally different box. Question: Importing the old MySQL 'rt3' database as 'rt4' How? Edit the dump file? Thanks for any further help! On 12/22/2011 4:55 PM, Thomas Sibley wrote: On 12/22/2011 03:45 PM, Jeff Blaine wrote: Before I waste a bunch of time, is there any chance this is likely to work? 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') 2. Stand up new server with RT 4.x and modern MySQL 3. Import old data Not with just those steps, but yes, of course you can upgrade from 3.4.2 to 4.0.4. Carefully read and follow the instructions in the UPGRADING.mysql, UPGRADING-3.4, UPGRADING-3.6, UPGRADING-3.8, and UPGRADING-4.0 documentation. You have a large upgrade ahead of you, but it's well documented and fairly straightforward. http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html is a gentle introduction, but it does not try to cover all of the individual steps you'll need to take, just the general process. Thomas 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 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
Re: [rt-users] 3.4.2 to 4.x
This is the way I upgraded from 3.8 - 4.0.x. I think you could pipe the dump without creating the database first, but is seems like I had an issue with MySQL throwing an error back at me saying database rt4 does not exist. So, to answer your question, yes. If you have a database already created and you pipe the dump using the mysql -u root -p rt4 mysqldump.sql command, it will put your dump into the database named rt4. Then you can go about the database upgrade procedures you have read in the UPGRADE_READMEs. Hope this helps. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Friday, December 23, 2011 2:42 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x On 12/23/2011 3:03 PM, Izz Abdullah wrote: Just (within MySql): create database rt4; Then, from the command line, using the dump from your current mysql server, mysql -uusername -p rt4 name_of_sql_dump.sql Thanks. That will override the 'CREATE DATABASE' in the rt3 dump file? -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Friday, December 23, 2011 2:00 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x I've read and re-read docs/UPGRADING*. Things are going quite smoothly so far, as this is a pretty stock old install of 3.4.2 heading to 4.0.4 on a totally different box. Question: Importing the old MySQL 'rt3' database as 'rt4' How? Edit the dump file? Thanks for any further help! On 12/22/2011 4:55 PM, Thomas Sibley wrote: On 12/22/2011 03:45 PM, Jeff Blaine wrote: Before I waste a bunch of time, is there any chance this is likely to work? 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') 2. Stand up new server with RT 4.x and modern MySQL 3. Import old data Not with just those steps, but yes, of course you can upgrade from 3.4.2 to 4.0.4. Carefully read and follow the instructions in the UPGRADING.mysql, UPGRADING-3.4, UPGRADING-3.6, UPGRADING-3.8, and UPGRADING-4.0 documentation. You have a large upgrade ahead of you, but it's well documented and fairly straightforward. http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html is a gentle introduction, but it does not try to cover all of the individual steps you'll need to take, just the general process. Thomas 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 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 Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] 3.4.2 to 4.x
On Sat, Dec 24, 2011 at 00:42, Jeff Blaine jbla...@kickflop.net wrote: On 12/23/2011 3:03 PM, Izz Abdullah wrote: Just (within MySql): create database rt4; Then, from the command line, using the dump from your current mysql server, mysql -uusername -p rt4 name_of_sql_dump.sql Thanks. That will override the 'CREATE DATABASE' in the rt3 dump file? mysqldump --opt xxx xxx.dump.sql This command doesn't add create database or other instructions to select database. You specify database to restore dump into when you run `mysql xxx xxx.dump.sql`. Note that you're using RT 3.4 on mysql 4.1 and newer, then you should use binary charset during dumping and don't forget to upgrade mysql schema. It's special step described in the documentation. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Friday, December 23, 2011 2:00 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x I've read and re-read docs/UPGRADING*. Things are going quite smoothly so far, as this is a pretty stock old install of 3.4.2 heading to 4.0.4 on a totally different box. Question: Importing the old MySQL 'rt3' database as 'rt4' How? Edit the dump file? Thanks for any further help! On 12/22/2011 4:55 PM, Thomas Sibley wrote: On 12/22/2011 03:45 PM, Jeff Blaine wrote: Before I waste a bunch of time, is there any chance this is likely to work? 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') 2. Stand up new server with RT 4.x and modern MySQL 3. Import old data Not with just those steps, but yes, of course you can upgrade from 3.4.2 to 4.0.4. Carefully read and follow the instructions in the UPGRADING.mysql, UPGRADING-3.4, UPGRADING-3.6, UPGRADING-3.8, and UPGRADING-4.0 documentation. You have a large upgrade ahead of you, but it's well documented and fairly straightforward. http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html is a gentle introduction, but it does not try to cover all of the individual steps you'll need to take, just the general process. Thomas 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 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 -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Creating custom fields with non-root account?
Yep. On Fri, Dec 23, 2011 at 1:39 AM, Stefan Vollmar voll...@nf.mpg.de wrote: Hello, we have recently added a new queue to our RT system: this queue is supposed to be used by one (external) group of colleagues only and they should be able to make any changes to it they desire. In our configuration, only the root user can create custom fields and, if possible, it should not be necessary for our external colleagues to have the root password to edit their custom fields. Is it possible to give particular users of one RT group root rights (or extended rights for editing custom fields, at least) - but only for one queue? Many thanks in advance. Best regards, Stefan -- Dr. Stefan Vollmar, Dipl.-Phys. Head of IT group Max-Planck-Institut für neurologische Forschung Gleuelerstr. 50, 50931 Köln, Germany Tel.: +49-221-4726-213 FAX +49-221-4726-298 Tel.: +49-221-478-5713 Mobile: 0160-93874279 Email: voll...@nf.mpg.de http://www.nf.mpg.de 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