Re: [rt-users] default screen configuration on 3.6.6

[Phil]

You guys ROCK

That did it... man thank you very much



On Tue, Mar 25, 2008 at 3:22 PM, Jeff Voskamp <[EMAIL PROTECTED]> 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
>
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Jeff Voskamp]

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
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Drew Barnes]

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:
> 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 
> <[EMAIL PROTECTED] > 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
> <[EMAIL PROTECTED] 
> > >>
> 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
> >
> >
> >
> 
> >
> > ___
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: [EMAIL PROTECTED]
> 
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
>
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Phil]

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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]
> > > 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
> >
> >
> > 
> >
> > ___
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: [EMAIL PROTECTED]
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Kenneth Crocker]

Phil,


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

Kenn
LBNL

On 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
>>
>> ___
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: [EMAIL PROTECTED]
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
>>
> 
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Drew Barnes]

"/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 <[EMAIL PROTECTED] 
> > 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
>
>
> 
>
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Kenneth Crocker]

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
LBNL

On 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 <[EMAIL PROTECTED] 
> > 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
> 
> 
> 
> 
> 
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Phil]

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 <[EMAIL PROTECTED]> 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
>
>
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Kenneth Crocker]

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
> 
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Kenneth Crocker]

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
LBNL

On 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
> 
> 
> 
> 
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Phil]

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 <[EMAIL PROTECTED]> 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
>
>
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] default screen configuration on 3.6.6

[Jeff Voskamp]

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

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

[rt-users] default screen configuration on 3.6.6

[Phil]

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
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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