Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » security system, no users shown....

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Page: 1 2 3
Go to End
Author Topic: 12345 Views
  • Nicolaas
    Avatar
    Forum Moderator
    213 Posts

    security system, no users shown.... Link to this post

    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.

  • Andy
    Avatar
    230 Posts

    Re: security system, no users shown.... Link to this post

    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!

  • Nicolaas
    Avatar
    Forum Moderator
    213 Posts

    Re: security system, no users shown.... Link to this post

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

  • loubabe
    Avatar
    1 Post

    Re: security system, no users shown.... Link to this post

    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?

  • Andy
    Avatar
    230 Posts

    Re: security system, no users shown.... Link to this post

    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.

  • billy
    Avatar
    Community Member
    9 Posts

    Re: security system, no users shown.... Link to this post

    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"

  • billy
    Avatar
    Community Member
    9 Posts

    Re: security system, no users shown.... Link to this post

    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.

  • guillem_l
    Avatar
    9 Posts

    Re: security system, no users shown.... Link to this post

    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.

    12345 Views
Page: 1 2 3
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.