Admin account problem with 1.2.2 upgrade and Postgresql

18 Mar 2004

      Hello,

After almost a year of running OTRS 1.1.2 (before that 1.0.1) successfully
with Postresql 7.2, we decided to upgrade to OTRS 1.2.2. 

Followed the instructions in the UPGRADING file, and all seems to have
proceeded normally with the database upgrade.

Copied over Kernel/Config.pm, Kernel/Config/GenericAgent.pm, as well as
.procmail and .forward files which deliver mail to OTRS.

The problem is that although we are able to login normally with our user
and admin accounts, no ticket, queue, or group information appears.

Logging into the root@localhost admin account shows a blank AgentFrontend
page rather than the AdminSelectBox.

OTRS shows the generic message that a user needs to be created rather than
working with UserID 1, but when attempting to create a user, the system
reports that admin has not permission and that "You have to be in the a
permitted group!". 

The data is definitely still inside Postgresql, as I can see the user (6
users in addition to root@localhost)  information from the 'system_user'
table and the queue information (17 queues) from the 'queue' table.

The only thing that occurs to me is that the permissions on the database
itself might be wrong.  The data is all there, and the update proceeded
normally.  Any ideas on how to get this one fixed ?  

Nothing in the logs shows up that is useful, as I suspect that this might
be all Postgres database table permission related.  Has anyone had a
similar experience that might be able to shed some light ?

-Eddie

Eddie Urenda

Robert Kehl

Wiktor Wodecki

Eddie Urenda

Eddie Urenda

Wiktor Wodecki

Eddie Urenda

tags

participants (3)