Search found 31 matches

by briggella
Wed Jun 02, 2021 10:06 am
Forum: Troubleshooting
Topic: [Solved] Myth v31.0 fails to restore database - unable to connect to database.
Replies: 15
Views: 8874
New Zealand

Re: Myth v31.0 fails to restore database - unable to connect to database.

Thought I would summarise the process finally used as it will be complicated to follow the posts at a later date. I am plagiarising the documentation heavily. Creating the mythtv user MythTV backend needs to run as its own user. This should be a system account. Create a user as follows: sudo useradd...
by briggella
Sun May 30, 2021 12:20 pm
Forum: Troubleshooting
Topic: [Solved] Myth v31.0 fails to restore database - unable to connect to database.
Replies: 15
Views: 8874
New Zealand

Re: Myth 0.31 fails to restore database - unable to connect to database.

Well the issue there was I needed to grant privileges to user mythtv@192.168.1.% om mythconverg. Then I could access mythtv-setup. Then it converted my schema. After that I tried to update my database and this time it worked. So updated some settings in the system now try to start myth-frontedn but ...
by briggella
Sun May 30, 2021 8:49 am
Forum: Troubleshooting
Topic: [Solved] Myth v31.0 fails to restore database - unable to connect to database.
Replies: 15
Views: 8874
New Zealand

Re: Myth 0.31 fails to restore database - unable to connect to database.

So I decided to drop the database from the new install and go with the advice from PG Bennett in his post earlier In this case I believe you need to recreate your mythtv user and password and grant the privileges. I don't know how the ubuntu install is supposed to do it, but since MySQL 8.0, with ma...
by briggella
Sun May 30, 2021 3:09 am
Forum: Troubleshooting
Topic: [Solved] Myth v31.0 fails to restore database - unable to connect to database.
Replies: 15
Views: 8874
New Zealand

Re: Myth 0.31 fails to restore database - unable to connect to database.

Now checked Mythtv is setup in the database with both types of password enabled. mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select user, host, plugin, authentication_strin...
by briggella
Sat May 29, 2021 7:23 pm
Forum: Troubleshooting
Topic: [Solved] Myth v31.0 fails to restore database - unable to connect to database.
Replies: 15
Views: 8874
New Zealand

Re: Myth 0.31 fails to restore database - unable to connect to database.

Hi again. 13 hr time difference here. Just had a few hrs sleep. I installed Ubuntu then ran the myth install from the repositories. Then ran my normal user accounf for myself as I need to connect from other computers. I the create the database by importing mc.sql into mysql then did the usual messin...
by briggella
Sat May 29, 2021 1:52 pm
Forum: Troubleshooting
Topic: [Solved] Myth v31.0 fails to restore database - unable to connect to database.
Replies: 15
Views: 8874
New Zealand

Re: Myth 0.31 fails to restore database - unable to connect to database.

Sorry Posts crossed. Interesting read, did seem to fit the problem I did what was suggested but no change. Here is my file. Suggested entry in bold. /etc/mysql/mysql.conf.d/mysqld.cnf # # The MySQL database server configuration file. # # One can use all long options that the program supports. # Run ...
by briggella
Sat May 29, 2021 1:43 pm
Forum: Troubleshooting
Topic: [Solved] Myth v31.0 fails to restore database - unable to connect to database.
Replies: 15
Views: 8874
New Zealand

Re: Myth 0.31 fails to restore database - unable to connect to database.

Thanks tried that Restarted Mysql but still getting authentication errors. Error log this time. /usr/share/mythtv/mythconverg_restore.pl --drop_database --create_database --verbose --directory /home/briggella --filename mythconverg-1348-20210525064119.sql.gz Configuring environment: - username: brig...
by briggella
Sat May 29, 2021 12:23 pm
Forum: Troubleshooting
Topic: [Solved] Myth v31.0 fails to restore database - unable to connect to database.
Replies: 15
Views: 8874
New Zealand

[Solved] Myth v31.0 fails to restore database - unable to connect to database.

