Ansicht von 4 Antwort-Themen
  • Autor
    Beiträge
    • #9625
      arbitrarystring
      Teilnehmer

      I have installed OTOBO using MySQL, and I am trying to migrate from OTRS 6, which is installed using Postgresql. I have followed all of the migration instructions. When I get to the point of checking the database, the migration program complains of network issues. There are no network issues that I am aware of. Postgresql is communicating on port 5432 normally. This is preventing me from continuing the migration process. What do I do?

    • #9757
      Stefan Rother
      Verwalter

      Dear Arbit,

      The migration itself should actually be quite simple, but there are various pitfalls in the environment and configuration.

      Did you do the migration as described in the documentation https://doc.otobo.org/manual/installation/stable/en/content/migration-from-otrs-6.html?

      If so, can you please post more information about your setup, procedures and log messages?

      In the next step we can then take a closer look at the problems.

      I wish you a nice day,

      Stefan

      Team OTOBO

      • Diese Antwort wurde geändert vor 5 Monaten, 1 Woche von Stefan Rother.
      • #9920
        arbitrarystring
        Teilnehmer

        I made a mistake, and did not install the postgresql perl module. Once the perl module was installed migration is proceeding, if slowly. Thank you for your reply.

    • #9891
      bes
      Teilnehmer

      Hello Arbitrary String,

      I have seen the same effect when I developed and tested the migration routines. However I still don’t understand why usually a more or less helpful message is shown, but sometimes this message pops up. I defenitly has nothing to do with networking, it’s more about JavaScript being confused about the current state. When it happens you can do two things. First check the Apache error log. This log should indicate what the problem was. Secondly you can restart the migration by requesting ‚migration.pl‘ again.

      There are two common problems that can occur. First access to PostgreSQL can be denied from the new server. You can check this by calling something like

      psql -U otrs –host=<postgres_server> otrs

      on the server where Apache is running. Another cause can be that the Perl database driver  DBD::Pg is not installed. You can check this with

      perldoc -l DBD::Pg.

      When testing I found that the diagnostics of the database check should be improved. I have added this to the upcoming release OTOBO 10.0.6, see https://github.com/RotherOSS/otobo/issues/627 .

      If this problem still occurs, could you send me the relevant excerpt from the Apache logfile ?

      Best regards,

      Bernhard

      • #9921
        arbitrarystring
        Teilnehmer

        I did not have the postgresql perl module installed! The system did not make any attempt to tell me that however, just the generic „network issues“ message.

    • #9922
      Sven Oesterling
      Verwalter

      That’s the case, if an ajax request of the client browser does not receive an answer from the server (in this case, because the server ran into an error, and not because of network loss). One could try to catch errors like this, and send more meaningful error messages. On the other hand, in this case the user has to be working on the server anyways, so there is always the possibility to just consult the log files… (One has to know, though…)

    • #10010
      bes
      Teilnehmer

      @arbitrarystring, I have added a check whether the required DBD::* module has been installed. See https://github.com/RotherOSS/otobo/issues/630. This feature will be available in the upcoming release of OTOBO 10.0.7,

Ansicht von 4 Antwort-Themen
  • Du musst angemeldet sein, um auf dieses Thema antworten zu können.