[mythtv-users] MySQL mythconverg permissions.... i give up.
rickard.l
rickard.l at bredband.net
Sat Mar 18 20:05:46 UTC 2006
Try installing libqt3-mt-mysql
-----Ursprungligt meddelande-----
Från: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] För Ed Gradek
Skickat: den 18 mars 2006 21:00
Till: mythtv-users at mythtv.org
Ämne: [mythtv-users] MySQL mythconverg permissions.... i give up.
Hi All,
I've spent the last few days trying to figure this out on my own, searching
the net, asking friends, and I'm all out of options.
I have a backend server with a single capture card (PVR-250) hostname
"backend.domain.com", IP 172.30.2.50
I have a frontend server, with TV-Out (EPIA MII 12000) hostname
"frontend.domain.com" IP 172.30.2.51
Everything was installed based on wilsonet.com's directions, all updates /
installs via YUM.
Backened works perfect. I try to load "mythfrontend" from the frontend
server, i get:
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-03-18 11:46:13.265 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-03-18 11:46:13.322 Unable to connect to database!
2006-03-18 11:46:13.322 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'root'@'frontend.domain.com' (using password: YES)
I've tried all combinations of the permissions section from the
myth-howto....:
$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
mysql> flush privileges;
....as well as using IP's instead of hostnames (which resolve fine either
way), firewall's and LinuxSE are all disabled, connecting as "root", etc. I
just have no idea what's wrong. I have NO idea what the mysql commands are
above, so maybe I have the syntax incorrect?
But can't figure it out.
Any help would be great! :(
Ed
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
More information about the mythtv-users
mailing list