Skip to content

Zabbix: Required parameter $sql_parts follows optional parameter $table_alias

We are running our monitoring solution zabbix on an arch linux system. Arch linux tends to be "up to date" since it philosophie is "patch current code base, not legacy".

I've updated the monitoring system and with that, the php version jumped from 7.4.x to 8.0.x.

After that, a lot of "widgets" (boxes) in the zabbix frontend displayed me a lot of the following error.

Required parameter $sql_parts follows optional parameter $table_alias [zabbix.php:22 → require_once() → ZBase->run() → CSettingsHelper::getGlobal() → CSettingsHelper::loadParams() → API::getApiService() → CRegistryFactory->getObject() → CApiService->__construct() → CApiService->pk() → CApiService->getTableSchema() → CAutoloader->loadClass() → require() in include/classes/core/CAutoloader.php:77]

I've researched it and found that the error exists in the DB.php class. I've opened the issue Ticket ZBX-18984 and created the pull request 39 on the github source code. Hopefully, this fix will make it quickly into the code. I've added a git patch file to the issue. You can download and apply it on your system.

It just happens on my Rasperry pi: signature from "Arch Linux ARM Build System <builder@archlinuxarm.org>" is unknown trust

I've started a regular update by using sudo pacman -Syyu and the following lines where the final result.

warning: Public keyring not found; have you run 'pacman-key --init'?
downloading required keys...
error: key "77193F152BDBE6A6" could not be looked up remotely
error: required key missing from keyring
error: failed to commit transaction (unexpected error)
Errors occurred, no packages were upgraded.

I did what was told me to do ;-).

sudo pacman-key --init

And after running sudo pacman -Syyu I was asked.

:: Import PGP key 4096R/68B3537F39A313B3E574D06777193F152BDBE6A6, "Arch Linux ARM Build System <builder@archlinuxarm.org>", created: 2014-01-18? [Y/n]

"As expected, I though" but than I got a long list of the error mention in the headline (for each package).

I've fixed this by executing the following command.

pacman-key --lsign-key 77193F152BDBE6A6

After that, sudo pacman -Syyu was running fine as expected. Strange note, all was working fine a week ago (2018-05-25) and the pgp key was created 2014 :O.

JDownloader and spontaneous core dump

JDownloader was working properly and than you just get core dumps all over again? Best try, upgrade your Java Runtime Environment.

sudo archlinux-java status
sudo pacman -S jre9-openjdk
sudo archlinux-java set jre9-openjdk
#if not needed anymore
sudo pacman -R jre8-openjdk

You need to update the $PATH variable. Either you restart your system or you open a new terminal to start JDownloader from their. All should work fine now.

phpstorm linux - java.lang.UnsatisfiedLinkError: /usr/lib/jvm/java-7-openjdk/jre/lib/amd64/libsplashscreen.so: libgif.so.6: cannot open shared object file: No such file or directory

Just got the following exception thrown while i updated/installed phpstorm on a fresh installed arch linux.

java.lang.UnsatisfiedLinkError: /usr/lib/jvm/java-7-openjdk/jre/lib/amd64/libsplashscreen.so: libgif.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1965)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1890)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1872)
at java.lang.Runtime.loadLibrary0(Runtime.java:849)
at java.lang.System.loadLibrary(System.java:1088)
at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:67)
at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:47)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.SplashScreen.getSplashScreen(SplashScreen.java:121)
at com.intellij.idea.IdeaApplication$IdeStarter.a(IdeaApplication.java:218)
at com.intellij.idea.IdeaApplication$IdeStarter.a(IdeaApplication.java:195)
at com.intellij.idea.IdeaApplication$IdeStarter.access$000(IdeaApplication.java:178)
at com.intellij.idea.IdeaApplication.(IdeaApplication.java:97)
at com.intellij.idea.IdeaUltimateApplication.(IdeaUltimateApplication.java:16)
at com.intellij.idea.MainImpl$1$1.proceed(MainImpl.java:53)
at com.intellij.ide.a.f.ab$3.run(ab$3.java:372)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

First idea, "well something went wrong" (because i simple rsynced my settings from another pc). Later it turned out something else was missing. A simple "pacman -S giflib" and everything was running fine afterwards.
so giflib was missing.
What is "giflib"?
giflib is a library for rendering and generating GIF image files.

source