Ok. I have not had luck on my previous quest to get this to work.

1. I have installed A26 three times. Twice to confirm this problem. The third time to upgrade to better hardware so I can run an HD3000 card.

2. First install was automagic install. Second install was manual per the docs. the third was auto again.

3. everything works great on local console.

4. I followed this from the docs all three times.

If you are running KnoppMyth as your backend server, Then on the backend:

* Edit /etc/mysql/my.cnf, comment out 'skip-networking'. The backend will only accept the mythtv user with a password of mythtv.
Before:
skip-networking
After
# skip-networking
* Restart MySQL(as root)
# /etc/init.d/mysql restart
* Reconfigure MythTV (as the mythtv user)
$ mythtv-setup
On screen 1 change 127.0.0.1(both instances) to the actual IP of the backend server.
<ESC> out of the myth-setup.

End of backend section.

5. Every frontend including the one on the A26 cd, gets some version of the following.

/Users/dhickman/Applications/MythFrontend.app/Contents/Resources
2005-11-21 00:00:43.506 New DB connection, total: 1
Total desktop width=2048, height=768, numscreens=2
2005-11-21 00:00:43.564 Using screen 0, 1024x768 at 0,0
2005-11-21 00:00:43.604 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
2005-11-21 00:00:43.606 New DB connection, total: 2
2005-11-21 00:00:43.622 Told to create a NEW database schema, but the database
already has 69 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

2005-11-21 00:00:43.623 Database Schema upgrade FAILED, unlocking.
2005-11-21 00:00:43.625 Couldn't upgrade database to new schema, exiting.

6. These clients work fine with another current install of 0.18.1

7. The three installs of A26 are fresh installs, no upgrades., I have been using myth tv for over a year and knoppmyth as a frontend for about three months.


If I am doing something wrong please post the url of a correct how-to...

Right now I am stuck using the box from my mediaMVP which can not decode the HD feeds.

Thanks

dhh

