I'm sure I'm doing something wrong... I know someone's gonna say "if you'd search the forum you'd find ________." But I'll post here and risk the embarassment...

Trying to run the frontend off of CD, just to see how it would work. MythTV never starts, and if I try to start it manually from a terminal window, it says it can't connect to the database, something about mysql.sock.

I have double and triplechecked my backend settings:

* commented out skip-networking in /etc/mysql/my.cnf
* restarted MySQL as root
* mythtv-setup has 127.0.0.1 changed to 192.168.1.30 (internal IP number for backend)
* I have not changed the mythtv MySQL password from its default on the back end, which I'm assuming is mythtv

The searches I've done here that I could find usually suggest that database connection problems are due to the password, but I haven't changed the mythtv MySQL password as far as I know (I did change the account's password so I could connect to it via SSH without everyone being able to get in as mythtv).

Or are the instructions talking about changing something about the frontend to make sure the password is mythtv on the frontend? If so, it's unclear to me how to do that, both from the instructions and from the messages I've found.

Thanks.

You will need to change the password for mysql, it is no longer mythtv, the password you should change it to is q2dUSRDq

You need to edit /usr/share/mythtv/mysql.txt
and change the line DBPassword=mythtv to DBPassword=q2dUSRDq

One sure way to find out:

- Start an xterm when the frontend doesn't start (left click, select xterm)
- Try to connect "manually" to your backend

(I am doing this from memory, so it might be slightly different)

You will then find out which of the two passwords you should use (depends on KnoppMyth version, I gather), and if you can connect via the network at all.

One more thing. After you have set everything up on the backend (comment out network stuff for mysql, setting in Myth), MAKE SURE to restart mythbackend!!
In my case, I only restarted mysqld and it took me quite a while to figure out what the problem was...

Also, did you modify the backend's IP address in the frontend setup dialog?? If you don't pay attention, it's easy to just accept the default settings that point to localhost...

Laurent

Thanks for the replies. Here's what I've determined:

* MySQL password is mythtv, not q2dUSRDq (at least for 0.15.1)
* I am stupid
* I feel the instructions aren't explicit enough for stupid people like me.
* I would propose that the frontend installation instructions be changed to the following:



Yes, I just blew right by the dialog after setting timezone, without entering the IP number of my MythTV backend. Just as saruman warned. I had left it at "localhost" and of course it couldn't connect to anything.

"Well," you are saying, "how was the frontend supposed to know what to connect to? Should it be psychic or something?"

Actually, yes, I thought maybe MythTV was broadcasting something, like iTunes does with Rendezvous, and that I didn't need to configure the frontend. I'm also surprised the dialog doesn't say "hey, you should at LEAST change 'localhost' to an IP number here, or it's not going to work."

Anyhow, the instructions should also probably mention restarting the backend after making the IP number changes in mythtv-setup.

Sorry if my instructions suck... Use XSecret's wiki...

_________________
cesman

When the source is open, the possibilities are endless!

1) They don't suck

2) I have always wondered why the password in frontend mode was different to the installed password for a backend. Any chance of changing that? (one less thing to be misinterpreted in the documentation :- )

_________________
| Nigel Pearson, nigel.pearson.au@gmail.com
| "Things you own end up owning you" - Tyler, Fight Club

I agree that they don't suck, but I also am happy to help with trying to clarify them... and yes, I've already been to the wiki and took a shot at them. Hope it helped.

The password is now mythtv to access on localhost or over the network.

_________________
cesman

When the source is open, the possibilities are endless!

Have a working R4V5 box. Want to run frontend from CD from my Dell D800 laptop.


On backend :
Did the commenting of skip-networking line.
Did the restart of mysql
did the IP address of the backend in mythtv-startup.

Exact same issues as start of thread post EXCEPT.

After Selecting TImezone get prompt for using DHCP. If I say yes, or configure manually network connection is made, no problem. Then it goes into an X session. It never asked for the IP address of the backend! Myth frontend does not start. I can ping my myth backend server. I can connect to the mysql on the backend with the "mysql -u mythtv -p -h backend_ip_address mythconverg" command just fine from xterm.

Seems I'm so close. Just can't seem to get the CD booted front end pointed to the backend.

Editing localhost on database parameters page did it.