[mythtv-users] New install and my problmes.
Damian Surr
damian at gingermagic.com
Fri Feb 2 17:19:15 UTC 2007
>> No output for the first two and the bind address for the last one:
>>
>> damian at MythBox:~$ netstat -an | grep 3306
>> damian at MythBox:~$ ps auxww | grep mysqld | grep -v grep
>> damian at MythBox:~$ grep -i bind-address /etc/mysql/my.cnf
>> # bind-address = 127.0.0.1
>> damian at MythBox:~$
>>
>> Does this offer any clues?
>> I really appreciate the help!
>>
>
> This *proves* mysqld is not running
>
> /etc/init.d/mysql start
>
That worked. I bet I turned it off following one of the pages I found
trying to reset the password, then failed to turn it back on.
> Then you should get an output from netstat -an | grep 3306 and ps auxww
> | grep mysqld | grep -v grep
>
I got these results:
damian at MythBox:~$ netstat -an | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
damian at MythBox:~$ ps auxww | grep mysqld | grep -v grep
root 4156 0.0 0.0 1656 500 ? S 16:59 0:00 /bin/sh
/usr/bin/mysqld_safe
mysql 4220 0.0 3.4 127704 17900 ? Sl 16:59 0:00
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
root 4221 0.0 0.1 1588 528 ? S 16:59 0:00 logger
-p daemon.err -t mysqld_safe -i -t mysqld
damian at MythBox:~$ grep -i bind-address /etc/mysql/my.cnf
# bind-address = 127.0.0.1
damian at MythBox:~$
> Then try
>
> mysql -u mythtv -p mythconverg
>
> and using either mythtv or the output of
>
> sudo grep DBPassword /usr/share/mythtv/mysql.txt | cut -d = -f 2
>
> as the password
>
This seemed to work:
damian at MythBox:~$ mysql -u mythtv -p mythconverg
Enter password: mythtv
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 5.0.24a-Debian_9-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
I didn't know what to do when I was there, so I came back out and tried
to run the backend again:
damian at MythBox:~$ sudo /etc/init.d/mythtv-backend start
mythbackend already running, use restart instead.
damian at MythBox:~$ sudo /etc/init.d/mythtv-backend restart
Restarting MythTV server: mythbackendNo /usr/bin/mythbackend found
running; none killed.
.
Session management error: Authentication Rejected, reason : None of the
authentication protocols specified are supported and host-based
authentication failed
.
damian at MythBox:~$
I feel like we're getting somewhere .. maybe :-)
Thanks again for all your help
Damian
More information about the mythtv-users
mailing list