The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Can we pass Mysql database name and table name to dynamically through web url using macros?
kamal_pradhan
Member Posts: 3 
Contributor I
I am getting difficulties in passing the database connection detail to a RapidMiner process deployed as a webservice . I tried to use macros and even after providing correct connection details.
I keep on getting this error
de.rapidanalytics.ejb.service.ServiceDataSourceExceptionError executing process /home/proc_1/test for service test: Database error occurred: Could not connect: Access denied for user 'root'@'static.115.208.216.95.clients.your-server.de' (using password: YES)
I keep on getting this error
de.rapidanalytics.ejb.service.ServiceDataSourceExceptionError executing process /home/proc_1/test for service test: Database error occurred: Could not connect: Access denied for user 'root'@'static.115.208.216.95.clients.your-server.de' (using password: YES)
0
Answers
Firstly, please check if the credentials you are passing is correct. Because error indicates wrong credentials...
Could you please give more details here?
What's the database? Also how exactly your process is setup, like how you are passing the macro value, and in what part of the workflow you are using it. Since you are saying, you are tryng to give database connection details via macros?
Please share Server error logs, available in following location:
<server-home-directory>\log\server.log
Cheers,
Pavithra
Hi,
What I'm trying to active passing the database details (url, username and password) through a created web-service using macro bindings. If I use a predefined connection in the server then the process works but If I try to specify the details through macros and parameters the following error occurs:
Thanks
<?xml version="1.0" encoding="UTF-8"?><process version="8.2.000"> <context> <input/> <output/> <macros> <macro> <key>url</key> <value/> </macro> <macro> <key>user</key> <value/> </macro> <macro> <key>pass</key> <value/> </macro> </macros> </context> <operator activated="true" class="process" compatibility="8.2.000" expanded="true" name="Process"> <process expanded="true"> <operator activated="true" class="jdbc_connectors:read_database" compatibility="8.2.000" expanded="true" height="68" name="Read Database" width="90" x="380" y="34"> <parameter key="define_connection" value="url"/> <parameter key="database_url" value="%{url}"/> <parameter key="username" value="%{user}"/> <parameter key="password" value="ZGmujF5bm8M="/> <enumeration key="parameters"/> </operator> <connect from_op="Read Database" from_port="output" to_port="result 1"/> <portSpacing port="source_input 1" spacing="0"/> <portSpacing port="sink_result 1" spacing="0"/> <portSpacing port="sink_result 2" spacing="0"/> </process> </operator> </process>@Pavithra_Rao I guess that´s the reason is says the user is not the right one.
I think you correct. I tried with the same step and it works fine in the studio but fails in the server.