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

[Stephen Worthington]

On Wed, 15 May 2019 17:55:12 -0500, you wrote:

>
>
>Hi Folks!
>
>Doing a little snooping to see if I cold find the configuration error 
>(or at least I think so) for my my mariaDB is not loading and might be 
>because looking at 127.0.0.1 (localhost) and I think it should be 
>looking at 192.168.0.3 (Backend-3’s static address).
>
>Didn’t really find anything other than this: mysqld --verbose --help
>
>mysqld --verbose --help | grep -i 127
>
>==> bind-address 127.0.0.1
>
>Also gave an error Could not increase number of max_open_files to more 
>than 1024 (request: 4139)
>
>(Didn’t find a ‘max_open’ nor ‘4139’ though.)
>
>Remember seeing something about bind-address but not where. I haven’t 
>fiddled with anything other than nosing around. Half-figuring that files 
>at 4139 may be important, or at least need to be corrected. The number 
>isn’t significant to me.
>
>TIA!
>
>Barry

If you have not changed the bind-address setting in the /etc/mysql/*
config files, you will get it only binding localhost (127.0.0.1).  But
that will not stop it from working.  There are going to be error
messages in the log files.  Unfortunately, which log file depends on
how it is configured.  So you need to look at:

/var/log/mysql.log
/var/log/mysql.err

and all the files in:

/var/log/mysql/

One or more of them will have all the normal startup messages, and the
error(s) that are causing it to shut down again.  If it is configured
right, the most likely place for the error(s) to be logged is:

/var/log/mysql/error.log

Since you do not know all that much about MariaDB yet, it is best if
you just post the entire log for the last time you attempted to start
MariaDB.  The easiest way to do that is to try starting it:

sudo systemctl start mariadb

and note down the time you did that command.  Then find any messages
in the logs that happened at that time and for the next few seconds
(minutes?) afterwards.  If there is not too much, just post it in an
email here, otherwise post it on pastebin.com and post a URL to there.

My first guess is that it will have a message about "can't init" a
"tc.log" file.  So when you are looking at the log files, if you find
one named tc.log, try deleting that and starting MariaDB again.