Dear,
i am facing this exception repeatedly...
Feb 4 23:53:50 CASUN99 OTRS-CGI-10[29075]: [Error][Kernel::System::Auth::LDAP::new][Line:53]: Need AuthModule::LDAP::BaseDN1 in Kernel/Config.pm
Feb 4 23:56:16 CASUN99 OTRS-CGI-10[29433]: [Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '1005f3b95d2d2e56c182409894cc72c01f' is invalid!!!
Feb 4 23:56:37 CASUN99 sshd[29445]: Did not receive identification string from 10.10.9.10
Feb 4 23:57:46 CASUN99 OTRS-CGI-10[29487]: [Notice][Kernel::System::CustomerAuth::DB::Auth] CustomerUser: paycb2 Authentication ok (REMOTE_ADDR: 193.104.115.2).
Feb 4 23:57:46 CASUN99 OTRS-CGI-10[29487]: [Notice][Kernel::System::AuthSession::DB::RemoveSessionID] Removed SessionID 108468764ebfee50342608b119d4d24e28.
Feb 4 23:57:58 CASUN99 OTRS-CGI-10[29496]: [Notice][Kernel::System::Ticket::TicketPermission] Permission denied (UserID: 297 'ro' on TicketID: 256127)!
Feb 5 00:01:02 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::Article::ArticleLastCustomerArticle][Line:1166]: No article found for TicketID 233161!
Feb 5 00:01:02 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketSubjectClean][Line:834]: Need TicketNumber!
Feb 5 00:01:02 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketPermission][Line:3283]: Need TicketID!
Feb 5 00:01:02 CASUN99 last message repeated 3 times
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::Article::ArticleLastCustomerArticle][Line:1166]: No article found for TicketID 233160!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketSubjectClean][Line:834]: Need TicketNumber!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketPermission][Line:3283]: Need TicketID!
Feb 5 00:01:03 CASUN99 last message repeated 3 times
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::Article::ArticleLastCustomerArticle][Line:1166]: No article found for TicketID 157307!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketSubjectClean][Line:834]: Need TicketNumber!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketPermission][Line:3283]: Need TicketID!
Feb 5 00:01:03 CASUN99 last message repeated 3 times
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::Article::ArticleLastCustomerArticle][Line:1166]: No article found for TicketID 75125!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketSubjectClean][Line:834]: Need TicketNumber!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketPermission][Line:3283]: Need TicketID!
Feb 5 00:01:03 CASUN99 last message repeated 3 times
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::User::GetUserData][Line:150]: Need User or UserID!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketFlagGet][Line:7625]: Need TicketID!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::User::GetUserData][Line:150]: Need User or UserID!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketFlagGet][Line:7625]: Need TicketID!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::User::GetUserData][Line:150]: Need User or UserID!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketFlagGet][Line:7625]: Need TicketID!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::User::GetUserData][Line:150]: Need User or UserID!
Feb 5 00:01:03 CASUN99 OTRS-CGI-10[29879]: [Error][Kernel::System::Ticket::TicketFlagGet][Line:7625]: Need TicketID!
We are facing usually OTRS logout on ticket closed most of the time, invalid session...
Please help me in this regard, i am thankful to you...
Permission denied (UserID: 297 'ro' on TicketID
Moderator: crythias
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Permission denied (UserID: 297 'ro' on TicketID
You might also have crashed tables, but ...
Let's assume you have a user that has a login of 297. Yes or no?
If yes, then that user doesn't have ro permissions (at least) for whatever reason for ticketID x
If no, then something is pretending to have a userID of 297 (generic agent, other batch file) ... Considering this doesn't appear to be "on the hour" (or it might be), you may also be having some sort of RPC or soap or other APi interface (this is happening in the middle of the night?) trying to impersonate UserID 297.
Next:
No article found for ticketID x. Again, it appears either:
1) article table corrupt
2) api creating tickets but no articles
GetUserData ... likely related to the first, but hard to tell.
(How to fix?)
Depends what's wrong. You should look at api calls, scheduled or otherwise, to your box, check the ticket table vs article table. Potentially (and this is just an idea, with no warranty or merit) delete the tickets from ticket table where there's no article attached. (Before thinking about that, look at the entry for a title or something.)
Disclaimer: your data is your responsibility. Don't just go deleting data because you heard somebody on the Internet say, "delete this". Make good, multiple, verifiable, recoverable backups of your data. Test things before breaking them. Document your changes, etc.
Let's assume you have a user that has a login of 297. Yes or no?
If yes, then that user doesn't have ro permissions (at least) for whatever reason for ticketID x
If no, then something is pretending to have a userID of 297 (generic agent, other batch file) ... Considering this doesn't appear to be "on the hour" (or it might be), you may also be having some sort of RPC or soap or other APi interface (this is happening in the middle of the night?) trying to impersonate UserID 297.
Next:
No article found for ticketID x. Again, it appears either:
1) article table corrupt
2) api creating tickets but no articles
GetUserData ... likely related to the first, but hard to tell.
(How to fix?)
Depends what's wrong. You should look at api calls, scheduled or otherwise, to your box, check the ticket table vs article table. Potentially (and this is just an idea, with no warranty or merit) delete the tickets from ticket table where there's no article attached. (Before thinking about that, look at the entry for a title or something.)
Disclaimer: your data is your responsibility. Don't just go deleting data because you heard somebody on the Internet say, "delete this". Make good, multiple, verifiable, recoverable backups of your data. Test things before breaking them. Document your changes, etc.
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
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
-
aliumair
- Znuny newbie
- Posts: 5
- Joined: 20 Nov 2012, 09:59
- Znuny Version: 3.0.6
- Real Name: Ali Umair
- Company: i2c inc
Re: Permission denied (UserID: 297 'ro' on TicketID
Thanks for Your response, I identify some tickets which have no articles, instead of deleting them, if i insert data in article and ticket_history against these tickets, can this solve my problem ???