httpd: libnss-mysql: mysql_fetch_row() found 1 rows (expecting 3).
httpd: libnss-mysql: mysql_query failed: Lost connection to MySQL server during query, trying again (2)
They originate from httpd because i use FastCGI-SuExec wrapper with apache. Every site runs under its own user. I recently discovered the error message but there were no visual errors at first.
The situation got critical when i tried to add a record to the grouplist table creating a 'www' group membership for a new user/site. Suddenly all sites responded with the famous "No input file specified" from suexec.
Researching this issue further I found that when i tried to add the user to another group that i use to restrict access to my PHP library, no site could access the library any more. So when trying to add a new member, the group gets killed.
I have 127 users, 68 groups & 189 memberships in my DB. www group has 63 members, lib group has 62.
I hope someone can give me advice on this issue.
System details:
FreeBSD 5.4
Mysql client & server 5.0.33 (latest from ports)
libnss-mysql-1.5_2 (latest from port)
apache+mod_ssl 1.3.37+2.8.28 (latest from porf)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Let me first thank you looking into this issue, I understand you must be very busy.
Yes this is related to my previous post, i assumed a limit reached till i noticed te same with another group which had only 62 members.
When i add the membership to /etc/groups everything is fine.
It does not matter which username i try to make member of one of the groups. After i add the membership, the group is no longer available.
In my previous post you find part of the debug info running 'id' when the group is gone and on the bottom the succeeding calls when i remove the membership.
I wish my knowledge of C wasn't that limited or i would debug this issue myself.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
from syslog:
httpd: libnss-mysql: mysql_fetch_row() found 1 rows (expecting 3).
httpd: libnss-mysql: mysql_query failed: Lost connection to MySQL server during query, trying again (2)
They originate from httpd because i use FastCGI-SuExec wrapper with apache. Every site runs under its own user. I recently discovered the error message but there were no visual errors at first.
The situation got critical when i tried to add a record to the grouplist table creating a 'www' group membership for a new user/site. Suddenly all sites responded with the famous "No input file specified" from suexec.
Researching this issue further I found that when i tried to add the user to another group that i use to restrict access to my PHP library, no site could access the library any more. So when trying to add a new member, the group gets killed.
I have 127 users, 68 groups & 189 memberships in my DB. www group has 63 members, lib group has 62.
I hope someone can give me advice on this issue.
System details:
FreeBSD 5.4
Mysql client & server 5.0.33 (latest from ports)
libnss-mysql-1.5_2 (latest from port)
apache+mod_ssl 1.3.37+2.8.28 (latest from porf)
Is this related to the > 63 members in a group (https://sourceforge.net/forum/message.php?msg_id=4183623) problem you're having?
Let me first thank you looking into this issue, I understand you must be very busy.
Yes this is related to my previous post, i assumed a limit reached till i noticed te same with another group which had only 62 members.
When i add the membership to /etc/groups everything is fine.
It does not matter which username i try to make member of one of the groups. After i add the membership, the group is no longer available.
In my previous post you find part of the debug info running 'id' when the group is gone and on the bottom the succeeding calls when i remove the membership.
I wish my knowledge of C wasn't that limited or i would debug this issue myself.