LinHES Forums
http://forums.linhes.org/

Ubuntu breezy Mythtv 0.18 Mysql - Access Denied error
http://forums.linhes.org/viewtopic.php?f=17&t=7011		 Page 1 of 1
Author:  lpnmb [ Mon Nov 21, 2005 8:32 am ]
Post subject:  Ubuntu breezy Mythtv 0.18 Mysql - Access Denied error
Hello all,

I have just signed up to the forum and have a VERY frustrating problem that I have spent probably 40-50 hours trying to solve! I've search myth/ubuntu/mysql forums for some cause but to no avail. I am quite new to mythtv and linux but I am starting to get a good handle on how it all fits together. I will try to be as concise as possible.

I just wish that there was some more information on this problem as it seems to be very common out there on all distros.

Oh yeah and I am running front/backend on the same machine.

1) this is the 3rd Dist. of linux I have tried (Knoppmyth, Debian Sarge being the previous) and all have resulted in basically the same error:

root@mythbox:/home/mythtv# mythbackend
2005-11-22 01:08:14.154 New DB connection, total: 1
2005-11-22 01:08:14.199 Unable to connect to database!
2005-11-22 01:08:14.200 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'192.168.0.101' (using password: YES)

2005-11-22 01:08:14.201 Failed to init MythContext, exiting.[/b]

2) Lastly I followed this FAQ: http://www.cs.rit.edu/~css8044/?q=mythinstall#

