RE: [rt-users] how to add members to user defined group in RT

[Baytalskiy, Sal]

You're right.

Search is only at Confifguration -> Users.

Well, the way I have it set up is like this:

All non-priveleged users are already part of that Non-priveleged group.
So I gave them a ShowTicket and a SeeQueue rights for all queues so that
they can see any ticket they submitted in any queue in their basic RT
interface.
I guess you wanted a more granular control of non-priveleged users... 


Thanks !
Sal Baytalskiy
DBG CTO Middleware
201-469-8459
[EMAIL PROTECTED]
MW-OnCall: 973-255-0789

-Original Message-
From: Akila Amarathunga [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 15, 2007 8:17 AM
To: Baytalskiy, Sal
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] how to add members to user defined group in RT

Hi Sal,

I went to configuration-> Groups-> 'sys1_grp'-> Members

but there's no search section for users :( ..

Thanks,
Akila

On Wed, 2007-08-15 at 07:09 -0500, Baytalskiy, Sal wrote:
> What you should do is do a search for each non-priveleged user id 
> while at the screen for adding users to a group.
> There's a search section right below the user id listing.
> 
> That is the only way to display non-priveleged users in RT.
> 
> 
> Thanks !
> Sal Baytalskiy
> DBG CTO Middleware
> 201-469-8459
> [EMAIL PROTECTED]
> MW-OnCall: 973-255-0789
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Akila 
> Amarathunga
> Sent: Wednesday, August 15, 2007 7:55 AM
> To: Mathew Snyder
> Cc: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] how to add members to user defined group in RT
> 
> ___
> 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
--
Akila Amarathunga
Linux Systems Engineer; WSO2, Inc.; http://www.wso2.com/
email: [EMAIL PROTECTED]; cell: +94 71 682 9488; fax: 0112424303

"Oxygenating the Web Service Platform."
___
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] how to add members to user defined group in RT

[Baytalskiy, Sal]

What you should do is do a search for each non-priveleged user id while at
the screen for adding users to a group.
There's a search section right below the user id listing.

That is the only way to display non-priveleged users in RT.


Thanks !
Sal Baytalskiy
DBG CTO Middleware
201-469-8459
[EMAIL PROTECTED]
MW-OnCall: 973-255-0789

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Akila
Amarathunga
Sent: Wednesday, August 15, 2007 7:55 AM
To: Mathew Snyder
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] how to add members to user defined group in RT

___
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] ImageAutoResize in RT 3.6.3

[Baytalskiy, Sal]

Thanks Justin!
Worked out great!
 
Sal.


  _  

From: Justin Hayes [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 14, 2007 12:37 PM
To: Baytalskiy, Sal
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] ImageAutoResize in RT 3.6.3


This is what I did on 3.6.3: 

copy share/html/Ticket/Elements/ShowTransactionAttachments to
local/html/Ticket/Elements/

then at around link 156 there is the code that display an image:

# if it's an image, show it as an image
elsif ( $RT::ShowTransactionImages and  $message->ContentType =~
/^image\//i ) {
$m->out('' );
}

well I just added a 'width=90%' declaration and it seems to work fine for me

# if it's an image, show it as an image
elsif ( $RT::ShowTransactionImages and  $message->ContentType =~
/^image\//i ) {
$m->out('' );
}

HTH

Justin


--
Justin Hayes
Support Manager
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 



On 7 May 2007, at 08:34, Baytalskiy, Sal wrote:


Hello!

I found an article on automatic image resizing for RT 3.2 on the Wiki.

However it talks about some files that seem to be very different in RT 3.6.3
that i'm running.

Is there a way to automatically scale attached images to the ticket's
display width?

Thanks !

Sal Baytalskiy


*** NDS UK IT scanned this email for malicious content ***

*** IMPORTANT: Do not open attachments from unrecognized senders  ***


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

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



Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
<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] RT 4

[Baytalskiy, Sal]

It almost sounds like RT needs a CRM addon, similar to RTFM or AT...
I think AT can serve as a starting point for this, from what I've seen it
do...Only define Customers instead of Assets. 


Thanks !
Sal Baytalskiy
DBG CTO Middleware
201-469-8459
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lanyon
Sent: Thursday, May 24, 2007 10:02 PM
To: Mathew Snyder
Cc: RT Users
Subject: Re: [rt-users] RT 4


On 25/05/2007, at 11:10 AM, Mathew Snyder wrote:

>> - Customer database and the ability to track tickets per customer
>
> But this is what RT does anyway

RT is currently *not* a customer database, it is a ticketing system.

We are getting pressured to move to systems like NetSuite or SugarCRM
because they have built in ticketing systems providing similar functionality
to RT and also manage all of the customer information and relations.

___
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

[rt-users] Oracle isssues fixed (somewhat)

[Baytalskiy, Sal]

Hey everyone!
So its looks like i'm up and running with Oracle 10g as a backend. Took a
lot of reading and hacking and hardcoding - but i got it done.
Better yet - both Orcale and MySQL RT instances are woking fine on the same
machine. For that i had to modify the DBI Handle.pm to include some checking
there. Otherwise its eaither or. Not an ideal way to do it - but it works
for now and that's what i need to show it to the bosses.
I was also able to install RTFM and AT with the same type of hacking.
 
My questions is now on the speed: when i create a ticket via RT and LOCAL
MySQL - i get Time to display: 2.851136  at the bottom right.
 
Doing the same exact thing with the (REMOTE) Oracle version gives me : Time
to display: 3.598018
 
Are these latencies normal? Or do i need to tune something?
 
Any ideas/suggestions will be greatly appreciated...
 
 
Sal.
___
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: OT: Open Minds in IT IN CA: was (Re: [rt-users] RT 4)

[Baytalskiy, Sal]

I hear that.
We have another piece of software that we're supposed to be using for ticket
tracking.
Nobody really uses it except for Production stuff (we simply have to)
because it is difficult to use, slow, poorly configured, list goes on.
Sure, they paid 6 figures for it - so naturally its the next best thing. The
only problem is - they can't make anyone use it :-)
Just goes to show...
And then i set up RT in about half a day and run a POC internally in our
group.
The only management person who's seen it is our manager because we just
can't let anyone know we're using something that hasn't been approved.
And we all know it won't ever be approved, no matter how good it is.
So the strategy is simple: we'll be using it until we collect enough data
that we can demonstrate that RT is essential to the grou's operation.
Think about this: how much wiggling and maneuvering needs to be done to
simply improve productivity of one of the most important IT departments.
How much time is wasted on this stupid strategizing when it could've been
spent doing actual work...
Oh, here's the kicker - the only reason my manager was able to let us use RT
is because of RTFM. 'Cause we needed one place to store the group's
collective wisdom.
And RT's ticket tracking functionality is basically presented as a
by-product...weird...


  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Redman
