[mythtv-users] 0.28 upgrade issue frontend connection

[Douglas Peale]

On 07/17/2016 01:01 AM, Mark Perkins wrote:
>> This is a single computer mythTV setup, so external access is not
> expected.
>
> Ok.
>
>> The IP address of this computer is 192.168.63.3  so for this machine, it
> should work the same as 127.0.0.1 or localhost.
>
> Agreed. Should. At least when the bound address is 0.0.0.0 not sure it
> does/should for the initial case where the mysqld bound address was
> 127.0.0.1.
>
> At this point you could probably just test this command:
> mysql -h127.0.0.1 -umythtv -pb0RhwvPj -e "select * from mythconverg.settings where value='BackendServerIP'"
>  
>
> And if / when that works update config.xml to use 127.0.0.1 as the IP
> address and call it a day. Probably also re-comment out the bind-address
> line in /etc/mysql/mysql.conf.d/mythtv.cnf just to tighten things up a
> little.
>
> However based on the netstat output using the IP address of 192.168.63.3
> should now have worked (mysqld is now bound to 0.0.0.0). Assuming you don’t
> have a firewall blocking things (I don't know what Mint uses for firewall)
> and also assuming there is not something odd happening with IPv6 I would be
> very very tempted to try this:
>
> mysql -uroot -pb0RhwvPj -e "grant all on mythconverg.* to
> 'mythtv'@'192.168.63.%' identified by 'mythtv';
> mysql -uroot -pb0RhwvPj -e "set password for
> 'mythtv'@'192.168.63.%'='b0RhwvPj'"
> mysql -uroot -pb0RhwvPj -e "flush privileges"
> mysql -h192.168.63.3 -umythtv -pb0RhwvPj -e "select * from
> mythconverg.settings where value='BackendServerIP'"
>
> If this works, then in my opinion it seems to show that a host value of %
> does not work as a wildcard for 192.168.63.%. If it works that is. Please
> let me know if you try it.
>
> Also, if the topmost command using -h127.0.0.1 does not work you could try
> this:
>
> mysql -uroot -pb0RhwvPj -e "grant all on mythconverg.* to
> 'mythtv'@'127.0.0.1' identified by 'mythtv';
> mysql -uroot -pb0RhwvPj -e "set password for
> 'mythtv'@'127.0.0.1'='b0RhwvPj'"
> mysql -uroot -pb0RhwvPj -e "flush privileges"
> mysql -h127.0.0.1 -umythtv -pb0RhwvPj -e "select * from mythconverg.settings
> where value='BackendServerIP'"
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
$ mysql -h127.0.0.1 -umythtv -pb0RhwvPj -e "select * from mythconverg.settings where value='BackendServerIP'"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-----------------+--------------+------------+
| value           | data         | hostname   |
+-----------------+--------------+------------+
| BackendServerIP | 192.168.63.3 | Compromise |
| BackendServerIP | 192.168.63.3 | Compromise |
+-----------------+--------------+------------+

$ mysql -uroot -pb0RhwvPj -e "grant all on mythconverg.* to 'mythtv'@'192.168.63.%' identified by 'mythtv';
> ^C

seem to be missing a quote

$ mysql -uroot -pb0RhwvPj -e "grant all on mythconverg.* to 'mythtv'@'192.168.63.%' identified by 'mythtv';"
mysql: [Warning] Using a password on the command line interface can be insecure.

$ mysql -uroot -pb0RhwvPj -e "set password for 'mythtv'@'192.168.63.%'='b0RhwvPj'"
mysql: [Warning] Using a password on the command line interface can be insecure.

$ mysql -uroot -pb0RhwvPj -e "flush privileges"
mysql: [Warning] Using a password on the command line interface can be insecure.

$ mysql -h192.168.63.3 -umythtv -pb0RhwvPj -e "select * from mythconverg.settings where value='BackendServerIP'"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-----------------+--------------+------------+
| value           | data         | hostname   |
+-----------------+--------------+------------+
| BackendServerIP | 192.168.63.3 | Compromise |
| BackendServerIP | 192.168.63.3 | Compromise |
+-----------------+--------------+------------+

The command seems to work, but both mythweb and liveTV are still not working.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160717/81cff447/attachment.sig>