Hi Folks, I upgraded my backend sever to Ubuntu 7.04 Feisty last night. I was not able to connect to the database with either of my xbox's and received the message 'Failed to connect to MYSQL database. I found the answer here on the forums, but wanted to make one clear post regarding the fix. The problem is that I am now running a newer version of MYSQL and the hash tables for passwords has changed.
Since alot of users wanted to know if there is a way to not only watch videos but download on remote PC within Intranet i thought its better to have a video complete explanation on setting up,.
To fix this, log into mysql on the backend (this assumes you are using user=mythtv passwd=mythtv and you're restricting access to the subnet 192.168.1.): $ mysql -u root -p mysql UPDATE mysql.user SET password=OLDPASSWORD('mythtv') WHERE user='mythtv' AND host='[email protected].%'; mysql flush privileges; mysql quit Should now work for you. I can't seem to get this to work despite me trying your fix When I enter the command: mysql UPDATE mysql.user SET password=OLDPASSWORD('mwpnycvz') WHERE user='mythtv' AND host='[email protected]'; mwpnycvz is the password that was put within mysql.txt after setting up Mythtv. It returns: Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 which leads me to believe that it didn't update anything because it's already correct? I am using the THC3 build of XBMC: XBMC SVN 2007-06-25 (25th of June 2007) rev9424 The xbmcmythtv I am using is the latest one from sourceforge, I think it's 20.34b.zip. What's weird is that when I read the README within that.zip file, it says this: MythTV@XBMC v0.20.31 is a python module for XBMC. Which leads me to believe they either didn't update the README or something is amiss? Can you please provide any comments?
Here is what my phpmyadmin privileges looks like: and then this is what the variables still says as far as oldpasswords = off???? Netstat -pant on the main mythtv server shows that 3306 is listening on 0.0.0.0:3306 which is MORE than just the localhost which is good. I have made sure that mythtv-setup has the static ip within it instead of the default localhost. I am running Ubuntu Feisty Fawn Mythtv repositories version which I believe is SVN version.20. Aptitude shows: 0.20-svn20070122-0.0ubuntu6 I don't know what else to do other than try to use the.31 xbmcmythtv version and PRAY that that works.
I also need to ensure that my smb shares are set correctly for livetv/cache and for previous recordings as I have read that if you don't have those correct, it will fail also. Is that true?
I am beginning to think that this is all too much work, as I already can watch the recordings over samba using xbmc, I just don't get the commercial skippping, I can't see upcoming recordings, and whatever else xbmcmythtv is suppose to do. Is it worth it? I just enabled the logging within xbmcmythtv, but didn't upload the.31 xbmcmythtv to the xbox yet as I am at work and forgot to turn on the xbox before I left. Do I need to somehow enable logging in xbmc as well, how? My backend shows nothing about failed connections, can I make mysql be more verbose about failed connections? Debian doesn't use mysql.err according to the my.cnf, it's all logged to syslog, does you're syslog show any info when you connect from the xbox?
Or is the logged error within /var/log/mythtv/mythtvbackend.log? Any help would be much appreciated. My im screennames are as follows: jabber using gmail account, new2linx, and AIM is new2linx also. Please PM when you can or respond to [email protected], Thank you so much!
I just installed Ubuntu Feisty 7.04 today as well, upgraded from an old Gentoo distro. My xbmcmythtv used to work just fine. So after the install, trying to run the app and view 'Recorded Shows', I got an error: 'Protocol version error:'REJECT','31'.
Then after I got a database connection error. I fixed the database connection error using suggested methods in these knowledge base postings, by setting the password to the old style password. But the backend connection is still an issue.
On the mythtb backend logs, it says it only speaks 31, not 15. So I update my settings to protocol 31, then the 'Test Settings' seems to work fine, but trying 'Recorded Shows' gives me an error 'Protocol version error: unsupported call for protocol vers.' I tried upgrading the xbmcmythtv to the current download, but that fails miserably. Anyone have a suggestion? I am struggling to make any progress with this.
After some research I have tried adding old-passwords, and oldpasswords=true to the etc/mysql/ my.cnf file and also changing oldpasswords=false to oldpasswords=true in the etc/mysql/conf.d/oldpasswords.cnf file but non of this seems to make any difference. When I try to set the old passwords for mythtv using two different syntaxes I get the results below mysql UPDATE mysql.user SET password=OLDPASSWORD('pzpddxvn') WHERE user='mythtv' AND host='[email protected]'; Query OK, 0 rows affected (0.05 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql set password for 'mythtv'@'192.168.1.19' = oldpassword('pzpddxvn'); ERROR 1133 (42000): Can't find any matching row in the user table Get the feeling must be something fairly basic.
Any help much appreciated. After getting a bit sudo happy with my previous installation, I had to rebuild my backend. I used Mythbuntu 7.10 (Gutsy). I tried the instructions in the first post and in this post. I am looking good until I get to: mysql SET PASSWORD FOR 'mythtv'@'192.168.1.102' = OLDPASSWORD('HPbpTGX8'); ERROR 1133 (42000): Can't find any matching row in the user table What am I doing wrong. I can't connect with my xbox.
I am successfully connection with my PC/Kubuntu frontends. Thanks to frooby and tippo, I have the modified xTV skin and am ready to rock, just can't connect. The newer XBMC doesn't use the xboxmediacenter.xml file. It now uses a file called sources.xml I beleive it's called. It's stored within the UserData folder. You don't really need to worry about your sources as now it's a piece of cake to add sources right from within XBMC.
You click the white button and say either edit source or add source and then you can pick a smb share, or a local drive or whatever. I am using the June 07, 2007 version of XBMC from T3CH and I keep getting the 'failed to connect to database conn' error. When I look at the xbmcmythtv log (you can enable xbmcmythtv logging within the default.py, just comment out this line, '#debugLevel = mythtvutil.DEBUGNONE' and uncomment one of the debug lines but not the gui one, as you want to either debug mythtv or all of it.) The log file gets stored within the folder that the python scripts of xbmcmythtv are located within. Anyway, when I look at that log file with a NOTEPAD python script program from within XBMC, it actually states that it's connecting??? I think my issue may be due to the smb shares defined in the settings aren't correct. What do you guys use for your smb shares?
I mean the entire syntax please. See what's weird is that XBMC has a place to put the username and password for connecting to a WORKGROUP and mine contains special characters so when I try to use smb://daniel:@192.168.0.3/media/400gb/mythtv, it doesn't work because the contains things like @! I can see the upcoming scheduled recordings from within xbmcmythtv which is why I believe that I am connected to the mysql database. I am using the.31 version of the xbmcmythtv since that's the protocol of mythtv from within the fiesty repo's.
Any help from anyone would be appreciated. Did you guys have to change anything within mythtv.py or default.py (besides the debugging)???? To the guy who says that he doesn't need live tv work, I am not entirely sure why you want this if that's not one of the things you'd like xbmcmythtv to do???? You can always just view your recorded programs thru samba using xbmc without using xbmcmythtv, you are aware of that right?
I suppose it'd be convienent to be able to change scheduled recordings and or add some, but live tv from Mythtv is a feature so it should work. So it should be as simple as uploading the xbe and cfg file, and renaming to evoxdash.xbe.cfg, then deleting (or renaming) my old F/apps/xbmc folder to something like F/apps/xbmc-old and uploading the new xbmc folder and it should work? Because this doesn't work for me. I also seem to get weird issues like if I'm connected over ftp, sometimes it won't let me rename the xbmc folder, as I guess it's connected to it. So then I turn on my xbox using the eject key, which takes me into the bios and I try ftp from there. My filezilla doesn't even give me an f-drive at this point, so i have to revert to using windows explorer ftp, yuck! Is there something i'm missing?
As for the point about livetv, i've never tried using it as i couldn't get it to work. I suppose it could be handy in that if you get a phone call, you hit and then resume later. But i didn't worry about it, since i couldn't get it working. Yes, i'm aware you can watch the recordings just using a samba share. That's actually what i'm doing right now, since i can't get this working.
The nice thing with the scripts is for a recording i can play it, even delete it from there, set recordings, etc. So i'd like to get this working. Any suggestions would be appreciated. Why would you want to rename it to evoxdash.xbe? You need to make the default.xbe or whatever the file is named straight from download match exactly what you had it before. So say you had a folder named xbmedia like me, which is located within my c drive, what I do is turn on my xbox, it launchs Avalaunch first, then I ftp into it using Filezilla or FlashFXP, then I completely download the OLD xbmedia folder frmo my xbox onto my computer, then I check out what the.xbe file was named, and what the folder was named. In my case the folder xbmedia and the.xbe file within that fodler was named xbm.xbe.
So i first make a copy of the xbe file located within the PIMPED version of the XBMC on my computer, then I rename the xbe file to match what I downloaded from the xbox and upload the entire folder to the same exact location and ensure that the folder is exactly what it used to be and WALA! The XBMC Pimped folder should look something like this. I was also going to ask, you softmod or hardmod? If softmod, which one? Also, do you use XBMC as a dashboard or as an app?
Forgot to say, there is no.cfg file. There's only folders and 1.xbe file within the MAIN XboxMediaCenter folder and that's it. When upgrading from an older version of XBMC, it's best to delete your cache folders located within X, Y and Z cause sometimes things get stored in there and will cause issues.
There's plenty of places within gogle that talk about upgrading to the latest XBMC. It's also preferred to first delete the XBMC gamesave, or the 0face008 directories in E: UDATA and E: TDATA.
Doing this deletes your XBMC settings, but its pretty much a necessity. Okay, let's see if I can remember.
It's been a while:-) It's a hard mod. I believe back when I did it it had EvolutionX (?) as the startup 'os' (hence the evoxdash.xbe). I think that's that what the bios calls initially. I can't quite remember. Anyways, then when doing the XBMC, the instructions were to upload the xbmc folder to f/apps/. So within the xbmc folder there's a default.xbe and the xboxmediacenter.xml.
But in the root of the c-drive, since i wanted it to start up into xbmc, i had to rename my evoxdash.xbe to something else, evoxdashalt.xbe, then put a copy of the xbmc default.xbe on the c-drive named evoxdash.xbe so it would start up into xbmc. Then there's a copy of the xboxmediacenter.xml on the c-drive as well. Those were the instructions i followed back in the day, a few years ago, and haven't updated since. Oh, and as for the.cfg file, sorry, i also tried an xbmc from 'GasGiver' and he had that. Yes, i see that pimped doesn't have it. So then with the pimped version, it shouldn't be under f/apps/xbmc but rather c/xbmedia? Maybe going into avalaunch will help me with my ftp issues, as then it wouldn't be accessing the xbmc anymore.
I believe i can get there from launching into xbmc-evolutionx-avalaunch. Yikes, what a process.
Oh, and yes, i had tried renaming the 0face008 folders in the e-udata and e-tdata to something like 0face008.DEL as I had come across a discussion on that as well. Well I am not sure if that's going to work.
Because how does the default.xbe (from xbmc) know to look for all it's config stuff within F:/Apps/xbmc? I am guessing that that info was held within the xbocmediacenter.xml file but since that not used any longer you'll need to read the new ways of making it launch as your Dashboard.
According to the readme files located within the T3CH builds that I mostly use, this is what is says: DASHBOARD INSTALL Option 1. Team XBMC's shortcut tool.
It's included in the tools folder as SHORTCUT by TEAM XBMC.xbeSHORTCUT by TEAM XBMC.cfgSHORTCUT by TEAM XBMC.xbeTeam UIX's Xbe Shortcut Maker v1.0VERY/E:/APPS/XBMC/SHORTCUT by TEAM UIX.xbe.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |