View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 6 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sat May 19, 2007 8:13 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
I am attempting to access the mySQL database via tapeworm.

A review of the Settings > General > Database configuration shows that the username=mythtv and pw=mythtv. This command confirms this:

user@mythtvhost40:~$ mysql -u mythtv -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 35
Server version: 5.0.32-Debian_2 Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
ERROR 1044 (42000): Access denied for user 'mythtv'@'localhost' to database 'mythconverg'

If 'mythtv' is denied access to 'mythconverge' then tapeworm will not be able to access the database? Is there a command that can grant access?

I followed the instructions for tapeworm here: http://tapeworm.spurgeonwoods.com/setup.htm . I also followed the instructions using:

mysql -u root -p

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Sat May 19, 2007 11:49 pm 
Offline
Joined: Wed Aug 23, 2006 3:07 pm
Posts: 339
Can you access mysql on that box directly using telnet?

just open telnet and connect as root first, and see if you can run
mysql mythconverg

If that works, see if you can do it using the mythtv login.


Top
 Profile  
 
 Post subject:
PostPosted: Sat May 19, 2007 11:56 pm 
Offline
Joined: Wed Aug 23, 2006 3:07 pm
Posts: 339
According to the config instructions, you need to login to mysql using

mysql -u root -p

Did you login to mysql using the mythtv account?


Top
 Profile  
 
 Post subject:
PostPosted: Sun May 20, 2007 7:41 am 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
The short version to the questions (in order) are:
================================
* Yes, I did try login to mysql using the mythtv database account.
* No, I have to use SSH (putty).
* mysql mythconverg: due to newbiness, I can not determine success, however, here are the results:

Code:
root@mythtvhost40:~# mysql mythconverg
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 70
Server version: 5.0.32-Debian_2 Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>






Detailed Version
============
I logged into mysql using mysql -u root -p. I had to fumble with the password: it turns out it is null. I followed the instructions and performed:

grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
flush privileges;


mySql returned:

Query OK, 0 rows affected (0.06 sec)

As I understand mythtv is a database account only. I am unable to login to the system as 'mythtv'. I was able to login to the database with the mythtv login:
Code:
root@mythtvhost40:~# mysql -u mythtv -p mythconverg
Enter password:
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 68
Server version: 5.0.32-Debian_2 Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


After trying to hit the database with tapeworm, it errs out with: unable to connect to the MySQL database. _mysql_exceptions.OperationalError : (2003, "Can't connecto to MySql server on '192.168.2.20 (10061)").

I was able to get Samba to work and found this to be very useful in getting large files over to my PC for viewing \ searching \ editing.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Sun May 20, 2007 7:49 am 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
gatorback wrote:
After trying to hit the database with tapeworm, it errs out with: unable to connect to the MySQL database. _mysql_exceptions.OperationalError : (2003, "Can't connecto to MySql server on '192.168.2.20 (10061)").
By default MySQL is set to not allow network access - You probably need to allow that to make Tapeworm work. See http://mysettopbox.tv/phpBB2/viewtopic.php?t=15288


Top
 Profile  
 
 Post subject:
PostPosted: Sun May 20, 2007 8:42 am 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
Thank you for pointing me out in the right direction.

I had to comment out the line specifying bind address as 127.0.0.1 in the /etc/mysql/my.cnf file on the backend system, and restart MySQL (/etc/init.d/mysql restart).

I found the explanation here:
http://www.knoppmythwiki.org/index.php?page=FrontendOnlyInstall

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu