no access to SQL server using proxy

kayman
kayman New Altair Community Member
edited November 5 in Community Q&A

I have some strange behaviour trying to access our company databases. I can access them when using direct (no proxy), but the moment I select proxy I cannot access the servers anymore (MS SQL).

This is pretty annoying as I have a process crawling websites that need the proxy to be set, and I want to load the results to our databases but that doesn't work unless I disable the proxy.

 

Any advice on what I need to set to also get access to my databases using proxy?

 

I'm using RM7.4 

Tagged:

Best Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Answer ✓

    Hi,

    did you try listing the name or ip address of your database server in the "No proxy for" list? This only works if you're using the Manual Proxy setting.

    Regards,

    Balázs

  • kayman
    kayman New Altair Community Member
    Answer ✓

    Sorry, too fast again... I can access my databases now with manual proxy but I loose access to the internet :-(

    So this is what I have :

     

    Using system proxy : access to the web but not to database or localhost RM server

    Using direct (no proxy) : access to database, localhost RM server but not web

    Using manual proxy and no proxy for localhost|mydb1|mydb2 : access to database, localhost RM Server but not to web anymore

     

    What would be the magic recepy ?

     

    [UPDATE] I had to remove the socks settigns, that did the trick for me.

    Now I get access to all of them using manual proxy, thanks for the support !

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Answer ✓

    Hi,

    did you try listing the name or ip address of your database server in the "No proxy for" list? This only works if you're using the Manual Proxy setting.

    Regards,

    Balázs

  • kayman
    kayman New Altair Community Member

    yeah, no success with that one either. I can give it a try with the IP.

    tbh, i am actually more suprised it works without the proxy as with the proxy, since I should only have access to the servers within the network by default. 

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    Do you need to specify an instance under the database schema parameter?

     

    Like "database;instance=sqlexpress"

  • kayman
    kayman New Altair Community Member

    Seems I was a bit too fast, I've tried again entering my database names under manual proxies and it seems to be ok, took just a bit more time as usual so I was probably not patient enough while I tried it before.

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    Cool! Happy RapidMining!

  • kayman
    kayman New Altair Community Member
    Answer ✓

    Sorry, too fast again... I can access my databases now with manual proxy but I loose access to the internet :-(

    So this is what I have :

     

    Using system proxy : access to the web but not to database or localhost RM server

    Using direct (no proxy) : access to database, localhost RM server but not web

    Using manual proxy and no proxy for localhost|mydb1|mydb2 : access to database, localhost RM Server but not to web anymore

     

    What would be the magic recepy ?

     

    [UPDATE] I had to remove the socks settigns, that did the trick for me.

    Now I get access to all of them using manual proxy, thanks for the support !

Categories