[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