
<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div><div style="direction: inherit;">Okay, that makes more sense. Now I'm back to my FCGI problem: the process spawns, but netstat shows nothing on the address:port I assign when using the command. I can't kill or restart it because it doesn't seem to exist, though I get a success message and can't spawn a new process on that port until I restart Nginx. Confusing! Yes, this is on a fresh Debian server with nothing but RT, Nginx, Fast-CGI, and supporting libraries installed. </div><br>Sent from my iPhone</div><div><br>On Aug 30, 2016, at 09:38, Jim Brandt <<a href="mailto:jbrandt@bestpractical.com">jbrandt@bestpractical.com</a>> wrote:<br><br></div><blockquote type="cite"><div><span></span><br><span></span><br><span>On 8/30/16 9:22 AM, Alex Hall wrote:</span><br><blockquote type="cite"><span>So doing</span><br></blockquote><blockquote type="cite"><span>/etc/init.d/nginx restart</span><br></blockquote><blockquote type="cite"><span>is enough to reload RT's configuration as well? Great, that makes things</span><br></blockquote><blockquote type="cite"><span>easier. It seems odd, since I thought Nginx (or whatever your server)</span><br></blockquote><blockquote type="cite"><span>was separate from RT and needed the middleware of a FastCGI or similar</span><br></blockquote><blockquote type="cite"><span>process to let the two talk. I'm glad I was wrong. :)</span><br></blockquote><span></span><br><span>Sorry, I was too vague in saying "the server". In a FCGI and nginx deployment, nginx doesn't manage FCGI directly, so you'll need to restart the FCGI processes. So your understanding was correct for the nginx configuration. With Apache and FCGI, Apache manages the FCGI processes, so restarting Apache does both.</span><br><span></span><br><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>During the initial setup, I thought I specified the right database</span><br></blockquote><blockquote type="cite"><span>engine, but I must have done something wrong. I've set it in the config</span><br></blockquote><blockquote type="cite"><span>file and it *should* be working now.</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>Last I tried, it was still complaining about the SQLite3 not loading,</span><br></blockquote><blockquote type="cite"><span>but perhaps I didn't restart the server after that latest change. I'm</span><br></blockquote><blockquote type="cite"><span>away for a couple days, but when I get back to my desk I'll try it all</span><br></blockquote><blockquote type="cite"><span>again.</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>Sent from my iPhone</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>On Aug 30, 2016, at 08:45, Jim Brandt <<a href="mailto:jbrandt@bestpractical.com">jbrandt@bestpractical.com</a></span><br></blockquote><blockquote type="cite"><span><<a href="mailto:jbrandt@bestpractical.com">mailto:jbrandt@bestpractical.com</a>>> wrote:</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><blockquote type="cite"><span>Restarting the server should reload the configuration. To confirm what</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>configuration RT has loaded, you can check the System Configuration</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>page at Admin > Tools > System Configuration. There you can check</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>DatabaseType, DatabaseHost, and other Database configuration. If it's</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>not what you expect, it could be RT is loading some configuration from</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>some other location. You can see the config files in the "Loaded</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>config files" section on that same page.</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span></span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>You set these in RT_Config.pm by selecting different options when</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>running the initial configure script. After that, you can override in</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>RT_SiteConfig.pm.</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span></span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>On 8/29/16 2:27 PM, Alex Hall wrote:</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>Hello list,</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>Until I can find out why FCGI processes don't work, I'm trying to run RT</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>on its own server with:</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>sudo /usr/share/request-tracker4/libexec/rt-server --port 8485</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>but I get an error about SQLite3 not working. The thing is, I have it</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>set to MySQL, not SQLite, so I don't know why it's not using MySQL. I</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>made a change to /etc/request-tracker4/RT_SiteConfig.pm, and the same to</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>RT_SiteConfig.d/51-DBConfig, but it didn't help. I tried</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>sudo /etc/init.d/request-tracker4 restart</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>to get the change to register, but had no luck. What do I have to do to</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>get RT to see configuration changes? This seems like a simple thing, but</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>I can't find it online, and the restart doesn't seem to have helped. If</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>there's something obvious I've missed in my DB setup that would cause it</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>to use the wrong backend, I'd love to know that as well. RT4.2.8 on</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>Debian 8. Thanks.</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span></span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>--</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>Alex Hall</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>Automatic Distributors, IT department</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span><a href="mailto:ahall@autodist.com">ahall@autodist.com</a> <<a href="mailto:ahall@autodist.com">mailto:ahall@autodist.com</a>></span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span><<a href="mailto:ahall@autodist.com">mailto:ahall@autodist.com</a>></span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span></span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span></span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>---------</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>RT 4.4 and RTIR training sessions, and a new workshop day!</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span><a href="https://bestpractical.com/training">https://bestpractical.com/training</a></span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>* Boston - October 24-26</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span>* Los Angeles - Q1 2017</span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><span></span><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>---------</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>RT 4.4 and RTIR training sessions, and a new workshop day!</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span><a href="https://bestpractical.com/training">https://bestpractical.com/training</a></span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>* Boston - October 24-26</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>* Los Angeles - Q1 2017</span><br></blockquote></blockquote></div></blockquote></body></html>