On Thursday 18 March 2004 15:16, Wiktor Wodecki wrote:

...

...

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 ?

Are you really sure you're working on your PostGreSQL? Is there potentially another MySql installed, now having overtaken the installation someho? I could think of a faulty /etc/sysconfig/otrs pointing towards a MySql now.

this looks suspicious close to my problem. see bug no. 366

ok, I found the problem on this one. There are two problems with the dbupdate scripts (I'm looking at the postgresql one, but I assume similar problems are on the mysql side). Have a look at http://bugs.otrs.org/show_bug.cgi?id=366 for the exact problem and a solution. However you have to set the admin right as in http://bugs.otrs.org/show_bug.cgi?id=331 and then manually readd all user-group relations via the admin frontend. Since our setup grew quite large until now I'm thinking about getting in pl/pgsql language to create a stored procedure which could be used to update the db. This wouldn't work on mysql however (which doesn't know stored procedures). Maybe one of the OTRS developers might give me a helping hand with that ;-) -- Regards, Wiktor Wodecki net mobile AG - 40470 Duesseldorf - Germany 923B DCF8 070C 9FDD 5E05 9AE3 E923 5A35 182C 9783