[mythtv-users] mysql error

[Rich Goodwin]

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

-- 

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/73573da5/attachment.pgp