Hi,

 

Just in case someone is interested, I updated my script to upgrade an OTRS 6 patch version.

 

sudo nano /opt/updateotrs6.sh

sudo chmod +x /opt/updateotrs6.sh

sudo ./opt/updateotrs6.sh

 

updateotrs6.sh:

 

sudo systemctl stop crond.service

sudo systemctl stop httpd.service

sudo -u otrs -H sh -c "/opt/otrs/bin/Cron.sh stop"

sudo -u otrs -H sh -c "/opt/otrs/bin/otrs.Daemon.pl stop"

sudo -H sh -c "ls /opt"

sudo -H sh -c "rm /opt/otrsrpm.rpm -f"

sudo -H sh -c "ls /opt"

sudo -H sh -c "curl http://ftp.otrs.org/pub/otrs//RPMS/rhel/7/otrs-6.0.26-01.noarch.rpm -Lo /opt/otrsrpm.rpm"

sudo -H sh -c "ls /opt"

sudo -H sh -c "rpm -Uvh /opt/otrsrpm.rpm"

# sudo -u otrs -H sh -c "/opt/otrs/scripts/DBUpdate-to-6.pl"

sudo -u otrs -H sh -c "/opt/otrs/bin/otrs.Console.pl Admin::Package::UpgradeAll"

sudo systemctl start crond.service

sudo systemctl start httpd.service

sudo -u otrs -H sh -c "/opt/otrs/bin/Cron.sh start"

sudo -u otrs -H sh -c "/opt/otrs/bin/otrs.Daemon.pl start"

 

Regards

 

Rudolf Bargholz

 

Von: Rudolf Bargholz
Gesendet: Freitag, 7. Februar 2020 17:05
An: User questions and discussions about OTRS.
Betreff: [otrs] Resolved: Problem upgrading from OTRS 6.0.25 to 6.0.26

 

Hi Roy,

 

Ok, tried out your advice, re-ran the scripts/DBUpdate-to-6.pl, and it seems to have worked. Thank you. This is however the first time I needed to re-run the scripts/DBUpdate-to-6.pl after updating a patch release. After the patch update I needed to update all of the packages, but now there is no longer an error in the System log, and, more importantly, I am able to log on to OTRS again after updating.

 

Again, thanks to all who were interested and helped.

 

Regards

 

Rudolf Bargholz

 

 

[rb@olts-otrs ~]$ sudo -i

[sudo] password for rb:

[root@olts-otrs ~]# systemctl stop crond.service

[root@olts-otrs ~]# systemctl stop httpd.service

 

[root@olts-otrs ~]#

[root@olts-otrs ~]# su - otrs

[otrs@olts-otrs ~]$ /opt/otrs/bin/Cron.sh stop

done

[otrs@olts-otrs ~]$ /opt/otrs/bin/otrs.Daemon.pl stop

 

Manage the OTRS daemon process.

 

Daemon stopped

[otrs@olts-otrs ~]$ exit

logout

[root@olts-otrs ~]# cd /opt

[root@olts-otrs opt]# ls

containerd  l  -L  L  otrs  otrs.sql  sublime_text  teamviewer  trimbody.sql

[root@olts-otrs opt]# rm *.rpm -f

[root@olts-otrs opt]# ls

containerd  l  -L  L  otrs  otrs.sql  sublime_text  teamviewer  trimbody.sql

[root@olts-otrs opt]# curl http://ftp.otrs.org/pub/otrs//RPMS/rhel/7/otrs-6.0.26-01.noarch.rpm -Lo /opt/otrsrpm.rpm

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current

                                 Dload  Upload   Total   Spent    Left  Speed

100   275  100   275    0     0  11000      0 --:--:-- --:--:-- --:--:-- 11000

100 24.6M  100 24.6M    0     0  38.4M      0 --:--:-- --:--:-- --:--:-- 38.4M

[root@olts-otrs opt]# rpm -Uvh /opt/otrsrpm.rpm

Verifying...                          ################################# [100%]

Preparing...                          ################################# [100%]

Check OTRS user ... otrs exists.

usermod: no changes

usermod: no changes

Updating / installing...

   1:otrs-6.0.26-01                   warning: /opt/otrs/Kernel/Config.pm created as /opt/otrs/Kernel/Config.pm.rpmnew

################################# [ 50%]

 

Next steps:

 

[restart web server]

systemctl restart apache2.service

 

[install the OTRS database]

Make sure your database server is running.

Use a web browser and open this link:

http://olts-otrs/otrs/installer.pl

 

[start OTRS daemon and corresponding watchdog cronjob]

/opt/otrs/bin/otrs.Daemon.pl start

/opt/otrs/bin/Cron.sh start

 

((enjoy))

Your OTRS Team

 

Cleaning up / removing...

   2:otrs-6.0.25-01                   ################################# [100%]

[root@olts-otrs opt]# su - otrs

[otrs@olts-otrs ~]$ cd /opt/otrs/

[otrs@olts-otrs ~]$ scripts/DBUpdate-to-6.pl

 

Migration started ...

 

