LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 03-19-2006, 10:29 PM   #1
LiquidSlumber
Member
 
Registered: Jun 2005
Location: columbus ohio
Distribution: Ubuntu and Fedora
Posts: 36
Blog Entries: 2

Rep: Reputation: 15
Question The mythtvfrontend can't log into MySQL from any other user than the mythtv user!


I the following I refer to a linux users and mySQL users. When I says linux user, I mean a user on my linux system. When I say mySQL user, I mean a user in the mySQL database. Also when mythtv is installed via apt-get it automatically makes BOTH a linux and mysql user both which are name "mythtv". Here's my questions: it seems that in Ubuntu that only the mythtv linux user can open up mythfrontend, mythtv-setup or any other graphical part of mythtv. If another linux user tries, like jared in the example below, to open it up the program mythfrontend outputs this:
Code:
jared@Blue:~$ mythfrontend
2006-03-19 02:57:49.151 Using runtime prefix = /usr
2006-03-19 02:57:49.170 XScreenSaver support enabled
2006-03-19 02:57:49.189 New DB connection, total: 1
2006-03-19 02:57:49.200 Unable to connect to database!
2006-03-19 02:57:49.201 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
2006-03-19 02:57:49.254 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-03-19 02:57:49.306 Unable to connect to database!
2006-03-19 02:57:49.306 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES)
It looks like mythtv is trying to login as the mythtv mysql user, but it's running to some sort of problem. It looks like it could be some sort of mysql problem. Does anyone know how to fix this?

P.S let me know if you don't understand my problem, and I'll try to clarify it for you

Last edited by LiquidSlumber; 03-20-2006 at 03:50 PM.
 
Old 03-24-2006, 11:04 PM   #2
LiquidSlumber
Member
 
Registered: Jun 2005
Location: columbus ohio
Distribution: Ubuntu and Fedora
Posts: 36
Blog Entries: 2

Original Poster
Rep: Reputation: 15
Thumbs up Sucess!

looks like Captain_Murdoch saved the day on this one. I was talking to people in the mythtv irc channel he recommended that I copy the linux user mythtv's msql.txt (/home/mythtv/.mythtv/mysql.txt) to my other user's .mythtv dir (/home/jared/.mythtv/mysql.txt). Everything works great! Thanks Captain_Murdoch!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can a non-mythtv user open mythfrontend in ubuntu? Could it by a MySQL problem? LiquidSlumber Ubuntu 0 03-19-2006 02:01 AM
C program to see user log on in system and print user with real user name also naveen245 Programming 2 12-21-2005 12:53 AM
Samba -- XP user can log in to shares but smbclient user always gets password errors ejoe Linux - Software 3 04-18-2005 10:55 AM
Cant only log in as root after user log-in. ADJenkins Linux - General 2 11-17-2004 04:18 PM
libnss-mysql (Store your UNIX user accounts in MySQL) markus1982 Linux - Security 0 01-26-2003 02:24 AM


All times are GMT -5. The time now is 03:26 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration