I have a fresh, text-only installation of openSuSe 13.1 (physical server, old Samsung netbook), and I'm trying to get OTRS up and running. I've installed OTRS using the below commands. I don't think they're all necessary, but someone in the OtterHub forums had a successful installation with the software versions I'm targeting using this sequence, so I was trying to piggyback on that success.
zypper in otrs-3.3.4-01.noarch.rpm gcc make mysql-community-server perl-Crypt-SSLeay perl-JSON-XS perl-YAML-LibYAML zypper in perl-Text-CSV_XS perl-PDF-API2 perl-GDGraph perl-Encode-HanExtra postfix perl-DBD-mysql cd ~otrs && bin/otrs.SetPermissions.pl --otrs-user=otrs --web-user=wwwrun --otrs-group=www --web-group=www /opt/otrs rcmysql start systemctl start apache2.service mysqladmin --user=root password password
All of that works fine. I'm able to get to the OTRS web installer, but that's where I get hung up. I get to the part of the web installer that creates the database, and it times out. The script successfully creates the database and updates
Config.pm with the new password. I can't tell from
installer.pl what it tries to do next.
Here's the error from
[Tue Jan 28 20:53:23.136306 2014] [cgi:warn] [pid 6856] [client 192.168.1.10:52732] AH01220: Timeout waiting for output from CGI script /opt/otrs/bin/cgi-bin/installer.pl, referer: http://svr-clptest/otrs/installer.pl [Tue Jan 28 20:53:23.136470 2014] [cgi:error] [pid 6856] [client 192.168.1.10:52732] Script timed out before returning headers: installer.pl, referer: http://svr-clptest/otrs/installer.pl
The browser displays the following:
The gateway did not receive a timely response from the upstream server or application.
This is on a local network at home. I'm accessing the Linux server using PuTTY from a Windows 8 machine. I'm using a wireless connection from the Windows 8 machine, but the server has a hard line connection to the router, if that makes any difference. I don't have any trouble executing anything from PuTTY or accessing the index page through the browser (Firefox 26). I've tried connecting from a computer on my network, and one off of my network. In both cases, I'm able to get to my domain and the web installer. But I can't make a PuTTY connection to the server from outside my network.
I've spent a couple of hours researching the error, and I can't figure out what the next step should be.
Right now, a text-only version of openSUSE and OTRS are the only things running on the machine. I haven't done anything else with it. I'm open to starting the installation from scratch again--OS and all. I'm thinking that the timeout error has something to do with my firewall settings, but I'm not a network guy. Really have no idea how to diagnose this.
I tried reinstalling everything fresh tonight, but then added KDE so I could walk through the web installer on the host. I get exactly the same errors. It's not a problem between server and client. Something's wrong with OTRS... Or maybe with apache?
I may have found a catch-22 here. Following crythias' instructions (post here: http://forums.otterhub.org/viewtopic.php?f=63&t=23757), I noticed that the OTRS service wouldn't start. The error indicated that otrs couldn't connect to the database. Of course it can't, because the OTRS database hasn't been created yet. So the error also suggests using the web installer to set up the database.
I run the web installer, get the same error in the same place. But now that the database is created, the OTRS service starts. The problem is, now I can't complete the installer because the database already exists. If I try to create a new database, it tells me 'otrs' already exists. If I try to use the existing database, it tells me 'Database already contains data - it should be empty!' If I use an empty database called 'otrs,' my OTRS error log spits out the following:
[Fri Jan 31 20:45:01 2014][Error][Kernel::System::PID::PIDGet] Table 'otrs.process_id' doesn't exist, SQL: ' SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1' [Fri Jan 31 20:45:32 2014][Error][/opt/otrs/bin/otrs.CheckDB.pl] Table 'otrs.valid' doesn't exist, SQL: 'SELECT * FROM valid'
If I start the service, then delete the database, the service immediately spits out an error
[Fri Jan 31 21:05:38 2014][Error][Kernel::System::PID::PIDGet] Table 'otrs.process_id' doesn't exist, SQL: ' SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1' [Fri Jan 31 21:05:38 2014][Error][Kernel::System::DB::new] Unknown database 'otrs'
If the OTRS service is supposed to be started before I run the web installer, but the service won't start until the database is created, I think I'm stuck.