[mythtv-users] BE3 - Issues with installation and database

[Barry Martin]

/Yesterday had erroneously used "Re: mythtv-users Digest, Vol 194, Issue 
19" as the subject./


Hi Stephen!


System (Backend-3) off overnight – just powered up (to give a reference 
of what is going on)


Did *service –status-all*(because easier for me to memorize!) - the two 
we’re interested in:

[-] mysql

[+] mythtv-backend



If you have MariaDB installed, the mysql.service and mysqld.service
unit files get set up as links to mariadb.service:

root at mypvr:/etc/systemd/system# ll mys*

    Either something wrong or I’m not understanding something or both:
    to get to your root I’d have to prefix with sudo. Ah! cd
    /etc/systemd/system then sudo 11 mys* “11” command not found. Also
    tried ‘ll’.

    Okay – back from dinner. Still at Barry at Backend-3
    <mailto:Barry at Backend-3>:/etc/systemd/system. For no rear reason
    type ‘11’ - command not found. Typed in ‘ll’ - bunch of stuff!


    So 11 mys* gives:


    barry at Backend-3:/etc/systemd/system$ ll mys*

    lrwxrwxrwx 1 root root 35 May 14 09:21 mysqld.service ->
    /lib/systemd/system/mariadb.service

    lrwxrwxrwx 1 root root 35 May 14 09:21 mysql.service ->
    /lib/systemd/system/mariadb.service

    barry at Backend-3:/etc/systemd/system$


root at mypvr:/etc/systemd/system# systemctl status mariadb


    barry at Backend-3:/etc/systemd/system$

    barry at Backend-3:/etc/systemd/system$ systemctl status mariadb

    ● mariadb.service - MariaDB 10.1.38 database server

    Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor
    preset:

    Active: failed (Result: timeout) since Thu 2019-05-16 16:25:00 CDT;
    1h 23min

    Docs: man:mysqld(8)

    https://mariadb.com/kb/en/library/systemd/

    Process: 1020 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS
    $_WSREP_NEW_CLUSTER $_WS

    Process: 918 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery
    ] && VAR=

    Process: 914 ExecStartPre=/bin/sh -c systemctl unset-environment
    _WSREP_START_

    Process: 899 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root
    -d /var/run

    Main PID: 1020 (code=exited, status=0/SUCCESS)


    May 16 16:23:26 Backend-3 systemd[1]: Starting MariaDB 10.1.38
    database server..

    May 16 16:23:28 Backend-3 mysqld[1020]: 2019-05-16 16:23:28
    140267238837376 [Not

    May 16 16:24:57 Backend-3 systemd[1]: mariadb.service: Start
    operation timed out

    May 16 16:25:00 Backend-3 systemd[1]: mariadb.service: Failed with
    result 'timeo

    May 16 16:25:00 Backend-3 systemd[1]: Failed to start MariaDB
    10.1.38 database s

    lines 1-16/16 (END)


    As I mentioned from some Google-wandering found where appears to be
    configured to localhost 127.0.0.1 and I’m guessing it should be
    looking at Backend-3 192.168.0.3


    Thanks again!

    Barry



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190516/b571b249/attachment.html>