[mythtv-users] New install and my problmes.

[Damian Surr]

>> 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