Re: [rt-users] Trying to get AssetTracker1.2.4b1 to work with RT3.8.7

2010-06-19 Thread Torsten Brumm 
OK, have you tried to clean the mason cache and restart apache?

Another point: i'm not sure where RT is installed via yum, is it placed in
/opt/rt3 ?? or somewhere else?

Torsten

2010/6/18 Alan Yuen 

> Hi,
>
> I am a newbie to RT, so any help is appreciated.
> I installed RT the lazy way, running Fedora 13, I just "yum install" RT, RT
> is up and working in no time.
>
> Then I did "svn checkout
> http://ass-tracker-4rt.googlecode.com/svn/at/tags/1.2.4b1";, got the beta
> source to AT, followed all the steps in README.
>
> Everything seems to be ok, rebooted Fedora 13, however I don't see anything
> change in RT (ie didn't add "Asset" under "Tools").  Am I missing
> something?
>
> Here is what happened in make install:
>
> [r...@localhost 1.2.4b1]# make install
> mkdir -p //opt/rt3/etc/AssetTracker/
> cp etc/AssetTracker/AT_Config.pm //opt/rt3/etc/AssetTracker/AT_Config.pm
> [ -f //opt/rt3/etc/AssetTracker/AT_SiteConfig.pm ] || cp
> etc/AssetTracker/AT_SiteConfig.pm
> //opt/rt3/etc/AssetTracker/AT_SiteConfig.pm
> chgrp rt //opt/rt3/etc/AssetTracker/AT_Config.pm
> chown root //opt/rt3/etc/AssetTracker/AT_Config.pm
> chgrp rt //opt/rt3/etc/AssetTracker/AT_SiteConfig.pm
> chown root //opt/rt3/etc/AssetTracker/AT_SiteConfig.pm
> Installed configuration. about to install at in
> for dir in `cd ./lib/ && find . -type d -print`; do \
>  /bin/sh ./install-sh -c -d -m 0755 /opt/rt3/lib/$dir ; \
>done
> for f in `cd ./lib/ && find . -type f -name \*.pm -print`; do \
>  /bin/sh ./install-sh -c  -m 0644 lib/$f  /opt/rt3/lib/$f ; \
>done
> for dir in `cd ./html/ && find . -type d -print`; do \
>  /bin/sh ./install-sh -c -d -m 0755 /opt/rt3/share/html/$dir ; \
>done
> for f in `cd ./html/ && find . -type f -print`; do \
>  /bin/sh ./install-sh -c  -m 0644 html/$f
> /opt/rt3/share/html/$f ; \
>done
> for dir in `cd ./po/ && find . -type d -print`; do \
>  /bin/sh ./install-sh -c -d -m 0755 /opt/rt3/po/$dir ; \
>done
> for f in `cd ./po/ && find . -type f -print`; do \
>  /bin/sh ./install-sh -c  -m 0644 po/$f  /opt/rt3/po/$f ; \
>done
> mkdir -p -m 0755 /opt/rt3/sbin/;
> for dir in `cd ./sbin/ && find . -type d -print`; do \
>  /bin/sh ./install-sh -c -d -m 0755 /opt/rt3/sbin//$dir ; \
>done
> for f in `cd ./sbin/ && find . -type f -print`; do \
>  /bin/sh ./install-sh -c  -m 0644 sbin/$f  /opt/rt3/sbin//$f ; \
>done
> mkdir -p //opt/rt3/etc/AssetTracker/
> cp -rp \
>etc/AssetTracker/acl.* \
>etc/AssetTracker/initialdata \
>etc/AssetTracker/schema.* \
>etc/AssetTracker/drop_* \
>etc/AssetTracker/upgrade \
>//opt/rt3/etc/AssetTracker/
> # Make the libraries readable
> #chmod 0755 /
> chown -R root //opt/rt3/lib
> chgrp -R bin //opt/rt3/lib
> chmod -R  u+rwX,go-w,go+rX  //opt/rt3/lib
> chmod 0755 //opt/rt3/etc/AssetTracker/
> chmod 0500 //opt/rt3/etc/AssetTracker//*
> #TODO: the config file should probably be able to have its
> # owner set separately from the binaries.
> chown -R root //opt/rt3/etc/AssetTracker/
> chgrp -R rt //opt/rt3/etc/AssetTracker/
> chmod 0554 //opt/rt3/etc/AssetTracker/AT_Config.pm
> chmod 0554 //opt/rt3/etc/AssetTracker/AT_SiteConfig.pm
> # Make the web ui readable by all.
> chmod -R  u+rwX,go-w,go+rX  //opt/rt3/share/html
> chown -R root  //opt/rt3/share/html
> chgrp -R bin  //opt/rt3/share/html
> make dropdb.`/usr/bin/perl -I/opt/rt3/lib -I/opt/rt3/lib -e'use RT;
> RT::LoadConfig(); print ${$RT::{$ARGV[0]}};' DatabaseType`
> make[1]: Entering directory `/root/1.2.4b1'
> mysql   `/usr/bin/perl -I/opt/rt3/lib -I/opt/rt3/lib -e'use RT;
> RT::LoadConfig(); print ${$RT::{$ARGV[0]}};' DatabaseName` -u root -p <
> etc/AssetTracker/drop_schema.mysql
> Enter password:
> make[1]: Leaving directory `/root/1.2.4b1'
> /usr/bin/perl /opt/rt3/sbin//at-setup-database --action init --datadir
> ./etc/AssetTracker/ --dba root --prompt-for-dba-password
> Name "RT::DatabaseHost" used only once: possible typo at
> /opt/rt3/sbin//at-setup-database line 221.
> In order to create or update your RT database,this script needs to connect
> to your mysql instance on localhost as root.
> Please specify that user's database password below. If the user has no
> database
> password, just press return.
>
> Password:
> Now populating AssetTracker database schema.
> Creating database schema.
> Done setting up database schema.
> Now inserting AssetTracker database ACLs
> Done setting up database ACLs.
> Now inserting AssetTracker data
> Creating Superuser  ACL...done.
> Creating groups...141.142.done.
> Creating types...1.done.
> Creating ACL...That principal already has that right.done.
> Done setting up database content.
> [r...@localhost 1.2.4b1]#
>
>
> Thanks.
>
> Rgds,
> Alan
>
>
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.c

Re: [rt-users] Setting LastUpdatedBy in a scrip

2010-06-19 Thread Torsten Brumm 
>From wiki: http://wiki.bestpractical.com/view/WriteCustomActionHow to be
silent

Now you put SetXxxx calls all over the places in RT and suddenly note that
strange transactions appear in tickets. They have creator
RT_Systemand describe
what you've done with your scrips. Sometimes it's better to be
silent and not mislead users. These transactions also go through the steps
described earlier and could trigger some conditions too. *Just use the long
form of SetXxx functions:*

$TicketObj->_Set(Field => 'Priority', Value => 90, RecordTransaction => 0);

Could work this way!

Torsten

2010/6/19 Jason Maderios 

>  I tried that
>
>
> my ( $st, $msg ) = $self->TicketObj->SetSubject ("\($cftype - $cfphone\)
> $csubj", RecordTransaction => 0 );
>
> But I still get:
>
> Sat Jun 19 11:57:25 2010 The RT System itself - Subject changed from (no
> value) to '( DSL- 5551212) '
>
> For some reason the transaction still shows up
>
>
>
>  *From:* Torsten Brumm 
> *Sent:* Saturday, June 19, 2010 11:07 AM
> *To:* Jason Maderios 
> *Cc:* rt-users@lists.bestpractical.com
> *Subject:* Re: [rt-users] Setting LastUpdatedBy in a scrip
>
> I have no idea about your scrip, but in most cases you can use
> RecordTransaction=0 (search the wiki for correct syntax)
>
> Torsten
>
> 2010/6/19 Jason Maderios 
>
>>  All,
>>
>> I have scrips that update information in custom fields on each transaction
>> on a ticket.
>>
>> The scrips work great however they always set LastUpdatedBy to RT_System.
>> How can I set the LastUpdatedBy to the actual user working the ticket at the
>> end of the scrip?
>>
>> Regards,
>>
>> Jason Maderios
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
>
>
>
> --
> MFG
>
> Torsten Brumm
>
> http://www.brumm.me
> http://www.elektrofeld.de
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de

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

Re: [rt-users] Setting LastUpdatedBy in a scrip

2010-06-19 Thread Jason Maderios 
I tried that


my ( $st, $msg ) = $self->TicketObj->SetSubject ("\($cftype - $cfphone\) 
$csubj", RecordTransaction => 0 );

But I still get:

Sat Jun 19 11:57:25 2010 The RT System itself - Subject changed from (no value) 
to '( DSL- 5551212) ' 

For some reason the transaction still shows up




From: Torsten Brumm 
Sent: Saturday, June 19, 2010 11:07 AM
To: Jason Maderios 
Cc: rt-users@lists.bestpractical.com 
Subject: Re: [rt-users] Setting LastUpdatedBy in a scrip


I have no idea about your scrip, but in most cases you can use 
RecordTransaction=0 (search the wiki for correct syntax)

Torsten


2010/6/19 Jason Maderios 

  All,

  I have scrips that update information in custom fields on each transaction on 
a ticket.

  The scrips work great however they always set LastUpdatedBy to RT_System.  
How can I set the LastUpdatedBy to the actual user working the ticket at the 
end of the scrip?

  Regards,

  Jason Maderios


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




-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de

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

Re: [rt-users] Setting LastUpdatedBy in a scrip

2010-06-19 Thread Torsten Brumm 
I have no idea about your scrip, but in most cases you can use
RecordTransaction=0 (search the wiki for correct syntax)

Torsten

2010/6/19 Jason Maderios 

>  All,
>
> I have scrips that update information in custom fields on each transaction
> on a ticket.
>
> The scrips work great however they always set LastUpdatedBy to RT_System.
> How can I set the LastUpdatedBy to the actual user working the ticket at the
> end of the scrip?
>
> Regards,
>
> Jason Maderios
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de

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

[rt-users] Setting LastUpdatedBy in a scrip

2010-06-19 Thread Jason Maderios 
All,

I have scrips that update information in custom fields on each transaction on a 
ticket.

The scrips work great however they always set LastUpdatedBy to RT_System.  How 
can I set the LastUpdatedBy to the actual user working the ticket at the end of 
the scrip?

Regards,

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

[rt-users] Understanding schema of RT

2010-06-19 Thread Alberto Villanueva 
Good morning,


As a consequence of my current work, I have to learn the schema of the RT
database. My current version is 3.8.1, but on my explanation I am going to
use the version 3.4 (http://bestpractical.com/rt/3.4-schema.png).

I want to understand a relation using the "Any RT::Record" virtual table
perfectly. For example: using the "Transactions" table. I'm going to do my
explanation, and please you correct me if I do wrong.

My explanation:
- ONE ObjectID of "Transactions" has MANY id in "Any RT::Record" virtual
table.
- ONE Creator of "Any RT::Record" has MANY id in "Principals" table.
- Therefore, ONE Creator of "Transactions" has MANY id in "Principals" table.

Before I show several queries I have test, I would like to know if my
explanation is correct.


Thanks a lot!
Best regards,

-- 
ALBERTO VILLANUEVA VAL
Consultor
___

ALTRAN: talento generando innovación

ParqueEmpresarial Las Mercedes, Edificio 1
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57

www.altran.es




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