Connection issues against SQL Server

[Rolf Larsson]

Hi all,

I've been attempting to connect to a Microsoft SQL Server instance hosted on Amazon RDS.

Port 1433 is, against common sense, public while we attempt to get this set up, and we can both connect and log in to the service from other external hosts.

However, supermetrics fails during 'Test Connection' with the following message (tested just now): Connection failed from IP <my IP, redacted>, 107.178.192.68: Failed to establish a database connection. Check connection string, username and password.

The IP address (107.178.192.68) is a Google IP. None of the IP's are my database instance.

When I check the log on the Database instance, I see no failed connections from any of these IP's (or any other unexpected IP, for that matter). Nor do I see any failed logins for my user.

Can you verify what the problem is in this case? I've searched for prior threads about this and would argue that your previous argument that Google does the connection is not relevant here as this seems to fail between my host and Googles Servers.

It would also be beneficial if you could return a more accurate error message. Asking the user to check the connection string is irrelevant, as the string is built by the underlying code and you don't present it; also it requires knowledge about the technologies in use. Nor is the user/password comment relevant, as it hasn't even gotten to that part of the connection yet, as far as I can tell.

I have the Free Trial, but am debugging this for a user that has the Pro license, who receives the same problems.

-- Rolf

[Rolf Larsson]

I doublechecked with adblockers etc turned off, and had the same issue.

In the JS console, I get the following when I click on "Database" in the sidebar:

sidebar1.js?v=1.297411:4 

Uncaught TypeError: Cannot read property 'email' of undefined

updateLogins @ sidebar1.js?v=1.297411:4

zi @ 3402363213-mae_html_user_bin_i18n_mae_html_user__sv.js:50

(anonymous function) @ 3402363213-mae_html_user_bin_i18n_mae_html_user__sv.js:15

Nj.D @ 3402363213-mae_html_user_bin_i18n_mae_html_user__sv.js:78

xh @ 3402363213-mae_html_user_bin_i18n_mae_html_user__sv.js:31

sh @ 3402363213-mae_html_user_bin_i18n_mae_html_user__sv.js:32

(anonymous function) @ 3402363213-mae_html_user_bin_i18n_mae_html_user__sv.js:29

...and the following when I press "Test connection".

userCodeAppPanel?lu=0:1 

Mixed Content: The page at 'https://docs.google.com/spreadsheets/d/1tWvzakjdHGTqIVO8nYt13K0E-cZXm0Xsh94zVRmOhVY/edit#gid=0' was loaded over HTTPS, but requested an insecure image 'http://s3.amazonaws.com/Supermetrics/ajax-loader_transp.gif'. This content should also be served over HTTPS.

[Rolf Larsson]

