Re: [rt-users] rt asterisk

2014-11-06 Thread Stefan Hornburg (Racke)
On 11/05/2014 07:31 PM, Shahab Sharifzadeh wrote:
 very thank...
 
 nobody help me?
  
 

I suggest to use the Perl module RT::Rest::Client and not trying to hack the 
content
by your own. Even PHP should have some support for stuff like that.

Regards
Racke

-- 
Modern Perl, Dancer and eCommerce consulting.


Re: [rt-users] rt asterisk

2014-11-04 Thread Stefan Hornburg (Racke)
On 11/04/2014 11:55 AM, Shahab Sharifzadeh wrote:
 
 hi
 good time
 
 i want to join rt(request tracker) to asterisk by rt-soap-server.pl.
 but i dont no what to do...
 
 1- i installed- SOAP::Lite and MIME::Entity
 2-after that ,how I run ./rt-soap-server.pl ? And how configure?
 

I recommend to take a look at RT::Client::REST. REST is far easier to deal
with than SOAP.

Sample module using RT::Client::REST:

https://github.com/interchange/Helpdesk-Integration

Regards
Racke

-- 
Modern Perl, Dancer and eCommerce consulting.
-- 
RT Training November 4  5 Los Angeles
http://bestpractical.com/training


Re: [rt-users] Delete Post

2013-03-03 Thread Stefan Hornburg (Racke)
On 03/03/2013 04:26 PM, bluethundr wrote:
 Hello,
 
 I'd like to delete this post because I've accidentally included some
 passwords in it:
 
 http://requesttracker.8502.n7.nabble.com/RT-Bounce-messages-td45911.html#a33251204
 
 I've gone to the thread and clicked 'options'. But for some reason it
 doesn't give me the option to delete even tho I'm the author. Is there
 someone who can help me out here? Maybe I'm doing something wrong.
 

Yes, better change your passwords. They are out in the wild now regardless
whether you can delete the post or not.

Regards
Racke


-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team



-- 
RT training in Amsterdam, March 20-21: 
http://bestpractical.com/services/training.html

Help improve RT by taking our user survey: 
https://www.surveymonkey.com/s/N23JW9T


Re: [rt-users] Upgrade from 3.6.1 to 3.8.8

2010-12-10 Thread Stefan Hornburg (Racke)

On 12/10/2010 05:57 PM, Kevin Falcone wrote:

On Fri, Dec 10, 2010 at 02:55:40PM +0100, Stefan Hornburg (Racke) wrote:

On 12/10/2010 02:48 PM, Kevin Falcone wrote:

We now will be upgrading our Debian server and the version of RT
used will go from 3.6.1 to 3.8.8.

How feasible is the upgrade from 3.6.1 to 3.8.8?  What would need to
be done?

Someone has mentioned updates to the DB being needed - I'd
appreciate any pointers to the SQL which would be needed.


Have you read through UPGRADING and the README that are included with
every download of RT?

It covers all of this.


Not really. It is very important for the upgrade to read UPGRADING.mysql
and follow the steps detailed below:


Both of the files I reference contain pointers to UPGRADING.mysql

3.8 (3.8-trunk)$ grep UPGRADING.mysql *
README: you're using MySQL, read through UPGRADING.mysql as well.
UPGRADING:If you are using MySQL, please read the instructions in 
UPGRADING.mysql as
UPGRADING:New schema for mysql 4.1 and greater, read more in UPGRADING.mysql.

-kevin



Kevin, I just wanted to point this out - many people missed this step because 
the
upgrade docs are not clear enough - check the archives :-).

Regards
Racke



--
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team



Re: [rt-users] Google crawlers.

2010-12-09 Thread Stefan Hornburg (Racke)

On 12/09/2010 02:34 PM, Mark Jenks wrote:

I guess I'm going for the DNS blocking method, since I don't see where
to put in a robots.txt file into RT.   I'll have to do some custom
conf.d stuff when I get back into the office next week.



You can specify robots.txt in your Apache configuration, before
the statements you use for RT:

