Thanks! I'll give that a try when I get back to my boxes.

SWEET !!

That worked without having to drop the mythconverg DB.



To save a step I used and tested below mysqul update command and worked as well.



After making that DB change my R5A26 Frontend connects to my R5A26 Backend fine.

Someone want to update the R5A26 WIKI info? It may be safer to make 1 DB change than to drop the entire DB.

To be safe, I would advise against this particular SQL command, as you probably will have multiple rows in the settings table for the DBSchemaVer value at this point. It appears that mythfrontend can handle it, but it does not look like this is what is intended.

Glad, though, that it worked for you!

So does the above work. and is it safe?

snake

But couldn't multiple rows also be deleted using below DELETE MYSQL command as well?



I am not a SQL expert I just researched the UPDATE command in trying to fix the problem prior to reading your post.


Safe ? IMO Using the above MYSQL commands to change the MySQL DB, is safer than dumping the DB, loosing all data and restoring.

Thanks again for everyone's help.

Work ?. I posted to someone else how to fix and they noted worked for them too. http://mysettopbox.tv/phpBB2/viewtopic.php?t=7287

The update command should be safe, and will not produce multiple occurances since the whole point of using update versus insert is to update in place.

So DBSchemaVer had no effect for me, but I found another setting that did.
I noticed that my frontend was trying to connect to localhost even though I had configured it to connect to the address of my master backend server.

I then noticed that MasterServerIP in settings had a hostname set. Both changing the hostname to NULL and adding a row with the hostname of my frontend machine both worked.

Here's a crazy new develoment. The frontend on my backend server as well as a PC frontend running RA26 both show a complete set of recordings. The frontend on the Macintosh only shows one of my recordings. The Mac will play that one recording just fine and will also play live TV. *shrug* I can live with that but I wonder what the cause is?

That is the intention...it appears that there is only supposed to be *one* DBSchemaVer row in the table. The DELETE command removes ALL rows (since, if you are getting the aforementioned error, you probably have multiple rows, which appears to be non-standard) so that the subsequent INSERT command leaves you with exactly one row.

The solution to both of these database issues are documented at the end of this page on the wiki:

http://knoppmythwiki.org/index.php?page=FrontendOnlyInstall

The fix for MasterServerIP is listed in the R5A22 notes, and the fix for the DBSchemaVer is listed in the notes for R5A26.

One question here. I just checked the "settings" table from webmin and notice that a fresh install of R5A26 sets the hostname to a non-NULL value for every value in that table. Should these all be set to NULL or are MasterServerIP and DBSchemaVer enough?

The settings table contains the settings that apply (a) to all devices and (b) to each device individually. All (or almost all) of the settings that you set in Utilities/Setup through the frontend are stored in this table (along with some other settings for some add-ons). This is why you are able to set, say, one frontend to use xine for DVD playback and another to use mplayer.

Those settings that are intended to be specific to a frontend will have the hostname value filled-in. Those settings that are intended to apply to all devices (e.g. the DBSchemaVer) will have a NULL value for the hostname; which, also, is why there should ONLY be ONE row for those settings.

If anyone who actually does development on the myth database side can expand or refute my statements, please do so. I am basing these conclusions strictly through my own digging.

I was having many of the same issues while using R5A26 on my backend and FC4 on my frontend. Part of this thread helped me to get closer. But I was still having problems with the frontend saying cannot connect to master server. But everything in mythtv-setup looked good and I had followed all the instructions to setup sql permissions, allow networking, setting up my.cnf and sql.txt, etc. And I could see traffic in my sql log so I knew the frontend was accessing the db ok.

What it ended up being was that the settings table only had one row for my backend:

mysql> select * from settings where value="MasterServerIP";
+----------------+-------------+----------+
| value | data | hostname |
+----------------+-------------+----------+
| MasterServerIP | 192.168.1.4 | backend |
+----------------+-------------+----------+
1 row in set (0.00 sec)



So I added it also for the frontend and all of a sudden everything worked correctly! I suspect I could have made hostname null and it would've worked too.
mysql> insert into settings (value,data,hostname) VALUES 'MasterServerIP', '192.168.1.4', 'frontend');

frego, if you are willing to use a more recent version of mythfrontend, you can examine the SQL requests, which might help you debug the problem. e.g.

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

The only thing that works for me 100% is dumping the database. BUT< I did this on a fresh install of R5A26. Not and update or on a box that I had been running. THAT WOULD BE A PAIN!

But is you are starting FRESH as I was, dropping the database works first time everytime. As far as recorded programs, Really, after thinking about it, you watch it, does anybody keep it? if so WHY? Put it on DVD or VCD


Don't reply to that question! lol..

So far, I've followed all of these instructions (except dropping the database) and it's still not working for me.

Of course I'm assuming this gets fixed in the next release of KnoppMyth. anyone know when that's due out?

_________________
<blockquote><i>"I Said I Was Smart, I Never Said I Was Mature..."</i><br>
--Ivan Kowalenko</blockquote>

When it's ready. There really isn't a better answer. It shouldn't be more than a couple months...