[mythtv-users] Re: mythfilldatabase

[Teruel de Campo]

Rich Deeming wrote:
> DB dir owned by mysql not daemon...
> 
> [root at r1 ~]# ls -al /var/lib/mysql
> total 28
> drwxr-xr-x   5 mysql mysql 4096 Jan 18 04:41 .
> drwxr-xr-x  38 root  root  4096 Jan  9 19:42 ..
> drwx------   2 mysql mysql 4096 Nov 27 10:44 mysql
> srwxrwxrwx   1 mysql mysql    0 Jan 18 04:41 mysql.sock
> drwx------   2 mysql mysql 4096 Jan 10 10:53 mythconverg
> drwx------   2 mysql mysql 4096 Nov 27 10:44 test
> 
> Checking that SUSE starts mysql with the same args this is mine.
> 
> root      2968     1  0 Jan18 ?        00:00:00 /bin/sh
> /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
> --pid-file=/var/run/mysqld/mysqld.pid
> mysql     2997  2968  0 Jan18 ?        00:00:00 /usr/libexec/mysqld
> --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql
> --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
> 
> 



amd64:/home/tdec # mysqlaccess -d info



Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- + --------------------
  N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    ?    ?    ?    ?    0    0    0   | localhost,nobody,info

amd64:/home/tdec # mysqlaccess -d mythconverg

Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- + --------------------
  N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    ?    ?    ?    ?    0    0    0   | localhost,nobody,mythconverg

amd64:/home/tdec # mysqlaccess -d test

Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- + --------------------
  Y    Y    Y    Y    Y    Y    N    N    N    N    N    Y    Y    Y    N    N    Y    Y    N    N    N    ?    ?    ?    ?    0    0    0   | localhost,nobody,test

amd64:/home/tdec # mysqlaccess -d mysql

Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- + --------------------
  N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    ?    ?    ?    ?    0    0    0   | localhost,nobody,mysql


Rich,

Sorry I have to bug you again. You were correct in your message about my problems with the mytyfilldatabase.
I'm trying to determine if my permissions are corrrect as well as the parameter to start the server.
I am new to linux and mysql. Mythtv has my introduction to this new enviroment so many obvious things are not
obvious for me :-(.

Above are all the databases I have in mysql.

Do you see any problems?

Should I change the User in the mythconverg to mythtv?

TIA.

Initially I though the hardest part was going to be the module vide/sound and I was wrong.
Everything was easy until I start to deal with mysql. Well I will go step by step until
the whole thing is solved.

Best regards,

-=terry(Denver)=-