I have run mc.sql onto sql, added a mythtv group, added<br>myself to that group, run the mysql commands to grant<br>permissions for the mythtv user, and still get<br>"cannot login to database?"<br><br><br><div class="gmail_quote">
On Sun, Dec 21, 2008 at 10:42 PM, the mad doctor kaeding <span dir="ltr"><<a href="mailto:the.mad.doctor.kaeding@gmail.com">the.mad.doctor.kaeding@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I just now compiled and installed the newest mysql (5.1.30),<br>and followed your instructions to the letter. And I get the<br>same problem: after a couple screens to enter sql names<br>and password, and checkboxes for waking the sql server,<br>
mythtv-setup takes me to a box saying "Cannot log in to<br>database?" (yes there is a question mark in it).<div class="Ih2E3d"><br><br>Here's what the terminal window says:<br><br>> mythtv-setup<br></div>
2008-12-21 22:40:32.067 Using runtime prefix = /usr, libdir = /usr/lib<br>
2008-12-21 22:40:32.307 DPMS is disabled.<br>2008-12-21 22:40:32.308 Empty LocalHostName.<br>2008-12-21 22:40:32.309 Using localhost value of kaeding<div class="Ih2E3d"><br>QSqlDatabase: QMYSQL3 driver not loaded<br>QSqlDatabase: available drivers:<br>
</div>
2008-12-21 22:40:32.311 New DB connection, total: 1<br>2008-12-21 22:40:32.311 Unable to connect to database!<br>2008-12-21 22:40:32.312 No error type from QSqlError? Strange...<br>QSqlQuery::exec: database not open<br>
QSqlQuery::exec: database not open<br>
2008-12-21 22:40:32.364 DB Error (KickDatabase):<br>Query was:<br>SELECT NULL;<div class="Ih2E3d"><br>No error type from QSqlError? Strange...<br>.............................................................................<br>
</div>2008-12-21 22:40:35.820 UPnPautoconf() - No UPnP backends found<br>
2008-12-21 22:40:35.821 No UPnP backends found<br>2008-12-21 22:40:35.827 Total desktop dim: 1600x1200, with 1 screen[s].<br>2008-12-21 22:40:35.827 Using screen 0, 1600x1200 at 0,0<br>2008-12-21 22:40:35.830 Switching to square mode (blue)<br>
2008-12-21 22:40:35.878 Using the Qt painter<div class="Ih2E3d"><br>mythtv: could not connect to socket<br>mythtv: Connection refused<br></div>2008-12-21 22:40:35.915 lirc_init failed for mythtv, see preceding messages<br>
2008-12-21 22:40:35.915 JoystickMenuClient Error: Joystick disabled - Failed toread /root/.mythtv/joystickmenurc<br>
2008-12-21 22:40:37.547 DB Error (Clear setting):<div class="Ih2E3d"><br>Query was:<br><br>No error type from QSqlError? Strange...<br></div>2008-12-21 22:40:37.547 DB Error (SaveSettingOnHost query failure: ):<div class="Ih2E3d">
<br>Query was:<br><br>No error type from QSqlError? Strange...<br></div>
2008-12-21 22:40:37.547 DB Error (Clear setting):<div class="Ih2E3d"><br>Query was:<br><br>No error type from QSqlError? Strange...<br></div>2008-12-21 22:40:37.547 DB Error (SaveSettingOnHost query failure: ):<div class="Ih2E3d">
<br>Query was:<br><br>No error type from QSqlError? Strange...<br></div>
2008-12-21 22:40:49.783 Writing settings file /root/.mythtv/mysql.txt<br>2008-12-21 22:40:49.784 Closing DB connection named 'DBManager0'<br>2008-12-21 22:40:49.824 Unable to connect to database!<br>2008-12-21 22:40:49.825 No error type from QSqlError? Strange...<br>
QSqlQuery::exec: database not open<br>QSqlQuery::exec: database not open<br>2008-12-21 22:40:49.876 DB Error (KickDatabase):<br>Query was:<br>SELECT NULL;<div class="Ih2E3d"><br>No error type from QSqlError? Strange...<br>
</div>2008-12-21 22:40:49.928 Cannot login to database?<br>
2008-12-21 22:40:49.928 Cannot login to database?<br>2008-12-21 22:40:49.928 Total desktop dim: 1600x1200, with 1 screen[s].<br>2008-12-21 22:40:49.929 Using screen 0, 1600x1200 at 0,0<br>2008-12-21 22:40:49.930 Switching to square mode (blue)<br>
2008-12-21 22:40:50.141 Using the Qt painter<div class="Ih2E3d"><br>mythtv: could not connect to socket<br>mythtv: Connection refused<br></div>2008-12-21 22:40:50.163 lirc_init failed for mythtv, see preceding messages<br>
2008-12-21 22:40:50.164 JoystickMenuClient Error: Joystick disabled - Failed toread /root/.mythtv/joystickmenurc<br>
2008-12-21 22:40:51.277 DB Error (Clear setting):<div class="Ih2E3d"><br>Query was:<br><br>No error type from QSqlError? Strange...<br></div>2008-12-21 22:40:51.277 DB Error (SaveSettingOnHost query failure: ):<div class="Ih2E3d">
<br>Query was:<br><br>No error type from QSqlError? Strange...<br></div>
2008-12-21 22:40:54.672 User cancelled database configuration<br>2008-12-21 22:40:54.698 Deleting UPnP client...<br>2008-12-21 22:40:56.073 Failed to init MythContext, exiting.<br><br><br><br><div class="gmail_quote"><div>
<div></div><div class="Wj3C7c">On Sun, Dec 21, 2008 at 9:32 PM, Brad DerManouelian <span dir="ltr"><<a href="mailto:myth@dermanouelian.com" target="_blank">myth@dermanouelian.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="Wj3C7c"><div><div><div><div>On Dec 21, 2008, at 5:38 PM, the mad doctor kaeding wrote:</div>
<br><blockquote type="cite">echo 'show databases;' | mysql --user=root --password<br>gives<br>....<br>mysql<br>mythconverg<br>.....</blockquote><div><br></div></div><div>So the mythtv user doesn't have access to the mythconverg database by the root user does.</div>
<div>Again, I point you to this page:</div><div><a href="http://www.mythtv.org/wiki/index.php/Mysql" target="_blank">http://www.mythtv.org/wiki/index.php/Mysql</a></div><div>With special attention to this part:</div><div>
<span style="font-family: -webkit-sans-serif; font-size: 13px; line-height: 19px;"><pre style="border: 1px dashed rgb(47, 111, 171); padding: 1em; color: black; background-color: rgb(249, 249, 249); line-height: 1.1em;">
# mysql -u root -p mysql
myqsl> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost'
-> IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
mysql> FLUSH PRIVILEGES;
mysql> quit</pre></span></div></div><br></div><br></div></div><div class="Ih2E3d">_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
<br></div></blockquote></div><br>
</blockquote></div><br>