[mythtv-users] MySQL too slow in startup?

[Mark Wormgoor]

Hi,

On Sun, 2005-03-20 at 04:41 -0600, Jay Jarvinen wrote:
> On Sun, 20 Mar 2005 10:50:49 +0100
> Mark Wormgoor <mark at wormgoor.com> wrote:
> 
> > I am having a problem with MythTV and MySQL on my backend system. 
> > MySQL loads during the initrd process and I start mythbackend in
> > rc.local(after loading ivtv).
> [...]
> > Mysqld.log shows it is ready:
> >   050320 08:43:59  mysqld started
> >   /usr/libexec/mysqld: ready for connections
> > 
> > But Mythbackend cannot yet connect:
> >   2005-03-20 08:44:06.869 Unable to connect to database!
> >   2005-03-20 08:44:07.190 Driver error was [1/1045]:
> >   QMYSQL3: Unable to connect
> >   Database error was:
> >   Access denied for user: 'mythtv at localhost' (Using password: YES)
> 
> It's hiding in plain sight.
> 
> MySQL is ready, but mythtv at localhost using password was denied access.
> 
> Check the appropriate scripts, config files, and MySQL permissions.
> These vary per system, so I won't make any assumptions.
> 
> Your environment (and user) may differ after startup, which would
> explain why it works 'later'. Need more details.

You're right.  Thanks for the answer.  It turns out that the mythbackend
daemon uses the .mythtv director for the user (root for my mythbackend).
However, $HOME isn't set yet, so it cannot read that file.  If I do:
export HOME=/root before the command, it's fine.

Kind regards,

Mark