This is exactly the scenario here. Except, the old MySQL accounts, I can login with either the MySQL credentials or the LDAP credentials (note the username is the same for both by convention for us). If you want to use MySQL login, did you add that as a secondary path of authentication in your SiteConfig file? I didn't want this option, but seems like when using ExternalAuth, if you wanted to allow local login / MySQL, you have to configure that as well in the config file. I could be wrong.
-----Original Message----- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Yan Seiner Sent: Wednesday, November 09, 2011 9:31 AM To: Thomas Sibley Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] ExternalAuth, local users, and upgrade woes On Wed, November 9, 2011 6:07 am, Thomas Sibley wrote: > On 11/08/2011 07:03 PM, Yan Seiner wrote: >> As near as I can figure, when we merged the two databases the user table >> got smashed together. > > How did you merge the databases? > > There is no existing tool to do a merge properly and doing it manually > is not trivial even with a good understanding of the schema. I think "merge" was not the right thing to say. We migrated the old database to the new database using the instructions in the README. We threw away our 4.0 test database. I think the problem is that we had user XXX in the 3.8 database as a local user and in the 4.0 database user XXX was LDAP external auth. Everything else works fine; just my local mysql users cannot log in and I can create them but not give them passwords. -- Pain is temporary. It may last a minute, or an hour, or a day, or a year, but eventually it will subside and something else will take its place. If I quit, however, it lasts forever. -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011 -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011
