RapidMiner

Learner III january_febro
Learner III

how to: Read Database on Rapidminer Server

Hi, I created a process reads database and execute  and apply the gradient boosted tree model then append back the result to the database. If i run it locally it works fine. I save the process on the rapidminer server and when i run it causes  

  com.rapidminer.operator.UserError: Database Connection Failed. Please define connection properly (please see attached file for the process and error).

Now I tried to create a database connection in my rapidminer server inputting the proper data on the fileds, but it just gives me 

red box (Please see image file) if i will run using this setting it will give me a java nullpointer.

 

Thank you for your help.

9 REPLIES
RM Certified Expert
RM Certified Expert

Re: how to: Read Database on Rapidminer Server

When you created the DB connection on Server, did you click test and get the green check mark?

 

If it gives you an error, then there's something wrong with your connection parameters.

 

You must give the DB connection on the Server and unique name "Server_DB" and then make sure to select that connection in your process to run it on the Server.

Learner III january_febro
Learner III

Re: how to: Read Database on Rapidminer Server

Hi @Thomas_Ott

Thank you for your reply. I followed your  instruction. The error did not display but it gives me red box (pls. see attached file).

I think my settings is right:

Name: Server_DB

Database System: MYSQL

Host: Localhost

Port: 3306

Schema: rapidminer_server (i created a table named es_sap)

User: root

Password: <empty>

Highlighted
RM Certified Expert
RM Certified Expert

Re: how to: Read Database on Rapidminer Server

Did you add in your password?

Learner III january_febro
Learner III

Re: how to: Read Database on Rapidminer Server

@Thomas_Ott 

I did not put a password because in my localhost i also did not put password. Is the password required?

RM Certified Expert
RM Certified Expert

Re: how to: Read Database on Rapidminer Server

So your root user has no password? I thought that's a must for the root user? No?

Learner III january_febro
Learner III

Re: how to: Read Database on Rapidminer Server

@Thomas_Ott

im using using xampp to for apache and mysql server. It's okay not to have a password for the root. 

I also tried adding a new user:rmUser with password: pwsd but to no avail Smiley Sad

 

What should i do?Smiley Sad

RM Certified Expert
RM Certified Expert
Solution

Re: how to: Read Database on Rapidminer Server

Can you try creating a new DB user (other than root) with a password and try it again?

RM Certified Expert
RM Certified Expert

Re: how to: Read Database on Rapidminer Server

Also check the Access Rights of the DB connection too, maybe your RM user doesn't have access rights to the DB connection you're creating.

Learner III january_febro
Learner III

Re: how to: Read Database on Rapidminer Server

@Thomas_Ott  Thank you very much for your immediate response Smiley Happy  

I have successfully added a database  connection but when i run the process it  has an error  a database connection failed still, this time the proble is the unknown table. Im pretty sure i have that table Smiley Sad

Twitter Feed