Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem to remotely access MySQL database using Google Apps Script
#11
[Solved]
(09-12-2014, 01:07 PM)Genesis Wrote: OK, this is early days and I could be off the mark, but I've got a theory. Is your IP a dynamic IP. Sort of makes sense you have to have a static IP for the distance connection to work because you have to have a white listed IP (you doing the white listing). Have you tried a proxy IP?

Check the literature here - quite informative for recommending strings for your coding:
https://my.hostmonster.com/cgi/help/89

The Google Apps Script runs on Google's servers, not my machine and thus, the script attempts to establish a connection between database and Google's servers. I guess I cannot extract the IP addresses of all the Google servers and so I have added a "%" and - additionally, however little sense it has - a "%.google.com" wildcards. This way, I do not have to manually set all the possible Google's addresses.

I will try to connect to the database from a local machine with some software now, just to ensure i am using the very correct credentials.

@Genesis Okay, I have attempted to connect to the database using HeidiSQL from my local machine. Did not succeed. This is what I did receive:
resim

I have no idea what should I try to do now, what I do have, though, is another question: could you check (at least using the portable version of HeidiSQL from here) if you are able to connect to your database if you have any located here, on Gigarank? To ensure that it is possible to do on Gigarank.
#12
[Solved]
Why dont you try to change your output file from MySQL to become JSON or XML file then calling to appengine ?
HOT MUSIC VIDEO | Video Music Knowledgebase
#13
[Solved]
(09-13-2014, 12:06 AM)jaran Wrote: Why dont you try to change your output file from MySQL to become JSON or XML file then calling to appengine ?

I am not using App Engine. Google Apps Script is a completely different thing than Google App Engine is. And I am not trying to make a call from here to Google Apps but the other way around.

Could anyone check if they can access databases on their free hostings on Gigarank remotely? If it is possible, I could try to connect to my database, since so far two different approaches to achieve this did not work.
#14
[Solved]
I have tried to connect to the database using an Android app (just to check it out). Still, no positive result.
What I got is this:
resim

I would like to politely request somebody just to check if they can connect to their database remotely. If it is possible and the fault is on my side, I would then post the issue to Stackoverflow for further search for the cause.

Great thanks in advance!
#15
[Solved]
I have created a free MySQL database using db4free.net service and tried connecting to their database - this solution worked without any problem. The problem does not lie in my script then.

Since nobody tried connecting to their database remotely, I have to try to find a solution on my own, it seems Sad Anyways, if anyone would want to help, you could download HeidiSQL portable software, launch it type in your database's credentials and just check it. I would truly appreciate it!


Could you, administrators, read this article and ensure that the 3306 port is open in Gigarank's firewall, if you use any? I would be grateful.
http://www.liquidweb.com/kb/opening-port...-firewall/


Also, does anyone know if I should set the Remote Access wildcard in cPanel to
Quote:%
or to
Code:
%.%.%.%
?
None of above seems to work, but I did not find any documentation on this topic so I may have been doing it wrong for all the time. The db4free.net connection worked without setting anything in cPanel, since user does not have access to the cPanel there.

Just to be 100% sure: I have set all the addresses specified by Google in the tutorial page mentioned above. This (as I had expected) did not bring any effect. Now my Remote Access page looks like this:
resim
A bit funny, but hey, at least I am sure :)
#16
[Solved]
Hello,
Are you able to login remotely now?
Please do not email or PM me with private support requests - Use Support Section.
Don't forget to read TOS.
Never argue with idiots.
First, they'll bring you down to their level and then beat you with their experience!
[-] The following 1 user Likes un4saken's post:
  • Gregoric
#17
[Solved]
(09-24-2014, 02:34 PM)un4saken Wrote: Hello,
Are you able to login remotely now?

Hello!

It works perfectly now! I am truly grateful for fixing this. What did you do, if I could ask? Was the issue related to my account or something else?

Thank you again!

Best regards to you & whole staff!


PS.: If anyone would need help with connecting to the database using Google Apps Script, I could gladly help.
#18
[Solved]
It was not related to your account, it was something with the firewall.
Please do not email or PM me with private support requests - Use Support Section.
Don't forget to read TOS.
Never argue with idiots.
First, they'll bring you down to their level and then beat you with their experience!
#19
[Solved]
@un4saken Out of curiosity. Does this mean that every one else should be able to access remotely as well now, or would they need to be set up similarly individually?
#20
[Solved]
yes, it's all okay now.
Please do not email or PM me with private support requests - Use Support Section.
Don't forget to read TOS.
Never argue with idiots.
First, they'll bring you down to their level and then beat you with their experience!
  




Users browsing this thread:
1 Guest(s)

Problem to remotely access MySQL database using Google Apps Script566