Re: [Dorset] Best Way of Installing Old Version of MySQL Client
Hi Terry, At the time, I didn't have to do anything for the pis to be compatible, because the mysql client provided worked with the database on the NAS box. I believe incompatibility would start to be a problem if we updated Raspberry Pi OS as well, but with the current version all seems fine. I think I'd have to recommend using a virtual machine too, that's probably the easiest fix for this problem. Hamish On 13 July 2023 10:56:03 BST, Terry Coles wrote: >Thanks everyone for your suggestions. > >On 13/07/2023 10:07, Ralph Corderoy wrote: >> A package manager understands dependencies between packages. You've >> cherry-picked one package and not handled its dependencies. > >> The executable isn't self-contained. It can refer to other object files of >> code. >... >> No, with the shared libraries you have available. But they, in turn, >> may eventually be incompatible with the kernel if you have to go back >> far enough. >Thanks. I think that I can see the light. >>> Does this mean I cannot use it on this machine without (perhaps) >>> running everything in a VM? >> That would seem simplest. >Yes; presumably running a very old distro to avoid all these issues. >> Or Hamish mentioned recently on this list some Python MySQL client which >> he uses. > >Apparently, that still calls the MySQL Client that has been installed. > >Hamish, > >When you built the software framework, what did you do to ensure compatibility >between the Pis and the NAS Box? > >-- >Terry Coles > > >-- > Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 > Check to whom you are replying > Meetings, mailing list, IRC, ... http://dorset.lug.org.uk > New thread, don't hijack: mailto:dorset@mailman.lug.org.uk -- Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Best Way of Installing Old Version of MySQL Client
Thanks everyone for your suggestions. On 13/07/2023 10:07, Ralph Corderoy wrote: A package manager understands dependencies between packages. You've cherry-picked one package and not handled its dependencies. The executable isn't self-contained. It can refer to other object files of code. ... No, with the shared libraries you have available. But they, in turn, may eventually be incompatible with the kernel if you have to go back far enough. Thanks. I think that I can see the light. Does this mean I cannot use it on this machine without (perhaps) running everything in a VM? That would seem simplest. Yes; presumably running a very old distro to avoid all these issues. Or Hamish mentioned recently on this list some Python MySQL client which he uses. Apparently, that still calls the MySQL Client that has been installed. Hamish, When you built the software framework, what did you do to ensure compatibility between the Pis and the NAS Box? -- Terry Coles -- Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Best Way of Installing Old Version of MySQL Client
Hi Terry, > Originally, I was getting a problem owing to a mismatch > between the Version on the server (5.1.56) and the version provided by > Ubuntu 23.04 (8.033). I uninstalled the package mysql-client-8.0, and > downloaded MySQL-client-5.1.56-1.glibc23.x86_64.rpm from the MySQL > website, (there is no deb available). I then used alien to convert the > rpm to a deb format and installed it. A package manager understands dependencies between packages. You've cherry-picked one package and not handled its dependencies. > However, when I tried to run this, I got: > > $ mysql -u -p -h 192.168.0.25 mysql: > error while loading shared libraries: libncursesw.so.5: cannot > open shared object file: No such file or directory The executable isn't self-contained. It can refer to other object files of code. $ ldd /bin/true linux-vdso.so.1 (0x7ffd13f35000) libc.so.6 => /usr/lib/libc.so.6 (0x7f00b6b92000) /lib64/ld-linux-x86-64.so.2 => /usr/lib64/ld-linux-x86-64.so.2 (0x7f00b6d91000) $ The executable you're running wants, amongst other things, a libncursesw.so.5 which isn't found. You probably have a later version installed. ‘locate libncursesw.so’ would find it. But installing an old version of libncursesw might just show up other old dependencies it needs. And so on. And the mysql executable might need other old things apart from libncursesw. You could spend days trying to sort it. > Clearly there is an incompatibility here with the kernel. No, with the shared libraries you have available. But they, in turn, may eventually be incompatible with the kernel if you have to go back far enough. > Does this mean I cannot use it on this machine without (perhaps) > running everything in a VM? That would seem simplest. Or Hamish mentioned recently on this list some Python MySQL client which he uses. -- Cheers, Ralph. -- Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Best Way of Installing Old Version of MySQL Client
This is indeed the way that .so files work. A symlink from the current version, to the non-versioned, and linked, library. On Thu, 13 Jul 2023 at 09:14, Victor Churchill wrote: > My recollection (a bit hazy, and I don't have a machine to hand to check) > is that under /usr/lib you should find a file > libncursesw.so. and another file libncursesw.so that is a symlink the > missing file: > libncursesw.so.4.perhaps > libncursesw.so -> libncursesw.so.5 > > and that your client is looking for libncursesw.so and the existing symlink > is pointing to a file that does not exist. > If you find that, then a fix could be to change the symlink to point to the > existing libncursesw.so.4.perhaps . > As caveatted above, this is based on a dimmish recollection from a while > ago. > > > best regards, > 웃 > Victor Churchill, > Netley Abbey, Southampton > > > > On Thu, 13 Jul 2023 at 08:40, Terry Coles wrote: > > > Hi, > > > > With Hamish's help, I've got as far as logging into the WMT Database > > over ssh; it appears that my keys didn't match. > > > > I'm now back to trying to access the database using the MySQL Client in > > a shell. Originally, I was getting a problem owing to a mismatch > > between the Version on the server (5.1.56) and the version provided by > > Ubuntu 23.04 (8.033). I uninstalled the package mysql-client-8.0, and > > downloaded MySQL-client-5.1.56-1.glibc23.x86_64.rpm from the MySQL > > website, (there is no deb available). I then used alien to convert the > > rpm to a deb format and installed it. > > > > However, when I tried to run this, I got: > > > > terry@OptiPlex:~/Useful$ mysql -u -p -h 192.168.0.25 mysql: > > error while loading shared libraries: libncursesw.so.5: cannot open > > shared object file: No such file or directory > > > > Clearly there is an incompatibility here with the kernel. Does this mean > > I cannot use it on this machine without (perhaps) running everything in > > a VM? > > > > -- > > Terry Coles > > > > > > -- > > Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 > > Check to whom you are replying > > Meetings, mailing list, IRC, ... http://dorset.lug.org.uk > > New thread, don't hijack: mailto:dorset@mailman.lug.org.uk > > > -- > Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 > Check to whom you are replying > Meetings, mailing list, IRC, ... http://dorset.lug.org.uk > New thread, don't hijack: mailto:dorset@mailman.lug.org.uk > -- Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Best Way of Installing Old Version of MySQL Client
Have you done an slocate libncurses* to see if any of the ncurses libraries are lurking on your system? On Thu, 13 Jul 2023 at 08:38, Terry Coles wrote: > Hi, > > With Hamish's help, I've got as far as logging into the WMT Database > over ssh; it appears that my keys didn't match. > > I'm now back to trying to access the database using the MySQL Client in > a shell. Originally, I was getting a problem owing to a mismatch > between the Version on the server (5.1.56) and the version provided by > Ubuntu 23.04 (8.033). I uninstalled the package mysql-client-8.0, and > downloaded MySQL-client-5.1.56-1.glibc23.x86_64.rpm from the MySQL > website, (there is no deb available). I then used alien to convert the > rpm to a deb format and installed it. > > However, when I tried to run this, I got: > > terry@OptiPlex:~/Useful$ mysql -u -p -h 192.168.0.25 mysql: > error while loading shared libraries: libncursesw.so.5: cannot open > shared object file: No such file or directory > > Clearly there is an incompatibility here with the kernel. Does this mean > I cannot use it on this machine without (perhaps) running everything in > a VM? > > -- > Terry Coles > > > -- > Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 > Check to whom you are replying > Meetings, mailing list, IRC, ... http://dorset.lug.org.uk > New thread, don't hijack: mailto:dorset@mailman.lug.org.uk > -- Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Best Way of Installing Old Version of MySQL Client
My recollection (a bit hazy, and I don't have a machine to hand to check) is that under /usr/lib you should find a file libncursesw.so. and another file libncursesw.so that is a symlink the missing file: libncursesw.so.4.perhaps libncursesw.so -> libncursesw.so.5 and that your client is looking for libncursesw.so and the existing symlink is pointing to a file that does not exist. If you find that, then a fix could be to change the symlink to point to the existing libncursesw.so.4.perhaps . As caveatted above, this is based on a dimmish recollection from a while ago. best regards, 웃 Victor Churchill, Netley Abbey, Southampton On Thu, 13 Jul 2023 at 08:40, Terry Coles wrote: > Hi, > > With Hamish's help, I've got as far as logging into the WMT Database > over ssh; it appears that my keys didn't match. > > I'm now back to trying to access the database using the MySQL Client in > a shell. Originally, I was getting a problem owing to a mismatch > between the Version on the server (5.1.56) and the version provided by > Ubuntu 23.04 (8.033). I uninstalled the package mysql-client-8.0, and > downloaded MySQL-client-5.1.56-1.glibc23.x86_64.rpm from the MySQL > website, (there is no deb available). I then used alien to convert the > rpm to a deb format and installed it. > > However, when I tried to run this, I got: > > terry@OptiPlex:~/Useful$ mysql -u -p -h 192.168.0.25 mysql: > error while loading shared libraries: libncursesw.so.5: cannot open > shared object file: No such file or directory > > Clearly there is an incompatibility here with the kernel. Does this mean > I cannot use it on this machine without (perhaps) running everything in > a VM? > > -- > Terry Coles > > > -- > Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 > Check to whom you are replying > Meetings, mailing list, IRC, ... http://dorset.lug.org.uk > New thread, don't hijack: mailto:dorset@mailman.lug.org.uk > -- Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
[Dorset] Best Way of Installing Old Version of MySQL Client
Hi, With Hamish's help, I've got as far as logging into the WMT Database over ssh; it appears that my keys didn't match. I'm now back to trying to access the database using the MySQL Client in a shell. Originally, I was getting a problem owing to a mismatch between the Version on the server (5.1.56) and the version provided by Ubuntu 23.04 (8.033). I uninstalled the package mysql-client-8.0, and downloaded MySQL-client-5.1.56-1.glibc23.x86_64.rpm from the MySQL website, (there is no deb available). I then used alien to convert the rpm to a deb format and installed it. However, when I tried to run this, I got: terry@OptiPlex:~/Useful$ mysql -u -p -h 192.168.0.25 mysql: error while loading shared libraries: libncursesw.so.5: cannot open shared object file: No such file or directory Clearly there is an incompatibility here with the kernel. Does this mean I cannot use it on this machine without (perhaps) running everything in a VM? -- Terry Coles -- Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk