[mythtv-users] access denied for remote frontend

Stephen Kitchener stephen at g6dzj.demon.co.uk
Thu Jan 5 16:21:12 UTC 2006


On Thursday 05 Jan 2006 16:16, Eric Sharkey wrote:
You need to change mysql's startup file...

/etc/sysconfig/mysqld

eg...

# (oe) Remove --skip-networking to enable network access from
# non local clients. Access from localhost will still work.
# MYSQLD_OPTIONS="--skip-networking"
MYSQLD_OPTIONS=""

# (oe) set TMPDIR and TMP environment variables
TMPDIR="${datadir}/.tmp"
TMP="${TMPDIR}"

Steve

> 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