Creating alert causes error

[GoogleCodeExporter]

Creating alert causes error

[GoogleCodeExporter]

Yep, my bad--working on a fix for this right now.  In the mean-time, you can 
use "Schedule Query" instead and choose the connector "Send to email."  I will 
have a fix posted by the end of the day.

Original comment by [email protected] on 23 Feb 2012 at 5:39

• Added labels: Priority-High
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Ok, just put this commit in to fix this.  The menu is now streamlined to 
provide alert and schedule in the same dialog and defaults to alerting.

Original comment by [email protected] on 23 Feb 2012 at 6:56

• Changed state: Fixed
• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

OK, I fill check  it out.

Original comment by [email protected] on 23 Feb 2012 at 7:14

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

One thing here.  I just tried update_from_svn.sh and got a message that it is 
now deprecated and to use install.sh node update.  That is fine but I am 
running into the same issue as using the update_from_svn.sh script, which is 
that elsa.conf is overwritten and since I am using a custom port for syslogs 
being forwarded, it means I have to remember to udpate this file every time I 
update.

Can this be changed somehow to make note of changes and alert the user or to 
protect the file or to show a diff and allow for interactive update?

Original comment by [email protected] on 23 Feb 2012 at 7:20

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

That's a good suggestion.  Can you quick issue a feature-request bug for that?  
In the meantime, can you confirm that your alert issue is fixed?

Original comment by [email protected] on 23 Feb 2012 at 8:15

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

It is not.  I still get the same error now when I try to schedule and alert.

Invalid args, missing arg: connector

Original comment by [email protected] on 23 Feb 2012 at 9:44

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

You ran install.sh web update?  If you're running the latest code, its' not 
possible to get that error message, so either something is cached in your 
browser or the code didn't update.

Original comment by [email protected] on 23 Feb 2012 at 10:42

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Yes, I ran that at the time.
I just ran through the install.sh node update and install.sh web update today 
and tried again to run the alert.  This time I get the following error after I 
choose the frequency and hit OK.

DBD::mysql::st execute failed: Unknown column 'connector' in 'field list' 
QUERY: INSERT INTO query_schedule (uid, query, frequency, start, end, 
connector, params, last_alert, alert_threshold) VALUES (?, (SELECT query FROM 
query_log WHERE qid=?), ?, ?, ?, ?, ?, "1970-01-01 00:00:00", ?) at 
/usr/local/elsa/web/lib/API.pm line 210 API::_dbh_error_handler('DBD::mysql::st 
execute failed: Unknown column \'connector\' i...', 
'DBI::st=HASH(0x2b0d7a6f0ee0)', 'undef') called at 
/usr/local/elsa/web/lib/API.pm line 1602 
API::schedule_query('API=HASH(0x2b0d78507260)', 'HASH(0x2b0d78174e90)') called 
at /usr/local/elsa/web/lib/Web/Query.pm line 30 eval {...} called at 
/usr/local/elsa/web/lib/Web/Query.pm line 28 
Web::Query::call('Web::Query=HASH(0x2b0d7a613b10)', 'HASH(0x2b0d78405900)') 
called at /usr/lib/perl5/site_perl/5.8.8/Plack/Component.pm line 39 
Plack::Component::__ANON__('HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/App/URLMap.pm line 71 
Plack::App::URLMap::call('Plack::App::URLMap=HASH(0x2b0d7a5bfba0)', 
'HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Component.pm line 39 
Plack::Component::__ANON__('HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Middleware/Session.pm line 52 
Plack::Middleware::Session::call('Plack::Middleware::Session=HASH(0x2b0d7a614550
)', 'HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Component.pm line 39 
Plack::Component::__ANON__('HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Middleware/CrossOrigin.pm line 115 
Plack::Middleware::CrossOrigin::call('Plack::Middleware::CrossOrigin=HASH(0x2b0d
7a65a810)', 'HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Component.pm line 39 
Plack::Component::__ANON__('HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Middleware/Static.pm line 18 
Plack::Middleware::Static::call('Plack::Middleware::Static=HASH(0x2b0d7a65aa80)'
, 'HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Component.pm line 39 
Plack::Component::__ANON__('HASH(0x2b0d78405900)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Handler/Apache2.pm line 66 
Plack::Handler::Apache2::call_app('Plack::Handler::Apache2', 
'Apache2::RequestRec=SCALAR(0x2b0d70ac01f0)', 'CODE(0x2b0d7a65aa60)') called at 
/usr/lib/perl5/site_perl/5.8.8/Plack/Handler/Apache2.pm line 91 
Plack::Handler::Apache2::handler('Apache2::RequestRec=SCALAR(0x2b0d70ac01f0)') 
called at -e line 0 eval {...} called at -e line 0 

Original comment by [email protected] on 14 Mar 2012 at 8:30

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Looks like the schema updates didn't work in the install.sh web update command. 
Try manually doing the following queries in elsa_web:

ALTER TABLE query_schedule DROP COLUMN action_params
ALTER TABLE query_schedule DROP FOREIGN KEY `query_schedule_ibfk_2`
ALTER TABLE query_schedule DROP COLUMN action_id
ALTER TABLE query_schedule ADD COLUMN connector VARCHAR(255)
ALTER TABLE query_schedule ADD COLUMN params VARCHAR(8000)

Original comment by [email protected] on 14 Mar 2012 at 8:42

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Well, looks like a bit bigger issue than the schema update.  I am missing the 
query_schedule table entirely.  I going to check the elsa directories for the 
mysql schema and see if it is in there.  If so, I will create the table.  I 
will let you know the outcome.

Original comment by [email protected] on 14 Mar 2012 at 9:52

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Nevermind.  The tables were there.  I was looking in syslog rather than 
elsa_web.  I have applied the schema updates and will see if the query now 
works.

Original comment by [email protected] on 14 Mar 2012 at 10:01

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Ok, now I can schedule an alert and can see the scheduled queries.  Good 
progress so far.

Thanks.

Original comment by [email protected] on 14 Mar 2012 at 10:02

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

OK, the next issue has come up.  I can see the schedule tasks but action is set 
to "undefined".  I try to set it to Email and I get a pop-up error saying 
"Invalid arg: action".  The same pop for Create Ticket and Save.

Original comment by [email protected] on 14 Mar 2012 at 10:11

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

The actions table is empty.

Original comment by [email protected] on 14 Mar 2012 at 10:21

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Ok, that means that for whatever reason, the install.sh web update didn't work 
because the code you are running is old.  Can you run again and check for any 
problems?

Original comment by [email protected] on 15 Mar 2012 at 2:32

• Added labels: ****
• Removed labels: ****