[mythtv-users] Upgrade to 2.6.17-gentoo-r2/ivtv-0.7.0/mythtv-0.19_p9163-r1 and having problems

[Mark Knecht]

On 7/16/06, John Johnson <johnatl at mac.com> wrote:
> Michael T. Dean wrote:
> > On 07/16/06 15:29, Mark Knecht wrote:
> >
> >
> >> On 7/16/06, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> >>
> >>
> >>
> >>> On 07/16/06 14:28, Mark Knecht wrote:
> >>>
> >>>
> >>>> dragonfly ~ # mysql -u root mythconverg
> >>>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> >>>> '/var/run/mysqld/mysqld.sock' (111)
> >>>>
> >>>>
> >>>>
> >>> Do you have the --skip-networking option in your commandline or in your
> >>> MySQL configuration file?
> >>>
> >>>
> >> I assume this is not a mysql permissions issue since I need to connect
> >> to change permissions?
> >>
> >> skip-networking is commented out in both /etc/conf.d/mysql and
> >> /etc/mysql/my.cnf
> >>
> >>
> >
> > >So, does the file /var/run/mysqld/mysqld.sock exist?  If not, make sure
> > >the user who's running mysqld has permissions to write to it and then
> > >restart mysql.
> >
> Didn't get the beginning of this thread, but you can eliminate the
> socket errors by specifying the host on the command line. Such as:
>
> If your server is in your /etc/hosts (or otherwise defined):
> mysql -uroot -ppassword -hserver mythconverg
>
> If not, use its numeric IP address:
> mysql -uroot -h192.168.0.100 mythconverg
>
Hi John,

Yes, I've tried them both. Unable to connect:

mark at dragonfly ~ $ mysql -u mythtv -h 192.168.1.55 mythconverg
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.55' (111)
mark at dragonfly ~ $ mysql -u mythtv -h 192.168.1.55 -p mythconverg
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.55' (111)
mark at dragonfly ~ $

It really seems like mysql is acting like the skip-networking
directive is operational even though it seems to be commented out.

I've got a second (non-updated) mythbackend server at my parent house.
On that machine I can log in:

mark at gandalf ~ $ mysql -u mythtv -h localhost -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'recordedmarkup'
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 188 to server version: 4.0.25

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye
mark at gandalf ~ $

Thanks,
Mark