LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > SUSE / openSUSE
User Name
Password
SUSE / openSUSE This Forum is for the discussion of Suse Linux.

Notices


Reply
  Search this Thread
Old 09-15-2006, 06:47 AM   #1
carl0ski
Member
 
Registered: Sep 2004
Location: Melbourne, Victoria Australia
Distribution: Support those that support you :)
Posts: 872
Blog Entries: 12

Rep: Reputation: 30
MythTV setup and SUSE


Hi

i have never ever suceeded in setting up MythTV

MySqL database always fails to work
http://mythtv.org/wiki/index.php/Use...l_Installation

Code:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock
anyone have a full script to initially setup MYTHV In Suse 10.1?

or why i cant get MySQL to work properly
 
Old 09-15-2006, 08:02 AM   #2
Samoth
Member
 
Registered: Apr 2005
Distribution: Exherbo
Posts: 474
Blog Entries: 1

Rep: Reputation: 32
Well, at first look it would assume that you dont have MySQL either installed or running. Did you make sure it was running with YaST?
 
Old 09-15-2006, 09:29 AM   #3
carl0ski
Member
 
Registered: Sep 2004
Location: Melbourne, Victoria Australia
Distribution: Support those that support you :)
Posts: 872

Original Poster
Blog Entries: 12

Rep: Reputation: 30
Quote:
Originally Posted by Samoth
Well, at first look it would assume that you dont have MySQL either installed or running. Did you make sure it was running with YaST?
Code:
linux-carl:/home/carl0ski # /etc/init.d/mysql start
Starting service MySQL                                               done
linux-carl:/home/carl0ski # mysql -u root -p mysqldatabase
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
fairly sure
 
Old 09-15-2006, 12:04 PM   #4
Samoth
Member
 
Registered: Apr 2005
Distribution: Exherbo
Posts: 474
Blog Entries: 1

Rep: Reputation: 32
you might have wanted to blank out that password first ;-)

why don't you post the output of "ls /var/lib/mysql/" here. I am on a SuSE(10.0) box now so I might be able to compare.
 
Old 09-15-2006, 08:46 PM   #5
carl0ski
Member
 
Registered: Sep 2004
Location: Melbourne, Victoria Australia
Distribution: Support those that support you :)
Posts: 872

Original Poster
Blog Entries: 12

Rep: Reputation: 30
Code:
linux-carl:/home/carl0ski # ls -a /var/lib/mysql/
ib_logfile0
mysqld.log        
mysql.sock  
update-stamp-5.0
ib_logfile1  
mysqld.log.1.bz2  
test
ibdata1  
mysql        
mysqld.pid        
tmp

Last edited by carl0ski; 09-15-2006 at 08:48 PM.
 
Old 09-16-2006, 07:57 AM   #6
Samoth
Member
 
Registered: Apr 2005
Distribution: Exherbo
Posts: 474
Blog Entries: 1

Rep: Reputation: 32
I see the sock file, try doing this: "ls -l /var/lib/mysql/mysql.sock" so we can look at the permissions on it, although that probably isn't the problem.
 
Old 09-16-2006, 08:00 PM   #7
carl0ski
Member
 
Registered: Sep 2004
Location: Melbourne, Victoria Australia
Distribution: Support those that support you :)
Posts: 872

Original Poster
Blog Entries: 12

Rep: Reputation: 30
Quote:
Originally Posted by Samoth
I see the sock file, try doing this: "ls -l /var/lib/mysql/mysql.sock" so we can look at the permissions on it, although that probably isn't the problem.
carl0ski@linux-carl:~> ls -l /var/lib/mysql/mysql.sock
srwxrwxrwx 1 mysql mysql 0 2006-09-16 10:32 /var/lib/mysql/mysql.sock
 
  


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
Need Help to setup MyThtv madman100 Linux - Newbie 2 09-09-2006 05:08 AM
how to setup mysql for mythtv?? jadukor Slackware 9 04-13-2006 02:01 AM
MythTV setup for a MySQL noob sadarax Linux - General 1 03-11-2006 01:31 AM
mythtv setup problems..... heinola Linux - Software 2 01-06-2006 11:58 PM
mythtv - video source setup d1l2w3 Linux - Software 0 03-31-2005 09:49 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > SUSE / openSUSE

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