getting error on otrs/installer.pl

Moderator: crythias

Post Reply
AmitP
Znuny newbie
Posts: 32
Joined: 29 May 2019, 10:01
Znuny Version: otrs6
Real Name: Amit

getting error on otrs/installer.pl

Post by AmitP »

Hi
After database successfully created i clicked next and got following error on page:
I chose postgresql, ubuntu 16.04 otrs6.0.12
--------------------------------------------
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@localhost to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Apache/2.4.18 (Ubuntu) Server at 45.43.30.90 Port 80
-----------------------------------------------------------------------
I checked apache error log and found:

[Thu May 30 00:40:55.153720 2019] [:error] [pid 28248:tid 139879149197056] Wide character in subroutine entry at /opt/otrs/Kernel/System/DB.pm line 470.\

My setup is incomplete please let me know why it happened and how to correct it. I am unable to move to other remain steps.

Please help

Thanks
fcasal
Znuny wizard
Posts: 336
Joined: 21 Apr 2014, 16:14
Znuny Version: 6.0.18

Re: getting error on otrs/installer.pl

Post by fcasal »

It seems you missed some steps, could you replicate here the steps you made?
AmitP
Znuny newbie
Posts: 32
Joined: 29 May 2019, 10:01
Znuny Version: otrs6
Real Name: Amit

Re: getting error on otrs/installer.pl

Post by AmitP »

Hi

I tried earlier howtoforge steps with otrs5. but failed.
than i went for otrs 6.0.18

i followed the steps given in
Installation From Source (Linux, Unix)
shell> tar xzf /tmp/otrs-x.x.x.tar.gz
shell> mv otrs-x.x.x /opt/otrs

root@controller:/opt/otrs# perl /opt/otrs/bin/otrs.CheckModules.pl
o Apache::DBI......................ok (v1.12)
o Apache2::Reload..................ok (v0.13)
o Archive::Tar.....................ok (v2.04)
o Archive::Zip.....................ok (v1.56)
o Crypt::Eksblowfish::Bcrypt.......ok (v0.009)
o Crypt::SSLeay....................ok (v0.73_04)
o Date::Format.....................ok (v2.24)
o DateTime.........................ok (v1.21)
o DBI..............................ok (v1.634)
o DBD::mysql.......................ok (v4.033)
o DBD::ODBC........................Not installed! Use: 'apt-get install -y libdbd-odbc-perl' (optional - Required to connect to a MS-SQL database.)
o DBD::Oracle......................Not installed! (optional - Required to connect to a Oracle database.)
o DBD::Pg..........................ok (v3.5.3)
o Digest::SHA......................ok (v5.95)
o Encode::HanExtra.................ok (v0.23)
o IO::Socket::SSL..................ok (v2.024)
o JSON::XS.........................ok (v3.01)
o List::Util::XS...................ok (v1.41)
o LWP::UserAgent...................ok (v6.26)
o Mail::IMAPClient.................ok (v3.38)
o IO::Socket::SSL................ok (v2.024)
o Authen::SASL...................ok (v2.16)
o Authen::NTLM...................ok (v1.09)
o ModPerl::Util....................ok (v2.000009)
o Net::DNS.........................ok (v0.81)
o Net::LDAP........................ok (v0.65)
o Template.........................ok (v2.24)
o Template::Stash::XS..............ok (undef)
o Text::CSV_XS.....................ok (v1.21)
o Time::HiRes......................ok (v1.9726)
o XML::LibXML......................ok (v2.0123)
o XML::LibXSLT.....................ok (v1.94)
o XML::Parser......................ok (v2.44)
o YAML::XS.........................ok (v0.41)


apt-cache search Digest::MD5

apt-get install libdigest-md5-perl

perl -MCPAN -e shell;
Terminal does not support AddHistory.

cpan shell -- CPAN exploration and modules installation (v2.11)
Enter 'h' for help.

useradd -d /opt/otrs -c 'OTRS user' otrs

usermod -G www-data otrs

shell> perl -cw /opt/otrs/bin/cgi-bin/index.pl
/opt/otrs/bin/cgi-bin/index.pl syntax OK

shell> perl -cw /opt/otrs/bin/cgi-bin/customer.pl
/opt/otrs/bin/cgi-bin/customer.pl syntax OK

shell> perl -cw /opt/otrs/bin/otrs.Console.pl
/opt/otrs/bin/otrs.Console.pl syntax OK

>apt-get install apache2 libapache2-mod-perl2

shell> a2enmod perl
shell> a2enmod version
shell> a2enmod deflate
shell> a2enmod filter
shell> a2enmod headers

>>>>>>>>>>>>>>>>>>>>>>>>>>>.for version iam getting error


shell> bin/otrs.SetPermissions.pl --web-user=otrs


bin/otrs.SetPermissions.pl --web-group=www-data




This is all.....


Thanks
fcasal
Znuny wizard
Posts: 336
Joined: 21 Apr 2014, 16:14
Znuny Version: 6.0.18

Re: getting error on otrs/installer.pl

Post by fcasal »

AmitP
Znuny newbie
Posts: 32
Joined: 29 May 2019, 10:01
Znuny Version: otrs6
Real Name: Amit

Re: getting error on otrs/installer.pl

Post by AmitP »

Hi thanks

But i want to use postgresql.
The links is about Mysql.
can you suggest a link with postggres, i used howtoforge but i wasnt successful.

Thanks
AmitP
Znuny newbie
Posts: 32
Joined: 29 May 2019, 10:01
Znuny Version: otrs6
Real Name: Amit

Re: getting error on otrs/installer.pl

Post by AmitP »

Getting below error for installer.pl on using existing database:


Result of database check
Wrong database collation (character_set_database is utf8mb4, but it needs to be utf8).
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: getting error on otrs/installer.pl

Post by root »

Hi,

Reconfigure the database, your DBA should know how to do it.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
AmitP
Znuny newbie
Posts: 32
Joined: 29 May 2019, 10:01
Znuny Version: otrs6
Real Name: Amit

Re: getting error on otrs/installer.pl

Post by AmitP »

ALTER DATABASE
otrs_db
CHARACTER SET = utf8
COLLATE = utf8_unicode_ci;

did this and it worked.
thanks for help.
kkoperator
Znuny newbie
Posts: 8
Joined: 14 Dec 2021, 14:35
Znuny Version: 6.0.38
Real Name: Hubert Maluczki

Re: getting error on otrs/installer.pl with a2enmod version

Post by kkoperator »

The instructions at https://www.vultr.com/docs/how-to-insta... is great.
Unfortunately I have the same error with a2enmod version.

(debian11 and apache 2.4.54-1)

user@debian11:~$ sudo a2enmod version
ERROR: Module version does not exist!

user@debian11:~$ sudo apache2ctl -M
version_module (static)

user@debian11:~$ sudo ls /etc/apache2/mods-available/
usertrack.load
vhost_alias.load
xml2enc.load

user@debian11:~$ sudo ls /etc/apache2/mods-enabled/
status.conf
status.load
finde . -iname manual.wtf | dir manual.wtf /s
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: getting error on otrs/installer.pl with a2enmod version

Post by root »

kkoperator wrote: 21 Feb 2023, 22:26 The instructions at https://www.vultr.com/docs/how-to-insta... is great.
Unfortunately I have the same error with a2enmod version.

Hi,

These instructions are outdated. I recommend using the manual.
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Post Reply