Demo server

The demo sites will be refreshed every hour and pull in the latest master branch.

Refresh manually

To refresh the demo sites, login as the deploy user then run the update command:

/var/www/internet.openpolice.be/scripts/demo/internet.php reinstall

Problems?

In case of problems, you can restart the services by logging in as admin and then restarting mysql, php and nginx with:

service nginx restart
service php5-fpm restart
service mysql restart

Important notes

When you are updating the intranet-platform repository and have replaced the install/custom/views.sql dump, make sure to put in the correct user name for these operations! If you are working locally on your database as the root user, and export these views, they will look as follows:

CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `jos_news_view_activities`

You want to make sure to replace the username with demo - otherwise it will not work anymore on the demo server!

CREATE ALGORITHM=MERGE DEFINER=`demo`@`localhost` SQL SECURITY DEFINER VIEW `jos_news_view_activities`