Default screen configuration on 3.6.6

When I open up RT 3.6.6 for the first time the initial screen is blank… Is
this normal? I mean there are no tickets listed,I have to search for all the
tickets first?

Can I configure it to show the latest received tickets?

Is there a way to configure it so that it lists the latest un assigned
tickets…? Similar to the older versions of RT?

Phil

Phil wrote:

When I open up RT 3.6.6 for the first time the initial screen is
blank… Is this normal? I mean there are no tickets listed,I have to
search for all the tickets first?

Can I configure it to show the latest received tickets?

Is there a way to configure it so that it lists the latest un assigned
tickets…? Similar to the older versions of RT?

Phil
Did you remember to do all the database updates as well for 3.6.6? The
updates for 3.5.1 adds default Homepage settings for everyone.

Jeff Voskamp

I tried to run them but they did not work… there was no script in the
location it specified…

I ran make update
at the bottom it said to run 3 scripts… there were directories as listed.

I will try again…On Tue, Mar 25, 2008 at 2:55 PM, Jeff Voskamp javoskam@uwaterloo.ca wrote:

Phil wrote:

When I open up RT 3.6.6 for the first time the initial screen is
blank… Is this normal? I mean there are no tickets listed,I have to
search for all the tickets first?

Can I configure it to show the latest received tickets?

Is there a way to configure it so that it lists the latest un assigned
tickets…? Similar to the older versions of RT?

Phil
Did you remember to do all the database updates as well for 3.6.6? The
updates for 3.5.1 adds default Homepage settings for everyone.

Jeff Voskamp

Phil,

If you have not used your home page before, you have to set it up. 

Click “edit” on the right. Select what youwant to display on your home
page and then click “home”.

Kenn
LBNLOn 3/25/2008 11:37 AM, Phil wrote:

When I open up RT 3.6.6 for the first time the initial screen is
blank… Is this normal? I mean there are no tickets listed,I have to
search for all the tickets first?

Can I configure it to show the latest received tickets?

Is there a way to configure it so that it lists the latest un assigned
tickets…? Similar to the older versions of RT?

Phil



The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Phil,

Actually, the 3.6.1 DB upgrade only inserts a couple queries as 

options; the Unowned query and the My own tickets query. There are no DB
Schema changes, per se. Hope this helps.

Kenn
LBNLOn 3/25/2008 11:55 AM, Jeff Voskamp wrote:

Phil wrote:

When I open up RT 3.6.6 for the first time the initial screen is
blank… Is this normal? I mean there are no tickets listed,I have to
search for all the tickets first?

Can I configure it to show the latest received tickets?

Is there a way to configure it so that it lists the latest un assigned
tickets…? Similar to the older versions of RT?

Phil
Did you remember to do all the database updates as well for 3.6.6? The
updates for 3.5.1 adds default Homepage settings for everyone.

Jeff Voskamp


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

I tried to run the scripts and I get th following error:

Creating database schema.
Couldn’t find schema file for mysql

This is what I ran:
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action schema --datadir etc/upgrade/3.5.1/content install-sh

Where can I find the schema file?On Tue, Mar 25, 2008 at 2:55 PM, Jeff Voskamp javoskam@uwaterloo.ca wrote:

Phil wrote:

When I open up RT 3.6.6 for the first time the initial screen is
blank… Is this normal? I mean there are no tickets listed,I have to
search for all the tickets first?

Can I configure it to show the latest received tickets?

Is there a way to configure it so that it lists the latest un assigned
tickets…? Similar to the older versions of RT?

Phil
Did you remember to do all the database updates as well for 3.6.6? The
updates for 3.5.1 adds default Homepage settings for everyone.

Jeff Voskamp

Phil,

If you are going to run the DB updates, you will most likely have to 

get the Admin password to do it. DataBases tend to be strctly protected
from jobs that change the database without the correct password. The
“latest received tickets” is one of the queries that comes with the
3.5.1 updates.

Kenn
LBNLOn 3/25/2008 11:58 AM, Phil wrote:

I tried to run them but they did not work… there was no script in the
location it specified…

I ran make update
at the bottom it said to run 3 scripts… there were directories as listed.

I will try again…

On Tue, Mar 25, 2008 at 2:55 PM, Jeff Voskamp <javoskam@uwaterloo.ca mailto:javoskam@uwaterloo.ca> wrote:

Phil wrote:
 > When I open up RT 3.6.6 for the first time the initial screen is
 > blank... Is this normal? I mean there are no tickets listed,I have to
 > search for all the tickets first?
 >
 > Can I configure it to show the latest received tickets?
 >
 > Is there a way to configure it so that it lists the latest un
assigned
 > tickets...? Similar to the older versions of RT?
 >
 > Phil
Did you remember to do all the database updates as well for 3.6.6? The
updates for 3.5.1 adds default Homepage settings for everyone.

