View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 13 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Mon Feb 14, 2005 7:00 am 
Offline
Joined: Wed Feb 11, 2004 12:11 pm
Posts: 19
I have just tried to install the R5A9 release and I am getting 'Access denied for user mythtv@localhost' when the installation script tries to set up Mythtv. I've checked the mysql.txt file and it seems to be setup properly with the correct password of mythtv (unencrypted) but still errors in the installation script.

Any suggestions? If anyone can provide a fix, I promise to write it up on the wiki.

BTW, congrats on the release of R5 - can't wait to get it fired up and see what new goodies are included! Kudos to you guys!


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 7:36 am 
Offline
Joined: Mon Oct 06, 2003 10:38 am
Posts: 4978
Location: Nashville, TN
hmmm this is strange. could we get a few more details? Are you upgrading, or doing a fresh install? which install method did you chose auto install, auto upgrade, manual install?

note that this is alpha software and there will be some bugs. you may have just found one, although I haven't heard of any of the testers having this issue.

_________________
Have a question search the forum and have a look at the KnoppMythWiki.

Xsecrets


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 10:22 am 
Offline
Joined: Wed Feb 11, 2004 12:11 pm
Posts: 19
I did an auto install from scratch. Went through the usual questions (586/686/Lirc etc) and then got the errors when the script started to run.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 11:05 am 
Offline
Joined: Wed Feb 11, 2004 12:11 pm
Posts: 19
Just tried the auto-install from scratch again - exactly the same problem. Watching closely, the first of the error messages that appears in the xterm window is:

unable to read configuration file mysql.txt
followed by more errors culminating in the
access denied for user mythtv@localhost

The mysql.txt file exists:
Code:
root@mythtv:/# find / -name mysql.txt
/etc/mythtv/mysql.txt
/usr/share/mythtv/mysql.txt
root@mythtv:/# ls -l /etc/mythtv/mysql.txt
-rw-rw----  1 mythtv mythtv 954 Dec 14 14:29 /etc/mythtv/mysql.txt
root@mythtv:/# ls -l /usr/share/mythtv/mysql.txt
lrwxrwxrwx  1 root root 21 Feb 14 16:36 /usr/share/mythtv/mysql.txt -> /etc/mythtv/mysql.txt


And looks OK (as far as I can tell):
Code:
root@mythtv:/# cat /etc/mythtv/mysql.txt
DBHostName=localhost
DBUserName=mythtv
DBName=mythconverg

# Set the following if you want to use something other than the
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise
# you'll need to reconfigure mythtv (or futz with the DB) every time.
# TWO HOSTS MUST NOT USE THE SAME VALUE
#
#LocalHostName=my-unique-identifier-goes-here

# If you want your frontend to be able to wake your MySQL server
# using WakeOnLan, have a look at the following settings:
#
# Set the time the frontend waits (in seconds) beetween reconnect tries.
# This should be the rough time your MySQL server needs for startup
#WOLsqlReconnectWaitTime=0
#
#
# This is the amount of retries to wake the MySQL server until the frontend
# gives up
#WOLsqlConnectRetry=5
#
#
# This is the command executed to wake your MySQL server.
#WOLsqlCommand=echo \'WOLsqlServerCommand not set\'
DBPassword=mythtv


I'm happy to provide more details. Thanks for your help.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 11:56 am 
Offline
Joined: Fri May 21, 2004 11:55 pm
Posts: 1206
Location: Silicon Valley, CA
Very odd. Here is the same file from my working R4V5 system, note the different password at the end:
Code:
root@mythtv:~ # cat /etc/mythtv/mysql.txt
DBHostName=localhost
DBUserName=mythtv
DBName=mythconverg

# Set the following if you want to use something other than the
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise
# you'll need to reconfigure mythtv (or futz with the DB) every time.
# TWO HOSTS MUST NOT USE THE SAME VALUE
#
#LocalHostName=my-unique-identifier-goes-here
DBPassword=q2dUSRDq

