LinHES Forums • View topic - MySQL access from Windows (solved)

Board index Linux MythTV

All times are UTC - 6 hours

MySQL access from Windows (solved)

Page 1 of 1

[ 4 posts ]

Print view

Previous topic Next topic

Author

Message

Ralph

Post subject: MySQL access from Windows (solved)

Posted: Wed Feb 22, 2006 1:28 am

Joined: Sat Dec 03, 2005 5:59 pm

Posts: 111

Location: Sydney, Australia

I’ve had this working before so I have no idea why, since upgrading from R5A26 to R5A30.2, I can’t get it working again... I want to be able to see episode, title etc. information from within Windows Explorer. At the moment I can only get durations. I’m using the MythTV DirectShow filter, version 0.10.0 from here http://sourceforge.net/projects/dsmyth

The filter works OK as I can play the .nuv files in Windows, but I can’t get access to any of the file property information from mythconverg.
In case it's relevant, /etc/mythtv/mysql.txt says

Code:

DBHostName=localhost
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg

In the ‘MySQL database’ page of the MythTV Filters Settings screen, I have username, password and host all set to mythtv and database set to mythconverg, but on pressing the ‘Test MySQL connection’ button, the error reports Can’t connect to MySQL server on ‘mythtv’ (10061)

I’ve followed the instructions here www.mythtv.org/docs/mythtv-HOWTO-6.html to allow access from any host (no security) with

Code:

$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
mysql> flush privileges;

I have checked Webmin’s ‘User Permissions’ to confirm this has worked, ie. username 'mythtv' has access to database 'mythconverg' from any host, with all permissions (except ‘Grant privileges’)
Webmin’s ‘Database Permissions’ also confirms that mythconverg may be accessed by username mythtv from any host.
There was nothing set for ‘Host Permissions’ so I manually added ‘any’ host to be allowed to access mythconverg.
As far as I can tell, this setup should remove all security – yet I still don’t got no access :roll:

I had this working before, without any trouble in R5A26, so I’m probably just forgetting to do something ‘obvious’ – any ideas please :?:

Last edited by Ralph on Wed Feb 22, 2006 2:20 am, edited 1 time in total.

Top

cesman

Post subject:

Posted: Wed Feb 22, 2006 1:36 am

Joined: Fri Sep 19, 2003 7:05 pm

Posts: 5088

Location: Fontana, Ca

Perhaps MySQL isn't listening for network connections? I'd suggest reading the phamplet, in particle the frontend section.

_________________
cesman

When the source is open, the possibilities are endless!

Top

Ep Woody

Post subject:

Posted: Wed Feb 22, 2006 1:55 am

Joined: Mon Jan 23, 2006 7:02 am

Posts: 24

Location: The Netherlands

Maybe your windows machine isn't detecting mythtv as a host? What happens if you enter your IP-Address in the HOST?

_________________
KnoppMyth R5A30.1 upgraded to MythTV 0.19
P3-900 MHz
Asus CUV board (VIA Apollo 133A)
40 Gig HD
PVR-350
Optrex Display 160*128 T6963c

VMWare 4.5.1
KnoppMyth R5A30.2 upgraded to MythTV 0.19
IDE "virtual drive"

Top

Ralph

Post subject:

Posted: Wed Feb 22, 2006 2:20 am

Joined: Sat Dec 03, 2005 5:59 pm

Posts: 111

Location: Sydney, Australia

cesman wrote:

Perhaps MySQL isn't listening for network connections? I'd suggest reading the phamplet, in particle the frontend section.

Brilliant

pamphlet wrote:

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

All working AOK now - thanks a bunch :!:

Top

Page 1 of 1

[ 4 posts ]

Board index Linux MythTV

All times are UTC - 6 hours

Who is online

Users browsing this forum: No registered users and 3 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