Alias /robots.txt /path/to/your/robots.txt

Regards
Racke


--
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team



Re: [rt-users] How to install RT-3.8.8 on Debian lenny [SOLVED]

2010-11-17 Thread Stefan Hornburg (Racke)

On 11/17/2010 03:08 PM, Wagner Pereira wrote:

Hi Dominic and the others,

I really thank your reply but, after Jesse said at 
http://blog.bestpractical.com/2010/09/rt-4-an-update.html,
I decided to wait for the RT 4, the Jesse's Xmas gift!



Why wait? Start building RT4 Debian packages!

Just my 2 cents :-).

Regards
Racke


--
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team



Re: [rt-users] RT email time

2010-06-02 Thread Stefan Hornburg (Racke)

On 06/02/2010 08:13 PM, Juan N. DLC wrote:

Hi,

For some reazon my RT is sending the emails when any action is configured
with 4 hours of difference from the real time.

from GUI:
Dateshttps://srthr31/Ticket/ModifyDates.html?id=1934   Created: Wed Jun 02
14:10:24 2010
from email sent:
Created On: 2010-06-02 18:10:24

Any configuration should I need to look at? Can someone point me to where
look?


What about $Timezone setting in RT_SiteConfig.pm. Debian packages are using:

Set($Timezone, `/bin/date +%Z`);

Regards
Racke


--
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team


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


Re: [rt-users] RT email time

2010-06-02 Thread Stefan Hornburg (Racke)

On 06/02/2010 09:46 PM, Juan N. DLC wrote:

yes, that is the problem I'm having. Any thoughts?


Which distribution do you run? What is the output of date +%Z?

Regards
Racke


--
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team


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


Re: [rt-users] RT email time

2010-06-02 Thread Stefan Hornburg (Racke)

On 06/02/2010 10:17 PM, Juan N. DLC wrote:

Racke,

we...@srthr31:~$ /bin/date +%Z
AST



That should be the correct timezone for Puerto Rico (GMT - 4). Do you have the
same problem sending email for the command line (e.g. with mail from bds-mailx
package)? Which email server are you using?

Regards
Racke

--
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team


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


Re: [rt-users] 500 - Internal error

2009-02-20 Thread Stefan Hornburg (Racke)
Alberto Villanueva wrote:
 The rt log (/var/log/rt.log) is empty :S :S :S
 
 The log of apache (/var/log/httpd/error_log):
 
 [Thu Feb 19 19:38:45 2009] [warning]: DBD::mysql::st execute failed: INSERT
 command denied to user 'vtd_rt_dbuser'@'localhost' for table 'sessions' at
 /usr/lib/perl5/site_perl/5.10.0/Apache/Session/Store/DBI.pm line 44.
 (/usr/lib/perl5/site_perl/5.10.0/Apache/Session/Store/DBI.pm:44)
 

Looks like vtd_rt_dbuser lacks the proper MySQL permissions write to the
sessions table.

Regards
 Racke


-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team

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

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


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


Re: [rt-users] Problem with PDF attachments

2009-01-22 Thread Stefan Hornburg (Racke)
System Administrator wrote:
 Hi,
 
 I recently upgraded from version 3.4.6 to 3.8.1.  Since then, pdf
 attachments downloaded from RT or sent by RT are corrupted, Acrobat
 Reader displays the error  Insufficient data for an image.  This
 occurs even for pdf attachments saved before the upgrade.  I saw no
 errors in the database upgrade script running.
 
 Have anyone had this issue before and encountered a solution?

Did you apply the MySQL 4.0-4.1 schema changes as described
in UPGRADING.mysql?

Regards
  Racke


-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team

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

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


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 disable fckeditor globally?

2009-01-16 Thread Stefan Hornburg (Racke)
Remy Berrebi wrote:
 hi everyone,
 
 on my side, i installed a fresh 3.8.1 version of RT and i can not see 
 anywhere fckeditor menu-bar, is there a documentation or something i 
 miss about it?
 
 i even try to put Set($MessageBoxRichText, 1); but nothing change... i 
 test my RT with firefox 3 on linux and IE6 on linux...
 
 any help will be appreciate,

