Driver Error Was 1 1045 Mythtv
Contents |
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu mythtv cannot connect to database Wiki Community Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu
Access Denied For User Mythtv
Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu
Mythtv Could Not Connect To The Database
OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Official Flavours Support Mythbuntu mythtv-setup refuses to
Mythtv Setup
connect to db Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Results 1 to 8 of 8 Thread: mythtv-setup refuses to connect to db Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 14th, 2008 #1 zoiks View Profile View Forum Posts Private Message Frothy Coffee! Join Date Dec 2005 Beans 210 DistroUbuntu Breezy 5.10 mythtv-setup refuses to connect to db I've tried to be careful to follow the directions, but I can't get past running sudo mythtv-setup. Code: mythbox@coral:~$ sudo mythtv-setup.real (English chosen) (message box says no UPnP backends found) Code: 2008-05-14 00:24:55.481 Using runtime prefix = /usr, libdir = /usr/lib 2008-05-14 00:24:55.487 XScreenSaver support enabled 2008-05-14 00:24:55.487 DPMS is active. 2008-05-14 00:24:55.487 Empty LocalHostName. 2008-05-14 00:24:55.487 Using localhost value of coral 2008-05-14 00:24:55.493 New DB connection, total: 1 2008-05-14 00:24:55.496 Unable to connect to database! 2008-05-14 00:24:55.496 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 2008-05-14 00:24:55.546 DB Error (KickDatabase): Query was: SELECT NULL; No error type from QSqlError? Strange... QServerSocket: failed to bind or listen to the socket 2008-05-14 00:24:55.597 MCP::InitUPnP() - HttpServer Create Error 2008-05-14 00:24:55.597 Del
Post #1 of 4 (2365 views) Permalink Can't start Mythbackend Before I get into stuff, I'll give some background to my situation. Last Wednesday evening I installed the packages required for MythDVD to be able to import properly. Things went slowly but I eventually got it to work. Thursday comes around and all of a sudden the Frontends started hanging. I went downstairs and found a crazy set of error messages in the terminal running mythbackend. Some huge block of MYSQL selections and https://ubuntuforums.org/showthread.php?t=793783 such that came up in an error surrounded by fairly normal reports. It turns out that the Mythtv error logs had gotten to be several gigabytes in size and actually filled the filesystem, making booting and any actual operation a chore for the system. After deleting the files, the system returned to its peppy self. [.The error logs contained seemingly endless http://www.gossamer-threads.com/lists/mythtv/users/298965 copies of the same report: some error from libdvdread (or something) saying it couldn't access the drive.] I ran mythtv-setup while the computer was in that filled up state and screwed up the mysql settings. After I made room on the drive I ran it again and filled all the settings with the standard affair. My /etc/mythtv/mysql.txt file now contains the following: DBHostName=localhost > DBUserName=mythtv > DBName=mythconverg > DBPassword=mythtv However, I still cannot log into mythbackend. Here's the sequence I now try to follow without any results: 1. mysql -u root mythconverg 1. grant all on mythconverg.* to mythtv@"192.168.10.%" identified by "mythtv"; 2. flush privileges; 2. mythtv-setup 1. all settings default (this was what I used to set up the computer initially and had everything running smoothly). 2. Snipped terminal output sample (from mythtv-setup): QSqlQuery::exec: database not open QSqlQuery::exec: database not open 2007-11-04 12:04:53.365 DB Error (KickDatabase): Query was: SELECT NULL; No error type from QSqlError? Strange... 2007-11-04 12:04:53.419 Unable to connect to database! 2007-11-04 12:04:53.420 Driver error was [1/1045]: QMYSQL3: Unable to connect Database error was: Access deni
#1 2006-10-11 04:38:46 86turbodsl Member Registered: 2006-10-11 Posts: 7 mysql problems with network connectivity / mythtv I'm having big problems that I can't solve with https://bbs.archlinux.org/viewtopic.php?id=25923 my mysql install. I'm running the most current mysql packages, and trying to install mythtv on top of it. I can install and run my mythbackend script no problem as long as I use localhost as the parameter for backend connections. As soon as I try to use my IP address in .mythtv/mysql.txt I get connect to the following error:[mythtv@mythtv .mythtv]$ mythbackend2006-10-11 00:34:01.871 Using runtime prefix = /usr/local2006-10-11 00:34:01.881 New DB connection, total: 12006-10-11 00:34:01.886 Unable to connect to database!2006-10-11 00:34:01.887 Driver error was [1/1045]:QMYSQL3: Unable to connectDatabase error was:Access denied for user 'mythtv'@'mythtv' (using password: YES)QSqlQuery::exec: database not openQSqlQuery::exec: database not open2006-10-11 00:34:01.942 DB Error (KickDatabase):Query was:SELECT NULL;No error type from not connect to QSqlError? Strange...2006-10-11 00:34:01.997 Failed to init MythContext, exiting.[mythtv@mythtv .mythtv]$I made sure I had skip-networking commented out in my /etc/my.cnf file, I see from some posts that tcpwrappers is a potential pitfall, so I checked my hosts/deny/allow files and they are as follows:## /etc/hosts.allow#sshd: 192.168.123.0/255.255.255.0mysqld: 192.168.123.0/255.255.255.0mysqld-max : ALL : ALLOW# End of file## /etc/hosts.deny#ALL: ALL: DENY# End of fileDoes anyone have any ideas? I have been through ALL of the mysql help site at http://dev.mysql.com/doc/refman/5.0/en/ … enied.htmland nothing seems to work. I'm completely stumped and I'd like to get this working, as I use a remote connection on my internal net to connect to the mysql database for mythtv usage, and this is preventing it.Thanks in advance.Mark Offline #2 2006-10-11 11:35:55 luca Member From: Rome Registered: 2005-10-30 Posts: 280 Re: mysql problems with network connectivity / mythtv Hi 86turbodsl,try with this:within mysql command prompt assign permissions to mythtv user:grant all privileges on