I have installed Ubuntu 20.04.2.0 and Mythtv 31 and having got through the usual database password problems I am now trying to restore the original database to the system. There was remote access originally from a second machine so IP addresses were specified for the Backend server rather than just ...
by briggella
Sat Jun 27, 2020 7:25 am
Forum: Troubleshooting
Topic: Myth 29 - channel scan finds no channels when previously worked.
Replies: 13
Views: 597
New Zealand

Re: Myth 29 - channel scan finds no channels when previously worked.

mythtv-setup.20200627001040.4745.log Sorry about that - should have read it more carefully. I changed the Country setting in the Video Sources and didn't realise that the channel scanning had a separate setting that would override it. Once I followed your instructions, the Full scan worked for Tune...
by briggella
Fri Jun 26, 2020 9:10 pm
Forum: Troubleshooting
Topic: Myth 29 - channel scan finds no channels when previously worked.
Replies: 13
Views: 597
New Zealand

Re: Myth 29 - channel scan finds no channels when previously worked.

mythtv-setup.20200626201733.12718.log
Log of Myth-setup doing full scan with different country selections
(232.29 KiB) Downloaded 42 times
Now completed full scan with country codes NZ and Australia. No channels found.

Log attached.
by briggella
Fri Jun 26, 2020 7:24 pm
Forum: Troubleshooting
Topic: Myth 29 - channel scan finds no channels when previously worked.
Replies: 13
Views: 597
New Zealand

Re: Myth 29 - channel scan finds no channels when previously worked.

Actually the New Zealand selection doesn"t seem to work. I couldn't select NZ in w_scan and had to use default which turned out to be DE. The New Zealand selection in myth often doesn't work too so I have always left it at default. We are used to being forgotten about at this end of the world but we...
by briggella
Fri Jun 26, 2020 8:52 am
Forum: Troubleshooting
Topic: Myth 29 - channel scan finds no channels when previously worked.
Replies: 13
Views: 597
New Zealand

Re: Myth 29 - channel scan finds no channels when previously worked.

mythtv-setup.20200626080633.2656.log
Mythtv-setup log for scan of existing transports
(190.06 KiB) Downloaded 40 times
videosource.txt
Videosource Table
(425 Bytes) Downloaded 38 times
Other files
by briggella
Fri Jun 26, 2020 8:50 am
Forum: Troubleshooting
Topic: Myth 29 - channel scan finds no channels when previously worked.
Replies: 13
Views: 597
New Zealand

Re: Myth 29 - channel scan finds no channels when previously worked.

OK now things get interesting. By way of clarification, My original terrestrial transports were called Freeview for DVBT and Freeview2 for DVBT2 catds. In order to avoid any complications with these, I created new transports of Freeview-DVBT and Freeview-DVBT2 to do fresh scans and if they setup cor...
by briggella
Thu Jun 25, 2020 12:25 pm
Forum: Troubleshooting
Topic: Myth 29 - channel scan finds no channels when previously worked.
Replies: 13
Views: 597
New Zealand

Re: Myth 0.29 - channel scan finds no channels when previously worked.

Yes - I have also tried adapter2. The Si2168 tuners do not display signal strength, I believe due to a bug in the Linux Kernel, so I am limited to using the DVB-T tuners rather than the T2 tuners. They still work for watching TV but show signal strength as 0% which is not helpful. I haven't tried th...
by briggella
Thu Jun 25, 2020 10:11 am
Forum: Troubleshooting
Topic: Myth 29 - channel scan finds no channels when previously worked.
Replies: 13
Views: 597
New Zealand

Myth 29 - channel scan finds no channels when previously worked.

My first and previous post was two years ago with a similar problem when I was installing this system. After a few tweaks it has worked reasonably well since then. I am running mythtv version: fixes/29 v29.1-13-g329c235 on a Ubuntu 18.04 base with a HVR 5525 DVBS/DVBT PCIe card, an HVR NOVA TD500 du...