-
I reported this bug directory to the maintainer, but I copy it here so it doesn't get reported several times:
http://lists.gnu.org/archive/html/savannah-hackers-public/2009-08/msg00004.html
Hi,
Thanks for developing libnss-mysql, it looks like I'll be able to drop
our db->system cron job ( at http://savannah.gnu.org/ ) :)
I have a suggestion to improve the 'getgrent' query quite a lot.
2009-08-23 10:46:58 UTC by beuc
-
Hi,
When the buffer is too small, libnss-mysql returns NSS_TRYAGAIN so that the OS doubles the buffer size and call the function again.
However the MySQL resultset is not reset, so when the function is called again, it uses the next row, and hence skips an entry.
I experienced this while using "getent group" (getgrent) with many users: it skipped a group at each buffer resize.
Attach...
2009-08-07 17:56:30 UTC by beuc
-
You'll want to set an appropriate connect timeout option in your system's my.cnf file. I don't recall the exact syntax offhand but I'm sure it's a well-documented MySQL configuration option.
2009-02-13 05:23:26 UTC by cinergi
-
I have 4 server setup where i am using libnss for authentication.
My Mysql server machine nfs goes down, so mysql hangs.
Now i am not able to login to any of the other 3 servers bcos the api call mysql_real_connect() hangs .
Is there any way i can set up a timeout when eshtablishing a connecction?
The api call should disconnect automatically after 5 seconds ..
something like that..
2009-02-11 12:32:26 UTC by deepasri
-
After looking at the backtrace and understanding what is going on a little more, it looks like something in the output of my getgrgid query isn't being handled properly; strlen() is segfaulting for some reason:
#0 0x00000008008209e2 in strlen () from /lib/libc.so.7
#1 0x000000080081dd1b in strchr () from /lib/libc.so.7
#2 0x00000008008181fa in snprintf () from /lib/libc.so.7
#3...
2009-01-22 18:09:27 UTC by silfreed
-
It seems that the passwd entries are working fine, but when I try to enable libnss-mysql for group I get segmentation faults when running 'id <user>'.
Looking at the trace, it looks like getpwnam is first called, then getgrent (getting all the groups), the group file is read, then id segfaults on running geteuid.
Any ideas on what might be going on here?
-Doug Warner.
2009-01-21 18:20:58 UTC by silfreed
-
I forgot to paste the permissions for mysql users.
Replace 'itbm' with the name of your database.
-- grant.sql start --------
grant usage on *.* to 'nss-root'@'localhost';
grant usage on *.* to 'nss-user'@'localhost';
grant select (name, id, home, shell, password)
on itbm.users
To 'nss-user'@'localhost', 'nss-root'@'localhost';
grant select (name, password...
2008-05-25 13:59:32 UTC by is_null
-
-- sql start ----------
CREATE TABLE `users_groups` (
`uid` int(7) NOT NULL,
`gid` int(7) NOT NULL,
`main` tinyint(1) default NULL
);
CREATE TABLE `users` (
`id` int(7) NOT NULL auto_increment,
`name` varchar(30) NOT NULL,
`password` varchar(34) NOT NULL,
`home` varchar(150) default NULL,
`shell` varchar(50) default NULL,
-- Optionnal, for gecos with CONCAT_WS(...
2008-05-25 13:32:21 UTC by is_null
-
Well that would certainly explain things. I apologize. Please feel free to delete my post so that no one gets confused. When I did an apt-cache search for nss-mysql, the only packages that come up are for the other project. That's really too confusing with the names being so similar. I thought I was helping you guys out. Sorry.
2007-12-01 22:15:28 UTC by dfwlinuxguy
-
Based on this config file:
http://dfwlinuxguy.com/libnss-mysql/nss-mysql.conf
You're not using this project's code. You're using http://savannah.nongnu.org/projects/nss-mysql/
Is that the reason for the confusion?
The examples and documentation included in my project should work perfectly. I'll certainly fix that if that's not the case -- but I'll need pointers to what's inaccurate.
2007-12-01 21:03:31 UTC by cinergi