Jeff Voskamp


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

“/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action schema --datadir etc/upgrade/3.5.1/content install-sh”

You have an extra install-sh on that line. Also the --action should be
insert.

Phil wrote:

Phil,

OPPS! I meant 3.5.1, not 3.6.1. That's a typo.

Kenn
LBNLOn 3/25/2008 12:05 PM, Kenneth Crocker wrote:

Phil,

Actually, the 3.6.1 DB upgrade only inserts a couple queries as
options; the Unowned query and the My own tickets query. There are no DB
Schema changes, per se. Hope this helps.

Kenn
LBNL

On 3/25/2008 11:55 AM, Jeff Voskamp wrote:

Phil wrote:

When I open up RT 3.6.6 for the first time the initial screen is
blank… Is this normal? I mean there are no tickets listed,I have to
search for all the tickets first?

Can I configure it to show the latest received tickets?

Is there a way to configure it so that it lists the latest un assigned
tickets…? Similar to the older versions of RT?

Phil
Did you remember to do all the database updates as well for 3.6.6? The
updates for 3.5.1 adds default Homepage settings for everyone.

Jeff Voskamp


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Well I tried with install instead and it said it was an invalid action
command…

What should be the entire command I should run?On Tue, Mar 25, 2008 at 3:09 PM, Drew Barnes barnesaw@ucrwcu.rwc.uc.edu wrote:

“/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action schema --datadir etc/upgrade/3.5.1/content install-sh”

You have an extra install-sh on that line. Also the --action should be
insert.

Phil wrote:

I tried to run the scripts and I get th following error:

Creating database schema.
Couldn’t find schema file for mysql

This is what I ran:
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action schema --datadir etc/upgrade/3.5.1/content install-sh

Where can I find the schema file?

On Tue, Mar 25, 2008 at 2:55 PM, Jeff Voskamp <javoskam@uwaterloo.ca mailto:javoskam@uwaterloo.ca> wrote:

Phil wrote:
> When I open up RT 3.6.6 for the first time the initial screen is
> blank... Is this normal? I mean there are no tickets listed,I
have to
> search for all the tickets first?
>
> Can I configure it to show the latest received tickets?
>
> Is there a way to configure it so that it lists the latest un
assigned
> tickets...? Similar to the older versions of RT?
>
> Phil
Did you remember to do all the database updates as well for 3.6.6?

The

updates for 3.5.1 adds default Homepage settings for everyone.

Jeff Voskamp


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

You don’t need the install-sh anywhere.

/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action insert --datadir etc/upgrade/3.5.1/content

Phil wrote:

Kenneth Crocker wrote:

Phil,

Actually, the 3.6.1 DB upgrade only inserts a couple queries as 

options; the Unowned query and the My own tickets query. There are no
DB Schema changes, per se. Hope this helps.

Kenn
LBNL
Installs two Searches and “HomepageSettings”:
{ Name => ‘HomepageSettings’,
Description => ‘HomepageSettings’,
Content =>
{ ‘body’ =>
[ { type => ‘system’, name => ‘My Tickets’ },
{ type => ‘system’, name => ‘Unowned Tickets’ },
{ type => ‘component’, name => ‘QuickCreate’},
],
‘summary’ =>
[
{ type => ‘component’, name => ‘MyReminders’ },
{ type => ‘component’, name => ‘Quicksearch’ },
{ type => ‘component’, name => ‘RefreshHomepage’ },
]
},

Without that you don’t have a default screen layout for the main page.
The important command to run is:

rt-setup-database --dba root --dba-password IamRoot --action insert
–datadir etc/upgrade/$VERSION

Jeff

You guys ROCK!!!

That did it… man thank you very much!!!On Tue, Mar 25, 2008 at 3:22 PM, Jeff Voskamp javoskam@uwaterloo.ca wrote:

Kenneth Crocker wrote:

Phil,

Actually, the 3.6.1 DB upgrade only inserts a couple queries as

options; the Unowned query and the My own tickets query. There are no
DB Schema changes, per se. Hope this helps.

Kenn
LBNL
Installs two Searches and “HomepageSettings”:
{ Name => ‘HomepageSettings’,
Description => ‘HomepageSettings’,
Content =>
{ ‘body’ =>
[ { type => ‘system’, name => ‘My Tickets’ },
{ type => ‘system’, name => ‘Unowned Tickets’ },
{ type => ‘component’, name => ‘QuickCreate’},
],
‘summary’ =>
[
{ type => ‘component’, name => ‘MyReminders’ },
{ type => ‘component’, name => ‘Quicksearch’ },
{ type => ‘component’, name => ‘RefreshHomepage’ },
]
},

Without that you don’t have a default screen layout for the main page.
The important command to run is:

rt-setup-database --dba root --dba-password IamRoot --action insert
–datadir etc/upgrade/$VERSION

Jeff