Check your JavaScript error console first (and look at the HTML source
code where you see a trace of fckeditor).

Regards
Racke



-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team

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

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


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


Re: [rt-users] error starting apache2

2008-12-11 Thread Stefan Hornburg (Racke)
Michael James wrote:
 SLES 10 SP2 fresh build
 RT 3.8.1 downloaded from BestPractical yesterday.
 
 After installing RT, I brought an existing RT_SiteConfig.pm file over from 
 another server running RT 3.6.6. 
 
 Apache2 fails to start with the following errors in 
 /var/log/apache2/error_log:
 
 [Thu Dec 11 13:34:09 2008] [error] Couldn't load RT config file 
 RT_SiteConfig.pm:\n\nType of arg 1 to RT::Set must be one of [...@%] (not 
 scalar assignment) at /opt/rt3/etc/RT_SiteConfig.pm line 43, near 
 )\nCompilation failed in require at /opt/rt3/bin/../lib/RT/Config.pm line 
 410.\nBEGIN failed--compilation aborted at /opt/rt3/bin/webmux.pl line 
 101.\nCompilation failed in require at (eval 7) line 1.\n
 
 [Thu Dec 11 13:34:09 2008] [error] Can't load Perl file: 
 /opt/rt3/bin/webmux.pl for server tracker3.stonebridgebank.com:0, exiting...
 
 Line 43 of RT_SiteConfig.pm is Set($WebPath = ); which looks perfectly OK 
 to me.
 
 Any ideas?
 

Set($WebPath, '');

Regards
   Racke



-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team

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

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


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


[rt-users] Size of Relationship Charts

2008-11-06 Thread Stefan Hornburg (Racke)
Hello,

finally I got the relationship charts running :-). They're silently failing
if IPC::Run::SafeHandles module is missing ...
make testdeps doesn't check for that either.

Anyway, how can I change the size of elements in the graph (larger font,
larger containers)?

Regards
   Racke

-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team

___
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] 404 on Ubuntu 8.10

