RapidMiner

RapidMiner

how to: Read Database on Rapidminer Server

SOLVED
Contributor II

how to: Read Database on Rapidminer Server

[ Edited ]

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.

See more topics labeled with:

Attachments

9 REPLIES
Community Manager

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.

Regards,
T-Bone
Twitter: @neuralmarket
Contributor II

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>

Attachments

Community Manager

Re: how to: Read Database on Rapidminer Server

Did you add in your password?

Regards,
T-Bone
Twitter: @neuralmarket
Contributor II

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?

Community Manager

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?

Regards,
T-Bone
Twitter: @neuralmarket
Contributor II

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

Community Manager

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?

Regards,
T-Bone
Twitter: @neuralmarket
Community Manager

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.

Regards,
T-Bone
Twitter: @neuralmarket
Contributor II

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