[Tapeworm] can't connect to sql database

[david at spurgeonwoods.com]

> Hi David,
>
> I bought Tapeworm a while back, but I only just upgraded to Myth .19 (just
> before .20 came out, heh), so I haven't had a chance to try it until now.
> I'm using Tapeworm 1.1.1.
>
> I'm having two problems.  The minor one is that when error messages
> appear,
> they flash very quickly in the bottom window of Tapeworm and then
> disappear.
> Don't know if anyone else is seeing that or if its a symptom of something
> worse.
>
> The other is that I can't connect to mysql.  The error I get is "mysql
> exceptions operationalerror 2003 can't connect to mysql server on
> 192.168.1.15 10061".  There are only 4 settings in the config window, and
> they seem obvious enough ;), so I'm not sure what else to try.  I tried
> the
> trick "use a DNS name instead of the IP" mentioned in the mailing list,
> but
> it didn't help, got a different message saying can't find the machine.  My
> mythbox is on a static IP and I can ping it ok.
>
> I followed the instructions on your page to open up mysql, which appeared
> to
> work OK, but I don't have a client on another machine to verify it (is
> there
> a simple way to do so from Windows?).  I can log into mysql locally as
> mythtv / mythtv or as root / <something>.
>
> There aren't any error messages in the mysql logs.  mysqld.error ends
> with:
>
> /usr/sbin/mysqld: ready for connections. Version: '4.0.25'  socket:
> '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-4.0.25-r2
>
> Is the sql version OK?
>
> On Windows, TapeWorm.exe.log says:
>
> Traceback (most recent call last):
>   File "TapeWorm.py", line 317, in OnPlay
> TypeError: coercing to Unicode: need string or buffer, NoneType found
> Traceback (most recent call last):
>   File "TapeWorm.py", line 413, in OnCapture
> TypeError: coercing to Unicode: need string or buffer, NoneType found
>
> The samba part seems to be fine; I can navigate to the recordings
> directory
> from Windows without issue.
>
> I know that's not much to go on; are there any further troubleshooting
> steps
> you can suggest?  (I'm a mysql noob but I'm learning).
>
> Thanks, and I really like the fact that you're supporting Lamplighter's
> with
> this software.
>
> -Mike Grusin
> CU Aerospace Engineering
> Master of Engineering candidate
> mgrusin at flyingcircuits.com


Mike,

The first thing that comes to mind is that perhaps your mysql accounts are
only set up to access from localhost, not remote hosts.  Check the user
table in the mysql database to see if you have a user account with either
'%' or your windows computer's IP address as the "host".  If not, you need
to create an additional mythtv user account with the host set to "%".

If that doesn't work, download the MySQL GUI Tools from the MySQL web
site.  http://dev.mysql.com/downloads/gui-tools/5.0.html.  The MySQL
Administator and the MySQL Query Browser might be helpful.

If that doesn't work, let me know.  I'm on the road at the moment, but
will get back to you when I have access to internet.

David