Checking requirements ...

 

    Requirement check for: Check framework version ...

    Requirement check for: Check required Perl version ...

    Requirement check for: Check required database version ...

    Requirement check for: Check database charset ...

    Requirement check for: Check required Perl modules ...

    Requirement check for: Check if database has been backed up ...

 

        Did you backup the database? [Y]es/[N]o: y

 

    Requirement check for: Upgrade database structure ...

    Requirement check for: Migrating time zone configuration ...

    Requirement check for: Update calendar appointment future tasks ...

    Requirement check for: Migrate GenericAgent jobs configuration ...

    Requirement check for: Migrate TicketAppointment rules configuration ...

    Requirement check for: Create entries in new article table ...

    Requirement check for: Migrate ArticleType in ProcessManagement Data ...

    Requirement check for: Migrate ArticleType in PostMaster filters ...

 

Executing tasks ...

 

    Step 1 of 44: Check framework version ...

    Step 2 of 44: Check required Perl version ...

    Step 3 of 44: Check required database version ...

    Step 4 of 44: Check database charset ...

    Step 5 of 44: Check required Perl modules ...

    Step 6 of 44: Check installed CPAN modules for known vulnerabilities ...

    Step 7 of 44: Check if database has been backed up ...

    Step 8 of 44: Upgrade database structure ...

    Step 9 of 44: Migrate configuration ...

    Step 10 of 44: Refresh configuration cache after migration of OTRS 5 settings ...

    Step 11 of 44: Migrating ticket storage configuration ...

    Step 12 of 44: Migrating article search index configuration ...

    Step 13 of 44: Migrating ticket zoom customer information widget configuration ...

    Step 14 of 44: Drop deprecated table gi_object_lock_state ...

    Step 15 of 44: Migrate PossibleNextActions setting ...

    Step 16 of 44: Migrate ZoomExpand setting ...

    Step 17 of 44: Migrating time zone configuration ...

    Step 18 of 44: Migrating modified settings ...

    Step 19 of 44: Create appointment calendar tables ...

    Step 20 of 44: Create ticket number counter tables ...

    Step 21 of 44: Update calendar appointment future tasks ...

    Step 22 of 44: Add basic appointment notification for reminders ...

    Step 23 of 44: Create Form Draft tables ...

    Step 24 of 44: Clean and drop group_user permission_value column ...

    Step 25 of 44: Migrate GenericAgent jobs configuration ...

    Step 26 of 44: Migrate TicketAppointment rules configuration ...

    Step 27 of 44: Migrate Merged Ticket history name values ...

    Step 28 of 44: Migrate ticket statistics ...

    Step 29 of 44: Migrate ticket notifications ...

    Step 30 of 44: Create entries in new article table ...

    Step 31 of 44: Post changes on article related tables ...

    Step 32 of 44: Migrate ArticleType in ProcessManagement Data ...

    Step 33 of 44: Migrate ArticleType in PostMaster filters ...

    Step 34 of 44: Migrate chat articles ...

    Step 35 of 44: Initialize default cron jobs ...

    Step 36 of 44: Migrate web service configuration ...

    Step 37 of 44: Migrate package repository configuration ...

    Step 38 of 44: Migrate ticket search profiles ...

    Step 39 of 44: Uninstall Merged Feature Add-Ons ...

    Step 40 of 44: Clean up the cache ...

    Step 41 of 44: Refresh configuration cache another time ...

    Step 42 of 44: Deploy ACLs ...

    Step 43 of 44: Deploy processes ...

    Step 44 of 44: Check invalid settings ...

 

 

 

Migration completed!

 

[otrs@olts-otrs ~]$ exit

logout

[root@olts-otrs opt]# systemctl start httpd.service

[root@olts-otrs opt]# systemctl start crond.service

[root@olts-otrs opt]# su - otrs

[otrs@olts-otrs ~]$ /opt/otrs/bin/otrs.Daemon.pl start

 

Manage the OTRS daemon process.

 

Daemon started

[otrs@olts-otrs ~]$ /opt/otrs/bin/Cron.sh start

(using /opt/otrs) done

[otrs@olts-otrs ~]$ No indexing needed! Skipping...

Done.

Processing ticket escalation events ...

 

Spawning child process to fetch incoming messages from mail accounts...

 

mail.onlinetravel.ch (POP3)...

Done.

 

No messages available for sending.

Done.

 

[otrs@olts-otrs ~]$

 

 

Von: Roy Kaldung
Gesendet: Freitag, 7. Februar 2020 15:53
An: User questions and discussions about OTRS.
Betreff: Re: [otrs] Problem upgrading from OTRS 6.0.25 to 6.0.26

 

Hi,

> On Feb 7, 2020, at 12:48 PM, Rudolf Bargholz <Bargholz@onlinetravel.ch> wrote:
>
> After installing the patch, I was no longer able to enter my username and password to log into OTRS. No idea why.

Should be related to the updated jQuery version. The directory was renamed from jquery-3.2.1 to jquery-3.4.1.

I’m pretty sure that this is related by not running scripts/DBUpdate-to-6.pl (see manual) because the SysConfig needs to be updated.

Regards,
Roy Kaldung

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs