Migrate V2.2.17 on PostgreSQL to new server with V3.0 on Timescale-DB

[victor]

Yes, TimescaleDB could increase graphing speed. You have to experiment. If you have enough disk space you can do migration from one to another quite fast and check the difference.

Best regards,
Victor

[user54119]

i tried to compile netxms-3.0.2357 on openSUSE LEAP 15.1 but got error from configure 'cannot find pcre.h'.
Then installed package 'pcre-devel' (version 8.41) from package-manager (YaST), configure and get 'error: libpcre32 is requred'.Then downloaded  https://ftp.pcre.org/pub/pcre/pcre-8.43.tar.gz
./configure --prefix=/opt/pcre --disable-static --disable-dependency-tracking --enable-pcre16 --enable-pcre32 --disable-cpp --enable-utf --enable-unicode-properties --disable-stack-for-recursionmakemake installthen configure for NetXMS with option --with-pcre=/opt/pcre but got again 'error: libpcre32 is requred

[victor]

Please share your config.log.

Best regards,
Victor

[user54119]

here I have. Thanks Victor!

---

config.zip

[victor]

Very strange. Please show output of command

file /opt/pcre/lib/libpcre32.so*

and

ldd /opt/pcre/lib/libpcre32.so

Best regards,
Victor

[user54119]

netxms:~ # file /opt/pcre/lib/libpcre32.so*
/opt/pcre/lib/libpcre32.so*: cannot open `/opt/pcre/lib/libpcre32.so*' (No such file or directory)
netxms:~ # ldd /opt/pcre/lib/libpcre32.so
ldd: /opt/pcre/lib/libpcre32.so: No such file or directory

[victor]

That means that libpcre was not properly built or installed. Are you sure that there were no compiltation or installation errors? What files are present in /opt/pcre/lib?

Best regards,
Victor

[user54119]

Thanks for your help Victor. Bu t I didnt's saw errors. Here all output of configure, make, make install: Maybee you see some problems in it.

---

pcre-build-output.txt

[Tursiops]

Looks like compiling PCRE installed the libraries in /opt/pcre/lib64, while NetXMS is looking in /opt/pcre/lib.
Not sure if it would be enough to create a symbolic link lib64 -> lib?

[user54119]

I didn't knew NetXMS is looking in /opt/pcre/lib. Made a symlink and compiling NetXMS is fine now. I'm a step forward, thanks 

[victor]

This looks like a bug in configure script - it is made with assumption that library files always installed under PCRE prefix /lib. Seems to not be the case on SUSE. I'll update configure script.

Best regards,
Victor