Messages

1

21.1 Legacy Series / Re: Installing MariaDB/MySQL system tables in '/var/db/mysql' fails

« on: April 12, 2021, 05:35:06 pm »

I figured out the issue.

FreeBSD 12.1 is end-of-life.  I had to change the FreeBSD.conf to the following:

FreeBSD: {
  url: "pkg+http://pkg.freebsd.org/FreeBSD:12:amd64/release_1",
  enabled: yes
}

And then did pkg update, pkg upgrade, removed mariadb105-server, installed mariadb103-server.


Installed packages to be DOWNGRADED:
        bash: 5.1.4_1 -> 5.0.11 [FreeBSD]
        icu: 68.2,1 -> 64.2,1 [FreeBSD]
        rsync: 3.2.3 -> 3.1.3_1 [FreeBSD]
        xxhash: 0.8.0 -> 0.7.1 [FreeBSD]
        zstd: 1.4.8 -> 1.4.3 [FreeBSD]

Mariadb103 is latest for 12.1 release.

Maybe OpnSense can put this as a check?

THanks

2

21.1 Legacy Series / Installing MariaDB/MySQL system tables in '/var/db/mysql' fails

« on: April 12, 2021, 03:51:22 pm »

Hi Community,

I recently installed (from scratch) 21.1. Then upgraded to 21.1.4.
I then allow to install from FreeBSD repos [/usr/local/etc/pkg/repos/FreeBSD.conf, changed to yes].
I then installed mariadb105-server.

When trying to run the server, it fails.

I tried the following to troubleshoot:
1. Uninstall and re-install 10.5
2. Uninstall and installed prior versions 10.4 and 10.3
3. pkg-static upgrade -f
4. Ran all commands as suggested in the error msg
5. Check internet and only two websites talking about memalign@FBSD_1.6 and might be related to conflicts in lib? No idea.

Appreciate the help.

Note: I've been using Opnsense for the last 5 years on the same hardware Zotac CI321 with no issues with install from FreeBSD repo.

Below is msg.

-------------------

service mysql-server onestart

Installing MariaDB/MySQL system tables in '/var/db/mysql' ...
ld-elf.so.1: /usr/local/libexec/mysqld: Undefined symbol "memalign@FBSD_1.6"
cat: stdout: Broken pipe
cat: stdout: Broken pipe
cat: stdout: Broken pipe

Installation of system tables failed!  Examine the logs in
/var/db/mysql for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

    shell> /usr/local/bin/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

    shell> /usr/local/libexec/mysqld --skip-grant-tables --general-log &

and use the command line tool /usr/local/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/bin/mysql -u root mysql
    mysql> show tables;

Try 'mysqld --help' if you have problems with paths.  Using
--general-log gives you a log in /var/db/mysql that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql

-------------------

3

General Discussion / zbox ci323 sdhci_pci0-slot0 issue

« on: April 12, 2016, 03:02:55 am »

Reaching out to group since this is a new box and no issues booting and using; but, giving the following error (repeatedly during boot up; but, then goes away):

No major issues running opnsense 16.1.x. 

However, it is noticeable slower to upgrade from 16.1.x to 16.1.x+1 for example.

On zbox 321 for example, takes about 5 minutes for entire process to upgrade. on this new box, about 30 minutes. all settings are same.

seems like freebsd drives with the SD card reader.

sdhci_pci0-slot0:  Controller timeout
sdhci_pci0-slot0: ============== REGISTER DUMP ==============
sdhci_pci0-slot0: Sys addr: 0x00000000 | Version:  0x00001002
sdhci_pci0-slot0: Blk size: 0x00000000 | Blk cnt:  0x00000000
sdhci_pci0-slot0: Argument: 0x00000000 | Trn mode: 0x00000000
sdhci_pci0-slot0: Present:  0x1fff0001 | Host ctl: 0x00000001
sdhci_pci0-slot0: Power:    0x00000000 | Blk gap:  0x00000080
sdhci_pci0-slot0: Wake-up:  0x00000000 | Clock:    0x0000fa07
sdhci_pci0-slot0: Timeout:  0x00000000 | Int stat: 0x00000000
sdhci_pci0-slot0: Int enab: 0x01ff00fb | Sig enab: 0x01ff00fb
sdhci_pci0-slot0: AC12 err: 0x00000000 | Slot int: 0x00000000
sdhci_pci0-slot0: Caps:     0x446cc8b2 | Max curr: 0x00000000
sdhci_pci0-slot0: ===========================================

4

General Discussion / crontab resetting after reboot

« on: April 12, 2016, 02:29:29 am »

Hi, every time the server reboots; the crontab resets. How can we save cronjobs during reboots?
Using 16.1.9. Not sure if always an issue; but, using for past few months.