Re: [mythtv-users] mysql access problem
On Thu, 2005-10-13 at 22:24 +0100, Martin West wrote: hhmm, I think I have found the problem. The default mysql installation 3.23.58. I have a local installation of 4.1 in /usr/local. /usr/bin/mysql -u mythtv -p Enter password: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client So now have to figure how to get mythtvsetup to use my local installation. The solution is http://dev.mysql.com/doc/refman/5.0/en/old-client.html SET PASSWORD FOR 'mythtv'@'localhost' = OLD_PASSWORD('mythtv'); and add old_password to the daemon pragmas in my.cnf. On Thu, 2005-10-13 at 22:06 +0100, Martin West wrote: I ran the install mc.sql OK but when I run mythtvsetup I get an error saying authentication protocol not supported. I can logon using mysql -u mythtv -p at a command line. Im using mysql 4.1.9 on FC3. Any thoughts? ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- regards Martin West http://www.objectgizmos.com 07879 680 096 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
Yep, Thanks. Found the solution last night. You also have to add old_password to my.cnf The mythtv is one installed by yum following the instructions for fedora. On Thu, 2005-10-13 at 15:08 -0700, Ben Holt wrote: On 13/10/05, Martin West [EMAIL PROTECTED] wrote: I ran the install mc.sql OK but when I run mythtvsetup I get an error saying authentication protocol not supported. I can logon using mysql -u mythtv -p at a command line. Im using mysql 4.1.9 on FC3. Any thoughts? It looks like your mythtv version was compiled against an older mysql version. 4.1 uses a different format than earlier versions. Here's what you need to do: mysql -u root -p mysql (enter root password) update user SET Password=OLD_PASSWORD('mythtv user password') where User='mythtv username'; FLUSH PRIVILEGES; exit; Mythtv should now be able to access your database again. - Ben ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- regards Martin West http://www.objectgizmos.com 07879 680 096 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] mysql access problem
I ran the install mc.sql OK but when I run mythtvsetup I get an error saying authentication protocol not supported. I can logon using mysql -u mythtv -p at a command line. Im using mysql 4.1.9 on FC3. Any thoughts? -- regards Martin West ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
hhmm, I think I have found the problem. The default mysql installation 3.23.58. I have a local installation of 4.1 in /usr/local. /usr/bin/mysql -u mythtv -p Enter password: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client So now have to figure how to get mythtvsetup to use my local installation. On Thu, 2005-10-13 at 22:06 +0100, Martin West wrote: I ran the install mc.sql OK but when I run mythtvsetup I get an error saying authentication protocol not supported. I can logon using mysql -u mythtv -p at a command line. Im using mysql 4.1.9 on FC3. Any thoughts? ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- regards Martin West http://www.objectgizmos.com 07879 680 096 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
Martin West wrote: I ran the install mc.sql OK but when I run mythtvsetup I get an error saying authentication protocol not supported. I can logon using mysql -u mythtv -p at a command line. Im using mysql 4.1.9 on FC3. The authentication protocol error means that the current user doesn't have permission to use X11 so no window can be created. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
Martin West wrote: hhmm, I think I have found the problem. The default mysql installation 3.23.58. I have a local installation of 4.1 in /usr/local. /usr/bin/mysql -u mythtv -p Enter password: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client Bruce Markey wrote: The authentication protocol error means that the current user doesn't have permission to use X11 so no window can be created. Opps, I was thinking of another problem people often rreport but this is a different error message. Never mind. See www.mysql.org for the best information regarding MySQL stuff. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
On Thu, 2005-10-13 at 14:34 -0700, Bruce Markey wrote: Martin West wrote: I ran the install mc.sql OK but when I run mythtvsetup I get an error saying authentication protocol not supported. I can logon using mysql -u mythtv -p at a command line. Im using mysql 4.1.9 on FC3. The authentication protocol error means that the current user doesn't have permission to use X11 so no window can be created. Thanks but I dont think so. The X Window comes up. Its a mysql problem, Im trying LD_LIBRARY_PATH pointing to my mysql lib directory in usr/local -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- regards Martin West http://www.objectgizmos.com 07879 680 096 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
On 13/10/05, Martin West [EMAIL PROTECTED] wrote: I ran the install mc.sql OK but when I run mythtvsetup I get an error saying authentication protocol not supported. I can logon using mysql -u mythtv -p at a command line. Im using mysql 4.1.9 on FC3. Any thoughts? It looks like your mythtv version was compiled against an older mysql version. 4.1 uses a different format than earlier versions. Here's what you need to do: mysql -u root -p mysql (enter root password) update user SET Password=OLD_PASSWORD('mythtv user password') where User='mythtv username'; FLUSH PRIVILEGES; exit; Mythtv should now be able to access your database again. - Ben ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users