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