Search found 216 matches

by diyhouse
Thu Mar 18, 2021 9:35 pm
Forum: General Discussion
Topic: [Solved] tuner card device file order control with udev
Replies: 2
Views: 141
Great Britain

Re: tuner card device file order control with udev

Many tx Paul,.. adapter_nr,.. was the solution,... ( light bulb moment you might say ),... as I had seen this else where and not twigged, as they say. For the TBS cards 6285 & 6904 the solution is as follows:- vi /etc/modprobe.d/dvb.conf options tbsecp3 adapter_nr=1,2,3,4 options saa716x_core adapte...
by diyhouse
Tue Mar 16, 2021 5:21 pm
Forum: General Discussion
Topic: [Solved] tuner card device file order control with udev
Replies: 2
Views: 141
Great Britain

[Solved] tuner card device file order control with udev

Greeting all,.. I have just upgraded my system with a new quad SAT tuner,.. to add to my quad Freeview tuner. By default when the kernel installs, the devices appear in a random order,.. 1 sat tuner,.. followed by 4 FView tuners, and then the remaining 3 SAT tuners. I have seen the udev stuff using ...
by diyhouse
Mon Jan 18, 2021 8:52 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

Re: DataBase login/Connection failing

Yabba dabba Doo,.. !!!!!!!!!!!!!!!!!!!!!!! that was a good guess! ! Executing command: 'mysql' --defaults-extra-file='/tmp/LpdhPoMbTV' --host='localhost' --port='3306' --user='mythtv' 'mythconverg' mysql exited with status: 0 Restored 4588 of 4588 lines. Successfully restored backup. Found DBSchemaV...
by diyhouse
Mon Jan 18, 2021 5:00 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

Re: DataBase login/Connection failing

Hi Bill,.. Many Tx for your help,.. have made some progress,.. but still unable to restore old Database.. Have run the following commands:- drop user 'mythtv'@'localhost'; # localhost user creation. CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH mysql_native_password; ALTER USER 'myt...
by diyhouse
Sun Jan 17, 2021 8:39 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

Re: DataBase login/Connection failing

Tx's for responding Bill,.. So if I do a mysql> DROP USER mythtv; from the sql prompt,.. and then enter your commands as given (line by line) how does this script overcome my issue of setting the passwd to that required by my old database,.. password: KCd22fwc, and hopefully enable me to restore my ...
by diyhouse
Sun Jan 17, 2021 4:49 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

Re: DataBase login/Connection failing

OK,.. so I'm still pulling my hair out,.. whats left :D I am using the following command:- Any pointers/help gratefully received,..... Does the BE need to be running and attached to the Dbase??? ( using the original created install SQL credentials )??? Just checking my understanding. /usr/share/myth...
by diyhouse
Sat Jan 16, 2021 5:55 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

Re: DataBase login/Connection failing

I have found this SQL statement:- ALTER USER USER() IDENTIFIED BY 'auth_string' REPLACE 'current_auth_string'; But I am struggling with its usage,.. as I don't wont to mess-up my dbase,.. I envisage usage something like as follows, taking the output from the sql output mysql> SELECT User,Host,plugin...
by diyhouse
Sat Jan 16, 2021 2:30 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

Re: DataBase login/Connection failing

Update:- found these posts with some extra bits that seem to allow for passwd update; For Ubuntu 19 with MySQL 8.0.17-0ubuntu2, what ended up working for me was a combination of many answers: In the MySQL's configuration file (/etc/mysql/mysql.conf.d/mysqld.cnf on my machine), under [mysqld], add: s...
by diyhouse
Sat Jan 16, 2021 1:53 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

Re: DataBase login/Connection failing

well found a whole bunch of scripts and methods to change the root sql password,.. but none seem to work. the basics seem to be as follows:- Once the mysql server has been stopped and run from the following comand line sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking & mysql -u root ,... ...
by diyhouse
Sat Jan 16, 2021 9:19 am
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

Re: DataBase login/Connection failing

Hi Wes,.. Many tx for getting back,.. I have checked both /home/USER/.mythtv and /home/mythtv/.mythtv and /etc/mythtv folders,.. and the only only xml file here is the config.xml.. which contains only the old credentials that I wish to 'change to',.. ( this is the config.xml file have saved from my ...
by diyhouse
Fri Jan 15, 2021 2:50 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
Great Britain

DataBase login/Connection failing

Hi guys I'm in the middle of a 29 to 31 clean upgrade on an Xubuntu base. mysql Database appears to be running,.. but I cannot connect the backend to it,... This I believe is due to the newly created database having a new 'passwd key',.. understandable,... what i cannot find is what the mysql root p...
by diyhouse
Tue Dec 29, 2020 9:23 pm
Forum: General Discussion
Topic: connecting Mythweb across subnets
Replies: 4
Views: 215
Great Britain

Re: connecting Mythweb across subnets

thanks for that Bill,.. I have been pondering a upgrade to 20.04 and the latest Mythtv,... on a clean install,... I think this may be the opportunity to start that process... as I don't want to do the multiple subnet stuff twice...
by diyhouse
Tue Dec 29, 2020 1:51 pm
Forum: General Discussion
Topic: connecting Mythweb across subnets
Replies: 4
Views: 215
Great Britain

Re: connecting Mythweb across subnets

Hi Bill yes tx for the comments,.. YES,.. I can run msql across subnets.... So currently looking at apache2 stuff and sites available and enabled,.. and as far as I can see I have nothing loaded,.. So I assume Apache2 is just taking defaults for home network,.. and nothing outside of that!... so hen...
by diyhouse
Mon Dec 28, 2020 10:39 pm
Forum: General Discussion
Topic: connecting Mythweb across subnets
Replies: 4
Views: 215
Great Britain

connecting Mythweb across subnets

I have a combined myth FE/BE on a 192.168.3.x network,.. and web client on a 192.168.6.x subnet ( all controlled from a pfsense firewall ). I have tried connecting and enabling connections,.. the ports 3300 to 6600 are open but I cannot connect to mythweb, even though ping work in both directions. I...
by diyhouse
Mon May 25, 2020 3:45 pm
Forum: Raspberry Pi
Topic: Raspberry Pi 4 Case + Fan
Replies: 7
Views: 1003
Great Britain

Re: Raspberry Pi 4 Case + Fan

I had similar problems with my Pi4 feeling a little on the 'hot' side,.. I didn't like the horrible little 5v fans that were supplied so I decided to re-vamp the the cooling and power supply. So I mounted a larger 12v fan topside of a piece of perspex,.. with a small variable power supply,. Ok so it...