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

2011-11-09 Thread Thomas Sibley
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

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

2011-11-09 Thread Yan Seiner
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

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

2011-11-09 Thread Izz Abdullah
-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

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

2011-11-09 Thread Yan Seiner
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

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

2011-11-09 Thread Kevin Falcone
On Wed, Nov 09, 2011 at 09:34:41AM -0600, Izz Abdullah wrote: 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

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

2011-11-09 Thread Yan Seiner
On Wed, November 9, 2011 8:49 am, Kevin Falcone wrote: If you're having trouble managing RT internal users while logged in as an LDAP user, please see Ruslan's response about possible bugs. Try logging in as root and seeing if that helps. Is the bug report public? If so, where? Thanks!

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

2011-11-09 Thread Kevin Falcone
On Wed, Nov 09, 2011 at 09:01:01AM -0800, Yan Seiner wrote: On Wed, November 9, 2011 8:49 am, Kevin Falcone wrote: If you're having trouble managing RT internal users while logged in as an LDAP user, please see Ruslan's response about possible bugs. Try logging in as root and seeing if

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

2011-11-09 Thread Yan Seiner
On Wed, November 9, 2011 9:10 am, Kevin Falcone wrote: On Wed, Nov 09, 2011 at 09:01:01AM -0800, Yan Seiner wrote: On Wed, November 9, 2011 8:49 am, Kevin Falcone wrote: If you're having trouble managing RT internal users while logged in as an LDAP user, please see Ruslan's response about

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

2011-11-09 Thread Izz Abdullah
...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Yan Seiner Sent: Wednesday, November 09, 2011 11:45 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] ExternalAuth, local users, and upgrade woes On Wed, November 9, 2011 9:10 am, Kevin Falcone wrote

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

2011-11-09 Thread Kevin Falcone
On Wed, Nov 09, 2011 at 09:45:20AM -0800, Yan Seiner wrote: On Wed, November 9, 2011 9:10 am, Kevin Falcone wrote: On Wed, Nov 09, 2011 at 09:01:01AM -0800, Yan Seiner wrote: On Wed, November 9, 2011 8:49 am, Kevin Falcone wrote: If you're having trouble managing RT internal users

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

2011-11-09 Thread Yan Seiner
On Wed, November 9, 2011 9:55 am, Kevin Falcone wrote: On Wed, Nov 09, 2011 at 09:45:20AM -0800, Yan Seiner wrote: I've been poking around in the databases... In the virgin RT4 database (the one we created from scratch) the password field is varchar(256). In the converted RT3-RT4 database

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

2011-11-09 Thread Kevin Falcone
On Wed, Nov 09, 2011 at 10:07:16AM -0800, Yan Seiner wrote: On Wed, November 9, 2011 9:55 am, Kevin Falcone wrote: On Wed, Nov 09, 2011 at 09:45:20AM -0800, Yan Seiner wrote: I've been poking around in the databases... In the virgin RT4 database (the one we created from scratch) the

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

2011-11-09 Thread Ruslan Zakirov
On Wed, Nov 9, 2011 at 9:10 PM, Kevin Falcone falc...@bestpractical.com wrote: On Wed, Nov 09, 2011 at 09:01:01AM -0800, Yan Seiner wrote: On Wed, November 9, 2011 8:49 am, Kevin Falcone wrote: If you're having trouble managing RT internal users while logged in as an LDAP user, please see

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

2011-11-09 Thread Yan Seiner
On Wed, November 9, 2011 10:38 am, Kevin Falcone wrote: Look at the output of the command and your database logs. Since your schema isn't upgraded, something failed. You can look through etc/upgrade/relevant-versions/* and see what else should have run. OK, a cursory look says that

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

2011-11-08 Thread Izz Abdullah
I've seen this on our system. When you move the database and are using external authentication, you, at least I am able, to login with either my MySQL credentials, or my LDAP credentials. When modifying / adding users, I have to put in my MySQL password for this to work for local users. I

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

2011-11-08 Thread Yan Seiner
That worked! Interesting Any way to remove the mysql password? On Tue, November 8, 2011 7:31 am, Izz Abdullah wrote: I've seen this on our system. When you move the database and are using external authentication, you, at least I am able, to login with either my MySQL credentials, or my

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

2011-11-08 Thread Izz Abdullah
- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Yan Seiner Sent: Tuesday, November 08, 2011 9:49 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] ExternalAuth, local users, and upgrade woes That worked! Interesting

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

2011-11-08 Thread Ruslan Zakirov
Sent: Tuesday, November 08, 2011 9:49 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] ExternalAuth, local users, and upgrade woes That worked! Interesting Any way to remove the mysql password? On Tue, November 8, 2011 7:31 am, Izz Abdullah wrote: I've seen this on our

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

2011-11-08 Thread Izz Abdullah
with a blank password does NOT work). From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Tuesday, November 08, 2011 1:08 PM To: Izz Abdullah Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] ExternalAuth, local users, and upgrade woes Direct

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

2011-11-08 Thread Thomas Sibley
On 11/08/2011 02:11 PM, Izz Abdullah wrote: But yeah, setting the password = ‘’ actually forces the external authentication (trying to login with a blank password does NOT work). I believe properly the password column should be '*NO-PASSWORD*' not the empty string. Thomas RT Training

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

2011-11-08 Thread Izz Abdullah
] On Behalf Of Thomas Sibley Sent: Tuesday, November 08, 2011 1:17 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] ExternalAuth, local users, and upgrade woes On 11/08/2011 02:11 PM, Izz Abdullah wrote: But yeah, setting the password = ‘’ actually forces the external authentication

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

2011-11-08 Thread Ruslan Zakirov
On Tue, Nov 8, 2011 at 11:17 PM, Thomas Sibley t...@bestpractical.com wrote: On 11/08/2011 02:11 PM, Izz Abdullah wrote: But yeah, setting the password = ‘’ actually forces the external authentication (trying to login with a blank password does NOT work). I believe properly the password

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

2011-11-08 Thread Yan Seiner
On Tue, November 8, 2011 12:41 pm, Ruslan Zakirov wrote: On Tue, Nov 8, 2011 at 11:17 PM, Thomas Sibley t...@bestpractical.com wrote: On 11/08/2011 02:11 PM, Izz Abdullah wrote: But yeah, setting the password = ‘’ actually forces the external authentication (trying to login with a blank