WHat's the difference between this channel, and #freebsd-irc ?

#freebsd-irc is if you aren't registered with nickserv

Ah! Ok. No wonder it was so much more quiet.

just built a new machine and I was wondering if freebsd would be solid on a newer amd ryzen 7000 series processor, I want to use it on one of my SSDs

I have better luck with older hardware most of the time with BSD-based systems, so I don't want an unstable system

any help would be appreciated, and thanks ahead of time

johnm: if it's unstable the hardware is probably needs intervention

rtprio: so it should not have any specific errors that are related to the OS itself?

no you should not

ok, thank you, I was hoping I had not missed something obvious and just wanted to confirm

perhaps someone who has that specific hardware can speak up.

I'll be here if someone would like to add some specific results, and it would be appreciated to have that confirmation too

whois micttyl

oops

you just increased their suffering

It's a cruel world out there!

Hi all, I'm having issues with curl(1) refusing to connect to HTTPS servers, failing with 'SSL certificate problem: unable to get local issuer certificate'; pkg(8) reports ca_root_nss is installed, I even pkg install -f ca_root_nss for good measure, but no dice

Perhaps something has or is serving revoked|expired certificate?

What is your OS version?

no parv , I'm talking about facebook.com, google.fr, etc.

12.4-RELEASE

is your clock off?

Sat Jan 14 09:47:42 CET 2023 # no

the error really points to missing certs, not failing checks for dates

i didnt read your url until now

yeah

you're missing ca certs, thats no bueno

FWIW, curl here (FreeBSD 13.1-STABLE) is 7.86, ca_root_nss is 3.86

ca_root_nss-3.86 curl-7.87.0

this seems to be a global problem across all my jails, too :(

*only on my jails

I really had other things to do today T___T

moviuro, Here I have 128 links (linked to in /usr/share/certs) compared to 1 on your side

I need to re-trigger the install script of ca_root_nss, I guess. no idea how to do that though

If I remember right, pkg delete -f doesn't uninstall things packages depending on the uninstalled package. Could uninstall and reinstall

but

since you did pkg install -f, I don't think there'd be a difference

xtile: can confirm no difference

Using The Ports system, a port can (or, could when I last tried) be removed without removing any other packages: cd security/ca_root_nss && make build && make deinstall && make install

parv: I uninstalled the package and reinstalled it. I have no ports anywhere, I'm *not* touching that today

Yeah, mixing ports and pkg is unfun.

🤷‍♂️

I wish ports could be updated to match quarterly pkg.

some jails are missing a LOT of files :/ x0.at/Gy5K.txt

xtile: that will bugs you each time installing something relavant, because it will keep suggesting you to install after all

hmm?

ah, yes, as for forcibly uninstalling a package

I know, since a year or so ago, bash suddenly became a dependency of many packages, and I kept manually uninstalling it. Fortunately that was fixed.

certctl -v rehash

what kind of magic does one need from bash? it should be just like "oh, i didn't comply, f it ich habe no time"

if it was required for the dev version, that should be reasonable though

what happened was a bunch of packages began requiring bash-completion as a run dependency, which also then required bash. i believe the fix was a ports dev turned it into just a build dependency

been a while

Title: [ports] Revision 566543

johnm: I am using the AMD Ryzen 7 Pro 4750U on OpenBSD, and it works great.

I would guess when it works on OpenBSD, there's a high chance it will work on FreeBSD. The problem I've usually had is hardware not working on OpenBSD but working on FreeBSD.

I am excited to build a new computer sometime this year. My current one's one I built in 2012, and it doesn't even count as x86-64-v2. en.wikipedia.org/wiki/X86-64#Microarchitecture_levels I heard some GNU/Linux distros have been moving to x86-64-v2 and dropping original x86-64 support, actually.

Title: x86-64 - Wikipedia

Reminded by Ryzen and the fact the new ones have AVX-512 and stuff.

No clue what AVX-512 is. Not a big hardware guy. I took a chance on AMD because my other laptop is Intel, and in a crippled state to address all the issues with their recent CPUs.

At least lost 50% of its capacity.

dang

xtile: that sounds like a big break. and feels a lot faster than the move from i386 to i586 / i686

perhaps... It means those distros no longer support my current hardware. But when I asked all my friends about their hardware, no-one else was affected by this

I did a pkg search latex and didn't find a package that looked right, what's the recommended way to install latex on FreeBSD (13.1)

A quick web search hints that texlive-full may be a good one for that.

crb: iirc I use tex-formats for latex

but no one has put that into ports yet

hello people someone can help to me i wiil try run from freebsd 13.1 the re::engine::RE2 and i get error bsd.to/E1DK

Title: dpaste/E1DK (Plain Text)

meena: do you compile tectonic on freebsd?

ld: error: undefined symbol: vesa_unload_ioctl

>>> referenced by vesa.c:1965 (/usr/src/sys/dev/fb/vesa.c:1965)

>>> vesa.o:(vesa_mod_event)

i was trying to compile a PAE minimal kernel on i686 and I got this

(by "i686" I mean "Haswell running in 32-bit mode." I am not stupid enough to run a Pentium Pro in 2023.)

git grep -F hints it's in syscons, not vt.

After a run of "portupgrade -a" I get a long list of "No such file or directory @ rb_check_realpath_internal - /usr/local/lib/compat/pkg/libstdc++.so.6" for various packages all in /usr/local/lib/compat/pkg what is this telling me?

V_PauAmma_V: so i shouldn't nodevice sc, got it

merci

wwt: I believe to have done that before, yes

"created … using an unholy mix of python code and manual editing" freebsd/freebsd-src 017de00

Title: Add a SVG version of vector-Beastie. · freebsd/freebsd-src@017de00 · GitHub

meena: freebsd foundation doesnt even have the rights in the beastie image

so it is not allowed to manipulate it

wwt: i knew that, but i didn't know Marshall Kirk McKusick held it: mckusick.com/beastie/mainpage/copyright.html

Title: BSD T-shirts

kusick should waive his rights and make it free

must

I'm currently updating zabbix5-server to zabbix6-server. with that comes an update from mysql5.x to mysql8.0. my problem is that the zabbix-server seems to be able to connect to the mysql database via the /tmp/mysql.sock socket (as it can successfully query the database schema version) but as soon as it wants to alter the table (performing the update) it looses the connection and reports: "Can't connect to local MySQL server through socket /tmp/mysql.sock (61)"

this runs in a jail

does anybody have any idea? this was working fine for many years now. I have been digging for over an hour now but nothing seems to work. The PHP webinterface seems to have no problems connection to the database via the socket using the same credentials.

before that it literally reports: "Lost connection to MySQL server during query"

tct: can you do it? with the MySQL Client? and do tube thing it tries (and fails)?

meena, what do you mean by "do the tube thing"?

I can login with the same user, same credentials, same socket via the CLI client.

same, the same thing

meena, I'd rather not run the same alter table statement manually as this is part of an upgrade procedure performed by zabbix6-server. don't want to get into more problems

is the code not idempotent?

I do not understand what that means :/

I've also updated the jail from 13.0-RELEASE to 13.1-RELEASE

Title: Idempotence - Wikipedia

zabbix 5 to 6 upgrade is seamless. the upgrade of database is handled by zabbix itself.

otis, exactly - and zabbix cannot do that: pastebin.com/dZqxQJc4

Title: 11211:20230114:180906.199 Starting Zabbix Server. Zabbix 6.0.12 (revision 126aa - Pastebin.com

otis, heh, thanks for maintaining this :)

hm, in fact, i don't use it with mysql, only with postgres. you could check mysql error log perhaps?

otis, if I set incorrect credentials or connection settings in the zabbix server config. it also errors but then isn't able to query the database version.

otis, yeah, this is the last and only server I have with mysql. I migrated to psql some time ago but can't/don't-want-to do this with this one here right now.

otis, trying to locate the corresponding mysql log files...

or clone the database (or at least affected tables) and perform the query manualy to see what's the error.

treefrom

otis, just checked mysql logs. nothing relevant to this. it just says that everything is fine :<

oops, sorry

otis, if I set an incorrect DBPassword= in the zabbix server config, then restart the zabbix_server service, it tells me that it couldn't authenticate. so what I have shown in the paste would clearly indicate that it CAN communicate with the mysql server. (especially given that it can successfully read the version from the database)

so I did what otis & meena suggested: login with the same user & password (also throught he socket) and ran the same query: pastebin.com/T0Z8ALrW

Title: zabbix_server:/root@[18:20] # mysql -u zabbix -p -S /tmp/mysql.sockEnter passw - Pastebin.com

(I did a 'use zabbix;' inbetween to select the 'zabbix' database.

seems like _something_ kills the connection

tct: did you do any mysqlcheck to see if the database isn't corrupted?

otis, mysqlcheck -c zabbix returns all "OK"

otis, but then it looses connection again: pastebin.com/rB5iHqP8

Title: zabbix_server:/root@[18:29] # mysqlcheck -c zabbixzabbix.acknowledges - Pastebin.com

so clearly there's something wrong with your mysql, i'd say.

hence I came to ask for help :D

:-/ default log is in /var/log/mysql/mysql.err

or mysqld.err

that does not exist

log files are in /var/db/mysql for me

ok, so you should check them.

otis, it would appear that the zabbix.dashboard table is corrupt

mysqlcheck -r --auto-repair maybe?

yeah I am trying to run the repair but "The storage engine for the table doesn't support repair'

I remember why I switched to psql...

changing the engine on only that table doesn't work either as: "because the table participates in a foreign key constraint"

error log on MySQL might have to be enabled

otis, I restored everything to the state before I touched something, then did the same procedure again. On first start of zabbix6-server: pastebin.com/aVvmJYjR

Title: 37039:20230114:190112.344 Starting Zabbix Server. Zabbix 6.0.12 (revision 126aa - Pastebin.com

so clearly everything is fine other than the corrupted database.

not sure if it's worth fixing or starting over with psql

it has one very small drawback: it's more than advisable to track every major version of postgres and update in a timely manner.

esp. when you decide to go with timescale

I wonder if there's any way to migrate the data… pgloader.io

Title: pgloader

it's ⬆️ written in Common Lisp

It must be most excellent then :-)

cracauer: it's rock solid.