Hi again,
I'm seeing the same problem on another server (FC3 instead of FC2). I
used the rpm on both servers to install OTRS. Could it be that OTRS
somehow thinks I'm still running MySQL 3.23.x and therefor does not
communicate correctly with the database or something? I'd really like
some ideas, even if they seem far out. The OTRS cronjobs are still
running and they work, because when I look at the database I see new
tickets being added. I just can't login to the webinterface (so I
can't handle them).
Nils Breunese.
I thought there might be something wrong with my modules, but /opt/
otrs/bin/otrs.checkModules gives me "ok" for every single module.
What can I do to troubleshoot these 'Connection closed by remote
server' errors?
I wrote:
I think it's database related somehow, but I still can't quite put
my finger on it. Connecting with elinks (a text-mode webbrowser)
to OTRS gives me a lot of "Error reading from socket" errors, but
it also gave me this error after trying to log in (I put x's in
for a hexidecimal number):
dbih_getcom handle DBI::db=HASH(0xxxxxxxx) is not a valid DBI
handle at /usr/li
The error appears to be truncated because of the limited console
linewidth. Apparently there is some problem with the database
connection (am I right?).
Maybe I should repeat that I installed MySQL 4.1.15 from the
Atomic Rocket Turtle repository which also installs a mysql-compat
package to trick the Plesk Control Panel into thinking MySQL
3.23.x is still installed. I also added "old-passwords" to /etc/
my.cnf to let MySQL use the old style of passwords (because that's
what Plesk uses). Could it be that OTRS somehow detects the wrong
MySQL version and thus doesn't work? The CheckDB.pl script tells
me the DB is ok...
Is there something I can try to make sure the database connection
is working with OTRS? All other scripts on this server using MySQL
seem to work just fine.
Nils.
I wrote:
Today I upgraded PHP (4.4.1 -> 4.4.2) and MySQL (3.23.x ->
4.1.15) on my Fedora Core 2 server and restart both the MySQL and
Apache webserver. All seems to work (I run several vhosts on this
server) except that OTRS seems to have lost it. When I go to /
otrs/index.pl the login screen appears, but when I login I get
'Connection closed by remote server'. I've looked all over but
have found no error message whatsoever.
/var/log/messages says (I put in x's for private data):
Feb 18 19:14:24 xxxx OTRS-CGI-1[24835]: [Notice]
[Kernel::System::Auth::DB::Auth] User: xxxx authentication ok
(REMOTE_ADDR: xxx.xxx.xxx.xxx).
Also the DB is alright according to OTRS:
# /opt/otrs/bin/CheckDB.pl
It looks Ok!
And restarting the otrs service doesn't help or seem to find any
problems:
# service otrs restart
Shutting down OTRS
Disable /opt/otrs/bin/PostMaster.pl ... done.
Shutting down cronjobs ...
done.
Final shutdown of OTRS.. done
Starting OTRS..
Checking httpd ... done.
Checking MySQL ... done.
Checking database connect... It looks Ok! done.
Enable /opt/otrs/bin/PostMaster.pl ... done.
Checking otrs spool dir... done.
Creating cronjobs (source /opt/otrs/var/cron/*) ...
done.
-->> http://xxx.xxx.xxx/otrs/index.pl <<--
Final start of OTRS.. done
Other Perl-based webscripts (such as Movable Type) are working
correctly. What could be the problem? Where can I look?
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
