On your MythTV box, try running:
ps ax | grep mysql
You should see several processes of mysqld running. If not, the mysqld daemon isn't started, try: sudo /etc/init.d/mysql start and look for errors, also check /var/log/mysql.log for errors: sudo tail /var/log/mysql.log
If mysqld is running, try:
nmap localhost
you should see: Starting nmap V. 2.54BETA31 ( www.insecure.org/nmap/ ) ... Port State Service ... 3306/tcp open mysql
If so, try this: mysql -umythtv -pmythtv mythconverg
you should get a mysql> prompt. Try:
show tables;
You should see a list of a lot of tables used by MythTV. To exit do this: \q
That should be a decent start on troubleshooting the problem.
Regards, JJ
On 16-Jan-2005, at 15:36, Teruel de Campo wrote:
I'm new to linux. My first project as an introduction to linux has been MythTV. Im am not familiar with mysql. I am reading from the site as well as man and a book I got (mysql /Duboi).
-------------------------------------
Sytem: SuSE 9.2 running amd64.
Wintv-pvr 350
ivtv 0.3.2.a
mythtv 0.16
--------------------------------------
Present status:
ivtv device driver working very well both sound and video mythv working very well. both watch tv and recording.
The three steps i did to install and run mythtv:
(1) run the ./setup for mythtv . When setup finishes it ask to run mythfilldatabase to populate the channel. I have to IGNORE this instruction
(2) run backend
(3) run front end
Setup the mythfilldatabase inside mythtv and waint until the following day to populate the channels with information. Then everything OK
--------------------------------------- Here my questions.
(1) if I run mythfilldatabase
$ mythfilldatabase
It runs, it connects to DataDirect, it seems to get all the information, then loops again and again and finally stop with error that can not access
<Can't connect to local MYSQL server through socket ...../mysql/mysql.sock'>
mysql.sock exist and if I change the permission.
chown -R mysql /var/lib/mysql
then reports a error in program.myi
The final result is that I have to reinstall the mc.sql and also mythtv. So my approach is just to IGNORE to run mythfilldatabase except within mythtv as I said before.
My questions: running
$ mythfilldatabase
is this correct? Or I am missing option/parameters?
(2) How can you run mythfilldatabase from outside of mythtv? How can I refresh the channels from outside mythtv?.
In the mythtv manual there is a session in how to use the cron method. Is this the ONLY other way to do it?.
In summary my impression is that running
$ mythfilldatabase without parameters is not correct (BTW --help did not help me)
That there are only 2 ways to run it one is within mythtv like I am doing it now and the other is with cron. Am I correct?
Any ideas, any instructions, any general statments may help me to understand what I am doing with mythfilldatabase/mysql
TIA
-=terry(Denver)=- _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