2008-11-03 Thread Stefan Hornburg (Racke)
Jared Liebl wrote:
 I'm trying to get RT 3.8.1 installed on a Ubuntu v8.10 server, and I
 seem to be setting it up wrong.  I keep getting a 404 message when I try
 to access RT.
 
 I did find the instructions for upgrading a Ubuntu install from 3.6 to
 3.8 (http://www.nabble.com/Re:-Ubuntu-RT-3.8-package-p19726512.html),
 but I'm not smart enough to figure out how to run the configure script
 properly to get it to install in the locations chosen by the Ubuntu
 package, so I'm trying to do a manual install.
 
 I started by loading my server as a Ubuntu LAMP server (I have some
 other stuff besides RT that I want to add to this machine later).  Then
 I installed Mod Perl 2 and ran 'make fixdeps', and everything seemed to
 go well.  I ran Make Install, and installed everything to the default
 directory (/opt/rt3/).
 
 Then I copied /opt/rt3/etc/RT_Config.pm to
 /opt/rt3/etc/RT_SiteConfig.pm, and changed the following lines:
 Set($rtname , servername.domain.tld);
 Set($Organization , domain.tld);
 Set($Timezone , 'US/Central');
 Set($DatabaseUser , 'rt_user');
 Set($DatabasePassword , 'mypassword');
 Set($WebPath, /rt);
 Set($WebBaseURL, 'http://servername.domain.tld' .
 RT-Config-Get('WebDomain') . ':' . RT-Config-Get('WebPort'));
 
 Finally, I modified my Apache configuration file
 (/etc/apache2/sites-available/default), so that it looks like this:
 VirtualHost *:80
   ServerAdmin [EMAIL PROTECTED]
 
   DocumentRoot /var/www/
   Directory /
   Options FollowSymLinks
   AllowOverride None
   /Directory
   Directory /var/www/
   Options Indexes FollowSymLinks MultiViews
   AllowOverride None
   Order allow,deny
   allow from all
   /Directory
 
   ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
   Directory /usr/lib/cgi-bin
   AllowOverride None
   Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
   Order allow,deny
   Allow from all
   /Directory
 
   ErrorLog /var/log/apache2/error.log
 
   # Possible values include: debug, info, notice, warn, error,
 crit,
   # alert, emerg.
   LogLevel warn
 
   CustomLog /var/log/apache2/access.log combined
 
 Alias /doc/ /usr/share/doc/
 Directory /usr/share/doc/
 Options Indexes MultiViews FollowSymLinks
 AllowOverride None
 Order deny,allow
 Deny from all
 Allow from 127.0.0.0/255.0.0.0 ::1/128
 /Directory
 
# as RT is out of document root then we want alias
# and should define directory access
Alias /rt/ /opt/rt3/share/html/
Directory /opt/rt3/share/html/
Order allow,deny
Allow from all
/Directory
 
PerlRequire /opt/rt3/bin/webmux.pl
Location /rt/
AddDefaultCharset UTF-8
SetHandler perl-script
PerlHandler RT::Mason
/Location
 /VirtualHost
 
 I can get a page to load at http://servername.domain.tld, but if I go to
 http://servername.domain.tld/rt, I get a 404:
 Not Found
 The requested URL /rt was not found on this server.
 Apache/2.2.9 (Ubuntu) PHP/5.2.6-2ubuntu4 with Suhosin-Patch
 mod_perl/2.0.4 Perl/v5.10.0 Server at servername.domain.tld Port 80
 
 /var/log/apache2/error.log reads:
 [error] [client 192.168.0.123] File does not exist: /var/www/rt
 
 I think that the problem should be easy to fix, if you know apache well.
 I'd really love to use RT 3.8 on Ubuntu.  I'd rather not switch
 distributions, or use an earlier version.
 
 Does anyone have any suggestions for me?

Try to leave off the trailing slash on /rt/. Also I would suppose
Alias /rt/ would override Location /rt/.

Regards
  Racke

-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team

___
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] Public Interface

2007-06-28 Thread Stefan Hornburg (Racke)

Jesse Vincent wrote:


On May 14, 2007, at 11:20 AM, Stefan Hornburg wrote:

I recently start to use RT for tracking bugs and issues in projects 
for my customers. Now I would like to extend this to open source 
software,

where everyone should be able to view and comment on tickets.

Questions:

1. How can I setup a guest account for unauthorized users like on 
rt.cpan.org ?



Have a look at these distributions in the RT svn repository.

RT-BugTracker/
RT-BugTracker-Public/


The latter one bugs out on RT 3.6.1 (Debian packages from etch) with:

System error
error:  	Error during compilation of 
/usr/share/request-tracker3.6/html/Callbacks/BugTracker-Public/autohandler/Default:
Variable $session is not imported at 
/usr/share/request-tracker3.6/html/Callbacks/BugTracker-Public/autohandler/Default line 3.
Global symbol $session requires explicit package name at 
/usr/share/request-tracker3.6/html/Callbacks/BugTracker-Public/autohandler/Default line 3.


context:
1:  %init
2:  if ( $session{'CurrentUser'}-Name eq $RT::WebPublicUser
3:  or defined $session{'BitcardUser'} or defined 
$session-{'CurrentUser'}-{'OpenID'} )
4:  {
5:  # This is a public user, we only want them going to /Public/
6:  #
7:  # The following logic is very similar to the priv/unpriv logic
... 
code stack: /usr/share/perl5/HTML/Mason/Interp.pm:445
/usr/share/perl5/HTML/Mason/Request.pm:1087
/usr/share/perl5/HTML/Mason/Request.pm:1020
/usr/share/perl5/HTML/Mason/Request.pm:1198
/usr/share/request-tracker3.6/html/Elements/Callback:83
/usr/share/request-tracker3.6/html/autohandler:255
raw error

Any advice ?

Thanks
Racke

--
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team

___
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