Sent: Saturday, May 19, 2007 12:07 AM
To: rt-users@lists.bestpractical.com
Subject: Re: OT: Open Minds in IT IN CA: was (Re: [rt-users] RT 4)




 Original Message  
Subject:Re: OT: Open Minds in IT IN CA: was (Re: [rt-users] RT 4)

Date:   Fri, 18 May 2007 21:06:12 -0700 
From:   Andrew Redman  <mailto:[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> 
To: Robert G. Werner  <mailto:[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> 
References:
<mailto:[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED]> <[EMAIL PROTECTED]>  


Just as a comment, the Boss loved it when I got RT working, and his Boss 

loved it when we started to get stats on performance improvements from 

it, so that was all groovy. That said, there is one person in our 

department (the oldest and arguably least competent, though there is 

quite a lively competition for that title...) has the idea that "If I 

pay more for it, it must be better" firmly embedded in his head. We were 

looking at 3 backup systems, one cost $5k and did everything we wanted 

and more, the other was $30k, and fell short of a few of our 

requirements, and he insisted that the $30k one was the way to go. I 

suppose if you had a couple people like that in key positions in a 

company then OSS could have some difficulty...



Anyway, I'm just glad he's not my boss. Keep up the RT awesomeness. - Andrew



Robert G. Werner wrote:

> Baytalskiy, Sal wrote:

>> I wish you were right...

> [snip]

> It certainly hasn't been my experience.  My bosses really like it when 

> I make something happen and it doesn't cost them much of anything but 

> my time.

>

> Certainly,  my bosses aren't open source zealots.  We are an Oracle 

> shop.  But ever place I've worked,  when I bring in important 

> improvements in network reliability and monitoring or now trouble 

> ticket tracking with RT the response has been ecstatic and the fact 

> that it doesn't cost anything has been huge.

>

> The added luxury of being able to modify and look at the code has been 

> icing on the cake.

>

> My experiences have mostly been in relatively small shops (50 - 300 

> people) over the last 10 years in California so take what I say with 

> an enormous grain of salt.

>

> But really,  to me,  it sounds like there are better jobs out there 

> for you.

>



___
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: Open Minds in IT IN CA: was (Re: [rt-users] RT 4)

[Baytalskiy, Sal]

I envy you. I really do.
In the past 13 years I've been working in IT (development and then
midlleware/operations) for fairly large corporations.
And I have to say that every single GOOD piece of software that I tried to
bring in - had to be fought for. To the point when its almost not worth it
to even try. Its extremely frustrating and just irritates me to no end. The
narrow-mindness and inability to see good things of the upper management is
astounding. The amounts of money being literally WASTED on crappy software
simply because some clown up on top (who's never going to use it) decided
so...This is only possible in large companies because a smaller shop just
wouldn't be able to survive like that.
I guess West Coast has always been more open to new things, maybe because of
Palo Alto and all the good things that came out of there, plus I think the
people are just generally more open-minded.
Out here, in NY, its just not like that...unfortunately...


-Original Message-
From: Robert G. Werner [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 18, 2007 11:57 PM
To: Baytalskiy, Sal
Cc: Matthew Keller; RT Users
Subject: OT: Open Minds in IT IN CA: was (Re: [rt-users] RT 4)

Baytalskiy, Sal wrote:
> I wish you were right... 
> 
[snip]
It certainly hasn't been my experience.  My bosses really like it when I
make something happen and it doesn't cost them much of anything but my time.

Certainly,  my bosses aren't open source zealots.  We are an Oracle shop.
But ever place I've worked,  when I bring in important improvements in
network reliability and monitoring or now trouble ticket tracking with RT
the response has been ecstatic and the fact that it doesn't cost anything
has been huge.

The added luxury of being able to modify and look at the code has been icing
on the cake.

My experiences have mostly been in relatively small shops (50 - 300
people) over the last 10 years in California so take what I say with an
enormous grain of salt.

But really,  to me,  it sounds like there are better jobs out there for you.

--
Robert G. Werner (Network Systems Administrator) [EMAIL PROTECTED]

559.244.3734

On the Internet, nobody knows you're a dog.
-- Cartoon caption
___
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] RT 4

[Baytalskiy, Sal]

I wish you were right... 

-Original Message-
From: Matthew Keller [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 18, 2007 8:36 PM
To: Baytalskiy, Sal
Cc: Mathew Snyder; Jesse Vincent; RT Users
Subject: RE: [rt-users] RT 4

Please don't translate YOUR company/woes to "many big corporation".
That's completely ridiculous.

On Fri, 2007-05-18 at 02:25 -0400, Baytalskiy, Sal wrote:
> Using Nagios as an example.
> Its written also in Perl, but there's a Java port which basically 
> eliminates the installation completely.
> Download a bunch JARs and fire up Java.
> If there was a port of RT in Java - this would do wonders for the 
> adoption rate.
> Many big corporation don't allow open source stuff and Perl-based 
> software in particular...
>  
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mathew 
> Snyder
> Sent: Friday, May 18, 2007 2:20 AM
> To: Jesse Vincent
> Cc: RT Users
> Subject: Re: [rt-users] RT 4
> 
> The ability to customize the colors easily from the Configuration menu.
> 
> Mathew
> Keep up with me and what I'm up to: http://theillien.blogspot.com
> 
> 
> Jesse Vincent wrote:
> > If, for the sake of argument, Best Practical were to rewrite RT, 
> > what would you want to see in the new product?
> > 
> > Think big.
> > 
> > Jesse
> > 
> > 
> > 
> > --
> > --
> > 
> > ___
> > 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
___
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] Desperately ned Oracle help

[Baytalskiy, Sal]

Yep, I had to edit the Makefile as well. Not only did I change all /lib to
/lib32, but I also had to remove the -xarch=v9 from everywhere.
That fixed the make process for DBD::Oracle.

Now, the good news: I finally figured it out and made the 'make
initialize-database' work. It even inserted the schema all by itself.
Here's what I had to do:

In the file /usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm

I replaced
my $handle = DBI->connect($self->DSN, $args{'User'}, $args{'Password'}) ||
croak "Connect Failed $DBI::errstr\n" ;
With
my $handle = DBI->connect("DBI:Oracle:CLORAD1", $args{'User'},
$args{'Password'}) || croak "Connect Failed $DBI::errstr\n" ;

Effectively hardcoding the connection info.

That seems to fix the errors I was getting and finally populated the DB.

I then used other suggestions that were made here and added some more
directives to my httpd.conf file and I can finally connect to the RT
instance with Oracle 10g backend.

I have to say that ticket creation takes much longer than with local MySQL
instance. I'm not sure if its my setup or its just that slow.

Now the new challenge is to install RTFM and AssetTracker. They both make
additions to the DB as well. We'll see how that works out...


Thanks everyone!!!

Sal.

-Original Message-----
From: Joop van de Wege [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 18, 2007 6:04 AM
To: Baytalskiy, Sal
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Desperately ned Oracle help

Baytalskiy, Sal wrote:
> Hey guys!
> A little update:
> i've been looking at the rt-setup-database script trying to figure out 
> how to get around the issues i'm having.
> So the very first error mentioned this: at 
> //usr/local/rt3_ora/sbin/rt-setup-database line 103 which is this 
> *$dbh = DBI->connect( get_system_dsn(), $args{'dba'}, 
> $args{'dba-password'} )* So i replaced that with: $dbh = DBI->connect( 
> "DBI:Oracle:", $args{'dba'}, $args{'dba-password'} )
>  
> That seemed to get me a bit farther as i got this output:
> Now creating a database for RT.
> ...skipped as mwpoc is not mwpoc or we're working with Oracle.
> DSN component 'CLORAD1' is not in 'name=value' format at 
> /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627 DBI 
> connect('CLORAD1;port=1521','mwpoc',...) failed: Can't connect using 
> this syntax without specifying a HOST and one of SID INSTANCE_NAME 
> SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database 
> *line 138 *Can't connect using this syntax without specifying a HOST 
> and one of SID INSTANCE_NAME SERVER SERVICE_NAME at 
> //usr/local/rt3_ora/sbin/rt-setup-database line 138,  line 1.
> make: *** [initialize-database] Error 255
I'm using Oracle too and it should not matter whether the database is on
  the localhost or a remote one, so I would go back and do the following:
- drop the schema of RT on the remote server
- add the RT user or grant DBA role to it (temporarily)
- configure RT again with the correct parameters these are mine adjust
accordingly:
   -- export ORACLE_HOME=/your/oracle/home
   -- export ORACLE_SID=YOURSID
   -- (else the following line will barf)
   -- ./configure --with-db-type=Oracle --with-db-dba=rt_user
  --with-db-database=XE

  (if XE is in your tnsnames.ora then everything should work doesn't matter
where that db is)
- make initialize-database

As to the 32/64bit problem that used to be an issue but since I haven't done
a clean install in a while I don't  know if current DBD::Oracle still has
problems. The way I fixed this once, from memory, is that I did edit the
make file to use $ORACLE_HOME/lib32 instead of $ORACLE_HOME/lib which is
since 10g 64bit instead of 32 as is used to be in pre 10g.
But you should get a error from making DBD::Oracle which should be rather
clear on  this issue since it complains about elf64 problems.

Hope this helps, either contact me offlist, I might be able to help.

Joop
___
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] RT 4

[Baytalskiy, Sal]

I'm sorry too...What do you think, I like this situation? I can't stand it.
It took weeks of pleeding with my manager just to get him to look at RT...
Whatever, it just suxx, when a corporation is so narrow-minded...

Sorry, just venting...

-Original Message-
From: Robert Long [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 18, 2007 2:16 PM
To: Baytalskiy, Sal
Cc: RT Users
Subject: Re: [rt-users] RT 4


Ah, I would like to disagree with part of your post regarding who Nagios is
written ;

Nagios is written in C.  It has a built in perl interpreter to run plugins
that are written in perl faster, but even so, all of the official plugins
that come with Nagios are written in in C as well. 
Nagios is not written in Perl:

# find nagios-2.9/ -name *.c | wc -l
50


Using the 'Blue' java port of nagios wouldn't eliminate the use of perl in
any fashion - the only components of Nagios that use perl are contributed
and custom plugins - if you're using those under Nagios or under 'Blue',
they're still going to be perl/lisp/python/ruby/whatever.

Another thing I can't help but think about is; how is changing the language
from anything to perl going to make it not open sourced? 

I'm sorry you work / live in a world where open sourced software and perl
are looked down upon and the policy is to avoid such things.

.r'

Baytalskiy, Sal wrote:
> Using Nagios as an example.
> Its written also in Perl, but there's a Java port which basically 
> eliminates the installation completely.
> Download a bunch JARs and fire up Java.
> If there was a port of RT in Java - this would do wonders for the 
> adoption rate.
> Many big corporation don't allow open source stuff and Perl-based 
> software in particular...
>  
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mathew 
> Snyder
> Sent: Friday, May 18, 2007 2:20 AM
> To: Jesse Vincent
> Cc: RT Users
> Subject: Re: [rt-users] RT 4
>
> The ability to customize the colors easily from the Configuration menu.
>
> Mathew
> Keep up with me and what I'm up to: http://theillien.blogspot.com
>
>
> Jesse Vincent wrote:
>   
>> If, for the sake of argument, Best Practical were to rewrite RT, what 
>> would you want to see in the new product?
>>
>> Think big.
>>
>> Jesse
>>
>>
>> -
>> -
>> --
>>
>> ___
>> 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
>   
___
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] Desperately ned Oracle help

[Baytalskiy, Sal]

I tried replacing 

$RT::Handle->Connect();  (line 390)

with

$RT::Handle = DBI->connect("dbi:Oracle:host=clorad1.aig.com;sid=CLORAD1",
"mwpoc", "mwpoc"); 

Not sure if this is correct but that got me even farther:

Password: 
Now creating a database for RT.
Creating Oracle database CLORAD1.
Done setting up database ACLs.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Now inserting RT core system objects
Checking for existing system user...Can't locate object method "Rollback"
via package "DBI::db" at /usr/local/rt3_ora/lib/RT.pm line 345.
make: *** [initialize-database] Error 255

I can actually see that it created the user id that I specified as $RTUser
in my SiteConfig.pm file.

Please tell me what I'm doing wrong and how can I make this line 390 work.

Thanks in advance,
Sal.

-Original Message-
From: Joop van de Wege [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 18, 2007 6:04 AM
To: Baytalskiy, Sal
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Desperately ned Oracle help

Baytalskiy, Sal wrote:
> Hey guys!
> A little update:
> i've been looking at the rt-setup-database script trying to figure out 
> how to get around the issues i'm having.
> So the very first error mentioned this: at 
> //usr/local/rt3_ora/sbin/rt-setup-database line 103 which is this 
> *$dbh = DBI->connect( get_system_dsn(), $args{'dba'}, 
> $args{'dba-password'} )* So i replaced that with: $dbh = DBI->connect( 
> "DBI:Oracle:", $args{'dba'}, $args{'dba-password'} )
>  
> That seemed to get me a bit farther as i got this output:
> Now creating a database for RT.
> ...skipped as mwpoc is not mwpoc or we're working with Oracle.
> DSN component 'CLORAD1' is not in 'name=value' format at 
> /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627 DBI 
> connect('CLORAD1;port=1521','mwpoc',...) failed: Can't connect using 
> this syntax without specifying a HOST and one of SID INSTANCE_NAME 
> SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database 
> *line 138 *Can't connect using this syntax without specifying a HOST 
> and one of SID INSTANCE_NAME SERVER SERVICE_NAME at 
> //usr/local/rt3_ora/sbin/rt-setup-database line 138,  line 1.
> make: *** [initialize-database] Error 255
I'm using Oracle too and it should not matter whether the database is on
  the localhost or a remote one, so I would go back and do the following:
- drop the schema of RT on the remote server
- add the RT user or grant DBA role to it (temporarily)
- configure RT again with the correct parameters these are mine adjust
accordingly:
   -- export ORACLE_HOME=/your/oracle/home
   -- export ORACLE_SID=YOURSID
   -- (else the following line will barf)
   -- ./configure --with-db-type=Oracle --with-db-dba=rt_user
  --with-db-database=XE

  (if XE is in your tnsnames.ora then everything should work doesn't matter
where that db is)
- make initialize-database

As to the 32/64bit problem that used to be an issue but since I haven't done
a clean install in a while I don't  know if current DBD::Oracle still has
problems. The way I fixed this once, from memory, is that I did edit the
make file to use $ORACLE_HOME/lib32 instead of $ORACLE_HOME/lib which is
since 10g 64bit instead of 32 as is used to be in pre 10g.
But you should get a error from making DBD::Oracle which should be rather
clear on  this issue since it complains about elf64 problems.

Hope this helps, either contact me offlist, I might be able to help.

Joop
___
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] Desperately ned Oracle help

[Baytalskiy, Sal]

Update:

I tried getting DBA permissions temporarily but the DBAs won't do it for me.
Too risky they say.
So they granted the CREATE USER permission to the existing user id they gave
me.
That got me a bit farther than yesterday.

Here's the output:

Password: 
Now creating a database for RT.
Creating Oracle database CLORAD1.
Done setting up database ACLs.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Now inserting RT core system objects
[Fri May 18 14:55:38 2007] [crit]: Connect Failed Can't connect using this
syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME
 at //usr/local/rt3_ora/sbin/rt-setup-database line 390
(/usr/local/rt3_ora/lib/RT.pm:346)

Stack trace:
RT::__ANON__() called at /usr/perl5/5.8.4/lib/Carp.pm:191
Carp::croak() called at
/usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm:106
DBIx::SearchBuilder::Handle::Connect() called at
/usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle/Oracle.pm:46
DBIx::SearchBuilder::Handle::Oracle::Connect() called at
/usr/local/rt3_ora/lib/RT/Handle.pm:98
RT::Handle::Connect() called at
//usr/local/rt3_ora/sbin/rt-setup-database:390
main::insert_initial_data() called at
//usr/local/rt3_ora/sbin/rt-setup-database:149
Connect Failed Can't connect using this syntax without specifying a HOST and
one of SID INSTANCE_NAME SERVER SERVICE_NAME
 at //usr/local/rt3_ora/sbin/rt-setup-database line 390
make: *** [initialize-database] Error 29

So at this point I really need your help on getting past the Line 390
problem (sub insert_initial_data)
What do I need to do to make it connect to my DB? I've been hardcoding the
DBI:Oracle:CLORAD1 everywhere else it was failing to connect.
But I don't know how to do it in this sub. Here's how its trying to connect
now:

#connect to the db, for actual RT work
require RT::Handle;
$RT::Handle = RT::Handle->new();
Line 390)  $RT::Handle->Connect();

Is there anything I can set to make it connect to my DB like this? I don't
care if I hardcode it like I did before, just as long as its able to finally
finish initializing the DB.

I think I'm real close now...


-Original Message-
From: Joop van de Wege [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 18, 2007 6:04 AM
To: Baytalskiy, Sal
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Desperately ned Oracle help

Baytalskiy, Sal wrote:
> Hey guys!
> A little update:
> i've been looking at the rt-setup-database script trying to figure out 
> how to get around the issues i'm having.
> So the very first error mentioned this: at 
> //usr/local/rt3_ora/sbin/rt-setup-database line 103 which is this 
> *$dbh = DBI->connect( get_system_dsn(), $args{'dba'}, 
> $args{'dba-password'} )* So i replaced that with: $dbh = DBI->connect( 
> "DBI:Oracle:", $args{'dba'}, $args{'dba-password'} )
>  
> That seemed to get me a bit farther as i got this output:
> Now creating a database for RT.
> ...skipped as mwpoc is not mwpoc or we're working with Oracle.
> DSN component 'CLORAD1' is not in 'name=value' format at 
> /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627 DBI 
> connect('CLORAD1;port=1521','mwpoc',...) failed: Can't connect using 
> this syntax without specifying a HOST and one of SID INSTANCE_NAME 
> SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database 
> *line 138 *Can't connect using this syntax without specifying a HOST 
> and one of SID INSTANCE_NAME SERVER SERVICE_NAME at 
> //usr/local/rt3_ora/sbin/rt-setup-database line 138,  line 1.
> make: *** [initialize-database] Error 255
I'm using Oracle too and it should not matter whether the database is on
  the localhost or a remote one, so I would go back and do the following:
- drop the schema of RT on the remote server
- add the RT user or grant DBA role to it (temporarily)
- configure RT again with the correct parameters these are mine adjust
accordingly:
   -- export ORACLE_HOME=/your/oracle/home
   -- export ORACLE_SID=YOURSID
   -- (else the following line will barf)
   -- ./configure --with-db-type=Oracle --with-db-dba=rt_user
  --with-db-database=XE

  (if XE is in your tnsnames.ora then everything should work doesn't matter
where that db is)
- make initialize-database

As to the 32/64bit problem that used to be an issue but since I haven't done
a clean install in a while I don't  know if current DBD::Oracle still has
problems. The way I fixed this once, from memory, is that I did edit the
make file to use $ORACLE_HOME/lib32 instead of $ORACLE_HOME/lib which is
since 10g 64bit instead of 32 as is used to be in pre 10g.
But yo

RE: [rt-users] RT 4

[Baytalskiy, Sal]

Whoa, take it easy...
All I'm saying, and this is coming from personal experience trying to bring
RT into my workplace, it is very difficult to introduce this type of
software (no matter how good it is) into a huge company.
When our security group hears about Perl or sendmail or MySQL - you can
pretty much kiss your software goodbye.

Now, the reason I took Java as an example is because while it is (almost)
open source - it is also installed on every UNIX box.
There's no reason to have GCC and other supporting software in order to
install the software you want.

Also, with Java 1.5 - there's an ability to have embedded DB.

It may very well be a VM image. I've playing with a monitoring solution
called Zenoss which gives you a VM image that you can fire up in 20 minutes
and have a complete working solution.

In any event, in my company it is VERY difficult to bring RT in through the
official channels precisely because of the install process.

Sal.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Goldstein
Sent: Friday, May 18, 2007 9:57 AM
To: RT Users
Subject: Re: [rt-users] RT 4 

>Using Nagios as an example.
>Its written also in Perl, but there's a Java port which basically 
>eliminates the installation completely.
>Download a bunch JARs and fire up Java.
>If there was a port of RT in Java - this would do wonders for the 
>adoption rate.
>Many big corporation don't allow open source stuff and Perl-based 
>software in particular...

That makes my head spin!

Are you saying the installation is a turnoff, regardless of language?
If so, there are alternatives to java, such as a VM image.
Or, like WebGUI (a CMS I'm playing with), you can download a full runtime,
including apache, mysql, and perl itself, so there isn't the usuall
"installation".

Are you saying it must be java, just because of "policy"?
That the shop knows java, doesn't know perl, and won't install anything but
java?  

Are you saying bigcos don't like things writting in perl because perl is
open source?  Even if the app is not open?
Even though RT is open in the way I care about, it is closed in the sense
that changes in the official distribution are
vetted by a company.   Besides, what now that java is being open-sourced?

I'm not that familiar with nagios.  Do the jars include a database and web
server?  Also, how do they ensure that the perl and java versions actually
work the same?

  bobg
___
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] RT 4

[Baytalskiy, Sal]

Using Nagios as an example.
Its written also in Perl, but there's a Java port which basically eliminates
the installation completely.
Download a bunch JARs and fire up Java.
If there was a port of RT in Java - this would do wonders for the adoption
rate.
Many big corporation don't allow open source stuff and Perl-based software
in particular...
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mathew Snyder
Sent: Friday, May 18, 2007 2:20 AM
To: Jesse Vincent
Cc: RT Users
Subject: Re: [rt-users] RT 4

The ability to customize the colors easily from the Configuration menu.

Mathew
Keep up with me and what I'm up to: http://theillien.blogspot.com


Jesse Vincent wrote:
> If, for the sake of argument, Best Practical were to rewrite RT, what 
> would you want to see in the new product?
> 
> Think big.
> 
> Jesse
> 
> 
> --
> --
> 
> ___
> 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] Desperately ned Oracle help

[Baytalskiy, Sal]

Hey guys!
A little update:
i've been looking at the rt-setup-database script trying to figure out how
to get around the issues i'm having.
So the very first error mentioned this: at
//usr/local/rt3_ora/sbin/rt-setup-database line 103 which is this
$dbh = DBI->connect( get_system_dsn(), $args{'dba'}, $args{'dba-password'} )
So i replaced that with: $dbh = DBI->connect( "DBI:Oracle:", $args{'dba'},
$args{'dba-password'} )
 
That seemed to get me a bit farther as i got this output:
Now creating a database for RT.
...skipped as mwpoc is not mwpoc or we're working with Oracle.
DSN component 'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627
DBI connect('CLORAD1;port=1521','mwpoc',...) failed: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 138
Can't connect using this syntax without specifying a HOST and one of SID
INSTANCE_NAME SERVER SERVICE_NAME at
//usr/local/rt3_ora/sbin/rt-setup-database line 138,  line 1.
make: *** [initialize-database] Error 255
 
So next, naturally, i looked at line 138 and replaced 
$dbh = DBI->connect( $Handle->DSN, ${RT::DatabaseUser},
${RT::DatabasePassword} ) || die $DBI::errstr;
with
$dbh = DBI->connect( "DBI:Oracle:CLORAD1", ${RT::DatabaseUser},
${RT::DatabasePassword} ) || die $DBI::errstr;
 
That got me a little farther again:
Now creating a database for RT.
...skipped as mwpoc is not mwpoc or we're working with Oracle.
Now populating database schema.
Now inserting database ACLs
Now inserting RT core system objects
[Thu May 17 23:25:02 2007] [crit]: Connect Failed Can't connect using this
syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME
 at //usr/local/rt3_ora/sbin/rt-setup-database line 390
(/usr/local/rt3_ora/lib/RT.pm:346)
 
Stack trace:
RT::__ANON__() called at /usr/perl5/5.8.4/lib/Carp.pm:191
Carp::croak() called at
/usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm:106
DBIx::SearchBuilder::Handle::Connect() called at
/usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle/Oracle.pm:46
DBIx::SearchBuilder::Handle::Oracle::Connect() called at
/usr/local/rt3_ora/lib/RT/Handle.pm:98
RT::Handle::Connect() called at
//usr/local/rt3_ora/sbin/rt-setup-database:390
main::insert_initial_data() called at
//usr/local/rt3_ora/sbin/rt-setup-database:149
Connect Failed Can't connect using this syntax without specifying a HOST and
one of SID INSTANCE_NAME SERVER SERVICE_NAME
 at //usr/local/rt3_ora/sbin/rt-setup-database line 390
make: *** [initialize-database] Error 29
 
I am stuck again though as line 390 is this:
require RT::Handle;
$RT::Handle = RT::Handle->new();
$RT::Handle->Connect();

Since i no nothing about Perl - i have no idea what i have to hardcode here
to get past this.
 
Any ideas, anyone? I'm just trying to hack this script to populate the DB so
i can finally move on to trying to configure the web interface...


  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baytalskiy,
Sal
Sent: Thursday, May 17, 2007 5:02 PM
To: Vonnahme, Nathan; Justin Brodley; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help


Thanks for your responses !!!
 
Nathan, i ran the script you provided and here's the output:
hello
Oracle
DBD::Oracle::db selectrow_array failed: ORA-00942: table or view does not
exist (DBD ERROR: error possibly near <*> indicator at char 17 in 'select
name from <*>v$database') [for Statement "select name from v$database"] at
testOracle.pl line 20.
10.02.0300
name from v$database: 
 
It seems to be connecting to the DB just fine.
 
I also went through this post:
http://www.zorranlabs.com/articles/step-by-step-installation-dbd-oracle-1.16
-on-solaris-9-and-oracle-9-client.htm
<http://www.zorranlabs.com/articles/step-by-step-installation-dbd-oracle-1.1
6-on-solaris-9-and-oracle-9-client.htm> 
 
And performed the modifications mentioned there. Rebuilt the DBD::Oracle
using only the 32 bit libraries.
And ran the test script at the end of that article. It worked fine. Here's
the outpu:
 
Running testDBDOracle.pl...
  (*) Attempting Oracle Login ...
  OK
  (*) Creating table TEST_DBI ...
  OK
  (*) Insert into TEST_DBI ...
  1 rows inserted.
  1 rows inserted.
  1 rows inserted.
  OK
  (*) Select from TEST_DBI ...
--> TEST_DBI_INTR_NO :  1000
--> TEST_DBI_NAME:  Jeff Hunter
--> TEST_DBI_INTR_NO :  1001
--> TEST_DBI_NAME:  Melody Hunter
--> TEST_DBI_INTR_NO :  1002
--> TEST_DBI_NAME:  Alex Hunter
  OK
  (*) Delete from TEST_DBI ...
  3 rows d

RE: [rt-users] Desperately ned Oracle help

[Baytalskiy, Sal]

Thanks for your responses !!!
 
Nathan, i ran the script you provided and here's the output:
hello
Oracle
DBD::Oracle::db selectrow_array failed: ORA-00942: table or view does not
exist (DBD ERROR: error possibly near <*> indicator at char 17 in 'select
name from <*>v$database') [for Statement "select name from v$database"] at
testOracle.pl line 20.
10.02.0300
name from v$database: 
 
It seems to be connecting to the DB just fine.
 
I also went through this post:
http://www.zorranlabs.com/articles/step-by-step-installation-dbd-oracle-1.16
-on-solaris-9-and-oracle-9-client.htm
<http://www.zorranlabs.com/articles/step-by-step-installation-dbd-oracle-1.1
6-on-solaris-9-and-oracle-9-client.htm> 
 
And performed the modifications mentioned there. Rebuilt the DBD::Oracle
using only the 32 bit libraries.
And ran the test script at the end of that article. It worked fine. Here's
the outpu:
 
Running testDBDOracle.pl...
  (*) Attempting Oracle Login ...
  OK
  (*) Creating table TEST_DBI ...
  OK
  (*) Insert into TEST_DBI ...
  1 rows inserted.
  1 rows inserted.
  1 rows inserted.
  OK
  (*) Select from TEST_DBI ...
--> TEST_DBI_INTR_NO :  1000
--> TEST_DBI_NAME:  Jeff Hunter
--> TEST_DBI_INTR_NO :  1001
--> TEST_DBI_NAME:  Melody Hunter
--> TEST_DBI_INTR_NO :  1002
--> TEST_DBI_NAME:  Alex Hunter
  OK
  (*) Delete from TEST_DBI ...
  3 rows deleted.
  OK
  (*) Drop table TEST_DBI ...
  OK
  (*) Select USER and SYSTEM ...
--> USER :  MWPOC
--> SYSDATE  :  17-MAY-2007 16:45:59
  OK
  (*) Attempting Oracle Logoff ...
  OK
Ending testDBDOracle.pl...
 
Judging by that output i think my setup is working fine. But the problem
still persists: i'm still unable to run the 'make initialize-database' part
of the install.
 
Still getting the same old error:
DSN component 'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627
DBI connect('CLORAD1;port=1521','mwpoc',...) failed: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103
Failed to connect to dbi:Oracle:CLORAD1;port=1521 as mwpoc: Can't connect
using this syntax without specifying a HOST and one of SID INSTANCE_NAME
SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103,
 line 1.
make: *** [initialize-database] Error 255
 
 
Something tells me that it may be an issue with the 'rt-setup-database'
script itself? Is that a possibility?
 


  _  

From: Vonnahme, Nathan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 17, 2007 3:29 PM
To: Baytalskiy, Sal; Justin Brodley; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help




  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baytalskiy,
Sal
Sent: Thursday, May 17, 2007 9:47 AM
To: Justin Brodley; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help


The Oracle readme said that the DB needs to be prepared.
So i ran the schema.Oracle file via the SQLPlus and it inserted all the
tables and indexes.
So i now have the database setup, just empty. No data.
Then, while running the 'make initialize-database' there's a step in that
script to insert the schema. Since i already did that - i commented it out,
just like the Wiki suggests.
So that step should be skipped and it should just try to insert the required
data into the DB.
And that's where i'm stuck at this point.
 
After some googling i found that i might have a problem with the
DBD::Oracle. Apparently it tried installing that module as a 64-bit.
But my Perl is 32-bit. This seems to be a common occurence.
 

 
 
It may help to narrow the problem by testing DBD::Oracle first.  Try using
the 'dbish' utility installed with DBI, or with a test script like this
(copied and pasted from one I used a while back-- I had to mess with
manually setting $ORACLE_HOME and $LIBPATH in some cases):
 
#!/usr/local/bin/perl -w
 
print "hello\n";
 
use DBI;
#use DBD::Oracle;
 
#print "ENV:\n", map {"  $_:  $ENV{$_}\n"} sort keys %ENV;
 
if ($^O =~ m/aix/i) {
$ENV{ORACLE_HOME} = '/usr/local/oracle/instantclient';
$ENV{LIBPATH} = $ENV{ORACLE_HOME};
}
 
my $dbh = DBI->connect('dbi:Oracle:host=clorad1.aig.com;sid=clorad1',
'user', 'password');
 
print join "\n", $dbh->get_info(17),
$dbh->get_info(18);
 
print "\nname from v\$database:  ", $dbh->selectrow_array("select name from
v\$database");
 
print "\n\n";

 
I had trouble in the past with 64 / 32 bit perl

RE: [rt-users] Desperately ned Oracle help

[Baytalskiy, Sal]

The Oracle readme said that the DB needs to be prepared.
So i ran the schema.Oracle file via the SQLPlus and it inserted all the
tables and indexes.
So i now have the database setup, just empty. No data.
Then, while running the 'make initialize-database' there's a step in that
script to insert the schema. Since i already did that - i commented it out,
just like the Wiki suggests.
So that step should be skipped and it should just try to insert the required
data into the DB.
And that's where i'm stuck at this point.
 
After some googling i found that i might have a problem with the
DBD::Oracle. Apparently it tried installing that module as a 64-bit.
But my Perl is 32-bit. This seems to be a common occurence.
 
Here's what i'm getting when trying to run 'make initialize-database' :
 
/usr/bin/perl //usr/local/rt3_ora/sbin/rt-setup-database --action init --dba
mwpoc --prompt-for-dba-password
Unquoted string "error" may clash with future reserved word at
/usr/local/rt3_ora/etc/RT_SiteConfig.pm line 286.
In order to create or update your RT database,this script needs to connect
to your Oracle instance on clorad1.aig.com as mwpoc.
Please specify that user's database password below. If the user has no
database
password, just press return.
 
Password: 
DSN component 'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627
DBI connect('CLORAD1;port=1521','mwpoc',...) failed: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103
Failed to connect to dbi:Oracle:CLORAD1;port=1521 as mwpoc: Can't connect
using this syntax without specifying a HOST and one of SID INSTANCE_NAME
SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103,
 line 1.
make: *** [initialize-database] Error 255
 
 
The hostname where oracle Db is running is clorad1.aig.com. Instance/Service
name is CLORAD1.


  _____  

From: Justin Brodley [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 17, 2007 1:40 PM
To: Baytalskiy, Sal; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help



I would make sure the variable is set everywhere, the initial data is
imported with the schema, that you commented out. Out of curiosity why are
you commenting out the "schema" the only reason you would do this is if the
database was already created with all the appropriate tables. Our oracle
guys just setup the RT user as per the oracle readme and then we just ran
initialize-database and it created the rest. 

 

Justin Brodley

 

From: Baytalskiy, Sal [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 17, 2007 10:34 AM
To: Justin Brodley; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help

 

Thanks a lot, Justin!!!

This is very valuable info!

 

However, i'm not at that step yet. I've just built RT with Oracle support
and was trying to run 'make initialize-database'

I've commented out the 'insert_schema()' method call, cause schema is
already in place.

I was expecting the thing to insert the initial RT data into the DB. But
that's where it was failing.

 

Do you think i should set the variable you mentioned in the shell and try
running it again?

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Justin
Brodley
Sent: Thursday, May 17, 2007 1:20 PM
To: Baytalskiy, Sal; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help

Sal- It has to do with Apache and your CGI handler not knowing the oracle
parameters. We use Fast CGI on Redhat connecting to a remote Oracle servers.
I had to add the following lines to my httpd.conf file:

 

# RT STUFF FOR APACHE

SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/10.2.0/client_1/lib

SetEnv ORACLE_HOME /u01/app/oracle/product/10.2.0/client_1

SetEnv ORACLE_SID rt

SetEnv TWO_TASK rt

(change above variables to your implementation)

 

In Httpd conf I also had to change the initialization string for Fastcgi,
this is the line in my config.

 

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4
-initial-env LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib
-initial-env ORACLE_HOME=/u01/app/oracle/product/10.2.0/client1 -initial-env
ORACLE_SID=rt -initial-env TWO_TASK=rt

 

Some of this might be a bit excessive but I was trying everything and spent
a ton of time on the fastcgi and apache websites trying to figure this out.
Once this was all completed I was successful in getting DBI Searchbuilder
working. This took about a 12 hours of research and trial and error on my
part, and I've meant to go back and put this information in the wiki but
haven't had a chance. 

 

 Justin Brodley

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Beha

RE: [rt-users] Desperately ned Oracle help

[Baytalskiy, Sal]

Thanks a lot, Justin!!!
This is very valuable info!
 
However, i'm not at that step yet. I've just built RT with Oracle support
and was trying to run 'make initialize-database'
I've commented out the 'insert_schema()' method call, cause schema is
already in place.
I was expecting the thing to insert the initial RT data into the DB. But
that's where it was failing.
 
Do you think i should set the variable you mentioned in the shell and try
running it again?


  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Justin
Brodley
Sent: Thursday, May 17, 2007 1:20 PM
To: Baytalskiy, Sal; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help



Sal- It has to do with Apache and your CGI handler not knowing the oracle
parameters. We use Fast CGI on Redhat connecting to a remote Oracle servers.
I had to add the following lines to my httpd.conf file:

 

# RT STUFF FOR APACHE

SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/10.2.0/client_1/lib

SetEnv ORACLE_HOME /u01/app/oracle/product/10.2.0/client_1

SetEnv ORACLE_SID rt

SetEnv TWO_TASK rt

(change above variables to your implementation)

 

In Httpd conf I also had to change the initialization string for Fastcgi,
this is the line in my config.

 

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4
-initial-env LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib
-initial-env ORACLE_HOME=/u01/app/oracle/product/10.2.0/client1 -initial-env
ORACLE_SID=rt -initial-env TWO_TASK=rt

 

Some of this might be a bit excessive but I was trying everything and spent
a ton of time on the fastcgi and apache websites trying to figure this out.
Once this was all completed I was successful in getting DBI Searchbuilder
working. This took about a 12 hours of research and trial and error on my
part, and I've meant to go back and put this information in the wiki but
haven't had a chance. 

 

 Justin Brodley

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baytalskiy,
Sal
Sent: Wednesday, May 16, 2007 9:49 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Desperately ned Oracle help

 

Hey everyone!

As ive already mentioned - i'm being forced to use Oracle for my RT 3.6.3
instance.

Well, today i finally got an Oracle 10g instance up and loaded the
schema.Oracle file into it.

Did the ./configure for RT(./configure --prefix=/usr/local/rt3_ora
--with-db-type=Oracle --with-db-host=clorad1.example.com --with-db-port=1521
--with-db-rt-host=localhost --with-db-dba=rtusr --with-db-database=clorad1
--with-db-rt-user=rtusr --with-db-rt-pass=* )

 

Everything was ok.

 

While doing make initialize-database i got this error: Unable to load
DBIx::SearchBuilder database handle for 'Oracle'.

 

Realized that i don't have DBD::Oracle installed, so i downloaded that from
CPAN and installed that.

There were errors during the install and i found a workaround to delete
-xarch=v9 from the Makefile. After that install finished.

 

Then i followed the Wiki and commented out the insert_schema() method call.

 

But i'm still getting errors trying to init the DB.

 

 

Test suggested by the Wiki (TWO_TASK=FOO perl -MDBI -le
'DBI->connect("DBI:Oracle:", "rt3", "rt3")') seems to be successful. Or at
least it doesn't give any errors.

 

This is the error i get while doing make initialize-database :

 

DSN component 'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627
DBI connect('CLORAD1;port=1521','rtusr',...) failed: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103
Failed to connect to dbi:Oracle:CLORAD1;port=1521 as rtusr: Can't connect
using this syntax without specifying a HOST and one of SID INSTANCE_NAME
SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103,
 line 1.
make: *** [initialize-database] Error 255

 

 

PLEASE HELP !!!

 

Thanks in advance,

Sal.

___
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] Desperately ned Oracle help

[Baytalskiy, Sal]

Hey everyone!
As ive already mentioned - i'm being forced to use Oracle for my RT 3.6.3
instance.
Well, today i finally got an Oracle 10g instance up and loaded the
schema.Oracle file into it.
Did the ./configure for RT(./configure --prefix=/usr/local/rt3_ora
--with-db-type=Oracle --with-db-host=clorad1.example.com --with-db-port=1521
--with-db-rt-host=localhost --with-db-dba=rtusr --with-db-database=clorad1
--with-db-rt-user=rtusr --with-db-rt-pass=* )
 
Everything was ok.
 
While doing make initialize-database i got this error: Unable to load
DBIx::SearchBuilder database handle for 'Oracle'.
 
Realized that i don't have DBD::Oracle installed, so i downloaded that from
CPAN and installed that.
There were errors during the install and i found a workaround to delete
-xarch=v9 from the Makefile. After that install finished.
 
Then i followed the Wiki and commented out the insert_schema() method call.
 
But i'm still getting errors trying to init the DB.
 
 
Test suggested by the Wiki (TWO_TASK=FOO perl -MDBI -le
'DBI->connect("DBI:Oracle:", "rt3", "rt3")') seems to be successful. Or at
least it doesn't give any errors.
 
This is the error i get while doing make initialize-database :
 
DSN component 'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627
DBI connect('CLORAD1;port=1521','rtusr',...) failed: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103
Failed to connect to dbi:Oracle:CLORAD1;port=1521 as rtusr: Can't connect
using this syntax without specifying a HOST and one of SID INSTANCE_NAME
SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103,
 line 1.
make: *** [initialize-database] Error 255
 
 
PLEASE HELP !!!
 
Thanks in advance,
Sal.
___
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] migrating to Oracle 10g

[Baytalskiy, Sal]

Hey everyone!
I'm being forced to migrate RT 3.6.3 from MySQL 5.0.41 Community Server to
Oracle 10g.
You know, infinite levels of corporate paranoya and such...
But in any event, i've searched the Wiki and found very little on the
subject. I did download and installed the Oracle Migration Workbench tool
and successfully connected to my MySQL instance.
Am i better off creating the DB from scratch as part of RT install (i'll
also be migrating RT itself to another box) or is it better to perform an
actual migration of the whole MySQL DB, including the data, to Oracle via
the migration tool?
Has anyone done this type of a migration in the past?
 
Also, i'm concerned about installing extensions such as RTFM and AT with
Oracle. I know the schemas exist but is the installation process different?
Do i need to manually load the schemas first? The Oracle DB will be sitting
on another box than RT. Does this matter?
___
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] RT 3.6.3 - running two instances on the same box

[Baytalskiy, Sal]

Now that i have to instances of RT up - i have yet another question: when
installing extensions, sometimes, i can't get the install to point to the
second RT instance. I've tried doing the 'RTHOME=/path/to/second/instance
perl Makefile.PL' but some extensions still only point to the first one. How
do i work around that? Change the Makefile manually and then run the make?
Thanks in advance,
Sal.
___
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] Problem with MySupportQueues in RT 3.6.3

[Baytalskiy, Sal]

Has anyone else noticed that you can't roll up the MySupportQueues (the one
that displays 'Queues I'm an AdminCc for') in RT 3.6.3 ?
When you place that widget on the 'RT At a Glance' page and click the little
'X' to roll it up - it just makes a clicking sound and stays open...
Is there a quick fix for that?
 
Also, if anyone has installed the Timeline extension (
 http://simile.mit.edu/timeline
 /), i just noticed that the Timeline tab
actually replaces the Bulk Update tab. Is there a way to avoid that and just
have both? I've not been able to find the Tabs file for the Ticket menu...
 
Yesterday i've installed a second RT instance for DEV, to play around with
and try stuff before i promote it to the stable instance.
The database for this DEV instance went into the same MySQL instance. So i
now have TWO databases running in there: rt3 and rt3_dev.
While installing the second RT instance - it was complaining about the DB
being inaccessible (i'm guessing because of the 'root' pasword that was
setup by me last time i installed RT).
I'm not entirely sure what i did, but at some point the DB initialize for
the second instance finally went through.
When i bounced the apache instance though - i wasn't able to access the
first, good RT instance anymore...
I had to change the RTDBUser and RTDBPassword in the SiteConfig for the
first instance to get it to work again...weird...
___
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] Navigation in RT 3.6.3

[Baytalskiy, Sal]

Hello everyone!
I was wondering if it would be possible to NOT have the navigation menu
scroll with the ticket's history?
For either of the stylesheets (3.4 or 3.5) rigth now when you start
scrolling down the ticket's history, the navigation menu disappears.
And there are some pretty long tickets. So i think it would be nice to be
able to keep the menu on top (for the 3.5 CSS) or on the left (for the 3.4
CSS).
I'm not sure if this would require frames or JavaScript or whatever, but its
certainly something i would like to have.
Anyone thought of that? Maybe there are already implementations and i just
haven't seen one yet?
Thanks in advance,
Sal.


smime.p7s
Description: S/MIME cryptographic signature
___
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] ImageAutoResize in RT 3.6.3

[Baytalskiy, Sal]

Hello!

I found an article on automatic image resizing for RT 3.2 on the Wiki.

However it talks about some files that seem to be very different in RT 3.6.3
that i'm running.

Is there a way to automatically scale attached images to the ticket's
display width?

Thanks !

Sal Baytalskiy



smime.p7s
Description: S/MIME cryptographic signature
___
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