On your MythTV box, try running:
ps ax | grep mysql
[EMAIL PROTECTED]:~> ps ax | grep mysql 7256 pts/1 S 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql 7281 pts/1 Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/amd64.pid --skip-locking --port=3306--socket=/var/lib/mysql/mysql.sock 11747 pts/2 S+ 0:00 grep mysql
nmap localhost
Thxs nice port scanner
[EMAIL PROTECTED]:~> nmap localhost
Starting nmap 3.75 ( http://www.insecure.org/nmap/ ) at 2005-01-16 20:22 MST Interesting ports on localhost (127.0.0.1): (The 1656 ports scanned but not shown below are in state: closed) PORT STATE SERVICE 22/tcp open ssh 25/tcp open smtp 111/tcp open rpcbind 631/tcp open ipp 3306/tcp open mysql 6543/tcp open mythtv 6544/tcp open mythtv
Nmap run completed -- 1 IP address (1 host up) scanned in 0.202 seconds
If so, try this: mysql -umythtv -pmythtv mythconverg
you should get a mysql> prompt. Try:
show tables;
mysql> show tables; +----------------------------+ | Tables_in_mythconverg | +----------------------------+ | callsignnetworkmap | | capturecard | | cardinput | | channel | | codecparams | | conflictresolutionany | | conflictresolutionoverride | | conflictresolutionsingle | | credits | | dvb_channel | | dvb_pids | | dvb_sat | | dvb_signal_quality | | favorites | | housekeeping | | jumppoints | | keybindings | | keyword | | mythlog | | networkiconmap | | oldprogram | | oldrecorded | | people | | profilegroups | | program | | programgenres | | programrating | | recgrouppassword | | record | | recorded | | recordedmarkup | | recordingprofiles | | recordoverride | | settings | | transcoding | | videosource | +----------------------------+ 36 rows in set (0.00 sec)
That should be a decent start on troubleshooting the problem.
Thank you for everything. It seems everything is working ok. I was wondering why I can not do
# myth filldatabase
From the reading I though that you could do it any time to refresh the table.
I'll keep this message and thxs much for all the tips.
All the best,
-=terry(Denver)=-
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
