dlangille

[slocum dan ~] % vm list                                                                         21:29:05
/usr/local/sbin/vm: ERROR: virtual machines can only be managed by root


[slocum dan ~] % sudo vm list                                                                    21:29:06
NAME            DATASTORE  LOADER     CPU  MEMORY  VNC  AUTO  STATE
hass            default    uefi       4    4GB     -    No    Running (72577)
home-assistant  default    uefi       1    1GB     -    No    Stopped
myguest         default    bhyveload  1    768M    -    No    Stopped

dlangille

Dec 26 21:09:17 r720-01 kernel: mps1: mpssas_prepare_remove: Sending reset for target ID 21
Dec 26 21:09:17 r720-01 kernel: da12 at mps1 bus 0 scbus8 target 21 lun 0
Dec 26 21:09:17 r720-01 kernel: da12: <ATA Samsung SSD 850 3B6Q>  s/n S3PTNF0JA70159T      detached
Dec 26 21:09:17 r720-01 kernel: mps1: No pending commands: starting remove_device
Dec 26 21:09:18 r720-01 kernel: (da12:mps1:0:21:0): Periph destroyed
Dec 26 21:09:18 r720-01 ZFS[67733]: vdev state changed, pool_guid=1975810868733347630 vdev_guid=8716406602783665762
Dec 26 21:09:18 r720-01 ZFS[67737]: vdev is removed, pool_guid=1975810868733347630 vdev_guid=8716406602783665762
Dec 26 21:09:19 r720-01 kernel: da12 at mps1 bus 0 scbus8 target 21 lun 0
Dec 26 21:09:19 r720-01 kernel: da12: <ATA Samsung SSD 850 3B6Q> Fixed Direct Access SPC-4 SCSI device
Dec 26 21:09:19 r720-01 kernel: da12: Serial Number S3PTNF0JA70159T     

dlangille

vm img https://github.com/home-assistant/operating-system/releases/download/9.3/haos_ova-9.3.qcow2.xz

vm create -t debian -c 4 -m 4GB -s 200G -i haos_ova-9.3.qcow2.xz home-assistant

dlangille

[air01 dan ~] % brew install joe                                                                                8:55:49
Running `brew update --auto-update`...
==> Auto-updated Homebrew!
Updated 2 taps (homebrew/core and homebrew/services).
==> New Formulae
bindgen             ferium              libretls            pgsync              [email protected]         vhs
btrfs-progs         fred                libunibreak         pinocchio           rnr                 waybackpy
cbindgen            gebug               license-eye         pluto               tart                xcodes
cdsclient           hotbuild            llama               pomsky              textract            xq
cloudprober         huggingface-cli     [email protected]        postgresql@15       trezor-bridge

dlangille

===========================================================================
=======================<phase: package        >============================
===>  Building package for qt5-gui-5.15.5p165
pkg-static: Unable to access file /wrkdirs/usr/ports/x11-toolkits/qt5-gui/work/stage/usr/local/include/qt5/QtLinuxAccessibilitySupport/5.15.5/QtLinuxAccessibilitySupport/private/application_p.h:No such file or directory
pkg-static: Unable to access file /wrkdirs/usr/ports/x11-toolkits/qt5-gui/work/stage/usr/local/include/qt5/QtLinuxAccessibilitySupport/5.15.5/QtLinuxAccessibilitySupport/private/atspiadaptor_p.h:No such file or directory
pkg-static: Unable to access file /wrkdirs/usr/ports/x11-toolkits/qt5-gui/work/stage/usr/local/include/qt5/QtLinuxAccessibilitySupport/5.15.5/QtLinuxAccessibilitySupport/private/bridge_p.h:No such file or directory
pkg-static: Unable to access file /wrkdirs/usr/ports/x11-toolkits/qt5-gui/work/stage/usr/local/include/qt5/QtLinuxAccessibilitySupport/5.15.5/QtLinuxAccessibilitySupport/

dlangille

The before trigger assumed a port could appear in only one catgory (imagine a directory on disk)

e.g. /usr/ports/category/port/

However, there are virtual categories which group together similar ports in a category which does not exist on disk.

The before trigger grabbed values into local varibles instead of inserting directly into the target table.

The new trigger does a INSERT INTO ... SELECT FROM

dlangille

root@freshports:/usr/ports # grep --exclude distfiles/ -r pkg-descr * | grep DESCR
Mk/Uses/qt-dist.mk:DESCR?=			${PORTSDIR}/devel/${_QT_RELNAME}/pkg-descr
Mk/bsd.port.mk:DESCR?=			${PKGDIR}/pkg-descr
Mk/bsd.port.mk:	@if [ ! -f ${DESCR} ]; then ${ECHO_MSG} "** Missing pkg-descr for ${PKGNAME}."; exit 1; fi
accessibility/linux-c7-atk/Makefile:DESCR=		${.CURDIR}/../${PORTNAME}/pkg-descr
accessibility/linux-c7-at-spi2-core/Makefile:DESCR=		${.CURDIR}/../${PORTNAME}/pkg-descr
accessibility/linux-c7-at-spi2-atk/Makefile:DESCR=		${.CURDIR}/../${PORTNAME}/pkg-descr
archivers/linux-c7-lz4/Makefile:DESCR=		${.CURDIR}/../liblz4/pkg-descr
audio/linux-c7-flac/Makefile:DESCR=		${.CURDIR}/../${PORTNAME}/pkg-descr
audio/linux-c7-pulseaudio-utils/Makefile:DESCR=		${.CURDIR}/../${PORTNAME}/pkg-descr

dlangille

[dev-ingress01 dan ~/modules] % svn diff port.pm                                                                                    16:23:03
Index: port.pm
===================================================================
--- port.pm	(revision 5833)
+++ port.pm	(working copy)
@@ -728,7 +728,8 @@
 		 my $only_for_archs, my $not_for_archs,      my $license,              my $fetchdepends, 
 		 my $extractdepends, my $patchdepends,       my $uses,                 my $pkgmessagepath,
 		 my $distinfo_file,  my $license_restricted, my $manual_package_build, my $license_perms,
-		 my $conflicts,      my $conflicts_build,    my $conflicts_install,    my $options_name) = split(/\n/s, $MakeResults);

dlangille

$ mysql -u root -p
mysql> create user gemuser identified by 'gempass'
mysql> create database gem;
mysql> grant usage on gem.* to gemuser@localhost identified by 'gempass';
mysql> grant all privileges on gem.* to gemuser@localhost;


$ cat config.txt
mysql_out = true
mysql_host     = localhost

dlangille

btmon can:

Collect data from Brultech ECM-1240, ECM-1220, and GEM power monitors.  Print
the data, save the data to database, or upload the data to a server.

Python 3 compatible fork: https://github.com/BenK22/mtools/tree/influxdb/bin

Which was forked from: https://github.com/mroch/mtools

Original repo: https://github.com/matthewwall/mtools