Search found 77 matches

by pinnerite
Fri Feb 22, 2019 3:19 pm
Forum: Troubleshooting
Topic: Cannot login to database
Replies: 7
Views: 55
Great Britain

Re: Cannot login to database

This worked mysql --host=localhost --user mythtv --password mythconverg But this did not -- at first mysql --host=192.168.0.5 --port=3306 --user mythtv --password mythconverg Following your pointer, I discovered that the bind address in /etc/mysql/mariadb.conf.d/50-server.cnf was still 127.0.0.1. I ...
by pinnerite
Thu Feb 21, 2019 9:53 pm
Forum: Troubleshooting
Topic: Cannot login to database
Replies: 7
Views: 55
Great Britain

Re: Cannot login to database

thelma@origen /var/log/mythtv $ ls -ls /home/mythtv/.mythtv total 20 4 drwxr-xr-x 2 sshd mythtv 4096 Nov 30 19:06 3rdParty 4 drwxr-xr-x 5 sshd mythtv 4096 Dec 6 21:56 cache 4 drwxr-xr-x 2 sshd mythtv 4096 Nov 30 19:06 channels 0 lrwxrwxrwx 1 sshd mythtv 22 Jun 26 2018 config.xml -> /etc/mythtv/confi...
by pinnerite
Thu Feb 21, 2019 9:09 pm
Forum: Troubleshooting
Topic: Cannot login to database
Replies: 7
Views: 55
Great Britain

Re: Cannot login to database

The configuration directory contents are spot on.

I can indeed access the DB from the command line.

I am unfamiliar with pastebin but I have pasted the backend.log here.

https://pastebin.com/nZrzCKsn
by pinnerite
Thu Feb 21, 2019 8:23 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

The problem, believed to have arisen from a corruption was resolved by a complete uninstall and purge of all file MySQL-related, followed by an installation of MariaDB.

That seems to have cracked it.

Thank you Mike and Bill for your persistence in trying to solve the problem.
by pinnerite
Thu Feb 21, 2019 7:37 pm
Forum: Troubleshooting
Topic: Cannot login to database
Replies: 7
Views: 55
Great Britain

Cannot login to database

Following a week of problems with MySQL I installed MariaDB on Mint 19.1 and created the mythtv user, mythconverg etc. The user is in the mythtv group mythtv-setup went Ok. host IP address, password etc were as in config.xml, both in ~./mythtv and /etc/mythtv except the former has an entry for rende...
by pinnerite
Mon Feb 18, 2019 6:43 am
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

Apologies, I forgot to add: thelma@origen ~ $ systemctl cat mysql.service # /lib/systemd/system/mysql.service # MySQL systemd service file [Unit] Description=MySQL Community Server After=network.target [Install] WantedBy=multi-user.target [Service] Type=forking User=mysql Group=mysql PIDFile=/run/my...
by pinnerite
Sun Feb 17, 2019 7:09 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

I thought that we were making progress until I next rebooted when I could no longer get into mysql! $ mysql ERROR 1045 (28000): Access denied for user 'thelma'@'localhost' (using password: NO) # mysql ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded root@origen:~# You must be pretty vexed with...
by pinnerite
Sun Feb 17, 2019 2:00 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

Nothing showed up in any of the ".cnf" files nor by the 'grep' statement.
by pinnerite
Sun Feb 17, 2019 11:53 am
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

some exchanges seem to have gone missing from this thread but following your advice I added the sudo group to the installing user 'thelma'. I could then get into mysql from both regular user and root prompts. I then started to follow the steps that you suggested. This is the result: thelma@origen ~ ...
by pinnerite
Sat Feb 16, 2019 11:13 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

It was a while ago. i cannot remember if I used 'apt install mythtv' or synaptic. I have added the sudo group to thelma. Remarkable, I can now get into mysql by both: $ mysql and by # mysql I will have to wait until tomorrow to gain access directly to the target computer. Thank you for sticking with...
by pinnerite
Sat Feb 16, 2019 2:24 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

No. Thelma was the installing user.

thelma@origen ~ $ groups
thelma adm lp cdrom dip video plugdev lpadmin nopasswdlogin scanner sambashare mysql mythtv
thelma@origen ~ $
by pinnerite
Sat Feb 16, 2019 1:34 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

I think something must have gone wrong soon after installation and everything since has compounded it. The clue to this is: thelma@origen ~ $ sudo mysql [sudo] password for thelma: Sorry, user thelma is not allowed to execute '/usr/bin/mysql' as root on origen.asandco. thelma@origen ~ $ I came acros...
by pinnerite
Fri Feb 15, 2019 9:37 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

thelma@origen / $ mysql -uroot -p < /usr/share/mythtv/sql/mc.sql
Enter password:
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded
by pinnerite
Fri Feb 15, 2019 7:44 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

Back to square one:
$ mysql
ERROR 1045 (28000): Access denied for user 'thelma'@'localhost' (using password: NO)

# mysql
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded

Mysql is a black art that I have never mastered.
by pinnerite
Fri Feb 15, 2019 5:46 pm
Forum: Troubleshooting
Topic: Can only log in to MySQL from #
Replies: 32
Views: 283
Great Britain

Re: Can only log in to MySQL from #

I decided to try testing via ssh. seems to work.
The database is indeed mythconverg
The password I tried is that in config.xml, as also seen in mythtv-setup
but
$ mysql -umythtv -p mythconverg
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)
$