tisdag 02 november 2004 16:28 skrev Danny Sauer:
The SQL auth works ok, but the nss libraries just don't seem to work quite completely - and it's tough to determine *which* of the available libraries should be used, given that there are at elast 2 of each, and that both of those usually appear to be dead. I've played with nss_mysql and pam_mysql, never any of the other SQL variants. It's a shame that it's not quite there, because I'm a bit more comfortable dealing with the RDBMS than I am with the LDAP stuff. The LDAP has a bit more "smoke and mirrors" feel to it, for some reason. Maybe that's just me. Regardless, you definately need to use indecies, and you should probably run nscd if you're using any network auth service. That'd probably take care of any slowdown.
Did you try using ldap with an sql backend? After I setup bdb as an ldap backend, the speed was good ... it's the default ldap database that was slow. I noticed the slowness, because I did setup ldap on my own desktop, while testing and stuff, but when I went into 3D games, there was a "momentary" pause during network play all the time. The reason, was the ldap ... momentary wasn't some huge time, only an instant, but during armyops ... that's enough to get your character killed during combat :-) I did notice however, when I revisited my settings that I had indexed all major attributes, including default as sub, but had failed to specifically index the uid attribute, merely the uidNumber attribute. It may have played a role, but bdb is definately faster but more volatile.