Re: [rt-users] Email signature disclaimers

2008-11-12 Thread Panu
 How is everyone dealing with their standard corporate email legal 
 disclaimers on ticket replies?

MTA? (should work for normal emails too)

I personally hate them :) They have no other legal value than make 
stupid people scared to sue for whatever reason. At least in most 
European countries that is the case. But then, people sue other people 
much less for stupid reasons than other side of the Atlantic :)
___
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] E-mail Templates are only a single character

2008-10-17 Thread Panu
 ALTER TABLE Templates MODIFY Content CHAR NULL DEFAULT NULL;
 ALTER TABLE Templates MODIFY Content BLOB NULL DEFAULT NULL;

I think this is the problem. I had the same happening to me.

Ole Graig told me the following:

--- cut ---

the sql.queries file
that I got out of running etc/upgrade/schema.mysql-4.0-4.1.pl
contained some destructive transforms that I had to change. Several
multi-character fields were temporarily transformed into type CHAR,
which truncated them to a single character. Check your sql.queries file
(e.g. 'grep  CHAR  sql.queries) and make sure you're not hitting the
same thing; in my case, one of the fields that was thus truncated was in
fact this same Templates.Content field. RT's templates don't work so
good when they consist of only one character.  :-)

--- cut ---


___
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] Trouble upgrading to 3.8.1

2008-10-13 Thread Panu
 When I run from //rt/src/rt-3.8.1 OR from //rt/src and just 
 enter make testdeps I get command not found. Could THAT be a problem? 
 Am I running some old software when I run /tools/bin/ make testdeps?

You can/(have to) be in main RT directory.

What I'm doing: (I could copy this from the README file

extract the RT archive into /tmp

tar xzvf rt.tar.gz -C /tmp

cd /tmp/rt (or whatever version specific directory the archive extract 
created)

./configure

Make testdeps

if there was something missing then, (may need more than one run)

make fixdeps

make testdeps

make install

as you can see I'm nowhere near any /bin/, /src/ or similar directories

___
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] Trouble upgrading to 3.8.1

2008-10-10 Thread Panu
 From: Kenneth Crocker [EMAIL PROTECTED]
 I ran /tools/bin/ make fixdeps and I got this result:

I newer point to a subdirectory, not sure if it matters though. I do 
always just what the readme/install file tells me. So in the directory 
where I have extracted the rt archive I do make testdeps and make 
fixdeps and eventually make install.

It's normal that it follows dependencies, and tests the modules as they 
are installed. If you get a lot of errors you may have to install those 
manually either using cpan or downloading different archives and then 
installing them manually.
___
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 3.8.1: Tickets interface logs you out

2008-09-12 Thread Panu
 I'm running mysql 5.0.32. So - why the 4.1 schema is fine but the  
 other one isn't I don't know :) Is it an error in the non 4.1 schema  
 or ??

It seems that naming of that upgrade file is somewhat misleading based 
on the problems people are having because they did not follow those 
instructions (I did not have Mysql 4, I have 4.1, 5, etc. already)

You need to follow the instructions if you are upgrading from  3.8 to 
3.8.1 no matter what your mysql database version is. That's my 
understanding.
___
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-Users Digest, Vol 53, Issue 105

2008-08-28 Thread Panu
 I  have tried most thing to get 3.8.1 running without success so I have 
 done the following
  
 1. installed fedora 9 as a clean install
 2. yum update
 3. yum install rt3
  
 got it to work as I need it to http://localhost/rt3
 (http://localhost  gives the apache welcome page) but get version rt-3.6.6

This has been explained to you already, you can't use localhost to 
anyone else than you. I.e., localhost will be different for different 
machines. You have to use your machines ip-address. The sooner you get 
rid of localhost the sooner you are little bit closer to a working system.


 it installed it in /usr/share/rt3/html

That is the default yes. Except the directory is just /usr/share/rt3/ in 
my opinion

 next I downloaded rt-3.8.1.tar.gz

Why, when you installed RT already through packet management system?


 then
  
 1. ./configure --prefix=/usr/share/rt3/html

what is html doing at the end of the path? Was it really installed in 
that directory by yum?

 2. make fixdeps
 3. make upgrade
 4. upgraded the database
  
 the problem is if i now run http://localhost/rt3 i still get version 3.6.6

Yes because you installed the new version to /usr/share/rt3/html


 if I now change in/etc/httpd/conf.d/rt3.conf
  
 from
  
 PerlRequire /user/sbin/webmux.pl
  
 to
  
 PerlRequire /usr/share/rt3/http/bin/webmux.pli get 404 not found

Do you have webmux in that directory you specified. The path with my 
install is /opt/rt/sbin/webmux.pl


 What do i need to do to get rt-3.8.1 running as http://localhost/rt3 and 
 NOT as http://localhost

Why you have to have localhost as the address? You need to understand 
apaches configuration files to be able to configure the address to your 
liking.

What I would do is to make a clean install if you don't have tickets or 
anything yet. And follow the instruction closely. I had some problems 
too with upgrade but they were because I had an older RT instance 
configured on the same server, so it's better you remove all traces of 
RT from httpd.conf I think.
___
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] Problem upgrading from 3.6.1 to 3.8.1

