
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