I would suggest that the regression tests should not run on the "normal" postgres instance anyway. They should be running against a "clean" ephemeral instance that is created by the test suite, and torn down afterwards.
I was able to build on Windows using msys2 but I still cannot run the tests which run both on Linux and MacOS.
ellevset
@ellevset
Gents, I was trying to install MobiliyDB on a fresh (minimal) Centos 8 install, but I am stuck at it not finding lwgeom, however I have installed the required packages and I am able to find the lwgeom.h file in /usr/include. Is this the right place to ask for some assistance on that?
Brad Hards
@bradh
@ellevset I don't think Gents is entirely appropriate.
What does the configure log show is actually failing?
ellevset
@ellevset
Noted on the Gents-part. When I run cmake I get: CMake Error at CmakeLists.txt: 158 (message): Could not find lwgeom;
Brad Hards
@bradh
I meant in the build/CMakeFiles/CMakeOutput.log (which probably appears just below that message, with a full path).
ellevset
@ellevset
I am not sure what to look for, that file doesn't indicate any errors at all. lwgeom is not mentioned. It ends with 'implicit fwks: []'
Vicky Vergara
@cvvergara
did you install lwgeom?
ellevset
@ellevset
I believe so, as far as I understand liblwgeom was installed with postgis, I have a file /usr/include/liblwgeom.h. dnf tells me that file was installed with postgis25-devel
Nope, still no luck. I am stranded at the same error message, that it can't find lwgeom.
Brad Hards
@bradh
@ellevset To get going, consider adding symlinks for the required files to whatever your library search path contains.
ellevset
@ellevset
@bradh That worked like a charm. However this raises a question. it seems that cmake can use files in /usr/pgsql-12/include folder, but not /usr/pgsql-12/lib. Is that intentional?
ellevset
@ellevset
almost there, got to the last point and then: ERROR: could not load library "/usr/pgsql-12/lib/libMobilityDB.so": /usr/pgsql-12/lib/libMobilityDB.so: undefined symbol: lwgeom_hash
Vicky Vergara
@cvvergara
I get that error when postgis with another version is installed
Normally when I try mobilitydb I remove postgis and install only postgis 2.5
when I go back to my normal work I remove postgis 2.5 install the latest version of postgis and do what I need to do
I will be very busy from now to the 3rd of october, but we can meet after that. I have a new computer and I havent tried mobilitydb on it, so its like starting from scratch. And we can work it out together.
Brad Hards
@bradh
@ellevset send a pull request if you think it could be improved.
I have no idea if it was intended - I didn't write it. Just trying to help you get going.
ellevset
@ellevset
I have no other postgis to uninstall. I gave up compiling and used docker. Seems to be working swimmingly. Thanks a lot for you assistance everyone.
tituskibiwott
@tituskibiwott
Hi there ,thanks for this beatiful piece of software. So i was getting this error while calling mobility db functions "/usr/lib/postgresql/12/lib/libMobilityDB-1.0.so": /usr/lib/postgresql/12/lib/libMobilityDB-1.0.so: undefined symbol: ST_Distance.
tituskibiwott
@tituskibiwott
This lead me to compile and recompile to no avail.However,I noticed this appeared only on db clients such as psql,dbeaver,php pdo and psycopg but not qgis. Guess what running a postgis function such as st_astext or even select postgis_full_version() before using mobilitydb functions solves this problem. This works for me, tested on pg12 and pg13 with postgis 3.1
tituskibiwott
@tituskibiwott
also works on pg11 with postgis 2.5
Maxim Van de Wynckel
@Maximvdw
is MobilityDB planning to participate at FOSDEM22?
I'd however recommend that you use our 'still in development' QGIS plugin MOVE, which allows you to query MobilityDB directly in QGIS, and get animated visualizations of the result. The plugin automates the casting, and python code (plus a couple of optimizations): https://github.com/mschoema/move