[mythtv-users] MySQL errors, mysqld.sock

Marc Tousignant drayson at net1plus.com
Fri Jul 8 09:20:24 EDT 2005


I found your error here
http://www.washington.edu/computing/web/publishing/mysql-install.html
In this case, you have incorrectly specified the path to mysql.sock in your
home directory. Look at step 9 and fix your ~/.my.cnf file
http://www.washington.edu/computing/web/publishing/mysql-install.html#step9

I'm running gentoo as well.
Here is the relavant section of my /etc/mysql/my.cnf
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
log-error       = /var/log/mysql/mysqld.err

I checked my system and I do not have a /var/lib/mysqld folder which, unless
you created one, I think your problem is. Mysql can not start because it can
not create a file in a directory that does not exist.

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> bounces at mythtv.org] On Behalf Of al
> Sent: Thursday, July 07, 2005 7:53 PM
> To: Aaron Stewart
> Cc: Discussion about mythtv
> Subject: Re: [mythtv-users] MySQL errors, mysqld.sock
> 
> I've tried the logs too. Applicable info:
> 
> [mysql.err]
> 
> 050706 07:03:48  mysqld started
> 050706  7:03:48 Can't start server : Bind on unix socket: No such file
> or directory
> 050706  7:03:48 Do you already have another mysqld server running on
> socket: /var/lib/mysqld/m$
> 050706  7:03:48 Aborting
> 
> 050706  7:03:48 /usr/sbin/mysqld: Shutdown Complete
> 
> 050706 07:03:48  mysqld ended
> 
> 050707 18:57:11  mysqld started
> 050707 18:57:12  mysqld ended
> 
> [mysql.log] - nothing
> 
> [mysqld.err]
> 
> 050706  6:57:05 /usr/sbin/mysqld: Shutdown Complete
> 
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 050707 18:57:11  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 050707 18:57:11  InnoDB: Log file ./ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 050707 18:57:11  InnoDB: Log file ./ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 050707 18:57:12  InnoDB: Started; log sequence number 0 0
> 050707 18:57:12 [ERROR] Fatal error: Can't open privilege tables:
> Table 'mysql.host' doesn't exist
> 
> On 7/7/05, Aaron Stewart <acs at hourglassone.com> wrote:
> > Look in /var/log/mysql/* and see if that points to problems.
> >
> > I've had a similar issue, but it was one of those things I just blew
> > through without thinking about what it was, so I'm crossing my fingers
> > that it's something simple.
> >
> > -=Aaron
> >
> > al wrote:
> >
> > >Long time reader, first time poster.
> > >
> > >Problem: MySQL no longer connects to the mysqld server.
> > >
> > >History: I setup a Knoppmyth frontend/backend system (see specs in
> > >sig, rather vanilla setup) about a year ago. Recently I started over
> > >from scratch on Gentoo to learn more about the system.
> > >
> > >After installing everything, I had a working MythTV frontend/backend
> > >system. However, it took me a few weeks to get the IR blaster working.
> > >The first time I tried MythTV after fixing the IR blaster, mythbackend
> > >failed. I traced the problem back to MySQL. I could no longer connect
> > >to the mysqld server or databases.
> > >
> > >I've read up on MySQL troubleshooting but have not found success with
> > >the common suggestions. I have verified all permissions on the
> > >applicable directories (/var/lib/mysql, /var/run/mysqld, etc). I have
> > >a "mysql" user and "mysql" group. I do not have a mysqld.sock, which I
> > >understand is created upon running the server. I can't create it. I
> > >have verified that the mysqld.sock is not in /tmp. I've tried
> > >unmerging/ re-emerging MySQL several times, even upgrading to MySQL
> > >4.1.12.
> > >
> > >here is some applicable info about my problem:
> > >
> > ># mysqladmin -u root password new-password
> > >mysqladmin: connect to server at 'localhost' failed
> > >error: 'Can't connect to local MySQL server through socket
> > >'/var/run/mysqld/mysqld.sock' (2)'
> > >Check that mysqld is running and that the socket:
> > >'/var/run/mysqld/mysqld.sock' exists!
> > >
> > ># ps aux | grep mysqld
> > >root     28316  0.0  0.1   1484   436 pts/0    R+   19:03   0:00 grep
> mysqld
> > >
> > ># mysqld_safe
> > >Starting mysqld daemon with databases from /var/lib/mysql
> > >STOPPING server from pid file /var/run/mysqld/mysqld.pid
> > >050707 18:57:12  mysqld ended
> > >
> > >Can anyone help me? Since this is a new installation, I have no
> > >database to save. I can destroy/create new databases as needed.
> > >
> > >TIA,
> > >-Al
> > >_______________________________________________
> > >mythtv-users mailing list
> > >mythtv-users at mythtv.org
> > >http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > >
> > >
> >
> >
> 
> 
> --
> Biostar M7NCG 400
> AMD Athlon XP 2000
> PVR 350
> nVidia GeForce4 MX 440
> S-vid out to SD TV
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



More information about the mythtv-users mailing list