Try querying the database on your backend from one of your frontends (e.g. grab a copy CocoaMySQL for your Mac, point it at your backend's IP address, the database mythconverg, user and password mythtv), and have a look at the tables.

Can you see DBSchemaVer in settings? What value does it have?

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

1083

Hmmm. So the database is definitely there, and has data.
I just did a test install at work, and get the same problem.
Yet, on an R5A26 box at home (that I have since updated to SVN head),
the problem isn't manifest.


mythfrontend -v all says:
2005-11-28 15:37:04.469 MSqlQuery: SELECT data FROM settings WHERE value = 'GuiWidth' AND hostname IS NULL;
2005-11-28 15:37:04.472 MSqlQuery: SELECT data FROM settings WHERE value = 'GuiHeight' AND hostname = 'macaque.ind.tansu.com.au' ;
2005-11-28 15:37:04.483 MSqlQuery: SELECT data FROM settings WHERE value = 'GuiHeight' AND hostname IS NULL;
2005-11-28 15:37:04.485 Enabling Settings Cache.
2005-11-28 15:37:04.486 Clearing Settings Cache.
2005-11-28 15:37:04.488 user: 505 effective user: 505 before privileged thread
2005-11-28 15:37:04.489 user: 505 effective user: 505 run_priv_thread
2005-11-28 15:37:04.491 user: 505 effective user: 505 after privileged thread
2005-11-28 15:37:04.529 MSqlQuery: SELECT data FROM settings WHERE value = 'DBSchemaVer' AND hostname = 'macaque.ind.tansu.com.au' ;
2005-11-28 15:37:04.531 MSqlQuery: SELECT data FROM settings WHERE value = 'DBSchemaVer' AND hostname IS NULL;
2005-11-28 15:37:04.531 Current Schema Version:
2005-11-28 15:37:04.532 Newest Schema Version : 1110
2005-11-28 15:37:04.534 MSqlQuery: CREATE TABLE IF NOT EXISTS schemalock ( schemalock int(1));
2005-11-28 15:37:04.535 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
2005-11-28 15:37:04.536 MSqlQuery: LOCK TABLE schemalock WRITE;
2005-11-28 15:37:04.537 Current database schema version
2005-11-28 15:37:04.539 New DB connection, total: 2
2005-11-28 15:37:04.563 MSqlQuery: SHOW TABLES;
2005-11-28 15:37:04.564 Told to create a NEW database schema, but the database already has 68 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

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

Did we ever find out an answer to this problem..

I have the exact same thing..


2005-11-28 13:29:10.194 New DB connection, total: 1
Total desktop width=1152, height=864, numscreens=1
2005-11-28 13:29:10.203 Using screen 0, 1152x864 at 0,0
2005-11-28 13:29:10.210 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
2005-11-28 13:29:10.212 New DB connection, total: 2
2005-11-28 13:29:10.216 Told to create a NEW database schema, but the database
already has 68 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

2005-11-28 13:29:10.217 Database Schema upgrade FAILED, unlocking.
2005-11-28 13:29:10.217 Couldn't upgrade database to new schema, exiting.

Oops. This is a bug (in 0.18 ) that I forgot about. We need to insert a value in the database. This command did it for me:

INSERT INTO settings (value, data, hostname) VALUES ('DBSchemaVer', '1083', 'macaque.ind.tansu.com.au');

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

The value of "macaque.ind.tansu.com.au" should be our own mythtv hostname right?

For those that want to try the command:

Type "mysql"

mysql> use mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> INSERT INTO settings (value, data, hostname) VALUES ('DBSchemaVer', '1083', 'mythtv.localdomain.local');
Query OK, 1 row affected (0.02 sec)

mysql> quit
Bye

Hello everyone!

I had same problem with no remote frontends connecting, I was about to go bak to R5A16 but then I found this thread.

I tried the thing in the above post and it didnt work for me. Heres what did work:

I dropped the mythconverg DB

ran mc.sql script
ran mythtv-setup

And now I can connect remote frontends!

However I can not watch tv! After selecting watch tv screen goes black for a few seconds then quits.

Thats the next thing to get fixed I guess.

How do you do this?

This worked.. WHen you rerun the mythtv-setup make sure you setup everything back up.. Under general make sure u use the correct directories..

Set up tuners and info and rerun the mythfilldatabase..

Don't forget to associate the tuner with a source.

GOOD JOB DUDE.. now to test to see if it works after a reboot.

I have it working great now! After I got frontends toconnect but couldnt watch tv I just started and quit mythtv-setup and restarted mythtv-backend.

Thats /etc/init.d/wythtv-backend restart as root

When you rerun mythtvsetup and put in all your settings theres a couple things that get put in automatically in the knoppmyth install that you have to put in manually - like the location oc lvetv buffer /cache/cache and the location of saved tv storage /myth/tv

It seems like theres some problem in the R5A26 installer script.

Now I just have to set up lvm and music and video and picture shares

I added it to the wiki..

http://knoppmythwiki.org/index.php?page ... nlyInstall

Also, You will have to rerun the:

install_mythburn.sh

install_mythstreamtv.sh

Fix that little problem with mythburn..
vi /myth/mythburn/scripts/createintro.sh
replace
nice jpeg2yuv -v 0 -n $((framerate * ) -I p -f $framerate -j \
with this
nice jpeg2yuv -v 0 -n 200 -I p -f $framerate -j \

Fixes some framerate issue.

You may have setup your remote.

I am still tweaking a few things.. but over all it seems to work fine.

I re-loaded my backend three different times, trying different things, before I was able to get a frontend to work. I, too, decided to go the route of dropping the database and letting mythtv-setup recreate it.

One interesting quirk: After running the KnoppMyth text installer and the first reboot, I switched to a different console, logged-in, and checked the schema version before the second installer began (i.e. the one in an xterm that begins by asking for the root password).

The mysql command



gave me a schema version in the 1090's (I don't remember the exact number...sorry). After the installation finished, the schema version reverted to 1084, but the entry had the hostname filled with my backend's name instead of being "Null" (which, I believe, is what it is supposed to be...at least that's how it's listed after dropping the DB and letting mythtv-setup recreate the database). Is this, maybe, a remnant from R5A22? Or just a bug in mythTV 18.1/18.2?

One other thing...if you decide to go the route of dropping the database, you might want to follow the Kugalowski documentation in the Miscellaneous section (section 23.5 in the instructions for mythTV 18.1) about backing-up and restoring the database. If you have recordings on your backend, you DEFINITELY will want to do this.

I too have been having problems running a remote frontend on RA26 that worked fine with RA16. I got a little futher by doing..

INSERT INTO settings (value, data, hostname) VALUES ('DBSchemaVer', '1083', 'macaque.ind.tansu.com.au');

as posted above, though it was unclear to me if macaque.ind.tansu.com.au
in the example is supposed to be the backend or the frontend. I tried using my backend address first and it had no effect. I tired my frontend address
and now my frontend on Mac OS X at least runs (it was immedately exiting prior to the insert), but when I try to watch recordings it complains that it can't connect to the master backend server.
Tailing /var/log/mysql/mysql.log on the backend shows that the frontend is issuing lots of queries. I'm stumped.

Help?

Hi, DarG.

I have R5A26 running with two frontends connecting to a master backend. As mentioned in an earlier post, I dumped my database and allowed mythtv-setup to recreate it to get to a working setup.

I just queried my working database, and I do not have multiple entries for DBSchemaVer - only one, with a null hostname. Given that, you might want to give this a try:



Good luck!