Mantis: tracker goes offline and Source Integration misses commits

[Kunda1]

An aside: both Mantis and SI need updates:
https://mantisbt.org/blog/archives/mantisbt/658
https://github.com/mantisbt-plugins/sou ... tag/v2.3.1

[kkremitzki]

Would you be interested in me teaching you how to maintain Mantis? Now that it's on Digital Ocean we have a better automatic backup situation and more granular access control options.

[Kunda1]

Sure, that would be OK with me

[kkremitzki]

Just for starters here's the admin manual reference on the process for updates:

https://mantisbt.org/docs/master/en-US/ ... ll.upgrade

[kkremitzki]

You should now be able to SSH in to the machine running the tracker with ssh vagrant@tracker.lxd after SSHing into the server. Please feel free to attempt the upgrade and other maintenance and just announce things in advance.

Also, once you are in the tracker machine, if you do sudo -i to get a root shell and then ctrl-R to search through the history, then type sudo -u www-data you will find the command used to the source integration import. It needs to be ran in /var/www/tracker, so you can use that to add a cronjob to fix the issue with missing imports.

[Kunda1]

You should now be able to SSH in to the machine running the tracker

Sorry for the delay, I have a moment to do this and am attempting now

[openBrain]

JFYI, it seems Source Integration is totally at lost ATM. No commit has been correctly caught for weeks.

[Kunda1]

JFYI, it seems Source Integration is totally at lost ATM. No commit has been correctly caught for weeks.

Check again. Looks like @kkremitzki's instructions worked

Question though, can I use sudo in a bash 1 liner and run from cron ?

Also why does source integration need to be 'rebooted' ? Is there something we can do to avoid a cron script ? Also can i create a script that uses a conditional to check if Source Integration is down to 'reboot' it?

I'll ask on https://gitter.im/mantisbt-plugins/source-integration

[openBrain]

Check again. Looks like @kkremitzki's instructions worked

I saw one manually ran an update at 15:23 UTC. It added a big bunch of changes in the activity stack.
But this isn't a good way I guess if someone has to do it every hour.
You can chain some sudos using '&&' and eventually run this with cron.
But so it is not killed with your session, you have to run it with 'nohup' or inside a 'screen'. You can also create a cronjob (if server allows) which is probably the cleanest way.
Do you have a pointer to the commands you're using?

[Kunda1]

Do you have a pointer to the commands you're using?

Code: Select all

sudo -i
cd /var/www/tracker
sudo -u www-data php-cgi -f plugin.php page=Source/import id=all api_key=alphanumerickey

Should I add that in to a cronjob that runs every 30 minutes?

Code: Select all

* */2 * * * sudo -i && cd /var/www/tracker && sudo -u www-data php-cgi -f plugin.php page=Source/import id=all api_key=alphanumerickey

Should the cronjob be run from a root cron or the vagrant@ account cron ?