2022-02-03
The problem: latest java required TLS 1.2
Solution 1: edit java config to allow TLS1.1
issue: everytime we update java we would need to fix the java config
Solution 2: roll my own
failed miserably
Solution 3: install maridb to kubernetes
kmysql.homlish.net 10.11.168.244
had to connect to the pod to create users
CREATE USER ‘phomlish’@’%’ IDENTIFIED BY ‘****’;
GRANT ALL PRIVILEGES ON * . * TO ‘phomlish’@’%’;
FLUSH PRIVILEGES;
Solution 2:
2022-02-03 04:10:25,026 ERROR n.h.j.d.DbConnection2 [main] 87 ~ Error setting up jukebox db: java.sql.SQLException: Wrong mariaDB url:
jdbc:mariadb//mysql.homlish.net:3306/music?user=jukebox&password=sg7b1OFXF7dnUpB58iD2&useSsl=true&trustServerCertificate=true&serverTimezone=America/New_York
jdbc:mariadb//mysql.homlish.net:3306/music?user=jukebox&password=sg7b1OFXF7dnUpB58iD2
jdbc:mysql://localhost:3306/db?user=someUser&disableMariaDbDriver
sudo apt install build-essential libboost-system-dev libboost-thread-dev libboost-program-options-dev libboost-test-dev
sudo apt-get install cmake libblkid-dev e2fslibs-dev libboost-all-dev libaudit-dev
cmake ../server -LH
pkgcfg_lib__OPENSSL_ssl:FILEPATH=/usr/lib/x86_64-linux-gnu/libssl.so
pkgcfg_lib__OPENSSL_crypto:FILEPATH=/usr/lib/x86_64-linux-gnu/libcrypto.so
/opt/openssl/lib/libssl.so
/opt/openssl/lib/libssl.so.1.1
/opt/openssl/lib/libcrypto.so
/opt/openssl/lib/libcrypto.so.1.1
pkgcfg_lib__OPENSSL_ssl:FILEPATH=/opt/openssl/lib/libssl.so
pkgcfg_lib__OPENSSL_crypto:FILEPATH=/opt/openssl/lib/libcrypto.so
readelf -a libmariadb/libmariadb/libmariadb.so.3
git clean -xffd && git submodule foreach –recursive git clean -xffd
cmake . -DNOT_FOR_DISTRIBUTION=ON -DPLUGIN_AUTH_PAM=NO \
-DOPENSSL_ROOT_DIR=/opt/openssl \
-DINSTALL_PREFIX:PATH=/opt/mariadb \
-DBUILD_CONFIG=mysql_release && make -j8
cmake –build .
root@a0:/usr/src2/a0/mariadb# ldd sql/mariadbd
linux-vdso.so.1 (0x00007fff2239f000)
libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f98d1b3b000)
liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007f98d1b13000)
libaio.so.1 => /lib/x86_64-linux-gnu/libaio.so.1 (0x00007f98d1b0e000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f98d1aed000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f98d1ae8000)
libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f98d1964000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f98d17df000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f98d161e000)
/lib64/ld-linux-x86-64.so.2 (0x00007f98d3d7d000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f98d1604000)