On Wed, 2006-12-13 at 10:53 -0600, Michael Satterwhite wrote: > Craig White wrote: > > On Wed, 2006-12-13 at 10:07 -0600, Michael Satterwhite wrote: > >> Craig White wrote: > >>> On Wed, 2006-12-13 at 09:52 -0600, Michael Satterwhite wrote: > >>>> When I try to connect to the mysql server on Fedora, the client > >>>> libraries report that they don't support the authentication scheme used > >>>> by 5.1. I can't upgrade the client libraries as the production server is > >>>> running mysql 4.1 (I'm using Fedora for development). > >>>> > >>>> I see the 4.1 client routines in the yum search, but I don't see the 4.1 > >>>> server. How can I install mysql 4.1 on FC5? > >>> ---- > >>> yum install mysqlclient14 > >>> > >>> if necessary... > >>> > >>> yum install mysqlclient14-devel > >> That I've got. The question is how to install Mysql *SERVER* 4.1. > > ---- > > "I see" said the blind man > > > > Check on the 'client' machine that 'my.cnf' is using > > > > old_passwords=0 > > > > a downgrade of the server from mysql-5 to mysql-4 isn't generally desired and installing it would be a trick and a half since there are so many things built against the mysql-libs already in Fedora. > > > > Are we still talking Ruby on Rails? What OS does your server run? Is it reasonable to think in terms of upgrading the server to mysql-5 if the suggestion about oldpasswords doesn't help? > > Not RoR this time. > > I have a (legacy) VB program that I support. It runs productively > against a 4.1 server - so the client libs on the Windows machine are (of > course) 4.1. > > The production server is running linux (slackware, I believe). > > I have to connect to the development server as well as the production > server, and I have no ability to force the production server to upgrade > to mysql 5. Those responsible for the production server won't upgrade > until *THEY* have a reason to need to. ---- OK then, given that Fedora has as its stated purpose to be a bleeding edge distribution, MySQL 4.x doesn't get coverage and most would use RHEL or a re-spin like CentOS 4 and automatically get MySQL 4.1.x as part of the distribution. If you absolutely had to have MySQL 4.x on a Fedora Core 5/6 system, I would think that the only way to accomplish it without getting everything else all fubar would be to install from source, in /usr/local and compile only the server stuff that you need while leaving the MySQL 5 libs, etc in place. This is not an easy task but shouldn't be that difficult either. Craig
