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 _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
