I have installed the 1.3 version of libnss-mysql from rpm and from source with the same results. Everything works as expected except that whenever the server is rebooted, libnss-mysql opens multiple (10-15?) persistant connections to my database. If I install libnss-mysql and use it without rebooting only one persistant connection is created. It's almost like the libnss-mysql can not see the database immediatly when the sytem is booting so it just keeps trying to open new persistant connections, then the database appears and all the persistant connections become active. Again this is only a problem with rebooting. Does anyone have any ideas?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I think these just must be the result of applications starting on boot. I'll have to increase the amount of connections allowed per host and set the wait time down and see what happens.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You are correct. Many daemons/processes will ask for a username only once in a great while, and often only at startup. Your solution should do the trick.
The FSSOS project I'm now working on solves this issue by the way. I just released 0.4, which should be pretty stable on linux.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have installed the 1.3 version of libnss-mysql from rpm and from source with the same results. Everything works as expected except that whenever the server is rebooted, libnss-mysql opens multiple (10-15?) persistant connections to my database. If I install libnss-mysql and use it without rebooting only one persistant connection is created. It's almost like the libnss-mysql can not see the database immediatly when the sytem is booting so it just keeps trying to open new persistant connections, then the database appears and all the persistant connections become active. Again this is only a problem with rebooting. Does anyone have any ideas?
I think these just must be the result of applications starting on boot. I'll have to increase the amount of connections allowed per host and set the wait time down and see what happens.
You are correct. Many daemons/processes will ask for a username only once in a great while, and often only at startup. Your solution should do the trick.
The FSSOS project I'm now working on solves this issue by the way. I just released 0.4, which should be pretty stable on linux.