Getting some issues while integrating scalr with Service now

[Shashi Bhushan]

Hi , 

I am currently working on scalr (open source) to create a demo for some usecases to our customers, and for that I need to integrate our service now portal with Scalr. 

I followed this tutorial :  https://scalr-wiki.atlassian.net/wiki/display/docs/Send+Scalr+events+to+ServiceNow+using+Lambda 

but whenever I am testing it to save events into service now tables its showing failed error. 

I have tested my lambda function and API Gateway in AWS , and when I Assign payload manually its getting saved in Service now , but from scalr its getting failed. 

Then I tried the same process with the hosted scalr account with same lambda function and same API gateway just by creating a new endpoint , And this time it was completed successfully and saved into the table I created in Service now. 

If anybody else had same issue kindly help. 

Thankyou 

Shashi Bhushan 

[Marc O'Brien]

Hi Shashi,

Can you please provide details on the failure you are experiencing?  Error logs or messages from the UI may be helpful. 

Many thanks,
Wm. Marc O'Brien
Scalr Technical Support

[Shashi Bhushan]

Hi Marc, 

The issue is with the webhooks I am using with my opensource version of scalr , same webhook is working with the hosted version. 

This is the error log I am getting while firing an event to get stored in service now . 

[31/Jan/2017 09:36:01][       dbqueue_event][ 30108]      ERROR Unable to process webhook: 2F65AE0FB32B429B87952079F03107B8, reason: <type 'exceptions.TypeError'> __init__() got an unexpected keyword argument 'server_hostname'

Thankyou,

Shashi Bhushan  

[Marc O'Brien]

Hi Shashi,

It looks like this is related to a bug that was resolved in Scalr 6.0.1.  This explains why we see the issue with Open Source Scalr but not on Hosted Scalr, which uses the latest version of Scalr.  Apologies for the confusion.  You will need to wait for a future update to Open Source Scalr, continue with Hosted Scalr, or begin a discussion with our Sales team about Enterprise Scalr if that would be a better fit for you.  Please let us know if you have any further questions or troubles and we will do our best to lend a hand.

Many thanks,
Wm. Marc O'Brien
Scalr Technical Support

[Shashi Bhushan]

Hi Marc,

 Actually it got resolved after some upgradation I had done with python 7.2.6.

Thankyou for you support.

And Can you help me with mysql, how can I access the tables inside "Scalr" database ,like by connecting to mysql with root and password . I have a usecase in which I need data that scalr saves in scalr database - main database.

Thankyou 

Shashi Bhushan

--
You received this message because you are subscribed to a topic in the Google Groups "scalr-discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/scalr-discuss/m2HYhNXmV4g/unsubscribe.
To unsubscribe from this group and all its topics, send an email to scalr-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Marc O'Brien]

Hi Shashi,

Glad to hear you were able to work around this.  Many other packages will be updated to newer versions in the latest versions of Scalr enterprise as well.  Regarding access to the embedded databases, this was briefly discussed in this previous discussion thread.  Summary:  To access the embedded DB you will need to pull the long scalr mysql password from scalr-server-secrets.json and use the following to login (swap "scalr" for "analytics" if you need to access the analytics DB): 

sudo /opt/scalr-server/embedded/bin/mysql -u scalr -p<PASSWORD> scalr

As always, let us know if you have any further troubles or questions and we will do our best to lend a hand.

Cheers,

[Shashi Bhushan]

Hi Marc, 

Thankyou for your support, It really helped alot. 

For the database part , I am not able to see the output of the queries , I must be doing something wrong, 

when I run this command : 

sudo /opt/scalr-server/embedded/bin/mysql -u scalr -p<PASSWORD> scalr -e "<QUERIES>" 

then the output is Usage but not the query that I run . 

the output looks like : But I need to see the output of the queries I ran . 

mysql  Ver 14.14 Distrib 5.6.33, for debian-linux-gnu (x86_64) using  EditLine wrapper

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Usage: mysql [OPTIONS] [database]

  -?, --help          Display this help and exit.

  -I, --help          Synonym for -?

   --bind-address=name IP address to bind to.

  --character-sets-dir=name

                      Directory for character set files.

  --column-type-info  Display column type information.

  -c, --comments      Preserve comments. Send comments to the server. The

                      default is --skip-comments (discard comments), enable

                      with --comments.

  -C, --compress      Use compression in server/client protocol.

  -#, --debug[=#]     This is a non-debug version. Catch this and exit.

  --debug-check       Check memory and open file usage at exit.

  -T, --debug-info    Print some debug info at exit.

  -D, --database=name Database to use.

  --default-character-set=name

                      Set the default character set.

  --delimiter=name    Delimiter to be used.

  --enable-cleartext-plugin

                      Enable/disable the clear text authentication plugin.

  -e, --execute=name  Execute command and quit. (Disables --force and history

                      file.)

  -E, --vertical      Print the output of a query (rows) vertically.

  

Default options are read from the following files in the given order:

/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

The following groups are read: mysql client

The following options may be given as the first argument:

--print-defaults        Print the program argument list and exit.

--no-defaults           Don't read default options from any option file,

 

Variables (--variable-name=value)

and boolean options {FALSE|TRUE}  Value (after reading options)

--------------------------------- ----------------------------------------

auto-rehash                       TRUE

auto-vertical-output              FALSE

bind-address                      (No default value)

character-sets-dir                (No default value)

column-type-info                  FALSE

comments                          FALSE

compress                          FALSE

debug-check                       FALSE

debug-info                        FALSE

database                          (No default value)

default-character-set             auto

delimiter                         ;

enable-cleartext-plugin           FALSE

vertical                          TRUE

force                             FALSE

named-commands                    FALSE

ignore-spaces                     FALSE

port                              3306

prompt                            mysql>

quick                             FALSE

raw                               FALSE

reconnect                         FALSE

socket                            (No default value)

ssl                               FALSE

ssl-crlpath                       (No default value)

ssl-verify-server-cert            FALSE

table                             FALSE

Thankyou again Marc 

Shashi Bhushan 

[Marc O'Brien]

Hi Shashi,

You should be able to use sudo /opt/scalr-server/embedded/bin/mysql -u scalr -p<PASSWORD> scalr to login to the database and then manually execute any queries you need.