How to find out scalr mysql database passwrd

[neeraj jain]

Hi all,

I am using scalr community version and tring to find password for the mysql database used by scalr. I can see some password in the scalr-server-secrets.json file but it is encrypted. is it possible to get this password? I am enabling analytics and require this password. 

[Marc O'Brien]

Hi Neeraj,

This password string found within scalr-server-secrets.json is not encrypted.  This file contains the plaintext passwords for the indicated services and accounts.

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

[neeraj jain]

Thanks Marc,

I realised that later on, Thanks for your response.

--
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/LMtP5K3vmSM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to scalr-discus...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Thanks & Regards,

Neeraj Jain

Phone: +91-976-941-4047

skype: njain.jain

[neeraj jain]

Hi Marc,

can you help me with my Analytics setup. I am installed community version but some analytics is not working. I have enabled explicitly in my configuration file like below.  I can see my DB parameter is correct infact Analytics DB is created successfully. But no data is coming up on GUI. Can you suggest some configuration which is require to enable this module. 

app[:configuration] = {

  "scalr" => {

    "analytics" => {

                "enabled" => true,

                "connections" =>{

                        "analytics" =>{

                                "host" => "127.0.0.1",

                                "port" => 6280,

                                "name" => "analytics",

                                "user" => "scalr",

                                "password" => "2593a125b60749cc27aa088572afa5010b61c5309ebcad062601529fc541483a3a40d82b782dce238b4a6113f0b81e221de5"

                        },

                        "scalr" =>{

                                 "host" => "127.0.0.1",

                                 "port" => 6280,

                                 "name" => "scalr",

                                 "user" => "scalr",

                                 "pass" => "2593a125b60749cc27aa088572afa5010b61c5309ebcad062601529fc541483a3a40d82b782dce238b4a6113f0b81e221de5"

   }

                }

    }

  }

}

Thanks & Regards,

Neeraj Jain

Phone: +91-976-941-4047

skype: njain.jain

[Marc O'Brien]

Hi Neeraj,

After making changes to your scalr-server.rb, did you run the scalr-server-ctl reconfigure command to make your changes active?  For a single server install with the default "enable_all true" within scalr-server.rb, you should not need to do any additional configuration for Cost Analytics to function.  Have you confirmed that you have associated Environments with Cost Centers and Farms with Projects so that there is valid cost analytic data to report?  If so, it may be helpful to see screenshots of your expected/experienced behavior in the UI that illustrate the problem.

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

On Tue, Jul 26, 2016 at 10:11 PM, neeraj jain <> wrote:

Thanks Marc,

I realised that later on, Thanks for your response.

On Tuesday 26 July 2016, Marc O'Brien <> wrote:

Hi Neeraj,

This password string found within scalr-server-secrets.json is not encrypted.  This file contains the plaintext passwords for the indicated services and accounts.

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



On Tuesday, July 26, 2016 at 1:44:55 AM UTC-6, neeraj jain wrote:

Hi all,

I am using scalr community version and tring to find password for the mysql database used by scalr. I can see some password in the scalr-server-secrets.json file but it is encrypted. is it possible to get this password? I am enabling analytics and require this password. 

--
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/LMtP5K3vmSM/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.

[neeraj jain]

Hi Marc, 

I have tried all below options but one thing I have identified that my setup has some issue with phython version and gevent.

i am keep getting ssl error statins unknown server host name.

do you any idea about it?

Thanks Marc,

To unsubscribe from this group and all its topics, send an email to scalr-discus...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Thanks & Regards,

Neeraj Jain

Phone: +91-976-941-4047

skype: njain.jain

--
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/LMtP5K3vmSM/unsubscribe.

To unsubscribe from this group and all its topics, send an email to scalr-discus...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[neeraj jain]

here is the stack trace from service log.

[28/Jul/2016 05:32:40][              helper][  2063] ^[[91m     ERROR^[[0m AWS billing for environments [1], month 7 failed. Reason: <type 'exceptions.TypeError'> __init__() got an unexpected keyword argument 'server_hostname'

Traceback (most recent call last):

  File "/opt/scalr-server/embedded/scalr/app/python/scalrpy/../scalrpy/util/billing.py", line 467, in csv_files

    force=bool(self.config['dtime_to']))

  File "/opt/scalr-server/embedded/scalr/app/python/scalrpy/../scalrpy/util/billing.py", line 170, in download_billing_file

    bucket = conn.get_bucket(bucket_name)

  File "/opt/scalr-server/embedded/lib/python2.7/site-packages/boto/s3/connection.py", line 503, in get_bucket

    return self.head_bucket(bucket_name, headers=headers)

  File "/opt/scalr-server/embedded/lib/python2.7/site-packages/boto/s3/connection.py", line 522, in head_bucket

    response = self.make_request('HEAD', bucket_name, headers=headers)

  File "/opt/scalr-server/embedded/lib/python2.7/site-packages/boto/s3/connection.py", line 665, in make_request

    retry_handler=retry_handler

  File "/opt/scalr-server/embedded/lib/python2.7/site-packages/boto/connection.py", line 1071, in make_request

    retry_handler=retry_handler)

  File "/opt/scalr-server/embedded/lib/python2.7/site-packages/boto/connection.py", line 943, in _mexe

    request.body, request.headers)

  File "/opt/scalr-server/embedded/lib/python2.7/httplib.py", line 1057, in request

    self._send_request(method, url, body, headers)

  File "/opt/scalr-server/embedded/lib/python2.7/httplib.py", line 1097, in _send_request

    self.endheaders(body)

  File "/opt/scalr-server/embedded/lib/python2.7/httplib.py", line 1053, in endheaders

    self._send_output(message_body)

  File "/opt/scalr-server/embedded/lib/python2.7/httplib.py", line 897, in _send_output

    self.send(msg)

  File "/opt/scalr-server/embedded/lib/python2.7/httplib.py", line 859, in send

    self.connect()

  File "/opt/scalr-server/embedded/lib/python2.7/httplib.py", line 1278, in connect

    server_hostname=server_hostname)

  File "/opt/scalr-server/embedded/lib/python2.7/ssl.py", line 352, in wrap_socket

    _context=self)

TypeError: __init__() got an unexpected keyword argument 'server_hostname'

Thanks & Regards,

Neeraj Jain

Phone: +91-976-941-4047

skype: njain.jain

[Marc O'Brien]

Hi Neeraj,

As a first step in troubleshooting this, can you confirm your version of Open Source Scalr?  Has this deployment been updated to 5.11.22?  Are you seeing Cost Analytics data correctly for all environments and time frames except for "environments [1], month 7" as noted in your error?

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

Thanks Marc,

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.

--

Thanks & Regards,

Neeraj Jain

Phone: +91-976-941-4047

skype: njain.jain

--
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/LMtP5K3vmSM/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.

[Matthieu Serrepuy]

Hi !

I am trying to connect to the backend mysql database but none of the user/pass found in /etc/scalr-server/scalr-server-secrets.json, scalr-server-ctl show-attributes or scalr-server-ctl show-config are working :(

Am I missing somethign obvious ?

Where can I find the credentials that scalr is currently using ?

Thanks,

Matt

[Marc O'Brien]

Hi Matt,

The database user passwords are listed in /etc/scalr-server/scalr-server-secrets.json under the mysql section.  Use the following one liner to login to the embedded database:

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

Please note:  No space between "-p" and your password.

Cheers,

Wm. Marc O'Brien
Scalr Technical Support