Re: [rt-users] Upgrade RT 3.8.7 to 4.0.1
| +---+--+ 1 row in set (0.00 sec) ## ## ## mysql show create table ACL; +---++ | Table | Create Table | +---++ | ACL | CREATE TABLE `ACL` ( `id` int(11) NOT NULL AUTO_INCREMENT, `PrincipalType` varchar(25) CHARACTER SET ascii NOT NULL, `PrincipalId` int(11) NOT NULL, `RightName` varchar(25) CHARACTER SET ascii NOT NULL, `ObjectType` varchar(25) CHARACTER SET ascii NOT NULL, `ObjectId` int(11) NOT NULL DEFAULT '0', `Creator` int(11) NOT NULL DEFAULT '0', `Created` datetime DEFAULT NULL, `LastUpdatedBy` int(11) NOT NULL DEFAULT '0', `LastUpdated` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `ACL1` (`RightName`,`ObjectType`,`ObjectId`,`PrincipalType`,`PrincipalId`) ) ENGINE=InnoDB AUTO_INCREMENT=1731 DEFAULT CHARSET=utf8 | +---++ -- Message: 2 Date: Fri, 29 Aug 2014 16:59:59 -0500 From: Kevin Falcone falc...@bestpractical.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrade RT 3.8.7 to 4.0.1 Message-ID: 20140829215959.gd3...@jibsheet.com Content-Type: text/plain; charset=us-ascii On Fri, Aug 29, 2014 at 01:18:11PM -0300, Felipe Agnelli Barbosa wrote: Show the schema of your Users table, although if your ACL table is also messed up then you've not completed the upgrade. You neglected this information run 'show create table Users' and 'show create table ACL' and share it with us. -kevin -- next part -- A non-text attachment was scrubbed... Name: not available Type
Re: [rt-users] Upgrade RT 3.8.7 to 4.0.1
Hi Kevin, I already understood where i was wrong. Here my answers, Message: 12 Date: Fri, 22 Aug 2014 09:59:41 -0400 From: Kevin Falcone falc...@bestpractical.com To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgrade RT 3.8.7 to 4.0.1 Message-ID: 20140822135941.ge3...@jibsheet.com Content-Type: text/plain; charset=us-ascii On Mon, Aug 18, 2014 at 06:02:41PM -0300, Felipe Agnelli Barbosa wrote: 4. Apply upgrade the schema at the current server and after in the new server $perl /usr/share/request-tracker3.8/etc/upgrade/[1] upgrade-mysql-schema.pl rtdb root password queries.sql $mysql -u root -p rtdb queries.sql Why? Step 1 of http://bestpractical.com/docs/rt/4.0/UPGRADING.mysql.html tells you not to run that ok 5. Run the upgrade database at the new server $rt-setup-database-4 --prompt-for-dba-password --action upgrade I assume this has not completed properly here, i receive following msg, Processing 3.8.8 Now inserting data. [ [warning]: Couldn't set SortOrder: That is already the current value (/usr/share/request-tracker4/etc/upgrade/3.8.8/content:32) Processing 3.8.9 Now inserting data. [warning]: Use of uninitialized value in string eq at /usr/share/request-tracker4/lib/RT/Template.pm line 656, line 1. (/usr/share/request-tracker4/lib/RT/Template.pm:656) [warning]: Use of uninitialized value in string eq at /usr/share/request-tracker4/lib/RT/Template.pm line 656, line 1. (/usr/share/request-tracker4/lib/RT/Template.pm:656) [warning]: Use of uninitialized value in string eq at /usr/share/request-tracker4/lib/RT/Template.pm line 656, line 1. (/usr/share/request-tracker4/lib/RT/Template.pm:656) Processing 3.9.1 Now inserting data. Processing 3.9.2 Now inserting data. Processing 3.9.3 Now populating database schema. Processing 3.9.5 Now populating database schema. Processing 3.9.6 Now populating database schema. Processing 3.9.7 Now populating database schema. Now inserting data. Processing 3.9.8 Now populating database schema. Now inserting data. Processing 4.0.0rc2 Now populating database schema. Processing 4.0.0rc4 Now populating database schema. Processing 4.0.0rc7 Now inserting data. Processing 4.0.1 Now inserting data. Processing 4.0.3 Now inserting data. Processing 4.0.4 Now inserting data. Processing 4.0.6 Now populating database schema. Now inserting data. Processing 4.0.9 Now inserting data. Processing 4.0.12 Now populating database schema. Processing 4.0.13 Now populating database schema. Processing 4.0.18 Now inserting data. Processing 4.0.19 Now populating database schema. Now inserting data. Done. Whats mean the warning message? and more, after that, when I restarted webserver, i receive too a msg, like that, [warning]: Use of uninitialized value in numeric eq (==) at /usr/share/request-tracker4/lib/RT/ScripAction.pm line 202. (/usr/share/request-tracker4/lib/RT/ScripAction.pm:202) Thank you for your help, 6. Start webserver at the new server $service apache2 start Than, i can do login once after changing my password and i can't create ticket neither change the owner they. Show the schema of your Users table, although if your ACL table is also messed up then you've not completed the upgrade. Show your database upgrade. -kevin -- next part -- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 221 bytes Desc: not available URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20140822/f5c2bd88/attachment-0001.pgp -- A dúvida é o principio da sabedoria -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Upgrade RT 3.8.7 to 4.0.1
Hi Guys, I'm migrating of server and i would like to upgrade my rt instalation. My current configuration is it, Ubuntu 10.0.4 RT(via apt-get) 3.8.7 Mysql 5.1.6 New server: Ubuntu 14.0.4 RT(via apt-get) 4.0.19 Mysql 5.5.3 So, I follow the documentation, README, UPGRADING-3.8.gz, UPGRADING-4.0.gz, UPGRADING.mysql, NOTES.Debian.gz, README.Debian.gz among other. I find to other cases like me at the list but it don't help to fix my problem. And, i did the following : 1. Backup at the current server $/usr/bin/mysqldump -u root -password --default-character-set=latin1 --databases rtdb rtdb.dump 2. Imported at the new server $mysql -u root -password --default-character-set=latin1 rtdb rtdb.dump 3. Exec this script at the new server $perl /usr/share/request-tracker4/etc/upgrade/vulnerable-passwords 4. Apply upgrade the schema at the current server and after in the new server $perl /usr/share/request-tracker3.8/etc/upgrade/upgrade-mysql-schema.pl rtdb root password queries.sql $mysql -u root -p rtdb queries.sql 5. Run the upgrade database at the new server $rt-setup-database-4 --prompt-for-dba-password --action upgrade 6. Start webserver at the new server $service apache2 start Than, i can do login once after changing my password and i can't create ticket neither change the owner they. So you guy, can me give a hint? I appreciate your help. -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Queries Sql
How can I tell how many comments had every ticket via sql queries? thanks in advance, Felipe BR -- A dúvida é o principio da sabedoria
[rt-users] comments - as regard them?
Gentlemen, I am developing a script in sql, and I wonder how many comments each ticket is created. What would my sql query? From what I saw, the ticket data are in Table guaradados attachments. Thank you in advance. Felipe BR -- A dúvida é o principio da sabedoria
[rt-users] Records RT - Doubt
Dear, Not sure this is the place, but wanted help to generate some reports relating to RT in a MySQL database. I wonder if they already have a tool ready for customization of reports, or if I have to do this via sql queries. Thank you in advance, Felipe BR -- A dúvida é o principio da sabedoria
Re: [rt-users] Records RT - Doubt
Hello Ruslan Zakirov, Thank you for your attention, so I wanted something more specific, how I can export in CSV? And, by chance, someone already has some ready to excel? Outside CSV has some other way? Thanks again, Felipe BR 2011/5/25 Ruslan Zakirov r...@bestpractical.com Hi, Take look at charts, saved searches and dashboards. If it's not enough, people often use csv export and excel to produce reports. On Wed, May 25, 2011 at 8:16 PM, Felipe Agnelli Barbosa no.mo...@gmail.com wrote: Dear, Not sure this is the place, but wanted help to generate some reports relating to RT in a MySQL database. I wonder if they already have a tool ready for customization of reports, or if I have to do this via sql queries. Thank you in advance, Felipe BR -- A dúvida é o principio da sabedoria -- Best regards, Ruslan. -- A dúvida é o principio da sabedoria
Re: [rt-users] Records RT - Doubt
Okay, I'll check that. Enjoying a little more, it is possible for SQL?, I was thinking of doing some SQL queries and build a Python script showing statistics. Felipe BR 2011/5/25 Ruslan Zakirov r...@bestpractical.com Hi, Search for tickets, open page with results, use actions at the top right corner. On Wed, May 25, 2011 at 8:57 PM, Felipe Agnelli Barbosa no.mo...@gmail.com wrote: Hello Ruslan Zakirov, Thank you for your attention, so I wanted something more specific, how I can export in CSV? And, by chance, someone already has some ready to excel? Outside CSV has some other way? Thanks again, Felipe BR 2011/5/25 Ruslan Zakirov r...@bestpractical.com Hi, Take look at charts, saved searches and dashboards. If it's not enough, people often use csv export and excel to produce reports. On Wed, May 25, 2011 at 8:16 PM, Felipe Agnelli Barbosa no.mo...@gmail.com wrote: Dear, Not sure this is the place, but wanted help to generate some reports relating to RT in a MySQL database. I wonder if they already have a tool ready for customization of reports, or if I have to do this via sql queries. Thank you in advance, Felipe BR -- A dúvida é o principio da sabedoria -- Best regards, Ruslan. -- A dúvida é o principio da sabedoria -- Best regards, Ruslan. -- A dúvida é o principio da sabedoria
Re: [rt-users] Records RT - Doubt
I have a copy of the database, and I'll test it. 2011/5/25 Ruslan Zakirov r...@bestpractical.com On Wed, May 25, 2011 at 9:15 PM, Felipe Agnelli Barbosa no.mo...@gmail.com wrote: Okay, I'll check that. Enjoying a little more, it is possible for SQL?, I was thinking of doing some SQL queries and build a Python script showing statistics. Sure, who will stop you from SQLing DB on your server? Felipe BR 2011/5/25 Ruslan Zakirov r...@bestpractical.com Hi, Search for tickets, open page with results, use actions at the top right corner. On Wed, May 25, 2011 at 8:57 PM, Felipe Agnelli Barbosa no.mo...@gmail.com wrote: Hello Ruslan Zakirov, Thank you for your attention, so I wanted something more specific, how I can export in CSV? And, by chance, someone already has some ready to excel? Outside CSV has some other way? Thanks again, Felipe BR 2011/5/25 Ruslan Zakirov r...@bestpractical.com Hi, Take look at charts, saved searches and dashboards. If it's not enough, people often use csv export and excel to produce reports. On Wed, May 25, 2011 at 8:16 PM, Felipe Agnelli Barbosa no.mo...@gmail.com wrote: Dear, Not sure this is the place, but wanted help to generate some reports relating to RT in a MySQL database. I wonder if they already have a tool ready for customization of reports, or if I have to do this via sql queries. Thank you in advance, Felipe BR -- A dúvida é o principio da sabedoria -- Best regards, Ruslan. -- A dúvida é o principio da sabedoria -- Best regards, Ruslan. -- A dúvida é o principio da sabedoria -- Best regards, Ruslan. -- A dúvida é o principio da sabedoria