(I've also tried with both Chrome and Firefox)

[Clinton Deacon]

Our system uses Google's JDBC connector. You should check all of Google's IPs are open to connect to your database. See more at https://developers.google.com/apps-script/guides/jdbc#accessing_local_databases

Kind Regards

Clinton Deacon

Senior Application Developer

http://www.supermetrics.com

On Fri, May 20, 2016 at 12:28 PM, Rolf Larsson <rolf.l...@gmail.com> wrote:

(I've also tried with both Chrome and Firefox)

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at https://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/c8f21133-d947-441c-869f-e899457a1472%40googlegroups.com.

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

[Rolf Larsson]

Hi Clinton,

As mentioned, all IP's are allowed to connect, but nothing comes through to the database server.

[Rolf Larsson]

The problem remains. Any further suggestions? For reference, it works well against a MySQL database that is secured in the exact same way.

This is definitely some problem in the connection code, not with our configuration, as we have confirmed it works perfectly to connect. However, as it outputs a very general error message, I have no idea what to attempt next.

It would be great if we could see the connection string it's trying to feed into JDBC, so I can attempt to reproduce it.

[Bobby Palta]

I'm having the same problem myself. I use Amazon RDS and went through the entire list of IPs to white-list on the GoogleCloud JDBC page. Funny enough, the error message says that it's trying to connect from [my ip] and 107.178.193.17/32 which isn't even on the list of IPs (https://developers.google.com/apps-script/guides/jdbc#accessing_local_databases). I tried using SuperMetrics months ago and quit in frustration because of this same issue. Seems it hasn't been fixed in all that time.

It looks like a useful product and I'd like to try it, but can't even get a connection. If someone from the company could lend a hand, that would be great.

Thanks.

[Mikael Thuneberg]

Unfortunately, there isn't really anything we can do. The connection details are handled by Google, we have no control over it. Connecting to Amazon RDS MySQL does work when we test it with our own server.

--

You received this message because you are subscribed to the Google Groups "Supermetrics" group.

To unsubscribe from this group and stop receiving emails from it, send an email to automateanalytics+unsubscribe@googlegroups.com.

Visit this group at https://groups.google.com/group/automateanalytics.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/24131ce3-8127-41f6-afc6-49c1885266ea%40googlegroups.com.

[Eric Emme]

Has anyone found a solution for this? I am getting the same error message trying to connect to an Amazon Sql Instance.

It seems like an issue with Supermeterics, as I am able to build my own JDBC connector in Google Apps Scripts which can connect just fine...

On Wednesday, August 31, 2016 at 2:13:42 AM UTC-7, Supermetrics Support wrote:

Unfortunately, there isn't really anything we can do. The connection details are handled by Google, we have no control over it. Connecting to Amazon RDS MySQL does work when we test it with our own server.

On 31 August 2016 at 02:59, Bobby Palta <bobby...@pipelinenow.com> wrote:

I'm having the same problem myself. I use Amazon RDS and went through the entire list of IPs to white-list on the GoogleCloud JDBC page. Funny enough, the error message says that it's trying to connect from [my ip] and 107.178.193.17/32 which isn't even on the list of IPs (https://developers.google.com/apps-script/guides/jdbc#accessing_local_databases). I tried using SuperMetrics months ago and quit in frustration because of this same issue. Seems it hasn't been fixed in all that time.

It looks like a useful product and I'd like to try it, but can't even get a connection. If someone from the company could lend a hand, that would be great.

Thanks.


On Wednesday, June 15, 2016 at 3:26:23 AM UTC-4, Rolf Larsson wrote:

The problem remains. Any further suggestions? For reference, it works well against a MySQL database that is secured in the exact same way.

This is definitely some problem in the connection code, not with our configuration, as we have confirmed it works perfectly to connect. However, as it outputs a very general error message, I have no idea what to attempt next.

It would be great if we could see the connection string it's trying to feed into JDBC, so I can attempt to reproduce it.

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.

To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.

Visit this group at https://groups.google.com/group/automateanalytics.

[Shahar Halperin]

same here.

works with other tools, the addon gives an error.

shahar

[Jason Parlevliet]

Same here.  I have a packet sniffer set up on my server, and confirmed there is nothing coming in on port 1433 when I test this.  I tried telling the Supermetrics addon that the server was MySQL, I can see a connection attempt from a Google IP on port 3306 when I do that.  Changed it back to SQL server, nothing again.

To test, I forwarded ports 3306 and 1433 on my home router to my desktop, same symptoms - I see packets come in on port 3306 when I use MySQL, but when I choose SQL server, nothing.

So it's not firewall, not authentication.  The Supermetrix addon just doesn't do anything when you choose SQL Server

[Mikael Thuneberg]

We would love to fix the connection issue with SQL Server. Would it be possible for you to privately share the connection information for the db so we could test? If so, please email to mikael.t...@supermetrics.com.

--

You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at https://groups.google.com/group/automateanalytics.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/50d704fe-b53a-40aa-a5b4-557e88ad5e9f%40googlegroups.com.

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

3904