[mythtv-users] mysql error
Rich Goodwin
rich.goodwin at cox.net
Mon Jan 8 02:32:37 UTC 2007
On Sun, 2007-01-07 at 19:26 -0500, Rich Goodwin wrote:
> On Wed, 2007-01-03 at 13:26 -0500, Michael T. Dean wrote:
> > On 01/01/2007 12:08 AM, Rich Goodwin wrote:
> > > I just pulled down the SVN version of Myth and built it on SuSe Linux
> > > Enterprise Desktop 10. I made sure lame, qt-mysql and qt-devel were
> > > installed and that the environment variables were setup before
> > > compiling.
> > >
> > > When I run nythtv-setup, it cannot connect to mysql. The daemon is
> > > running. The relevant error info I get is
> > > QSqlDatabase: QMYSQL3 driver not loaded
> > > QSqlDatabase: available drivers:
> >
> > Your qt-mysql is not installed properly or you've installed it for the
> > wrong version of QT (i.e. QT4).
> >
> > > I am not able to manually go into mysql - access denied.
> >
> > That's a second problem. Check the MySQL docs (and/or the MythTV docs
> > for MythTV configuration of MySQL permissions).
> >
> > Mike
>
> Well, I was unhappy with what I configured in the OS (found I was using
> 32-bit version on a 64-bit system and other issues) so I rebuilt it. I
> used the SLED-10 64 dit distro on DVD and extracted several packages
> from the SLES 10 DVD, packman.iu-bremen.de & packman.inode.at. I
> compiled the code and then realized that there are 64-bit binaries at
> packman.inode.at so I let YAST download it from there.
>
> While setting up the initial MySQL db and ensuring MySQL was running, I
> followed SuSe's recommendation in setting a password for root. I fear
> that set something that will now not let myth in. I manually logged in
> as root and ran the mc.sql commands successfully. This did require me
> to use the root password (for mysql). Now when I run mythtv-setup, I
> get:
>
> 2007-06-02 19:12:58.656 Using runtime prefix = /usr/local
> 2007-06-02 19:13:00.647 DPMS is active.
> 2007-06-02 19:13:00.647 Unable to read configuration file mysql.txt
> 2007-06-02 19:13:00.647 Trying to create a basic mysql.txt file
> 2007-06-02 19:13:00.648 Writing settings
> file /home/mythtv/.mythtv/mysql.txt
> 2007-06-02 19:13:00.759 New DB connection, total: 1
> 2007-06-02 19:13:01.000 Unable to connect to database!
> 2007-06-02 19:13:01.000 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'localhost' (using password: YES)
>
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2007-06-02 19:13:01.054 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError? Strange...
> 2007-06-02 19:13:01.106 Unable to connect to database!
> 2007-06-02 19:13:01.106 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'localhost' (using password: YES)
>
> Anyone have an idea as to how to set the MySQL password(s) properly. I
> am not a database person and am not confident I'd just spin wheels
> reading/searching the MySQL sites. For instance, I followed the Myth
> doc recommendations on securing the password and played with settings
> provided in the mc.sql file - to no avail.
>
> Rich
I just realized the version that is loaded by default is a bit newer -
when I run mysqladmin version, I get:
% mysqladmin version
mysqladmin Ver 8.41 Distrib 5.0.18, for suse-linux on x86_64
Rich
--
GPG/PGP Key Id: 1B257AEC from pgp.mit.edu
Remember, all Windows machines are, by definition, fault tolerant.
They run Windows don't they!!
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20070107/6beedc9e/attachment.pgp
More information about the mythtv-users
mailing list