[mythtv-users] access denied for remote frontend

Eric Sharkey eric at lisaneric.org
Thu Jan 5 16:16:42 UTC 2006


I'm trying to connect a remote frontend to a working mythtv box and I
keep getting Access Denied errors when the frontend tries to connect
to the mysql server.

I've read the docs and googled this to find all of the common problems
and none of them seem to fit my situation.

The mysql server is up and correctly configured for remote access.
If on the remote frontend box I run:

  mysql -h mythtered -u mythtv -p<mypassword> mythconverg

Then I get connected correctly and can see all of the tables, yet when
mythfrontend tries to connect to the same host using the same dbname,
username, and password it gets access denied.

I snarfed the mysql network traffic and looked at the difference
between the mysql command line client and the mythfrontend traffic and
noticed that mysql sends a packet that looks like:

        0x0000:  4508 0080 7379 4000 4006 019a c0a8 2201  E...sy at .@.....".
        0x0010:  c0a8 220b a157 0cea 6049 546a f15c f05f  .."..W..`ITj.\._
        0x0020:  8018 05b4 b4ad 0000 0101 080a 60a6 271b  ............`.'.
        0x0030:  9ebf dbb9 4800 0001 8da6 0300 0000 0001  ....H...........
        0x0040:  0800 0000 0000 0000 0000 0000 0000 0000  ................
        0x0050:  0000 0000 0000 0000 6d79 7468 7476 0014  ........mythtv..
        0x0060:  c18a 400a ccf7 be84 35aa df4f dd48 f934  .. at .....5..O.H.4
        0x0070:  f16d 8e76 6d79 7468 636f 6e76 6572 6700  .m.vmythconverg.

while mythfrontend looks like:

        0x0000:  4508 0058 b25c 4000 4006 c2de c0a8 2201  E..X.\@. at .....".
        0x0010:  c0a8 220b a11b 0cea 5f6d 528a f03e 2a70  .."....._mR..>*p
        0x0020:  8018 05b4 2aa8 0000 0101 080a 60a5 e0e1  ....*.......`...
        0x0030:  9ebf 9582 2000 0001 8d20 0000 006d 7974  .............myt
        0x0040:  6874 7600 5f5c 4952 555e 525d 006d 7974  htv._\IRU^R].myt
        0x0050:  6863 6f6e 7665 7267                      hconverg

It looks like both of these packets end with username, obscured password,
and database name but, but the mythfrontend is using fewer characters
for the password, so it must be using some sort of different password
obfuscation algorithm, or a different password.

Any idea what could cause this?

Both machines are Debian Sid running the same mythtv 0.18.1 packages.

Eric


More information about the mythtv-users mailing list