MySQL not installable [solved but still problems to access database] [Solved]

[mash]

Hi, I need to access a mySQL-DB on another machine (server).
I tried to install mySQL from the deb file provided at https://dev.mysql.com/downloads/file/?id=536087
But ended up with errors:

Code: Select all

Warning: unable to close filehandle $dc2hp_writefh properly: Broken pipe during global destruction.
dpkg: error processing package mysql-apt-config (--configure):
 installed mysql-apt-config package post-installation script subprocess returned error exit status 128
Errors were encountered while processing:
 mysql-apt-config

So I tried to install MariaDB. But the installation failed as well with the same error regarding "mysql-apt-config"
Any ideas what to do to get a mySQL client running?
The MX Linux was installed freshly five days ago - so I don't think it's a problem with other installed programs
Thanks in Advance

[chrispop99]

Welcome to the forum.

You have asked this question on the Facebook group, and two people there are still trying to help you.

Posting in both places ties up resources that could be better used for other things; please wait until all possibilities are exhausted in one place before asking in the other.

Chris

[Stevo]

You may also try booting MX with systemd, since many of these third-party programs assume you're using it and won't run without it. "Mysql-apt-config" seems to be from the third-party deb, and is interfering with mariadb, so cleaning that out first would be a priority.

[siamhie]

Post your QSI (Quick System Information) found in the MX Tools menu.

[baldyeti]

Hi, I need to access a mySQL-DB on another machine (server).

Then a client package should suffice, say default-mysql-client (which apparently pulls mariadb-client on bookworm)

[mash]

You may also try booting MX with systemd, since many of these third-party programs assume you're using it and won't run without it. "Mysql-apt-config" seems to be from the third-party deb, and is interfering with mariadb, so cleaning that out first would be a priority.

