Re: [rt-users] Database again stuck at SQLite?

2016-09-13 Thread Alex Hall
Just a quick update. I've now tried changing the port and database
username, then re-applying the settings with update-rt-siteconfig. They
change just fine. Yet, the error in the log is still regarding SQLite3,
even though the database type is very clearly set to mysql. I have no idea
why the setting is right, but RT refuses to use it. Please, if anyone knows
how to troubleshoot this or re-run the initial database setup, let me know.
Thanks.

On Tue, Sep 13, 2016 at 7:07 AM, Alex Hall  wrote:

> Hello all,
> I emailed last week asking a lot of questions, among them how to get my RT
> installation over to MySQL instead of SQLite3. Having moved to a company
> server, I'm again configuring RT, and I'm again stuck here. During the
> install, I accidentally hit enter at the database prompt rather than first
> hitting M. I figured I could change it later, so wasn't worried about it,
> especially as I'm now comfortable with how to update settings in RT.
>
> Yet, I can't seem to manage it. I've gone into 
> RT_SiteConfig.d51dbconfig-common
> and made the changes, then issued
> update-rt-siteconfig
> and gotten confirmation that my configuration file was replaced, but the
> log continues to show that RT is trying to connect to SQLite. I've also
> restarted the RT service, and there's no server to restart since this
> database error kills the FCGI server immediately after it spawns. I've even
> restarted Nginx, though it shouldn't make a difference. I know there's a
> command to re-run the database configuration wizard, but I can't find it
> anywhere.
>
> Two things, then. What's the command to re-configure the database
> settings, and why might changing them in RT_SiteConfig.d and then running
> update-rt-siteconfig not make the changes I want? Thanks!




-- 
Alex Hall
Automatic Distributors, IT department
ah...@autodist.com
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017

Re: [rt-users] Changing Text on RT Login Page

2016-09-13 Thread Matt Zagrabelny
On Mon, Sep 12, 2016 at 7:11 PM, Tim Gustafson  wrote:
> Hi,
>
> We just moved a bunch of users to an RT instance that uses LDAP
> authentication, as opposed to RT-specific passwords.  Some of our
> users don't read our announcement e-mails (imagine that...) and are
> trying to log in using their old RT-specific password, which is
> causing them to send e-mails asking why they can't log in.
>
> What's the "official" way to modify the login page's HTML to include
> some information about using their LDAP password?

Callbacks.

There are a couple of ways, callbacks and local overrides. Callbacks
are more flexible and allow upgrades to continue to occur without
impediment.

https://docs.bestpractical.com/rt/4.4.1/writing_extensions.html

In share/html/Elements/Login there are a few callbacks:

$ grep -i callback share/html/Elements/Login
% $m->callback( %ARGS, CallbackName => 'Header' );
% $m->callback( %ARGS, CallbackName => 'BeforeForm' );
%# Give callbacks a chance to add more control elements
% $m->callback( %ARGS );
% $m->callback( %ARGS, CallbackName => 'AfterForm' );

-m
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017


[rt-users] Database again stuck at SQLite?

2016-09-13 Thread Alex Hall
Hello all,
I emailed last week asking a lot of questions, among them how to get my RT 
installation over to MySQL instead of SQLite3. Having moved to a company 
server, I'm again configuring RT, and I'm again stuck here. During the install, 
I accidentally hit enter at the database prompt rather than first hitting M. I 
figured I could change it later, so wasn't worried about it, especially as I'm 
now comfortable with how to update settings in RT.

Yet, I can't seem to manage it. I've gone into RT_SiteConfig.d51dbconfig-common 
and made the changes, then issued
update-rt-siteconfig
and gotten confirmation that my configuration file was replaced, but the log 
continues to show that RT is trying to connect to SQLite. I've also restarted 
the RT service, and there's no server to restart since this database error 
kills the FCGI server immediately after it spawns. I've even restarted Nginx, 
though it shouldn't make a difference. I know there's a command to re-run the 
database configuration wizard, but I can't find it anywhere.

Two things, then. What's the command to re-configure the database settings, and 
why might changing them in RT_SiteConfig.d and then running 
update-rt-siteconfig not make the changes I want? Thanks!
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017