Forum posts to 'Archive'

Re: security system, no users shown....

rino — Wed, 14 May 2008 22:33:04 +1200

some other problem i noticed: i think the whole ajax system (showing list of possible accounts while typing etc.) has a problem if you have your PHP configuration (php.ini) on
error_reporting = E_ALL (shows all PHP errors and notices). the ajax response will then contains notices about undefined variables at the beginning, for example:

<code>
Notice: Undefined variable: result in C:\DATA\PHP_Eclipse_Workspace\P503_ZOFINGIA_WEBSITE

\htdocs\cms\code\SecurityAdmin.php on line 99

on my system this prevented the popup list with the possible accounts from showing...

as soon as i change the php.ini file to "error_reporting = E_ALL & ~E_NOTICE" and restart apache it starts to work again.

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

Decisive Flow — Tue, 22 Apr 2008 08:07:01 +1200

Doesn't work for 2.2

It seems crazy in a basic silverstripe installation, I can't add, view or edit users.

The one I added through the database to a user group with no permissions (as told to in order to see restricted front end pages) just keeps redirecting back to the login page.

Help!!!!

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

Decisive Flow — Mon, 21 Apr 2008 15:18:02 +1200

haydens worked for me as well.. although I still don't think I can add new users - I can modify ones that exist though or something. Something seemed to work after a while anyway,

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

mandrew — Mon, 21 Apr 2008 15:16:00 +1200

Can someone confirm that this bug doesn't appear in the latest release candidate?

If so then we need to know about it!

Thanks

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

contigo — Sat, 12 Apr 2008 03:24:54 +1200

I could not view users as well, Hayden's suggestion above did the trick.

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

bbeer — Sat, 29 Mar 2008 22:27:35 +1300

OK I was able to solve my Problem.
I had eAccelerator in PHP5 on, this prevented the users and Groups from being visible. I switched it off now all is perfect!

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

bbeer — Wed, 26 Mar 2008 08:10:04 +1300

Hi
OK same Problem here. The right side of the Security Panel stays empty. I don't see any users nor can I edit any groups. However I can add groups but not edit them.

Thanks for your help!

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

Hayden — Wed, 19 Mar 2008 17:27:35 +1300

Does changing HAVING MIN(`ID`) to HAVING MIN(`ID`) = ID on line 143 of cms/code/MemberTableField.php help at all?

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

Decisive Flow — Mon, 17 Mar 2008 10:42:16 +1300

I have the same problem but don't really want to do anything until the 'official' fix is there.

But I have a new live site and no access for my customer!

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

darkowl — Thu, 17 Jan 2008 11:36:02 +1300

Very interesting... question for you, can you add / view members in the newsletter module?

It seems that they use the same tables (site members and newsletter recipients), so could this be related to the issue that I've encountered here: http://www.silverstripe.com/site-builders-forum/flat/24702

EDIT: Just had a look at the security section, lo and behold no users are shown (but are in the database). I'd say that they're related.

MySQL version is 4.1.11

Running the query from the previous page (modded for my setup), I get...

SQL query:

SELECT `Group_Members`.`ID` IN (SELECT `ID` FROM `Group_Members` WHERE `GroupID`='4' GROUP BY `MemberID` HAVING MIN(`ID`))

MySQL said:

#1109 - Unknown table 'Group_Members' in IN/ALL/ANY subquery

Let's see if we can do something about that...

EDIT 2: Yes indeed, it seems that HAVING MIN(`ID`) seems to be at fault. If it's removed, SilverStripe magically starts showing users again. I have no idea what repercussions that's going to have - hopefully none ;)

The next question then, is *why* that code was failing silently (silent fails are never a good thing...)

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

guillem_l — Tue, 08 Jan 2008 11:42:52 +1300

I'm having same problem, no users shown in security section. Will try to remove MIN from the SQL query but would be great to get some official answer about this issue. I get same error in tow different machines with tow different servers.

Thanks.

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

billy — Tue, 06 Nov 2007 14:15:25 +1300

Ok, further to this.. I took the sub select from the query mentioned above "SELECT `ID` FROM `Group_Members` WHERE `GroupID`='2' GROUP BY `MemberID` HAVING MIN(`ID`);"

Again this query works on 2 boxes and not on the other one.

Then I take the MIN(ID) out and what do you know, it works on across the board!

Considering that the box having the problems is the oldest version out of the three I'm wondering if the functionality of the MySQL 'MIN' function has changed somehow?

Anyway if anyone could offer me a fix that would be great.

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

billy — Tue, 06 Nov 2007 14:08:59 +1300

Anything further on this? I'm getting the same thing, can't allow axx to the server though sorry

The strange thing is that the same code, with the same database is working on two different machines.

I managed to do a bit of investigation into the bug: When I var_dumped the 'MemberTableField' object I find a member variable called 'sourceFilter' which contains an array with element that has a value of "`Group_Members`.`ID` IN (SELECT `ID` FROM `Group_Members` WHERE `GroupID`='1' GROUP BY `MemberID` HAVING MIN(`ID`))"

So I used this to create a select that looks like this: SELECT * FROM Group_Members WHERE `Group_Members`.`ID` IN (SELECT `ID` FROM `Group_Members` WHERE `GroupID`='1' GROUP BY `MemberID` HAVING MIN(`ID`));

Running this select on the boxes that work results in a set of data, one row for each user in the group. Running it on the box that doesn't work I get nothing.

Seems like it's a mysql related issue to me.

Working machines are "MySQL 5.0.45-Debian_1" and "MySQL 5.0.24a-log"
Non-Working machine is "MySQL 5.0.18"

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

Andy — Wed, 12 Sep 2007 09:54:43 +1200

I'm sorry, I have never seen this bug before. If one of you is ok with me accessing your server, then send me your server details (andrew@silverstripe.com) and I'll see if I can find what is causing the problem.

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

loubabe — Wed, 12 Sep 2007 08:32:14 +1200

I am having the exact same problem. The membes are in the database, and I can even login with the given account, but nothing is visible in the security pages. Not even the original admin account I created. Any ideas?

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

Nicolaas — Tue, 11 Sep 2007 12:50:58 +1200

yes, this is in the security area. The person added never shows at all.... Does that answer your question?

Posted to: security system, no users shown.... Show Thread | Post Reply

Re: security system, no users shown....

Andy — Tue, 11 Sep 2007 12:42:34 +1200

Is the list you are referring to the table in the Security admin section in the CMS? What happens when you add a member - do they stay until you refresh or disappear immediately?

The inability to delete a user is a known issue, the best you can do via the CMS is remove them from all groups. I've created a ticket for this issue.

There is a register link on the bug tracker on the top right under the search button!

Posted to: security system, no users shown.... Show Thread | Post Reply

security system, no users shown....

Nicolaas — Mon, 10 Sep 2007 14:59:52 +1200

Hi,

I have just installed ss on a new site, but I cant seem to add users to the security list.
That is, I can add them, but they do not show on the list. I do think they are actually added, because somewhere else I saw them as an option for owner.

Also, I want to get rid of the user with the default username and password (but, again the problem is that this is not listed anywhere)

Is there something that I am missing?

Thanks

Nicolaas
PS how can i log something to the bug database? I do not have a username or password for that...
PPS I checked the mysql database and in there I found all the users in the members table.

Posted to: security system, no users shown.... Show Thread | Post Reply