Ho do I boot mx with systemd? [edit> found it but couldn't find how to delete this message]

[baldyeti]

At the boot menu, select the "Advanced Options" entry. You'll get a sub-menu with systemd and sysVinit options.

[mash]

Post your QSI (Quick System Information) found in the MX Tools menu.

Code: Select all

System:
  Kernel: 6.1.0-30-amd64 [6.1.124-1] arch: x86_64 bits: 64 compiler: gcc v: 12.2.0
    parameters: BOOT_IMAGE=/vmlinuz-6.1.0-30-amd64 root=UUID=<filter> ro quiet splash
    resume=UUID=<filter> resume_offset=25765888 init=/lib/systemd/systemd
  Desktop: KDE Plasma v: 5.27.5 wm: kwin_x11 vt: 7 dm: SDDM Distro: MX-23.5_KDE_x64 Libretto Jan
    12 2025 base: Debian GNU/Linux 12 (bookworm)
Machine:
  Type: Laptop System: Acer product: NG-VN7-791G-712T v: V1.14 serial: <superuser required>
  Mobo: Acer model: NG-VN7-791G-712T v: V1.14 serial: <superuser required> UEFI: Insyde v: 1.14
    date: 08/06/2015
Battery:
  ID-1: BAT0 charge: 41.9 Wh (96.1%) condition: 43.6/51.0 Wh (85.5%) volts: 12.8 min: 11.4
    model: LGC AC14A8L type: Li-ion serial: <filter> status: not charging
CPU:
  Info: model: Intel Core i7-4720HQ bits: 64 type: MT MCP arch: Haswell gen: core 4 level: v3
    note: check built: 2013-15 process: Intel 22nm family: 6 model-id: 0x3C (60) stepping: 3
    microcode: 0x28
  Topology: cpus: 1x cores: 4 tpc: 2 threads: 8 smt: enabled cache: L1: 256 KiB
    desc: d-4x32 KiB; i-4x32 KiB L2: 1024 KiB desc: 4x256 KiB L3: 6 MiB desc: 1x6 MiB
  Speed (MHz): avg: 1327 high: 1754 min/max: 800/3600 scaling: driver: intel_cpufreq
    governor: ondemand cores: 1: 1623 2: 900 3: 1100 4: 1197 5: 1268 6: 1233 7: 1754 8: 1543
    bogomips: 41502
  Flags: avx avx2 ht lm nx pae sse sse2 sse3 sse4_1 sse4_2 ssse3 vmx
  Vulnerabilities:
  Type: gather_data_sampling status: Not affected
  Type: itlb_multihit status: KVM: VMX disabled
  Type: l1tf mitigation: PTE Inversion; VMX: conditional cache flushes, SMT vulnerable
  Type: mds mitigation: Clear CPU buffers; SMT vulnerable
  Type: meltdown mitigation: PTI
  Type: mmio_stale_data status: Unknown: No mitigations
  Type: reg_file_data_sampling status: Not affected
  Type: retbleed status: Not affected
  Type: spec_rstack_overflow status: Not affected
  Type: spec_store_bypass mitigation: Speculative Store Bypass disabled via prctl
  Type: spectre_v1 mitigation: usercopy/swapgs barriers and __user pointer sanitization
  Type: spectre_v2 mitigation: Retpolines; IBPB: conditional; IBRS_FW; STIBP: conditional; RSB
    filling; PBRSB-eIBRS: Not affected; BHI: Not affected
  Type: srbds mitigation: Microcode
  Type: tsx_async_abort status: Not affected
Graphics:
  Device-1: Intel 4th Gen Core Processor Integrated Graphics vendor: Acer Incorporated ALI
    driver: i915 v: kernel arch: Gen-7.5 process: Intel 22nm built: 2013 ports: active: eDP-1
    empty: HDMI-A-1 bus-ID: 00:02.0 chip-ID: 8086:0416 class-ID: 0300
  Device-2: NVIDIA GM107M [GeForce GTX 860M] vendor: Acer Incorporated ALI driver: N/A
    alternate: nouveau non-free: 530.xx+ status: current (as of 2023-03) arch: Maxwell code: GMxxx
    process: TSMC 28nm built: 2014-19 pcie: gen: 3 speed: 8 GT/s lanes: 16 bus-ID: 01:00.0
    chip-ID: 10de:1392 class-ID: 0302
  Device-3: Sunplus Innovation Laptop Integrated WebCam HD type: USB driver: uvcvideo
    bus-ID: 3-9:8 chip-ID: 1bcf:2c6e class-ID: 0e02
  Display: x11 server: X.Org v: 1.21.1.7 with: Xwayland v: 22.1.9 compositor: kwin_x11 driver: X:
    loaded: modesetting unloaded: fbdev,vesa dri: crocus gpu: i915 display-ID: :0 screens: 1
  Screen-1: 0 s-res: 1920x1080 s-dpi: 96 s-size: 508x285mm (20.00x11.22") s-diag: 582mm (22.93")
  Monitor-1: eDP-1 model: LG Display 0x0469 built: 2014 res: 1920x1080 hz: 60 dpi: 128 gamma: 1.2
    size: 382x215mm (15.04x8.46") diag: 438mm (17.3") ratio: 16:9 modes: 1920x1080
  API: OpenGL v: 4.6 Mesa 24.2.2-1~mx23ahs renderer: Mesa Intel HD Graphics 4600 (HSW GT2)
    direct-render: Yes
Audio:
  Device-1: Intel Xeon E3-1200 v3/4th Gen Core Processor HD Audio vendor: Acer Incorporated ALI
    driver: snd_hda_intel bus-ID: 3-1.1.4:9 v: kernel chip-ID: 0b0e:0300 bus-ID: 00:03.0
    class-ID: 0300 chip-ID: 8086:0c0c class-ID: 0403 serial: <filter>
  Device-2: Intel 8 Series/C220 Series High Definition Audio vendor: Acer Incorporated ALI 8
    driver: snd_hda_intel v: kernel bus-ID: 00:1b.0 chip-ID: 8086:8c20 class-ID: 0403
  Device-3: GN Netcom Jabra EVOLVE 20 MS type: USB driver: jabra,snd-usb-audio,usbhid
  API: ALSA v: k6.1.0-30-amd64 status: kernel-api tools: alsamixer,amixer
  Server-1: PipeWire v: 1.0.0 status: active with: 1: pipewire-pulse status: active
    2: wireplumber status: active 3: pipewire-alsa type: plugin 4: pw-jack type: plugin
    tools: pactl,pw-cat,pw-cli,wpctl
Network:
  Device-1: Qualcomm Atheros QCA6174 802.11ac Wireless Network Adapter vendor: Lite-On
    driver: ath10k_pci v: kernel modules: wl pcie: gen: 1 speed: 2.5 GT/s lanes: 1 bus-ID: 07:00.0
    chip-ID: 168c:003e class-ID: 0280
  IF: wlan0 state: up mac: <filter>
  Device-2: Broadcom NetLink BCM57780 Gigabit Ethernet PCIe vendor: Acer Incorporated ALI
    driver: tg3 v: kernel pcie: gen: 1 speed: 2.5 GT/s lanes: 1 port: N/A bus-ID: 08:00.0
    chip-ID: 14e4:1692 class-ID: 0200
  IF: eth0 state: down mac: <filter>
Bluetooth:
  Device-1: Lite-On type: USB driver: btusb v: 0.8 bus-ID: 3-10:10 chip-ID: 04ca:3011
    class-ID: e001
  Report: hciconfig ID: hci0 rfk-id: 4 state: up address: <filter> bt-v: 2.1 lmp-v: 4.1
    sub-v: 25a hci-v: 4.1
  Info: acl-mtu: 1024:8 sco-mtu: 50:8 link-policy: rswitch hold sniff
    link-mode: peripheral accept service-classes: rendering, capturing, object transfer, audio,
    telephony
Drives:
  Local Storage: total: 2.05 TiB used: 1.08 TiB (52.4%)
  SMART Message: Unable to run smartctl. Root privileges required.
  ID-1: /dev/sda maj-min: 8:0 vendor: Kingston model: RBU-SNS8100S3256GD size: 238.47 GiB
    block-size: physical: 512 B logical: 512 B speed: 6.0 Gb/s type: SSD serial: <filter> rev: 06.9
    scheme: GPT
  ID-2: /dev/sdb maj-min: 8:16 vendor: Samsung model: ST2000LM003 HN-M201RAD size: 1.82 TiB
    block-size: physical: 4096 B logical: 512 B speed: 6.0 Gb/s type: HDD rpm: 5400 serial: <filter>
    rev: 0001 scheme: GPT
Partition:
  ID-1: / raw-size: 110.33 GiB size: 108.04 GiB (97.92%) used: 31.31 GiB (29.0%) fs: ext4
    dev: /dev/sda5 maj-min: 8:5
  ID-2: /boot raw-size: 266 MiB size: 239.3 MiB (89.96%) used: 103.4 MiB (43.2%) fs: ext4
    dev: /dev/sda6 maj-min: 8:6
  ID-3: /boot/efi raw-size: 100 MiB size: 96 MiB (96.00%) used: 24.5 MiB (25.5%) fs: vfat
    dev: /dev/sda2 maj-min: 8:2
  ID-4: /home raw-size: 48.8 GiB size: 47.74 GiB (97.81%) used: 38.58 GiB (80.8%) fs: ext4
    dev: /dev/sdb4 maj-min: 8:20
Swap:
  Kernel: swappiness: 15 (default 60) cache-pressure: 100 (default)
  ID-1: swap-1 type: file size: 19.54 GiB used: 0 KiB (0.0%) priority: -2 file: /swap/swap
Sensors:
  System Temperatures: cpu: 68.0 C mobo: N/A
  Fan Speeds (RPM): N/A
Repos:
  Packages: pm: dpkg pkgs: 2617 libs: 1403 tools: apt,apt-get,aptitude,nala pm: rpm pkgs: 0
    pm: flatpak pkgs: 0
  No active apt repos in: /etc/apt/sources.list
  Active apt repos in: /etc/apt/sources.list.d/debian-stable-updates.list
    1: deb http://deb.debian.org/debian bookworm-updates main contrib non-free non-free-firmware
  Active apt repos in: /etc/apt/sources.list.d/debian.list
    1: deb http://deb.debian.org/debian bookworm main contrib non-free non-free-firmware
    2: deb http://security.debian.org/debian-security bookworm-security main contrib non-free non-free-firmware
  Active apt repos in: /etc/apt/sources.list.d/mx.list
    1: deb http://ftp.cica.es/mirrors/Linux/MX-Packages/mx/repo/ bookworm main non-free
    2: deb http://ftp.cica.es/mirrors/Linux/MX-Packages/mx/repo/ bookworm ahs
  Active apt repos in: /etc/apt/sources.list.d/opera-developer.list
    1: deb https://deb.opera.com/opera-developer/ stable non-free
Info:
  Processes: 306 Uptime: 1h 40m wakeups: 4 Memory: 15.54 GiB used: 6.85 GiB (44.1%) Init: systemd
  v: 252 target: graphical (5) default: graphical tool: systemctl Compilers: gcc: 12.2.0 alt: 12
  Client: shell wrapper v: 5.2.15-release inxi: 3.3.26
Boot Mode: UEFI

[mash]

Ok, I now have mysql installed and can run it from command line (after additional apt install mariadb-client-core).
Unfortunately I want to access the database from a program that I have written and that worked with other Linux flavors and on a windows machine.
The program is written in lazarus and complains not being able to find libmysqlclient.so (in /usr/lib/)
I tried to link libmariadb.so to the destination but to no avail because now my program is confused with de unexpected version number.
IIRC I used to install also mysql-dev but this package is not available. Any idea please how to obtain the correct libmysqlclient.so?

[mash]

The solution was to install libmariadb-dev

apt install libmariadb-dev

Set a symlink to the missing libmysqlclient

ln /usr/lib/x86_64-linux-gnu/libmariadb.so.3 /usr/lib/libmysqlclient.so

Change the property of TMySQL57connection SkipLibraryVersionCheck := true;
--
The latter one is the Component that connects to the database libs and it finds other version values with MariaDB than the expected mysql/values