LinuxQuestions.org
Visit Jeremy's Blog.
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 01-25-2005, 10:15 PM   #1
mykrob
Member
 
Registered: Jun 2004
Location: Jackson, TN
Distribution: Kubuntu Feisty
Posts: 606

Rep: Reputation: 31
MythTV & mySQL


Hi-
i am trying to get mythtv running, but seem to be having some trouble with databases. Mythtv requires mysql, which i have installed, but i apparently dont understand how to set it up properly. Every command regarding either mythtv or mysql yields the same error:

Code:
myk@linux:~> mythfilldatabase
Unable to connect to database!
Driver error was [1/2002]:
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
myk@linux:~>
how do i get this database going?

Please advise if more information is needed.
Thanks,
-myk
 
Old 01-26-2005, 07:51 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982
have you built the databases yet?

as root it's something like:
mysql -p < /usr/share/mythtv/mysql/mc.sql

that will set up the database access and users. that's not the right command though... only similar to that... i'm sure the path is wrong. also make sure mysql is actually running
 
Old 01-26-2005, 01:06 PM   #3
mykrob
Member
 
Registered: Jun 2004
Location: Jackson, TN
Distribution: Kubuntu Feisty
Posts: 606

Original Poster
Rep: Reputation: 31
no luck

Code:
myk@linux:~/Downloads/mythtv/mythtv-0.16/database> mysql -p < mc.sql
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
myk@linux:~/Downloads/mythtv/mythtv-0.16/database>
any other ideas?

thanks,
-myk
 
Old 01-26-2005, 01:29 PM   #4
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982
start mysql.
 
Old 01-26-2005, 01:33 PM   #5
mykrob
Member
 
Registered: Jun 2004
Location: Jackson, TN
Distribution: Kubuntu Feisty
Posts: 606

Original Poster
Rep: Reputation: 31
i cant even do that. It seems my problem is getting mysql to work. I installed it from the Suse DVD, so i know its not an installation error..

Code:
myk@linux:~> mysql start
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
myk@linux:~>
what would you like me to try next?
Thanks,
-myk
 
Old 01-26-2005, 01:41 PM   #6
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982
like i said, start mysql. i don't mean "run the front end client" i mean, run mysql itself... start the service.
 
Old 01-26-2005, 03:16 PM   #7
j0217995
Member
 
Registered: Jan 2003
Location: Grand Rapids, Michigan, USA
Distribution: Kubuntu
Posts: 71

Rep: Reputation: 15
I would think there would be a problem w/ your install of mysql. I am currently using SuSE 9.1 and have done the install through FTP and had no problems w/ MySQL when I installed it. So I would recomend reinstalling it through YaST and see what is going on. Then start it up. COnnect via mysql -u USERNAME -p PASSWORD and create the databases.
 
Old 01-26-2005, 03:27 PM   #8
mykrob
Member
 
Registered: Jun 2004
Location: Jackson, TN
Distribution: Kubuntu Feisty
Posts: 606

Original Poster
Rep: Reputation: 31
acid_kewpie-
can you elaborate? I thought that the command "mysql start" would start the service. Am i missing something?

Please advise,
-myk
 
Old 01-26-2005, 03:31 PM   #9
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982
nope. you should have a service script /etc/init.d/mysqld probably, run that with a "start" parameter. alterntivaly i'm sure yast can start it for you.
 
Old 01-26-2005, 03:48 PM   #10
mykrob
Member
 
Registered: Jun 2004
Location: Jackson, TN
Distribution: Kubuntu Feisty
Posts: 606

Original Poster
Rep: Reputation: 31
okay, i understand. I'll check the runlevel editor in yast. This determines startup services. I can also enable and disable services while running here. Will post back after i get home tonight.

Thanks,
-myk
 
Old 01-27-2005, 09:30 PM   #11
mykrob
Member
 
Registered: Jun 2004
Location: Jackson, TN
Distribution: Kubuntu Feisty
Posts: 606

Original Poster
Rep: Reputation: 31
i have mysql running now.. Just need to figure out the rest...

thanks,
-myk
 
Old 01-27-2005, 09:37 PM   #12
mykrob
Member
 
Registered: Jun 2004
Location: Jackson, TN
Distribution: Kubuntu Feisty
Posts: 606

Original Poster
Rep: Reputation: 31
here's my most recent attempt:

Code:
myk@linux:~> mythtv
Unable to connect to database!
Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES)

couldn't open db
myk@linux:~> mythbackend
Unable to connect to database!
Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES)

Couldn't open database
myk@linux:~>

dont know what to do. I am trying to read through these directions, but they are a little too plentiful..

-myk
 
Old 01-28-2005, 01:42 AM   #13
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982Reputation: 1982
sounds like you've still not run the mc.sql script.
 
Old 01-28-2005, 08:48 AM   #14
BruceCadieux
Member
 
Registered: Apr 2002
Location: Wales MA.
Distribution: openSuSE 11.1
Posts: 409

Rep: Reputation: 32
Here what I did to install and get the mysql database running under SuSE 9.2. They assume a basic understanding of SuSE 9.2 and Yast.

Install the MySql database in Yast. You will need the database, the database client and the devel files.

Once they are installed you will need to go into the runlevel editor in Yast and start MySQL. The quotations, and %, and ; in the commands are necessary, be sure to include them.

Now in a console as user root (su) run the commands below.

cd /usr/share/mythtv/database

mysql < mc.sql

mysql -u root mythconverg

Your prompt will look different now because you are in the mysql command prompt.

mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";

mysql> flush privileges;

mysql> \q

Again as user root in a console, restart the database

/etc/init.d/mysql restart

Once the database has restarted you can then start to setup mythtv

from a console run mythsetup

When done setting up mythtv run mythfilldatabase
 
Old 01-28-2005, 01:13 PM   #15
mykrob
Member
 
Registered: Jun 2004
Location: Jackson, TN
Distribution: Kubuntu Feisty
Posts: 606

Original Poster
Rep: Reputation: 31
still having some trouble. I have subscribed at Zap2it for TV listings, placed my username and password in MythTV for the setup, setup my tvtuner/video device as best as i could figure out... i get a green screen with static, and it cant seem to import any channels.. here's an excerpt from console after running "mythfilldatabase"

Code:
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Authorization failed.
--13:09:59--  http://datadirect.webservices.zap2it...gs/xtvdService
           => `-'
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Authorization failed.
always authorization failed...

what next? This looks like a great app, just a b*tch to get setup.
But, as always, with a little persistence......

Thanks,
-myk
 
  


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 mysql database setup help carmat06 Debian 3 09-27-2005 05:41 PM
MythTV and MySQL database on same Computer linux-rulz Linux - Software 4 05-19-2005 06:15 PM
mythtv and mysql noob problems Shaun32 SUSE / openSUSE 1 05-09-2005 02:48 PM
Mythtv for multiple systems (another mysql problem) greghead Linux - Software 1 02-16-2005 07:49 PM
Mythtv and mysql, strange error Ossar Linux - Software 1 12-18-2004 09:55 PM

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

All times are GMT -5. The time now is 12:55 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