opencaching / deployment Goto Github PK

View Code? Open in Web Editor NEW

1.0 1.0 2.0 31 KB

Set of scripts and tools that allows you to deploy opencaching server. Also source code used for building DEVEL VM.

HCL 15.42% PHP 84.58%

deployment's People

Contributors

Stargazers

Watchers

Forkers

stefopl mzylowski

deployment's Issues

Find the best way for compressing VHD files

During packer run we using:

deployment/oc-devel.vbox.pkr.hcl

Lines 63 to 65 in 1a8ca7b

 post-processor "compress" { 

 output = "oc-devel.vhd.tar.gz" 

 compression_level = 9

We can consider changing this to shell command a call 7z or something.

Map is not working just after running freshly build of a VM

After running a fresh instance of VM build by packer map v3 is not working. After click on map in php error log I see many:

[Sat Jul 15 19:23:40.997640 2023] [php:notice] [pid 779] [client 192.168.56.1:49466] Division by zero, referer: http://local.opencaching.pl/MainMap/embeded

Exception is thrown from here: https://github.com/opencaching/okapi/blob/master/okapi/services/caches/map/TileTree.php#L307-L312

And due to some reasons is not correctly handled by code here:
https://github.com/opencaching/okapi/blob/master/okapi/services/caches/map/TileTree.php#L279-L284

This leads to errors on client side:

For 9.0-beta release I just started builded VM, changed all lat and lon that was == 0, left the VM for 1h and OKAPI finished building of tiles tree.
I don't think this is an option for next releases. We can:

deliver VM without OKAPI tiles tree generated (I believe this is what #9 will happen after anyway. Previous version of VM's also was delivered without those OKAPI data?)
improvements about OKAPI?
trigger somehow tiles tree rebuilding from ansible/packer run and deliver VM with already prepared tiles.

Documenting and executing mechanism to convert and import/update NUTS_LAYER data directly from official source

Documenting and executing mechanism to convert and import/update NATURA 2000 data directly from official source

From: https://github.com/opencaching/opencaching-pl/wiki/vm_requests

ocpl user for connecting to database instead of root

Problem with applying devel dump on fresh mysql db

@kojoty Did you tried apply dump generated by your script?
There is some problem with 'news' table:

Importing OC PL Devel Database Dump...
ERROR 1067 (42000) at line 3990: Invalid default value for 'date_publication'
ERROR 1146 (42S02) at line 4016: Table 'ocpl.news' doesn't exist
ERROR 1146 (42S02) at line 4017: Table 'ocpl.news' doesn't exist
ERROR 1146 (42S02) at line 4018: Table 'ocpl.news' doesn't exist
ERROR 1146 (42S02) at line 4019: Table 'ocpl.news' doesn't exist

https://travis-ci.org/opencaching/devel-dockerfiles/builds/316046321