Hi Matt, I'm told by engineering that this was an issue on our end (when generating the data for export), and that it should now be fixed.
To update, you'd need to run the following query and then sync again: UPDATE roles SET env_id = '0', account_id = '0' WHERE env_id IS NULL AND account_id IS NULL; I think this is equivalent to what you can, though, so if it works you might not need to update again. Cheers, -- Thomas | Product Manager @ Scalr | tho...@scalr.com | www.scalr.com | blog.scalr.com On Fri, May 1, 2015 at 2:45 PM, Matt Shibla <mshib...@gmail.com> wrote: > I've found a difference in the data between the 2 hosts which appears to > cause the shared roles not to show. On the 2nd server, the client_id and > env_id fields of the roles table were NULL for the origin = "SHARED" > roles. On the 1st server (where the roles showed up), these fields were > 0. After altering the data on the 2nd server (UPDATE roles SET client_id = > 0, env_id = 0 WHERE origin = "SHARED"), the roles show up on the 2nd server. > > The sync_shared_roles.php scripts are identical. I looked at the the > table schema and noticed no difference. I did see that the origin, > client_id, and env_id fields are keys for secondary indices. The innodb > plugin version is 5.6.22 on the 1st server (which worked) and 5.6.24 on the > 2nd server (which didn't). > > My primary concern is resolved for me, but the sync_shared_roles.php > currently does not do what I expect. I'm unclear as yet what is wrong. > > On Thursday, April 30, 2015 at 1:05:08 PM UTC-4, Matt Shibla wrote: > >> I'm trying to test a chef cookbook we've written to (re)deploy Scalr in >> our environment. After configuring the new server and bringing up the >> Scalr application, I attempted to run the sync_shared_roles.php script to >> sync the shared roles. The script finished and exited with a return code >> of 0 with no other output. After creating accounts and looking at the >> roles manager page, I see no shared roles configured as there are on my >> original Scalr server. I logged into the mysql database and queried the >> roles table. There appear to be shared roles there. >> >> I suspect there's a data error somewhere, but I'm wondering if anyone has >> encountered this problem before, or if anyone has an idea of how to solve >> it other than just comparing every data field in the database across all >> the role-related tables. Any suggestions would be welcome. Thanks. >> >> -matt >> > -- > You received this message because you are subscribed to the Google Groups > "scalr-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to scalr-discuss+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to scalr-discuss+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