3) My mysql user table (whatever it's called looks like this:

+---------------+------------------+------------------+
| Host | User | Password |
+---------------+------------------+------------------+
| localhost | root | |
| localhost | debian-sys-maint | 1963f6ef4ff1e7ec |
| localhost | mythtv | 0476fc026afffe24 |
| 192.168.0.101 | mythtv | 0476fc026afffe24 |
| 192.168.0.101 | root | |
| 127.0.0.1 | root | |
+---------------+------------------+------------------+
status - mysql:

Connection id: 14
Current database: mysql
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.12-Debian_1ubuntu3-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 50 min 29 sec

and I have used the command similar to this to set the permissions:
mysql> grant all on mythconverg.* to root@"192.168.0.101" identified by "";

my mysql.txt file

root@mythbox:/etc/mythtv# more mysql.txt
DBHostName=192.168.0.101
DBUserName=mythtv
DBName=mythconverg
DBPassword=pgnbbydb
root@mythbox:/etc/mythtv#

Now, from all the reading I have done I cam across a little thread somewhere on the mysql forums that mentions a possible problem with user permissions to the /var/run/mysqld/mysqld.sock file however my attempts to change permissions for this file revealed my serious lack of knowledge of Linux.....

Well I can't think of what more I can say, other than PLEASE HELP ME!!!!

I am utterly frustrated! Oh and also I did try to remove Mythtv and Mysql but got the following error (and this happens also when trying to install/upgrade any package.....:

root@mythbox:/var/run/mysqld# apt-get remove mythtv
Reading package lists... Done
Building dependency tree... Done
Package mythtv is not installed, so not removed
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0B of archives.
After unpacking 0B of additional disk space will be used.
Setting up mythtv-database (0.18.1-5) ...
Failed to connect to database: Access denied for user 'root'@'localhost' (using password: YES) at -e line 5, <> line 1.
Failed to create database (incorrect admin username/password?)
If you supplied incorrect information, try:
dpkg-reconfigure --force mythtv-database
dpkg: error processing mythtv-database (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mythtv-database
E: Sub-process /usr/bin/dpkg returned an error code (1)

----------

Any help would be extremely well received!
Best Regards,
Lach/


one more cut/paste:

root@mythbox:/var/run/mysqld# netstat -ap | grep mysql
tcp 0 0 192.168.0.101:mysql *:* LISTEN 8636/mysqld
unix 2 [ ACC ] STREAM LISTENING 11674 8636/mysqld /var/run/mysqld/mysqld.sock
Author:  jfunk [ Mon Nov 21, 2005 6:17 pm ]
Post subject: 
Hello,

I recently had the same problem and fixed it by modifing the mysql configuration. The following is taken from the MythTV documentation at www.mythtv.org



MySQL not connecting correctly

Your MySQL installation may have networking turned off. Check that /etc/mysql/my.cnf does not contain skip-networking. If it does, remove it. Also verify that bind-address is set to your IP address instead of 127.0.0.1. If you change either of these items, restart MySQL.


Hopefully this will help!!

--Jeff
Author:  lpnmb [ Mon Nov 21, 2005 7:00 pm ]
Post subject: 
Thanks for your reply Jeff, I have checked these previously and have definately set the Bind address to my netcard address. however it still fails repeatedly. as you can see here it looks as if it is trying to connect correctly.

root@mythbox:~# mythfrontend
mythfrontend: cannot connect to X server
root@mythbox:~# mythbackend
2005-11-22 11:28:42.913 New DB connection, total: 1
2005-11-22 11:28:42.961 Unable to connect to database!
2005-11-22 11:28:42.961 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'192.168.0.101' (using password: YES)
2005-11-22 11:28:42.963 Failed to init MythContext, exiting.

Also did this little test to see that the port is open:

root@mythbox:~# telnet 192.168.0.101 3306
Trying 192.168.0.101...
Connected to 192.168.0.101.
Escape character is '^]'.
H
4.1.12-Debian_1ubuntu3-log-ABiiRA.`,x\BuIIt,zE)>

Bad handshakeConnection closed by foreign host.

----------------------------

I just went through the whole thing again..... WAHOOOOO I can't believe it......looking at the file /etc/mythtv/mysql.txt :

DBHostName=192.168.0.101
DBUserName=mythtv
DBName=mythconverg
DBPassword=mythtv

Now here it is - The line that says DBPassword=mythtv, was actually something like 'DBPassword=PdnRqs-Bla' (roughly) and for some reason I thought that it was encrypted....maybe it is supposed to be but blowed if I know......anyway maybe I'll write a FAQ on this saga....there is soooo many things that can go wrong with the mysql install, though it all seems clear to me now.
Author:  Xsecrets [ Mon Nov 21, 2005 7:04 pm ]
Post subject: 
well I think the pblah stuff is what it's supposed to be. If I remember correctly (it's been a long time) the debian package uses some strange password, at any rate I would load webmin if I were you and change the password on the mythtv user and then make sure you have the same one in the mysql.txt file, and also make sure that the mythtv user is allowed access to the mythconverge database from localhost. All of this can of course be done from the command line, but webmin makes it easier if you don't know mysql.
Author:  lpnmb [ Tue Nov 29, 2005 9:15 pm ]
Post subject: 
Grrrrr now I am having a problem Xorg.......

it seems to be another common problem.

X Window System Version 6.8.2 (Ubuntu 6.8.2-77 20051010174523 root@vernadsky.buildd)
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: Linux 2.6.10 i686 [ELF]
Current Operating System: Linux mythbox 2.6.12-9-386 #1 Mon Oct 10 13:14:36 BST 2005 i686
Build Date: 10 October 2005
Before reporting problems, check http://wiki.X.Org
to make sure that you have the latest version.
Module Loader present
OS Kernel: Linux version 2.6.12-9-386 (buildd@rothera) (gcc version 3.4.5 20050809 (prerelease) (Ubuntu 3.4.4-6ubuntu8)) #1 Mon Oct 10 13:14:36 BST 2005
Markers: (--) probed, (**) from config file, (==) default setting,
(++) from command line, (!!) notice, (II) informational,
(WW) warning, (EE) error, (NI) not implemented, (??) unknown.
(==) Log file: "/var/log/Xorg.0.log", Time: Wed Nov 30 14:08:53 2005
(==) Using config file: "/etc/X11/xorg.conf"
Skipping "/usr/X11R6/lib/modules/libfb.a:fbmmx.o": No symbols found

waiting for X server to shut down

-----------

I have tried all the stuff including install the nvidia drivers ( that was a mission for a noob!) which required kernel source and gcc versions to be correct etc..... But again I am at a loss....I am sure this is not supposed to be so difficult (read that as "not supposed to have so many problems") since I have followed the howto for myth to the letter.



I am using Breezy badger, could this not be the best option, maybe I will download a ealier version?

Does anybody have any thoughts on any of the above?

kind regards,
Lachlan.
Author:  jakep_82 [ Thu Dec 01, 2005 2:32 pm ]
Post subject: 
First, this isn't the right forum to ask about Xorg. Second, this is a Knoppmyth board, not an Ubuntu board. Third, have you read the log file mentioned in the error?
Author:  lpnmb [ Thu Dec 01, 2005 7:08 pm ]
Post subject: 
sorry! I didn't think...

it all relates to my mythtv install.....I'll go to another forum.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/