Darn - I knew as soon as I sent this I'd find a stupid mistake :-)
I had carelessly commented out the PW filed in Config.pm...
Sorry to bother...
From: Mike Morris <Mike@musicplace.com>
To: otrs@otrs.org
Subject: customer_user "pw" field not being updated
Date: Sun, 10 Oct 2010 16:09:11 -0700
It seems like this should be a FAQ, but I haven't found it anywhere (although lots
of similar stuff, mostly LDAP)... anyway:
I'm using Customer::AuthModule = DB.
I've confirmed that the table name in "Table", the field names in "CustomerKey"
and "CustomerPassword" are all correct (at their defaults).
I'm using PostgreSQL 8.3, btw.
I believe I've confirmed the DSN is correct; it's set to
"dbi:Pg:dbname=otrs;host=localhost;user=otrs;password=[removed];".
I can generate errors on the web front end by intentionally misconfiguring this; I
can also successfully connect with this as my DSN string in a simple Perl script.
I've also tried moving user and password information out of the DSN into their
respective config fields... every combination I can think of. I am fairly confident
that the DSN is not the problem, but not 100%...
Anyway, when using the Customer front end to request a password reset, the
customer_user.pw field is never updated. Email is sent, clicking the link gets me
emailed a new password, but the password is never written to the DB, so of
course I can't log in with it.
[As an aside: I'm having trouble using logs because traffic is making syslog so
full... and I can't change the SysConfig "Logfile" parameter; when I select File and
submit, it refreshes as "SysLog" again...??? ]
Thanks in advance for any advice,
MikeM
Mike Morris
The Music Place
1617 Willowhurst Avenue
San Jose, CA 95125
(408) 445-ARTS (2787)
------------------------------------
Your Free Historical Quote:
"...we shall welcome to a participation
of all our rights and privileges, [anyone]
if by decency and propriety of conduct
they appear to merit the enjoyment."
-- George Washington,
(Address to the Members of the Volunteer
Association of Ireland, 2 December 1783)
------------------------------------