[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