"Cannot connect to Database"

jsimoesjsimoes MemberPosts:5Contributor II
edited May 2019 inHelp
Hello everyone,

I am trying to connect with the database and I am getting the following error:

“通信链路失败packet sent to the server was 0 ms ago."

I am running Snow Leopard with Rapid-I 5. The database is running locally and I can access it from both console and phpAdmin. Any ideas of where the problem might be?

Thanks,
Jose
Tagged:

Answers

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:2,531Unicorn
    Hi Jose,
    there are dozens of problems possible. To start with: Which data base system are you using?

    Greetings,
    Sebastian
  • jsimoesjsimoes MemberPosts:5Contributor II
    MySQL... with XAMPP.. What's next?
  • flyfireflyfire MemberPosts:11Contributor II
    Hi there.
    First, check the 'Show Database Driver' in the 'Tool' menu, see if the MySQL driver is available.
    If so, Try the right format of the connection string like "jdbc:mysql://host:port/database" as well as the right user name and password.
    If not, download the right driver, and put it in the setuppath/Rapid-I/RapidMiner5/lib/jdbc, restart RapidMiner, and try the step above.

    :),
    Flyfire.
  • jsimoesjsimoes MemberPosts:5Contributor II
    Everything is there and correctly configured. The problem is that I am not using the DB from the MAC computer but from XAMPP. The other DB it connect correctly. However, when I kill it's process and launch the other DB it does not work. And I don't understand why..

    Any other ideas?

    PS: It is working with remote databases - The only problem is localhost!
  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:2,531Unicorn
    Hi,
    did you check if the MySQL user has the privilege to connect to that database from localhost?
    In the Connection Settings Dialog there's a "Check Connection" button. What does it report if you press it?

    Greetings,
    Sebastian
  • preethypreethy MemberPosts:7Contributor I
    Hello,

    I am using RapidMiner 5.3.
    I am trying to read some data from csv files and would like to put it into a MySQL database. I am using write database operator. I added the connection settings, the database name, username and password. When I test the connection, I am getting "Communication link failure. The last packet sent successfully to the server was 0 milliseconds ago....".

    I tried out the below suggestions:

    1. Removed the jar file from lib/jdbc and installed another version.-Didn't work
    2. Added a new user with all privileges assigned. Didn't work.

    Can anyone help out?
Sign InorRegisterto comment.