Fw: Re: Mariadb on NetBSD 10.1

[Niels Müller Larsen <arosano%protonmail.com@localhost>]

Hi David

I tried your suggestions. They made sense to me. But the results
were negative. With or without your additions to the /etc/rc.d/mariadb file, the xconsole says 'Starting mariadb' (from /var/run/rc.log) but it has not started, and there is no trace of it in any other logs.
I can start it manually, without any problems.

I have tried many things, also reordering, but to no avail.

The only thing that will make it start at boot is removing the '&' but that seems to block the automatic start of my local httpd server which is essential to my teaching. So I am f...d.

I don't want to use more time on it now. I will start it manually, or switch to postgresql, which just starts automatically, and then return to the issue next time there is an update to NetBSD.

Thanks for your time trying to help me.

/Niels

Sent with [Proton Mail](https://proton.me/mail/home) secure email.

------- Forwarded Message -------
From: Niels Müller Larsen <arosano%protonmail.com@localhost>
Date: On Tuesday, April 1st, 2025 at 7:53 PM
Subject: Re: Mariadb on NetBSD 10.1
To: David Brownlee <abs%absd.org@localhost>, netbsd-users%netbsd.org@localhost <netbsd-users%netbsd.org@localhost>

> Sent from [Proton Mail](https://proton.me/mail/home) for iOS
>
> On Tue, Apr 1, 2025 at 18:15, David Brownlee <[abs%absd.org@localhost](mailto:On Tue, Apr 1, 2025 at 18:15, David Brownlee <<a href=)> wrote:
>
>> On Mon, 31 Mar 2025 at 20:58, Niels Müller Larsen
>> <arosano%protonmail.com@localhost> wrote:
>>>
>>> Sent from Proton Mail for iOS
>>>
>>> On Mon, Mar 31, 2025 at 10:16, David Brownlee <abs%absd.org@localhost> wrote:
>>>
>>> On Sun, 30 Mar 2025 at 13:11, Niels Müller Larsen
>>> <arosano%protonmail.com@localhost> wrote:
>>>
>>> > On Sun, Mar 30, 2025 at 12:55, Greg Troxel <gdt%lexort.com@localhost> wrote:
>>> >
>>> > Niels Müller Larsen <arosano%protonmail.com@localhost> writes:
>>> >
>>> > > I have installed the above, and it runs nice and smooth in a node app for teaching.
>>> > > That is if I start mariadb from the CLI.
>>> > >
>>> > > If I try to put
>>> > > mariadb=YES
>>> > > into /etc/rc.conf and reboot, the xconsole says “mariadb started” but there is no trace of it, and I still have to start it manually.
>>> > >
>>> > > The log files give no clues.
>>> >
>>> > A guess is that something in the startup assumes that PATH has more in
>>> > it, than it does. You didn't say what "start from CLI" means.
>>> >
>>> > Set your PATH to just default, no pkgsrc, clean env and
>>> >
>>> > sh -x /etc/rc.d/mariadb start
>>> >
>>> > and read the output
>>> >
>>> > Thnx
>>> >
>>> > Start from CLI means
>>> > $ doas service mariadb start
>>> >
>>> > As for your suggestion I will try that
>>>
>>>
>>> You might also want to try starting from the command line but clearing
>>> the environment first:
>>>
>>> doas env -i /etc/rc.d/mariadb start
>>>
>>> Also check that the installed mariadb rc.d file matches the current shipped:
>>>
>>> diff /etc/rc.d/mariadb /usr/pkg/share/examples/rc.d/mariadb
>>>
>>> (Running mariadb 11.4.5 on NetBSD-10.1/amd64 here, but as always:
>>> "works on my machine" is of limited help :)
>>>
>>> David
>>>
>>> Thanks.
>>> I can start it from the command line without any problem.
>>> The automatic start on boot should be enabled by putting ‘mariadb=YES’ into /etc/rc.conf, but it doesn’t. The mariadb file in /etc/rc.d is copied from the examples, so no diff.
>>> On xconsole it says that mariadb started, which indicates the things in rc.conf and rc.d are in place except it is not true.
>>> I find no log messages mentioning mariadb until I start it manually.
>>> I have also played with the order, so that the xconsole mentions mariadb last. Didn’t help.
>>> Very mysterious, and that bugs me.
>>> I can live with having to do the manual start, but it annoys me that I don’t know why.
>>
>> So just to confirm, running "env -i /etc/rc.d/mariadb start" as root
>> starts it just fine?
>>
>> Could you confirm if it works if you add the following to rc.d/mariadb
>>
>> start_cmd="mariadb_start"
>> mariadb_start()
>> {
>> echo "$command $rc_flags $command_args"
>> sh -c "$command $rc_flags $command_args"
>> }
>>
>> If it still fails on startup, then add "ktrace -id " to the start of
>> the "sh -c" line, and you should end up with a ktrace.out (probably in
>> /). This will be a record of all the syscalls made by the sh -c and
>> any processes it forks. You can view it with kdump, and if mariadb is
>> still running you can stop all recording into the file with ktrace -C
>>
>> (I notice you replied direct - I'm happy to have this email shared
>> on-list if you prefer)
>>
>> Thanks
>>
>> David
>
> sorry, I didn’t mean to exclude the list. I am teaching tomorrow, so I’ll get back to it on thursday. Interesting suggestions.
>
> /niels