_________________
Do you code to live, or live to code?
Search LinHES forum through Google


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 12:39 pm 
Offline
Joined: Wed Dec 03, 2003 9:46 pm
Posts: 102
Location: Provo, UT
It has been a couple of days but I seem to remember having the same problem. It was caused by a permission problem for the file. I fixed it by granting more acces to the mysql.txt file. What are the persmissions on your box for that file currently?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 1:50 pm 
Offline
Joined: Wed Feb 11, 2004 12:11 pm
Posts: 19
Changing the permissions seems to have done it. I did a clean install, ctrl-alt-f1 to the terminal and changed the permissions:
Code:
root@mythtv:/# ls -l /etc/mythtv/mysql.txt
-rw-rw----  1 mythtv mythtv 954 Dec 14 14:29 /etc/mythtv/mysql.txt
root@mythtv:/# chmod 664 /etc/mythtv/mysql.txt
root@mythtv:/# ls -l /etc/mythtv/mysql.txt
-rw-rw-r--  1 mythtv mythtv 954 Dec 14 14:29 /etc/mythtv/mysql.txt
 

and that's fixed the problem. The install now proceeds through to mythtv-setup. :D

I've now been trapped by the old mythtv-setup video sources setup 'bug'. The uk tv grabber needs input in the terminal window to continue but I can't seem to find a way to shift focus back to the terminal window from mythtv-setup (which just hangs waiting). I've tried every key combo I can think of without success. :(

Anyone know a keyboard combo to shift window focus in R5?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 2:24 pm 
In R4V5 with FVWM, I'd use alt-F1 and pick it off the list but about R5??

Whatever the answer is please post it here!

Thanks!

Andrew Lynch


Top
  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 3:36 pm 
Offline
Joined: Fri Apr 02, 2004 10:08 am
Posts: 1637
Location: Virginia, USA
I searched for "fluxbox shift window focus" in Google; alt-tab, maybe?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 5:47 pm 
Offline
Joined: Wed Dec 03, 2003 9:46 pm
Posts: 102
Location: Provo, UT
I'm not familiar with this bug but have you tried ctrl-alt-f7? I discovered this just this week. Ctrl-alt-f1 through ctrl-alt-f6 takes you to a terminal window and ctrl-alt-f7 takes you back to the X session where you began.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 14, 2005 10:45 pm 
Offline
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location: Fontana, Ca
Please DON"T start a thread for one problem then start discussing another.

_________________
cesman

When the source is open, the possibilities are endless!


Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 15, 2005 3:58 am 
Offline
Joined: Wed Feb 11, 2004 12:11 pm
Posts: 19
Apologies, I'll start a new thread for the focus problem instead.....


Top
 Profile  
 
PostPosted: Sun Feb 20, 2005 12:16 pm 
Offline
Joined: Sun Feb 20, 2005 11:29 am
Posts: 19
Location: Garden Grove, CA
I installed the R5A9 once with fair results for my first time and had to do the modprobe for the 350 card problem. I have loaded R5A9 serveral times trying diferent things then I started having a problem during the install process.

After the file copy finish and when it starts to set things up I get alot of errors flash up on the screen about RSA errors , no such directory, and something about IDE but it clears off the screen so I can only get some of it. After that you get a message that KNOPPMYTH was installed and the percent finished shows 83%.

The next step after reboot I do the login in as root and modprobe to fix the 350 card issue, then reboot again.

After answering the standard questions the system will start the finial link stuff before the Mythtv setup stuff. Just before the setup stuff you can see an error on MySql but it is in dark blue and not on the screen long.

During the setup everything is fine until you try to attach the capture cards to input connections, I get the same problem as I got before the 350 card issue problem nothing to connect to.

If I continue anyway I get an error about the backend not able to talk to the front end, as it turns out the MySql did not start.

I tried the fix listed in another message above but this did not help. It seems that the install errors have something to do with it.

By the way I was able to install R5A9 several times and was able to record programs and view them to the monitor, this all started after I tried R5A10. Went back to R5A9 and got the same problems.

I have replace the new 40gb Wd with a new 200gb Wd, turned off UDMA in the bios on both the hard drive and DVD/CD-RW, replaced the DVD/CD-RW with a simple CD-RW drive, Re-downloaded from multiple sources the ISO image for both 9 and 10, Disabled all un-needed I/O ports, replaced the memory, replaced the PowerSupply.

This system has been a good Windows XP system and Linux RedHat 9 system with no problems for the last two years.

I an now going to try a R4 image and see what happens.

Pleas if anyone else has seen this MySql problem help...... :cry:

_________________
Doug Laing
doug@laingelectronics.com
Hotmail/Trillian (doug-laing@hotmail.com)


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu