Question concerning upgrade from 3.6.3 to 3.8

Hello,

we upgraded to 3.8. today. Worked well, and I have to say: Great work on
3.8., really!

A few things seem to be missing from our installation, however. While I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks. Also, I can’t find the graphical relationship
chart. And should there be anything about pgp in the preferences?

Basically, what I did is I checked all dependencies, make-installed a fresh
installation to /opt/rt3 (3.6.3 had been running in /home/rt3) and ran
rt-setup-database --dba xxxxx --prompt-for-dba-password --action upgrade.

Any thoughts where I might have gone wrong? Again: Everything else works
like a charm, and (again): It looks great and we look forward to working
with it.

Thanks for any input!
Bert
BerlinOnline (https://www.berlinonline.de/rt3/)
View this message in context: http://www.nabble.com/Question-concerning-upgrade-from-3.6.3-to-3.8-tp18470464p18470464.html

Hello,

we upgraded to 3.8. today. Worked well, and I have to say: Great
work on
3.8., really!

A few things seem to be missing from our installation, however.
While I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

It should be another portlet like “My Bookmarks” or “Bookmarked
Tickets” in the user’s “RT At a glance” preferences"

Also, I can’t find the graphical relationship
chart.

On any ticket’s display page, there should be a “Graph” link in the
upper-right corner of the links box. If it’s not there, you may not
have graphviz installed.

And should there be anything about pgp in the preferences?

Only if RT could find gpg when starting up.

It should be another portlet like “My Bookmarks” or “Bookmarked
Tickets” in the user’s “RT At a glance” preferences"

There is not, that’s why I wrote. Is there a way to insert it manually?
View this message in context: http://www.nabble.com/Question-concerning-upgrade-from-3.6.3-to-3.8-tp18470464p18471000.html

It should be another portlet like “My Bookmarks” or “Bookmarked
Tickets” in the user’s “RT At a glance” preferences"

There is not, that’s why I wrote. Is there a way to insert it
manually?

Have you overridden HomepageComponents?

It should be another portlet like “My Bookmarks” or “Bookmarked
Tickets” in the user’s “RT At a glance” preferences"

There is not, that’s why I wrote. Is there a way to insert it
manually?

Have you overridden HomepageComponents?

No, I didn’t touch it:
Set($HomepageComponents, [qw(QuickCreate Quicksearch MyAdminQueues
MySupportQueues MyReminders RefreshHomepage Dashboards)]);
Was that a mistake?
View this message in context: http://www.nabble.com/Question-concerning-upgrade-from-3.6.3-to-3.8-tp18470464p18471229.html

It should be another portlet like “My Bookmarks” or “Bookmarked
Tickets” in the user’s “RT At a glance” preferences"

There is not, that’s why I wrote. Is there a way to insert it
manually?

Have you overridden HomepageComponents?

No, I didn’t touch it:
Set($HomepageComponents, [qw(QuickCreate Quicksearch MyAdminQueues
MySupportQueues MyReminders RefreshHomepage Dashboards)]);
Was that a mistake?

Nope. Looks ok. Have you run the database upgrades that come as part
of 3.8?

It should be another portlet like “My Bookmarks” or “Bookmarked
Tickets” in the user’s “RT At a glance” preferences"

There is not, that’s why I wrote. Is there a way to insert it
manually?

Have you overridden HomepageComponents?

No, I didn’t touch it:
Set($HomepageComponents, [qw(QuickCreate Quicksearch MyAdminQueues
MySupportQueues MyReminders RefreshHomepage Dashboards)]);
Was that a mistake?

Nope. Looks ok. Have you run the database upgrades that come as part
of 3.8?

Well, hm. I ran rt-setup-database and told it to upgrade from 3.6.3. I’m
pretty sure it changed the database, and it didn’t complain. But maybe I’m
missing something?
View this message in context: http://www.nabble.com/Question-concerning-upgrade-from-3.6.3-to-3.8-tp18470464p18471398.html

Hello,

we upgraded to 3.8. today. Worked well, and I have to say: Great
work on
3.8., really!

A few things seem to be missing from our installation, however.
While I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

It should be another portlet like “My Bookmarks” or “Bookmarked
Tickets” in the user’s “RT At a glance” preferences"

–action upgrade you’ve run have to add this portlet to default system
settings. So all people who are using defaults must see it on RT at
Glance

Also, I can’t find the graphical relationship
chart.

On any ticket’s display page, there should be a “Graph” link in the
upper-right corner of the links box. If it’s not there, you may not
have graphviz installed.
use one of ./configure options to make sure all dependencies are
there, this as well applies to gpg support.

And should there be anything about pgp in the preferences?

Only if RT could find gpg when starting up.
GPG integration is pretty well documented in perldoc lib/RT/Crypt/GnuPG.pm which is referenced from RT_Config.pm

As well as jesse said it can be disabled during server start, try to
log everything.

Basically, what I did is I checked all dependencies, make-installed
a fresh
installation to /opt/rt3 (3.6.3 had been running in /home/rt3) and ran
rt-setup-database --dba xxxxx --prompt-for-dba-password --action
upgrade.

Any thoughts where I might have gone wrong? Again: Everything else
works
like a charm, and (again): It looks great and we look forward to
working
with it.

Thanks for any input!
Bert

BerlinOnline (https://www.berlinonline.de/rt3/)

View this message in context: http://www.nabble.com/Question-concerning-upgrade-from-3.6.3-to-3.8-tp18470464p18470464.html
Sent from the Request Tracker - Dev mailing list archive at
Nabble.com.


List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel


List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Best regards, Ruslan.

bertbat said:

A few things seem to be missing from our installation, however. While
I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

I’m having similar issues. Just upgraded from 3.6.7. I have run the
database upgrade script and verified that HomepageComponents is set to
defaults. Still no bookmark options are available when setting up my
"RT at a glance". Any tips? Could you recommend a database table or
index that I should check for to make sure bookmark support was properly
added to the DB?

Jay

Jay Lee
Network/Systems Administrator
Information Technology Department
Philadelphia Biblical University

jlee.vcf (259 Bytes)

Jay Lee wrote:

bertbat said:

A few things seem to be missing from our installation, however. While
I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

I’m having similar issues. Just upgraded from 3.6.7. I have run the
database upgrade script and verified that HomepageComponents is set to
defaults. Still no bookmark options are available when setting up my
"RT at a glance". Any tips? Could you recommend a database table or
index that I should check for to make sure bookmark support was properly
added to the DB?

From what I understand the relevant part of the upgrade for the bookmarks is
stored in etc/upgrade/3.7.82.

I ran

rt-setup-database --dba server --prompt-for-dba-password --action insert
–datafile content

(don’t know if that’s possible)

and got

“ERROR: RT requires that MySQL InnoDB table support be enabled.
Remove the ‘skip-innodb’ line from your my.cnf file, restart MySQL, and try
again.”

However, since anything else worked fine, I wonder if that really is the
problem. I’m pretty sure the upgrade-script changed the database correctly,
I see all kinds of new fields within the tables.
View this message in context: http://www.nabble.com/Question-concerning-upgrade-from-3.6.3-to-3.8-tp18490078p18490447.html

bertbat said:

A few things seem to be missing from our installation, however. While
I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

I’m having similar issues. Just upgraded from 3.6.7. I have run the
database upgrade script and verified that HomepageComponents is set to
defaults. Still no bookmark options are available when setting up my
"RT at a glance". Any tips? Could you recommend a database table or
index that I should check for to make sure bookmark support was properly
added to the DB?

Jay

Jay Lee
Network/Systems Administrator
Information Technology Department
Philadelphia Biblical University

jlee.vcf (259 Bytes)

bertbat said:

A few things seem to be missing from our installation, however.
While I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

I’m having similar issues. Just upgraded from 3.6.7. I have run
the database upgrade script and verified that HomepageComponents is
set to defaults. Still no bookmark options are available when
setting up my “RT at a glance”. Any tips? Could you recommend a
database table or index that I should check for to make sure
bookmark support was properly added to the DB?

Can you send me the output of the SQL command:

select Name, Description from Attributes where ObjectType =
‘RT::System’;

I’m having similar issues. Just upgraded from 3.6.7. I have run the
database upgrade script and verified that HomepageComponents is set to
defaults. Still no bookmark options are available when setting up my
"RT at a glance". Any tips? Could you recommend a database table or
index that I should check for to make sure bookmark support was properly
added to the DB?

It was my fault. I didn’t follow the instructions in UPGRADE.mysql
which was preventing:

/opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/3.7.82

from running correctly and creating the necessary search. All set now.

My users are thrilled with 3.8 (and I haven’t even shown them bookmarks
yet, that’ll be tomorrow). Thanks for all your hard work!

Jay
Jay Lee
Network / Systems Administrator
Information Technology Dept.
Philadelphia Biblical University

bertbat wrote:

A few things seem to be missing from our installation, however. While I
see the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks. Also, I can’t find the graphical relationship
chart. And should there be anything about pgp in the preferences?

The whole thing was my mistake. First of all, our RT didn’t run on InnoDB,
which I didn’t know since I didn’t set it up originally. I fixed that by
enabling InnoDB and converting the tables. Then I updated DBD::mysql which
was an old version. After that, everything pretty much went as described.
View this message in context: http://www.nabble.com/Question-concerning-upgrade-from-3.6.3-to-3.8-tp18470464p18509509.html

Jesse -

I’m having the same problem, after upgrading from 3.6.6 to 3.8.0. I’m
now running 3.8.1rc1. See below for the requested query.

A few things seem to be missing from our installation, however. While I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

[snip]

Can you send me the output of the SQL command:
select Name, Description from Attributes where ObjectType = ‘RT::System’;

mysql> select Name, Description from Attributes where ObjectType = ‘RT::System’;
| Name | Description |
| Search - My Tickets | [_1] highest priority tickets I own |
| Search - Unowned Tickets | [_1] newest unowned tickets |
| HomepageSettings | HomepageSettings |

Thanks,

Greg

Jesse -

I’m having the same problem, after upgrading from 3.6.6 to 3.8.0. I’m
now running 3.8.1rc1. See below for the requested query.

That pretty clearly shows that the database side of upgrades didn’t
happen.> 2008/7/16 Jesse Vincent jesse@bestpractical.com

A few things seem to be missing from our installation, however.
While I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

[snip]

Can you send me the output of the SQL command:
select Name, Description from Attributes where ObjectType =
‘RT::System’;

mysql> select Name, Description from Attributes where ObjectType =
‘RT::System’;
±-------------------------±------------------------------------+
| Name | Description |
±-------------------------±------------------------------------+
| Search - My Tickets | [_1] highest priority tickets I own |
| Search - Unowned Tickets | [_1] newest unowned tickets |
| HomepageSettings | HomepageSettings |
±-------------------------±------------------------------------+

Thanks,

Greg

Then somehow you’ve missed etc/upgrade/3.7.82/contentOn Wed, Aug 6, 2008 at 12:30 AM, Greg Petras gpetme@gmail.com wrote:

Jesse -

I’m having the same problem, after upgrading from 3.6.6 to 3.8.0. I’m
now running 3.8.1rc1. See below for the requested query.

2008/7/16 Jesse Vincent jesse@bestpractical.com

A few things seem to be missing from our installation, however. While I see
the new “Dashboards”-search in “Rt at a glance”, there is no search
selectable for Bookmarks.

[snip]

Can you send me the output of the SQL command:
select Name, Description from Attributes where ObjectType = ‘RT::System’;

mysql> select Name, Description from Attributes where ObjectType = ‘RT::System’;
±-------------------------±------------------------------------+
| Name | Description |
±-------------------------±------------------------------------+
| Search - My Tickets | [_1] highest priority tickets I own |
| Search - Unowned Tickets | [_1] newest unowned tickets |
| HomepageSettings | HomepageSettings |
±-------------------------±------------------------------------+

Thanks,

Greg


List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Best regards, Ruslan.

Then somehow you’ve missed etc/upgrade/3.7.82/content

Strange. I ran rt-setup-database as instructed. Regardless, I ran the
content for each version needed, and the bookmarks section shows up
now.

Thanks guys!

Greg

Date: Tue, 5 Aug 2008 14:06:41 -0700
From: “Greg Petras” gpetme@gmail.com
Subject: Re: [Rt-devel] Question concerning upgrade from 3.6.3 to 3.8
To: “Ruslan Zakirov” ruz@bestpractical.com
Cc: Jay Lee jlee@pbu.edu, rt-devel@lists.bestpractical.com
Message-ID:
ffa2dce10808051406p369b4e34h661fd81e43e68e99@mail.gmail.com
Content-Type: text/plain; charset=ISO-8859-1

Then somehow you’ve missed etc/upgrade/3.7.82/content

Strange. I ran rt-setup-database as instructed. Regardless, I ran the
content for each version needed, and the bookmarks section shows up
now.

Thanks guys!

Greg
I have had the same issue, basically the rt-setup-database upgrade
scripts complain that’s it’s not the new schema, you have to do the
alter table schema updates before you can run it, unfortunately the
documentation isn’t very specific in that regard, the instruction is
confusing with the documents cross referencing.

Curtis

Date: Tue, 5 Aug 2008 14:06:41 -0700
From: “Greg Petras” gpetme@gmail.com
Subject: Re: [Rt-devel] Question concerning upgrade from 3.6.3 to 3.8
To: “Ruslan Zakirov” ruz@bestpractical.com
Cc: Jay Lee jlee@pbu.edu, rt-devel@lists.bestpractical.com
Message-ID:
ffa2dce10808051406p369b4e34h661fd81e43e68e99@mail.gmail.com
Content-Type: text/plain; charset=ISO-8859-1

Then somehow you’ve missed etc/upgrade/3.7.82/content

Strange. I ran rt-setup-database as instructed. Regardless, I ran the
content for each version needed, and the bookmarks section shows up
now.

Thanks guys!

Greg
I have had the same issue, basically the rt-setup-database upgrade
scripts complain that’s it’s not the new schema, you have to do the
alter table schema updates before you can run it, unfortunately the
documentation isn’t very specific in that regard, the instruction is
confusing with the documents cross referencing.
What exactly is confusing? Please provide us more info, we really
would like to improve documentation to make it easier.

Curtis


List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Best regards, Ruslan.