diff options
| -rw-r--r-- | README.txt | 19 | ||||
| -rw-r--r-- | templates/expedition.html | 2 | ||||
| -rw-r--r-- | urls.py | 1 |
3 files changed, 20 insertions, 2 deletions
@@ -241,6 +241,25 @@ $ sudo systemctl restart mysql.service $ sudo systemctl stop mysql.service $ sudo systemctl start mysql.service +While logged in at a terminal session as expo on expo.survex.,com + +$ mysql -h localhost -u expo -p<password> +will get you the MariasDb command prompt: https://www.hostwinds.com/guide/how-to-use-mysql-mariadb-from-command-line/ + +then: +>drop database troggle; +>create database troggle; +>quit +Somewhere I have notes for the GRANT PRIVS type runes... + +Ah yes: +CREATE DATABASE troggle; +GRANT ALL PRIVILEGES ON troggle.* TO 'expo'@'localhost' IDENTIFIED BY 'somepassword'; FLUSH PRIVILEGES; (at mysql root prompt) + +(explained on https://chartio.com/resources/tutorials/how-to-grant-all-privileges-on-a-database-in-mysql/) +(but you need to create the database too) + + Running a Troggle server ------------------------ For high volume use, Troggle should be run using a web server like apache. diff --git a/templates/expedition.html b/templates/expedition.html index 5a6f559..6c3e186 100644 --- a/templates/expedition.html +++ b/templates/expedition.html @@ -19,7 +19,7 @@ {% endifequal %} {% endfor %} </p> - +<p>See also the <a href="/years/{{expedition.year}}/">documentation index</a> for this Expo <p>Reparse and reload this year's logbook by clicking here: <a href="/expedition/{{expedition.year}}?reload">RELOAD</a> <p><b>At a single glance:</b> The table shows all expo cavers and their recorded trips. @@ -75,7 +75,6 @@ trogglepatterns = [ # url(r'^person/(?P<person_id>\d*)/?$', logbooks.person), url(r'^person/(?P<first_name>[A-Z]*[a-z\-\'&;]*)[^a-zA-Z]*(?P<last_name>[a-z\-\']*[^a-zA-Z]*[A-Z]*[a-z\-&;]*)/?', logbooks.person, name="person"), # url(r'^person/(\w+_\w+)$', logbooks.person, name="person"), -# url(r'^personform/(.*)$', personForm), url(r'^expedition/(\d+)$', logbooks.expedition, name="expedition"), url(r'^api/expeditions_tsv$', logbooks.Expeditions_tsvListView.as_view()), |