On 27/1/18 9:49 pm, Sjoerd Mullender wrote:
On 27/01/18 01:12, Stephen Morris wrote:
> On 26/1/18 7:58 pm, Sjoerd Mullender wrote:
>> On 26/01/18 00:59, Stephen Morris wrote:
>>> On 26/1/18 10:49 am, Stephen Morris wrote:
>>>> On 25/1/18 4:33 am, John Pilkington wrote:
>>>>> On 24/01/18 17:09, John Pilkington wrote:
>>>>>> sysstemctl | grep maria gives
>>>>>>
>>>>>> ● mariadb.service loaded failed
>>>>>> failed MariaDB 10.1 database server
>>>>>>
>>>>>> There was a 'normal shutdown' of version 10.1.29
>>>>>>
>>>>>> version 10.1.30 reports:
>>>>>>
>>>>>> 2018-01-24 13:55:42 140690185448192 [ERROR] mysqld: Can't
>>>>>> create/write to file '/run/mariadb/mariadb.pid' (Errcode:
2 "No such
>>>>>> file or directory")
>>>>>> 2018-01-24 13:55:42 140690185448192 [ERROR] Can't start
server:
>>>>>> can't create PID file: No such file or directory
>>>>>>
>>>>>> I reinstalled and it failed again.
>>>>>>
>>>>>> John P
>>>>> yumex-dnf offered 10.1.21-5 as a downgrade, and that is running.
>>>> Just some info on this, I'm on F27 using mariadb (64 bit) 10.2.9-3
and
>>>> it does not appear to be exhibiting this issue in that systemctl
>>>> status mariadb shows that the service has started at boot time.
>>> Just further to this, on my system, which may be a hangover from having
>>> installed the community-mysql packages first and using that environment
>>> before uninstalling these and installing the mariadb equivalents, the
>>> mariadb.pid file is placed in /run/mysqld which is owned by User/Group
>>> mysql. The time stamp on this file indicates that it was successfully
>>> created with this mornings boot.
>> See the bug report:
https://bugzilla.redhat.com/show_bug.cgi?id=1538066
>>
>> Quick fix until mariadb update arrives: add the following line to the
>> file /usr/lib/tmpfiles.d/mariadb.conf:
>>
>> d /run/mariadb 0755 mysql mysql -
> My mariadb.conf, as installed from the Fedora repositories, has the
> following line already in there, but in there twice:
>
>
> d /run/mysql 0755 mysql mysql
The directory in /usr/lib/tmpfiles.d/mariadb.conf has to match the one
in /etc/my.cnf.d/mariadb-server.cnf for the pid-file variable. The new
value seems to be /run/mariadb.
I've looked at /etc/my.cnf.d/mariadb-server.cnf on my system and in the
[mysqld] section it has the following entries:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mariadb/mariadb.log
pid-file=/run/mysqld/mariadb.pid
I did have the community-mysql packages installed, but when in answer to
another thread I raised I was told that mariadb was the Fedora
officially support package, I uninstalled the community-mysql packages
and installed the equivalent mariadb packages, which is the first time I
have ever had mariadb installed. I do have some other mysql addon
packages that in their description and package name do not have any
indication that they are written for either of the two package
environments, one of which provides the admin tool that netbeans wants
to know about in its mysql configuration. Netbeans mysql configuration
also has places to specify the commands to start and stop mariadb but I
haven't specified those as with the service automatically starting at
boot time I don't need to.
Is it possible the directory locations have changed with 10.2 as, from
my perspective, the maridb.conf and mariadb-server.cnf files are as
supplied by the Fedora packages?
regards,
Steve
>> regards,
>>
>> Steve
>>
>>>> regards,
>>>>
>>>> Steve
>>>>
>>>>> regards,
>>>>>
>>>>> Steve
>>>>>
>>>>>
>>>>>> _______________________________________________
>>>>>> users mailing list -- users(a)lists.fedoraproject.org
>>>>>> To unsubscribe send an email to
users-leave(a)lists.fedoraproject.org
>>>>> _______________________________________________
>>>>> users mailing list -- users(a)lists.fedoraproject.org
>>>>> To unsubscribe send an email to users-leave(a)lists.fedoraproject.org
>>>> _______________________________________________
>>>> users mailing list -- users(a)lists.fedoraproject.org
>>>> To unsubscribe send an email to users-leave(a)lists.fedoraproject.org
>>>
>>> _______________________________________________
>>> users mailing list -- users(a)lists.fedoraproject.org
>>> To unsubscribe send an email to users-leave(a)lists.fedoraproject.org
>> _______________________________________________
>> users mailing list -- users(a)lists.fedoraproject.org
>> To unsubscribe send an email to users-leave(a)lists.fedoraproject.org
>
> _______________________________________________
> users mailing list -- users(a)lists.fedoraproject.org
> To unsubscribe send an email to users-leave(a)lists.fedoraproject.org