We hadn't dabbled with Zope and database connectivity before, so we decided to initially try getting it connecting to MySQL. After some initial problems, we got this working fine with one exception. If our server has to be restarted for any reason, then the rpm of MySQL that we installed stops working (amongst other things, the socket seems to disappear off the server!). So, each time the server is restarted (not very often thankfully), we have to reinstall MySQL. Anyone hazard a guess why it's doing this? Richard H.
Richard Hewison writes:
... If our server has to be restarted for any reason, then the rpm of MySQL that we installed stops working (amongst other things, the socket seems to disappear off the server!). So, each time the server is restarted (not very often thankfully), we have to reinstall MySQL. Anyone hazard a guess why it's doing this? It is not completely unimaginable that a communication socket goes away when the server is shut down.
It should be created again when the server restarts. If not, try a newer version of MySQL. If this is impossible, there are easier ways to create a socket (mknode) than reinstalling the rpm. Dieter
On 26 Feb 2002, at 20:10, Dieter Maurer wrote:
It is not completely unimaginable that a communication socket goes away when the server is shut down.
That's our limited knowledge of Linux and comms sockets for you. Thanks for the info.
It should be created again when the server restarts. If not, try a newer version of MySQL. If this is impossible, there are easier ways to create a socket (mknode) than reinstalling the rpm.
We are running the most recent version of MySQL for Linux that we could find (rpm version 3.23.47-1). I'm assuming that the command to create this socket on restarting the OS is located somewhere in a Linux startup script of some kind? Thanks for your help on this. After all, this problem we've got with MySQL is only indirectly Zope related! Richard H.
Richard Hewison writes:
On 26 Feb 2002, at 20:10, Dieter Maurer wrote: .... We are running the most recent version of MySQL for Linux that we could find (rpm version 3.23.47-1). I'm assuming that the command to create this socket on restarting the OS is located somewhere in a Linux startup script of some kind? Not sure, whether your rpm installs it there automatically. It should be in the start script.
Dieter
Not sure, whether your rpm installs it there automatically. It should be in the start script.
Dieter
We've now found a slightly more recent non-rpm release of MySQL for Linux v3.23.49a and that install works fine and has solved the problem of the socket vanishing when the OS is restarted. Thanks for all suggestions. Richard H.
On Wed, 2002-02-27 at 03:33, Richard Hewison wrote:
We are running the most recent version of MySQL for Linux that we could find (rpm version 3.23.47-1). I'm assuming that the command to create this socket on restarting the OS is located somewhere in a Linux startup script of some kind?
Assuming you have at least Red Hat 7.0: /sbin/service mysql help else: /etc/rc.d/init.d/mysql help You must be root to do anything useful (start|stop). -- Andy Dustman PGP: 0x930B8AB6 @ .net http://dustman.net/andy You can have my keys when you pry them from my dead, cold neurons.
participants (3)
-
Andy Dustman -
Dieter Maurer -
Richard Hewison