2008-08-20 Thread panu
 ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET utf8 NULL 
 DEFAULT NULL;

 I don't see anything wrong with that line.
 
 Panu -
 Don't know about your other problem, but I ran into this SQL burp in
 four or five different tables while going from 3.6.0 to 3.8.1rc5. MySQL
 doesn't like the CHARACTER SET directive for a field of type BLOB. These
 lines should probably be changed to specify TEXT instead of BLOB (or you
 could remove the 'CHARACTER SET utf8' directive if you know the fields
 in question are used to store binary data instead of text.)
 
 Looking at my database, Templates.Content is definitely TEXT.
 
 Oh, and one other thing to watch out for -- the sql.queries file
 that I got out of running etc/upgrade/schema.mysql-4.0-4.1.pl
 contained some destructive transforms that I had to change. Several
 multi-character fields were temporarily transformed into type CHAR,
 which truncated them to a single character. Check your sql.queries file
 (e.g. 'grep  CHAR  sql.queries) and make sure you're not hitting the
 same thing; in my case, one of the fields that was thus truncated was in
 fact this same Templates.Content field. RT's templates don't work so
 good when they consist of only one character. :-)

Ole,

thanks a lot, I should have paid more attention to that. I for some 
reason mixed up TEXT and CHAR. As the fields the queries wanted to 
convert to blob were already blob I just deleted those rows and I now 
have probably? a properly upgraded DB. (yes I restored an old dump first :)

I still have various problems, the cleanslate problem still appear in 
the logs with various pages. For example:

Can't locate object method CleanSlate via package 
RT::Action::SendEmail at 
/opt/rt38/bin/../lib/RT/Interface/Web/Handler.pm line 213.\n, referer: 
http://xxx.yyy.com/Search/Simple.html


I also get internal server error with simple search. And for example 
homepage has:

RT::Ticket::ACLEquivalenceObjects Unimplemented in RT::Principal. 
(/opt/rt38/bin/../lib/RT/Principal_Overlay.pm line 327) and I can't see 
any of my tickets.

Same kind of error appears on almost all pages.
___
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-Users Digest, Vol 53, Issue 59

2008-08-20 Thread panu
 From:
 Ruslan Zakirov [EMAIL PROTECTED]

 Apache+mod_perl with two RTs in different virtual hosts?

 Can't locate object method CleanSlate via package
 RT::Action::SendEmail at
 /opt/rt38/bin/../lib/RT/Interface/Web/Handler.pm line 213.\n, referer:
 http://xxx.yyy.com/Search/Simple.html

Yes... That was it. Slowly learning the wonders or Perl  Apache :)

Another thing is that the scandinavian characters are messed up like 
Geirs said. But that is not that important at this time (especially if 
new tickets will have them correctly).

Thanks for the help.
___
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 upgrading from 3.6.1 to 3.8.1

2008-08-19 Thread panu
Everything else is going just fine with the upgrade except the end result :)

when I upgrade the schema I get various errors like:

ERROR 1064 (42000) at line 131: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'CHARACTER SET utf8 NULL DEFAULT NULL' at line 1

whole query:

ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET utf8 NULL 
DEFAULT NULL;

I don't see anything wrong with that line.

also there's an error displaying in every page:

The server encountered an internal error or misconfiguration and was 
unable to complete your request.

etc...

the error in error log is:

Can't locate object method CleanSlate via package 
RT::Action::SendEmail at 
/opt/rt38/bin/../lib/RT/Interface/Web/Handler.pm line 213.\n, referer: 
http://...

are these 2 errors related.
___
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] Re: RTFM/RT version question

2006-10-25 Thread Panu
I'm trying to upgrade from RT 3.4.2/RTFM 2.0.2 
to RT 3.6.1.  Seems I need to upgrade RTFM as well,

so I tried 2.2.0RC4, since the dates seems to be similar.

Kinda works, but not really.  (I'm using the 3.4-retro css
if that matters.)  I never see the content of the articles,
unless I view the history, and there is no box in which
to create content for new articles.


We had the same problem, unfortunately we couldn't leave out a possible 
upgrade error so I ended up reinstalling rtfm from scratch and then 
inputting all old articles by hand. Luckily we didn't have that many...


It would be nice to know a possible solution in case we have problems 
upgrading to the final version.


Panu
___
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