Move application : error when running jobqueue.pl

[Pierre Hernandez]

Hi all,

I try to move existing bugzilla application on a new server. Everything goes well until i try to send emails. i got the following error:

Argument contains empty address at lib/Email/MIME/Encode.pm line 154.
Argument contains empty address at lib/Email/MIME/Encode.pm line 154.
Failed to execute INSERT INTO ts_error
(jobid, funcid, message, error_time)
VALUES (?, ?, ?, ?)
with jobid, funcid, message, error_time: DBD::mysql::st execute failed: Data too long for column 'message' at row 1 at lib/Data/ObjectDriver/Driver/DBI.pm line 418.

What's going wrong ? Do you have an idea?

Here's the setup on new server:

BUGZILLA 4.2.4
Perl v5.28.1
Mysql 5.7.33

Thanks for your help

[Thorsten Schöning]

Guten Tag Pierre Hernandez,
am Donnerstag, 28. Januar 2021 um 11:35 schrieben Sie:

> Argument contains empty address at lib/Email/MIME/Encode.pm line 154.
> Argument contains empty address at lib/Email/MIME/Encode.pm line 154.

You most likely installed required dependencies on your old server
using "install-module.pl", which stores them into the "lib" folder of
Bugzilla. Those dependencies ONLY work for the system in which they
have been installed and can NOT easily be migrated to other systems.
You need to empty that folder and reinstall dependencies.

If I was you, I would ALWAYS prefer the package manager of the
distribution to install dependencies and use "install-module.pl" only
for those which are not available otherwise and which you absolutely
need to use. This would have prevented this kind of problem because
checksetup.pl would have told you about missing dependencies instead
of NOT telling you, while things are simply incompatible on runtime.

> Failed to execute INSERT INTO ts_error
> (jobid, funcid, message, error_time)
> VALUES (?, ?, ?, ?)
> with jobid, funcid, message, error_time: DBD::mysql::st execute
> failed: Data too long for column 'message' at row 1 at
> lib/Data/ObjectDriver/Driver/DBI.pm line 418.

The same like above most likely and your database driver is most
likely simply too old to support your most likely newer MySQL.

Mit freundlichen Grüßen

Thorsten Schöning

--
Thorsten Schöning
AM-SoFT IT-Service - Bitstore Hameln GmbH i.G. ist ein Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK

E-Mail: Thorsten....@AM-SoFT.de
Web: http://www.AM-SoFT.de/

Telefon: 05151- 9468- 0
Telefon: 05151- 9468-55
Fax: 05151- 9468-88
Mobil: 0178-8 9468-04

AM-SoFT IT-Service - Bitstore Hameln GmbH i.G., Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB neu - Geschäftsführer: Janine Galonska


Für Rückfragen stehe ich Ihnen sehr gerne zur Verfügung.

Mit freundlichen Grüßen

Thorsten Schöning


Tel: 05151 9468 0
Fax: 05151 9468 88
Mobil:
Webseite: https://www.am-soft.de

AM-Soft IT-Service - Bitstore Hameln GmbH i.G. ist ein Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK

AM-Soft IT-Service - Bitstore Hameln GmbH i.G.
Brandenburger Str. 7c
31789 Hameln
Tel: 05151 9468 0

Bitstore IT-Consulting GmbH
Zentrale - Berlin Lichtenberg
Frankfurter Allee 285
10317 Berlin
Tel: 030 453 087 80

CBS IT-Service - Bitstore Kaulsdorf UG
Tel: 030 453 087 880 1

Büro Dallgow-Döberitz
Tel: 03322 507 020

Büro Kloster Lehnin
Tel: 033207 566 530

PCE IT-Service - Bitstore Darmstadt UG
Darmstadt
Tel: 06151 392 973 0

Büro Neuruppin
Tel: 033932 606 090

ACI EDV Systemhaus Dresden GmbH
Dresden
Tel: 0351 254 410

Das Systemhaus - Bitstore Magdeburg GmbH
Magdeburg
Tel: 0391 636 651 0

Allerdata.IT - Bitstore Wittenberg GmbH
Wittenberg
Tel: 03491 876 735 7

Büro Liebenwalde
Tel: 033054 810 00

HSA - das Büro - Bitstore Altenburg UG
Altenburg
Tel: 0344 784 390 97

Bitstore IT – Consulting GmbH
NL Piesteritz
Piesteritz
Tel: 03491 644 868 6

Solltec IT-Services - Bitstore Braunschweig UG
Braunschweig
Tel: 0531 206 068 0

MF Computer Service - Bitstore Gütersloh GmbH
Gütersloh
Tel: 05245 920 809 3

Firmensitz: MF Computer Service - Bitstore Gütersloh GmbH, Gildestraße 25, 33442 Herzebrock-Clarholz
Geschäftsführer Janine Galonska

[Pierre Hernandez]

Guten Tag Thorsten,

thanks for your feedback.

In your opinion, can i upgrade MySQL Driver or do you think i've to downgrade mysql ( i'm actually in version 5.7 and my old server was on 5.1 ) ?

I applied your solution ( remove lib/ folder content and run ./install-modules.pl --all but issue still there )

Danke :)

[Thorsten Schöning]

Guten Tag Pierre Hernandez,
am Donnerstag, 28. Januar 2021 um 23:31 schrieben Sie:

> Hi Thorsten,

Please ALWAYS write to the list, I will ignore private mails like
these next time.

> Private Emails Do Not Help Others

https://www.bugzilla.org/support/

> I finally downgrade mysql to version 5.1.73. I follow your recommendation
> and use only install-module.pl in order to complete the installation.

I didn't recommend ANY of these, but the exact opposite to NOT use
install-module.pl unless absolutely necessary.

> job failed: There was an error sending mail from '@myserver.coml' to '':

There seem to be two problems here: Your local mail setup is
incompatible with Bugzilla and doesn't properly provide a sender. In
most cases this can easily be fixed by changing "mailfrom" in the
admin-UI of Bugzilla.

https://bugzilla.readthedocs.io/en/5.0/administering/parameters.html#email

The second problem seems to be a missing recipient, which might be
because you are still using install-module.pl instead of your package
manager and the former puts Perl-libs in place incompatible with your
system wide libs. Those things are exactly why install-module.pl
should NOT be used unless absolutely necessary, even if the Bugzilla
docs don't make that as clear as I do.