Can't create new user in RT3.2.2

hi,
i’m using RT3.2.2 with oracle 9 as the database. i
have a problem with creating new account in RT. i
used root as the login and under the configuration
link on the left side, i select ‘Users’ → ‘New user’.
i proceed to enter the new account information. i
also checked ‘let this user access RT’ and ‘let this
use be granted rights’. when i click submit i get the
following error: ‘User could not be created: Could not
create user’. i also sees the following error in the
log…
[Tue Jan 4 19:33:26 2005] [error]: Could not create a
new user -
(/ora2/ORACLE/RT3/lib/RT/User_Overlay.pm:260)

does anyone have any ideas on what the problem might
be? thanks
jim

Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

At Tuesday 1/4/2005 02:36 PM, James Lee wrote:

hi,
i’m using RT3.2.2 with oracle 9 as the database. i
have a problem with creating new account in RT. i
used root as the login and under the configuration
link on the left side, i select ‘Users’ → ‘New user’.
i proceed to enter the new account information. i
also checked ‘let this user access RT’ and ‘let this
use be granted rights’. when i click submit i get the
following error: ‘User could not be created: Could not
create user’. i also sees the following error in the
log…
[Tue Jan 4 19:33:26 2005] [error]: Could not create a
new user -
(/ora2/ORACLE/RT3/lib/RT/User_Overlay.pm:260)

Do you see ORA-12704 in the RT log? And are you using DBD::Oracle 1.16? If
so, you may have hit a known problem that I don’t think has been solved
yet. A workaround seems to be to go back to DBD::Oracle 1.15.

Steve

I’d like to generate some metrics from RT to
see how various queues are doing. This
might be things like

  • per-user breakdown of tickets answered
  • per-queue % of tickets closed same day

and other things you’d look at to get a
general day by day health of a support
organization.

Does anyone have any suggestions of
tools that do this already, or a place to
start?

thanks

Ed

Edward Vielmetti
edward.vielmetti@gmail.com

that did the trick. i replaced DBD::Oracle 1.16 with
DBD::Oracle 1.15 and i can create new users now.
thanks a lot for your help.
jim— Stephen Turner sturner@MIT.EDU wrote:

Do you see ORA-12704 in the RT log? And are you
using DBD::Oracle 1.16? If
so, you may have hit a known problem that I don’t
think has been solved
yet. A workaround seems to be to go back to
DBD::Oracle 1.15.

Steve

Do you Yahoo!?
The all-new My Yahoo! - Get yours free!

that did the trick. i replaced DBD::Oracle 1.16 with
DBD::Oracle 1.15 and i can create new users now.
thanks a lot for your help.
jim

I’ve gotten a testcase of the 1.16 bug down to the creation of a single
attachment, but not much further than that. I needed to buy new hardware
to run oracle, which is part of what’s cause the slow progress. But
we’re getting ever closer.

-j

From: Jesse Vincent jesse@bestpractical.com
Subject: Re: [rt-users] can’t create new user in RT3.2.2
To: James Lee jlee110@yahoo.com
Cc: Stephen Turner sturner@MIT.EDU, rt-users@lists.bestpractical.com

that did the trick. i replaced DBD::Oracle 1.16 with
DBD::Oracle 1.15 and i can create new users now.
thanks a lot for your help.
jim

I’ve gotten a testcase of the 1.16 bug down to the creation of a single
attachment, but not much further than that. I needed to buy new hardware
to run oracle, which is part of what’s cause the slow progress. But
we’re getting ever closer.
Can I be of use?
We are a software development company using Oracle exclusively and have
quite a few instances of Oracle running of which atleast one can be used
to test (92i). Further I have a separate apache/perl/rt test tree which
I can use.

Joop

Joop van de Wege JoopvandeWege@mococo.nl