maiformed reply from socks server

2131012221310122 MemberPosts:40Guru
edited March 2020 inHelp

Hello, I am using RapidMiner studio 8.1.3 and trying to use "read database" operator.

So I have to manage database connection first.

But when I test the connection, it shows error message in the background like this:

1.jpg

2.png

3.jpg

Does anybody know the answer? Thanks a lot.

1.jpg 0B
2.png 0B
3.jpg 0B
Tagged:

Best Answer

  • rfuentealbarfuentealba Moderator, RapidMiner Certified Analyst, Member, University ProfessorPosts:568Unicorn
    Solution Accepted

    Hello@21310122,

    This is strange, SOCKS servers aren't a common practice for managing PostgreSQL connections. This can mean one of three things:

    1. 你配置你的电脑或网络使用SOCKS proxy.
    2. You configured your SOCKS proxy in the RapidMiner Studio preferences.
    3. You configured your PostgreSQL driver to connect to a SOCKS proxy but you don't have one.

    Let's think a bit:

    1. You actuallycanconnect to your database using another client, hence that is not the case. That's great because a) this rules out your computer or your network setup, which is harder to address if company policies force you to use such a thing, and b) I don't know how to use Windows and can't help you.
    2. You actuallycan'tconnect to your database using RapidMiner Studio, hence you should checkPreferences > Proxy, and either delete your proxy settings or add your PostgreSQL host to the "No proxy for" list, so that it doesn't get redirected.
    3. You may have configured SOCKS on your driver, but looking at the dialog opened with the "Advanced" button, I don't see a SOCKS configuration for the PostgreSQL driver provided with RapidMiner Studio/Server, hence this is not the case. That's bad, that was the simpler solution.
    4. Youdohave a SOCKS server but it's a v4. This is not supported by the PostgreSQL JDBC driver, AFAIK. If that is the case, that's a no-no. SOCKS5 has been around since mid-1996, and a little kitten goes to heaven when one uses SOCKS4.

    Anyway, try something else:

    1. Replace the PostgreSQL JDBC driver by a newer one.
    2. Make sure you are using Java 8. I've seen a few bugs related with handling SOCKS, but these are labelled with Java 7.
    3. If nothing else works, please give us a bit more information about your network and your setup. If you wish, do it in a private message to me. I have seen this kind of errors plenty of times with PostgreSQL but honestly, never with RapidMiner.

    All the best,

Answers

  • rfuentealbarfuentealba Moderator, RapidMiner Certified Analyst, Member, University ProfessorPosts:568Unicorn

    Wait, wait... why is your server on168.0.0.0/8? IIRC, that is a public IP.

  • 2131012221310122 MemberPosts:40Guru

    Thank you a lot.

    I check Preferences > Proxy as you said (I didn't check this before, so I use the default value "System proxy" ) and I change it to "Direct(no proxy)" now.

    Then I retried the connection test in RM, it showS connected success.

  • rfuentealbarfuentealba Moderator, RapidMiner Certified Analyst, Member, University ProfessorPosts:568Unicorn

    Glad it helped! Enjoy!

Sign InorRegisterto comment.