LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
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 07-20-2003, 05:38 PM   #1
dexter4560
Member
 
Registered: Jul 2003
Location: Dominican Republic
Posts: 41

Rep: Reputation: 15
MythTV


Hello.........................im just finish install MythTV.............i already suply all dependencies for the rpm...........all of it. But when i try to run it i just get this message:
[dexter@dexter settings]$ mythtv
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

couldn't open db

How can i solve this problem??????
 
Old 07-20-2003, 07:02 PM   #2
izibo
LQ Newbie
 
Registered: Jul 2003
Posts: 7

Rep: Reputation: 0
did you set up mysql and then run mythfilldatabase?
 
Old 07-20-2003, 07:03 PM   #3
izibo
LQ Newbie
 
Registered: Jul 2003
Posts: 7

Rep: Reputation: 0
oh... and before mythfilldatabase but after setting up mysql you have to run mythtvsetup
 
Old 07-20-2003, 08:56 PM   #4
dexter4560
Member
 
Registered: Jul 2003
Location: Dominican Republic
Posts: 41

Original Poster
Rep: Reputation: 15
Myth TV......Im still stock

Whe i do ¨mythfilldatabase¨:

[root@dexter settings]# mythfilldatabase
Session management error: Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

couldn't open db
[root@dexter settings]#

----------------------------------------------------
When i do ¨mythtvsetup¨:

[root@dexter settings]# mythtvsetup
Session management error: Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Unable to open database:
Driver error was:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@dexter settings]#
 
Old 08-14-2003, 12:12 AM   #5
Eagle0
LQ Newbie
 
Registered: Aug 2003
Posts: 6

Rep: Reputation: 0
I'm also getting this exact error. Has anything been resolved here at all?
 
Old 08-14-2003, 03:30 AM   #6
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984Reputation: 1984
Quote:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
there is clearly no sql database running...
 
Old 08-14-2003, 07:46 AM   #7
Cooner
Member
 
Registered: Jul 2003
Location: Hastings, MN. USA
Distribution: Ubuntu 10.xx
Posts: 109

Rep: Reputation: 15
First things first.
Is MySQL installed and running?

Last edited by Cooner; 08-14-2003 at 07:55 AM.
 
Old 09-09-2003, 08:44 AM   #8
liguorir
Member
 
Registered: May 2003
Posts: 256

Rep: Reputation: 30
Exclamation MySQL

After Installing MySQL you need to do the following...

chkconfig mysqlon
service mysqld start

Thanks,

Robert Liguori
 
Old 01-10-2004, 01:30 PM   #9
eugeny
Member
 
Registered: Oct 2003
Location: Riga, Latvia
Distribution: Mandriva 2008
Posts: 35

Rep: Reputation: 15
I have the same problem!

[root@eugeny eugeny]# mythtv
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES)

couldn't open db


[root@eugeny eugeny]# chkconfig mysqlon
[root@eugeny eugeny]# service mysqld start
Cannot find mysqld service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
-v|--version: Print version.
 
Old 01-10-2004, 02:49 PM   #10
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
Quote:
Originally posted by eugeny



[root@eugeny eugeny]# chkconfig mysqlon
[root@eugeny eugeny]# service mysqld start
Cannot find mysqld service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
-v|--version: Print version.
Not sure if thats a typo but it should be:


[root@eugeny eugeny]# chkconfig mysql on

and if it can not find the mysqld service that usually means you don't have mysql installed. See if you have the startup script in /etc/init.d and query your packages to see if you have mysql installed.
 
Old 01-11-2004, 10:05 AM   #11
eugeny
Member
 
Registered: Oct 2003
Location: Riga, Latvia
Distribution: Mandriva 2008
Posts: 35

Rep: Reputation: 15
Yes I have the mysql file in /etc/init.d/ also I've checked the drakconf||system||DrakXservices and it shows that mysql is running and it is in "startup";
"chkconfig mysql on" and "chkconfig mysqlon" shows nothing(even after turning mysql off via drakconf);
I've installed MythTV, MySQL & other packages from rpms.
May be SQL needs additional configuration?
 
Old 01-22-2004, 07:08 AM   #12
eugeny
Member
 
Registered: Oct 2003
Location: Riga, Latvia
Distribution: Mandriva 2008
Posts: 35

Rep: Reputation: 15
I solved it: i fogot to configure MySQL after installing mythbackend:

mysql -u root < /usr/share/doc/mythtv-0.12/database/mc.sql
 
  


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
Mythtv android6011 Slackware - Installation 0 06-12-2005 08:32 AM
Mythtv zonen Linux - Software 3 05-17-2005 12:30 AM
MythTv jobless_joe Linux - General 13 12-18-2004 09:41 PM
MythTV?? willk Linux - General 11 06-29-2004 03:50 AM
MythTV Greg21 Linux - Software 2 10-26-2003 01:54 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:24 AM.

Main Menu
Advertisement
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
Open Source Consulting | Domain Registration