- Arch-general - lists.archlinux.org

[arch-general] SQLite Session Extension
by Adam Levy 22 Jul '19

22 Jul '19

I'm using SQLite extensively for a programming project and today I noticed that sqlite is not built with the Session Extension enabled. https://www.sqlite.org/sessionintro.html https://git.archlinux.org/svntogit/packages.git/tree/trunk/PKGBUILD?h=packa… Interestingly enough, I can use the C interface for sessions without issue. But when I use the sqlite3 CLI the .session command is not available. I went ahead and rebuilt the package with the options mentioned in the first link to enable the sessions extension, and the .session command was then available. I was wondering if this was an extension that is ever likely to be enabled in the build? Also perhaps someone more knowledgeable could explain why the C interface to Sessions work, but it is not available in the CLI interface? Forgive me if this is not the proper channel. I could have messaged the maintainer Andreas Radke directly but wasn't sure of the appropriate convention for such a question. Thank you Adam Levy

2 1

[arch-general] Hardware video acceleration
by Ralf Mardorf 21 Jul '19

21 Jul '19

Hi, when playing youtube videos hardware video acceleration seems to gain absolutely nothing on my machine or I've done something wrong ;). Am I missing something? The percent values playing a youtube video with and without enhanced- h264ify are raw estimated values, based upon my impression, so I consider those values as quasi equal, the minimal difference is neglectable. https://addons.mozilla.org/firefox/addon/enhanced-h264ify/ https://chrome.google.com/webstore/detail/enhanced-h264ify/omkfmpieigblcllm… $ firefox --safe-mode https://www.youtube.com/watch?v=wqLEg0MsSMQ & top %Cpu(s): 14 us 22% Web Content 14% firefox $ firefox https://www.youtube.com/watch?v=wqLEg0MsSMQ & top [x] Block VP8 [x] Block VP9 [x] Block AV1 %Cpu(s): 13 us 20% Web Content 15% firefox $ google-chrome-stable https://www.youtube.com/watch?v=wqLEg0MsSMQ & top [x] Block VP8 [x] Block VP9 [x] Block AV1 %Cpu(s): 8 us 14% chrome 13% chrome [ ] Block VP8 [ ] Block VP9 [ ] Block AV1 %Cpu(s): 11 us 15% chrome 14% chrome $ hwinfo --cpu | grep Model | sort -u; vainfo Model: 6.60.3 "Intel(R) Celeron(R) CPU G1840 @ 2.80GHz" vainfo: VA-API version: 1.5 (libva 2.5.0) vainfo: Driver version: Intel i965 driver for Intel(R) Haswell Desktop - 2.3.0 vainfo: Supported profile and entrypoints VAProfileMPEG2Simple : VAEntrypointVLD VAProfileMPEG2Simple : VAEntrypointEncSlice VAProfileMPEG2Main : VAEntrypointVLD VAProfileMPEG2Main : VAEntrypointEncSlice VAProfileH264ConstrainedBaseline: VAEntrypointVLD VAProfileH264ConstrainedBaseline: VAEntrypointEncSlice VAProfileH264Main : VAEntrypointVLD VAProfileH264Main : VAEntrypointEncSlice VAProfileH264High : VAEntrypointVLD VAProfileH264High : VAEntrypointEncSlice VAProfileH264MultiviewHigh : VAEntrypointVLD VAProfileH264MultiviewHigh : VAEntrypointEncSlice VAProfileH264StereoHigh : VAEntrypointVLD VAProfileH264StereoHigh : VAEntrypointEncSlice VAProfileVC1Simple : VAEntrypointVLD VAProfileVC1Main : VAEntrypointVLD VAProfileVC1Advanced : VAEntrypointVLD VAProfileNone : VAEntrypointVideoProc VAProfileJPEGBaseline : VAEntrypointVLD $ uname -rvm; rtirq status 5.2.0-rt1-0-cornflower #1 SMP PREEMPT RT Thu Jul 18 09:49:07 CEST 2019 x86_64 PID CLS RTPRIO NI PRI %CPU STAT COMMAND 206 FF 90 - 130 0.0 S irq/28-xhci_hcd 207 FF 90 - 130 0.0 S irq/16-ehci_hcd 211 FF 89 - 129 0.0 S irq/23-ehci_hcd 336 FF 85 - 125 0.0 S irq/16-snd_hdsp 363 FF 80 - 120 0.0 S irq/16-snd_ice1 126 FF 50 - 90 0.0 S irq/9-acpi 138 FF 50 - 90 0.0 S irq/8-rtc0 205 FF 50 - 90 0.0 S irq/1-i8042 213 FF 50 - 90 0.0 S irq/29-ahci[000 324 FF 50 - 90 0.0 S irq/30-mei_me 325 FF 50 - 90 0.0 S irq/5-parport0 327 FF 50 - 90 0.0 S irq/18-i801_smb 338 FF 50 - 90 0.0 S irq/32-i915 387 FF 50 - 90 0.0 S irq/33-snd_hda_ 559 FF 50 - 90 0.0 S irq/31-enp3s0 9 TS - 0 19 0.4 S ksoftirqd/0 23 TS - 0 19 0.4 S ksoftirqd/1 $ pacman -Q intel-hybrid-codec-driver libva libva-utils intel-hybrid-codec-driver 2.0.0.r169.edead0c-2 libva 2.5.0-1 libva-utils 2.5.0-1 $ pacman -Q firefox google-chrome firefox 68.0.1-2 google-chrome 75.0.3770.142-1 $ pacman -Q x264 x264 2:157.r72db4377-1 Regards, Ralf -- pacman -Q linux{,-rt{-cornflower,-pussytoes,,-securityink}}|cut -d\ -f2 5.2.1.arch1-1 5.2_rt1-0 5.0.21_rt16-1 5.0.19_rt11-1 4.19.50_rt22-0

4 6

[arch-general] Proper use of signify in PKGBUILDs
by Stephen Gregoratto 21 Jul '19

21 Jul '19

I recently adopted the openbsd-manpages package[1], and wanted to verify downloaded files using OpenBSD's signify(1) tool. For each release of OpenBSD, you download the base public key[2], the architecture-specific files and the SHA256.sig[3] for those files. The files are verified by running: signify -Cp openbsd-65-base.pub -x SHA256.sig *.tgz The problem is that PKGBUILD thinks that the signify signature is a PGP signature, and tries to verify it against a non-existent file/PGP key. I've worked around this by renaming SHA256.sig to SHA256. Have any other packagers/maintainers experienced this problem, and if so are there any better solutions other than the one I mentioned? [1] https://aur.archlinux.org/packages/openbsd-manpages/ [2] https://ftp.openbsd.org/pub/OpenBSD/6.5/openbsd-65-base.pub [3] https://ftp.openbsd.org/pub/OpenBSD/6.5/amd64/SHA256.sig -- Stephen Gregoratto

4 6

[arch-general] PC build for hardware video acceleration
by L. Rose 19 Jul '19

19 Jul '19

Dear community, I want to build a new CPU-focused Arch Linux PC. No requirements for GPU, except for H.265 4K decode, in decent profiles (whatever that means). What hardware is best supported by libraries like VA-API and VDPAU? Are there other relevant libraries? Which libraries are still maintained and up-to-date, which are open source? I see three options right now: 1. High-end Intel CPU (e.g. i9-9900K) w/ integrated HD 630 GPU, or 2. CPU w/o iGPU (e.g. AMD Ryzen Threadripper 2920X) + dedicated, low-end AMD GPU (e.g. Radeon RX 560) 3. CPU w/o iGPU and low-end NVidia GPU (e.g. GTX 1050) I couldn't find out which setup works best using the wiki and other sources. Maybe anyone could point me to the right direction? What hardware is recommended for good H.265 4K playback on GPU? Thanks in advance, kind regards, L.

4 4

[arch-general] How to get "b"-menu in Arch i3
by Ram Kumar 17 Jul '19

17 Jul '19

Hi there Archers, I am moving from manjaro i3 to Arch now, already started customizing i3 to my need. Has anyone seen how the "b-menu" in Manjaro i3 is?..it contains bluetooth, network manger etc.. binded to mod+ctrl+b keys by default. how can i get a similar one to my Arch config?.. please guide me. Thanks in advance Fellow newbie Archer Ramkumar

6 10

[arch-general] Intel Wireless AC 3165 not working on install media
by Tomás Acauan Schertel 14 Jul '19

14 Jul '19

Hi guys. I'm trying to install Arch on my new notebook, but I can't make my WiFi adapter to work. I'm following Install Guide\Wireless Network Configuration\WPA_supplicant to connect, but it's not working.. Looks like I can't set WiFi adapter UP. Does someone have this WiFi adapter working during installation? Thanks for your help. *Beste Grüße* *Tomás Schertel*

2 2

[arch-general] 5.2 kernel, Virtualbox console takes on video-mode size -- nice.
by David C. Rankin 12 Jul '19

12 Jul '19

All, With the 5.2 kernel, virtualbox no longer boots to the GRUB_GFXMODE, but instead boots to the video-mode-hint given to virtualbox. That is a welcomed change. -- David C. Rankin, J.D.,P.E.

1 0

