Alpha Video Training
Results 1 to 3 of 3

Thread: Web security SQL migration, unable to delete users

  1. #1
    Member
    Real Name
    Luke
    Join Date
    Dec 2011
    Location
    Northern Virginia, USA
    Posts
    174

    Default Web security SQL migration, unable to delete users

    I am in the process of migrating my web security tables to MySQL and have hit a snag, I can not delete users from the web security "add users and groups" dialog built into alpha five. It gives no error, after I close and reopen the dialog all the users I deleted are back (they never got deleted from the SQL db). I know the database connection works as I can add users, change their assigned groups, add groups, and delete groups.

    I originally setup all my tables to have int primary keys but have since moved over to the GUIDs as I assumed that was the issue but it did not fix the issue. I have checked all the active link field mappings with the field names listed here: http://wiki.alphasoftware.com/a5/Usi...20Security.pdf and they line up. I can edit a user so I assume the field mappings is not the issue anyways.

    Anyone else have this issue?

  2. #2
    Member
    Real Name
    Luke
    Join Date
    Dec 2011
    Location
    Northern Virginia, USA
    Posts
    174

    Default Re: Web security SQL migration, unable to delete users

    Here are my table definitions if it helps

    websecurity_users SQL Table
    Code:
    CREATE TABLE `websecurity_users` (
      `ws_users_GUID` char(36) NOT NULL,
      `ws_users_Userid` char(100) NOT NULL,
      `ws_users_Password` char(60) DEFAULT NULL,
      `ws_users_RememberMe` bit(1) DEFAULT NULL,
      `ws_users_RedirPage` char(60) DEFAULT NULL,
      `ws_users_Password_Entered` datetime DEFAULT NULL,
      `ws_users_Password_Expires` datetime DEFAULT NULL,
      `ws_users_Email` char(100) DEFAULT NULL,
      `ws_users_Security_Question` char(100) DEFAULT NULL,
      `ws_users_Security_Answer` char(60) DEFAULT NULL,
      `ws_users_updated_web` datetime DEFAULT NULL,
      `ws_users_updated_local` datetime DEFAULT NULL,
      `ws_users_ulink` char(40) DEFAULT NULL,
      PRIMARY KEY (`ws_users_GUID`),
      UNIQUE KEY `ws_users_Userid` (`ws_users_Userid`),
      UNIQUE KEY `ws_users_GUID` (`ws_users_GUID`),
      KEY `ws_users_Userid_idx` (`ws_users_Userid`),
      KEY `ws_users_GUID_idx` (`ws_users_GUID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    websecurity_users active link field map
    Code:
    guid|ws_users_GUID|C
    userid|ws_users_Userid|C
    password|ws_users_Password|C
    rememberme|ws_users_RememberMe|L
    redirpage|ws_users_RedirPage|C
    passEnt|ws_users_Password_Entered|T
    passExp|ws_users_Password_Expires|T
    email|ws_users_Email|C
    SecQues|ws_users_Security_Question|C
    SecAns|ws_users_Security_Answer|C
    updweb|ws_users_updated_web|T
    updlocal|ws_users_updated_local|T
    ulink|ws_users_ulink|C


    websecurity_members SQL Table
    Code:
    CREATE TABLE `websecurity_members` (
      `ws_members_group_GUID` char(36) NOT NULL,
      `ws_members_user_GUID` char(36) NOT NULL,
      `ws_members_updweb` datetime DEFAULT NULL,
      `ws_members_updlocal` datetime DEFAULT NULL,
      PRIMARY KEY (`ws_members_group_GUID`,`ws_members_user_GUID`),
      KEY `ws_members_group_GUID` (`ws_members_group_GUID`),
      KEY `ws_members_user_GUID` (`ws_members_user_GUID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    websecurity_members active link field map
    Code:
    group_guid|ws_members_group_GUID|C
    user_guid|ws_members_user_GUID|C
    updweb|ws_members_updweb|T
    updlocal|ws_members_updlocal|T


    websecurity_groups SQL Table
    Code:
    CREATE TABLE `websecurity_groups` (
      `ws_groups_group_GUID` char(36) NOT NULL,
      `ws_groups_group_name` char(60) NOT NULL,
      `ws_groups_updweb` datetime DEFAULT NULL,
      `ws_groups_updlocal` datetime DEFAULT NULL,
      PRIMARY KEY (`ws_groups_group_GUID`),
      KEY `ws_groups_group_GUID` (`ws_groups_group_GUID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    websecurity_groups active link field map
    Code:
    group_Guid|ws_groups_group_GUID|C
    group_Name|ws_groups_group_name|C
    updweb|ws_groups_updweb|T
    updlocal|ws_groups_updlocal|T

    websecurity_expired SQL Table
    Code:
    CREATE TABLE `websecurity_expired` (
      `ws_expired_user_GUID` char(36) NOT NULL,
      `ws_expired_Password` char(60) NOT NULL,
      `ws_expired_lastused` datetime NOT NULL,
      PRIMARY KEY (`ws_expired_user_GUID`),
      KEY `ws_expired_user_GUID` (`ws_expired_user_GUID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    websecurity_expired active link field map
    Code:
    user_Guid|ws_expired_user_GUID|C
    password|ws_expired_Password|C
    lastused|ws_expired_lastused|T

  3. #3
    "Certified" Alphaholic TheSmitchell's Avatar
    Real Name
    Sarah
    Join Date
    Apr 2012
    Posts
    1,334

    Default Re: Web security SQL migration, unable to delete users

    Quote Originally Posted by LukeS View Post
    I am in the process of migrating my web security tables to MySQL and have hit a snag, I can not delete users from the web security "add users and groups" dialog built into alpha five. It gives no error, after I close and reopen the dialog all the users I deleted are back (they never got deleted from the SQL db). I know the database connection works as I can add users, change their assigned groups, add groups, and delete groups.

    I originally setup all my tables to have int primary keys but have since moved over to the GUIDs as I assumed that was the issue but it did not fix the issue. I have checked all the active link field mappings with the field names listed here: http://wiki.alphasoftware.com/a5/Usi...20Security.pdf and they line up. I can edit a user so I assume the field mappings is not the issue anyways.

    Anyone else have this issue?
    YES. How did you solve your problem?
    Alpha Anywhere latest pre-release

Similar Threads

  1. Cant add web users for web security
    By russgoeckner in forum Application Server Version 11 - Web/Browser Applications
    Replies: 7
    Last Post: 05-14-2013, 05:17 AM
  2. Web Security: deleting all users of a group
    By Rida Alhasan in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 04-29-2012, 07:09 AM
  3. Retrieve web security users
    By eskimoavenue in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 10-04-2011, 01:14 PM
  4. Security Framework Delete/Import users
    By Steve Bovino in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 11-29-2008, 01:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •