Author Topic: Cannot connect to myth backend server...  (Read 1891 times)

puddy

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
Cannot connect to myth backend server...
« on: November 11, 2007, 05:35:33 pm »
After going through myth setup and trying to start tv, I get a message saying that myth is having problems and is trying to reset.  After a bit, I get the "Cannot connect to myth backend server. Is it running?  Is the ip set correctly in setup."  This is on a diskless MD with a core only machine running elsewhere on the network.  Running mythbackend on my core I get the following:

Using runtime prefix = /usr
New DB connection, total: 1
Unable to connect ot database!
Driver error was [1/1045]:
QMYSQL3:Unable to connect
Database error was:
Access denied for user 'mthtv'@'localhost' (using password: YES)

QSqlQuery::exec:database not open
QSqlQuery::exec:database not open
DB ERROR (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
Failed to init Mythcontext, exiting.

I can access MySql from the configuration screen in mce manager.

I have searched the forum as well as google, with no clear answer to the problem.  Any help is appreciated.



rwilson131

  • Veteran
  • ***
  • Posts: 118
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #1 on: November 11, 2007, 06:24:09 pm »
Myth connects with a different username and password.  I believe the location is

/usr/share/mythtv/mysql.txt

Find out the password on the Core via
Code: [Select]
cat /usr/share/mythtv/mysql.txt
Then ssh moon<#> and match the file password with the one from the Core

can you connect with from the MD
Code: [Select]
mysql -h 192.168.80.1 -u mythtv -p mythconverg
using the password from the core file.

Thanks
Rob

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #2 on: November 11, 2007, 06:36:40 pm »
Normally you're not supposed to have to run mythbackend by hand.  It does sound like a setup or configuration problem to me, but I have never encountered those errors myself.

I think you need to check /etc/mythtv/mysql.txt both on the core and on the MD, iirc there are also some setup options when you start TV from the orbitter that you could check. 

Googling "Access denied for user 'mythtv'@'localhost'" gave me this as the third result: https://help.ubuntu.com/community/MythTV/Install/Troubleshooting which might contain some more info.


"Change is inevitable. Progress is optional."
-- Anonymous


puddy

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #3 on: November 11, 2007, 11:39:28 pm »
Thanks for all the help and suggestions, and I am making some progress.  When I try to play TV now I get a dialog saying that I must be a member of the mythtv group and would I like to be added automatically.  When I answer yes it goes to a screen that says I must manually restart the session.  How do I do that from inside MCE.  Or should I just add my MCE user to the mythtv group?

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #4 on: November 12, 2007, 12:07:57 am »
I don't really understand why you are having so much trouble, normally none of this is needed.

Anyway, to answer your question, edit the /etc/group file by hand with your favorite text editor under KDE (like kate or nano), find the line starting with "mythtv:" and append "linuxmce" to it.  So that it looks something like:
Code: [Select]
mythtv:x:123:root,linuxmce

That should get you past the error I reckon.

PS. I didn't mean to try and "correct/contradict" you rwilson131, I completely overlooked your reply before, sorry.
"Change is inevitable. Progress is optional."
-- Anonymous


puddy

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #5 on: November 12, 2007, 02:08:05 am »
Are the problems I am seeing possibly from installing from cd's and installing a 'core only' server?  Anyway, thanks for the help.

puddy

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #6 on: November 12, 2007, 02:37:13 am »
Under mythfrontend setup there is a user field.  What is this field supposed to be set to,  linuxmce or mythtv?  It is currently set to mythtv and adding linuxmce to /etc/group under mythtv did not fix my problem.

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #7 on: November 12, 2007, 06:37:40 am »
So it still complains that you're not a member of the mythtv group?  How strange.

That user is normally set to mythtv.

I don't think the problem is with the cd installer.

"Change is inevitable. Progress is optional."
-- Anonymous


puddy

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #8 on: November 12, 2007, 05:40:05 pm »
I think I saw a post somewhere saying that this was solved, at least once, by unplugging the pvr-usb2, deleting it from the md in web-admin, and then hot plugging it.  I think I will give that a try.  Again, thanks for all the help and suggestions. 

puddy

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
Re: Cannot connect to myth backend server...
« Reply #9 on: November 14, 2007, 07:11:57 pm »
Well, uninstalling and reinstalling didn't help.  I freakin' give up.  I'm going to reload linuxmce from the dvd this time (this will make the 4th time I've installed it) and try again.  I seem to get a little closer to everything working each time.

jpmswiss

  • Guest
Re: Cannot connect to myth backend server...
« Reply #10 on: November 23, 2007, 02:48:25 pm »
I'm going to reload linuxmce from the dvd this time (this will make the 4th time I've installed it) and try again.  I seem to get a little closer to everything working each time.

I just did that.....and i have the same "can't connect" problem!
Maybe it has something to do with the order/sequence Myth is set up. ???

Besides Myth and some error messages in the Orbiter about some devices (20/21 embedded phone) not loaded correctly  - everything else seems to work OK. All of my Audio/Video files were found  ;D