What does message mean in my log ?

Moderator: crythias

Post Reply
ponomy
Znuny newbie
Posts: 21
Joined: 03 Feb 2011, 06:09
Znuny Version: 2.0

What does message mean in my log ?

Post by ponomy »

Hi community,

I found the log that indicate OTRS installation incompletely. The log message is below.

"
[Sat Mar 12 18:58:37 2011][Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '10019745232e20fb276d07847a16a239d3' is invalid!!!
[Sat Mar 12 18:58:44 2011][Notice][Kernel::System::Auth::DB::Auth] User: root@localhost authentication ok (REMOTE_ADDR: 10.0.10.134).
[Sat Mar 12 18:59:00 2011][Error][Kernel::System::WebUserAgent::Request][135] Can't get file from http://otrs.org/product.xml?Product=OTRS-3.0.5: 500 Can't connect to otrs.org:80 (connect: timeout)[Sat Mar 12 18:59:36 2011][Error][Kernel::System::WebUserAgent::Request][135] Can't get file from http://ftp.otrs.org/pub/otrs/misc/packa ... sitory.xml: 500 Can't connect to ftp.otrs.org:80 (connect: timeout)
[Sat Mar 12 18:59:52 2011][Error][Kernel::System::WebUserAgent::Request][135] Can't get file from http://otrs.org/repository.xml: 500 Can't connect to otrs.org:80 (connect: timeout)
[Sat Mar 12 19:00:19 2011][Notice][Kernel::System::Package::RepositoryGet] No such package GeneralCatalog-2.1.96!
[Sat Mar 12 19:00:23 2011][Error][Kernel::System::Package::_Database][1817] CREATE command denied to user 'otrsusr'@'10.2.17.45' for table 'general_catalog', SQL: 'CREATE TABLE general_catalog ( id INTEGER NOT NULL AUTO_INCREMENT,
general_catalog_class VARCHAR (100) NOT NULL,
name VARCHAR (100) NOT NULL,
valid_id SMALLINT NOT NULL,
comments VARCHAR (200) NULL,
create_time DATETIME NOT NULL,
create_by INTEGER NOT NULL,
change_time DATETIME NOT NULL,
change_by INTEGER NOT NULL,
PRIMARY KEY(id),
UNIQUE INDEX general_catalog_U_395 (general_catalog_class, name)
)'
"

I would like to know what does it mean (Highlight Message ).

Best Regards,

Ponomy

Java Tutorial: https://sites.google.com/site/itsecuritycourse/
IT Security Course: http://sites.google.com/site/csponomy/
เขียนจาวา โจทย์จาวา เขียนโปรแกรมภาษาจาวา IT Security Course
Follow Me: @csponomy
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: What does message mean in my log ?

Post by crythias »

The first stuff says what it means: the server you're running OTRS can't connect to otrs.org. Check firewall/proxy for more information.

The bold CREATE command denied means what it says: otrsusr@... doesn't have create privileges.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Post Reply