Hello,
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/
