[mythtv-users] Remote frontend won't connect to database

Another Sillyname anothersname at googlemail.com
Tue May 13 12:12:21 UTC 2014 

Can you confirm that the settings for your mysql database allow access
from a remote IP address?

http://www.mythtv.org/wiki/MythTV-HOWTO_-_0.27#Modifying_access_to_the_MySQL_database_for_multiple_systems

On 6 May 2014 17:48, Yippee Three-eight <yp_38 at yahoo.com> wrote:
> I'm trying to get my remote frontend to connect to my backend.  I've been trying everything I could find via google, but nothing's worked yet.  I'm running 0.27 on both machines, and both machines are using OpenSUSE 13.1, x86_64.
>
> My backend appears to work fine.  I can use the frontend on the backend box, and mythweb works fine.  My firewall on the backend machine is not blocking any access on the internal network.
>
> When I run "mythfrontend --nologserver" on the frontend machine, this is the output:
> /> mythfrontend --nologserver
> 2014-05-06 11:05:36.928562 I  Setup Interrupt handler
> 2014-05-06 11:05:36.928593 I  Setup Terminated handler
> 2014-05-06 11:05:36.928604 I  Setup Segmentation fault handler
> 2014-05-06 11:05:36.928614 I  Setup Aborted handler
> 2014-05-06 11:05:36.928623 I  Setup Bus error handler
> 2014-05-06 11:05:36.928633 I  Setup Floating point exception handler
> 2014-05-06 11:05:36.928644 I  Setup Illegal instruction handler
> 2014-05-06 11:05:36.928656 I  Setup Real-time signal 0 handler
> 2014-05-06 11:05:36.928668 I  Setup User defined signal 1 handler
> 2014-05-06 11:05:36.928678 I  Setup User defined signal 2 handler
> 2014-05-06 11:05:36.928832 C  mythfrontend version: tag: v0.27 [317d5b7] www.mythtv.org
> 2014-05-06 11:05:36.928842 C  Qt version: compile: 4.8.5, runtime: 4.8.5
> 2014-05-06 11:05:36.928848 N  Enabled verbose msgs:  general
> 2014-05-06 11:05:36.928865 N  Setting Log Level to LOG_INFO
> 2014-05-06 11:05:36.929078 N  Using runtime prefix = /usr
> 2014-05-06 11:05:36.929098 N  Using configuration directory = /home/tonka/.mythtv
> 2014-05-06 11:05:36.929234 I  Assumed character encoding: en_US.UTF-8
> 2014-05-06 11:05:36.929327 I  Added logging to the console
> 2014-05-06 11:05:36.929824 I  Using localhost value of Tonka_htpc_front
> 2014-05-06 11:05:36.929992 I  Testing network connectivity to '10.6.2.27'
> 2014-05-06 11:05:36.931645 I  Starting process manager
> 2014-05-06 11:05:36.933025 I  Starting IO manager (write)
> 2014-05-06 11:05:36.937239 I  Starting process signal handler
> 2014-05-06 11:05:36.943517 I  Starting IO manager (read)
> 2014-05-06 11:07:44.283284 E  Unable to connect to database!
> 2014-05-06 11:07:44.283338 E  Driver error was [1/2003]:
> QMYSQL: Unable to connect
> Database error was:
> Can't connect to MySQL server on '10.6.2.27' (110)
>
> 2014-05-06 11:07:44.353895 N  Desktop video mode: 1920x1080 60.000 Hz
> 2014-05-06 11:07:44.399180 E  LIRC: Failed to connect to Unix socket '/dev/lircd'
>             eno: Permission denied (13)
> 2014-05-06 11:07:44.399225 E  JoystickMenuThread: Joystick disabled - Failed to read /home/tonka/.mythtv/joystickmenurc
> 2014-05-06 11:07:44.399238 I  UDPListener: Enabling
> 2014-05-06 11:07:44.399963 I  Binding to UDP 127.0.0.1:0
> 2014-05-06 11:07:44.400028 I  Binding to UDP 10.6.2.33:0
> 2014-05-06 11:07:44.400080 I  Binding to UDP 10.6.2.255:0
> 2014-05-06 11:07:44.411832 I  Using Frameless Window
> 2014-05-06 11:07:44.411886 I  Using Full Screen Window
> 2014-05-06 11:07:44.421444 I  Using the Qt painter
> 2014-05-06 11:07:44.831119 I  MythCoreContext: Connecting to backend server: localhost:6543 (try 1 of 1)
> 2014-05-06 11:07:44.831315 E  No address defined for host: localhost
> 2014-05-06 11:07:44.843838 N  Setting QT default locale to en_US
> 2014-05-06 11:07:44.848695 E  MythSocket(7f5e5800c030:-1): Failed to connect to (127.0.0.1:6543) Connection refused
> 2014-05-06 11:07:44.853967 E  Connection to master server timed out.
>             Either the server is down or the master server settings
>             in mythtv-settings does not contain the proper IP address
> <the last five 'lines' repeat endlessly>
>
> I can't figure out why I'm getting these lines:
> 2014-05-06 11:07:44.831119 I  MythCoreContext: Connecting to backend server: localhost:6543 (try 1 of 1)
> 2014-05-06 11:07:44.831315 E  No address defined for host: localhost
>
> Why is it trying to connect to localhost?
>
> Obviously, I'm getting no log files.  I run --nologserver because about 85% of the time, when I don't use that option, the frontend hangs on "adding logging to mythlogserver at TCP:<something>", but that's a different issue.
>
>
> My /home/<username>/config.xml on both boxes looks like this:
> <Configuration>
>   <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
>   <Database>
>     <PingHost>1</PingHost>
>     <Host>10.6.2.27</Host>
>     <UserName>mythtv</UserName>
>     <Password>mythtv</Password>
>     <DatabaseName>mythconverg</DatabaseName>
>     <Port>3306</Port>
>   </Database>
>   <WakeOnLAN>
>     <Enabled>0</Enabled>
>     <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
>     <SQLConnectRetry>5</SQLConnectRetry>
>     <Command>echo 'WOLsqlServerCommand not set'</Command>
>   </WakeOnLAN>
> </Configuration>
> The only difference is that I've given my frontend a LocalHostName.
>
> My my.cnf file on the frontend looks like this:
> # This is default example of MySQL/MariaDB configuration provided with openSUSE
> # It is based on upstream defaults with some additional examples.
>
> # The following options will be passed to all MariaDB clients
> [client]
> # password  = your_password
> # port       = 3306
> # socket     = /var/run/mysql/mysql.sock
>
> [mysqld]
>
> # Remove leading # if you don't want to listen on network (only socket - safer)
> # skip-networking
>
> # Remove leading # and set to the amount of RAM for the most important data
> # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
> # innodb_buffer_pool_size = 128M
>
> # Using newer file format that supports dynamic and compressed row formats.
> # If you are using replication you have to make sure, that these options are
> # set everywhere the same way (probably comment them out is the easiest way)
> innodb_file_format=Barracuda
> innodb_file_per_table=ON
>
> # Remove leading # to turn on a very important data integrity option: logging
> # changes to the binary log between backups.
> # log_bin=mysql-bin
> # binlog_format=mixed
>
> # Remove leading # if you want to store your database elsewhere
> # datadir       = /var/lib/mysql
>
> # required unique id between 1 and 2^32 - 1
> # defaults to 1 if master-host is not set
> # but will not function as a master if omitted
> server-id       = 1
>
> # These are commonly set, remove the # and set as required.
> # port = 3306
> # socket = /var/run/mysql/mysql.sock
>
> # Don't listen on a TCP/IP port at all. This can be a security enhancement,
> # if all processes that need to connect to mysqld run on the same host.
> # All interaction with mysqld must be made via Unix sockets or named pipes.
> # Note that using this option without enabling named pipes on Windows
> # (via the "enable-named-pipe" option) will render mysqld useless!
> #
> # skip-networking
>
> # Remove leading # to set options mainly useful for reporting servers.
> # The server defaults are faster for transactions and fast SELECTs.
> # Adjust sizes as needed, experiment to find the optimal values.
> # join_buffer_size = 128M
> # sort_buffer_size = 2M
> # read_rnd_buffer_size = 2M
>
> sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
>
>
> [mysqld_multi]
> mysqld     = /usr/bin/mysqld_safe
> mysqladmin = /usr/bin/mysqladmin
> log        = /var/log/mysqld_multi.log
>
> # If you want to use mysqld_multi uncomment 1 or more mysqld sections
> # below or add your own ones.
>
> # WARNING
> # --------
> # If you uncomment mysqld1 than make absolutely sure, that database mysql,
> # configured above, is not started.  This may result in corrupted data!
> #
> # [mysqld1]
> # port       = 3306
> # datadir    = /var/lib/mysql
> # pid-file   = /var/lib/mysql/mysqld.pid
> # socket     = /var/lib/mysql/mysql.sock
> # user       = mysql
>
> # [mysqld2]
> # port       = 3307
> # datadir    = /var/lib/mysql-databases/mysqld2
> # pid-file   = /var/lib/mysql-databases/mysqld2/mysql.pid
> # socket     = /var/lib/mysql-databases/mysqld2/mysql.sock
> # user       = mysql
>
> # [mysqld3]
> # port       = 3308
> # datadir    = /var/lib/mysql-databases/mysqld3
> # pid-file   = /var/lib/mysql-databases/mysqld3/mysql.pid
> # socket     = /var/lib/mysql-databases/mysqld3/mysql.sock
> # user       = mysql
>
> # [mysqld6]
> # port       = 3309
> # datadir    = /var/lib/mysql-databases/mysqld6
> # pid-file   = /var/lib/mysql-databases/mysqld6/mysql.pid
> # socket     = /var/lib/mysql-databases/mysqld6/mysql.sock
> # user       = mysql
>
> !includedir /etc/my.cnf.d
>
>
> The my.cnf file on my backend is the same.  I did try adding the line "bind-address 0.0.0.0" to the my.cnf on the backend also.
>
> Neither machine has a mysql.cnf nor a mythtv.cnf.
>
> Any suggestions on what I can try?
>
> Mike B
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

More information about the mythtv-users mailing list