Problem migrating auth to postgresql

User avatar
Neoniet
New member
 
Posts: 5
Joined: Mon Jul 16, 2018 17:54
In-game: Neoniet

Problem migrating auth to postgresql

by Neoniet » Thu Jan 02, 2020 15:15

I am migrating my server backend to postgresql.

I migrated correctly blocks:
Code: Select all
$ bin/minetestserver --migrate postgresql --world /home/neoniet/server/worlds/world
 Migrated 491130 blocks, 98.7984% completed.
2020-01-02 14:36:23: ACTION[Main]: Successfully migrated 497103 blocks
2020-01-02 14:36:23: ACTION[Main]: world.mt updated


and player:

Code: Select all
$ bin/minetestserver --migrate-players postgresql --world /home/neoniet/server/worlds/world
2020-01-02 14:37:44: ACTION[Main]: Migrating player Hunter
2020-01-02 14:37:44: ACTION[Main]: Migrating player Neoniet
2020-01-02 14:37:44: ACTION[Main]: Migrating player luisito
2020-01-02 14:37:44: ACTION[Main]: Successfully migrated 3 players
2020-01-02 14:37:44: ACTION[Main]: world.mt updated


but to migrated auth giveme a error:
Code: Select all
$ bin/minetestserver --migrate-auth postgresql --world /home/neoniet/server/worlds/world
2020-01-02 14:38:11: ERROR[Main]: An error occurred during migration: Database backend postgresql not supported.


I have compiled with these cmake options:

Code: Select all
cmake .. -DRUN_IN_PLACE=true -DBUILD_CLIENT=false -DENABLE_POSTGRESQL=ON -DENABLE_FREETYPE=ON -DENABLE_SYSTEM_GMP=ON -DCMAKE_BUILD_TYPE=Release -DENABLE_CURSES=ON -DENABLE_GETTEXT=ON-- The C compiler identification is GNU 8.3.0
-- The CXX compiler identification is GNU 8.3.0
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- *** Will build version 5.1.0 ***
-- Found Irrlicht: /usr/lib/x86_64-linux-gnu/libIrrlicht.so 
-- Using GMP provided by system.
-- Found GMP: /usr/lib/x86_64-linux-gnu/libgmp.so 
-- Using bundled JSONCPP library.
-- Found LuaJit: /usr/lib/x86_64-linux-gnu/libluajit-5.1.so (found version "")
-- Using LuaJIT provided by system.
CMake Warning at src/CMakeLists.txt:32 (message):
  Neither BUILD_CLIENT nor BUILD_SERVER is set! Setting BUILD_SERVER=true


-- Found CURL: /usr/lib/x86_64-linux-gnu/libcurl.so 
-- cURL support enabled.
-- Found GetText: /usr/include 
-- GetText enabled; locales found: be;ca;cs;da;de;dv;el;eo;es;et;fil;fr;he;hu;id;it;ja;ja_KS;jbo;kk;kn;ko;ky;lo;lt;ms;my;nb;nl;nn;pl;pt;pt_BR;ro;ru;sl;sr_Cyrl;sv;sw;th;tr;uk;vi;zh_CN;zh_TW
-- Found Freetype: /usr/lib/x86_64-linux-gnu/libfreetype.so (found version "2.9.1")
-- Freetype enabled.
-- Looking for cbreak in /usr/lib/x86_64-linux-gnu/libncursesw.so
-- Looking for cbreak in /usr/lib/x86_64-linux-gnu/libncursesw.so - found
-- Found Ncursesw: /usr/lib/x86_64-linux-gnu/libncursesw.so 
-- ncurses console enabled.
-- Found PostgreSQL: /usr/lib/x86_64-linux-gnu/libpq.so (found version "11.5 (Debian 11.5-1+deb10u1)")
-- PostgreSQL backend enabled
-- PostgreSQL includes: /usr/include/postgresql;/usr/include/postgresql/11/server
-- LevelDB not found!
-- Redis not found!
-- Found SQLite3: /usr/lib/x86_64-linux-gnu/libsqlite3.so 
-- SpatialIndex not found!
-- Found ZLIB: /usr/lib/x86_64-linux-gnu/libz.so (found version "1.2.11")
-- Looking for clock_gettime in rt
-- Looking for clock_gettime in rt - found
-- Looking for include file endian.h
-- Looking for include file endian.h - found
-- Locale blacklist applied; Locales used: ca;cs;da;de;dv;el;eo;es;et;fil;fr;hu;id;it;ja;ja_KS;jbo;kk;kn;lo;lt;ms;my;nb;nl;nn;pl;pt;pt_BR;ro;ru;sl;sr_Cyrl;sv;sw;th;tr;uk;vi
-- Could NOT find Doxygen (missing: DOXYGEN_EXECUTABLE)
-- Configuring done
-- Generating done
-- Build files have been written to: /home/neoniet/minetest/bin


What is the problem?
 

User avatar
sfan5
Moderator
 
Posts: 3847
Joined: Wed Aug 24, 2011 09:44
Location: Germany
GitHub: sfan5
IRC: sfan5

Re: Problem migrating auth to postgresql

by sfan5 » Thu Jan 02, 2020 22:51

As seen on the wiki page using Postgres for auth storage is currently not possible.
Mods: Mesecons | WorldEdit | Nuke & Minetest builds for Windows (32-bit & 64-bit)
 

User avatar
Neoniet
New member
 
Posts: 5
Joined: Mon Jul 16, 2018 17:54
In-game: Neoniet
 


Return to Problems



Who is online

Users browsing this forum: MSN [Bot], v-rob and 12 guests