LinHES Forums • View topic - Frontend only ... in my dreams

Board index Linux General

All times are UTC - 6 hours

Frontend only ... in my dreams

Page 1 of 1

[ 3 posts ]

Print view

Previous topic Next topic

Author

Message

hpladds

Post subject: Frontend only ... in my dreams

Posted: Tue Jul 11, 2006 1:29 pm

Joined: Mon Jul 10, 2006 6:55 pm

Posts: 8

Hey all,

I can't connect to the Backend of my Frontend/Backend machine from a remote Frontend machine.

Frontend/Backend is a AMD 3500+ 64 machine. (Works Fine) The Frontend only machine is a Celeron 3.05. (Has worked as a dedicated Front/Backend machine.)

But using the Celeron as Frontend only-- Grrr....
Below are the error messages I receive:

Quote:

2006-07-11 09:43:26.513 Using runtime prefix = /usr
2006-07-11 09:43:26.540 New DB connection, total: 1
2006-07-11 09:43:26.542 Unable to connect to database!
2006-07-11 09:43:26.542 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.2.102' (111)

2006-07-11 09:43:26.600 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-07-11 09:43:26.653 Unable to connect to database!
2006-07-11 09:43:26.653 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:Can't connect to MySQL server on '192.168.2.102' (111) ....

(note: many more instances of the above error message edited out ... )

2006-07-11 09:43:36.003 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-07-11 09:43:36.056 Failed to init MythContext, exiting.

I've tried a multitude of setup option provided by Knoppmyth's API -- no luck, always the same error messages as above.

I have also tried is solution from the web "Fedora Myth Tips-n-tTricks" However, I can't tell if there is a typo in the instructions. If my backend is 192.168.0.112 and the frontend is 192.168.0.115. Are the instructions suggesting that I grant permission to mythtv@"192.168.0.%" ? (Please see text below.)

Quote:

Configuring a remote front-end is relatively easy. There are only a few steps you need to take on your back-end machine.

1. On the machine you're running mysql (typically the same machine as your MythTV master backend server), you need to allow mysql connections from other hosts on your network. This example assumes your local area network is 10.0.1.0/255.255.255.0, adjust accordingly for your network:

$ mysql -u root -p mythconverg
mysql> grant all on mythconverg.* to mythtv@"10.0.1.%" identified by "mythtv";
mysql> flush privileges;
mysql> quit "

I have also read that problems similar to mine are caused by running differing versions of MySQL. I installed from the same installation disk, so I'm assuming that the same version has been installed. But perhaps not; might KnoppmythTV install differing version of MySQL depending upon the machine's hardware?

Thanks All

Top

datobin1

Post subject:

Posted: Tue Jul 11, 2006 1:43 pm

Joined: Wed Dec 21, 2005 1:14 pm

Posts: 145

Location: Charlotte NC USA

Have you tried doing this;

Code:

Frontend
This allows you to use the CD as a frontend if you have a MythTV backend setup.
You can select this option by pressing <ENTER>. After providing the requested information, the CD will boot X and start mythfronted. 
Note: Using the CD as a frontend is dependant upon the backend being configured with MySQL listening on the network. 
If you are running KnoppMyth as your backend server, Then on the backend: 
Edit /etc/mysql/my.cnf, comment out 'skip-networking'. The backend will only accept the mythtv user with a password of mythtv.
Before:
skip-networking
After
# skip-networking
Restart MySQL(as root) 
# /etc/init.d/mysql restart 
Reconfigure MythTV (as the mythtv user) 
$ mythtv-setup
On screen 1 change 127.0.0.1(both instances) to the actual IP of the backend server. 
<ESC> out of the myth-setup. 
End of backend section.

[/code]

_________________
Backend System
XP2400
Nforce2 Abit NF7-S ver2
Intergrated nvidia sound and network
Nvidia 6200 DVI out to Projector
multiple drives using LVM
PVR - 500

Top

marc.aronson

Post subject:

Posted: Tue Jul 11, 2006 8:44 pm

Joined: Tue Jan 18, 2005 2:07 am

Posts: 1532

Location: California

What version of Knoppmyth are you using, and are you using that some install on both the front-end and backend?

Top

Page 1 of 1

[ 3 posts ]

Board index Linux General

All times are UTC - 6 hours

Who is online

Users browsing this forum: No registered users and 4 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