[rt-users] ExternalAuth, local users, and upgrade woes

[Yan Seiner]

On Wed, November 9, 2011 7:34 am, Izz Abdullah wrote:
> 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.\

The local user/LDAP user thing worked fine when we tested 4.0 (built from
scratch).  We could create local users and autocreate LDAP users.

We use the same SiteConfig file for the migrated 3.8->4.0 database, and
the users don't work correctly.

I'm trying to get phpmyadmin working right now so I can look at the tables
and see what's going on.  (Another story; apache is being subborn but
that's not for this list.)

>
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Yan Seiner
> Sent: Wednesday, November 09, 2011 9:31 AM
> To: Thomas Sibley
> Cc: rt-users at 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
>
> !DSPAM:4eba9dac253411804284693!
>
>


-- 
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.