Re: [rt-users] How to move an existing database to a new server

2014-11-12 Thread Vas
Hi Kevin,
once again thank you for your reply.

So If understood correctly:

1)/opt/rt4/sbin/rt-setup-database --action drop database (drop the existing
rt4 database which I created when first install rt4.2.9)
Followed this guide
http://binarynature.blogspot.co.uk/2013/10/install-request-tracker-4-on-ubuntu-server.html
so I have done initdb and don't need to do again?
2)/opt/rt4/sbin/rt-setup-database --action create database,acl (create a new
database with acl)
3)gunzip -c rt-mydump.sql.gz | mysql -uroot -p rt4
4)/opt/rt4/sbin/rt-setup-database --action upgrade

On step 4 I get Error: Couldn't read dir './etc/upgrade' with upgrade data

Having a read around, this error comes up if you are not running from the
extracted source directory.
But my understanding was that /opt/rt4/sbin is the correct location because
step 12 work with no problems.

Thank you
Vas



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875p58999.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


Re: [rt-users] login via html-form (username/password) and WebExternalAuth side-by-side

2014-11-12 Thread Luca Mazzaferro

On 11/11/2014 08:19 PM, Kevin Falcone wrote:

On Tue, Nov 11, 2014 at 12:45:41PM +0100, Luca Mazzaferro wrote:

I want to give my users the possibility to login to rt through an
SSO-mechanism (here: kerberos).
It works fine if I require a Kerberos -ticket in through apache2.
However, I would like to either have the people type their username /
password in the HTML-Login form
or click a button to login with the Kerberos ticket.

I'd suggest either two Virtual Hosts, one which does the kerberos
tickets, or one domain using Satisfy so that people without kerberos
tickets drop through to RT's login.

Have you reviewed
http://bestpractical.com/docs/rt/latest/authentication
Your technique of copying and fiddling with Login.html seems much more
complicated that it's needed to be for anyone that we've set this up
for before.  Most of the time folks just have a button on the normal
login page that runs them off to the shib or kerb auth points and then
back again and then RT notices you have REMOTE_USER and you're good to
go.

-kevin

Hi Kevin,
thank you very much for your suggestions.
Unfortunately here I have some firewall restrictions
so 2 Virtual hosts could be difficult.
I will try to read

http://bestpractical.com/docs/rt/latest/authentication

Thank you again

Luca


[rt-users] how sync mysql?

2014-11-12 Thread Shahab Sharifzadeh
how i sync status field's in table Tickets (RT) with other table in remote 
server?(Update or insret)

example :
if i changed ticket status(new = open) in RT web interface other filed table 
in remote server is change.