[arch-general] Unmaintained project with active community fork - what to do with the package?
by Danila Kiver 01 Jul '19

01 Jul '19

Hi all, please help me in handling the following situation. The bash-bats package ( https://www.archlinux.org/packages/community/any/bash-bats ) uses the upstream repository ( https://github.com/sstephenson/bats ), which is no longer maintained by its owner ( https://github.com/sstephenson/bats/issues/150 ). Looks like the project moved to a community-maintained fork ( https://github.com/bats-core/bats-core ), which already reached version 1.1.0 and includes crucial fixes, while the original project stays untouched for a long while. What would be the correct approach here: ask the maintainer of bash-bats package to switch to the active fork, or leave this deprecated package as it is and create an AUR package for the fork? Regards, Danila Kiver.

2 1

[arch-general] PCYNLITX project and its innovations ( for multi-threading )
by Erkam Murat Bozkurt 30 Jun '19

30 Jun '19

PCYNLITX platform offers completely new programming technology which can be named as Programmable Meta-Programming System and PCYNLITX platform is just a particular application of this new programming methodology. Basically, PCYNLITX is an intelligent integrated development environment ( IDE ) which can produce an application-specific multi-threading library based on your needs and assists you in multi-thread software development process. PCYNLITX is not a multi-threading library. Instead, it is a multi-threading library generator. You can find out very comprehensive documentation about pcynlitx project from both project web site and source code repository. The addresses of the project web page and source code repository are given in below links. www.pcynlitx.tech https://sourceforge.net/projects/pcynlitx The outcome of the PCYNLITX platform acts as an autonomous thread management system provides deterministic scheduling of the threads. You can control the thread with the numbers given by you and determine the relation of the threads. In other words, different from the other multi-threading tools, you can directly schedule the threads independently from the operating system. The scientific journal of the project is under review on IEEE Transactions on Software Engineering. Currently, the PCYNLITX platform only works on Linux based operating systems and the other versions ( Windows and McOSx ) are under development. The License of the PCYNLITX platform is GNU GPLv3 Free Software License. You can find out many other documents including scientific introduction of the project (“Technical Introduction” ), code examples and GUI tutorial form the project web sites. You can also find out a documents introducing std::thread programming, pthread programming and OpenMP programming on the web sites. Currently, ubuntu, debian and fedora distros are supported and arch linux version of the pcynlitx will be available soon. I am always waiting your valuable comments and contributions. Thanks and best regards. Erkam Murat Bozkurt M.Sc in Control Systems

4 3

[arch-general] maria update to 10.4.6 breaks akonadi's db
by Oliver Jaksch 30 Jun '19

30 Jun '19

Updated three of my KDE clients by terminal (not logged in by display manager/DM) and ran # systemctl restart mariadb.service && mariadb-upgrade -u root -p as stated by pacman and arch-acnnounce. All went fine so far. No client starts or uses a mariadb service. But after logging in at DM and starting Kontact the drama begins: New Mails are shown but no one can be read and journal is showing lots of Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: DATABASE ERROR: Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Error code: "1452" Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement" Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(qlonglong, 345491))(":1", QVariant(qlonglong, 9))(":2", QVariant(QByteArray, "Return-Path: <receiver(a)bla.com>\r\nDelivered-To: copyrec(a)bla.com\r\nReceived: from localhost (localhost [127.0.0.1])\r\n\tby mail.sender.com (Postfix) with ESMTP id 6E9EF624B8;\r\n\tFri, 28 Jun 2019 05:49:16 +0200 (CEST)\r\nDKIM-Filter: OpenDKIM Filter v2.11.0 mail.sender.com 6E9EF624B8\r\nDKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sender.com;\r\n\ts=mail; [...] Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Query: "INSERT INTO PartTable (pimItemId, partTypeId, data, datasize, version) VALUES (:0, :1, :2, :3, :4)" Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Error during insertion into table "PartTable" "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement" Jun 28 05:49:17 zotac3 akonadiserver[5774]: org.kde.pim.akonadiserver: Error while handling command CreateItem on connection akonadi_imap_resource_10 (0x55f027a24a20) Jun 28 05:49:17 zotac3 akonadi_imap_resource[1543]: org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "Failed to insert new part into database." Jun 28 05:49:17 zotac3 akonadi_imap_resource[1543]: org.kde.pim.akonadicore: Error during ItemSync: "Failed to insert new part into database." ~/.local/share/akonadi/db_data/mysql.err is showing continuously 2019-06-28 6:14:21 10 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active Stopping akonadi and therefore mariadb, then downgrading to mariadb* 10.3.16-1 helped. Looks like something's not really going together there yet. - Oliver

3 8