Morning/Afternoon,
I had a few issue with crashed tables last week and haven't been able to
resolve these.
Since last week I have repaired all associated database tables (ALL tables),
with "mysql repair table ..."
and via myisamchk. Either repair function returns an all clean yet the
GenericAgent.pl is still not able to
select from any of the Pre-Composed Answers. It simply halts and doesn't return
anything.
Yet manual queries return the information out of the database just fine. See
below.
By manual queries I mean the select statements which are being issued through
otrs to the db,
what isn't happening is for the information selected out of the db to be passed
back to the app.
######################################
>From [EMAIL PROTECTED] Thu Mar 09 16:11:22 2006
Envelope-to: [EMAIL PROTECTED]
Delivery-date: Thu, 09 Mar 2006 16:11:22 +1100
From: [EMAIL PROTECTED] (Cron Daemon)
To: [EMAIL PROTECTED]
Subject: Cron <[EMAIL PROTECTED]> test -x $HOME/bin/GenericAgent.pl &&
$HOME/bin/GenericAgent.pl -c db >> /dev/null
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/opt/otrs/>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=otrs>
Date: Thu, 09 Mar 2006 16:10:42 +1100
DBD::mysql::st execute failed: Can't open file: 'generic_agent_jobs.MYI'.
(errno: 145) at /opt/otrs/Kernel/System/DB.pm line 440, <PRODUCT> line 4.
ERROR: OTRS-GenericAgent-10 Perl: 5.8.4 OS: linux Time: Thu Mar 9 16:10:02 2006
Message: Can't open file: 'generic_agent_jobs.MYI'. (errno: 145), SQL: 'SELECT
job_name FROM generic_agent_jobs'
Traceback (6938):
Module: Kernel::System::GenericAgent::JobList (v1.11 ) Line: 638
Module: /opt/otrs//bin/GenericAgent.pl (v1.36) Line: 131
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
/opt/otrs/Kernel/System/DB.pm line 477, <PRODUCT> line 4.
######################################
Mysql Log when selecting a pre composed answer:
33009 Query SELECT salutation, first_name, last_name, login, pw,
email, customer_id, comments, valid_id, login FROM customer_user WHERE login
= '[EMAIL PROTECTED] <mailto:'[EMAIL PROTECTED]> '
33009 Query SELECT sa.value0, sa.value1 FROM system_address sa, queue sq
WHERE sq.id = 5 and sa.id = sq.system_address_id
33009 Query SELECT text FROM standard_response WHERE id = 16
33009 Query SELECT text FROM salutation sa, queue sq WHERE sq.id = 5
and sq.salutation_id = sa.id
33009 Query SELECT text FROM signature si, queue sq WHERE sq.id = 5
and sq.signature_id = si.id
33009 Query SELECT login , salutation, first_name, last_name FROM
customer_user WHERE login = '[EMAIL PROTECTED]' LIMIT 1
######################################
Manual queries return:
mysql> SELECT salutation, first_name, last_name, login, pw, email,
customer_id, comments, valid_id, login FROM customer_user WHERE login = '
<mailto:'[EMAIL PROTECTED]> [EMAIL PROTECTED]';
Empty set (0.00 sec)
mysql> SELECT sa.value0, sa.value1 FROM system_address sa, queue sq WHERE
sq.id = 5 and sa.id = sq.system_address_id;
+------------------------+--------------------+
| value0 | value1 |
+------------------------+--------------------+
| [EMAIL PROTECTED] | BigPond Postmaster |
+------------------------+--------------------+
1 row in set (0.00 sec)
mysql> SELECT text FROM standard_response WHERE id = 16
-> ;
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| text |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Thank you for your email.
The error was caused by BigPond's mail server being blacklisted as a result of
a spammer on the BigPond network. We have terminated the services of the
spammer and requested a de-listing of our mail server which should be effective
within the next 48 hours. Plesae re-send your message.
|+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT text FROM salutation sa, queue sq WHERE sq.id = 5 and
sq.salutation_id = sa.id;
+--------------------------------------+
| text |
+--------------------------------------+
| Dear <OTRS_CUSTOMER_REALNAME>,
|
+--------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT text FROM signature si, queue sq WHERE sq.id = 5 and
sq.signature_id = si.id;
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| text
|
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Sincerely,
Bigpond Postmaster
BigPond Broadband & Dial-up Internet Access
[faq] http://www.bigpond.com/help/faqs/
[email faq] http://www.bigpond.com/help/email/
[security] http://www.bigpond.com/help/security/
|
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT login , salutation, first_name, last_name FROM customer_user
WHERE login = '[EMAIL PROTECTED]' LIMIT 1;
Empty set (0.00 sec)
Any ideas anyone? ;)
Rgs,
Daniel Buchner
BigPond Operations
Desk: +61 2 8255 0618
Mobile:+61 428 225 476
Email: [EMAIL PROTECTED]
The information transmitted in this document is intended only for the person or
entity to whom it is addressed. It may contain confidential or privileged
material. Any review, retransmission, dissemination or other use or taking of
any action in reliance upon this information by persons or entities other than
the intended recipient is prohibited. If you received this in error, please
contact the sender and delete all copies of the material.
_______________________________________________
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/
