View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 6 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sat Jan 28, 2006 7:01 pm 
Offline
Joined: Sat Jan 28, 2006 11:29 am
Posts: 83
I need to change some values normally done via the setup menu in the frontend (music path), but I don't have a keyboard on the machine, so I wanna tsh onto it and edit the file by hand remotely, restart the front end, but I've been searching for about 4 hours to no avail. The front end doesn't seem to be running mysql so I figured it ain't stored in a database like it is on the backend machine. I found a file

/home/.../conf/settings.txt

which contained the value I wanted to change (MusicLocation), but changing it made no difference. I've googled til my fingers are sore. Does anyone know?


Top
 Profile  
 
 Post subject:
PostPosted: Sat Jan 28, 2006 8:18 pm 
Offline
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location: Fontana, Ca
Those settings are all kept in the db (on the master backend). I suppose you could use webmin to change them... Back uo first.

_________________
cesman

When the source is open, the possibilities are endless!


Top
 Profile  
 
 Post subject:
PostPosted: Sat Jan 28, 2006 8:28 pm 
Offline
Joined: Sat Jan 28, 2006 11:29 am
Posts: 83
I was looking in there about 5 hours ago, but could only see the ones for the frontend on that same machine not the ones for my remote front end. I've been googling and greping and searching for hours to no avail.

Dammit I feel like such a fool, I only scrolled through a few pages and assumed it was ALL for user mythtv - Arrrrrrrghhh I've been going out of my mind. A simple SQL query on the settings table and I find the field.

BUT it says "Data in this table cannot be edited because it has no primary key"


Last edited by HappyTalk on Sat Jan 28, 2006 8:35 pm, edited 1 time in total.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Jan 28, 2006 8:34 pm 
Offline
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location: Fontana, Ca
If you gave all your frontends different names, you should see them in the db...

_________________
cesman

When the source is open, the possibilities are endless!


Top
 Profile  
 
 Post subject:
PostPosted: Sat Jan 28, 2006 8:51 pm 
Offline
Joined: Sat Jan 28, 2006 11:29 am
Posts: 83
The frontends have different names and I have found the record I wish to change in the settings table but webmin is not letting me edit the record saying:-

"Data in this table cannot be edited because it has no primary key"

However If I just execute an SQL command on database mythconverg
Code:
UPDATE settings SET data = '/myth/music' WHERE value = 'MusicLocation' and hostname like 'xebian%'

SELECT * from settings where value = 'MusicLocation'

It does the job?

Why is Webmin not letting me edit the data, what's it having or not having a primary key got to do with anything?

OK well I have music and video stored on back end playing on front end now - Thanks for your help BTW


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 30, 2006 6:18 am 
Offline
Joined: Sat Jan 28, 2006 11:29 am
Posts: 83
OK I posted a howto for anyone else who needs to do this here:-

http://mysettopbox.tv/phpBB2/viewtopic.php?t=8175


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu