Re: [SLUG] mythTV mySQL woes
On Mon, 16 Mar 2009 02:26:59 am Jake Anderson wrote: > Jonathan wrote: > > Hi ALL, > > > > So after a few months at out new home, I eventualy realised that our TV > > antena pointed a different direction to everyone else. A bit of a tweak, > > an wolla! I had (some) digital TV back on the computer. > > So with this new found victory i decided to re-configure my Myth TV so I > > could use it over my network. > > > > Here begins the problems > > > > After changing the permisions on MYSQL I can no longer access it from > > Myth. Yet I can log into it from KMySQLAdmin. > > > > How can one programme access it and another not? > > > > HELP!!! > > this is the only error I could pick up: > > driver error 1/1044 > > > > Running: > > Kubuntu (presumably the latest version, I'm always installing updates) > > Card: PVR2000(H?) rev j > > > > Thanks > > > > Jon > > try connecting from the command line > mysql -u mythconverg -p -h localhost > > to see what usernames and passwords you should be using > cat /etc/mythtv/mysql.conf (i think its a .conf) > > what do you mean by changed the permissions on mysql? > > Reading between the lines I reckons you might be having a localhost > socket/tcpip mojo problem. > if you want to run other myth front ends you want to change the user > mythconverg to 'mythconverg'@'%' rather than 'mythconverg'@'localhost' > (note the quotes, if you do the grant without the quotes it can all go > pear shaped) > you will also need to edit /etc/mysql/my.conf and change "bind address" > to "0.0.0.0" or to the ip address of your network adaptor Hi Jake, > mysql -u mythconverg -p -h localhost but mythconverg is the database not the user? > what do you mean by changed the permissions on mysql? I use the webmin module to change the settings for MYSQL. I told it allow user mythtv to connect from any port > you will also need to edit /etc/mysql/my.conf and change "bind address" > to "0.0.0.0" or to the ip address of your network got me: /usr/bin/mysql: unknown variable 'bindaddress=0.0.0.0' what do you mean by change the user? I did notice that sometimes for some weird reason when I typed int the network IP of my server 192 it came up as 'myth' '@' ' ' in the log window, which I thought was weird. Cheers Jon -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
Re: [SLUG] mythTV mySQL woes
Hi Jake, mysql -u mythconverg -p -h localhost but mythconverg is the database not the user? I've probably changed mine to something totally random, use the details from /etc/mythtv/mysql.txt although you do raise a good point do something like mysql -u someusername -p -h localhost mythconverg that should also make sure your logging into the right db and have access to it. then think about trying it again with 127.0.0.1 and your machines public ip address. (going from memory the mysql client will use a socket on localhost and tcp/ip on 127) what do you mean by changed the permissions on mysql? I use the webmin module to change the settings for MYSQL. I told it allow user mythtv to connect from any port That should have fixed up that @'localhost' Vs @'%' thing take a look in the mysql.user table to check (ie select * from mysql.user;) you will also need to edit /etc/mysql/my.conf and change "bind address" to "0.0.0.0" or to the ip address of your network got me: /usr/bin/mysql: unknown variable 'bindaddress=0.0.0.0' this is the line from my my.cnf bind-address= 0.0.0.0 what do you mean by change the user? I did notice that sometimes for some weird reason when I typed int the network IP of my server 192 it came up as 'myth' '@' ' ' in the log window, which I thought was weird. probably some sort of reverse dns lookup weirdness, wouldnt worry about it too much Cheers Jon -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
[SLUG] Re: [activities] SLUG Committee elections: progress so far
2009/3/16 Sridhar Dhanapalan : > Unless I missed something, I still need to be publicly seconded :) My mistake. James Polley did this. Sorry James :) -- Bring choice back to your computer. http://www.linux.org.au/linux -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
[SLUG] Re: [CTTE] Re: [activities] SLUG Committee elections: progress so far
* Sridhar Dhanapalan [2009-03-16 20:24:39 +1100]: > Good idea. I've updated the 2009 AGM wiki page: > > http://wiki.slug.org.au/2009agm > > Unless I missed something, I still need to be publicly seconded :) I second Sridhar Dhanapalan for President of SLUG. Sonia Hamilton. signature.asc Description: Digital signature -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
[SLUG] Re: [activities] SLUG Committee elections: progress so far
2009/3/16 Martin Visser : > Sridhar, > > Is it possible for the wiki to be updated to show the current status of > nominees. That is showing the nominated, seconded, accepted or rejected > status of candidates or non-candidates? With the recent goings-on it is > difficult to keep track of what position we are at in this regard. Good idea. I've updated the 2009 AGM wiki page: http://wiki.slug.org.au/2009agm Unless I missed something, I still need to be publicly seconded :) -- Bring choice back to your computer. http://www.linux.org.au/linux -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html