"Cannot connect to Database"

jsimoes
jsimoes New Altair Community Member
edited November 2024 in Community Q&A
Hello everyone,

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

"Communications link failure Last 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

  • land
    land New Altair Community Member
    Hi Jose,
    there are dozens of problems possible. To start with: Which data base system are you using?

    Greetings,
      Sebastian
  • jsimoes
    jsimoes New Altair Community Member
    MySQL... with XAMPP.. What's next?
  • flyfire
    flyfire New Altair Community Member
    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.
  • jsimoes
    jsimoes New Altair Community Member
    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!
  • land
    land New Altair Community Member
    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
  • preethy
    preethy New Altair Community Member
    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?

Categories