MythTV & mySQL

mykrob · 01-25-2005, 10:15 PM

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

acid_kewpie · 01-26-2005, 07:51 AM

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

mykrob · 01-26-2005, 01:06 PM

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

acid_kewpie · 01-26-2005, 01:29 PM

start mysql.

mykrob · 01-26-2005, 01:33 PM

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

acid_kewpie · 01-26-2005, 01:41 PM

like i said, start mysql. i don't mean "run the front end client" i mean, run mysql itself... start the service.

j0217995 · 01-26-2005, 03:16 PM

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.

mykrob · 01-26-2005, 03:27 PM

acid_kewpie-
can you elaborate? I thought that the command "mysql start" would start the service. Am i missing something?

Please advise,
-myk

acid_kewpie · 01-26-2005, 03:31 PM

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.

mykrob · 01-26-2005, 03:48 PM

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

mykrob · 01-27-2005, 09:30 PM

i have mysql running now.. Just need to figure out the rest...

thanks,
-myk

mykrob · 01-27-2005, 09:37 PM

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

acid_kewpie · 01-28-2005, 01:42 AM

sounds like you've still not run the mc.sql script.

BruceCadieux · 01-28-2005, 08:48 AM

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

mykrob · 01-28-2005, 01:13 PM

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