Upgrade feedback - 1.1.x -> 1.3.2

Howdy, Yesterday I upgraded my OTRS install from 1.1.x (maybe 1.1.3?) to 1.3.2. The upgrade was mostly smooth, but I thought I'd give some feedback on things I had to tweak. I followed the suggestion of upgrading the DB (PostgreSQL) to the 1.2 schema first, then to the 1.3 schema. This worked OK, the only thing that was missing was that in the group_user table nobody had permission_key or permission_value settings. So I could login fine, but couldn't do anything - not even see my queues - even as the admin user! Eventually I found the problem and scanned through the initial SQL load data for 1.3 to see what was supposed to be there and did some UPDATEs. That's all fine now. Second, I notice that the Kernel/Config.pm line for PostgreSQL still hasn't been updated to be compatible with non-localhost DB servers, so I had to merge in that change from my older version as well. # (The database DSN for PostgrSQL ==> more: "man DBD::Pg") -# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; + $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};"; That's all I had to do, everything is working great now - thanks for all the work on the new version! Bryan

Hi Bryan, Bryan Fullerton wrote:
[...] Second, I notice that the Kernel/Config.pm line for PostgreSQL still hasn't been updated to be compatible with non-localhost DB servers, so I had to merge in that change from my older version as well.
# (The database DSN for PostgrSQL ==> more: "man DBD::Pg") -# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; + $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};";
Thanks! I changed it now to: # if you want to use a local socket connection # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; # if you want to use a tcpip connection # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};"; So you have the choice! :-)
That's all I had to do, everything is working great now - thanks for all the work on the new version!
Thanks for feedback! :)
Bryan
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
participants (2)
-
Bryan Fullerton
-
Martin Edenhofer