[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, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> On 07/16/06 14:28, Mark Knecht wrote:
>
> >At this point I cannot connect to the database. MySQL is running, or
> >seems to be:
> >
> >dragonfly ~ # /etc/init.d/mysql status
> > * status:  started
> >dragonfly ~ # /etc/init.d/mythbackend status
> > * status:  stopped
> >dragonfly ~ #
> >
> >dragonfly ~ # mysql -u root mythconverg
> >ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> >'/var/run/mysqld/mysqld.sock' (111)
> >dragonfly ~ #
> >
> >
> >What next steps might I take? It's been almost 18 months since I set
> >up a backend so I'm quite rusty.
> >
> Do you have the --skip-networking option in your commandline or in your
> MySQL configuration file?
>
> Mike

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:

<SNIP>
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations
[mysqld]
character-set-server            = utf8
default-character-set           = utf8
user                                            = mysql
port                                            = 3306
socket                                          = /var/run/mysqld/mysqld.sock
pid-file                                        = /var/run/mysqld/mysqld.pid
log-error                                       = /var/log/mysql/mysqld.err
basedir                                         = /usr
datadir                                         = /var/lib/mysql
skip-locking
key_buffer                                      = 16M
max_allowed_packet                      = 1M
table_cache                             = 64
sort_buffer_size                        = 512K
net_buffer_length                       = 8K
read_buffer_size                        = 256K
read_rnd_buffer_size            = 512K
myisam_sort_buffer_size         = 8M
language                                        = /usr/share/mysql/english

# security:
# using "localhost" in connects uses sockets by default
# skip-networking
bind-address                            = 192.168.1.55
port = 3306

log-bin
server-id                                       = 1
<SNIP>


dragonfly conf.d # emerge -pv mysql

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild   R   ] dev-db/mysql-4.1.20  USE="berkdb perl ssl -big-tables
-cluster -debug -embedded -extraengine -latin1 -minimal -raid -srvdir
-static" 0 kB

Total size of downloads: 0 kB
dragonfly conf.d #


- Mark